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(); }