private void button1_Click(object sender, EventArgs e)
{
bool work = false;
label4.Text = "";
string query = @"select * from Account where username='******' and password='******' and position='site administrator'";
ds.Clear();
da.SelectCommand = new SqlCommand(query, db);
db.Open();
da.Fill(ds);
db.Close();
if (ds.Tables[0].Rows.Count > 0)
{
ManageUserAccount mg = new ManageUserAccount();
this.Hide();
mg.ShowDialog();
this.Show();
textBox1.Text = textBox2.Text = "";
work = true;
}
else if (work == false)
{
query = @"select * from Account where username='******' and password='******' and position='secretary'";
ds.Clear();
da.SelectCommand = new SqlCommand(query, db);
db.Open();
da.Fill(ds);
db.Close();
if (ds.Tables[0].Rows.Count > 0)
{
SecretaryWindow sc = new SecretaryWindow();
this.Hide();
sc.ShowDialog();
this.Show();
textBox1.Text = textBox2.Text = "";
work = true;
}
else if (work == false)
{
query = @"select * from Account where username='******' and password='******' and position='officer'";
ds.Clear();
da.SelectCommand = new SqlCommand(query, db);
db.Open();
da.Fill(ds);
db.Close();
if (ds.Tables[0].Rows.Count > 0)
{
OfficerWindow of = new OfficerWindow();
this.Hide();
of.ShowDialog();
this.Show();
textBox1.Text = textBox2.Text = "";
work = true;
}
else if (work == false)
{
query = @"select * from Account where username='******' and password='******' and position='post women'";
ds.Clear();
da.SelectCommand = new SqlCommand(query, db);
db.Open();
da.Fill(ds);
db.Close();
if (ds.Tables[0].Rows.Count > 0)
{
PostwomenWindow pw = new PostwomenWindow();
this.Hide();
pw.ShowDialog();
this.Show();
textBox1.Text = textBox2.Text = "";
work = true;
}
else
{
label4.Text = "warning : wrong user name or password";
}
}
}
}
}
private void button5_Click(object sender, EventArgs e)
{
ManageUserAccount mg = new ManageUserAccount();
mg.Show();
}