public calResult fnc_SaveAppointment(calOperation p_objcalOperation, calPatientEO p_objPatientEO, ArrayList p_objALDoctorAmount, calEvent p_objcalEvent, ArrayList p_objALProcedureCodeEO, string UserId) { int iEventID = 0; calResult objReturnResult = new calResult(); conn = new SqlConnection(strsqlCon); conn.Open(); comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); SqlTransaction transaction; transaction = conn.BeginTransaction(); try { if (p_objcalOperation.add_patient == true) { #region "Save Patient Information" comm.CommandText = "SP_MST_PATIENT_DATA_ENTRY"; comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; comm.Transaction = transaction; comm.Parameters.AddWithValue("@SZ_PATIENT_FIRST_NAME", p_objPatientEO.SZ_PATIENT_FIRST_NAME); comm.Parameters.AddWithValue("@SZ_PATIENT_LAST_NAME", p_objPatientEO.SZ_PATIENT_LAST_NAME); comm.Parameters.AddWithValue("@SZ_COMPANY_ID", p_objPatientEO.SZ_COMPANY_ID); comm.Parameters.AddWithValue("@SZ_CASE_TYPE_ID", p_objPatientEO.SZ_CASE_TYPE_ID); if (p_objPatientEO.I_PATIENT_AGE != "") { comm.Parameters.AddWithValue("@I_PATIENT_AGE", p_objPatientEO.I_PATIENT_AGE); } if (p_objPatientEO.SZ_PATIENT_ADDRESS != "") { comm.Parameters.AddWithValue("@SZ_PATIENT_ADDRESS", p_objPatientEO.SZ_PATIENT_ADDRESS); } if (p_objPatientEO.SZ_PATIENT_CITY != "") { comm.Parameters.AddWithValue("@SZ_PATIENT_CITY", p_objPatientEO.SZ_PATIENT_CITY); } if (p_objPatientEO.SZ_PATIENT_PHONE != "") { comm.Parameters.AddWithValue("@SZ_PATIENT_PHONE", p_objPatientEO.SZ_PATIENT_PHONE); } if (p_objPatientEO.SZ_PATIENT_STATE_ID != "" && p_objPatientEO.SZ_PATIENT_STATE_ID != "NA") { comm.Parameters.AddWithValue("@SZ_PATIENT_STATE_ID", p_objPatientEO.SZ_PATIENT_STATE_ID); } if (p_objPatientEO.MI != "") { comm.Parameters.AddWithValue("@MI", p_objPatientEO.MI); } if (p_objPatientEO.SZ_CASE_STATUS_ID != "") { comm.Parameters.AddWithValue("@SZ_CASE_STATUS_ID", p_objPatientEO.SZ_CASE_STATUS_ID); } if (p_objPatientEO.SZ_INSURANCE_ID != "") { comm.Parameters.AddWithValue("@SZ_INSURANCE_ID", p_objPatientEO.SZ_INSURANCE_ID); } if (!UserId.ToString().Equals("")) { comm.Parameters.AddWithValue("@sz_user_id", UserId.ToString()); } comm.Parameters.AddWithValue("@FLAG", "ADD"); comm.ExecuteNonQuery(); #endregion #region "Get Latest Patient ID" comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandText = "SP_MST_PATIENT"; comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; comm.Transaction = transaction; comm.Parameters.AddWithValue("@FLAG", "GET_LATEST_PATIENT_ID"); objDS = new DataSet(); objDAdp = new SqlDataAdapter(comm); objDAdp.Fill(objDS); if (objDS != null) { if (objDS.Tables[0] != null) { p_objcalEvent.SZ_PATIENT_ID = objDS.Tables[0].Rows[0][0].ToString(); } } #endregion } #region "Add Doctor Amount" if (p_objALDoctorAmount != null) { for (int i = 0; i < p_objALDoctorAmount.Count; i++) { if (((calDoctorAmount)p_objALDoctorAmount[i]).SZ_PROCEDURE_ID != "--- Select ---") { comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandText = "SP_TXN_DOCTOR_PROCEDURE_AMOUNT"; comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; comm.Transaction = transaction; comm.Parameters.AddWithValue("@SZ_DOCTOR_ID", ((calDoctorAmount)p_objALDoctorAmount[i]).SZ_DOCTOR_ID); comm.Parameters.AddWithValue("@SZ_PROCEDURE_ID", ((calDoctorAmount)p_objALDoctorAmount[i]).SZ_PROCEDURE_ID); comm.Parameters.AddWithValue("@SZ_COMPANY_ID", ((calDoctorAmount)p_objALDoctorAmount[i]).SZ_COMPANY_ID); comm.Parameters.AddWithValue("@SZ_TYPE_CODE_ID", ((calDoctorAmount)p_objALDoctorAmount[i]).SZ_TYPE_CODE_ID); comm.Parameters.AddWithValue("@FLAG", "ADDREGERRING"); comm.ExecuteNonQuery(); } } } #endregion #region "Add Event" 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 ", p_objcalEvent.SZ_PATIENT_ID); comm.Parameters.AddWithValue("@DT_EVENT_DATE", p_objcalEvent.DT_EVENT_DATE); comm.Parameters.AddWithValue("@DT_EVENT_TIME", p_objcalEvent.DT_EVENT_TIME); comm.Parameters.AddWithValue("@SZ_EVENT_NOTES", p_objcalEvent.SZ_EVENT_NOTES); comm.Parameters.AddWithValue("@SZ_DOCTOR_ID", p_objcalEvent.SZ_DOCTOR_ID); comm.Parameters.AddWithValue("@SZ_TYPE_CODE_ID", p_objcalEvent.SZ_TYPE_CODE_ID); comm.Parameters.AddWithValue("@SZ_COMPANY_ID", p_objcalEvent.SZ_COMPANY_ID); comm.Parameters.AddWithValue("@DT_EVENT_TIME_TYPE", p_objcalEvent.DT_EVENT_TIME_TYPE); comm.Parameters.AddWithValue("@DT_EVENT_END_TIME", p_objcalEvent.DT_EVENT_END_TIME); comm.Parameters.AddWithValue("@DT_EVENT_END_TIME_TYPE", p_objcalEvent.DT_EVENT_END_TIME_TYPE); comm.Parameters.AddWithValue("@SZ_REFERENCE_ID", p_objcalEvent.SZ_REFERENCE_ID); comm.Parameters.AddWithValue("@BT_STATUS", p_objcalEvent.BT_STATUS); comm.Parameters.AddWithValue("@BT_TRANSPORTATION", p_objcalEvent.BT_TRANSPORTATION); if (p_objcalEvent.I_TRANSPORTATION_COMPANY != null) { comm.Parameters.AddWithValue("@I_TRANSPORTATION_COMPANY", p_objcalEvent.I_TRANSPORTATION_COMPANY); } if (p_objcalEvent.SZ_OFFICE_ID != null) { comm.Parameters.AddWithValue("@SZ_OFFICE_ID", p_objcalEvent.SZ_OFFICE_ID); } SqlParameter parmReturnValue = new SqlParameter("@RETURN", SqlDbType.Int); parmReturnValue.Direction = ParameterDirection.ReturnValue; comm.Parameters.Add(parmReturnValue); comm.Parameters.AddWithValue("@FLAG", "ADD2"); comm.Parameters.AddWithValue("@SZ_USER_ID", UserId.ToString()); comm.ExecuteNonQuery(); iEventID = (int)comm.Parameters["@RETURN"].Value; #endregion #region "Add Procedure Codes" if (p_objALProcedureCodeEO != null) { for (int i1 = 0; i1 < p_objALProcedureCodeEO.Count; i1++) { if (((calProcedureCodeEO)p_objALProcedureCodeEO[i1]).SZ_PROC_CODE != "--- Select ---") { comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandText = "SP_SAVE_REFERRAL_PROC_CODE"; comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; comm.Transaction = transaction; comm.Parameters.AddWithValue("@SZ_PROC_CODE ", ((calProcedureCodeEO)p_objALProcedureCodeEO[i1]).SZ_PROC_CODE); comm.Parameters.AddWithValue("@I_EVENT_ID", iEventID); comm.Parameters.AddWithValue("@I_STATUS", ((calProcedureCodeEO)p_objALProcedureCodeEO[i1]).I_STATUS); comm.ExecuteNonQuery(); } } } #endregion transaction.Commit(); #region "Create Result object" objReturnResult.event_id = iEventID.ToString(); objReturnResult.msg = "Patient added successfully !"; objReturnResult.msg_code = "SUCCESS"; #endregion } catch (Exception ex) { objReturnResult = new calResult(); objReturnResult.msg = "Error"; objReturnResult.msg_code = "ERROR"; objReturnResult.event_id = "-1"; transaction.Rollback(); Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } return(objReturnResult); }
public calResult AddVisit(calOperation p_objcalOperation, OutSchedulePatientDAO p_objOutPatientDAO, ArrayList p_objALDoctorAmount, calEvent p_objcalEvent, ArrayList p_objALProcedureCodeEO, string UserId, string roomID, string extddlReferringFacility, string txtCompanyID, string extddlDoctor) { bool PatientExist = false; string newCaseID = ""; string OldPatientID = ""; int iEventID = 0; calResult objReturnResult = new calResult(); conn = new SqlConnection(strsqlCon); conn.Open(); comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); SqlTransaction transaction; transaction = conn.BeginTransaction(); OldPatientID = p_objcalEvent.SZ_PATIENT_ID.ToString(); try { #region "Get Patient Id If It is already exist in test company" comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandText = "SP_GET_PATIENTID_EXIST_IN_OTHER_COMPANY"; comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; comm.Transaction = transaction; comm.Parameters.AddWithValue("@SZ_SOURCE_COMPANY", txtCompanyID); comm.Parameters.AddWithValue("@SZ_DEST_COMPANY", extddlReferringFacility); comm.Parameters.AddWithValue("@SZ_PATIENT_ID", p_objcalEvent.SZ_PATIENT_ID); objDS = new DataSet(); objDAdp = new SqlDataAdapter(comm); objDAdp.Fill(objDS); if (objDS != null) { if (objDS.Tables.Count > 0) { if (objDS.Tables[0] != null) { p_objcalEvent.SZ_PATIENT_ID = objDS.Tables[0].Rows[0][0].ToString(); PatientExist = true; if (p_objcalEvent.SZ_PATIENT_ID.ToString().ToLower() != "null") { PatientExist = true; } } } } #endregion if (p_objcalOperation.add_patient == true) { #region "Save Patient Information" comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandText = "SP_OUT_SCHEDULE_MST_PATIENT_DATA_ENTRY"; comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; comm.Transaction = transaction; comm.Parameters.AddWithValue("@SZ_PATIENT_FIRST_NAME", p_objOutPatientDAO.sPatientFirstName); comm.Parameters.AddWithValue("@SZ_PATIENT_LAST_NAME", p_objOutPatientDAO.sPatientLastName); comm.Parameters.AddWithValue("@SZ_COMPANY_ID", p_objOutPatientDAO.sSourceCompanyID); comm.Parameters.AddWithValue("@SZ_CASE_TYPE_ID", p_objOutPatientDAO.sCaseTypeID); comm.Parameters.AddWithValue("@SZ_TEST_COMPANY_ID", p_objOutPatientDAO.sDestinationCompanyID); if (p_objOutPatientDAO.sPatientAge != "") { comm.Parameters.AddWithValue("@I_PATIENT_AGE", p_objOutPatientDAO.sPatientAge); } if (p_objOutPatientDAO.sPatientAddress != "") { comm.Parameters.AddWithValue("@SZ_PATIENT_ADDRESS", p_objOutPatientDAO.sPatientAddress); } if (p_objOutPatientDAO.sPatientCity != "") { comm.Parameters.AddWithValue("@SZ_PATIENT_CITY", p_objOutPatientDAO.sPatientCity); } if (p_objOutPatientDAO.sPatientPhone != "") { comm.Parameters.AddWithValue("@SZ_PATIENT_PHONE", p_objOutPatientDAO.sPatientPhone); } if (p_objOutPatientDAO.sPatientState != "" && p_objOutPatientDAO.sPatientState != "NA") { comm.Parameters.AddWithValue("@SZ_PATIENT_STATE_ID", p_objOutPatientDAO.sPatientState); } if (p_objOutPatientDAO.sPatientMI != "") { comm.Parameters.AddWithValue("@MI", p_objOutPatientDAO.sPatientMI); } if (p_objOutPatientDAO.sCaseStatusID != "") { comm.Parameters.AddWithValue("@SZ_CASE_STATUS_ID", p_objOutPatientDAO.sCaseStatusID); } if (p_objOutPatientDAO.sInsuranceID != "") { comm.Parameters.AddWithValue("@SZ_INSURANCE_ID", p_objOutPatientDAO.sInsuranceID); } if (!UserId.ToString().Equals("")) { comm.Parameters.AddWithValue("@sz_user_id", UserId.ToString()); } //comm.Parameters.AddWithValue("@FLAG", "ADD"); comm.ExecuteNonQuery(); #endregion } #region "Copy Patient" if (p_objcalOperation.add_patient != true) { comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandText = "sp_add_out_schedule_patient"; comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; comm.Transaction = transaction; comm.Parameters.AddWithValue("@sz_connection_from", extddlReferringFacility); comm.Parameters.AddWithValue("@sz_connection_to", txtCompanyID); comm.Parameters.AddWithValue("@sz_user_id", UserId); comm.Parameters.AddWithValue("@sz_doctor_id", extddlDoctor); comm.Parameters.AddWithValue("@sz_patient_id", p_objcalEvent.SZ_PATIENT_ID); comm.Parameters.AddWithValue("@event_id", iEventID.ToString()); comm.Parameters.AddWithValue("@room_id", roomID); comm.ExecuteNonQuery(); } #endregion //#region "Get Patient Id If It is already exist in test company" //comm = new SqlCommand(); //comm.CommandText = "SP_GET_PATIENTID_EXIST_IN_OTHER_COMPANY"; //comm.CommandType = CommandType.StoredProcedure; //comm.Connection = conn; //comm.Transaction = transaction; //comm.Parameters.AddWithValue("@SZ_SOURCE_COMMPANY", txtCompanyID); //comm.Parameters.AddWithValue("@SZ_DEST_COMPANY", extddlReferringFacility); //comm.Parameters.AddWithValue("@SZ_PATIENT_ID", p_objcalEvent.SZ_PATIENT_ID); //objDS = new DataSet(); //objDAdp = new SqlDataAdapter(comm); //objDAdp.Fill(objDS); //if (objDS != null) //{ // if (objDS.Tables[0] != null) // { // p_objcalEvent.SZ_PATIENT_ID = objDS.Tables[0].Rows[0][0].ToString(); // PatientExist = true; // if (p_objcalEvent.SZ_PATIENT_ID.ToString().ToLower() != "null") // { // PatientExist = true; // } // } //} //#endregion if (!PatientExist) { #region "Get Latest Patient ID" comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandText = "SP_MST_PATIENT"; comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; comm.Transaction = transaction; comm.Parameters.AddWithValue("@FLAG", "GET_LATEST_PATIENT_ID"); objDS = new DataSet(); objDAdp = new SqlDataAdapter(comm); objDAdp.Fill(objDS); if (objDS != null) { if (objDS.Tables[0] != null) { p_objcalEvent.SZ_PATIENT_ID = objDS.Tables[0].Rows[0][0].ToString(); } } #endregion } #region "Add Doctor Amount" if (p_objALDoctorAmount != null) { for (int i = 0; i < p_objALDoctorAmount.Count; i++) { if (((calDoctorAmount)p_objALDoctorAmount[i]).SZ_PROCEDURE_ID != "--- Select ---") { comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandText = "SP_TXN_DOCTOR_PROCEDURE_AMOUNT"; comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; comm.Transaction = transaction; comm.Parameters.AddWithValue("@SZ_DOCTOR_ID", ((calDoctorAmount)p_objALDoctorAmount[i]).SZ_DOCTOR_ID); comm.Parameters.AddWithValue("@SZ_PROCEDURE_ID", ((calDoctorAmount)p_objALDoctorAmount[i]).SZ_PROCEDURE_ID); comm.Parameters.AddWithValue("@SZ_COMPANY_ID", ((calDoctorAmount)p_objALDoctorAmount[i]).SZ_COMPANY_ID); comm.Parameters.AddWithValue("@SZ_TYPE_CODE_ID", ((calDoctorAmount)p_objALDoctorAmount[i]).SZ_TYPE_CODE_ID); comm.Parameters.AddWithValue("@FLAG", "ADDREGERRING"); comm.ExecuteNonQuery(); } } } #endregion #region "Add Event" 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 ", p_objcalEvent.SZ_PATIENT_ID); comm.Parameters.AddWithValue("@DT_EVENT_DATE", p_objcalEvent.DT_EVENT_DATE); comm.Parameters.AddWithValue("@DT_EVENT_TIME", p_objcalEvent.DT_EVENT_TIME); comm.Parameters.AddWithValue("@SZ_EVENT_NOTES", p_objcalEvent.SZ_EVENT_NOTES); comm.Parameters.AddWithValue("@SZ_DOCTOR_ID", p_objcalEvent.SZ_DOCTOR_ID); comm.Parameters.AddWithValue("@SZ_TYPE_CODE_ID", p_objcalEvent.SZ_TYPE_CODE_ID); comm.Parameters.AddWithValue("@SZ_COMPANY_ID", p_objcalEvent.SZ_REFERENCE_ID); comm.Parameters.AddWithValue("@DT_EVENT_TIME_TYPE", p_objcalEvent.DT_EVENT_TIME_TYPE); comm.Parameters.AddWithValue("@DT_EVENT_END_TIME", p_objcalEvent.DT_EVENT_END_TIME); comm.Parameters.AddWithValue("@DT_EVENT_END_TIME_TYPE", p_objcalEvent.DT_EVENT_END_TIME_TYPE); comm.Parameters.AddWithValue("@SZ_REFERENCE_ID", p_objcalEvent.SZ_REFERENCE_ID); comm.Parameters.AddWithValue("@BT_STATUS", p_objcalEvent.BT_STATUS); comm.Parameters.AddWithValue("@BT_TRANSPORTATION", p_objcalEvent.BT_TRANSPORTATION); if (p_objcalEvent.I_TRANSPORTATION_COMPANY != null) { comm.Parameters.AddWithValue("@I_TRANSPORTATION_COMPANY", p_objcalEvent.I_TRANSPORTATION_COMPANY); } if (p_objcalEvent.SZ_OFFICE_ID != null) { comm.Parameters.AddWithValue("@SZ_OFFICE_ID", p_objcalEvent.SZ_OFFICE_ID); } SqlParameter parmReturnValue = new SqlParameter("@RETURN", SqlDbType.Int); parmReturnValue.Direction = ParameterDirection.ReturnValue; comm.Parameters.Add(parmReturnValue); comm.Parameters.AddWithValue("@FLAG", "ADD2"); comm.Parameters.AddWithValue("@SZ_USER_ID", UserId.ToString()); comm.ExecuteNonQuery(); iEventID = (int)comm.Parameters["@RETURN"].Value; #endregion #region "update txn_calendar_event for load out schedule calendar" if (p_objcalOperation.add_patient != true) { comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandText = "sp_out_schedule_calendar_event"; comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; comm.Transaction = transaction; comm.Parameters.AddWithValue("@sz_patient_Id ", OldPatientID); comm.Parameters.AddWithValue("@sz_company_id ", txtCompanyID); comm.Parameters.AddWithValue("@event_id", iEventID); comm.ExecuteNonQuery(); } #endregion #region "Add Procedure Codes" if (p_objALProcedureCodeEO != null) { for (int i1 = 0; i1 < p_objALProcedureCodeEO.Count; i1++) { if (((calProcedureCodeEO)p_objALProcedureCodeEO[i1]).SZ_PROC_CODE != "--- Select ---") { comm = new SqlCommand(); comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); comm.CommandText = "SP_SAVE_REFERRAL_PROC_CODE"; comm.CommandType = CommandType.StoredProcedure; comm.Connection = conn; comm.Transaction = transaction; comm.Parameters.AddWithValue("@SZ_PROC_CODE ", ((calProcedureCodeEO)p_objALProcedureCodeEO[i1]).SZ_PROC_CODE); comm.Parameters.AddWithValue("@I_EVENT_ID", iEventID); comm.Parameters.AddWithValue("@I_STATUS", ((calProcedureCodeEO)p_objALProcedureCodeEO[i1]).I_STATUS); comm.ExecuteNonQuery(); } } } #endregion #region "Copy Patient" //if (p_objcalOperation.add_patient != true) //{ // comm = new SqlCommand(); // comm.CommandText = "sp_add_out_schedule_patient"; // comm.CommandType = CommandType.StoredProcedure; // comm.Connection = conn; // comm.Transaction = transaction; // comm.Parameters.AddWithValue("@sz_connection_from", extddlReferringFacility); // comm.Parameters.AddWithValue("@sz_connection_to", txtCompanyID); // comm.Parameters.AddWithValue("@sz_user_id", UserId); // comm.Parameters.AddWithValue("@sz_doctor_id", extddlDoctor); // comm.Parameters.AddWithValue("@sz_patient_id", p_objcalEvent.SZ_PATIENT_ID); // comm.Parameters.AddWithValue("@event_id", iEventID.ToString()); // comm.Parameters.AddWithValue("@room_id", roomID); // comm.ExecuteNonQuery(); //} #endregion transaction.Commit(); #region "Create Result object" objReturnResult.event_id = iEventID.ToString(); objReturnResult.msg = "Patient added successfully !"; objReturnResult.msg_code = "SUCCESS"; objReturnResult.sz_patient_id = p_objcalEvent.SZ_PATIENT_ID; #endregion } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); objReturnResult = new calResult(); objReturnResult.msg = "Error"; objReturnResult.msg_code = "ERROR"; objReturnResult.event_id = "-1"; transaction.Rollback(); } return(objReturnResult); }