private void btnBack_Click(object sender, EventArgs e) { Chef chef = new Chef(plan); Bartender bar = new Bartender(plan); plan.Controls.Remove(this); if (lbS.Text == "Gift Cashier Schedule") { ((Button)bar.Controls["btnOrder"]).Text = "Gift Order"; ((Button)bar.Controls["btnS"]).Text = lbS.Text; ((Label)bar.Controls["lbTitle"]).Text = "Gift Cashier"; plan.Controls.Add(bar); } if (lbS.Text == "Bartender Schedule") { ((Button)bar.Controls["btnOrder"]).Text = "Bar Order"; ((Button)bar.Controls["btnS"]).Text = lbS.Text; ((Label)bar.Controls["lbTitle"]).Text = "Bartender"; plan.Controls.Add(bar); } if (lbS.Text == "Chef Schedule") { ((Button)chef.Controls["btnS"]).Text = lbS.Text; ((Label)chef.Controls["lbTitle"]).Text = "Chef"; plan.Controls.Add(chef); } if (lbS.Text == "Server Schedule") { ((Button)chef.Controls["btnS"]).Text = lbS.Text; ((Label)chef.Controls["lbTitle"]).Text = "Server"; plan.Controls.Add(chef); } if (lbS.Text == "Cleaner Schedule") { ((Button)chef.Controls["btnS"]).Text = lbS.Text; ((Label)chef.Controls["lbTitle"]).Text = "Cleaner"; plan.Controls.Add(chef); } ((Label)bar.Controls["lbName"]).Text = lbName.Text; ((Label)chef.Controls["lbName"]).Text = lbName.Text; ((Label)bar.Controls["lbID"]).Text = lbID.Text; ((Label)chef.Controls["lbID"]).Text = lbID.Text; }
private void btnEmLog_Click(object sender, EventArgs e) { var uid = txtEmId.Text; var password = txtEmPW.Text; var query = "SELECT Staff_ID,Password,Position_Name,First_Name,Last_Name FROM Staff,Positions WHERE Staff_ID = '" + uid + "' AND Password = '******' AND Positions.Position_ID = Staff.Position_ID"; var chef = new Chef(_plan); var bar = new Bartender(_plan); if (_connection != null) { _connection.Open(); SetupSqlCommand(query); var dataReader = _cmd.ExecuteReader(); if (dataReader.HasRows) { var em = new Employee(); while (dataReader.Read()) { em.EmID = dataReader["Staff_ID"].ToString(); em.Password = dataReader["Password"].ToString(); em.PositionName = dataReader["Position_Name"].ToString(); em.FName = dataReader["First_Name"].ToString(); em.LName = dataReader["Last_Name"].ToString(); // employees.Add(em); } // Chef chef = new Chef(plan); if ((em.PositionName == "Server") || (em.PositionName == "Chef") || (em.PositionName == "Cleaner")) { if (em.PositionName == "Cleaner") { ((Button)chef.Controls["btnS"]).Text = @"Cleaner Schedule"; } if (em.PositionName == "Server") { ((Button)chef.Controls["btnS"]).Text = @"Server Schedule"; } if (em.PositionName == "Chef") { ((Button)chef.Controls["btnS"]).Text = @"Chef Schedule"; } ((Label)chef.Controls["lbTitle"]).Text = em.PositionName; ((Label)chef.Controls["lbName"]).Text = em.FName + @" " + em.LName; ((Label)chef.Controls["lbID"]).Text = em.EmID; _plan.Controls.Add(chef); _plan.Controls.Remove(this); } else { if (em.PositionName == "Cashier") { ((Button)bar.Controls["btnOrder"]).Text = @"Gift Order"; ((Button)bar.Controls["btnS"]).Text = @"Gift Cashier Schedule"; ((Label)bar.Controls["lbTitle"]).Text = @"Gift " + em.PositionName; } if (em.PositionName == "Bartender") { ((Button)bar.Controls["btnOrder"]).Text = @"Bar Order"; ((Button)bar.Controls["btnS"]).Text = @"Bartender Schedule"; ((Label)bar.Controls["lbTitle"]).Text = em.PositionName; } ((Label)bar.Controls["lbName"]).Text = em.FName + @" " + em.LName; ((Label)bar.Controls["lbID"]).Text = em.EmID; _plan.Controls.Add(bar); _plan.Controls.Remove(this); } dataReader.Close(); } else { MessageBox.Show(@"Invalid username/password, please try again"); } _connection.Close(); } else { _connection?.Close(); MessageBox.Show(@"Try to reconnect database server"); } }