public void AddSystemFactionTracking(IEICSystemFaction systemFaction)
{
var sprocConfig = new StoredProcedureConfig
{
ProcedureName = "add_systemfactiontracking",
Parameters =
{
["@sysName"] = systemFaction.System.Name,
["@sysTraffic"] = systemFaction.System.Traffic,
["@sysPopulation"] = systemFaction.System.Population,
["@sysGovernment"] = systemFaction.System.Government,
["@sysSecurity"] = systemFaction.System.Security,
["@sysPower"] = systemFaction.System.Power,
["@facName"] = systemFaction.Faction.Name,
["@facAllegiance"] = systemFaction.Faction.Allegiance,
["@facInfluence"] = systemFaction.Influence,
["@facCurrentState"] = systemFaction.CurrentState,
["@facPendingState"] = systemFaction.PendingState,
["@facRecoverState"] = systemFaction.RecoveringState,
["@controllingFaction"] = false,
["@updatedBy"] = systemFaction.UpdatedBy
}
};
_dataAdapter.ExecuteNonQueryProcedure(sprocConfig);
}
public List<IEICSystemFaction> GetLatestEICSystemFactionTracking()
{
var sprocConfig = new StoredProcedureConfig
{
ProcedureName = "get_latestsystemfaction_tracking"
};
var dt = _dataAdapter.ExecuteProcedure(sprocConfig);
var eicSystemFactions = dt.Select().Select(row => new EICSystemFaction()
{
System = new EICSystem()
{
Name = row["system_name"].ToString(),
Traffic = int.Parse(row["system_traffic"].ToString()),
Population = int.Parse(row["system_population"].ToString()),
Government = row["system_government"].ToString(),
Allegiance = row["system_allegiance"].ToString(),
State = row["system_state"].ToString(),
Security = row["system_security"].ToString(),
Economy = row["system_economy"].ToString(),
Power = row["system_power"].ToString(),
PowerState = row["system_power_state"].ToString(),
},
Faction = new EICFaction()
{
Name = row["faction_name"].ToString()
},
Influence = Double.Parse(row["systemfaction_influence"].ToString()),
CurrentState = row["systemfaction_currentstate"].ToString(),
PendingState = row["systemfaction_pendingstate"].ToString(),
RecoveringState = row["systemfaction_recoveringstate"].ToString()
}).ToList<IEICSystemFaction>();
return eicSystemFactions;
}