Assign people to different groups using asp.net mvc C#

I want to assign people to different groups based on their scores, from a table called "people" to another table called "grouping" starting from the highest score. There are 80 people I want the first 20 candidates with the highest score assigned to “Group A”, the next 20 to ” Group B”, the next 20 to ” Group C” and so on. Am using asp.net MVC and C#

Database Name : peopleDB

Fields in people table

peopleID

Firstname

Lastname

scoresobtained

Grouping Table

Firstname

Lastname

group

In my Controller

public ActionResult autoassign()

{

var rc = new peopleDBEntities();

var res = (from p in rc.people

orderby p.scoresobtained descending

select new

{

firstname = p.firstname.ToString(),

lastname = p.lastname.ToString(),

score = f.canditatescores.ToString(),

});

in my controller as shown above, i have retrieved the values from people table from highest scores.(descending) how do iterate to pare them into groups of 20 each. i do not know how to go about it. so please help. I am using asp.net mvc in C#

First thing you need is that make sure that your Group table has link to your People. so make sure that your Group table have PeopleID on it.

Once you have that then it's easy for you to add and map each people to groups:

using (var db = new peopleDBEntities()) {

var people = (from q in db.People

orderby q.Score

select q).ToList();

//get the first 20 data

var groupA = people.Skip(0).Take(20);

AssignPeopleToGroup(groupA,"Group A");

//get the next 20 data

var groupB = people.Skip(20).Take(40);

AssignPeopleToGroup(groupB,"Group B");

//get the next 20 data

var groupC = people.Skip(40).Take(60);

AssignPeopleToGroup(groupC,"Group C");

//get the next 20 data

var groupD = people.Skip(60).Take(80);

AssignPeopleToGroup(groupD,"Group D");

}

private void AssignPeopleToGroup(List group, string groupName){

using (var db = new peopleDBEntities()) {

//here you can add the data to the Group table

foreach(var p in groupB){

Group G = new Group();

G.PeopleID = p.PeopleID;

G.FirstName = p.FirstName;

G.LastName = p.LastName;

G.Group = groupName;

db.Groups.Add(G);

db.SaveChanges();

}

1 Reply

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

Vincent Maverick Durano11y ago
First thing you need is that make sure that your Group table has link to your People. so make sure that your Group table have PeopleID on it.

Once you have that then it's easy for you to add and map each people to groups:

using (var db = new peopleDBEntities()) {
               var people = (from q in db.People
                     orderby q.Score
                     select q).ToList();

         //get the first 20 data
         var groupA = people.Skip(0).Take(20);
         AssignPeopleToGroup(groupA,"Group A");
         //get the next 20 data
         var groupB = people.Skip(20).Take(40);
         AssignPeopleToGroup(groupB,"Group B");
         //get the next 20 data
         var groupC = people.Skip(40).Take(60);
         AssignPeopleToGroup(groupC,"Group C");
         //get the next 20 data
         var groupD = people.Skip(60).Take(80);
         AssignPeopleToGroup(groupD,"Group D");

}

private void AssignPeopleToGroup(List group, string groupName){
   using (var db = new peopleDBEntities()) {
      //here you can add the data to the Group table
      foreach(var p in groupB){
         Group G = new Group();
         G.PeopleID = p.PeopleID;
         G.FirstName = p.FirstName;
         G.LastName = p.LastName;
        G.Group = groupName;
         db.Groups.Add(G);
         db.SaveChanges();
      }
   }
}
0