/// <summary>
/// Financials the assessment_ failed_data.
/// </summary>
private void FinancialAssessment_Failed_data()
{
var financialAssessmentDetails = new List <FinancialAssessmentDetailsModel>();
financialAssessmentDetailsModel = new FinancialAssessmentDetailsModel()
{
FinancialAssessmentDetailsID = 0,
FinancialAssessmentID = 1,
CategoryTypeID = 1,
Amount = 100,
FinanceFrequencyID = 17,
CategoryID = 1
};
financialAssessmentDetails.Add(financialAssessmentDetailsModel);
financialAssessmentViewModel = new FinancialAssessmentViewModel()
{
ContactID = 0,
FinancialAssessmentID = 1,
AssessmentDate = DateTime.Now,
TotalIncome = 300000,
TotalExpenses = 30000,
AdjustedGrossIncome = 5000,
TotalExtraOrdinaryExpenses = 100,
TotalOther = 100,
ExpirationDate = DateTime.Now,
ExpirationReasonID = 0,
FamilySize = 2
};
}
public void Initialize()
{
communicationManager = new CommunicationManager("X-Token", ConfigurationManager.AppSettings["UnitTestToken"]);
communicationManager.UnitTestUrl = ConfigurationManager.AppSettings["UnitTestUrl"];
requestModel = new FinancialAssessmentModel()
{
ContactID = 1,
FinancialAssessmentID = 1,
AssessmentDate = DateTime.Now,
TotalIncome = 300000,
TotalExpenses = 30000,
AdjustedGrossIncome = 5000,
TotalExtraOrdinaryExpenses = 100,
TotalOther = 100,
ExpirationDate = DateTime.Now,
ExpirationReasonID = 0,
FamilySize = 2
};
requestDetailsModel = new FinancialAssessmentDetailsModel()
{
FinancialAssessmentDetailsID = 1,
FinancialAssessmentID = 1,
CategoryTypeID = 1,
Amount = 100,
FinanceFrequencyID = 17,
CategoryID = 1
};
}
public void AddFinancialAssessmentDetails_Failed()
{
//Arrenge
var url = baseRoute + "AddFinancialAssessmentDetails";
requestDetailsModel = new FinancialAssessmentDetailsModel()
{
FinancialAssessmentDetailsID = 0,
FinancialAssessmentID = 1,
CategoryTypeID = 1,
Amount = 100,
FinanceFrequencyID = 17,
CategoryID = 1
};
//Act
var response = communicationManager.Post <FinancialAssessmentDetailsModel, Response <FinancialAssessmentDetailsModel> >(requestDetailsModel, url);
//Assert
Assert.IsNull(response.DataItems);
}
public void UpdateFinancialAssessmentDetails_Success()
{
//Arrange
var url = baseRoute + "UpdateFinancialAssessmentDetails";
requestDetailsModel = new FinancialAssessmentDetailsModel()
{
FinancialAssessmentDetailsID = 1,
FinancialAssessmentID = 1,
CategoryTypeID = 1,
Amount = 100,
FinanceFrequencyID = 1,
CategoryID = 1
};
//Act
var response = communicationManager.Post <FinancialAssessmentDetailsModel, Response <FinancialAssessmentDetailsModel> >(requestDetailsModel, url);
//Assert
Assert.IsTrue(response.RowAffected > 0, "Financial assessment could not be updated.");
}
public void updateFinancialAssessmentDetails_Success()
{
// Arrange
var controller = new FinancialAssessmentController(new FinancialAssessmentRepository(token));
// Act
financialAssessmentDetailsModel = new FinancialAssessmentDetailsModel()
{
FinancialAssessmentDetailsID = 1,
FinancialAssessmentID = 1,
CategoryTypeID = 1,
Amount = 100,
FinanceFrequencyID = 17,
CategoryID = 1
};
var modelResponse = controller.UpdateFinancialAssessmentDetails(financialAssessmentDetailsModel);
// Assert
Assert.IsNotNull(modelResponse);
Assert.IsTrue(modelResponse.RowAffected > 0);
}
/// <summary>
/// To crate sql parameter list for financial assessment details model
/// </summary>
/// <param name="financialAssessmentDetail">financial assessment details model</param>
/// <returns>sql parameter list</returns>
private List <SqlParameter> BuildFinancialAssessmentDetailsSpParams(
FinancialAssessmentDetailsModel financialAssessmentDetail)
{
var spParameters = new List <SqlParameter>();
spParameters.Add(financialAssessmentDetail.FinancialAssessmentDetailsID > 0 // Update, not Add
? new SqlParameter("FinancialAssessmentDetailID", financialAssessmentDetail.FinancialAssessmentDetailsID)
: new SqlParameter("FinancialAssessmentID", financialAssessmentDetail.FinancialAssessmentID)
);
spParameters.AddRange(new List <SqlParameter>
{
new SqlParameter("CategoryTypeID", (object)financialAssessmentDetail.CategoryTypeID ?? DBNull.Value),
new SqlParameter("Amount", (object)financialAssessmentDetail.Amount ?? DBNull.Value),
new SqlParameter("FinanceFrequencyID", (object)financialAssessmentDetail.FinanceFrequencyID ?? DBNull.Value),
new SqlParameter("CategoryID", (object)financialAssessmentDetail.CategoryID ?? DBNull.Value),
new SqlParameter("RelationshipTypeID", (object)financialAssessmentDetail.RelationshipTypeID ?? DBNull.Value),
new SqlParameter("ModifiedOn", financialAssessmentDetail.ModifiedOn ?? DateTime.Now)
});
return(spParameters);
}
public Response <FinancialAssessmentDetailsModel> UpdateFinancialAssessmentDetails(FinancialAssessmentDetailsModel financialAssessmentDetail)
{
return(financialAssessmentRepository.UpdateFinancialAssessmentDetails(financialAssessmentDetail));
}
/// <summary>
/// To update the financial assessment details (income or expenses) for contact id of FinancialAssessmentModel
/// </summary>
/// <param name="financialAssessmentDetail">Updated financial Assessment detail model</param>
/// <returns>Response type Financial assessment detail</returns>
public Response <FinancialAssessmentDetailsModel> UpdateFinancialAssessmentDetails(FinancialAssessmentDetailsModel financialAssessmentDetail)
{
string apiUrl = BaseRoute + "UpdateFinancialAssessmentDetails";
return(communicationManager.Post <FinancialAssessmentDetailsModel, Response <FinancialAssessmentDetailsModel> >(financialAssessmentDetail, apiUrl));
}
public IHttpActionResult UpdateFinancialAssessmentDetails(FinancialAssessmentDetailsModel financialAssessmentDetails)
{
return(new HttpResult <Response <FinancialAssessmentDetailsModel> >(financialAssessmentRuleEngine.UpdateFinancialAssessmentDetails(financialAssessmentDetails), Request));
}
/// <summary>
/// To update the financial assessment details (income or expenses) for contact id of FinancialAssessmentDetailsModel
/// </summary>
/// <param name="financialAssessment">Updated financial Assessment Details model</param>
/// <returns>Financial assessment</returns>
public Response <FinancialAssessmentDetailsModel> UpdateFinancialAssessmentDetails(FinancialAssessmentDetailsModel financialAssessmentDetails)
{
var procsParameters = BuildFinancialAssessmentDetailsSpParams(financialAssessmentDetails);
var financialAssessmentRepository = unitOfWork.GetRepository <FinancialAssessmentDetailsModel>(SchemaName.Registration);
Response <FinancialAssessmentDetailsModel> spResults = new Response <FinancialAssessmentDetailsModel>();
using (var transactionScope = unitOfWork.BeginTransactionScope())
{
try
{
spResults = financialAssessmentRepository.ExecuteNQStoredProc("usp_UpdateFinancialAssessmentDetails", procsParameters);
if (spResults.ResultCode != 0)
{
spResults.ResultCode = spResults.ResultCode;
spResults.ResultMessage = spResults.ResultMessage;
}
if (!financialAssessmentDetails.ForceRollback.GetValueOrDefault(false))
{
unitOfWork.TransactionScopeComplete(transactionScope);
}
}
catch (Exception ex)
{
logger.Error(ex);
spResults.ResultCode = -1;
spResults.ResultMessage = "An unexpected error has occurred!";
}
}
return(spResults);
}
public IHttpActionResult UpdateFinancialAssessmentDetails(FinancialAssessmentDetailsModel financialAssessmentDetail)
{
return(new HttpResult <Response <FinancialAssessmentDetailsModel> >(financialAssessmentDataProvider.UpdateFinancialAssessmentDetails(financialAssessmentDetail), Request));
}
/// <summary>
/// To call the Add financial assessment details web api method
/// </summary>
/// <param name="financialAssessment">model of FinancialAssessment </param>
/// <returns>Financial Assessment View Model type</returns>
public Response <FinancialAssessmentDetailsModel> AddFinancialAssessmentDetails(FinancialAssessmentDetailsModel financialAssessmentDetail)
{
string apiUrl = baseRoute + "AddFinancialAssessmentDetails";
var response = communicationManager.Post <FinancialAssessmentDetailsModel, Response <FinancialAssessmentDetailsModel> >(financialAssessmentDetail, apiUrl);
return(response);
}
/// <summary>
/// Financials the assessment_ success.
/// </summary>
private void FinancialAssessment_Success()
{
Mock <IFinancialAssessmentDataProvider> mock = new Mock <IFinancialAssessmentDataProvider>();
financialAssessmentDataProvider = mock.Object;
var financialAssessmentDetails = new List <FinancialAssessmentDetailsModel>();
financialAssessmentDetail = new FinancialAssessmentDetailsModel()
{
FinancialAssessmentDetailsID = 1,
FinancialAssessmentID = 1,
CategoryTypeID = 1,
Amount = 100,
FinanceFrequencyID = 17,
CategoryID = 1
};
financialAssessmentDetails.Add(financialAssessmentDetail);
var financialAssessmentModels = new List <FinancialAssessmentModel>();
financialAssessmentModel = new FinancialAssessmentModel()
{
ContactID = 1,
FinancialAssessmentID = 1,
AssessmentDate = DateTime.Now,
TotalIncome = 300000,
TotalExpenses = 30000,
AdjustedGrossIncome = 5000,
TotalExtraOrdinaryExpenses = 100,
TotalOther = 100,
ExpirationDate = DateTime.Now,
ExpirationReasonID = 0,
FamilySize = 2,
FinancialAssessmentDetails = financialAssessmentDetails
};
financialAssessmentModels.Add(financialAssessmentModel);
var financialAssessment = new Response <FinancialAssessmentModel>()
{
DataItems = financialAssessmentModels,
RowAffected = 1
};
var financialAssessmentDetailsResult = new Response <FinancialAssessmentDetailsModel>()
{
DataItems = financialAssessmentDetails,
RowAffected = 1
};
//Get FinancialAssessment
Response <FinancialAssessmentModel> financialAssessmentResponse = new Response <FinancialAssessmentModel>();
financialAssessmentResponse.DataItems = financialAssessmentModels.Where(contact => contact.ContactID == contactId && contact.FinancialAssessmentID == financialAssessmentID).ToList();
mock.Setup(r => r.GetFinancialAssessment(It.IsAny <long>(), It.IsAny <long>()))
.Returns(financialAssessmentResponse);
//Add FinancialAssessment
mock.Setup(r => r.AddFinancialAssessment(It.IsAny <FinancialAssessmentModel>()))
.Callback((FinancialAssessmentModel financialAssessmentsModel) => financialAssessmentModels.Add(financialAssessmentsModel))
.Returns(financialAssessment);
//Update FinancialAssessment
mock.Setup(r => r.UpdateFinancialAssessment(It.IsAny <FinancialAssessmentModel>()))
.Callback((FinancialAssessmentModel financialAssessmentsModel) => financialAssessmentModels.Add(financialAssessmentsModel))
.Returns(financialAssessment);
//Add FinancialAssessment Details
mock.Setup(r => r.AddFinancialAssessmentDetails(It.IsAny <FinancialAssessmentDetailsModel>()))
.Callback((FinancialAssessmentDetailsModel financialAssessmentsDetailsModel) => financialAssessmentDetails.Add(financialAssessmentsDetailsModel))
.Returns(financialAssessmentDetailsResult);
//Update FinancialAssessment Details
mock.Setup(r => r.UpdateFinancialAssessmentDetails(It.IsAny <FinancialAssessmentDetailsModel>()))
.Callback((FinancialAssessmentDetailsModel financialAssessmentsDetailsModel) => financialAssessmentDetails.Add(financialAssessmentsDetailsModel))
.Returns(financialAssessmentDetailsResult);
//Delete FinancialAssessment
Response <bool> deleteResponse = new Response <bool>();
List <bool> lstStatus = new List <bool>();
lstStatus.Add(true);
deleteResponse.RowAffected = 1;
deleteResponse.ResultCode = 0;
deleteResponse.DataItems = lstStatus;
mock.Setup(r => r.DeleteFinancialAssessmentDetail(It.IsAny <long>(), DateTime.UtcNow))
.Callback((long id) => financialAssessmentModels.Remove(financialAssessmentModels.Find(x => x.FinancialAssessmentDetails[0].FinancialAssessmentDetailsID == id)))
.Returns(deleteResponse);
}
/// <summary>
/// To update the financial assessment details for contact id
/// </summary>
/// <param name="financialAssessment">model of FinancialAssessment </param>
/// <returns>Response type financial assesment model </returns>
public Response <FinancialAssessmentDetailsModel> UpdateFinancialAssessmentDetails(FinancialAssessmentDetailsModel financialAssessmentDetails)
{
return(financialAssessmentService.UpdateFinancialAssessmentDetails(financialAssessmentDetails));
}
