end-point-blog-dotnet-5-web-api/QuoteOverridesController.cs at master · megakevi...

end-point-blog-dotnet-5-web-api/QuoteOverridesController.cs at master · megakevin/end-point-blog-dotnet-5-web-api · GitHubPermalink

using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.Mvc; using Microsoft.EntityFrameworkCore; using VehicleQuotes; using VehicleQuotes.Models; using VehicleQuotes.ResourceModels;

namespace VehicleQuotes.Controllers { [Route("api/[controller]")] [ApiController] public class QuoteOverridesController : ControllerBase { private readonly VehicleQuotesContext _context;

public QuoteOverridesController(VehicleQuotesContext context) { _context = context; }

// GET: api/QuoteOverrides [HttpGet] public async Task<ActionResult<IEnumerable<QuoteOverrideSpecification>>> GetQuoteOverides() { var quotesOverridesToReturn = _context.QuoteOverides.Select(qo => new QuoteOverrideSpecification { ID = qo.ID, Year = qo.ModelStyleYear.Year, Make = qo.ModelStyleYear.ModelStyle.Model.Make.Name, Model = qo.ModelStyleYear.ModelStyle.Model.Name, BodyType = qo.ModelStyleYear.ModelStyle.BodyType.Name, Size = qo.ModelStyleYear.ModelStyle.Size.Name, Price = qo.Price });

return await quotesOverridesToReturn.ToListAsync(); }

// GET: api/QuoteOverrides/5 [HttpGet("{id}")] public async Task<ActionResult<QuoteOverrideSpecification>> GetQuoteOverride(int id) { var quoteOverride = await _context.QuoteOverides .Include(qo => qo.ModelStyleYear.ModelStyle.Model.Make) .Include(qo => qo.ModelStyleYear.ModelStyle.BodyType) .Include(qo => qo.ModelStyleYear.ModelStyle.Size) .FirstOrDefaultAsync(qo => qo.ID == id);

if (quoteOverride == null) { return NotFound(); }

return new QuoteOverrideSpecification { ID = quoteOverride.ID, Year = quoteOverride.ModelStyleYear.Year, Make = quoteOverride.ModelStyleYear.ModelStyle.Model.Make.Name, Model = quoteOverride.ModelStyleYear.ModelStyle.Model.Name, BodyType = quoteOverride.ModelStyleYear.ModelStyle.BodyType.Name, Size = quoteOverride.ModelStyleYear.ModelStyle.Size.Name, Price = quoteOverride.Price }; }

// PUT: api/QuoteOverrides/5 [HttpPut("{id}")] public async Task<IActionResult> PutQuoteOverride(int id, QuoteOverrideSpecification quoteOverride) { if (id != quoteOverride.ID) { return BadRequest(); }

var quoteOverrideToUpdate = await _context.QuoteOverides .FirstOrDefaultAsync(qo => qo.ID == id);

if (quoteOverrideToUpdate == null) { return NotFound(); }

var modelStyleYearToOverride = _context.ModelStyleYears.FirstOrDefault( msy => msy.Year == quoteOverride.Year && msy.ModelStyle.Model.Make.Name == quoteOverride.Make && msy.ModelStyle.Model.Name == quoteOverride.Model && msy.ModelStyle.BodyType.Name == quoteOverride.BodyType && msy.ModelStyle.Size.Name == quoteOverride.Size );

if (modelStyleYearToOverride == null) { return UnprocessableEntity("The specified vehicle model to override is not registered."); }

quoteOverrideToUpdate.Price = quoteOverride.Price; quoteOverrideToUpdate.ModelStyleYear = modelStyleYearToOverride;

try { await _context.SaveChangesAsync(); } catch (Microsoft.EntityFrameworkCore.DbUpdateException) { return Conflict(); }

return NoContent(); }

// POST: api/QuoteOverrides [HttpPost] public async Task<ActionResult<QuoteOverrideSpecification>> PostQuoteOverride(QuoteOverrideSpecification quoteOverride) { var modelStyleYearToOverride = _context.ModelStyleYears.FirstOrDefault( msy => msy.Year == quoteOverride.Year && msy.ModelStyle.Model.Make.Name == quoteOverride.Make && msy.ModelStyle.Model.Name == quoteOverride.Model && msy.ModelStyle.BodyType.Name == quoteOverride.BodyType && msy.ModelStyle.Size.Name == quoteOverride.Size );

if (modelStyleYearToOverride == null) { return UnprocessableEntity("The specified vehicle model to override is not registered."); }

var quoteOverrideToCreate = new QuoteOverride { Price = quoteOverride.Price, ModelStyleYear = modelStyleYearToOverride };

_context.QuoteOverides.Add(quoteOverrideToCreate);

try { await _context.SaveChangesAsync(); } catch (Microsoft.EntityFrameworkCore.DbUpdateException) { return Conflict(); }

quoteOverride.ID = quoteOverrideToCreate.ID;

return CreatedAtAction( "GetQuoteOverride", new { id = quoteOverride.ID }, quoteOverride ); }

// DELETE: api/QuoteOverrides/5 [HttpDelete("{id}")] public async Task<IActionResult> DeleteQuoteOverride(int id) { var quoteOverride = await _context.QuoteOverides.FindAsync(id); if (quoteOverride == null) { return NotFound(); }

_context.QuoteOverides.Remove(quoteOverride); await _context.SaveChangesAsync();

return NoContent(); } } }