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