public void ChangeDescriptionInGoal(int goalId, string description)
 {
     using (GoalContext context = new GoalContext())
     {
         var goal = context.Goals.Where(c => c.Id == goalId).FirstOrDefault();
         if (goal != null)
         {
             goal.Description = description;
             context.SaveChanges();
         }
     }
 }
        public int AddGoal(Domain.Entities.Goal goal)
        {
            Goal g = new Goal();
            g.Name = goal.Name;
            g.FolderId = goal.FolderId;

            using (GoalContext context = new GoalContext())
            {
                context.Goals.Add(g);
                context.SaveChanges();
            }
            return g.Id;
        }
        public int AddSubgoal(Domain.Entities.Subgoal subgoal)
        {
            Subgoal subg = new Subgoal();
            subg.Name = subgoal.Name;
            subg.GoalId = subgoal.GoalId;

            using (GoalContext context = new GoalContext())
            {
                context.Subgoals.Add(subg);
                context.SaveChanges();
            }
            return subg.Id;
        }
        public int AddFolder(Domain.Entities.Folder folder)
        {
            Folder f = new Folder();
            f.Name = folder.Name;
            f.UserId = folder.UserId;
            f.CreatorId = folder.CreatorId;

            using (GoalContext context = new GoalContext())
            {
                context.Folders.Add(f);
                context.SaveChanges();
            }
            return f.Id;
        }
 public void ChangeDueDateInGoal(int goalId, DateTime date)
 {
     using (GoalContext context = new GoalContext())
     {
         var goal = context.Goals.Where(c => c.Id == goalId).FirstOrDefault();
         if (goal != null)
         {
             goal.DueDate = date;
             context.SaveChanges();
         }
     }
 }
 public void DeleteSubgoal(int subgoalId)
 {
     using (GoalContext context = new GoalContext())
     {
         var subgoal = context.Subgoals.Where(c => c.Id == subgoalId).FirstOrDefault();
         if (subgoal != null)
         {
             context.Subgoals.Remove(subgoal);
             context.SaveChanges();
         }
     }
 }
 public void DeleteFolder(int folderId)
 {
     using (GoalContext context = new GoalContext())
     {
         var folder = context.Folders.Where(c => c.Id == folderId).FirstOrDefault();
         if (folder != null)
         {
             context.Folders.Remove(folder);
             context.SaveChanges();
         }
     }
 }
 public void ChangeIsStarredInGoal(int goalId)
 {
     using (GoalContext context = new GoalContext())
     {
         var goal = context.Goals.Where(c => c.Id == goalId).FirstOrDefault();
         if (goal != null)
         {
             goal.IsStarred = !goal.IsStarred;
             context.SaveChanges();
         }
     }
 }
 public void ChangeIsDoneInSubgoal(int subgoalId)
 {
     using (GoalContext context = new GoalContext())
     {
         var subgoal = context.Subgoals.Where(c => c.Id == subgoalId).FirstOrDefault();
         if (subgoal != null)
         {
             subgoal.IsDone = !subgoal.IsDone;
             context.SaveChanges();
         }
     }
 }