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());
        }
        try
        {
            ArrayList objAL = new ArrayList();
            objAL.Add(ddlProcedureCode.SelectedValue.ToString());
            objAL.Add(extddlSpeciality.Text);
            objAL.Add(txtCompanyID.Text);
            objAL.Add(extddlLocation.Text);
            _reportBO = new Bill_Sys_ReportBO();
            grdMissingProcedure.DataSource = _reportBO.Get_Missing_Procedure_Report(objAL);
            grdMissingProcedure.DataBind();
        }
        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());
        }
    }
    private void BindGridQueryString(string szFlag)
    {
        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
        {
            grdAllReports.DataSource = _reportBO.GetProcedureReports("SP_REPORT_PROCEDURE_REPORT", "", "", "NA", "NA", txtCompanyID.Text, szFlag);
            grdAllReports.DataBind();
        }
        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());
        }
    }
Пример #3
0
    public void BindGrid_DisplayDiagonosisCodeForTest(string sz_companyId, string sz_speciality, string sz_caseId)
    {
        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());
        }
        Bill_Sys_ReportBO _reportBO = new Bill_Sys_ReportBO();

        try
        {
            grdDisplayDiagonosisCode.DataSource = _reportBO.getAssociatedDiagnosisCodeForTest(sz_companyId, sz_speciality, sz_caseId);
            grdDisplayDiagonosisCode.DataBind();
        }
        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());
        }
    }
 protected void btnRevert_Click1(object sender, EventArgs e)
 {
     for (int j = 0; j < grdProcesureCode.Items.Count; j++)
     {
         CheckBox chkDelete1 = (CheckBox)grdProcesureCode.Items[j].FindControl("chkSelect");
         if (chkDelete1.Checked && grdProcesureCode.Items[j].Cells[11].Text.Trim().ToString().Equals("Received Report"))
         {
             Bill_Sys_ReportBO objUpdateReport = new Bill_Sys_ReportBO();
             objUpdateReport.RevertReport(Convert.ToInt32(grdProcesureCode.Items[j].Cells[1].Text.Trim().ToString()));
             #region Activity_Log
             this._DAO_NOTES_EO = new DAO_NOTES_EO();
             this._DAO_NOTES_EO.SZ_MESSAGE_TITLE = "REP_REVERT";
             this._DAO_NOTES_EO.SZ_ACTIVITY_DESC = "Procedure Id  : " + grdProcesureCode.Items[j].Cells[1].Text.Trim().ToString() + " Report Revrted . ";
             this._DAO_NOTES_BO               = new DAO_NOTES_BO();
             this._DAO_NOTES_EO.SZ_USER_ID    = (((Bill_Sys_UserObject)HttpContext.Current.Session["USER_OBJECT"]).SZ_USER_ID);
             this._DAO_NOTES_EO.SZ_CASE_ID    = this._DAO_NOTES_EO.SZ_CASE_ID = (((Bill_Sys_CaseObject)HttpContext.Current.Session["CASE_OBJECT"]).SZ_CASE_ID);
             this._DAO_NOTES_EO.SZ_COMPANY_ID = ((Bill_Sys_BillingCompanyObject)HttpContext.Current.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
             this._DAO_NOTES_BO.SaveActivityNotes(this._DAO_NOTES_EO);
             #endregion
             lblMsg.Text    = "Report Reverted Successfully";
             lblMsg.Visible = true;
         }
     }
     GetProcedureList(txtCaseID.Text, ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
 }
Пример #5
0
    private 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
        {
            //if (extddlLocation.Visible == true && extddlLocation.Text != "NA")
            //{
            //    grdAllReports.DataSource = _reportBO.GetAllReports("SP_REPORT_GET_PAYMENTS", txtFromDate.Text, txtToDate.Text, txtCompanyID.Text, extddlLocation.Text);
            //    grdAllReports.DataBind();

            //    grdForReport.DataSource = _reportBO.GetAllReports("SP_REPORT_GET_PAYMENTS", txtFromDate.Text, txtToDate.Text, txtCompanyID.Text, extddlLocation.Text);
            //    grdForReport.DataBind();
            //}
            //else
            //{
            //    grdAllReports.DataSource = _reportBO.GetAllReports("SP_REPORT_GET_PAYMENTS", txtFromDate.Text, txtToDate.Text, txtCompanyID.Text);
            //    grdAllReports.DataBind();

            //    grdForReport.DataSource = _reportBO.GetAllReports("SP_REPORT_GET_PAYMENTS", txtFromDate.Text, txtToDate.Text, txtCompanyID.Text);
            //    grdForReport.DataBind();
            //}
            if (extddlCaseType.Text != "NA")
            {
                grdAllReports.DataSource = _reportBO.GetAllReportsCase("SP_REPORT_GET_PAYMENTS", txtFromDate.Text, txtToDate.Text, txtCompanyID.Text, extddlCaseType.Text);
                grdAllReports.DataBind();

                grdForReport.DataSource = _reportBO.GetAllReportsCase("SP_REPORT_GET_PAYMENTS", txtFromDate.Text, txtToDate.Text, txtCompanyID.Text, extddlCaseType.Text);
                grdForReport.DataBind();
            }
            else
            {
                grdAllReports.DataSource = _reportBO.GetAllReportsCase("SP_REPORT_GET_PAYMENTS", txtFromDate.Text, txtToDate.Text, txtCompanyID.Text, extddlCaseType.Text);
                grdAllReports.DataBind();

                grdForReport.DataSource = _reportBO.GetAllReportsCase("SP_REPORT_GET_PAYMENTS", txtFromDate.Text, txtToDate.Text, txtCompanyID.Text, extddlCaseType.Text);
                grdForReport.DataBind();
            }
        }
        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());
        }
    }
    protected void BindGrid_DisplayDiagonosisCode(ArrayList p_objAL)
    {
        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());
        }
        this._reportBO = new Bill_Sys_ReportBO();
        try
        {
            this.grdDisplayDiagonosisCode.DataSource = this._reportBO.getAssociatedDiagnosisCode(p_objAL);
            this.grdDisplayDiagonosisCode.DataBind();
            ScriptManager.RegisterStartupScript(this, base.GetType(), "starScript", "showDisplayDiagnosisCodePopup();", true);
        }
        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());
        }
    }
Пример #7
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string selecttedrdb = Request.QueryString["selectedvalue"].ToString();

        if (selecttedrdb == "0")
        {
            if (Request.QueryString["PomID"] != null)
            {
                pomid = Request.QueryString["PomID"].ToString();

                companyid = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
                Bill_Sys_ReportBO _objReport = new Bill_Sys_ReportBO();
                DataSet           dsBillView = _objReport.GetBillDetails(pomid, companyid);
                grdPaymentTransaction.DataSource = dsBillView;
                grdPaymentTransaction.DataBind();
                //ModalPopupExtender1.Show();
            }
        }
        else
        {
            if (Request.QueryString["PomID"] != null)
            {
                pomid     = Request.QueryString["PomID"].ToString();
                companyid = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
                Bill_Sys_ReportBO _objReport = new Bill_Sys_ReportBO();
                DataSet           dsBillView = _objReport.GetBillDetailsOther(pomid, companyid);
                grdPaymentTransaction.DataSource = dsBillView;
                grdPaymentTransaction.DataBind();
                //ModalPopupExtender1.Show();
            }
        }
    }
 protected void extddlSpeciality_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (extddlSpeciality.Text != "NA")
     {
         lblProcedureCode.Visible = true;
         ddlProcedureCode.Visible = true;
         _reportBO = new Bill_Sys_ReportBO();
         DataSet DS = new DataSet();
         DS = _reportBO.GetProcedureCode(txtCompanyID.Text, extddlSpeciality.Text);
         ddlProcedureCode.DataSource     = DS;
         ddlProcedureCode.DataValueField = "Code";
         ddlProcedureCode.DataTextField  = "Description";
         ddlProcedureCode.DataBind();
         ListItem objTest = new ListItem();
         objTest.Text  = "--- Select ---";
         objTest.Value = "NA";
         ddlProcedureCode.Items.Insert(0, objTest);
     }
     else
     {
         ddlProcedureCode.SelectedIndex = 0;
         lblProcedureCode.Visible       = false;
         ddlProcedureCode.Visible       = false;
         lblProcedureDesc.Visible       = false;
         lstProcedureDesc.Visible       = false;
     }
 }
    private void BindGrid()
    {
        _reportBO = new Bill_Sys_ReportBO();
        try
        {
            if (extddlLocation.Visible == true && extddlLocation.Text != "NA")
            {
                grdAllReports.DataSource = _reportBO.GetAllReports("SP_REPORT_GET_UNBILLED_PROCEDURES", txtFromDate.Text, txtToDate.Text, txtCompanyID.Text, extddlLocation.Text);
                grdAllReports.DataBind();

                grdForReport.DataSource = _reportBO.GetAllReports("SP_REPORT_GET_UNBILLED_PROCEDURES", txtFromDate.Text, txtToDate.Text, txtCompanyID.Text, extddlLocation.Text);
                grdForReport.DataBind();
            }
            else
            {
                grdAllReports.DataSource = _reportBO.GetAllReports("SP_REPORT_GET_UNBILLED_PROCEDURES", txtFromDate.Text, txtToDate.Text, txtCompanyID.Text);
                grdAllReports.DataBind();

                grdForReport.DataSource = _reportBO.GetAllReports("SP_REPORT_GET_UNBILLED_PROCEDURES", txtFromDate.Text, txtToDate.Text, txtCompanyID.Text);
                grdForReport.DataBind();
            }
        }
        catch (Exception ex)
        {
            string strError = ex.Message.ToString();
            strError = strError.Replace("\n", " ");
            Response.Redirect("Bill_Sys_ErrorPage.aspx?ErrMsg=" + strError);
        }
    }
Пример #10
0
    protected void Page_Load(object sender, EventArgs e)
    {//Logging Start
        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());
        }
        try
        {
            if (!IsPostBack)
            {
                txtCompanyID.Text        = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
                extddlDoctor.Flag_ID     = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
                extddlSpeciality.Flag_ID = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
                _reportBO = new Bill_Sys_ReportBO();



                //extddlSpeciality.Text = _reportBO.getTop1Speciality(txtCompanyID.Text);
                //if (Session["SELECTED_PROC_CODE"] != null)
                //{
                //    extddlSpeciality.Text = Session["SELECTED_PROC_CODE"].ToString();
                //    Session["SELECTED_PROC_CODE"] = null;
                //}
                //if ((((Bill_Sys_SystemObject)Session["SYSTEM_OBJECT"]).SZ_LOCATION == "1"))
                //{
                //    extddlLocation.Visible = true;
                //    lblLocationName.Visible = true;
                //    extddlLocation.Flag_ID = txtCompanyID.Text.ToString();
                //}
                //BindGrid();
            }
        }
        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);
        }
        #region "check version readonly or not"
        string app_status = ((Bill_Sys_BillingCompanyObject)Session["APPSTATUS"]).SZ_READ_ONLY.ToString();
        if (app_status.Equals("True"))
        {
            Bill_Sys_ChangeVersion cv = new Bill_Sys_ChangeVersion(this.Page);
            cv.MakeReadOnlyPage("Bill_Sys_UnbilledVisits.aspx");
        }
        #endregion

        //Method End
        using (Utils utility = new Utils())
        {
            utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
        }
    }
Пример #11
0
    private void BindGridQueryString(string szFlag)
    {
        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());
        }
        this.txtVisit.Text          = this.drpdown_Documents.SelectedValue.ToString();
        this.ReceivedReport.Visible = true;
        this.txtireortreceive.Text  = szFlag;
        this.grdpaidbills.XGridBindSearch();
        this.grdpaidbills.Visible = true;
        this.btnnext.Visible      = true;
        this._reportBO            = new Bill_Sys_ReportBO();
        try
        {
            new Bill_Sys_ProcedureCode_BO();
            if (this.objSessionSystem.SZ_SHOW_PROCEDURE_CODE_ON_INTEGRATION != "1")
            {
                this.btnnext.Visible = true;
                this.grdpaidbills.Columns[0].Visible    = true;
                this.grdpaidbills.Columns[0x15].Visible = false;
                this.drpdown_Documents.Visible          = false;
            }
            else
            {
                this.btnnext.Visible = false;
                this.grdpaidbills.Columns[0].Visible    = false;
                this.grdpaidbills.Columns[0x15].Visible = true;
                this.drpdown_Documents.Visible          = true;
            }
            if (this.Session["SORT_DS"] != null)
            {
                this.Session["SORT_DS"] = null;
                this.Session["SORT_DS"] = this._reportBO.GetProcedureReports("SP_DASH_BOARD_PROCEDURE_REPORT", "", "", "NA", "NA", this.txtCompanyid.Text, szFlag);
            }
            else
            {
                this.Session["SORT_DS"] = this._reportBO.GetProcedureReports("SP_DASH_BOARD_PROCEDURE_REPORT", "", "", "NA", "NA", this.txtCompanyid.Text, szFlag);
            }
        }
        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(txtPatientName.Text);
            arrlst.Add(txtCaseNo.Text);
            // arrlst.Add(((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_ID);
            arrlst.Add(txtChkFromDate.Text);
            arrlst.Add(txtChkToDate.Text);
            arrlst.Add(txtChkNumber.Text);
            arrlst.Add(txtChkAmount.Text);
            DataSet ds = new DataSet();
            ds = _reportBO.GetMiscPaymentDetails(arrlst);
            grdPayment.DataSource = ds;
            grdPayment.DataBind();

            grdExcelMiscPayment.DataSource = ds;
            grdExcelMiscPayment.DataBind();
            Session["Excelgrid"] = ds;
            if (ds.Tables[0].Rows.Count > 0)
            {
                SumCheckAmount();
            }
            else
            {
                lblChkAmountvalue.Visible = false;
                lblChkAmount.Visible      = false;
            }
        }
        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());
        }
        try
        {
            string            sz_speciality = Session["PR_SZ_PROCEDURE_GROUP"].ToString();
            DataSet           dset          = new DataSet();
            Bill_Sys_ReportBO _objReportBO  = new Bill_Sys_ReportBO();
            if (Session["Case_Type"] == null || Session["Case_Type"] == "")
            {
                if ((((Bill_Sys_SystemObject)Session["SYSTEM_OBJECT"]).SZ_LOCATION == "1") && Session["Location_Id"] != "")
                {
                    dset = _objReportBO.GetReportByReport(txtCompanyID.Text, sz_speciality, Session["Location_Id"].ToString());
                }
                else
                {
                    dset = _objReportBO.GetReportByReport(txtCompanyID.Text, sz_speciality);
                }
            }
            if (Session["Case_Type"] != null && Session["Case_Type"] != "")
            {
                Bill_Sys_ReportBO objCaseType = new Bill_Sys_ReportBO();
                ArrayList         arrlst      = new ArrayList();
                arrlst.Add(txtCompanyID.Text);
                arrlst.Add(sz_speciality);
                arrlst.Add(Session["Location_Id"].ToString());
                arrlst.Add(Session["Case_Type"].ToString());
                //DataSet dsCaseType = new DataSet();
                dset = objCaseType.GetCaseTypeReport(arrlst);
            }

            grdPayment.DataSource = dset.Tables[0];
            grdPayment.DataBind();
        }
        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
        {
            DataTable dt = new DataTable();
            DataSet   ds = new DataSet();



            txtCompanyId.Text  = (((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
            txtOfficeId.Text   = Session["SZ_OFFICE_ID"].ToString();
            txtFromDate.Text   = Session["sz_From_Date"].ToString();
            txtToDate.Text     = Session["sz_To_Date"].ToString();
            txtOffice.Text     = Session["sz_Office_Id_Text"].ToString();
            txtLocationId.Text = Session["SZ_LOCATION_id"].ToString();


            //grdPayment.XGridDatasetNumber = 2;
            grdPayment.XGridBindSearch();
            //dt = (DataTable)grdPayment.XGridDataset;

            //if (dt.Rows.Count > 0)
            //{
            //    DataTable dt1 = new DataTable();
            //    dt1 = GetSumOfAmount(dt);
            //    DataView dv = new DataView(dt1);
            //    grdPayment.DataSource = dv;
            //    grdPayment.DataBind();
            //}
        }
        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());
        }
    }
Пример #15
0
    private void SearchList()
    {
        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());
        }
        _listOperation = new ListOperation();
        _reportBO      = new Bill_Sys_ReportBO();
        try
        {
            DataSet objDT = new DataSet();
            if ((((Bill_Sys_SystemObject)Session["SYSTEM_OBJECT"]).SZ_LOCATION == "1"))
            {
                DataTable objDTL = new DataTable();
                objDT  = _reportBO.GetPatientVisitSummary("SP_PATIENT_VISIT_SUMMARY_REPORT", txtCompanyID.Text);
                objDTL = DisplayLocationInGrid(objDT);
                grdCaseMaster.DataSource = objDTL;
                grdCaseMaster.DataBind();
                for (int i = 0; i < grdCaseMaster.Items.Count; i++)
                {
                    string str = grdCaseMaster.Items[i].Cells[2].Text.ToString();
                    str = str.ToString().Trim();
                    if (str.ToString().Trim() == "&nbsp;")
                    {
                        ((CheckBox)grdCaseMaster.Items[i].Cells[0].FindControl("chkSelect")).Visible = false;
                    }
                }
            }
            else
            {
                _listOperation.WebPage  = this.Page;
                _listOperation.Xml_File = "SearchCase.xml";
                _listOperation.LoadList();
            }
        }
        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());
        }
    }
Пример #16
0
    protected void btnSetLitigate_Click(object sender, EventArgs e)
    {
        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());
        }
        string _checkID     = "";
        string _listCheckID = "";
        int    _flag        = 1;
        string _billNumber  = "";
        string _billNoList  = "";

        _reportBO = new Bill_Sys_ReportBO();


        try
        {
            foreach (DataGridItem dgi in grdVerification.Items)
            {
                if (((CheckBox)dgi.FindControl("chkSelect")).Checked)
                {
                    _billNumber = _billNumber + "'" + dgi.Cells[2].Text + "',";
                }
            }

            _billNoList = _billNumber.Substring(0, _billNumber.Length - 1);
            ArrayList _arrlist = new ArrayList();
            _arrlist.Add(_billNoList);
            _arrlist.Add(txtCompanyID.Text);
            _arrlist.Add(_flag);

            _reportBO.setLitigate(_arrlist);

            BindGrid();
        }
        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());
        }
    }
Пример #17
0
    private 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
        {
            if (extddlLocation.Visible == true && extddlLocation.Text != "NA")
            {
                grdAllReports.DataSource = _reportBO.GetProcedureReports("SP_REPORT_PROCEDURE_REPORT", txtFromDate.Text, txtToDate.Text, extddlOffice.Text, ddlStatus.SelectedValue, txtCompanyID.Text, "", extddlLocation.Text);
                grdAllReports.DataBind();


                grdForReport.DataSource = _reportBO.GetProcedureReports("SP_REPORT_PROCEDURE_REPORT", txtFromDate.Text, txtToDate.Text, extddlOffice.Text, ddlStatus.SelectedValue, txtCompanyID.Text, "", extddlLocation.Text);
                grdForReport.DataBind();
            }
            else
            {
                grdAllReports.DataSource = _reportBO.GetProcedureReports("SP_REPORT_PROCEDURE_REPORT", txtFromDate.Text, txtToDate.Text, extddlOffice.Text, ddlStatus.SelectedValue, txtCompanyID.Text, "", "");
                grdAllReports.DataBind();


                grdForReport.DataSource = _reportBO.GetProcedureReports("SP_REPORT_PROCEDURE_REPORT", txtFromDate.Text, txtToDate.Text, extddlOffice.Text, ddlStatus.SelectedValue, txtCompanyID.Text, "", "");
                grdForReport.DataBind();
            }

            if (((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).BT_REFERRING_FACILITY == false)
            {
                grdAllReports.Columns[5].Visible = false;
                grdForReport.Columns[5].Visible  = false;
            }
        }
        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());
        }
    }
    private void BindTransportName()
    {
        string            szCmpId         = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID.ToString();
        Bill_Sys_ReportBO objReport       = new Bill_Sys_ReportBO();
        DataSet           dsTransportName = new DataSet();

        dsTransportName                 = objReport.GetTransportName(szCmpId);
        ddlTransportName.DataSource     = dsTransportName.Tables[0];
        ddlTransportName.DataTextField  = "SZ_TARNSPOTATION_COMPANY_NAME";
        ddlTransportName.DataValueField = "I_TARNSPOTATION_ID";
        ddlTransportName.DataBind();
        ddlTransportName.Items.Insert(0, "--Selecte--");
    }
    protected void BindGrid()
    {//Logging Start
        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();
        ArrayList objAL = new ArrayList();

        try
        {
            objAL.Add(Session["sz_StatusID"].ToString());
            objAL.Add(Session["sz_DoctorID"].ToString());
            objAL.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
            objAL.Add(txtSearchOrder.Text);
            objAL.Add(Session["sz_Location_Id"].ToString());
            objAL.Add(Session["SZ_PROCEDURE_ID"].ToString());
            grdBillReportDetails.DataSource = getBillReportDetails(objAL);
            grdBillReportDetails.DataBind();
            grdBillReportDetails.Columns[17].Visible = false;
            grdBillReportDetails.Columns[18].Visible = false;
            grdBillReportDetails.Columns[19].Visible = false;
            Decimal toatal = 0;
            foreach (DataGridItem dg in grdBillReportDetails.Items)
            {
                if (dg.Cells[11].Text != "&nbsp;")
                {
                    toatal = toatal + Convert.ToDecimal(dg.Cells[11].Text);
                }
            }
            lblTotal.Text = toatal.ToString();
        }
        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());
        }
    }
    private 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());
        }
        try
        {
            string providerID = "";
            int    billStatus = 0;
            string fromDate   = "";
            string toDate     = "";
            if (extddlProvider.Text != "NA" && extddlProvider.Text != "")
            {
                providerID = extddlProvider.Text;
            }
            if (ddlBillStatus.SelectedValue != "0")
            {
                billStatus = Convert.ToInt32(ddlBillStatus.SelectedValue);
            }
            if (txtFromDate.Text != "")
            {
                fromDate = txtFromDate.Text;
            }
            if (txtToDate.Text != "")
            {
                toDate = txtToDate.Text;
            }
            _bill_Sys_ReportBO       = new Bill_Sys_ReportBO();
            grdBillSearch.DataSource = _bill_Sys_ReportBO.GET_Provider_BILLS(providerID, billStatus, fromDate, toDate, ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID).Tables[0];
            grdBillSearch.DataBind();
        }
        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());
        }
    }
Пример #21
0
 private void BindBillsGrid(string szFlag)
 {
     this.PaidBills.Visible     = true;
     this.txtireortreceive.Text = szFlag;
     if (this.objSessionBillingCompany.BT_REFERRING_FACILITY)
     {
         this.grdBills.Columns[4].SortExpression = "MST_PATIENT.I_RFO_CHART_NO";
     }
     else
     {
         this.grdBills.Columns[4].SortExpression = "MST_PATIENT.SZ_CHART_NO";
     }
     this.grdBills.XGridBindSearch();
     this.grdBills.Visible = true;
     this._reportBO        = new Bill_Sys_ReportBO();
 }
Пример #22
0
    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());
        }
        try
        {
            DataSet   dataSet    = new DataSet();
            ArrayList arrayLists = new ArrayList();
            arrayLists.Add(this.txtCompanyID.Text);
            arrayLists.Add(this.txtFromDate.Text);
            arrayLists.Add(this.txtPatientName.Text.ToString().Trim());
            arrayLists.Add(this.txtCaseNo.Text.ToString().Trim());
            arrayLists.Add(this.extddlAttorney.Text);
            arrayLists.Add(this.extddlCaseStatus.Text);
            arrayLists.Add(this.extddlCaseType.Text);
            arrayLists.Add(this.extddlInsuranceCompany.Text);
            this._reportBO             = new Bill_Sys_ReportBO();
            dataSet                    = this._reportBO.Get_Attorney_Report(arrayLists);
            this.grdPayment.DataSource = dataSet;
            this.grdPayment.DataBind();
            this.grdExcel.DataSource = dataSet;
            this.grdExcel.DataBind();
            this.Session["DataBind"] = dataSet;
        }
        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());
        }
    }
Пример #23
0
    public void BindGrid()
    {
        Bill_Sys_ReportBO objReport = new Bill_Sys_ReportBO();
        DataSet           dsReport  = new DataSet();

        if (extddlSpeciality.Text.Equals("NA"))
        {
            dsReport = objReport.GetPOM_Report(txtFromBillDate.Text, txtToBillDate.Text, txtFromServiceDate.Text, txtToServiceDate.Text, txtFromPrintedDate.Text, txtToPrintedDate.Text, txtFromRecDate.Text, txtToRecDate.Text, txtBillNo.Text, "NA", txtPatientName.Text, txtCompanyID.Text, txtBillNo.Text, txtPatientName.Text);
        }
        else
        {
            dsReport = objReport.GetPOM_Report(txtFromBillDate.Text, txtToBillDate.Text, txtFromServiceDate.Text, txtToServiceDate.Text, txtFromPrintedDate.Text, txtToPrintedDate.Text, txtFromRecDate.Text, txtToRecDate.Text, txtBillNo.Text, extddlSpeciality.Text, txtPatientName.Text, txtCompanyID.Text, txtBillNo.Text, txtPatientName.Text);
        }
        Session["POMReport"]    = dsReport;
        grdPomReport.DataSource = dsReport.Tables[0];
        //  grdExel.DataSource = dsReport.Tables[0];
        //  grdExel.DataBind();
        grdPomReport.DataBind();
    }
    protected void OnextendDropDown_SelectedIndexChanged(object sender, EventArgs e)
    {
        lstNodeDescription.Items.Clear();
        _Bill_Sys_ReportBO = new Bill_Sys_ReportBO();
        DataSet ds = new DataSet();

        _Notification = new mbs.bl.litigation.Notification();
        ds            = _Notification.GetNodeDescForMissingNotification(txtCompanyID.Text, extddlGroup.Text);

        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            ListItem lt = new ListItem();
            lt.Text  = ds.Tables[0].Rows[i][0].ToString();
            lt.Value = ds.Tables[0].Rows[i][1].ToString();
            lstNodeDescription.Items.Add(lt);
        }
        for (int j = 0; j < lstNodeDescription.Items.Count; j++)
        {
            lstNodeDescription.Items[j].Selected = true;
        }
    }
Пример #25
0
    protected void Page_Load(object sender, EventArgs e)
    {
        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());
        }
        try
        {
            if (!base.IsPostBack)
            {
                this.txtCompanyID.Text        = ((Bill_Sys_BillingCompanyObject)this.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
                this.extddlDoctor.Flag_ID     = ((Bill_Sys_BillingCompanyObject)this.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
                this.extddlSpeciality.Flag_ID = ((Bill_Sys_BillingCompanyObject)this.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
                this.extddlCaseType.Flag_ID   = ((Bill_Sys_BillingCompanyObject)this.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
                this._reportBO = new Bill_Sys_ReportBO();
            }
        }
        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);
        }

        if (((Bill_Sys_BillingCompanyObject)this.Session["APPSTATUS"]).SZ_READ_ONLY.ToString().Equals("True"))
        {
            (new Bill_Sys_ChangeVersion(this.Page)).MakeReadOnlyPage("Bill_Sys_UnbilledVisits.aspx");
        }
        //Method End
        using (Utils utility = new Utils())
        {
            utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
        }
    }
    protected void ddlProcedureCode_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (!ddlProcedureCode.SelectedItem.ToString().Equals("--- Select ---"))
        {
            lblProcedureDesc.Visible = true;
            lstProcedureDesc.Visible = true;
            _reportBO = new Bill_Sys_ReportBO();
            DataSet DS = new DataSet();

            DS = _reportBO.GetProcedureDesc(txtCompanyID.Text, ddlProcedureCode.SelectedItem.ToString());
            lstProcedureDesc.DataSource     = DS;
            lstProcedureDesc.DataTextField  = DS.Tables[0].Columns[0].ToString();
            lstProcedureDesc.DataValueField = DS.Tables[0].Columns[1].ToString();
            lstProcedureDesc.DataBind();
        }
        else
        {
            ddlProcedureCode.SelectedIndex = 0;
            lblProcedureDesc.Visible       = false;
            lstProcedureDesc.Visible       = false;
        }
    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        txtSort.Text = "";
        int i = new int();

        //bind grid according  Search  condition
        if (!txtFromDate.Text.Trim().Equals("") && !txtToDate.Text.Trim().Equals(""))
        {
            i = DateTime.Compare(Convert.ToDateTime(txtToDate.Text), Convert.ToDateTime(txtFromDate.Text));
        }
        if (i.Equals(1) || i.Equals(0))
        {
            string            szCmpId       = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID.ToString();
            Bill_Sys_ReportBO objReport     = new Bill_Sys_ReportBO();
            DataSet           dsOfficeName1 = new DataSet();
            dsOfficeName1 = objReport.GetReceived_Report(szCmpId, txtFromDate.Text, txtToDate.Text, txtPatientName.Text, ddlOffice.SelectedValue);
            #region " default viwe of grid sor by ascending order of date"
            DataView dv2;
            dv2      = dsOfficeName1.Tables[0].DefaultView;
            dv2.Sort = "DATE_OF_REFERRAL_PROC ,PATIENT_NAME ASC";

            grdReceivedeport.DataSource = dv2;
            grdExel.DataSource          = dv2;
            Session["OfficeData"]       = dsOfficeName1;
            grdReceivedeport.DataBind();
            grdExel.DataBind();

            if ((((Bill_Sys_SystemObject)Session["SYSTEM_OBJECT"]).SZ_CHART_NO != "1"))
            {
                grdReceivedeport.Columns[2].Visible = false;
                grdExel.Columns[2].Visible          = false;
            }
            #endregion
        }
        else
        {
            lblMsg.Text = " To date must be greater than From date";
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        lblMsg.Text = "";
        if (!IsPostBack)
        { ///bind grid
            string            szCmpId      = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID.ToString();
            Bill_Sys_ReportBO objReport    = new Bill_Sys_ReportBO();
            DataSet           dsReport     = new DataSet();
            string            strStartTime = "00.00";
            string            strEndTime   = "00.00";

            dsReport = objReport.GetTransportSearchReport(szCmpId, "", "", "00.00", "", "00.00", "", "--Selecte--");
            grdAllReports.DataSource = dsReport.Tables[0];
            grdReports.DataSource    = dsReport.Tables[0];
            grdAllReports.DataBind();
            grdReports.DataBind();
            Session["ViewData"] = dsReport;
            ///bind time DropDownList
            BindTransportName();
            BindTimeControl();
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        btnRevert.Attributes.Add("onclick", "return ChekOne();");
        lblMsg.Text = "";
        if (!IsPostBack)
        {//bind office name to ddlOffice
            DataSet           dsOfficeName = new DataSet();
            string            szCmpId      = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID.ToString();
            Bill_Sys_ReportBO objReport    = new Bill_Sys_ReportBO();
            dsOfficeName             = objReport.GetOfficeName(szCmpId);
            ddlOffice.DataSource     = dsOfficeName.Tables[0];
            ddlOffice.DataTextField  = "SZ_OFFICE";
            ddlOffice.DataValueField = "SZ_OFFICE_ID";
            ddlOffice.DataBind();
            ddlOffice.Items.Insert(0, "--select--");
            //bind gride
            DataSet dsOfficeName1 = new DataSet();
            dsOfficeName1 = objReport.GetReceived_Report(szCmpId, "", "", "", "--select--");


            #region " default viwe of grid sor by ascending order of date"
            DataView dv1;
            dv1      = dsOfficeName1.Tables[0].DefaultView;
            dv1.Sort = "DATE_OF_REFERRAL_PROC,PATIENT_NAME ASC";
            grdReceivedeport.DataSource = dv1;
            grdExel.DataSource          = dv1;
            Session["OfficeData"]       = dsOfficeName1;
            grdReceivedeport.DataBind();
            grdExel.DataBind();

            #endregion
            if ((((Bill_Sys_SystemObject)Session["SYSTEM_OBJECT"]).SZ_CHART_NO != "1"))
            {
                grdReceivedeport.Columns[2].Visible = false;
                grdExel.Columns[2].Visible          = false;
            }
        }
    }
    protected void btnRevert_Click(object sender, EventArgs e)
    {
        //revert the recored
        for (int j = 0; j < grdReceivedeport.Items.Count; j++)
        {
            CheckBox chkDelete1 = (CheckBox)grdReceivedeport.Items[j].FindControl("chkUpdateStatus");
            if (chkDelete1.Checked)
            {
                Bill_Sys_ReportBO objUpdateReport = new Bill_Sys_ReportBO();
                objUpdateReport.RevertReport(Convert.ToInt32(grdReceivedeport.Items[j].Cells[10].Text.Trim().ToString()));
            }
        }



        //binding grid agin whith new value
        string            szCmpId       = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID.ToString();
        Bill_Sys_ReportBO objReport     = new Bill_Sys_ReportBO();
        DataSet           dsOfficeName1 = new DataSet();

        dsOfficeName1 = objReport.GetReceived_Report(szCmpId, txtFromDate.Text, txtToDate.Text, txtPatientName.Text, ddlOffice.SelectedValue);

        DataView dv1;

        dv1      = dsOfficeName1.Tables[0].DefaultView;
        dv1.Sort = "DATE_OF_REFERRAL_PROC,PATIENT_NAME ASC";

        grdReceivedeport.DataSource = dv1;
        grdExel.DataSource          = dv1;
        Session["OfficeData"]       = dsOfficeName1;
        grdReceivedeport.DataBind();
        grdExel.DataBind();
        if ((((Bill_Sys_SystemObject)Session["SYSTEM_OBJECT"]).SZ_CHART_NO != "1"))
        {
            grdReceivedeport.Columns[2].Visible = false;
            grdExel.Columns[2].Visible          = false;
        }
    }