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