public void AddTaskTag(Guid taskId, Guid tagId)
{
tTaskTag newTaskTag = new tTaskTag();
newTaskTag.TaskTagId = Guid.NewGuid();
newTaskTag.TaskId = taskId;
newTaskTag.TagId = tagId;
using (TodoListDataContext dc = new TodoListDataContext())
{
dc.tTaskTags.InsertOnSubmit(newTaskTag);
dc.SubmitChanges();
}
}
public void EditTask(Guid taskId, DateTime startDate, DateTime finishDate, string title, string description, Guid priorityId, Guid assigneeId, string picturePath, Guid stateId)
{
using (TodoListDataContext dc = new TodoListDataContext())
{
var editTask = dc.tTasks.SingleOrDefault(t => t.TaskId == taskId);
//editTask.TaskId = taskId;
editTask.StartDate = startDate;
editTask.FinishDate = finishDate;
editTask.Title = title;
editTask.Description = description;
editTask.PriorityId = priorityId;
editTask.AssigneeId = assigneeId;
editTask.Picture = picturePath;
editTask.StateId = stateId;
dc.SubmitChanges();
}
}
public void EditTask(Guid taskId, DateTime startDate, DateTime finishDate, string title, string description, Guid priorityId, Guid assigneeId, string picturePath, Guid stateId)
{
using (TodoListDataContext dc = new TodoListDataContext())
{
var editTask = dc.tTasks.SingleOrDefault(t => t.TaskId == taskId);
//editTask.TaskId = taskId;
editTask.StartDate = startDate;
editTask.FinishDate = finishDate;
editTask.Title = title;
editTask.Description = description;
editTask.PriorityId = priorityId;
editTask.AssigneeId = assigneeId;
editTask.Picture = picturePath;
editTask.StateId = stateId;
dc.SubmitChanges();
}
}
public Guid AddTask(DateTime startDate, DateTime finishDate, string title, string description, Guid priorityId, Guid assigneeId, string picturePath, Guid stateId)
{
tTask newTask = new tTask();
newTask.TaskId = Guid.NewGuid();
newTask.StartDate = startDate;
newTask.FinishDate = finishDate;
newTask.Title = title;
newTask.Description = description;
newTask.PriorityId = priorityId;
newTask.AssigneeId = assigneeId;
newTask.Picture = picturePath;
newTask.StateId = stateId;
using (TodoListDataContext dc = new TodoListDataContext())
{
dc.tTasks.InsertOnSubmit(newTask);
dc.SubmitChanges();
}
return newTask.TaskId;
}
public Guid AddTask(DateTime startDate, DateTime finishDate, string title, string description, Guid priorityId, Guid assigneeId, string picturePath, Guid stateId)
{
tTask newTask = new tTask();
newTask.TaskId = Guid.NewGuid();
newTask.StartDate = startDate;
newTask.FinishDate = finishDate;
newTask.Title = title;
newTask.Description = description;
newTask.PriorityId = priorityId;
newTask.AssigneeId = assigneeId;
newTask.Picture = picturePath;
newTask.StateId = stateId;
using (TodoListDataContext dc = new TodoListDataContext())
{
dc.tTasks.InsertOnSubmit(newTask);
dc.SubmitChanges();
}
return(newTask.TaskId);
}
