Lesson 14 - E-shop in ASP.NET Core MVC - Product reviews

In the previous lesson, E-shop in ASP.NET Core MVC - Product detail, we created the product detail page. In today's ASP.NET Core tutorial, we're going to add an option to rate individual products by users. It'll be possible to add one review per product by authenticated users. This new functionality will cause changes across the whole application layers, as we'll see in a moment. As always, let's have a look at the introductory motivational image:

Data layer

Entity model modifications

Let's add a new Review entity for storing reviews to the data project, it'll have relations to a product and a user. In addition to a primary key and foreign keys to these tables, we'll also store an integer value of the product rating (in the range of 1 - 5), the review content (2048 characters at most) and the date and time when the review was added. We'll create the reviews again just by specifying the virtual relationships to the given entities:

public class Review
{
    [DatabaseGenerated(DatabaseGeneratedOption.Identity), Key()]
    public int ReviewId { get; set; }

    [StringLength(2048, MinimumLength = 2, ErrorMessage = "The minimal length is 2 characters, maximum length is 2048 characters")]
    public string Content { get; set; }
    public string UserId { get; set; }
    public int ProductId { get; set; }
    public int Rating { get; set; }
    public DateTime Sent { get; set; }

    public virtual Product Product { get; set; }
    public virtual ApplicationUser User { get; set; }
}

We'll make minor changes to the existing Product and User entities as well. We'll add a virtual

...End of the preview...
Continue further