static private void Delete(long idvalue, SQLiteConnectionUser cn)
{
using (DbCommand cmd = cn.CreateCommand("DELETE FROM JournalEntries WHERE id = @id"))
{
cmd.AddParameterWithValue("@id", idvalue);
cn.SQLNonQueryText(cmd);
}
}
public void UpdateCommanderID(int cmdrid)
{
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(utc: true))
{
using (DbCommand cmd = cn.CreateCommand("Update JournalEntries set CommanderID = @cmdrid where ID=@journalid"))
{
cmd.AddParameterWithValue("@journalid", Id);
cmd.AddParameterWithValue("@cmdrid", cmdrid);
System.Diagnostics.Trace.WriteLine(string.Format("Update cmdr id ID {0} with map colour", Id));
cn.SQLNonQueryText(cmd);
CommanderId = cmdrid;
}
}
}
public static void ClearEDSMID(int currentcmdrid = -2) // -2 is all
{
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(utc: true))
{
using (DbCommand cmd = cn.CreateCommand("UPDATE JournalEntries SET EdsmId=0"))
{
if (currentcmdrid != -2)
{
cmd.CommandText = "UPDATE JournalEntries SET EdsmId=0 WHERE CommanderId==@cmd";
cmd.AddParameterWithValue("@cmd", currentcmdrid);
}
cn.SQLNonQueryText(cmd);
}
}
}
private bool Update(SQLiteConnectionUser cn, DbTransaction tn = null)
{
using (DbCommand cmd = cn.CreateCommand("Update JournalEntries set EventTime=@EventTime, TravelLogID=@TravelLogID, CommanderID=@CommanderID, EventTypeId=@EventTypeId, EventType=@EventStrName, EdsmId=@EdsmId, Synced=@Synced where ID=@id", tn))
{
cmd.AddParameterWithValue("@ID", Id);
cmd.AddParameterWithValue("@EventTime", EventTimeUTC); // MUST use UTC connection
cmd.AddParameterWithValue("@TravelLogID", TLUId);
cmd.AddParameterWithValue("@CommanderID", CommanderId);
cmd.AddParameterWithValue("@EventTypeId", EventTypeID);
cmd.AddParameterWithValue("@EventStrName", EventTypeStr);
cmd.AddParameterWithValue("@EdsmId", EdsmID);
cmd.AddParameterWithValue("@Synced", Synced);
cn.SQLNonQueryText(cmd);
return(true);
}
}
static public bool ResetCommanderID(int from, int to)
{
using (SQLiteConnectionUser cn = new SQLiteConnectionUser(utc: true))
{
using (DbCommand cmd = cn.CreateCommand("Update JournalEntries set CommanderID = @cmdridto where CommanderID=@cmdridfrom"))
{
if (from == -1)
{
cmd.CommandText = "Update JournalEntries set CommanderID = @cmdridto";
}
cmd.AddParameterWithValue("@cmdridto", to);
cmd.AddParameterWithValue("@cmdridfrom", from);
System.Diagnostics.Trace.WriteLine(string.Format("Update cmdr id ID {0} with {1}", from, to));
cn.SQLNonQueryText(cmd);
}
}
return(true);
}
public bool Add(JObject jo, SQLiteConnectionUser cn, DbTransaction tn = null)
{
using (DbCommand cmd = cn.CreateCommand("Insert into JournalEntries (EventTime, TravelLogID, CommanderId, EventTypeId , EventType, EventData, EdsmId, Synced) values (@EventTime, @TravelLogID, @CommanderID, @EventTypeId , @EventStrName, @EventData, @EdsmId, @Synced)", tn))
{
cmd.AddParameterWithValue("@EventTime", EventTimeUTC); // MUST use UTC connection
cmd.AddParameterWithValue("@TravelLogID", TLUId);
cmd.AddParameterWithValue("@CommanderID", CommanderId);
cmd.AddParameterWithValue("@EventTypeId", EventTypeID);
cmd.AddParameterWithValue("@EventStrName", EventTypeStr);
cmd.AddParameterWithValue("@EventData", jo.ToString());
cmd.AddParameterWithValue("@EdsmId", EdsmID);
cmd.AddParameterWithValue("@Synced", Synced);
cn.SQLNonQueryText(cmd);
using (DbCommand cmd2 = cn.CreateCommand("Select Max(id) as id from JournalEntries"))
{
Id = (int)(long)cn.SQLScalar(cmd2);
}
return(true);
}
}