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