public void BecauseOf() { using (TestDataContext dataContext = new TestDataContext(_connectionString)) { UserDto userDto = new UserDto { DisplayName = "TestUserName", Id = _idToUse, Latitude = 1.0M, Longitude = 1.0M, Email = "*****@*****.**", ZoneId = _currentHotZone, Money = 500, Level = 1, BaseLineEnergy = 15, BaseLineAttackPower = 15, PossibleItemAmount = 5 }; dataContext.UserDtos.InsertOnSubmit(userDto); dataContext.SubmitChanges(); HotZoneDto hotZoneDto = new HotZoneDto { CanStartHere = false, Id = _newHotZoneIdToUse, Latitude = (decimal)_newHotZoneLatitude, Longitude = (decimal)_newHotZoneLongitude, Name = "New Test HotZone" }; dataContext.HotZoneDtos.InsertOnSubmit(hotZoneDto); dataContext.SubmitChanges(); } }
public void TestCleanup() { TestDataContext testDataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); testDataContext.HotZoneDtos.DeleteAllOnSubmit(testDataContext.HotZoneDtos.Where(h => _hotZonesIds.Contains(h.Id))); testDataContext.SubmitChanges(); testDataContext.ZombiePackDtos.DeleteAllOnSubmit(testDataContext.ZombiePackDtos.Where(z => _zombiePackIds.Contains(z.Id))); testDataContext.SubmitChanges(); testDataContext.UserZombiePackProgressDtos.DeleteAllOnSubmit(testDataContext.UserZombiePackProgressDtos.Where(z => _zombiePackIds.Contains(z.ZombiePackId))); testDataContext.SubmitChanges(); testDataContext.UserDtos.DeleteAllOnSubmit(testDataContext.UserDtos.Where(u => _userIds.Contains(u.Id))); testDataContext.SubmitChanges(); }
public void TestCleanup() { TestDataContext testDataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); if (testDataContext.UserDtos.Any(s => s.FacebookUserId == _facebookUserId)) { testDataContext.UserDtos.DeleteOnSubmit(testDataContext.UserDtos.Single(s => s.FacebookUserId == _facebookUserId)); testDataContext.SubmitChanges(); } }
public void TestCleanup() { TestDataContext dataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); dataContext.UserDtos .DeleteAllOnSubmit( dataContext.UserDtos .Where(u => u.Id == _userId)); dataContext.SubmitChanges(); }
public void TestCleanup() { using (TestDataContext dataContext = new TestDataContext(_connectionString)) { dataContext.UserZombiePackProgressDtos.DeleteAllOnSubmit( dataContext.UserZombiePackProgressDtos.Where(c => c.UserId == _userId)); dataContext.SubmitChanges(); } }
public void TestInitialize() { TestDataContext testDataContext = new TestDataContext(_connectionString); var userCountDto = new UserCountDto { Id = Guid.NewGuid(), HotZonesDestroyed = 10, Miles = 11, UserId = _userId, PeakAttack = 111, ZombiesKilled = 1111, ZombiePacksDestroyed = 11111, AccumulatedMoney = 500 }; testDataContext.UserCountDtos.InsertOnSubmit(userCountDto); testDataContext.SubmitChanges(); UserDto userDto = new UserDto { Id = _userId, DisplayName = "name", Email = string.Empty }; testDataContext.UserDtos.InsertOnSubmit(userDto); testDataContext.SubmitChanges(); }
public void TestInitialize() { TestDataContext dataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); ZombiePackDto dto = new ZombiePackDto { Id = _zombiePackId, HotZoneId = Guid.NewGuid(), Latitude = 0, Longitude = 0, Name = string.Empty }; dataContext.ZombiePackDtos.InsertOnSubmit(dto); dataContext.SubmitChanges(); }
public void TestInitialize() { TestDataContext dataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); UserDto userDto = new UserDto { Id = _userId, DisplayName = "name", Email = "email", Latitude = 0, LocationId = Guid.NewGuid(), Longitude = 0, ZoneId = Guid.NewGuid() }; dataContext.UserDtos.InsertOnSubmit(userDto); dataContext.SubmitChanges(); }
public void BecauseOf() { using (TestDataContext dataContext = new TestDataContext(_connectionString)) { List<HotZoneDto> hotZoneDtos = new List<HotZoneDto>(); hotZoneDtos.Add(new HotZoneDto { Id = _hotZoneId, Latitude = (decimal)_latitudeToUse, Longitude = (decimal)_longitudeToUse, Name = "Hot Zone" }); dataContext.HotZoneDtos.InsertAllOnSubmit(hotZoneDtos); dataContext.SubmitChanges(); List<ZombiePackDto> zombiePackDtos = new List<ZombiePackDto>(); zombiePackDtos.Add(new ZombiePackDto { HotZoneId = _hotZoneId, Id = _zombiePackId, Latitude = (decimal)_latitudeToUse, Longitude = (decimal)_longitudeToUse, Name = "Zombie Pack1" }); zombiePackDtos.Add(new ZombiePackDto { HotZoneId = _hotZoneId, Id = _zombiePackId2, Latitude = (decimal)_latitudeToUse2, Longitude = (decimal)_longitudeToUse2, Name = "Zombie Pack2" }); dataContext.ZombiePackDtos.InsertAllOnSubmit(zombiePackDtos); dataContext.SubmitChanges(); } }
public void TestInitialize() { TestDataContext dataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); UserDto userDto = new UserDto { Id = _populatedUserId, DisplayName = "name", Email = "email", LastEnergy = 50, LastEnergyDate = DateTime.Today, Latitude = 0, LocationId = Guid.NewGuid(), Longitude = 0, BaseLineEnergy = 100, ZoneId = Guid.NewGuid() }; dataContext.UserDtos.InsertOnSubmit(userDto); userDto = new UserDto { Id = _emptyUserId, DisplayName = "name", Email = "email", LastEnergy = null, LastEnergyDate = null, Latitude = 0, LocationId = Guid.NewGuid(), Longitude = 0, BaseLineEnergy = 0, ZoneId = Guid.NewGuid() }; dataContext.UserDtos.InsertOnSubmit(userDto); dataContext.SubmitChanges(); }
public void TestCleanup() { TestDataContext dataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); dataContext.ZombiePackDtos.DeleteOnSubmit(dataContext.ZombiePackDtos.Single(s => s.Id == _zombiePackId)); dataContext.SubmitChanges(); }
public void TestCleanup() { _connectionString = DalTestContextSpecification.ConnectionString; using (TestDataContext testDataContext = new TestDataContext(_connectionString)) { testDataContext.UserCountDtos.DeleteAllOnSubmit( testDataContext.UserCountDtos.Where(s => s.UserId == _userId)); testDataContext.SubmitChanges(); } }
public void CleanUp() { using (TestDataContext dataContext = new TestDataContext(_connectionString)) { dataContext.HotZoneDtos.DeleteAllOnSubmit( dataContext.HotZoneDtos.Where(c => c.Id == _hotZoneId)); dataContext.ZombiePackDtos.DeleteAllOnSubmit( dataContext.ZombiePackDtos.Where(c => c.Id == _zombiePackId || c.Id == _zombiePackId2)); dataContext.SubmitChanges(); } }
private Guid GivenHotZone(string name) { TestDataContext testDataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); Guid hotZoneId = Guid.NewGuid(); HotZoneDto hotZoneDto = new HotZoneDto { Id = hotZoneId, CanStartHere = false, Latitude = 0, Longitude = 0, Name = name }; _hotZonesIds.Add(hotZoneId); testDataContext.HotZoneDtos.InsertOnSubmit(hotZoneDto); testDataContext.SubmitChanges(); return hotZoneId; }
private Guid GivenZombiePackInHotZone(Guid hotzoneId, string name) { TestDataContext testDataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); Guid zombiePackId = Guid.NewGuid(); _zombiePackIds.Add(zombiePackId); ZombiePackDto zombiePackDto = new ZombiePackDto { HotZoneId = hotzoneId, Id = zombiePackId, Latitude = 0, Longitude = 0, Name = name }; testDataContext.ZombiePackDtos.InsertOnSubmit(zombiePackDto); testDataContext.SubmitChanges(); return zombiePackId; }
private void GivenAllZombiesDestroyedIn(Guid userId, Guid zombiePackId) { TestDataContext testDataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); UserZombiePackProgressDto userZombiePackProgressDto = new UserZombiePackProgressDto { Id = Guid.NewGuid(), IsDestroyed = true, LastHuntDate = DateTime.Today, LastRegen = DateTime.Today, MaxZombies = 5, RegenMinuteTicks = 10, RegenZombieRate = 10, UserId = userId, ZombiePackId = zombiePackId, ZombiesLeft = 0 }; testDataContext.UserZombiePackProgressDtos.InsertOnSubmit(userZombiePackProgressDto); testDataContext.SubmitChanges(); }
private void GivenUserWithFacebookId(long facebookUserId) { TestDataContext testDataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); testDataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); UserDto userDto = new UserDto { BaseLineAttackPower = 0, BaseLineEnergy = 0, PossibleItemAmount = 0, CurrentBaseAttack = 0, CurrentBaseEnergy = 0, DisplayName = string.Empty, Email = string.Empty, FacebookUserId = facebookUserId, Id = Guid.NewGuid(), Latitude = 0, ZoneId = Guid.Empty }; testDataContext.UserDtos.InsertOnSubmit(userDto); testDataContext.SubmitChanges(); }
public void BeacauseOf() { using (TestDataContext dataConext = new TestDataContext(_connectionString)) { List<UserDto> userDtos = new List<UserDto>(); userDtos.Add(new UserDto { DisplayName = _displayName, Email = _email, Id = _idToUse, Latitude = (decimal)_lattitude, LocationId = _locationIdToUse, Longitude = (decimal)_longitude, ZoneId = _zoneIdToUse, Money = _money, LastVisitedHotZoneId = _lastVisitedHotZoneId, BaseLineAttackPower = 1, BaseLineEnergy = 100, Level = 5, PossibleItemAmount = _possibleItemAmount1, CurrentBaseAttack = 1, CurrentBaseEnergy = 100, FacebookUserId = 200 }); userDtos.Add(new UserDto { DisplayName = _displayName2, Email = _email2, Id = _idToUse2, Latitude = (decimal)_lattitude2, LocationId = _locationIdToUse2, Longitude = (decimal)_longitude2, ZoneId = _zoneIdToUse2, BaseLineAttackPower = 1, BaseLineEnergy = 100, Money = _money2, PossibleItemAmount = _possibleItemAmount2 }); dataConext.UserDtos.InsertAllOnSubmit(userDtos); dataConext.SubmitChanges(); } }
public void TestCleanup() { TestDataContext testDataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); testDataContext.UserCountDtos.DeleteAllOnSubmit(testDataContext.UserCountDtos.Where(s => _userIds.Contains(s.UserId.Value))); testDataContext.SubmitChanges(); testDataContext.UserDtos.DeleteAllOnSubmit(testDataContext.UserDtos.Where(s => _userIds.Contains(s.Id))); testDataContext.SubmitChanges(); }
public void BecauseOf() { using (TestDataContext dataContext = new TestDataContext(_connectionString)) { List<SafeHouseDto> safeHouseDtos = new List<SafeHouseDto>(); safeHouseDtos.Add(new SafeHouseDto { Id = _safeHouseId1, Latitude = (decimal)_safeHouseLat1, Longitude = (decimal)_safeHouseLong1, HotZoneId = _hotZoneId }); safeHouseDtos.Add(new SafeHouseDto { Id = _safeHouseId2, Latitude = (decimal)_safeHouseLat2, Longitude = (decimal)_safeHouseLong2, HotZoneId = _hotZoneId }); safeHouseDtos.Add(new SafeHouseDto { Id = _safeHouseId3, Latitude = (decimal)_safeHouseLat3, Longitude = (decimal)_safeHouseLong3, HotZoneId = _hotZoneId }); dataContext.SafeHouseDtos.InsertAllOnSubmit(safeHouseDtos); List<SafeHouseItemDto> safeHouseItemDtos = new List<SafeHouseItemDto>(); safeHouseItemDtos.Add(new SafeHouseItemDto { Id = _safeHouseItemId1, ItemId = _itemId1, SafeHouseId = _safeHouseId1, UserId = _userId1 }); safeHouseItemDtos.Add(new SafeHouseItemDto { Id = _safeHouseItemId2, ItemId = _itemId2, SafeHouseId = _safeHouseId1, UserId = _userId1 }); safeHouseItemDtos.Add(new SafeHouseItemDto { Id = _safeHouseItemId3, ItemId = _itemId2, SafeHouseId = _safeHouseId1, UserId = _userId1 }); safeHouseItemDtos.Add(new SafeHouseItemDto { Id = _safehouseItemId4, ItemId = _itemId2, SafeHouseId = _safeHouseId3, UserId = _userId3 }); List<ItemDto> itemDtos = new List<ItemDto>(); itemDtos.Add(new ItemDto { Id = _itemId1, Description = _itemDescription1, Distance = _itemDistance1, Energy = _itemEnergy1, Name = _itemName1, Price = _itemPrice1 }); itemDtos.Add(new ItemDto { Id = _itemId2, Description = _itemDescription2, Distance = _itemDistance2, Energy = _itemEnergy2, Name = _itemName2, Price = _itemPrice2 }); itemDtos.Add(new ItemDto { Id = _itemId3, Description = _itemDescription3, Distance = _itemDistance3, Energy = _itemEnergy3, Name = _itemName3, Price = _itemPrice3 }); dataContext.SafeHouseItemDtos.InsertAllOnSubmit(safeHouseItemDtos); dataContext.SubmitChanges(); } }
public void TestCleanup() { _connectionString = DalTestContextSpecification.ConnectionString; TestDataContext testDataContext = new TestDataContext(_connectionString); testDataContext.UserCountDtos.DeleteOnSubmit(testDataContext.UserCountDtos.Single(s => s.UserId == _userId)); if (testDataContext.UserCountDtos.Any(s => s.UserId == _nonExistantUserId)) { testDataContext.UserCountDtos.DeleteOnSubmit(testDataContext.UserCountDtos.Single(s => s.UserId == _nonExistantUserId)); } testDataContext.UserDtos.DeleteAllOnSubmit(testDataContext.UserDtos.Where(u => u.Id == _userId)); testDataContext.SubmitChanges(); }
public void should_set_last_energy_date_to_datetimenow_if_its_null_but_last_energy_isnt() { TestDataContext dataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); var dto = dataContext.UserDtos.Single(s => s.Id == _emptyUserId); dto.LastEnergy = 80; dataContext.SubmitChanges(); Contract.Tuple<int, DateTime> energy = _userRetriever.GetLastSavedEnergy(_emptyUserId); Assert.AreEqual(80, energy.Item1); Assert.AreEqual(DateTime.Now.ToString(), energy.Item2.ToString()); }
public void CleanUp() { using (TestDataContext dataContext = new TestDataContext(_connectionString)) { dataContext.StoreDtos.DeleteAllOnSubmit( dataContext.StoreDtos.Where(c => c.Id == _storeId1 || c.Id == _storeId2 || c.Id == _storeId3)); dataContext.ItemDtos.DeleteAllOnSubmit( dataContext.ItemDtos.Where(c => c.Id == _itemId1)); dataContext.SubmitChanges(); } }
public void BecauseOf() { using (TestDataContext dataContext = new TestDataContext(_connectionString)) { List<StoreDto> storeDtos = new List<StoreDto>(); storeDtos.Add(new StoreDto { Id = _storeId1, Latitude = (decimal)_latitude1, Longitude = (decimal)_longitude1, Name = _name1, HotZoneId = _hotZoneId }); storeDtos.Add(new StoreDto { Id = _storeId2, Latitude = (decimal)_latitude2, Longitude = (decimal)_longitude2, Name = _name2, HotZoneId = _hotZoneId }); storeDtos.Add(new StoreDto { Id = _storeId3, Latitude = (decimal)_latitude3, Longitude = (decimal)_longitude3, Name = _name3, HotZoneId = _hotZoneId }); dataContext.StoreDtos.InsertAllOnSubmit(storeDtos); List<ItemDto> itemDtos = new List<ItemDto>(); itemDtos.Add(new ItemDto { Description = _itemDescription1, Distance = _itemDistance1, Energy = _itemEnergy1, Id = _itemId1, Name = _itemName1, Price = _itemPrice1 }); dataContext.ItemDtos.InsertAllOnSubmit(itemDtos); dataContext.SubmitChanges(); _storeCount = dataContext.StoreDtos.Count(); _itemCount = dataContext.ItemDtos.Count(); } }
public void CleanUp() { using (TestDataContext dataContext = new TestDataContext(_connectionString)) { dataContext.UserDtos.DeleteAllOnSubmit( dataContext.UserDtos.Where(c => c.Id == _idToUse)); dataContext.HotZoneDtos.DeleteAllOnSubmit( dataContext.HotZoneDtos.Where(c => c.Id == _newHotZoneIdToUse)); dataContext.SubmitChanges(); } }
private Guid GivenUser(string name) { TestDataContext testDataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); Guid userId = Guid.NewGuid(); UserDto userDto = new UserDto { Id = userId, BaseLineAttackPower = 0, BaseLineEnergy = 0, CurrentBaseAttack = 0, CurrentBaseEnergy = 0, DisplayName = name, Email = string.Empty, FacebookUserId = 0, Latitude = 0, Level = 0, ZoneId = Guid.Empty }; testDataContext.UserDtos.InsertOnSubmit(userDto); testDataContext.SubmitChanges(); _userIds.Add(userId); return userId; }
private void GivenUser(int withFacebookId, int level, string name, long killed = 0, long miles = 0, long packs = 0, long hotzones = 0, long money = 0, long streak = 0) { TestDataContext testDataContext = new TestDataContext(DalTestContextSpecification.ConnectionString); Guid userId = Guid.NewGuid(); UserDto userDto = new UserDto { Id = userId, BaseLineAttackPower = 0, BaseLineEnergy = 0, CurrentBaseAttack = 0, CurrentBaseEnergy = 0, DisplayName = name, Email = string.Empty, FacebookUserId = withFacebookId, Latitude = 0, Level = level, ZoneId = Guid.Empty }; testDataContext.UserDtos.InsertOnSubmit(userDto); testDataContext.SubmitChanges(); UserCountDto userCountDto = new UserCountDto { AccumulatedMoney = money, HotZonesDestroyed = hotzones, Id = Guid.NewGuid(), Miles = miles, PeakAttack = streak, UserId = userId, ZombiePacksDestroyed = packs, ZombiesKilled = killed }; testDataContext.UserCountDtos.InsertOnSubmit(userCountDto); testDataContext.SubmitChanges(); _userIds.Add(userId); }
public void BecauseOf() { using (TestDataContext dataContext = new TestDataContext(_connectionString)) { List<UserDto> userDtos = new List<UserDto>(); userDtos.Add(new UserDto { Id = _userId, DisplayName = "Display Name", ZoneId = _hotZoneId, Latitude = (decimal)_latitude, Longitude = (decimal)_longitude, LocationId = _hotZoneId, Email = "*****@*****.**" }); dataContext.UserDtos.InsertAllOnSubmit(userDtos); dataContext.SubmitChanges(); List<ZombiePackDto> zombiePackDtos = new List<ZombiePackDto>(); zombiePackDtos.Add(new ZombiePackDto { HotZoneId = _hotZoneId, Id = _zombiePackId1, Latitude = (decimal)_zombiePackLat1, Longitude = (decimal)_zombiePackLong1, Name = "Zombie Pack 1" }); zombiePackDtos.Add(new ZombiePackDto { HotZoneId = _hotZoneId2, Id = _zombiePackId2, Latitude = (decimal)_zombiePackLat1, Longitude = (decimal)_zombiePackLong2, Name = "Zombie Pack 2" }); dataContext.ZombiePackDtos.InsertAllOnSubmit(zombiePackDtos); dataContext.SubmitChanges(); List<HotZoneDto> hotZoneDtos = new List<HotZoneDto>(); hotZoneDtos.Add(new HotZoneDto { Id = _hotZoneId, Latitude = (decimal)_latitude, Longitude = (decimal)_longitude, Name = "Hot Zone 1" }); hotZoneDtos.Add(new HotZoneDto { Id = _hotZoneId2, Latitude = (decimal)_latitude2, Longitude = (decimal)_longitude2, Name = "Hot Zone 2" }); dataContext.HotZoneDtos.InsertAllOnSubmit(hotZoneDtos); dataContext.SubmitChanges(); List<UserZombiePackProgressDto> userZombiePackProgressDtos = new List<UserZombiePackProgressDto>(); userZombiePackProgressDtos.Add(new UserZombiePackProgressDto { Id = _userZombiePackProgressId, IsDestroyed = false, LastHuntDate = null, LastRegen = DateTime.Today.AddMinutes(-1), MaxZombies = 100, RegenMinuteTicks = 10, RegenZombieRate = 5, UserId = _userId, ZombiePackId = _hotZoneId, ZombiesLeft = 100 }); userZombiePackProgressDtos.Add(new UserZombiePackProgressDto { Id = _userZombiePackProgressId2, IsDestroyed = true, LastHuntDate = null, LastRegen = DateTime.Today.AddMinutes(-1), MaxZombies = 100, RegenMinuteTicks = 10, RegenZombieRate = 5, UserId = _userId, ZombiePackId = _hotZoneId2, ZombiesLeft = 0 }); dataContext.UserZombiePackProgressDtos.InsertAllOnSubmit(userZombiePackProgressDtos); dataContext.SubmitChanges(); } }