public ActionResult Inscription() { niveauEducationDataClassesDataContext NE = new niveauEducationDataClassesDataContext(); var listeniveauxEducation = (from niveau in NE.niveauEducations select niveau.nom); ViewBag.liste = listeniveauxEducation; return(View()); }
public ActionResult AllCourses() { niveauEducationDataClassesDataContext bd = new niveauEducationDataClassesDataContext(); var listeCours = (from cours in bd.Cours where cours.niveaueducation == Session["niveau"].ToString() select cours); ViewBag.listeCours = listeCours; return(View()); }
public ActionResult AddCours(string Title, string Education, string Chapters, string Date, string Description, string Image) { niveauEducationDataClassesDataContext db = new niveauEducationDataClassesDataContext(); Cour c1 = new Cour { idprof = Convert.ToInt32(Session["id"]), titre = Title, niveaueducation = Education, chapitres = Chapters, date = Date, description = Description, image = Image }; //fetch IDPROF db.Cours.InsertOnSubmit(c1); db.SubmitChanges(); return(View("AddCourse")); }
public ActionResult Course2(string coursid) { niveauEducationDataClassesDataContext bd = new niveauEducationDataClassesDataContext(); EleveCour e1 = new EleveCour { ideleve = Convert.ToInt32(Session["id"]), idcours = Convert.ToInt32(coursid) }; bd.EleveCours.InsertOnSubmit(e1); bd.SubmitChanges(); var listeCours = (from cours in bd.EleveCours where cours.ideleve == Convert.ToInt32(Session["id"]) select cours.Cour); ViewBag.listeCours = listeCours; return(View("MyCourses")); }
public ActionResult first(string username, string password) { niveauEducationDataClassesDataContext db = new niveauEducationDataClassesDataContext(); var compte = (from cmpt in db.credentials where cmpt.username == Session["username"].ToString() && cmpt.password == Session["password"].ToString() select cmpt); foreach (var cmpt in compte) { cmpt.username = username; cmpt.password = password; cmpt.firsttime = 0; db.SubmitChanges(); } return(View("accueil")); }
public ActionResult Course(string titre) { niveauEducationDataClassesDataContext bd = new niveauEducationDataClassesDataContext(); var coursActif = (from cours in bd.Cours where cours.Id == Convert.ToInt32(titre) select cours); ViewBag.cours = coursActif; CoursContenu c1 = new CoursContenu(); c1.Id = coursActif.ToList().ElementAt(0).Id; //.ElementAt(0).Id; c1.titre = coursActif.ToList().ElementAt(0).titre; c1.date = coursActif.ToList().ElementAt(0).date; c1.image = coursActif.ToList().ElementAt(0).image; c1.niveaueducation = coursActif.ToList().ElementAt(0).niveaueducation; c1.chapitres = coursActif.ToList().ElementAt(0).chapitres; c1.description = coursActif.ToList().ElementAt(0).description; string[] chaps = c1.chapitres.Split(','); ViewBag.chapitres = chaps; return(View(c1)); }
public ActionResult login(string username, string pwd) { niveauEducationDataClassesDataContext db = new niveauEducationDataClassesDataContext(); var compteSTD = (from cmpt in db.credentials where cmpt.username == username && cmpt.password == pwd select cmpt); int countSTD = compteSTD.Count(); var comptePROF = (from cmpt in db.profs where cmpt.username == username && cmpt.password == pwd select cmpt); int countPROF = comptePROF.Count(); //trouver le niveau deducation de eleve var niveau = (from cmpt in db.Inscriptions where cmpt.email == compteSTD.ToList().ElementAt(0).email select cmpt); if (countSTD == 1) { int first = 1; foreach (var elem in compteSTD) { first = elem.firsttime; } if (first == 1) { Session["id"] = compteSTD.ToList().ElementAt(0).Id; Session["username"] = username; Session["password"] = pwd; Session["email"] = compteSTD.ToList().ElementAt(0).email; Session["niveau"] = niveau.ToList().ElementAt(0).education; return(View("first")); } else { Session["id"] = compteSTD.ToList().ElementAt(0).Id; Session["username"] = username; Session["password"] = pwd; Session["email"] = compteSTD.ToList().ElementAt(0).email; Session["niveau"] = niveau.ToList().ElementAt(0).education; return(View("accueil")); } } else if (countPROF == 1) { Session["id"] = comptePROF.ToList().ElementAt(0).Id; Session["username"] = username; Session["password"] = pwd; return(RedirectToAction("accueil", "Teacher")); } else { ViewBag.msg = "Username or Password incorrect"; return(View("login")); } }