public ActionResult attendanceList(string keyword, tbl_Attendance attendances) { var results = (from item in db.tbl_Attendance where item.tbl_staffInfo.Name.Contains(keyword) || item.Sift.Contains(keyword) select item).ToList(); var pageIndex = attendances.Page ?? 1; attendances.AttendanceListResult = results.ToPagedList(pageIndex, RecordsPerPage); return(View(attendances)); }
public JsonResult attendanceDelete(int id = 0) { tbl_Attendance attendance = db.tbl_Attendance.Where(x => x.AttendID == id).FirstOrDefault(); db.tbl_Attendance.Remove(attendance); db.SaveChanges(); return(Json(true, JsonRequestBehavior.AllowGet)); }
public ActionResult attendanceList(tbl_Attendance attendances) { var results = (from item in db.tbl_Attendance select item).ToList().OrderBy(p => p.AttendID); var pageIndex = attendances.Page ?? 1; attendances.AttendanceListResult = results.ToPagedList(pageIndex, RecordsPerPage); return(View(attendances)); //return View(db.Attendances.ToList()); }
public ActionResult addAttendance(tbl_Attendance attend) { if (ModelState.IsValid) { db.tbl_Attendance.Add(attend); db.SaveChanges(); return(RedirectToAction("attendanceList")); } ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name"); ViewBag.UserID = new SelectList(db.tbl_UserInfo, "UserInfoID", "UserName"); return(View(attend)); }
public ActionResult AttendanceUpdate(int id = 0) { attendancid = id; tbl_Attendance bc = db.tbl_Attendance.FirstOrDefault(a => a.AttendID == attendancid); if (bc == null) { return(HttpNotFound()); } ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name"); ViewBag.GetEmployeeAttendance = bc.EmployeeAttendance; ViewBag.GetSift = bc.Sift; ViewBag.GetOverTime = bc.OverTime; return(View(bc)); }
public ActionResult AttendanceUpdate(tbl_Attendance bc, int id = 0) { tbl_Attendance bc1 = db.tbl_Attendance.FirstOrDefault(a => a.AttendID == attendancid); bc1.StaffID = bc.StaffID; bc1.EmployeeAttendance = bc.EmployeeAttendance; bc1.Sift = bc.Sift; bc1.OverTime = bc.OverTime; if (bc1 == null) { return(HttpNotFound()); } db.SaveChanges(); ViewBag.StaffID = new SelectList(db.tbl_staffInfo, "StaffID", "Name"); return(View(bc1)); }