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