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);
}
}
}
