public void GetOneAddressByID() { using (EFAddressMapper mapper = new EFAddressMapper(CONNECTION_STRING)) { Assert.AreEqual(AddressClassic1.Road, mapper.FindBy(2).Road); } }
public void AddAddressWithoutCountry() { using (EFAddressMapper mapper = new EFAddressMapper(CONNECTION_STRING)) { mapper.AddorUpdate(AddressWithoutCountry); } }
public void GetAllAddress() { using (EFAddressMapper mapper = new EFAddressMapper(CONNECTION_STRING)) { Assert.AreEqual(3, mapper.GetAll().Count); } }
public void GetOneAddressBysearch() { using (EFAddressMapper mapper = new EFAddressMapper(CONNECTION_STRING)) { Expression <Func <Address, bool> > expression = a => a.Road == AddressClassic2.Road && a.Number == AddressClassic2.Number; Assert.AreEqual(1, mapper.FindBy(expression).Count); } }
public void AddEmptyAddress() { using (EFAddressMapper mapper = new EFAddressMapper(CONNECTION_STRING)) { mapper.AddorUpdate(AddressEmpty); Assert.AreEqual(3, mapper.GetAll().Count); } }
public void AddAddressWithoutPostalCode() { using (EFAddressMapper mapper = new EFAddressMapper(CONNECTION_STRING)) { mapper.AddorUpdate(AddressWithoutPostalCode); Assert.AreEqual(3, mapper.GetAll().Count); } }
public void AddAddressClassic() { using (EFAddressMapper mapper = new EFAddressMapper(CONNECTION_STRING)) { mapper.AddorUpdate(AddressClassic1); Assert.AreEqual(1, mapper.GetAll().Count); } }
public void DeleteAddress() { using (EFAddressMapper mapper = new EFAddressMapper(CONNECTION_STRING)) { mapper.Delete(3); Expression <Func <Address, bool> > expression = a => a.ID == 3; Assert.AreEqual(0, mapper.FindBy(expression).Count); } }
public void AddAddresses() { List <Address> adresses = new List <Address> { AddressClassic1, AddressClassic2 }; using (EFAddressMapper mapper = new EFAddressMapper(CONNECTION_STRING)) { mapper.AddorUpdate(adresses); Assert.AreEqual(3, mapper.GetAll().Count); } }
public void UpdateAddress() { using (EFAddressMapper mapper = new EFAddressMapper(CONNECTION_STRING)) { AddressClassic3 = mapper.AddorUpdate(AddressClassic3); AddressClassic3.Number = "105"; mapper.AddorUpdate(AddressClassic3); Expression <Func <Address, bool> > expression = a => a.ID == AddressClassic3.ID; Assert.AreEqual("105", mapper.FindBy(AddressClassic3.ID).Number); } }
public void Setup() { addresses = new List <Address> { new Address() { Country = "Belgique", Locality = "Ouffet", Number = "7", PostalCode = "4590", Road = "Sauveniere" }, new Address() { Country = "Belgique", Locality = "Liege", Number = "82", PostalCode = "4000", Road = "Leman" }, new Address() { Country = "France", Locality = "Paris", Number = "100", PostalCode = "10000", Road = "efle" }, new Address() { Country = "Italie", Locality = "Rome", Number = "97", PostalCode = "8520", Road = "pize" } }; using (EFAddressMapper mapper = new EFAddressMapper(CONNECTION_STRING)) { addresses = mapper.AddorUpdate(addresses); } users = new List <User> { new User() { Login = "******", Password = "******", Name = "bologne", LastName = "sauce", Email = "*****@*****.**", Phone = "0475859565", Rank = UserRank.Member, Address = addresses[0] } , new User() { Login = "******", Password = "******", Name = "coucou", LastName = "carle", Email = "*****@*****.**", Phone = "0465958565", Rank = UserRank.Member, Address = addresses[1] } , new User() { Login = "******", Password = "******", Name = "polo", LastName = "lolo", Email = "*****@*****.**", Phone = "0456958565", Rank = UserRank.Member, Address = addresses[2] } }; using (EFUserMapper mapper = new EFUserMapper(CONNECTION_STRING)) { users = mapper.AddorUpdate(users); } journeyClassic1 = new Journey() { Description = "trajet 1", Driver = users[0], FreeSeat = 4, StartingAddress = addresses[0], DriverUpAddress = addresses[1], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>() }; journeyClassic2 = new Journey() { Description = "trajet 2", Driver = users[1], FreeSeat = 4, StartingAddress = addresses[2], DriverUpAddress = addresses[1], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>() }; journeyClassic3 = new Journey() { Description = "trajet 3", Driver = users[0], FreeSeat = 4, StartingAddress = addresses[3], DriverUpAddress = addresses[2], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>() }; journeyClassic4 = new Journey() { Description = "trajet 4", Driver = users[0], FreeSeat = 4, StartingAddress = addresses[3], DriverUpAddress = addresses[2], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>() }; journeyWithoutDescription = new Journey() { Driver = users[0], FreeSeat = 4, StartingAddress = addresses[0], DriverUpAddress = addresses[1], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>() }; journeyWithoutFreeSeat = new Journey() { Description = "trajet 1", Driver = users[0], StartingAddress = addresses[0], DriverUpAddress = addresses[1], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>() }; journeyWithoutDriver = new Journey() { Description = "trajet 1", FreeSeat = 4, StartingAddress = addresses[0], DriverUpAddress = addresses[1], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>() }; journeyWithoutStartingAddress = new Journey() { Description = "trajet 1", Driver = users[0], FreeSeat = 4, DriverUpAddress = addresses[1], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>() }; journeyWithoutDriverUpAddress = new Journey() { Description = "trajet 1", Driver = users[0], FreeSeat = 4, StartingAddress = addresses[0], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>() }; journeyWithoutStartingDateTime = new Journey() { Description = "trajet 1", Driver = users[0], FreeSeat = 4, StartingAddress = addresses[0], DriverUpAddress = addresses[1], DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>() }; journeyWithoutDriverUpDateTime = new Journey() { Description = "trajet 1", Driver = users[0], FreeSeat = 4, StartingAddress = addresses[0], DriverUpAddress = addresses[1], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), Passengers = new List <User>() }; journeyEmpty = new Journey(); }
public void Setup() { EFAddressMapper addressMapper = new EFAddressMapper("Test-WebProject2017-DB"); addresses = new List <Address> { new Address() { Country = "Belgique", Locality = "Ouffet", Number = "7", PostalCode = "4590", Road = "Sauveniere" }, new Address() { Country = "Belgique", Locality = "Liege", Number = "82", PostalCode = "4000", Road = "Leman" } }; AddressClassic3 = new Address() { Country = "France", Locality = "Paris", Number = "100", PostalCode = "10000", Road = "efle" }; using (EFAddressMapper mapper = new EFAddressMapper(CONNECTION_STRING)) { addresses = mapper.AddorUpdate(addresses); } userClassic1 = new User() { Login = "******", Password = "******", Name = "bologne", LastName = "sauce", Email = "*****@*****.**", Phone = "0475859565", Rank = UserRank.Member, Address = addresses.First() }; userClassic2 = new User() { Login = "******", Password = "******", Name = "coucou", LastName = "carle", Email = "*****@*****.**", Phone = "0465958565", Rank = UserRank.Member, Address = addresses.Last() }; userClassic3 = new User() { Login = "******", Password = "******", Name = "polo", LastName = "lolo", Email = "*****@*****.**", Phone = "0456958565", Rank = UserRank.Member, Address = addresses.Last() }; userClassic4 = new User() { Login = "******", Password = "******", Name = "polo", LastName = "lolo", Email = "*****@*****.**", Phone = "0456958565", Rank = UserRank.Member, Address = addresses.Last() }; userClassic5 = new User() { Login = "******", Password = "******", Name = "polo", LastName = "lolo", Email = "*****@*****.**", Phone = "0456958565", Rank = UserRank.Member, Address = addresses.Last() }; userWithoutLogin = new User() { Password = "******", Name = "bologne", LastName = "sauce", Email = "*****@*****.**", Phone = "0475859565", Rank = UserRank.Member, Address = addresses.First() }; userWithoutPassword = new User() { Login = "******", Name = "bologne", LastName = "sauce", Email = "*****@*****.**", Phone = "0475859565", Rank = UserRank.Member, Address = addresses.First() }; userWithoutName = new User() { Login = "******", Password = "******", LastName = "sauce", Email = "*****@*****.**", Phone = "0475859565", Rank = UserRank.Member, Address = addresses.First() }; userWithoutLastName = new User() { Login = "******", Password = "******", Name = "bologne", Email = "*****@*****.**", Phone = "0475859565", Rank = UserRank.Member, Address = addresses.First() }; userWithoutEmail = new User() { Login = "******", Password = "******", Name = "bologne", LastName = "sauce", Phone = "0475859565", Rank = UserRank.Member, Address = addresses.First() }; userWithoutPhone = new User() { Login = "******", Password = "******", Name = "bologne", LastName = "sauce", Email = "*****@*****.**", Rank = UserRank.Member, Address = addresses.First() }; userWithoutAddress = new User() { Login = "******", Password = "******", Name = "bologne", LastName = "sauce", Email = "*****@*****.**", Phone = "0475859565", Rank = UserRank.Member }; userWithoutUserRank = new User() { Login = "******", Password = "******", Name = "bologne", LastName = "sauce", Email = "*****@*****.**", Phone = "0475859565", Address = addresses.First() }; userEmpty = new User(); }