/// <summary>
/// Update the Identifier.
/// </summary>
/// <param name="referralID">The client identifier model to update.</param>
/// <returns></returns>
Response <ContactClientIdentifierModel> UpdateIdentifier(long contactID, ContactClientIdentifierModel identifierToUpdate)
{
var repository = _unitOfWork.GetRepository <ContactClientIdentifierModel>(SchemaName.Registration);
var spParameters = BuildParams(contactID, identifierToUpdate);
return(_unitOfWork.EnsureInTransaction(repository.ExecuteNQStoredProc, "usp_UpdateContactClientIdentifier", spParameters, forceRollback: identifierToUpdate.ForceRollback.GetValueOrDefault()));
}
/// <summary>
/// Builds the parameters.
/// </summary>
/// <param name="model">The client identifier model.</param>
/// <returns></returns>
private List <SqlParameter> BuildParams(long contactID, ContactClientIdentifierModel model)
{
var spParameters = new List <SqlParameter>();
spParameters.Add(new SqlParameter("TransactionLogID", (object)model.TransactionID ?? DBNull.Value));
spParameters.Add(new SqlParameter("ModuleComponentID", (object)model.ScreenID ?? DBNull.Value));
if (model.ContactClientIdentifierID > 0)
{
spParameters.Add(new SqlParameter("ContactClientIdentifierID", model.ContactClientIdentifierID));
}
spParameters.Add(new SqlParameter("ContactID", contactID));
spParameters.Add(new SqlParameter("ClientIdentifierTypeID", (object)model.ClientIdentifierTypeID ?? DBNull.Value));
spParameters.Add(new SqlParameter("AlternateID", (object)model.AlternateID ?? DBNull.Value));
spParameters.Add(new SqlParameter("ExpirationReasonID", (object)model.ExpirationReasonID ?? DBNull.Value));
spParameters.Add(new SqlParameter("EffectiveDate", (object)model.EffectiveDate ?? DBNull.Value));
spParameters.Add(new SqlParameter("ExpirationDate", (object)model.ExpirationDate ?? DBNull.Value));
spParameters.Add(new SqlParameter("ModifiedOn", model.ModifiedOn ?? DateTime.Now));
return(spParameters);
}
