//
// GET: /Quote/Create
public ActionResult Create()
{
QuoteViewModel quoteVM = new QuoteViewModel();
var artists = db.Artists.ToList();
artists.Add(new Artist() { Name = "Add New Artist", Id = -1 });
quoteVM.Artists = new SelectList(artists, "Id", "Name");
var tracks = db.Tracks.ToList();
tracks.Add(new Track() { Title = "Add New Song", Id = -1 });
quoteVM.Tracks = new SelectList(tracks, "Id", "Title");
var albums = db.Albums.ToList();
albums.Add(new Album() { Title = "Add New Album", Id = -1 });
quoteVM.Albums = new SelectList(albums, "Id", "Title");
return View(quoteVM);
}
public ActionResult Create(QuoteViewModel quoteVM)
{
if (ModelState.IsValid)
{
if (quoteVM.ArtistId == -1)
{
Artist artist = db.Artists.FirstOrDefault(a => a.Name == quoteVM.ArtistName);
if (artist == null) {
db.Artists.Add(new Artist() { Name=quoteVM.ArtistName,DateModified=DateTime.Now});
db.SaveChanges();
}
}
if (quoteVM.AlbumArtistId == -1)
{
Artist artist = db.Artists.FirstOrDefault(a => a.Name == quoteVM.AlbumArtistName);
if (artist == null)
{
db.Artists.Add(new Artist() { Name = quoteVM.AlbumArtistName, DateModified = DateTime.Now });
db.SaveChanges();
}
}
Quote quote = new Quote();
quote.Text = quoteVM.Text;
quote.DateModified = DateTime.Now;
quote.Explicit = quoteVM.Explicit;
quote.Explanation = quoteVM.Explanation;
if (quoteVM.ArtistId != -1)
{
quote.Artist = db.Artists.Find(quoteVM.ArtistId);
}
else {
quote.Artist = db.Artists.SingleOrDefault(a=>a.Name == quoteVM.ArtistName);
}
if (quoteVM.TrackId != -1)
{
quote.Track = db.Tracks.Find(quoteVM.TrackId);
}
else
{
Track track = db.Tracks.FirstOrDefault(t => t.Title == quoteVM.TrackName);
if (track == null)
{
quote.Track = new Track() { Title = quoteVM.TrackName, DateModified = DateTime.Now,ReleaseDate=quoteVM.TrackReleaseDate };
}
else
{
quote.Track = track;
}
}
if (quoteVM.AlbumId != -1)
{
quote.Track.Album = db.Albums.Find(quoteVM.AlbumId);
}
else
{
Album album = db.Albums.FirstOrDefault(a => a.Title == quoteVM.AlbumName);
if (album == null)
{
quote.Track.Album = new Album() { Title = quoteVM.AlbumName, DateModified = DateTime.Now,ReleaseDate=quoteVM.AlbumReleaseDate};
if (quoteVM.AlbumArtistId > -1)
{
quote.Track.Album.Artist = db.Artists.Find(quoteVM.AlbumArtistId);
}
else
{
if (quoteVM.AlbumArtistId == -1)
{
quote.Track.Album.Artist = db.Artists.SingleOrDefault(a => a.Name == quoteVM.AlbumArtistName);
} else {
//get the value of the newly added artist
quote.Track.Album.Artist = db.Artists.SingleOrDefault(a => a.Name == quoteVM.ArtistName);
}
}
}
else
{
quote.Track.Album = album;
}
}
db.Quotes.Add(quote);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(quoteVM);
}
public ActionResult Edit(QuoteViewModel quoteVM)
{
if (ModelState.IsValid)
{
Quote quote = db.Quotes.FirstOrDefault(q => q.Id == quoteVM.Id);
quote.Text = quoteVM.Text;
quote.Explanation = quoteVM.Explanation;
quote.Explicit = quoteVM.Explicit;
quote.DateModified = DateTime.Now;
if (quoteVM.ArtistId == -1)
{
Artist artist = db.Artists.FirstOrDefault(a => a.Name == quoteVM.ArtistName);
if (artist == null)
{
db.Artists.Add(new Artist() { Name = quoteVM.ArtistName, DateModified = DateTime.Now });
db.SaveChanges();
}
}
if (quoteVM.AlbumArtistId == -1)
{
Artist artist = db.Artists.FirstOrDefault(a => a.Name == quoteVM.AlbumArtistName);
if (artist == null)
{
db.Artists.Add(new Artist() { Name = quoteVM.AlbumArtistName, DateModified = DateTime.Now });
db.SaveChanges();
}
}
if (quoteVM.ArtistId != -1)
{
quote.Artist = db.Artists.Find(quoteVM.ArtistId);
}
else
{
quote.Artist = db.Artists.SingleOrDefault(a => a.Name == quoteVM.ArtistName);
}
if (quoteVM.TrackId != -1)
{
quote.Track = db.Tracks.Find(quoteVM.TrackId);
}
else
{
Track track = db.Tracks.FirstOrDefault(t => t.Title == quoteVM.TrackName);
if (track == null)
{
quote.Track = new Track() { Title = quoteVM.TrackName, DateModified = DateTime.Now, ReleaseDate = quoteVM.TrackReleaseDate };
}
else
{
quote.Track = track;
}
}
if (quoteVM.AlbumId != -1)
{
quote.Track.Album = db.Albums.Find(quoteVM.AlbumId);
}
else
{
Album album = db.Albums.FirstOrDefault(a => a.Title == quoteVM.AlbumName);
if (album == null)
{
quote.Track.Album = new Album() { Title = quoteVM.AlbumName, DateModified = DateTime.Now, ReleaseDate = quoteVM.AlbumReleaseDate };
if (quoteVM.AlbumArtistId > -1)
{
quote.Track.Album.Artist = db.Artists.Find(quoteVM.AlbumArtistId);
}
else
{
if (quoteVM.AlbumArtistId == -1)
{
quote.Track.Album.Artist = db.Artists.SingleOrDefault(a => a.Name == quoteVM.AlbumArtistName);
}
else
{
//get the value of the newly added artist
quote.Track.Album.Artist = db.Artists.SingleOrDefault(a => a.Name == quoteVM.ArtistName);
}
}
}
else
{
quote.Track.Album = album;
}
}
db.Entry(quote).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}else {
var artists = db.Artists.ToList();
artists.Add(new Artist() { Name = "Add New Artist", Id = -1 });
quoteVM.Artists = new SelectList(artists, "Id", "Name", quoteVM.ArtistId);
var tracks = db.Tracks.ToList();
tracks.Add(new Track() { Title = "Add New Song", Id = -1 });
quoteVM.Tracks = new SelectList(tracks, "Id", "Title", quoteVM.TrackId);
var albums = db.Albums.ToList();
albums.Add(new Album() { Title = "Add New Album", Id = -1 });
quoteVM.Albums = new SelectList(albums, "Id", "Title", quoteVM.AlbumId);
}
return View(quoteVM);
}
//
// GET: /Quote/Edit/5
public ActionResult Edit(int id = 0)
{
Quote quote = db.Quotes.Find(id);
QuoteViewModel quoteVM = new QuoteViewModel();
if (quote == null)
{
return HttpNotFound();
}
else {
quoteVM.Text = quote.Text;
quoteVM.TrackId = quote.Track.Id;
quoteVM.TrackReleaseDate = (DateTime)quote.Track.ReleaseDate;
quoteVM.ArtistId = quote.Artist.Id;
quoteVM.AlbumId = quote.Track.Album.Id;
quoteVM.AlbumReleaseDate = (DateTime)quote.Track.Album.ReleaseDate;
quoteVM.AlbumArtistId = quote.Track.Album.Artist.Id;
quoteVM.Explanation = quote.Explanation;
quoteVM.Explicit = quote.Explicit;
var artists = db.Artists.ToList();
artists.Add(new Artist() { Name = "Add New Artist", Id = -1 });
quoteVM.Artists = new SelectList(artists, "Id", "Name",quote.Artist.Id);
var albumArtists = db.Artists.ToList();
albumArtists.Add(new Artist() { Name = "Add New Artist", Id = -1 });
quoteVM.AlbumArtists = new SelectList(albumArtists, "Id", "Name", quote.Track.Album.Artist.Id);
var tracks = db.Tracks.ToList();
tracks.Add(new Track() { Title = "Add New Song", Id = -1 });
quoteVM.Tracks = new SelectList(tracks, "Id", "Title",quote.Track.Id);
var albums = db.Albums.ToList();
albums.Add(new Album() { Title = "Add New Album", Id = -1 });
quoteVM.Albums = new SelectList(albums, "Id", "Title", quote.Track.Album.Id);
}
return View(quoteVM);
}
//
// GET: /Quote/Details/5
public ActionResult Details(int id = 0)
{
Quote quote = db.Quotes.Find(id);
QuoteViewModel quoteVM = new QuoteViewModel();
if (quote == null)
{
return HttpNotFound();
} else {
quoteVM.Id = quote.Id;
quoteVM.Text = quote.Text;
quoteVM.Explanation = quote.Explanation;
quoteVM.ArtistName = quote.Artist.Name;
quoteVM.ArtistId = quote.Artist.Id;
quoteVM.TrackName = quote.Track.Title;
quoteVM.TrackId = quote.Track.Id;
quoteVM.AlbumName = quote.Track.Album.Title;
quoteVM.AlbumId = quote.Track.Album.Id;
quoteVM.AlbumArtistName = quote.Track.Album.Artist.Name;
quoteVM.AlbumArtistId = quote.Track.Album.Artist.Id;
}
return View(quoteVM);
}
//
// GET: /Quote/Delete/5
public ActionResult Delete(int id = 0)
{
Quote quote = db.Quotes.Find(id);
QuoteViewModel quoteVM = new QuoteViewModel();
if (quote == null)
{
return HttpNotFound();
} else {
quoteVM.Id = quote.Id;
quoteVM.Text = quote.Text;
quoteVM.ArtistName = quote.Artist.Name;
quoteVM.TrackName = quote.Track.Title;
}
return View(quoteVM);
}