public bool AddLoanAccountRequest(LoanRequestViewModel request) { bool result = false; using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Database1ConnectionString"].ToString())) { int requestID; SqlCommand command = new SqlCommand("SELECT Count(RequestID) FROM LoanRequest ", connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); string customerName = GetCustomerNamebyCustomerID(request.customerID); reader.Read(); requestID = Convert.ToInt16(reader[0]) + 1; reader.Close(); command.CommandText = String.Format("INSERT INTO LoanRequest (RequestID, TypeOfLoan, CustomerID, SubmissionDate, Status, BranchCode, AnnualIncome, Amount, Tenure, AddressProof, SalaryProof, CustomerName) VALUES('{0}', '{1}', '{2}', '{3}', 'S', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}') ", requestID, request.typeOfLoan, request.customerID, DateTime.Now.ToString(), request.branchName, request.annualIncome.ToString(), request.amount.ToString(), request.tenure.ToString(), request.addressProof, request.salaryProof, customerName); if (command.ExecuteNonQuery() > 0) result = true; } return result; }
public ActionResult ApplyForLoan() { CommonDAL objCommonDal = new CommonDAL(); ViewBag.cityList = objCommonDal.GetCityList(); long customerID = (Session["User"] as UserRole).customerID; CustomerDAL objCustomerDal = new CustomerDAL(); LoanRequestViewModel objLoanRequest = new LoanRequestViewModel(); objLoanRequest.customerID = customerID; objLoanRequest.age = objCustomerDal.GetAgeByCustomerID(customerID); objLoanRequest.salaryProof = new byte[1024]; objLoanRequest.addressProof = new byte[1024]; @ViewBag.loanTypeList = new List<SelectListItem>() { new SelectListItem(){Text = "Personal",Value="P"}, new SelectListItem(){Text = "Home",Value="H"}, new SelectListItem(){Text = "Vehicle",Value="V"}, }; return View(objLoanRequest); }
public ActionResult ApplyForLoan(LoanRequestViewModel model) { CommonDAL objCommonDal = new CommonDAL(); CustomerDAL objCustomerDal = new CustomerDAL(); ViewBag.cityList = objCommonDal.GetCityList(); @ViewBag.loanTypeList = new List<SelectListItem>() { new SelectListItem(){Text = "Personal",Value="P"}, new SelectListItem(){Text = "Home",Value="H"}, new SelectListItem(){Text = "Vehicle",Value="V"}, }; if(objCustomerDal.AddLoanAccountRequest(model) ) { ModelState.AddModelError("", "You request for loan was successful. You may apply for yet another loan"); } else { ModelState.AddModelError("", "Operation failed"); } return View(model); }