Calculating sum of the scores of similar ids

Question

0.00/5 (No votes)

See more:

Hello

I'm creating a web site in asp.net with C# language.

I have 9 lists. Each lists have 2 columns : ID with int type, and Value with int16 type. ID is unique.

I want to calculate score of each ID in each list with a special formula. For instance, you think this is the result after calculating all scores:

id    list number   value   score
100   1              2      10
300   1              2      9
200   1              4      11
100   2              3      10.5
200   2              3      10
...

I want to calculate sum of the scores of each id. I mean, the final score of id number 100 in my example is: 10+10.5+....

What do you suggest for me to do this? My idea for first stage is to create a list and store id, list name, value, and score in it(like the above table), but I don't know how to do stage 2.

I would be grateful if you kindly help me.
Thanks a lot

[edit]Code block added - OriginalGriff[/edit]

Posted 20-Sep-14 3:59am

k5_ce

Updated 20-Sep-14 4:12am

OriginalGriff

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-09-20T04:44:00

If you create a list then you are half way there. What I would do is go one stage further, and create a class to hold the values, and then build a list of the class instances:

C#

public class UserScore
   {
   public int ID { get; set; }
   public int Number { get; set; }
   public int Value { get; set; }
   public double Score { get; set; }
   public UserScore(int id, int number, int value, double score)
      {
      ID = id;
      Number = number;
      Value = value;
      Score = score;
      }
   }

You can then construct a List of the class and fill it:

C#

List<userscore> list = new List<userscore>();
list.Add(new UserScore(100, 1, 2, 10));
list.Add(new UserScore(300, 1, 2, 9));
list.Add(new UserScore(200, 1, 4, 11));
list.Add(new UserScore(100, 2, 3, 10.5));
list.Add(new UserScore(200, 2, 4, 10));

You can then use Linq to group the results:

C#

var totals = from uc in list
             group uc by uc.ID into g
             select new { ID = g.Key, TotalScore = g.Sum(x => x.Score) };

[edit]Spurious XML removed[/edit]

Arkadeep De · Answer 2 · 2014-09-20T09:06:00

Solution 2

if you are using sql then use SUM() with group by clause.

Posted 20-Sep-14 9:06am

Arkadeep De

Comments

k5_ce 22-Sep-14 9:54am

Thanks for your answer. These data are not saved in database. The raw data are stored in database. I put them to several formulas, and after that I want to do this stages.
Best regards