/// <summary>
/// Builds the financial summary confirmation statement sp parameters.
/// </summary>
/// <param name="financialSummaryConfirmationStatement">The financial summary confirmation statement.</param>
/// <param name="isUpdate">if set to <c>true</c> [is update].</param>
/// <returns></returns>
private List <SqlParameter> BuildFinancialSummaryConfirmationStatementSpParams(FinancialSummaryConfirmationStatementModel financialSummaryConfirmationStatement, bool isUpdate)
{
var spParameters = new List <SqlParameter>();
if (isUpdate)
{
spParameters.Add(new SqlParameter("FinancialSummaryConfirmationStatementID", financialSummaryConfirmationStatement.FinancialSummaryConfirmationStatementID));
}
spParameters.Add(new SqlParameter("FinancialSummaryID", financialSummaryConfirmationStatement.FinancialSummaryID));
spParameters.Add(new SqlParameter("ConfirmationStatementID", (object)financialSummaryConfirmationStatement.ConfirmationStatementID ?? DBNull.Value));
spParameters.Add(new SqlParameter("DateSigned", (object)financialSummaryConfirmationStatement.DateSigned ?? DBNull.Value));
spParameters.Add(new SqlParameter("SignatureStatusID", (object)financialSummaryConfirmationStatement.SignatureStatusID ?? DBNull.Value));
spParameters.Add(new SqlParameter("ModifiedOn", financialSummaryConfirmationStatement.ModifiedOn ?? DateTime.Now));
return(spParameters);
}
/// <summary>
/// Updates the financial summary confirmation statement.
/// </summary>
/// <param name="financialSummaryConfirmationStatement"></param>
/// <returns></returns>
public Response <FinancialSummaryConfirmationStatementModel> UpdateFinancialSummaryConfirmationStatement(FinancialSummaryConfirmationStatementModel financialSummaryConfirmationStatement)
{
var repository = unitOfWork.GetRepository <FinancialSummaryConfirmationStatementModel>(SchemaName.Registration);
var spParameters = BuildFinancialSummaryConfirmationStatementSpParams(financialSummaryConfirmationStatement, true);
var response = unitOfWork.EnsureInTransaction <Response <FinancialSummaryConfirmationStatementModel> >(repository.ExecuteNQStoredProc, "usp_UpdateFinancialSummaryConfirmationStatement", spParameters, forceRollback: financialSummaryConfirmationStatement.ForceRollback ?? false);
if (financialSummaryConfirmationStatement.EntitySignatureID == null || financialSummaryConfirmationStatement.EntitySignatureID == 0)
{
AddSignature(financialSummaryConfirmationStatement.SignatureBLOB,
financialSummaryConfirmationStatement.FinancialSummaryConfirmationStatementID,
(int)DocumentType.ConfirmationStatement,
financialSummaryConfirmationStatement.EntitySignatureID,
financialSummaryConfirmationStatement.ContactID,
null,
(int)EntityType.Contact,
financialSummaryConfirmationStatement.ModifiedOn);
}
return(response);
}
