public void InsertProductionLog(IntrusionEvents eventType, int?facilityDefinition, int?facilityLevel, int?oldFacilityLevel, Character character, int?points, int?oldPoints, long?owner)
{
const string insertStr = @"insert intrusionproductionlog (siteeid,eventtype,facilitydefinition,facilitylevel,oldfacilitylevel,characterid,points,oldpoints,owner)
values (@siteeid,@eventtype,@facilitydefinition,@facilitylevel,@oldfacilitylevel,@characterid,@points,@oldpoints,@owner)";
Db.Query().CommandText(insertStr)
.SetParameter("@siteeid", Eid)
.SetParameter("@eventtype", (int)eventType)
.SetParameter("@facilitydefinition", facilityDefinition)
.SetParameter("@facilitylevel", facilityLevel)
.SetParameter("@oldfacilitylevel", oldFacilityLevel)
.SetParameter("@characterid", character?.Id)
.SetParameter("@points", points)
.SetParameter("@oldpoints", oldPoints)
.SetParameter("@owner", owner)
.ExecuteNonQuery();
}
public void InsertIntrusionSiteMessageLog(Character character, string message, long?owner, IntrusionEvents intrusionEvents)
{
Db.Query().CommandText("insert intrusionsitemessagelog (siteeid,owner,characterid,message,eventtype) values (@siteEID,@owner,@characterID,@message,@eventType)")
.SetParameter("@siteEID", Eid)
.SetParameter("@owner", owner)
.SetParameter("@characterID", character.Id)
.SetParameter("@message", message)
.SetParameter("@eventType", intrusionEvents)
.ExecuteNonQuery();
}
private void InsertIntrusionEffectLog(int?characterId, int?effectId, long?owner, IntrusionEvents intrusionEvents)
{
Db.Query().CommandText("insert intrusioneffectlog (siteeid,characterid,effectid,owner,eventtype) values (@siteEID,@characterID,@effectID,@owner,@eventType)")
.SetParameter("@siteEID", Eid)
.SetParameter("@characterID", characterId)
.SetParameter("@effectID", effectId)
.SetParameter("@owner", owner)
.SetParameter("@eventType", intrusionEvents)
.ExecuteNonQuery();
}
public void InsertDockingRightsLog(Character character, double?dockingStandingLimit, long?owner, IntrusionEvents intrusionEvents)
{
Db.Query().CommandText("insert intrusiondockingrightslog (characterid,siteeid,dockingstandinglimit,owner,eventtype) values (@characterID,@siteEID,@dockingStandingLimit,@owner,@eventType)")
.SetParameter("@characterID", character?.Id)
.SetParameter("@siteEID", Eid)
.SetParameter("@dockingStandingLimit", dockingStandingLimit)
.SetParameter("@owner", owner)
.SetParameter("@eventType", intrusionEvents)
.ExecuteNonQuery();
}
private void InsertIntrusionLog(long?owner, int newStability, long?winnerCorporationEid, int sapDefinition, int oldStability, long?oldOwner, IntrusionEvents intrusionEvents)
{
const string insertStr = @"insert intrusionsitelog (siteeid,owner,stability,winnercorporationeid,sapdefinition,oldstability,oldowner,eventtype)
values (@siteEID,@owner,@stability,@winnerCorporationEid,@sapDefinition,@oldStability,@oldOwner,@eventType)";
Db.Query().CommandText(insertStr)
.SetParameter("@siteEID", Eid)
.SetParameter("@owner", owner)
.SetParameter("@stability", newStability)
.SetParameter("@oldStability", oldStability)
.SetParameter("@winnerCorporationEid", winnerCorporationEid)
.SetParameter("@sapDefinition", sapDefinition)
.SetParameter("@oldOwner", oldOwner)
.SetParameter("@eventType", intrusionEvents)
.ExecuteNonQuery();
}
