public string LoanNumber(CustomerLoanMortage obj)
        {
            Random random  = new Random();
            var    details = context.Customers.Where(c => c.Contact == obj.Contact).FirstOrDefault();

            var userId = details.UserId;
            var Rnum   = random.Next(1000, 10000);

            var loanNumber = userId + Rnum;

            return(loanNumber);
        }
        public ActionResult ApplyLoan(CustomerLoanMortage obj)
        {
            ViewBag.Date = context.Mortgages.ToList();

            var month = DateTime.Now.Month;
            var year  = DateTime.Now.Year;

            try
            {
                if (!ModelState.IsValid)
                {
                    return(View());
                }
                var customer = context.Customers.Where(c => c.FName == obj.FName && c.LName == obj.LName &&

                                                       c.Contact == obj.Contact && c.Email == obj.Email

                                                       ).FirstOrDefault();

                if (customer == null)
                {
                    ModelState.AddModelError("", "Please Enter correct Customer Information");
                    return(View());
                }

                obj.LoanNumber = LoanNumber(obj);

                obj.LoanApplyDate   = DateTime.Now;
                obj.DayOfEmiPayment = new DateTime(year, month, 5).AddMonths(1);
                obj.LoanStatus      = "new";



                context.CustomerLoanMortages.Add(obj);
                context.SaveChanges();
            }
            catch (Exception ex)
            {
                Session.Add("ErrorMessage", ex.Message);
                return(View("ErrorView"));
            }
            var loanId = context.CustomerLoanMortages.Where(loan => loan.LoanNumber == obj.LoanNumber).FirstOrDefault().Id;



            return(RedirectToAction("Index"));
        }