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