/// <summary> /// Initializes a new instance of the WinningNumbers class and fills it with the data from the IDataRecord /// </summary> /// <param name="myDataRecord"></param> /// <returns></returns> private static WinningNumbers FillDataRecord(IDataRecord myDataRecord) { WinningNumbers myWinningNumsObject = new WinningNumbers(); myWinningNumsObject.GameId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("GameId")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("GameId"))) { myWinningNumsObject.GameName = myDataRecord.GetString(myDataRecord.GetOrdinal("GameName")); myWinningNumsObject.DrawingDate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("DrawingDate")); myWinningNumsObject.NumberValue = myDataRecord.GetInt32(myDataRecord.GetOrdinal("NumberValue")); } return myWinningNumsObject; }
/// <summary> /// Initializes a new instance of the WinningNumbers class and fills it with the data from the IDataRecord /// </summary> /// <param name="myDataRecord"></param> /// <returns></returns> private static WinningNumbers FillDataRecord(IDataRecord myDataRecord) { WinningNumbers myWinningNumsObject = new WinningNumbers(); //myWinningNumsObject.DrawingDateId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("DrawingDateId")); //myWinningNumsObject.GameId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("GameId")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("NumberValue"))) { myWinningNumsObject.NumberValue = myDataRecord.GetInt32(myDataRecord.GetOrdinal("NumberValue")); } myWinningNumsObject.WinningNumbersId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("WinningNumbersId")); return myWinningNumsObject; }