/*public void LoadRepairStatement()
* {
* _statements = _statement.RetrieveRepairStatement(_conditionString1);
* _totalRepair = 0;
* foreach (Statement statement in _statements)
* {
* _supplierID = statement.SupplierID;
* _repairID = statement.ID;
* _invoiceNumber = statement.InvoiceNumber;
* _type = statement.Type;
* _repairAmount = statement.AmountDue;
* _totalRepair += statement.AmountDue;
*
* ListViewItem searchStatement = new ListViewItem(_supplierID.ToString());
* searchStatement.SubItems.Add(_repairID.ToString());
* searchStatement.SubItems.Add(_invoiceNumber);
* searchStatement.SubItems.Add(_type);
* searchStatement.SubItems.Add(_repairAmount.ToString("N2"));
*
* statementLV.Items.Add(searchStatement);
* }
* }
* public void LoadRepairDetailStatement()
* {
* _statements = _statement.RetrieveRepairDetailStatement(_conditionString1);
* _totalPart = 0;
* foreach (Statement statement in _statements)
* {
* _supplierID = statement.SupplierID;
* _partID = statement.ID;
* _invoiceNumber = statement.InvoiceNumber;
* _type = statement.Type;
* _repairAmount = statement.AmountDue;
* _totalPart += statement.AmountDue;
*
* ListViewItem searchStatement = new ListViewItem(_supplierID.ToString());
* searchStatement.SubItems.Add(_partID.ToString());
* searchStatement.SubItems.Add(_invoiceNumber);
* searchStatement.SubItems.Add(_type);
* searchStatement.SubItems.Add(_repairAmount.ToString("N2"));
*
* statementLV.Items.Add(searchStatement);
* }
* }*/
#endregion
#region Other Methods
private void ShowData(string plateNumber)
{
LoadRegistration(plateNumber);
LoadInsurance(plateNumber);
LoadRepair(plateNumber);
Loadfuel(plateNumber);
_vehicle = _vehicle.RetrieveVehicleInfo(plateNumber);
plateNumberTB.Text = _vehicle.PlateNumber;
crNumberTB.Text = _vehicle.CRNumber;
crDateDTP.Value = _vehicle.CRDate;
listingCB.Text = _vehicle.Listing;
brandCB.Text = _vehicle.Brand;
categoryCB.Text = _vehicle.Category;
issuedToTB.Text = _vehicle.IssuedTo;
_registration = _registration.RetrieveRegistrationInfo(plateNumber);
registrationPlateNumberTB.Text = _registration.PlateNumber;
registeredNameTB.Text = registrationRegisteredNameTB.Text = _registration.RegisteredName;
registrationORNumberTB.Text = _registration.ORNumber;
if (_registration.Renewal.ToString() != "01/01/0001 12:00:00 AM")
{
registrationRenewalDTP.Value = _registration.Renewal;
}
else
{
registrationRenewalDTP.Value = DateTime.Now;
}
registrationAmountTB.Text = _registration.Amount.ToString("N2");
remarksRTB.Text = _registration.Remarks;
_insurance = _insurance.RetrieveInsuranceInfo(plateNumber);
insurancePlateNumberTB.Text = plateNumber;
insuranceRegisteredNameTB.Text = _registration.RegisteredName;
insuranceCompanyTB.Text = _insurance.Company;
// insuranceDurationFromDTP.Value = _insurance.DurationFrom;
// insuranceDurationToDTP.Value = _insurance.DurationTo;
//insuranceRenewalDTP.Value = _insurance.Renewal;
insuranceAmountTB.Text = _insurance.Amount.ToString("N2");
_repairs = _repair.RetrieveRepairList(plateNumber);
repairPlateNumberTB.Text = plateNumber; //this
//repairDateDTP.Value = _repair.RepairDate;
repairTypeOfRepairTB.Text = _repair.TypeOfRepair;
repairSupplierCB.Text = _supplier.RetrieveSupplierInfo(_repair.SupplierID).SupplierName;
repairInvoiceNumberCB.Text = _repair.InvoiceNumber;
repairAmountTB.Text = _repair.Amount.ToString("N2");
_fuel = _fuel.RetrieveFuelInfo(plateNumber);
fuelPlateNumberTB.Text = plateNumber; //this
fuelVehicleTB.Text = _vehicle.RetrieveVehicleInfo(_fuel.PlateNumber).Category;
// fuelDateDTP.Value = _fuel.FuelDate;
fuelTypeOfFuelCB.Text = _fuel.TypeOfFuel;
fuelSupplierTB.Text = _supplier.RetrieveSupplierInfo(_fuel.SupplierID).SupplierName;
fuelAmountTB.Text = _fuel.Amount.ToString("N2");
}
private void ShowData(string plateNumber)
{
_insurance = _insurance.RetrieveInsuranceInfo(plateNumber);
insuranceIDTB.Text = _insurance.InsuranceID.ToString();
plateNumberCB.Text = _insurance.PlateNumber;
registeredNameTB.Text = _registration.RegisteredName;
companyCB.Text = _insurance.Company;
durationFromDTP.Value = _insurance.DurationFrom;
durationToDTP.Value = _insurance.DurationTo;
renewalDTP.Value = _insurance.Renewal;
amountTB.Text = _insurance.Amount.ToString("N2");
}
private void saveB_Click(object sender, EventArgs e)
{
if (plateNumberCB.Text == "")
{
MessageBox.Show("Please choose a PLATE NUMBER", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (registeredNameTB.Text == "")
{
MessageBox.Show("Please enter the REGISTERED NAME", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (companyCB.Text == "")
{
MessageBox.Show("Please choose a COMPANY", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (amountTB.Text == "")
{
MessageBox.Show("Please insert an AMOUNT", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (renewalDTP.Value == DateTime.Now)
{
MessageBox.Show("Please insert the RENEWAL DATE", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
try
{
insuranceID = int.Parse(insuranceIDTB.Text.Trim());
plateNumber = plateNumberCB.Text.Trim();
registeredName = registeredNameTB.Text.Trim();
company = companyCB.Text.Trim();
durationFrom = durationFromDTP.Value;
durationTo = durationToDTP.Value;
amount = double.Parse(amountTB.Text.Trim());
renewal = renewalDTP.Value;
_insurance = new Insurance(insuranceID,
plateNumber,
company,
durationFrom,
durationTo,
renewal,
amount);
_insurance.InsertInsurance(_insurance);
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void insuranceEditB_Click(object sender, EventArgs e)
{
if (insuranceEditB.Text == "Edit")
{
insuranceEditB.Text = "Save";
EnableInsurance();
}
else if (insuranceEditB.Text == "Save")
{
if (_insuranceRegisteredName != insuranceRegisteredNameTB.Text ||
_insuranceCompany != insuranceCompanyTB.Text ||
_insuranceDurationFrom != insuranceDurationFromDTP.Value ||
_insuranceDurationTo != insuranceDurationToDTP.Value ||
_insuranceRenewal != insuranceDurationToDTP.Value ||
_insuranceRenewal != insuranceRenewalDTP.Value ||
_insuranceAmount != double.Parse(insuranceAmountTB.Text))
{
_insurance = new Insurance(_insurance.InsuranceID,
_insurance.PlateNumber,
insuranceCompanyTB.Text,
insuranceDurationFromDTP.Value,
insuranceDurationToDTP.Value,
insuranceRenewalDTP.Value,
double.Parse(insuranceAmountTB.Text.Trim()));
}
_insurance.UpdateInsuranceInfo(_insurance);
DisableInsurance();
insuranceEditB.Text = "Edit";
LoadRegistration(_insurance.PlateNumber);
LoadInsurance(_insurance.PlateNumber);
LoadRepair(_insurance.PlateNumber);
Loadfuel(_insurance.PlateNumber);
}
}
public List <Insurance> RetrieveInsuranceList(string plateNumber)
{
List <Insurance> insuranceList = new List <Insurance>();
try
{
_dbOp.DBConnect();
MySqlCommand cmd = _dbOp._dbConn.CreateCommand();
cmd.CommandText = @"SELECT * FROM Insurance " + "WHERE PlateNumber = @PlateNumber";
cmd.Parameters.AddWithValue("@PlateNumber", plateNumber);
MySqlDataReader reader = cmd.ExecuteReader();
Insurance temp = new Insurance();
while (reader.Read())
{
InsuranceID = (int)reader.GetValue(0);
PlateNumber = (string)reader.GetValue(1);
Company = (string)reader.GetValue(2);
DurationFrom = (DateTime)reader.GetValue(3);
DurationTo = (DateTime)reader.GetValue(4);
Renewal = (DateTime)reader.GetValue(5);
Amount = (double)reader.GetValue(6);
temp = new Insurance(InsuranceID, PlateNumber, Company, DurationFrom, DurationTo, Renewal, Amount);
insuranceList.Add(temp);
}
reader.Close();
_dbOp.DBClose();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return(insuranceList);
}
