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(); }