private void logoutToolStripMenuItem_Click(object sender, EventArgs e)
{
DialogResult Diag = new DialogResult();
Diag = MessageBox.Show("Do you want to logout?", "Confirmation", MessageBoxButtons.YesNo);
if (Diag == DialogResult.Yes)
{
Obj.Connection();
Obj.WriteAudit("INSERT INTO tblaudit (UserName,Module,Activity,DateOccured) VALUES ('"
+ user + "','Dashboard','Logged-Out','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "')");
Obj.CloseConnection();
this.Hide();
var form2 = new frmLogin();
form2.Closed += (s, args) => this.Close();
form2.Show();
}
else if (Diag == DialogResult.No)
{
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
DatabaseLibrary Obj = new DatabaseLibrary();
//string dtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
try
{
Obj.Connection();
Obj.cmd = new MySqlCommand(@"SELECT * FROM tbluser WHERE BINARY UserName=@UserN AND Password=@PassW LIMIT 1", Obj.conn);
Obj.cmd.Parameters.AddWithValue("@UserN", txtUser.Text);
Obj.cmd.Parameters.AddWithValue("@PassW", txtPass.Text);
Obj.datRead = Obj.cmd.ExecuteReader();
if (Obj.datRead.HasRows)
{
Obj.datRead.Read();
uL = Obj.datRead.GetString(2);
Obj.CloseConnection();
Obj.Connection();
Obj.WriteAudit("INSERT INTO tblaudit (UserName,Module,Activity,DateOccured) VALUES ('"
+ txtUser.Text + "','Login','Logged-In','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "')");
MessageBox.Show("Access Granted!", "OK", MessageBoxButtons.OK, MessageBoxIcon.Information);
Obj.CloseConnection();
this.Hide();
var form2 = new frmMain(txtUser.Text, uL);
form2.Closed += (s, args) => this.Close();
form2.Show();
}
else
{
MessageBox.Show("Access Denied!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtUser.Text = string.Empty;
txtPass.Text = string.Empty;
txtUser.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
