// GET: Produts public ActionResult AddProduct() { var products = new List <ProductModel>(); using (WMEntities db = new WMEntities()) { var dbProducts = db.Products; foreach (var item in dbProducts) { products.Add(new ProductModel() { Id = item.Id, Name = item.Name, Price = item.Price, Producer = item.Producer, ProductCategoryName = item.ProductCategory?.Name, ProductCategoryId = item.ProductCategoryId, Supplier = item.Supplier }); } } ProductModel.Products = products; return(View(ProductModel)); }
private List <ProductCategory> GetProductCategories() { var result = new List <ProductCategory>(); using (WMEntities db = new WMEntities()) { result = db.ProductCategories.ToList(); } return(result); }
public ActionResult EditProductAction(AddProductModel pm) { using (WMEntities db = new WMEntities()) { var p = db.Products.Where(x => x.Id == pm.Id).FirstOrDefault(); p.Name = pm.Name; p.Price = pm.Price; p.Producer = pm.Producer; p.ProductCategoryId = pm.CategoryId; p.Supplier = pm.Supplier; db.SaveChanges(); } return(Json("OK")); }
public ActionResult AddProductAction(AddProductModel pm) { using (WMEntities db = new WMEntities()) { db.Products.Add(new Product() { Name = pm.Name, Price = pm.Price, Producer = pm.Producer, ProductCategoryId = pm.CategoryId, Supplier = pm.Supplier }); db.SaveChanges(); } return(Json("OK")); }