private void button2_Click(object sender, EventArgs e)
{
string identi = textBox1.Text;
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Jahin\Documents\Super_shop_test_1.mdf;Integrated Security=True;Connect Timeout=30");
con.Open();
SqlCommand s1 = new SqlCommand("SELECT * FROM Customerinfo where userId = '" + textBox1.Text + "' and password = '******'", con);
SqlDataReader dt;
dt = s1.ExecuteReader();
int c = 0;
while (dt.Read())
{
c += 1;
}
if (c == 1)
{
ChooseProduct cp = new ChooseProduct(identi);
cp.Show();
this.Hide();
}
else if (c > 0)
{
MessageBox.Show("Wrong User Id or password", "Waring", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("Wrong User Id or password", "Waring", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
textBox1.Text = textBox1.Text;
textBox2.Clear();
}
private void button1_Click(object sender, EventArgs e)
{
cp.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
// Salesman_Home p = new Salesman_Home(this);
c.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
string identi = textBox1.Text;
int l = textBox1.Text.Length;
int l1 = textBox2.Text.Length;
if (l == 5 || l == 6 || l == 7)
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Lenovo\Desktop\project final\try table with\Super_shop_test_1.mdf;Integrated Security=True;Connect Timeout=30");
con.Open();
SqlCommand s1 = new SqlCommand("SELECT * FROM Customerinfo where userId = '" + textBox1.Text + "' and password = '******'", con);
SqlDataReader dt;
dt = s1.ExecuteReader();
int c = 0;
while (dt.Read())
{
c += 1;
}
if (c == 1)
{
ChooseProduct cp = new ChooseProduct(identi);
cp.Show();
this.Hide();
}
else if (c > 0)
{
MessageBox.Show("Wrong User Id or password", "Waring", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("Wrong User Id or password", "Waring", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
textBox1.Text = textBox1.Text;
textBox2.Clear();
}
else if (l == 8 || l == 9 || l == 10 || l == 11)
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Lenovo\Desktop\project final\try table with\Super_shop_test_1.mdf;Integrated Security=True;Connect Timeout=30");
con.Open();
SqlCommand s1 = new SqlCommand("SELECT * FROM Salesmaninfo where SId = '" + textBox1.Text + "' and password = '******'", con);
SqlDataReader dt;
dt = s1.ExecuteReader();
int c = 0;
while (dt.Read())
{
c += 1;
}
if (c == 1)
{
Salesman_Home sh = new Salesman_Home(identi);
sh.Show();
this.Hide();
}
else if (c > 0)
{
MessageBox.Show("Wrong User Id or password", "Waring", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("Wrong User Id or password", "Waring", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
textBox1.Text = textBox1.Text;
textBox2.Clear();
}
else if (l == 2 || l == 3 || l == 4)
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Lenovo\Desktop\project final\try table with\Super_shop_test_1.mdf;Integrated Security=True;Connect Timeout=30");
con.Open();
SqlCommand s1 = new SqlCommand("SELECT * FROM Admininfo where AId = '" + textBox1.Text + "' and password = '******'", con);
SqlDataReader dt;
dt = s1.ExecuteReader();
int c = 0;
while (dt.Read())
{
c += 1;
}
if (c == 1)
{
Admin_Home ah = new Admin_Home(identi);
ah.Show();
this.Hide();
}
else if (c > 0)
{
MessageBox.Show("Wrong User Id or password", "Waring", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("Wrong User Id or password", "Waring", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
textBox1.Text = textBox1.Text;
textBox2.Clear();
}
else
{
MessageBox.Show("Wrong User Id or password", "Waring", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}