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 = ""; } }