public void BindGrid()
{
DataSet dset;
try
{
string hdnBills = hdnBillNumber.Value.ToString();
Bill_Sys_BillTransaction_BO n_bo = new Bill_Sys_BillTransaction_BO();
string[] sBillNumber = System.Text.RegularExpressions.Regex.Split(hdnBills, @"\,");
gbmodel.bill.Bill billNo = new gbmodel.bill.Bill();
List <gbmodel.bill.Bill> lstBills = new List <gbmodel.bill.Bill>();
for (int i = 0; i < sBillNumber.Length; i++)
{
billNo = new gbmodel.bill.Bill();
if (sBillNumber.Length > 0)
{
if (sBillNumber[i] != "")
{
billNo.Number = sBillNumber[i].ToString();
lstBills.Add(billNo);
}
}
}
DataTable dtBillNumbers = new DataTable();
dtBillNumbers.Columns.Add("sz_bill_id", typeof(string));
dtBillNumbers.Columns.Add("sz_assigned_lawfirm_id", typeof(string));
dtBillNumbers.Columns.Add("sz_company_id", typeof(string));
foreach (gbmodel.bill.Bill sBill in lstBills)
{
DataRow row = dtBillNumbers.NewRow();
row["sz_bill_id"] = sBill.Number;
dtBillNumbers.Rows.Add(row);
}
gbmodel.account.Account oAccount = new gbmodel.account.Account();
oAccount.ID = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
SrvBill srvBill = new SrvBill();
dset = new DataSet();
//dset = srvBill.GetBilVerificationlDetails(dtBillNumbers, lstBills, oAccount);
dset = n_bo.GetBilEORDetails(dtBillNumbers, oAccount.ID.ToString());
grdEORReceived.DataSource = dset.Tables[0];
grdEORReceived.DataBind();
}
catch (Exception ex)
{
lblScan.Visible = false;
lblMessage.Visible = false;
lblErrorMessage.Visible = true;
lblErrorMessage.Text = ex.Message.ToString();
}
}
protected void grdEORReceived_ItemCommand(object source, DataGridCommandEventArgs e)
{
try
{
int rowIndex = e.Item.ItemIndex;
gbmodel.bill.Bill oBillNo = new gbmodel.bill.Bill();
gbmodel.bill.verification.Verification p_oVerification = new gbmodel.bill.verification.Verification();
oBillNo.Number = grdEORReceived.DataKeys[rowIndex].ToString();
p_oVerification.Id = e.Item.Cells[5].Text.ToString();
gbmodel.account.Account oAccount = new gbmodel.account.Account();
oAccount.ID = txtCompanyID.Text;
SrvBill oSrvBill = new SrvBill();
int i = oSrvBill.DeleteVerificationDescription(oBillNo, p_oVerification, oAccount);
if (i > 0)
{
lblErrorMessage.Visible = false;
lblMessage.Visible = true;
lblMessage.Text = "Record deleted Successfully";
}
else
{
lblMessage.Visible = false;
lblErrorMessage.Text = "";
lblErrorMessage.Visible = true;
lblErrorMessage.Text = "An error occured while deleting the record";
}
BindGrid();
}
catch (Exception ex)
{
lblScan.Visible = false;
lblMessage.Visible = false;
lblErrorMessage.Text = "";
lblErrorMessage.Visible = true;
lblErrorMessage.Text = ex.Message.ToString();
}
}
public void BindGrid()
{
DataSet dset;
try
{
string hdnIns = hdnBillNumber.Value.ToString();
string[] sBillNumber = System.Text.RegularExpressions.Regex.Split(hdnIns, @"\,");
gbmodel.bill.Bill billNo = new gbmodel.bill.Bill();
List <gbmodel.bill.Bill> lstBills = new List <gbmodel.bill.Bill>();
for (int i = 0; i < sBillNumber.Length; i++)
{
billNo = new gbmodel.bill.Bill();
if (sBillNumber.Length > 0)
{
if (sBillNumber[i] != "")
{
billNo.Number = sBillNumber[i].ToString();
lstBills.Add(billNo);
}
}
}
DataTable dtBillNumbers = new DataTable();
//for each of your properties
dtBillNumbers.Columns.Add("sz_bill_id", typeof(string));
foreach (gbmodel.bill.Bill sBill in lstBills)
{
DataRow row = dtBillNumbers.NewRow();
//foreach of your properties
row["sz_bill_id"] = sBill.Number;
dtBillNumbers.Rows.Add(row);
}
gbmodel.account.Account oAccount = new gbmodel.account.Account();
oAccount.ID = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
SrvBill srvBill = new SrvBill();
dset = srvBill.GetBillDenialDetails(dtBillNumbers, lstBills, oAccount);
grdVerificationReq.DataSource = dset.Tables[0];
grdVerificationReq.DataBind();
for (int i = 0; i < grdVerificationReq.Items.Count; i++)
{
if (grdVerificationReq.Items[i].Cells[9].Text != " ")
{
hfindex.Value = "";
hfverificationId.Value = "";
hfindex.Value = i.ToString();
hfverificationId.Value = grdVerificationReq.Items[i].Cells[5].Text.ToString();
}
}
}
catch (Exception ex)
{
lblScan.Visible = false;
lblMessage.Visible = false;
lblErrorMessage.Text = "";
lblErrorMessage.Visible = true;
lblErrorMessage.Text = ex.Message.ToString();
}
}
