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();
}
}
}
