protected void ASPxComboBoxddlReadingddlDoctor_SelectedIndexChanged(object sender, EventArgs e) { Bill_Sys_Billing_Provider _Bill_Sys_Billing_Provider = new Bill_Sys_Billing_Provider(); DataSet dsreadingdoctorlist = new DataSet(); string szdoctorname = ddlReadingddlDoctor.Text; string[] szDoctorId = szdoctorname.Split('-'); string szalldoctorids = szDoctorId[0]; dsreadingdoctorlist = _Bill_Sys_Billing_Provider.GetAllDoctorList(szalldoctorids, txtCompanyID.Text); lstReadingdoctor.DataTextField = "DESCRIPTION"; lstReadingdoctor.DataValueField = "CODE"; lstReadingdoctor.DataSource = dsreadingdoctorlist; lstReadingdoctor.DataBind(); btnUpdate.Enabled = false; for (int cntLst = 0; cntLst < lstReadingdoctor.Items.Count; cntLst++) { for (int i = 0; i < dsreadingdoctorlist.Tables[0].Rows.Count; i++) { if (dsreadingdoctorlist.Tables[0].Rows[i]["CODE"].ToString() == lstReadingdoctor.Items[cntLst].Value.ToString()) { lstReadingdoctor.Items[cntLst].Selected = true; } } } }
protected void btnUpdate_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()); } Bill_Sys_Billing_Provider _Bill_Sys_Billing_Provider = new Bill_Sys_Billing_Provider(); btnsave.Enabled = true; try { if (ddlReadingddlDoctor.Value != null) { if (ddlInsurance.Value != null) { if (ddlCaseType.Value != null) { if (lstReadingdoctor.SelectedItem != null) { for (int cntLst = 0; cntLst < lstReadingdoctor.Items.Count; cntLst++) { if (lstReadingdoctor.Items[cntLst].Selected == true) { _Bill_Sys_Billing_Provider.UpdateExcludingBill(txtCompanyID.Text, lstReadingdoctor.Items[cntLst].Value.ToString(), lstReadingdoctor.Items[cntLst].Text, ddlInsurance.Value.ToString(), ddlInsurance.Text, ddlCaseType.Value.ToString(), ddlCaseType.Text); } } } DataSet ds = new DataSet(); ds = _Bill_Sys_Billing_Provider.GetExcludingBillDeatils(txtCompanyID.Text); grdexcludingbill.DataSource = ds; grdexcludingbill.DataBind(); ClearControl(); usrMessage.PutMessage("Update Successfully ...!"); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage.Show(); } } } btnUpdate.Enabled = false; ddlReadingddlDoctor.Enabled = 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()); } }
protected void btnDelete_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()); } btnUpdate.Enabled = false; ddlReadingddlDoctor.Enabled = true; Bill_Sys_Billing_Provider _Bill_Sys_Billing_Provider = new Bill_Sys_Billing_Provider(); try { string szdoctorname = Convert.ToString(grdexcludingbill.GetRowValues(grdexcludingbill.FocusedRowIndex, "SZ_READING_DOCTOR")); string[] szDoctorId = szdoctorname.Split('-'); string szDoctorname = szDoctorId[0]; for (int i = 0; i < grdexcludingbill.VisibleRowCount; i++) { ASPxGridView _ASPxGridView = (ASPxGridView)grdid.FindControl("grdexcludingbill"); GridViewDataColumn c = (GridViewDataColumn)grdexcludingbill.Columns[9]; CheckBox checkBox = (CheckBox)grdexcludingbill.FindRowCellTemplateControl(i, c, "chkall"); if (checkBox != null) { if (checkBox.Checked) { //_Bill_Sys_Billing_Provider.RemoveexcludingBill(txtCompanyID.Text, Convert.ToString(grdexcludingbill.GetRowValues(i, "SZ_READING_DOCTOR_ID")), Convert.ToString(grdexcludingbill.GetRowValues(i, "SZ_INSURANCE_ID")), Convert.ToString(grdexcludingbill.GetRowValues(i, "SZ_CASE_TYPE_ID"))); _Bill_Sys_Billing_Provider.RemoveexcludingBill(szDoctorname, txtCompanyID.Text); ClearControl(); usrMessage.PutMessage("Delete Successfully ...!"); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage.Show(); } } } DataSet ds = new DataSet(); ds = _Bill_Sys_Billing_Provider.GetExcludingBillDeatils(txtCompanyID.Text); grdexcludingbill.DataSource = ds; grdexcludingbill.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); } btnsave.Enabled = true; //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void btnRemove_Click(object sender, EventArgs e) { string szcasetypid = Convert.ToString(grdbillingprovider.GetRowValues(grdbillingprovider.FocusedRowIndex, "SZ_CASE_TYPE_ID")); Bill_Sys_Billing_Provider _Bill_Sys_Billing_Provider = new Bill_Sys_Billing_Provider(); _Bill_Sys_Billing_Provider.RemoveBillingaddresscasetype(txtCompanyID.Text, szcasetypid, txtofficeid.Text); ClearControl(); usrMessage.PutMessage("Billing Provider Delete Successfully ...!"); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage.Show(); }
protected void btnSave_Click(object sender, EventArgs e) { Bill_Sys_Billing_Provider _Bill_Sys_Billing_Provider = new Bill_Sys_Billing_Provider(); string szcasetypid = Convert.ToString(grdbillingprovider.GetRowValues(grdbillingprovider.FocusedRowIndex, "SZ_CASE_TYPE_ID")); _Bill_Sys_Billing_Provider.AddBillingaddress(txtCompanyID.Text, szcasetypid, txtbillingprovideraddress.Text, txtbillingprovidercity.Text, txtofficeid.Text, txtproviderbillingname.Text, txtbillingproviderphone.Text, extddlBillingProviderState.Text, txtbillingproviderzip.Text, txtbillingproviderfax.Text); ClearControl(); usrMessage.PutMessage("Billing Provider Saved Successfully ...!"); usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage); usrMessage.Show(); }
protected void btnReportSearch_Click(object sender, EventArgs e) { Bill_Sys_Billing_Provider _Bill_Sys_Billing_Provider = new Bill_Sys_Billing_Provider(); DataSet dsShowgrandTotal = new DataSet(); string szofficeid = ""; if (lstprovidernamename.SelectedItem != null) { bool flagc = false; for (int cntLst = 0; cntLst < lstprovidernamename.Items.Count; cntLst++) { if (lstprovidernamename.Items[cntLst].Selected == true) { flagc = true; } if (flagc == true) { if (lstprovidernamename.Items[cntLst].Selected == true) { if (szofficeid == "") { szofficeid = "'" + lstprovidernamename.Items[cntLst].Value.ToString() + "'"; } else { szofficeid = szofficeid + "," + "'" + lstprovidernamename.Items[cntLst].Value.ToString() + "'"; } } } } dsShowgrandTotal = _Bill_Sys_Billing_Provider.getGrandTotal(szofficeid, txtCompanyID.Text, txtcaseid.Text); grdGrandTotals.DataSource = dsShowgrandTotal; grdGrandTotals.DataBind(); Session["dsShowProvider"] = dsShowgrandTotal; sdsCompanyMaster.SelectCommand = "SP_GET_OFFICE_SUMMARY"; sdsCompanyMaster.DataSourceMode = SqlDataSourceMode.DataSet; sdsCompanyMaster.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; sdsCompanyMaster.SelectParameters.Clear(); sdsCompanyMaster.SelectParameters.Add("SZ_OFFICE_ID", DbType.String, szofficeid); sdsCompanyMaster.SelectParameters.Add("SZ_COMPANY_ID", DbType.String, txtCompanyID.Text); sdsCompanyMaster.SelectParameters.Add("SZ_CASE_ID", DbType.String, txtcaseid.Text); gridprovider.DataSource = sdsCompanyMaster; gridprovider.DataBind(); DataSet dscasenotes = new DataSet(); dscasenotes = _Bill_Sys_Billing_Provider.getCaseNotes(szofficeid, txtCompanyID.Text, txtcaseid.Text); grdccasenotes.DataSource = dscasenotes; grdccasenotes.DataBind(); Session["dscasenotes"] = dscasenotes; } }
protected void Page_Load(object sender, EventArgs e) { string szofficeid = Request.QueryString["szofficeid"].ToString(); txtofficeid.Text = szofficeid; txtCompanyID.Text = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; if (!IsPostBack) { DataSet dsbillingprovider = new DataSet(); Bill_Sys_Billing_Provider _Bill_Sys_Billing_Provider = new Bill_Sys_Billing_Provider(); dsbillingprovider = _Bill_Sys_Billing_Provider.BillingProvider(txtCompanyID.Text); grdbillingprovider.DataSource = dsbillingprovider; grdbillingprovider.DataBind(); tblbillingaddress.Visible = false; tbldefaultgaddress.Visible = false; } }
protected void grdbillingprovider_OnRowCommand(object sender, DevExpress.Web.ASPxGridViewRowCommandEventArgs e) { if (e.CommandArgs.CommandName == "Select") { tblbillingaddress.Visible = true; tbldefaultgaddress.Visible = true; string casetypeid = e.KeyValue.ToString(); object keyValue = grdbillingprovider.GetRowValues(grdbillingprovider.FocusedRowIndex, new string[] { grdbillingprovider.KeyFieldName }); //string szcasetypid=Convert.ToString(grdbillingprovider.GetRowValues(id., "SZ_CASE_TYPE_ID")); Bill_Sys_Billing_Provider _Bill_Sys_Billing_Provider = new Bill_Sys_Billing_Provider(); DataSet dsprovideradd = new DataSet(); dsprovideradd = _Bill_Sys_Billing_Provider.BillingProviderAddress(casetypeid, txtCompanyID.Text, txtofficeid.Text); if (dsprovideradd.Tables.Count > 1) { if (dsprovideradd.Tables[1].Rows.Count > 0) { txtOffice.Text = dsprovideradd.Tables[1].Rows[0]["SZ_OFFICE"].ToString(); txtOfficeAdd.Text = dsprovideradd.Tables[1].Rows[0]["SZ_OFFICE_ADDRESS"].ToString(); txtOfficeCity.Text = dsprovideradd.Tables[1].Rows[0]["SZ_OFFICE_CITY"].ToString(); txtOfficeZip.Text = dsprovideradd.Tables[1].Rows[0]["SZ_OFFICE_ZIP"].ToString(); txtOfficePhone.Text = dsprovideradd.Tables[1].Rows[0]["SZ_OFFICE_PHONE"].ToString(); txtFax.Text = dsprovideradd.Tables[1].Rows[0]["SZ_OFFICE_FAX"].ToString(); extddlOfficeState.Text = dsprovideradd.Tables[1].Rows[0]["SZ_OFFICE_STATE_ID"].ToString(); } } if (dsprovideradd.Tables.Count > 0) { if (dsprovideradd.Tables[0].Rows.Count > 0) { txtbillingprovideraddress.Text = dsprovideradd.Tables[0].Rows[0]["SZ_PROVIDER_ADDRESS"].ToString(); txtproviderbillingname.Text = dsprovideradd.Tables[0].Rows[0]["SZ_PROVIDER_NAME"].ToString(); txtbillingproviderphone.Text = dsprovideradd.Tables[0].Rows[0]["SZ_PROVIDER_PHONE"].ToString(); extddlBillingProviderState.Text = dsprovideradd.Tables[0].Rows[0]["SZ_PROVIDER_STATE"].ToString(); txtbillingproviderzip.Text = dsprovideradd.Tables[0].Rows[0]["SZ_PROVIDER_ZIP"].ToString(); txtbillingprovidercity.Text = dsprovideradd.Tables[0].Rows[0]["SZ_PROVIDER_CITY"].ToString(); txtbillingproviderfax.Text = dsprovideradd.Tables[0].Rows[0]["SZ_PROVIDER_FAX"].ToString(); } else { ClearControl(); } } } }
protected void btnReportSearch_Click(object sender, EventArgs e) { Bill_Sys_Billing_Provider billSysBillingProvider = new Bill_Sys_Billing_Provider(); DataSet dataSet = new DataSet(); string str = ""; if (this.lstprovidernamename.SelectedItem != null) { bool flag = false; for (int i = 0; i < this.lstprovidernamename.Items.Count; i++) { if (this.lstprovidernamename.Items[i].Selected) { flag = true; } if (flag && this.lstprovidernamename.Items[i].Selected) { str = (str != "" ? string.Concat(str, ",'", this.lstprovidernamename.Items[i].Value.ToString(), "'") : string.Concat("'", this.lstprovidernamename.Items[i].Value.ToString(), "'")); } } dataSet = billSysBillingProvider.getGrandTotal(str, this.txtCompanyID.Text, this.txtcaseid.Text); this.grdGrandTotals.DataSource = dataSet; this.grdGrandTotals.DataBind(); this.Session["dsShowProvider"] = dataSet; this.sdsCompanyMaster.SelectCommand = "SP_GET_OFFICE_SUMMARY"; this.sdsCompanyMaster.DataSourceMode = SqlDataSourceMode.DataSet; this.sdsCompanyMaster.SelectCommandType = SqlDataSourceCommandType.StoredProcedure; this.sdsCompanyMaster.SelectParameters.Clear(); this.sdsCompanyMaster.SelectParameters.Add("SZ_OFFICE_ID", DbType.String, str); this.sdsCompanyMaster.SelectParameters.Add("SZ_COMPANY_ID", DbType.String, this.txtCompanyID.Text); this.sdsCompanyMaster.SelectParameters.Add("SZ_CASE_ID", DbType.String, this.txtcaseid.Text); this.gridprovider.DataSource = this.sdsCompanyMaster; this.gridprovider.DataBind(); DataSet caseNotes = new DataSet(); caseNotes = billSysBillingProvider.getCaseNotes(str, this.txtCompanyID.Text, this.txtcaseid.Text); this.grdccasenotes.DataSource = caseNotes; this.grdccasenotes.DataBind(); this.Session["dscasenotes"] = caseNotes; } }
protected void btnUpdate_Click(object sender, EventArgs e) { Bill_Sys_Billing_Provider _Bill_Sys_Billing_Provider = new Bill_Sys_Billing_Provider(); //_Bill_Sys_Billing_Provider.UpdateProvider(txtOfficeCity.Text,txtofficeid.Text,txtCompanyID.Text); //SVN }
protected void grdexcludingbill_RowCommand(object sender, DevExpress.Web.ASPxGridViewRowCommandEventArgs 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()); } btnUpdate.Enabled = true; btnsave.Enabled = false; if (e.CommandArgs.CommandName == "Select") { Bill_Sys_Billing_Provider _Bill_Sys_Billing_Provider = new Bill_Sys_Billing_Provider(); DataSet dsreadingdoctorlist = new DataSet(); string szdoctorname = Convert.ToString(grdexcludingbill.GetRowValues(grdexcludingbill.FocusedRowIndex, "SZ_READING_DOCTOR")); string[] szDoctorId = szdoctorname.Split('-'); string szalldoctorids = szDoctorId[0]; dsreadingdoctorlist = _Bill_Sys_Billing_Provider.GetAllDoctorIDList(szalldoctorids, txtCompanyID.Text); lstReadingdoctor.DataTextField = "DESCRIPTION"; lstReadingdoctor.DataValueField = "CODE"; lstReadingdoctor.DataSource = dsreadingdoctorlist; lstReadingdoctor.DataBind(); btnUpdate.Enabled = true; for (int cntLst = 0; cntLst < lstReadingdoctor.Items.Count; cntLst++) { for (int i = 0; i < dsreadingdoctorlist.Tables[0].Rows.Count; i++) { if (dsreadingdoctorlist.Tables[0].Rows[i]["CODE"].ToString() == lstReadingdoctor.Items[cntLst].Value.ToString()) { lstReadingdoctor.Items[cntLst].Selected = true; } } } ddlReadingddlDoctor.Enabled = false; lstReadingdoctor.Enabled = false; btnremove.Visible = false; //object keyValue = grdexcludingbill.GetRowValues(grdexcludingbill.FocusedRowIndex, new string[] { grdexcludingbill.KeyFieldName }); try { if (Convert.ToString(grdexcludingbill.GetRowValues(grdexcludingbill.FocusedRowIndex, "SZ_READING_DOCTOR_ID")) != " ") { ddlReadingddlDoctor.Text = Convert.ToString(grdexcludingbill.GetRowValues(grdexcludingbill.FocusedRowIndex, "SZ_READING_DOCTOR_ID")); } else { ddlReadingddlDoctor.Text = ""; } if (Convert.ToString(grdexcludingbill.GetRowValues(grdexcludingbill.FocusedRowIndex, "SZ_INSURANCE_ID")) != " ") { ddlInsurance.Text = Convert.ToString(grdexcludingbill.GetRowValues(grdexcludingbill.FocusedRowIndex, "SZ_INSURANCE_ID")); } else { ddlInsurance.Text = ""; } if (Convert.ToString(grdexcludingbill.GetRowValues(grdexcludingbill.FocusedRowIndex, "SZ_CASE_TYPE_ID")) != " ") { ddlCaseType.Text = Convert.ToString(grdexcludingbill.GetRowValues(grdexcludingbill.FocusedRowIndex, "SZ_CASE_TYPE_ID")); } else { ddlCaseType.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()); } }
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 { txtCompanyID.Text = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; btnDelete.Attributes.Add("onclick", "return callfordelete();"); btnsave.Attributes.Add("onclick", "return val_CheckControls();"); btnUpdate.Attributes.Add("onclick", "return val_CheckControls();"); if (!IsPostBack) { DataSet dsReadingddlDoctor = new DataSet(); Bill_Sys_Billing_Provider objDoc = new Bill_Sys_Billing_Provider(); dsReadingddlDoctor = objDoc.GetReadingDoctorList(txtCompanyID.Text); ddlReadingddlDoctor.DataSource = dsReadingddlDoctor; ListEditItem itm1 = new ListEditItem("--Select--", null); ddlReadingddlDoctor.DataBind(); ddlReadingddlDoctor.Items.Insert(0, itm1); DataSet dsInsurance = new DataSet(); Bill_Sys_Billing_Provider objInsurance = new Bill_Sys_Billing_Provider(); dsInsurance = objInsurance.GetInsuranceList(txtCompanyID.Text); ddlInsurance.DataSource = dsInsurance; ListEditItem itminsurance = new ListEditItem("--Select--", null); ddlInsurance.DataBind(); ddlInsurance.Items.Insert(0, itminsurance); DataSet dsCaseType = new DataSet(); Bill_Sys_Billing_Provider objCaseType = new Bill_Sys_Billing_Provider(); dsCaseType = objCaseType.GetCaseTypeList(txtCompanyID.Text); ddlCaseType.DataSource = dsCaseType; ListEditItem itmCaseType = new ListEditItem("--Select--", null); ddlCaseType.DataBind(); ddlCaseType.Items.Insert(0, itmCaseType); Bill_Sys_Billing_Provider _Bill_Sys_Billing_Provider = new Bill_Sys_Billing_Provider(); DataSet ds = new DataSet(); ds = _Bill_Sys_Billing_Provider.GetExcludingBillDeatils(txtCompanyID.Text); grdexcludingbill.DataSource = ds; grdexcludingbill.DataBind(); hdndelete.Value = ""; btnUpdate.Enabled = false; } if (hdndelete.Value != "true") { DataSet ds = new DataSet(); Bill_Sys_Billing_Provider _Bill_Sys_Billing_Provider = new Bill_Sys_Billing_Provider(); ds = _Bill_Sys_Billing_Provider.GetExcludingBillDeatils(txtCompanyID.Text); grdexcludingbill.DataSource = ds; grdexcludingbill.DataBind(); } else { hdndelete.Value = ""; } } 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()); } }