public static MenuItemModel Insert(MenuItemModel menuItem)/*,int menuItem, string itemName, * int price,string picture,string description,int menuSectionID)*/ { try { using (RoundTheCornerEntities rc = new RoundTheCornerEntities()) { PL.TblMenuItem newRow = new TblMenuItem() { ItemID = rc.TblMenuItems.Any() ? rc.TblMenuItems.Max(u => u.ItemID) + 1 : 1, ItemName = menuItem.ItemName, MenuID = menuItem.MenuItem, Price = menuItem.Price, Picture = menuItem.Picture, Description = menuItem.Description, MenuSectionID = menuItem.MenuSectionID }; rc.TblMenuItems.Add(newRow); rc.SaveChanges(); menuItem.ItemID = newRow.ItemID; return(menuItem); } } catch (Exception ex) { throw ex; } }
public static bool Insert(string menuItemname, int menuID, decimal price, string picture, int menusectionID, string desc) { try { using (RoundTheCornerEntities rc = new RoundTheCornerEntities()) { PL.TblMenuItem newRow = new TblMenuItem() { ItemID = rc.TblMenuItems.Any() ? rc.TblMenuItems.Max(u => u.ItemID) + 1 : 1, MenuID = menuID, ItemName = menuItemname, Price = price, Picture = picture, Description = desc, MenuSectionID = menusectionID }; rc.TblMenuItems.Add(newRow); rc.SaveChanges(); return(true); } } catch (Exception ex) { throw ex; } }
public static bool Update(MenuItemModel menuItem) { try { if (menuItem.ItemID != 0) { using (RoundTheCornerEntities rc = new RoundTheCornerEntities()) { TblMenuItem TblMenuItem = rc.TblMenuItems.FirstOrDefault(u => u.ItemID == menuItem.ItemID); if (TblMenuItem != null) { TblMenuItem.ItemID = menuItem.ItemID; TblMenuItem.ItemName = menuItem.ItemName; TblMenuItem.Picture = menuItem.Picture; TblMenuItem.Price = menuItem.Price; TblMenuItem.Description = menuItem.Description; TblMenuItem.MenuSectionID = menuItem.MenuSectionID; rc.SaveChanges(); return(true); } else { throw new Exception("Item was not found"); } } } else { throw new Exception("Must have a valid id"); } } catch (Exception ex) { throw ex; } }