private void loginBtn_Click(object sender, EventArgs e) { user = usernameTxt.Text; pass = passwordTxt.Text; if (user == "" || pass == "") { MetroFramework.MetroMessageBox.Show(this, "Please provide UserName and Password"); return; } if (conn.State == ConnectionState.Closed) { conn.Open(); } try { string sql = "SELECT * FROM Login"; cmd = new SqlCommand(sql, conn); dataReader = cmd.ExecuteReader(); Boolean valid = false; while (dataReader.Read()) { if (dataReader.GetString(0) == user && dataReader.GetString(1) == pass) { this.Hide(); valid = true; if (dataReader.GetString(2) == "Admin") { AdminPanel ap = new AdminPanel(this, conn); ap.Show(); } else if (dataReader.GetString(2) == "Management") { ManagementPanel mp = new ManagementPanel(this, conn); mp.Show(); } else { MetroFramework.MetroMessageBox.Show(this, "You Don't Have Access to System"); this.Show(); } } } if (!valid) { MetroFramework.MetroMessageBox.Show(this, "Incorrect Login Details. Try Again"); } } catch (Exception) { throw; } finally { conn.Close(); } }
private void admManageBtn_Click(object sender, EventArgs e) { mPan = new ManagementPanel(form, conn); mPan.Show(); this.Hide(); }