// 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"));
}
