public Guid CreateUpdateDateTimeFormat(SmsConfigurationDTO smsConfigurationDto)
{
string spName = "apt_code.SmsAppointmentService.createUpdateConfigurationData";
try
{
using (var connection = m_providerFactory.CreateConnection())
{
var oracleParameters = DateTimeFormatQueryParamsHelper.GetDateTimeFormatCreateUpdateQueryParams(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> GetDateTimeFormatByHospital(long hospitalId)
{
string spName = "apt_code.SmsAppointmentService.getParameterValues";
try
{
using (var connection = m_providerFactory.CreateConnection())
{
var oracleparams = DateTimeFormatQueryParamsHelper.GetDateTimeFormatSearchQueryParams(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(mapToDateTimeFormatDto(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);
}
}
