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