public ActionResult AddProduct(TBLPRODUCTS p1)
{
var ctgr = db.TBLCATEGORIES.Where(m => m.CATEGORYID == p1.TBLCATEGORIES.CATEGORYID).FirstOrDefault();
p1.TBLCATEGORIES = ctgr;
db.TBLPRODUCTS.Add(p1);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult UPDATE(TBLPRODUCTS p)
{
var product = db.TBLPRODUCTS.Find(p.PRODUCTID);
product.PRODUCTNAME = p.PRODUCTNAME;
product.BRAND = p.BRAND;
product.STOCK = p.STOCK;
product.PRICE = p.PRICE;
//product.PRODUCTCATEGORY = p.PRODUCTCATEGORY;
var ctgr = db.TBLCATEGORIES.Where(m => m.CATEGORYID == p.TBLCATEGORIES.CATEGORYID).FirstOrDefault();
product.PRODUCTCATEGORY = ctgr.CATEGORYID;
db.SaveChanges();
return(RedirectToAction("Index"));
}