private void btnAdd_Click(object sender, EventArgs e) { List <MySqlParameter> paramlist = new List <MySqlParameter>(); paramlist.Clear(); paramlist.Add(new MySqlParameter("@vehicleId", GlobalLoginData.vehicleId)); paramlist.Add(new MySqlParameter("@customerName", txtName.Text)); paramlist.Add(new MySqlParameter("@customerTel", txtContactNo.Text)); paramlist.Add(new MySqlParameter("@toPurchaseDate", dateToPurchase.Value)); //paramlist.Add(new MySqlParameter("@email", txtEmail.Text)); paramlist.Add(new MySqlParameter("@amount", Convert.ToDouble(txtAmount.Text))); string query = "INSERT INTO tbloffers (vehicleID, customerFirstName, customerContact, offerDate, offerAmount) VALUES (@vehicleId, @customerName, @customerTel, @toPurchaseDate, @amount)"; int rowsAffedted = DatabaseHandler.insertOrDeleteRow(query, paramlist); if (rowsAffedted == 1) { try { MessageBox.Show("New Inquiry Added Successfully!"); //DatabaseHandler.populateGridViewWithBinding(ucSearchCars.queryOffer, ucSearchCars.datagridOffersVehicle); } catch (Exception) { MessageBox.Show("Inquiry Not Added!"); } } else { MessageBox.Show("Error Occured!"); } }
private void btnViewMore_Click(object sender, EventArgs e) { List <MySqlParameter> paramlist = new List <MySqlParameter>(); paramlist.Clear(); paramlist.Add(new MySqlParameter("@address", txtAddress.Text)); paramlist.Add(new MySqlParameter("@nic", txtName.Text)); paramlist.Add(new MySqlParameter("@customerName", txtName.Text)); paramlist.Add(new MySqlParameter("@customerTel", txtContactNumber.Text)); paramlist.Add(new MySqlParameter("@notes", txtSpecialNotes.Text)); string query = "INSERT INTO tblcustomer VALUES (@nic, @customerName, @address, 'SELLER', 'REG_COMPANY', @customerTel)"; int rowsAffedted = DatabaseHandler.insertOrDeleteRow(query, paramlist); if (rowsAffedted == 1) { try { ucVehicleDetails temp = new ucVehicleDetails(); if (!frmHomepage.Instance.pnlcontainer.Controls.Contains(ucVehicleDetails.Instance)) { frmHomepage.Instance.pnlcontainer.Controls.Add(ucVehicleDetails.Instance); ucVehicleDetails.Instance.Dock = DockStyle.Fill; ucVehicleDetails.Instance.BringToFront(); GlobalLoginData.customerId = txtName.Text; } else { ucVehicleDetails.Instance.BringToFront(); GlobalLoginData.customerId = txtName.Text; } } catch (Exception) { MessageBox.Show("Operation Unsuccessful!"); } } else { MessageBox.Show("Error Occured!" + rowsAffedted); } //this.Hide(); }
private void btnOk_Click(object sender, EventArgs e) { string vehicleModel = txtModel.Text; string vehicleMake = cmbMake.SelectedText; string inquirySpecialNotes = txtSpecialNotes.Text; string customerName = txtName.Text; string customerTel = txtPhoneNumber.Text; string customerAdd = txtEmail.Text; List <MySqlParameter> paramlist = new List <MySqlParameter>(); paramlist.Clear(); paramlist.Add(new MySqlParameter("@vehicleModel", vehicleModel)); paramlist.Add(new MySqlParameter("@vehicleMake", vehicleMake)); paramlist.Add(new MySqlParameter("@customerName", customerName)); paramlist.Add(new MySqlParameter("@specialNotes", inquirySpecialNotes)); paramlist.Add(new MySqlParameter("@customerContact", customerTel)); paramlist.Add(new MySqlParameter("@customerAddress", customerAdd)); string query = "INSERT INTO tblinquiries (customerName, customerContact, customerAddress, vehicleModel, vehicleMake, specialNotes) VALUES (@customerName, @customerContact, @customerAddress, @vehicleModel, @vehicleMake, @specialNotes)"; int rowsAffedted = DatabaseHandler.insertOrDeleteRow(query, paramlist); if (rowsAffedted == 1) { try { MessageBox.Show("New Inquiry Added Successfully!"); populateDataGrid(); } catch (Exception) { MessageBox.Show("Inquiry Not Added!"); } } else { MessageBox.Show("Error Occured!" + rowsAffedted); } }
private void btnViewMore_Click(object sender, EventArgs e) { MemoryStream ms1 = new MemoryStream(); MemoryStream ms2 = new MemoryStream(); MemoryStream ms3 = new MemoryStream(); MemoryStream ms4 = new MemoryStream(); MemoryStream ms5 = new MemoryStream(); MemoryStream ms6 = new MemoryStream(); MemoryStream ms7 = new MemoryStream(); MemoryStream ms8 = new MemoryStream(); MemoryStream ms9 = new MemoryStream(); //picBoxOne.Image.Save(ms1, picBoxOne.Image.RawFormat); //picBoxTwo.Image.Save(ms2, picBoxTwo.Image.RawFormat); //picBoxThree.Image.Save(ms3, picBoxThree.Image.RawFormat); //picBoxFour.Image.Save(ms4, picBoxFour.Image.RawFormat); //picBoxFive.Image.Save(ms5, picBoxFive.Image.RawFormat); //picBoxSix.Image.Save(ms6, picBoxSix.Image.RawFormat); //picBoxSeven.Image.Save(ms7, picBoxSeven.Image.RawFormat); //picBoxEight.Image.Save(ms8, picBoxEight.Image.RawFormat); //picBoxNine.Image.Save(ms9, picBoxNine.Image.RawFormat); byte[] img1 = ms1.ToArray(); byte[] img2 = ms2.ToArray(); byte[] img3 = ms3.ToArray(); byte[] img4 = ms4.ToArray(); byte[] img5 = ms5.ToArray(); byte[] img6 = ms6.ToArray(); byte[] img7 = ms7.ToArray(); byte[] img8 = ms8.ToArray(); byte[] img9 = ms9.ToArray(); List <MySqlParameter> paramlist = new List <MySqlParameter>(); string query = "INSERT INTO tblvehicle VALUES " + "(@RegNo, @customerNIC, @firstRegDate, @status, @chassisNo, @engineNo, @manufactureYear, @cc, @color, @mileage, @fuelType, @Make, @Model, @origin,@TransmissionGear, " + "@seatingCapacity, @ownerCount, @insuType, @insuCompanny, @insuDate, @lastservice, @serviceCount, @img1, @img2, @img3, @img4, @img5, @img6, @img7, @img8, @img9, @notes, @price)"; paramlist.Clear(); paramlist.Add(new MySqlParameter("@RegNo", txtVehicleRegNo.Text)); paramlist.Add(new MySqlParameter("@customerNIC", GlobalLoginData.customerId)); paramlist.Add(new MySqlParameter("@Make", txtMake.Text)); paramlist.Add(new MySqlParameter("@Model", cmbModel.SelectedText)); paramlist.Add(new MySqlParameter("@status", cmbVehicleStatus.SelectedText)); paramlist.Add(new MySqlParameter("@fuelType", cmbFuelType.SelectedText)); paramlist.Add(new MySqlParameter("@TransmissionGear", cmbTransmissionGear.SelectedText)); paramlist.Add(new MySqlParameter("@mileage", txtVehicleMileage.Text)); paramlist.Add(new MySqlParameter("@chassisNo", txtChassisNo.Text)); paramlist.Add(new MySqlParameter("@engineNo", txtEngineNo.Text)); paramlist.Add(new MySqlParameter("@cc", txtCylinderCapacity.Text)); paramlist.Add(new MySqlParameter("@color", txtColor.Text)); paramlist.Add(new MySqlParameter("@origin", cmbOriginCountry.SelectedText)); paramlist.Add(new MySqlParameter("@ownerCount", countPreviousOwner.Value)); paramlist.Add(new MySqlParameter("@seatingCapacity", countSeatingCapacity.Value)); paramlist.Add(new MySqlParameter("@serviceCount", countServicesDone.Value)); paramlist.Add(new MySqlParameter("@firstRegDate", dateFirstRegDate.Value)); paramlist.Add(new MySqlParameter("@insuType", txtInsuranceType.Text)); paramlist.Add(new MySqlParameter("@insuCompanny", txtInsuranceCompany.Text)); paramlist.Add(new MySqlParameter("@insuDate", dateInsurance.Value)); paramlist.Add(new MySqlParameter("@manufactureYear", yearManufacture.Value)); paramlist.Add(new MySqlParameter("@lastservice", dateLastService.Value)); paramlist.Add(new MySqlParameter("@notes", txtSpecialNotes.Text)); paramlist.Add(new MySqlParameter("@img1", null)); paramlist.Add(new MySqlParameter("@img2", null)); paramlist.Add(new MySqlParameter("@img3", null)); paramlist.Add(new MySqlParameter("@img4", null)); paramlist.Add(new MySqlParameter("@img5", null)); paramlist.Add(new MySqlParameter("@img6", null)); paramlist.Add(new MySqlParameter("@img7", null)); paramlist.Add(new MySqlParameter("@img8", null)); paramlist.Add(new MySqlParameter("@img9", null)); paramlist.Add(new MySqlParameter("@price", txtVehiclePrice.Text)); int rowsAffedted = DatabaseHandler.insertOrDeleteRow(query, paramlist); if (rowsAffedted >= 0) { try { if (!frmHomepage.Instance.pnlcontainer.Controls.Contains(ucSearchCars.Instance)) { frmHomepage.Instance.pnlcontainer.Controls.Add(ucSearchCars.Instance); ucSearchCars.Instance.Dock = DockStyle.Fill; ucSearchCars.Instance.BringToFront(); } else { ucSearchCars.Instance.BringToFront(); } } catch (Exception) { MessageBox.Show("Operation Unsuccessful!"); } } else { MessageBox.Show("Error Occured!"); } }