void INoteCollectionRepo.Remove(ITaskCore container, INoteCore item)
{
string taskSeriesId, taskId;
backend.DecodeTaskId(container, out taskSeriesId, out taskId);
backend.Rtm.NotesDelete(backend.Timeline, item.Id);
}
public string UpdateText(ITaskCore task, string text)
{
var dummyTask = backend.GetTaskBy(task.Id);
dummyTask.Text = text;
return(text);
}
public DateTime Complete(ITaskCore task, DateTime completionDate)
{
var dummyTask = backend.GetTaskBy(task.Id);
dummyTask.CompleteTask();
return(dummyTask.CompletionDate);
}
void INoteCollectionRepo.AddNew(ITaskCore task, INoteCore note)
{
var dummyTask = backend.GetTaskBy(task.Id);
var dummyNote = new DummyNote(note.Text);
dummyTask.TaskNotes.Add(dummyNote);
}
public void Add(ITaskListCore taskList, ITaskCore task)
{
var dummyList = backend.GetTaskListBy(taskList.Id);
var dummyTask = backend.GetTaskBy(task.Id);
dummyList.Tasks.Add(dummyTask);
}
void TaskListTaskCollectionRepo.AddNew(ITaskListCore container,
ITaskCore item)
{
var command =
"INSERT INTO Tasks" +
"(Name, DueDate, CompletionDate, Priority, State, " +
"Category, ExternalID) " +
"VALUES (@name, @dueDate, @completionDate, " +
"@priority, @state, @catId, ''); " +
"SELECT last_insert_rowid();";
using (var cmd = new SqliteCommand(database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddWithValue("@name", item.Text);
cmd.Parameters.AddWithValue("@dueDate",
Database.FromDateTime(item.DueDate));
cmd.Parameters.AddWithValue("@completionDate",
Database.FromDateTime(DateTime.MinValue));
cmd.Parameters.AddWithValue("@priority", (int)item.Priority);
cmd.Parameters.AddWithValue("@state", (int)item.State);
cmd.Parameters.AddWithValue("@catId",
int.Parse(container.Id));
var id = cmd.ExecuteScalar().ToString();
item.SetId(id);
}
}
IEnumerable <INoteCore> INoteCollectionRepo.GetAll(ITaskCore container)
{
var notes = backend.TaskListRepo.Notes;
return(notes.Where(t => t.Item1 == container.Id)
.Select(t => t.Item2));
}
public TaskPriority UpdatePriority(
ITaskCore task, TaskPriority priority)
{
var dummyTask = backend.GetTaskBy(task.Id);
dummyTask.Priority = (int)priority;
return(priority);
}
public void Remove(ITaskListCore taskList, ITaskCore task)
{
var dummyList = backend.GetTaskListBy(taskList.Id);
var dummyTask = dummyList.Tasks.Single(
t => t.Id.ToString() == task.Id);
dummyList.Tasks.Remove(dummyTask);
}
void INoteCollectionRepo.Remove(ITaskCore task, INoteCore note)
{
var dummyTask = backend.GetTaskBy(task.Id);
var dummyNote = dummyTask.TaskNotes.Single(
n => n.Id.ToString() == note.Id);
dummyTask.TaskNotes.Remove(dummyNote);
}
public void DecodeTaskId(ITaskCore task, out string taskSeriesId,
out string taskId)
{
var ids = task.Id.Split();
taskSeriesId = ids [0];
taskId = ids [1];
}
public DateTime UpdateDueDate(ITaskCore task, DateTime dueDate)
{
var dummyTask = backend.GetTaskBy(task.Id);
dummyTask.DueDate = dueDate == DateTime.MinValue
? DateTime.MaxValue : dueDate;
return(dueDate);
}
void ITaskListTaskCollectionRepo.Remove(ITaskListCore container,
ITaskCore item)
{
string taskSeriesId, taskId;
backend.DecodeTaskId(item, out taskSeriesId, out taskId);
backend.Rtm.TasksDelete(backend.Timeline, container.Id,
taskSeriesId, taskId);
}
void ITaskRepository.Activate(ITaskCore task)
{
var taskList = task.TaskListContainers.First();
string taskSeriesId, taskId;
backend.DecodeTaskId(task, out taskSeriesId, out taskId);
backend.Rtm.TasksUncomplete(backend.Timeline, taskList.Id,
taskSeriesId, taskId);
}
public AddEditTask(TaskDTO task)
{
InitializeComponent();
WindowHelper.SmallWindowSettings(this);
taskCore = new TaskCore();
authCore = new AuthenticationCore();
currentTask = task;
InitializeData();
}
IEnumerable <INoteCore> INoteCollectionRepo.GetAll(
ITaskCore container)
{
var dummyTask = backend.GetTaskBy(container.Id);
foreach (var dummyNote in dummyTask.TaskNotes)
{
yield return(CreateNote(dummyNote));
}
}
void NoteCollectionRepo.Remove(ITaskCore container, INoteCore item)
{
var command = "DELETE FROM Notes WHERE ID=@id;";
using (var cmd = new SqliteCommand(database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddIdParameter(item);
cmd.ExecuteNonQuery();
}
}
string ITaskRepository.UpdateText(ITaskCore task, string text)
{
var taskList = task.TaskListContainers.First();
string taskSeriesId, taskId;
backend.DecodeTaskId(task, out taskSeriesId, out taskId);
var list = backend.Rtm.TasksSetName(backend.Timeline,
taskList.Id, taskSeriesId, taskId, task.Text);
return(list.TaskSeriesCollection [0].Name);
}
void TaskListTaskCollectionRepo.Remove(ITaskListCore container,
ITaskCore item)
{
var command = "DELETE FROM Tasks WHERE ID=@id;";
using (var cmd = new SqliteCommand(database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddWithValue("@id", int.Parse(item.Id));
cmd.ExecuteNonQuery();
}
}
string ITaskRepository.UpdateText(ITaskCore task, string text)
{
var command = "UPDATE Tasks SET Name=@name WHERE ID=@id;";
using (var cmd = new SqliteCommand(database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddWithValue("@name", text);
cmd.Parameters.AddIdParameter(task);
cmd.ExecuteNonQuery();
}
return(text);
}
void ITaskListTaskCollectionRepo.AddNew(ITaskListCore container,
ITaskCore item)
{
var list = backend.Rtm.TasksAdd(
backend.Timeline, item.Text, container.Id);
var taskSeries = list.TaskSeriesCollection [0];
var last = taskSeries.TaskCollection.Length - 1;
var id = backend.EncodeTaskId(
taskSeries.TaskID, taskSeries.TaskCollection [last].TaskID);
item.SetId(id);
}
void ITaskRepository.Discard(ITaskCore task)
{
var command = "UPDATE Tasks SET State=@state WHERE ID=@id;";
using (var cmd = new SqliteCommand(database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddWithValue(
"@state", (int)TaskState.Discarded);
cmd.Parameters.AddIdParameter(task);
cmd.ExecuteNonQuery();
}
}
DateTime ITaskRepository.UpdateDueDate(ITaskCore task, DateTime date)
{
var command = "UPDATE Tasks SET DueDate=@dueDate WHERE ID=@id;";
using (var cmd = new SqliteCommand(database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddWithValue("@dueDate",
Database.FromDateTime(date));
cmd.Parameters.AddIdParameter(task);
cmd.ExecuteNonQuery();
}
return(date);
}
TaskPriority ITaskRepository.UpdatePriority(ITaskCore task,
TaskPriority priority)
{
var command = "UPDATE Tasks SET Priority=@priority WHERE ID=@id;";
using (var cmd = new SqliteCommand(database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddWithValue("@priority", (int)priority);
cmd.Parameters.AddIdParameter(task);
cmd.ExecuteNonQuery();
}
return(priority);
}
DateTime ITaskRepository.Complete(ITaskCore task,
DateTime completionDate)
{
var taskList = task.TaskListContainers.First();
string taskSeriesId, taskId;
backend.DecodeTaskId(task, out taskSeriesId, out taskId);
var list = backend.Rtm.TasksComplete(backend.Timeline,
taskList.Id, taskSeriesId, taskId);
var last = list.TaskSeriesCollection [0].TaskCollection.Length - 1;
return(list.TaskSeriesCollection [0].TaskCollection [last].Completed);
}
void INoteCollectionRepo.AddNew(ITaskCore container, INoteCore item)
{
var taskList = container.TaskListContainers.First();
string taskSeriesId, taskId;
backend.DecodeTaskId(container, out taskSeriesId, out taskId);
var note = backend.Rtm.NotesAdd(backend.Timeline, taskList.Id,
taskSeriesId, taskId, item.Title, item.Text);
item.Text = note.Text;
item.Title = note.Title;
item.SetId(note.ID);
}
public void AddNew(ITaskListCore taskList, ITaskCore task)
{
var dummyList = backend.GetTaskListBy(taskList.Id);
var dummyTask = new DummyTask(task.Text)
{
DueDate = task.DueDate == DateTime.MaxValue
? DateTime.MinValue : task.DueDate,
Priority = (int)task.Priority
};
dummyList.Tasks.Add(dummyTask);
}
TaskPriority ITaskRepository.UpdatePriority(ITaskCore task,
TaskPriority priority)
{
var taskList = task.TaskListContainers.First();
string taskSeriesId, taskId;
backend.DecodeTaskId(task, out taskSeriesId, out taskId);
var list = backend.Rtm.TasksSetPriority(backend.Timeline,
taskList.Id, taskSeriesId, taskId, task.GetPriorityString());
var last = list.TaskSeriesCollection [0].TaskCollection.Length - 1;
return(list.TaskSeriesCollection [0]
.TaskCollection [last].GetTaskPriority());
}
void ITaskRepository.Activate(ITaskCore task)
{
var command = "UPDATE Tasks SET State=@state, " +
"CompletionDate=@completionDate WHERE ID=@id;";
using (var cmd = new SqliteCommand(database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddWithValue("@state", (int)TaskState.Active);
cmd.Parameters.AddWithValue("@completionDate",
Database.FromDateTime(DateTime.MinValue));
cmd.Parameters.AddIdParameter(task);
cmd.ExecuteNonQuery();
}
}
void NoteCollectionRepo.AddNew(ITaskCore container, INoteCore item)
{
var command = "INSERT INTO Notes (Name, Text, Task)" +
"VALUES (@name, @text, @id); SELECT last_insert_rowid();";
using (var cmd = new SqliteCommand(database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddWithValue("@name", item.Title);
cmd.Parameters.AddWithValue("@text", item.Text);
cmd.Parameters.AddIdParameter(container);
var id = cmd.ExecuteScalar().ToString();
item.SetId(id);
}
}
IEnumerable<INoteCore> INoteCollectionRepo.GetAll(
ITaskCore container)
{
var dummyTask = backend.GetTaskBy (container.Id);
foreach (var dummyNote in dummyTask.TaskNotes)
yield return CreateNote (dummyNote);
}
void INoteCollectionRepo.ClearAll(ITaskCore container)
{
var dummyTask = backend.GetTaskBy (container.Id);
dummyTask.TaskNotes.Clear ();
}
void NoteCollectionRepo.AddNew(ITaskCore container, INoteCore item)
{
var command = "INSERT INTO Notes (Name, Text, Task)" +
"VALUES (@name, @text, @id); SELECT last_insert_rowid();";
using (var cmd = new SqliteCommand (database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddWithValue ("@name", item.Title);
cmd.Parameters.AddWithValue ("@text", item.Text);
cmd.Parameters.AddIdParameter (container);
var id = cmd.ExecuteScalar ().ToString ();
item.SetId (id);
}
}
public DateTime UpdateDueDate(ITaskCore task, DateTime dueDate)
{
var dummyTask = backend.GetTaskBy (task.Id);
dummyTask.DueDate = dueDate == DateTime.MinValue
? DateTime.MaxValue : dueDate;
return dueDate;
}
void NoteCollectionRepo.Add(ITaskCore container, INoteCore item)
{
throw new NotSupportedException (
"A note can only belong to a single task.");
}
void ITaskCollectionRepo.ClearAll(ITaskCore container)
{
throw new NotSupportedException (NestedTasksErrMsg);
}
ITaskCore ITaskCollectionRepo.GetBy(
ITaskCore container, string id)
{
throw new NotSupportedException (NestedTasksErrMsg);
}
INoteCore INoteCollectionRepo.GetBy(
ITaskCore container, string id)
{
return CreateNote (backend.GetNoteBy (id));
}
void ITaskRepository.Activate(ITaskCore task)
{
var command = "UPDATE Tasks SET State=@state, " +
"CompletionDate=@completionDate WHERE ID=@id;";
using (var cmd = new SqliteCommand (database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddWithValue ("@state", (int)TaskState.Active);
cmd.Parameters.AddWithValue ("@completionDate",
Database.FromDateTime (DateTime.MinValue));
cmd.Parameters.AddIdParameter (task);
cmd.ExecuteNonQuery ();
}
}
void NoteCollectionRepo.Remove(ITaskCore container, INoteCore item)
{
var command = "DELETE FROM Notes WHERE ID=@id;";
using (var cmd = new SqliteCommand (database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddIdParameter (item);
cmd.ExecuteNonQuery ();
}
}
void NoteCollectionRepo.ClearAll(ITaskCore container)
{
throw new NotImplementedException ();
}
IEnumerable<INoteCore> NoteCollectionRepo.GetAll(ITaskCore container)
{
var command =
"SELECT ID, Name, Text FROM Notes WHERE Task=@id;";
using (var cmd = new SqliteCommand (database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddIdParameter (container);
using (var dataReader = cmd.ExecuteReader ()) {
var id = dataReader.GetInt32 (0).ToString ();
var name = dataReader.GetString (1);
var text = dataReader.GetString (2);
var note = backend.Factory.CreateNote (id);
note.Title = name;
note.Text = text;
yield return note;
}
}
}
void INoteCollectionRepo.Remove(ITaskCore task, INoteCore note)
{
var dummyTask = backend.GetTaskBy (task.Id);
var dummyNote = dummyTask.TaskNotes.Single (
n => n.Id.ToString () == note.Id);
dummyTask.TaskNotes.Remove (dummyNote);
}
public TaskPriority UpdatePriority(
ITaskCore task, TaskPriority priority)
{
var dummyTask = backend.GetTaskBy (task.Id);
dummyTask.Priority = (int)priority;
return priority;
}
IEnumerable<ITaskCore> ITaskCollectionRepo.GetAll(
ITaskCore container)
{
throw new NotSupportedException (NestedTasksErrMsg);
}
public void Activate(ITaskCore task)
{
var dummyTask = backend.GetTaskBy (task.Id);
dummyTask.RevertCompletion ();
}
void ITaskCollectionRepo.Remove(ITaskCore container, ITaskCore item)
{
throw new NotSupportedException (NestedTasksErrMsg);
}
void TaskListTaskCollectionRepo.Remove (ITaskListCore container,
ITaskCore item)
{
var command = "DELETE FROM Tasks WHERE ID=@id;";
using (var cmd = new SqliteCommand (database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddWithValue ("@id", int.Parse (item.Id));
cmd.ExecuteNonQuery ();
}
}
public INoteCore UpdateNote(ITaskCore task, INoteCore note)
{
throw new NotSupportedException (
"This backend supports multiple notes.");
}
void ITaskListTaskCollectionRepo.Remove(ITaskListCore container,
ITaskCore item)
{
string taskSeriesId, taskId;
backend.DecodeTaskId (item, out taskSeriesId, out taskId);
backend.Rtm.TasksDelete (backend.Timeline, container.Id,
taskSeriesId, taskId);
}
public string UpdateText(ITaskCore task, string text)
{
var dummyTask = backend.GetTaskBy (task.Id);
dummyTask.Text = text;
return text;
}
public void DecodeTaskId (ITaskCore task, out string taskSeriesId,
out string taskId)
{
var ids = task.Id.Split ();
taskSeriesId = ids [0];
taskId = ids [1];
}
void TaskListTaskCollectionRepo.AddNew (ITaskListCore container,
ITaskCore item)
{
var command =
"INSERT INTO Tasks" +
"(Name, DueDate, CompletionDate, Priority, State, " +
"Category, ExternalID) " +
"VALUES (@name, @dueDate, @completionDate, " +
"@priority, @state, @catId, ''); " +
"SELECT last_insert_rowid();";
using (var cmd = new SqliteCommand (database.Connection)) {
cmd.CommandText = command;
cmd.Parameters.AddWithValue ("@name", item.Text);
cmd.Parameters.AddWithValue ("@dueDate",
Database.FromDateTime (item.DueDate));
cmd.Parameters.AddWithValue ("@completionDate",
Database.FromDateTime (DateTime.MinValue));
cmd.Parameters.AddWithValue ("@priority", (int)item.Priority);
cmd.Parameters.AddWithValue ("@state", (int)item.State);
cmd.Parameters.AddWithValue ("@catId",
int.Parse (container.Id));
var id = cmd.ExecuteScalar ().ToString ();
item.SetId (id);
}
}
public DateTime Complete(ITaskCore task, DateTime completionDate)
{
var dummyTask = backend.GetTaskBy (task.Id);
dummyTask.CompleteTask ();
return dummyTask.CompletionDate;
}
void ITaskListTaskCollectionRepo.AddNew(ITaskListCore container,
ITaskCore item)
{
var list = backend.Rtm.TasksAdd (
backend.Timeline, item.Text, container.Id);
var taskSeries = list.TaskSeriesCollection [0];
var last = taskSeries.TaskCollection.Length - 1;
var id = backend.EncodeTaskId (
taskSeries.TaskID, taskSeries.TaskCollection [last].TaskID);
item.SetId (id);
}
public void Discard(ITaskCore task)
{
throw new NotSupportedException ("Discarding is not supported.");
}
void ITaskListTaskCollectionRepo.Add(ITaskListCore container,
ITaskCore item)
{
throw new NotSupportedException (
"A task can only belong to one task list.");
}
void INoteCollectionRepo.Add(ITaskCore task, INoteCore note)
{
throw new NotSupportedException (
"Notes can only belong to one task.");
}
INoteCore NoteCollectionRepo.GetBy(ITaskCore container, string id)
{
throw new NotImplementedException ();
}
void INoteCollectionRepo.AddNew(ITaskCore task, INoteCore note)
{
var dummyTask = backend.GetTaskBy (task.Id);
var dummyNote = new DummyNote (note.Text);
dummyTask.TaskNotes.Add (dummyNote);
}
