protected void Save_Click(object sender, EventArgs e) { DataTable SaleDetail = (DataTable)ViewState["SALE_TRANSACTION_TABLE"]; DataTable Sale = new DataTable(); if (SaleDetail.Rows.Count > 0) { Sale.Columns.Add("TOTAL_AMOUNT", typeof(decimal)); Sale.Columns.Add("AMOUNT_PAID", typeof(decimal)); Sale.Columns.Add("CUSTOMER_ID_ID", typeof(int)); DataRow dr = Sale.NewRow(); dr["TOTAL_AMOUNT"] = Convert.ToDecimal(ViewState["TOTAL_AMOUNT"].ToString()); dr["AMOUNT_PAID"] = 0; dr["CUSTOMER_ID_ID"] = 0; Sale.Rows.InsertAt(dr, 0); } stock.AddSaleTransaction(SaleDetail, Sale); }
protected void btnPay_Click(object sender, EventArgs e) { DataTable SaleDetail = (DataTable)ViewState["SALE_TRANSACTION_TABLE"]; Decimal finalamount = 0; Decimal amountPaid = 0, amountDue = 0; try { foreach (DataRow dr in SaleDetail.Rows) { finalamount += Convert.ToDecimal(dr["NET_AMOUNT"].ToString()); } totalAmount.Text = finalamount.ToString(); amountPaid = Convert.ToDecimal(Amountpaid.Text.Trim()); amountDue = finalamount - amountPaid; DataTable Sale = new DataTable(); if (SaleDetail.Rows.Count > 0) { Sale.Columns.Add("CUSTOMER_ID", typeof(int)); Sale.Columns.Add("TOTAL_AMOUNT", typeof(decimal)); Sale.Columns.Add("AMOUNT_PAID", typeof(decimal)); Sale.Columns.Add("AMOUNT_DUE", typeof(decimal)); DataRow dr = Sale.NewRow(); dr["CUSTOMER_ID"] = ddlcustomer.SelectedValue.ToString(); dr["TOTAL_AMOUNT"] = finalamount.ToString(); dr["AMOUNT_PAID"] = Amountpaid.Text.Trim(); dr["AMOUNT_DUE"] = amountDue.ToString(); Sale.Rows.InsertAt(dr, 0); } stock.AddSaleTransaction(SaleDetail, Sale); main_section.Visible = true; bill_section.Visible = false; Response.Redirect(Request.Url.AbsoluteUri); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Alert", "Data has been saved", true); } catch (Exception ex) { logger.Error(MODULE_NAME, "btnPay_Click", ex); throw ex; } }