ASP.Net Displaying Table using For each

Question

I apologies in advance for my formatting!

I'm following a tutorial (Here) and I'm trying to create a details Page for Category but instead of displaying Course Title and Grade, I want to display the Product's id,Brand,Name,Barcode and Price of every product that has the same CategoryId.

However, I get this error:

"Inventory.Models.Category does not contain a definiton for 'Category' and no extension method 'Category' accepting a first argument of type 'Invetory.Models.Category' could be found"

Class Model

public class Category {
    public int Id{get;set;}
    public string Name {get;set;}
    }
public class Product{
    public int Id{get;set;}
    public int CategoryId{get;set;}
    public String Brand {get;set;}
    public String Name {get;set;}
    public decimal Price{get;set;
}

Category/Details.cshtml:

@model Inventory.Models.Category

@{
    ViewBag.Title = "Details";
}

<h2>Details</h2>

<div>
    <h4>Category</h4>
    <hr />
    <dl class="dl-horizontal">
        <dt>
            @Html.DisplayNameFor(model => model.Name) <--ERROR HERE
        </dt>

        <dd>
            @Html.DisplayFor(model => model.Name) <--ERROR
        </dd>
        <!--Test start-->
        <dt>
            @Html.DisplayNameFor(model => model.Category)
        </dt>
        <dd>
            <table class="table">
                <tr>
                    <th>Category</th>
                    <th>ID</th>
                </tr>
                @foreach (var item in Model.Category)
                {
                    <tr>
                        <td>
                            @Html.DisplayFor(modelItem => item.Product.Name)
                        </td>
                        <td>
                            @Html.DisplayFor(modelItem => item.ID)
                        </td>
                    </tr>
                }
            </table>
        </dd>
        <!--test end-->
    </dl>
</div>
<p>
    @Html.ActionLink("Edit", "Edit", new { id = Model.ID }) |
    @Html.ActionLink("Back to List", "Index")
</p>

Product.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;


namespace Inventory.Models
{
    public class Product
    {
        public int Id { get; set; }
        public int CategoryId { get; set; }
        public string Brand { get; set; }
        public string Name { get; set; }
        public string Barcode { get; set;}
        public decimal Price { get; set; }

        public virtual ICollection<Category> Categories { get; set; }
    }
}

Category.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace Inventory.Models
{
    public class Category
    {
        public int ID { get; set; }
        public string Name { get; set; }

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

Mō Iđɍɨɇƶ · Accepted Answer · 2015-11-09 11:49:20Z

1

Okay so you have quite a bit of problems but let's do this

1) your model is most likely Product not Category so change in your view @model Inventory.Models.Category to @model Inventory.Models.Product

2) There is no Category in the Product Model so add that

public class Product
{
    public int Id { get; set; }
    public int CategoryId { get; set; }
    public string Brand { get; set; }
    public string Name { get; set; }
    public string Barcode { get; set;}
    public decimal Price { get; set; }

    public Category Category { get; set; } // <--- Add this

    public virtual ICollection<Category> Categories { get; set; }
}

3) The IEnumerable (i.e. the list you loop through) is called Categories not Category so change @foreach (var item in Model.Category) to @foreach (var item in Model.Categories)

edited Nov 9, 2015 at 11:49

answered Nov 9, 2015 at 11:41

Mō Iđɍɨɇƶ

3311 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

TykiMikk Over a year ago

I actually have both Category/Details.cshtml and Product/Details.cshtml. I want lots of Products assigned to some categories. Eg Coca Cola has category Id 1 and category id 1 relates to ID in Category which is Drinks. I actually want Products to be displayed in my Category html file. So when I press Details in the Category.html it'll display a list of all the products assigned to that categoryID.

Mō Iđɍɨɇƶ Over a year ago

@JasonWan so the relationship between Category to Product is one to many or many to many?

TykiMikk Over a year ago

Many to many! So For example We have in Product Coke with Category Id 1 which relates to Drinks in Category with is Id also 1

Mō Iđɍɨɇƶ Over a year ago

Okay so what I think you should do is: 1) Firstly make your models in a way that they support what you want i.e. both Category and Product model should have an IEnumerable collection of what they are referencing and this needs to be populated correctly. 2) Check every page that you are calling things that exists in that model i.e. if you write model.X than the model should have property with a public get

TykiMikk Over a year ago

If you look back up ! After applying what you told me to do gives me that error.

|

Collectives™ on Stack Overflow

ASP.Net Displaying Table using For each

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related