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);
}
