category filters on the basis of search text.

Rishabh Singh

9y851LINQ

My Controller is :-

ViewBag.categoryfilter = _context.MasterProductCategory.Include(u => u.MasterProduct).ThenInclude(u => u.Brand)

.Where(u => u.MasterProduct.ProductName.Contains(search)).ToList();

Where as MasterProduct is related with MasterProductCategory table on :-

public virtual ICollection MasterProduct { get; set; }

Hence Under the Product Name Word it is showing Error. And In My view Page:-

@if (ViewBag.categoryfilter != null)

{

@foreach (var items in ViewBag.categoryfilter)

{

@items.CategoryName

@foreach (var item in ViewBag.categoryfilter)

{

@item.BrandName

}

incval++;

}

These Are my codes to bind the category and respected brand on the basis of prodeuctname.

I am using VS2017 with asp.net-core Please Guide me with suitable solution to bind it properly.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhilash J A9y ago
I have updated my answer. Please look up it !!!
0
Rishabh Singh9y ago
@ Mani Kandan

I appreciate your effort but you forgot to join the third table Brand Which has to return the name of brands having relation with MasterProduct But No Relation with MasterProductCategory.
0
Abhilash J A9y ago
Avoid viewbag, create a model class list then add items.

Okay! Let's create a list brandnames inside the model class like:-
public class MasterProduct
{
List<string> brandnames = new List<string>();
}
List masterProduct = new List();

var filteredData = from pCat in _context.MasterProductCategory join product in _context.MasterProduct on pCat.idproductcategory equls product.idproduct  where product.ProductName.Contains(search) orderby product.idproduct select product;

masterProduct  = filteredData.ToList();

masterProduct.brandnames = new List();

masterProduct.brandnames = (from brand in Brand join product in Product on brand.idproduct equls product.idproduct).ToList();

return masterProduct;
View,
@MasterProduct
@if (Model.count>0)
{
    @foreach (var item in Model)
    {
        <li class="col-sm-3">
            <a href="#" data-target="#@incval" data-toggle="collapse" data-parent="#stacked-menu">@item.CategoryNamea>
            <ul class="nav nav-stacked collapse left-submenu col-sm-3" id="@incval">
                @foreach (var item2 in Model.brandnames)
                {
                    <li class="pad-left-15"><a href="#">@item2.BrandNamea>li>
                }
            ul>
        li>
        incval++;
    }
}
Cheers !!!
0
Rajkiran Swain9y ago
https://stackoverflow.com/questions/5065729/using-linq-how-can-i-filter-a-collection-on-partial-string-property

https://stackoverflow.com/questions/5274884/linq-keyword-searching-with-contains
0