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