public async Task <IActionResult> Edit(int id, [Bind("ID,UserID,SongID")] FavouriteSong favouriteSong) { if (id != favouriteSong.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(favouriteSong); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FavouriteSongExists(favouriteSong.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["SongID"] = new SelectList(_context.Songs, "ID", "SongTitle", favouriteSong.SongID); ViewData["UserID"] = new SelectList(_context.Users, "Id", "Id", favouriteSong.UserID); return(View(favouriteSong)); }
public int AddToFavourite(FavouriteSong fs) { FavouriteSong f = new FavouriteSong(); // f.SongName = fs.SongName; f.SongId = fs.SongId; f.SongName = db.Song.Where(x => x.SongId == f.SongId).Select(x => x.name).FirstOrDefault(); f.user = User.Identity.GetUserName(); if (f.user == "") { return(0); } var f1 = db.favouritesong.Where(x => x.SongId == f.SongId && x.user == f.user).FirstOrDefault(); Console.WriteLine(f1); if (f1 == null) { db.favouritesong.Add(f); db.SaveChanges(); return(f.SongId); } return(0); //return RedirectToAction("/Account/Login"); }
public async Task <IActionResult> RemoveFromFavourites(FavouriteSong song) { var dbSong = await _db.Songs.SingleOrDefaultAsync(m => m.ID == song.ID); _db.Remove(dbSong); await _db.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); }
public async Task <IActionResult> AddToFavourites(FavouriteSong song) { song.Artist = TempData["currentArtist"].ToString(); song.Title = TempData["currentTitle"].ToString(); _db.Add(song); await _db.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); }
public async Task <IActionResult> Create([Bind("ID,UserID,SongID")] FavouriteSong favouriteSong) { if (ModelState.IsValid) { _context.Add(favouriteSong); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["SongID"] = new SelectList(_context.Songs, "ID", "SongTitle", favouriteSong.SongID); ViewData["UserID"] = new SelectList(_context.Users, "Id", "Id", favouriteSong.UserID); return(View(favouriteSong)); }
public int RemoveFavourite(FavouriteSong fs) { FavouriteSong f = new FavouriteSong(); // f.SongName = fs.SongName; f.SongId = fs.SongId; f.user = User.Identity.GetUserName(); var f1 = db.favouritesong.Where(x => x.SongId == f.SongId && x.user == f.user).FirstOrDefault(); db.favouritesong.Remove(f1); db.SaveChanges(); return(f.SongId); // return RedirectToAction("DisplaySong"); }
// Method to save favourite user songs ----------------------------- public async Task <IActionResult> saveFavSong(int SongID) { User user = await _userManager.GetUserAsync(User); Song song = await _context.Songs.FindAsync(SongID); FavouriteSong favouriteSong = new FavouriteSong { User = user, Song = song, }; if (ModelState.IsValid) { _context.Add(favouriteSong); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } return(NotFound()); }
public ActionResult RemoveFavourite(FavouriteSong fs) { return(RedirectToAction("DisplaySong")); }