public async Task <ActionResult <ApprovalRegRespObj> > GoForApproval([FromBody] ApprovalObj entity)
{
using (var _trans = _dataContext.Database.BeginTransaction())
{
try
{
var currentUserId = _httpContextAccessor.HttpContext.User?.FindFirst(x => x.Type == "userId").Value;
var user = await _serverRequest.UserDataAsync();
var loan = _dataContext.credit_loan.Find(entity.TargetId);
var req = new IndentityServerApprovalCommand
{
ApprovalComment = entity.Comment,
ApprovalStatus = entity.ApprovalStatusId,
TargetId = entity.TargetId,
WorkflowToken = loan.WorkflowToken,
ReferredStaffId = entity.ReferredStaffId
};
var previousDetails = _dataContext.cor_approvaldetail.Where(x => x.WorkflowToken.Contains(loan.WorkflowToken) && x.TargetId == entity.TargetId).ToList();
var lastDate = loan.CreatedOn;
if (previousDetails.Count() > 0)
{
lastDate = previousDetails.OrderByDescending(x => x.ApprovalDetailId).FirstOrDefault().Date;
}
if (previousDetails.Count() > 0)
{
lastDate = previousDetails.OrderByDescending(x => x.ApprovalDetailId).FirstOrDefault().Date;
}
var details = new cor_approvaldetail
{
Comment = entity.Comment,
Date = DateTime.Now,
ArrivalDate = previousDetails.Count() > 0 ? lastDate : loan.CreatedOn,
StatusId = entity.ApprovalStatusId,
TargetId = entity.TargetId,
StaffId = user.StaffId,
WorkflowToken = loan.WorkflowToken
};
var result = await _serverRequest.StaffApprovalRequestAsync(req);
if (!result.IsSuccessStatusCode)
{
return(new ApprovalRegRespObj
{
Status = new APIResponseStatus
{
Message = new APIResponseMessage {
FriendlyMessage = result.ReasonPhrase
}
}
});
}
var stringData = await result.Content.ReadAsStringAsync();
var response = JsonConvert.DeserializeObject <ApprovalRegRespObj>(stringData);
if (!response.Status.IsSuccessful)
{
return(new ApprovalRegRespObj
{
Status = response.Status
});
}
if (response.ResponseId == (int)ApprovalStatus.Processing)
{
loan.ApprovalStatusId = (int)ApprovalStatus.Processing;
await _dataContext.cor_approvaldetail.AddAsync(details);
await _dataContext.SaveChangesAsync();
_trans.Commit();
return(new ApprovalRegRespObj
{
ResponseId = (int)ApprovalStatus.Processing,
Status = new APIResponseStatus {
IsSuccessful = true, Message = response.Status.Message
}
});
}
if (response.ResponseId == (int)ApprovalStatus.Revert)
{
loan.ApprovalStatusId = (int)ApprovalStatus.Revert;
await _dataContext.cor_approvaldetail.AddAsync(details);
await _dataContext.SaveChangesAsync();
_trans.Commit();
return(new ApprovalRegRespObj
{
ResponseId = (int)ApprovalStatus.Revert,
Status = new APIResponseStatus {
IsSuccessful = true, Message = response.Status.Message
}
});
}
if (response.ResponseId == (int)ApprovalStatus.Approved)
{
var applicationResponse = _repo.DisburseLoan(entity.TargetId, user.StaffId, user.UserName, entity.Comment);
var customer = _dataContext.credit_loancustomer.Find(loan.CustomerId);
await _serverRequest.SendMail(new MailObj
{
fromAddresses = new List <FromAddress> {
},
toAddresses = new List <ToAddress>
{
new ToAddress {
address = customer.Email, name = customer.FirstName
}
},
subject = "Loan Successfully Approved",
content = $"Hi {customer.FirstName}, <br> Your loan application has been finally approved. <br/> Loan Amount : {loan.PrincipalAmount}",
sendIt = true,
});
//Update CustomerTransaction
if (applicationResponse.DisbursementEntry != null && applicationResponse.IntegralFeeEntry != null)
{
_customerTrans.CustomerTransaction(applicationResponse.DisbursementEntry);
_customerTrans.CustomerTransaction(applicationResponse.IntegralFeeEntry);
}
//Generate Schedule
if (applicationResponse.loanPayment != null && applicationResponse.AnyIdentifier > 0)
{
await _schedule.AddLoanSchedule(applicationResponse.AnyIdentifier, applicationResponse.loanPayment);
}
//Update IFRS
_ifrs.UpdateScoreCardHistoryByLoanDisbursement(entity.TargetId, user.UserId);
//Pay with Flutterwave
if (applicationResponse.FlutterObj != null)
{
var flutter = _serverRequest.GetFlutterWaveKeys().Result;
if (flutter.keys.useFlutterWave)
{
var res = _flutter.createBulkTransfer(applicationResponse.FlutterObj).Result;
loan.ApprovalStatusId = (int)ApprovalStatus.Approved;
await _dataContext.cor_approvaldetail.AddAsync(details);
await _dataContext.SaveChangesAsync();
_trans.Commit();
if (res.status.ToLower().Trim() != "success")
{
return(new ApprovalRegRespObj
{
ResponseId = (int)ApprovalStatus.Revert,
Status = new APIResponseStatus {
IsSuccessful = true, Message = new APIResponseMessage {
FriendlyMessage = "Loan disbursed successfully but transfer creation failed"
}
}
});
}
else if (res.status.ToLower().Trim() == "success")
{
return(new ApprovalRegRespObj
{
ResponseId = (int)ApprovalStatus.Revert,
Status = new APIResponseStatus {
IsSuccessful = true, Message = new APIResponseMessage {
FriendlyMessage = "Loan disbursed successfully and transfer creation successful"
}
}
});
}
}
}
loan.ApprovalStatusId = (int)ApprovalStatus.Approved;
await _dataContext.cor_approvaldetail.AddAsync(details);
await _dataContext.SaveChangesAsync();
_trans.Commit();
return(new ApprovalRegRespObj
{
ResponseId = (int)ApprovalStatus.Approved,
Status = new APIResponseStatus {
IsSuccessful = true, Message = response.Status.Message
}
});
}
if (response.ResponseId == (int)ApprovalStatus.Disapproved)
{
loan.ApprovalStatusId = (int)ApprovalStatus.Disapproved;
await _dataContext.cor_approvaldetail.AddAsync(details);
await _dataContext.SaveChangesAsync();
_trans.Commit();
return(new ApprovalRegRespObj
{
ResponseId = (int)ApprovalStatus.Disapproved,
Status = new APIResponseStatus {
IsSuccessful = true, Message = response.Status.Message
}
});
}
return(new ApprovalRegRespObj
{
Status = response.Status
});
}
catch (Exception ex)
{
_trans.Rollback();
var errorCode = ErrorID.Generate(5);
_logger.Error($"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}");
return(new ApprovalRegRespObj
{
Status = new APIResponseStatus {
IsSuccessful = false, Message = new APIResponseMessage {
FriendlyMessage = "Error Occurred", TechnicalMessage = ex?.Message, MessageId = errorCode
}
}
});
}
finally { _trans.Dispose(); }
}
}
public async Task <AuthenticationResult> CustomerRegisterAsync(CustomUserRegistrationReqObj userRegistration)
{
try
{
var accountNumber = GeneralHelpers.GenerateRandomDigitCode(10);
var existingUser = await _userManager.FindByEmailAsync(userRegistration.Email);
if (existingUser != null)
{
return(new AuthenticationResult
{
Status = new APIResponseStatus
{
IsSuccessful = false,
Message = new APIResponseMessage
{
FriendlyMessage = "User with this email address already exist"
}
}
});
}
var user = new ApplicationUser
{
Email = userRegistration.Email,
UserName = userRegistration.Email,
PhoneNumber = userRegistration.PhoneNo,
FirstName = userRegistration.FirstName,
LastName = userRegistration.LastName,
Address = userRegistration.Address,
CustomerTypeId = userRegistration.CustomerTypeId,
ApprovalStatusId = 1,
SecurityAnswered = userRegistration.SecurityAnswered,
QuestionId = userRegistration.QuestionId
};
var createdUser = await _userManager.CreateAsync(user, userRegistration.Password);
var customer = new credit_loancustomer
{
Email = userRegistration.Email,
UserIdentity = user.Id,
PhoneNo = userRegistration.PhoneNo,
FirstName = userRegistration.FirstName,
LastName = userRegistration.LastName,
Address = userRegistration.Address,
CustomerTypeId = userRegistration.CustomerTypeId,
CASAAccountNumber = accountNumber,
ApprovalStatusId = 1,
ProfileStatus = 0,
Active = true,
Deleted = false,
CreatedBy = user.Email,
CreatedOn = DateTime.Now,
RegistrationSource = "Website"
};
_dataContext.credit_loancustomer.Add(customer);
_dataContext.SaveChanges();
if (!createdUser.Succeeded)
{
return(new AuthenticationResult
{
Status = new APIResponseStatus
{
IsSuccessful = false,
Message = new APIResponseMessage
{
FriendlyMessage = createdUser.Errors.Select(x => x.Description).FirstOrDefault(),
}
}
});
}
var custCode = ConfirmationCode.Generate();
var successful = await CustomerSendAndStoreConfirmationCode(custCode, user.Email);
var accountId = user.Id;
var name = user.FirstName;
var baseUrl = _configuration.GetValue <string>("FrontEndUrl:webUrl");
var url = baseUrl + "/#/auth/activate-account/" + accountId + "";
var content1 = "Welcome to GOS Credit! There's just one step before you get to complete your customer account registration. Verify you have the right email address by clicking on the button below.";
var content2 = "Once your account creation is completed, your can explore our services and have a seamless experience.";
var body = GeneralHelpers.MailBody(name, url, content1, content2);
var addresses = new ToAddress
{
name = user.FirstName + " " + user.LastName,
address = user.Email
};
var addressList = new List <ToAddress> {
addresses
};
var mailObj = new MailObj
{
subject = "Email Verification",
content = body,
toAddresses = addressList,
fromAddresses = new List <FromAddress> {
},
sendIt = true,
saveIt = false
};
var res = _identityServer.SendMail(mailObj);
return(new AuthenticationResult
{
Status = new APIResponseStatus
{
IsSuccessful = true,
CustomToken = custCode,
}
});
}
catch (Exception ex)
{
#region Log error
var errorCode = ErrorID.Generate(4);
_logger.Error($"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}");
return(new AuthenticationResult
{
Status = new APIResponseStatus
{
Message = new APIResponseMessage
{
FriendlyMessage = "Error occured!! Please try again later",
MessageId = errorCode,
TechnicalMessage = $"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}"
}
}
});
#endregion
}
}
