Загрузка данных


using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using AutoServiceApp.Data;
using AutoServiceApp.Models;

namespace AutoServiceApp.Controllers
{
    public class ServiceRequestsController : Controller
    {
        private readonly AutoServiceDbContext _context;

        public ServiceRequestsController(AutoServiceDbContext context)
        {
            _context = context;
        }

        // GET: ServiceRequests
        public async Task<IActionResult> Index()
        {
            var requests = await _context.ServiceRequests
                .Include(r => r.Vehicle)
                .ThenInclude(v => v.Client)
                .ToListAsync();
            return View(requests);
        }

        // GET: ServiceRequests/Details/5
        public async Task<IActionResult> Details(int? id)
        {
            if (id == null)
            {
                return NotFound();
            }

            var request = await _context.ServiceRequests
                .Include(r => r.Vehicle)
                .ThenInclude(v => v.Client)
                .FirstOrDefaultAsync(m => m.Id == id);

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

            return View(request);
        }

        // GET: ServiceRequests/Create
        public IActionResult Create()
        {
            ViewBag.VehicleId = new SelectList(_context.Vehicles.Include(v => v.Client), "Id", "LicensePlate");
            return View();
        }

        [HttpPost]
        [ValidateAntiForgeryToken]
        public async Task<IActionResult> Create([Bind("Id,RequestNumber,Description,AdditionalInfo,Status,EstimatedCost,ActualCost,DesiredDate,VehicleId")] ServiceRequest request)
        {
            if (ModelState.IsValid)
            {
                request.CreatedAt = DateTime.Now;
                request.GenerateRequestNumber();
                _context.Add(request);
                await _context.SaveChangesAsync();
                return RedirectToAction(nameof(Index));
            }
            ViewBag.VehicleId = new SelectList(_context.Vehicles.Include(v => v.Client), "Id", "LicensePlate", request.VehicleId);
            return View(request);
        }

        // GET: ServiceRequests/Edit/5
        public async Task<IActionResult> Edit(int? id)
        {
            if (id == null)
            {
                return NotFound();
            }

            var request = await _context.ServiceRequests.FindAsync(id);
            if (request == null)
            {
                return NotFound();
            }
            ViewBag.VehicleId = new SelectList(_context.Vehicles.Include(v => v.Client), "Id", "LicensePlate", request.VehicleId);
            return View(request);
        }

        [HttpPost]
        [ValidateAntiForgeryToken]
        public async Task<IActionResult> Edit(int id, [Bind("Id,RequestNumber,Description,AdditionalInfo,Status,EstimatedCost,ActualCost,CreatedAt,DesiredDate,VehicleId")] ServiceRequest request)
        {
            if (id != request.Id)
            {
                return NotFound();
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(request);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!ServiceRequestExists(request.Id))
                    {
                        return NotFound();
                    }
                    else
                    {
                        throw;
                    }
                }
                return RedirectToAction(nameof(Index));
            }
            ViewBag.VehicleId = new SelectList(_context.Vehicles.Include(v => v.Client), "Id", "LicensePlate", request.VehicleId);
            return View(request);
        }

        // GET: ServiceRequests/Delete/5
        public async Task<IActionResult> Delete(int? id)
        {
            if (id == null)
            {
                return NotFound();
            }

            var request = await _context.ServiceRequests
                .Include(r => r.Vehicle)
                .FirstOrDefaultAsync(m => m.Id == id);

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

            return View(request);
        }

        // POST: ServiceRequests/Delete/5
        [HttpPost, ActionName("Delete")]
        [ValidateAntiForgeryToken]
        public async Task<IActionResult> DeleteConfirmed(int id)
        {
            var request = await _context.ServiceRequests.FindAsync(id);
            if (request != null)
            {
                _context.ServiceRequests.Remove(request);
            }

            await _context.SaveChangesAsync();
            return RedirectToAction(nameof(Index));
        }

        private bool ServiceRequestExists(int id)
        {
            return _context.ServiceRequests.Any(e => e.Id == id);
        }
    }
}