public void NewPlaylistTest()
{
DBPlaylist dbPlaylist = new DBPlaylist();
User user = new User(1, "Myron Antonissen", "*****@*****.**", "4761KL", DateTime.Now, Country.Germany, 624196793, new Subscription("", 0.0, ""));
NewPlaylistModel playlist = new NewPlaylistModel();
Assert.AreEqual(true, dbPlaylist.NewPlaylist(playlist, user));
}
public ActionResult NewPlaylist(NewPlaylistModel playlist)
{
if (dbPlaylist.NewPlaylist(playlist, LogedinUser))
{
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
public async Task <IActionResult> NewPlaylist(NewPlaylistModel model)
{
if (ModelState.IsValid)
{
var playlist = await _playlistService.CreatePlaylist(model.Title, model.Description);
return(RedirectToAction("Playlist", new { Id = playlist.Id }));
}
return(View(model));
}
public bool NewPlaylist(NewPlaylistModel playlist, User user)
{
if (con.State != System.Data.ConnectionState.Open)
{
con.Open();
}
MySqlCommand cmd = new MySqlCommand
{
Connection = con,
CommandText = "INSERT INTO Playlist (Name, Userid) VALUES (@name, @userid)"
};
cmd.Parameters.AddWithValue("@name", playlist.Name);
cmd.Parameters.AddWithValue("@userid", user.ID);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
