public static bool GetAllSystemNotes()
{
try
{
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: EDDbAccessMode.Reader))
{
using (DbCommand cmd = cn.CreateCommand("select * from SystemNote"))
{
DataSet ds = SQLiteDBClass.SQLQueryText(cn, cmd);
if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return(false);
}
globalSystemNotes.Clear();
foreach (DataRow dr in ds.Tables[0].Rows)
{
SystemNoteClass sys = new SystemNoteClass(dr);
globalSystemNotes.Add(sys);
//System.Diagnostics.Debug.WriteLine("Global note " + sys.Journalid + " " + sys.SystemName + " " + sys.Note);
}
return(true);
}
}
}
catch
{
return(false);
}
}
public static bool GetAllBookmarks()
{
try
{
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: EDDbAccessMode.Reader))
{
using (DbCommand cmd = cn.CreateCommand("select * from Bookmarks"))
{
DataSet ds = null;
ds = SQLiteDBClass.SQLQueryText(cn, cmd);
if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return(false);
}
bookmarks.Clear();
foreach (DataRow dr in ds.Tables[0].Rows)
{
BookmarkClass bc = new BookmarkClass(dr);
bookmarks.Add(bc);
}
return(true);
}
}
}
catch
{
return(false);
}
}
public static bool LoadBookmarks()
{
System.Diagnostics.Debug.Assert(gbl == null); // no double instancing!
gbl = new GlobalBookMarkList();
try
{
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: EDDbAccessMode.Reader))
{
using (DbCommand cmd = cn.CreateCommand("select * from Bookmarks"))
{
DataSet ds = null;
ds = SQLiteDBClass.SQLQueryText(cn, cmd);
if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return(false);
}
foreach (DataRow dr in ds.Tables[0].Rows)
{
BookmarkClass bc = new BookmarkClass(dr);
gbl.globalbookmarks.Add(bc);
}
return(true);
}
}
}
catch
{
return(false);
}
}
public static List <WantedSystemClass> GetAllWantedSystems()
{
try
{
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: EDDbAccessMode.Reader))
{
using (DbCommand cmd = cn.CreateCommand("select * from wanted_systems"))
{
DataSet ds = SQLiteDBClass.SQLQueryText(cn, cmd);
if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return(null);
}
List <WantedSystemClass> retVal = new List <WantedSystemClass>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
WantedSystemClass sys = new WantedSystemClass(dr);
retVal.Add(sys);
}
return(retVal);
}
}
}
catch
{
return(null);
}
}
public static List <SavedRouteClass> GetAllSavedRoutes()
{
List <SavedRouteClass> retVal = new List <SavedRouteClass>();
try
{
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(utc: true, mode: EDDbAccessMode.Reader))
{
using (DbCommand cmd1 = cn.CreateCommand("select * from routes_expeditions"))
{
DataSet ds1 = SQLiteDBClass.SQLQueryText(cn, cmd1);
if (ds1.Tables.Count > 0 && ds1.Tables[0].Rows.Count > 0)
{
using (DbCommand cmd2 = cn.CreateCommand("select * from route_systems"))
{
DataSet ds2 = SQLiteDBClass.SQLQueryText(cn, cmd2);
foreach (DataRow dr in ds1.Tables[0].Rows)
{
DataRow[] syslist = new DataRow[0];
if (ds2.Tables.Count != 0)
{
syslist = ds2.Tables[0].Select(String.Format("routeid = {0}", dr["id"]), "id ASC");
}
SavedRouteClass sys = new SavedRouteClass(dr, syslist);
retVal.Add(sys);
}
}
}
}
}
}
catch
{
}
return(retVal);
}
static public List <TravelLogUnit> GetAll()
{
List <TravelLogUnit> list = new List <TravelLogUnit>();
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(mode: EDDbAccessMode.Reader))
{
using (DbCommand cmd = cn.CreateCommand("select * from TravelLogUnit"))
{
DataSet ds = SQLiteDBClass.SQLQueryText(cn, cmd);
if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return(list);
}
foreach (DataRow dr in ds.Tables[0].Rows)
{
TravelLogUnit sys = new TravelLogUnit(dr);
list.Add(sys);
}
return(list);
}
}
}
