Tutorial do provedor MongoDB para o EF Core: criação de um aplicativo com CRUD e controle de alterações

1
 "MongoDBSettings": {
2
   "AtlasURI": "mongodb+srv://<username>:<password>@<url>",
3
   "DatabaseName": "cargarage"
4
 }

1
using MongoDB.Bson;
2
using SuperCarBookingSystem.Models;
3
4
namespace SuperCarBookingSystem.Services
5
{
6
    public interface ICarService
7
    {
8
        IEnumerable<Car> GetAllCars();
9
        Car? GetCarById(ObjectId id);
10
11
        void AddCar(Car newCar);
12
13
        void EditCar(Car updatedCar);
14
15
        void DeleteCar(Car carToDelete);
16
    }
17
}

1
using Microsoft.EntityFrameworkCore;
2
using MongoDB.Bson;
3
using MongoDB.Driver;
4
using SuperCarBookingSystem.Models;
5
6
namespace SuperCarBookingSystem.Services
7
{
8
    public class CarService : ICarService
9
	{

1
 private readonly CarBookingDbContext _carDbContext;
2
 public CarService(CarBookingDbContext carDbContext)
3
 {
4
     _carDbContext = carDbContext;
5
 }

1
public IEnumerable<Car> GetAllCars()
2
{
3
       return _carDbContext.Cars.OrderBy(c => c.Id).AsNoTracking().AsEnumerable<Car>();
4
}

1
public Car? GetCarById(ObjectId id)
2
{
3
    return _carDbContext.Cars.FirstOrDefault(c  => c.Id == id);
4
}

1
public void AddCar(Car car)
2
{
3
    _carDbContext.Cars.Add(car);
4
5
    _carDbContext.ChangeTracker.DetectChanges();
6
    Console.WriteLine(_carDbContext.ChangeTracker.DebugView.LongView);
7
8
    _carDbContext.SaveChanges();
9
}

1
public void EditCar(Car car)
2
{
3
      var carToUpdate = _carDbContext.Cars.FirstOrDefault(c => c.Id == car.Id);
4
5
    if(carToUpdate != null)
6
    {                
7
        carToUpdate.Model = car.Model;
8
        carToUpdate.NumberPlate = car.NumberPlate;
9
        carToUpdate.Location = car.Location;
10
        carToUpdate.IsBooked = car.IsBooked;
11
12
        _carDbContext.Cars.Update(carToUpdate);
13
14
        _carDbContext.ChangeTracker.DetectChanges();
15
        Console.WriteLine(_carDbContext.ChangeTracker.DebugView.LongView);
16
17
        _carDbContext.SaveChanges();
18
            
19
    }
20
  else
21
    {
22
        throw new ArgumentException("The car to update cannot be found. ");
23
    }
24
}        

1
public void DeleteCar(Car car)
2
{
3
	var carToDelete = _carDbContext.Cars.Where(c => c.Id == car.Id).FirstOrDefault();
4
5
	if(carToDelete != null) {
6
       _carDbContext.Cars.Remove(carToDelete);
7
	   _carDbContext.ChangeTracker.DetectChanges();
8
       Console.WriteLine(_carDbContext.ChangeTracker.DebugView.LongView);
9
      _carDbContext.SaveChanges();
10
      }
11
    else {
12
        throw new ArgumentException("The car to delete cannot be found.");
13
    }
14
}

1
using MongoDB.Bson;
2
using SuperCarBookingSystem.Models;
3
namespace SuperCarBookingSystem.Services
4
{
5
    public interface IBookingService
6
    {
7
        IEnumerable<Booking> GetAllBookings();
8
        Booking? GetBookingById(ObjectId id);
9
10
        void AddBooking(Booking newBooking);
11
12
        void EditBooking(Booking updatedBooking);
13
14
        void DeleteBooking(Booking bookingToDelete);
15
    }
16
}

1
using Microsoft.EntityFrameworkCore;
2
using MongoDB.Bson;
3
using SuperCarBookingSystem.Models;
4
5
namespace SuperCarBookingSystem.Services
6
{
7
    public class BookingService : IBookingService
8
    {
9
        private readonly CarBookingDbContext _carDbContext;
10
11
        public BookingService(CarBookingDbContext carDBContext)
12
        {
13
            _carDbContext = carDBContext;
14
        }
15
        public void AddBooking(Booking newBooking)
16
        {
17
            var bookedCar = _carDbContext.Cars.FirstOrDefault(c => c.Id == newBooking.CarId);
18
            if (bookedCar == null)
19
            {
20
                throw new ArgumentException("The car to be booked cannot be found.");
21
            }
22
23
            newBooking.CarModel = bookedCar.Model;
24
25
            bookedCar.IsBooked = true;
26
            _carDbContext.Cars.Update(bookedCar);
27
28
            _carDbContext.Bookings.Add(newBooking);
29
30
            _carDbContext.ChangeTracker.DetectChanges();
31
            Console.WriteLine(_carDbContext.ChangeTracker.DebugView.LongView);
32
33
            _carDbContext.SaveChanges();
34
        }
35
36
        public void DeleteBooking(Booking booking)
37
        {
38
            var bookedCar = _carDbContext.Cars.FirstOrDefault(c => c.Id == booking.CarId);
39
            bookedCar.IsBooked = false;
40
41
            var bookingToDelete = _carDbContext.Bookings.FirstOrDefault(b => b.Id == booking.Id);
42
43
            if(bookingToDelete != null)
44
            {
45
                _carDbContext.Bookings.Remove(bookingToDelete);
46
                _carDbContext.Cars.Update(bookedCar);
47
48
                _carDbContext.ChangeTracker.DetectChanges();
49
                Console.WriteLine(_carDbContext.ChangeTracker.DebugView.LongView);
50
51
                _carDbContext.SaveChanges();
52
            }
53
            else
54
            {
55
                throw new ArgumentException("The booking to delete cannot be found.");
56
            }
57
        }
58
59
        public void EditBooking(Booking updatedBooking)
60
        {
61
           var bookingToUpdate = _carDbContext.Bookings.FirstOrDefault(b => b.Id == updatedBooking.Id);
62
           
63
            
64
            if (bookingToUpdate != null)
65
            {               
66
                bookingToUpdate.StartDate = updatedBooking.StartDate;
67
                bookingToUpdate.EndDate = updatedBooking.EndDate;
68
                
69
70
                _carDbContext.Bookings.Update(bookingToUpdate);
71
72
                _carDbContext.ChangeTracker.DetectChanges();
73
                _carDbContext.SaveChanges();
74
75
                Console.WriteLine(_carDbContext.ChangeTracker.DebugView.LongView);
76
            }  
77
            else 
78
            { 
79
                throw new ArgumentException("Booking to be updated cannot be found");
80
            }
81
            
82
        }
83
84
        public IEnumerable<Booking> GetAllBookings()
85
        {
86
            return _carDbContext.Bookings.OrderBy(b => b.StartDate).AsNoTracking().AsEnumerable<Booking>();
87
        }
88
89
        public Booking? GetBookingById(ObjectId id)
90
        {
91
            return _carDbContext.Bookings.AsNoTracking().FirstOrDefault(b => b.Id == id);
92
        }
93
        
94
    }
95
}

1
private readonly ICarService _carService;
2
3
4
public CarController(ICarService carService)
5
{
6
    _carService = carService;
7
}

1
public IActionResult Index()
2
{
3
    CarListViewModel viewModel = new()
4
    {
5
        Cars = _carService.GetAllCars(),
6
    };
7
    return View(viewModel);
8
}

1
public IActionResult Add()
2
{
3
    return View();
4
}

1
 [HttpPost]
2
 public IActionResult Add(CarAddViewModel carAddViewModel)
3
 {
4
     if(ModelState.IsValid)
5
     {
6
         Car newCar = new()
7
         {
8
             Model = carAddViewModel.Car.Model,
9
             Location = carAddViewModel.Car.Location,
10
             NumberPlate = carAddViewModel.Car.NumberPlate
11
         };
12
13
14
         _carService.AddCar(newCar);
15
         return RedirectToAction("Index");
16
     }
17
18
19
     return View(carAddViewModel);         
20
 }

1
 public IActionResult Edit(string id)
2
 {
3
     if(id == null)
4
     {
5
         return NotFound();
6
     }
7
8
9
     var selectedCar = _carService.GetCarById(new ObjectId(id));
10
     return View(selectedCar);
11
 }
12
13
14
 [HttpPost]
15
 public IActionResult Edit(Car car)
16
 {
17
     try
18
     {
19
         if(ModelState.IsValid)
20
         {
21
             _carService.EditCar(car);
22
             return RedirectToAction("Index");
23
         }
24
         else
25
         {
26
             return BadRequest();
27
         }
28
     }
29
     catch (Exception ex)
30
     {
31
         ModelState.AddModelError("", $"Updating the car failed, please try again! Error: {ex.Message}");
32
     }
33
34
35
     return View(car);
36
 }

1
public IActionResult Delete(string id) {
2
    if (id == null)
3
    {
4
        return NotFound();
5
    }
6
7
8
    var selectedCar = _carService.GetCarById(new ObjectId(id));
9
    return View(selectedCar);
10
}
11
12
13
[HttpPost]
14
public IActionResult Delete(Car car)
15
{
16
    if (car.Id == null)
17
    {
18
        ViewData["ErrorMessage"] = "Deleting the car failed, invalid ID!";
19
        return View();
20
    }
21
22
23
    try
24
    {
25
        _carService.DeleteCar(car);
26
        TempData["CarDeleted"] = "Car deleted successfully!";
27
28
29
        return RedirectToAction("Index");
30
    }
31
    catch (Exception ex)
32
    {
33
        ViewData["ErrorMessage"] = $"Deleting the car failed, please try again! Error: {ex.Message}";
34
    }
35
36
37
    var selectedCar = _carService.GetCarById(car.Id);
38
    return View(selectedCar);
39
}        

1
@if (TempData["CarDeleted"] != null)
2
{
3
    <p class="text-success">@TempData["CarDeleted"]</p>
4
}

1
@if (!Model.Cars.Any())
2
{
3
    <p>No results</p>
4
}

1
else
2
{
3
    <table class="table table-condensed table-bordered">
4
        <tr>
5
            <th>
6
                Model
7
            </th>
8
            <th>
9
                Number Plate
10
            </th>
11
            <th>
12
                Location
13
            </th>            
14
            <th>
15
                Actions
16
            </th>
17
        </tr>
18
19
        @foreach (var car in Model.Cars)
20
        {
21
            <tr>
22
                <td>@car.Model</td>
23
                <td>@car.NumberPlate</td>
24
                <td>@car.Location</td>                
25
                <td>
26
                    <a asp-action="Edit" asp-route-id="@car.Id.ToString()">Edit</a>
27
                    <a asp-action="Delete" asp-route-id="@car.Id.ToString()">Delete</a>
28
                    @if(!car.IsBooked)
29
                    {
30
                        <a asp-controller="Booking" asp-action="Add" asp-route-carId="@car.Id.ToString()">Book</a>
31
                    }                    
32
                </td>
33
            </tr>
34
        }
35
36
    </table>
37
}
38
39
<p>
40
    <a class="btn btn-primary" asp-action="Add">Add new car</a>
41
</p>

1
pattern: "{controller=Car}/{action=Index}/{id?}");

1
@model CarAddViewModel
2
3
4
<h2>Create a new car</h2>
5
<hr />
6
7
8
@if (ViewData["ErrorMessage"] != null)
9
{
10
    <p class="text-danger">@ViewData["ErrorMessage"]</p>
11
}

1
<form method="post" asp-controller="Car" asp-action="Add">
2
    <div asp-validation-summary="All" class="text-danger"></div>
3
4
5
    <div class="mb-3">
6
        <label asp-for="Car.Model" class="form-label"></label>
7
        <input asp-for="Car.Model" class="form-control" />
8
        <span asp-validation-for="Car.Model" class="text-danger"></span>
9
    </div>
10
11
12
    <div class="mb-3">
13
        <label asp-for="Car.NumberPlate" class="form-label"></label>
14
        <input asp-for="Car.NumberPlate" class="form-control" />
15
        <span asp-validation-for="Car.NumberPlate" class="text-danger"></span>
16
    </div>
17
18
19
      <div class="mb-3">
20
        <label asp-for="Car.Location" class="form-label"></label>
21
        <input asp-for="Car.Location" class="form-control" />
22
        <span asp-validation-for="Car.Location" class="text-danger"></span>
23
    </div>
24
25
26
    <input type="submit" value="Add car" class="btn btn-primary" />
27
</form>

1
@model Car
2
3
<h2>Update @Model.Model</h2>
4
<hr />
5
6
<form method="post" asp-controller="Car" asp-action="Edit">
7
    <div asp-validation-summary="ModelOnly" class="text-danger"></div>
8
    <input type="hidden" asp-for="Id" />
9
10
    <div class="mb-3">
11
        <label asp-for="Model" class="form-label"></label>
12
        <input asp-for="Model" class="form-control" />
13
        <span asp-validation-for="Model" class="text-danger"/>
14
    </div>
15
    <div class="mb-3">
16
        <label asp-for="NumberPlate" class="form-label"></label>
17
        <input asp-for="NumberPlate" class="form-control" />
18
        <span asp-validation-for="NumberPlate" class="text-danger"/>
19
    </div>
20
    <div class="mb-3">
21
        <label asp-for="Location" class="form-label"></label>
22
        <input asp-for="Location" class="form-control" />
23
        <span asp-validation-for="Location" class="text-danger"/>
24
    </div>
25
    <input type="submit" value="Update car" class="btn btn-primary" />
26
</form>
27
<div>
28
    <a asp-controller="Car" asp-action="Index">Back to list</a>
29
</div>

1
@model Car
2
3
4
<h2>Deleting @Model.Model</h2>
5
<hr />
6
7
8
@if(ViewData["ErrorMessage"] != null)
9
{
10
    <p class="text-danger">@ViewData["ErrorMessage"]</p>
11
}

1
<div>
2
    <dl class="row">
3
        <dt class="col-sm-2">
4
            <label asp-for="Model"></label>
5
        </dt>
6
        <dd class="col-sm-10">
7
            @Model?.Model
8
        </dd>
9
        <dt class="col-sm-2">
10
            <label asp-for="NumberPlate"></label>
11
        </dt>
12
        <dd class="col-sm-10">
13
            @Model?.NumberPlate
14
        </dd>
15
        <dt class="col-sm-2">
16
            <label asp-for="Location"></label>
17
        </dt>
18
        <dd class="col-sm-10">
19
            @Model?.Location
20
        </dd>
21
22
23
    </dl>
24
</div>

1
<form method="post" asp-action="Delete">
2
    <input type="hidden" asp-for="Id" />
3
    <input type="submit" value="Delete car" class="btn btn-danger" onclick="javascript: return confirm('Are you sure you want to delete this car?');" />
4
</form>
5
6
7
<div>
8
    <a asp-controller="Car" asp-action="Index">Back to list</a>
9
</div>

1
@model BookingListViewModel
2
3
4
@if (TempData["BookingDeleted"] != null)
5
{
6
    <p class="text-success">@TempData["BookingDeleted"]</p>
7
}
8
9
10
@if (!Model.Bookings.Any())
11
{
12
    <p>No results</p>
13
}
14
15
16
else
17
{    
18
    <table class="table table-condensed table-bordered">
19
        <tr>
20
            <th>
21
                Booked Car
22
            </th>
23
            <th>
24
                Start Date
25
            </th>
26
            <th>
27
                End Date
28
            </th>
29
            <th>
30
                Actions
31
            </th>
32
        </tr>
33
34
35
        @foreach(var booking in Model.Bookings)
36
        {
37
            <tr>
38
                <td>@booking.CarModel</td>
39
                <td>@booking.StartDate</td>
40
                <td>@booking.EndDate</td>
41
                <td>
42
                    <a asp-action="Edit" asp-route-id="@booking.Id.ToString()">Edit</a>
43
                    <a asp-action="Delete" asp-route-id="@booking.Id.ToString()">Delete</a>
44
                </td>
45
            </tr>
46
        }
47
48
49
    </table>   
50
51
52
}

1
@model BookingAddViewModel
2
3
4
@if (ViewData["ErrorMessage"] != null)
5
{
6
    <p class="text-danger">@ViewData["ErrorMessage"]</p>
7
}
8
9
<form method="post" asp-controller="Booking" asp-action="Add">
10
    <div asp-validation-summary="All" class="text-danger"></div>
11
    <input type="hidden" asp-for="Booking.Id" />
12
    <input type="hidden" asp-for="Booking.CarId" />
13
14
    <div class="mb-3">
15
        <label asp-for="Booking.StartDate" class="form-label"></label>
16
        <input asp-for="Booking.StartDate" type="date" class="form-control" />
17
        <span asp-validation-for="Booking.StartDate" class="text-danger"></span>
18
    </div>
19
    <div class="mb-3">
20
        <label asp-for="Booking.EndDate" class="form-label"></label>
21
        <input asp-for="Booking.EndDate" type="date" class="form-control" />
22
        <span asp-validation-for="Booking.EndDate" class="text-danger"></span>
23
    </div>
24
25
    <input type="submit" value="Book car" class="btn btn-primary" />
26
</form>

1
@model Booking
2
3
4
<h2>Editing booking for @Model.CarModel between @Model.StartDate and @Model.EndDate</h2>
5
<hr />
6
7
8
<form method="post" asp-controller="Booking" asp-action="Edit">
9
    <div asp-validation-summary="ModelOnly" class="text-danger"></div>
10
    <input type="hidden" asp-for="Id" />
11
12
13
    <div class="mb-3">
14
        <label asp-for="StartDate" class="form-label"></label>
15
        <input asp-for="StartDate" class="form-control" />
16
        <span asp-validation-for="StartDate" class="text-danger" />
17
    </div>
18
    <div class="mb-3">
19
        <label asp-for="EndDate" class="form-label"></label>
20
        <input asp-for="EndDate" class="form-control" />
21
        <span asp-validation-for="EndDate" class="text-danger" />
22
    </div>  
23
    <input type="submit" value="Update booking" class="btn btn-primary" />
24
</form>
25
<div>
26
    <a asp-controller="Booking" asp-action="Index">Back to bookings</a>
27
</div>