private Station GetConquerableStationByID(int stationID)
{
System.Net.WebClient webClient = new System.Net.WebClient();
webClient.Headers.Add("user-agent", "LogisticiansTools: - Contact Natalie Cruella");
string URL = string.Format("{0}/eve/ConquerableStationList.xml.aspx", _baseEveApi);
System.IO.Stream dataStream = webClient.OpenRead(URL);
string XMLData = new System.IO.StreamReader(dataStream).ReadToEnd();
XmlDocument doc = new XmlDocument();
doc.LoadXml(XMLData);
XmlNodeList nodes = doc.GetElementsByTagName("row");
Station station = new Station();
foreach (XmlNode node in nodes)
{
if (Convert.ToInt32(node.Attributes["stationID"].Value) == stationID)
{
station = new Station()
{
StationID = stationID,
SolarSystemID = Convert.ToInt32(node.Attributes["solarSystemID"].Value),
StationName = node.Attributes["stationName"].Value.ToString()
};
_connectionObject.Close();
station.SolarSystem = GetSolarSystemByID(station.SolarSystemID);
return station;
}
}
return station;
}
public Station GetStationByID(int stationID)
{
SQLiteCommand _cmd = _connectionObject.CreateCommand();
_cmd.CommandText = "SELECT * FROM staStations WHERE stationID = '" + stationID + "'";
_connectionObject.Open();
SQLiteDataReader reader = _cmd.ExecuteReader();
Station station = new Station();
if (reader.Read())
{
station = DataAccess.BuildObjects.BuildStation(ref reader);
_connectionObject.Close();
station.SolarSystem = GetSolarSystemByID(station.SolarSystemID);
}
else
station = GetConquerableStationByID(stationID);
_connectionObject.Close();
return station;
}