public ActionResult DeleteIngredient(long ckId, string Tp, long ingId)
{
// TODO: Add insert logic here
switch (Tp)
{
case "L":
//var MyLiq = (from l in db.CocktailLiquors where l.CocktailId == ckId & l.Id == ingId select l).Single();
CocktailLiquor CokLiq = db.CocktailLiquors.Find(ckId, ingId);
db.CocktailLiquors.Remove(CokLiq);
break;
case "N":
CocktailNoAlcohol CokNoa = db.CocktailNoAlcohols.Find(ckId, ingId);
db.CocktailNoAlcohols.Remove(CokNoa);
//var MyNoA = (from n in db.CocktailNoAlcohols where n.CocktailId == ckId & n.Id == ingId select n).Single();
//db.CocktailNoAlcohols.DeleteObject(MyNoA);
break;
case "C":
//var MyCor = (from c in db.CocktailCordials where c.CocktailId == ckId & c.Id == ingId select c).Single();
//db.CocktailCordials.DeleteObject(MyCor);
CocktailCordial CokCor = db.CocktailCordials.Find(ckId, ingId);
db.CocktailCordials.Remove(CokCor);
break;
case "G":
CockTail CokGar = db.CockTails.Find(ckId);
Garnish Gar = db.Garnishes.Find(ingId);
CokGar.Garnishes.Remove(Gar);
//var MyGar = (from c in db.CocktailGarnishes where c.CocktailId == ckId & c.Id == ingId select c).Single();
//db.CocktailGarnishes.DeleteObject(MyGar);
break;
case "P":
CockTail CokPro = db.CockTails.Find(ckId);
Process Pro = db.Processes.Find(ingId);
CokPro.Processes.Remove(Pro);
//var MyGar = (from c in db.CocktailGarnishes where c.CocktailId == ckId & c.Id == ingId select c).Single();
//db.CocktailGarnishes.DeleteObject(MyGar);
break;
}
db.SaveChanges();
return(null);
}
// helper
public List <CocktailLiquor> ConvertFromStringToCocktailLiquor(CocktailCreate cocktailCreate, Cocktail cocktail)
{
List <CocktailLiquor> cocktailLiquors = new List <CocktailLiquor>();
List <string> liquors = cocktailCreate.LiquorsInCocktail.Split(_separator, StringSplitOptions.RemoveEmptyEntries).ToList();
foreach (string name in liquors)
{
var query =
_context
.Liquors
.Single(e => e.Type == name && e.Subtype == null || e.Subtype == name);
CocktailLiquor junction = new CocktailLiquor()
{
Liquor = query,
Cocktail = cocktail
};
cocktailLiquors.Add(junction);
}
return(cocktailLiquors);
}
