public async Task <IActionResult> Edit(string id, [Bind("ListenerID,BandID,Note")] BandListener bandListener)
{
if (id != bandListener.BandID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(bandListener);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BandListenerExists(bandListener.BandID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["BandID"] = new SelectList(_context.Bands, "BandID", "BandID", bandListener.BandID);
ViewData["ListenerID"] = new SelectList(_context.Listeners, "ListenerID", "ListenerID", bandListener.ListenerID);
return(View(bandListener));
}
public async Task <IActionResult> Create([Bind("ListenerID,BandID,Note")] BandListener bandListener)
{
if (ModelState.IsValid)
{
_context.Add(bandListener);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["BandID"] = new SelectList(_context.Bands, "BandID", "BandID", bandListener.BandID);
ViewData["ListenerID"] = new SelectList(_context.Listeners, "ListenerID", "ListenerID", bandListener.ListenerID);
return(View(bandListener));
}
public static void Initialize(MusicContext context)
{
context.Database.EnsureCreated();
if (context.Listeners.Any())
{
return;
}
var listeners = new Listener[] {
new Listener {
Name = "Ola", DateOfBirth = DateTime.Parse("1999-12-01")
},
new Listener {
Name = "Malgorzata", DateOfBirth = DateTime.Parse("1999-12-01")
},
new Listener {
Name = "Jan", DateOfBirth = DateTime.Parse("1999-12-01")
},
new Listener {
Name = "Julia", DateOfBirth = DateTime.Parse("1999-12-01")
},
};
foreach (Listener l in listeners)
{
context.Listeners.Add(l);
}
context.SaveChanges();
var bands = new Band[] {
new Band {
BandID = "Tool", City = "New York", FormationDate = DateTime.Parse("2012-01-01"), Genre = Genre.art
},
new Band {
BandID = "Jamie xx", City = "London", FormationDate = DateTime.Parse("2017-01-01"), Genre = Genre.folk
},
new Band {
BandID = "Janes Addiciton", City = "Los Angeles", FormationDate = DateTime.Parse("1989-01-01"), Genre = Genre.pop
},
new Band {
BandID = "Aesop Rock", City = "Los Angeles", Genre = Genre.pop
},
};
foreach (Band b in bands)
{
context.Bands.Add(b);
}
context.SaveChanges();
var bandsListeners = new BandListener[] {
new BandListener {
ListenerID = 1, BandID = "Tool", Note = 4
},
new BandListener {
ListenerID = 1, BandID = "Janes Addiciton", Note = 2
},
new BandListener {
ListenerID = 2, BandID = "Aesop Rock", Note = 4
},
new BandListener {
ListenerID = 3, BandID = "Jamie xx", Note = 5
},
new BandListener {
ListenerID = 4, BandID = "Aesop Rock", Note = 2
},
};
foreach (BandListener bl in bandsListeners)
{
context.BandsListeners.Add(bl);
}
context.SaveChanges();
var tours = new Tour[] {
new Tour {
BandID = "Tool", City = "Gdynia", Date = DateTime.Parse("2017-06-01")
},
new Tour {
BandID = "Tool", City = "Warszawa", Date = DateTime.Parse("2017-07-01")
},
new Tour {
BandID = "Tool", City = "Katowice", Date = DateTime.Parse("2017-01-01")
},
new Tour {
BandID = "Jamie xx", City = "Berlin", Date = DateTime.Parse("2017-02-01")
},
new Tour {
BandID = "Jamie xx", City = "Moscow", Date = DateTime.Parse("2017-03-01")
},
new Tour {
BandID = "Aesop Rock", City = "Peking", Date = DateTime.Parse("2017-04-01")
},
new Tour {
BandID = "Aesop Rock", City = "Oslo", Date = DateTime.Parse("2017-05-01")
},
};
foreach (var t in tours)
{
context.Tours.Add(t);
}
context.SaveChanges();
}
