public override string Execute()
{
string title = this.Parameters[0];
string priority = this.Parameters[1];
string end = this.Parameters[2];
string description = this.Parameters[3];
string importancePercent = this.Parameters[4];
ISubTask currSubtask = this.Factory
.CreateSubTask(title, priority, end, description, importancePercent);
EngineMaikaTI.CurrentLongTermTask.AddSubTask(currSubtask);
return(Messages.SubTaskCreated(title));
}
public override string Execute()
{
string longTermTaskName = this.Parameters[0];
string subTaskName = this.Parameters[1];
if (EngineMaikaTI.LoggedUser.LongTermTasks.Any(x => x.Title == longTermTaskName))
{
ILongTermTask currLongTermTask = EngineMaikaTI.LoggedUser.LongTermTasks.First(x => x.Title == longTermTaskName);
if (currLongTermTask.AllTasks.Any(x => x.Title == subTaskName))
{
ISubTask subTaskToRemove = currLongTermTask.AllTasks.First(x => x.Title == subTaskName);
currLongTermTask.AllTasks.Remove(subTaskToRemove);
return(Messages.TaskRemoved(subTaskName));
}
return(Messages.NoSubtaskFound());
}
return(Messages.NoLongTermTaskFound());
}
public static void InsertSubTask(ISubTask subTask, long taskID)
{
using (IDbConnection connection = new SQLiteConnection(GetConnectionString()))
{
var order = (uint)GetCount("subtasks");
subTask.OrderNumber = order;
var sql = @"insert into subtasks (Content, Priority, IsCompleted, DueDate)
values (@Content, @Priority, @IsCompleted, @DueDate)";
connection.Execute(sql,
new
{
subTask.Content,
subTask.Priority,
subTask.IsCompleted,
subTask.DueDate
});
subTask.ID = GetLastRowID("subtasks");
connection.Dispose();
}
AssignSubTaskToTheTask(taskID, GetLastRowID("subtasks"));
}
public static void DeleteSubTask(ISubTask task)
{
using IDbConnection connection = new SQLiteConnection(GetConnectionString());
connection.Delete((SubTask)task);
connection.Dispose();
}
public void AddSubTask(ISubTask subtask)
{
this.AllTasks.Add(subtask);
}
