private static IEnumerable <ZoneSector> LoadAll(IZoneManager zoneManager)
{
var records = Db.Query().CommandText("select id,name,sector,zoneid from zonesectors").Execute();
foreach (var record in records)
{
var zoneID = record.GetValue <int>(3);
if (!zoneManager.ContainsZone(zoneID))
{
continue;
}
var sector = new ZoneSector
{
id = record.GetValue <int>(0),
name = record.GetValue <string>(1),
sector = record.GetValue <byte[]>(2),
zoneID = zoneID
};
yield return(sector);
}
}
public void HandleRequest(IRequest request)
{
using (var scope = Db.CreateTransaction())
{
var character = request.Session.Character;
var primaryactivity = request.Data.GetOrDefault(k.primaryActivity, -1);
var primaryzone = request.Data.GetOrDefault(k.zoneID, -1);
var primarybase = request.Data.GetOrDefault(k.baseEID, (long)-1);
var orientation = request.Data.GetOrDefault(k.orientation, -1);
var lookingfor = request.Data.GetOrDefault(k.lookingFor, -1);
var preferredfaction = request.Data.GetOrDefault(k.preferredFaction, -1);
var providesinsurance = request.Data.GetOrDefault(k.providesInsurance, -1);
var timezone = request.Data.GetOrDefault(k.timeZone, -1);
var requiredactivity = request.Data.GetOrDefault(k.requiredActivity, -1);
var communication = request.Data.GetOrDefault(k.communication, -1);
var services = request.Data.GetOrDefault(k.services, -1);
var updateList = new List <string>();
var insertDict = new Dictionary <string, object>();
var corporationeid = character.CorporationEid;
DefaultCorporationDataCache.IsCorporationDefault(corporationeid).ThrowIfTrue(ErrorCodes.CharacterMustBeInPrivateCorporation);
var role = Corporation.GetRoleFromSql(character);
role.IsAnyRole(CorporationRole.CEO, CorporationRole.DeputyCEO, CorporationRole.HRManager, CorporationRole.PRManager).ThrowIfFalse(ErrorCodes.InsufficientPrivileges);
var update = false;
var query = Db.Query();
var id = query.CommandText("select id from yellowpages where corporationeid=@corporationeid")
.SetParameter("@corporationeid", corporationeid)
.ExecuteScalar <int>();
if (id > 0)
{
update = true;
}
insertDict.Add("corporationeid", corporationeid);
if (primaryactivity >= 0)
{
insertDict.Add("primaryactivity", primaryactivity);
updateList.Add("primaryactivity=@primaryactivity ");
query.SetParameter("@primaryactivity", primaryactivity);
}
if (primaryzone >= 0)
{
_zoneManager.ContainsZone(primaryzone).ThrowIfFalse(ErrorCodes.ZoneNotFound);
insertDict.Add("zoneID", primaryzone);
updateList.Add("zoneID = @primaryzone ");
query.SetParameter("@primaryzone", primaryzone);
}
//set explicitely on the client
if (request.Data.ContainsKey(k.zoneID) && primaryzone == -1)
{
updateList.Add("zoneID = NULL ");
}
//na ezert nem lehet pbs base-t a yellow pagesbe beallitani
if (primarybase > 0)
{
var dockingBase = _dockingBaseHelper.GetDockingBase(primarybase);
insertDict.Add("baseEID", dockingBase.Eid);
updateList.Add("baseEID = @primarybase ");
query.SetParameter("@primarybase", primarybase);
}
if (request.Data.ContainsKey(k.baseEID) && primarybase == -1)
{
updateList.Add("baseEID = NULL ");
}
if (orientation >= 0)
{
insertDict.Add("orientation", orientation);
updateList.Add("orientation=@orientation ");
query.SetParameter("@orientation", orientation);
}
if (lookingfor >= 0)
{
insertDict.Add("lookingfor", lookingfor);
updateList.Add("lookingfor=@lookingfor ");
query.SetParameter("@lookingfor", lookingfor);
}
if (preferredfaction >= 0)
{
insertDict.Add("preferredfaction", preferredfaction);
updateList.Add("preferredfaction = @preferredfaction ");
query.SetParameter("@preferredfaction", preferredfaction);
}
if (request.Data.ContainsKey(k.preferredFaction) && preferredfaction == -1)
{
updateList.Add("preferredfaction = NULL ");
}
if (providesinsurance >= 0)
{
insertDict.Add("providesinsurance", providesinsurance);
updateList.Add("providesinsurance=@providesinsurance ");
query.SetParameter("@providesinsurance", providesinsurance);
}
if (timezone >= 0)
{
insertDict.Add("timezone", timezone);
updateList.Add("timezone=@timezone ");
query.SetParameter("@timezone", timezone);
}
if (requiredactivity >= 0)
{
insertDict.Add("requiredactivity", requiredactivity);
updateList.Add("requiredactivity=@requiredactivity ");
query.SetParameter("@requiredactivity", requiredactivity);
}
if (communication >= 0)
{
insertDict.Add("communication", communication);
updateList.Add("communication=@communication ");
query.SetParameter("@communication", communication);
}
if (services >= 0)
{
insertDict.Add("services", services);
updateList.Add("services=@services");
query.SetParameter("@services", services);
}
updateList.Count.ThrowIfEqual(0, ErrorCodes.NothingDefined);
string cmdStr;
if (update)
{
cmdStr = "update yellowpages set " + updateList.ArrayToString() + " where id=@id";
query.CommandText(cmdStr).SetParameter("@id", id);
}
else
{
cmdStr = insertDict.ToInsertString("yellowpages", "nothing");
query.CommandText(cmdStr);
}
query.ExecuteNonQuery().ThrowIfNotEqual(1, ErrorCodes.SQLExecutionError);
var entry = _corporationManager.GetYellowPages(corporationeid);
var result = new Dictionary <string, object> {
{ k.data, entry }
};
Message.Builder.FromRequest(request).WithData(result).Send();
CorporationData.RemoveFromCache(corporationeid);
scope.Complete();
}
}
