public IngredientDetail GetIngredientbyId(int id) { using (var context = new CookbookContext()) { var entity = context .Ingredients .Single(e => e.ID == id && e.AuthorID == userId); var ingredientDetail = new IngredientDetail { ID = entity.ID, Name = entity.Name, Description = entity.Description, DateCreated = entity.DateCreated, DateModified = entity.DateModified, Amount = entity.Amount, Unit = entity.Unit, TemplateId = entity.TemplateId, }; var TemplateName = context.Larders .SingleOrDefault(l => l.AuthorID == userId && l.ID == entity.TemplateId); if (TemplateName != null) { ingredientDetail.TemplateName = TemplateName.Name.ToString(); } return(ingredientDetail); } }
public int CreateRecipe(RecipeCreate model) { using (var context = new CookbookContext()) { var season = new Season() { AuthorID = userId, Summer = model.Season.Summer, Fall = model.Season.Fall, Winter = model.Season.Winter, Spring = model.Season.Spring }; context.Seasons.Add(season); context.SaveChanges(); var entity = new Recipe() { AuthorID = userId, Name = model.Name, SeasonID = season.ID, Description = model.Description, DateCreated = DateTimeOffset.UtcNow, }; context.Recipes.Add(entity); context.SaveChanges(); return entity.ID; } }
public RecipeDetail GetRecipebyId(int id) { using (var context = new CookbookContext()) { var entity = context .Recipes .Single(e => e.ID == id && e.AuthorID == userId); var ingredients = context .Ingredients .Where(i => i.AuthorID == userId && i.LarderId == id) .Select( i => new IngredientListItem { ID = i.ID, Amount = i.Amount, Unit = i.Unit, Name = i.Name, Description = i.Description } ).ToList(); var actions = context .Actions .Where(a => a.AuthorID == userId && a.LarderId == id) .Select( a => new ActionListItem { ID = a.ID, Description = a.Description } ).ToList(); var platings = GetPlatingsByRecipeId(id); return new RecipeDetail { ID = entity.ID, Name = entity.Name, Description = entity.Description, Ingredients = new IngredientList { LarderId=entity.ID, Ingredients = ingredients }, Actions = new ActionList { LarderId=entity.ID, Directions = actions }, Seasons = entity.Season.GetSeasons(), DateCreated = entity.DateCreated, DateModified = entity.DateModified, Platings = platings }; } }
public bool DeleteLarder(int id) { using (var context = new CookbookContext()) { var entity = context .Larders .Single(e => e.ID == id && e.AuthorID == userId); context.Larders.Remove(entity); return(context.SaveChanges() == 1); } }
public bool UpdateAction(ActionEdit model) { using (var context = new CookbookContext()) { var entity = context .Actions .Single(e => e.ID == model.ID && e.AuthorID == userId); entity.Description = model.Description; return(context.SaveChanges() == 1); } }
public bool CreateAction(ActionCreate model) { var entity = new Data.Models.Action() { AuthorID = userId, Description = model.Description, LarderId = model.LarderID }; using (var context = new CookbookContext()) { context.Actions.Add(entity); return(context.SaveChanges() == 1); } }
public bool UpdateLarder(LarderEdit model) { using (var context = new CookbookContext()) { var entity = context .Larders .Single(e => e.ID == model.ID && e.AuthorID == userId); entity.Name = model.Name; entity.Description = model.Description; entity.DateModified = DateTimeOffset.UtcNow; return(context.SaveChanges() == 1); } }
public List<RecipeListItem> GetRecipesByLarderId(int id) { using (var context = new CookbookContext()) { return context .Recipes .Where(x => x.Ingredients.Any(i => i.TemplateId == id)) .Select( r => new RecipeListItem() { ID = r.ID, Name = r.Name, }).ToList(); } }
public bool CreateLarder(LarderCreate model) { var entity = new LarderModel() { AuthorID = userId, Name = model.Name, Description = model.Description, DateCreated = DateTimeOffset.UtcNow, }; using (var context = new CookbookContext()) { context.Larders.Add(entity); return(context.SaveChanges() == 1); } }
public ActionDetail GetActionById(int id) { using (var context = new CookbookContext()) { var entity = context .Actions .Single(e => e.ID == id && e.AuthorID == userId); return (new ActionDetail { ID = entity.ID, Description = entity.Description }); } }
public void PopulateAssignedMealTypeData(CookbookContext context, Recipe recipe) { var allMealTypes = context.MealTypes; var recipeMealTypes = new HashSet <int>( recipe.RecipeAssignments.Select(m => m.MealTypeID)); AssignedMealTypeDataList = new List <AssignedMealTypeData>(); foreach (var mealType in allMealTypes) { AssignedMealTypeDataList.Add(new AssignedMealTypeData { MealTypeID = mealType.ID, Name = mealType.Name, Assigned = recipeMealTypes.Contains(mealType.ID) }); } }
public bool UpdateIngredient(IngredientEdit model) { using (var context = new CookbookContext()) { var entity = context .Ingredients .Single(e => e.ID == model.ID && e.AuthorID == userId); entity.Name = model.Name; entity.Description = model.Description; entity.Amount = model.Amount; entity.Unit = model.Unit; entity.DateModified = DateTimeOffset.UtcNow; return(context.SaveChanges() == 1); } }
public List<PlatingListItem> GetPlatingsByRecipeId(int id) { using (var context = new CookbookContext()) { return context .Platings .Where(x => x.RecipePlatings.Any(rp => rp.RecipeID == id)) .Select( p => new PlatingListItem() { ID = p.ID, Name = p.Name }) .ToList(); } }
public List<RecipeListItem> GetRecipesByPlatingId(int id) { using (var context = new CookbookContext()) { return context .Recipes .Where(x => x.RecipePlatings.Any(rp => rp.PlatingID == id)) .Select( r => new RecipeListItem() { ID = r.ID, Name = r.Name }) .ToList(); } }
public bool UpdateRecipe(RecipeEdit model) { using (var context = new CookbookContext()) { var entity = context .Recipes .Single(e => e.ID == model.ID && e.AuthorID == userId); entity.Name = model.Name; entity.Description = model.Description; entity.DateModified = DateTimeOffset.UtcNow; if (model.Season.Fall) { entity.Season.Fall = true;} else { entity.Season.Fall = false; } if (model.Season.Spring) { entity.Season.Spring = true;} else { entity.Season.Spring = false; } if (model.Season.Summer) { entity.Season.Summer = true;} else { entity.Season.Summer = false; } if (model.Season.Winter) { entity.Season.Winter = true;} else { entity.Season.Winter = false; } return context.SaveChanges() != 0; } }
public PlatingDetail GetPlatingbyId(int id) { using (var context = new CookbookContext()) { var query = context .Platings .Single(e => e.AuthorID == userId && e.ID == id); return(new PlatingDetail() { ID = query.ID, Name = query.Name, Description = query.Description, DateCreated = query.DateCreated, DateModified = query.DateModified, Recipes = GetRecipesByPlatingId(id) }); } }
public bool CreateIngredient(IngredientCreate model) { var entity = new Ingredient() { AuthorID = userId, Name = model.Name, Description = model.Description, DateCreated = DateTimeOffset.UtcNow, Amount = model.Amount, Unit = model.Unit, LarderId = model.LarderId, }; using (var context = new CookbookContext()) { context.Ingredients.Add(entity); return(context.SaveChanges() == 1); } }
private List <RecipeListItem> GetRecipesByPlatingId(int id) { using (var context = new CookbookContext()) { return(context .RecipePlatings .Where(rp => rp.PlatingID == id) .Select(rp => new RecipeListItem() { ID = rp.RecipeID, Name = context .Recipes .FirstOrDefault(r => r.ID == rp.RecipeID) .Name }) .ToList()); } }
public IEnumerable <ActionListItem> GetActions() { using (var context = new CookbookContext()) { var query = context .Actions .Where(e => e.AuthorID == userId) .Select( e => new ActionListItem { ID = e.ID, Description = e.Description } ); return(query.ToArray()); } }
public IEnumerable <PlatingListItem> GetPlatings() { using (var context = new CookbookContext()) { var query = context .Platings .Where(e => e.AuthorID == userId) .Select( e => new PlatingListItem { ID = e.ID, Name = e.Name, Description = e.Description, } ); return(query.ToArray()); } }
public IEnumerable <LarderListItem> GetLarders() { using (var context = new CookbookContext()) { var query = context .Larders .Where(e => e.AuthorID == userId) .Select( e => new LarderListItem { ID = e.ID, Name = e.Name, Description = e.Description, Season = e.Season } ); return(query.ToArray()); } }
public LarderDetail GetLarderbyId(int id) { using (var context = new CookbookContext()) { var entity = context .Larders .Single(e => e.ID == id && e.AuthorID == userId); var ingredients = context .Ingredients .Where(i => i.AuthorID == userId && i.LarderId == id) .Select( i => new IngredientListItem { ID = i.ID, Amount = i.Amount, Unit = i.Unit, Name = i.Name, Description = i.Description } ); var actions = context .Actions .Where(a => a.AuthorID == userId && a.LarderId == id) return (new LarderDetail { ID = entity.ID, Name = entity.Name, Description = entity.Description, Seasons = entity.Season.GetSeasons(), DateCreated = entity.DateCreated, DateModified = entity.DateModified }); } }
public int CreateLarder(LarderCreate model) { using (var context = new CookbookContext()) { var season = new Season(); if (model.Season == null) { season.AuthorID = userId; season.Summer = false; season.Fall = false; season.Winter = false; season.Spring = false; } else { season.AuthorID = userId; season.Summer = model.Season.Summer; season.Fall = model.Season.Fall; season.Winter = model.Season.Winter; season.Spring = model.Season.Spring; }; context.Seasons.Add(season); context.SaveChanges(); var entity = new LarderModel() { AuthorID = userId, Name = model.Name, SeasonID = season.ID, Description = model.Description, DateCreated = DateTimeOffset.UtcNow, }; context.Larders.Add(entity); context.SaveChanges(); return(entity.ID); } }
public IEnumerable <IngredientListItem> GetIngredients() { using (var context = new CookbookContext()) { var query = context .Ingredients .Where(e => e.AuthorID == userId) .Select( e => new IngredientListItem { ID = e.ID, Name = e.Name, Description = e.Description, Amount = e.Amount, Unit = e.Unit } ); return(query.ToArray()); } }
public bool AddPlating(PlatingAddList model) { using (var context = new CookbookContext()) { var entities = context.RecipePlatings.Where(e => e.RecipeID == model.RecipeId); foreach (var entity in entities) { context.RecipePlatings.Remove(entity); } foreach (var plating in model.Platings) { if (plating.IsIncluded == true) { context.Set <RecipePlating>().Add(new RecipePlating { PlatingID = plating.ID, RecipeID = model.RecipeId }); } } return(context.SaveChanges() != -1); } }
public void UpdateRecipeMealTypes(CookbookContext context, string[] selectedMealTypes, Recipe recipeToUpdate) { if (selectedMealTypes == null) { recipeToUpdate.RecipeAssignments = new List <RecipeAssignment>(); return; } var selectedMealTypesHS = new HashSet <string>(selectedMealTypes); var recipeMealTypes = new HashSet <int>(recipeToUpdate.RecipeAssignments.Select(r => r.Recipe.RecipeID)); foreach (var mealType in context.MealTypes) { if (!selectedMealTypesHS.Contains(mealType.ID.ToString())) { if (!recipeMealTypes.Contains(mealType.ID)) { recipeToUpdate.RecipeAssignments.Add( new RecipeAssignment { RecipeID = recipeToUpdate.RecipeID, MealTypeID = mealType.ID }); } } else { if (recipeMealTypes.Contains(mealType.ID)) { RecipeAssignment mealToRemove = recipeToUpdate .RecipeAssignments .SingleOrDefault(r => r.MealTypeID == mealType.ID); context.Remove(mealToRemove); } } } }
public IngredientRepository(CookbookContext cookbookContext) { _cookbookContext = cookbookContext; }
public KomentarService(CookbookContext context, IMapper mapper) : base(context, mapper) { }
public BaseService(CookbookContext context, IMapper mapper) { _context = context; _mapper = mapper; }
public PreporukaService(CookbookContext context, IMapper mapper) { _context = context; _mapper = mapper; }