Exemplo n.º 1
0
        private void UpdatePerson(PersonDbContext context, Person personWithNewData, Person personInDb)
        {
            context.Entry <Person>(personInDb).CurrentValues.SetValues(personWithNewData);
            var contactsInDb = personInDb.Contacts.ToList();

            foreach (var contactInDb in contactsInDb)
            {
                var contact = personWithNewData.Contacts.SingleOrDefault(i => i.Id == contactInDb.Id);
                if (contact != null)
                {
                    context.Entry(contactInDb).CurrentValues.SetValues(contact);
                }
                else
                {
                    context.Contacts.Remove(contactInDb);
                }
            }
            foreach (var contact in personWithNewData.Contacts)
            {
                if (!personInDb.Contacts.Any(c => c.Id == contact.Id))
                {
                    contact.Person = personInDb;
                    personInDb.Contacts.Add(contact);
                }
            }
        }
Exemplo n.º 2
0
        //public SQLitePersonRepository(IKeyGenerator<long> personKeyGenerator, IKeyGenerator<string> contactKeyGenerator)
        //{
        //    _personKeyGenerator = personKeyGenerator;
        //    _contactKeyGenerator = contactKeyGenerator;
        //}

        public List <Person> GetAllPeople()
        {
            using (var context = new PersonDbContext())
            {
                var people = (from p in context.People.Include(p => p.Contacts) select p).ToList();
                return(people);
            }
        }
Exemplo n.º 3
0
 public void DeletePerson(Person person)
 {
     using (var context = new PersonDbContext())
     {
         var personInDb = context.People.SingleOrDefault(p => p.Id == person.Id);
         if (personInDb != null)
         {
             context.People.Remove(personInDb);
             context.SaveChanges();
         }
     }
 }
Exemplo n.º 4
0
 public void SavePerson(Person person)
 {
     person = SetIdsForNewEntities(person);
     using (var context = new PersonDbContext())
     {
         var personInDb = context.People.Include(p => p.Contacts).SingleOrDefault(p => p.Id == person.Id);
         if (personInDb == null)
         {
             InsertPerson(context, person);
         }
         else
         {
             UpdatePerson(context, person, personInDb);
         }
         context.SaveChanges();
     }
 }
Exemplo n.º 5
0
 private void InsertPerson(PersonDbContext context, Person person)
 {
     context.People.Add(person);
 }