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);
}
return(true);
}
}
}
catch
{
return(false);
}
}
private bool UpgradeDB4()
{
string query1 = "ALTER TABLE SystemNote ADD COLUMN Note TEXT";
string dbfile = GetSQLiteDBFile();
try
{
File.Copy(dbfile, dbfile.Replace("EDDiscovery.sqlite", "EDDiscovery3.sqlite"));
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine("Exception: " + ex.Message);
System.Diagnostics.Trace.WriteLine("Trace: " + ex.StackTrace);
}
try
{
ExecuteQuery(query1);
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine("Exception: " + ex.Message);
System.Diagnostics.Trace.WriteLine("Trace: " + ex.StackTrace);
MessageBox.Show("UpgradeDB4 error: " + ex.Message);
}
GetAllSystems();
foreach (SystemClass sys in globalSystems)
{
if (sys.Note != null && sys.Note.Length > 0)
{
SystemNoteClass note = new SystemNoteClass();
note.Name = sys.name;
note.Note = sys.Note;
note.Time = DateTime.Now;
note.Add();
}
}
PutSettingInt("DBVer", 4);
return(true);
}
public bool GetAllSystemNotes()
{
try
{
using (SQLiteConnection cn = new SQLiteConnection(ConnectionString))
{
using (SQLiteCommand cmd = new SQLiteCommand())
{
DataSet ds = null;
cmd.Connection = cn;
cmd.CommandType = CommandType.Text;
cmd.CommandTimeout = 30;
cmd.CommandText = "select * from SystemNote";
ds = SqlQueryText(cn, cmd);
if (ds.Tables.Count == 0)
{
return(false);
}
//
if (ds.Tables[0].Rows.Count == 0)
{
return(false);
}
globalSystemNotes.Clear();
foreach (DataRow dr in ds.Tables[0].Rows)
{
SystemNoteClass sys = new SystemNoteClass(dr);
globalSystemNotes[sys.Name.ToLower()] = sys;
}
return(true);
}
}
}
catch
{
return(false);
}
}
public static void setTargetSystem(Object sender, EDDiscoveryForm _discoveryForm, String sn, Boolean prompt)
{
if (string.IsNullOrWhiteSpace(sn))
{
if (prompt && TargetClass.IsTargetSet()) // if prompting, and target is set, ask for delete
{
if (ExtendedControls.MessageBoxTheme.Show("Confirm deletion of target", "Delete a target", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
TargetClass.ClearTarget();
_discoveryForm.NewTargetSet(sender); // tells everyone who cares a new target was set
}
}
return;
}
ISystem sc = _discoveryForm.history.FindSystem(sn);
string msgboxtext = null;
if (sc != null && sc.HasCoordinate)
{
SystemNoteClass nc = SystemNoteClass.GetNoteOnSystem(sc.name, sc.id_edsm); // has it got a note?
if (nc != null)
{
TargetClass.SetTargetNotedSystem(sc.name, nc.id, sc.x, sc.y, sc.z);
msgboxtext = "Target set on system with note " + sc.name;
}
else
{
BookmarkClass bk = BookmarkClass.FindBookmarkOnSystem(sn); // has it been bookmarked?
if (bk != null)
{
TargetClass.SetTargetBookmark(sc.name, bk.id, bk.x, bk.y, bk.z);
msgboxtext = "Target set on booked marked system " + sc.name;
}
else
{
bool createbookmark = false;
if ((prompt && ExtendedControls.MessageBoxTheme.Show("Make a bookmark on " + sc.name + " and set as target?", "Make Bookmark", MessageBoxButtons.OKCancel) == DialogResult.OK) || !prompt)
{
createbookmark = true;
}
if (createbookmark)
{
BookmarkClass newbk = new BookmarkClass();
newbk.StarName = sn;
newbk.x = sc.x;
newbk.y = sc.y;
newbk.z = sc.z;
newbk.Time = DateTime.Now;
newbk.Note = "";
newbk.Add();
TargetClass.SetTargetBookmark(sc.name, newbk.id, newbk.x, newbk.y, newbk.z);
}
}
}
}
else
{
if (sn.Length > 2 && sn.Substring(0, 2).Equals("G:"))
{
sn = sn.Substring(2, sn.Length - 2);
}
GalacticMapObject gmo = _discoveryForm.galacticMapping.Find(sn, true, true); // ignore if its off, find any part of string, find if disabled
if (gmo != null)
{
TargetClass.SetTargetGMO("G:" + gmo.name, gmo.id, gmo.points[0].X, gmo.points[0].Y, gmo.points[0].Z);
msgboxtext = "Target set on galaxy object " + gmo.name;
}
else
{
msgboxtext = "Unknown system, system is without co-ordinates or galaxy object not found";
}
}
_discoveryForm.NewTargetSet(sender); // tells everyone who cares a new target was set
if (msgboxtext != null && prompt)
{
ExtendedControls.MessageBoxTheme.Show(msgboxtext, "Create a target", MessageBoxButtons.OK);
}
}
public static void showBookmarkForm(Object sender,
EDDiscoveryForm discoveryForm, ISystem cursystem, BookmarkClass curbookmark, bool notedsystem)
{
// try and find the associated bookmark..
BookmarkClass bkmark = (curbookmark != null) ? curbookmark : BookmarkClass.bookmarks.Find(x => x.StarName != null && x.StarName.Equals(cursystem.name));
SystemNoteClass sn = (cursystem != null) ? SystemNoteClass.GetNoteOnSystem(cursystem.name, cursystem.id_edsm) : null;
string note = (sn != null) ? sn.Note : "";
BookmarkForm frm = new BookmarkForm();
if (notedsystem && bkmark == null) // note on a system
{
long targetid = TargetClass.GetTargetNotedSystem(); // who is the target of a noted system (0=none)
long noteid = sn.id;
frm.InitialisePos(cursystem.x, cursystem.y, cursystem.z);
frm.NotedSystem(cursystem.name, note, noteid == targetid); // note may be passed in null
frm.ShowDialog();
if ((frm.IsTarget && targetid != noteid) || (!frm.IsTarget && targetid == noteid)) // changed..
{
if (frm.IsTarget)
{
TargetClass.SetTargetNotedSystem(cursystem.name, noteid, cursystem.x, cursystem.y, cursystem.z);
}
else
{
TargetClass.ClearTarget();
}
}
}
else
{
bool regionmarker = false;
DateTime tme;
long targetid = TargetClass.GetTargetBookmark(); // who is the target of a bookmark (0=none)
if (bkmark == null) // new bookmark
{
frm.InitialisePos(cursystem.x, cursystem.y, cursystem.z);
tme = DateTime.Now;
frm.NewSystemBookmark(cursystem.name, note, tme.ToString());
}
else // update bookmark
{
frm.InitialisePos(bkmark.x, bkmark.y, bkmark.z);
regionmarker = bkmark.isRegion;
tme = bkmark.Time;
frm.Update(regionmarker ? bkmark.Heading : bkmark.StarName, note, bkmark.Note, tme.ToString(), regionmarker, targetid == bkmark.id);
}
DialogResult res = frm.ShowDialog();
if (res == DialogResult.OK)
{
BookmarkClass newcls = new BookmarkClass();
if (regionmarker)
{
newcls.Heading = frm.StarHeading;
}
else
{
newcls.StarName = frm.StarHeading;
}
newcls.x = double.Parse(frm.x);
newcls.y = double.Parse(frm.y);
newcls.z = double.Parse(frm.z);
newcls.Time = tme;
newcls.Note = frm.Notes;
if (bkmark != null)
{
newcls.id = bkmark.id;
newcls.Update();
}
else
{
newcls.Add();
}
if ((frm.IsTarget && targetid != newcls.id) || (!frm.IsTarget && targetid == newcls.id)) // changed..
{
if (frm.IsTarget)
{
TargetClass.SetTargetBookmark(regionmarker ? ("RM:" + newcls.Heading) : newcls.StarName, newcls.id, newcls.x, newcls.y, newcls.z);
}
else
{
TargetClass.ClearTarget();
}
}
}
else if (res == DialogResult.Abort && bkmark != null)
{
if (targetid == bkmark.id)
{
TargetClass.ClearTarget();
}
bkmark.Delete();
}
}
discoveryForm.NewTargetSet(sender);
}