public static string GetPatientDetail(string Parameter)
{
DataSet ds = new SchedularDAO().GetPatientDetail(Parameter, ((Bill_Sys_BillingCompanyObject)HttpContext.Current.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
String resultJson = string.Empty;
resultJson = resultJson + "{";
resultJson = resultJson + "\"SZ_CASE_NO\":" + "\"" + ds.Tables[0].Rows[0]["sz_case_no"] + "\",";
resultJson = resultJson + "\"PATIENT_NAME\":" + "\"" + ds.Tables[0].Rows[0]["PATIENT_NAME"] + "\",";
resultJson = resultJson + "\"DT_DOB\":" + "\"" + ds.Tables[0].Rows[0]["DT_DOB"] + "\",";
resultJson = resultJson + "\"DT_DATE_OF_ACCIDENT\":" + "\"" + ds.Tables[0].Rows[0]["DT_DATE_OF_ACCIDENT"] + "\",";
resultJson = resultJson + "\"SZ_PATIENT_PHONE\":" + "\"" + ds.Tables[0].Rows[0]["SZ_PATIENT_PHONE"] + "\",";
resultJson = resultJson + "\"ATTORNEY_NAME\":" + "\"" + ds.Tables[0].Rows[0]["ATTORNEY_NAME"] + "\",";
resultJson = resultJson + "\"SZ_ATTORNEY_PHONE\":" + "\"" + ds.Tables[0].Rows[0]["sz_attorney_phone"] + "\"";
resultJson = resultJson + "}";
return(resultJson);
//ddlPatient.JSProperties.Add("cpSZ_CASE_NO", ds.Tables[0].Rows[0]["sz_case_no"]);
//ddlPatient.JSProperties.Add("cpPATIENT_NAME", ds.Tables[0].Rows[0]["PATIENT_NAME"]);
//ddlPatient.JSProperties.Add("cpDT_DOB", ds.Tables[0].Rows[0]["DT_DOB"]);
//ddlPatient.JSProperties.Add("cpDT_DATE_OF_ACCIDENT", ds.Tables[0].Rows[0]["DT_DATE_OF_ACCIDENT"]);
//ddlPatient.JSProperties.Add("cpSZ_PATIENT_PHONE", ds.Tables[0].Rows[0]["SZ_PATIENT_PHONE"]);
//ddlPatient.JSProperties.Add("cpATTORNEY_NAME", ds.Tables[0].Rows[0]["ATTORNEY_NAME"]);
//ddlPatient.JSProperties.Add("cpSZ_ATTORNEY_PHONE", ds.Tables[0].Rows[0]["sz_attorney_phone"]);
}
return(string.Empty);
}
private void BindSpecialty()
{
DataSet ds = new SchedularDAO().GetSpecialtyAll(((Bill_Sys_BillingCompanyObject)HttpContext.Current.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
ddlSpeciality.DataSource = ds.Tables[0];
ddlSpeciality.DataBind();
}
private void BindProvider()
{
DataSet ds = new SchedularDAO().GetAllDoctorBySpecialty(ddlSpeciality.Value.ToString(), ((Bill_Sys_BillingCompanyObject)HttpContext.Current.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
ddlProvider.DataSource = ds.Tables[0];
ddlProvider.DataBind();
ddlProvider.SelectedIndex = -1;
}
protected void ddlPatient_Callback(object sender, DevExpress.Web.CallbackEventArgsBase e)
{
DataSet ds = new SchedularDAO().GetPatientDetail(e.Parameter, ((Bill_Sys_BillingCompanyObject)HttpContext.Current.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ddlPatient.JSProperties.Add("cpSZ_CASE_NO", ds.Tables[0].Rows[0]["sz_case_no"]);
ddlPatient.JSProperties.Add("cpPATIENT_NAME", ds.Tables[0].Rows[0]["PATIENT_NAME"]);
ddlPatient.JSProperties.Add("cpDT_DOB", ds.Tables[0].Rows[0]["DT_DOB"]);
ddlPatient.JSProperties.Add("cpDT_DATE_OF_ACCIDENT", ds.Tables[0].Rows[0]["DT_DATE_OF_ACCIDENT"]);
ddlPatient.JSProperties.Add("cpSZ_PATIENT_PHONE", ds.Tables[0].Rows[0]["SZ_PATIENT_PHONE"]);
ddlPatient.JSProperties.Add("cpATTORNEY_NAME", ds.Tables[0].Rows[0]["ATTORNEY_NAME"]);
ddlPatient.JSProperties.Add("cpSZ_ATTORNEY_PHONE", ds.Tables[0].Rows[0]["sz_attorney_phone"]);
}
}
