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

Question

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#

Vincent Maverick Durano · Answer

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(); } } }