public string Delete(SongDataObj song) //OK
{
string retValue = string.Empty;
string strCmd = string.Format("Delete From public.\"{0}\" where \"songID\" = {1}", this.TblName, song.SongID.ToString());
using (NpgsqlCommand cmd = new NpgsqlCommand(strCmd, GetConnection()))
{
cmd.ExecuteNonQuery();
}
return(retValue);
}
public string RemoveSongFromPlayList(SongDataObj song) //OK
{
string retValue = string.Empty;
string strCmd = string.Format("Update public.\"{0}\" set inPlayList = 0 where \"songID\" = {1}", this.TblName, song.SongID.ToString());
using (NpgsqlCommand cmd = new NpgsqlCommand(strCmd, GetConnection()))
{
cmd.ExecuteNonQuery();
}
return(retValue);
}
public static string RemoveSongFromPlayList(string songID)//OK
{
SongDataObj song = new SongDataObj();
song.SongID = long.Parse(songID);
new SongReps().RemoveSongFromPlayList(song);
// PPB.GameClasses.Song.RemoveSongFromPlayList(long.Parse(songID));
return("The Song removed successfully");
}
public static string AddSongToPlayList(string songID) //OK
{
SongDataObj song = new SongDataObj();
song.SongID = long.Parse(songID);
new SongReps().PutInPlayList(song);
// PPB.GameClasses.Song.PutInPlayList(long.Parse(songID));
return("The Song added successfully");
}
public SongDataObj Insert(SongDataObj song) //OK
{
string strCmd = string.Format("Insert into public.\"{0}\" (\"userID\", name, artist, album, \"inPlaylist\" ) values ( {1}, '{2}', '{3}', '{4}', '0') ", this.TblName, song.UserID, song.Name.Trim(), song.Artist.Trim(), song.Album.Trim());
using (NpgsqlCommand cmd = new NpgsqlCommand(strCmd, GetConnection()))
{
cmd.ExecuteNonQuery();
cmd.CommandText = "select max(\"songID\") from public.\"Songs\" ";
song.SongID = (long)cmd.ExecuteScalar();
}
return(song);
}
public static string DeleteSong(string json_songID) //OK
{
long songID = long.Parse(GetSingleValueFromJson(json_songID, "songID"));
SongDataObj song = new SongDataObj();
song.SongID = songID;
new SongReps().Delete(song);
// PPB.GameClasses.Song.Delete(songID);
return("The Song seleted successfully");
}
public static string AddSong(string json_SongRec) //OK
{
DataRow dr = jsonStringToTable(json_SongRec).Rows[0];
SongDataObj song = new SongDataObj();
song.UserID = long.Parse(dr["userID"].ToString());
song.Name = dr["Name"].ToString();
song.Artist = dr["Artist"].ToString();
song.Album = dr["Album"].ToString();
new SongReps().Insert(song);
return("The Song added successfully");
}
public void Update(SongDataObj song) //OK
{
string strCmd = string.Format("Update public.\"{0}\" set userID = @UserID, name=@name, artist=@artist, album=@album, inPlaylist=@inPlaylist where songID = @songID ", this.TblName);
using (NpgsqlCommand cmd = new NpgsqlCommand(strCmd, GetConnection()))
{
//cmd.CommandText = "Update public.\"Songs\" set userID = @UserID, name=@name, artist=@artist, album=@album where songID = @songID ";
cmd.Parameters.AddWithValue("@songID", song.SongID);
cmd.Parameters.AddWithValue("@userID", song.UserID);
cmd.Parameters.AddWithValue("@artist", song.Artist);
cmd.Parameters.AddWithValue("@album", song.Album);
cmd.Parameters.AddWithValue("@inPlaylist", song.InPlaylist);
cmd.ExecuteNonQuery();
}
}
