protected void BtnNewPlaylistClicked(object sender, EventArgs e)
{
List<Playlist> playlistList = databaseManager.GetAllPlaylists();
int hightestPlaylistID = 0;
foreach (Playlist p in playlistList)
{
if (p.PlaylistID >= hightestPlaylistID)
{
hightestPlaylistID = p.PlaylistID + 1;
}
}
if (tbPlaylistName.Text != string.Empty)
{
Playlist playlist = new Playlist(hightestPlaylistID,currentUser,tbPlaylistName.Text);
databaseManager.NewPlaylist(playlist);
Page.Response.Redirect(HttpContext.Current.Request.Url.ToString(), true);
}
}
public List<Playlist> GetPlaylists(string username)
{
List<Playlist> playlistList = new List<Playlist>();
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
string query = "SELECT afspeellijstID,NAAM FROM SE_Afspeellijst WHERE gebruikersnaam = :userName";
OracleCommand command = new OracleCommand(query, connection);
command.CommandType = CommandType.Text;
command.Parameters.Add("userName", username);
OracleDataReader dataReader;
int playlistID = 0;
string name = string.Empty;
try
{
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
playlistID = Convert.ToInt32(dataReader["AFSPEELLIJSTID"]);
name = Convert.ToString(dataReader["NAAM"]);
Playlist playlist = new Playlist(playlistID,GetUser(username),name);
playlistList.Add(playlist);
}
}
catch
{
// Catch if reading from the database doesn't work
}
connection.Close();
return playlistList;
}
public bool NewPlaylist(Playlist playlist)
{
//List<Comment> comments = GetComments(video);
//int commentID = comments.Count() + 1;
string query = "INSERT INTO SE_AFSPEELLIJST (AFSPEELLIJSTID,GEBRUIKERSNAAM,NAAM) VALUES (:playlistID,:username,:playlistName)";
// Located lower than usual, because GetComments(video) would close the connection.
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
OracleCommand command = new OracleCommand(query, connection);
command.CommandType = CommandType.Text;
command.Parameters.Add("playlistID", playlist.PlaylistID);
command.Parameters.Add("username", playlist.User.Username);
command.Parameters.Add("playlistName", playlist.Name);
try
{
command.ExecuteNonQuery();
}
catch
{
return false;
// Catch if the command was not succesfully executed.
}
connection.Close();
return true;
}
public List<Playlist> GetAllPlaylists()
{
List<Playlist> PlaylistList = new List<Playlist>();
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
string query = "SELECT * FROM SE_AFSPEELLIJST";
OracleCommand command = new OracleCommand(query, connection);
command.CommandType = CommandType.Text;
OracleDataReader dataReader;
int playlistId = 0;
string username = string.Empty;
string name = string.Empty;
try
{
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
playlistId= Convert.ToInt32(dataReader["AFSPEELLIJSTID"]);
username = Convert.ToString(dataReader["GEBRUIKERSNAAM"]);
name = Convert.ToString(dataReader["NAAM"]);
Playlist playlist = new Playlist(playlistId, GetUser(username), name);
PlaylistList.Add(playlist);
}
}
catch
{
// Catch if reading from the database doesn't work
}
connection.Close();
return PlaylistList;
}