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 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 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 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 IEnumerable<Domain.Entities.Goal> SearchGoalsByName(string substring) { List<Skeleton.Domain.Entities.Goal> result = new List<Domain.Entities.Goal>(); System.Data.SqlClient.SqlParameter param = new System.Data.SqlClient.SqlParameter("@str", substring); param.SqlDbType = System.Data.SqlDbType.NVarChar; using (GoalContext context = new GoalContext()) { var goals = context.Database.SqlQuery<Model.Goal>("select * from goals where name like '%'+@str+'%'", param); //var goals = context.Database.SqlQuery<Model.Goal>("SearchSubstring @str", param); foreach (var item in goals) { result.Add(new Domain.Entities.Goal() { Id = item.Id, Name = item.Name, Description = item.Description, DueDate = item.DueDate, IsDone = item.IsDone, IsStarred = item.IsStarred, FolderId = item.FolderId }); } } return result; }
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(); } } }