public ActionResult Create(ItemsModels item)
{
var _item = new Item();
_item.Title = item.Title;
_item.Stock = item.Stock;
var _itemPrice = new ItemPrice();
_itemPrice.Price = item.Price;
_itemPrice.Entered = DateTime.Now;
// TODO: Duplicate Title Check
if (ModelState.IsValid)
{
db.Items.AddObject(_item);
db.SaveChanges();
_itemPrice.ID = _item.ID;
db.ItemPrices.AddObject(_itemPrice);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(item));
}
//
// GET: /Items/
public ViewResult Index()
{
List <ItemsModels> itemList = new List <ItemsModels>();
var items = from x in db.Items
join y in db.ItemPrices on x.ID equals y.ID
select new { x.ID, x.Title, x.Stock, y.Price, y.Entered };
var latest = from n in items
group n by n.ID into g
select g.OrderByDescending(t => t.Entered).FirstOrDefault();
foreach (var i in latest)
{
var item = new ItemsModels();
item.ID = i.ID;
item.Title = i.Title;
item.Stock = i.Stock;
item.Price = i.Price;
item.Entered = i.Entered;
itemList.Add(item);
}
return(View(itemList));
}
