public async Task <IActionResult> Post(UserShoppingList userIngredient)
{
_context.Add(userIngredient);
await _context.SaveChangesAsync();
return(Ok(userIngredient));
}
public async Task <IActionResult> Put(UserShoppingList userIngredient)
{
_context.Entry(userIngredient).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(NoContent());
}
public override ListModel partialUpdate(int foodId, ListModel data)
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
UserShoppingList list = entities.UserShoppingLists.FirstOrDefault(item => item.USER_ID == Globals.UserId.Value && item.FOOD_ID == foodId);
List <PropertyInfo> listProperties = list.GetType().GetProperties().ToList();
foreach (var dataProp in data.GetType().GetProperties())
{
var dataPropValue = dataProp.GetValue(data);
if (dataPropValue != null && dataProp.Name != "version")
{
var listProp = listProperties.Find(item => item.Name == ListMapping[dataProp.Name]);
if (listProp != null)
{
listProp.SetValue(list, dataPropValue);
}
}
}
entities.SaveChanges();
return(new ListModel
{
ownerId = Globals.UserId.Value,
itemId = list.FOOD_ID,
itemName = list.FOOD_NAME,
itemUnit = list.MEASUREMENT_NAME,
value = list.QUANTITY.Value
});
}
}
void items_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType != ListItemType.Header)
{
UserShoppingList userShoppingList = (UserShoppingList)e.Item.DataItem;
bool canDelete = userShoppingList.CAN_DELETE.HasValue ? userShoppingList.CAN_DELETE.Value : false;
PlaceHolder canDeletePlaceHolder = (PlaceHolder)e.Item.FindControl("PlaceHolder1");
canDeletePlaceHolder.Visible = canDelete;
}
}
internal void CheckShoppingListItem(int userId, int foodId, bool active)
{
UserShoppingList userShoppingList = DataContext.UserShoppingLists.SingleOrDefault(p => p.USER_ID == userId && p.FOOD_ID == foodId);
if (userShoppingList != null)
{
userShoppingList.ACTIVE = active;
}
DataContext.SaveChanges();
}
public override bool Delete(int foodId)
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
UserShoppingList list = entities.UserShoppingLists.SingleOrDefault(item => item.USER_ID == Globals.UserId && item.FOOD_ID == foodId);
if (list != null)
{
entities.UserShoppingLists.Remove(list);
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
};
}
public override ListModel GetSingle(int foodId)
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
UserShoppingList list = entities.UserShoppingLists.SingleOrDefault(item => item.USER_ID == Globals.UserId.Value && item.FOOD_ID == foodId);
if (list != null)
{
return(new ListModel
{
ownerId = Globals.UserId.Value,
itemId = list.FOOD_ID,
itemName = list.FOOD_NAME,
itemUnit = list.MEASUREMENT_NAME,
value = list.QUANTITY.Value
});
}
else
{
return(new ListModel());
}
}
}
public override void Add(ListModel data)
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
Food food = entities.Foods.Where(item => item.FoodId == data.itemId).SingleOrDefault();
if (food != null)
{
UserShoppingList _new = new UserShoppingList
{
FOOD_ID = food.FoodId,
FOOD_NAME = food.FoodName,
CATEGORY_ID = food.FoodCategoryId,
CATEGORY_NAME = food.FoodCategory.FoodCategoryName,
QUANTITY = 0,
USER_ID = Globals.UserId.Value,
ACTIVE = true,
CAN_DELETE = true
};
entities.UserShoppingLists.Add(_new);
entities.SaveChanges();
}
}
}
