public async Task <OfferLetterDetailObj> Handle(GenerateOfferLetterQuery request, CancellationToken cancellationToken) { var _LoanOffer = await _repo.GetLoanapplicationOfferLeterAsync(request.ApplicationReference); OfferLetterDetailObj offerletterResp = new OfferLetterDetailObj { Status = new APIResponseStatus { IsSuccessful = false, Message = new APIResponseMessage() } }; if (_LoanOffer != null) { var _Companies = await _serverRequest.GetAllCompanyAsync(); var _Currency = await _serverRequest.GetCurrencyAsync(); var _LoanCustomer = await _loanCustomerRepo.GetLoanCustomersAsync(); var _Product = await _product.GetProductsAsync(); offerletterResp.CompanyName = _Companies.companyStructures.FirstOrDefault(c => c.companyStructureId == _LoanOffer.CompanyId)?.name; offerletterResp.ProductName = _Product.FirstOrDefault(c => c.ProductId == _LoanOffer.ApprovedProductId)?.ProductName; offerletterResp.CurrencyName = _Currency.commonLookups.FirstOrDefault(c => c.LookupId == _LoanOffer.CurrencyId)?.LookupName; offerletterResp.Tenor = _LoanOffer.ApprovedTenor; offerletterResp.InterestRate = _LoanOffer.ApprovedRate; offerletterResp.LoanAmount = _LoanOffer.ApprovedAmount; offerletterResp.ExchangeRate = _LoanOffer.ExchangeRate; offerletterResp.CustomerAddress = _LoanCustomer.FirstOrDefault(a => a.CustomerId == _LoanOffer.CustomerId)?.Address; offerletterResp.CustomerEmailAddress = _LoanCustomer.FirstOrDefault(d => d.CustomerId == _LoanOffer.CustomerId)?.Email; offerletterResp.CustomerPhoneNumber = _LoanCustomer.FirstOrDefault(d => d.CustomerId == _LoanOffer.CustomerId)?.PhoneNo; offerletterResp.ApplicationDate = _LoanOffer.ApplicationDate; offerletterResp.LoanApplicationId = _LoanOffer.ApplicationRefNumber; offerletterResp.RepaymentSchedule = "Not applicable"; offerletterResp.RepaymentTerms = "Not applicable"; offerletterResp.Purpose = _LoanOffer.Purpose; offerletterResp.CustomerName = $"{_LoanCustomer.FirstOrDefault(d => d.CustomerId == _LoanOffer.CustomerId)?.FirstName} {_LoanCustomer.FirstOrDefault(d => d.CustomerId == _LoanOffer.CustomerId)?.LastName} "; } var decision = _repo.GetOfferletterDecision(_LoanOffer.LoanApplicationId); var customerDocs = await _loanCustomerRepo.GetCustomerDocumentsAsync(_LoanOffer.CustomerId); var signatureExist = customerDocs.Any(s => s.DocumentTypeId == 1); if (decision != null && signatureExist) { if (decision.ReportStatus.ToLower().Trim() == "accept") { offerletterResp.Signature = customerDocs.FirstOrDefault(x => x.DocumentTypeId == 1)?.DocumentFile; } } if (offerletterResp != null) { offerletterResp.Status.IsSuccessful = true; return(offerletterResp); } offerletterResp.Status.Message.FriendlyMessage = "Unable to fetch offer letter"; return(offerletterResp); }