public IEnumerable<Restaurants> GetAllRestaurant()
{
using (var model = new RestoBookEntities())
{
var result = from restaurant in model.Restaurants
from cuisine in restaurant.TypeCuisine
join addr in model.Adresse on restaurant.Id_Restaurant equals addr.RestaurantsId
join ville in model.Ville on addr.VilleId equals ville.Id_Ville
select new
{
Id = restaurant.Id_Restaurant,
Nom = restaurant.lb_nom.Trim(),
Active = restaurant.isActive,
Rue = addr.lb_rue.Trim(),
CP = addr.lb_codepostal.Trim(),
Ville = ville.lb_ville.Trim(),
Cuisine = cuisine.lb_cuisne.Trim()
};
var gpResult = from gpRestaurant in result.AsEnumerable()
group gpRestaurant by gpRestaurant.Nom into gp
select new Restaurants()
{
Id = gp.Select(s=>s.Id).FirstOrDefault(),
Nom = gp.Select(s => s.Nom).FirstOrDefault(),
Active = gp.Select(s => s.Active).FirstOrDefault(),
Rue = gp.Select(s => s.Rue).FirstOrDefault(),
CP = gp.Select(s => s.CP).FirstOrDefault(),
Ville = gp.Select(s => s.Ville).FirstOrDefault(),
Cuisine = String.Join(",", gp.Select(s => s.Cuisine))
};
return gpResult.ToList();
}
}
public static void Update(InfoRestaurant lstInfoRestaurant,byte[] img,string name)
{
using (var model = new RestoBookEntities())
{
var image = new Picture();
var restaurants = model.Restaurants.Find(lstInfoRestaurant.Id);
var addresse = model.Adresse.Find(restaurants.Id_Restaurant);
addresse.lb_codepostal = lstInfoRestaurant.Cp;
addresse.lb_rue = lstInfoRestaurant.Rue;
restaurants.lb_nom = lstInfoRestaurant.Nom;
restaurants.isActive = lstInfoRestaurant.Active;
image.lb_Name = name;
image.lb_Picure = img;
restaurants.Picture.Add(image);
restaurants.Adresse.Add(addresse);
model.Entry(restaurants).State = System.Data.Entity.EntityState.Modified;
model.SaveChanges();
}
}