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);
}