/// <summary>
        /// Delete Loan
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public ActionResult DeleteLoan(int id)
        {
            try
            {
                DB64Entities db   = new DB64Entities();
                var          item = db.Loans.Where(x => x.Id == id).SingleOrDefault();
                db.Loans.Remove(item);
                db.SaveChanges();

                return(RedirectToAction("Loanlist", "Admin"));
            }
            catch (Exception ex)
            {
                throw(ex);
            }
        }
        /// <summary>
        /// Delete installment from database
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public ActionResult DeleteInstallment(int id)
        {
            try
            {
                DB64Entities db    = new DB64Entities();
                var          item2 = db.Installements.Where(x => x.Id == id).SingleOrDefault();
                int          temp  = item2.LoanId;
                var          item  = db.Installements.Where(x => x.Id == id).SingleOrDefault();
                db.Installements.Remove(item);
                db.SaveChanges();

                return(RedirectToAction("ViewInstallment", "Admin", new { id = temp }));
            }
            catch (Exception ex)
            {
                throw (ex);
            }
        }