public IHttpActionResult PutRestaurant(RestaurantsModify restaurantsMod) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (!db.Restaurants.Any(x => x.IdRestaurant == restaurantsMod.IdRestaurant)) { return(BadRequest()); } int cuisineTypeId = db.CuisineTypes.Where(x => x.Name == restaurantsMod.CuisineType).First().IdCuisine; RestaurantsObj restoModify = db.Restaurants.Where(x => x.IdRestaurant == restaurantsMod.IdRestaurant).First(); restoModify.Name = restaurantsMod.Name; restoModify.Adress = restaurantsMod.Adress; restoModify.PostalCode = restaurantsMod.PostalCode; restoModify.Phone = restaurantsMod.Phone; restoModify.IdCuisine = cuisineTypeId; restoModify.urlThumbnail = restaurantsMod.urlThumbnail; restoModify.City = restaurantsMod.City; db.SaveChanges(); RestaurantsObj finalResto = db.Restaurants.Where(x => x.IdRestaurant == restaurantsMod.IdRestaurant).First(); return(Ok(TransformObject.TransformRestoObjIntoRestoViewDetails(finalResto, db))); }
public IHttpActionResult DeleteRestaurant(int id) { RestaurantsObj restaurantsObj = db.Restaurants.Find(id); if (restaurantsObj == null) { return(NotFound()); } db.Restaurants.Remove(restaurantsObj); List <ImagesObj> imagesDel = db.Images.Where(x => x.IdRestaurant == id).ToList(); foreach (var item in imagesDel) { db.Images.Remove(item); } List <DishesObj> dishesDel = db.Dishes.Where(x => x.IdRestaurant == id).ToList(); foreach (var item in dishesDel) { db.Dishes.Remove(item); } db.SaveChanges(); return(Ok(restaurantsObj)); }
public IHttpActionResult PostRestaurant(RestaurantsCreate restaurantsC) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } int nb = 0; nb = db.CuisineTypes.Where(x => x.Name == restaurantsC.CuisineType).Count(); if (nb == 0) { CuisineTypeObj newCui = new CuisineTypeObj { Name = restaurantsC.CuisineType }; db.CuisineTypes.Add(newCui); db.SaveChanges(); } int idCuisineType = db.CuisineTypes.Where(x => x.Name == restaurantsC.CuisineType).First().IdCuisine; RestaurantsObj newResto = new RestaurantsObj { Adress = restaurantsC.Adress, City = restaurantsC.City, IdCuisine = idCuisineType, Name = restaurantsC.Name, Phone = restaurantsC.Phone, PostalCode = restaurantsC.PostalCode, Rating = 10, urlThumbnail = restaurantsC.urlThumbnail }; db.Restaurants.Add(newResto); db.SaveChanges(); int idresto = db.Restaurants.Where(x => x.Name == restaurantsC.Name).First().IdRestaurant; foreach (var item in restaurantsC.Plats) { DishesObj dishe = new DishesObj { Name = item.Name, Price = item.Price, Pde = "a", IdRestaurant = idresto }; db.Dishes.Add(dishe); db.SaveChanges(); } return(Ok(TransformObject.TransformRestoObjIntoRestoViewDetails(newResto, db))); }
public static void ratingAvg(int id, FeedMeContext context) { List <RatingsObj> ratingList = context.Ratings.Where(x => x.RestaurantId == id).ToList(); double result = 0; foreach (var item in ratingList) { result += item.Note; } result = result / ratingList.Count(); RestaurantsObj restoMaj = context.Restaurants.Where(x => x.IdRestaurant == id).First(); restoMaj.Rating = result; context.SaveChanges(); }
public static RestaurantsModify TransformRestoObjIntoRestoModify(RestaurantsObj resto, FeedMeContext context) { string cuisineTypeName = context.CuisineTypes.Where(x => x.IdCuisine == resto.IdCuisine).First().Name; RestaurantsModify restoMod = new RestaurantsModify { Adress = resto.Adress, City = resto.City, CuisineType = cuisineTypeName, IdRestaurant = resto.IdRestaurant, Name = resto.Name, Phone = resto.Phone, PostalCode = resto.PostalCode, urlThumbnail = resto.urlThumbnail }; return(restoMod); }
public IHttpActionResult GetRestaurantsModify(int?id = -1) { if (id == null) { return(NotFound()); } if (id == -1 || !db.Restaurants.Any(x => x.IdRestaurant == id)) { return(NotFound()); } RestaurantsObj resto = db.Restaurants.Where(x => x.IdRestaurant == id).First(); if (resto.Equals(null)) { return(NotFound()); } RestaurantsModify restoMod = TransformObject.TransformRestoObjIntoRestoModify(resto, db); return(Ok(restoMod)); }
public static RestaurantsViewDetails TransformRestoObjIntoRestoViewDetails(RestaurantsObj resto, FeedMeContext context) { RestaurantsView restoV = TransformRestoObjIntoRestoView(resto, context); List <ImagesObj> imgList = context.Images.Where(x => x.IdRestaurant == resto.IdRestaurant).ToList(); List <DishesObj> dishesList = context.Dishes.Where(x => x.IdRestaurant == resto.IdRestaurant).ToList(); RestaurantsViewDetails restoD = new RestaurantsViewDetails { Adress = restoV.Adress, City = restoV.City, CuisineType = restoV.CuisineType, IdRestaurant = restoV.IdRestaurant, Name = restoV.Name, Phone = restoV.Phone, PostalCode = restoV.PostalCode, Rating = restoV.Rating, urlThumbnail = restoV.urlThumbnail, Images = imgList, Dishes = dishesList }; return(restoD); }
public RestaurantsViewDetails GetRestaurantDetails(int id) { RestaurantsObj resto = db.Restaurants.Where(x => x.IdRestaurant == id).First(); return(TransformObject.TransformRestoObjIntoRestoViewDetails(resto, db)); }