public ActionResult Create([Bind(Include = "Name,Price,CoffeeIds")] Bean bean, string[] CoffeeIds)
{
if (ModelState.IsValid)
{
Bean checkbean = db.Beans.SingleOrDefault(x => x.Name == bean.Name);
if (checkbean == null)
{
db.Beans.Add(bean);
db.SaveChanges();
}
if (CoffeeIds != null)
{
foreach (string coffeeId in CoffeeIds)
{
Models.CoffeeBean coffeeBean = new Models.CoffeeBean();
coffeeBean.BeanId = bean.BeanId;
coffeeBean.CoffeeId = coffeeId;
bean.Coffees.Add(coffeeBean);
}
db.Entry(bean).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Duplicate Bean detected.");
}
ViewBag.Coffees = new MultiSelectList(db.Coffees.ToList(), "CoffeeId", "Name", CoffeeIds);
return(View(bean));
}
public ActionResult Create([Bind(Include = "Name,Price, BeanIds")] Coffee coffee, string[] BeanIds)
{
if (ModelState.IsValid)
{
Coffee checkCoffee = db.Coffees.SingleOrDefault(x => x.Name == coffee.Name);
if (checkCoffee == null)
{
//coffee.CoffeeId = Guid.NewGuid().ToString();
db.Coffees.Add(coffee);
db.SaveChanges();
if (BeanIds != null)
{
foreach (string beanId in BeanIds)
{
Models.CoffeeBean coffeeBean = new Models.CoffeeBean();
coffeeBean.CoffeeId = coffee.CoffeeId;
coffeeBean.BeanId = beanId;
coffee.Beans.Add(coffeeBean);
}
db.Entry(coffee).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Duplicate Coffee detected.");
}
}
ViewBag.Beans = new MultiSelectList(db.Beans.ToList(), "BeanId", "Name", BeanIds);
return(View(coffee));
}
public ActionResult DeleteConfirmed(string id)
{
Models.CoffeeBean coffeeBean = db.CoffeeBeans.Find(id);
db.CoffeeBeans.Remove(coffeeBean);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "BeanId,Name,Price,CoffeeIds")] Bean bean, string[] CoffeeIds)
{
if (ModelState.IsValid)
{
Bean tmpBean = db.Beans.Find(bean.BeanId);
if (tmpBean != null)
{
Bean checkBean = db.Beans.SingleOrDefault(x => x.Name == bean.Name && x.BeanId != bean.BeanId);
if (checkBean == null)
{
tmpBean.Name = bean.Name;
tmpBean.EditDate = DateTime.Now;
tmpBean.Price = bean.Price;
db.Entry(tmpBean).State = EntityState.Modified;
//items to remove
var removeItems = tmpBean.Coffees.Where(x => !CoffeeIds.Contains(x.CoffeeId)).ToList();
foreach (var removeItem in removeItems)
{
db.Entry(removeItem).State = EntityState.Deleted;
}
//items to add
if (CoffeeIds != null)
{
var addItems = CoffeeIds.Where(x => !tmpBean.Coffees.Select(y => y.CoffeeId).Contains(x));
foreach (var addItem in addItems)
{
Models.CoffeeBean coffeeBean = new Models.CoffeeBean();
coffeeBean.CoffeeBeanId = Guid.NewGuid().ToString();
coffeeBean.CreateDate = DateTime.Now;
coffeeBean.EditDate = coffeeBean.CreateDate;
coffeeBean.BeanId = tmpBean.BeanId;
coffeeBean.CoffeeId = addItem;
db.CoffeeBeans.Add(coffeeBean);
}
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Duplicate Bean detected.");
}
}
}
//ViewBag.GenreId = new SelectList(db.Genres, "GenreId", "Name", game.GenreId);
ViewBag.Genres = new MultiSelectList(db.Coffees.ToList(), "CoffeeId", "Name", CoffeeIds);
return(View(bean));
}
// GET: CoffeeBeans/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Models.CoffeeBean coffeeBean = db.CoffeeBeans.Find(id);
if (coffeeBean == null)
{
return(HttpNotFound());
}
return(View(coffeeBean));
}
// GET: CoffeeBeans/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Models.CoffeeBean coffeeBean = db.CoffeeBeans.Find(id);
if (coffeeBean == null)
{
return(HttpNotFound());
}
ViewBag.BeanId = new SelectList(db.Beans, "BeanId", "Name", coffeeBean.BeanId);
ViewBag.CoffeeId = new SelectList(db.Coffees, "CoffeeId", "Name", coffeeBean.CoffeeId);
return(View(coffeeBean));
}
public ActionResult Edit([Bind(Include = "CoffeeBeanId,CoffeeId,BeanId,CreateDate,EditDate")] Models.CoffeeBean coffeeBean)
{
if (ModelState.IsValid)
{
var tmpCoffeeBean = db.CoffeeBeans.Find(coffeeBean.CoffeeBeanId);
tmpCoffeeBean.EditDate = DateTime.Now;
tmpCoffeeBean.BeanId = coffeeBean.BeanId;
tmpCoffeeBean.CoffeeId = coffeeBean.CoffeeId;
db.Entry(tmpCoffeeBean).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BeanId = new SelectList(db.Beans, "BeanId", "Name", coffeeBean.BeanId);
ViewBag.CoffeeId = new SelectList(db.Coffees, "CoffeeId", "Name", coffeeBean.CoffeeId);
return(View(coffeeBean));
}
public ActionResult Create([Bind(Include = "CoffeeBeanId,CoffeeId,BeanId,CreateDate,EditDate")] Models.CoffeeBean coffeeBean)
{
if (ModelState.IsValid)
{
Models.CoffeeBean tmpCoffeeBean = db.CoffeeBeans.SingleOrDefault(y => y.BeanId == coffeeBean.BeanId && y.CoffeeId == coffeeBean.CoffeeId && y.CoffeeBeanId == coffeeBean.CoffeeBeanId);
if (tmpCoffeeBean == null)
{
coffeeBean.CoffeeBeanId = Guid.NewGuid().ToString();
coffeeBean.CreateDate = DateTime.Now;
coffeeBean.EditDate = coffeeBean.CreateDate;
db.CoffeeBeans.Add(coffeeBean);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Duplicate entry found");
}
}
ViewBag.BeanId = new SelectList(db.Beans, "BeanId", "Name", coffeeBean.BeanId);
ViewBag.CoffeeId = new SelectList(db.Coffees, "CoffeeId", "Name", coffeeBean.CoffeeId);
return(View(coffeeBean));
}
