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