public List <HUTModels.Ingredient> GetPerRecipe(int recipeId) { List <HUTModels.Ingredient> ingredients = repo.Get <HUTDataAccessLayerSQL.Ingredient>() .Select(x => new HUTModels.Ingredient() { FoodId = x.FoodId, IngredientId = x.IngredientId, RecipeId = x.RecipeId, Weight = x.Weight }) .Where(y => y.RecipeId == recipeId) .OrderByDescending(z => z.Weight) .ToList(); return(ingredients); }
public List <HUTModels.CalorieCountOffDay> GetDaysOffInDateRange(int personId, DateTime startDate, DateTime endDate) { List <HUTModels.CalorieCountOffDay> counts = repo.Get <CalorieCountOffDay>(c => c.PersonId == personId && c.DateEntered >= startDate.Date && c.DateEntered <= endDate.Date, orderBy: o => o.OrderBy(c => c.DateEntered) ) .Select(x => new HUTModels.CalorieCountOffDay() { CalorieCountOffDayId = x.CalorieCountOffDayId, PersonId = x.PersonId, DateEntered = x.DateEntered.Date }) .ToList(); return(counts); }
public List <HUTModels.Weight> GetByDateRange(int personId, DateTime startDate, DateTime endDate) { List <HUTModels.Weight> weight = repo.Get <Weight>(w => w.PersonId == personId && w.DateEntered >= startDate.Date && w.DateEntered <= endDate.Date, orderBy: o => o.OrderBy(w => w.DateEntered) ) .Select(x => new HUTModels.Weight() { WeightId = x.WeightId, PersonId = x.PersonId, DateEntered = x.DateEntered, WeightAmount = x.WeightAmount }) .ToList(); return(weight); }
public List <HUTModels.CalorieCount> GetByDateRange(int personId, DateTime startDate, DateTime endDate) { List <HUTModels.CalorieCount> counts = repo.Get <CalorieCount>(c => c.PersonId == personId && c.DatetimeEntered >= startDate.Date && c.DatetimeEntered <= endDate.Date, orderBy: o => o.OrderBy(c => c.DatetimeEntered) ) .Select(x => new HUTModels.CalorieCount() { CalorieCountId = x.CalorieCountId, PersonId = x.PersonId, DatetimeEntered = x.DatetimeEntered, Calories = x.Calories }) .ToList(); return(counts); }
public List <HUTModels.Size> GetByDateRange(int personId, DateTime startDate, DateTime endDate) { List <HUTModels.Size> sizes = repo.Get <Size>(s => s.PersonId == personId && s.DateEntered >= startDate.Date && s.DateEntered <= endDate.Date, orderBy: o => o.OrderBy(s => s.DateEntered) ) .Select(x => new HUTModels.Size() { SizeId = x.SizeId, PersonId = x.PersonId, DateEntered = x.DateEntered, Bicep = x.Bicep, Stomach = x.Stomach }) .ToList(); return(sizes); }