public static bool DeleteBySite(int siteId) { DBMediaTrack.DeleteBySite(siteId); StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("DELETE FROM mp_MediaPlayer "); sqlCommand.Append("WHERE "); sqlCommand.Append("ModuleID IN (SELECT ModuleID FROM mp_Modules WHERE SiteID = :SiteID) "); sqlCommand.Append(";"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":SiteID", DbType.Int32); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = siteId; int rowsAffected = SqliteHelper.ExecuteNonQuery( ConnectionString.GetConnectionString(), sqlCommand.ToString(), arParams); return(rowsAffected > 0); }
/// <summary> /// Deletes a row from the doan_MediaPlayers table. /// </summary> /// <param name="playerID">The ID of the Media Player.</param> /// <returns>Returns true if row deleted.</returns> public static bool Delete(int playerId) { DBMediaTrack.DeleteByPlayer(playerId); StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("DELETE FROM mp_MediaPlayer "); sqlCommand.Append("WHERE "); sqlCommand.Append("PlayerID = @PlayerID "); sqlCommand.Append(";"); FbParameter[] arParams = new FbParameter[1]; arParams[0] = new FbParameter("@PlayerID", FbDbType.Integer); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = playerId; int rowsAffected = FBSqlHelper.ExecuteNonQuery( ConnectionString.GetWriteConnectionString(), sqlCommand.ToString(), arParams); return(rowsAffected > -1); }
/// <summary> /// Deletes the Player that is for a Module. /// </summary> /// <param name="moduleID">The ID of the Module.</param> /// <returns>Returns true if row deleted.</returns> public static bool DeleteByModule(int moduleId) { DBMediaTrack.DeleteByModule(moduleId); StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("DELETE FROM mp_MediaPlayer "); sqlCommand.Append("WHERE "); sqlCommand.Append("PlayerID = @PlayerID "); 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); }
public static bool DeleteBySite(int siteId) { DBMediaTrack.DeleteBySite(siteId); StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("DELETE FROM mp_mediaplayer "); sqlCommand.Append("WHERE "); sqlCommand.Append("moduleid IN (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 the Player that is for a Module. /// </summary> /// <param name="moduleID">The ID of the Module.</param> /// <returns>Returns true if row deleted.</returns> public static bool DeleteByModule(int moduleId) { DBMediaTrack.DeleteByModule(moduleId); StringBuilder sqlCommand = new StringBuilder(); sqlCommand.Append("DELETE FROM mp_MediaPlayer "); sqlCommand.Append("WHERE "); sqlCommand.Append("ModuleID = ?ModuleID "); sqlCommand.Append(";"); MySqlParameter[] arParams = new MySqlParameter[1]; arParams[0] = new MySqlParameter("?ModuleID", MySqlDbType.Int32); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = moduleId; int rowsAffected = MySqlHelper.ExecuteNonQuery( ConnectionString.GetWriteConnectionString(), sqlCommand.ToString(), arParams); return(rowsAffected > 0); }