HOw can i get total from txt file empolyee wise..

public class EmpTotalSalary

{

public int EmpId { get; set; }

public int Salary { get; set; }

}

string filepath = @"TextFile1.txt";

var fileStream = new FileStream(filepath, FileMode.Open, FileAccess.Read);

using (var streamReader = new StreamReader(fileStream, Encoding.UTF8))

{

string line;

List<EmpTotalSalary> totalEmpTotalSalary = new List<EmpTotalSalary>();

while ((line = streamReader.ReadLine()) != null)

{

string[] splitLine = line.Split('|');

string[] splitByMid = line.Split('-');

string[] split1 = splitByMid[0].Split(':');

string[] split2 = splitByMid[1].Split(':');

totalEmpTotalSalary.Add(new EmpTotalSalary { EmpId = Convert.ToInt32(split1[1]), Salary = Convert.ToInt32(split2[1]) });

}

var finalData = totalEmpTotalSalary.GroupBy(x => x.EmpId).Select(

g => new

{

EmpId = g.First().EmpId,

Salary = g.Sum(s => s.Salary)

});

}