Exemplos de PersonRepository.SQL PeopleEntities.SaveChanges em C# (CSharp)

Exemplo n.º 1

Arquivo: SQLRepository.cs Projeto: jeremybytes/learning-interfaces

        public void DeletePerson(string lastName)
        {
            using (var context = new PeopleEntities())
            {
                var foundPerson = GetDataPerson(context, lastName);
                if (foundPerson == null)
                    return;

                context.DataPersons.Remove(foundPerson);
                context.SaveChanges();
            }
        }

Exemplo n.º 2

        public void DeletePerson(string lastName)
        {
            using (var context = new PeopleEntities())
            {
                var foundPerson = GetDataPerson(context, lastName);
                if (foundPerson == null)
                {
                    return;
                }

                context.DataPersons.Remove(foundPerson);
                context.SaveChanges();
            }
        }

Exemplo n.º 3

Arquivo: SQLRepository.cs Projeto: jeremybytes/learning-interfaces

        public void UpdatePerson(string lastName, Person updatedPerson)
        {
            using (var context = new PeopleEntities())
            {
                var foundPerson = GetDataPerson(context, lastName);
                if (foundPerson == null)
                    return;

                foundPerson.FirstName = updatedPerson.FirstName;
                foundPerson.LastName = updatedPerson.LastName;
                foundPerson.StartDate = updatedPerson.StartDate;
                foundPerson.Rating = updatedPerson.Rating;

                context.SaveChanges();
            }
        }

Exemplo n.º 4

        public void UpdatePerson(string lastName, Person updatedPerson)
        {
            using (var context = new PeopleEntities())
            {
                var foundPerson = GetDataPerson(context, lastName);
                if (foundPerson == null)
                {
                    return;
                }

                foundPerson.FirstName = updatedPerson.FirstName;
                foundPerson.LastName  = updatedPerson.LastName;
                foundPerson.StartDate = updatedPerson.StartDate;
                foundPerson.Rating    = updatedPerson.Rating;

                context.SaveChanges();
            }
        }

Exemplo n.º 5

Arquivo: SQLRepository.cs Projeto: jeremybytes/learning-interfaces

        public void AddPerson(Person newPerson)
        {
            using (var context = new PeopleEntities())
            {
                if (GetDataPerson(context, newPerson.LastName) != null)
                    return;

                var person = new DataPerson()
                {
                    FirstName = newPerson.FirstName,
                    LastName = newPerson.LastName,
                    StartDate = newPerson.StartDate,
                    Rating = newPerson.Rating,
                };
                context.DataPersons.Add(person);
                context.SaveChanges();
            }
        }

Exemplo n.º 6

        public void AddPerson(Person newPerson)
        {
            using (var context = new PeopleEntities())
            {
                if (GetDataPerson(context, newPerson.LastName) != null)
                {
                    return;
                }

                var person = new DataPerson()
                {
                    FirstName = newPerson.FirstName,
                    LastName  = newPerson.LastName,
                    StartDate = newPerson.StartDate,
                    Rating    = newPerson.Rating,
                };
                context.DataPersons.Add(person);
                context.SaveChanges();
            }
        }