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));
SQLiteDBClass.SQLNonQueryText(cn, cmd);
using (DbCommand cmd2 = cn.CreateCommand("Select Max(id) as id from routes_expeditions"))
{
Id = (long)SQLiteDBClass.SQLScalar(cn, 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;
SQLiteDBClass.SQLNonQueryText(cn, cmd2);
}
}
return(true);
}
}
private bool Add(SQLiteConnectionUser cn)
{
using (DbCommand cmd = cn.CreateCommand("Insert into wanted_systems (systemname) values (@systemname)"))
{
cmd.AddParameterWithValue("@systemname", system);
SQLiteDBClass.SQLNonQueryText(cn, cmd);
using (DbCommand cmd2 = cn.CreateCommand("Select Max(id) as id from wanted_systems"))
{
id = (long)SQLiteDBClass.SQLScalar(cn, 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);
SQLiteDBClass.SQLNonQueryText(cn, cmd);
using (DbCommand cmd2 = cn.CreateCommand("Select Max(id) as id from TravelLogUnit"))
{
id = (long)SQLiteDBClass.SQLScalar(cn, cmd2);
}
return(true);
}
}
private bool Add(SQLiteConnectionUser cn)
{
using (DbCommand cmd = cn.CreateCommand("Insert into Bookmarks (StarName, x, y, z, Time, Heading, Note) values (@sname, @xp, @yp, @zp, @time, @head, @note)"))
{
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);
SQLiteDBClass.SQLNonQueryText(cn, cmd);
using (DbCommand cmd2 = cn.CreateCommand("Select Max(id) as id from Bookmarks"))
{
id = (long)SQLiteDBClass.SQLScalar(cn, cmd2);
}
bookmarks.Add(this);
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);
SQLiteDBClass.SQLNonQueryText(cn, cmd);
using (DbCommand cmd2 = cn.CreateCommand("Select Max(id) as id from SystemNote"))
{
id = (long)SQLiteDBClass.SQLScalar(cn, cmd2);
}
globalSystemNotes.Add(this);
Dirty = false;
return(true);
}
}
