public Guid UpdateGroupedText(GroupedTextDTO groupedTextDTO)
{
string spName = "apt_code.SmsAppointmentService.updateTextTemplate";
try
{
using (var connection = m_providerFactory.CreateConnection())
{
var oracleParameters = GroupTemplateQueryParamHelper.GetGroupTemplateUpdateQueryParams(groupedTextDTO);
var newGuid = SaveAndReturnPK(spName, "l_newtextTemplateGUID", oracleParameters, connection);
return(newGuid);
}
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex)
{
s_log.ErrorException("UpdateGroupedText (Error from Oracle)", ex);
throw new DBOperationException(ex.Message, ex.Number, DBExceptionScenarios.OracleExceptionOccured, ex);
}
catch (DBOperationException e)
{
s_log.WarnException("Error Occured in UpdateGroupedText", e);
throw;
}
catch (Exception ex)
{
s_log.ErrorException("UpdateGroupedText Fails", ex);
throw new DBOperationException(ex.Message, DBExceptionScenarios.ExceptionOccured, ex);
}
}
private GroupedTextDTO MapToGroupedTextDTO(IDictionary <string, Object> dictionary)
{
var textTemplateGuid = dictionary["SMSTEXTTEMPLATEGUID"];
var organizationId = dictionary["ORGANIZAIONID"];
var hospitalId = dictionary["HOSPITALID"];
var departmentId = dictionary["DEPARTMENTID"];
var templateName = dictionary["TEMPLATENAME"];
var smstext = dictionary["SMSTEXT"];
var replacedByGuid = dictionary["REPLACEDBYGUID"];
var validToDate = dictionary["VALIDTO"];
var validFromDate = dictionary["VALIDFROM"];
var isActive = dictionary["ISACTIVE"];
GroupedTextDTO dto = new GroupedTextDTO();
if (textTemplateGuid != null)
{
dto.GroupedTempateGUID = new Guid((byte[])textTemplateGuid);
}
if (replacedByGuid != null)
{
dto.ReplacedByGUID = new Guid((byte[])replacedByGuid);
}
if (organizationId != null)
{
dto.OrganizationID = (long)organizationId;
}
if (hospitalId != null)
{
dto.HospitalID = (long)hospitalId;
}
if (departmentId != null)
{
dto.DepartmentID = (long)departmentId;
}
if (templateName != null)
{
dto.Name = templateName.ToString();
}
if (smstext != null)
{
dto.Text = smstext.ToString();
}
if (validFromDate != null)
{
dto.ValidFrom = (DateTime)validFromDate;
}
if (validToDate != null)
{
dto.ValidTo = (DateTime)validToDate;
}
if (isActive != null)
{
dto.IsActive = Convert.ToInt16(isActive) == 0 ? false : true;
}
return(dto);
}
/// <summary>
/// Query params for saving grouped Templates
/// </summary>
/// <param name="groupedTextDTO"></param>
/// <returns></returns>
internal static OracleDynamicParameters GetGroupTemplateSaveQueryParams(GroupedTextDTO groupedTextDTO)
{
OracleDynamicParameters dynamicParameters = new OracleDynamicParameters();
dynamicParameters.Add("p_organizationID", (groupedTextDTO.OrganizationID == null ? null : groupedTextDTO.OrganizationID), OracleMappingType.Long, ParameterDirection.Input);
dynamicParameters.Add("p_hospitalID", groupedTextDTO.HospitalID, OracleMappingType.Long, ParameterDirection.Input);
dynamicParameters.Add("p_departmentID", (groupedTextDTO.DepartmentID == null ? null : groupedTextDTO.DepartmentID), OracleMappingType.Long, ParameterDirection.Input);
dynamicParameters.Add("p_SMSTextTempName", groupedTextDTO.Name, OracleMappingType.Varchar2, ParameterDirection.Input);
dynamicParameters.Add("p_SMSText", groupedTextDTO.Text, OracleMappingType.Varchar2, ParameterDirection.Input);
dynamicParameters.Add("l_SMSTextTempID", null, OracleMappingType.Raw, ParameterDirection.ReturnValue, 16);
return(dynamicParameters);
}
private SMSTextTemplate DataDTOToModel(GroupedTextDTO dataDto)
{
return(new SMSTextTemplate()
{
TextTemplateTextId = dataDto.GroupedTempateGUID,
OrganizationID = dataDto.OrganizationID,
HospitalID = dataDto.HospitalID,
DepartmentID = dataDto.DepartmentID,
TextTemplateName = dataDto.Name,
TextTemplateString = dataDto.Text,
IsActive = dataDto.IsActive,
ValidFrom = dataDto.ValidFrom,
ValidTo = dataDto.ValidTo
});
}
private GroupedTextDTO GetGroupedTextDTO(long hospitalId)
{
GroupedTextDTO dto = new GroupedTextDTO
{
OrganizationID = OrganizationId,
DepartmentID = DepartmentId,
HospitalID = hospitalId,
Name = "GroupedTem_0001",
Text = "Dear {patientName} !!",
ValidFrom = DateTime.Now,
ValidTo = DateTime.Now.AddDays(2),
IsActive = true
};
return(dto);
}
/// <summary>
/// update text Template Query params
/// </summary>
/// <param name="groupedTextDTO"></param>
/// <returns></returns>
internal static OracleDynamicParameters GetGroupTemplateUpdateQueryParams(GroupedTextDTO groupedTextDTO)
{
OracleDynamicParameters dynamicParameters = new OracleDynamicParameters();
if (groupedTextDTO.GroupedTempateGUID != null)
{
dynamicParameters.Add("p_textTemplateGUID", GuidConvert.ToRaw(groupedTextDTO.GroupedTempateGUID), OracleMappingType.Raw, ParameterDirection.Input);
}
dynamicParameters.Add("p_hospitalID", groupedTextDTO.HospitalID, OracleMappingType.Long, ParameterDirection.Input);
dynamicParameters.Add("p_departmentID", groupedTextDTO.DepartmentID, OracleMappingType.Long, ParameterDirection.Input);
dynamicParameters.Add("p_SMSTextTempName", groupedTextDTO.Name, OracleMappingType.Varchar2, ParameterDirection.Input);
dynamicParameters.Add("p_SMSText", groupedTextDTO.Text, OracleMappingType.Varchar2, ParameterDirection.Input);
dynamicParameters.Add("l_newtextTemplateGUID", null, OracleMappingType.Raw, ParameterDirection.ReturnValue, 16);
return(dynamicParameters);
}
public Guid SaveGroupedText(GroupedTextDTO tempateDTO)
{
return(m_groupedTemplateDataStore.CreateUpdateGroupText(tempateDTO));
}
internal static OracleDynamicParameters GetGroupTemplateSaveUpdateQueryParams(GroupedTextDTO groupedTextDTO)
{
var isactive = groupedTextDTO.IsActive ? 1 : 0;
OracleDynamicParameters dynamicParameters = new OracleDynamicParameters();
dynamicParameters.Add("p_oldTemplateGUID", groupedTextDTO.GroupedTempateGUID, OracleMappingType.Raw, ParameterDirection.Input);
dynamicParameters.Add("p_organizationID", (groupedTextDTO.OrganizationID == null ? null : groupedTextDTO.OrganizationID), OracleMappingType.Long, ParameterDirection.Input);
dynamicParameters.Add("p_hospitalID", groupedTextDTO.HospitalID, OracleMappingType.Long, ParameterDirection.Input);
dynamicParameters.Add("p_departmentID", (groupedTextDTO.DepartmentID == null ? null : groupedTextDTO.DepartmentID), OracleMappingType.Long, ParameterDirection.Input);
dynamicParameters.Add("p_SMSTextTempName", groupedTextDTO.Name, OracleMappingType.Varchar2, ParameterDirection.Input);
dynamicParameters.Add("p_SMSText", groupedTextDTO.Text, OracleMappingType.Varchar2, ParameterDirection.Input);
dynamicParameters.Add("p_validFrom", groupedTextDTO.ValidFrom, OracleMappingType.Date, ParameterDirection.Input);
dynamicParameters.Add("p_validTo", groupedTextDTO.ValidTo, OracleMappingType.Date, ParameterDirection.Input);
dynamicParameters.Add("p_isActive", isactive, OracleMappingType.Int16, ParameterDirection.Input);
dynamicParameters.Add("l_SMSTextTempID", null, OracleMappingType.Raw, ParameterDirection.ReturnValue, 16);
return(dynamicParameters);
}
