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