public ActionResult Edit(int id)
{
lab6_2.Areas.admin.Models.shopEntities db = new Models.shopEntities();
lab6_2.Areas.admin.Models.Product item = db.Product.Find(id);
ViewBag.item = item;
return(View());
}
public ActionResult Del(int id)
{
var product = new lab6_2.Areas.admin.Models.Product()
{
Id = id
};
lab6_2.Areas.admin.Models.shopEntities db = new Models.shopEntities();
db.Product.Attach(product);
db.Product.Remove(product);
db.SaveChanges();
return(RedirectToAction("/admin/Shop/Index"));
}
public ActionResult Index(String search = "", String order = "")
{
lab6_2.Areas.admin.Models.shopEntities db = new Models.shopEntities();
List <lab6_2.Areas.admin.Models.Product> lst = null;
if (search == "")
{
switch (order)
{
case "Id":
lst = db.Product.OrderBy(m => m.Id).ToList();
break;
case "Name":
lst = db.Product.OrderBy(m => m.Name).ToList();
break;
case "Price":
lst = db.Product.OrderBy(m => m.Price).ToList();
break;
default:
lst = db.Product.OrderBy(m => m.StockNum).ToList();
break;
}
}
else
{
switch (order)
{
case "Id":
lst = db.Product.Where(m => m.Name.Contains(search)).OrderBy(m => m.Id).ToList();
break;
case "Name":
lst = db.Product.Where(m => m.Name.Contains(search)).OrderBy(m => m.Name).ToList();
break;
case "Price":
lst = db.Product.Where(m => m.Name.Contains(search)).OrderBy(m => m.Price).ToList();
break;
default:
lst = db.Product.Where(m => m.Name.Contains(search)).OrderBy(m => m.StockNum).ToList();
break;
}
}
ViewBag.lst = lst;
ViewBag.search = search;
return(View());
}
public ActionResult Check(string LoginName, string PWD)
{
lab6_2.Areas.admin.Models.shopEntities db = new Models.shopEntities();
List <lab6_2.Areas.admin.Models.User> lst = db.User.Where(m => m.LoginName == LoginName && m.PWD == PWD).ToList();
if (lst.Count >= 1)
{
FormsAuthentication.SetAuthCookie(LoginName, false);
return(Redirect("/admin/Shop/Index"));
}
else
{
return(Redirect("/admin/Login/Index?message=error"));
}
}
public ActionResult EditSave(decimal Price, string ProductName, int Amount, int ProductId)
{
lab6_2.Areas.admin.Models.shopEntities db = new Models.shopEntities();
lab6_2.Areas.admin.Models.Product item = db.Product.Find(ProductId);
item.Name = ProductName;
item.Price = Price;
item.StockNum = Amount;
var file = Request.Files["pic"];
if (file.ContentLength != 0)
{
String path = Server.MapPath("/upload/");
String filepath = Guid.NewGuid().ToString() + ".jpg";
System.IO.File.Delete(path + item.Pic);
file.SaveAs(path + filepath);
item.Pic = filepath;
}
db.SaveChanges();
return(RedirectToAction("/admin/Shop/Index"));
}
