private void btn_enter_Click(object sender, EventArgs e) { automation_systemEntities database = new automation_systemEntities(PublicVariable.MainConnectionString); try { if (txt_username.Text.Trim() != "" && txt_password.Text.Trim() != "") { /////////////hashing password SHA256CryptoServiceProvider SHA256 = new SHA256CryptoServiceProvider(); Byte[] B1; Byte[] B2; B1 = UTF8Encoding.UTF8.GetBytes(txt_password.Text.Trim()); B2 = SHA256.ComputeHash(B1); string HashedPassword = BitConverter.ToString(B2); var login_query = (from U in database.Users where U.Username == txt_username.Text.Trim() where U.Password == HashedPassword where U.Activity == 1 select U).ToList(); if (login_query.Count == 1) { /// Obtain user profile for use throughout the app PublicVariable.gUserFirstName = login_query[0].UserFirstName; PublicVariable.gUserFamilyName = login_query[0].UserFamily; PublicVariable.gUserId = login_query[0].userID; /////Register user profile in log file to control entry and exit s.22 string computerName = System.Environment.MachineName; UserLog UL = new UserLog(); UL.ComputerName = computerName; UL.IpAddress = lbl_IP.Text.Trim(); UL.EnterDateTime = lbl_date.Text.Trim() + "-" + string.Format("{0:HH:mm:ss}", Convert.ToDateTime(DateTime.Now.Hour + ":" + DateTime.Now.Minute + ":" + DateTime.Now.Second)); UL.UserId = PublicVariable.gUserId; database.UserLogs.Add(UL); database.SaveChanges(); } else { MessageBox.Show("The user was not found"); return; } if (rdb_admin.Checked) { if (txt_username.Text.Trim() == "admin") { PublicVariable.gSetUser = 1; ////admin } else { MessageBox.Show("The user does not have administrator access"); return; } } else { PublicVariable.gSetUser = 2; ///users } this.Close(); } } catch { MessageBox.Show("There is a problem with the server, please try again"); } }