public ActionResult BankApplicationView(string id, string type)
{
int loanMasterId = string.IsNullOrEmpty(id.DecryptString()) ? default(int) : Convert.ToInt32(id.DecryptString());
MemberLoanApplicationViewDto objLoanViewDto = _bankLoanService.GetMemberLoanApplicationViewDetails(loanMasterId);
ViewBag.isViewPage = type != "A";
return(View(objLoanViewDto));
}
public ActionResult MemberLoanApplicationView(FormCollection form)
{
string id = form.Get("LoanMasterId");
string statusCode = form.Get("StatusCode");
string comments = string.Empty;
string action = "APP";
if (statusCode == "INITIATED" || statusCode == "FOR_GROUP_REVERIFY")
{
comments = form.Get("GroupApprovalComments");
}
else
{
action = form.Get("ddlAction");
if (statusCode == "FOR_CLUSTER_REVIEW" || statusCode == "FOR_CLUSTER_REVERIFY")
{
comments = form.Get("ClusterApprovalComments");
}
else
{
comments = form.Get("FederationApprovalComments");
}
}
Enums.ApprovalActions actionType = Utilities.Enums.ApprovalActions.APP;
if (action == "CAN")
{
actionType = Utilities.Enums.ApprovalActions.CAN;
}
else if (action == "REJ")
{
actionType = Utilities.Enums.ApprovalActions.REJ;
}
string loanCode = form.Get("LoanCode");
int loanMasterId = string.IsNullOrEmpty(id.DecryptString()) ? default(int) : Convert.ToInt32(id.DecryptString());
ResultDto res = _memberloanapplicationService.ApproveMemberLoanApplication(loanMasterId, loanCode, actionType, comments, UserInfo.UserID);
TempData["Result"] = res;
if (res.ObjectId > 0)
{
return(RedirectToAction("MemberLoanApplicationLookup"));
}
else
{
MemberLoanApplicationViewDto objLoanViewDto = _memberloanapplicationService.GetMemberLoanApplicationViewDetails(loanMasterId);
ViewBag.isViewPage = false;
return(View(objLoanViewDto));
}
}
public MemberLoanApplicationViewDto GetMemberLoanApplicationViewDetails(int loanMasterId)
{
MemberLoanApplicationViewDto objLoanApplication = new MemberLoanApplicationViewDto();
AdoHelper objAdo = new AdoHelper();
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@LoanMasterID", loanMasterId);
parms[0].SqlDbType = System.Data.SqlDbType.Int;
SqlDataReader dr = objAdo.ExecDataReaderProc("uspGetMemberLoanApplicationView", parms);
if (dr.Read())
{
objLoanApplication.LoanMasterId = Convert.ToInt32(dr["LoanMasterID"]);
objLoanApplication.LoanCode = Convert.ToString(dr["LoanCode"]);
objLoanApplication.MemberName = Convert.ToString(dr["MemberName"]);
objLoanApplication.LoanApplicationDate = Convert.ToDateTime(dr["LoanApplicationDate"]);
objLoanApplication.ProjectPurpose = Convert.ToString(dr["ProjectName"]);
objLoanApplication.LoanPurpose = Convert.ToString(dr["LoanPurpose"]);
objLoanApplication.LoanApplyAmount = Convert.ToInt32(dr["LoanAmountApplied"]);
objLoanApplication.NoOfInstallmentsProposed = Convert.ToInt32(dr["NoofInstallmentsProposed"]);
objLoanApplication.LoanPrincipalAccountHead = Convert.ToString(dr["PrincipalAccountHead"]);
objLoanApplication.LoanRepaymentMode = Convert.ToString(dr["Mode"]);
if (dr["AppLevel"] != DBNull.Value)
{
objLoanApplication.ApprovalLevel = Convert.ToInt32(dr["AppLevel"]);
}
objLoanApplication.Status = Convert.ToString(dr["Status"]);
objLoanApplication.StatusCode = Convert.ToString(dr["StatusCode"]);
objLoanApplication.GroupApprovalComments = Convert.ToString(dr["GroupComments"]);
objLoanApplication.ClusterApprovalComments = Convert.ToString(dr["ClusterComments"]);
objLoanApplication.FederationApprovalComments = Convert.ToString(dr["FederationComments"]);
if (dr["GroupActionDate"] != DBNull.Value)
{
objLoanApplication.GroupActionDate = Convert.ToDateTime(dr["GroupActionDate"]);
}
if (dr["ClusterActionDate"] != DBNull.Value)
{
objLoanApplication.ClusterActionDate = Convert.ToDateTime(dr["ClusterActionDate"]);
}
if (dr["FederationActionDate"] != DBNull.Value)
{
objLoanApplication.FederationActionDate = Convert.ToDateTime(dr["FederationActionDate"]);
}
if (dr["DisbursementDate"] != DBNull.Value)
{
objLoanApplication.LoanInterestAccountHead = Convert.ToString(dr["InterestAccountHead"]);
objLoanApplication.InterestRate = Convert.ToInt32(dr["ROI"]);
objLoanApplication.MonthlyDueDay = Convert.ToInt32(dr["DueDay"]);
objLoanApplication.DisbursementDate = Convert.ToDateTime(dr["DisbursementDate"]);
objLoanApplication.NoOfInstallment = Convert.ToInt32(dr["NoOfInstallments"]);
objLoanApplication.LoanReferenceNumber = Convert.ToString(dr["LoanRefNumber"]);
objLoanApplication.DisbursementAmount = Convert.ToDecimal(dr["DisbursedAmount"]);
objLoanApplication.InstallmentStartFrom = Convert.ToDateTime(dr["InstallmentStartFrom"]);
objLoanApplication.InstallmentClosingDate = Convert.ToDateTime(dr["LoanClosingDate"]);
objLoanApplication.MonthlyPrincipalDemand = Convert.ToInt32(dr["MonthlyPrincipalDemand"]);
objLoanApplication.ChequeNumber = Convert.ToString(dr["ChequeNumber"]);
if (dr["ChequeDate"] != DBNull.Value)
{
objLoanApplication.ChequeDate = Convert.ToDateTime(dr["ChequeDate"]);
}
objLoanApplication.BankAccountHead = Convert.ToString(dr["BankAccountHead"]);
}
}
return(objLoanApplication);
}
