public bool Delete(string deleteID)
{
try
{
Tbl_NhanVien deleteRecord = DB.Tbl_NhanViens.Single(record => record.maNV == deleteID);
DB.Tbl_NhanViens.DeleteOnSubmit(deleteRecord);
DB.SubmitChanges();
return(true);
}
catch { return(false); }
}
public bool Add(NhanVien newNV)
{
try
{
Tbl_NhanVien newRecord = MyConvert.ToTbl_NhanVien(newNV);
DB.Tbl_NhanViens.InsertOnSubmit(newRecord);
DB.SubmitChanges();
return(true);
}
catch { return(false); }
}
public static Tbl_NhanVien ToTbl_NhanVien(NhanVien nhanvien)
{
Tbl_NhanVien record = new Tbl_NhanVien();
record.maNV = nhanvien.MaNV;
record.hoTen = nhanvien.HoTen;
record.ngaySinh = nhanvien.NgaySinh;
record.ngayVaoLam = nhanvien.NgayVaoLam;
record.soCMND = nhanvien.SoCMND;
record.ngayCapCMND = nhanvien.NgayCapCMND;
record.gioiTinh = nhanvien.GioiTinh;
record.email = nhanvien.Email;
record.soDT = nhanvien.SDT;
record.diaChi = nhanvien.DiaChi;
record.trangThai = nhanvien.TrangThai;
return(record);
}
public bool UpDate(LSLamViec updateLSLV)
{
try
{
Tbl_NhanVien tempNV = DB.Tbl_NhanViens.Single(record => record.maNV == updateLSLV.MaNV);
Tbl_LichSuLamViec updateRecord = DB.Tbl_LichSuLamViecs.Single(record => record.maNV == updateLSLV.MaNV && record.maChucVu == updateLSLV.MaChucVu && record.maPB == updateLSLV.MaPB);
updateRecord.maNV = updateLSLV.MaNV;
updateRecord.maPB = updateLSLV.MaPB;
updateRecord.maChucVu = updateLSLV.MaChucVu;
updateRecord.ngayBD = updateLSLV.NgayBD;
updateRecord.ngayKT = updateLSLV.NgayKT;
DB.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpDate(CTThamGiaDTNV updateCTDTNV)
{
try
{
//Tbl_CTThamGiaDTNV updateRecord = DB.Tbl_CTThamGiaDTNVs.Single(record => record.maNV == updateCTDTNV.MaNV && record.maKhoaDT == updateCTDTNV.MaKhoaDT);
Tbl_NhanVien tempnhanvien = DB.Tbl_NhanViens.Single(record => record.maNV == updateCTDTNV.MaNV);
Tbl_CTThamGiaDTNV updateRecord = new Tbl_CTThamGiaDTNV();
updateRecord.maNV = updateCTDTNV.MaNV;
updateRecord.maKhoaDT = updateCTDTNV.MaKhoaDT;
updateRecord.nhanXet = updateCTDTNV.NhanXet;
updateRecord.ketQua = updateCTDTNV.KetQua;
DB.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool Add(CTThamGiaDTNV newCTTGDT)
{
try
{
//Tbl_CTThamGiaDTNV newRecord = DB.Tbl_CTThamGiaDTNVs.Single(record => record.maNV == newCTTGDT.MaNV && record.maKhoaDT == newCTTGDT.MaKhoaDT);
Tbl_NhanVien tempnhanvien = DB.Tbl_NhanViens.Single(record => record.maNV == newCTTGDT.MaNV);
Tbl_CTThamGiaDTNV newRecord = new Tbl_CTThamGiaDTNV();
newRecord.maNV = newCTTGDT.MaNV;
newRecord.maKhoaDT = newCTTGDT.MaKhoaDT;
newRecord.nhanXet = newCTTGDT.NhanXet;
newRecord.ketQua = newCTTGDT.KetQua;
DB.Tbl_CTThamGiaDTNVs.InsertOnSubmit(newRecord);
DB.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool Update(NhanVien updateNV)
{
try
{
Tbl_NhanVien updateRecord = DB.Tbl_NhanViens.Single(record => record.maNV == updateNV.MaNV);
updateRecord.maNV = updateNV.MaNV;
updateRecord.hoTen = updateNV.HoTen;
updateRecord.ngaySinh = updateNV.NgaySinh;
updateRecord.ngayVaoLam = updateNV.NgayVaoLam;
updateRecord.soCMND = updateNV.SoCMND;
updateRecord.ngayCapCMND = updateNV.NgayCapCMND;
updateRecord.gioiTinh = updateNV.GioiTinh;
updateRecord.email = updateNV.Email;
updateRecord.soDT = updateNV.SDT;
updateRecord.diaChi = updateNV.DiaChi;
updateRecord.trangThai = updateNV.TrangThai;
DB.SubmitChanges();
return(true);
}
catch { return(false); }
}
public bool Add(CTKyLuatNV newCTKL)
{
try
{
Tbl_NhanVien tempNV = DB.Tbl_NhanViens.Single(record => record.maNV == newCTKL.MaNV);
Tbl_CTKyLuatNV newRecord = new Tbl_CTKyLuatNV();
newRecord.maNV = newCTKL.MaNV;
newRecord.maKyLuat = newCTKL.MaKyLuat;
newRecord.hinhThucKL = newCTKL.HinhThucKL;
newRecord.ngayLap = newCTKL.NgayLap;
newRecord.ngayThiHanh = newCTKL.NgayThiHanh;
newRecord.ngayKetThuc = newCTKL.NgayKetThuc;
newRecord.mucDoKL = newCTKL.MucDoKL;
newRecord.lyDo = newCTKL.LyDo;
newRecord.ghiChu = newCTKL.GhiChu;
DB.Tbl_CTKyLuatNVs.InsertOnSubmit(newRecord);
DB.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public static NhanVien ToNhanVien(Tbl_NhanVien record)
{
return(new NhanVien(record.maNV, record.hoTen, record.ngaySinh, record.ngayVaoLam, record.soCMND, record.ngayCapCMND,
record.gioiTinh, record.email, record.soDT, record.diaChi, record.trangThai.Value));
}
