public async Task <IActionResult> PutOne(int id, [FromBody] Batteries body)
        {
            await Db.Connection.OpenAsync();

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

            //check the request sent if it valid
            if (body is null)
            {
                return(new NotFoundObjectResult("Please enter something in the status"));
            }
            if (body.Status.ToLower() != "intervention" && body.Status.ToLower() != "active" && body.Status.ToLower() != "inactive")
            {
                return(new NotFoundObjectResult("The status you entered is invalide!"));
            }
            if (result is null)
            {
                return(new NotFoundResult());
            }
            result.Status = body.Status;
            await result.UpdateAsync();

            return(new OkObjectResult(result));
        }
        public async Task <IActionResult> GetLatest()
        {
            await Db.Connection.OpenAsync();

            var query  = new BatteriesQuery(Db);
            var result = await query.LatestPostsAsync();

            return(new OkObjectResult(result));
        }
        public async Task <IActionResult> GetOne(int id)
        {
            await Db.Connection.OpenAsync();

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

            if (result is null)
            {
                return(new NotFoundResult());
            }
            return(new OkObjectResult(result));
        }