public static void Initialize(PieContext context)
{
context.Database.EnsureCreated();
if (context.Pies.Any())
{
return; // BD a fost creata anterior
}
var pies = new Pie[]
{
new Pie {
Name = "Placinta cu mere", ShortDescription = "Prăjitură simplă cu mere rase călite cu zahăr și scorțișoară și aluat fraged", Price = Decimal.Parse("105")
},
new Pie {
Name = "Cheesecake cu afine", ShortDescription = "Tarta cu blat de biscuiti si crema de mascarpone", Price = Decimal.Parse("118")
},
new Pie {
Name = "Placinta cu gutui", ShortDescription = "Gustul copilariei intr-o placinta frageda cu umplutura de gutui si nuci", Price = Decimal.Parse("135")
},
new Pie {
Name = "Tarta cu lapte condensat si lime", ShortDescription = "O prajitura racoritoare, fara coacere si cu o combinatie de gusutri interesanta", Price = Decimal.Parse("115")
},
new Pie {
Name = "Placinta cu dovleac", ShortDescription = "Dovleacul placintar este ingredintul perfect pentru o placinta cu gust de toamna", Price = Decimal.Parse("100")
},
new Pie {
Name = "Cheesecake cu oreo", ShortDescription = "Indragita atat de cei mici cat si de cei mari", Price = Decimal.Parse("108")
},
new Pie {
Name = "Tarta cu marar", ShortDescription = "Tarta cu marar aduce impreuna gusturile de urda si marar proaspete", Price = Decimal.Parse("113")
},
new Pie {
Name = "Placinta cu varza", ShortDescription = "Aluat pufos umplut cu varza a la Cluj", Price = Decimal.Parse("98")
},
};
foreach (Pie s in pies)
{
context.Pies.Add(s);
}
context.SaveChanges();
var customers = new Customer[]
{
new Customer {
CustomerID = 1050, Name = "Barna Valentina", BirthDate = DateTime.Parse("1998-11-06")
},
new Customer {
CustomerID = 1045, Name = "Barna Ana", BirthDate = DateTime.Parse("1968-08-19")
},
};
foreach (Customer c in customers)
{
context.Customers.Add(c);
}
context.SaveChanges();
var orders = new Order[]
{
new Order {
PieID = 1, CustomerID = 1053, OrderDate = DateTime.Parse("10-28-2020")
},
new Order {
PieID = 3, CustomerID = 1045, OrderDate = DateTime.Parse("11-28-2020")
},
new Order {
PieID = 4, CustomerID = 1045, OrderDate = DateTime.Parse("10-21-2020")
},
new Order {
PieID = 2, CustomerID = 1050, OrderDate = DateTime.Parse("12-10-2020")
},
new Order {
PieID = 6, CustomerID = 1052, OrderDate = DateTime.Parse("06-11-2020")
},
new Order {
PieID = 5, CustomerID = 1052, OrderDate = DateTime.Parse("09-12-2020")
},
};
foreach (Order e in orders)
{
context.Orders.Add(e);
}
context.SaveChanges();
var retailers = new Retailer[]
{
new Retailer {
RetailerName = "Mama Luta", Adress = "Str. Principala, nr. 40, Ampoita"
},
new Retailer {
RetailerName = "CorinaSweets", Adress = "Str. Motilor, nr. 35, Alba-Iulia"
},
new Retailer {
RetailerName = "Byron", Adress = "Str. 1Decembrie, nr. 22, Alba-Iulia"
},
};
foreach (Retailer p in retailers)
{
context.Retailers.Add(p);
}
context.SaveChanges();
var retailedpies = new RetailedPie[]
{
new RetailedPie {
PieID = pies.Single(c => c.Name == "Placinta cu varza").ID,
RetailerID = retailers.Single(i => i.RetailerName ==
"Mama Luta").ID
},
new RetailedPie {
PieID = pies.Single(c => c.Name == "Placinta cu mere").ID,
RetailerID = retailers.Single(i => i.RetailerName ==
"Mama Luta").ID
},
new RetailedPie {
PieID = pies.Single(c => c.Name == "Cheesecake cu oreo").ID,
RetailerID = retailers.Single(i => i.RetailerName ==
"CorinaSweets").ID
},
new RetailedPie {
PieID = pies.Single(c => c.Name == "Cheesecake cu afine").ID,
RetailerID = retailers.Single(i => i.RetailerName == "CorinaSweets").ID
},
new RetailedPie {
PieID = pies.Single(c => c.Name == "Tarta cu lapte condensat si lime").ID,
RetailerID = retailers.Single(i => i.RetailerName == "Byron").ID
},
new RetailedPie {
PieID = pies.Single(c => c.Name == "Placinta cu gutui").ID, RetailerID = retailers.Single(i => i.RetailerName == "Byron").ID
},
new RetailedPie {
PieID = pies.Single(c => c.Name == "Placinta cu dovleac").ID, RetailerID = retailers.Single(i => i.RetailerName == "Byron").ID
},
new RetailedPie {
PieID = pies.Single(c => c.Name == "Tarta cu marar").ID, RetailerID = retailers.Single(i => i.RetailerName == "Mama Luta").ID
},
};
foreach (RetailedPie pb in retailedpies)
{
context.RetailedPies.Add(pb);
}
context.SaveChanges();
}