public ProductVM GetProductDetail(int id)
{
mergedEntities db = new mergedEntities();
ProductVM productVM = new ProductVM();
var query =
from p in db.Products
where (p.productID == id)
select new ProductVM()
//select new
{
ProductId = p.productID,
ProductName = p.productName,
Unit = p.unit,
ProductType = p.producType,
SupplierId = (int)p.supplierID,
Price = (decimal)p.price
};
foreach (var item in query)
{
productVM.ProductId = item.ProductId;
productVM.ProductName = item.ProductName;
productVM.Unit = item.Unit;
productVM.ProductType = item.ProductType;
productVM.SupplierId = item.SupplierId;
productVM.Price = item.Price;
}
return productVM;
}
public ActionResult EditProducts(ProductVM productVM)
{
ProductRepo productRepo = new ProductRepo();
ProductVM editedProductVM = new ProductVM();
if (ModelState.IsValid)
{
editedProductVM = productRepo.UpdateProduct(productVM);
return RedirectToAction("AdminOnly");
}
else
{
ViewBag.ErrorMessage = "This entry is invalid.";
return View(productVM);
}
}
public ProductVM UpdateProduct(ProductVM productVM)
{
mergedEntities db = new mergedEntities();
Product product = db.Products.Where(p => p.productID == productVM.ProductId &&
p.supplierID == productVM.SupplierId).FirstOrDefault();
product.productID = productVM.ProductId;
product.productName = productVM.ProductName;
product.productName = productVM.ProductType;
product.supplierID = productVM.SupplierId;
product.price = productVM.Price;
product.unit = productVM.Unit;
db.SaveChanges();
return productVM;
}
public ActionResult EditProducts(int id)
{
ProductRepo productRepo = new ProductRepo();
ProductVM productVM = new ProductVM();
productVM = productRepo.GetProductDetail(id);
return View(productVM);
}