public async Task <IActionResult> Getlist()
        {
            await Db.Connection.OpenAsync();

            var query  = new ElevatorQuery(Db);
            var result = await query.Async();

            await Db.Connection.CloseAsync();

            if (result is null)
            {
                return(new NotFoundResult());
            }
            return(new OkObjectResult(result));
        }
        public async Task <IActionResult> SetOne(int id, [FromBody] Elevator body)
        {
            await Db.Connection.OpenAsync();

            var query  = new ElevatorQuery(Db);
            var result = await query.FindOneAsync(id);

            if (result is null)
            {
                await Db.Connection.CloseAsync();

                return(new NotFoundResult());
            }
            result.Status = body.Status;
            await result.UpdateAsync();

            await Db.Connection.CloseAsync();

            return(new OkObjectResult(result));
        }