❔ Post Request no working

DayanK · 2023-08-20T07:33:01.659Z

please I tried to make a post request but I receive some error. How I can fix it ? I'm using .net core 6 version. Thanks in advance public class Product { public int Id { get; set; } public string Name { get; set; } public decimal Price { get; set; } } }

J

jiniux•8/20/23, 7:45 AM

read the error

P

Pobiega•8/20/23, 7:58 AM

You'll need to post the code for the function that is throwing the error, if you actually want help

P

Pobiega•8/20/23, 7:58 AM

but yeah, its "Microsoft.Data.SqlClient" that is throwing the error, that tells me a lot

PPobiega You'll need to post the code for the function that is throwing the error, if you...

D

DayanKOP•8/20/23, 8:08 AM

cs using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Azure.WebJobs;
using Microsoft.Azure.WebJobs.Extensions.Http;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Logging;
using Newtonsoft.Json;
using System.IO;
using System.Linq;
using System.Threading.Tasks;

namespace ServerLessRestApi
{
    public class ProductsGetAllCreate
    {
        private readonly AppDbContext _context;

        public ProductsGetAllCreate (AppDbContext context)
        {
            _context = context;
        }

        [FunctionName("ProductsGetAllCreate")]
        public async Task<IActionResult> Run(
            [HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = "products")] HttpRequest req)
        {
           if(req.Method == HttpMethods.Post)
            {
                string requestBody = await new StreamReader(req.Body).ReadToEndAsync();
                var product = JsonConvert.DeserializeObject<Product>(requestBody);
                
                _context.Products.Add(product);
                await _context.SaveChangesAsync();
                return new CreatedResult("/products", product);
            }

           var products = await _context.Products.ToListAsync();
            return new OkObjectResult(products);
        }  
    }
}

cs using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Azure.WebJobs;
using Microsoft.Azure.WebJobs.Extensions.Http;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Logging;
using Newtonsoft.Json;
using System.IO;
using System.Linq;
using System.Threading.Tasks;

namespace ServerLessRestApi
{
    public class ProductsGetAllCreate
    {
        private readonly AppDbContext _context;

        public ProductsGetAllCreate (AppDbContext context)
        {
            _context = context;
        }

        [FunctionName("ProductsGetAllCreate")]
        public async Task<IActionResult> Run(
            [HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = "products")] HttpRequest req)
        {
           if(req.Method == HttpMethods.Post)
            {
                string requestBody = await new StreamReader(req.Body).ReadToEndAsync();
                var product = JsonConvert.DeserializeObject<Product>(requestBody);
                
                _context.Products.Add(product);
                await _context.SaveChangesAsync();
                return new CreatedResult("/products", product);
            }

           var products = await _context.Products.ToListAsync();
            return new OkObjectResult(products);
        }  
    }
}

cs using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Azure.WebJobs;
using Microsoft.Azure.WebJobs.Extensions.Http;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Logging;
using Newtonsoft.Json;
using System.IO;
using System.Linq;
using System.Threading.Tasks;

namespace ServerLessRestApi
{
    public class ProductsGetAllCreate
    {
        private readonly AppDbContext _context;

        public ProductsGetAllCreate (AppDbContext context)
        {
            _context = context;
        }

        [FunctionName("ProductsGetAllCreate")]
        public async Task<IActionResult> Run(
            [HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = "products")] HttpRequest req)
        {
           if(req.Method == HttpMethods.Post)
            {
                string requestBody = await new StreamReader(req.Body).ReadToEndAsync();
                var product = JsonConvert.DeserializeObject<Product>(requestBody);
                
                _context.Products.Add(product);
                await _context.SaveChangesAsync();
                return new CreatedResult("/products", product);
            }

           var products = await _context.Products.ToListAsync();
            return new OkObjectResult(products);
        }  
    }
}

cs using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Azure.WebJobs;
using Microsoft.Azure.WebJobs.Extensions.Http;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Logging;
using Newtonsoft.Json;
using System.IO;
using System.Linq;
using System.Threading.Tasks;

namespace ServerLessRestApi
{
    public class ProductsGetAllCreate
    {
        private readonly AppDbContext _context;

        public ProductsGetAllCreate (AppDbContext context)
        {
            _context = context;
        }

        [FunctionName("ProductsGetAllCreate")]
        public async Task<IActionResult> Run(
            [HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = "products")] HttpRequest req)
        {
           if(req.Method == HttpMethods.Post)
            {
                string requestBody = await new StreamReader(req.Body).ReadToEndAsync();
                var product = JsonConvert.DeserializeObject<Product>(requestBody);
                
                _context.Products.Add(product);
                await _context.SaveChangesAsync();
                return new CreatedResult("/products", product);
            }

           var products = await _context.Products.ToListAsync();
            return new OkObjectResult(products);
        }  
    }
}

P

Pobiega•8/20/23, 8:08 AM

$code

PPobiega $code

M

MODiX•8/20/23, 8:08 AM

To post C# code type the following:
```cs
// code here
```

Get an example by typing

$codegif

$codegif

in chat

If your code is too long, post it to: https://paste.mod.gg/

P

Pobiega•8/20/23, 8:09 AM

also, the problem seems to lie in the setup of your context or the context itself

A

Accord•8/23/23, 6:25 AM

Was this issue resolved? If so, run

/close

/close

otherwise I will mark this as stale and this post will be archived until there is new activity.

❔ Post Request no working

Similar Threads

Similar Threads

Similar Threads