// GET: CheckUp public ActionResult GetChecksUp(string sortOrder, string currentFilter, string searchString, int?page) { ViewBag.CurrentSort = sortOrder; ViewBag.NameSortParm = string.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date"; if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; IQueryable <CheckUp> Checks = db.CheckUps; if (!string.IsNullOrEmpty(searchString)) { Checks = Checks.Where(s => s.doctor.doctorName.Contains(searchString) || s.Patient.name.Contains(searchString) || s.CheckType.Contains(searchString) || s.CreateAt.ToString().Contains(searchString)); } var viewModels = new List <CheckUpViewModel>(); if (Checks != null) { foreach (var item in Checks) { var viewModel = new CheckUpViewModel(); viewModel.id = item.id; viewModel.doctorName = item.doctor.doctorName; viewModel.Patientname = item.Patient.name; viewModel.CreateAt = item.CreateAt; viewModel.CheckType = item.CheckType; viewModels.Add(viewModel); } } if (page.HasValue && page < 1) { return(null); } // retrieve list from database/wherever9 var listUnpaged = viewModels.ToList(); // page the list const int pageSize = 10; var listPaged = listUnpaged.ToPagedList(page ?? 1, pageSize); // return a 404 if user browses to pages beyond last page. special case first page if no items exist if (listPaged.PageNumber != 1 && page.HasValue && page > listPaged.PageCount) { return(null); } return(View(listPaged)); }
public ActionResult Delete(CheckUpViewModel checkUpView) { var result = db.CheckUps.Find(checkUpView.id); db.CheckUps.Remove(result); db.SaveChanges(); return(RedirectToAction("GetChecksUp")); }
public ActionResult Delete(int id) { var checkup = db.CheckUps.Find(id); CheckUpViewModel viewModel = new CheckUpViewModel { CheckType = checkup.CheckType, doctorName = checkup.doctor.doctorName, Patientname = checkup.Patient.name, CreateAt = checkup.CreateAt, id = checkup.id }; return(View(viewModel)); }