public ActionResult Grades() { int User; LoginController Log = new LoginController(); Log.wyciaganie_ID(out User); if (TempData.ContainsKey("Informacja")) { ViewBag.Informacja = TempData["Informacja"]; } else if (TempData.ContainsKey("Brak_Danych")) { ViewBag.Informacja = TempData["Brak_Danych"]; } else if ((TempData.ContainsKey("Brak_Danych")) && TempData.ContainsKey("Informacja")) { ViewBag.Informacja = TempData["Informacja"]; } SzkolaEntities db = new SzkolaEntities(); Grades Grades = new Grades(); var Zmienna = (from table1 in db.Teacher join table2 in db.School_Class on table1.ClassID equals table2.ClassID where User == table1.UserID select new Grades { ClassID = table2.ClassID, Nazwa_Klasy = table2.Nazwa, TeacherID = table1.TeacherID, Przedmiot = table1.Przedmiot }).Distinct().ToList(); return(View("~/Views/Teacher/Grades.cshtml", "~/Views/Main_Layout.cshtml", Zmienna)); }
public JsonResult GetEvents() { using (SzkolaEntities School = new SzkolaEntities()) { School.Configuration.LazyLoadingEnabled = false; LoginController Log = new LoginController(); int ID; Log.wyciaganie_ID(out ID); var result = (from n in School.Student where n.UserID == ID select n.ClassID).Single(); var result2 = Convert.ToInt32(result); var events = School.Events.ToList().Where(xx => xx.ClassID == result2); return(new JsonResult { Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }