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

            var query  = new InterventionQuery(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, String status)
        {
            await Db.Connection.OpenAsync();

            var query  = new InterventionQuery(Db);
            var result = await query.First(id);

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

                return(new NotFoundResult());
            }
            result.Status = status;
            await result.UpdateStatus();

            result = await query.First(id);

            await Db.Connection.CloseAsync();

            return(new OkObjectResult(result));
        }