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