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;
}
}
