private void metroButton1_Click(object sender, EventArgs e)
{
Logglobals.logout = DateTime.Now;
Role.UserLog log = new Role.UserLog(Logglobals.id, Logglobals.logout.ToString("yyyy-MM-dd HH:mm:ss"), Logglobals.detail);
try
{
Database.updateLog(log);
Userglobals.uid = 0;
Userglobals.uname = "";
Userglobals.priv = "";
Logglobals.detail = "";
Logglobals.ip = "";
Logglobals.login.ToLocalTime();
Logglobals.logout.ToLocalTime();
Logglobals.id = 0;
Dashboard dash = new Dashboard();
this.Hide();
dash.ShowDialog();
this.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
public static void updateLog(Role.UserLog log)
{
try
{
DBConnection.updateDB("update user_log set logged_out_dateTime='" + log.LoggedOutDateTime + "', detail='" + log.Detail + "' where log_id = '" + log.LogId + "';");
}
catch (Exception ex)
{
Console.WriteLine(ex);
MessageBox.Show("Something went wrong!", "Logging out", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static void addLog(Role.UserLog log)
{
try
{
DBConnection.updateDB("insert into user_log (user_id, logged_in_dateTime, detail, ip) values " +
"(" + log.User.UserId + ",'" + log.LoggedInDateTime + "','" + log.Detail + "', '" + log.Ip + "')");
}
catch (Exception ex)
{
Console.WriteLine(ex);
MessageBox.Show("Something went wrong!", "Logging in", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}