internal bool AddShoppingListAdditionalItem(int menuId, string itemName) { using (DataContext) { try { ShoppingListAdditionalItem additionalItem = new ShoppingListAdditionalItem { MenuId = menuId }; GeneralItem generalItem = DataContext.GeneralItems.SingleOrDefault(gi => gi.GeneralItemName.Trim() == itemName.Trim()); if (generalItem != null) { additionalItem.GeneralItemId = generalItem.GeneralItemId; } else { additionalItem.ItemName = itemName; } DataContext.ShoppingListAdditionalItems.Add(additionalItem); DataContext.SaveChanges(); return(true); } catch { return(false); } } }
protected void AdditionalsItem_DataBound(object sender, RepeaterItemEventArgs e) { RepeaterItem rptItem = e.Item as RepeaterItem; ShoppingListAdditionalItem shopAdditional = (rptItem.DataItem as ShoppingListAdditionalItem); Label name = rptItem.FindControl("lblItemName") as Label; if (shopAdditional.GeneralItem != null) { name.Text = shopAdditional.GeneralItem.GeneralItemName; } else if (shopAdditional.ItemName != null) { name.Text = shopAdditional.ItemName; } }
internal bool DeleteShoppingListAdditionalItem(int itemId) { using (DataContext) { try { ShoppingListAdditionalItem additionalItem = DataContext.ShoppingListAdditionalItems.Single(slai => slai.ShoppingListItemId == itemId); DataContext.ShoppingListAdditionalItems.Remove(additionalItem); DataContext.SaveChanges(); return(true); } catch { return(false); } } }