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));
}
