public model.Task GetTask(int id)
{
model.Task task = null;
using (SQLiteConnection connection = GetConnection())
{
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(connection))
{
command.CommandText = "SELECT * FROM task";
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
task = new model.Task();
task.Id = Convert.ToInt32(reader["id"]);
task.Title = Convert.ToString(reader["title"]);
task.Completed = Convert.ToInt32(reader["completed"]);
task.Description = Convert.ToString(reader["description"]);
}
}
}
connection.Close();
}
return(task);
}
public model.Task CreateTask(string Name, string Description, UserGroup UserGroup, User Owner, TaskState TaskState, DateTime DueDate, DateTime StartDate, DateTime?CompletionDate, List <TaskCategory> TaskCategories)
{
int currentTaskID = 0;
model.Task task = new model.Task(currentTaskID, Name, Description, UserGroup, Owner, TaskState, DueDate, StartDate, CompletionDate, TaskCategories);
currentTaskID++;
_tasks.Add(task);
return(task);
}
public model.Task UpdateTask(model.Task Task, string Name, string Description, UserGroup UserGroup, User Owner, TaskState TaskState, DateTime DueDate, DateTime StartDate, DateTime?CompletionDate, List <TaskCategory> TaskCategories)
{
foreach (model.Task aTask in _tasks)
{
if (aTask.TaskID == Task.TaskID)
{
int id = aTask.TaskID;
_tasks.Remove(aTask);
model.Task task = new model.Task(id, Name, Description, UserGroup, Owner, TaskState, DueDate, StartDate, CompletionDate, TaskCategories);
_tasks.Add(task);
return(task);
}
}
return(null);
}
