How to Calculate Values Between Ages

Question

User-1892044535 posted

Hello guys, I want to Collect values between ages like this table and i am using mvc5 code first how can i display count values  between  the ages from my database 

age from 1--4	age from 5--10	age from 11--16	age from 17--22	age from 23--27	sum
?	?	?	?	?

The ages i entered by a textbox how can i Sort and collect them

and this is my model

public class Pation
{
[Key]
public int Id { get; set; }
public string PationName { get; set; }
public int Age { get; set; }
public Sex Sex { get; set; }
public Viset viset { get; set; }
public Free IsFree { get; set; }
public string NameProd { get; set; }
public string esalNum { get; set; }
public string Pationphone { get; set; }
public string cons { get; set; }
public DateTime DateWared { get; set; } = DateTime.UtcNow.AddHours(3);

}

Answer 1

User-271186128 posted

Hi mas,

mas mas

I want to Collect values between ages like this table and i am using mvc5 code first how can i display count values  between  the ages from my database 

You could refer to the following code to collect the value.

from u in users
let range = (u.Age >= 0  && u.Age < 10 ? "0-9" :
             u.Age >= 10 && u.Age < 15 ? "10-14" :
             u.Age >= 15 && u.Age < 50 ? "15-49" :
            "50+")
group u by range into g
select new { g.Key, Count=g.Count() };

Best regards,
Dillion

Answer 2

User-1892044535 posted

Zhi Lv  

I Really wont thank you so thank you bro  so much but how my view it's going to be like ? just give me one example i am sorry  

Answer 3

User-1892044535 posted
Please man please help me man

Answer 4

User-271186128 posted

Hi mas,

You could refer to the following code to use Foreach or For statement to display the values.

            var query = (from t in datalist
                        let range = (
                                     t.Age>= 0 && t.Age< 10 ? "0-9" :
                                     t.Age>= 11 && t.Age< 15 ? "10-14" :
                                     t.Age>= 15 && t.Age< 50 ? "15-50" :
                                     "50+"
                                     )
                        group t by range into g
                        select new UserRange { AgeRange = g.Key, Count = g.Count() }).ToList();
            //add the sum column.
            query.Add(new UserRange() { AgeRange = "Sum", Count = query.Sum(c => c.Count) });

            ViewBag.UserData = query;

Code in the view:

<table border="1">

    <tr>
        @foreach (var item in ViewBag.UserData)
        {
            <th>@item.AgeRange </th>
        }

    </tr>
    <tr>
        @foreach (var item in ViewBag.UserData)
        {
            <td>@item.Count </td>
        }
    </tr>
</table>

The result as below:

Best regards,
Dillion

Answer 5

User-1892044535 posted

bro how can i thank you bro man you save my live men thank you so much

Answer 6

User-1892044535 posted

hi  Zhi Lv how you doing Zhi Lv i try the add to code but i got some error bro

public ActionResult AllCuont()
{
var query = (from t in db.Pations
let range = (
t.Age >= 0 && t.Age < 10 ? "0-9" :
t.Age >= 11 && t.Age < 15 ? "10-14" :
t.Age >= 15 && t.Age < 50 ? "15-50" :
"50+"
)
group t by range into g
select new UserRange { AgeRange = g.Key, Count = g.Count() }).ToList();
//add the sum column.
query.Add(new UserRange() { AgeRange = "Sum", Count = query.Sum(c => c.Count) });

ViewBag.UserData = query;
return View();
}

and I added model like this 

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

namespace Archive.Models
{
public class UserRange
{
public string AgeRange { get; set; }
public IEnumerable<Pation> Count { get; set; }
}
}

the error says  cannot convert from 'int' to 'system.collections.generic.ienumerable 

Answer 7

User-1892044535 posted

hi Zhi Lv how you doing Zhi Lv i try the add to code but i got some error bro

public ActionResult AllCuont()
{
var query = (from t in db.Pations
let range = (
t.Age >= 0 && t.Age < 10 ? "0-9" :
t.Age >= 11 && t.Age < 15 ? "10-14" :
t.Age >= 15 && t.Age < 50 ? "15-50" :
"50+"
)
group t by range into g
select new UserRange { AgeRange = g.Key, Count = g.Count() }).ToList();
//add the sum column.
query.Add(new UserRange() { AgeRange = "Sum", Count = query.Sum(c => c.Count) });

ViewBag.UserData = query;
return View();
}

and I added model like this

{
public class UserRange
{
public string AgeRange { get; set; }
public IEnumerable<Pation> Count { get; set; }
}
}

the error says cannot convert from 'int' to 'system.collections.generic.ienumerable

idon't know why this happen't 

Answer 8

User-271186128 posted

Hi mas,

mas mas

the error says cannot convert from 'int' to 'system.collections.generic.ienumerable

In my code, the Count property should be the int type, instead of the IEnumerable type, like this:

    public class UserRange
    {
        public string AgeRange { get; set; }
        public int Count { get; set; }
    }

Best regards,
Dillion

Answer 9

User-1892044535 posted

Thank you, my friend. I worked. Thank you very much, brother. I appreciate you standing with me brother