public TaskResponse GetTeamMemberWithTasks(int teamMemberId)
{
try
{
TeamMember teamMember = GetMemberInfo(teamMemberId);
List <Task> taskList = new List <Task>();
Task task = null;
using (SqlConnection sqlConnection = new SqlConnection(CONNECTION_DATA_STRING))
using (SqlCommand sqlCommand = new SqlCommand())
{
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = GET_TEAM_MEMBER_WITH_TASKS_BY_ID;
sqlCommand.Parameters.Add("@teamMemberId", SqlDbType.Int, 6);
sqlCommand.Parameters["@teamMemberId"].Value = teamMemberId;
sqlConnection.Open();
SqlDataReader dataReader = sqlCommand.ExecuteReader();
while (dataReader.Read())
{
task = TaskMapper.MapToTask(dataReader);
taskList.Add(task);
}
dataReader.Close();
return(new TaskResponse(teamMember, taskList));
}
}
catch (SqlException e)
{
Console.WriteLine(e.Message);
}
return(null);
}
