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");
}
}
