public FacultiesViewModel GetFacultiesViewModel(int?uniId) { var model = new FacultiesViewModel(); using (var db = new ErasmusDbContext()) { model.Faculties = db.Faculties.Where(x => x.UniversityId == uniId).ToList().Select(x => new FacultyView() { Name = x.Name, Id = x.Id, UniversityName = x.University == null ? "Not assigned" : x.University.Name }).ToList(); } return(model); }
public ActionResult Faculties() { FacultiesViewModel model = _adminBusinessLogic.GetFacultiesViewModel(); return(View(model)); }
public ActionResult Index(int?flag) { string pathFile = @"~/App_Data/Manual.txt"; var fileContents = System.IO.File.ReadAllText(System.Web.HttpContext.Current.Server.MapPath(pathFile)); ViewBag.Manual = fileContents; if (flag.HasValue) { ViewBag.LinkToOther = (flag.Value == 1 ? "Student" : "Faculty"); } else { ViewBag.LinkToOther = "Faculty"; } AddFields(); var ReturnModel = new FacultiesViewModel(); var facultiesFiltered = db.Faculties.Where(f => f.Display.HasValue && f.Display.Value && ((f.FacultyApplicationDate.HasValue && EntityFunctions.TruncateTime(f.FacultyApplicationDate.Value) >= EntityFunctions.TruncateTime(DateTime.Now)) || (f.StudentApplicationDate.HasValue && EntityFunctions.TruncateTime(f.StudentApplicationDate.Value) >= EntityFunctions.TruncateTime(DateTime.Now)))).ToList(); if (flag.HasValue) { if (!String.IsNullOrEmpty(ViewBag.LinkToOther.ToString()) && ViewBag.LinkToOther.ToString().Equals("Student")) { ViewBag.ColorF = "lightblue"; var facultiesTeachersFiltered = facultiesFiltered.Where(f => (f.IsFeatured.HasValue && f.IsFeatured.Value) && f.FacultyPlacesAvailable.HasValue && f.FacultyPlacesAvailable.Value > 0 && f.FacultyApplicationDate.HasValue && f.FacultyApplicationDate.Value.Year >= DateTime.Now.Year && f.FacultyApplicationDate.Value.Month >= DateTime.Now.Month && f.FacultyApplicationDate.Value.Day >= DateTime.Now.Day && f.FacultyEnrollmentDate.HasValue).ToList().OrderBy(l => l.FacultyApplicationDate.Value).Take(10); if (facultiesTeachersFiltered.ToList().Count < 10) { var facultiesTeachersFilteredNotFeatured = facultiesFiltered.Where(f => (!f.IsFeatured.HasValue || (f.IsFeatured.HasValue && !f.IsFeatured.Value)) && f.FacultyPlacesAvailable.HasValue && f.FacultyPlacesAvailable.Value > 0 && f.FacultyApplicationDate.HasValue && f.FacultyApplicationDate.Value.Year >= DateTime.Now.Year && f.FacultyApplicationDate.Value.Month >= DateTime.Now.Month && f.FacultyApplicationDate.Value.Day >= DateTime.Now.Day && f.FacultyEnrollmentDate.HasValue).ToList().OrderBy(l => l.FacultyApplicationDate.Value).Take(10 - facultiesTeachersFiltered.ToList().Count); facultiesTeachersFiltered = facultiesTeachersFiltered.Concat(facultiesTeachersFilteredNotFeatured); } foreach (var fax in facultiesTeachersFiltered) { fax.CoursesString = string.Join(", ", fax.Courses.Select(x => x.SubjectObj.Name)); } ReturnModel.TeacherPlaces = new List <Faculty>(facultiesTeachersFiltered); return(View(ReturnModel)); } } ViewBag.ColorS = "lightblue"; var facultiesFilteredFinal = facultiesFiltered.Where(f => (f.IsFeatured.HasValue && f.IsFeatured.Value) && f.StudentPlacesAvailable.HasValue && f.StudentPlacesAvailable.Value > 0 && f.StudentApplicationDate.HasValue && f.StudentApplicationDate.Value.Year >= DateTime.Now.Year && f.StudentApplicationDate.Value.Month >= DateTime.Now.Month && f.StudentApplicationDate.Value.Day >= DateTime.Now.Day && f.StudentEnrollmentDate.HasValue).ToList().OrderBy(l => l.StudentApplicationDate.Value).Take(10); if (facultiesFilteredFinal.ToList().Count < 10) { var facultiesStudentsFilteredNotFeatured = facultiesFiltered.Where(f => (!f.IsFeatured.HasValue || (f.IsFeatured.HasValue && !f.IsFeatured.Value)) && f.StudentPlacesAvailable.HasValue && f.StudentPlacesAvailable.Value > 0 && f.StudentApplicationDate.HasValue && f.StudentApplicationDate.Value.Year >= DateTime.Now.Year && f.StudentApplicationDate.Value.Month >= DateTime.Now.Month && f.StudentApplicationDate.Value.Day >= DateTime.Now.Day && f.StudentEnrollmentDate.HasValue).ToList().OrderBy(l => l.StudentApplicationDate.Value).Take(10 - facultiesFilteredFinal.ToList().Count); facultiesFilteredFinal = facultiesFilteredFinal.Concat(facultiesStudentsFilteredNotFeatured); } ReturnModel.StudentsPlaces = new List <Faculty>(facultiesFilteredFinal); return(View(ReturnModel)); }
public ActionResult Faculties() { FacultiesViewModel model = _uniAdminBusinessLogic.GetFacultiesViewModel(User.Identity.GetUserUniversityId().ToIntNullable()); return(View(model)); }