Nested Query MVC LINQ

Question

I'm new to MVC and LINQ. Currently I faced difficulty on the project and decide to posted up.

My MVC-View that I wanted to achieve

Cut
----------------------------------
1   20%     
2   40%     
Color
----------------------------------
3   30%    
4   50%     
Perm
----------------------------------
5   10%

This is some example of my data table

ID  Offer   Service
-------------------
1   20%     Cut
2   40%     Cut
3   30%     Color
4   50%     Color
5   10%     Perm

My Controller:

var services = (from ps in db.PS
                select ps).Distinct().ToArray();
ViewBag.services = services;

My View:

@foreach (var item in ViewBag.services){
    <h3 class="page-header">
        @item
    </h3>

    //Table TAG INSERT Here: ID, Offer, Service
}

PROBLEM comes now, I have no idea on how to populate the data from DB into the view according to their own Service(eg: Cut, Color, Perm) in View

I'm thinking of doing this to store the data according to services in my Controller:

foreach (var i in services){
    var servicesdata = (from ps in db.PS
                        where ps.Service == i
                        select ps).ToArray();
}

I'm wondering can I push the services data that already according to the services into some kind of array so that I can populate into view?

score 3 · Accepted Answer · 2017-11-14 01:06:31Z

3

You can use a .GroupBy() clause to group your data by Service. Start by creating view models to represent what you want to display in the view

public class OfferVM
{
    public int ID { get; set; }
    [DisplayFormat(DataFormatString = "{0:P0}")]
    public float Offer { get; set; } // assumes you store this as float in the db
}
public class ServiceVM
{
    public string Name { get; set; }
    public IEnumerable<OfferVM> Offers { get; set; }
}

Then in the controller

IEnumerable<ServiceVM> model = db.PS.GroupBy(x => x.Service).Select(x => new ServiceVM()
{
    Name = x.Key,
    Offers = x.Select(y => new OfferVM()
    {
        ID = y.ID,
        Offer = y.Offer
    })
});
return View(model);

And in the view

@model IEnumerable<ServiceVM>
@foreach (var service in Model)
{
    <h2>@service.Name</h2>
    foreach (var item in service.Offers)
    {
        <span>@item.ID</span>
        <span>@Html.DisplayFor(m => item.Offer)</span>
    }
}

edited Nov 14, 2017 at 1:06

answered Apr 21, 2016 at 4:45

user3559349

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

2 Comments

Luiz Over a year ago

Classic group by question

J4X Over a year ago

Thank You so much @Stephen Muecke

Anurag Deokar · Accepted Answer · 2016-04-21 04:35:36Z

1

ViewBag is a dynamic property you can insert ViewBag anything but when you retrieve data from ViewBag, first need to convert it.

@foreach (var item in (List<PS>)ViewBag.services){
    <h3 class="page-header">
        @item
    </h3>

    //Table TAG INSERT Here: ID, Offer, Service
}

answered Apr 21, 2016 at 4:35

Anurag Deokar

8497 silver badges13 bronze badges

2 Comments

J4X Over a year ago

Yeah understand, but can you elaborate more on the (List<PS>)ViewBag.Services ?

Anurag Deokar Over a year ago

List<PS> PS is your business class first declare namespace on view to uses these class Ex @Using YourProjectName.WhereYourClassIs like that

Collectives™ on Stack Overflow

Nested Query MVC LINQ

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related