public IReadOnlyCollection <Season> GetAll()
{
try
{
_connection.Open();
var command = _realization.GetCommand(_connection, DbConstant.Command.GetSeasonList);
var seasonssTable = _realization.CreateTable("Seasons");
seasonssTable = _realization.FillInTable(seasonssTable, command);
var list = ParseToSeasonList(seasonssTable);
return(list);
}
catch (Exception exeption)
{
_commonLogger.Info(exeption.Message);
throw new Exception();
}
finally
{
_connection.Close();
}
}