public void UpdateNhanVien_BaoHiem_IdNHanVienBH(BHNHANVIEN_BAOHIEM nvbh)
{
BHNHANVIEN_BAOHIEM item = dataContext.BHNHANVIEN_BAOHIEMs.Where(p => p.IDNhanVien_BaoHiem == nvbh.IDNhanVien_BaoHiem).SingleOrDefault();
item = nvbh;
Save();
}
public void UpdateNhanVien_BaoHiem(BHNHANVIEN_BAOHIEM nvbh)
{
BHNHANVIEN_BAOHIEM item = dataContext.BHNHANVIEN_BAOHIEMs.Where(p => p.IDNhanVien_BaoHiem == nvbh.IDNhanVien_BaoHiem).SingleOrDefault();
//item = nvbh;
item.DangDongBHTN = nvbh.DangDongBHTN;
item.DangDongBHXH = nvbh.DangDongBHXH;
item.DangDongBHYT = nvbh.DangDongBHYT;
item.LuongBaoHiem = nvbh.LuongBaoHiem;
item.PhuCapCV = nvbh.PhuCapCV;
item.PhuCapKhac = nvbh.PhuCapKhac;
item.PhuCapTNN = nvbh.PhuCapTNN;
item.PhuCapTNVK = nvbh.PhuCapTNVK;
item.DaNghi = nvbh.DaNghi;
item.TrangThaiCapTheBHYT = nvbh.TrangThaiCapTheBHYT;
item.TrangThaiCapSoBHXH = nvbh.TrangThaiCapSoBHXH;
Save();
HOSO hs = dataContext.HOSOs.Where(p => p.PR_KEY == (decimal)item.IDNhanVien_BaoHiem).SingleOrDefault();
hs.SOTHE_BHXH = nvbh.SoSoBHXH;
hs.SOTHE_BHYT = nvbh.SoTheBHYT;
hs.NGAY_DONGBH = nvbh.TuThangBHYT;
hs.NGAY_HETHAN_BHYT = nvbh.DenThangBHYT;
hs.MA_NOI_KCB = nvbh.NoiDangKyKCB;
hs.NGAYCAP_BHXH = nvbh.NgayDangKyBHXH;
hs.MA_NOICAP_BHXH = nvbh.NoiCapSoBHXH;
Save();
}
public void LuuNhanVienDongMoi(BHNHANVIEN_BAOHIEM nvbh)
{
BHNHANVIEN_BAOHIEM nv = new BHNHANVIEN_BAOHIEM();
nv = nvbh;
dataContext.BHNHANVIEN_BAOHIEMs.InsertOnSubmit(nv);
dataContext.SubmitChanges();
//Lưu biến động bảo hiểm
DAL.BHBIENDONGBAOHIEM bdbh = new DAL.BHBIENDONGBAOHIEM();
bdbh.IDQuyDinhBienDong = dataContext.BHQUYDINHBIENDONGs.SingleOrDefault(p => p.MaBienDong == "TDMBH").IDQuyDinhBienDong;
bdbh.IDNhanVien_BaoHiem = nvbh.IDNhanVien_BaoHiem;
bdbh.TuNgay = nv.NgayDangKyBHXH == null ? DateTime.Now : nv.NgayDangKyBHXH.Value;
bdbh.Loai = dataContext.BHQUYDINHBIENDONGs.SingleOrDefault(p => p.MaBienDong == "TDMBH").LoaiAnhHuong;
bdbh.MaNhanVien = nvbh.MaNhanVien;
bdbh.HoTen = nvbh.HoTen;
bdbh.MaSo = nvbh.SoSoBHXH;
bdbh.NgaySinh = nvbh.NgaySinh;
bdbh.GioiTinh = nvbh.GioiTinh ?? true;
bdbh.ChucVu = "";
if (dataContext.DM_CHUCVUs.SingleOrDefault(p => p.MA_CHUCVU == nvbh.MaChucVu) != null)
{
var singleOrDefault = dataContext.DM_CHUCVUs.SingleOrDefault(p => p.MA_CHUCVU == nvbh.MaChucVu);
if (singleOrDefault != null)
{
bdbh.ChucVu = singleOrDefault.TEN_CHUCVU;
}
}
bdbh.TienLuongMoi = nvbh.LuongBaoHiem;
bdbh.PhuCapCVMoi = nvbh.PhuCapCV;
bdbh.PhuCapTNNgheMoi = nvbh.PhuCapTNN;
bdbh.PhuCapTNVKMoi = nvbh.PhuCapTNVK;
bdbh.ThangDangKy = nvbh.NgayDangKyBHXH ?? DateTime.Now;
bdbh.DaCoSo = string.IsNullOrEmpty(nvbh.SoSoBHXH) ? bdbh.DaCoSo = false : bdbh.DaCoSo = true;
bdbh.DaDuyet = true;
bdbh.UserID = nvbh.UserID;
bdbh.DateCreate = DateTime.Now;
bdbh.MaDonVi = nvbh.MaDonVi;
bdbh.DienGiai = "";
dataContext.BHBIENDONGBAOHIEMs.InsertOnSubmit(bdbh);
dataContext.SubmitChanges();
}
