public static void MeilleuresRecettes(List <BestRecipes> thelast, int limit = 4) { NgCookingXEntities1 db = new NgCookingXEntities1(); /*List<Recettes> derniere = db.Recettes.OrderByDescending(c => c.id).Take(limit).ToList(); * * 2eme possibilité pour vérifier le bon fonctionnement ( classement par ordre alphabétique)*/ List <Recettes> BestRate = db.Recettes.OrderBy(c => c.id).Take(limit).ToList(); foreach (var rec in BestRate) { if (rec.Comment.Count > 0) { thelast.Add(new BestRecipes { bestRecette = rec, rate = (decimal)rec.Comment.Average(r => r.mark) }); } else { thelast.Add(new BestRecipes { bestRecette = rec, rate = 0 }); } } }
public static void DernieresRecettes(List <BestRecipes> recettes, int limit = 4) { NgCookingXEntities1 db = new NgCookingXEntities1(); List <Recettes> BestRate = db.Recettes.OrderByDescending(c => c.Comment.Average(r => r.mark)).Take(limit).ToList(); foreach (var rec in BestRate) { if (rec.Comment.Count > 0) { recettes.Add(new BestRecipes { bestRecette = rec, rate = (decimal)rec.Comment.Average(r => r.mark) }); } else { recettes.Add(new BestRecipes { bestRecette = rec, rate = 0 }); } } }
public static void seeding() { var db = new NgCookingXEntities1(); string json = ""; using (StreamReader r = new StreamReader(@"C:\Users\C17 Developer\Documents\XavierProject\NgCooking\NgCooking\App_Data\Json\categories.json")) { json = r.ReadToEnd(); dynamic array = JsonConvert.DeserializeObject(json); foreach (dynamic item in array) { var Cat = new Categories { id = item.id, name = item.nameToDisplay, }; db.Categories.Add(Cat); } } using (StreamReader r = new StreamReader(@"C:\Users\C17 Developer\Documents\XavierProject\NgCooking\NgCooking\App_Data\Json\communaute.json")) { json = r.ReadToEnd(); List <Communaute> ListUser = JsonConvert.DeserializeObject <List <Communaute> >(json); foreach (var Commu in ListUser) { db.Communaute.Add(Commu); } } using (StreamReader r = new StreamReader(@"C:\Users\C17 Developer\Documents\XavierProject\NgCooking\NgCooking\App_Data\Json\ingredients.json")) { json = r.ReadToEnd(); List <Ingredient> ListIng = JsonConvert.DeserializeObject <List <Ingredient> >(json); foreach (var Ing in ListIng) { db.Ingredient.Add(Ing); } //dynamic array = JsonConvert.DeserializeObject(json); //foreach (dynamic item in array) //{ // var Ing = new Ingredient(); // Ing.id = item.id; // Ing.name = item.name; // Ing.isAvailable = item.isAvailable; // Ing.picture = item.picture; // Ing.category = item.category.Value; // Ing.calories = item.calories; // db.Ingredient.Add(Ing); //} } using (StreamReader r = new StreamReader(@"C:\Users\C17 Developer\Documents\XavierProject\NgCooking\NgCooking\App_Data\Json\recettes.json")) { json = r.ReadToEnd(); List <Recettes> ListRecipes = JsonConvert.DeserializeObject <List <Recettes> >(json); foreach (var Recip in ListRecipes) { db.Recettes.Add(Recip); } } db.SaveChanges(); //} //using (StreamReader r = new StreamReader(@"C:\Users\C17 Developer\Documents\XavierProject\NgCooking\NgCooking\App_Data\Json\recettes.json")) //{ // json = r.ReadToEnd(); // dynamic array = JsonConvert.DeserializeObject(json); // foreach (dynamic item in array) // { // var com = new Comment // { // comment1 = item.comment, // userID = item.userId, // recipeId = item.id, // title = item.title, // mark = (int)item.mark // }; // db.Comment.Add(com); // } //db.SaveChanges(); }