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 }); } }
public IEnumerable <RecipeModel> List() { using (MyBuyListEntities entities = new MyBuyListEntities()) { return(entities.Recipes.Select(r => new RecipeModel { RecipeId = r.RecipeId, RecipeName = r.RecipeName }).ToList()); } }
public IEnumerable <FoodModel> Ingrediants() { using (MyBuyListEntities entities = new MyBuyListEntities()) { return(entities.Foods.Select(r => new FoodModel { FoodId = r.FoodId, FoodName = r.FoodName }).ToList()); } }
public IEnumerable <FoodModel> List() { using (MyBuyListEntities entities = new MyBuyListEntities()) { return(entities.Foods.Select(item => new FoodModel { FoodId = item.FoodId, FoodName = item.FoodName }).ToList()); } }
void getUser(string token) { using (MyBuyListEntities entities = new MyBuyListEntities()) { User user = entities.Users.SingleOrDefault(p => p.Token == token); if (user != null) { Globals.UserId = user.UserId; } } }
public IEnumerable <UserModel> List() { using (MyBuyListEntities entities = new MyBuyListEntities()) { return(entities.Users.Select(item => new UserModel { Name = item.DisplayName, Email = item.Email, Password = item.Password }).ToList()); } }
public FoodModel Single(int id) { using (MyBuyListEntities entities = new MyBuyListEntities()) { Food food = entities.Foods.FirstOrDefault(item => item.FoodId == id); return(new FoodModel { FoodId = food.FoodId, FoodName = food.FoodName }); } }
public IEnumerable <FoodModel> Partial(string pre) { using (MyBuyListEntities entities = new MyBuyListEntities()) { return(entities.Foods //.TakeWhile(item => item.FoodName.IndexOf(prefix) != -1) .Select(item => new FoodModel { FoodId = item.FoodId, FoodName = item.FoodName }).ToList()); } }
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[] GetAll() { using (MyBuyListEntities entities = new MyBuyListEntities()) { return((from a in entities.UserShoppingLists where a.USER_ID == Globals.UserId select new ListModel { ownerId = a.USER_ID, itemId = a.FOOD_ID, itemName = a.FOOD_NAME, itemUnit = a.MEASUREMENT_NAME, itemUnitId = a.MEASURMENT_ID.Value, value = a.QUANTITY.Value }).ToArray()); } }
public override ListModel[] GetAll() { using (MyBuyListEntities entities = new MyBuyListEntities()) { var result = (from a in entities.MissingLists join b in entities.MissingListDetails on a.ID equals b.LIST_ID where a.CREATED_BY == Globals.UserId.Value select new ListModel { ownerId = a.CREATED_BY, itemId = b.Food.FoodId, itemName = b.Food.FoodName, itemUnit = b.MeasurementUnit.UnitName, value = b.QUANTITY }).ToArray(); return(result); }; }
public RecipeModel ById(int id) { try { using (MyBuyListEntities entities = new MyBuyListEntities()) { IQueryable <Ingredient> ingredient = entities.Ingredients.Where(p => p.RecipeId == id); List <IngrediantModel> ingModelList = new List <IngrediantModel>(); ingredient.ToList().ForEach(p => { ingModelList.Add(new IngrediantModel { Name = p.Food.FoodName, Measure = p.MeasurementUnit.UnitName, Quantity = p.Quantity }); }); Recipe recipe = entities.Recipes.FirstOrDefault(r => r.RecipeId == id); if (recipe != null) { return(new RecipeModel { RecipeId = recipe.RecipeId, RecipeName = recipe.RecipeName, Ingrediants = ingModelList, PreparationMethod = recipe.PreparationMethod }); } else { return(null); } } } catch { return(null); } }
public string Login([FromBody] LoginInfo login) { using (MyBuyListEntities entities = new MyBuyListEntities()) { User user = entities.Users.FirstOrDefault(p => p.Name == login.userName && p.Password == login.password); if (user != null) { Globals.UserId = user.UserId; string token = Convert.ToBase64String(Encoding.ASCII.GetBytes(string.Format("{0}:{1}", login.userName, login.password))); user.Token = token; entities.SaveChanges(); return(token); } else { return(null); } } }
public Response GetUnits() { try { using (MyBuyListEntities entities = new MyBuyListEntities()) { return(new SuccessResponse <UnitModel[]> { results = entities.MeasurementUnits.Select(item => new UnitModel { unitId = item.UnitId, unitName = item.UnitName }).ToArray() }); } } catch (Exception e) { throw new Exception(e.Message); } }
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 Response Search(string searchValue) { try { using (MyBuyListEntities entities = new MyBuyListEntities()) { return(new SuccessResponse <FoodModel[]> { results = (from a in entities.Foods where a.FoodName.Contains(searchValue) select new FoodModel { FoodId = a.FoodId, FoodName = a.FoodName }).ToArray() }); } } catch (Exception e) { throw new Exception(e.Message); } }
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(); } } }