private void button1_Click(object sender, EventArgs e) { DbCars db = new DbCars(); WindowsFormsApplication1.Car w = new WindowsFormsApplication1.Car(); try { w.Id = int.Parse(textBox1.Text); if (db.CarExist(w.Id) == true) { DialogResult dialogResult = MessageBox.Show("Are You Sure To Delete Car?", "Delete", MessageBoxButtons.YesNoCancel); if (dialogResult == DialogResult.Yes) { db.DeleteCar(w); MessageBox.Show("Car was deleted Successfully"); } } else { MessageBox.Show("Car with similar ID was not found , try again", "Error"); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }
private void button3_Click(object sender, EventArgs e) { WindowsFormsApplication1.Car w = new WindowsFormsApplication1.Car(); DbCars db = new DbCars(); DataSet ds = new DataSet(); try { w.Id = int.Parse(textBox1.Text); if (db.CarExist(w.Id) == true) { ds = db.getCarInfo(w); textBox1.Text = ds.Tables[0].Rows[0]["ProductCode"].ToString(); textBox3.Text = ds.Tables[0].Rows[0]["Kind"].ToString(); textBox2.Text = ds.Tables[0].Rows[0]["Color"].ToString(); textBox4.Text = ds.Tables[0].Rows[0]["ClientId"].ToString(); textBox5.Text = ds.Tables[0].Rows[0]["History"].ToString(); } else { textBox1.Text = "Car not found "; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }