private void btnAdd_Click(object sender, EventArgs e) { try { dbconnection.Open(); string query = "select Car_License_ID from car_license where Car_ID=" + CarId + ""; MySqlCommand com = new MySqlCommand(query, dbconnection); if (com.ExecuteScalar() == null) { if (txtCarNumber.Text != "") { string qeury = "insert into car_license (Car_ID,Car_License_Number,Car_Shaza_Number,Car_Model,Car_Company,Start_License_Date,End_License_Date)values(@Car_ID,@Car_License_Number,@Car_Shaza_Number,@Car_Model,@Car_Company,@Start_License_Date,@End_License_Date)"; com = new MySqlCommand(qeury, dbconnection); com.Parameters.Add("@Car_ID", MySqlDbType.Int16); com.Parameters["@Car_ID"].Value = CarId; com.Parameters.Add("@Car_License_Number", MySqlDbType.VarChar, 255); com.Parameters["@Car_License_Number"].Value = txtLicenseNumber.Text; com.Parameters.Add("@Car_Shaza_Number", MySqlDbType.VarChar, 255); com.Parameters["@Car_Shaza_Number"].Value = txtShaza.Text; com.Parameters.Add("@Car_Model", MySqlDbType.VarChar, 255); com.Parameters["@Car_Model"].Value = txtModel.Text; com.Parameters.Add("@Car_Company", MySqlDbType.VarChar); com.Parameters["@Car_Company"].Value = txtCarCampany.Text; com.Parameters.Add("@Start_License_Date", MySqlDbType.Date); com.Parameters["@Start_License_Date"].Value = dateTimePicker1.Value.Date; com.Parameters.Add("@End_License_Date", MySqlDbType.Date); com.Parameters["@End_License_Date"].Value = dateTimePicker2.Value.Date; com.ExecuteNonQuery(); MessageBox.Show("add success"); clear(); XtraTabPage xtraTabPage = getTabPage("تسجيل رخصة العربية"); xtraTabPage.ImageOptions.Image = null; carsMainForm.displayNotification(dbconnection); } else { MessageBox.Show("enter Car Number"); } } else { MessageBox.Show("This Car already exist"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } dbconnection.Close(); }
private void btnUpdate_Click(object sender, EventArgs e) { try { dbconnection.Open(); if (txtCarNumber.Text != "") { string qeury = "update car_license set Car_License_Number=@Car_License_Number,Car_Shaza_Number=@Car_Shaza_Number,Car_Model=@Car_Model,Car_Company=@Car_Company,Start_License_Date=@Start_License_Date,End_License_Date=@End_License_Date where Car_ID=" + CarId; MySqlCommand com = new MySqlCommand(qeury, dbconnection); com.Parameters.Add("@Car_License_Number", MySqlDbType.VarChar, 255); com.Parameters["@Car_License_Number"].Value = txtLicenseNumber.Text; com.Parameters.Add("@Car_Shaza_Number", MySqlDbType.VarChar, 255); com.Parameters["@Car_Shaza_Number"].Value = txtShaza.Text; com.Parameters.Add("@Car_Model", MySqlDbType.VarChar, 255); com.Parameters["@Car_Model"].Value = txtModel.Text; com.Parameters.Add("@Car_Company", MySqlDbType.VarChar); com.Parameters["@Car_Company"].Value = txtCarCampany.Text; com.Parameters.Add("@Start_License_Date", MySqlDbType.Date); com.Parameters["@Start_License_Date"].Value = dateTimePicker1.Value.Date; com.Parameters.Add("@End_License_Date", MySqlDbType.Date); com.Parameters["@End_License_Date"].Value = dateTimePicker2.Value.Date; com.ExecuteNonQuery(); MessageBox.Show("update success"); carsMainForm.displayNotification(dbconnection); XtraTabPage xtraTabPage = getTabPage("تعديل رخصة العربية"); xtraTabPage.ImageOptions.Image = null; } else { MessageBox.Show("enter Car Number"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } dbconnection.Close(); }
private void btnAdd_Click(object sender, EventArgs e) { try { dbconnection.Open(); if (comSpareParts.Text != "") { string qeury = "insert into car_sparepart (Car_ID,SparePart_ID,Car_SparePart_Info,Car_SpareDate)values(@Car_ID,@SparePart_ID,@Car_SparePart_Info,@Car_SpareDate)"; MySqlCommand com = new MySqlCommand(qeury, dbconnection); com.Parameters.Add("@Car_ID", MySqlDbType.Int32); com.Parameters["@Car_ID"].Value = CarId; com.Parameters.Add("@SparePart_ID", MySqlDbType.Int16); com.Parameters["@SparePart_ID"].Value = comSpareParts.SelectedValue; com.Parameters.Add("@Car_SparePart_Info", MySqlDbType.VarChar, 255); com.Parameters["@Car_SparePart_Info"].Value = txtInfo.Text; com.Parameters.Add("@Car_SpareDate", MySqlDbType.Date); com.Parameters["@Car_SpareDate"].Value = dateTimePicker1.Value.Date; com.ExecuteNonQuery(); displayCarSpareParts(); comSpareParts.Focus(); carsMainForm.displayNotification(dbconnection); } else { MessageBox.Show("enter Name"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } dbconnection.Close(); }