public List <PickUpRequest> GetPickUpRequests(PickUpStatus status)
{
const string query = "SELECT * FROM PickupRequests WHERE Status = @PickUpStatus;";
var requests = _dbConnection.Connection.Query <PickUpRequest>(query, new { PickUpStatus = status });
return(requests.ToList());
}
public int UpdatePickUpStatus(PickUpStatus status, int pickUpId)
{
const string sql = "UPDATE PickupRequests SET Status = @PickUpStatus WHERE Id = @PickUpId;";
return(_dbConnection.Connection.Execute(sql, new { PickUpStatus = status, PickUpId = pickUpId }));
}
// Update the pickup
public override void Update( TimeSpan elapsedTime )
{
if ( Active && currentStatus == PickUpStatus.RESPAWNING )
{
if ( respawnTimer <= 0 )
{
respawnTimer = 0;
Details[PickupID].spawnBehaviour( elapsedTime, this );
currentStatus = PickUpStatus.SPAWNED;
}
else
{
respawnTimer -= elapsedTime.TotalSeconds;
}
}
//base.Update(gameTime);
}
public override void UpdateFromPacket( NetIncomingMessage packet )
{
PickupID = packet.ReadInt32();
worldPosition.X = packet.ReadFloat();
worldPosition.Y = packet.ReadFloat();
currentStatus = (PickUpStatus)packet.ReadByte();
}
// Initialize the pickup
public void Initialize( int ID )
{
this.PickupID = ID;
respawnTime = Details[ID].respawnTime;
respawnTimer = 0;
onHit = Details[ID].hitBehaviour;
currentStatus = PickUpStatus.RESPAWNING;
// Set the pickup to be active
Active = true;
}
