public async Task Update() { IStationDao stationDao = new AdoStationDao(DefaultConnectionFactory.FromConfiguration(_connectionStringConfigName)); Station station = await stationDao.FindByIdAsync(1); string name = station.Name; station.Name = "TEST UPDATE"; bool update1 = await stationDao.UpdateAllAsync(station); Assert.IsTrue(update1); Station station1 = await stationDao.FindByIdAsync(1); Assert.IsTrue(station1.Name == "TEST UPDATE"); station.Name = name; bool update2 = await stationDao.UpdateAllAsync(station); Assert.IsTrue(update2); Station station2 = await stationDao.FindByIdAsync(1); Assert.IsTrue(station2.Name == name); }
public async Task FindByProvinceId() { IStationDao stationDao = new AdoStationDao(DefaultConnectionFactory.FromConfiguration(_connectionStringConfigName)); Station station = (await stationDao.FindByProvinceIdAsync(1)).FirstOrDefault(); Assert.IsTrue(station != null && station.CommunityId == 85); }
public async Task FindByName() { IStationDao stationDao = new AdoStationDao(DefaultConnectionFactory.FromConfiguration(_connectionStringConfigName)); Station station = (await stationDao.FindByNameAsync("ANDAU")).FirstOrDefault(); Assert.IsTrue(station != null && station.Name == "ANDAU"); }
public async Task FindByJoinedId() { IStationDao stationDao = new AdoStationDao(DefaultConnectionFactory.FromConfiguration(_connectionStringConfigName)); Station station = await stationDao.FindJoinedByIdAsync(1); Assert.IsTrue(station != null && station.Id == 1); }
public async Task FindAll() { IStationDao stationDao = new AdoStationDao(DefaultConnectionFactory.FromConfiguration(_connectionStringConfigName)); IEnumerable <Station> stations = await stationDao.FindAllAsync(); int count = stations.Count(); Assert.IsTrue(count > 1); }
public async Task FindByCreator() { IStationDao stationDao = new AdoStationDao(DefaultConnectionFactory.FromConfiguration(_connectionStringConfigName)); IEnumerable <Station> stations = await stationDao.FindByCreatorIdAsync(1); Assert.IsTrue(stations.Any()); IEnumerable <Station> stations2 = await stationDao.FindByCreatorIdAsync(1231234123); Assert.IsFalse(stations2.Any()); }
public async Task Add() { IStationDao stationDao = new AdoStationDao(DefaultConnectionFactory.FromConfiguration(_connectionStringConfigName)); Station station = new Station("Test!!", 1, 42.111, 42.111, 85, 122.4, 1); bool insert1 = await stationDao.AddStationAsync(station); Assert.IsTrue(insert1); Station station1 = (await stationDao.FindByNameAsync("Test!!")).FirstOrDefault(); Assert.IsTrue(station1 != null && station1.Name == station.Name); bool delete = await stationDao.DeleteStationAsync(station1); Assert.IsTrue(delete); }