câu 1
câu 2
// ===== XAML - ThongKeWindow.xaml =====
/*
*/
// ===== Code-behind - ThongKeWindow.xaml.cs =====
using System.Linq;
using System.Windows;
using EmployeeManagement.Models;
using Microsoft.EntityFrameworkCore;
namespace EmployeeManagement
{
public partial class ThongKeWindow : Window
{
EmployeeDbContext db = new EmployeeDbContext();
public ThongKeWindow()
{
InitializeComponent();
hienthi();
}
private void hienthi()
{
// Thống kê theo phòng ban: tổng lương, số nhân viên
var query = from nv in db.NhanViens
join pb in db.PhongBans
on nv.MaPhongBan equals pb.MaPhongBan
group nv by new { nv.MaPhongBan, pb.TenPhongBan } into g
select new
{
MaPhongBan = g.Key.MaPhongBan,
TenPhongBan = g.Key.TenPhongBan,
TongLuong = g.Sum(x => x.Luong ?? 0),
SoNhanVien = g.Count()
};
dtg.ItemsSource = query.ToList();
}
protected override void OnClosed(System.EventArgs e)
{
base.OnClosed(e);
db?.Dispose();
}
}
}