public JsonResult SaveDataInDatabase(FacultyListViewModel f) { var result = false; try { if (f.faculty.facId > 0) { Faculty f1 = db.Faculties.SingleOrDefault(x => x.facId == f.faculty.facId); f1.facNum = f.faculty.facNum; f1.name = f.faculty.name; f1.department = f.faculty.department; f1.rank = f.faculty.rank; db.SaveChanges(); result = true; } else { Faculty f1 = new Faculty(); f1.facNum = f.faculty.facNum; f1.name = f.faculty.name; f1.department = f.faculty.department; f1.rank = f.faculty.rank; db.Faculties.Add(f1); db.SaveChanges(); result = true; } } catch (Exception e) { throw e; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult List() { var facultiesInDb = _facultyService.GetFaculties(); var facultyDtos = new List <FacultyDto>(); foreach (var faculty in facultiesInDb) { var facultyDto = Mapper.Map <Faculty, FacultyDto>(faculty); facultyDtos.Add(facultyDto); } var viewModel = new FacultyListViewModel { FacultyDtos = facultyDtos, }; return(View(viewModel)); }
public ActionResult Index(string searchBy, string search, int?page, int?pagesize) { List <FacultyViewModel> l = db.Faculties.Select(x => new FacultyViewModel { facId = x.facId, facNum = x.facNum, name = x.name, department = x.department, rank = x.rank }).ToList(); int defaultpagesize = 2; if (pagesize != null) { defaultpagesize = (int)pagesize; } FacultyListViewModel f = new FacultyListViewModel(); if (search != null) { if (searchBy == "Department") { f.ipage = l.Where(x => x.department.ToLower().StartsWith(search.ToLower()) || search == null).ToList().ToPagedList(page ?? 1, defaultpagesize); return(View(f)); } else if (searchBy == "Rank") { f.ipage = l.Where(x => x.rank.ToLower().StartsWith(search.ToLower()) || search == null).ToList().ToPagedList(page ?? 1, defaultpagesize); return(View(f)); } else if (searchBy == "Name") { f.ipage = l.Where(x => x.name.ToLower().StartsWith(search.ToLower()) || search == null).ToList().ToPagedList(page ?? 1, defaultpagesize); return(View(f)); } } f.ipage = l.ToList().ToPagedList(page ?? 1, defaultpagesize); return(View(f)); }