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 void UpdateMaintenanceInfo(Maintenance maintenance) { try { _dbOp.DBConnect(); MySqlCommand cmd = _dbOp._dbConn.CreateCommand(); cmd.CommandText = @"UPDATE Maintenance SET MaintenanceID = @MaintenanceID,PlateNumber = @PlateNumber, PartID = @PartID, Status = @Status " + "WHERE MaintenanceID = @MaintenanceID"; cmd.Parameters.AddWithValue("@MaintenanceID", maintenance.MaintenanceID); cmd.Parameters.AddWithValue("@PlateNumber", maintenance.PlateNumber); cmd.Parameters.AddWithValue("@PartID", maintenance.PartID); cmd.Parameters.AddWithValue("@Status", maintenance.Status); cmd.ExecuteNonQuery(); MessageBox.Show("Maintenance Record has been updated!"); _dbOp.DBClose(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void doneB_Click(object sender, EventArgs e) { if (plateNumberCB.Text == "") { MessageBox.Show("Please choose a PLATE NUMBER", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (partCB.Text == "") { MessageBox.Show("Please choose a VEHICLE PART/n If VEHICLE PART does exist on the choices, please ADD a NEW PART.", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { _maintenanceID = _maintenance.CreateMaintenanceID(); _repairID = _repair.CreateRepairID(); _plateNumber = plateNumberCB.Text.Trim(); _partID = _part.RetrievePartID(partCB.Text.Trim()); _maintenance = new Maintenance(_maintenanceID, _plateNumber, _partID, _status); _maintenance.InsertMaintenance(_maintenance); plateNumberCB.Text = ""; partCB.Text = ""; } Close(); }