private void GetProcedureCode(string p_szDoctorID)
{
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_Calender billSysCalender = new Bill_Sys_Calender();
try
{
this.lstProcedureCode.Items.Clear();
this.lstProcedureCode.DataSource = billSysCalender.GetReferringDoctorProcedureCodeList(((Bill_Sys_BillingCompanyObject)this.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID, p_szDoctorID);
this.lstProcedureCode.DataTextField = "DESCRIPTION";
this.lstProcedureCode.DataValueField = "CODE";
this.lstProcedureCode.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 AddVisit()
{
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
ArrayList objAdd = new ArrayList();
objAdd.Add(((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_ID); //Case Id
objAdd.Add(TXT_CURRENT_DATE.Text); //Appointment date
objAdd.Add("8.30"); //Appointment time
objAdd.Add(""); //Notes
// objAdd.Add(extddlDoctor.Text); vivek 2/2/10
objAdd.Add(txtDoctorId.Text);
objAdd.Add("TY000000000000000003");//Type
objAdd.Add(txtCompanyID.Text);
objAdd.Add("AM");
objAdd.Add("9.00");
objAdd.Add("AM");
objAdd.Add("2");
// add visit for FU only
Bill_Sys_PatientVisitBO objPV = new Bill_Sys_PatientVisitBO();
String szDefaultVisitTypeID = objPV.GetVisitType(txtCompanyID.Text, "GET_FU_VALUE");
objAdd.Add(szDefaultVisitTypeID);//Type
_bill_Sys_Calender.SaveEvent(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
}
public static bool CheckVisitForVisitType(string Parameter)
{
string[] clientData = Parameter.Split(new char[] { '-' });
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
return(!_bill_Sys_Calender.CheckVisitForVisitType(clientData[2], clientData[1], clientData[0], ((Bill_Sys_BillingCompanyObject)System.Web.HttpContext.Current.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID));
}
private void BindVisiTypeList(ref RadioButtonList listVisitType)
{
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_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
try
{
listVisitType.Items.Clear();
listVisitType.DataSource = _bill_Sys_Calender.GET_Visit_Types(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
listVisitType.DataTextField = "VISIT_TYPE";
listVisitType.DataValueField = "VISIT_TYPE_ID";
listVisitType.DataBind();
listVisitType.Items[2].Selected = 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 ddlVisit_Callback(object sender, DevExpress.Web.CallbackEventArgsBase e)
{
string[] clientData = e.Parameter.Split(new char[] { '-' });
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
ddlVisit.JSProperties.Add("cpIsValid", !_bill_Sys_Calender.CheckVisitForVisitType(clientData[2], clientData[1], clientData[0], ((Bill_Sys_BillingCompanyObject)System.Web.HttpContext.Current.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID));
}
protected void extddlDoctor_extendDropDown_SelectedIndexChanged(object sender, EventArgs e)
{
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
if (_bill_Sys_Calender.CheckReferralExists(extddlDoctor.Text, ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID))
{
//RowProcedureCode.Visible = true;
GetProcedureCode(extddlDoctor.Text);
}
else
{
lstProcedureCode.Items.Clear();
//RowProcedureCode.Visible = false;
}
}
private void BindDoctorList()
{
string str = this.Session["SendPatientToDoctor"].ToString();
if (str.ToLower() == "false")
{
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
DataSet doctorlList = _bill_Sys_Calender.GetDoctorlList(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
this.grdDoctor.DataSource = doctorlList;
this.grdDoctor.DataBind();
}
else if (str.ToLower() == "true")
{
Bill_Sys_Event_BO objDocList = new Bill_Sys_Event_BO();
DataSet dsDoctor = objDocList.GetDoctorlList(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
grdDoctor.DataSource = dsDoctor;
grdDoctor.DataBind();
}
}
private void BindGrid(DateTime date, string flag, int time)
{
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_Calender = new Bill_Sys_Calender();
try
{
if (time > 0)
{
//BindGrid(Convert.ToDateTime(Session["CURRENT_DATE"].ToString()), Session["CALENDER_STATE"].ToString(), 0);
grdDisplayEvents.DataSource = _bill_Sys_Calender.GetEventDetailList(date, flag, txtCaseID.Text, txtCompanyid.Text, time);
}
else
{
grdDisplayEvents.DataSource = _bill_Sys_Calender.GetEventDetailList(date, "Day", txtCaseID.Text, txtCompanyid.Text, time);
}
grdDisplayEvents.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 BindDoctorList()
{
string str = this.Session["SendPatientToDoctor"].ToString();
if (str.ToLower() != "false")
{
if (str.ToLower() == "true")
{
Bill_Sys_Event_BO billSysEventBO = new Bill_Sys_Event_BO();
DataSet doctorlList = billSysEventBO.GetDoctorlList(((Bill_Sys_BillingCompanyObject)this.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
this.grdDoctor.DataSource = doctorlList;
this.grdDoctor.DataBind();
}
return;
}
else
{
Bill_Sys_Calender billSysCalender = new Bill_Sys_Calender();
DataSet dataSet = billSysCalender.GetDoctorlList(((Bill_Sys_BillingCompanyObject)this.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
this.grdDoctor.DataSource = dataSet;
this.grdDoctor.DataBind();
return;
}
}
protected void ASPxScheduler1_AppointmentsChanged(object sender, PersistentObjectsEventArgs e)
{
//Delete Schedule
DevExpress.XtraScheduler.Internal.Implementations.AppointmentInstance AppointmentInstance = (DevExpress.XtraScheduler.Internal.Implementations.AppointmentInstance)e.Objects[0];
DeleteSchedule objSchedule = new DeleteSchedule();
objSchedule.Index = 0;
if (AppointmentInstance.Type == AppointmentType.Normal)
{
objSchedule.AppointmentID = Convert.ToInt32(AppointmentInstance.Id);
}
else if (AppointmentInstance.Type == AppointmentType.Pattern)
{
objSchedule.AppointmentID = Convert.ToInt32(AppointmentInstance.RecurrencePattern.Id);
}
switch (AppointmentInstance.Type)
{
case AppointmentType.ChangedOccurrence:
break;
case AppointmentType.DeletedOccurrence:
case AppointmentType.Pattern:
objSchedule.Index = -1;
billSysDeleteBO.DeleteEventSchedular(objSchedule);
break;
case AppointmentType.Normal:
// billSysDeleteBO.DeleteEventSchedular(objSchedule);
break;
case AppointmentType.Occurrence:
break;
default:
break;
}
if (AppointmentInstance.Type == AppointmentType.Pattern)
{
OccurrenceCalculator oc = OccurrenceCalculator.CreateInstance(AppointmentInstance.RecurrenceInfo);
TimeInterval ttc = new TimeInterval(AppointmentInstance.RecurrenceInfo.Start, AppointmentInstance.RecurrenceInfo.End.Add(AppointmentInstance.Duration));
AppointmentBaseCollection appts = oc.CalcOccurrences(ttc, AppointmentInstance);
foreach (Appointment item in appts)
{
int index = item.RecurrenceIndex;
#region Data insert to TXN_CALENDAR
try
{
ArrayList objAdd;
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
objAdd = new ArrayList();
objAdd.Add(_bill_Sys_Calender.GetCaseIDByPatient(AppointmentInstance.CustomFields[0].ToString()));
objAdd.Add(item.Start);
objAdd.Add(item.Start.Hour + "." + item.Start.Minute);
objAdd.Add(AppointmentInstance.Description);
objAdd.Add(AppointmentInstance.CustomFields[2]);
objAdd.Add("TY000000000000000003");
objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
objAdd.Add(AppointmentInstance.Start.ToString("tt", CultureInfo.InvariantCulture));
int endMin = Convert.ToInt32(item.End.Minute);
int endHr = Convert.ToInt32(item.End.Hour);
string endTime = item.End.Hour + "." + item.End.Minute;
if (endMin >= 60)
{
endMin = endMin - 60;
endHr = endHr + 1;
if (endHr > 12)
{
endHr = endHr - 12;
if (AppointmentInstance.End.Hour != 12)
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
else if (endHr == 12)
{
if (AppointmentInstance.End.Hour != 12)
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
}
objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString());
objAdd.Add(item.End.ToString("tt", CultureInfo.InvariantCulture));
objAdd.Add(AppointmentInstance.StatusKey);
objAdd.Add(item.CustomFields["VISIT_TYPE_ID"]);
objAdd.Add(AppointmentInstance.Id);
objAdd.Add(index);
_bill_Sys_Calender.SaveEventFromSchedular(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
index++;
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
#endregion
}
return;
}
else if (AppointmentInstance.Type == AppointmentType.Normal)
{
string[] clientData = AppointmentInstance.Location.Split(new char[] { '-' });
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
int index = 0;
if (clientData[2].Trim() != "null")
{
if (_bill_Sys_Calender.CHECKVISIT_FOR_APPOINTMENT(Convert.ToInt32(AppointmentInstance.Id), index, ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID))
{
#region Data Update to TXN_CALENDAR
try
{
ArrayList objAdd;
objAdd = new ArrayList();
objAdd.Add(_bill_Sys_Calender.GetCaseIDByPatient(clientData[2]));
objAdd.Add(AppointmentInstance.Start);
objAdd.Add(AppointmentInstance.Start.Hour + "." + AppointmentInstance.Start.Minute);
objAdd.Add(AppointmentInstance.Description);
objAdd.Add(clientData[1]);
objAdd.Add("TY000000000000000003");
objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
objAdd.Add(AppointmentInstance.Start.ToString("tt", CultureInfo.InvariantCulture));
int endMin = Convert.ToInt32(AppointmentInstance.End.Minute);
int endHr = Convert.ToInt32(AppointmentInstance.End.Hour);
string endTime = AppointmentInstance.End.Hour + "." + AppointmentInstance.End.Minute;
if (endMin >= 60)
{
endMin = endMin - 60;
endHr = endHr + 1;
if (endHr > 12)
{
endHr = endHr - 12;
if (AppointmentInstance.End.Hour != 12)
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
else if (endHr == 12)
{
if (AppointmentInstance.End.Hour != 12)
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
}
objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString());
objAdd.Add(AppointmentInstance.End.ToString("tt", CultureInfo.InvariantCulture));
objAdd.Add(AppointmentInstance.StatusKey);
objAdd.Add(clientData[0]);
objAdd.Add(AppointmentInstance.Id);
objAdd.Add(index);
objAdd.Add(AppointmentInstance.Id);
_bill_Sys_Calender.UPDATEEventByAppointmentId(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
index++;
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
#endregion
}
else
{
#region Data insert to TXN_CALENDAR
try
{
ArrayList objAdd;
objAdd = new ArrayList();
objAdd.Add(_bill_Sys_Calender.GetCaseIDByPatient(clientData[2]));
objAdd.Add(AppointmentInstance.Start);
objAdd.Add(AppointmentInstance.Start.Hour + "." + AppointmentInstance.Start.Minute);
objAdd.Add(AppointmentInstance.Description);
objAdd.Add(clientData[1]);
objAdd.Add("TY000000000000000003");
objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
objAdd.Add(AppointmentInstance.Start.ToString("tt", CultureInfo.InvariantCulture));
int endMin = Convert.ToInt32(AppointmentInstance.End.Minute);
int endHr = Convert.ToInt32(AppointmentInstance.End.Hour);
string endTime = AppointmentInstance.End.Hour + "." + AppointmentInstance.End.Minute;
if (endMin >= 60)
{
endMin = endMin - 60;
endHr = endHr + 1;
if (endHr > 12)
{
endHr = endHr - 12;
if (AppointmentInstance.End.Hour != 12)
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
else if (endHr == 12)
{
if (AppointmentInstance.End.Hour != 12)
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
}
objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString());
objAdd.Add(AppointmentInstance.End.ToString("tt", CultureInfo.InvariantCulture));
objAdd.Add(0);
objAdd.Add(clientData[0]);
objAdd.Add(AppointmentInstance.Id);
objAdd.Add(index);
_bill_Sys_Calender.SaveEventFromSchedular(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
#endregion
}
}
}
else if (AppointmentInstance.Type == AppointmentType.DeletedOccurrence)
{
//Deleted code in TXN_CALENDER_EVENTS
//DeleteSchedule objSchedule = new DeleteSchedule();
//objSchedule.Index = apt.RecurrenceIndex;
//objSchedule.AppointmentID = Convert.ToInt32(apt.RecurrencePattern.Id);
//billSysDeleteBO.DeleteEventSchedular(objSchedule);
//return;
}
else if (AppointmentInstance.Type == AppointmentType.ChangedOccurrence)
{
string[] clientData = AppointmentInstance.Location.Split(new char[] { '-' });
int index = AppointmentInstance.RecurrenceIndex;
#region Data Update to TXN_CALENDAR
try
{
ArrayList objAdd;
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
objAdd = new ArrayList();
objAdd.Add(_bill_Sys_Calender.GetCaseIDByPatient(clientData[2]));
objAdd.Add(AppointmentInstance.Start);
objAdd.Add(AppointmentInstance.Start.Hour + "." + AppointmentInstance.Start.Minute);
objAdd.Add(AppointmentInstance.Description);
objAdd.Add(clientData[1]);
objAdd.Add("TY000000000000000003");
objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
objAdd.Add(AppointmentInstance.Start.ToString("tt", CultureInfo.InvariantCulture));
int endMin = Convert.ToInt32(AppointmentInstance.End.Minute);
int endHr = Convert.ToInt32(AppointmentInstance.End.Hour);
string endTime = AppointmentInstance.End.Hour + "." + AppointmentInstance.End.Minute;
if (endMin >= 60)
{
endMin = endMin - 60;
endHr = endHr + 1;
if (endHr > 12)
{
endHr = endHr - 12;
if (AppointmentInstance.End.Hour != 12)
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
else if (endHr == 12)
{
if (AppointmentInstance.End.Hour != 12)
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
}
objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString());
objAdd.Add(AppointmentInstance.End.ToString("tt", CultureInfo.InvariantCulture));
objAdd.Add(AppointmentInstance.StatusKey);
objAdd.Add(clientData[0]);
objAdd.Add(AppointmentInstance.RecurrencePattern.Id);
objAdd.Add(index);
objAdd.Add(AppointmentInstance.Id);
_bill_Sys_Calender.UPDATEEventByAppointmentId(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
index++;
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
#endregion
}
}
protected void ASPxScheduler1_AppointmentsInserted(object sender, DevExpress.XtraScheduler.PersistentObjectsEventArgs e)
{
//Task.Factory.StartNew(() =>
//{
Appointment apt = (Appointment)e.Objects[0];
string[] clientData = apt.Location.Split(new char[] { '-' });
if (clientData[2].Trim() != "null")
{
if (apt.Type == AppointmentType.Pattern)
{
OccurrenceCalculator oc = OccurrenceCalculator.CreateInstance(apt.RecurrenceInfo);
TimeInterval ttc = new TimeInterval(apt.RecurrenceInfo.Start, apt.RecurrenceInfo.End.Add(apt.Duration));
AppointmentBaseCollection appts = oc.CalcOccurrences(ttc, apt);
foreach (Appointment item in appts)
{
int index = item.RecurrenceIndex;
#region Data insert to TXN_CALENDAR
try
{
ArrayList objAdd;
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
objAdd = new ArrayList();
objAdd.Add(_bill_Sys_Calender.GetCaseIDByPatient(clientData[2]));
objAdd.Add(item.Start);
objAdd.Add(item.Start.Hour + "." + item.Start.Minute);
objAdd.Add(apt.Description);
objAdd.Add(clientData[1]);
objAdd.Add("TY000000000000000003");
objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
objAdd.Add(apt.Start.ToString("tt", CultureInfo.InvariantCulture));
int endMin = Convert.ToInt32(item.End.Minute);
int endHr = Convert.ToInt32(item.End.Hour);
string endTime = item.End.Hour + "." + item.End.Minute;
if (endMin >= 60)
{
endMin = endMin - 60;
endHr = endHr + 1;
if (endHr > 12)
{
endHr = endHr - 12;
if (apt.End.Hour != 12)
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
else if (endHr == 12)
{
if (apt.End.Hour != 12)
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
}
objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString());
objAdd.Add(item.End.ToString("tt", CultureInfo.InvariantCulture));
objAdd.Add(apt.StatusId);
objAdd.Add(clientData[0]);
objAdd.Add(apt.Id);
objAdd.Add(index);
_bill_Sys_Calender.SaveEventFromSchedular(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
index++;
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
#endregion
}
return;
}
else if (apt.Type == AppointmentType.Normal)
{
#region Data insert to TXN_CALENDAR
try
{
ArrayList objAdd;
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
objAdd = new ArrayList();
objAdd.Add(_bill_Sys_Calender.GetCaseIDByPatient(clientData[2]));
objAdd.Add(apt.Start);
objAdd.Add(apt.Start.Hour + "." + apt.Start.Minute);
objAdd.Add(apt.Description);
objAdd.Add(clientData[1]);
objAdd.Add("TY000000000000000003");
objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
objAdd.Add(apt.Start.ToString("tt", CultureInfo.InvariantCulture));
int endMin = Convert.ToInt32(apt.End.Minute);
int endHr = Convert.ToInt32(apt.End.Hour);
string endTime = apt.End.Hour + "." + apt.End.Minute;
if (endMin >= 60)
{
endMin = endMin - 60;
endHr = endHr + 1;
if (endHr > 12)
{
endHr = endHr - 12;
if (apt.End.Hour != 12)
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
else if (endHr == 12)
{
if (apt.End.Hour != 12)
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
}
objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString());
objAdd.Add(apt.End.ToString("tt", CultureInfo.InvariantCulture));
objAdd.Add(0);
objAdd.Add(clientData[0]);
objAdd.Add(apt.Id);
objAdd.Add(0);
_bill_Sys_Calender.SaveEventFromSchedular(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
#endregion
return;
}
else if (apt.Type == AppointmentType.DeletedOccurrence)
{
//Deleted code in TXN_CALENDER_EVENTS
DeleteSchedule objSchedule = new DeleteSchedule();
objSchedule.Index = apt.RecurrenceIndex;
objSchedule.AppointmentID = Convert.ToInt32(apt.RecurrencePattern.Id);
billSysDeleteBO.DeleteEventSchedular(objSchedule);
return;
}
else if (apt.Type == AppointmentType.ChangedOccurrence)
{
return;
}
}
}
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
{
ArrayList obj = new ArrayList();
if (txtFromDate.Text == "" && txtToDate.Text == "")
{
obj.Add(DateTime.Today.ToShortDateString());
obj.Add(DateTime.Today.ToShortDateString());
}
else
{
obj.Add(txtFromDate.Text);
obj.Add(txtToDate.Text);
}
obj.Add(txtCompanyID.Text);
if (extddlVisitRoom.Text != "NA" && extddlVisitRoom.Text != "")
{
obj.Add(extddlVisitRoom.Text);
}
else
{
obj.Add("");
}
//Code to send location id to stoared procedure
if (extddlLocation.Visible == true && extddlLocation.Text != "" && extddlLocation.Text != "NA")
{
obj.Add(extddlLocation.Text);
}
//end of code
_bill_Sys_Calender = new Bill_Sys_Calender();
grdScheduleReport.DataSource = _bill_Sys_Calender.GET_Schedule_Visits(obj);
grdScheduleReport.DataBind();
grdForReport.DataSource = _bill_Sys_Calender.GET_Schedule_Visits(obj);
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 btnUpdateStatus_Click(object sender, EventArgs e)
{
int iFlag = 0;
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
Bill_Sys_Event_BO _Bill_Sys_Event_BO = new Bill_Sys_Event_BO();
ArrayList objAdd;
try
{
Boolean _valid = true;
if (_valid == true)
{
for (int i = 0; i < this.grdTodayVisit.Rows.Count; i++)
{
CheckBox chkSelected = (CheckBox)grdTodayVisit.Rows[i].FindControl("ChkSelect");
string iEventID = "";
string szcaseID = "";
string szDoctorID = "";
string szhave_login = "";
string szgroupcode = "";
if (chkSelected.Checked == true)
{
iEventID = grdTodayVisit.DataKeys[i]["I_EVENT_ID"].ToString();
szcaseID = grdTodayVisit.DataKeys[i]["SZ_CASE_ID"].ToString();
szDoctorID = grdTodayVisit.DataKeys[i]["SZ_DOCTOR_ID"].ToString();
szhave_login = grdTodayVisit.DataKeys[i]["IS_HAVE_LOGIN"].ToString();
szgroupcode = grdTodayVisit.DataKeys[i]["GROUP_CODE"].ToString();
if (szhave_login == "1")
{
if (ddlStatus.SelectedValue == "1")
{
int endMin = Convert.ToInt32(ddlReSchMinutes.SelectedValue) + Convert.ToInt32("30");
int endHr = Convert.ToInt32(ddlReSchHours.SelectedValue);
string endTime = ddlReSchTime.SelectedValue;
if (endMin >= 60)
{
endMin = endMin - 60;
endHr = endHr + 1;
if (endHr > 12)
{
endHr = endHr - 12;
if (ddlReSchHours.SelectedValue != "12")
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
else if (endHr == 12)
{
if (ddlReSchHours.SelectedValue != "12")
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
}
_Bill_Sys_Event_BO.UpdateRescheduledoctorvisits(iEventID, "", txtReScheduleDate.Text, szgroupcode, ddlReSchHours.SelectedValue.ToString() + "." + ddlReSchMinutes.SelectedValue.ToString(), ddlReSchTime.SelectedValue, endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString(), endTime);
}
else if (ddlStatus.SelectedValue == "3")
{
Bill_Sys_Calender _bill_Sys_Calender1 = new Bill_Sys_Calender();
ArrayList objAdd1 = new ArrayList();
objAdd1.Add(iEventID);
objAdd1.Add(false);
objAdd1.Add(ddlStatus.SelectedValue);
_bill_Sys_Calender1.UPDATE_Event_Status(objAdd1);
}
else
{
iFlag = 1;
}
}
else
{
if (ddlStatus.SelectedValue == "1")
{
objAdd = new ArrayList();
objAdd.Add(szcaseID);
objAdd.Add(txtReScheduleDate.Text);
objAdd.Add(ddlReSchHours.SelectedValue.ToString() + "." + ddlReSchMinutes.SelectedValue.ToString());
objAdd.Add("");
objAdd.Add(szDoctorID);
objAdd.Add("TY000000000000000003");
objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
objAdd.Add(ddlReSchTime.SelectedValue);
int endMin = Convert.ToInt32(ddlReSchMinutes.SelectedValue) + Convert.ToInt32("30");
int endHr = Convert.ToInt32(ddlReSchHours.SelectedValue);
string endTime = ddlReSchTime.SelectedValue;
if (endMin >= 60)
{
endMin = endMin - 60;
endHr = endHr + 1;
if (endHr > 12)
{
endHr = endHr - 12;
if (ddlReSchHours.SelectedValue != "12")
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
else if (endHr == 12)
{
if (ddlReSchHours.SelectedValue != "12")
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
}
objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString());
objAdd.Add(endTime.ToString());
_bill_Sys_Calender.SaveEvent(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
}
_bill_Sys_Calender = new Bill_Sys_Calender();
objAdd = new ArrayList();
objAdd.Add(iEventID);
objAdd.Add(false);
objAdd.Add(ddlStatus.SelectedValue);
_bill_Sys_Calender.UPDATE_Event_Status(objAdd);
}
}
}
lblMessage.Text = "";
usrMessage.PutMessage("Update Sucessfully ...");
usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage);
usrMessage.Show();
Bind_Grid();
//Bill_Sys_Event_BO objGetVisits = new Bill_Sys_Event_BO();
//DataSet dsVisits = new DataSet();
//dsVisits = objGetVisits.GetCaledarVisits(txtGetDay.Value, txtCompanyID.Text, extddlSpeciality.Text, txtProvider.Text, extddlDoctor.Text);
//grdTodayVisit.XGridBindSearch();
//ViewState["griddata"] = dsVisits;
clear();
}
}
catch (Exception ex)
{
}
}
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
{
btnSave.Attributes.Add("onclick", "return formValidator('form1','extddlDoctor,txtAppointmentDate,extddlVisitType,ddlHours,txtReDate,ddlReSchHours');");
if (!IsPostBack)
{
string eventId = Request.QueryString["eventId"].ToString();
BindTimeControl();
txtCompanyID.Text = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
extddlVisitType.Flag_ID = txtCompanyID.Text;
// Set default 'C' for Visit Type
Bill_Sys_PatientVisitBO objPV = new Bill_Sys_PatientVisitBO();
extddlVisitType.Text = objPV.GetDefaultVisitType(txtCompanyID.Text);
///////////////////
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
DataTable dt = new DataTable();
dt = _bill_Sys_Calender.GET_EVENT_DETAIL(eventId);
if (dt.Rows.Count > 0)
{
for (int drRow = 0; drRow <= dt.Rows.Count - 1; drRow++)
{
ddlHours.SelectedValue = dt.Rows[drRow].ItemArray.GetValue(3).ToString().PadLeft(2, '0');
ddlMinutes.SelectedValue = dt.Rows[drRow].ItemArray.GetValue(1).ToString().PadLeft(2, '0');
ddlTime.SelectedValue = dt.Rows[drRow].ItemArray.GetValue(5).ToString();
extddlDoctor.Flag_ID = dt.Rows[drRow].ItemArray.GetValue(10).ToString();
extddlDoctor.Text = dt.Rows[drRow].ItemArray.GetValue(10).ToString();
extddlVisitType.Text = dt.Rows[drRow].ItemArray.GetValue(17).ToString();
txtPatientID.Text = dt.Rows[drRow].ItemArray.GetValue(12).ToString();
txtAppointmentDate.Text = dt.Rows[drRow].ItemArray.GetValue(13).ToString();
ddlStatus.SelectedValue = dt.Rows[drRow].ItemArray.GetValue(15).ToString();
txtCaseID.Text = dt.Rows[drRow].ItemArray.GetValue(16).ToString();
txtVisitStatus.Text = dt.Rows[drRow].ItemArray.GetValue(15).ToString();
txtReEventID.Text = dt.Rows[drRow].ItemArray.GetValue(18).ToString();
if (txtReEventID.Text == "" && ddlStatus.SelectedValue == "1")
{
txtReDate.Text = dt.Rows[drRow].ItemArray.GetValue(19).ToString();
ddlReSchHours.SelectedValue = dt.Rows[drRow].ItemArray.GetValue(20).ToString().PadLeft(2, '0');
ddlReSchMinutes.SelectedValue = dt.Rows[drRow].ItemArray.GetValue(21).ToString().PadLeft(2, '0');
ddlReSchTime.SelectedValue = dt.Rows[drRow].ItemArray.GetValue(22).ToString();
lblReDate.Visible = true;
lblReTIme.Visible = true;
txtReDate.Visible = true;
ddlReSchHours.Visible = true;
ddlReSchMinutes.Visible = true;
ddlReSchTime.Visible = true;
}
if (ddlStatus.SelectedValue == "2")
{
btnSave.Visible = true;
ddlHours.Enabled = false;
ddlMinutes.Enabled = false;
ddlTime.Enabled = false;
ddlStatus.Enabled = false;
extddlDoctor.Enabled = false;
txtAppointmentDate.Enabled = false;
}
DataTable dtTest = _bill_Sys_Calender.GetReferringProcCodeList(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID, extddlDoctor.Text).Tables[0];
ddlTestNames.DataSource = dtTest;
ddlTestNames.DataTextField = "DESCRIPTION";
ddlTestNames.DataValueField = "CODE";
ddlTestNames.DataBind();
ddlOldTestNames.DataSource = dtTest;
ddlOldTestNames.DataTextField = "DESCRIPTION";
ddlOldTestNames.DataValueField = "CODE";
ddlOldTestNames.DataBind();
// if (dt.Rows[drRow].ItemArray.GetValue(14).ToString() == "True" || ddlStatus.SelectedValue=="2" )
// {
//btnUpdate.Visible = true;
DataSet ds = new DataSet();
Patient_TVBO _patient_TVBO = new Patient_TVBO();
ds = _patient_TVBO.GetAppointProcCode(Convert.ToInt32(eventId));
foreach (DataRow dr in ds.Tables[0].Rows)
{
foreach (ListItem lst in ddlTestNames.Items)
{
if (lst.Value == dr.ItemArray.GetValue(0).ToString())
{
lst.Selected = true;
}
}
foreach (ListItem lst in ddlOldTestNames.Items)
{
if (lst.Value == dr.ItemArray.GetValue(0).ToString())
{
lst.Selected = true;
}
}
}
//}
}
////////////////////
}
}
lblMsg.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 extddlDoctor_extendDropDown_SelectedIndexChanged(object sender, EventArgs e)
{
Bill_Sys_Calender billSysCalender = new Bill_Sys_Calender();
}
protected void btnSave_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());
}
try
{
this._bill_Sys_Visit_BO = new Bill_Sys_Visit_BO();
string str = "";
string str1 = "";
string szPatientID = null;
string dt_Opendate = null;
string dt_Created = null;
ArrayList arr = new ArrayList();
foreach (DataGridItem item in this.grdCaseMaster.Items)
{
if (!((CheckBox)item.Cells[0].FindControl("chkSelect")).Checked)
{
continue;
}
szPatientID = item.Cells[3].Text;
ArrayList arrayLists = new ArrayList();
arrayLists.Add(this.txtCompanyID.Text);
arrayLists.Add(item.Cells[COL_CASE_ID].Text);
arrayLists.Add(this.ddlDoctor.SelectedValue);
arrayLists.Add(this.txtAppointdate.Text);
if (this._bill_Sys_Visit_BO.Checkvisitexists(arrayLists))
{
str = (str != "" ? string.Concat(str, ", ", item.Cells[4].Text) : item.Cells[4].Text);
//List of patients who have a visit for the selected date. Avoid adding visit for them
arr.Add(szPatientID);
}
}
foreach (DataGridItem item in this.grdCaseMaster.Items)
{
if (!((CheckBox)item.Cells[0].FindControl("chkSelect")).Checked)
{
continue;
}
szPatientID = item.Cells[3].Text;
dt_Opendate = item.Cells[7].Text;
DateTime dtOpen = Convert.ToDateTime(dt_Opendate);
dt_Created = item.Cells[6].Text;
DateTime dtcreate = Convert.ToDateTime(dt_Created);
bool flagAlreadyExist = exists(szPatientID, arr);
if (flagAlreadyExist == false)
{
if (this.lstProcedureCode.Visible || !(Convert.ToDateTime(this.txtAppointdate.Text) > Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy"))))
{
if ((Convert.ToDateTime(this.txtAppointdate.Text) >= Convert.ToDateTime(dtOpen.ToString("MM/dd/yyyy"))) && (Convert.ToDateTime(this.txtAppointdate.Text) >= Convert.ToDateTime(dtcreate.ToString("MM/dd/yyyy"))))
{
bool flag2 = false;
if (!((CheckBox)item.Cells[0].FindControl("chkSelect")).Checked)
{
continue;
}
this._bill_Sys_Calender = new Bill_Sys_Calender();
this.objAdd = new ArrayList();
this.objAdd.Add(item.Cells[2].Text);
this.objAdd.Add(this.txtAppointdate.Text);
this.objAdd.Add("8.30");
this.objAdd.Add("");
this.objAdd.Add(this.ddlDoctor.SelectedValue);
this.objAdd.Add("TY000000000000000003");
this.objAdd.Add(((Bill_Sys_BillingCompanyObject)this.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
this.objAdd.Add("AM");
this.objAdd.Add("9.00");
this.objAdd.Add("AM");
this.objAdd.Add(szPatientID);
this._bill_Sys_Calender.SaveEventWithAutoVisitType(this.objAdd, ((Bill_Sys_UserObject)this.Session["USER_OBJECT"]).SZ_USER_ID.ToString());
ArrayList arrayLists1 = new ArrayList();
arrayLists1.Add(item.Cells[2].Text);
arrayLists1.Add(this.ddlDoctor.SelectedValue);
arrayLists1.Add(((Bill_Sys_BillingCompanyObject)this.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
int eventID = this._bill_Sys_Calender.GetEventID(arrayLists1);
if (this.lstProcedureCode.Visible)
{
this._bill_Sys_Calender = new Bill_Sys_Calender();
this.objAdd = new ArrayList();
this.objAdd.Add(eventID);
this.objAdd.Add(false);
this.objAdd.Add(this.ddlStatus.SelectedValue);
this._bill_Sys_Calender.UPDATE_Event_Status(this.objAdd);
foreach (ListItem listItem in this.lstProcedureCode.Items)
{
if (!listItem.Selected)
{
continue;
}
this.objAdd = new ArrayList();
this.objAdd.Add(listItem.Value);
this.objAdd.Add(eventID);
this.objAdd.Add(this.ddlStatus.SelectedValue);
this._bill_Sys_Calender.Save_Event_RefferPrcedure(this.objAdd);
}
}
this._DAO_NOTES_EO = new DAO_NOTES_EO();
this._DAO_NOTES_EO.SZ_MESSAGE_TITLE = "APPOINTMENT_ADDED";
this._DAO_NOTES_EO.SZ_ACTIVITY_DESC = string.Concat("Date : ", this.txtAppointdate.Text);
this._DAO_NOTES_BO = new DAO_NOTES_BO();
this._DAO_NOTES_EO.SZ_USER_ID = ((Bill_Sys_UserObject)this.Session["USER_OBJECT"]).SZ_USER_ID;
this._DAO_NOTES_EO.SZ_CASE_ID = item.Cells[2].Text;
this._DAO_NOTES_EO.SZ_COMPANY_ID = ((Bill_Sys_BillingCompanyObject)this.Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
this._DAO_NOTES_BO.SaveActivityNotes(this._DAO_NOTES_EO);
flag2 = true;
if (flag2)
{
this.lblMsg.Text = "Appointment(s) scheduled successfully";
}
}
else
{
str1 = (str1 != "" ? string.Concat(str1, ", ", item.Cells[4].Text) : item.Cells[4].Text);
//this.Page.ClientScript.RegisterClientScriptBlock(base.GetType(), "ss", "<script language='javascript'>alert('Visit date cannot be future date from open date');</script>");
}
}
else
{
this.Page.ClientScript.RegisterClientScriptBlock(base.GetType(), "ss", "<script language='javascript'>alert('Visit for future date cannot be added');</script>");
}
}
}
if (str != "")
{
ClientScriptManager clientScript = this.Page.ClientScript;
Type type = base.GetType();
string[] text = new string[] { "<script language='javascript'>alert('Visit for ", str, " already scheduled on ", this.txtAppointdate.Text, " ...!');</script>" };
clientScript.RegisterClientScriptBlock(type, "ss", string.Concat(text));
}
if (str1 != "")
{
lblDateMsg.Text = "Visit for " + str1 + " can be future date from open date.";
}
}
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
{
btnSave.Attributes.Add("onclick", "return formValidator('frmProcedureGroup','txtProcedureGroup');");
btnUpdate.Attributes.Add("onclick", "return formValidator('frmProcedureGroup','txtProcedureGroup');");
txtCompanyID.Text = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
if (Session["Flag"] != null && Session["Flag"].ToString() == "true")
{
//TreeMenuControl1.Visible = false;
grdProcedureGroup.Visible = false;
btnUpdate.Visible = false;
}
else
{
//TreeMenuControl1.ROLE_ID = ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ROLE;
Bill_Sys_DisplaySpeciality objspeciality = new Bill_Sys_DisplaySpeciality();
DataSet dset = new DataSet();
if (!IsPostBack)
{
string szBitValue = Session["SendPatientToDoctor"].ToString();
if (szBitValue.ToLower() == "false")
{
chkDonotHaveNotes.Visible = false;
lblDonotHaveNotes.Visible = false;
}
else
{
chkDonotHaveNotes.Visible = true;
lblDonotHaveNotes.Visible = true;
}
BindGrid();
txtIELimit.Text = "0";
txtFULimit.Text = "0";
txtCLimit.Text = "0";
btnUpdate.Enabled = false;
BindProcedureGroupLstBox();
txtFULimit.Enabled = false;
txtIELimit.Enabled = false;
txtCLimit.Enabled = false;
_Calendar = new Bill_Sys_Calender();
DataTable CheckVisitTypes = new DataTable();
if (((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).BT_REFERRING_FACILITY.ToString().ToLower() == "false")
{
if (txtCompanyID.Text != "")
{
CheckVisitTypes = _Calendar.GET_Visit_Types(txtCompanyID.Text);
}
if (CheckVisitTypes.Rows.Count > 0)
{
foreach (DataRow dr in CheckVisitTypes.Rows)
{
if (dr["VISIT_TYPE"].ToString().Trim().ToLower() == "ie")
{
txtIELimit.Enabled = true;
}
else if (dr["VISIT_TYPE"].ToString().Trim().ToLower() == "fu")
{
txtFULimit.Enabled = true;
}
else if (dr["VISIT_TYPE"].ToString().Trim().ToLower() == "c")
{
txtCLimit.Enabled = true;
}
}
}
}
}
}
_deleteOpeation = new Bill_Sys_DeleteBO();
if (_deleteOpeation.checkForDelete(txtCompanyID.Text, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ROLE))
{
btnDelete.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);
}
#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_ProcedureGroup.aspx");
}
#endregion
//Method End
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
}
protected void btnCheckinSave_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());
}
Boolean blInitialVisitNotExist = false;
Boolean blInitialVisitExist = false;
Boolean blVisitExist = false;
CaseDetailsBO _caseDetailsBO = new CaseDetailsBO();
lblCheckinMsg.Text = "";
#region "Save"
Bill_Sys_Visit_BO _bill_Sys_Visit_BO = new Bill_Sys_Visit_BO();
ArrayList objAdd = new ArrayList();
try
{
#region "Check for Valid visit"
for (int i = 0; i < grdDoctorList.Items.Count; i++)
{
if (((CheckBox)grdDoctorList.Items[i].Cells[0].FindControl("chkVisit")).Checked == true)
{
String szSelectedVisit = ((RadioButtonList)grdDoctorList.Items[i].Cells[3].FindControl("listVisitType")).SelectedItem.Text;
String szSelectedVisitID = ((RadioButtonList)grdDoctorList.Items[i].Cells[3].FindControl("listVisitType")).SelectedItem.Value;
#region "Check for Visit"
Boolean iEvisitExists = false;
Boolean visitExists = false;
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings.Get("MyConnectionString"));
SqlCommand comd = new SqlCommand("SP_CHECK_INITIALE_VALUATIONEXISTS");
comd.CommandType = CommandType.StoredProcedure;
comd.Connection = con;
comd.Connection.Open();
comd.Parameters.AddWithValue("@SZ_CASE_ID", Session["CHECK_IN_CASE_ID"].ToString());
comd.Parameters.AddWithValue("@SZ_COMPANY_ID", ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
comd.Parameters.AddWithValue("@SZ_PATIENT_ID", Session["CHECK_IN_PATIENT_ID"].ToString());
comd.Parameters.AddWithValue("@SZ_DOCTOR_ID", grdDoctorList.Items[i].Cells[1].Text);
comd.Parameters.AddWithValue("@VISIT_DATE", txtVisitDate.Text);
string visitType = ((RadioButtonList)grdDoctorList.Items[i].Cells[3].FindControl("listVisitType")).SelectedItem.Text;
comd.Parameters.AddWithValue("@VISIT_TYPE", visitType);
//int intCountVisits = Convert.ToInt32(comd.ExecuteScalar());
SqlParameter objIEExists = new SqlParameter("@INITIAL_EXISTS", SqlDbType.Bit);
objIEExists.Direction = ParameterDirection.Output;
comd.Parameters.Add(objIEExists);
SqlParameter objVisitStatus = new SqlParameter("@VISIT_EXISTS", SqlDbType.Bit, 20);
objVisitStatus.Direction = ParameterDirection.Output;
comd.Parameters.Add(objVisitStatus);
comd.ExecuteNonQuery();
comd.Connection.Close();
iEvisitExists = Convert.ToBoolean(objIEExists.Value);
visitExists = Convert.ToBoolean(objVisitStatus.Value);
if (iEvisitExists == false && szSelectedVisit != "IE")
{
((RadioButtonList)grdDoctorList.Items[i].Cells[3].FindControl("listVisitType")).BackColor = Color.Yellow;
blInitialVisitNotExist = true;
continue;
}
if (iEvisitExists == true && szSelectedVisit == "IE")
{
((RadioButtonList)grdDoctorList.Items[i].Cells[3].FindControl("listVisitType")).BackColor = Color.Pink;
blInitialVisitExist = true;
continue;
}
if (visitExists == true)
{
((RadioButtonList)grdDoctorList.Items[i].Cells[3].FindControl("listVisitType")).BackColor = Color.Red;
blVisitExist = true;
continue;
}
#endregion
}
}
if (blInitialVisitNotExist == true)
{
lblCheckinMsg.Text = "<br>Schedules cannot be saved because patient shown in yellow color are visiting first time hence there visit type should be Initial Evaluation.";
lblCheckinMsg.Focus();
lblCheckinMsg.Visible = true;
}
if (blInitialVisitExist == true)
{
lblCheckinMsg.Text = lblCheckinMsg.Text + "<br>Schedules cannot be saved because patient shown in pink color already has Initial Evaluation.";
lblCheckinMsg.Focus();
lblCheckinMsg.Visible = true;
}
if (blVisitExist == true)
{
lblCheckinMsg.Text = lblCheckinMsg.Text + "<br>Schedules cannot be saved because patient shown in red color already has this visit";
lblCheckinMsg.Focus();
lblCheckinMsg.Visible = true;
}
#endregion
#region "Save All Visit"
if (blInitialVisitNotExist == false && blInitialVisitExist == false && blVisitExist == false)
{
for (int i = 0; i < grdDoctorList.Items.Count; i++)
{
if (((CheckBox)grdDoctorList.Items[i].Cells[0].FindControl("chkVisit")).Checked == true)
{
String szSelectedVisit = ((RadioButtonList)grdDoctorList.Items[i].Cells[3].FindControl("listVisitType")).SelectedItem.Text;
String szSelectedVisitID = ((RadioButtonList)grdDoctorList.Items[i].Cells[3].FindControl("listVisitType")).SelectedItem.Value;
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
ArrayList objAL = new ArrayList();
objAL.Add(Session["CHECK_IN_CASE_ID"].ToString()); //Case Id
objAL.Add(txtVisitDate.Text); //Appointment date
objAL.Add("8.30"); //Appointment time
objAL.Add(""); //Notes
objAL.Add(grdDoctorList.Items[i].Cells[1].Text); // Doctor ID
objAL.Add("TY000000000000000003"); //Type
objAL.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID); // Company ID
objAL.Add("AM");
objAL.Add("9.00");
objAL.Add("AM");
objAL.Add("0");
objAL.Add(szSelectedVisitID);
_bill_Sys_Calender.SaveEvent(objAL, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
}
}
if (blInitialVisitNotExist == false && blInitialVisitExist == false && blVisitExist == false)
{
lblCheckinMsg.Text = "Visit Added Successfully.";
Page.ClientScript.RegisterStartupScript(this.GetType(), "ss", "<script language='javascript'> window.parent.document.location.href='Bill_Sys_SearchCase.aspx';window.self.close(); </script>");
}
}
#endregion
}
catch (Exception ex)
{
log.Debug("Bill_Sys_CheckinPopup. Method - btnCheckinSave_Click : " + ex.Message.ToString());
log.Debug("Bill_Sys_CheckinPopup. Method - btnCheckinSave_Click : " + ex.StackTrace.ToString());
log.Debug("Bill_Sys_CheckinPopup. Method - btnCheckinSave_Click : " + ex.InnerException.Message.ToString());
log.Debug("Bill_Sys_CheckinPopup. Method - btnCheckinSave_Click : " + ex.InnerException.StackTrace.ToString());
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());
}
#endregion
}
protected void btnSave_Click(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
{
Boolean _valid = true;
if (ddlStatus.SelectedValue == "1")
{
if (txtReScheduleDate.Text == "" && ddlReSchHours.SelectedValue == "00")
{
lblMessage.Text = "Please enter Re-Schedule Date and Time";
_valid = false;
}
}
if (_valid == true)
{
string eventID = Request.QueryString["eventid"].ToString();
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
Bill_Sys_Event_BO _Bill_Sys_Event_BO = new Bill_Sys_Event_BO();
ArrayList objAdd;
if (txtHaveLogin.Text == "1")
{
if (ddlStatus.SelectedValue == "1")
{
int endMin = Convert.ToInt32(ddlReSchMinutes.SelectedValue) + Convert.ToInt32("30");
int endHr = Convert.ToInt32(ddlReSchHours.SelectedValue);
string endTime = ddlReSchTime.SelectedValue;
if (endMin >= 60)
{
endMin = endMin - 60;
endHr = endHr + 1;
if (endHr > 12)
{
endHr = endHr - 12;
if (ddlReSchHours.SelectedValue != "12")
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
else if (endHr == 12)
{
if (ddlReSchHours.SelectedValue != "12")
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
}
_Bill_Sys_Event_BO.UpdateRescheduledoctorvisits(txtEventID.Text, txtNotes.Text, txtReScheduleDate.Text, txtGroupCode.Text, ddlReSchHours.SelectedValue.ToString() + "." + ddlReSchMinutes.SelectedValue.ToString(), ddlReSchTime.SelectedValue, endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString(), endTime);
}
else if (ddlStatus.SelectedValue == "3")
{
Bill_Sys_Calender _bill_Sys_Calender1 = new Bill_Sys_Calender();
ArrayList objAdd1 = new ArrayList();
objAdd1.Add(eventID);
objAdd1.Add(false);
objAdd1.Add(ddlStatus.SelectedValue);
_bill_Sys_Calender1.UPDATE_Event_Status(objAdd1);
}
else
{
usrMessage.PutMessage("Note: You cannot mark a visit as Completed if that patient visit is to be finalized by the doctor.");
usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage);
usrMessage.Show();
return;
}
}
else
{
if (ddlStatus.SelectedValue == "1")
{
lblMessage.Text = "";
objAdd = new ArrayList();
objAdd.Add(txtCaseID.Text);
objAdd.Add(txtReScheduleDate.Text);
objAdd.Add(ddlReSchHours.SelectedValue.ToString() + "." + ddlReSchMinutes.SelectedValue.ToString());
objAdd.Add(txtNotes.Text);
objAdd.Add(txtDoctorid.Text);
objAdd.Add("TY000000000000000003");
objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
objAdd.Add(ddlReSchTime.SelectedValue);
int endMin = Convert.ToInt32(ddlReSchMinutes.SelectedValue) + Convert.ToInt32("30");
int endHr = Convert.ToInt32(ddlReSchHours.SelectedValue);
string endTime = ddlReSchTime.SelectedValue;
if (endMin >= 60)
{
endMin = endMin - 60;
endHr = endHr + 1;
if (endHr > 12)
{
endHr = endHr - 12;
if (ddlReSchHours.SelectedValue != "12")
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
else if (endHr == 12)
{
if (ddlReSchHours.SelectedValue != "12")
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
}
objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString());
objAdd.Add(endTime.ToString());
_bill_Sys_Calender.SaveEvent(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
}
_bill_Sys_Calender = new Bill_Sys_Calender();
objAdd = new ArrayList();
objAdd.Add(eventID);
objAdd.Add(false);
objAdd.Add(ddlStatus.SelectedValue);
_bill_Sys_Calender.UPDATE_Event_Status(objAdd);
}
usrMessage.PutMessage("Save Sucessfully ...");
usrMessage.SetMessageType(UserControl_ErrorMessageControl.DisplayType.Type_UserMessage);
usrMessage.Show();
}
}
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 css_btnSave_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());
}
try
{
AddVisit();
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
ArrayList objGetEvent = new ArrayList();
objGetEvent.Add(((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_ID);
objGetEvent.Add(txtDoctorId.Text);
objGetEvent.Add(txtCompanyID.Text);
int eventid = _bill_Sys_Calender.GetEventID(objGetEvent);
txtEventID.Text = Convert.ToString(eventid);
Session["AC_SYNAPTIC_EVENT_ID"] = txtEventID.Text;
grdProcedure.Columns[2].Visible = true;
DataSet dsDelete = _objCheckoutBO.PTNotesPatientTreatmentDelete(txtEventID.Text);
//_saveOperation = new SaveOperation();
//_saveOperation.WebPage = this.Page;
//_saveOperation.Xml_File = "SYNFollow.xml";
//_saveOperation.SaveMethod();
//TUSHAR:- To Save Visit From SYN Doctor Screen
ArrayList _VisitInfo = new ArrayList();
_VisitInfo.Add(txtEventID.Text);
_VisitInfo.Add(TXT_PATIENT_LAST_NAME.Text);
_VisitInfo.Add(TXT_PATIENT_FIRST_NAME.Text);
_VisitInfo.Add(TXT_DOA.Text);
_VisitInfo.Add(TXT_CURRENT_DATE.Text);
_VisitInfo.Add(DrpDoctorNotes.SelectedItem.Text.ToString() + " " + txtDoctorNotes.Text);
_VisitInfo.Add(DrpTreatmentTime.SelectedItem.Text.ToString());
_VisitInfo.Add(Slider2.Text);
_VisitInfo.Add(Slider4.Text);
_VisitInfo.Add(Listbias.SelectedValue.ToString());
_VisitInfo.Add(Slider1.Text);
_VisitInfo.Add(extddlArea.Selected_Text.ToString());
_objCheckoutBO.Add_SYN_Visit(_VisitInfo);
//End Of Code
for (int i = 0; i < grdProcedure.Rows.Count; i++)
{
CheckBox chkDelete1 = (CheckBox)grdProcedure.Rows[i].FindControl("ChkProcId");
if (chkDelete1.Checked)
{
string ProcId = grdProcedure.Rows[i].Cells[2].Text;
SaveValues(ProcId);
}
}
// check button for save or update
if (css_btnSave.Text == "UPDATE TREATMENTS")
{
// FillPDFValue(txtEventID.Text, txtCompanyID.Text, sz_CompanyName);
}
else if (css_btnSave.Text == "SAVE TREATMENTS")
{
// Page.ClientScript.RegisterClientScriptBlock(typeof(GridView), "Msg", "window.open('Bill_Sys_AC_Accu_FollowUP_PatientSign.aspx','Sign','toolbar=no,directories=no,menubar=no,scrollbars=no,status=no,resizable=no,width=700,height=575'); ", true);
// Page.ClientScript.RegisterClientScriptBlock(typeof(GridView), "Msg", "window.open('Bill_Sys_AC_Accu_Followup_Signature.aspx','Sign','toolbar=no,directories=no,menubar=no,scrollbars=no,status=no,resizable=no,width=700,height=575'); ", true);
}
bool _checkImage = true;
_checkImage = _objCheckoutBO.checkImageForSynFollowup(txtEventID.Text);
if (_checkImage == true)
{
css_btnSave.Text = "UPDATE TREATMENTS";
}
else
{
css_btnSave.Text = "SAVE TREATMENTS";
}
grdProcedure.Columns[2].Visible = false;
btnDiagnosysCodes.Enabled = true;
savecomplaints();
}
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)
{
btnSave.Attributes.Add("onclick", "return formValidator('form1','ddlStatus');");
btnDelete.Attributes.Add("onclick", "return ConfirmDelete();");
if (!IsPostBack)
{
BindTimeControl();
string id = Request.QueryString["id"].ToString();
txtEventID.Text = id;
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
DataTable dt = new DataTable();
dt = _bill_Sys_Calender.GET_EVENT_DETAIL(id);
if (dt.Rows.Count > 0)
{
for (int drRow = 0; drRow <= dt.Rows.Count - 1; drRow++)
{
lblDoctorName.Text = dt.Rows[drRow].ItemArray.GetValue(0).ToString();
lblType.Text = dt.Rows[drRow].ItemArray.GetValue(1).ToString();
lblHours.Text = dt.Rows[drRow].ItemArray.GetValue(3).ToString();
lblMinutes.Text = dt.Rows[drRow].ItemArray.GetValue(4).ToString();
lblTime.Text = dt.Rows[drRow].ItemArray.GetValue(5).ToString();
lblEndHours.Text = dt.Rows[drRow].ItemArray.GetValue(6).ToString();
lblEndMinutes.Text = dt.Rows[drRow].ItemArray.GetValue(7).ToString();
lblEndTime.Text = dt.Rows[drRow].ItemArray.GetValue(8).ToString();
txtNotes.Text = dt.Rows[drRow].ItemArray.GetValue(9).ToString();
lblDoctorID.Text = dt.Rows[drRow].ItemArray.GetValue(10).ToString();
lblTypeCode.Text = dt.Rows[drRow].ItemArray.GetValue(11).ToString();
lblPatientID.Text = dt.Rows[drRow].ItemArray.GetValue(12).ToString();
lblDate.Text = dt.Rows[drRow].ItemArray.GetValue(13).ToString();
ddlStatus.SelectedValue = dt.Rows[drRow].ItemArray.GetValue(15).ToString();
txtCaseID.Text = dt.Rows[drRow].ItemArray.GetValue(16).ToString();
if (_bill_Sys_Calender.CheckReferralExists(lblDoctorID.Text, ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID) == true)
{
if (ddlStatus.SelectedValue == "2")
{
ddlTestNames.DataSource = _bill_Sys_Calender.GetAssociatedProcCodeList(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID, dt.Rows[drRow].ItemArray.GetValue(10).ToString(), "GETCOMPLETEVISITCODE", txtCaseID.Text, id);
}
else
{
ddlTestNames.DataSource = _bill_Sys_Calender.GetAssociatedProcCodeList(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID, dt.Rows[drRow].ItemArray.GetValue(10).ToString(), "GETALLCODE", txtCaseID.Text, id);
}
ddlTestNames.DataTextField = "DESCRIPTION";
ddlTestNames.DataValueField = "CODE";
ddlTestNames.DataBind();
}
else
{
ddlTestNames.DataSource = _bill_Sys_Calender.GetReferringProcCodeList(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID, dt.Rows[drRow].ItemArray.GetValue(10).ToString());
ddlTestNames.DataTextField = "DESCRIPTION";
ddlTestNames.DataValueField = "CODE";
ddlTestNames.DataBind();
}
// if (dt.Rows[drRow].ItemArray.GetValue(14).ToString() == "True" || ddlStatus.SelectedValue=="2" )
// {
//btnUpdate.Visible = true;
ds = new DataSet();
_patient_TVBO = new Patient_TVBO();
ds = _patient_TVBO.GetAppointProcCode(Convert.ToInt32(id));
foreach (DataRow dr in ds.Tables[0].Rows)
{
foreach (ListItem lst in ddlTestNames.Items)
{
if (lst.Value == dr.ItemArray.GetValue(0).ToString())
{
lst.Selected = true;
}
}
}
//}
if (ddlStatus.SelectedValue != "0")
{
lblMessage.Visible = true;
lblMessage.Text = ddlStatus.SelectedItem.Text;
btnSave.Visible = false;
}
if (dt.Rows[drRow]["BT_STATUS"].ToString().ToLower() == "false")
{
btnDelete.Visible = true;
}
else
{
btnDelete.Visible = false;
}
}
}
GETAppointPatientDetail(Convert.ToInt32(id));
//}
}
#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("ViwScheduled.aspx");
}
#endregion
}
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_Visit_BO = new Bill_Sys_Visit_BO();
objAdd = new ArrayList();
Bill_Sys_Calender _bill_Sys_Calender;
string eventId = Request.QueryString["eventId"].ToString();
try
{
if (Convert.ToDateTime(txtAppointmentDate.Text) > Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")) && ddlStatus.SelectedValue == "2")
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "ss", "<script language='javascript'>alert('Visit for future date cannot be completed...!');</script>");
}
else
{
//////////
//Boolean iEvisitExists = false;
//Boolean visitExists = false;
//Boolean reVisitExists = false;
//SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings.Get("MyConnectionString"));
//SqlCommand comd = new SqlCommand("SP_CHECK_UPDATE_INITIALE_VALUATIONEXISTS");
//comd.CommandType = CommandType.StoredProcedure;
//comd.Connection = con;
//comd.Connection.Open();
//comd.Parameters.AddWithValue("@SZ_CASE_ID", ((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_ID);
//comd.Parameters.AddWithValue("@SZ_COMPANY_ID", ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
//comd.Parameters.AddWithValue("@SZ_PATIENT_ID", ((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_PATIENT_ID);
//comd.Parameters.AddWithValue("@SZ_DOCTOR_ID", extddlDoctor.Text);
//comd.Parameters.AddWithValue("@VISIT_DATE", txtAppointmentDate.Text);
//comd.Parameters.AddWithValue("@I_EVENT_ID", eventId);
////int intCountVisits = Convert.ToInt32(comd.ExecuteScalar());
//if (ddlStatus.SelectedValue == "1") { comd.Parameters.AddWithValue("@RE_VISIT_DATE", txtReDate.Text); }
//SqlParameter objIEExists = new SqlParameter("@INITIAL_EXISTS", SqlDbType.Bit);
//objIEExists.Direction = ParameterDirection.Output;
//comd.Parameters.Add(objIEExists);
//SqlParameter objVisitStatus = new SqlParameter("@VISIT_EXISTS", SqlDbType.Bit, 20);
//objVisitStatus.Direction = ParameterDirection.Output;
//comd.Parameters.Add(objVisitStatus);
//SqlParameter objReVisitStatus = new SqlParameter("@RE_VISIT_EXISTS", SqlDbType.Bit, 20);
//objReVisitStatus.Direction = ParameterDirection.Output;
//comd.Parameters.Add(objReVisitStatus);
//comd.ExecuteNonQuery();
//comd.Connection.Close();
//iEvisitExists = Convert.ToBoolean(objIEExists.Value);
//visitExists = Convert.ToBoolean(objVisitStatus.Value);
//if (objReVisitStatus.Value.ToString() != "") reVisitExists = Convert.ToBoolean(objReVisitStatus.Value);
//if (iEvisitExists == false && extddlVisitType.Selected_Text != "IE")
//{
// lblMsg.Text = "Schedule can not be saved patient is visiting first time hence there visit type should be Initial Evaluation.";
// lblMsg.Focus();
// lblMsg.Visible = true;
// return;
//}
//if (iEvisitExists == true && extddlVisitType.Selected_Text == "IE")
//{
// lblMsg.Text = "Schedule can not be saved because patient already has Initial Evaluation.";
// lblMsg.Focus();
// lblMsg.Visible = true;
// return;
//}
//if (visitExists == true && ddlStatus.SelectedValue!="1")
//{
// lblMsg.Text = "Schedule can not be saved because patient already has this visit";
// lblMsg.Focus();
// lblMsg.Visible = true;
// return;
//}
//if (reVisitExists == true && ddlStatus.SelectedValue == "1" && txtReEventID.Text == "")
//{
// lblMsg.Text = "Schedule can not be saved because patient already has visit on re-schedule date";
// lblMsg.Focus();
// lblMsg.Visible = true;
// return;
//}
/////////
////////////RE-Schedule
////////////RE-Schedule add
int reendMin = Convert.ToInt32(ddlReSchMinutes.SelectedValue) + Convert.ToInt32(30);
int reendHr = Convert.ToInt32(ddlReSchHours.SelectedValue);
string reendTime = ddlReSchTime.SelectedValue;
if (reendMin >= 60)
{
reendMin = reendMin - 60;
reendHr = reendHr + 1;
if (reendHr > 12)
{
reendHr = reendHr - 12;
if (ddlReSchHours.SelectedValue != "12")
{
if (reendTime == "AM")
{
reendTime = "PM";
}
else if (reendTime == "PM")
{
reendTime = "AM";
}
}
}
else if (reendHr == 12)
{
if (ddlReSchHours.SelectedValue != "12")
{
if (reendTime == "AM")
{
reendTime = "PM";
}
else if (reendTime == "PM")
{
reendTime = "AM";
}
}
}
}
if (ddlStatus.SelectedValue == "1" && txtReEventID.Text == "")
{
_bill_Sys_Calender = new Bill_Sys_Calender();
objAdd = new ArrayList();
objAdd.Add(txtCaseID.Text); //Case Id
objAdd.Add(txtReDate.Text); //Appointment date
objAdd.Add(ddlReSchHours.SelectedValue.ToString() + "." + ddlReSchMinutes.SelectedValue.ToString()); //Appointment time
objAdd.Add(""); //Notes
objAdd.Add(extddlDoctor.Text);
objAdd.Add("TY000000000000000003");
objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
objAdd.Add(ddlReSchTime.SelectedValue);
objAdd.Add(reendHr.ToString().PadLeft(2, '0') + "." + reendMin.ToString().PadLeft(2, '0'));
objAdd.Add(reendTime);
if (Convert.ToDateTime(txtReDate.Text) >= Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")))
{
objAdd.Add("0");
}
else
{
objAdd.Add("2");
}
objAdd.Add(extddlVisitType.Text);
_bill_Sys_Calender.SaveEvent(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
ArrayList objGetEvent = new ArrayList();
objGetEvent.Add(txtCaseID.Text);
objGetEvent.Add(extddlDoctor.Text);
objGetEvent.Add(txtCompanyID.Text);
int reeventID = _bill_Sys_Calender.GetEventID(objGetEvent);
txtReEventID.Text = reeventID.ToString();
foreach (ListItem lstItem in ddlTestNames.Items)
{
if (lstItem.Selected == true)
{
objAdd = new ArrayList();
objAdd.Add(lstItem.Value);
objAdd.Add(reeventID);
if (Convert.ToDateTime(txtReDate.Text) >= Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")))
{
objAdd.Add("0");
}
else
{
objAdd.Add("2");
}
_bill_Sys_Calender.Save_Event_RefferPrcedure(objAdd);
}
}
// Start : Save appointment Notes.
_DAO_NOTES_EO = new DAO_NOTES_EO();
_DAO_NOTES_EO.SZ_MESSAGE_TITLE = "APPOINTMENT_ADDED";
_DAO_NOTES_EO.SZ_ACTIVITY_DESC = "Date : " + txtReDate.Text;
_DAO_NOTES_BO = new DAO_NOTES_BO();
_DAO_NOTES_EO.SZ_USER_ID = ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID;
_DAO_NOTES_EO.SZ_CASE_ID = ((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_ID;
_DAO_NOTES_EO.SZ_COMPANY_ID = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
_DAO_NOTES_BO.SaveActivityNotes(_DAO_NOTES_EO);
lblMsg.Visible = true;
lblMsg.Text = "Appointment Added successfully.";
}
////////////RE-Schedule add
////////////RE-Schedule Update
else if (ddlStatus.SelectedValue == "1" && txtReEventID.Text != "")
{
_bill_Sys_Calender = new Bill_Sys_Calender();
objAdd = new ArrayList();
objAdd.Add(txtReEventID.Text); //event Id
objAdd.Add(txtCaseID.Text); //Case Id
objAdd.Add(txtReDate.Text); //Appointment date
objAdd.Add(ddlReSchHours.SelectedValue.ToString() + "." + ddlReSchMinutes.SelectedValue.ToString()); //Appointment time
objAdd.Add(""); //Notes
objAdd.Add(extddlDoctor.Text);
objAdd.Add("TY000000000000000003");
objAdd.Add(txtCompanyID.Text);
objAdd.Add(ddlReSchTime.SelectedValue);
objAdd.Add(reendHr.ToString().PadLeft(2, '0') + "." + reendMin.ToString().PadLeft(2, '0'));
objAdd.Add(reendTime);
if (Convert.ToDateTime(txtReDate.Text) >= Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")))
{
objAdd.Add("0");
}
else
{
objAdd.Add("2");
}
objAdd.Add(extddlVisitType.Text);
_bill_Sys_Calender.UPDATEEvent(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
_bill_Sys_Calender.Delete_Event_RefferPrcedure(Convert.ToInt32(txtReEventID.Text));
foreach (ListItem lstItem in ddlTestNames.Items)
{
if (lstItem.Selected == true)
{
objAdd = new ArrayList();
objAdd.Add(lstItem.Value);
objAdd.Add(txtReEventID.Text);
if (ddlTestNames.Visible == true && Convert.ToDateTime(txtAppointmentDate.Text) >= Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")))
{
objAdd.Add("0");
}
else
{
objAdd.Add("2");
}
_bill_Sys_Calender.Save_Event_RefferPrcedure(objAdd);
}
}
}
////////////RE-Schedule Update
////////////RE-Schedule
_bill_Sys_Calender = new Bill_Sys_Calender();
objAdd = new ArrayList();
objAdd.Add(eventId); //event Id
objAdd.Add(txtCaseID.Text); //Case Id
objAdd.Add(txtAppointmentDate.Text); //Appointment date
objAdd.Add(ddlHours.SelectedValue.ToString() + "." + ddlMinutes.SelectedValue.ToString()); //Appointment time
objAdd.Add(""); //Notes
objAdd.Add(extddlDoctor.Text);
objAdd.Add("TY000000000000000003");
objAdd.Add(txtCompanyID.Text);
int endMin = Convert.ToInt32(ddlMinutes.SelectedValue) + Convert.ToInt32(30);
int endHr = Convert.ToInt32(ddlHours.SelectedValue);
string endTime = ddlTime.SelectedValue;
if (endMin >= 60)
{
endMin = endMin - 60;
endHr = endHr + 1;
if (endHr > 12)
{
endHr = endHr - 12;
if (ddlHours.SelectedValue != "12")
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
else if (endHr == 12)
{
if (ddlHours.SelectedValue != "12")
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
}
objAdd.Add(ddlTime.SelectedValue);
objAdd.Add(endHr.ToString().PadLeft(2, '0') + "." + endMin.ToString().PadLeft(2, '0'));
objAdd.Add(endTime);
objAdd.Add(ddlStatus.SelectedValue);
objAdd.Add(extddlVisitType.Text);
if (ddlStatus.SelectedValue == "1")
{
objAdd.Add(txtReEventID.Text);
objAdd.Add(txtReDate.Text);
}
_bill_Sys_Calender.UPDATEEvent(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
_bill_Sys_Calender.Delete_Event_RefferPrcedure(Convert.ToInt32(eventId));
ArrayList Olditems = new ArrayList();
foreach (ListItem lstItem in ddlTestNames.Items)
{
if (lstItem.Selected == true)
{
objAdd = new ArrayList();
objAdd.Add(lstItem.Value);
objAdd.Add(eventId);
if (ddlTestNames.Visible == true && Convert.ToDateTime(txtAppointmentDate.Text) >= Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")))
{
objAdd.Add("0");
}
else
{
objAdd.Add("2");
}
_bill_Sys_Calender.Save_Event_RefferPrcedure(objAdd);
}
if (ddlOldTestNames.Items.FindByValue(lstItem.Value).Selected == true && lstItem.Selected == false)
{
Olditems.Add(lstItem.Value);
}
}
//////////If appointment is updated from schedule to completed and remove any existing treatments
if (txtVisitStatus.Text == "0" && ddlStatus.SelectedValue != "0" && Olditems.Count > 0)
{
_bill_Sys_Calender = new Bill_Sys_Calender();
objAdd = new ArrayList();
objAdd.Add(txtCaseID.Text); //Case Id
objAdd.Add(txtAppointmentDate.Text); //Appointment date
objAdd.Add(ddlHours.SelectedValue.ToString() + "." + ddlMinutes.SelectedValue.ToString()); //Appointment time
objAdd.Add(""); //Notes
objAdd.Add(extddlDoctor.Text);
objAdd.Add("TY000000000000000003");
objAdd.Add(txtCompanyID.Text);
objAdd.Add(ddlTime.SelectedValue);
objAdd.Add(endHr.ToString().PadLeft(2, '0') + "." + endMin.ToString().PadLeft(2, '0'));
objAdd.Add(endTime);
objAdd.Add("0");
objAdd.Add(extddlVisitType.Text);
_bill_Sys_Calender.SaveEvent(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
ArrayList objOldGetEvent = new ArrayList();
objOldGetEvent.Add(txtCaseID.Text);
objOldGetEvent.Add(extddlDoctor.Text);
objOldGetEvent.Add(txtCompanyID.Text);
int neweventID = _bill_Sys_Calender.GetEventID(objOldGetEvent);
foreach (Object obj in Olditems)
{
objAdd = new ArrayList();
objAdd.Add(obj.ToString());
objAdd.Add(neweventID);
objAdd.Add("0");
_bill_Sys_Calender.Save_Event_RefferPrcedure(objAdd);
}
}
//////////If appointment is updated from schedule to completed and remove any existing treatments
// Start : Save appointment Notes.
_DAO_NOTES_EO = new DAO_NOTES_EO();
_DAO_NOTES_EO.SZ_MESSAGE_TITLE = "APPOINTMENT_ADDED";
_DAO_NOTES_EO.SZ_ACTIVITY_DESC = "Date : " + txtAppointmentDate.Text;
_DAO_NOTES_BO = new DAO_NOTES_BO();
_DAO_NOTES_EO.SZ_USER_ID = ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID;
_DAO_NOTES_EO.SZ_CASE_ID = ((Bill_Sys_CaseObject)Session["CASE_OBJECT"]).SZ_CASE_ID;
_DAO_NOTES_EO.SZ_COMPANY_ID = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
_DAO_NOTES_BO.SaveActivityNotes(_DAO_NOTES_EO);
lblMsg.Visible = true;
lblMsg.Text = "Appointment Updated successfully.";
if (Request.QueryString["GRD_ID"] != null)
{
Session["GRD_ID"] = Request.QueryString["GRD_ID"].ToString();
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "ss", "<script language='javascript'> window.parent.document.location.href='Bill_SysPatientDesk.aspx';window.self.close(); </script>");
}
}
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 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_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
try
{
String szError = "";
#region "Check for Previous Date"
DateTime dtEnteredDate = Convert.ToDateTime(Convert.ToDateTime(txtAppointmentDate.Text).ToString("MM/dd/yyyy") + " " + ddlHours.SelectedValue + ":" + ddlMinutes.SelectedValue + " " + ddlTime.SelectedValue);
DateTime dtEnteredLastDate = dtEnteredDate.AddMinutes(30);
#endregion
#region "Check For Room Days and Time"
Decimal StartTime = 0.00M;
Decimal EndTime = 0.00M;
if (ddlTime.SelectedValue == "PM" && (Convert.ToInt32(ddlHours.SelectedValue) < 12))
{
StartTime = 12.00M + Convert.ToDecimal(ddlHours.SelectedValue.ToString()) + Convert.ToDecimal("." + ddlMinutes.SelectedValue.ToString());
}
else
{
StartTime = Convert.ToDecimal(ddlHours.SelectedValue.ToString()) + Convert.ToDecimal("." + ddlMinutes.SelectedValue.ToString());
}
if (dtEnteredLastDate.ToString("tt") == "PM" && (Convert.ToInt32(dtEnteredLastDate.ToString("hh")) < 12))
{
EndTime = 12M + Convert.ToDecimal(dtEnteredLastDate.ToString("hh") + "." + dtEnteredLastDate.ToString("mm"));
}
else
{
EndTime = Convert.ToDecimal(dtEnteredLastDate.ToString("hh") + "." + dtEnteredLastDate.ToString("mm"));
}
Bill_Sys_RoomDays objRD = new Bill_Sys_RoomDays();
ArrayList objChekList = new ArrayList();
objChekList.Add(extddlRoom.Text);
objChekList.Add(Convert.ToDateTime(txtAppointmentDate.Text).ToString("MM/dd/yyyy"));
objChekList.Add(extddlReferringFacility.Text);
objChekList.Add(StartTime);
objChekList.Add(EndTime);
if (!objRD.checkRoomTiming(objChekList))
{
szError = szError + Convert.ToDateTime(txtAppointmentDate.Text).ToString("MM/dd/yyyy");
}
#endregion
int eventID = Convert.ToInt32(txtEventID.Text);
string sz_date = txtAppointmentDate.Text;
ArrayList objAdd = new ArrayList();
objAdd.Add(txtPatientID.Text);
objAdd.Add(sz_date);
objAdd.Add(ddlHours.SelectedValue.ToString() + "." + ddlMinutes.SelectedValue.ToString());
objAdd.Add(txtNotes.Text);
objAdd.Add(extddlReferringDoctor.Text);
if (ddlTestNames.Items.Count > 1)
{
objAdd.Add(ddlTestNames.Items[1].Value);
}
else
{
objAdd.Add("");
}
objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
objAdd.Add(ddlTime.SelectedValue);
objAdd.Add((Convert.ToInt32(dtEnteredLastDate.ToString("hh")).ToString() + "." + dtEnteredLastDate.ToString("mm").ToString()));
objAdd.Add(dtEnteredLastDate.ToString("tt"));
objAdd.Add(extddlReferringFacility.Text);
objAdd.Add(eventID);
if (chkTransportation.Checked == true)
{
objAdd.Add(1);
}
else
{
objAdd.Add(0);
}
if (chkTransportation.Checked == true && extddlTransport.Text != "NA")
{
objAdd.Add(Convert.ToInt32(extddlTransport.Text));
}
else
{
objAdd.Add(null);
}
eventID = _bill_Sys_Calender.UPDATE_Event_Referral(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
#region "Update Procedure Codes"
_bill_Sys_Calender.Delete_Event_RefferPrcedure(eventID);
foreach (ListItem lst in ddlTestNames.Items)
{
if (lst.Selected == true)
{
objAdd = new ArrayList();
objAdd.Add(lst.Value);
objAdd.Add(eventID);
if (((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).BT_REFERRING_FACILITY == true)
{
objAdd.Add(2);
}
else
{
objAdd.Add(0);
}
_bill_Sys_Calender.Save_Event_RefferPrcedure(objAdd);
}
}
if (szError == "")
{
lblMsg.Text = "Appointment scheduled successfully.";
if (Request.QueryString["GRD_ID"] != null)
{
Session["GRD_ID"] = Request.QueryString["GRD_ID"].ToString();
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "ss", "<script language='javascript'> window.parent.document.location.href='Bill_SysPatientDesk.aspx';window.self.close(); </script>");
}
else
{
Bill_Sys_RoomDays objRD1 = new Bill_Sys_RoomDays();
String szStartTime = objRD1.getRoomStart_EndTime(extddlRoom.Text, txtAppointmentDate.Text, extddlReferringFacility.Text);
lblMsg.Text = " Add appointment between ---> ";
lblMsg.Text = lblMsg.Text + szStartTime;
lblMsg.Focus();
lblMsg.Visible = true;
}
#endregion
}
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 string SaveEvent(ArrayList arrEventInfo)
{
string szResult = "";
conn = new SqlConnection(strConn);
conn.Open();
SqlTransaction transaction;
transaction = conn.BeginTransaction();
try
{
for (int icount = 0; icount < arrEventInfo.Count; icount++)
{
Bill_Sys_Event_DAO objEvent = new Bill_Sys_Event_DAO();
objEvent = (Bill_Sys_Event_DAO)arrEventInfo[icount];
comm = new SqlCommand();
comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
comm.CommandText = "SP_TXN_CALENDAR_EVENT";
comm.CommandType = CommandType.StoredProcedure;
comm.Connection = conn;
comm.Transaction = transaction;
comm.Parameters.AddWithValue("@SZ_CASE_ID ", objEvent.SZ_CASE_ID);
comm.Parameters.AddWithValue("@DT_EVENT_DATE", objEvent.DT_EVENT_DATE);
comm.Parameters.AddWithValue("@DT_EVENT_TIME", objEvent.DT_EVENT_TIME);
comm.Parameters.AddWithValue("@SZ_EVENT_NOTES", objEvent.SZ_EVENT_NOTES);
comm.Parameters.AddWithValue("@SZ_DOCTOR_ID", objEvent.SZ_DOCTOR_ID);
comm.Parameters.AddWithValue("@SZ_TYPE_CODE_ID", objEvent.SZ_TYPE_CODE_ID);
comm.Parameters.AddWithValue("@SZ_COMPANY_ID", objEvent.SZ_COMPANY_ID);
comm.Parameters.AddWithValue("@DT_EVENT_TIME_TYPE", objEvent.DT_EVENT_TIME_TYPE);
comm.Parameters.AddWithValue("@DT_EVENT_END_TIME", objEvent.DT_EVENT_END_TIME);
comm.Parameters.AddWithValue("@DT_EVENT_END_TIME_TYPE", objEvent.DT_EVENT_END_TIME_TYPE);
comm.Parameters.AddWithValue("@FLAG", "ADD");
comm.Parameters.AddWithValue("@I_STATUS", "0");
comm.Parameters.AddWithValue("@SZ_USER_ID", objEvent.SZ_USER_ID);
comm.Parameters.AddWithValue("@SZ_VISIT_TYPE", objEvent.SZ_VISIT_TYPE);
comm.ExecuteNonQuery();
int eventID = 0;
comm = new SqlCommand();
comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
comm.CommandText = "GET_EVENT_ID";
comm.CommandType = CommandType.StoredProcedure;
comm.Connection = conn;
comm.Transaction = transaction;
comm.Parameters.AddWithValue("@SZ_CASE_ID ", objEvent.SZ_CASE_ID);
comm.Parameters.AddWithValue("@SZ_DOCTOR_ID", objEvent.SZ_DOCTOR_ID);
comm.Parameters.AddWithValue("@SZ_COMPANY_ID", objEvent.SZ_COMPANY_ID);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
if (dr[0] != DBNull.Value)
{
eventID = (int)dr[0];
}
}
dr.Close();
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
if (_bill_Sys_Calender.CheckReferralExists(objEvent.SZ_DOCTOR_ID, objEvent.SZ_COMPANY_ID) == true)
{
comm = new SqlCommand();
comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
comm.CommandText = "UPDATE_EVENT_STATUS";
comm.CommandType = CommandType.StoredProcedure;
comm.Connection = conn;
comm.Transaction = transaction;
comm.Parameters.AddWithValue("@I_EVENT_ID ", eventID.ToString());
comm.Parameters.AddWithValue("@BT_STATUS", "false");
comm.Parameters.AddWithValue("@I_STATUS", "0");
comm.ExecuteNonQuery();
}
string szActiveDesc = "Date : " + objEvent.DT_EVENT_DATE + objEvent.DT_EVENT_TIME + objEvent.DT_EVENT_TIME_TYPE;
XmlDocument doc = new XmlDocument();
doc.Load(AppDomain.CurrentDomain.BaseDirectory.ToString() + "XML/ActivityNotesXML.xml");
XmlNodeList nl = doc.SelectNodes("NOTES/" + "APPOINTMENT_ADDED" + "/MESSAGE");
string strMessage = szActiveDesc + " " + nl.Item(0).InnerText;
comm = new SqlCommand();
comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
comm.CommandText = "SP_TXN_NOTES";
comm.CommandType = CommandType.StoredProcedure;
comm.Connection = conn;
comm.Transaction = transaction;
comm.Parameters.AddWithValue("@SZ_NOTE_CODE", "NOT1004");
comm.Parameters.AddWithValue("@SZ_CASE_ID", objEvent.SZ_CASE_ID);
comm.Parameters.AddWithValue("@SZ_USER_ID", objEvent.SZ_USER_ID);
comm.Parameters.AddWithValue("@SZ_NOTE_TYPE", "NTY0001");
comm.Parameters.AddWithValue("@SZ_NOTE_DESCRIPTION", strMessage);
comm.Parameters.AddWithValue("@IS_DENIED", objEvent.IS_DENIED);
comm.Parameters.AddWithValue("@SZ_COMPANY_ID", objEvent.SZ_COMPANY_ID);
comm.Parameters.AddWithValue("@FLAG", "ADD");
comm.ExecuteNonQuery();
}
transaction.Commit();
szResult = "success";
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
transaction.Rollback();
}
finally
{
conn.Close();
}
return(szResult);
}
protected void btnSave_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());
}
try
{
Boolean _valid = true;
if (ddlStatus.SelectedValue == "1")
{
if (txtReScheduleDate.Text == "" && ddlReSchHours.SelectedValue == "00")
{
lblMessage.Text = "Please enter Res-Schedule Date and Time";
_valid = false;
}
}
else if (ddlStatus.SelectedValue == "2")
{
if (ddlTestNames.GetSelectedIndices().Length == 0)
{
lblMessage.Text = "Please select procedure";
_valid = false;
}
DateTime dtPassDate;
dtPassDate = Convert.ToDateTime(lblDate.Text);
if (dtPassDate > DateTime.Now)
{
lblMessage.Text = "Cannot complete visit at future date.";
_valid = false;
}
}
else if (ddlStatus.SelectedValue == "3")
{
DateTime dtPassDate;
dtPassDate = Convert.ToDateTime(lblDate.Text);
if (dtPassDate > DateTime.Now)
{
lblMessage.Text = "Cannot no show visit at future date.";
_valid = false;
}
}
if (_valid == true)
{
string eventID = Request.QueryString["id"].ToString();
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
ArrayList objAdd;
if (ddlStatus.SelectedValue == "2")
{
foreach (ListItem lst in ddlTestNames.Items)
{
if (lst.Selected == true)
{
objAdd = new ArrayList();
objAdd.Add(lst.Value);
objAdd.Add(eventID);
objAdd.Add(ddlStatus.SelectedValue);
_bill_Sys_Calender.Update_Event_RefferPrcedure(objAdd);
Bill_Sys_ReferalEvent _bill_Sys_ReferalEvent = new Bill_Sys_ReferalEvent();
ArrayList arrOBJ = new ArrayList();
arrOBJ.Add(lblDoctorID.Text);
arrOBJ.Add(lst.Value);
arrOBJ.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
arrOBJ.Add(lst.Value);
_bill_Sys_ReferalEvent.AddDoctorAmount(arrOBJ);
_bill_Sys_Calender.UpdateProcedure(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID, lblDoctorID.Text, lst.Value, true, "");
}
else
{
_bill_Sys_Calender.UpdateProcedure(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID, lblDoctorID.Text, lst.Value, false, eventID);
}
}
}
else if (ddlStatus.SelectedValue == "1")
{
objAdd = new ArrayList();
objAdd.Add(txtCaseID.Text);
objAdd.Add(txtReScheduleDate.Text);
objAdd.Add(ddlReSchHours.SelectedValue.ToString() + "." + ddlReSchMinutes.SelectedValue.ToString());
objAdd.Add(txtNotes.Text);
objAdd.Add(lblDoctorID.Text);
objAdd.Add(lblTypeCode.Text);
objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
objAdd.Add(ddlReSchTime.SelectedValue);
////////////////
int endMin = Convert.ToInt32(ddlReSchMinutes.SelectedValue) + Convert.ToInt32("30");
int endHr = Convert.ToInt32(ddlReSchHours.SelectedValue);
string endTime = ddlReSchTime.SelectedValue;
if (endMin >= 60)
{
endMin = endMin - 60;
endHr = endHr + 1;
if (endHr > 12)
{
endHr = endHr - 12;
if (ddlReSchHours.SelectedValue != "12")
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
else if (endHr == 12)
{
if (ddlReSchHours.SelectedValue != "12")
{
if (endTime == "AM")
{
endTime = "PM";
}
else if (endTime == "PM")
{
endTime = "AM";
}
}
}
}
//ddlEndHours.SelectedValue = endHr.ToString().PadLeft(2, '0');
//ddlEndMinutes.SelectedValue = endMin.ToString().PadLeft(2, '0');
//ddlEndTime.SelectedValue = endTime.ToString();
/////////////////
objAdd.Add(endHr.ToString().PadLeft(2, '0').ToString() + "." + endMin.ToString().PadLeft(2, '0').ToString());
objAdd.Add(endTime.ToString());
_bill_Sys_Calender.SaveEvent(objAdd, ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID.ToString());
objAdd = new ArrayList();
objAdd.Add(txtCaseID.Text);
objAdd.Add(lblDoctorID.Text);
objAdd.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
int reScheventID = _bill_Sys_Calender.GetEventID(objAdd);
if (_bill_Sys_Calender.CheckReferralExists(lblDoctorID.Text, ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID) == true)
{
foreach (ListItem lstItem in ddlTestNames.Items)
{
if (lstItem.Selected == true)
{
objAdd = new ArrayList();
objAdd.Add(lstItem.Value);
objAdd.Add(reScheventID);
objAdd.Add(0);
_bill_Sys_Calender.Update_Event_RefferPrcedure(objAdd, eventID);
// _bill_Sys_Calender.Save_Event_RefferPrcedure(objAdd);
_bill_Sys_Calender.UpdateProcedure(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID, lblDoctorID.Text, lstItem.Value, true, "");
}
else
{
_bill_Sys_Calender.UpdateProcedure(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID, lblDoctorID.Text, lstItem.Value, false, reScheventID.ToString());
}
}
}
}
_bill_Sys_Calender = new Bill_Sys_Calender();
objAdd = new ArrayList();
objAdd.Add(eventID);
objAdd.Add(false);
objAdd.Add(ddlStatus.SelectedValue);
_bill_Sys_Calender.UPDATE_Event_Status(objAdd);
// Start : Save appointment Notes.
_DAO_NOTES_EO = new DAO_NOTES_EO();
_DAO_NOTES_EO.SZ_MESSAGE_TITLE = "APPOINTMENT_UPDATED";
// _DAO_NOTES_EO.SZ_ACTIVITY_DESC = "Date : " + lblDate.Text;
_DAO_NOTES_EO.SZ_ACTIVITY_DESC = "Date : " + lblDate.Text.Substring(0, lblDate.Text.IndexOf(" ")) + " " + lblHours.Text + ":" + lblMinutes.Text + " " + lblTime.Text;
_DAO_NOTES_BO = new DAO_NOTES_BO();
_DAO_NOTES_EO.SZ_USER_ID = ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_ID;
_DAO_NOTES_EO.SZ_CASE_ID = txtCaseID.Text;
_DAO_NOTES_EO.SZ_COMPANY_ID = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID;
_DAO_NOTES_BO.SaveActivityNotes(_DAO_NOTES_EO);
// End
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "ss", "<script language='javascript'> parent.document.getElementById('divid').style.visibility = 'hidden';window.parent.document.location.href=window.parent.document.location.href;window.self.close();window.parent.document.location.reload(); parent.document.getElementById('lblMsg').value='Event added successfully.';</script>");
}
}
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 DisplayCalender(DateTime _date)
{
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 topLabel = "<table id='Calendar1' cellspacing='0' cellpadding='2' rules='all'" +
"title='Calendar' border='1' style='width: 100%; height: 400px; font-size: 9pt;" +
"font-family: Verdana; color: Black; border-width: 1px; border-style: Solid; border-color: Silver;" +
"background-color: White; border-collapse: collapse;'>";
string dayHeader = "<tr>" +
" <th align='center' abbr='Sunday' scope='col' style='border-width: 1px;height: 60px; border-style: solid;background-color:#CCCCCC;" +
" font-size: 8pt; font-weight: bold;'>" +
" Sun</th>" +
"<th align='center' abbr='Monday' scope='col' style='border-width: 1px;height: 60px; border-style: solid;background-color:#CCCCCC;" +
" font-size: 8pt; font-weight: bold;'>" +
" Mon</th>" +
"<th align='center' abbr='Tuesday' scope='col' style='border-width: 1px;height: 60px; border-style: solid;background-color:#CCCCCC;" +
" font-size: 8pt; font-weight: bold; width: 123px;'>" +
" Tue</th>" +
"<th align='center' abbr='Wednesday' scope='col' style='border-width: 1px;height: 60px; border-style: solid;background-color:#CCCCCC;" +
" font-size: 8pt; font-weight: bold;'>" +
" Wed</th>" +
"<th align='center' abbr='Thursday' scope='col' style='border-width: 1px;height: 60px; border-style: solid;background-color:#CCCCCC;" +
" font-size: 8pt; font-weight: bold;'>" +
" Thu</th>" +
"<th align='center' abbr='Friday' scope='col' style='border-width: 1px;height: 60px; border-style: solid;background-color:#CCCCCC;" +
" font-size: 8pt; font-weight: bold;'>" +
" Fri</th>" +
"<th align='center' abbr='Saturday' scope='col' style='border-width: 1px;height: 60px; border-style: solid;background-color:#CCCCCC;" +
" font-size: 8pt; font-weight: bold;'>" +
" Sat</th>" +
"</tr>";
int setNumber = ComputeLastDayOfMonth(_date);
int totalDays = DateTime.DaysInMonth(_date.Year, _date.Month);
string innertabel = "";
int dateStatus = 1;
for (int i = 0; i <= 5; i++)
{
innertabel = innertabel + "<tr>";
for (int j = 1; j <= 7; j++)
{
if (setNumber == j && dateStatus <= totalDays)
{//href='javascript:
string currentDate = _date.Month.ToString() + "/" + dateStatus.ToString() + "/" + _date.Year.ToString();
Bill_Sys_Calender _bill_Sys_Calender = new Bill_Sys_Calender();
ArrayList obj = new ArrayList();
obj.Add(txtCaseID.Text);
obj.Add(((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID);
obj.Add(currentDate);
decimal _percentage = _bill_Sys_Calender.GET_EVENT_PERCENTAGE(obj);
string _color = ParseXML(Server.MapPath("Config/EventColor.xml"), _percentage);
innertabel = innertabel + "<td align='left' valign='top' style='color: #999999; width: 8%; height: 85px; background-color:" + _color + "; '>" +
"<a href='#' onclick=\" var _date = new Date(); _date='" + currentDate + "'; setDiv(_date);\" style='color: Black' title='" + getMonth(_date.Month) + " " + dateStatus.ToString() + "'>" +
"" + dateStatus.ToString() + "</a></td>";
dateStatus = dateStatus + 1;
setNumber = setNumber + 1;
}
else
{
innertabel = innertabel + "<td align='left' valign='top' style='color: #999999; width: 8%; height: 85px;'>" +
"</td>";
}
}
setNumber = 1;
innertabel = innertabel + "</tr>";
}
Cal.InnerHtml = topLabel + dayHeader + innertabel + "</table>";
}
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());
}
}
