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 Update(SQLiteConnectionUser cn) { using (DbCommand cmd = cn.CreateCommand("UPDATE routes_expeditions SET name=@name, start=@start, end=@end, Status=@stat WHERE id=@id")) { cmd.AddParameterWithValue("@id", Id); 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("DELETE FROM route_systems WHERE routeid=@routeid")) { cmd2.AddParameterWithValue("@routeid", Id); cn.SQLNonQueryText(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); } }
static private bool Delete(SQLiteConnectionUser cn, long id) { using (DbCommand cmd = cn.CreateCommand("DELETE FROM CaptainsLog WHERE id = @id")) { cmd.AddParameterWithValue("@id", id); cn.SQLNonQueryText(cmd); return(true); } }
private bool Delete(SQLiteConnectionUser cn) { using (DbCommand cmd = cn.CreateCommand("DELETE FROM Bookmarks WHERE id = @id")) { cmd.AddParameterWithValue("@id", id); cn.SQLNonQueryText(cmd); return(true); } }
public static void ClearEDSMID() { using (SQLiteConnectionUser cn = new SQLiteConnectionUser(utc: true)) { using (DbCommand cmd = cn.CreateCommand("UPDATE SystemNote SET EdsmId=0")) { cn.SQLNonQueryText(cmd); } } }
private bool Delete(SQLiteConnectionUser cn) { using (DbCommand cmd = cn.CreateCommand("DELETE FROM SystemNote WHERE id = @id")) { cmd.AddParameterWithValue("@id", id); cn.SQLNonQueryText(cmd); globalSystemNotes.RemoveAll(x => x.id == id); // remove from list any containing id. 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); } }
public bool Update(SQLiteConnectionUser cn, DbTransaction tn = null) { using (DbCommand cmd = cn.CreateCommand("Update TravelLogUnit set Name=@Name, Type=@type, size=@size, Path=@Path, CommanderID=@CommanderID where ID=@id", tn)) { cmd.AddParameterWithValue("@ID", id); cmd.AddParameterWithValue("@Name", Name); cmd.AddParameterWithValue("@Type", type); cmd.AddParameterWithValue("@size", Size); cmd.AddParameterWithValue("@Path", Path); cmd.AddParameterWithValue("@CommanderID", CommanderId); cn.SQLNonQueryText(cmd); return(true); } }
private bool Update(SQLiteConnectionUser cn) { using (DbCommand cmd = cn.CreateCommand("Update CaptainsLog set Commander=@c, Time=@t, SystemName=@s, BodyName=@b, Note=@n, Tags=@g, Parameters=@p where ID=@id")) { cmd.AddParameterWithValue("@id", ID); 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); return(true); } }
private bool Update(SQLiteConnectionUser cn) { using (DbCommand cmd = cn.CreateCommand("Update SystemNote set Name=@Name, Time=@Time, Note=@Note, Journalid=@journalid, EdsmId=@EdsmId where ID=@id")) { cmd.AddParameterWithValue("@ID", id); cmd.AddParameterWithValue("@Name", SystemName); cmd.AddParameterWithValue("@Note", Note); cmd.AddParameterWithValue("@Time", Time); cmd.AddParameterWithValue("@journalid", Journalid); cmd.AddParameterWithValue("@EdsmId", EdsmId); cn.SQLNonQueryText(cmd); Dirty = false; } return(true); }
private bool Update(SQLiteConnectionUser cn) { using (DbCommand cmd = cn.CreateCommand("Update Bookmarks set StarName=@sname, x = @xp, y = @yp, z = @zp, Time=@time, Heading = @head, Note=@note, PlanetMarks=@pmarks where ID=@id")) { cmd.AddParameterWithValue("@ID", id); 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); 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); } }