Guest User

Untitled

a guest
May 24th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.46 KB | None | 0 0
  1. private void btnAverageSalEmp_Click(object sender, EventArgs e)
  2. {
  3. IEnumerable<decimal> dec = employeeList.Select(s => s.YearlySalary);
  4. decimal avg = dec.Average();
  5. MessageBox.Show("Average of all Employee Salary: " + avg.ToString());
  6. }
  7.  
  8. private void button2_Click(object sender, EventArgs e)
  9. {
  10. IEnumerable<decimal> companyNameQuery = from emp in employeeList where emp.CompanyName == cboCompany.Text select emp.YearlySalary;
  11. decimal avg = companyNameQuery.Average();
  12. MessageBox.Show("Average of Employee Salary based on Company Selected: " + avg.ToString("c"));
  13. }
  14.  
  15. private void btnDisplayOverAvgSalary_Click(object sender, EventArgs e)
  16. {
  17. IEnumerable<decimal> dec = employeeList.Select(s => s.YearlySalary);
  18. decimal avg = dec.Average();
  19. var names = employeeList.Select(s => new { FN = s.Firstname, LN = s.Lastname, CN = s.CompanyName, SAL = s.YearlySalary });
  20. foreach (var n in names)
  21. {
  22. if (n.SAL > avg)
  23. {
  24. ListViewItem lstviewitem = new ListViewItem(n.FN);
  25. lstviewitem.SubItems.Add(n.LN);
  26. lstviewitem.SubItems.Add(n.CN);
  27. lstviewitem.SubItems.Add(n.SAL.ToString("c"));
  28. listView1.Items.Add(lstviewitem);
  29. }
  30. }
  31.  
  32. }
Add Comment
Please, Sign In to add comment