We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

Question about item count in a result[Answered] RSS

14 replies

Last post Feb 26, 2021 05:38 PM by MiguelMi

‹ Previous Thread|Next Thread ›

Shortcuts

Related Links

- Reply
MiguelMi
Member

22 Points

66 Posts

Question about item count in a result

Feb 17, 2021 04:59 PM|MiguelMi|LINK

The answers I found are very scattered, so I'll ask.
Is it possible to count the number of items within the return view (result) or even in a variable?

Thanks,
- Reply
mgebhard
All-Star

53711 Points

24042 Posts
Re: Question about item count in a result

Feb 17, 2021 07:30 PM|mgebhard|LINK
MiguelMi
The answers I found are very scattered, so I'll ask.
Is it possible to count the number of items within the return view (result) or even in a variable?

You did not share the code that defines or populates "results". If "results" is a collection then you can get the count of items at any time using the standard .Count() method.
```
int myCount = result.Count();
```
If you need the count within the View then "results" becomes the strongly typed view model. The Razor syntax is shown below.
```
<div> My Count = @Model.Count()</div>
```
- Reply
MiguelMi
Member

22 Points

66 Posts

Re: Question about item count in a result

Feb 17, 2021 09:43 PM|MiguelMi|LINK

thanks, i will try to apply the example.
my result comes from a join.

https://forums.asp.net/t/2174364.aspx?Select+values+from+another+class
- Reply
MiguelMi
Member

22 Points

66 Posts

Re: Question about item count in a result

Feb 18, 2021 05:26 PM|MiguelMi|LINK

Yes, I managed to adapt the example to the project and it worked.

Take the same topic to ask another question with the same theme:

How can I count the values that are being listed in the @item.Values?

Example:

I am listing the values through a foreach

Total: 412

thanks again
- Reply
mgebhard
All-Star

53711 Points

24042 Posts

Re: Question about item count in a result

Feb 18, 2021 07:44 PM|mgebhard|LINK

Again, you have not shared any relevant code. The example is a SUM not a COUNT which can be easily coded using LINQ if we had the actual code...

MiguelMi

Member

22 Points

66 Posts

Re: Question about item count in a result

Feb 18, 2021 09:05 PM|MiguelMi|LINK

yes, you're right i'm sorry and my example is complex

my model from table Quantities

 public partial class Quantities
    {
        public int ID_Order { get; set; }
        public int ID_Line { get; set; }
        public Nullable<int> Value{ get; set; }

    }

Controller

 public ActionResult Index()
        {
            var orders = db.Orders.ToList();
            var colors = db.Colors.ToList();
            var quantities = db.Quantities.ToList();
            //Query syntax
            var result1 = (from o in orders
                          join c in colors
                             on o.ID_Orders equals c.ID_Orders into co
                          group new { o, co } by o.ID_Orders into g
                          from i in g
                          select new {order=i.o,colors=i.co}).ToList();
            var result2 = (from r1 in result1
                          from c in r1.colors
                           join q in quantities                              on new { orderId = c.ID_Orders, colorlineId = c.ID_Line_Color } equals new { orderId = q.ID_Orders, colorlineId = q.ID_Color_Line } into q
                          group new ColorsWithQuantitiesViewModel { coler=c, quantities=q.ToList()}  by c.ID_Orders).ToList();
            var result = (from r1 in result1
                          join r2 in result2
                             on r1.order.ID_Orders equals r2.Key
                         select new OrderWithColorsQuantitiesViewModel
                         {
                             order=r1.order,
                             colers=r2.ToList()
                         }).ToList();
            return View(result);
        }

view

<table class="table table-borderless table-sm " id="ordertable">
    @foreach (var item in Model)
    {      
        <tr>
            <td style="width: 300px;">
                <b>Artigo: </b>@item.order.ID_Orders
            </td>
            <td style="width: 500px;">
                <b>Modelo: </b>@item.order.Model
            </td>
        </tr>
        <tr>
            <td colspan="8">
                <table class="table table-bordered ordertable">
                    @foreach (var item2 in item.colers)
                    {
                        <tr>
                            @if (item2.quant.Count != 0)
                            {
                                <td style="width: 100px;">
                                    @item2.coler.Cor
                                </td>
                                <td style="width: 80px;">
                                    @foreach (var item3 in item2.quant)
                                    {
                                        @item3.Values
                                    }
                                </td>
                            }

my values are being listed under @item3.Valuesvar sumVal= result.Sum(x => x.Value);

my purpose is for the SUM to be declared in the controller

Thanks

- Reply
Jerry Cai
Participant

1110 Points

371 Posts
Re: Question about item count in a result

Feb 19, 2021 03:36 AM|Jerry Cai|LINK
Hi,MiguelMi

MiguelMi
my purpose is for the SUM to be declared in the controller

Could you please share the models design? To sum in controller, you can do this like this:
```
SUM=db.table.select(a=>a.Values).Sum();
```
Then you can pass it to view by using ViewData.

Best Regards,

Jerry Cai
ASP.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today. Learn more >
- Reply
MiguelMi
Member

22 Points

66 Posts
Re: Question about item count in a result

Feb 23, 2021 07:55 PM|MiguelMi|LINK
I have a problem with my SUM () it is only sum the first value of List to listing in a foreach
my example:
```
var totaQuantV = ResultList .Select(a => a.colers[0].Quant[0].Values).Sum();
```
are there any other ways to declare a SUM?

I tried but I have the same result;
```
var totaQuantV = ResultList.Sum(a => a.colers[0].Quant[0].Values);
```
thanks,
- Reply
mgebhard
All-Star

53711 Points

24042 Posts
Re: Question about item count in a result

Feb 23, 2021 09:29 PM|mgebhard|LINK
MiguelMi

I have a problem with my SUM () it is only sum the first value of List to listing in a foreach
my example:
```
var totaQuantV = ResultList .Select(a => a.colers[0].Quant[0].Values).Sum();
```
are there any other ways to declare a SUM?
The results are expected since you are only summing one item or one item in the nested collection. I'm pretty sure you have design bugs related to the LINQ that generates ResultList.