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
{
}
}
