public void BindGrid()
{
string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url);
using (Utils utility = new Utils())
{
utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod());
}
_reportBO = new Bill_Sys_ReportBO();
try
{
ArrayList arrlst = new ArrayList();
arrlst.Add(txtCompanyID.Text);
arrlst.Add(txtFromDate.Text);
arrlst.Add(txtToDate.Text);
arrlst.Add(txtProvider.Text);
// send parameter Location_Id to function GetBillReportProvider
arrlst.Add(extddlLocation.Text);
DataSet objDS = new DataSet();
objDS = _reportBO.GetBillReportProvider(arrlst);
decimal SumTotalBillAmount = 0;
decimal SumTotalPaidAmount = 0;
decimal SumTotalOutstandingAmount = 0;
decimal SumTotalWriteOff = 0;
decimal SumTotalTransferred = 0;
for (int i = 0; i < objDS.Tables[0].Rows.Count; i++)
{
SumTotalBillAmount = SumTotalBillAmount + Convert.ToDecimal(objDS.Tables[0].Rows[i]["TOTAL_BILL_AMOUNT"].ToString().Remove(0, 1));
SumTotalPaidAmount = SumTotalPaidAmount + Convert.ToDecimal(objDS.Tables[0].Rows[i]["MN_PAID"].ToString().Remove(0, 1));
SumTotalOutstandingAmount = SumTotalOutstandingAmount + Convert.ToDecimal(objDS.Tables[0].Rows[i]["TOTAL_OUTSTANDING_AMOUNT"].ToString().Remove(0, 1));
SumTotalWriteOff = SumTotalWriteOff + Convert.ToDecimal(objDS.Tables[0].Rows[i]["FLT_WRITE_OFF"].ToString().Remove(0, 1));
SumTotalTransferred = SumTotalTransferred + Convert.ToDecimal(objDS.Tables[0].Rows[i]["mn_transferred_amount"].ToString().Remove(0, 1));
}
if (objDS.Tables[0].Rows.Count > 0)
{
DataRow objDR = objDS.Tables[0].NewRow();
objDR["PROVIDER_NAME"] = "<b>Total</b>";
objDR["TOTAL_BILL_AMOUNT"] = "<b>$" + SumTotalBillAmount.ToString() + "</b>";
objDR["MN_PAID"] = "<b>$" + SumTotalPaidAmount.ToString() + "</b>";
objDR["TOTAL_OUTSTANDING_AMOUNT"] = "<b>$" + SumTotalOutstandingAmount.ToString() + "</b>";
objDR["FLT_WRITE_OFF"] = "<b>$" + SumTotalWriteOff.ToString() + "</b>";
objDR["mn_transferred_amount"] = "<b>$" + SumTotalTransferred.ToString() + "</b>";
objDS.Tables[0].Rows.InsertAt(objDR, 0);
}
grdPayment.DataSource = objDS;
grdPayment.DataBind();
// AddAmount();
LinkButton show = null;
if (objDS.Tables[0].Rows.Count > 0)
{
show = (LinkButton)grdPayment.Items[0].FindControl("lnkshow");
show.Visible = false;
}
if (txtFromDate.Text != "")
{
Session["ReportFromDate"] = txtFromDate.Text;
}
else
{
Session["ReportFromDate"] = DateTime.Parse("Jan 1, 2009");
}
if (txtToDate.Text != "")
{
Session["ReportToDate"] = txtToDate.Text;
}
else
{
Session["ReportToDate"] = DateTime.Today;
}
Session["SZ_LOCATION_id"] = extddlLocation.Text;
Session["sz_Office_Id_Text"] = txtProvider.Text;
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
string str2 = "Error Request=" + id + ".Please share with Technical support.";
base.Response.Redirect("Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2);
}
//Method End
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
}
public void BindGrid()
{
string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url);
using (Utils utility = new Utils())
{
utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod());
}
_reportBO = new Bill_Sys_ReportBO();
try
{
ArrayList arrlst = new ArrayList();
arrlst.Add(txtCompanyID.Text);
arrlst.Add(txtFromDate.Text);
arrlst.Add(txtToDate.Text);
arrlst.Add(txtProvider.Text);
// send parameter Location_Id to function GetBillReportProvider
arrlst.Add(extddlLocation.Text);
DataSet objDS = new DataSet();
objDS = _reportBO.GetBillReportProvider(arrlst);
decimal SumTotalBillAmount = 0;
decimal SumTotalPaidAmount = 0;
decimal SumTotalOutstandingAmount = 0;
for (int i = 0; i < objDS.Tables[0].Rows.Count; i++)
{
SumTotalBillAmount = SumTotalBillAmount + Convert.ToDecimal(objDS.Tables[0].Rows[i]["TOTAL_BILL_AMOUNT"].ToString().Remove(0, 1));
SumTotalPaidAmount = SumTotalPaidAmount + Convert.ToDecimal(objDS.Tables[0].Rows[i]["TOTAL_PAID_AMOUNT"].ToString().Remove(0, 1));
SumTotalOutstandingAmount = SumTotalOutstandingAmount + Convert.ToDecimal(objDS.Tables[0].Rows[i]["TOTAL_OUTSTANDING_AMOUNT"].ToString().Remove(0, 1));
}
if (objDS.Tables[0].Rows.Count > 1)
{
DataRow objDR = objDS.Tables[0].NewRow();
objDR["PROVIDER_NAME"] = "<b>Total</b>";
objDR["TOTAL_BILL_AMOUNT"] = "<b>$" + SumTotalBillAmount.ToString() + "</b>";
objDR["TOTAL_PAID_AMOUNT"] = "<b>$" + SumTotalPaidAmount.ToString() + "</b>";
objDR["TOTAL_OUTSTANDING_AMOUNT"] = "<b>$" + SumTotalOutstandingAmount.ToString() + "</b>";
objDS.Tables[0].Rows.InsertAt(objDR, 0);
}
grdPayment.DataSource = objDS;
grdPayment.DataBind();
// AddAmount();
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
string str2 = "Error Request=" + id + ".Please share with Technical support.";
base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2);
}
//Method End
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
}
