public List <Food> GetAll()
{
using (CocktailDBContext context = new CocktailDBContext())
{
return(context.Foods.ToList());
}
}
public List <Ingredient> GetByCocktailName(string cocktailName)
{
using (CocktailDBContext context = new CocktailDBContext())
{
return(context.Ingredients.Where(c => c.CocktailName == cocktailName).ToList());
}
}
public Food Get(string key)
{
using (CocktailDBContext context = new CocktailDBContext())
{
return(context.Foods.Where(c => c.Name == key).FirstOrDefault());
}
}
public List <Ingredient> GetAll()
{
using (CocktailDBContext context = new CocktailDBContext())
{
return(context.Ingredients.ToList());
}
}
public void DeleteAll()
{
using (CocktailDBContext context = new CocktailDBContext())
{
context.Foods.RemoveRange(context.Foods);
context.SaveChanges();
}
}
public void Delete(string key)
{
using (CocktailDBContext context = new CocktailDBContext())
{
Food food = Get(key);
context.Foods.Remove(food);
}
}
public void Create(Food food)
{
using (CocktailDBContext context = new CocktailDBContext())
{
context.Foods.Add(food);
context.SaveChanges();
}
}
public void Create(Ingredient ingredient)
{
using (CocktailDBContext context = new CocktailDBContext())
{
context.Ingredients.Add(ingredient);
context.SaveChanges();
}
}
public void Delete(string key)
{
using (CocktailDBContext context = new CocktailDBContext())
{
Ingredient ingredients = Get(key);
context.Ingredients.Remove(ingredients);
}
}
public void Update(Cocktail cocktail)
{
using (CocktailDBContext context = new CocktailDBContext())
{
context.Update(cocktail);
context.SaveChanges();
}
}
public void DeleteAll()
{
using (CocktailDBContext context = new CocktailDBContext())
{
context.Ingredients.RemoveRange(context.Ingredients);
context.Cocktails.RemoveRange(context.Cocktails);
context.SaveChanges();
}
}
public void Create(Cocktail cocktail)
{
using (CocktailDBContext context = new CocktailDBContext())
{
context.Cocktails.Add(cocktail);
context.Ingredients.AddRange(cocktail.IngredientDescription);
context.SaveChanges();
}
}
public void Delete(string key)
{
using (CocktailDBContext context = new CocktailDBContext())
{
Cocktail cocktail = Get(key);
context.Ingredients.RemoveRange(cocktail.IngredientDescription);
context.Cocktails.Remove(cocktail);
context.SaveChanges();
}
}
public Cocktail Get(string key)
{
using (CocktailDBContext context = new CocktailDBContext())
{
IEnumerable <Cocktail> cocktails = context.Cocktails;
Cocktail cocktail = context.Cocktails.Where(c => c.Name == key).FirstOrDefault();
cocktail = GetIngredientDescription(cocktail);
return(cocktail);
}
}
/// <summary>
/// Used to get cocktails by a contain search
/// </summary>
/// <param name="search">Name of cocktail</param>
public List <Cocktail> GetBySearch(string search)
{
List <Cocktail> cocktails;
using (CocktailDBContext context = new CocktailDBContext())
{
cocktails = context.Cocktails.Where(c => c.Name.Contains(search)).ToList();
}
for (int i = 0; i < cocktails.Count; i++)
{
cocktails[i] = GetIngredientDescription(cocktails[i]);
}
return(cocktails);
}
public List <Cocktail> GetAll()
{
List <Cocktail> cocktails;
using (CocktailDBContext context = new CocktailDBContext())
{
cocktails = context.Cocktails.ToList();
}
for (int i = 0; i < cocktails.Count; i++)
{
cocktails[i] = GetIngredientDescription(cocktails[i]);
}
return(cocktails);
}
