internal void UpdateItemAmount(Entity.ExtendedInvoice invoice, String selectedItem, int amount) { DBGetInvoice db = new DBGetInvoice(); String item_name = selectedItem.Split('|')[0]; int item_in_invoice_id = db.GetItemInInvoicedId(invoice.Id, item_name); var item_in_invoice_update = dbContext.Item_in_invoice.SingleOrDefault(x => x.Id == item_in_invoice_id); item_in_invoice_update.Amount = amount; dbContext.SubmitChanges(); invoice.items = db.GetItemList(invoice.Id); }
public void DeleteItemInInvoice(Entity.ExtendedInvoice invoice, String name) { DBGetInvoice db = new DBGetInvoice(); int item_in_invoice_id = db.GetItemInInvoicedId(invoice.Id, name); Debug.WriteLine(item_in_invoice_id); var item_in_invoice_delete = dbContext.Item_in_invoice.SingleOrDefault(x => x.Id == item_in_invoice_id); dbContext.Item_in_invoice.DeleteOnSubmit(item_in_invoice_delete); dbContext.SubmitChanges(); invoice.items = db.GetItemList(invoice.Id); }