public List <CaNghi> CaNghi() { List <CaNghi> _listCaNghi = new List <CaNghi>(); string _sQuery = "SELECT * FROM CANGHI"; DataTable _dt = SelectData.Select.ExcuteQuery(_sQuery); foreach (DataRow _dr in _dt.Rows) { CaNghi _cn = new CaNghi(); _cn.NgayNghi = _dr["NGAYNGHICA"].ToString(); _cn.GioLam = _dr["GIOLAM"].ToString(); _cn.IDNhanVien = _dr["IDNHANVIEN"].ToString(); _listCaNghi.Add(_cn); _cn = null; } _dt = null; return(_listCaNghi); }
public int RemoveNhanVien(string _sId, NgayNghi _nn, DanhSachCa _dsc, CaNghi _cn, LuongTam _lt) { int _i = 0; string _sQuery = "DELETE NHANVIEN WHERE ID = @ID"; string _sQuery1 = "DELETE NGAYNGHI WHERE IDNHANVIEN = @IDNHANVIEN"; string _sQuery2 = "DELETE DANHSACHCA WHERE IDNHANVIEN = @IDNHANVIEN"; string _sQuery3 = "DELETE CANGHI WHERE IDNHANVIEN = @IDNHANVIEN"; string _sQuery4 = "DELETE LUONGTAM WHERE IDNHANVIEN = @IDNHANVIEN"; if (_nn != null) { _i += SelectData.Select.ExcuteNonQuery(_sQuery1, new object[] { _nn.IDNhanVien }); } if (_dsc != null) { _i += SelectData.Select.ExcuteNonQuery(_sQuery2, new object[] { _dsc.IDNhanVien }); } if (_cn != null) { _i += SelectData.Select.ExcuteNonQuery(_sQuery3, new object[] { _cn.IDNhanVien }); } _i += SelectData.Select.ExcuteNonQuery(_sQuery4, new object[] { _lt.IDNhanVien }); return(SelectData.Select.ExcuteNonQuery(_sQuery, new object[] { _sId }) + _i); }
public int ChuyenCaThanhNgay(CaNghi _cn, NgayNghi _nn, DanhSachCa _dsc) { int _i = 0; string _sQuery = "INSERT INTO NGAYNGHI VALUES ( @NGAYNGHI , @IDNHANVIEN )"; string _sQuery1 = "DELETE CANGHI WHERE IDNHANVIEN = @IDNHANVIEN AND NGAYNGHICA = @NGAYNGHICA"; string _sQuery2 = "UPDATE DANHSACHCA SET CHECKCA = @CHECKCA WHERE ID = @ID AND IDNHANVIEN = @IDNHANVIEN"; _i += SelectData.Select.ExcuteNonQuery(_sQuery2, new object[] { _dsc.CheckCa, _dsc.ID, _dsc.IDNhanVien }); _i += SelectData.Select.ExcuteNonQuery(_sQuery1, new object[] { _cn.IDNhanVien, _cn.NgayNghi }); _i += SelectData.Select.ExcuteNonQuery(_sQuery, new object[] { _nn.Ngay, _nn.IDNhanVien }); return(_i); }
public int DiemDanhCa(DanhSachCa _dsc, CaNghi _cn, bool _bCheckCa) { string _sQuery = "INSERT INTO CANGHI VALUES ( @NGAYNGHICA , @GIOLAM , @IDNHANVIEN )"; string _sQuery1 = "DELETE CANGHI WHERE NGAYNGHICA = @NGAYNGHICA AND GIOLAM = @GIOLAM AND IDNHANVIEN = @IDNHANVIEN"; string _sQuery2 = "UPDATE DANHSACHCA SET CHECKCA = @CHECKCA WHERE IDNHANVIEN = @IDNHANVIEN AND ID = @ID"; int _i = 0; _i += SelectData.Select.ExcuteNonQuery(_sQuery2, new object[] { _dsc.CheckCa, _dsc.IDNhanVien, _dsc.ID }); if (_bCheckCa == false) { _i += SelectData.Select.ExcuteNonQuery(_sQuery, new object[] { _cn.NgayNghi, _cn.GioLam, _cn.IDNhanVien }); } if (_bCheckCa == true) { _i += SelectData.Select.ExcuteNonQuery(_sQuery1, new object[] { _cn.NgayNghi, _cn.GioLam, _cn.IDNhanVien }); } return(_i); }