// to add total to invoice table protected void Button3_Click(object sender, EventArgs e) { using (DatabaseEntities db = new DatabaseEntities()) { var result = from i in db.invoice_line_item group i by new { i.inv_hed_id } into g select new { g.Key.inv_hed_id, totalcost = (double)g.Sum(x => x.ser_cost) }; foreach (var r in result) { foreach (var s in db.invoices) { if (r.inv_hed_id == s.inv_hed_id) { s.total_cost = r.totalcost; } } } db.SaveChanges(); } var invoices = db.invoices.ToList(); InvoiceList.DataSource = invoices; InvoiceList.DataBind(); }
// WHOLE LIST public void InvoiceListView() { CsInvoice list = new CsInvoice(InvoiceTable); try { ConnectionClass.DisplayInvoice(list); InvoiceList.DataSource = list.InvoiceList; InvoiceList.DataBind(); } catch { TEST.Text = "Error Occured, Please try reloading page. Sorry for inconvenience"; } finally { } }
public void FilterInvoiceByNumber() { KeyWordNum = keywordbox.Text; CsSearchInvoice filist = new CsSearchInvoice(KeyWordName, KeyWordNum, InvoiceTable); try { ConnectionClass.SearchInvoiceByNum(filist); InvoiceList.DataSource = filist.Invoicelist; InvoiceList.DataBind(); } catch { TEST.Text = "Error Occured, Please try reloading page. Sorry for inconvenience"; } finally { } }