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