Object Oriented Programming Using C#: Part 9

CREATE TABLE [dbo].[User_Activity_Log](
      NOT NULL,
    [UAL_Timestamp] [datetime] NOT NULL,
    [UAL_Function_Performed] [nvarchar](100) NOT NULL,
    [UAL_Other_Information] [nvarchar](100) NULL,
    [UAL_IP_Address] [nvarchar](15) NOT NULL,
    PRIMARY KEY CLUSTERED 
    (
        [UAL_User_Id] ASC,
        [UAL_Timestamp] ASC
    ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

CREATE TABLE [dbo].Login_Client(
        NULL,
        NULL,
      [LON_Employee_No] [varchar](10) NULL,
      [LON_Login_Password] [varchar](20) NULL,
        NULL,
        NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

INSERT INTO PSH.[dbo].[Login_Client]
VALUES ('Naveed Zaman', 'naveed.zaman', '22339', 'khan@123', 'A', 'Active')

public static SqlConnection GetDBConnection()
{
    SqlConnection conn = new SqlConnection(
        "Data Source=.\\CRMIS;Initial Catalog=PSH;User ID=sa;Password=###Reno321");
    return conn;
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace UserActivityLog_OOP_Concept {
    class Login {
        static string userid;
        static string password;
        static string ip;
        public string EmpNo = string.Empty;
        SqlConnection con = Main.GetDBConnection();

        public Login() {}

        public Login(string _userid, string _password, string _ip) {
            userid = _userid;
            password = _password;
            ip = _ip;
        }

        public string getidinfo {
            get {
                return userid;
            }
        }

        public string getpassinfo {
            get {
                return password;
            }
        }

        public string getipinfo {
            get {
                return ip;
            }
        }

        public string Validation() {
            try {
                DataTable consultanttable = new DataTable();
                string SQL = @"SELECT LON_Employee_No FROM Login_Client where LON_Login_Name = '" + userid + "' AND LON_Login_Password = '" + password + "'";
                SqlDataAdapter Consultantdataadapter = new SqlDataAdapter(SQL, con);
                Consultantdataadapter.Fill(consultanttable);
                foreach(DataRow myrow in consultanttable.Rows) {
                    EmpNo = (myrow[0].ToString());
                }
            } catch (InvalidCastException e) {
                throw (e); // Rethrowing exception e
            }
            return EmpNo;
        }
    }
}

Please check the code carefully.

We have created the class login and in that class, we define four member variables, three of them static and one is public. We have already discussed access modifiers in previous articles. After that, we created an object icon of the class Main that we defined in Step 6. It will help us to create a connection between C# and SQL Server.

After that, we defined the default constructor of a class Login and overloaded the Constructor with two parameters.

It's very important to understand the importance of the overloaded constructor. It will be initialized whenever we create the object of the class with the two parameters, userid, and password. We have defined a default constructor as well that will help us when we need an object on a class without parameters.

Further, we have defined read-only properties of the class login that will help us to read member variables.

In this session, we have defined a method validation of a class login that will help us validate the login info and return EmpNo.

Step 12. Please insert the following code in the UserActivityLog class.

Block A

• We have defined two member variables.
• We have defined the constructor of the class User_Activity_Log with a two-parameter that will initialize the member variables of the class.

Block B

• A method task will be used to insert the data into the database, so we need to create the object on the main class with the name of the icon.
• Using an insert statement we can insert the new row into the database that will get the parameter action which can be "login", "add new", "save" etcetera.

Step 13. Please insert the following code in the form.

Block A

• We have initialized the position of the form.
• String variable host Find host by name System.
• Gets a list of IP addresses that are associated with a host.
• Assign the IP address to CIP.
• lblCP. Text is assigned the IP address to the label that will display the IP info.

Block B

• Close the login windows.

Block C

• Checking if textboxes are not empty.

Block D

• Creating object LG that will activate the constructor of the class login with three parameters.
• Call the method validation using the object LG.
• Using the "LG.EmpNo" public variable we check either user and password correctly.
• Message box if the information is not correct.
• If the information is correct then we will create the object "alog" of the class UserActivityLog; it calls the constructor with four parameters.
• Using the "log" object we call the method task that will insert the data in the database.
• FrmActivity creates the object of the form.
• Load the form using the object name remains.

Step 14. Insert the following code into the FrmActivity form.

Block A

• We have initialized the position of the form.
• We create the object "alog" for the class UserActivityLog that will initialize member variables of the class UserActivityLog using three parameters and the values of the parameters are the properties of the login class.
• The next step is to use a method "task" of the class UserActivityLog with the parameter "Add new Record".

Block B

• We have initialized the position of the form.
• We create an object "alog" for the class UserActivityLog that will initialize the member variables of a class UserActivityLog using three parameters and the values of the parameter are the properties of the login class.
• The next step is to use the method "task" of the class UserActivityLog with the parameter "Save Record".

The same with the blocks, C, D, and E.

Step 15. Now press F5. You will see the login screen; just enter.

• user name: Naveed.zaman
• user name: khan@123

Click the login button.

Now press the "Add-New" button, "Save" button, "Discard" button, and then press the "Login" button.

Step 16. Now open the SQL Server table; you will get a result like the following.