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); }