private void BtnLogin_Click(object sender, RoutedEventArgs e) { string queryCheckCredentials = string.Format("SELECT users.emp_id AS EMP_ID, " + "users.role_id as ROLE_ID, " + "users.password AS PASSWORD, " + "users_information.status AS STATUS " + "FROM users LEFT JOIN users_information " + "ON users.emp_id = users_information.emp_id " + "WHERE users.emp_id = @empID AND users_information.emp_id = @empID " + "AND users.password = @password"); string queryLogInRecord = string.Format("INSERT INTO timelog" + "(emp_id, log_time, log_status) " + "VALUES" + "(@emp_id, @log_time, @log_status)"); try { if (SqlQueries.Login(queryCheckCredentials, Convert.ToInt32(txtEmpID.Text), txtPassword.Password) == true) { if (SqlQueries.Logger(queryLogInRecord, Globals.Emp_ID, btnLogin.Content.ToString())) { MessageBox.Show("Logged in"); MainWindow mw = new MainWindow(); this.Close(); mw.ShowDialog(); } } else { txtEmpID.Clear(); txtPassword.Clear(); } } catch (Exception err) { MessageBox.Show(err.Message); } }
// button to logout // sets logout data to true to close application private void BtnLogout_Click(object sender, RoutedEventArgs e) { string queryLoggerOut = string.Format("INSERT INTO timelog" + "(emp_id, log_time, log_status) " + "VALUES(@emp_id, @log_time, @log_status)"); if (cartTotal == 0) { if (SqlQueries.Logger(queryLoggerOut, Globals.Emp_ID, btnLogout.Content.ToString()) == true) { MessageBox.Show("Logging Out"); lblEmpID.Content = " "; lblEmployee.Content = " "; Login login = new Login(); logout = true; if (logout == true) { this.Close(); } login.Show(); } else { MessageBox.Show("Something went wrong logging out"); } } else { MessageBox.Show("Transaction Ongoing"); } }