public ActionResult CreateMemberLoanApplication(string id)
{
int loanmasterId = string.IsNullOrEmpty(id.DecryptString()) ? default(int) : Convert.ToInt32(id.DecryptString());
int GroupId = GroupInfo.GroupID;
LoadDropdowns();
bool isView = false;
if (Request.QueryString["isView"] != null)
{
isView = Request.QueryString["isView"] == "1";
}
ViewBag.isView = isView;
MemberLoanApplicationDto memberLoanApplicationDto = new MemberLoanApplicationDto();
if (loanmasterId > 0)
{
memberLoanApplicationDto = _memberloanapplicationService.GetMemberLoanApplicationDetailsById(loanmasterId);
}
return(View(memberLoanApplicationDto));
}
public ActionResult ConfirmMemberLoanApplication(MemberLoanApplicationDto objLoan)
{
LoadMemberLoanApprovalInfo(objLoan);
int count = _memberloanapplicationService.SubmitLoanApplicationApproval((MemberLoanApprovalDto)objLoan, UserInfo.UserID, objLoan.LoanMasterId);
return(RedirectToAction("MemberLoanApplicationLookup"));
}
private MemberLoanApplicationDto LoadMemberLoanApprovalInfo(MemberLoanApplicationDto objLoan)
{
string statusCode = objLoan.StatusCode;
int loanSanctionAmount = default(int);
int NoOfInstallments = default(int);
if (statusCode == "INITIATED" || string.IsNullOrWhiteSpace(statusCode))
{
int.TryParse(Request.Form["GLSactionAmount"], out loanSanctionAmount);
int.TryParse(Request.Form["GLInstallments"], out NoOfInstallments);
objLoan.ApprovalType = "CA";
objLoan.LoanSanctionAmount = loanSanctionAmount;
objLoan.NoOfInstallments = NoOfInstallments;
objLoan.ApprovalComments = Convert.ToString(Request.Form["GLComments"]);
objLoan.Action = Convert.ToString(Request.Form["GLAction"]);
objLoan.ActionDate = Convert.ToDateTime(Request.Form["lblGLActionDate"]);
}
else if (statusCode == "FOR_CDA_REVIEW")
{
int.TryParse(Request.Form["CDASactionAmount"], out loanSanctionAmount);
int.TryParse(Request.Form["CDAInstallments"], out NoOfInstallments);
objLoan.ApprovalType = "CDA";
objLoan.LoanSanctionAmount = loanSanctionAmount;
objLoan.NoOfInstallments = NoOfInstallments;
objLoan.ApprovalComments = Convert.ToString(Request.Form["CDAComments"]);
objLoan.Action = Convert.ToString(Request.Form["hdnCDAAction"]);
objLoan.ActionDate = Convert.ToDateTime(Request.Form["lblCDAActionDate"]);
}
else if (statusCode == "FOR_RI_REVIEW")
{
int.TryParse(Request.Form["RISactionAmount"], out loanSanctionAmount);
int.TryParse(Request.Form["RIInstallments"], out NoOfInstallments);
objLoan.ApprovalType = "RI";
objLoan.LoanSanctionAmount = loanSanctionAmount;
objLoan.NoOfInstallments = NoOfInstallments;
objLoan.ApprovalComments = Convert.ToString(Request.Form["RIComments"]);
objLoan.Action = Convert.ToString(Request.Form["hdnRIAction"]);
objLoan.ActionDate = Convert.ToDateTime(Request.Form["lblRIActionDate"]);
}
else if (statusCode == "FOR_MD_APPROVAL")
{
int.TryParse(Request.Form["MDSactionAmount"], out loanSanctionAmount);
int.TryParse(Request.Form["MDInstallments"], out NoOfInstallments);
objLoan.ApprovalType = "MD";
objLoan.LoanSanctionAmount = loanSanctionAmount;
objLoan.NoOfInstallments = NoOfInstallments;
objLoan.ApprovalComments = Convert.ToString(Request.Form["MDComments"]);
objLoan.Action = Convert.ToString(Request.Form["hdnMDAction"]);
objLoan.ActionDate = Convert.ToDateTime(Request.Form["lblMDActionDate"]);
}
return(objLoan);
}
public ActionResult CreateMemberLoanApplication(MemberLoanApplicationDto objLoan)
{
var resultDto = new ResultDto();
int GroupId = GroupInfo.GroupID;
bool IsChecked = false;
if (objLoan.LoanMasterId <= 0)
{
MemberLoanDisbursementDataAccess dl = new MemberLoanDisbursementDataAccess();
IsChecked = dl.CheckLoanExisted(objLoan.MemberID, objLoan.InterestMasterID);
if (IsChecked)
{
resultDto.Message = "Unable to create Loan: Outstanding Amount Exists for this member";
}
}
objLoan = LoadMemberLoanApprovalInfo(objLoan);
objLoan.UserID = UserInfo.UserID;
objLoan.GroupID = GroupInfo.GroupID;
if (!IsChecked)
{
if (string.IsNullOrEmpty(objLoan.StatusCode) || objLoan.StatusCode == "INITIATED")
{
resultDto = _memberloanapplicationService.InsertUpdateMemberLoanApplication(objLoan);
objLoan.LoanCode = resultDto.ObjectCode;
objLoan.LoanMasterId = resultDto.ObjectId;
}
if (objLoan.LoanMasterId > 0)
{
_memberloanapplicationService.SubmitLoanApplicationApproval((MemberLoanApprovalDto)objLoan, UserInfo.UserID, objLoan.LoanMasterId, true);
objLoan = _memberloanapplicationService.GetMemberLoanApplicationDetailsById(objLoan.LoanMasterId);
}
}
TempData["Result"] = resultDto;
LoadDropdowns();
return(View(objLoan));
}
private ResultDto InsertUpdateMemberLoanApplicationOld(MemberLoanApplicationDto MemberLoanApplication)
{
ResultDto resultDto = new ResultDto();
MemberLoanApplication.LoanType = "M";
string obectName = "Member Loan Application";
try
{
ObjectParameter paramLoanMasterID = new ObjectParameter("LoanMasterID", MemberLoanApplication.LoanMasterId);
ObjectParameter paramloanCode = new ObjectParameter("LoanCode", string.Empty);
int count = _dbContext.uspLoanApplicationInsertUpdate(paramLoanMasterID, paramloanCode, MemberLoanApplication.LoanType, MemberLoanApplication.MemberID, MemberLoanApplication.GroupID,
MemberLoanApplication.LoanApplicationDate, MemberLoanApplication.LoanPurpose, MemberLoanApplication.FundSourceId, MemberLoanApplication.ProjectID, MemberLoanApplication.LoanAmountApplied, MemberLoanApplication.NoofInstallmentsProposed, MemberLoanApplication.Mode, MemberLoanApplication.UserID, MemberLoanApplication.InterestMasterID);
resultDto.ObjectId = (int)paramLoanMasterID.Value;
resultDto.ObjectCode = string.IsNullOrEmpty((string)paramloanCode.Value) ? MemberLoanApplication.LoanCode : (string)paramloanCode.Value;
if (resultDto.ObjectId > 0)
{
resultDto.Message = string.Format("{0} details saved successfully with code : {1}", obectName, resultDto.ObjectCode);
}
else if (resultDto.ObjectId == -1)
{
resultDto.Message = string.Format("Error occured while generating {0} code", obectName);
}
else
{
resultDto.Message = string.Format("Error occured while saving {0} details", obectName);
}
}
catch (Exception)
{
resultDto.Message = string.Format("Service layer error occured while saving the {0} details", obectName);
resultDto.ObjectId = -98;
}
return(resultDto);
}
public ResultDto Insert(MemberLoanApplicationDto MemberLoanApplication)
{
return(InsertUpdateMemberLoanApplicationOld(MemberLoanApplication));
}
public ResultDto InsertUpdateMemberLoanApplication(MemberLoanApplicationDto objMemberLoan)
{
MemberLoanDisbursementDataAccess objMemberLoandal = new MemberLoanDisbursementDataAccess();
return(objMemberLoandal.InsertUpdateMemberLoanApplication(objMemberLoan));
}
