private bool Add(SQLiteConnectionUser cn)
{
using (DbCommand cmd = cn.CreateCommand("Insert into routes_expeditions (name, start, end, Status) values (@name, @start, @end, @stat)"))
{
cmd.AddParameterWithValue("@name", Name);
cmd.AddParameterWithValue("@start", StartDate);
cmd.AddParameterWithValue("@end", EndDate);
cmd.AddParameterWithValue("@stat", (Deleted ? 1 : 0) + (EDSM ? 2 : 0));
cn.SQLNonQueryText(cmd);
using (DbCommand cmd2 = cn.CreateCommand("Select Max(id) as id from routes_expeditions"))
{
Id = (long)cn.SQLScalar(cmd2);
}
using (DbCommand cmd2 = cn.CreateCommand("INSERT INTO route_systems (routeid, systemname) VALUES (@routeid, @name)"))
{
cmd2.AddParameter("@routeid", DbType.String);
cmd2.AddParameter("@name", DbType.String);
foreach (var sysname in Systems)
{
cmd2.Parameters["@routeid"].Value = Id;
cmd2.Parameters["@name"].Value = sysname;
cn.SQLNonQueryText(cmd2);
}
}
return(true);
}
}
private bool Add(SQLiteConnectionUser cn)
{
using (DbCommand cmd = cn.CreateCommand("Insert into wanted_systems (systemname) values (@systemname)"))
{
cmd.AddParameterWithValue("@systemname", system);
cn.SQLNonQueryText(cmd);
using (DbCommand cmd2 = cn.CreateCommand("Select Max(id) as id from wanted_systems"))
{
id = (long)cn.SQLScalar(cmd2);
}
return(true);
}
}
private bool Add(SQLiteConnectionUser cn)
{
using (DbCommand cmd = cn.CreateCommand("Insert into TravelLogUnit (Name, type, size, Path, CommanderID) values (@name, @type, @size, @Path, @CommanderID)"))
{
cmd.AddParameterWithValue("@name", Name);
cmd.AddParameterWithValue("@type", type);
cmd.AddParameterWithValue("@size", Size);
cmd.AddParameterWithValue("@Path", Path);
cmd.AddParameterWithValue("@CommanderID", CommanderId);
cn.SQLNonQueryText(cmd);
using (DbCommand cmd2 = cn.CreateCommand("Select Max(id) as id from TravelLogUnit"))
{
id = (long)cn.SQLScalar(cmd2);
}
return(true);
}
}
private bool Add(SQLiteConnectionUser cn)
{
using (DbCommand cmd = cn.CreateCommand("Insert into CaptainsLog (Commander, Time, SystemName, BodyName, Note, Tags, Parameters) values (@c,@t,@s,@b,@n,@g,@p)"))
{
cmd.AddParameterWithValue("@c", Commander);
cmd.AddParameterWithValue("@t", TimeUTC);
cmd.AddParameterWithValue("@s", SystemName);
cmd.AddParameterWithValue("@b", BodyName);
cmd.AddParameterWithValue("@n", Note);
cmd.AddParameterWithValue("@g", Tags);
cmd.AddParameterWithValue("@p", Parameters);
cn.SQLNonQueryText(cmd);
using (DbCommand cmd2 = cn.CreateCommand("Select Max(id) as id from CaptainsLog"))
{
ID = (long)cn.SQLScalar(cmd2);
}
return(true);
}
}
private bool Add(SQLiteConnectionUser cn)
{
using (DbCommand cmd = cn.CreateCommand("Insert into Bookmarks (StarName, x, y, z, Time, Heading, Note, PlanetMarks) values (@sname, @xp, @yp, @zp, @time, @head, @note, @pmarks)"))
{
cmd.AddParameterWithValue("@sname", StarName);
cmd.AddParameterWithValue("@xp", x);
cmd.AddParameterWithValue("@yp", y);
cmd.AddParameterWithValue("@zp", z);
cmd.AddParameterWithValue("@time", Time);
cmd.AddParameterWithValue("@head", Heading);
cmd.AddParameterWithValue("@note", Note);
cmd.AddParameterWithValue("@pmarks", PlanetaryMarks?.ToJsonString());
cn.SQLNonQueryText(cmd);
using (DbCommand cmd2 = cn.CreateCommand("Select Max(id) as id from Bookmarks"))
{
id = (long)cn.SQLScalar(cmd2);
}
return(true);
}
}
private bool AddToDbAndGlobal(SQLiteConnectionUser cn)
{
using (DbCommand cmd = cn.CreateCommand("Insert into SystemNote (Name, Time, Note, journalid, edsmid) values (@name, @time, @note, @journalid, @edsmid)"))
{
cmd.AddParameterWithValue("@name", SystemName);
cmd.AddParameterWithValue("@time", Time);
cmd.AddParameterWithValue("@note", Note);
cmd.AddParameterWithValue("@journalid", Journalid);
cmd.AddParameterWithValue("@edsmid", EdsmId);
cn.SQLNonQueryText(cmd);
using (DbCommand cmd2 = cn.CreateCommand("Select Max(id) as id from SystemNote"))
{
id = (long)cn.SQLScalar(cmd2);
}
globalSystemNotes.Add(this);
Dirty = false;
return(true);
}
}
