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