private void addFront_Click(object sender, EventArgs e)
{
if (this.description.Text.Trim() != "")
{
Task t = new Task();
t.description = this.description.Text;
t.notes = this.notes.Text;
_taskSet._tasksNotDone.AddFirst(t);
TaskRepository.InsertTask(t);
Clear();
}
}
public static void UpdateTask(Task t)
{
try
{
using (IDbConnection connection = GetConnection())
{
var sql = "Update Task set description=@description, notes=@notes, Created=@Created, TimeSpentInSeconds=@TimeSpentInSeconds, Completed=@Completed " +
"where id=@id";
connection.Execute(sql, t);
}
}
catch
{
Console.WriteLine("Update Task failed");
throw;
}
}
private void addNext_Click(object sender, EventArgs e)
{
if (this.description.Text.Trim() != "")
{
if (_taskSet._currentTask == null)
{
addBack_Click(sender, e);
}
else
{
Task t = new Task();
t.description = this.description.Text;
t.notes = this.notes.Text;
_taskSet._tasksNotDone.AddAfter(_taskSet._currentTask, t);
TaskRepository.InsertTask(t);
Clear();
}
}
}
public static void InsertTask(Task t)
{
try
{
using (IDbConnection connection = GetConnection())
{
var sql = @"Insert into Task (description, notes, Created, TimeSpentInSeconds) values (@description, @notes, @Created, @TimeSpentInSeconds);";
connection.Execute(sql, t);
sql = "SELECT top(1) id from Task order by id desc";
var id = connection.Query<int>(sql).Single();
t.id = id;
}
}
catch
{
Console.WriteLine("Insert Task failed");
throw;
}
}
private void done_Click(object sender, EventArgs e)
{
SaveElapsedTime();
_taskSet._currentTask.Value.Completed = DateTime.Now;
update_Click(sender, e);
Task clonedTask = new Task();
clonedTask.description = _taskSet._currentTask.Value.description;
clonedTask.notes = _taskSet._currentTask.Value.notes;
clonedTask.id = _taskSet._currentTask.Value.id;
clonedTask.TimeSpentInSeconds = _taskSet._currentTask.Value.TimeSpentInSeconds;
clonedTask.Created = _taskSet._currentTask.Value.Created;
clonedTask.Completed = _taskSet._currentTask.Value.Completed;
_taskSet._tasksDone.AddLast(clonedTask);
LinkedListNode<Task> newCurrentTask = null;
if (_taskSet._currentTask.Next != null)
{
newCurrentTask = _taskSet._currentTask.Next;
_taskSet._tasksNotDone.Remove(_taskSet._currentTask);
_taskSet._currentTask = newCurrentTask;
}
else if (_taskSet._currentTask.Previous != null)
{
newCurrentTask = _taskSet._currentTask.Previous;
_taskSet._tasksNotDone.Remove(_taskSet._currentTask);
_taskSet._currentTask = newCurrentTask;
}
else
{
_taskSet._tasksNotDone.Remove(_taskSet._currentTask);
ShowFinishedStatus();
}
LoadForm();
}
