public static bool DeleteBySite(int siteId) { DBMediaFile.DeleteBySite(siteId); StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("DELETE FROM mp_MediaTrack "); sqlCommand.Append("WHERE "); sqlCommand.Append("PlayerID IN (SELECT PlayerID FROM mp_MediaPlayer WHERE ModuleID IN ( "); sqlCommand.Append("SELECT ModuleID FROM mp_Modules WHERE SiteID = @SiteID)) "); sqlCommand.Append(";"); FbParameter[] arParams = new FbParameter[1]; arParams[0] = new FbParameter("@SiteID", FbDbType.Integer); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = siteId; int rowsAffected = FBSqlHelper.ExecuteNonQuery( ConnectionString.GetWriteConnectionString(), sqlCommand.ToString(), arParams); return(rowsAffected > -1); }
public static bool DeleteBySite(int siteId) { DBMediaFile.DeleteBySite(siteId); StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("DELETE FROM mp_mediatrack "); sqlCommand.Append("WHERE "); sqlCommand.Append("playerid IN (SELECT playerid FROM mp_mediaplayer WHERE moduleid IN ( "); sqlCommand.Append("SELECT moduleid FROM mp_modules WHERE siteid = :siteid)) "); sqlCommand.Append(";"); NpgsqlParameter[] arParams = new NpgsqlParameter[1]; arParams[0] = new NpgsqlParameter("siteid", NpgsqlTypes.NpgsqlDbType.Integer); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = siteId; int rowsAffected = NpgsqlHelper.ExecuteNonQuery( ConnectionString.GetWriteConnectionString(), CommandType.Text, sqlCommand.ToString(), arParams); return(rowsAffected > -1); }
/// <summary> /// Deletes a row from the doan_MediaTracks table. /// </summary> /// <param name="trackID">The ID of the track.</param> /// <returns>True if a row was deleted.</returns> public static bool Delete(int trackId) { DBMediaFile.DeleteByTrack(trackId); StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("DELETE FROM mp_mediatrack "); sqlCommand.Append("WHERE "); sqlCommand.Append("trackid = :trackid "); sqlCommand.Append(";"); NpgsqlParameter[] arParams = new NpgsqlParameter[1]; arParams[0] = new NpgsqlParameter("trackid", NpgsqlTypes.NpgsqlDbType.Integer); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = trackId; int rowsAffected = NpgsqlHelper.ExecuteNonQuery( ConnectionString.GetWriteConnectionString(), CommandType.Text, sqlCommand.ToString(), arParams); return(rowsAffected > -1); }
public static bool DeleteByModule(int moduleId) { DBMediaFile.DeleteByModule(moduleId); StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("DELETE FROM mp_MediaTrack "); sqlCommand.Append("WHERE "); sqlCommand.Append("PlayerID IN (SELECT PlayerID FROM mp_MediaPlayer WHERE ModuleID = @ModuleID) "); sqlCommand.Append(";"); SqlCeParameter[] arParams = new SqlCeParameter[1]; arParams[0] = new SqlCeParameter("@ModuleID", SqlDbType.Int); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = moduleId; int rowsAffected = SqlHelper.ExecuteNonQuery( ConnectionString.GetConnectionString(), CommandType.Text, sqlCommand.ToString(), arParams); return(rowsAffected > -1); }
/// <summary> /// Deletes all rows from the doan_MediaTracks table for a particular player instance. /// </summary> /// <param name="playerID">The ID of the player.</param> /// <returns>True if rows were deleted.</returns> public static bool DeleteByPlayer(int playerId) { DBMediaFile.DeleteByPlayer(playerId); StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("DELETE FROM mp_MediaTrack "); sqlCommand.Append("WHERE "); sqlCommand.Append("PlayerID = :PlayerID "); sqlCommand.Append(";"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":PlayerID", DbType.Int32); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = playerId; int rowsAffected = SqliteHelper.ExecuteNonQuery( ConnectionString.GetConnectionString(), sqlCommand.ToString(), arParams); return(rowsAffected > 0); }
/// <summary> /// Deletes a row from the doan_MediaTracks table. /// </summary> /// <param name="trackID">The ID of the track.</param> /// <returns>True if a row was deleted.</returns> public static bool Delete(int trackId) { DBMediaFile.DeleteByTrack(trackId); StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("DELETE FROM mp_MediaTrack "); sqlCommand.Append("WHERE "); sqlCommand.Append("TrackID = @TrackID "); sqlCommand.Append(";"); FbParameter[] arParams = new FbParameter[1]; arParams[0] = new FbParameter("@TrackID", FbDbType.Integer); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = trackId; int rowsAffected = FBSqlHelper.ExecuteNonQuery( ConnectionString.GetWriteConnectionString(), sqlCommand.ToString(), arParams); return(rowsAffected > -1); }