public ActionResult Index(string user, string pass)
{
context = new DataClassAdminDataContext();
contextStudent = new DataClasses1DataContext();
IList <Cours> uneListe = new List <Cours>();
var etudiantQuery = (from x in contextStudent.etudiants where x.Id == user select x.education).Single();
var query = from c in context.Cours
where c.Prerequis == etudiantQuery
select c;
var querryRez = query.ToList();
foreach (var data in querryRez)
{
uneListe.Add(new Cours()
{
Nom = data.Nom,
Description = data.Description,
Prerequis = data.Prerequis,
NbModules = data.NbModules,
Content = data.Content
});
}
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
if (user != null && user != "")
{
if (pass != null && pass != "")
{
var res = (from m in db.connections where m.user == user && m.password == pass select m).Count();
if (res == 1)
{
return(View("~/Views/Home/CoursStudent.cshtml", uneListe));//"nom de la view");
}
else
{
ViewBag.login = "******";
}
}
else
{
ViewBag.login = "******";
}
}
else
{
ViewBag.login = "******";
}
return(View());
}
}
/// <summary>
/// The HomeController() function is used to create a new instance of the Database
/// context variable is a simple access to its data.
/// </summary>
public HomeController()
{
context = new DataClassAdminDataContext();
contextStudent = new DataClasses1DataContext();
}
