public ActionResult DeleteConfirmed(long id)
{
CockTail cocktail = db.CockTails.Find(id);
db.CockTails.Remove(cocktail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(long id)
{
CockTail cocktail = db.CockTails.Find(id);
GetAllIngredients();
MyCoctailIngredient.CocktailId = (int)id;
MyCoctailIngredient.Name = cocktail.Name;
return(PartialView("Edit", MyCoctailIngredient));
}
public ActionResult SeeCocktailNoAjx(string name)
{
name = name.Replace("_", " ");
CockTail cockTail = db.CockTails.Where(c => c.Name == name).FirstOrDefault();
//CockTail cocktail = db.CockTails.Find(id);
long id = cockTail.CocktailId;
ViewBag.Title = cockTail.Name;
return(View("SeeCocktailNoAjxPd", GetRecipe(id)));
}
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);
}
public ActionResult Create(FormCollection collection)
{
if (ModelState.IsValid)
{
//var c = db.CockTails.Last().CocktailId;
//var cId = c.CocktailId;
CockTail myCok = new CockTail {
Name = collection["Name"]
};
db.CockTails.Add(myCok);
db.SaveChanges();
myCok = this.InsertAllIngredients(collection["Liquors"], collection["NoAlcohols"], collection["Garnishes"], collection["Cordials"], collection["Glass"], collection["Process"], collection["Categories"], myCok);
db.CockTails.Find(myCok.CocktailId);
db.Entry(myCok).State = EntityState.Modified;
db.SaveChanges();
//db.CockTails.Add(myCok);
//db.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
public CockTail InsertAllIngredients(string liq, string NoA, string gar, string cor, string gla, string pro, string cat, CockTail Coc)
{
// Liquor
if (liq != null)
{
var Myliq = this.MyStringToInteger(liq);
for (var i = 0; i < Myliq.Length; i++)
{
Coc.CocktailLiquors.Add(new CocktailLiquor {
CocktailId = Coc.CocktailId, Id = Myliq[i]
});
}
}
// No Alcohols
if (NoA != null)
{
var MyNoA = this.MyStringToInteger(NoA);
for (var i = 0; i < MyNoA.Length; i++)
{
Coc.CocktailNoAlcohols.Add(new CocktailNoAlcohol {
CocktailId = Coc.CocktailId, Id = MyNoA[i]
});
}
}
// Cordials
if (cor != null)
{
var Mycor = this.MyStringToInteger(cor);
for (var i = 0; i < Mycor.Length; i++)
{
Coc.CocktailCordials.Add(new CocktailCordial {
CocktailId = Coc.CocktailId, Id = Mycor[i]
});
}
}
// Garnishes
if (gar != null)
{
var Mygar = this.MyStringToInteger(gar);
for (var i = 0; i < Mygar.Length; i++)
{
Coc.Garnishes.Add(db.Garnishes.Find(Mygar[i]));
}
}
// Processes
if (pro != null)
{
var Mypro = this.MyStringToInteger(pro);
for (var i = 0; i < Mypro.Length; i++)
{
Coc.Processes.Add(db.Processes.Find(Mypro[i]));
}
}
// Glass
Coc.GlassId = Convert.ToInt16(gla);
// Categories
Coc.CategoryId = Convert.ToInt16(cat);
// Coc.ProcessId = Convert.ToInt16(pro);
return(Coc);
}
public ActionResult Delete(long id)
{
CockTail cocktail = db.CockTails.Find(id);
return(View(cocktail));
}
//public ViewResult Find()
//{
// var MyL = from c in db.CockTails.ToList() select new SelectListItem { Value = c.CocktailId.ToString(), Text = c.Name };
// MyCocktailSumary.Cocktails = MyL;
// return View(MyCocktailSumary);
//}
//
// GET: /Cocktail/Details/5
public ViewResult Details(long id)
{
CockTail cocktail = db.CockTails.Find(id);
return(View(cocktail));
}
