private DataPerson GetDataPerson(PeopleEntities context, string lastName) { DataPerson foundPerson = null; foundPerson = (from p in context.DataPersons where p.LastName == lastName select p).FirstOrDefault(); return(foundPerson); }
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(); } }
public Person GetPerson(string lastName) { Person person = null; using (var context = new PeopleEntities()) { var foundPerson = GetDataPerson(context, lastName); if (foundPerson != null) person = GetPersonFromDataPerson(foundPerson); } return person; }
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(); } }
public Person GetPerson(string lastName) { Person person = null; using (var context = new PeopleEntities()) { var foundPerson = GetDataPerson(context, lastName); if (foundPerson != null) { person = GetPersonFromDataPerson(foundPerson); } } return(person); }
public IEnumerable <Person> GetPeople() { using (var ctx = new PeopleEntities()) { var dataPeople = ctx.DataPersons.ToList(); var people = new List <Person>(); foreach (var dataPerson in dataPeople) { people.Add(new ApplicationPerson(dataPerson)); } return(people); } }
public IEnumerable <Person> GetPeople() { using (var ctx = new PeopleEntities()) { var people = from p in ctx.DataPersons select new Person { FirstName = p.FirstName, LastName = p.LastName, StartDate = p.StartDate.Value, Rating = p.Rating.Value, }; return(people.ToList()); } }
public IEnumerable<Person> GetPeople() { using (var ctx = new PeopleEntities()) { var people = from p in ctx.DataPersons select new Person { FirstName = p.FirstName, LastName = p.LastName, StartDate = p.StartDate.Value, Rating = p.Rating.Value, }; return people.ToList(); } }
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(); } }
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(); } }
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(); } }
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(); } }
public IEnumerable <Person> GetPeople() { using (var ctx = new PeopleEntities()) { var dataPeople = ctx.DataPersons.ToList(); var people = new List <Person>(); foreach (var dataPerson in dataPeople) { people.Add(new Person { FirstName = dataPerson.FirstName, LastName = dataPerson.LastName, StartDate = dataPerson.StartDate.Value, Rating = dataPerson.Rating.Value, }); } return(people); } }
public Person GetPerson(string lastName) { Person person = null; using (var context = new PeopleEntities()) { var foundPerson = GetDataPerson(context, lastName); if (foundPerson != null) { person = new Person() { FirstName = foundPerson.FirstName, LastName = foundPerson.LastName, StartDate = foundPerson.StartDate.Value, Rating = foundPerson.Rating.Value, } } ; } return(person); }
private DataPerson GetDataPerson(PeopleEntities context, string lastName) { throw new NotImplementedException(); }
private DataPerson GetDataPerson(PeopleEntities context, string lastName) { DataPerson foundPerson = null; foundPerson = (from p in context.DataPersons where p.LastName == lastName select p).FirstOrDefault(); return foundPerson; }