private void button3_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox1, "Please Enter Serial Number");
}
else if (comboBox1.SelectedIndex == -1)
{
errorProvider1.Clear();
errorProvider1.SetError(comboBox1, "Please Select Model");
}
else if (comboBox2.SelectedIndex == -1)
{
errorProvider1.Clear();
errorProvider1.SetError(comboBox2, "Please Select Trim");
}
else if (comboBox3.SelectedIndex == -1)
{
errorProvider1.Clear();
errorProvider1.SetError(comboBox3, "Please Select Color");
}
else if (comboBox4.SelectedIndex == -1)
{
errorProvider1.Clear();
errorProvider1.SetError(comboBox4, "Please Select Year");
}
else if (textBox2.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox2, "Please Enter Total Price");
}
else
{
errorProvider1.Clear();
conn();
cmd.CommandText = " Update Car SET Model=@mod,Trim=@trim,Color=@color,Year=@year,Price=@price where Serial=@serial";
cmd.Parameters.AddWithValue("@serial", textBox1.Text);
cmd.Parameters.AddWithValue("@mod", comboBox1.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@trim", comboBox2.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@color", comboBox3.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@year", comboBox4.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@price", textBox2.Text);
cmd.ExecuteNonQuery();
scon.Close();
UpdateDone ud = new UpdateDone();
ud.Show();
textBox1.Clear();
textBox2.Clear();
comboBox1.Text = "";
comboBox2.Text = "";
comboBox3.Text = "";
comboBox4.Text = "";
}
}
private void button3_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox1, "Please Enter Employee Name");
}
else if (comboBox1.SelectedIndex == -1)
{
errorProvider1.Clear();
errorProvider1.SetError(comboBox1, "Please Select Position");
}
else if (textBox2.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox2, "Please Select Birthdate");
}
else if (textBox3.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox3, "Please Enter Commission");
}
else
{
errorProvider1.Clear();
conn();
cmd.CommandText = " Update Employee SET Firstname=@fn,Position=@pos,Bdate=@bd,Commision=@com where Username=@uname";
cmd.Parameters.AddWithValue("@fn", textBox1.Text);
cmd.Parameters.AddWithValue("@pos", comboBox1.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@bd", textBox2.Text);
cmd.Parameters.AddWithValue("@com", textBox3.Text);
cmd.Parameters.AddWithValue("@uname", LoginPage.Username);
cmd.ExecuteNonQuery();
UpdateDone ud = new UpdateDone();
ud.Show();
}
}
private void button3_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox1, "Please Enter Customer name");
}
else if (textBox2.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox2, "Please Enter Street");
}
else if (textBox3.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox3, "Please Enter City");
}
else if (textBox4.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox4, "Please Enter Province");
}
else if (textBox5.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox5, "Please Enter Postalcode");
}
else if (textBox6.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox6, "Please Enter Phone number");
}
else if (textBox9.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox9, "Please Enter Purchase Date");
}
else if (comboBox5.SelectedIndex == -1 && comboBox5.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(comboBox5, "Please Select Car Serial Number");
}
else if (comboBox1.SelectedIndex == -1)
{
errorProvider1.Clear();
errorProvider1.SetError(comboBox1, "Please Select Model");
}
else if (comboBox2.SelectedIndex == -1)
{
errorProvider1.Clear();
errorProvider1.SetError(comboBox2, "Please Select Trim");
}
else if (comboBox3.SelectedIndex == -1)
{
errorProvider1.Clear();
errorProvider1.SetError(comboBox3, "Please Select Color");
}
else if (comboBox4.SelectedIndex == -1)
{
errorProvider1.Clear();
errorProvider1.SetError(comboBox4, "Please Select Year");
}
else if (textBox8.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox8, "Please Enter Total Price");
}
else if (textBox10.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox10, "Please Enter Purchase Invoice");
}
else
{
errorProvider1.Clear();
conn();
cmd1.CommandText = " Update Car SET Model=@mod,Trim=@trim,Color=@color,Year=@year,Price=@price,Purchinv=@piv,Purchdate=@pdate where Serial=@serial";
cmd1.Parameters.AddWithValue("@serial", comboBox5.SelectedItem.ToString());
cmd1.Parameters.AddWithValue("@mod", comboBox1.SelectedItem.ToString());
cmd1.Parameters.AddWithValue("@trim", comboBox2.SelectedItem.ToString());
cmd1.Parameters.AddWithValue("@color", comboBox3.SelectedItem.ToString());
cmd1.Parameters.AddWithValue("@year", comboBox4.SelectedItem.ToString());
cmd1.Parameters.AddWithValue("@price", textBox8.Text);
cmd1.Parameters.AddWithValue("@piv", textBox10.Text);
cmd1.Parameters.AddWithValue("@pdate", textBox9.Text);
cmd1.ExecuteNonQuery();
scon.Close();
UpdateDone ud = new UpdateDone();
ud.Show();
}
}
private void button3_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox1, "Please Enter Serial Number");
}
else if (textBox2.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox2, "Please Select Service Date");
}
else if (textBox3.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox3, "Please Enter Customer Name");
}
else if (textBox4.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox4, "Please Enter Parts Cost");
}
else if (textBox5.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox5, "Please Enter Labor Cost");
}
else if (textBox6.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox6, "Please Enter Total Price");
}
else if (richTextBox2.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(richTextBox2, "Please Enter Service Description");
}
else
{
errorProvider1.Clear();
conn();
double taxPercent = 1.13;
double partscost = double.Parse(textBox4.Text);
double laborcost = double.Parse(textBox5.Text);
double total = (partscost + laborcost) * taxPercent;
double tax = (partscost + laborcost) * (taxPercent - 1);
cmd.CommandText = " Update Service SET Serdate=@sd,Cname=@cn,Partscost=@pc,Laborcost=@lc,Tax=@tax,Totalcost=@total,Description=@desc where Serial=@serno";
cmd.Parameters.AddWithValue("@serno", textBox1.Text);
cmd.Parameters.AddWithValue("@sd", textBox2.Text);
cmd.Parameters.AddWithValue("@cn", textBox3.Text);
cmd.Parameters.AddWithValue("@pc", textBox4.Text);
cmd.Parameters.AddWithValue("@lc", textBox5.Text);
cmd.Parameters.AddWithValue("@tax", tax);
cmd.Parameters.AddWithValue("@total", total);
cmd.Parameters.AddWithValue("@desc", richTextBox2.Text);
cmd.ExecuteNonQuery();
//MessageBox.Show("Service Info updated!!!!");
UpdateDone ud = new UpdateDone();
ud.Show();
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
textBox4.Clear();
textBox5.Clear();
textBox6.Clear();
richTextBox2.Clear();
richTextBox1.Clear();
}
}
private void button3_Click(object sender, EventArgs e)
{
if (textBox2.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox2, "Please Enter Customer Name");
}
else if (textBox3.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox3, "Please Enter Salesman Name");
}
else if (textBox5.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox5, "Please Select Delivery Date");
}
else if (textBox6.Text == "")
{
errorProvider1.Clear();
errorProvider1.SetError(textBox6, "Please Enter Total Amount");
}
else
{
errorProvider1.Clear();
conn();
string insurance = "";
if (radioButton1.Checked)
{
insurance = "YES";
}
else
{
insurance = "NO";
}
cmd.CommandText = " Update Saleinv SET Salesman=@sman,Saledate=@sdate,Price=@price,Insurance=@ins where Cname=@cname";
cmd2.CommandText = " Update Car SET Price=@cprice where Serial=@serial";
cmd.Parameters.AddWithValue("@cname", textBox2.Text);
cmd.Parameters.AddWithValue("@sman", textBox3.Text);
cmd.Parameters.AddWithValue("@sdate", textBox5.Text);
cmd.Parameters.AddWithValue("@price", textBox6.Text);
cmd.Parameters.AddWithValue("@ins", insurance);
cmd2.Parameters.AddWithValue("@serial", textBox1.Text);
cmd2.Parameters.AddWithValue("@cprice", textBox6.Text);
cmd.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
UpdateDone ud = new UpdateDone();
ud.Show();
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
textBox5.Clear();
textBox6.Clear();
comboBox1.Text = "";
comboBox2.Text = "";
comboBox3.Text = "";
comboBox4.Text = "";
}
}
