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