public bool EditSalesRecord(int id, DateTime date, StockItem item, int quantity, DataManager data)
{
foreach (SalesRecord s in _sales_record)
{
if (s.SalesId == id)
{
string command = "UPDATE SalesTable "
+ "SET Stock_Id = " + item.StockId
+ ", Sales_Quantity = " + quantity
+ ", Sales_Date= " + date
+ " Where Sales_Id = " + id + ";";
if (data.PushData(command))
{
_sales_record.Remove(s);
_sales_record.Add(new SalesRecord(id, item, quantity, date));
return(true);
}
}
}
return(false);
}
