public static LotteryGameCollection GetCollection()
{
LotteryGameCollection tempList = null;
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_GetGame", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", SelectTypeEnum.GetCollection);
myConnection.Open();
using (SqlDataReader myReader = myCommand.ExecuteReader())
{
if (myReader.HasRows)
{
tempList = new LotteryGameCollection();
while (myReader.Read())
{
tempList.Add(FillDataRecord(myReader));
}
}
myReader.Close();
}
}
}
return tempList;
}
private LotteryGameDTOCollection HydrateLotteryDTO(LotteryGameCollection lotteryCollection)
{
LotteryGameDTOCollection tempCollection = new LotteryGameDTOCollection();
if (lotteryCollection !=null && lotteryCollection.Count > 0)
{
foreach (LotteryGameValue item in lotteryCollection)
{
if (!string.IsNullOrEmpty(item.GameNameAbbrev))
tempCollection.Add(new LotteryGameDTO { LotteryGameId = item.LotteryGameId, GameAbbreviation = item.GameNameAbbrev });
else
tempCollection.Add(new LotteryGameDTO { LotteryGameId = item.LotteryGameId });
}
}
return tempCollection;
}
