public void AddOrUpdateStock(Stock stock)
{
using (var db = new DrinksContext())
{
var existingStock = db.Stocks.FirstOrDefault(x => x.Name == stock.Name);
if (existingStock != null)
{
existingStock.RemainingUnits = stock.RemainingUnits;
}
else
{
var newId = 1;
if (db.Stocks != null && db.Stocks.Count() > 0)
{
newId = db.Stocks.Max(x => x.ID) + 1;
}
stock.ID = newId;
db.Stocks.Add(stock);
}
db.SaveChanges();
}
}
public void AddOrUpdateDrink(Drink drink)
{
using (var db = new DrinksContext())
{
var existingDrink = db.Drinks.FirstOrDefault(x => x.Name == drink.Name);
if (existingDrink != null)
{
existingDrink.MilkUnit = drink.MilkUnit;
existingDrink.SugarUnit = drink.SugarUnit;
existingDrink.CoffeeBeanUnit = drink.CoffeeBeanUnit;
}
else
{
var newId = 1;
if (db.Drinks != null && db.Drinks.Count() > 0)
{
newId = db.Drinks.Max(x => x.ID) + 1;
}
drink.ID = newId;
db.Drinks.Add(drink);
}
db.SaveChanges();
}
}
public List <Drink> GetAllDrinks()
{
var drinks = new List <Drink>();
using (var ctx = new DrinksContext())
{
drinks = ctx.Drinks.Select(d => d).ToList();
}
return(drinks);
}
public void AddOrderHistory(OrderHistory history)
{
using (var db = new DrinksContext())
{
var newId = 1;
if (db.OrderHistoryList != null && db.OrderHistoryList.Count() > 0)
{
newId = db.OrderHistoryList.Max(x => x.ID) + 1;
}
history.ID = newId;
db.OrderHistoryList.Add(history);
db.SaveChanges();
}
}
public Drink GetDrinkById(int id)
{
Drink drink = null;
using (var db = new DrinksContext())
{
var query = db.Drinks.FirstOrDefault(x => x.ID == id);
if (query != null)
{
drink = query;
}
}
return(drink);
}
public List <OrderHistory> GetAllOrderHistory()
{
var orderHistoryList = new List <OrderHistory>();
using (var db = new DrinksContext())
{
var query = db.OrderHistoryList.Where(x => x.ID > 0);
if (query != null)
{
orderHistoryList = query.OrderBy(x => x.OrderTime).ToList();
}
}
return(orderHistoryList);
}
public List <Stock> GetAllStocks()
{
var stocks = new List <Stock>();
using (var db = new DrinksContext())
{
var query = db.Stocks.Where(x => x.ID > 0);
if (query != null)
{
stocks = query.ToList();
}
}
return(stocks);
}
public List <Drink> GetAllDrinks()
{
var drinks = new List <Drink>();
using (var db = new DrinksContext())
{
var query = db.Drinks.Where(x => x.ID > 0 && !string.IsNullOrEmpty(x.Name));
if (query != null)
{
drinks = query.ToList();
}
}
return(drinks);
}
public void ClearContext()
{
using (var db = new DrinksContext())
{
foreach (var drink in db.Drinks)
{
db.Drinks.Remove(drink);
}
foreach (var history in db.OrderHistoryList)
{
db.OrderHistoryList.Remove(history);
}
foreach (var stock in db.Stocks)
{
db.Stocks.Remove(stock);
}
db.SaveChanges();
}
}
public DrinksController(DrinksContext db)
{
this.db = db;
/*initial drinks added on startup
* drop and update entire database to show changes:
* dotnet ef database drop
* dotnet ef database update
*/
if (this.db.Drinks.Count() == 0)
{
this.db.Drinks.Add(new Drinks()
{
name = "Strawberry Basil Mule", type = "vodka", image =
"https://hips.hearstapps.com/hmg-prod.s3.amazonaws.com/images/1552320409.png?crop=0.699xw:0.992xh;0.206xw,0.00817xh&resize=980:*",
recipe = "Ingredients:" + Environment.NewLine +
"8 Strawberries" + Environment.NewLine +
"Half a Lime" + Environment.NewLine +
"Basil Sprig" + Environment.NewLine +
"1.5oz Premium Vodka" + Environment.NewLine +
"3.5oz Brooklyn Crafted Lemon Lime Ginger Beer" + Environment.NewLine + Environment.NewLine +
"Instructions:" + Environment.NewLine +
"Muddle fresh strawberries (roughly 6), 2 lime wedges and basil in a copper mule mug. Top with ice, vodka and Brooklyn Crafted. Garnish with strawberry and lime wedge and basil leaves."
});
this.db.Drinks.Add(new Drinks()
{
name = "Black Cherry Beast", type = "vodka", image =
"https://hips.hearstapps.com/mac.h-cdn.co/assets/17/05/black-cherry-effen-beast_rs.jpg?crop=1.0xw:1xh;center,top&resize=980:*",
recipe = "Ingredients:" + Environment.NewLine +
" 1.5 parts EFFEN Black Cherry Vodka" + Environment.NewLine +
"2 parts White Cranberry Juice" + Environment.NewLine +
"0.5 parts Vanilla Simple Syrup" + Environment.NewLine +
"0.5 parts Fresh Lemon Juice" + Environment.NewLine +
"Brandied Cherries, for garnish" + Environment.NewLine + Environment.NewLine +
"Instructions:" + Environment.NewLine +
"Shake and strain all ingredients over fresh ice in a rocks glass. Garnish with brandied cherries"
});
this.db.Drinks.Add(new Drinks()
{
name = "Raspberry Smash", type = "vodka", image =
"https://hips.hearstapps.com/mac.h-cdn.co/assets/16/44/raspberry-smash_rs.jpg?crop=1.0xw:1xh;center,top&resize=980:*",
recipe = "Ingredients:" + Environment.NewLine +
"6-8 Mint Leaves" + Environment.NewLine +
"6 Fresh Raspberries" + Environment.NewLine +
"2 oz. 50 Bleu Vodka" + Environment.NewLine +
"1 oz. Fresh Lemon Juice" + Environment.NewLine +
"1 oz. Pomegranate Juice" + Environment.NewLine +
"½ oz. Simple Syrup" + Environment.NewLine +
"Garnish: Lemon Wheel, Raspberry, Mint Sprig" + Environment.NewLine + Environment.NewLine +
"Instructions:" + Environment.NewLine +
"Add mint and raspberries into mixing tin. Lightly muddle, to press berries and to release the oils from mint. Now add the rest of the ingredients. Add ice and shake vigorously. Now strain over crushed ice and garnish with lemon, raspberry, and mint."
});
this.db.Drinks.Add(new Drinks()
{
name = "Fresca Frizz", type = "vodka", image =
"https://hips.hearstapps.com/mac.h-cdn.co/assets/16/42/bottiglia-fresca-fizz.jpg?crop=1.0xw:1xh;center,top&resize=980:*",
recipe = "Ingredients:" + Environment.NewLine +
"4-6 Raspberries" + Environment.NewLine +
"10-12 Mint Leaves" + Environment.NewLine +
"1 ½ oz. Grey Goose Vodka" + Environment.NewLine +
"¾ oz. Fresh Lime Juice" + Environment.NewLine +
"¾ oz. Wilks & Wilson Raspberry Gomme Syrup" + Environment.NewLine +
"1 ½ oz. Prosecco (Add after shake)" + Environment.NewLine +
"Garnish: Raspberry, Mint Sprig" + Environment.NewLine + Environment.NewLine +
"Instructions:" + Environment.NewLine +
"Add raspberries, six mint leaves, and raspberry syrup into mixing tin, then lightly muddle. Add the rest of the ingredients, except for the prosecco. Add ice and shake vigorously. Now add 1 ½ oz prosecco into mixing tin, and strain over crushed ice with 6 mint leaves on the bottom of the glass. Garnish with raspberry and mint."
});
this.db.Drinks.Add(new Drinks()
{
name = "Smoked & Salted", type = "whiskey", image =
"https://hips.hearstapps.com/hmg-prod.s3.amazonaws.com/images/181115-ibl-f-b-372-1554261182.jpg?crop=0.536xw:1.00xh;0.276xw,0&resize=980:*",
recipe = "Ingredients" + Environment.NewLine +
"2 oz Four Roses Bourbon" + Environment.NewLine +
".25 oz maple syrup (slightly thinned out with hot water ahead of time)" + Environment.NewLine +
"5 dashes Crude Smoke & Salt Bitters" + Environment.NewLine + Environment.NewLine +
"Instructions" + Environment.NewLine +
"Stir with ice to chill and dilute. Strain into a double rocks glass with a large ice cube. Garnish with an orange twist"
});
this.db.Drinks.Add(new Drinks()
{
name = "The Hobnail", type = "whiskey", image =
"https://hips.hearstapps.com/toc.h-cdn.co/assets/17/05/hongkongthepontiachobnail.jpg?crop=1xw:0.8342391304347826xh;center,top&resize=980:*",
recipe = "Ingredients:" + Environment.NewLine +
"1.5 oz Pig's Nose blended Scotch" + Environment.NewLine +
".75 oz ginger syrup" + Environment.NewLine +
".75 oz lemon juice" + Environment.NewLine +
"1 teaspoon Averna Amaro" + Environment.NewLine +
"2 dashes Angostura bitters" + Environment.NewLine + Environment.NewLine +
"Instructions" + Environment.NewLine +
"Shake and double strain into a bucket, add ice, and garnish with a healthy swath of orange."
});
this.db.Drinks.Add(new Drinks()
{
name = "Brassmonkey", type = "whiskey", image =
"https://hips.hearstapps.com/toc.h-cdn.co/assets/17/05/hongkongstocktonbrassmonkey.jpg?crop=0.445xw:1.00xh;0.156xw,0&resize=980:*",
recipe = "Ingredients" + Environment.NewLine +
"1.5 oz Johnnie Walker Black" + Environment.NewLine +
".75 oz lime juice" + Environment.NewLine +
".75 oz egg whites" + Environment.NewLine +
".5 oz vanilla syrup*" + Environment.NewLine +
"3 dashes Chuncho bitters" + Environment.NewLine +
".5 barspoon maca powder" + Environment.NewLine +
".5 barspoon lucuma powder" + Environment.NewLine + Environment.NewLine +
"Instructions" + Environment.NewLine +
"Mix all the ingredients in a mixing glass. Dry shake first, then hard shake with ice. Fine strain into a glass with ice. Garnish with a dash of bitters." + Environment.NewLine + Environment.NewLine +
"*To make vanilla syrup: combine 2 cups raw sugar, 1 cup water, and 1 vanilla stick that has been sliced open. Slow cook over low heat for 15 minutes."
});
this.db.Drinks.Add(new Drinks()
{
name = "Chad’s Drink", type = "whiskey", image =
"https://drivito2.imgix.drizly.com/070500db587880f7/d0e78c297d26/WR-Neat_Hero.png?auto=format%2Ccompress&dpr=2&fm=jpeg&q=30&w=375",
recipe = "Ingredients:" + Environment.NewLine +
"2 oz of Woodford Reserve" + Environment.NewLine +
"Instructions:" + Environment.NewLine +
"Teach 3610 for a whole semester. Find your finest cocktail glass. Pour and enjoy!"
});
this.db.Drinks.Add(new Drinks()
{
name = "The Lamborn", type = "rum", image =
"https://hips.hearstapps.com/hmg-prod.s3.amazonaws.com/images/thelamborn-gk-1493417675.jpg?crop=1xw:1xh;center,top&resize=980:*",
recipe = "Ingredients:" + Environment.NewLine +
"2 oz Mount Gay Silver rum" + Environment.NewLine +
"2 oz snap pea juice" + Environment.NewLine +
"1 oz lime juice" + Environment.NewLine +
".5 oz jasmine syrup" + Environment.NewLine + Environment.NewLine +
"Instructions:" + Environment.NewLine +
"Shake with ice and strain into a highball glass over fresh ice. Garnish with pea shoots and flower."
});
this
.db.Drinks.Add(new Drinks()
{
name = "Tropic Bowl", type = "rum", image =
"https://hips.hearstapps.com/toc.h-cdn.co/assets/16/33/tropic-bowl2_1.jpg?crop=0.447xw:1.00xh;0.401xw,0&resize=*:2136",
recipe = "Ingredients:" + Environment.NewLine +
"1.5 oz Banks 5 Rum" + Environment.NewLine +
".75 oz spiced pineapple syrup" + Environment.NewLine +
".5 oz honey syrup" + Environment.NewLine +
".5 oz fresh lime juice" + Environment.NewLine +
"1 strawberry, muddled" + Environment.NewLine +
"1 mint sprig" + Environment.NewLine +
"1 pinch Salt" + Environment.NewLine + Environment.NewLine +
"Instructions:" + Environment.NewLine +
"Muddle, shake, fine strain on crushed ice in a tiki mug. Optional: garnish with two pineapple leaves, orchid and tiki straw."
});
this.db.Drinks.Add(new Drinks()
{
name = "Paid Vacation Days", type = "rum", image =
"https://hips.hearstapps.com/hmg-prod.s3.amazonaws.com/images/atfohnyc-0796-1491932215.jpg?crop=0.447xw:1.00xh;0.366xw,0&resize=*:2136",
recipe = "Ingredients:" + Environment.NewLine +
"1.5 oz Don Q Rum" + Environment.NewLine +
"1.5 oz pineapple juice" + Environment.NewLine +
".75 oz orange juice" + Environment.NewLine +
".5 oz hazelnut liqueur" + Environment.NewLine +
"Club soda, to fill" + Environment.NewLine +
"Mint, to garnish" + Environment.NewLine + Environment.NewLine +
"Instructions:" + Environment.NewLine +
"Combine rum, pineapple, orange and hazelnut into a shaking tin. Fill halfway with ice and shake for 5 seconds. Strain into a Collins glass with ice. Top with club soda and garnish with a mint sprig."
});
this.db.Drinks.Add(new Drinks()
{
name = "Boozy Affagato", type = "rum", image =
"https://hips.hearstapps.com/toc.h-cdn.co/assets/16/33/boozy-affogato-naren-young-credit-steven-freihon_1.jpg?crop=0.512xw:0.638xh;0.231xw,0.362xh&resize=*:2136",
recipe = "Ingredients:" + Environment.NewLine +
".5 oz Appleton Reserve rum" + Environment.NewLine +
".5 oz Fonseca LBV Port" + Environment.NewLine +
".5 oz Licor 43" + Environment.NewLine +
".5 oz agave nectar" + Environment.NewLine +
"2 oz cold brew coffee" + Environment.NewLine +
"Glass: Latte" + Environment.NewLine +
"Garnish: Biscotti (serve with a spoon)" + Environment.NewLine + Environment.NewLine +
"Instructions:" + Environment.NewLine +
"Pour over 1 scoop of gelato."
});
this.db.Drinks.Add(new Drinks()
{
name = "It's Greek To Me", type = "tequila", image = "https://hips.hearstapps.com/toc.h-cdn.co/assets/17/10/avra-madisons-its-greek-to-me-usd16_alan-battman.jpg?crop=1.0xw:1xh;center,top&resize=980:*",
recipe = "Ingredients" + Environment.NewLine +
"4 slices ginger" + Environment.NewLine +
"1 oz Maestro Dobel Tequila" + Environment.NewLine +
".5 oz Mavrakis Tsipouro" + Environment.NewLine +
"1 oz lime juice" + Environment.NewLine +
".75 oz Chambord" + Environment.NewLine +
".5 oz agave" + Environment.NewLine +
"1 dash Angostura bitters" + Environment.NewLine +
"Instructions" + Environment.NewLine +
"Muddle ginger into the bottom of a shaker. Combine all other ingredients in shaker over ice and shake. Strain into a cocktail glass and garnish with sage."
});
this.db.Drinks.Add(new Drinks()
{
name = "The Magui Cactus", type = "tequila", image =
"https://hips.hearstapps.com/toc.h-cdn.co/assets/17/10/andazmayakobamaguicactuscocktailphoto.jpg?crop=0.9652582159624413xw:1xh;center,top&resize=980:*",
recipe = "Ingredients" + Environment.NewLine +
"5 mint leaves" + Environment.NewLine +
"1 oz lime juice " + Environment.NewLine +
"1 oz Xtanbentum (an anise liqueur made in Mexico's Yucatan region)" + Environment.NewLine +
"1 oz simple syrup" + Environment.NewLine +
"1.5 oz white tequila" + Environment.NewLine +
"2 oz cactus puree" + Environment.NewLine +
"Instructions:" + Environment.NewLine +
"Shake all ingredients and serve in a rocks glass whose edge is half salted and garnished with mint leaves."
});
this.db.Drinks.Add(new Drinks()
{
name = "The Mystic Marvel", type = "tequila", image =
"https://hips.hearstapps.com/toc.h-cdn.co/assets/17/10/fishbowl-at-dream-midtowns-mystic-marvel-usd13.jpg?crop=1xw:0.9728301886792453xh;center,top&resize=*:2136",
recipe = "Ingredients" + Environment.NewLine +
"1.5 oz Casamigos Tequila" + Environment.NewLine +
"1 oz prickly pear purée" + Environment.NewLine +
".75 oz agave" + Environment.NewLine +
".75 oz lime juice" + Environment.NewLine +
"Instructions" + Environment.NewLine +
"Combine all ingredients in a shaker over ice and shake. Strain over fresh ice and garnish with a salt rim and lime."
});
this.db.Drinks.Add(new Drinks()
{
name = "Blood Orange Margarita", type = "tequila", image =
"https://hips.hearstapps.com/toc.h-cdn.co/assets/17/10/bloodorangemargaritajpg.jpeg?crop=1.0xw:1xh;center,top&resize=*:2136",
recipe = "Ingredients" + Environment.NewLine +
"1.5 oz Silver Tequila" + Environment.NewLine +
".5 oz Cointreau" + Environment.NewLine +
".5 blood orange juice" + Environment.NewLine +
".75 oz simple syrup" + Environment.NewLine +
"1 oz lime juice" + Environment.NewLine +
"Instructions" + Environment.NewLine +
"Fill a mixing tin with ice. Add all ingredients and shake vigorously. Empty shaker contents into a rocks glass with a salted rim. Garnish with a blood orange slice."
});
this.db.SaveChanges();
}
}
public OrdersController(DrinksContext context)
{
_context = context;
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new DrinksContext(
serviceProvider.GetRequiredService <
DbContextOptions <DrinksContext> >()))
{
// Look for any movies.
if (context.Cocktail.Any())
{
return; // DB has been seeded
}
context.Cocktail.AddRange(
new Cocktail
{
Name = "Vesper",
Glass = "martini",
Category = "Before Dinner Cocktail",
Ingredients = "6 cl Gin, 1.5 cl Vodka, 0.75 cl Lillet Blonde.",
Garnish = "Lemon twist",
Preparation = "Shake and strain into a chilled cocktail glass."
},
new Cocktail
{
Name = "Bacardi",
Glass = "martini",
Category = "Before Dinner Cocktail",
Ingredients = "4.5 cl White rum, 2 cl Lime juice, 1 cl Syrup.",
Garnish = "None",
Preparation = "Shake with ice cubes. Strain into chilled cocktail glass."
},
new Cocktail
{
Name = "Negroni",
Glass = "old-fashioned",
Category = "Before Dinner Cocktail",
Ingredients = "3 cl Gin, 3 cl Campari, 3 cl Vermouth.",
Garnish = "Half an orange slice",
Preparation = "Build into old-fashioned glass filled with ice. Stir gently."
},
new Cocktail
{
Name = "Rose",
Glass = "martini",
Category = "None",
Ingredients = "2 cl Kirsch, 4 cl Vermouth, 3 dashes Strawberry syrup.",
Garnish = "None",
Preparation = "Stir all ingredients with ice and strain into a cocktail glass."
},
new Cocktail
{
Name = "Old Fashioned",
Glass = "old-fashioned",
Category = "Before Dinner Cocktail",
Ingredients = "4.5 cl Whiskey, 2 dashes Angostura Bitters, 1 sugar cube, Few dashes plain water.",
Garnish = "Orange slice and cherry",
Preparation = "Place sugar cube in old-fashioned glass and saturate with bitters, add a dash of plain water. Muddle until dissolve. Fill the glass with ice cubes and add whisky."
},
new Cocktail
{
Name = "Tuxedo",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "3 cl Gin, 3 cl Vermouth, 1/2 bar spoon Maraschino, 1/4 bar spoon Absinthe, 3 dashes Orange Bitters.",
Garnish = "Cherry and lemon twist",
Preparation = "Stir all ingredients with ice and strain into cocktail glass."
},
new Cocktail
{
Name = "Mojito",
Glass = "collins",
Category = "Longdrink",
Ingredients = "4 cl White rum, 3 cl Lime juice, 6 Mint sprigs, 2 teaspoons white sugar, Soda water.",
Garnish = "Mint leaves and lemon slice",
Preparation = "Muddle mint sprigs with sugar and lime juice. Add splash of soda water and fill glass with cracked ice. Pour rum and top with soda water. Serve with straw."
},
new Cocktail
{
Name = "Horse's Neck",
Glass = "highball",
Category = "Longdrink",
Ingredients = "4 cl Cognac, 12 cl Ginger Ale, Dash of Angostura bitters (optional).",
Garnish = "Lemon twist",
Preparation = "Build into highball glass with ice cubes. Stir gently. If required, add dashes of Angostura bitters."
},
new Cocktail
{
Name = "Planter's Punch",
Glass = "highball",
Category = "Longdrink",
Ingredients = "4.5 cl Dark rum, 3.5 cl Orange juice, 3.5 cl Pineapple juice, 2 cl Lemon juice, 1 cl Syrup, 1 cl Syrup, 3 to 4 dashes Angostura bitters.",
Garnish = "Pineapple slice and a cherry",
Preparation = "Pour all ingredients, except the bitters, into shaker filled with ice. Shake. Pour into large glass, filled with ice. Add Angostura bitters, “on top”."
},
new Cocktail
{
Name = "Sea Breeze",
Glass = "highball",
Category = "Longdrink",
Ingredients = "4 cl Vodka, 12 cl Cranberry juice, 3 cl Grapefruit juice.",
Garnish = "Lime wedge",
Preparation = "Build all ingredients in a rock glass filled with ice."
},
new Cocktail
{
Name = "Pisco Sour",
Glass = "old-fashioned",
Category = "All Day Cocktail",
Ingredients = "4.5 cl Pisco, 3 cl Lemon juice, 2 cl Syrup, 1 raw egg white (small egg).",
Garnish = "None",
Preparation = "Shake and strain into a chilled champagne flute. Dash some Angostura bitters on top."
},
new Cocktail
{
Name = "Long Island Iced Tea",
Glass = "highball",
Category = "Longdrink",
Ingredients = "1.5 cl Tequila, 1.5 cl Vodka, 1.5 cl White rum, 1.5 cl Triple Sec, 1.5 cl Gin, 2.5 cl Lemon juice, 3.0 cl Syrup, 1 dash of Cola.",
Garnish = "Lemon twist",
Preparation = "Add all ingredients into highball glass filled with ice. Stir gently. Serve with straw."
},
new Cocktail
{
Name = "Clover Club",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "4.5 cl Gin, 1.5 cl Syrup, 1.5 cl Lemon juice, Few drops of Egg White.",
Garnish = "None",
Preparation = "Shake with ice cubes. Strain into cocktail glass."
},
new Cocktail
{
Name = "Angel Face",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "3 cl Gin, 3 cl Apricot brandy, 3 cl Calvados.",
Garnish = "None",
Preparation = "Shake with ice cubes. Strain into a cocktail glass."
},
new Cocktail
{
Name = "Mimosa",
Glass = "champagne-flute",
Category = "Sparkling Cocktail",
Ingredients = "7.5 cl Champagne, 7.5 cl Orange juice.",
Garnish = "Optional orange twist",
Preparation = "Pour orange juice into flute and gently pour Champagne. Stir gently. Note: Buck's Fizz is a very similar cocktail but made of two parts champagne to one part orange juice."
},
new Cocktail
{
Name = "Whiskey Sour",
Glass = "old-fashioned",
Category = "Before Dinner Cocktail",
Ingredients = "4.5 cl Whiskey, 3.0 cl Lemon juice, 1.5 cl Syrup.",
Garnish = "Half an orange slice and cherry",
Preparation = "Dash egg white (Optional: if used shake little harder to foam up the egg white). Pour all ingredients into cocktail shaker filled with ice. Shake. Strain into cocktail glass. If served ‘On the rocks’, strain ingredients into old-fashioned glass filled with ice."
},
new Cocktail
{
Name = "Screwdriver",
Glass = "highball",
Category = "All Day Cocktail",
Ingredients = "5 cl Vodka, 10 cl Orange juice.",
Garnish = "Orange slice",
Preparation = "Build into a highball glass filled with ice. Stir gently."
},
new Cocktail
{
Name = "Cuba Libre",
Glass = "highball",
Category = "Longdrink",
Ingredients = "5 cl White rum, 12 cl Cola, 1 cl Lime juice.",
Garnish = "Lime wedge",
Preparation = "Build all ingredients in a highball glass filled with ice."
},
new Cocktail
{
Name = "Manhattan",
Glass = "martini",
Category = "Before Dinner Cocktail",
Ingredients = "5 cl Whiskey, 2 cl Vermouth, 1 dash Angostura Bitters.",
Garnish = "Cherry",
Preparation = "Stir in mixing glass with ice cubes. Strain into chilled cocktail glass."
},
new Cocktail
{
Name = "Porto Flip",
Glass = "martini",
Category = "After Dinner Cocktail",
Ingredients = "1.5 cl Cognac, 4.5 cl Red Port, 1 cl Egg yolk.",
Garnish = "None",
Preparation = "Shake with ice cubes. Strain into cocktail glass. Sprinkle with fresh ground nutmeg."
},
new Cocktail
{
Name = "Gin Fizz",
Glass = "highball",
Category = "Longdrink",
Ingredients = "4.5 cl Gin, 3 cl Lemon juice, 1 cl Syrup, 8 cl Soda water.",
Garnish = "Lemon slice",
Preparation = "Shake all ingredients with ice cubes, except soda water. Pour into tumbler. Top with soda water."
},
new Cocktail
{
Name = "Espresso Martini",
Glass = "martini",
Category = "After Dinner Cocktail",
Ingredients = "5 cl Vodka, 1 cl Coffee liqueur, Sugar syrup (according to individual preference of sweetness), 1 short strong Espresso.",
Garnish = "None",
Preparation = "Shake and strain into a chilled cocktail glass."
},
new Cocktail
{
Name = "Margarita",
Glass = "margarita",
Category = "All Day Cocktail",
Ingredients = "3.5 cl Tequila, 2 cl Triple Sec, 1.5 cl Lime juice.",
Garnish = "None",
Preparation = "Shake with ice cubes. Strain into cocktail glass rimmed with salt (note:Fruit Margarita - blend selected fruit with the above recipe)."
},
new Cocktail
{
Name = "French 75",
Glass = "champagne-tulip",
Category = "Sparkling Cocktail",
Ingredients = "3 cl Gin, 1.5 cl Lemon juice, 2 dashes Sugar syrup, 6 cl Champagne.",
Garnish = "None",
Preparation = "Shake with ice cubes, except for champagne. Strain into a champagne flute. Top up with champagne. Stir gently."
},
new Cocktail
{
Name = "Yellow Bird",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "3 cl White rum, 1.5 cl Galliano, 1.5 cl Triple Sec, 1.5 cl Lime juice.",
Garnish = "None",
Preparation = "Shake and strain into a chilled cocktail glass."
},
new Cocktail
{
Name = "Pina Colada",
Glass = "hurricane",
Category = "Longdrink",
Ingredients = "3 cl White rum, 9 cl Pineapple juice, 3 cl Coconut milk.",
Garnish = "Pineapple slice and a cherry",
Preparation = "Blend all the ingredients with ice in a electric blender, pour into a large goblet or Hurricane glass and serve with straws."
},
new Cocktail
{
Name = "Aviation",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "4.5 cl Gin, 1.5 cl Cherry liqueur, 1.5 cl Lemon juice.",
Garnish = "None",
Preparation = "Shake and strain into a chilled cocktail glass."
},
new Cocktail
{
Name = "Bellini",
Glass = "champagne-flute",
Category = "Sparkling Cocktail",
Ingredients = "10 cl Prosecco, 5 cl Peach puree.",
Garnish = "None",
Preparation = "Pour peach puree into chilled glass and add sparkling wine. Stir gently. Variations: Puccini (fresh mandarin juice), Rossini (fresh strawberry puree), Tintoretto (fresh pomegranate juice)"
},
new Cocktail
{
Name = "Grasshopper",
Glass = "martini",
Category = "After Dinner Cocktail",
Ingredients = "3 cl Créme liqueur, 3 cl Créme liqueur, 3 cl Cream.",
Garnish = "None",
Preparation = "Shake with ice cubes. Strain into chilled cocktail glass."
},
new Cocktail
{
Name = "Tequila Sunrise",
Glass = "highball",
Category = "Longdrink",
Ingredients = "4.5 cl Tequila, 9 cl Orange juice, 1.5 cl Syrup.",
Garnish = "Orange slice and a cherry",
Preparation = "Build tequila and orange juice into highball with ice cubes. Add a splash of grenadine to create sunrise effect. Do not stir."
},
new Cocktail
{
Name = "Daiquiri",
Glass = "martini",
Category = "Before Dinner Cocktail",
Ingredients = "4.5 cl White rum, 2.5 cl Lime juice, 1.5 cl Syrup.",
Garnish = "None",
Preparation = "Shake and strain into a cocktail glass."
},
new Cocktail
{
Name = "Rusty Nail",
Glass = "old-fashioned",
Category = "After Dinner Cocktail",
Ingredients = "4.5 cl Whiskey, 2.5 cl Drambuie.",
Garnish = "Lemon twist",
Preparation = "Build into old-fashioned glass filled with ice. Stir gently."
},
new Cocktail
{
Name = "B52",
Glass = "shot",
Category = "After Dinner Cocktail",
Ingredients = "2 cl Coffee liqueur, 2 cl Cream liqueur, 2 cl Triple Sec.",
Garnish = "None",
Preparation = "Layer ingredients one at a time starting with Kahlúa, followed by Baileys Irish Cream and top with Grand Marnier. Flame the Grand Marnier, serve while the flame is still on, accompanied with a straw on side plate."
},
new Cocktail
{
Name = "Stinger",
Glass = "martini",
Category = "After Dinner Cocktail",
Ingredients = "5 cl Cognac, 2 cl Créme liqueur.",
Garnish = "None",
Preparation = "Stir in mixing glass with ice cubes. Strain into a cocktail glass."
},
new Cocktail
{
Name = "Golden Dream",
Glass = "martini",
Category = "After Dinner Cocktail",
Ingredients = "2 cl Galliano, 2 cl Triple Sec, 2 cl Orange juice, 1 cl Cream.",
Garnish = "None",
Preparation = "Shake with ice cubes. Strain into chilled cocktail glass."
},
new Cocktail
{
Name = "God Mother",
Glass = "old-fashioned",
Category = "None",
Ingredients = "3.5 cl Vodka, 3.5 cl DiSaronno.",
Garnish = "None",
Preparation = "Build into old fashioned glass filled with ice cubes. Stir gently."
},
new Cocktail
{
Name = "Spritz Veneziano",
Glass = "old-fashioned",
Category = "Sparkling Cocktail",
Ingredients = "6 cl Prosecco, 4 cl Aperol, Splash of Soda water.",
Garnish = "Half an orange slice",
Preparation = "Build into an old-fashioned glass filled with ice. Top with a splash of soda water."
},
new Cocktail
{
Name = "Bramble",
Glass = "old-fashioned",
Category = "All Day Cocktail",
Ingredients = "4 cl Gin, 1.5 cl Lemon juice, 1 cl Syrup, 1.5 cl Blackberry liqueur.",
Garnish = "Lemon slice and two blackberries",
Preparation = "Build over crushed ice, in a rock glass. Stir, then pour the blackberry liqueur over the top of the drink in a circular fashion."
},
new Cocktail
{
Name = "Alexander",
Glass = "martini",
Category = "None",
Ingredients = "3 cl Cognac, 3 cl Créme liqueur, 3 cl Cream.",
Garnish = "None",
Preparation = "Shake and strain into a chilled cocktail glass. Sprinkle with fresh ground nutmeg."
},
new Cocktail
{
Name = "Lemon Drop Martini",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "2.5 cl Vodka, 2 cl Triple Sec, 1.5 cl Lemon juice.",
Garnish = "Lemon slice",
Preparation = "Shake and strain into a chilled cocktail glass rimmed with sugar."
},
new Cocktail
{
Name = "French Martini",
Glass = "martini",
Category = "Before Dinner Cocktail",
Ingredients = "4.5 cl Vodka, 1.5 cl Raspberry liqueur, 1.5 cl Pineapple juice.",
Garnish = "None",
Preparation = "Stir in mixing glass with ice cubes. Strain into chilled cocktail glass. Squeeze oil from lemon peel onto the drink."
},
new Cocktail
{
Name = "Black Russian",
Glass = "old-fashioned",
Category = "After Dinner Cocktail",
Ingredients = "5 cl Vodka, 2 cl Coffee liqueur.",
Garnish = "None",
Preparation = "Build into old fashioned glass filled with ice cubes. Stir gently. Note: for White Russian, float fresh cream on the top and stir gently."
},
new Cocktail
{
Name = "Bloody Mary",
Glass = "highball",
Category = "Longdrink",
Ingredients = "4.5 cl Vodka, 9 cl Tomato juice, 1.5 cl Lemon juice, 2 to 3 dashes of Worcestershire Sauce, Tabasco, Celery salt, Pepper.",
Garnish = "Celery and optionally lemon wedge",
Preparation = "Stir gently, pour all ingredients into highball glass."
},
new Cocktail
{
Name = "Mai-tai",
Glass = "highball",
Category = "Longdrink",
Ingredients = "4 cl White rum, 2 cl Dark rum, 1.5 cl Triple Sec, 1.5 cl Syrup, 1 cl Lime juice.",
Garnish = "Pineapple spear, mint leaves and lime wedge",
Preparation = "Shake and strain into highball glass. Serve with straw."
},
new Cocktail
{
Name = "Barracuda",
Glass = "margarita",
Category = "Sparkling Cocktail",
Ingredients = "4.5 cl Dark rum, 1.5 cl Galliano, 6 cl Pineapple juice, 1 dash Lime juice, Top with Prosecco.",
Garnish = "None",
Preparation = "Pour and Serve."
},
new Cocktail
{
Name = "Sex on the Beach",
Glass = "highball",
Category = "Longdrink",
Ingredients = "4 cl Vodka, 2 cl Peach schnapps, 4 cl Cranberry juice, 4 cl Orange juice.",
Garnish = "Orange slice",
Preparation = "Build all ingredients in a highball glass filled with ice."
},
new Cocktail
{
Name = "Monkey Gland",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "5 cl Gin, 3 cl Orange juice, 2 drops Absinthe, 2 drops Grenadine.",
Garnish = "None",
Preparation = "Shake and strain into a chilled cocktail glass."
},
new Cocktail
{
Name = "Derby",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "6 cl Gin, 2 drops Peach Bitters, 2 Fresh mint leaves.",
Garnish = "Mint leaves",
Preparation = "Stir in mixing glass with ice cubes. Strain into a cocktail glass."
},
new Cocktail
{
Name = "Sidecar",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "5 cl Cognac, 2 cl Triple Sec, 2 cl Lemon juice.",
Garnish = "None",
Preparation = "Shake with ice cubes. Strain into cocktail glass."
},
new Cocktail
{
Name = "Irish Coffee",
Glass = "hot-drink",
Category = "Hot Drink",
Ingredients = "4 cl Whiskey, 9 cl Hot coffee, 3 cl Cream, 1 teaspoon of brown sugar.",
Garnish = "None",
Preparation = "Warm the Irish whiskey over a burner. Pour into the glass (for hot drink) hot coffee, and add a teaspoon of sugar. Float Cream on top."
},
new Cocktail
{
Name = "Sazerac",
Glass = "old-fashioned",
Category = "After Dinner Cocktail",
Ingredients = "5 cl Cognac, 1 cl Absinthe, 1 sugar cube, 2 dashes Peychaud’s bitters.",
Garnish = "Lemon twist",
Preparation = "Rinse a chilled old-fashioned glass with the absinthe, add crushed ice and set it aside. Stir the remaining ingredients over ice and set it aside. Discard the ice and any excess absinthe from the prepared glass, and strain the drink into the glass. Note: The original recipe changed after the American Civil War, rye whiskey substituted cognac as it became hard to obtain."
},
new Cocktail
{
Name = "Americano",
Glass = "old-fashioned",
Category = "Before Dinner Cocktail",
Ingredients = "3 cl Campari, 3 cl Vermouth, A splash of soda water.",
Garnish = "Half an orange slice",
Preparation = "Build into old fashioned glass filled with ice cubes. Add a splash of soda water."
},
new Cocktail
{
Name = "Singapore Sling",
Glass = "highball",
Category = "Longdrink",
Ingredients = "3 cl Gin, 1.5 cl Cherry liqueur, 0.75 cl Triple Sec, 0.75 cl DOM Bénédictine, 12.0 cl Pineapple juice, 1.5 cl Lime juice, 1 cl Syrup, 1 dash Angostura bitters.",
Garnish = "Pineapple slice and a cherry",
Preparation = "Shake with ice cubes. Strain into highball glass."
},
new Cocktail
{
Name = "French Connection",
Glass = "old-fashioned",
Category = "None",
Ingredients = "3.5 cl Cognac, 3.5 cl DiSaronno.",
Garnish = "None",
Preparation = "Build into old fashioned glass filled with ice cubes. Stir gently."
},
new Cocktail
{
Name = "Moscow Mule",
Glass = "highball",
Category = "Longdrink",
Ingredients = "4.5 cl Vodka, 12 cl Ginger beer, 0.5 cl Lime juice, 1 slice lime in a highball glass.",
Garnish = "Lime slice",
Preparation = "Combine the vodka and ginger beer. Add lime juice."
},
new Cocktail
{
Name = "John Collins",
Glass = "highball",
Category = "Longdrink",
Ingredients = "4.5 cl Gin, 3 cl Lemon juice, 1.5 cl Syrup, 6 cl Soda water.",
Garnish = "Lemon slice and a cherry",
Preparation = "Build into highball glass filled with ice. Stir gently. Add a dash of Angostura bitters. (Note: Use Old Tom Gin for Tom Collins)"
},
new Cocktail
{
Name = "Kir",
Glass = "white-wine",
Category = "Before Dinner Cocktail",
Ingredients = "9 cl Dry White Wine, 1 cl Créme liqueur.",
Garnish = "None",
Preparation = "Pour Créme de Cassis into glass, top up with white wine. For Kir Royal: Use champagne instead of white wine."
},
new Cocktail
{
Name = "Mint Julep",
Glass = "highball",
Category = "Longdrink",
Ingredients = "6 cl Whiskey, 4 fresh mint sprigs, 1 teaspoon powdered sugar, 2 teaspoons water.",
Garnish = "Mint sprig",
Preparation = "In a highball glass gently muddle the mint, sugar and water. Fill the glass with cracked ice, add Bourbon and stir well until the glass is frost."
},
new Cocktail
{
Name = "Tommy's Margarita",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "4.5 cl Tequila, 1.5 cl Lime juice, 2 bar spoons of Agave nectar.",
Garnish = "None",
Preparation = "Shake and strain into a chilled cocktail glass."
},
new Cocktail
{
Name = "Paradise",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "3.5 cl Gin, 2 cl Apricot brandy, 1.5 cl Orange juice.",
Garnish = "None",
Preparation = "Shake with ice cubes. Strain into chilled cocktail glass."
},
new Cocktail
{
Name = "Dirty Martini",
Glass = "martini",
Category = "Before Dinner Cocktail",
Ingredients = "6 cl Vodka, 1 cl Vermouth, 1 cl Olive juice.",
Garnish = "Green olive",
Preparation = "Stir in mixing glass with ice cubes. Strain into chilled martini glass."
},
new Cocktail
{
Name = "Champagne Cocktail",
Glass = "champagne-flute",
Category = "Sparkling Cocktail",
Ingredients = "9 cl Champagne, 1 cl Cognac, 2 dashes Angostura Bitters, 1 sugar cube.",
Garnish = "Orange slice and a cherry",
Preparation = "Add dash of Angostura bitter onto sugar cube and drop it into champagne flute. Add cognac followed by pouring gently chilled champagne."
},
new Cocktail
{
Name = "Mary Pickford",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "6 cl White rum, 1 cl Cherry liqueur, 6 cl Pineapple juice, 1 cl Syrup.",
Garnish = "None",
Preparation = "Shake and strain into a chilled large cocktail glass."
},
new Cocktail
{
Name = "Hemingway Special",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "6 cl White rum, 4 cl Grapefruit juice, 1.5 cl Cherry liqueur, 1.5 cl Lime juice.",
Garnish = "None",
Preparation = "Shake with ice cubes. Strain into a double cocktail glass."
},
new Cocktail
{
Name = "Dark 'n' Stormy",
Glass = "highball",
Category = "Longdrink",
Ingredients = "6 cl Dark rum, 10 cl Ginger beer.",
Garnish = "Lime wedge",
Preparation = "Build into highball glass filled with ice. Add rum first and top it with ginger beer."
},
new Cocktail
{
Name = "Ramos Fizz",
Glass = "highball",
Category = "Longdrink",
Ingredients = "4.5 cl Gin, 1.5 cl Lime juice, 1.5 cl Lemon juice, 3 cl Syrup, 6 cl Cream, 1 Egg white, 3 dashes Orange flower water, 2 drops Vanilla extract, Soda water.",
Garnish = "None",
Preparation = "Pour all ingredients (except soda) in a mixing glass, dry shake (no ice) for two minutes, add ice and hard shake for another minute. Strain into a highball glass without ice, top with soda."
},
new Cocktail
{
Name = "Russian Spring Punch",
Glass = "highball",
Category = "Sparkling Cocktail",
Ingredients = "2.5 cl Vodka, 2.5 cl Lemon juice, 1.5 cl Créme liqueur, 1 cl Syrup.",
Garnish = "Lemon slice and a blackberry",
Preparation = "Shake the ingredients and pour into highball glass. Top with Sparkling wine."
},
new Cocktail
{
Name = "God Father",
Glass = "old-fashioned",
Category = "None",
Ingredients = "3.5 cl Whiskey, 3.5 cl DiSaronno.",
Garnish = "None",
Preparation = "Build into old fashioned glass filled with ice cubes. Stir gently."
},
new Cocktail
{
Name = "Cosmopolitan",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "4 cl Vodka, 1.5 cl Triple Sec, 1.5 cl Lime juice, 3 cl Cranberry juice.",
Garnish = "Lime slice",
Preparation = "Shake with ice cubes. Strain into a large cocktail glass."
},
new Cocktail
{
Name = "Dry Martini",
Glass = "martini",
Category = "Before Dinner Cocktail",
Ingredients = "6 cl Gin, 1 cl Vermouth.",
Garnish = "None",
Preparation = "Stir in mixing glass with ice cubes. Strain into chilled martini glass. Squeeze oil from lemon peel onto the drink, or garnish with olive."
},
new Cocktail
{
Name = "Between the Sheets",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "3 cl White rum, 3 cl Cognac, 3 cl Triple Sec, 2 cl Lemon juice.",
Garnish = "None",
Preparation = "Shake with ice cubes. Strain into chilled cocktail glass."
},
new Cocktail
{
Name = "Casino",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "4 cl Gin, 1 cl Cherry liqueur, 1 cl Orange Bitters, 1 cl Lemon juice.",
Garnish = "Lemon twist and a cherry",
Preparation = "Shake with ice cubes. Strain into chilled cocktail glass."
},
new Cocktail
{
Name = "Caipirinha",
Glass = "old-fashioned",
Category = "All Day Cocktail",
Ingredients = "5 cl Cachaca, half fresh lime cut into 4 wedges, 2 teaspoon sugar.",
Garnish = "None",
Preparation = "Place lime and sugar in old fashion glass and muddle. Fill glass with ice and Cachaca (note:Caipiroska- use Vodka instead of Cachaca)."
},
new Cocktail
{
Name = "Vampiro",
Glass = "highball",
Category = "None",
Ingredients = "5 cl Tequila, 7 cl Tomato juice, 3 cl Orange juice, 1 cl Lime juice, 1 teaspoon clear honey, Half slice onion finely chopped, Few slices fresh red hot chili peppers, Few drops Worcestershire sauce, Salt.",
Garnish = "Lime wedge and a green or red chili",
Preparation = "Shake with ice cubes. Strain into a highball glass, filled with ice."
},
new Cocktail
{
Name = "Kamikaze",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "3 cl Vodka, 3 cl Triple Sec, 3 cl Lime juice.",
Garnish = "None",
Preparation = "Shake and strain into a chilled cocktail glass."
},
new Cocktail
{
Name = "White Lady",
Glass = "martini",
Category = "All Day Cocktail",
Ingredients = "4 cl Gin, 3 cl Triple Sec, 2 cl Lemon juice.",
Garnish = "None",
Preparation = "Shake with ice cubes. Strain into large cocktail glass."
},
new Cocktail
{
Name = "Harvey Wallbanger",
Glass = "highball",
Category = "All Day Cocktail",
Ingredients = "4.5 cl Vodka, 1.5 cl Galliano, 9 cl Orange juice.",
Garnish = "Orance slice and a cherry",
Preparation = "Build vodka and orange juice into a highball glass filled with ice. Stir gently and float Galliano on top."
}
);
context.SaveChanges();
}
}
public DrinkController(DrinksContext context)
{
_context = context;
}
