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