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