//
// GET: /Artist/
public ActionResult Index()
{
using (var ctx = new ChinookEntities())
{
var artistCollection = ctx.Artists.OrderByDescending(t => t.ArtistId).ToList();
return View(artistCollection);
}
}
public ActionResult Edit(int id)
{
using (var ctx = new ChinookEntities())
{
var artist = ctx.Artists.Single(t => t.ArtistId == id);
return View(artist);
}
}
public ActionResult Edit(Artist artist)
{
using (var ctx = new ChinookEntities())
{
var a = ctx.Artists.Single(t => t.ArtistId == artist.ArtistId);
a.Name = artist.Name;
ctx.SaveChanges();
return RedirectToAction("Index");
}
}
public ActionResult Delete(int id)
{
using (var ctx = new ChinookEntities())
{
var artist = ctx.Artists.Single(t => t.ArtistId == id);
ctx.Artists.Remove(artist);
ctx.SaveChanges();
return RedirectToAction("Index");
}
}
public ActionResult Create(Artist artist)
{
using (var ctx = new ChinookEntities())
{
var id = ctx.Artists.OrderByDescending(t => t.ArtistId).First().ArtistId;
artist.ArtistId = ++id;
ctx.Artists.Add(artist);
ctx.SaveChanges();
return RedirectToAction("Index");
}
}
