private void txtSearchAllCarDetails_TextChanged(object sender, EventArgs e) { txtSearchAllCarDetails.CharacterCasing = CharacterCasing.Upper; 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.vehicleRegNo like '%" + txtSearchAllCarDetails.Text + "%' OR tblvehicle.vehicleModel like '%" + txtSearchAllCarDetails.Text + "%' OR tblvehicle.vehicleMake like '%" + txtSearchAllCarDetails.Text + "%'"; DatabaseHandler.populateGridViewWithBinding(query, dgridCarsAllCarDetails); }
private void txtModel_TextChanged(object sender, EventArgs e) { UppercaseCharacters(txtModel); string selectStatement = "SELECT customerName as 'Customer Name', customerAddress as 'Address', customerContact as 'Contact', vehicleModel as 'Model', vehicleMake as 'Make', specialNotes as 'Notes' FROM tblinquiries WHERE vehicleModel like '%" + txtModel.Text + "%'"; DatabaseHandler.populateGridViewWithBinding(selectStatement, dgridAllInquiries); }
private void ucViewSelectedCar_Load(object sender, EventArgs e) { string queryOffer = "SELECT customerFirstName as 'Name', offerAmount as 'Amount', customerContact as 'Contact', offerDate as 'To Purchase Date', offerSpecialNote as 'Notes' from tbloffers where vehicleId = '" + GlobalLoginData.vehicleId + "'"; DatabaseHandler.populateGridViewWithBinding(queryOffer, datagridOffersVehicle); string queryVehicle = "select * from tblvehicle where tblvehicle.vehicleID = vehicleId"; txtPriceViewVehicle.Text = DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "price"); txtMakeViewVehicle.Text = DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleMake"); txtMadelViewVehicle.SelectedText = DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleModel"); txtStatusViewVehicle.SelectedText = DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleStatus"); txtYearOfManufactureViewVehicle.Text = DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleManufacturedDate"); //byte[] img1 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleImageOne")); //byte[] img2 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleImageTwo")); //byte[] img3 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleImageThree")); //byte[] img4 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleImageFour")); //byte[] img5 = Encoding.ASCII.GetBytes(DatabaseHandler.returnOneValueWithoutParams(queryVehicle, "vehicleImageFive")); //MemoryStream ms = new MemoryStream(img1); //picBoxViewCar01.Image = Image.FromStream(ms); //picBoxViewCar02.Image = Image.FromStream(new MemoryStream(img2)); //picBoxViewCar03.Image = Image.FromStream(new MemoryStream(img3)); //picBoxViewCar04.Image = Image.FromStream(new MemoryStream(img4)); //picBoxViewCar05.Image = Image.FromStream(new MemoryStream(img5)); }
private void cmbMake_SelectedIndexChanged(object sender, EventArgs e) { string selectStatement = "SELECT customerName as 'Customer Name', customerAddress as 'Address', customerContact as 'Contact', vehicleModel as 'Model', vehicleMake as 'Make', specialNotes as 'Notes' FROM tblinquiries WHERE vehicleMake like '%" + cmbMake.SelectedText + "%'"; DatabaseHandler.populateGridViewWithBinding(selectStatement, dgridAllInquiries); }
private void populateDataGrid() { string query = "SELECT customerName as 'Customer Name', customerAddress as 'Address', customerContact as 'Contact', vehicleModel as 'Model', vehicleMake as 'Make', specialNotes as 'Notes' from tblinquiries"; DatabaseHandler.populateGridViewWithBinding(query, dgridAllInquiries); }
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); }