private void ShowPendingBills() { string connStr = string.Empty; if (Request.Cookies["Company"] != null) { connStr = System.Configuration.ConfigurationManager.ConnectionStrings[Request.Cookies["Company"].Value].ToString(); } else { Response.Redirect("~/Login.aspx"); } BusinessLogic bl = new BusinessLogic(); var customerID = ddledger.SelectedValue.Trim(); var dsSales = bl.ListCreditSales(connStr.Trim(), customerID); var receivedData = bl.GetCustReceivedAmount(connStr); if (dsSales != null) { foreach (DataRow dr in receivedData.Tables[0].Rows) { var billNo = dr["BillNo"].ToString(); var billAmount = dr["TotalAmount"].ToString(); for (int i = 0; i < dsSales.Tables[0].Rows.Count; i++) { if (billNo.Trim() == dsSales.Tables[0].Rows[i]["BillNo"].ToString()) { dsSales.Tables[0].Rows[i].BeginEdit(); double val = (double.Parse(dsSales.Tables[0].Rows[i]["Amount"].ToString()) - double.Parse(billAmount)); dsSales.Tables[0].Rows[i]["Amount"] = val; dsSales.Tables[0].Rows[i].EndEdit(); if (val == 0.0) { dsSales.Tables[0].Rows[i].Delete(); } } } dsSales.Tables[0].AcceptChanges(); } } rowdetails.Visible = true; GrdViewSales.DataSource = dsSales; GrdViewSales.DataBind(); }
private void BindSales(int strBillno) { DataSet ds = new DataSet(); BusinessLogic bl = new BusinessLogic(sDataSource); bool deletedItems = false; deletedItems = ChkSales.Checked; if (strBillno == 0) { ds = bl.lsSales(deletedItems); } else { ds = bl.lsSalesForId(strBillno, deletedItems); } if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { GrdViewSales.DataSource = ds.Tables[0].DefaultView; GrdViewSales.DataBind(); } } else { GrdViewSales.DataSource = null; GrdViewSales.DataBind(); } if (ChkSales.Checked) { GrdViewSales.Columns[11].Visible = false; GrdViewSales.Columns[10].Visible = true; } else { GrdViewSales.Columns[10].Visible = false; GrdViewSales.Columns[11].Visible = true; } }
protected void ComboBox2_SelectedIndexChanged(object sender, EventArgs e) { try { string debtorID = ddledger.SelectedValue; //ReportsBL.ReportClass rptStock = new ReportsBL.ReportClass(); //DataSet ds = rptStock.getCategory(sDataSource); //gvCategory.DataSource = ds; //gvCategory.DataBind(); string connStr = string.Empty; if (Request.Cookies["Company"] != null) { connStr = System.Configuration.ConfigurationManager.ConnectionStrings[Request.Cookies["Company"].Value].ToString(); } else { Response.Redirect("~/Login.aspx"); } BusinessLogic bl = new BusinessLogic(); var customerID = ddledger.SelectedValue.Trim(); var dsSales = bl.ListCreditSales(connStr.Trim(), customerID); rowdetails.Visible = true; GrdViewSales.DataSource = dsSales; GrdViewSales.DataBind(); //ShowPendingBills(); } catch (Exception ex) { TroyLiteExceptionManager.HandleException(ex); } }
protected void rdoType_SelectedIndexChanged(object sender, EventArgs e) { try { if (rdoType.SelectedValue == "Payment") { divPayment.Visible = true; divReceipt.Visible = false; divJournal.Visible = false; divPurchase.Visible = false; divSales.Visible = false; divPaymentResult.Visible = true; GrdViewJournal.DataSource = null; GrdViewJournal.DataBind(); GrdViewPurchase.DataSource = null; GrdViewPurchase.DataBind(); GrdViewReceipt.DataSource = null; GrdViewReceipt.DataBind(); GrdViewSales.DataSource = null; GrdViewSales.DataBind(); ChkSales.Checked = false; ChkJournal.Checked = false; ChkPurchase.Checked = false; ChkReceipt.Checked = false; BindPayment(); } else if (rdoType.SelectedValue == "Receipt") { divPayment.Visible = false; divReceipt.Visible = true; divJournal.Visible = false; divPurchase.Visible = false; divSales.Visible = false; ChkSales.Checked = false; ChkJournal.Checked = false; ChkPurchase.Checked = false; ChkPayDel.Checked = false; divPaymentResult.Visible = false; divJournalResult.Visible = false; divPurchaseResult.Visible = false; divReceiptResult.Visible = true; divSalesResult.Visible = false; GrdViewPayment.DataSource = null; GrdViewPayment.DataBind(); GrdViewJournal.DataSource = null; GrdViewJournal.DataBind(); GrdViewPurchase.DataSource = null; GrdViewPurchase.DataBind(); GrdViewSales.DataSource = null; GrdViewSales.DataBind(); BindReceipt(); } else if (rdoType.SelectedValue == "Journal") { divPayment.Visible = false; divReceipt.Visible = false; divJournal.Visible = true; divPurchase.Visible = false; divSales.Visible = false; ChkSales.Checked = false; ChkPayDel.Checked = false; ChkPurchase.Checked = false; ChkReceipt.Checked = false; divPaymentResult.Visible = false; divJournalResult.Visible = true; divPurchaseResult.Visible = false; divReceiptResult.Visible = false; divSalesResult.Visible = false; GrdViewPayment.DataSource = null; GrdViewPayment.DataBind(); GrdViewPurchase.DataSource = null; GrdViewPurchase.DataBind(); GrdViewReceipt.DataSource = null; GrdViewReceipt.DataBind(); GrdViewSales.DataSource = null; GrdViewSales.DataBind(); BindJournal(); } else if (rdoType.SelectedValue == "Purchase") { divPayment.Visible = false; divReceipt.Visible = false; divJournal.Visible = false; divPurchase.Visible = true; divSales.Visible = false; divPaymentResult.Visible = false; divJournalResult.Visible = false; divPurchaseResult.Visible = true; divReceiptResult.Visible = false; divSalesResult.Visible = false; ChkSales.Checked = false; ChkJournal.Checked = false; ChkPayDel.Checked = false; ChkReceipt.Checked = false; GrdViewPayment.DataSource = null; GrdViewPayment.DataBind(); GrdViewJournal.DataSource = null; GrdViewJournal.DataBind(); GrdViewReceipt.DataSource = null; GrdViewReceipt.DataBind(); GrdViewSales.DataSource = null; GrdViewSales.DataBind(); BindPurchase("0"); } else { divReceipt.Visible = false; divPayment.Visible = false; divJournal.Visible = false; divPurchase.Visible = false; divSales.Visible = true; ChkPayDel.Checked = false; ChkJournal.Checked = false; ChkPurchase.Checked = false; ChkReceipt.Checked = false; divPaymentResult.Visible = false; divJournalResult.Visible = false; divPurchaseResult.Visible = false; divReceiptResult.Visible = false; divSalesResult.Visible = true; GrdViewPayment.DataSource = null; GrdViewPayment.DataBind(); GrdViewJournal.DataSource = null; GrdViewJournal.DataBind(); GrdViewPurchase.DataSource = null; GrdViewPurchase.DataBind(); GrdViewReceipt.DataSource = null; GrdViewReceipt.DataBind(); BindSales(0); } } catch (Exception ex) { TroyLiteExceptionManager.HandleException(ex); } }