public bool SaveMenuItem(CsMenuItem menuItem)
{
return MenuItemProvider.GetInstance(_connectionString).SaveMenuItem(menuItem) != null;
}
public bool AddMenuItemWithLinkedOptions(CsMenuItem item)
{
if (!Authenticate())
return false;
var sbBuilder = new StringBuilder();
sbBuilder.AppendLine("");
sbBuilder.AppendLine("INSERT INTO [Menu_Item]");
sbBuilder.AppendLine(" ([Name]");
sbBuilder.AppendLine(" ,[PromotText]");
sbBuilder.AppendLine(" ,[IsActive]");
sbBuilder.AppendLine(" ,[Collection_Price]");
sbBuilder.AppendLine(" ,[Delivery_Price]");
sbBuilder.AppendLine(" ,[MultisaveQuantity]");
sbBuilder.AppendLine(" ,[MultiSaveDiscount]");
sbBuilder.AppendLine(" ,[PreparationTime]");
sbBuilder.AppendLine(" ,[Category_Id]");
sbBuilder.AppendLine(" ,[HasSubMenu]");
sbBuilder.AppendLine(" ,[Remarks]");
sbBuilder.AppendLine(" ,[MenuImage]");
sbBuilder.AppendLine(" ,[bHasDressing]");
sbBuilder.AppendLine(" ,[bHasTopping]");
sbBuilder.AppendLine(" ,[bHasBase]");
sbBuilder.AppendLine(" ,[ItemPosition]");
sbBuilder.AppendLine(" ,[Topping_Price]");
sbBuilder.AppendLine(" ,[LargeImage]");
sbBuilder.AppendLine(" ,[Option_ID_1]");
sbBuilder.AppendLine(" ,[Option_ID_2]");
sbBuilder.AppendLine(" ,[ToppingPrice1]");
sbBuilder.AppendLine(" ,[ToppingPrice2]");
sbBuilder.AppendLine(" ,[ToppingPrice3])");
sbBuilder.AppendLine(" VALUES");
sbBuilder.AppendLine(" ('" + item.Name + "'");
sbBuilder.AppendLine(" ,'" + item.PromotionText + "'");
sbBuilder.AppendLine(" ,'" + item.IsActive + "'");
sbBuilder.AppendLine(" ,'" + item.CollectionPrice.ToString("N2") + "'");
sbBuilder.AppendLine(" ,'" + item.DeliveryPrice.ToString("N2") + "'");
sbBuilder.AppendLine(" ," + item.MutilsaveQuantity + "");
sbBuilder.AppendLine(" ,'" + item.MultiSaveDiscount.ToString("N2") + "'");
sbBuilder.AppendLine(" ," + item.PreparationTime + "");
sbBuilder.AppendLine(" ," + item.CategoryID + "");
sbBuilder.AppendLine(" ,'" + item.HasSubMenu + "'");
sbBuilder.AppendLine(" ,'" + item.Remarks + "'");
sbBuilder.AppendLine(" ,'" + item.MenuImage + "'");
sbBuilder.AppendLine(" ,'" + item.HasDressing + "'");
sbBuilder.AppendLine(" ,'" + item.HasTopping + "'");
sbBuilder.AppendLine(" ,'" + item.HasBase + "'");
sbBuilder.AppendLine(" ," + item.ItemPosition + "");
sbBuilder.AppendLine(" ,'" + item.ToppingPrice.ToString("N2") + "'");
sbBuilder.AppendLine(" ,'" + item.LargeImage + "'");
sbBuilder.AppendLine(" ," + item.OptionId1 + "");
sbBuilder.AppendLine(" ," + item.OptionId2 + "");
sbBuilder.AppendLine(" ,'" + item.ToppingPrice1.ToString("N2") + "'");
sbBuilder.AppendLine(" ,'" + item.ToppingPrice2.ToString("N2") + "'");
sbBuilder.AppendLine(" ,'" + item.ToppingPrice3.ToString("N2") + "')");
return ExecuteUpdateQuery(sbBuilder.ToString());
}
