public Cashiers GetCashiers(int CashNumber) { Cashiers matchingCashier = new Cashiers(); using (SqlConnection myCnn = new SqlConnection(Helper.CnnVal("GroceriesDB"))) { string oString = "dbo.Cashier_GetByCashNumber @CashNumber"; SqlCommand oCmd = new SqlCommand(oString, myCnn); oCmd.Parameters.AddWithValue("@CashNumber", CashNumber); myCnn.Open(); using (SqlDataReader oReader = oCmd.ExecuteReader()) { while (oReader.Read()) { matchingCashier.Name = oReader["Name"].ToString(); matchingCashier.UserPassword = (int)oReader["UserPassword"]; } myCnn.Close(); } } return(matchingCashier); }
private void btnEnter_Click(object sender, EventArgs e) { try { if (TxtCashier.Enabled == true) { //if it matches, establish data access based on the cashier number entered DataAccess db = new DataAccess(); Cashiers c = db.GetCashiers(Convert.ToInt16(TxtCashier.Text)); Supervisors s = db.GetSupervisors(Convert.ToInt16(TxtCashier.Text)); //If user enters an invalid cashier number, chashier name will turn up null and will not run. clears if (c.Name != null || s.Name != null) { //sets the variables for password entry and stores cashier name if (c.Name != null) { Global.Cashier = c.Name; Global.Password = c.UserPassword.ToString(); } if (s.Name != null) { Global.Cashier = s.Name; Global.Password = s.Sup_Password.ToString(); } LblName.Text = Global.Cashier; TxtCashier.Enabled = false; txtPassword.Enabled = true; txtPassword.Focus(); return; } else { MessageBox.Show("Invalid Cashier!"); btnClear_Click(sender, e); } } //runs when the password textbox is enabled if (txtPassword.Enabled == true) { //runs if the password entered matches the users password if (txtPassword.Text == Global.Password) { MessageBox.Show("Log In Successful!"); //closes/hides the log in form this.Hide(); //launches the register form register.FormClosed += (s, args) => this.Close(); register.Show(); } else { //resets the log in form MessageBox.Show("Wrong Password!" + Environment.NewLine + "Try Again!"); btnClear_Click(sender, e); } } } catch { } }