/// <summary> /// Method to add the currentPerson information to the database. /// </summary> /// <param name="newPerson"></param> /// <returns></returns> public void addPerson(Person newPerson) { //Adding person to DB. using (var db = new PersonDBContext()) { db.People.Add(newPerson); db.SaveChanges(); } }
/// <summary> /// This method returns a list of people in the DB that have a matching first or last name. /// </summary> /// <param name="name"></param> /// <returns></returns> public List <Person> personQuery(string name) { //List of people with the name. List <Person> peopleList = new List <Person>(); //DO QUEREY using (var context = new PersonDBContext()) { // Query for all blogs with names starting with B var query = from b in context.People where b.FirstName.Trim().ToUpper() == name.Trim().ToUpper() || b.LastName.Trim().ToUpper() == name.Trim().ToUpper() select b; foreach (var item in query) { peopleList.Add(item); } } return(peopleList); }