public Guid CreateUpdatePSSLink(SmsConfigurationDTO smsConfigurationDto) { string spName = "apt_code.SmsAppointmentService.createUpdateConfigurationData"; try { using (var connection = m_providerFactory.CreateConnection()) { var oracleParameters = ConfigPSSLinkQueryParamsHelper.GetPSSLinkCreateUpdateQueryParams(smsConfigurationDto); var newGuid = SaveAndReturnPK(spName, "l_configurationguid", oracleParameters, connection); return(newGuid); } } catch (Oracle.ManagedDataAccess.Client.OracleException ex) { s_log.ErrorException("CreateUpdateDateTimeFormat (Error from Oracle)", ex); throw new DBOperationException(ex.Message, ex.Number, DBExceptionScenarios.OracleExceptionOccured, ex); } catch (DBOperationException e) { s_log.WarnException("Error Occured in CreateUpdateDateTimeFormat", e); throw; } catch (Exception ex) { s_log.ErrorException("CreateUpdateDateTimeFormat Fails", ex); throw new DBOperationException(ex.Message, DBExceptionScenarios.ExceptionOccured, ex); } }
public List <SmsConfigurationDTO> GetPSSLinkByHospital(long hospitalId) { string spName = "apt_code.SmsAppointmentService.getParameterValues"; try { using (var connection = m_providerFactory.CreateConnection()) { var oracleparams = ConfigPSSLinkQueryParamsHelper.GetPSSLinkSearchQueryParams(hospitalId); var results = connection.Query(spName, oracleparams, commandType: CommandType.StoredProcedure); if (results == null) { s_log.Error("GetDateTimeFormats returned empty or null result."); throw new DBOperationException("GetDateTimeFormats returned empty or null result.", GlobalOptions.DBExceptionScenarios.DBReturnedEmptyOrNullDataSet); } var smsConfigurationDtos = new List <SmsConfigurationDTO>(); foreach (var result in results) { var resultDictionary = result as IDictionary <string, object>; smsConfigurationDtos.Add(mapToSmsConfigurationDto(resultDictionary)); } return(smsConfigurationDtos); } } catch (Oracle.ManagedDataAccess.Client.OracleException ex) { s_log.ErrorException("CreateUpdateDateTimeFormat (Error from Oracle)", ex); throw new DBOperationException(ex.Message, ex.Number, DBExceptionScenarios.OracleExceptionOccured, ex); } catch (DBOperationException e) { s_log.WarnException("Error Occured in CreateUpdateDateTimeFormat", e); throw; } catch (Exception ex) { s_log.ErrorException("CreateUpdateDateTimeFormat Fails", ex); throw new DBOperationException(ex.Message, DBExceptionScenarios.ExceptionOccured, ex); } }