private void PopulateResponsibles(Task task)
{
if (task == null)
{
return;
}
MySqlCommand command = new MySqlCommand("SELECT user FROM task_responsibles WHERE @projectId=@projectId AND taskId=@taskId", _connection);
command.Parameters.Add("@projectId", MySqlDbType.Int32).Value = task.ProjectId;
command.Parameters.Add("@taskId", MySqlDbType.Int32).Value = task.Id;
using (IDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
task.Responsibles.Add(reader["user"].ToString());
}
}
}
public Task Find(int projectId, int taskId)
{
Task result = null;
StringBuilder query = new StringBuilder(GetFindTaskHeaderQuery());
query.AppendLine("WHERE TA.projectId=@projectId");
query.AppendLine("AND taskId=@taskId");
MySqlCommand command = new MySqlCommand(query.ToString(), _connection);
command.Parameters.Add("@projectId", MySqlDbType.Int32).Value = projectId;
command.Parameters.Add("@taskId", MySqlDbType.Int32).Value = taskId;
using (IDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
result = PopulateTask(reader);
}
}
PopulateResponsibles(result);
return(result);
}
