/// <summary> /// Update the Referral Client Concern. /// </summary> /// <param name="concernToAdd">The referral client concern model to add.</param> /// <returns></returns> Response <ReferralClientConcernsModel> UpdateClientConcern(ReferralClientConcernsModel clientConcern) { var repository = unitOfWork.GetRepository <ReferralClientConcernsModel>(SchemaName.Registration); var spParameters = BuildParams(clientConcern); return(unitOfWork.EnsureInTransaction(repository.ExecuteNQStoredProc, "usp_UpdateReferralConcernDetails", spParameters, forceRollback: clientConcern.ForceRollback.GetValueOrDefault())); }
/// <summary> /// Add/Update the Referral Client Concerns /// </summary> /// <param name="ReferralAdditionalDetailID">The referral Client Concerns.</param> /// <returns></returns> public Response <ReferralClientConcernsModel> AddUpdateClientConcern(ReferralClientConcernsModel clientConcern) { if (clientConcern.ReferralConcernDetailID > 0) { return(UpdateClientConcern(clientConcern)); } else { return(AddClientConcern(clientConcern)); } }
/// <summary> /// Builds the parameters. /// </summary> /// <param name="model">The referral.</param> /// <returns></returns> private List <SqlParameter> BuildParams(ReferralClientConcernsModel model) { var spParameters = new List <SqlParameter>(); if (model.ReferralConcernDetailID > 0) { spParameters.Add(new SqlParameter("ReferralConcernDetailID", model.ReferralConcernDetailID)); } spParameters.Add(new SqlParameter("ReferralAdditionalDetailID", (object)model.ReferralAdditionalDetailID ?? DBNull.Value)); spParameters.Add(new SqlParameter("ReferralConcernID", (object)model.ReferralConcernID ?? DBNull.Value)); spParameters.Add(new SqlParameter("Diagnosis", (object)model.Diagnosis ?? DBNull.Value)); spParameters.Add(new SqlParameter("ReferralPriorityID", (object)model.ReferralPriorityID ?? DBNull.Value)); spParameters.Add(new SqlParameter("ModifiedOn", model.ModifiedOn ?? DateTime.Now)); return(spParameters); }