/// <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(";"); SqliteParameter[] arParams = new SqliteParameter[1]; arParams[0] = new SqliteParameter(":ModuleID", DbType.Int32); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = moduleId; int rowsAffected = SqliteHelper.ExecuteNonQuery( ConnectionString.GetConnectionString(), sqlCommand.ToString(), arParams); return(rowsAffected > 0); }
/// <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(";"); NpgsqlParameter[] arParams = new NpgsqlParameter[1]; arParams[0] = new NpgsqlParameter("moduleid", NpgsqlTypes.NpgsqlDbType.Integer); arParams[0].Direction = ParameterDirection.Input; arParams[0].Value = moduleId; int rowsAffected = NpgsqlHelper.ExecuteNonQuery( ConnectionString.GetWriteConnectionString(), CommandType.Text, sqlCommand.ToString(), arParams); return(rowsAffected > -1); }