public ActionResult loanList(string keyword, tbl_Loan loan) { var results = (from item in db.tbl_Loan where item.tbl_staffInfo.Name.Contains(keyword) || item.PaymentWay.Contains(keyword) select item).ToList(); var pageIndex = loan.Page ?? 1; loan.loanListResults = results.ToPagedList(pageIndex, recordPerPages); return(View(loan)); }
public ActionResult loanList(tbl_Loan loan) { var results = (from item in db.tbl_Loan select item).ToList().OrderBy(l => l.LoanID); var pageIndex = loan.Page ?? 1; loan.loanListResults = results.ToPagedList(pageIndex, recordPerPages); return(View(loan)); }
public ActionResult loanDelete(int id = 0) { tbl_Loan bc1 = db.tbl_Loan.FirstOrDefault(l => l.LoanID == id); db.tbl_Loan.Remove(bc1); db.SaveChanges(); return(RedirectToAction("loanList")); }
public ActionResult loanUpdate(int id = 0) { loanid = id; tbl_Loan bc = db.tbl_Loan.FirstOrDefault(l => l.LoanID == loanid); if (bc == null) { return(HttpNotFound()); } ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name"); ViewBag.GetSalary = bc.Salary; ViewBag.GetLoanAmount = bc.LoanAmount; ViewBag.GetNewLoan = bc.NewLoan; ViewBag.GetLoanBack = bc.LoanBack; ViewBag.GetPaymentWay = bc.PaymentWay; ViewBag.GetGrandTotalLoan = bc.GrandTotalLoan; ViewBag.GetPaidLoan = bc.PaidLoan; return(View(bc)); }
public ActionResult loanUpdate(tbl_Loan bc, int id = 0) { tbl_Loan bc1 = db.tbl_Loan.FirstOrDefault(l => l.LoanID == loanid); bc1.StaffID = bc.StaffID; bc1.Salary = bc.Salary; bc1.LoanAmount = bc.LoanAmount; bc1.NewLoan = bc.NewLoan; bc1.LoanBack = bc.LoanBack; bc1.PaymentWay = bc.PaymentWay; bc1.GrandTotalLoan = bc.GrandTotalLoan; bc1.PaidLoan = bc.PaidLoan; if (bc1 == null) { return(HttpNotFound()); } db.SaveChanges(); ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name"); ViewBag.Messages = "Update Succesfully!!"; return(View(bc1)); }
public ActionResult addLoan(tbl_Loan loan) { if (ModelState.IsValid) { string userid = ""; string userSettings = ""; if (Request.Cookies["UserSettings"] != null) { if (Request.Cookies["UserSettings"]["UserName"] != null) { userSettings = Request.Cookies["UserSettings"]["UserName"]; userid = Request.Cookies["UserSettings"]["UserId"]; } } loan.EntryDate = DateTime.Today; loan.UserID = Convert.ToInt32(userid); db.tbl_Loan.Add(loan); db.SaveChanges(); return(RedirectToAction("loanList")); } ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name"); ViewBag.UserID = new SelectList(db.tbl_UserInfo, "UserInfoID", "UserName"); return(View(loan)); }