Share 2 list rcords into 1 list based on userid to showtotal using c#

Greetings

Using sharepoint 2016 on Prem

having 2 list like below

i want to validate record between 2 lists which is List A and List B.

if same record exist on list B based on "User ID" so it should merge the record into 1 record to sum up.

Note: if User "A" not exist on List B so it should transfer data into List C
But if User "A" record exist in list "B" so it should merge the record into 1 with sum up on count (Total Docs uploaded).

my output would be like this it should be in desc order based on "Total Docs uploaded'

Note:Want to do it programmatically

Thanks

Hi,

Please use below linq query which will help you to resolve your query,

var listA = new List {
new UserDetail(){
UserId = 1,
UserName = "A",
TotalDocuments=10
},
new UserDetail(){
UserId = 1,
UserName = "B",
TotalDocuments=2
},
new UserDetail(){
UserId = 1,
UserName = "C",
TotalDocuments=2
},
};
var listB = new List {
new UserDetail(){
UserId = 100,
UserName = "XY",
TotalDocuments=10
},
new UserDetail(){
UserId = 2,
UserName = "B",
TotalDocuments=102
},
new UserDetail(){
UserId = 3,
UserName = "C",
TotalDocuments=2
},
new UserDetail(){
UserId = 9,
UserName = "Test",
TotalDocuments=21
}
};
var listC = listA.Concat(listB);
var listCResult = listC.GroupBy(x => x.UserName)
.Select(u => new UserDetail {
UserId = u.First().UserId,
UserName = u.First().UserName,
TotalDocuments = u.Sum(d => d.TotalDocuments)
}).ToList();

2 Replies

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

Jignesh Kumar6y ago
Accepted answer
Hi,

Please use below linq query which will help you to resolve your query,
var listA = new List {

               new UserDetail(){
                   UserId = 1,
                   UserName = "A",
                   TotalDocuments=10
               },
               new UserDetail(){
                   UserId = 1,
                   UserName = "B",
                   TotalDocuments=2
               },
               new UserDetail(){
                   UserId = 1,
                   UserName = "C",
                   TotalDocuments=2
               },
           };

           var listB = new List {

               new UserDetail(){
                   UserId = 100,
                   UserName = "XY",
                   TotalDocuments=10
               },
               new UserDetail(){
                   UserId = 2,
                   UserName = "B",
                   TotalDocuments=102
               },
               new UserDetail(){
                   UserId = 3,
                   UserName = "C",
                   TotalDocuments=2
               },
               new UserDetail(){
                   UserId = 9,
                   UserName = "Test",
                   TotalDocuments=21
               }
           };

           var listC = listA.Concat(listB);

           var listCResult = listC.GroupBy(x => x.UserName)
                       .Select(u => new UserDetail {
                           UserId = u.First().UserId,
                           UserName = u.First().UserName,
                           TotalDocuments = u.Sum(d => d.TotalDocuments)
                       }).ToList();
mohammad qasim6y ago
thanks,works fine