public ActionResult DeleteConfirmed(int id) { tblItem tblItem = db.tblItems.Find(id); db.tblItems.Remove(tblItem); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit2([Bind(Include = "ItemID,ColletionID,ItemName,ItemBeschrijving,ItemOwned,ItemState,BuyPrice,CurrentPrice,Status,StatusBeschrijving")] tblItem tblItem) { if (ModelState.IsValid) { db.Entry(tblItem).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ColletionID = new SelectList(db.tblCollections, "CollectionID", "CollectionName", tblItem.ColletionID); return(View(tblItem)); }
public ActionResult Create([Bind(Include = "ItemID,ColletionID,ItemName,ItemBeschrijving,ItemOwned,ItemState,BuyPrice,CurrentPrice")] tblItem tblItem) { tblItem.Status = "Te Accorderen creatie"; if (ModelState.IsValid) { db.tblItems.Add(tblItem); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ColletionID = new SelectList(db.tblCollections, "CollectionID", "CollectionName", tblItem.ColletionID); return(View(tblItem)); }
// GET: tblItems/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblItem tblItem = db.tblItems.Find(id); if (tblItem == null) { return(HttpNotFound()); } return(View(tblItem)); }
// GET: tblItems/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblItem tblItem = db.tblItems.Find(id); if (tblItem == null) { return(HttpNotFound()); } ViewBag.ColletionID = new SelectList(db.tblCollections, "CollectionID", "CollectionName", tblItem.ColletionID); return(View(tblItem)); }
// GET: tblCategories public ActionResult Index(int?id) { var viewModel = new CollectionViewModel(); string query = "SELECT tblCategory.CategoryID, tblCategory.CategoryName, tblCategory.CategoryBeschrijving, tblCategory.Status, tblCategory.StatusBeschrijving FROM tblCategory LEFT JOIN tblItemCategory ON tblCategory.CategoryID = tblItemCategory.CategoryID WHERE tblItemCategory.ItemCategoryID IS NULL"; using (CollectionContext context = new CollectionContext()) { var list = context.Database.SqlQuery <tblCategory>(query).ToList(); viewModel.tblCategory = list; //return View(viewModel); } string query2 = "SELECT tblCategory.CategoryID, tblCategory.CategoryName, tblCategory.CategoryBeschrijving, tblCategory.Status, tblCategory.StatusBeschrijving, SUM(tblItem.BuyPrice) AS TotalBuyPrice, SUM(tblItem.CurrentPrice) AS TotalCurrentPrice, SUM(tblItem.CurrentPrice) - SUM(tblItem.BuyPrice) AS TotalPriceDiffrence FROM tblCategory INNER JOIN tblItemCategory ON tblCategory.CategoryID = tblItemCategory.CategoryID INNER JOIN tblItem ON tblItemCategory.ItemID = tblItem.ItemID GROUP BY tblCategory.CategoryID,tblCategory.CategoryName,tblCategory.CategoryBeschrijving,tblCategory.Status,tblCategory.StatusBeschrijving"; using (CollectionContext context = new CollectionContext()) { var list2 = context.Database.SqlQuery <tblCategoryTotals>(query2).ToList(); viewModel.tblCategoryTotals = list2; //return View(viewModel); } //viewModel.tblCategory = list; if (id != null) { viewModel.tblItem = db.tblItems; var items = new List <tblItem>(); tblItem eenItem = new tblItem(); viewModel.tblItemCategory = db.tblCategories.Where(i => i.CategoryID == id.Value).Single().tblItemCategories; foreach (tblItemCategory pp in viewModel.tblItemCategory) { eenItem = (tblItem)db.tblItems.Where(i => i.ItemID == pp.ItemID).Single(); items.Add(eenItem); } viewModel.tblItem = items; } return(View(viewModel)); }