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(txtPatientName.Text);
arrlst.Add(txtCaseNo.Text);
arrlst.Add(extddlLocation.Text);
arrlst.Add(txtChkFromDate.Text);
arrlst.Add(txtChkToDate.Text);
arrlst.Add(txtChkNumber.Text);
arrlst.Add(txtChkAmount.Text);
arrlst.Add(extddlUser.Text);
DataSet objDS = new DataSet();
if (((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).BT_REFERRING_FACILITY == true)
{
objDS = _reportBO.GetPaymentDetailsMRI(arrlst);
}
else
{
objDS = _reportBO.GetPaymentDetails(arrlst);
}
DataTable objDT = new DataTable();
objDT.Columns.Add("BILL_DATE");
objDT.Columns.Add("SZ_BILL_NUMBER");
objDT.Columns.Add("VISIT_DATE");
objDT.Columns.Add("PATIENT_NAME");
objDT.Columns.Add("CASE_TYPE");
objDT.Columns.Add("BILLED");
objDT.Columns.Add("RECEIVED");
objDT.Columns.Add("OUTSTANDING");
objDT.Columns.Add("SZ_COMMENT");
objDT.Columns.Add("DOCTOR_NAME");
DataRow objDR;
string sz_provider_name = "NA";
decimal ForGroupSumTotalBillAmount = 0;
decimal ForGroupSumTotalPaidAmount = 0;
decimal ForGroupSumTotalOutstandingAmount = 0;
decimal SumTotalBillAmount = 0;
decimal SumTotalPaidAmount = 0;
decimal SumTotalOutstandingAmount = 0;
for (int i = 0; i < objDS.Tables[0].Rows.Count; i++)
{
if (objDS.Tables[0].Rows[i]["PROVIDER_NAME"].ToString().Equals(sz_provider_name))
{
objDR = objDT.NewRow();
objDR["BILL_DATE"] = objDS.Tables[0].Rows[i]["DT_BILL_DATE"].ToString();
objDR["SZ_BILL_NUMBER"] = objDS.Tables[0].Rows[i]["SZ_BILL_NUMBER"].ToString();
objDR["VISIT_DATE"] = objDS.Tables[0].Rows[i]["DT_FIRST_VISIT_DATE"].ToString();
objDR["PATIENT_NAME"] = objDS.Tables[0].Rows[i]["PATIENT_NAME"].ToString();
objDR["CASE_TYPE"] = objDS.Tables[0].Rows[i]["SZ_CASE_TYPE"].ToString();
objDR["BILLED"] = objDS.Tables[0].Rows[i]["TOTAL_BILL_AMOUNT"].ToString();
objDR["RECEIVED"] = objDS.Tables[0].Rows[i]["TOTAL_PAID_AMOUNT"].ToString();
objDR["OUTSTANDING"] = objDS.Tables[0].Rows[i]["TOTAL_OUTSTANDING_AMOUNT"].ToString();
objDR["SZ_COMMENT"] = objDS.Tables[0].Rows[i]["SZ_COMMENT"].ToString();
objDR["DOCTOR_NAME"] = objDS.Tables[0].Rows[i]["DOCTOR_NAME"].ToString();
objDT.Rows.Add(objDR);
sz_provider_name = objDS.Tables[0].Rows[i]["PROVIDER_NAME"].ToString();
ForGroupSumTotalBillAmount = ForGroupSumTotalBillAmount + Convert.ToDecimal(objDS.Tables[0].Rows[i]["TOTAL_BILL_AMOUNT"].ToString().Remove(0, 1));
ForGroupSumTotalPaidAmount = ForGroupSumTotalPaidAmount + Convert.ToDecimal(objDS.Tables[0].Rows[i]["TOTAL_PAID_AMOUNT"].ToString().Remove(0, 1));
ForGroupSumTotalOutstandingAmount = ForGroupSumTotalOutstandingAmount + Convert.ToDecimal(objDS.Tables[0].Rows[i]["TOTAL_OUTSTANDING_AMOUNT"].ToString().Remove(0, 1));
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));
}
else
{
if (i != 0)
{
objDR = objDT.NewRow();
objDR["BILL_DATE"] = "";
objDR["SZ_BILL_NUMBER"] = "";
objDR["VISIT_DATE"] = "";
objDR["PATIENT_NAME"] = "";
objDR["CASE_TYPE"] = "<b>Total by P.c</b>";
objDR["BILLED"] = "<b>$" + ForGroupSumTotalBillAmount.ToString() + "</b>";
objDR["RECEIVED"] = "<b>$" + ForGroupSumTotalPaidAmount.ToString() + "</b>";
objDR["OUTSTANDING"] = "<b>$" + ForGroupSumTotalOutstandingAmount.ToString() + "</b>";
objDR["SZ_COMMENT"] = objDS.Tables[0].Rows[i]["SZ_COMMENT"].ToString();
objDR["DOCTOR_NAME"] = objDS.Tables[0].Rows[i]["DOCTOR_NAME"].ToString();
objDT.Rows.Add(objDR);
ForGroupSumTotalBillAmount = 0.00M;
ForGroupSumTotalPaidAmount = 0.00M;
ForGroupSumTotalOutstandingAmount = 0.00M;
}
ForGroupSumTotalBillAmount = ForGroupSumTotalBillAmount + Convert.ToDecimal(objDS.Tables[0].Rows[i]["TOTAL_BILL_AMOUNT"].ToString().Remove(0, 1));
ForGroupSumTotalPaidAmount = ForGroupSumTotalPaidAmount + Convert.ToDecimal(objDS.Tables[0].Rows[i]["TOTAL_PAID_AMOUNT"].ToString().Remove(0, 1));
ForGroupSumTotalOutstandingAmount = ForGroupSumTotalOutstandingAmount + Convert.ToDecimal(objDS.Tables[0].Rows[i]["TOTAL_OUTSTANDING_AMOUNT"].ToString().Remove(0, 1));
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));
objDR = objDT.NewRow();
objDR["BILL_DATE"] = "<b>" + objDS.Tables[0].Rows[i]["PROVIDER_NAME"].ToString() + "</b>";
objDR["SZ_BILL_NUMBER"] = "";
objDR["VISIT_DATE"] = "";
objDR["PATIENT_NAME"] = "";
objDR["CASE_TYPE"] = "";
objDR["BILLED"] = "";
objDR["RECEIVED"] = "";
objDR["OUTSTANDING"] = "";
objDR["SZ_COMMENT"] = "";
objDR["DOCTOR_NAME"] = "";
objDT.Rows.Add(objDR);
objDR = objDT.NewRow();
objDR["BILL_DATE"] = objDS.Tables[0].Rows[i]["DT_BILL_DATE"].ToString();
objDR["SZ_BILL_NUMBER"] = objDS.Tables[0].Rows[i]["SZ_BILL_NUMBER"].ToString();
objDR["VISIT_DATE"] = objDS.Tables[0].Rows[i]["DT_FIRST_VISIT_DATE"].ToString();
objDR["PATIENT_NAME"] = objDS.Tables[0].Rows[i]["PATIENT_NAME"].ToString();
objDR["CASE_TYPE"] = objDS.Tables[0].Rows[i]["SZ_CASE_TYPE"].ToString();
objDR["BILLED"] = objDS.Tables[0].Rows[i]["TOTAL_BILL_AMOUNT"].ToString();
objDR["RECEIVED"] = objDS.Tables[0].Rows[i]["TOTAL_PAID_AMOUNT"].ToString();
objDR["OUTSTANDING"] = objDS.Tables[0].Rows[i]["TOTAL_OUTSTANDING_AMOUNT"].ToString();
objDR["SZ_COMMENT"] = objDS.Tables[0].Rows[i]["SZ_COMMENT"].ToString();
objDR["DOCTOR_NAME"] = objDS.Tables[0].Rows[i]["DOCTOR_NAME"].ToString();
objDT.Rows.Add(objDR);
sz_provider_name = objDS.Tables[0].Rows[i]["PROVIDER_NAME"].ToString();
}
}
if (objDS.Tables[0].Rows.Count > 0)
{
objDR = objDT.NewRow();
objDR["BILL_DATE"] = "";
objDR["SZ_BILL_NUMBER"] = "";
objDR["VISIT_DATE"] = "";
objDR["PATIENT_NAME"] = "";
objDR["CASE_TYPE"] = "<b>Total by P.c</b>";
objDR["BILLED"] = "<b>$" + ForGroupSumTotalBillAmount.ToString() + "</b>";
objDR["RECEIVED"] = "<b>$" + ForGroupSumTotalPaidAmount.ToString() + "</b>";
objDR["OUTSTANDING"] = "<b>$" + ForGroupSumTotalOutstandingAmount.ToString() + "</b>";
objDR["SZ_COMMENT"] = "";
objDT.Rows.Add(objDR);
objDR = objDT.NewRow();
objDR["BILL_DATE"] = "";
objDR["SZ_BILL_NUMBER"] = "";
objDR["VISIT_DATE"] = "";
objDR["PATIENT_NAME"] = "";
objDR["CASE_TYPE"] = "<b>Total</b>";
objDR["BILLED"] = "<b>$" + SumTotalBillAmount.ToString() + "</b>";
objDR["RECEIVED"] = "<b>$" + SumTotalPaidAmount.ToString() + "</b>";
objDR["OUTSTANDING"] = "<b>$" + SumTotalOutstandingAmount.ToString() + "</b>";
objDR["SZ_COMMENT"] = "";
objDT.Rows.InsertAt(objDR, 0);
}
grdPayment.DataSource = objDT;
grdPayment.DataBind();
if (Request.QueryString["fromCase"] == null)
{
grdPayment.Columns[3].Visible = true;
}
else
{
grdPayment.Columns[3].Visible = false;
}
// 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());
}
}
