protected void BtnSave_Click(object sender, EventArgs e) { BillingLINQDataContext kp = new BillingLINQDataContext(); if (Session["InvoiceID"] != "new") { var invoice = kp.Invoices.Where(x => x.InvoiceID == (int)Session["InvoiceID"]).FirstOrDefault(); invoice.InvoiceDate = InvoiceDate.Date; invoice.DateOfCompletion = DateOfCompletion.Date; invoice.DueDate = DueDate.Date; invoice.CustomerID = (int)cbCustomer.Value; invoice.CompanyID = (int)cbCompany.Value; kp.SubmitChanges(); } else { int maxInvoiceID = kp.Invoices.Max(x => x.InvoiceID) + 1; BillingSoftware.Invoice item = new BillingSoftware.Invoice(); item.InvoiceNumber = DateTime.Today.ToString("yymmdd") + "_" + maxInvoiceID.ToString(); kp.Invoices.ToList().Add(item); kp.SubmitChanges(); } Response.Redirect("~/Pages/Invoice.aspx?Id=" + Session["InvoiceID"]); }
protected void BtnSaveItem_Click(object sender, EventArgs e) { BillingLINQDataContext kp = new BillingLINQDataContext(); var invoice = kp.InvoiceDetails.Where(x => x.InvoiceID == (int)Session["InvoiceID"]).FirstOrDefault(); invoice.ProductName = tbProductName.Text; invoice.AmountUnit = tbAmountUnit.Text; //invoice.Quantity = tbQuantity.Text.ToString; kp.SubmitChanges(); Response.Redirect(prevPage); }
protected void DeleteButton_Click(object sender, EventArgs e) { BillingLINQDataContext kp = new BillingLINQDataContext(); if (gvInvoice.FocusedRowIndex == -1) { return; } int id = (int)gvInvoice.GetRowValues(gvInvoice.FocusedRowIndex, "InvoiceID"); var delete = kp.Invoices.FirstOrDefault(s => s.InvoiceID == id); if (delete != null) { kp.Invoices.DeleteOnSubmit(delete); kp.SubmitChanges(); } Page.Response.Redirect(Page.Request.Url.ToString(), true); }