public void OnGet()
{
Brokers = new GetBrokers(_ctx).Do();
Dispatches = new GetDispatches(_ctx).Do();
Drivers = new GetDrivers(_ctx).Do();
Factories = new GetFactories(_ctx).Do();
Trailers = new GetTrailers(_ctx).Do();
Trucks = new GetTrucks(_ctx).Do();
}
public async Task <List <GameTrailer> > GetTrailersByID(int GameID)
{
SqlParameter gameParam = new SqlParameter {
ParameterName = "@GameID", SqlDbType = SqlDbType.Int, Value = GameID
};
return(await GetTrailers.FromSql("Exec CoQ.GetTrailersByID @GameID", gameParam)
.AsNoTracking()
.ToListAsync());
}
