public ActionResult Index(int page = 1, int pageSize = 10)
{
var dao = new SeasonDao();
var model = dao.ListPg(page, pageSize);
return(View(model));
}
protected TestBase()
{
var config = new ConfigurationBuilder().AddJsonFile("appsettings.json").Build();
var section = config.GetSection("ConnectionStrings").GetSection("huraceTest");
var provider = section["ProviderName"];
var connectionString = section["ConnectionString"];
ConnectionFactory =
new ConcreteConnectionFactory(DbUtil.GetProviderFactory(provider), connectionString);
RaceDao = new RaceDao(ConnectionFactory, StatementFactory);
SeasonDao = new SeasonDao(ConnectionFactory, StatementFactory);
LocationDao = new LocationDao(ConnectionFactory, StatementFactory);
CountryDao = new CountryDao(ConnectionFactory, StatementFactory);
DisciplineDao = new DisciplineDao(ConnectionFactory, StatementFactory);
SkierDao = new SkierDao(ConnectionFactory, StatementFactory);
StartListDao = new StartListDao(ConnectionFactory, StatementFactory);
RaceEventDao = new RaceEventDao(ConnectionFactory, StatementFactory);
SkierEventDao = new SkierEventDao(ConnectionFactory, StatementFactory);
TimeDataDao = new TimeDataDao(ConnectionFactory, StatementFactory);
GenderDao = new GenderDao(ConnectionFactory, StatementFactory);
SensorDao = new SensorDao(ConnectionFactory, StatementFactory);
RaceDataDao = new RaceDataDao(ConnectionFactory, StatementFactory);
RaceStateDao = new RaceStateDao(ConnectionFactory, StatementFactory);
StartStateDao = new StartStateDao(ConnectionFactory, StatementFactory);
EventTypeDao = new EventTypeDao(ConnectionFactory, StatementFactory);
_dataGenerator = new DataGenerator.Core.DataGenerator(provider, connectionString);
}
public async Task InsertTest()
{
var disciplineId = (await DisciplineDao.FindAllAsync()).First().Id;
var locationId = (await LocationDao.FindAllAsync()).First().Id;
var seasonId = (await SeasonDao.FindAllAsync()).First().Id;
var raceId = await RaceDao.InsertGetIdAsync(new Race
{
DisciplineId = disciplineId,
GenderId = (int)Domain.Enums.Gender.Male,
LocationId = locationId,
RaceDescription = "Description",
SeasonId = seasonId,
RaceStateId = (int)Domain.Enums.RaceDataEvent.RaceFinished,
RaceDate = new DateTime(2019, 11, 15)
});
var raceById = await RaceDao.FindByIdAsync(raceId.Value);
Assert.AreEqual(disciplineId, raceById.DisciplineId);
Assert.AreEqual((int)Domain.Enums.Gender.Male, raceById.GenderId);
Assert.AreEqual(locationId, raceById.LocationId);
Assert.AreEqual("Description", raceById.RaceDescription);
Assert.AreEqual(seasonId, raceById.SeasonId);
Assert.AreEqual((int)Domain.Enums.RaceDataEvent.RaceFinished, raceById.RaceStateId);
Assert.AreEqual(new DateTime(2019, 11, 15), raceById.RaceDate);
Assert.NotNull(raceById.Location);
Assert.NotNull(raceById.Gender);
Assert.NotNull(raceById.Season);
}
public JsonResult ChangeStatus(int id)
{
var result = new SeasonDao().ChangeStatus(id);
return(Json(new
{
status = result
}));
}
public async Task UpdateTest()
{
var season = (await SeasonDao.FindAllAsync()).First();
season.StartDate = season.StartDate.AddDays(-5);
await SeasonDao.UpdateAsync(season);
Assert.AreEqual(season.StartDate, (await SeasonDao.FindByIdAsync(season.Id))?.StartDate);
}
public ActionResult SeasonPage(int idc, int page = 1)
{
var newDao = new NewDao();
var season = new SeasonDao().ViewDetail(idc);
ViewBag.season = season;
ViewBag.ListNewsNew = newDao.ListNewsNew(12);
ViewBag.NewsNew = newDao.ListNewsNew(5);
ViewBag.NewsTop = newDao.ListNewsTop(6);
var model = newDao.ListBySeasonID(idc);
return(View(model.ToPagedList(page, 12)));
}
public async Task InsertTest()
{
var id = await SeasonDao.InsertGetIdAsync(new Season
{
StartDate = new DateTime(1969, 4, 20),
EndDate = new DateTime(2069, 4, 20)
});
var season = await SeasonDao.FindByIdAsync(id.Value);
Assert.AreEqual(new DateTime(1969, 4, 20), season.StartDate);
Assert.AreEqual(new DateTime(2069, 4, 20), season.EndDate);
}
public async Task GetRacesForSeason()
{
var season = (await SeasonDao.FindAllAsync()).First();
Assert.AreEqual(2, (await RaceDao.GetRacesForSeasonId(season.Id)).Count());
}
public PartialViewResult Season()
{
var model = new SeasonDao().ListAll();
return(PartialView(model));
}
public async Task CountRacesForSeasonTest()
{
var season = (await SeasonDao.FindAllAsync()).First();
Assert.AreEqual(2, await SeasonDao.CountRacesForSeason(season.Id));
}
public async Task FindByIdTest()
{
var id = (await SeasonDao.FindAllAsync()).First().Id;
Assert.NotNull(await SeasonDao.FindByIdAsync(id));
}
public async Task FindAllTest() => Assert.AreEqual(1, (await SeasonDao.FindAllAsync()).Count());
