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"));
}
}
