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(); } }