public JsonResult AllBands() { System.Console.WriteLine("Returning all bands"); List <Band> Bands = _context.Bands.ToList(); MyAllRecordsView results = new MyAllRecordsView(); Dictionary <string, object> bandName; foreach (Band band in Bands) { bandName = new Dictionary <string, object>(); if (band.DisplayName == null) { bandName.Add("Name", band.Name); } else { bandName.Add("Name", band.DisplayName); } bandName.Add("BandId", band.BandId); results.Data.Add(bandName); } // results.Songs = _context.Songs.ToList(); results.Success = true; results.Message = "Success! Returned some bands"; return(Json(results)); }
public JsonResult AllSongs() { System.Console.WriteLine("Returning all songs"); List <Song> Songs = _context.Songs.ToList(); MyAllRecordsView results = new MyAllRecordsView(); Dictionary <string, object> songName; foreach (Song song in Songs) { songName = new Dictionary <string, object>(); songName.Add("Name", song.Name); songName.Add("ID", song.SongId); songName.Add("RecordID", song.RecordId); songName.Add("Score", song.Score); results.Data.Add(songName); } // results.Songs = _context.Songs.ToList(); results.Success = true; results.Message = "Success! Returned some songs"; return(Json(results)); }
public JsonResult AllMusicians() { System.Console.WriteLine("Returning all musicians"); List <Musician> Musicians = _context.Musicians.ToList(); MyAllRecordsView results = new MyAllRecordsView(); Dictionary <string, object> musicianName; foreach (Musician musician in Musicians) { musicianName = new Dictionary <string, object>(); musicianName.Add("Name", musician.Name); musicianName.Add("ID", musician.MusicianId); if (musician.GivenName != null) { musicianName.Add("GivenName", musician.GivenName); } results.Data.Add(musicianName); } // results.Songs = _context.Songs.ToList(); results.Success = true; results.Message = "Success! Returned " + results.Data.Count() + " musicians"; return(Json(results)); }
public JsonResult AllCities() { System.Console.WriteLine("Returning all cities"); List <City> Cities = _context.Cities.ToList(); MyAllRecordsView results = new MyAllRecordsView(); int rows = 0; Dictionary <string, object> cityName; foreach (City city in Cities) { cityName = new Dictionary <string, object>(); cityName.Add("Name", city.Name); cityName.Add("State", city.State); cityName.Add("Country", city.Country); cityName.Add("CityId", city.CityId); results.Data.Add(cityName); rows += 1; } // results.Songs = _context.Songs.ToList(); results.Success = true; results.Rows = rows; results.Message = "Success! Returned " + rows + " cities"; return(Json(results)); }
public JsonResult AllTags() { System.Console.WriteLine("Returning all tags"); List <Tag> Tags = _context.Tags.ToList(); MyAllRecordsView results = new MyAllRecordsView(); Dictionary <string, object> tagName; foreach (Tag tag in Tags) { tagName = new Dictionary <string, object>(); tagName.Add("TagID", tag.TagId); tagName.Add("Name", tag.Name); tagName.Add("Genre", tag.Genre); results.Data.Add(tagName); } // results.Songs = _context.Songs.ToList(); results.Success = true; results.Message = "Success! Returned " + results.Data.Count() + " tags"; return(Json(results)); }
public JsonResult AllYears(int year) { System.Console.WriteLine("Returning records with year " + year); MyAllRecordsView results = new MyAllRecordsView(); List <Record> Records = _context.Records.Where(x => x.Year == year).ToList(); Dictionary <string, object> recordName; foreach (Record record in Records) { recordName = new Dictionary <string, object>(); recordName.Add("Name", record.Name); recordName.Add("ID", record.RecordId); recordName.Add("BandId", record.BandId); results.Data.Add(recordName); } // results.Songs = _context.Songs.ToList(); results.Success = true; results.Message = "Success! Returned some records with year " + year; return(Json(results)); }
public JsonResult AllRecords() { System.Console.WriteLine("Returning all records"); List <Record> Records = _context.Records.ToList(); MyAllRecordsView results = new MyAllRecordsView(); Dictionary <string, object> recordName; foreach (Record record in Records) { recordName = new Dictionary <string, object>(); recordName.Add("Name", record.Name); recordName.Add("ID", record.RecordId); recordName.Add("BandId", record.BandId); results.Data.Add(recordName); } // results.Songs = _context.Songs.ToList(); results.Success = true; results.Message = "Success! Returned " + results.Data.Count() + " records"; return(Json(results)); }