public void DeleteInvoice(Entity.ExtendedInvoice invoice) { var invoice_to_delete = dbContext.Invoice.Single(x => x.Id == invoice.Id); dbContext.Invoice.DeleteOnSubmit(invoice_to_delete); dbContext.SubmitChanges(); }
private void DeleteInvoice_Click(object sender, RoutedEventArgs e) { if (invoice_grid_view.SelectedItem != null) { DBDeleteInvoice db_delete = new DBDeleteInvoice(); DBGetInvoice db_get = new DBGetInvoice(); Entity.ExtendedInvoice invoice = db_get.GetInvoice(Int16.Parse(GetInvoiceId(invoice_grid_view.SelectedItem.ToString()))); db_delete.DeleteInvoice(invoice); SetGridViewDataSource(); } }
public void InsertItemInInvoice(Entity.ExtendedInvoice invoice) { DBUpdateInvoice db = new DBUpdateInvoice(); foreach (Entity.ExtendedItem i in invoice.items) { Item_in_invoice it = new Item_in_invoice(); it.Id = db.GetFreeItemInInvoiceId(); it.Item_Id = db.GetItemId(i); it.Invoice_Id = invoice.Id; it.Amount = i.amount; dbContext.Item_in_invoice.InsertOnSubmit(it); dbContext.SubmitChanges(); } }
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); }
public void AddInvoice(Entity.ExtendedInvoice invoice) { invoice.Id = GetFreeInvoiceId(); Invoice inv = new Invoice(); inv.Id = invoice.Id; inv.FA_Number = invoice.FA_Number; inv.Issue_Date = invoice.issue_date; inv.Due_Date = invoice.due_date; inv.Payment_Method = invoice.Payment_Method; inv.Subject_For_Id = invoice.subject_for.Id; inv.Subject_From_Id = invoice.subject_from.Id; dbContext.Invoice.InsertOnSubmit(inv); dbContext.SubmitChanges(); InsertItemInInvoice(invoice); }
public void UpdateInvoice(Entity.ExtendedInvoice invoice) { // dbContext.Invoice.InsertOnSubmit(); var invoiceToUpdate = dbContext.Invoice.SingleOrDefault(x => x.Id == invoice.Id); invoiceToUpdate.FA_Number = invoice.FA_Number; invoiceToUpdate.Issue_Date = invoice.issue_date; invoiceToUpdate.Due_Date = invoice.due_date; invoiceToUpdate.Payment_Method = invoice.Payment_Method; invoiceToUpdate.Subject_For_Id = invoice.subject_for.Id; invoiceToUpdate.Subject_From_Id = invoice.subject_from.Id; dbContext.SubmitChanges(); // dbContext.SubmitChanges(); }