public ActionResult Edit(int id)
{
QuanLySanPhamDataContext context = new QuanLySanPhamDataContext();
Product product = context.Products.FirstOrDefault(x => x.Id == id);
if (Request.Form.Count == 0)
{
return(View(product));
}
string productCode = Request.Form["ProductCode"];
string catalogId = Request.Form["CatalogId"];
string unitPrice = Request.Form["UnitPrice"];
string productName = Request.Form["ProductName"];
product.ProductCode = productCode;
product.CatalogId = int.Parse(catalogId);
product.UnitPrice = double.Parse(unitPrice);
product.ProductName = productName;
HttpPostedFileBase file = Request.Files["Picture"];
if (file != null)
{
string serverPath = HttpContext.Server.MapPath("~/Images");
string filePath = serverPath + "/" + file.FileName;
file.SaveAs(filePath);
product.Picture = file.FileName;
}
context.SubmitChanges();
return(RedirectToAction("Index"));
}
public ActionResult CTSP_SP(int id)
{
QuanLySanPhamDataContext context = new QuanLySanPhamDataContext();
CTSPResult sp = context.CTSP(id).FirstOrDefault();
return(View(sp));
}
public ActionResult Details(int id)
{
QuanLySanPhamDataContext context = new QuanLySanPhamDataContext();
Product p = context.Products.FirstOrDefault(x => x.Id == id);
return(View(p));
}
public ActionResult SanPhams(int catalogId)
{
QuanLySanPhamDataContext context = new QuanLySanPhamDataContext();
List <Product> dsProducts = context.Products.Where(x => x.CatalogId == catalogId).ToList();
return(View(dsProducts));
}
// GET: Catalog
public ActionResult Index()
{
QuanLySanPhamDataContext context = new QuanLySanPhamDataContext();
List <Catalog> dsCatalog = context.Catalogs.ToList();
return(View(dsCatalog));
}
public ActionResult DanhSachSanPhamChonLoc()
{
QuanLySanPhamDataContext context = new QuanLySanPhamDataContext();
List <ProductForDisplay> dsProduct = context.Products.Select(x => new ProductForDisplay()
{
ProductCode = x.ProductCode,
ProductName = x.ProductName
}).ToList();
return(View(dsProduct));
}
public ActionResult Delete(int id)
{
QuanLySanPhamDataContext context = new QuanLySanPhamDataContext();
Product product = context.Products.FirstOrDefault(x => x.Id == id);
if (product != null)
{
context.Products.DeleteOnSubmit(product);
context.SubmitChanges();
}
return(RedirectToAction("Index"));
}
// GET: Product
public ActionResult Index()
{
QuanLySanPhamDataContext context = new QuanLySanPhamDataContext();
List <Product> dsProduct = null;
if (Request.QueryString.Count == 0)
{
dsProduct = context.Products.ToList();
}
else
{
double min = double.Parse(Request.QueryString["txtMin"]);
double max = double.Parse(Request.QueryString["txtMax"]);
dsProduct = context.Products.Where(x => x.UnitPrice >= min && x.UnitPrice <= max).ToList();
}
return(View(dsProduct));
}
public ActionResult Edit(int id)
{
QuanLySanPhamDataContext context = new QuanLySanPhamDataContext();
Catalog catalog = context.Catalogs.FirstOrDefault(x => x.Id == id);
if (Request.Form.Count == 0)
{
return(View(catalog));
}
string catalogCode = Request.Form["CatalogCode"];
string catalogName = Request.Form["CatalogName"];
catalog.CatalogCode = catalogCode;
catalog.CatalogName = catalogName;
context.SubmitChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create()
{
if (Request.Form.Count > 0)
{
string catalogCode = Request.Form["CatalogCode"];
string catalogName = Request.Form["CatalogName"];
QuanLySanPhamDataContext context = new QuanLySanPhamDataContext();
Catalog catalog = new Catalog();
catalog.CatalogCode = catalogCode;
catalog.CatalogName = catalogName;
context.Catalogs.InsertOnSubmit(catalog);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
return(View());
}
