private void RepairEditB_Click(object sender, EventArgs e)
{
Button bt = (Button)sender;
switch (bt.Text)
{
case "Edit":
EnableRepair();
break;
case "Save":
if (_partDescription != partCB.Text ||
_purchasedDate != purchaseDateDTP.Value ||
_supplierName != supplierCB.Text ||
_invoiceNumber != invoiceNumberTB.Text ||
_amount != int.Parse(amountTB.Text))
{
_repairdetail = new RepairDetail(_repairdetail.RepairID, _repairdetail.PartID, purchaseDateDTP.Value, int.Parse(amountTB.Text), invoiceNumberTB.Text, _supplier.RetrieveSupplierID(supplierCB.Text));
}
_repairdetail.UpdateRepairDetailInfo(_repairdetail);
LoadDetails();
DisableRepair();
break;
}
}
private void AddItem()
{
ListViewItem partLVI = new ListViewItem();
partSupplierID = _supplier.RetrieveSupplierID(partSupplierCB.Text);
partID = _part.RetrievePartID(partCB.Text);
purchasedDate = partDateDTP.Value;
partInvoiceNumber = partInvoiceNumberTB.Text;
partDescription = partCB.Text;
partAmount = double.Parse(partAmountTB.Text);
_repairDetail = new RepairDetail(repairID, partID, purchasedDate, partAmount, partInvoiceNumber, partSupplierID);
_repairDetails.Add(_repairDetail);
partLVI.SubItems.Add(partSupplierCB.Text);
partLVI.SubItems.Add(partDateDTP.Value.ToShortDateString());
partLVI.SubItems.Add(partInvoiceNumberTB.Text);
partLVI.SubItems.Add(partCB.Text);
partLVI.SubItems.Add(partAmountTB.Text);
partLVI.SubItems.Add(statusCB.Text);
partListLV.Items.Add(partLVI);
this.Clear();
}
public RepairDetail RetrieveDetailInfo(int repairID)
{
RepairDetail temp = new RepairDetail();
try
{
_dbOp.DBConnect();
MySqlCommand cmd = _dbOp._dbConn.CreateCommand();
cmd.CommandText = @"SELECT * FROM RepairDetail " + "WHERE RepairID = @RepairID";
cmd.Parameters.AddWithValue("@RepairID", repairID);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
RepairID = (int)reader.GetValue(0);
PartID = (int)reader.GetValue(1);
PurchasedDate = (DateTime)reader.GetValue(2);
Amount = (double)reader.GetValue(3);
InvoiceNumber = (string)reader.GetValue(4);
SupplierID = (int)reader.GetValue(5);
temp = new RepairDetail(RepairID, PartID, PurchasedDate, Amount, InvoiceNumber, SupplierID);
}
reader.Close();
_dbOp.DBClose();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return(temp);
}
public void InsertRepairDetail(RepairDetail repairDetail)
{
try
{
_dbOp.DBConnect();
MySqlCommand cmd = _dbOp._dbConn.CreateCommand();
cmd.CommandText = @"INSERT INTO RepairDetail(RepairID,PartID,PurchasedDate,Amount,InvoiceNumber,SupplierID)
VALUES(@RepairID,@PartID,@PurchasedDate,@Amount,@InvoiceNumber,@SupplierID)";
cmd.Parameters.AddWithValue("@RepairID", repairDetail.RepairID);
cmd.Parameters.AddWithValue("@PartID", repairDetail.PartID);
cmd.Parameters.AddWithValue("@PurchasedDate", repairDetail.PurchasedDate);
cmd.Parameters.AddWithValue("@Amount", repairDetail.Amount);
cmd.Parameters.AddWithValue("@InvoiceNumber", repairDetail.InvoiceNumber);
cmd.Parameters.AddWithValue("@SupplierID", repairDetail.SupplierID);
cmd.ExecuteNonQuery();
_dbOp.DBClose();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public void UpdateRepairDetailInfo(RepairDetail repairDetail)
{
try
{
_dbOp.DBConnect();
MySqlCommand cmd = _dbOp._dbConn.CreateCommand();
cmd.CommandText = @"UPDATE RepairDetail SET RepairID = @RepairID, PartID = @PartID,Amount = @Amount,InvoiceNumber = @InvoiceNumber,SupplierID = @SupplierID " + "WHERE RepairID = @RepairID AND PartID = @PartID";
cmd.Parameters.AddWithValue("@RepairID", repairDetail.RepairID);
cmd.Parameters.AddWithValue("@PartID", repairDetail.PartID);
cmd.Parameters.AddWithValue("@Amount", repairDetail.Amount);
cmd.Parameters.AddWithValue("@InvoiceNumber", repairDetail.InvoiceNumber);
cmd.Parameters.AddWithValue("@SupplierID", repairDetail.SupplierID);
cmd.ExecuteNonQuery();
MessageBox.Show("Updated Repair Detail has been saved!");
_dbOp.DBClose();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void AddB_Click(object sender, EventArgs e)
{
DisableRepair();
_repairDetail = new RepairDetail(repairID, partID, purchasedDate, partAmount, partInvoiceNumber, partSupplierID);
AddItem();
partCB.Focus();
if (addB.Text == "Update")
{
addB.Text = "Add";
}
}
public List <RepairDetail> RetrieveStatementRepair(int partID, string invoiceNumber)
{
List <RepairDetail> repairDetailList = new List <RepairDetail>();
try
{
_dbOp.DBConnect();
MySqlCommand cmd = _dbOp._dbConn.CreateCommand();
cmd.CommandText = "SELECT * FROM RepairDetail " + "WHERE PartID = @PartID AND InvoiceNumber = @InvoiceNumber";
cmd.Parameters.AddWithValue("@PartID", partID);
cmd.Parameters.AddWithValue("@InvoiceNumber", invoiceNumber);
MySqlDataReader reader = cmd.ExecuteReader();
RepairDetail temp = new RepairDetail();
while (reader.Read())
{
RepairID = (int)reader.GetValue(0);
PartID = (int)reader.GetValue(1);
PurchasedDate = (DateTime)reader.GetValue(2);
Amount = (double)reader.GetValue(3);
InvoiceNumber = (string)reader.GetValue(4);
SupplierID = (int)reader.GetValue(5);
temp = new RepairDetail(RepairID, PartID, PurchasedDate, Amount, InvoiceNumber, SupplierID);
repairDetailList.Add(temp);
}
reader.Close();
_dbOp.DBClose();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
return(repairDetailList);
}
private void PartListLV_SelectedIndexChanged(object sender, EventArgs e)
{
addB.Text = "Update";
partSupplierCB.Enabled = true;
partDateDTP.Enabled = true;
partInvoiceNumberTB.Enabled = true;
if (partListLV.SelectedItems.Count > 0)
{
ListViewItem selectedPart = partListLV.SelectedItems[0];
string partItemNo = selectedPart.SubItems[0].Text;
partCB.Text = selectedPart.SubItems[4].Text;
partID = _part.RetrievePartID(partCB.Text);
purchasedDate = partDateDTP.Value = DateTime.Parse(selectedPart.SubItems[2].Text);
partSupplierCB.Text = selectedPart.SubItems[1].Text;
partSupplierID = _supplier.RetrieveSupplierID(partSupplierCB.Text);
partInvoiceNumber = partInvoiceNumberTB.Text = selectedPart.SubItems[3].Text;
partAmountTB.Text = selectedPart.SubItems[5].Text;
partAmount = double.Parse(partAmountTB.Text);
_repairDetail = new RepairDetail(repairID, partID, purchasedDate, partAmount, partInvoiceNumber, partSupplierID);
partListLV.SelectedItems[0].Remove();
}
}