public static int tinhThamNienTaiTruong(HRMDB0Entities db, NhanVien nv)
{
var tongThoiGian = new DateRanges();
foreach (var ct in db.nvQTLamViec.Where(ct => ct.NV_id == nv.id))
{
tongThoiGian.Add(ct.ThoiGianBatDau, ct.ThoiGianKetThuc);
}
foreach (var lv in db.nvQTNghiNganHan.Where(lv => lv.CongTac.NV_id == nv.id))
{
tongThoiGian.Sub(lv.NgayBatDau, lv.NgayKetThuc);
}
return(tongThoiGian.ToMonths());
}
public static int tinhThamNienGiangDay(HRMDB0Entities db, NhanVien nv)
{
var tongThoiGian = new DateRanges();
foreach (var ct in db.nvQTLamViec.Where(ct => ct.NV_id == nv.id)
.Where(ct => ct.ChucDanhChucVu_id.HasValue && ct.ChucDanhChuyenMon.laDayHoc))
{
/*if (ct.ChucDanhChuyenMon.tenChucDanhChuyenMon.ToLower().Contains("giảng")
|| ct.ChucDanhChuyenMon.tenChucDanhChuyenMon.ToLower().Contains("giáo"))*/
tongThoiGian.Add(ct.ThoiGianBatDau, ct.ThoiGianKetThuc);
}
return(tongThoiGian.ToMonths() +
db.NhanViens.All.Find(nv.id).nvTTMoRongs.Single().ThamNienGiangDay_Truoc);
}