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