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);
}
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 FindById()
{
var discipline = (await DisciplineDao.FindAllAsync()).First();
var disciplineById = await DisciplineDao.FindByIdAsync(discipline.Id);
Assert.AreEqual(discipline.DisciplineName, disciplineById?.DisciplineName);
}
public async Task DeleteTest()
{
var disciplineId = await DisciplineDao.InsertGetIdAsync(new Discipline { DisciplineName = "E" });
await DisciplineDao.DeleteAsync(disciplineId.Value);
Assert.IsNull(await DisciplineDao.FindByIdAsync(disciplineId.Value));
}
public async Task RemovePossibleDisciplineTest()
{
var location = (await LocationDao.FindAllAsync()).First();
var disciplineId = (await DisciplineDao.FindAllAsync()).First().Id;
await LocationDao.DeletePossibleDisciplineForLocation(location.Id, disciplineId);
Assert.AreEqual(1, (await LocationDao.GetPossibleDisciplinesForLocation(location.Id)).Count());
}
public async Task DeleteAllTest()
{
await DbTeardown();
await DisciplineDao.InsertAsync(new Discipline { DisciplineName = "E" });
await DisciplineDao.DeleteAllAsync();
Assert.IsEmpty(await DisciplineDao.FindAllAsync());
}
public async Task UpdateTest()
{
var discipline = (await DisciplineDao.FindAllAsync()).First();
discipline.DisciplineName = "ABC";
await DisciplineDao.UpdateAsync(discipline);
var disciplineById = await DisciplineDao.FindByIdAsync(discipline.Id);
Assert.AreEqual("ABC", disciplineById?.DisciplineName);
}
public async Task InsertTest()
{
var disciplineId = await DisciplineDao.InsertGetIdAsync(new Discipline
{
DisciplineName = "XXX"
});
var disciplineById = await DisciplineDao.FindByIdAsync(disciplineId.Value);
Assert.AreEqual("XXX", disciplineById?.DisciplineName);
}
private static void ValidExists(Discipline discipline)
{
try
{
using (DisciplineDao dao = new DisciplineDao())
dao.FindByPk(discipline.Code, discipline.Period.Graduation.Id);
throw new Exception("Já existe uma disciplina com esse código nesse curso");
}
catch (EntityNotFoundException e) { /* Entity not found, keep swimming! */ }
}
public async Task AddPossibleDisciplineTest()
{
var location = (await LocationDao.FindAllAsync()).First();
var disciplineId = await DisciplineDao.InsertGetIdAsync(new Discipline
{
DisciplineName = "XYZ"
});
await LocationDao.InsertPossibleDisciplineForLocation(location.Id, disciplineId.Value);
Assert.AreEqual(3, (await LocationDao.GetPossibleDisciplinesForLocation(location.Id)).Count());
}
public async Task AddPossibleDisciplineTest()
{
var disciplineId = await DisciplineDao.InsertGetIdAsync(new Discipline
{
DisciplineName = "TestDiscipline"
});
var skierId = (await SkierDao.FindAllAsync()).First().Id;
await SkierDao.InsertPossibleDisciplineForSkier(skierId, disciplineId.Value);
Assert.AreEqual(3, (await SkierDao.GetPossibleDisciplinesForSkier(skierId)).Count());
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
Entities.Discipline discipline = ExtractDisciplineFromForm();
using (DisciplineDao dao = new DisciplineDao())
dao.Update(discipline);
Response.Redirect(string.Format("profile.aspx?Graduation={0}&Discipline={1}", Discipline.Period.Graduation.Id, Discipline.Code));
}
catch (Exception ex)
{
ErrorMessage = ex.Message;
}
}
public void Page_Init(object sender, EventArgs e)
{
try
{
int graduationId = -1;
string disciplineCode;
int.TryParse(Request.Params["Graduation"], out graduationId);
disciplineCode = Request.Params["Discipline"] ?? string.Empty;
using (DisciplineDao dao = new DisciplineDao())
Discipline = dao.FindByPk(disciplineCode, graduationId);
}
catch (EntityNotFoundException ex)
{
throw new HttpException(404, ex.Message);
}
}
public async Task FindAllTest() => Assert.AreEqual(2, (await DisciplineDao.FindAllAsync()).Count());
