public HomeDelivary(Salesman_Home shm, string ss)
{
InitializeComponent();
this.shm = shm;
label3.Text = ss;
label5.Hide();
t.Rows.Clear();
dataGridView1.DataSource = t;
SqlConnection con1 = 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");
con1.Open();
string sl = string.Format("SELECT CId,status,totalCost,mobileno FROM Orderdetails");
SqlCommand s = new SqlCommand(sl, con1);
SqlDataAdapter dt = new SqlDataAdapter(s);
dt.Fill(t);
dataGridView1.DataSource = t;
}
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=D:\C# pro\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 if (l == 8 || l == 9 || l == 10 || l == 11)
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\C# pro\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
{
MessageBox.Show("Wrong User Id or password", "Waring", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
public PasswordChangeS(Salesman_Home s, string nm)
{
InitializeComponent();
this.s = s;
this.nm = nm;
}