public void CreerRestaurant(Restaurant r)
{
using (var ctx = new SoireeContext())
{
ctx.Restaurants.Add(r);
ctx.SaveChanges();
}
}
public void AjouterEtudiant(Eleve e)
{
using (var ctx = new SoireeContext())
{
e.Password = Crypto.HashPassword(e.Password);
ctx.Eleves.Add(e);
ctx.SaveChanges();
}
}
public Restaurant RenvoieRestaurant(int idRestaurant)
{
Restaurant r = new Restaurant();
using (var ctx = new SoireeContext())
{
r = ctx.Restaurants.FirstOrDefault(c => c.Id == idRestaurant);
}
return(r);
}
public IList <Sondage> RenvoieTousLesSondages()
{
List <Sondage> s = new List <Sondage>();
using (var ctx = new SoireeContext())
{
foreach (var sondage in ctx.Sondages)
{
s.Add(sondage);
}
}
return(s);
}
public IList <Restaurant> RenvoieTousLesRestaurants()
{
List <Restaurant> r = new List <Restaurant>();
using (var ctx = new SoireeContext())
{
foreach (var resto in ctx.Restaurants)
{
r.Add(resto);
}
}
return(r);
}
public bool EleveExist(string nom, int id)
{
using (var ctx = new SoireeContext())
{
var result = ctx.Eleves.Count(c => c.Nom == nom & c.Id != id);
if (result != 0)
{
return(true);
}
else
{
return(false);
}
}
}
public bool RestaurantExist(string nom)
{
using (var ctx = new SoireeContext())
{
var result = ctx.Restaurants.Count(c => c.Nom == nom);
if (result != 0)
{
return(true);
}
else
{
return(false);
}
}
}
public Dal()
{
s = new SoireeContext();
}
