public void Execute()
{
try {
using (var command =
new SQLiteCommand(Resources.SQL_SELECT_CATEGORY_BY_COMPETITION, _conn.DbConnection)) {
command.Parameters.AddWithValue("@COMPETITION_ID", _competitionDto.ID);
using (var reader = command.ExecuteReader()) {
Categories = new List <AbsoluteCategory>();
while (reader.Read())
{
int[] id = { reader.GetInt32(2), reader.GetInt32(3) };
var childCategory = new CompetitionService().SelectCategoryByAbsoluteCategories(id);
var category = new AbsoluteCategory {
Id = reader.GetInt32(0),
Name = reader.GetString(1),
CategoryM = childCategory.ElementAt(0),
CategoryF = childCategory.ElementAt(1)
};
Categories.Add(category);
}
}
}
}
catch (SQLiteException) {
_conn.DbConnection?.Close();
throw;
}
}
