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); }