예제 #1
0
        public static int Company()
        {
            int CompanyID = 0;

            if (GetUserLogInfo.GetMacAddress() == "408D5C3D4380")
            {
                CompanyID = 100;       // Kamrul-PC
            }
            else if (GetUserLogInfo.GetMacAddress() == "408D5C3D42D4")
            {
                CompanyID = 101;       // Kamrul-PC
            }
            else if (GetUserLogInfo.GetMacAddress() == "1C1B0DA84A7E")
            {
                CompanyID = 102;       // China-PC
            }
            else
            {
                CompanyID = 420;        // Un authorized pc
            }
            // int CompanyID = 5;        // SERVER
            // int CompanyID = 29;       // Front/Sales PC
            // int CompanyID = 14;       // VAT PC
            // int CompanyID = 23;       // Spears Parts
            // int CompanyID = 61;       //
            return(CompanyID);
        }
        private void Log_IN()
        {
            DateTime now        = DateTime.Now;
            string   date       = now.ToString("yyyyMMdd");
            int      today      = Convert.ToInt32(date);
            int      start_date = 20170516;
            int      last_date  = 20170530;

            if (start_date > today || last_date < today)
            {
                Trial tri = new Trial();
                tri.Show();
                Hide();
            }

            else
            {
                try
                {
                    string userName = textBoxUserName.Text;
                    userName = userName.Replace("'", "Sonali");
                    userName = userName.Replace("\"", "Sonali");
                    userName = userName.Replace("or", "Sonali");
                    userName = userName.Replace("OR", "Sonali");
                    userName = userName.Replace("-", "Sonali");
                    userName = userName.Replace("--", "Sonali");
                    userName = userName.Replace("=", "Sonali");
                    userName = userName.Replace("==", "Sonali");
                    userName = userName.Replace("===", "Sonali");
                    userName = userName.Replace(" ", "Sonali");
                    userName = userName.Replace("  ", "Sonali");
                    userName = userName.Replace("   ", "Sonali");
                    userName = userName.Replace("*", "Sonali");
                    string password = textBoxPassword.Text;
                    password = password.Replace(" ", "Sonali");
                    int Role  = 0;
                    int error = 0;
                    loguser = userName;
                    string        conStr     = ConfigurationManager.ConnectionStrings["PosConString"].ToString();
                    SqlConnection connection = new SqlConnection(conStr);
                    string        query      = "SELECT * FROM [User] WHERE UserName = @userName AND Password= @Password";
                    SqlCommand    command    = new SqlCommand(query, connection);

                    SqlParameter param  = new SqlParameter();
                    SqlParameter param2 = new SqlParameter();

                    param.ParameterName = "@userName";
                    param.Value         = userName;

                    param2.ParameterName = "@Password";
                    param2.Value         = password;

                    command.Parameters.Add(param);
                    command.Parameters.Add(param2);

                    connection.Open();

                    SqlDataReader reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        Role      = Convert.ToInt32(reader["Role"]);
                        loguserID = Convert.ToInt32(reader["ID"]);
                        error     = 1;
                    }
                    loguserRole = Role;
                    connection.Close();



                    if (error == 0)
                    {
                        MessageBox.Show("User Name or Password incorrect...");
                    }
                    if (error != 0)
                    {
                        // User Log Info Start

                        string CurrentUser    = userName;
                        int    Companyid      = CompanyID;
                        string ComputerName   = GetUserLogInfo.hostName;
                        string MacAddress     = GetUserLogInfo.GetMacAddress();
                        string LocalIPAddress = GetUserLogInfo.GetLocalIPAddress();
                        // string RealIPAddress = GetUserLogInfo.GetRealIPAddress();
                        string status = "1";


                        //  InsertUserLog(CurrentUser, Companyid, ComputerName, MacAddress, LocalIPAddress, RealIPAddress, status);
                        InsertUserLog(CurrentUser, Companyid, ComputerName, MacAddress, LocalIPAddress, status);        // Without Real IP

                        // User Log Info End

                        MainBody amainbody = new MainBody();
                        amainbody.Show();
                        Hide();
                    }
                }
                catch (Exception)
                {
                    MessageBox.Show("Database Connection Failed...");
                }
            }
        }