public ActionResult PriceDown_Each(int?id)
{
var db = new FabricsEntities();
db.Database.ExecuteSqlCommand("UPDATE dbo.Product SET Price=Price-1 WHERE ProductId=" + id);
return(RedirectToAction("Top10"));
}
public ActionResult PriceUp()
{
var db = new FabricsEntities();
foreach (var item in db.Product)
{
item.Price += 1;
}
db.SaveChanges();
//db.Database.ExecuteSqlCommand("UPDATE dbo.Product SET Price=Price+1");
return(RedirectToAction("Top10"));
}
public ActionResult PriceUp_Each(int?id)
{
var db = new FabricsEntities();
foreach (var item in db.Product)
{
if (null != id && id == item.ProductId)
{
item.Price += 1;
}
}
db.SaveChanges();
return(RedirectToAction("Top10"));
}
public ActionResult TOP10()
{
var db = new FabricsEntities();
var result = db.Product.Take(10);
// LINQ ( C# 3.0 )
//var data = from p in result
// select new ProductCreationVM()
// {
// ProductId = p.ProductId,
// ProductName = p.ProductName,
// Price = p.Price,
// OrderLineCount = p.OrderLine.Count()
// };
//var data = "SELECT * FROM table WHERE ...";
var data = db.Database.SqlQuery <ProductCreationVM>(
"SELECT TOP 10*, OrderLineCount=(SELECT COUNT(*) FROM dbo.OrderLine o WHERE o.ProductId=p.ProductId) FROM dbo.Product p");
return(View(data));
}