private void payB_Click(object sender, EventArgs e) { repairSupplierID = _supplier.RetrieveSupplierID(repairSupplierCB.Text); repairDate = repairDateDTP.Value; repairInvoiceNumber = repairInvoiceNumberTB.Text; repairAmount = double.Parse(repairAmountTB.Text); typeOfRepair = typeOfRepairCB.Text; try { foreach (RepairDetail repairDetail in _repairDetails) { _repairDetail.InsertRepairDetail(repairDetail); } plateNumber = plateNumberCB.Text.Trim(); repairDate = repairDateDTP.Value; typeOfRepair = typeOfRepairCB.Text.Trim(); partID = _part.RetrievePartID(partCB.Text); maintenanceID = _maintenance.RetrieveMaintenanceID(plateNumber, partID); repairSupplierID = _supplier.RetrieveSupplierID(repairSupplierCB.Text.Trim()); repairInvoiceNumber = repairInvoiceNumberTB.Text.Trim(); repairAmount = double.Parse(repairAmountTB.Text.Trim()); status = statusCB.Text.Trim(); _repair = new Repair(repairID, maintenanceID, repairDate, typeOfRepair, repairInvoiceNumber, repairSupplierID, repairAmount); _repair.InsertRepair(_repair); _maintenance = new Maintenance(maintenanceID, plateNumber, partID, status); _maintenance.UpdateMaintenanceInfo(_maintenance); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } NewPaymentForm newPaymentForm = new NewPaymentForm(); newPaymentForm.ShowDialog(); }
public List <Repair> RetrieveRepairIDList(int repairID) { List <Repair> repairList = new List <Repair>(); try { _dbOp.DBConnect(); MySqlCommand cmd = _dbOp._dbConn.CreateCommand(); cmd.CommandText = "SELECT * FROM Repair " + "WHERE RepairID = @RepairID"; cmd.Parameters.AddWithValue("@RepairID", repairID); MySqlDataReader reader = cmd.ExecuteReader(); Repair temp = new Repair(); while (reader.Read()) { RepairID = (int)reader.GetValue(0); MaintenanceID = (int)reader.GetValue(1); RepairDate = (DateTime)reader.GetValue(2); TypeOfRepair = (string)reader.GetValue(3); SupplierID = (int)reader.GetValue(4); InvoiceNumber = (string)reader.GetValue(5); Amount = (double)reader.GetValue(6); temp = new Repair(RepairID, MaintenanceID, RepairDate, TypeOfRepair, InvoiceNumber, SupplierID, Amount); repairList.Add(temp); } reader.Close(); _dbOp.DBClose(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } return(repairList); }
private void repairEditB_Click(object sender, EventArgs e) { Button bt = (Button)sender; switch (bt.Text) { case "Edit": repairEditB.Text = "Save"; EnableRepair(); break; case "Save": if (_repairDate != repairDateDTP.Value || _typeOfRepair != repairTypeOfRepairTB.Text || _repairSupplier != repairSupplierCB.Text || _repairAmount != double.Parse(repairAmountTB.Text)) { _repair = new Repair(int.Parse(_repair.RepairID.ToString()), _repair.MaintenanceID, repairDateDTP.Value, repairTypeOfRepairTB.Text, repairInvoiceNumberCB.Text, _supplier.RetrieveSupplierID(repairSupplierCB.Text), double.Parse(repairAmountTB.Text)); } _repair.UpdateRepairInfo(_repair); DisableRepair(); repairEditB.Text = "Edit"; LoadRegistration(_plateNumber); LoadInsurance(_plateNumber); LoadRepair(_plateNumber); Loadfuel(_plateNumber); break; } }