public static void Initialize(FoodOrderDbContext context)
{
/*
* Adatbázis létrehozása, amennyiben false létezik. A változásokat false kezeli. Ha változtattunk az
* adatbázis modelljén (a code-first osztályainkon), akkor az adatbázist törölni kell, hogy itt
* újra létrejöhessen a frissített szerkezettel.
* Törléshez az Sql Server Object Explorer ablak használható a Visual Studioban.
* Itt SQL Server > localdb > databases, vagy valami hasonló útvonalon találjuk az adatbázisainkat.
*/
context.Database.EnsureCreated( );
if (context.Categories.Any( ))
{
return; // Az adatbázis már inicializálva van.
}
IList <Category> defaultCategories = new List <Category>
{
new Category()
{
Name = "Levesek",
Items = new List <DrinkOrDish>()
{
new DrinkOrDish()
{
Name = "Gulyásleves",
Description = "Soup made with beef",
Price = 1000,
Spicy = true,
Vegetarian = false,
Fame = 0
},
new DrinkOrDish()
{
Name = "Brokkoli krémleves",
Description = "Soup made with broccoli",
Price = 500,
Spicy = false,
Vegetarian = true,
Fame = 0
},
new DrinkOrDish()
{
Name = "Jókai bableves",
Description = "Soup made with bean",
Price = 750,
Spicy = false,
Vegetarian = false,
Fame = 0
}
}
},
new Category()
{
Name = "Főételek",
Items = new List <DrinkOrDish>()
{
new DrinkOrDish()
{
Name = "Hortobágyi palacsinta",
Description = "Pancakes with meat",
Price = 1250,
Spicy = false,
Vegetarian = false,
Fame = 0
},
new DrinkOrDish()
{
Name = "Szilvás gombóc",
Description = "Sweet pastry with plum",
Price = 1000,
Spicy = false,
Vegetarian = true,
Fame = 0
},
new DrinkOrDish()
{
Name = "Spenótfőzelék",
Description = "Spinach with eggs",
Price = 800,
Spicy = false,
Vegetarian = true,
Fame = 0
}
}
},
new Category()
{
Name = "Pizzák",
Items = new List <DrinkOrDish>()
{
new DrinkOrDish()
{
Name = "Mozzarella caprese",
Description = "Pizza with mozzarella",
Price = 1250,
Spicy = false,
Vegetarian = true,
Fame = 0
},
new DrinkOrDish()
{
Name = "Húsimádó",
Description = "Pizza with 4 type of meat",
Price = 1000,
Spicy = false,
Vegetarian = false,
Fame = 0
},
new DrinkOrDish()
{
Name = "Csípős SonGoKu",
Description = "Spicy pizza with corn and mushroom",
Price = 800,
Spicy = true,
Vegetarian = false,
Fame = 0
}
}
},
new Category()
{
Name = "Italok",
Items = new List <DrinkOrDish>()
{
new DrinkOrDish()
{
Name = "Jalapeño Margarita",
Description = "A 'hot' beverage",
Price = 1250,
Spicy = true,
Vegetarian = true,
Fame = 0
},
new DrinkOrDish()
{
Name = "Blonde Manhattan",
Description = "Taliesin's favourite",
Price = 1000,
Spicy = false,
Vegetarian = true,
Fame = 0
},
new DrinkOrDish()
{
Name = "Fanta",
Description = "The old fashioned non-alcoholic drink",
Price = 350,
Spicy = false,
Vegetarian = true,
Fame = 0
}
}
}
};
foreach (Category list in defaultCategories)
{
context.Categories.Add(list);
}
context.SaveChanges( );
}
public FoodOrderRepository(FoodOrderDbContext dbContext)
{
_dbContext = dbContext;
}
