public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new DrinkUpContext(
serviceProvider.GetRequiredService <
DbContextOptions <DrinkUpContext> >()))
{
// Look for any coffee.
if (context.Coffee.Any())
{
return; // DB has been seeded
}
context.Coffee.AddRange(
new Coffee
{
CoffeeName = "Caffe Americano",
Description = "Espresso shots topped with hot water create a light layer of crema culminating in this wonderfully rich cup with depth and nuance.",
CoffeeType = "Hot Coffee",
Caffiene = true
},
new Coffee
{
CoffeeName = "Blonde Roast",
Description = "Lightly roasted coffee that's soft, mellow and flavorful. Easy-drinking on its own and delicious with milk, sugar or flavored with vanilla, caramel or hazelnut.",
CoffeeType = "Hot Coffee",
Caffiene = true
},
new Coffee
{
CoffeeName = "Blonde Roast",
Description = "Lightly roasted coffee that's soft, mellow and flavorful. Easy-drinking on its own and delicious with milk, sugar or flavored with vanilla, caramel or hazelnut.",
CoffeeType = "Hot Coffee",
Caffiene = true
}
);
context.SaveChanges();
}
}
public HomeController(DrinkUpContext context)
{
_context = context;
}
public TeaTagsLinksController(DrinkUpContext context)
{
_context = context;
}
public TeaStoreLinksController(DrinkUpContext context)
{
_context = context;
}
public PopsController(DrinkUpContext context)
{
_context = context;
}
public CoffeesController(DrinkUpContext context)
{
_context = context;
}
public TeasController(DrinkUpContext context)
{
_context = context;
}
public TeaIngredientsController(DrinkUpContext context)
{
_context = context;
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new DrinkUpContext(
serviceProvider.GetRequiredService <
DbContextOptions <DrinkUpContext> >()))
{
// Look for any teas.
if (!context.Pop.Any())
{
context.Pop.AddRange(
new Pop
{
PopId = 1,
PopName = "Mtn Dew",
FruitFlavor = "Always Fruity",
Diet = "Diet Pop",
PackageType = "Bottled Pop",
PreferTemp = "Room Tempature",
Sugar = "Zero Sugar",
NumDrinkPerDay = 5
},
new Pop
{
PopId = 1,
PopName = "Dr Pepper",
FruitFlavor = "Never Fruity",
Diet = "Regular Pop",
PackageType = "Bottled Pop",
PreferTemp = "Ice Cold",
Sugar = "Zero Sugar",
NumDrinkPerDay = 2
},
new Pop
{
PopId = 1,
PopName = "Mtn Dew",
FruitFlavor = "Always Fruity",
Diet = "Diet Pop",
PackageType = "Canned Pop",
PreferTemp = "Slightly Chilled",
Sugar = "Sugar Added",
NumDrinkPerDay = 2
},
new Pop
{
PopId = 1,
PopName = "Mtn Dew",
FruitFlavor = "Always Fruity",
Diet = "Diet Pop",
PackageType = "Bottled Pop",
PreferTemp = "Room Tempature",
Sugar = "Zero Sugar",
NumDrinkPerDay = 5
}
);
context.SaveChanges();
}
List <int> popIDList = new List <int>();
foreach (Tea thePop in context.Tea)
{
popIDList.Add(thePop.TeaID);
}
}
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new DrinkUpContext(
serviceProvider.GetRequiredService <
DbContextOptions <DrinkUpContext> >()))
{
// Look for any teas.
if (!context.Tea.Any())
{
context.Tea.AddRange(
new Tea
{
TeaName = "Brooklyn Tea",
Discription = "An organic black tea blend with a twist. Brooklyn has a vibrant black tea base with high notes of Madagascar vanilla for a full-bodied, malty morning cup.",
TeaType = "Black",
TeaBrand = "Art Of Tea",
Organic = false,
Caffene = 'H',
BrewType = "Loose",
BrewTempC = 96,
BrewTime = 4,
Source = ""
},
new Tea
{
TeaName = "6:00 PM Tea",
Discription = "Immerse yourself into a cup of this inviting loose leaf chamomile infused blend. 6:00 pm steeps a floral cup with a thin liquor and a sweet and spicy character. The perfect answer to your evening tea needs.",
TeaType = "Herbal",
TeaBrand = "Art Of Tea",
Organic = true,
Caffene = 'N',
BrewType = "Loose",
BrewTempC = 96,
BrewTime = 4,
Source = ""
},
new Tea
{
TeaName = "Mint Matcha Superfood Green Tea Powder",
Discription = "Indulge in a revitalizing Matcha green tea blend that brings you a soothing cup of natural goodness! The dry Mint Matcha green tea powder is of a bright, light-green color ; along with a earthy and minty aroma that fills the air. The brewed matcha tea is full-bodied and has a deep dark-green color. The cup starts with fresh vegetal notes of the pure Japanese matcha, joined by the discernible, cooling and invigorating notes of Mint which travel into the finish as well. This matcha tea can be accompanied by a dollop of honey or it can enjoyed all by itself. Overall, a calming and enveloping cup of vitality.",
TeaType = "Matcha",
TeaBrand = "Vahdam",
Organic = false,
Caffene = 'L',
BrewType = "Powder",
BrewTempC = 90,
BrewTime = 0,
Source = "Farms in Shizouka, Japan and India"
},
new Tea
{
TeaName = "Green Tea Blueberry Slim Life Tea",
Discription = "Formulated to help provide energy for an active lifestyle while dieting, Yogi Green Tea Blueberry Slim Life tea combines Green Tea and Garcinia Cambogia Fruit Extract with Panax Ginseng Root and Eleuthero Root to support stamina. Sweet Blueberry flavor and bright Hibiscus make Yogi Green Tea Blueberry Slim Life tea a delicious addition to a weight loss program of exercise and a balanced diet.",
TeaType = "Green",
TeaBrand = "Yogi",
Organic = false,
Caffene = 'H',
BrewType = "Bagged",
BrewTempC = 100,
BrewTime = 3,
Source = ""
} /*,
* new Tea
* {
* TeaName = "",
* Discription = "",
* TeaType = "",
* TeaBrand = "",
* Organic = ,
* Caffene = '',
* BrewType = "",
* BrewTempC = ,
* BrewTime = ,
* Source = ""
* }
*/
);
context.SaveChanges();
}
List <int> teaIDList = new List <int>();
foreach (Tea theTea in context.Tea)
{
teaIDList.Add(theTea.TeaID);
}
// Look for any teas.
if (!context.TeaIngredient.Any())
{
context.TeaIngredient.AddRange(
//0
new TeaIngredient
{
IngredientName = "Organic Black Tea"
},
new TeaIngredient
{
IngredientName = "Cornflowers"
},
new TeaIngredient
{
IngredientName = "Organic Marigolds"
},
new TeaIngredient
{
IngredientName = "Natural Flavors"
},
new TeaIngredient
{
IngredientName = "Organic Chamomile"
},
//5
new TeaIngredient
{
IngredientName = "Orgnic Lavender"
},
new TeaIngredient
{
IngredientName = "Organic Rosehips"
},
new TeaIngredient
{
IngredientName = "Organic Pink Peppercorn"
},
new TeaIngredient
{
IngredientName = "Matcha Green Tea Powder"
},
new TeaIngredient
{
IngredientName = "Mint Extracts"
},
//10
new TeaIngredient
{
IngredientName = "Hibiscus Flower"
},
new TeaIngredient
{
IngredientName = "Monk Fruit Extract"
},
new TeaIngredient
{
IngredientName = "Asian Ginseng Root (Panax ginseng)"
},
new TeaIngredient
{
IngredientName = "Chebulic Myrobalan Fruit (Haritaki)"
},
new TeaIngredient
{
IngredientName = "Bilberry Leaf"
},
//15
new TeaIngredient
{
IngredientName = "Bilberry Leaf"
},
new TeaIngredient
{
IngredientName = "Eleuthero Root"
},
new TeaIngredient
{
IngredientName = "Stevia Leaf"
},
new TeaIngredient
{
IngredientName = "Amla Fruit"
},
new TeaIngredient
{
IngredientName = "Belleric Myrobalan Fruit (Bibhitaki)"
}
/*
* ,
* new TeaIngredient
* {
* IngredientName = ""
* }
*/
);
context.SaveChanges();
}
if (!context.TeaIngredientLink.Any())
{
List <int> teaIngredientIDList = new List <int>();
foreach (TeaIngredient objectt in context.TeaIngredient)
{
teaIngredientIDList.Add(objectt.TeaIngredientID);
}
context.TeaIngredientLink.AddRange(
//Brooklyn Tea
new TeaIngredientLink
{
TeaId = teaIDList[0],
TeaIngredientID = teaIngredientIDList[0]
},
new TeaIngredientLink
{
TeaId = teaIDList[0],
TeaIngredientID = teaIngredientIDList[1]
},
new TeaIngredientLink
{
TeaId = teaIDList[0],
TeaIngredientID = teaIngredientIDList[2]
},
new TeaIngredientLink
{
TeaId = teaIDList[0],
TeaIngredientID = teaIngredientIDList[3]
},
//6:00 PM Tea
new TeaIngredientLink
{
TeaId = teaIDList[1],
TeaIngredientID = teaIngredientIDList[4]
},
new TeaIngredientLink
{
TeaId = teaIDList[1],
TeaIngredientID = teaIngredientIDList[5]
},
new TeaIngredientLink
{
TeaId = teaIDList[1],
TeaIngredientID = teaIngredientIDList[6]
},
new TeaIngredientLink
{
TeaId = teaIDList[1],
TeaIngredientID = teaIngredientIDList[7]
},
//Mint Matcha Superfood Green Tea PowderMint Matcha Superfood Green Tea Powder
new TeaIngredientLink
{
TeaId = teaIDList[2],
TeaIngredientID = teaIngredientIDList[8]
},
new TeaIngredientLink
{
TeaId = teaIDList[2],
TeaIngredientID = teaIngredientIDList[9]
},
//Blueberry Slim Life Tea
new TeaIngredientLink
{
TeaId = teaIDList[3],
TeaIngredientID = teaIngredientIDList[3]
},
//Blueberry Slim Life Tea
new TeaIngredientLink
{
TeaId = teaIDList[3],
TeaIngredientID = teaIngredientIDList[10]
},
//Blueberry Slim Life Tea
new TeaIngredientLink
{
TeaId = teaIDList[3],
TeaIngredientID = teaIngredientIDList[11]
},
//Blueberry Slim Life Tea
new TeaIngredientLink
{
TeaId = teaIDList[3],
TeaIngredientID = teaIngredientIDList[12]
},
//Blueberry Slim Life Tea
new TeaIngredientLink
{
TeaId = teaIDList[3],
TeaIngredientID = teaIngredientIDList[13]
},
//Blueberry Slim Life Tea
new TeaIngredientLink
{
TeaId = teaIDList[3],
TeaIngredientID = teaIngredientIDList[14]
},
//Blueberry Slim Life Tea
new TeaIngredientLink
{
TeaId = teaIDList[3],
TeaIngredientID = teaIngredientIDList[15]
},
//Blueberry Slim Life Tea
new TeaIngredientLink
{
TeaId = teaIDList[3],
TeaIngredientID = teaIngredientIDList[16]
},
//Blueberry Slim Life Tea
new TeaIngredientLink
{
TeaId = teaIDList[3],
TeaIngredientID = teaIngredientIDList[17]
},
//Blueberry Slim Life Tea
new TeaIngredientLink
{
TeaId = teaIDList[3],
TeaIngredientID = teaIngredientIDList[18]
},
//Blueberry Slim Life Tea
new TeaIngredientLink
{
TeaId = teaIDList[3],
TeaIngredientID = teaIngredientIDList[19]
}
);
context.SaveChanges();
}
if (!context.TeaStore.Any())
{
context.TeaStore.AddRange(
//0
new TeaStore
{
Name = "Art Of Tea",
Url = "https://www.artoftea.com/products/brooklyn"
},
new TeaStore
{
Name = "Art Of Tea",
Url = "https://www.artoftea.com/products/6pm"
},
new TeaStore
{
Name = "Vahdam",
Url = "https://www.vahdamteas.com/products/mint-matcha-green-tea?_pos=1&_sid=fd4ef41a3&_ss=r&variant=16903226294315"
},
new TeaStore
{
Name = "Amazon",
Url = ""
},
new TeaStore
{
Name = "Amazon",
Url = "https://www.amazon.com/stores/node/3050987011"
},
//5
new TeaStore
{
Name = "Walmart",
Url = "https://www.walmart.com/browse/food/yogi-tea/976759_976782_1001320_9454938?cat_id=976759_976782_1001320_9454938&facet=retailer%3AWalmart.com"
},
new TeaStore
{
Name = "Vitacost",
Url = "https://www.vitacost.com/yogi-1"
}
);
context.SaveChanges();
}
if (!context.TeaStoreLink.Any())
{
List <int> IDList = new List <int>();
foreach (TeaStore objectt in context.TeaStore)
{
IDList.Add(objectt.TeaStoreID);
}
context.TeaStoreLink.AddRange(
new TeaStoreLink
{
TeaId = teaIDList[0],
TeaStoreId = IDList[0]
},
new TeaStoreLink
{
TeaId = teaIDList[1],
TeaStoreId = IDList[1]
},
new TeaStoreLink
{
TeaId = teaIDList[2],
TeaStoreId = IDList[2]
},
new TeaStoreLink
{
TeaId = teaIDList[2],
TeaStoreId = IDList[3]
},
new TeaStoreLink
{
TeaId = teaIDList[3],
TeaStoreId = IDList[4]
},
new TeaStoreLink
{
TeaId = teaIDList[3],
TeaStoreId = IDList[5]
},
new TeaStoreLink
{
TeaId = teaIDList[3],
TeaStoreId = IDList[6]
}
);
context.SaveChanges();
}
if (!context.TeaTags.Any())
{
context.TeaTags.AddRange(
//0
new TeaTags
{
Tag = "vanilla"
},
new TeaTags
{
Tag = "full-bodied"
},
new TeaTags
{
Tag = "malty"
},
new TeaTags
{
Tag = "floral"
},
new TeaTags
{
Tag = "sweet and spicy"
},
//5
new TeaTags
{
Tag = "earthy"
},
new TeaTags
{
Tag = "minty"
},
new TeaTags
{
Tag = "vegital"
},
new TeaTags
{
Tag = "cooling"
},
new TeaTags
{
Tag = "fruity"
},
//10
new TeaTags
{
Tag = "sweet"
}
);
context.SaveChanges();
}
if (!context.TeaTagsLink.Any())
{
List <int> IDList = new List <int>();
foreach (TeaTags objectt in context.TeaTags)
{
IDList.Add(objectt.TeaTagID);
}
context.TeaTagsLink.AddRange(
new TeaTagsLink
{
TeaId = teaIDList[0],
TeaTagID = IDList[0]
},
new TeaTagsLink
{
TeaId = teaIDList[0],
TeaTagID = IDList[1]
},
new TeaTagsLink
{
TeaId = teaIDList[0],
TeaTagID = IDList[2]
},
new TeaTagsLink
{
TeaId = teaIDList[1],
TeaTagID = IDList[3]
},
new TeaTagsLink
{
TeaId = teaIDList[1],
TeaTagID = IDList[4]
},
new TeaTagsLink
{
TeaId = teaIDList[2],
TeaTagID = IDList[1]
},
new TeaTagsLink
{
TeaId = teaIDList[2],
TeaTagID = IDList[5]
},
new TeaTagsLink
{
TeaId = teaIDList[2],
TeaTagID = IDList[6]
},
new TeaTagsLink
{
TeaId = teaIDList[2],
TeaTagID = IDList[7]
},
new TeaTagsLink
{
TeaId = teaIDList[2],
TeaTagID = IDList[8]
},
new TeaTagsLink
{
TeaId = teaIDList[3],
TeaTagID = IDList[9]
},
new TeaTagsLink
{
TeaId = teaIDList[3],
TeaTagID = IDList[10]
}
);
context.SaveChanges();
}
}
}
public FrapuccinoesController(DrinkUpContext context)
{
_context = context;
}
