public JsonResult Search(String searchTerm = null, String searchType = "quote") { sixteenBars.Models.SixteenBarsDb db = new Models.SixteenBarsDb(); List <Library.Quote> SearchResults = new List <Library.Quote>(); switch (searchType) { case "album": SearchResults = (from q in db.Quotes where q.Track.Album.Title.Contains(searchTerm) select q).ToList(); break; case "artist": SearchResults = (from q in db.Quotes where q.Artist.Name.Contains(searchTerm) select q).ToList(); break; case "track": SearchResults = (from q in db.Quotes where q.Track.Title.Contains(searchTerm) select q).ToList(); break; default: SearchResults = (from q in db.Quotes where q.Text.Contains(searchTerm) select q).ToList(); break; } return(this.Json(SearchResults)); }
public JsonResult Search(String searchTerm = null, String searchType="quote") { sixteenBars.Models.SixteenBarsDb db = new Models.SixteenBarsDb(); List<Library.Quote> SearchResults = new List<Library.Quote>(); switch (searchType) { case "album": SearchResults = (from q in db.Quotes where q.Track.Album.Title.Contains(searchTerm) select q).ToList(); break; case "artist": SearchResults = (from q in db.Quotes where q.Artist.Name.Contains(searchTerm) select q).ToList(); break; case "track": SearchResults = (from q in db.Quotes where q.Track.Title.Contains(searchTerm) select q).ToList(); break; default: SearchResults = (from q in db.Quotes where q.Text.Contains(searchTerm) select q).ToList(); break; } return this.Json(SearchResults); }