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