RDBMS/RDBMS_lab4/Controllers/BuyersController.cs

using Microsoft.AspNetCore.Mvc;
using RDBMS_lab4.ViewModels;

namespace RDBMS_lab4.Controllers
{
    [Route("api/[controller]")]
    public class BuyersController : Controller
    {
        public BuyersController()
        {
        }

        [HttpGet("get")]
        public IActionResult get()
        {
            try
            {
                using var context = new beautySalonContext();
                var res = context.Buyers.Select(b => new BuyerViue(b)).ToList();
                return Ok(res);
            }
            catch (Exception ex)
            {
                return BadRequest(ex.Message);
            }
        }
        [HttpGet("get/{Id}")]
        public IActionResult get([FromRoute] int Id)
        {
            try
            {
                using var context = new beautySalonContext();
                var res = context.Buyers.FirstOrDefault(b => b.Id == Id);
                if (res == null)
                {
                    return Ok(null);
                }
                return Ok(new BuyerViue(res));
            }
            catch (Exception ex)
            {
                return BadRequest(ex.Message);
            }
        }
        [HttpPost("create")]
        public IActionResult create([FromBody] BuyerViue buyer)
        {
            try
            {
                using var context = new beautySalonContext();
                var res = context.Buyers.Add(new() { 
                    Name = buyer.Name,
                    Telephon = buyer.Telephon
                });
                context.SaveChanges();
                if (res == null)
                {
                    return BadRequest(new NullReferenceException());
                }
                return Ok(new BuyerViue(res.Entity));
            }
            catch (Exception ex)
            {
                return BadRequest(ex.Message);
            }
        }
        [HttpPut("update")]
        public IActionResult update([FromBody] BuyerViue buyer)
        {
            try
            {
                using var context = new beautySalonContext();
                var res = context.Buyers.FirstOrDefault(b => b.Id == buyer.Id);
                res.Telephon = buyer.Telephon;
                res.Name = buyer.Name;
                context.SaveChanges();   
                return Ok(new BuyerViue(res));
            }
            catch (Exception ex)
            {
                return BadRequest(ex.Message);
            }
        }
        [HttpDelete("delete/{Id}")]
        public IActionResult delete([FromRoute] int Id)
        {
            try
            {
                using var context = new beautySalonContext();
                var res = context.Buyers.FirstOrDefault(b => b.Id == Id);
                if (res != null)
                {
                    context.Buyers.Remove(res);
                    context.SaveChanges();
                }
                if (res == null)
                {
                    return BadRequest( new NullReferenceException());
                }
                return Ok(new BuyerViue(res));
            }
            catch (Exception ex)
            {
                return BadRequest(ex.Message);
            }
        }
    }
}