private void button4_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox1, "Please Enter Serial Number");
}
else
{
errorProvider1.Clear();
conn();
string s = "Select * from Service where Serial=@sn";
cmd.CommandText = s;
cmd.Parameters.AddWithValue("@sn", textBox1.Text);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
textBox1.Text = dr[5].ToString();
textBox2.Text = dr[3].ToString();
textBox3.Text = dr[4].ToString();
textBox4.Text = dr[6].ToString();
textBox5.Text = dr[7].ToString();
textBox6.Text = dr[9].ToString();
richTextBox2.Text = dr[10].ToString();
}
scon.Close();
SearchDone sd = new SearchDone();
sd.Show();
}
else
{
RecordDone rd = new RecordDone();
rd.Show();
}
}
}
private void button4_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
errorProvider1.SetError(textBox1, "Please Enter Serial Number");
}
else
{
errorProvider1.Clear();
conn();
string s = "Select * from Car where Serial=@sn";
cmd.CommandText = s;
cmd.Parameters.AddWithValue("@sn", textBox1.Text);
SqlDataReader rd = cmd.ExecuteReader();
if (rd.HasRows)
{
int count = 0;
while (rd.Read())
{
textBox1.Text = rd[2].ToString();
comboBox1.Text = rd[3].ToString();
comboBox2.Text = rd[4].ToString();
comboBox3.Text = rd[5].ToString();
comboBox4.Text = rd[6].ToString();
textBox2.Text = rd[7].ToString();
count++;
}
scon.Close();
SearchDone sd = new SearchDone();
sd.Show();
}
else
{
RecordDone rdd = new RecordDone();
rdd.Show();
}
}
}
private void button4_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" && comboBox5.Text == "")
{
errorProvider1.SetError(textBox1, "Please Enter Customer Name OR Serial Number");
errorProvider1.SetError(comboBox5, "Please Enter Customer Name OR Serial Number");
}
else
{
errorProvider1.Clear();
if (textBox1.Text != "")
{
conn();
string s_name = "Select c.Name,c.Street,c.City,c.Prov,c.Pcode,c.Phone,cr.Serial,cr.Model,cr.Trim,cr.Color,cr.Year,cr.Price,cr.Purchinv,cr.Purchdate from Customer c,Car cr WHERE c.ID=cr.Cid AND c.Name=@cname";
cmd1.CommandText = s_name;
cmd1.Parameters.AddWithValue("@cname", textBox1.Text);
SqlDataReader dr = cmd1.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
textBox1.Text = dr[0].ToString();
textBox2.Text = dr[1].ToString();
textBox3.Text = dr[2].ToString();
textBox4.Text = dr[3].ToString();
textBox5.Text = dr[4].ToString();
textBox6.Text = dr[5].ToString();
comboBox5.Text = dr[6].ToString();
comboBox1.Text = dr[7].ToString();
comboBox2.Text = dr[8].ToString();
comboBox3.Text = dr[9].ToString();
comboBox4.Text = dr[10].ToString();
textBox8.Text = dr[11].ToString();
textBox9.Text = dr[13].ToString();
textBox10.Text = dr[12].ToString();
}
SearchDone sd = new SearchDone();
sd.Show();
}
else
{
RecordDone rdd = new RecordDone();
rdd.Show();
}
}
else if (comboBox5.Text != "")
{
conn();
string s_cid = "Select DISTINCT c.Name,c.Street,c.City,c.Prov,c.Pcode,c.Phone,cr.Serial,cr.Model,cr.Trim,cr.Color,cr.Year,cr.Price,cr.Purchinv,cr.Purchdate from Customer c,Car cr where c.ID=cr.Cid AND cr.Serial=@serial";
cmd2.CommandText = s_cid;
cmd2.Parameters.AddWithValue("@serial", comboBox5.Text);
SqlDataReader dr = cmd2.ExecuteReader();
if (dr.HasRows)
{
int count = 0;
while (dr.Read())
{
textBox1.Text = dr[0].ToString();
textBox2.Text = dr[1].ToString();
textBox3.Text = dr[2].ToString();
textBox4.Text = dr[3].ToString();
textBox5.Text = dr[4].ToString();
textBox6.Text = dr[5].ToString();
comboBox5.Text = dr[6].ToString();
comboBox1.Text = dr[7].ToString();
comboBox2.Text = dr[8].ToString();
comboBox3.Text = dr[9].ToString();
comboBox4.Text = dr[10].ToString();
textBox8.Text = dr[11].ToString();
textBox9.Text = dr[13].ToString();
textBox10.Text = dr[12].ToString();
count++;
}
SearchDone sd = new SearchDone();
sd.Show();
}
else
{
RecordDone rdd = new RecordDone();
rdd.Show();
}
}
scon.Close();
}
}
private void button4_Click(object sender, EventArgs e)
{
conn();
if (textBox1.Text == "" && textBox2.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox1, "Please Enter Serial Number OR Customer Name");
errorProvider1.SetError(textBox2, "Please Enter Serial Number OR Customer Name");
}
else if (textBox2.Text != "" && textBox1.Text == "")
{
errorProvider1.Clear();
string s_name = "Select cr.Serial,c.Name,cr.Model,cr.Trim,cr.Color,cr.Year,cr.Purchdate,cr.Price,s.Salesman,s.Insurance from Car cr,Customer c,Saleinv s where cr.Cid=c.ID AND cr.Cid=s.Cid AND c.Name=@cname";
cmd.CommandText = s_name;
cmd.Parameters.AddWithValue("@cname", textBox2.Text);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
textBox1.Text = dr[0].ToString();
textBox2.Text = dr[1].ToString();
textBox3.Text = dr[8].ToString();
comboBox1.Text = dr[2].ToString();
comboBox2.Text = dr[3].ToString();
comboBox3.Text = dr[4].ToString();
comboBox4.Text = dr[5].ToString();
textBox5.Text = dr[6].ToString();
textBox6.Text = dr[7].ToString();
if (dr[9].ToString().Equals("YES"))
{
radioButton1.Checked = true;
}
else
{
radioButton2.Checked = true;
}
}
}
else
{
RecordDone rd = new RecordDone();
rd.Show();
}
}
else if (textBox2.Text == "" && textBox1.Text != "")
{
errorProvider1.Clear();
string s_name = "Select cr.Serial,c.Name,cr.Model,cr.Trim,cr.Color,cr.Year,cr.Purchdate,cr.Price,s.Salesman,s.Insurance from Car cr,Customer c,Saleinv s where cr.Cid=c.ID AND cr.Cid=s.Cid AND cr.Serial=@serial";
cmd.CommandText = s_name;
cmd.Parameters.AddWithValue("@serial", textBox1.Text);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
textBox1.Text = dr[0].ToString();
textBox2.Text = dr[1].ToString();
textBox3.Text = dr[8].ToString();
comboBox1.Text = dr[2].ToString();
comboBox2.Text = dr[3].ToString();
comboBox3.Text = dr[4].ToString();
comboBox4.Text = dr[5].ToString();
textBox5.Text = dr[6].ToString();
textBox6.Text = dr[7].ToString();
if (dr[9].ToString().Equals("YES"))
{
radioButton1.Checked = true;
}
else
{
radioButton2.Checked = true;
}
}
}
scon.Close();
}