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); }