private SparkTeleport CreateFromRecord(IDataRecord record)
{
var teleport = new SparkTeleport();
teleport.ID = record.GetValue <int>("id");
var baseEid = record.GetValue <long>("baseeid");
teleport.DockingBase = _dockingBaseHelper.GetDockingBase(baseEid);
teleport.Character = Character.Get(record.GetValue <int>("characterid"));
return(teleport);
}
public void Delete(SparkTeleport sparkTeleport)
{
var res = Db.Query().CommandText("delete charactersparkteleports where id=@ID")
.SetParameter("@ID", sparkTeleport.ID)
.ExecuteNonQuery();
if (res == 0)
{
throw new PerpetuumException(ErrorCodes.SQLDeleteError);
}
}
public SparkTeleport CreateSparkTeleport(DockingBase dockingBase, Character character)
{
var teleport = new SparkTeleport
{
Character = character,
DockingBase = dockingBase
};
_sparkTeleportRepository.Insert(teleport);
return(teleport);
}
public void Insert(SparkTeleport sparkTeleport)
{
sparkTeleport.ID = Db.Query().CommandText("insert charactersparkteleports (characterid,baseeid,basedefinition,zoneid,x,y) values (@characterID, @baseEID, @baseDefinition, @zoneID, @x, @y); select cast(scope_identity() as integer")
.SetParameter("@characterID", sparkTeleport.Character.Id)
.SetParameter("@baseEID", sparkTeleport.DockingBase.Eid)
.SetParameter("@baseDefinition", sparkTeleport.DockingBase.Definition)
.SetParameter("@zoneId", sparkTeleport.DockingBase.Zone.Id)
.SetParameter("@x", sparkTeleport.DockingBase.CurrentPosition.intX)
.SetParameter("@y", sparkTeleport.DockingBase.CurrentPosition.intY)
.ExecuteNonQuery();
if (sparkTeleport.ID == 0)
{
throw new PerpetuumException(ErrorCodes.SQLInsertError);
}
}
public void DeleteAndInform(SparkTeleport sparkTeleport)
{
_sparkTeleportRepository.Delete(sparkTeleport);
Transaction.Current.OnCommited(() =>
{
var data = new Dictionary <string, object> {
{ k.description, sparkTeleport.ToDictionary() }
};
Message.Builder.SetCommand(Commands.SparkTeleportBaseDeleted)
.WithData(data)
.ToCharacter(sparkTeleport.Character)
.Send();
});
}
public void Update(SparkTeleport item)
{
throw new NotImplementedException();
}