Hello Team,
Please I have 3 tables namely, Category table, product table and quantity table,
at the product page I select the category and then add the product price quantity and price and save it, but it doesn't get save when I try to save the data, kindly help.
public ActionResult SaveItem(ItemViewModel itemModel) { if (itemModel.ItemId > 0) { tblItem objItem = objRestaurantDBEntities.tblItems.Where(a => a.ItemId == itemModel.ItemId).FirstOrDefault<tblItem>(); objItem.CategoryId = itemModel.CategoryId; objItem.CategoryName = itemModel.tblCategory.CategoryName; objItem.ItemName = itemModel.ItemName; objItem.TransactionId = itemModel.QuantityId; objItem.Quantity = itemModel.tblQuantity.Quantity; objItem.ItemPrice = itemModel.ItemPrice; objRestaurantDBEntities.SaveChanges(); objItem.ItemId = itemModel.ItemId; return Json(new { result = true, message = "Product updated successfully...." }, JsonRequestBehavior.AllowGet); } tblItem objItemSave = new tblItem(); objItemSave.CategoryId = itemModel.CategoryId; objItemSave.CategoryName = itemModel.tblCategory.CategoryName; objItemSave.ItemName = itemModel.ItemName; objItemSave.TransactionId = itemModel.QuantityId; objItemSave.Quantity = itemModel.tblQuantity.Quantity; objItemSave.ItemPrice = itemModel.ItemPrice; objRestaurantDBEntities.tblItems.Add(objItemSave); objRestaurantDBEntities.SaveChanges(); return Json(new { result = true, message = "Product save successfully...." }, JsonRequestBehavior.AllowGet); }