public ActionResult deleteLastPreference() { QueryManager queryManager = new QueryManager(db); List<Preference> studentPreferences = queryManager.getStudentPreferences(User.Identity.Name); if (studentPreferences.Count() > 0 ) { Preference p = studentPreferences.Last(); db.Preferences.Attach(p); db.Preferences.Remove(p); db.SaveChanges(); } var redirectUrl = new UrlHelper(Request.RequestContext).Action("Index", "StudentPreferences"); return Json(new { Url = redirectUrl }); }
public ActionResult Index() { String user = User.Identity.Name; //user = "******"; ViewData["userName"] = user; List<String> l = programmes.Keys.ToList<string>(); l.Insert(0,"Please Select"); SelectList faculties = new SelectList(l); ViewData["faculties"] = faculties; RankingContext db = new RankingContext(); QueryManager mng = new QueryManager(db); DateTime end = Convert.ToDateTime(mng.getCampaignDates().PreferrencesLastDate); ViewData["isAddingPreferencesEnd"] = false; if (DateTime.Today > end) { ViewData["isAddingPreferencesEnd"] = true; } QueryManager queryManager = new QueryManager(db); List<Preference> studentPreferences = queryManager.getStudentPreferences(user); foreach (var preff in studentPreferences) { Faculty f = db.Faculties.Find(preff.ProgrammeName); String fac = (f != null ) ? f.FacultyName : ""; StudentPreferences pr = new StudentPreferences { Faculty = fac, ProgrammeName = preff.ProgrammeName, PrefNumber = preff.PrefNumber }; model.Add(pr); } ViewData["result"] = model; return View(model); }
public ActionResult Index(String faculty, String programmeName) { String user = User.Identity.Name; ViewData["userName"] = user; RankingContext db = new RankingContext(); QueryManager mng = new QueryManager(db); DateTime finale = Convert.ToDateTime(mng.getCampaignDates().PreferrencesLastDate); ViewData["isAddingPreferencesEnd"] = true; if (DateTime.Today > finale) { ViewData["isAddingPreferencesEnd"] = true; } List<String> l = programmes.Keys.ToList<string>(); l.Insert(0, "Please Select"); SelectList faculties = new SelectList(l); ViewData["faculties"] = faculties; String egn = user; //int lastPreferenceNumber = db.Preferences.Where(t => t.EGN == egn ) // .OrderByDescending(t => t.PrefNumber) // .FirstOrDefault().PrefNumber; QueryManager queryManager = new QueryManager(db); List<Preference> studentPreferences = queryManager.getStudentPreferences(egn); bool isPreferrenceRepeated = false; foreach (var preff in studentPreferences) { String fac = db.Faculties.Find(preff.ProgrammeName).FacultyName; StudentPreferences pr = new StudentPreferences { Faculty = fac, ProgrammeName = preff.ProgrammeName, PrefNumber = preff.PrefNumber }; if (faculty == fac && preff.ProgrammeName == programmeName) { isPreferrenceRepeated = true; } model.Add(pr); } if (!isPreferrenceRepeated) { int nextPrefenceNumber = (studentPreferences.Count() != 0) ? studentPreferences.Max(t => t.PrefNumber) + 1 : 1; StudentPreferences pref = new StudentPreferences { Faculty = faculty, ProgrammeName = programmeName, PrefNumber = nextPrefenceNumber }; Preference p = new Preference { EGN = egn, PrefNumber = nextPrefenceNumber, ProgrammeName = programmeName, TotalGrade = 0 }; db.Preferences.Add(p); db.SaveChanges(); model.Add(pref); } ViewData["result"] = model; return PartialView("_StudentPreferencesTable", model); //return View("Index",model); }