private void viewUser_Load(object sender, EventArgs e) { string query = "select * from tblvehicle where tblvehicle.vehicleID = '" + GlobalLoginData.vehicleId + "'"; int rows = DatabaseHandler.returnRowCountWithoutParams(query); if (rows == 1) { btnEdit.Show(); txtVehicleRegNo.Text = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleRegNo"); txtMake.Text = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleMake"); cmbModel.SelectedText = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleModel"); cmbVehicleStatus.SelectedText = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleStatus"); cmbFuelType.SelectedText = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleFuelType"); cmbTransmissionGear.SelectedText = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleTransmissionGear"); txtChassisNo.Text = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleChasisNo"); txtEngineNo.Text = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleEngineNo"); txtCylinderCapacity.Text = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleCylinderCapacity"); txtColor.Text = DatabaseHandler.returnOneValueWithoutParams(query, "vehicleColor"); cmbOriginCountry.SelectedText = DatabaseHandler.returnOneValueWithoutParams(query, "countryOfOrigin"); countPreviousOwner.Value = Convert.ToInt16(DatabaseHandler.returnOneValueWithoutParams(query, "previousOwnerCount")); countSeatingCapacity.Value = Convert.ToInt16(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleSeatingCapacity")); countServicesDone.Value = Convert.ToInt16(DatabaseHandler.returnOneValueWithoutParams(query, "noOfServicesDone")); dateFirstRegDate.Value = Convert.ToDateTime(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleRegDate")); dateInsurance.Value = Convert.ToDateTime(DatabaseHandler.returnOneValueWithoutParams(query, "insuranceDate")); yearManufacture.Value = Convert.ToDateTime(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleManufacturedDate")); dateLastService.Value = Convert.ToDateTime(DatabaseHandler.returnOneValueWithoutParams(query, "lastServiceDate")); txtInsuranceType.Text = DatabaseHandler.returnOneValueWithoutParams(query, "insuranceType"); txtInsuranceCompany.Text = DatabaseHandler.returnOneValueWithoutParams(query, "insuranceCompany"); txtSpecialNotes.Text = DatabaseHandler.returnOneValueWithoutParams(query, "specialNotes"); txtVehiclePrice.Text = DatabaseHandler.returnOneValueWithoutParams(query, "price"); //byte[] img = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageOne")); //byte[] img2 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageTwo")); //byte[] img3 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageThree")); //byte[] img4 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageFour")); //byte[] img5 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageFive")); //byte[] img6 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageSix")); //byte[] img7 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageSeven")); //byte[] img8 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageEight")); //byte[] img9 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(query, "vehicleImageNine")); //picBoxOne.Image = Image.FromStream(new MemoryStream(img)); //picBoxTwo.Image = Image.FromStream(new MemoryStream(img2)); //picBoxThree.Image = Image.FromStream(new MemoryStream(img3)); //picBoxFour.Image = Image.FromStream(new MemoryStream(img4)); //picBoxFive.Image = Image.FromStream(new MemoryStream(img5)); //picBoxSix.Image = Image.FromStream(new MemoryStream(img6)); //picBoxSeven.Image = Image.FromStream(new MemoryStream(img7)); //picBoxEight.Image = Image.FromStream(new MemoryStream(img8)); //picBoxNine.Image = Image.FromStream(new MemoryStream(img9)); txtVehicleRegNo.ReadOnly = true; txtMake.ReadOnly = true; cmbModel.Enabled = false; cmbVehicleStatus.Enabled = false; cmbFuelType.Enabled = false; cmbTransmissionGear.Enabled = false; txtChassisNo.ReadOnly = true; txtCylinderCapacity.ReadOnly = true; txtColor.ReadOnly = true; cmbOriginCountry.Enabled = false; countPreviousOwner.ReadOnly = true; countSeatingCapacity.ReadOnly = true; countServicesDone.ReadOnly = true; dateFirstRegDate.Enabled = false; dateInsurance.Enabled = false; yearManufacture.Enabled = false; dateLastService.Enabled = false; txtInsuranceType.ReadOnly = true; txtInsuranceCompany.ReadOnly = true; txtSpecialNotes.ReadOnly = true; picBoxOne.Enabled = false; picBoxTwo.Enabled = false; picBoxThree.Enabled = false; picBoxFour.Enabled = false; picBoxFive.Enabled = false; picBoxSix.Enabled = false; picBoxSeven.Enabled = false; picBoxEight.Enabled = false; picBoxNine.Enabled = false; txtVehiclePrice.ReadOnly = true; } }
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!"); } }
private void ucInsuranceLuxary_Load(object sender, EventArgs e) { string query = "SELECT customerName as 'Customer Name', vehicleModel as 'Model', vehicleMake as 'Make' from tblinquiries"; DatabaseHandler.populateGridViewWithBinding(query, dgridNotifications); }
private void cmbMakeAllCarDetails_SelectedIndexChanged(object sender, EventArgs e) { string query = "SELECT vehicleStatus as 'Status', vehicleRegNo as 'Registartion No', vehicleModel as 'Model', vehicleMake as 'Make', vehicleMileage as 'Mileage', vehicleManufacturedDate as 'Maufactured Year' from tblvehicle WHERE tblvehicle.vehicleModel like '%" + cmbModel.SelectedText + "%'"; DatabaseHandler.populateGridViewWithBinding(query, dgridCarsAllCarDetails); }
private void dateTimePickerYearofManufactureAllCarDetails_ValueChanged(object sender, EventArgs e) { string query = "SELECT vehicleStatus as 'Status', vehicleRegNo as 'Registartion No', vehicleModel as 'Model', vehicleMake as 'Make', vehicleMileage as 'Mileage', vehicleManufacturedDate as 'Maufactured Year' from tblvehicle WHERE tblvehicle.vehicleManufacturedDate like '%" + dateManufactured.Value + "%'"; DatabaseHandler.populateGridViewWithBinding(query, dgridCarsAllCarDetails); }
private void ucSearchCars_Load(object sender, EventArgs e) { string query = "SELECT vehicleID as 'ID', vehicleStatus as 'Status', vehicleRegNo as 'Registartion No', vehicleModel as 'Model', vehicleMake as 'Make', vehicleMileage as 'Mileage', vehicleManufacturedDate as 'Maufactured Year' from tblvehicle"; DatabaseHandler.populateGridViewWithBinding(query, dgridCarsAllCarDetails); }