public IQueryable <TableBookingTime> FindAll()
{
List <TableBookingTime> times = new List <TableBookingTime>();
string sql = "SELECT RowID, TimeValue, TimeText, Season, TimeOrder "
+ "FROM [AP_TableBookingTime]";
SqlDataReader sdr = SqlHelper.ExecuteReader(_connection, CommandType.Text, sql);
while (sdr.Read())
{
TableBookingTime time = new TableBookingTime(new Guid(sdr["RowID"].ToString()),
sdr["TimeValue"].ToString(),
sdr["TimeText"].ToString(),
sdr["Season"].ToString(),
Convert.ToInt32(sdr["TimeOrder"]));
times.Add(time);
}
sdr.Close();
return(times.AsQueryable());
}
public void Save(TableBookingTime aggregateRoot)
{
throw new NotImplementedException();
}
