public JsonResult GetProductDetails(int productID) { Class.Product sb = new Class.Product(); var prod = db.Product.Include(o => o.Category).Select(p => new { p.ProductID, p.ProdName, p.Category.CategName, p.Price, p.Stock }).SingleOrDefault(p => p.ProductID == productID); sb.Price = prod.Price; sb.Stock = prod.Stock; return(Json(sb, JsonRequestBehavior.AllowGet)); }
public JsonResult UpdateProduct(Class.Product updateProduct) { Models.Product Product = db.Product.SingleOrDefault(x => x.ProductID == updateProduct.ProductID); Product.CategID = updateProduct.CategID; Product.ProdName = updateProduct.ProdName; Product.Price = updateProduct.Price; Product.Stock = updateProduct.Stock; try { db.SaveChanges(); return(Json(new { isError = "F", message = "Successfully Saved." })); } catch (Exception ex) { return(Json(new { isError = "T", message = "Could not insert data." })); } }
public JsonResult AddProduct(Class.Product New_Product) { Models.Product Product = new Models.Product() { CategID = New_Product.CategID, ProdName = New_Product.ProdName, Price = New_Product.Price, Stock = New_Product.Stock }; try { db.Product.Add(Product); db.SaveChanges(); return(Json(new { isError = "F", message = "Successfully Saved." })); } catch (Exception ex) { return(Json(new { isError = "T", message = "Could not insert data." })); } }