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);
}
}
private SmsConfigurationDTO mapToDateTimeFormatDto(IDictionary <string, object> dictionary)
{
var tagGuid = dictionary["CONFIGURATIONGUID"];
var hospitalID = dictionary["HOSPITALID"];
var parameterType = dictionary["PARAMETERTYPE"];
var parameter = dictionary["PARAMETER"];
var parameterValue = dictionary["PARAMETERVALUE"];
var validUntil = dictionary["VALIDUNTILDATE"];
var smsConfigurationDto = new SmsConfigurationDTO();
if (tagGuid != null)
{
smsConfigurationDto.Id = new Guid((byte[])tagGuid);
}
smsConfigurationDto.HospitalId = (long)hospitalID;
smsConfigurationDto.Name = parameter as string;
smsConfigurationDto.Value = parameterValue as string;
smsConfigurationDto.IsActive = validUntil == null;
return(smsConfigurationDto);
}
private PSSLinkModel DataDTOToModel(SmsConfigurationDTO smsConfigurationDto)
{
return(new PSSLinkModel()
{
Id = smsConfigurationDto.Id,
Name = smsConfigurationDto.Name,
HospitalId = smsConfigurationDto.HospitalId,
Link = smsConfigurationDto.Value,
active = smsConfigurationDto.IsActive
});
}
public void DateTimeFormatIntegration_Create_SUCCESS()
{
var service = GetInstance <IDateTimeFormatDataService>();
var smsConfigurationDto = new SmsConfigurationDTO()
{
Name = "Test Format1",
HospitalId = HospitalId,
Value = "dd/MM/yy",
IsActive = true
};
var newGuid = service.SaveDateTimeFormat(smsConfigurationDto);
Assert.IsTrue(newGuid != null);
}
private DateTimeFormat DataDTOToModel(SmsConfigurationDTO smsConfigurationDto)
{
var date = DateTime.Now;
return(new DateTimeFormat()
{
Id = smsConfigurationDto.Id,
HospitalId = smsConfigurationDto.HospitalId,
Name = smsConfigurationDto.Name,
displaySample = date.ToString(smsConfigurationDto.Value),
format = smsConfigurationDto.Value,
active = smsConfigurationDto.IsActive
});
}
internal static OracleDynamicParameters GetPSSLinkCreateUpdateQueryParams(SmsConfigurationDTO smsConfigurationDto)
{
var isActiveIntVal = 1; // we don't support to inactive the link status
var parameterType = (short)GlobalOptions.ConfigurationParameterType.PSSLink;
var dynamicParameters = new OracleDynamicParameters();
dynamicParameters.Add("p_configurationguid", GuidConvert.ToRaw(smsConfigurationDto.Id), OracleMappingType.Raw, ParameterDirection.Input);
dynamicParameters.Add("p_hospitalID", smsConfigurationDto.HospitalId, OracleMappingType.Long, ParameterDirection.Input);
dynamicParameters.Add("p_parametertype", parameterType, OracleMappingType.Long, ParameterDirection.Input);
dynamicParameters.Add("p_parameter", smsConfigurationDto.Name, OracleMappingType.Varchar2, ParameterDirection.Input);
dynamicParameters.Add("p_parametervalue", smsConfigurationDto.Value, OracleMappingType.Varchar2, ParameterDirection.Input);
dynamicParameters.Add("p_isActive", isActiveIntVal, OracleMappingType.Long, ParameterDirection.Input);
dynamicParameters.Add("l_configurationguid", null, OracleMappingType.Raw, ParameterDirection.ReturnValue, 16);
return(dynamicParameters);
}
public Guid SaveDateTimeFormat(SmsConfigurationDTO smsConfigurationDto)
{
return(m_DateTimeFormatDataStore.CreateUpdateDateTimeFormat(smsConfigurationDto));
}
internal static OracleDynamicParameters GetDateTimeFormatCreateUpdateQueryParams(SmsConfigurationDTO smsConfigurationDto)
{
var isActiveIntVal = smsConfigurationDto.IsActive ? 1 : 0;
var parameterType = (short)GlobalOptions.ConfigurationParameterType.DateTimeFormat;
var dynamicParameters = new OracleDynamicParameters();
dynamicParameters.Add("p_configurationguid", GuidConvert.ToRaw(smsConfigurationDto.Id), OracleMappingType.Raw, ParameterDirection.Input);
dynamicParameters.Add("p_hospitalID", smsConfigurationDto.HospitalId, OracleMappingType.Long, ParameterDirection.Input);
dynamicParameters.Add("p_parametertype", parameterType, OracleMappingType.Long, ParameterDirection.Input);
dynamicParameters.Add("p_parameter", smsConfigurationDto.Name, OracleMappingType.Varchar2, ParameterDirection.Input);
dynamicParameters.Add("p_parametervalue", smsConfigurationDto.Value, OracleMappingType.Varchar2, ParameterDirection.Input);
dynamicParameters.Add("p_isActive", isActiveIntVal, OracleMappingType.Long, ParameterDirection.Input);
dynamicParameters.Add("l_configurationguid", null, OracleMappingType.Raw, ParameterDirection.ReturnValue, 16);
return(dynamicParameters);
}
public Guid CreateUpdatePSSLink(SmsConfigurationDTO smsConfigurationDto)
{
return(m_configPssLinkDataStore.CreateUpdatePSSLink(smsConfigurationDto));
}
