private void add_FormClosing(object sender, FormClosingEventArgs c) { c.Cancel = true; this.Hide(); DBSheet db = new DBSheet(); db.Show(); }
private void button1_Click(object sender, EventArgs e) { try { if (!(tbUserLogin.Text == string.Empty)) { if (!(tbPwdLogin.Text == string.Empty)) { dataConnect.Open(); String query = "SELECT * FROM Users WHERE username = @username and password = @password"; SqlCommand cmd = new SqlCommand(query, dataConnect); cmd.Parameters.AddWithValue("@username", tbUserLogin.Text); cmd.Parameters.AddWithValue("@password", tbPwdLogin.Text); SqlDataReader dbr; int isLogged = 0; dbr = cmd.ExecuteReader(); while (dbr.Read()) { isLogged = isLogged + 1; } if (isLogged == 1) { dbr.Close(); string roleChecker = string.Empty; String roleQuery = "SELECT * FROM Users WHERE username = @username"; SqlCommand roleCmd = new SqlCommand(roleQuery, dataConnect); roleCmd.Parameters.AddWithValue("@username", tbUserLogin.Text); SqlDataReader roleRead; roleRead = roleCmd.ExecuteReader(); roleRead.Read(); roleChecker = roleRead.GetValue(4).ToString(); if (roleChecker == "3") { dbForm.Show(); } else if (roleChecker != "3") { uPanel.Show(); } } else if (isLogged > 1) { MessageBox.Show("Duplicate username and password", "login page"); } else { MessageBox.Show(" username and password incorrect", "login page"); } } else { MessageBox.Show(" password empty", "login page"); } } else { MessageBox.Show(" username empty", "login page"); } } catch (Exception es) { MessageBox.Show(es.Message); } finally { dataConnect.Close(); } }
private void button1_Click(object sender, EventArgs e) { dbForm.Show(); }