public async Task <ActionResult> LiquidAssetsUsable(string fileId)
{
try
{
this.Info("Calculating Liquid Assets Usable");
// Validate custom header values
CustomHeaderData customHeaderData = new CustomHeaderData(HttpContext.Request.Headers);
customHeaderData.ValidateCustomHeaders();
// Get the file from disk
MismoContentModel mismoContentModel =
await _fileManagerApiClient.GetMismoContentAsync(fileId, $"{_configuration["FileManagerApi:ApiUrl"]}");
// Use custom header information and mismo content to create IUSLoan & DocTypeCalcResolver
_IUSLoanManager.SetUp(customHeaderData, mismoContentModel);
DocTypeCalcResolver docTypeCalcResolver = _IUSLoanManager.GetDocTypeCalcResolver();
IUSLoan iusLoan = _IUSLoanManager.GetIUSLoan();
// Use Factory to create Calculations Interface
Calculations calcs = DocTypeCalcFactory.Create(docTypeCalcResolver, iusLoan);
decimal total = calcs.AssetCalculation.LiquidAssetsUsable();
return(Ok(total));
}
catch (Exception ex)
{
this.Error("Error in calculating Liquid Assets Usable", ex.Message);
return(BadRequest(ex.Message));
}
}
public async Task <ActionResult> MortgageTermsDataAsync(string fileId)
{
try
{
this.Info("Calculating Mortgage Terms");
// Validate custom header values
CustomHeaderData customHeaderData = new CustomHeaderData(HttpContext.Request.Headers);
customHeaderData.ValidateCustomHeaders();
// Get the file from disk
MismoContentModel mismoContentModel =
await _fileManagerApiClient.GetMismoContentAsync(fileId, $"{_configuration["FileManagerApi:ApiUrl"]}");
// Use custom header information and mismo content to create IUSLoan & DocTypeCalcResolver
_IUSLoanManager.SetUp(customHeaderData, mismoContentModel);
DocTypeCalcResolver docTypeCalcResolver = _IUSLoanManager.GetDocTypeCalcResolver();
IUSLoan iusLoan = _IUSLoanManager.GetIUSLoan();
// Use Factory to create Calculations Interface
Calculations calcs = DocTypeCalcFactory.Create(docTypeCalcResolver, iusLoan);
if (iusLoan.MismoLoan.MortgageTerms != null)
{
return(Ok(iusLoan.MismoLoan.MortgageTerms));
}
else
{
return(NotFound());
}
}
catch (Exception ex)
{
this.Error("Error in Calculating Mortgage Terms", ex.Message);
return(BadRequest(ex.Message));
}
}
public async Task <ActionResult> CalculateWorksheet(string fileId)
{
try
{
this.Info("Calculating BankStatement worksheet");
// Validate custom header values
CustomHeaderData customHeaderData = new CustomHeaderData(HttpContext.Request.Headers);
customHeaderData.ValidateCustomHeaders();
// Get full request from disk
LoanCalcRequestModel loanCalcRequestModel =
await _fileManagerApiClient.GetLoanCalcRequestAsync(fileId, $"{_configuration["FileManagerApi:ApiUrl"]}");
MismoContentModel mismoContentModel = loanCalcRequestModel.MismoContent;
List <CreditContentModel> creditContents = loanCalcRequestModel.CreditContents;
// Use custom header information and mismo content to create IUSLoan & DocTypeCalcResolver
_IUSLoanManager.SetUp(customHeaderData, loanCalcRequestModel);
DocTypeCalcResolver docTypeCalcResolver = _IUSLoanManager.GetDocTypeCalcResolver();
IUSLoan iusLoan = _IUSLoanManager.GetIUSLoan();
// Use Factory to create Calculations Interface
Calculations calcs = DocTypeCalcFactory.Create(docTypeCalcResolver, iusLoan);
// Create worksheet model
Worksheet worksheet = new Worksheet();
if (calcs.Message == null)
{
// Calculate Assets section
worksheet.Assets = GetWorksheetAssets(calcs);
// Calculate Residual Assets section
worksheet.ResidualAssets = GetWorksheetResidualAssets(calcs, iusLoan);
worksheet.ResidualAssets.TotalResidualAsset = calcs.AssetCalculation.TotalResidualAssets();
// Calculate 60 months Required Reserves
//worksheet.MonthlyLiabilities = GetMonthlyLiabilities(calcs, iusLoan);
//worksheet.SixtyMonthsRequiredReserves = GetSixtyMonthRequiredReserves(worksheet.MonthlyLiabilities);
//worksheet.ProgramReservesRequired = worksheet.SixtyMonthsRequiredReserves.Total +
// (worksheet.ResidualAssets.CashFromBorrower.CashFromBorrowerTotal > 0
// ? worksheet.ResidualAssets.CashFromBorrower.CashFromBorrowerTotal : 0);
// Calculate Qualifying P&I Payment
worksheet.QualifyingPI = GetQualifyingPI(calcs).ToString();
// Calculate BaseReserve
worksheet.BaseReserves = GetBaseReserves(calcs);
// Calculate Reo Reserves ForNonSubj Retained Properties
worksheet.AdditionalReservesRequired = GetReservesForNonSubjRetainedProperties(calcs);
worksheet.TotalRequiredReserves = worksheet.BaseReserves + GetAddOneMonthReserves(calcs);
worksheet.UsableCashoutProceeds = GetUsableCashOut(worksheet.ResidualAssets.CashFromBorrower.CashFromBorrowerTotal, calcs.LoanCalcs.LTV());
worksheet.NetReservesNeededAfterCashOut = GetNetReserves(worksheet.BaseReserves, worksheet.AdditionalReservesRequired,
worksheet.ResidualAssets.CashFromBorrower.CashFromBorrowerTotal, calcs.LoanCalcs.LTV());
worksheet.TotalAdditionalReservesStillRequired =
worksheet.ResidualAssets.TotalResidualAsset - worksheet.NetReservesNeededAfterCashOut < 0 ?
worksheet.ResidualAssets.TotalResidualAsset - worksheet.NetReservesNeededAfterCashOut : 0;
worksheet.TotalRequiredAssetsForTransaction = worksheet.ResidualAssets.CashFromBorrower.CashFromBorrowerTotal
+ worksheet.TotalAdditionalReservesStillRequired;
}
else
{
worksheet.Message = calcs.Message;
}
return(Ok(worksheet));
}
catch (Exception ex)
{
this.Error("Error in BankStatement", ex.Message);
return(BadRequest(ex.Message));
}
}
public async Task <ActionResult> CalculateWorksheet(string fileId)
{
try
{
this.Info("Calculating Encompass UW Launchpad worksheet");
// Validate custom header values
CustomHeaderData customHeaderData = new CustomHeaderData(HttpContext.Request.Headers);
customHeaderData.ValidateCustomHeaders();
// Get full request from disk
LoanCalcRequestModel loanCalcRequestModel =
await _fileManagerApiClient.GetLoanCalcRequestAsync(fileId, $"{_configuration["FileManagerApi:ApiUrl"]}");
MismoContentModel mismoContentModel = loanCalcRequestModel.MismoContent;
List <CreditContentModel> creditContents = loanCalcRequestModel.CreditContents;
// Use custom header information and mismo content to create IUSLoan & DocTypeCalcResolver
_IUSLoanManager.SetUp(customHeaderData, loanCalcRequestModel);
DocTypeCalcResolver docTypeCalcResolver = _IUSLoanManager.GetDocTypeCalcResolver();
IUSLoan iusLoan = _IUSLoanManager.GetIUSLoan();
// Use Factory to create Calculations Interface
Calculations calcs = DocTypeCalcFactory.Create(docTypeCalcResolver, iusLoan);
UWLaunchPadWorksheet worksheet = new UWLaunchPadWorksheet();
if (calcs.Message == null)
{
worksheet.ProgramReservesRequired = calcs.LoanCalcs.ProgramReservesRequired();
worksheet.Source = "IUS";
worksheet.AdditionalReservesRequired = calcs.LoanCalcs.AdditionalReservesRequired();
worksheet.TotalReservesRequired = worksheet.ProgramReservesRequired + worksheet.AdditionalReservesRequired;
worksheet.TotalReservesRequiredMonth = Math.Round(worksheet.TotalReservesRequired / GetPITIA(iusLoan, calcs), 2);
worksheet.Assets = GetWorksheetAssets(calcs);
worksheet.VerifiedAssetsMonth = Math.Round(worksheet.Assets.TotalVerifiedAmount / GetPITIA(iusLoan, calcs), 2);
worksheet.FundsAvailableForReserves = calcs.AssetCalculation.TotalResidualAssets();
worksheet.UsableCashOutProceed = calcs.LoanCalcs.CashoutProceed();
worksheet.UsableCashOutProceedMonth = Math.Round(worksheet.UsableCashOutProceed / GetPITIA(iusLoan, calcs), 2);
worksheet.RequiredFundsToClose = calcs.LoanCalcs.CashFromBorrower();
worksheet.TotalReservesAfterClose = worksheet.Assets.TotalVerifiedAmount - worksheet.RequiredFundsToClose;
worksheet.TotalReservesAfterCloseMonth = Math.Round(worksheet.TotalReservesAfterClose / GetPITIA(iusLoan, calcs), 2);
worksheet.TotalReservesWithCashoutProceed = worksheet.Assets.TotalVerifiedAmount
+ worksheet.UsableCashOutProceed - worksheet.RequiredFundsToClose;
worksheet.TotalReservesWithCashoutProceedMonth = Math.Round(worksheet.TotalReservesWithCashoutProceed / GetPITIA(iusLoan, calcs), 2);
worksheet.TotalNetQualifyingReserves = calcs.LoanCalcs.NetQualifyingReserves();
worksheet.TotalNetCashReserveAmount = worksheet.Assets.TotalUsable - calcs.LoanCalcs.CashFromBorrower()
- worksheet.TotalReservesRequired;
}
else
{
worksheet.Message = calcs.Message;
}
return(Ok(worksheet));
}
catch (Exception ex)
{
this.Error("Error in Encompass UW LaunchPad", ex.Message);
return(BadRequest(ex.Message));
}
}
public async Task <ActionResult> CalculateWorksheet(string fileId)
{
try
{
this.Info("Calculating Asset Qualifier worksheet");
// Validate custom header values
CustomHeaderData customHeaderData = new CustomHeaderData(HttpContext.Request.Headers);
customHeaderData.ValidateCustomHeaders();
// Get full request from disk
LoanCalcRequestModel loanCalcRequestModel =
await _fileManagerApiClient.GetLoanCalcRequestAsync(fileId, $"{_configuration["FileManagerApi:ApiUrl"]}");
MismoContentModel mismoContentModel = loanCalcRequestModel.MismoContent;
List <CreditContentModel> creditContents = loanCalcRequestModel.CreditContents;
// Use custom header information and mismo content to create IUSLoan & DocTypeCalcResolver
_IUSLoanManager.SetUp(customHeaderData, loanCalcRequestModel);
DocTypeCalcResolver docTypeCalcResolver = _IUSLoanManager.GetDocTypeCalcResolver();
IUSLoan iusLoan = _IUSLoanManager.GetIUSLoan();
// Use Factory to create Calculations Interface
Calculations calcs = DocTypeCalcFactory.Create(docTypeCalcResolver, iusLoan);
// Create worksheet model
Worksheet worksheet = new Worksheet();
if (calcs.Message == null)
{
// Calculate Assets section C7, C8, C9, C10, E11
worksheet.Assets = GetWorksheetAssets(calcs);
//LoanAmount, Subordinate financing loan amount, Cash from borrower E12, E13, E14
worksheet.ResidualAssets = GetWorksheetResidualAssets(calcs, iusLoan);
//Total Residual Assets E15
worksheet.ResidualAssets.TotalResidualAsset = calcs.AssetCalculation.TotalResidualAssets();
// Total Monthly Liabilites, mortgage related expense, PITIA, Total Net Rental D16, D17, D18, D19, D20, E21
worksheet.MonthlyLiabilities = GetMonthlyLiabilities(calcs, iusLoan);
//Total 60 months Required Reserves E22
worksheet.SixtyMonthsRequiredReserves = GetSixtyMonthRequiredReserves(worksheet.MonthlyLiabilities);
// Calculate Qualifying P&I Payment E23
worksheet.QualifyingPI = iusLoan.ImpacProgramCode.Contains("IO") ? GetQualifyingPI(calcs).ToString()
: calcs.ProposedHousingCalcs.FirstMortgagePIAmount().ToString();
// Calculate BaseReserve E24
worksheet.BaseReserves = GetBaseReserves(calcs);
//Calculate Additional Reserves Required E25
worksheet.AdditionalReservesRequired = GetReservesForNonSubjRetainedProperties(calcs);
//Additional Reserves Required
//worksheet.AdditionalReservesRequired = calcs.LoanCalcs.AdditionalReservesRequired();
//Net Reserves Need after Cashout E28
worksheet.NetReservesNeededAfterCashOut = worksheet.BaseReserves + worksheet.AdditionalReservesRequired;
//Total Additional Still Required E29
worksheet.TotalAdditionalReservesStillRequired = worksheet.NetReservesNeededAfterCashOut > 0 ? worksheet.NetReservesNeededAfterCashOut : 0;
//Total Required Assets For Transaction E30
worksheet.TotalRequiredAssetsForTransaction = worksheet.ResidualAssets.TotalResidualAsset +
worksheet.SixtyMonthsRequiredReserves.Total + worksheet.TotalAdditionalReservesStillRequired;
//Loan Qualify D31
worksheet.LoanQualify = worksheet.ResidualAssets.TotalResidualAsset < worksheet.TotalRequiredAssetsForTransaction ? false : true;
//Amount of shortage or funds Remains E32
worksheet.FundRemain = worksheet.ResidualAssets.TotalResidualAsset - worksheet.TotalRequiredAssetsForTransaction;
//Toal Monthly Income C39
worksheet.TotalMonthlyIncome = worksheet.ResidualAssets.TotalResidualAsset > 0 ? worksheet.ResidualAssets.TotalResidualAsset / 60 : 0;
//Total Monthly Residual Income E39
worksheet.TotalMonthlyResidualIncome = worksheet.TotalMonthlyIncome - worksheet.MonthlyLiabilities.Total;
worksheet.Date = DateTime.Now.Date.ToString("MM/dd/yyyy", CultureInfo.InvariantCulture);
}
else
{
worksheet.Message = calcs.Message;
}
return(Ok(worksheet));
}
catch (Exception ex)
{
this.Error("Error in Asset Qualifier worksheet", ex.Message);
return(BadRequest(ex.Message));
}
}
