public List <Brevet_Raider> GetAllBrevet_Raider()
{
List <Brevet_Raider> brevet_RiderList = new List <Brevet_Raider>();
IDataReader resultSet;
try
{
myDatabase = new Database();
myDatabase.Open(myConnectionString);
string sqlText =
"SELECT * FROM Brevet_Rider" +
"ORDER BY brevetid";
resultSet = myDatabase.ExecuteQuery(sqlText);
while (resultSet.Read() == true)
{
Brevet_Raider brevet = new Brevet_Raider();
brevet.RiderId = (int)resultSet["riderid"];
brevet.BrevetId = (int)resultSet["brevetid"];
brevet.IsCompleated = (String)resultSet["isCompleated"];
brevet.FinishingTime = (String)resultSet["finishingtime"];
brevet_RiderList.Add(brevet);
}
resultSet.Close();
return(brevet_RiderList);
}
catch (Exception)
{
return(null);
}
finally
{
myDatabase.Close();
}
}
public List<Brevet_Raider> GetAllBrevet_Raider()
{
List<Brevet_Raider> brevet_RiderList = new List<Brevet_Raider>();
IDataReader resultSet;
try
{
myDatabase = new Database();
myDatabase.Open(myConnectionString);
string sqlText =
"SELECT * FROM Brevet_Rider"+
"ORDER BY brevetid";
resultSet = myDatabase.ExecuteQuery(sqlText);
while (resultSet.Read() == true)
{
Brevet_Raider brevet = new Brevet_Raider();
brevet.RiderId = (int)resultSet["riderid"];
brevet.BrevetId = (int)resultSet["brevetid"];
brevet.IsCompleated = (String)resultSet["isCompleated"];
brevet.FinishingTime = (String)resultSet["finishingtime"];
brevet_RiderList.Add(brevet);
}
resultSet.Close();
return brevet_RiderList;
}
catch (Exception)
{
return null;
}
finally
{
myDatabase.Close();
}
}
