private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("select * from Login where Username='******' and Password= '******'", con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable tbl = new DataTable();
sda.Fill(tbl);
string usertypeValue = comboBox1.SelectedItem.ToString();
if (tbl.Rows.Count > 0)
{
for (int i = 0; i < tbl.Rows.Count; i++)
{
if (tbl.Rows[i][2].ToString() == usertypeValue)
{
MessageBox.Show("Successfully Logged In As " + tbl.Rows[i][2]);
if (comboBox1.SelectedIndex == 0)
{
this.Hide();
Client c = new Client(textBox1.Text);
c.Show();
}
else if (comboBox1.SelectedIndex == 1)
{
this.Hide();
Guard g = new Guard(textBox1.Text);
g.Show();
}
else
{
this.Hide();
Admin a = new Admin();
a.Show();
}
}
}
}
else
{
MessageBox.Show("Check Username or Password or User Type");
}
}
private void metroButton4_Click(object sender, EventArgs e)
{
string username = lusernamebox.Text;
string password = lpassbox.Text;
string type = loginasCombobox.Text;
// ------------------------- Login --------------------------//
if (username == "" || password == "" || type == "")
{
MessageBox.Show(this, "Fill up every blank.", "Message", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
}
else if (type == "Admin")
{
int t = bo.admin_login(username, password);
if (t == 0)
{
MessageBox.Show(this, "Wrong Combination", "Message", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
}
else if (t == 1)
{
bo.mainname = username;
Admin admin = new Admin(bo);
admin.Show();
this.Hide();
}
else
{
MessageBox.Show(this, "Wrong Combination", "Message", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
}
}
else if (type == "Accountant")
{
int t = bo.accountant_login(username, password);
if (t == 0)
{
MessageBox.Show(this, "Wrong Combination", "Message", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
}
else if (t == 1)
{
bo.mainname = username;
Accountant_Main_Page acc = new Accountant_Main_Page(bo);
acc.Show();
this.Hide();
}
else
{
MessageBox.Show(this, "Wrong Combination", "Message", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
}
}
else if (type == "Client")
{
int t = bo.client_login(username, password);
if (t == 0)
{
MessageBox.Show(this, "Wrong Combination", "Message", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
}
else if (t == 1)
{
bo.mainname = username;
Client client = new Client(bo);
client.Show();
this.Hide();
}
else
{
MessageBox.Show(this, "Wrong Combination", "Message", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error);
}
}
}
