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); w.Kind = textBox3.Text; w.Color = textBox2.Text; w.ClientId = int.Parse(textBox4.Text); w.History = int.Parse(textBox5.Text); } catch (Exception exception) { MessageBox.Show("Invalid parameters", "Error"); return; } DbClients cdb = new DbClients(); if (!cdb.ClientExist(w.ClientId)) { MessageBox.Show("Invalid Client", "Error"); return; } db.insertCar(w); MessageBox.Show("add Car Success"); }
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"); } }
void updateBoxes() { DbClients dbc = new DbClients(); int ClientId = int.Parse(comboBox2.Text); textBox6.Text = (string)dbc.GetClientInfo(ClientId).Tables[0].Rows[0]["FirstName"]; //textBox6.Text = dbc.GetClientInfo(2).Tables[0].Columns[0].Table.ToString(); //textBox7.Text=dbc.GetClientInfo(2).Tables[0].Columns[0].Table.ToString(); DbCars dbca = new DbCars(); if (comboBox4.Text != "") { int carId = int.Parse(comboBox4.Text); textBox4.Text = (string)dbca.getCarInfo(carId).Tables[0].Rows[0]["Kind"]; } DbWorker dbw = new DbWorker(); if (comboBox3.Text != "") { int wId = int.Parse(comboBox3.Text); textBox7.Text = (string)dbw.getWorkerInfo(wId).Tables[0].Rows[0]["FirstName"]; } }
private void button1_Click(object sender, EventArgs e) { try { WindowsFormsApplication1.Car w = new WindowsFormsApplication1.Car(); DbCars db = new DbCars(); w.Id = int.Parse(textBox1.Text); w.Kind = textBox3.Text; w.Color = textBox2.Text; w.ClientId = int.Parse(textBox4.Text); w.History = int.Parse(textBox5.Text); DbClients cdb = new DbClients(); if (!cdb.ClientExist(w.ClientId)) { MessageBox.Show("Client Does not exist"); return; } db.UpdateCar(w); MessageBox.Show("Successfully updated Car"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
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); } }
private void AddTreatment_Load(object sender, EventArgs e) { DbKindTreatments db = new DbKindTreatments(); DataSet ds = db.GetAllKindTreatments(); DataSet ds2 = ds.Clone(); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.AllowUserToAddRows = false; dataGridView2.AllowUserToAddRows = false; foreach (DataGridViewColumn col in dataGridView1.Columns) { dataGridView2.Columns.Add((DataGridViewColumn)col.Clone()); } DbClients dbc = new DbClients(); comboBox2.DisplayMember = "ClientId"; comboBox2.ValueMember = "ClientId"; comboBox2.DataSource = dbc.GetAllClients().Tables[0].Columns[0].Table; comboBox3.DisplayMember = "WorkerId"; comboBox3.ValueMember = "WorkerId"; DbWorker dbw = new DbWorker(); comboBox3.DataSource = dbw.GetAllWorkers().Tables[0].Columns[0].Table; comboBox4.DisplayMember = "ProductCode"; comboBox4.ValueMember = "ProductCode"; DbCars dbca = new DbCars(); comboBox4.DataSource = dbca.GetAllCars().Tables[0].Columns[0].Table; textBox9.Text = "0"; }
private void button1_Click(object sender, EventArgs e) { DbCars db = new DbCars(); try { WindowsFormsApplication1.Car w = new WindowsFormsApplication1.Car(); w.Id = int.Parse(textBox1.Text); if (comboBox1.SelectedIndex == 0) { dataGridView1.DataSource = db.SearchCarByProductCode(w.Id).Tables[0]; } else { dataGridView1.DataSource = db.SearchCarByClientId(w.Id).Tables[0]; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }
private void button1_Click(object sender, EventArgs e) { DbCars db = new DbCars(); dataGridView1.DataSource = db.GetAllCars().Tables[0]; }