Method | Description | |
---|---|---|
BaseTableIDToName ( String Tablename, int id, String column = "" ) : object |
looks for the name of a id from a base table
|
|
BaseTableNameToID ( String Tablename, String Name, System.Boolean insertUnknown = false ) : object |
looks for the id of a name from a base table
|
|
CorrectMisspelledCommodities ( ) : |
Checks the commodity names with reference to table tbDNMap_Commodity. Correct misspellings if some found.
|
|
DeleteMarketData ( |
delete all market data older than x days
|
|
DeleteMultiplePrices ( List |
function deletes all exept the newest price for a commodity on a station, if there exists more than one.
|
|
DeleteNoLongerExistingMarketData ( int days, int singleStationID = null ) : void |
delete all data for every station, older than "youngest update" - "n days"
|
|
Dispose ( ) : void | ||
EliteDBIO ( ) : System |
constructor
|
|
ExportLocalizationDataToCSV ( string fileName, enLocalizationType activeSetting ) : void | ||
ExportMarketDataToCSV ( string fileName, System.Boolean inCurrentLanguage, System.Boolean extendedFormat ) : void |
exports the market data to a file
|
|
GetLogByTimestamp ( System.DateTime timeStamp ) : dsEliteDB.vilogRow |
returns a single log entry identified by its timestamp
|
|
GetNeighbourSystems ( |
gets all neighbours in a bubble around a system
|
|
GetStationnameFromStationID ( int stationID ) : String |
returns the name of a system through a given station-id
|
|
GetSystemnameFromStation ( int stationID ) : String |
returns the name of a system through a given station-id
|
|
ImportCommandersLog ( String Filename ) : |
imports the "Commander's Log" into the database
|
|
ImportEDCDData ( frmDataIO enImportTypes, String importFile ) : void | ||
ImportLocalizationDataFromCSV ( string fileName, |
||
ImportPrices ( Newtonsoft companionData ) : |
imports prices from a JSON companion data object
|
|
ImportPricesFromCSVFile ( String filename, enImportBehaviour importBehaviour, enDataSource dataSource, |
Imports the prices from a file with csv-strings (e.g. the old autosave-file)
|
|
ImportPricesFromCSVStrings ( String CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource ) : List |
Imports the prices from a list of csv-strings
|
|
ImportPricesFromEDDBStrings ( String CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource, |
Imports the prices from a list of csv-strings in EDDB format
|
|
ImportStations ( String Filename, System.Boolean addPrices ) : void |
imports the data from the file into the database (only newer data will be imported)
|
|
ImportStations_Own ( |
imports the "own" station data from the list of stations
|
|
ImportStations_Own ( List |
imports the "own" station data into the database
|
|
ImportStations_Own ( String Filename, System.Boolean OnlyAddUnknown = false ) : void |
imports the "own" station data from the file into the database (only initially once needed)
|
|
ImportStations_Own ( String Filename, Int32>.Dictionary |
imports the "own" station data from the list of stations
|
|
ImportSystems ( String Filename ) : void |
imports the data from the file into the database (only newer data will be imported)
|
|
ImportSystems_Own ( |
imports the data from the list of systems
|
|
ImportSystems_Own ( List |
imports the data from the list of systems
|
|
ImportSystems_Own ( String Filename, System.Boolean OnlyAddUnknown = false ) : Int32>.Dictionary |
imports the own data from the file into the database (only initially once needed)
|
|
ImportVisitedStations ( string Filename ) : void |
imports the old list of visited stations to the database
|
|
InsertColumnDefinition ( string iniGroup, string iniKey, int newColumnIndex, int newViewIndex, string newColumnDefinition ) : void |
Inserts data for new columns in existing definitions of datagrids
|
|
checkPotentiallyNewSystemOrStation ( String newSystemName, String newStationName, |
Checks if the system is existing and adds it, if not. Also sets the visited-flag if not set.
|
|
fromCSV ( String CSV_Strings, List |
creates a list of "EDStations" with price listings from csv-array
|
|
fromCSV_EDDB ( String CSV_Strings ) : List |
creates a list of "EDStations" with price listings from csv-array in EDDB format
|
|
getStations ( string System ) : string[] |
retrieves all stationnames in the system in a array
|
|
switchLanguage ( String Language ) : void |
Switch the language, updating the loccommodity-string in tbCommodities.
|
|
updateTranslation ( ) : void |
updates the localization of all commodities for the current language
|
|
updateVisitedBaseFromLog ( enVisitType Refresh ) : void |
Specifies all systems/stations from the Commander's Log as "visited". Necessary/recommended after a import of old "Commander's Log" files.
|
|
updateVisitedFlagsFromBase ( System.Boolean newSystem = true, System.Boolean newStation = true ) : void |
Update the visited-flag in the stations- and systems-tables from the visited-basetables (tbVisitedStations/tbVistitedSystems).
|
Method | Description | |
---|---|---|
Dispose ( bool disposing ) : void | ||
OnProgress ( ProgressEventArgs e ) : void |
Method | Description | |
---|---|---|
AddMissingLocalizationEntries ( ) : void |
adds for all items (commodities, levels, categories) the missing entries in the localization tables
|
|
ClearAll ( ) : void | ||
CopyEDStationCommodityToDataRow ( |
copies the commodities data from a "EDStation"-object to "tb_______Commodity"-table
|
|
CopyEDStationEconomiesToDataRows ( |
copies the economies data from a "EDStation"-object to "tbStationEconomy"-table
|
|
CopyEDStationToDataRow ( |
copies the data from a "EDStation"-object to a Datarow from table "tbStations"
|
|
CopyEDSystemToDataRow ( |
copies the data from a "EDSystem"-object to a Datarow from table "tbSystems"
|
|
GetCoordinates ( String systemName ) : |
returns the coordinates of the system
|
|
GetMapping ( string mappingTable, string idString1, System.Boolean throwException = true ) : string | ||
GetMapping ( string mappingTable, string idString1, string idString2, System.Boolean throwException = true ) : string | ||
GetMappingT ( string mappingTable, string idString1, System.Boolean throwException = true ) : String>.Tuple |
||
GetMappingT ( string mappingTable, string idString1, string idString2, System.Boolean throwException = true ) : String>.Tuple |
||
ImportCommodities ( List |
imports the data from the list (only newer data will be imported)
|
|
ImportCommoditiesFromFile ( String fileName ) : void |
imports the data from the file into the database (only newer data will be imported)
|
|
ImportCommodityLocalizations ( |
loads the localized commodity names and check if the self added names now included in the official dictionary
|
|
ImportCommodityLocalizations ( String Filename ) : void |
loads the localized commodity names and check if the self added names now included in the official dictionary
|
|
ImportCommodityPriceWarnLevels ( String Filename ) : void |
loads the existing price-warnlevel data
|
|
ImportEconomyLevelLocalizations ( String Filename ) : void |
loads the localized economy level names and check
|
|
ImportPrices ( List |
Imports the prices from the list of stations. It's clever firstly to import the stations from the same file.
|
|
PrepareBaseTables ( String TableName = "", System.Boolean saveChanged = false ) : void |
loads the data from the basetables into memory. For correct initialization it is necessary to call this fuction with a unset tableName
|
|
RecalcJumpDistancesInLog ( System.DateTime maxAge ) : void |
recalculates distances in the tbLog-table
|
|
RecalcJumpDistancesInLog ( System.DateTime startTime, System.DateTime endTime ) : void |
recalculates distances in the tbLog-table
|
|
SendLogToEDSM ( List |
||
getCommodityNames ( ) : List |
retrieves all known commodity names in the current language
|
|
getDistanceBetween ( |
returns the distance between two systems (given by id)
|
|
getDistanceBetween ( string System_1, string System_2 ) : double? |
retrun the distance between two systems (given by name)
|
|
getEconomyLevels ( ) : string>.Dictionary |
retrieves all known economylevels as original string in capitals and in the current language
|
|
getFreeIndex ( String TableName ) : |
get the next free index for the table (positive only)
|
|
getLevels ( int &DemandLevel, int &SupplyLevel, int?>.Dictionary |
||
getNextOwnSystemIndex ( ) : int |
gets the next free system-id for user added systems
|
|
sendProgressEvent ( ProgressEventArgs pEArgs ) : System.Boolean |
fires the progress event if necessary
|
public BaseTableIDToName ( String Tablename, int id, String column = "" ) : object | ||
Tablename | String | name of the basetable WITHOUT leading 'tb' |
id | int | |
column | String | |
return | object |
public BaseTableNameToID ( String Tablename, String Name, System.Boolean insertUnknown = false ) : object | ||
Tablename | String | name of the basetable WITHOUT leading 'tb' |
Name | String | |
insertUnknown | System.Boolean | |
return | object |
public CorrectMisspelledCommodities ( ) : |
||
return |
public DeleteMarketData ( |
||
days | ||
return | void |
public DeleteMultiplePrices ( List |
||
idList | List |
if not null the function only examines the given commodity-ids /// (for improving performance) |
return | void |
public DeleteNoLongerExistingMarketData ( int days, int singleStationID = null ) : void | ||
days | int | |
singleStationID | int | |
return | void |
public ExportLocalizationDataToCSV ( string fileName, enLocalizationType activeSetting ) : void | ||
fileName | string | |
activeSetting | enLocalizationType | |
return | void |
public ExportMarketDataToCSV ( string fileName, System.Boolean inCurrentLanguage, System.Boolean extendedFormat ) : void | ||
fileName | string | |
inCurrentLanguage | System.Boolean | |
extendedFormat | System.Boolean | |
return | void |
public GetLogByTimestamp ( System.DateTime timeStamp ) : dsEliteDB.vilogRow | ||
timeStamp | System.DateTime | |
return | dsEliteDB.vilogRow |
public GetNeighbourSystems ( |
||
stationId | system in the center of the bubble | |
maxDistance | Double | radius of the bubble |
return |
public GetStationnameFromStationID ( int stationID ) : String | ||
stationID | int | |
return | String |
public GetSystemnameFromStation ( int stationID ) : String | ||
stationID | int | |
return | String |
public ImportCommandersLog ( String Filename ) : |
||
Filename | String | |
return |
public ImportEDCDData ( frmDataIO enImportTypes, String importFile ) : void | ||
enImportTypes | frmDataIO | |
importFile | String | |
return | void |
public ImportLocalizationDataFromCSV ( string fileName, |
||
fileName | string | |
activeSetting | ||
importType | enLocalisationImportType | |
return | void |
public ImportPrices ( Newtonsoft companionData ) : |
||
companionData | Newtonsoft | JSON object with companion data |
return |
public ImportPricesFromCSVFile ( String filename, enImportBehaviour importBehaviour, enDataSource dataSource, |
||
filename | String | |
importBehaviour | enImportBehaviour | |
dataSource | enDataSource | |
importParams | only for control import behaviour from EDDB files, can be null | |
return |
public ImportPricesFromCSVStrings ( String CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource ) : List |
||
CSV_Strings | String | data to import |
importBehaviour | enImportBehaviour | filter, which prices to import |
dataSource | enDataSource | if data has no information about the datasource, this setting will count |
return | List |
public ImportPricesFromEDDBStrings ( String CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource, |
||
CSV_Strings | String | data to import |
importBehaviour | enImportBehaviour | filter, which prices to import |
dataSource | enDataSource | if data has no information about the datasource, this setting will count |
importParams | ||
return | void |
public ImportStations ( String Filename, System.Boolean addPrices ) : void | ||
Filename | String | |
addPrices | System.Boolean | |
return | void |
public ImportStations_Own ( |
||
Station | ||
OnlyAddUnknown | System.Boolean | |
setVisitedFlag | System.Boolean | |
return | void |
public ImportStations_Own ( List |
||
Stations | List |
|
changedSystemIDs | Int32>.Dictionary | |
OnlyAddUnknown | System.Boolean | |
setVisitedFlag | System.Boolean | |
return | void |
public ImportStations_Own ( String Filename, System.Boolean OnlyAddUnknown = false ) : void | ||
Filename | String | |
OnlyAddUnknown | System.Boolean | |
return | void |
public ImportStations_Own ( String Filename, Int32>.Dictionary |
||
Filename | String | |
changedSystemIDs | Int32>.Dictionary | |
OnlyAddUnknown | System.Boolean | |
return | void |
public ImportSystems ( String Filename ) : void | ||
Filename | String | |
return | void |
public ImportSystems_Own ( |
||
System | ||
OnlyAddUnknown | System.Boolean | |
setVisitedFlag | System.Boolean | |
return | Int32>.Dictionary |
public ImportSystems_Own ( List |
||
Systems | List |
|
OnlyAddUnknown | System.Boolean | |
setVisitedFlag | System.Boolean | |
return | Int32>.Dictionary |
public ImportSystems_Own ( String Filename, System.Boolean OnlyAddUnknown = false ) : Int32>.Dictionary |
||
Filename | String | |
OnlyAddUnknown | System.Boolean | |
return | Int32>.Dictionary |
public ImportVisitedStations ( string Filename ) : void | ||
Filename | string | |
return | void |
public static InsertColumnDefinition ( string iniGroup, string iniKey, int newColumnIndex, int newViewIndex, string newColumnDefinition ) : void | ||
iniGroup | string | |
iniKey | string | |
newColumnIndex | int | |
newViewIndex | int | |
newColumnDefinition | string | |
return | void |
protected OnProgress ( ProgressEventArgs e ) : void | ||
e | ProgressEventArgs | |
return | void |
public checkPotentiallyNewSystemOrStation ( String newSystemName, String newStationName, |
||
newSystemName | String | |
newStationName | String | |
coordinates | ||
setVisitedFlag | System.Boolean | |
return | void |
public fromCSV ( String CSV_Strings, List |
||
CSV_Strings | String | String to be converted |
foundSystems | List |
|
csvRowList | List |
for optional processing outside: a list of the data converted to CsvRow-objects |
return | List |
public fromCSV_EDDB ( String CSV_Strings ) : List |
||
CSV_Strings | String | String to be converted |
return | List |
public getStations ( string System ) : string[] | ||
System | string | |
return | string[] |
public switchLanguage ( String Language ) : void | ||
Language | String | new language for viewing |
return | void |
public updateVisitedBaseFromLog ( enVisitType Refresh ) : void | ||
Refresh | enVisitType | |
return | void |
public updateVisitedFlagsFromBase ( System.Boolean newSystem = true, System.Boolean newStation = true ) : void | ||
newSystem | System.Boolean | |
newStation | System.Boolean | |
return | void |