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