public static List <PersonViewModel> FindPeople(string url) { PeopleListDb _db = new PeopleListDb(); string searchCriteria = null; var strings = url.Split('/'); url = null; foreach (var item in strings) { if (item != "Home" && item != "SearchPeople" && item != "") { if (item.Contains("?")) { var change = item.Split('?'); if (change[0] == "undefined") { change[0] = null; } if (change.Count() < 2) { searchCriteria = change[0]; } else { url = change[0]; searchCriteria = change[1]; } } else { url = item; } } } var result = new List <Person>(); if (url == null) { if (searchCriteria == "Country") { result = _db.People.Include("ProfilePicture") .Include("Country").OrderBy(x => x.Country.CountryName).ToList(); } else if (searchCriteria == "LastName") { result = _db.People.Include("ProfilePicture") .Include("Country").OrderBy(x => x.LastName).ToList(); } else { result = _db.People.Include("ProfilePicture") .Include("Country").OrderBy(x => x.FirstName).ToList(); } } else { url.ToLower(); if (searchCriteria != null) { if (searchCriteria == "LastName") { result = _db.People.Include("ProfilePicture") .Include("Country") .OrderBy(x => x.LastName) .Where(x => x.FirstName.Contains(url) || x.LastName.Contains(url)) .ToList(); } else if (searchCriteria == "Country") { result = _db.People.Include("ProfilePicture") .Include("Country") .OrderBy(x => x.Country.CountryName).ThenBy(x => x.FirstName) .Where(x => x.Country.CountryName.Contains(url)) .ToList(); } else { result = _db.People.Include("ProfilePicture") .Include("Country") .OrderBy(x => x.FirstName) .Where(x => x.FirstName.Contains(url) || x.LastName.Contains(url)) .ToList(); } } } var model = new List <PersonViewModel>(); foreach (var item in result) { model.Add(new PersonViewModel(item)); } return(model); }
public static void IfEmptyPeopleDatabase() { PeopleListDb _db = new PeopleListDb(); var countries = _db.Countries.ToList(); var images = _db.Images.ToList(); List <Person> people = new List <Person>(); people.Add(new Person { FirstName = "John", LastName = "Smith", Email = "*****@*****.**" }); people[0].Country = countries.First(x => x.CountryName == "Denmark"); people[0].CountryId = countries.First(x => x.CountryName == "Denmark").CountryId; people[0].ProfilePicture = images.First(x => x.ImageName == "Img3"); people[0].ProfilePictureId = images.First(x => x.ImageName == "Img3").ImageId; people.Add(new Person { FirstName = "Jane", LastName = "Smith", Email = "*****@*****.**" }); people[1].Country = countries.First(x => x.CountryName == "Denmark"); people[1].CountryId = countries.First(x => x.CountryName == "Denmark").CountryId; people[1].ProfilePicture = images.First(x => x.ImageName == "Img5"); people[1].ProfilePictureId = images.First(x => x.ImageName == "Img5").ImageId; people.Add(new Person { FirstName = "Happy", LastName = "Hogan", Email = "*****@*****.**" }); people[2].Country = countries.First(x => x.CountryName == "Denmark"); people[2].CountryId = countries.First(x => x.CountryName == "Denmark").CountryId; people[2].ProfilePicture = images.First(x => x.ImageName == "Img6"); people[2].ProfilePictureId = images.First(x => x.ImageName == "Img6").ImageId; people.Add(new Person { FirstName = "Olaf", LastName = "Snowman", Email = "*****@*****.**" }); people[3].Country = countries.First(x => x.CountryName == "Norway"); people[3].CountryId = countries.First(x => x.CountryName == "Norway").CountryId; people[3].ProfilePicture = images.First(x => x.ImageName == "Img4"); people[3].ProfilePictureId = images.First(x => x.ImageName == "Img4").ImageId; foreach (var item in people) { _db.People.Add(item); } ; _db.SaveChanges(); }