public void LedgerNC(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
string n = (VictimFactionLocalised.Length > 0) ? VictimFactionLocalised : VictimFaction;
n += " total " + (TotalReward + Reward).ToString("N0");
mcl.AddEventNoCash(Id, EventTimeUTC, EventTypeID, n);
}
// if aclist has one action, action selector not shown.
public void Init(string t, string aclist, bool outc, EDDiscovery2.EDDTheme th, JSONFilter j = null)
{
// outc selects if group outer action can be selected, else its OR
theme = th;
actionlist = aclist;
allowoutercond = outc;
hoffset = (actionlist.Split(';').Count()>1) ? (288) : (160);
panelwidth = hoffset + 620;
result = j;
if (result != null)
{
foreach (JSONFilter.FilterEvent fe in result.filters)
{
Group g = CreateGroup(fe.eventname, fe.action, fe.innercondition.ToString(), fe.outercondition.ToString());
foreach (JSONFilter.Fields f in fe.fields)
{
CreateCondition(g, f.itemname, JSONFilter.MatchNames[(int)f.matchtype], f.contentmatch);
}
}
}
bool winborder = theme.ApplyToForm(this, SystemFonts.DefaultFont);
statusStripCustom.Visible = panelTop.Visible = !winborder;
this.Text = label_index.Text = t;
}
public void MaterialList(EDDiscovery2.DB.MaterialCommoditiesList mc, DB.SQLiteConnectionUser conn)
{
if (Materials != null)
{
foreach (KeyValuePair<string, int> k in Materials) // may be commodities or materials
mc.Craft(k.Key, k.Value); // same as this, uses up materials
}
}
public void LedgerNC(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
string v = (VictimLocalised.Length > 0) ? VictimLocalised : Victim;
if (v.Length == 0)
v = Faction;
if (Fine.HasValue)
v += " Fine " + Fine.Value.ToString("N0");
if (Bounty.HasValue)
v += " Bounty " + Bounty.Value.ToString("N0");
mcl.AddEventNoCash(Id, EventTimeUTC, EventTypeID, CrimeType + " on " + v);
}
public static double FindDistance(EDDiscovery2.DB.ISystem s1, EDDiscovery2.DB.ISystem s2)
{
DistanceClass dst = GetDistanceClass(s1, s2);
return (dst == null) ? -1 : dst.Dist;
}
public void Ledger(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
mcl.AddEvent(Id, EventTimeUTC, EventTypeID, Name + " " + System, Reward);
}
public void Ledger(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
mcl.AddEvent(Id, EventTimeUTC, EventTypeID, Type + " " + Count + " drones", -TotalCost);
}
public void Ledger(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
EDDiscovery2.DB.MaterialCommodities mc = mcl.GetMaterialCommodity(EDDiscovery2.DB.MaterialCommodities.CommodityCategory, Type, conn);
mcl.AddEvent(Id, EventTimeUTC, EventTypeID, mc.name + " " + Count,-TotalCost);
}
public static double Distance(EDDiscovery2.DB.ISystem s1, double x, double y, double z)
{
if (s1 != null && s1.HasCoordinate)
return Math.Sqrt((s1.x - x) * (s1.x - x) + (s1.y - y) * (s1.y - y) + (s1.z - z) * (s1.z - z));
else
return -1;
}
public void LedgerNC(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
mcl.AddEventNoCash(Id, EventTimeUTC, EventTypeID, AwardingFaction +" " + Reward);
}
public void Ledger(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
if (mcl.CashTotal != Credits)
{
mcl.AddEvent(Id, EventTimeUTC, EventTypeID, "Cash total differs, adjustment", Credits - mcl.CashTotal);
}
}
public void Ledger(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
EDDiscovery2.DB.MaterialCommodities mc = mcl.GetMaterialCommodity(EDDiscovery2.DB.MaterialCommodities.CommodityCategory, Type, conn);
mcl.AddEvent(Id, EventTimeUTC, EventTypeID, mc.name + " " + Count + " Avg " + AvgPricePaid, TotalSale, (double)(SellPrice - AvgPricePaid));
}
public void MaterialList(EDDiscovery2.DB.MaterialCommoditiesList mc, DB.SQLiteConnectionUser conn)
{
mc.Change(Category, Name, Count, 0, conn);
}
public void LedgerNC(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
EDDiscovery2.DB.MaterialCommodities mc = mcl.GetMaterialCommodity(EDDiscovery2.DB.MaterialCommodities.CommodityCategory, Type, conn);
mcl.AddEventNoCash(Id, EventTimeUTC, EventTypeID, mc.name );
}
public void MaterialList(EDDiscovery2.DB.MaterialCommoditiesList mc, DB.SQLiteConnectionUser conn)
{
mc.Change(EDDiscovery2.DB.MaterialCommodities.CommodityCategory, Type, 1, 0, conn);
}
public void MaterialList(EDDiscovery2.DB.MaterialCommoditiesList mc, DB.SQLiteConnectionUser conn)
{
if (Materials != null)
{
foreach (MaterialItem m in Materials.Materials)
mc.Set(m.Category, m.Name, m.Count, 0, conn);
}
if (Commodities != null)
{
foreach (CommodityItem m in Commodities.Commodities)
mc.Set(EDDiscovery2.DB.MaterialCommodities.CommodityCategory, m.Name, m.Count, m.BuyPrice, conn);
}
}
public void Ledger(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
if (Systems!=null)
mcl.AddEvent(Id, EventTimeUTC, EventTypeID, Systems.Length + " systems", Bonus + BaseValue);
}
public void Ledger(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
mcl.AddEvent(Id, EventTimeUTC, EventTypeID, StoredItemLocalised + " on " + Ship, -TransferCost);
}
public static DistanceClass GetDistanceClass(EDDiscovery2.DB.ISystem s1, EDDiscovery2.DB.ISystem s2)
{
if (s1 == null || s2 == null)
return null;
try
{
using (SQLiteConnectionSystem cn = new SQLiteConnectionSystem())
{
using (DbCommand cmd = cn.CreateCommand("SELECT * FROM Distances WHERE (NameA = @NameA and NameB = @NameB) OR (NameA = @NameB and NameB = @NameA) limit 1"))
{
cmd.AddParameterWithValue("@NameA", s1.name);
cmd.AddParameterWithValue("@NameB", s2.name);
DataSet ds = SQLiteDBClass.SQLQueryText(cn, cmd);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) // if found.
{
DistanceClass dist = new DistanceClass(ds.Tables[0].Rows[0]);
return dist;
}
}
}
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine("Exception : " + ex.Message);
System.Diagnostics.Trace.WriteLine(ex.StackTrace);
}
return null;
}
public SystemClass(JObject jo, EDDiscovery2.DB.SystemInfoSource source)
{
try
{
if (source == EDDiscovery2.DB.SystemInfoSource.RW)
{
try
{
x = jo["x"].Value<double>();
y = jo["y"].Value<double>();
z = jo["z"].Value<double>();
name = jo["name"].Value<string>();
SearchName = name.ToLower();
cr = 1;
status = SystemStatusEnum.RedWizzard;
}
catch
{
}
}
else if (source == EDDiscovery2.DB.SystemInfoSource.EDSC)
{
JArray ja = (JArray)jo["coord"];
name = jo["name"].Value<string>();
SearchName = name.ToLower();
cr = jo["cr"].Value<int>();
if (ja[0].Type == JTokenType.Float || ja[0].Type == JTokenType.Integer)
{
x = ja[0].Value<double>();
y = ja[1].Value<double>();
z = ja[2].Value<double>();
}
else
{
x = double.NaN;
y = double.NaN;
z = double.NaN;
}
CommanderCreate = jo["commandercreate"].Value<string>();
CreateDate = jo["createdate"].Value<DateTime>();
CommanderUpdate = jo["commanderupdate"].Value<string>();
UpdateDate = jo["updatedate"].Value<DateTime>();
status = SystemStatusEnum.EDSC;
}
else if (source == EDDiscovery2.DB.SystemInfoSource.EDSM)
{
JObject coords = (JObject)jo["coords"];
name = jo["name"].Value<string>();
SearchName = name.ToLower();
//cr = jo["cr"].Value<int>();
x = double.NaN;
y = double.NaN;
z = double.NaN;
if (coords != null && (coords["x"].Type == JTokenType.Float || coords["x"].Type == JTokenType.Integer))
{
x = coords["x"].Value<double>();
y = coords["y"].Value<double>();
z = coords["z"].Value<double>();
}
JArray submitted = (JArray)jo["submitted"];
if (submitted != null && submitted.Count > 0)
{
if (submitted[0]["cmdrname"] != null)
CommanderCreate = submitted[0]["cmdrname"].Value<string>();
CreateDate = submitted[0]["date"].Value<DateTime>();
if (submitted[submitted.Count - 1]["cmdrname"] != null)
CommanderUpdate = submitted[submitted.Count - 1]["cmdrname"].Value<string>();
UpdateDate = submitted[submitted.Count - 1]["date"].Value<DateTime>();
}
UpdateDate = jo["date"].Value<DateTime>();
if (CreateDate.Year <= 1)
CreateDate = UpdateDate;
id_edsm = (long)jo["id"]; // pick up its edsm ID
status = SystemStatusEnum.EDSC;
}
else if (source == EDDiscovery2.DB.SystemInfoSource.EDDB)
{
name = jo["name"].Value<string>();
SearchName = name.ToLower();
cr = 1;
x = jo["x"].Value<double>();
y = jo["y"].Value<double>();
z = jo["z"].Value<double>();
id_eddb = jo["id"].Value<int>();
faction = jo["faction"].Value<string>();
if (jo["population"].Type == JTokenType.Integer)
population = jo["population"].Value<long>();
government = EliteDangerous.Government2ID(jo["government"]);
allegiance = EliteDangerous.Allegiance2ID(jo["allegiance"]);
state = EliteDangerous.EDState2ID(jo["state"]);
security = EliteDangerous.EDSecurity2ID(jo["security"]);
primary_economy = EliteDangerous.EDEconomy2ID(jo["primary_economy"]);
if (jo["needs_permit"].Type == JTokenType.Integer)
needs_permit = jo["needs_permit"].Value<int>();
eddb_updated_at = jo["updated_at"].Value<int>();
id_edsm = (long)jo["edsm_id"]; // pick up its edsm ID
status = SystemStatusEnum.EDDB;
}
}
catch { } // since we don't have control of outside formats, we fail quietly.
}
public void Ledger(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
mcl.AddEvent(Id, EventTimeUTC, EventTypeID, Type + " Broker " + BrokerPercentage.ToString("0.0") + "%", Amount);
}
public static double DistanceIncludeDB(EDDiscovery2.DB.ISystem s1, EDDiscovery2.DB.ISystem s2)
{
double dist = Distance(s1, s2);
if (dist < 0)
dist = DistanceClass.FindDistance(s1, s2);
return dist;
}
public void Ledger(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
string s = (RetrievedItemLocalised.Length > 0) ? RetrievedItemLocalised : RetrievedItem;
mcl.AddEvent(Id, EventTimeUTC, EventTypeID, s + " on " + Ship, -Cost);
}
public void MaterialList(EDDiscovery2.DB.MaterialCommoditiesList mc, DB.SQLiteConnectionUser conn)
{
if (CommodityReward != null)
{
// Forum indicates its commodities, and we get normal materialcollected events if its a material.
for (int i = 0; i < CommodityReward.Length; i++)
mc.Change(EDDiscovery2.DB.MaterialCommodities.CommodityCategory, CommodityReward[i].Item1, CommodityReward[i].Item2, 0, conn);
}
}
public void Ledger(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
mcl.AddEvent(Id, EventTimeUTC, EventTypeID, Item, -Cost);
}
public void Ledger(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
mcl.AddEvent(Id, EventTimeUTC, EventTypeID, Count.ToString() + " drones", TotalSale);
}
public static double Distance(EDDiscovery2.DB.ISystem s1, EDDiscovery2.DB.ISystem s2)
{
if (s1 != null && s2 != null && s1.HasCoordinate && s2.HasCoordinate)
return Math.Sqrt((s1.x - s2.x) * (s1.x - s2.x) + (s1.y - s2.y) * (s1.y - s2.y) + (s1.z - s2.z) * (s1.z - s2.z));
else
return -1;
}
public void Ledger(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
string s = (SellItemLocalised.Length > 0) ? SellItemLocalised : SellItem;
mcl.AddEvent(Id, EventTimeUTC, EventTypeID, SellItemLocalised + " on " + Ship, SellPrice);
}
public void Ledger(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
mcl.AddEvent(Id, EventTimeUTC, EventTypeID, ShipType, -TransferPrice);
}
public void Ledger(EDDiscovery2.DB.MaterialCommoditiesLedger mcl, DB.SQLiteConnectionUser conn)
{
mcl.AddEvent(Id, EventTimeUTC, EventTypeID, "Amoubt " + Amount.ToString() +"t", -Cost);
}