private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" && textBox2.Text != "")
{
SqlConnection con = new SqlConnection("Data Source=DESKTOP-9LCQ337;Initial Catalog=bloodsystem;Integrated Security=True");
con.Open();
SqlCommand cmd1 = new SqlCommand("select user ");
SqlCommand cmd = new SqlCommand("select user_type from [user_table] where username='******' and password='******'", con);
string user_type = (string)cmd.ExecuteScalar();
if (user_type == "u")
{
SqlDataAdapter da = new SqlDataAdapter("select count(*) from [user_table] where username='******' and password='******'", con);
DataTable dt = new DataTable();
da.Fill(dt);
SqlCommand cm = new SqlCommand("select [use_id] from [user_table] where username='******' and password='******'", con);
value = (int)cm.ExecuteScalar();
if (dt.Rows[0][0].ToString() == "1")
{
this.Hide();
Adddonators f5 = new Adddonators();
f5.Show();
}
else
{
MessageBox.Show("invaulid username or password");
}
}
else if (user_type == "a")
{
SqlDataAdapter da = new SqlDataAdapter("select count(*) from [user_table] where username='******' and password='******'", con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
this.Hide();
AdminForm f6 = new AdminForm();
f6.Show();
}
else
{
MessageBox.Show("invaulid username or password");
}
}
else
{
MessageBox.Show("invaulid username or password");
}
}
else
{
MessageBox.Show("fill all textbox");
}
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
this.Hide();
Adddonators f5 = new Adddonators();
f5.Show();
}
