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