private void AddPersons(PersonInfoServiceDatabaseContext repository) { var persons = new List <Person>(); foreach (var pesel in Pesels) { persons.Add(new Person { PersonId = Guid.NewGuid(), Pesel = pesel, FirstName = FirstNames[_random.Next(0, FirstNames.Count - 1)], LastName = LastNmaes[_random.Next(0, LastNmaes.Count - 1)], BirthDate = new DateTime(_random.Next(1900, 2018), _random.Next(1, 12), _random.Next(1, 28)), InsuranceId = _random.Next(100000, 999999).ToString(), Address = new Address { AddressId = Guid.NewGuid(), Country = "Polska", Province = "Małopolska", ZipCode = $"{_random.Next(10,99)}-{_random.Next(100,999)}", City = Cities[_random.Next(0, Cities.Count - 1)], Street = Streets[_random.Next(0, Streets.Count - 1)], HomeNumber = $"{_random.Next(1,1000)}" } }); } persons.ForEach(s => repository.Persons.Add(s)); repository.SaveChanges(); }
public PersonTransferObject GetPersonInfo(string pesel) { Console.WriteLine("Pobranie informacji o konkretnej osobie"); var db = new PersonInfoServiceDatabaseContext(); var person = db.Persons.FirstOrDefault(p => p.Pesel == pesel); return(Mapper.Map <PersonTransferObject>(person)); }
public void Seed() { var personRepository = new PersonInfoServiceDatabaseContext(); if (personRepository.Persons.Any()) { return; } AddPersons(personRepository); }
public List <PersonTransferObject> FilterPersons(string pesel = null, string firstName = null, string lastName = null, string insuranceId = null, DateTime?birthDate = null) { Console.WriteLine("Filtrowanie osób"); var db = new PersonInfoServiceDatabaseContext(); var persons = db.Persons.Where(p => (pesel == null || p.Pesel.Contains(pesel)) && (firstName == null || p.FirstName.Contains(firstName)) && (lastName == null || p.LastName.Contains(lastName)) && (insuranceId == null || p.InsuranceId.Contains(insuranceId)) && (birthDate == null || (p.BirthDate.Day == birthDate.Value.Day && p.BirthDate.Month == birthDate.Value.Month && p.BirthDate.Year == birthDate.Value.Year))).ToList(); return(persons.Select(Mapper.Map <PersonTransferObject>).ToList()); }
public void GetDatabase() { var repository = new PersonInfoServiceDatabaseContext(); Assert.IsNotNull(repository); }