public LSLamViec passingData()
{
try
{
tempLSLV = new LSLamViec();
tempLSLV.MaNV = treeViewNhanVien.SelectedNode.Tag.ToString();
tempLSLV.MaNV = txtMaNV.Text;
tempLSLV.MaPB = cbbMaPB.Text;
tempLSLV.MaChucVu = cbbMaCV.Text;
tempLSLV.NgayBD = dateTimePickerNgayBatDau.Value;
tempLSLV.NgayKT = dateTimePickerNgayKetThuc.Value;
}
catch { }
return(null);
}
public List <LSLamViec> getAllLS()
{
List <LSLamViec> lstls = new List <LSLamViec>();
foreach (Tbl_LichSuLamViec item in DB.Tbl_LichSuLamViecs)
{
LSLamViec ls = new LSLamViec();
ls.MaNV = item.maNV;
ls.MaChucVu = item.maChucVu;
ls.MaPB = item.maPB;
ls.NgayBD = item.ngayBD;
ls.NgayKT = (DateTime)item.ngayKT;
lstls.Add(ls);
}
return(lstls);
}
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 Add(LSLamViec newLSLV)
{
try
{
Tbl_LichSuLamViec newRecord = DB.Tbl_LichSuLamViecs.Single(record => record.maNV == newLSLV.MaNV && record.maChucVu == newLSLV.MaChucVu && record.maPB == newLSLV.MaPB);
newRecord.maNV = newLSLV.MaNV;
newRecord.maPB = newLSLV.MaPB;
newRecord.maChucVu = newLSLV.MaChucVu;
newRecord.ngayBD = newLSLV.NgayBD;
newRecord.ngayKT = newLSLV.NgayKT;
DB.Tbl_LichSuLamViecs.InsertOnSubmit(newRecord);
DB.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
