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