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