public void TriggerEDSMRefresh()
{
SQLiteDBClass db = new SQLiteDBClass();
EDSMClass edsm = new EDSMClass();
edsm.GetNewSystems(db);
db.GetAllSystems();
}
internal string GetNewSystems(SQLiteDBClass db)
{
string json;
string date = "2010-01-01 00:00:00";
string lstsyst = db.GetSettingString("EDSMLastSystems", "2010-01-01 00:00:00");
string retstr = "";
Application.DoEvents();
json = RequestSystems(lstsyst);
db.GetAllSystems();
List<SystemClass> listNewSystems = SystemClass.ParseEDSM(json, ref date);
retstr = listNewSystems.Count.ToString() + " new systems from EDSM." + Environment.NewLine;
Application.DoEvents();
SystemClass.Store(listNewSystems);
db.PutSettingString("EDSMLastSystems", date);
return retstr;
}
public void TriggerEDSCRefresh()
{
SQLiteDBClass db = new SQLiteDBClass();
edsc.EDSCGetNewSystems(db);
db.GetAllSystems();
}
private void GetEDSCSystems()
{
try
{
SQLiteDBClass db = new SQLiteDBClass();
EDSMClass edsm = new EDSMClass();
string json;
string rwsystime = db.GetSettingString("RWLastSystems", "2000-01-01 00:00:00"); // Latest time from RW file.
string rwsysfiletime = "";
CommanderName = db.GetSettingString("CommanderName", "");
Invoke((MethodInvoker) delegate {
travelHistoryControl1.textBoxCmdrName.Text = CommanderName;
});
json = LoadJsonArray(fileTgcSystems);
List<SystemClass> systems = SystemClass.ParseEDSC(json, ref rwsysfiletime);
if (!rwsystime.Equals(rwsysfiletime)) // New distance file from Redwizzard
{
SystemClass.Delete(SystemStatusEnum.EDSC); // Remove all EDSC systems.
db.PutSettingString("RWLastSystems", rwsysfiletime);
db.PutSettingString("EDSMLastSystems", rwsysfiletime);
Invoke((MethodInvoker) delegate {
TravelHistoryControl.LogText("Adding data from tgcsystems.json " + Environment.NewLine);
});
SystemClass.Store(systems);
EDDBClass eddb = new EDDBClass();
DBUpdateEDDB(eddb);
}
string retstr = edsm.GetNewSystems(db);
Invoke((MethodInvoker)delegate
{
TravelHistoryControl.LogText(retstr);
});
db.GetAllSystemNotes();
db.GetAllSystems();
SystemNames.Clear();
foreach (SystemClass system in SystemData.SystemList)
{
SystemNames.Add(system.name);
}
}
catch (Exception ex)
{
Invoke((MethodInvoker) delegate {
TravelHistoryControl.LogText("GetEDSCSystems exception:" + ex.Message + Environment.NewLine);
});
}
}
internal string GetNewSystems(SQLiteDBClass db)
{
string json;
string date = "2010-01-01 00:00:00";
string lstsyst;
string retstr = "";
Application.DoEvents();
db.GetAllSystems();
//if (lstsys)
DateTime NewSystemTime;
if (SQLiteDBClass.globalSystems == null || SQLiteDBClass.globalSystems.Count ==0)
{
lstsyst = "2010-01-01 00:00:00";
}
else
{
NewSystemTime = SQLiteDBClass.globalSystems.Max(x => x.UpdateDate);
lstsyst = NewSystemTime.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
lstsyst = db.GetSettingString("EDSMLastSystems", lstsyst);
if (lstsyst.Equals("2010-01-01 00:00:00"))
lstsyst = NewSystemTime.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
}
json = RequestSystems(lstsyst);
List<SystemClass> listNewSystems = SystemClass.ParseEDSM(json, ref date);
List<SystemClass> systems2Store = new List<SystemClass>();
foreach (SystemClass system in listNewSystems)
{
// Check if sys exists first
SystemClass sys = SystemData.GetSystem(system.name);
if (sys == null)
systems2Store.Add(system);
else if (!sys.name.Equals(system.name) || sys.x != system.x || sys.y != system.y || sys.z != system.z) // Case or position changed
systems2Store.Add(system);
}
SystemClass.Store(systems2Store);
retstr = systems2Store.Count.ToString() + " new systems from EDSM." + Environment.NewLine;
Application.DoEvents();
db.PutSettingString("EDSMLastSystems", date);
return retstr;
}
internal string GetNewSystems(SQLiteDBClass db)
{
string json;
string date = "2010-01-01 00:00:00";
string lstsyst;
string retstr = "";
Application.DoEvents();
db.GetAllSystems();
//if (lstsys)
DateTime NewSystemTime;
if (SQLiteDBClass.globalSystems == null || SQLiteDBClass.globalSystems.Count ==0)
{
lstsyst = "2010-01-01 00:00:00";
}
else
{
NewSystemTime = SQLiteDBClass.globalSystems.Max(x => x.UpdateDate);
lstsyst = NewSystemTime.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
lstsyst = db.GetSettingString("EDSMLastSystems", lstsyst);
if (lstsyst.Equals("2010-01-01 00:00:00"))
lstsyst = NewSystemTime.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture);
}
json = RequestSystems(lstsyst);
List<SystemClass> listNewSystems = SystemClass.ParseEDSM(json, ref date);
retstr = listNewSystems.Count.ToString() + " new systems from EDSM." + Environment.NewLine;
Application.DoEvents();
SystemClass.Store(listNewSystems);
db.PutSettingString("EDSMLastSystems", date);
return retstr;
}
