private bool validation() { if (degreeTextField.Text.Equals("") || StatusText.Text.Equals("") || FirstLanguage.Text.Equals("") || CountryOrigin.Equals("")) { AppParam.Instance.showAlertMessage("Validation", "Please fill in required fields"); return(false); } return(true); }
//Метод загрузки данных с отношениям связей Многие-ко-Многим ef 5.0 **Пример** //https://metanit.com/sharp/entityframeworkcore/3.6.php #region public void addAllDish_ef_5_0() { using (ApplicationDbContext db = new ApplicationDbContext()) { Category category1 = new Category { Name = "Напитки" }; Category category2 = new Category { Name = "Закуски" }; db.Categories.AddRange(category1, category2); CountryOrigin countryOrigin = new CountryOrigin { Name = "Европейская" }; db.CountryOrigins.AddRange(countryOrigin); Ingredient_ef_5_0 ingredient1 = new Ingredient_ef_5_0 { Name_ef_5_0 = "вода" }; Ingredient_ef_5_0 ingredient2 = new Ingredient_ef_5_0 { Name_ef_5_0 = "сахар" }; Ingredient_ef_5_0 ingredient3 = new Ingredient_ef_5_0 { Name_ef_5_0 = "морква" }; Ingredient_ef_5_0 ingredient4 = new Ingredient_ef_5_0 { Name_ef_5_0 = "Лимон" }; Ingredient_ef_5_0 ingredient5 = new Ingredient_ef_5_0 { Name_ef_5_0 = "капуста" }; db.Ingredients_ef_5_0.AddRange(ingredient1, ingredient2, ingredient3, ingredient4, ingredient5); Dish_ef_5_0 dish1 = new Dish_ef_5_0 { Name = "Limonad", Category = category1, CountryOrigin = countryOrigin, Calories = 330, Weight = 500, Remain = 100 }; Dish_ef_5_0 dish2 = new Dish_ef_5_0 { Name = "Салат", Category = category2, CountryOrigin = countryOrigin, Calories = 730, Weight = 200, Remain = 14 }; Dish_ef_5_0 dish3 = new Dish_ef_5_0 { Name = "Газировка", Category = category2, CountryOrigin = countryOrigin, Calories = 730, Weight = 200, Remain = 14 }; db.Dishes_ef_5_0.AddRange(dish1, dish2, dish3); //первый вариант добавления данных работает только при модели мани то мани ef 5.0 ingredient1.Dishes_ef_5_0.Add(dish3); //Второй вариант добавления данных работает в мододелях мани то мани ef 5.0 и ef 3.0 ingredient1.DishIngredients_ef_5_0.Add(new DishIngredient_ef_5_0 { Dish_ef_5_0 = dish1, Ingredient_ef_5_0 = ingredient1, quantityIngredient_ef_5_0 = 250, DishIngredientDate_ef_5_0 = DateTime.Now }); ingredient2.DishIngredients_ef_5_0.Add(new DishIngredient_ef_5_0 { Dish_ef_5_0 = dish1, Ingredient_ef_5_0 = ingredient2, quantityIngredient_ef_5_0 = 50, DishIngredientDate_ef_5_0 = DateTime.Now }); ingredient4.DishIngredients_ef_5_0.Add(new DishIngredient_ef_5_0 { Dish_ef_5_0 = dish1, Ingredient_ef_5_0 = ingredient4, quantityIngredient_ef_5_0 = 10, DishIngredientDate_ef_5_0 = DateTime.Now }); ingredient2.DishIngredients_ef_5_0.Add(new DishIngredient_ef_5_0 { Dish_ef_5_0 = dish2, Ingredient_ef_5_0 = ingredient2, quantityIngredient_ef_5_0 = 10, DishIngredientDate_ef_5_0 = DateTime.Now }); ingredient3.DishIngredients_ef_5_0.Add(new DishIngredient_ef_5_0 { Dish_ef_5_0 = dish2, Ingredient_ef_5_0 = ingredient3, quantityIngredient_ef_5_0 = 250, DishIngredientDate_ef_5_0 = DateTime.Now }); ingredient4.DishIngredients_ef_5_0.Add(new DishIngredient_ef_5_0 { Dish_ef_5_0 = dish2, Ingredient_ef_5_0 = ingredient4, quantityIngredient_ef_5_0 = 90, DishIngredientDate_ef_5_0 = DateTime.Now }); ingredient5.DishIngredients_ef_5_0.Add(new DishIngredient_ef_5_0 { Dish_ef_5_0 = dish2, Ingredient_ef_5_0 = ingredient5, quantityIngredient_ef_5_0 = 80, DishIngredientDate_ef_5_0 = DateTime.Now }); db.SaveChanges(); Console.WriteLine("!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! addDish"); } }
//Метод загрузки данных с отношениям связей Многие-ко-Многим ef 3.0 **Пример** //https://metanit.com/sharp/entityframeworkcore/3.6.php #region public void addAllDish() { using (ApplicationDbContext db = new ApplicationDbContext()) { Category category1 = new Category { Name = "Напитки" }; Category category2 = new Category { Name = "Закуски" }; db.Categories.AddRange(category1, category2); CountryOrigin countryOrigin = new CountryOrigin { Name = "Европейская" }; db.CountryOrigins.AddRange(countryOrigin); Ingredient ingredient1 = new Ingredient { Name = "вода" }; Ingredient ingredient2 = new Ingredient { Name = "сахар" }; Ingredient ingredient3 = new Ingredient { Name = "морква" }; Ingredient ingredient4 = new Ingredient { Name = "Лимон" }; Ingredient ingredient5 = new Ingredient { Name = "капуста" }; db.Ingredients.AddRange(ingredient1, ingredient2, ingredient3, ingredient4, ingredient5); Dish dish1 = new Dish { Name = "Чай", Category = category1, CountryOrigin = countryOrigin, Calories = 330, Weight = 500, Remain = 100 }; Dish dish2 = new Dish { Name = "Салат", Category = category2, CountryOrigin = countryOrigin, Calories = 730, Weight = 200, Remain = 14 }; Dish dish3 = new Dish { Name = "Лимонад", Category = category2, CountryOrigin = countryOrigin, Calories = 730, Weight = 200, Remain = 14 }; db.Dishes.AddRange(dish1, dish2, dish3); ingredient1.DishIngredients.Add(new DishIngredient { Dish = dish3, Ingredient = ingredient1, quantityIngredient = 250, DishIngredientDate = DateTime.Now }); ingredient1.DishIngredients.Add(new DishIngredient { Dish = dish1, quantityIngredient = 250, DishIngredientDate = DateTime.Now }); ingredient2.DishIngredients.Add(new DishIngredient { Dish = dish1, quantityIngredient = 50, DishIngredientDate = DateTime.Now }); ingredient4.DishIngredients.Add(new DishIngredient { Dish = dish1, quantityIngredient = 10, DishIngredientDate = DateTime.Now }); ingredient2.DishIngredients.Add(new DishIngredient { Dish = dish2, quantityIngredient = 10, DishIngredientDate = DateTime.Now }); ingredient3.DishIngredients.Add(new DishIngredient { Dish = dish2, quantityIngredient = 250, DishIngredientDate = DateTime.Now }); ingredient4.DishIngredients.Add(new DishIngredient { Dish = dish2, quantityIngredient = 90, DishIngredientDate = DateTime.Now }); ingredient5.DishIngredients.Add(new DishIngredient { Dish = dish2, quantityIngredient = 80, DishIngredientDate = DateTime.Now }); db.SaveChanges(); Console.WriteLine("!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! addDish"); } }