public async Task <ActionResult <BandDetails> > PostBandDetails(BandDetails bandDetails)
{
_context.BandDetails.Add(bandDetails);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetBandDetails", new { id = bandDetails.Id }, bandDetails));
}
public async Task <IActionResult> PutBandDetails(int id, BandDetails bandDetails)
{
if (id != bandDetails.Id)
{
return(BadRequest());
}
_context.Entry(bandDetails).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BandDetailsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public BandDetailsController(BandDetails bandDetails)
{
if (bandDetails == null)
{
throw new ArgumentNullException(nameof(bandDetails));
}
this.bandDetails = bandDetails;
}
// GET: Bands/Details/5
//Details page will show a list of authors in that band
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//getting the band
Bands band = db.Bands.SqlQuery("select * from Bands where bandid = @id", new SqlParameter("id", id)).FirstOrDefault();
if (band == null)
{
return(HttpNotFound());
}
//getting the artists in this band (if any)
string query = "select * from Artists where bandid=" + id;
List <Artists> artists = db.Artists.SqlQuery(query).ToList();
BandDetails viewModel = new BandDetails();
viewModel.band = band;
viewModel.artists = artists;
return(View(viewModel));
}
