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); }