private void btnExit_Click(object sender, EventArgs e) { DialogResult dr = MessageBox.Show("Are you sure you want to log out the current account?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { try { MySqlCommand cmd = new MySqlCommand(); string sql = "UPDATE tblLogIn " + "SET strDoctStatus = 'OFF' " + "WHERE strStaffID = '" + userID + "' AND " + "dtmDateTimeLogOut IS NULL;"; cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); sql = "UPDATE tblLogIn " + "SET dtmDateTimeLogOut = NOW(), " + "strDoctStatus = 'OFF' " + "WHERE strLogInCode = @userID;"; cmd = new MySqlCommand(sql, conn); /* Prepare SQL Statements */ cmd.Parameters.AddWithValue("@userID", userID); cmd.Prepare(); /* Execute Prepared Query */ cmd.ExecuteNonQuery(); /* Close Connection */ conn.Close(); FormLogIn fli = new FormLogIn(); fli.Show(); this.Close(); } catch (MySqlException me) { MessageBox.Show(me.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
static void Main() { try { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); FormLogIn start = new FormLogIn(); start.FormClosed += new FormClosedEventHandler(FormClosed); start.Show(); Application.Run(); } catch (Exception ex) { MessageBox.Show("An unknown exception was caught!\n" + ex.Message + "\nPlease contact the administrator!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } // Main()
} // private void UpdateSystemTime() private void btnLogOut_Click(object sender, EventArgs e) { DialogResult dr = MessageBox.Show("Are you sure you want to log out the current account?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { try { MySqlCommand cmd = new MySqlCommand(); string sql = "UPDATE tblLogIn " + "SET dtmDateTimeLogOut = NOW() " + "WHERE strLogInCode = @userID;"; cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; /* Prepare SQL Statements */ cmd.Parameters.AddWithValue("@userID", userID); cmd.Prepare(); /* Execute Prepared Query */ cmd.ExecuteNonQuery(); /* Close Connection */ conn.Close(); /* Close Scanner */ ctrlLogs.CloseCam(); FormLogIn fli = new FormLogIn(); fli.Show(); formQueue.Close(); this.Close(); } catch (MySqlException me) { MessageBox.Show(me.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } // Action[Click]: btnLogOut
} // private void UpdateSystemTime() private void btnLogOut_Click(object sender, EventArgs e) { DialogResult dr = MessageBox.Show("Are you sure you want to log out the current account?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { try { MySqlCommand cmd = new MySqlCommand(); string sql = "UPDATE tblLogIn " + "SET strDoctStatus = 'OFF', " + "dtmDateTimeLogOut = NOW() " + "WHERE strStaffID = '" + userID + "' AND " + "dtmDateTimeLogOut IS NULL;"; cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); /* Close Connection */ conn.Close(); /* Close Threads */ ctrlViewAppt.CloseThreads(); FormLogIn fli = new FormLogIn(); fli.Show(); this.Close(); } catch (MySqlException me) { MessageBox.Show(me.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }