/// <summary>
/// Builds the parameters.
/// </summary>
/// <param name="referral">The referral.</param>
/// <returns></returns>
private List <SqlParameter> BuildParams(ReferralClientAdditionalDetailsModel referralAdditionalDetails)
{
var spParameters = new List <SqlParameter>();
if (referralAdditionalDetails.ReferralAdditionalDetailID > 0)
{
spParameters.Add(new SqlParameter("ReferralDispositionDetailID", referralAdditionalDetails.ReferralAdditionalDetailID));
}
spParameters.Add(new SqlParameter("ReferralHeaderID", referralAdditionalDetails.ReferralHeaderID));
spParameters.Add(new SqlParameter("ReferralID", referralAdditionalDetails.ContactID));
spParameters.Add(new SqlParameter("ReasonforCare", (object)referralAdditionalDetails.ReasonforCare ?? DBNull.Value));
spParameters.Add(new SqlParameter("IsTransferred", (object)referralAdditionalDetails.IsTransferred ?? DBNull.Value));
spParameters.Add(new SqlParameter("IsHousingProgram", (object)referralAdditionalDetails.IsHousingProgram ?? DBNull.Value));
spParameters.Add(new SqlParameter("HousingDescription", (object)referralAdditionalDetails.HousingDescription ?? DBNull.Value));
spParameters.Add(new SqlParameter("IsEligibleforFurlough", (object)referralAdditionalDetails.IsEligibleforFurlough ?? DBNull.Value));
spParameters.Add(new SqlParameter("IsReferralDischargeOrTransfer", (object)referralAdditionalDetails.IsReferralDischargeOrTransfer ?? DBNull.Value));
spParameters.Add(new SqlParameter("IsConsentRequired", (object)referralAdditionalDetails.IsConsentRequired ?? DBNull.Value));
spParameters.Add(new SqlParameter("Comments", (object)referralAdditionalDetails.Comments ?? DBNull.Value));
spParameters.Add(new SqlParameter("AdditionalConcerns", DBNull.Value));
spParameters.Add(new SqlParameter("ModifiedOn", referralAdditionalDetails.ModifiedOn ?? DateTime.Now));
return(spParameters);
}
/// <summary>
/// Updates the client AdditionalDetail.
/// </summary>
/// <param name="referral">The referral AdditionalDetail .</param>
/// <returns></returns>
public Response <ReferralClientAdditionalDetailsModel> UpdateClientAdditionalDetail(ReferralClientAdditionalDetailsModel referralAdditionalDetails)
{
var referralRepository = unitOfWork.GetRepository <ReferralClientAdditionalDetailsModel>(SchemaName.Registration);
var procParams = BuildParams(referralAdditionalDetails);
return(unitOfWork.EnsureInTransaction(
referralRepository.ExecuteNQStoredProc,
"usp_UpdateReferralAdditionalDetails",
procParams,
forceRollback: referralAdditionalDetails.ForceRollback.GetValueOrDefault(false),
idResult: false
));
}
