public List<String> Faculties() { RankingContext context = new RankingContext(); var f = from b in context.Faculties select b.FacultyName; return f.ToList<String>(); }
public List<String> Programmes(String facultyName) { RankingContext context = new RankingContext(); var f = from b in context.Faculties where b.FacultyName == facultyName select b.ProgrammeName; return f.ToList<String>(); }
public ActionResult Login(LoginModel model, string returnUrl) { String user = model.UserName; String pass = model.Password; if ( ModelState.IsValid && WebSecurity.Login(model.UserName, model.Password, persistCookie: model.RememberMe) && model.UserName == "Admin" ) { RankingContext db = new RankingContext(); if (db.Dates.ToList().Count() == 0) { return RedirectToAction("index", "CampaignRankingDates"); } return RedirectToAction("Menu", "Admin"); } if (ModelState.IsValid && WebSecurity.Login(model.UserName, model.Password, persistCookie: model.RememberMe) ) { string name = model.UserName; string[] roleNames = Roles.GetRolesForUser(name); foreach (string role in roleNames) { if (role.Contains("admin")) { return RedirectToAction("Menu", "Admin"); } } } if (ModelState.IsValid && WebSecurity.Login(model.UserName, model.Password, persistCookie: model.RememberMe)) { RankingContext db = new RankingContext(); QueryManager mng = new QueryManager(db); DateTime end = Convert.ToDateTime(mng.getCampaignDates().FirstRankingDate); if (DateTime.Today > end) { return RedirectToAction("Index", "StudentRankingInformation"); } //return RedirectToLocal(returnUrl); return RedirectToAction("Index", "StudentPreferences"); } // If we got this far, something failed, redisplay form ModelState.AddModelError("", "The user name or password provided is incorrect."); return View(model); }
public QueryManager(RankingContext context) { this.context = context; }
public Ranker(RankingContext context) { this.context = context; queryManager = new QueryManager(context); }
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); }
public ActionResult Index() { RankingContext db = new RankingContext(); QueryManager mng = new QueryManager(db); String user = User.Identity.Name; String s = mng.getCampaignDates().FirstRankingDate; // класиране първи етап - дати DateTime first = Convert.ToDateTime(mng.getCampaignDates().FirstRankingDate); ViewData["isFirstRankingDate"] = false; if (DateTime.Today >= first) { ViewData["isFirstRankingDate"] = true; } ViewData["isFirstRankListPublished"] = false; if (db.Dates.ToList().Last().FirstRankingDate == "true") { ViewData["isFirstRankListPublished"] = true; } // класиране втори етап - дати DateTime second = Convert.ToDateTime(mng.getCampaignDates().SecondRankingDate); ViewData["isSecondRankingDate"] = false; if (DateTime.Today >= second) { ViewData["isSecondRankingDate"] = true; } ViewData["isSecondRankListPublished"] = false; if (db.Dates.ToList().Last().FirstRankingDate == "true") { ViewData["isSecondRankListPublished"] = true; } // класиране трети етап - дати DateTime third = Convert.ToDateTime(mng.getCampaignDates().ThirdRankingDate); ViewData["isThirdRankingDate"] = false; if (DateTime.Today >= third) { ViewData["isThirdRankingDate"] = true; } ViewData["isThirdRankListPublished"] = false; if (db.Dates.ToList().Last().FirstRankingDate == "true") { ViewData["isThirdRankListPublished"] = true; } ViewData["mainAdmin"] = false; if (user == "Admin") { ViewData["mainAdmin"] = true; } ViewData["userName"] = user; List<String> l = programmes.Keys.ToList<string>(); l.Insert(0, "Please Select"); SelectList faculties = new SelectList(l); ViewData["faculties"] = faculties; ViewData["result"] = model; return View(model); }
public ActionResult Index(String faculty, String programmeName) { //генериране на combobox 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 first = Convert.ToDateTime(mng.getCampaignDates().FirstRankingDate); ViewData["isFirstRankingDate"] = false; if (DateTime.Today >= first) { ViewData["isFirstRankingDate"] = true; } ViewData["isFirstRankListPublished"] = false; if (db.Dates.ToList().Last().FirstRankingDate == "true") { ViewData["isFirstRankListPublished"] = true; } // класиране втори етап - дати DateTime second = Convert.ToDateTime(mng.getCampaignDates().SecondRankingDate); ViewData["isSecondRankingDate"] = false; if (DateTime.Today >= second) { ViewData["isSecondRankingDate"] = true; } ViewData["isSecondRankListPublished"] = false; if (db.Dates.ToList().Last().FirstRankingDate == "true") { ViewData["isSecondRankListPublished"] = true; } // класиране трети етап - дати DateTime third = Convert.ToDateTime(mng.getCampaignDates().ThirdRankingDate); ViewData["isThirdRankingDate"] = false; if (DateTime.Today >= third) { ViewData["isThirdRankingDate"] = true; } ViewData["isThirdRankListPublished"] = false; if (db.Dates.ToList().Last().FirstRankingDate == "true") { ViewData["isThirdRankListPublished"] = true; } //вземане на потребителското име на потребителя String user = User.Identity.Name; ViewData["userName"] = user; //проверка кой администратор е влязъл ViewData["mainAdmin"] = false; if (user == "Admin") { ViewData["mainAdmin"] = true; } QueryManager queryManager = new QueryManager(db); List<FacultyRankList> rankList = queryManager.getRankList(programmeName); foreach (var item in rankList) { FacultyRankList rank = new FacultyRankList { ProgrammeName = programmeName, EGN = item.EGN, TotalGrade = item.TotalGrade }; model.Add(rank); } //FacultyRankList f = new FacultyRankList //{ // EGN = "12345678", // ProgrammeName = programmeName, // TotalGrade = 4.5 //}; //model.Add(f); ViewData["result"] = model; return PartialView("_ProgrammeRankListTable", model); }