Exemplo n.º 1
0
        internal SavedListDetail AddListItem(string name, int quantity, int listId)
        {
            Food food = new AdminDA().GetFood(name);

            if (food == null)
            {
                return(null);
            }

            SavedListDetail savedListDetails = (from p in DataContext.SavedListDetails
                                                where p.LIST_ID == listId && p.FOOD_ID == food.FoodId
                                                select p).SingleOrDefault();

            if (savedListDetails == null)
            {
                savedListDetails = new SavedListDetail
                {
                    FOOD_ID             = food.FoodId,
                    LIST_ID             = listId,
                    QUANTITY            = quantity,
                    MEASUREMENT_UNIT_ID = food.CalculateUnitId
                };

                DataContext.SavedListDetails.InsertOnSubmit(savedListDetails);
            }
            else
            {
                savedListDetails.QUANTITY = quantity;
            }

            DataContext.SubmitChanges();

            return(savedListDetails);
        }
Exemplo n.º 2
0
 internal void UpdateSavedListItem(int id, int quantity)
 {
     using (DataContext)
     {
         SavedListDetail savedListDetails = DataContext.SavedListDetails.SingleOrDefault(p => p.ID == id);
         if (savedListDetails != null)
         {
             savedListDetails.QUANTITY = quantity;
             DataContext.SubmitChanges();
         }
     }
 }
Exemplo n.º 3
0
        internal void DeleteListItem(int ingredientId)
        {
            using (DataContext)
            {
                SavedListDetail savedListDetail = (from p in DataContext.SavedListDetails
                                                   where p.ID == ingredientId
                                                   select p).SingleOrDefault();

                DataContext.SavedListDetails.DeleteOnSubmit(savedListDetail);

                bool isEmpty = DataContext.SavedListDetails.Where(p => p.LIST_ID == savedListDetail.LIST_ID).Count() == 1;
                if (isEmpty)
                {
                    SavedList savedList = DataContext.SavedLists.SingleOrDefault(p => p.ID == savedListDetail.LIST_ID);
                    DataContext.SavedLists.DeleteOnSubmit(savedList);
                }

                DataContext.SubmitChanges();
            }
        }
        public string AddSavedListItem(int listId, string itemName, int quantity)
        {
            try
            {
                Food food = BusinessFacade.Instance.GetFood(itemName);
                if (food == null)
                {
                    BusinessFacade.Instance.SaveFood(new Food
                    {
                        FoodName       = itemName,
                        FoodCategoryId = 0
                    });
                }

                SavedListDetail savedListDetail = BusinessFacade.Instance.AddSavedListItem(itemName, quantity, listId);
                string          result          = JsonSerializer <SavedListDetail>(savedListDetail);
                return(result);
            }
            catch
            {
                return(null);
            }
        }