public void XoaPhepNam(PhepNamDTO _phepNamDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _phepNamDTO.MaChamCong)
};
base.Procedure("PHEPNAM_delete", sqlParams);
}
public DataTable Select_PhepNamByMaChamCong(PhepNamDTO _phepNamDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _phepNamDTO.MaChamCong)
};
return(base.executeNonQuerya("PhepNam_SelectByMaChamCong", sqlParams));
}
public void DeleteAll_PhepNamByMaChamCong(PhepNamDTO _phepNamDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _phepNamDTO.MaChamCong)
};
base.Procedure("PhepNam_deleteByMaChamCong", sqlParams);
}
public void Delete_PhepNamByID(PhepNamDTO _phepNamDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@ID", _phepNamDTO.ID)
};
base.Procedure("PhepNam_deleteByID", sqlParams);
}
public DataTable PhepNam_getTinhCong(PhepNamDTO _phepNamDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaChamCong", _phepNamDTO.MaChamCong),
new SqlParameter("@Ngay", _phepNamDTO.Ngay)
};
return(base.executeNonQuerya("PhepNam_getTinhCong", sqlParams));
}
public void ThemPhepNam(PhepNamDTO _phepNamDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter> {
new SqlParameter("@MaNhanVien", _phepNamDTO.MaNhanVien),
new SqlParameter("@TenNhanVien", _phepNamDTO.TenNhanVien),
new SqlParameter("@MaChamCong", _phepNamDTO.MaChamCong),
new SqlParameter("@Ngay", _phepNamDTO.Ngay),
new SqlParameter("@DemCong", _phepNamDTO.DemCong),
new SqlParameter("@DemGio", _phepNamDTO.DemGio),
new SqlParameter("@Nghi", _phepNamDTO.Nghi)
};
base.Procedure("PHEPNAM_add", sqlParams);
}
public void Xoa_TatCaPhepNam(PhepNamDTO _phepNamDTO)
{
this._phepNamDAL.XoaTatCaPhepNam(_phepNamDTO);
}
public void Them_PhepNam(PhepNamDTO _phepNamDTO)
{
this._phepNamDAL.ThemPhepNam(_phepNamDTO);
}
public DataTable SelectPhepNamByMaChamCong(PhepNamDTO _phepNamDTO)
{
return(this._phepNamDAL.Select_PhepNamByMaChamCong(_phepNamDTO));
}
public DataTable PhepNamGetTinhCong(PhepNamDTO _phepNamDTO)
{
return(this._phepNamDAL.PhepNam_getTinhCong(_phepNamDTO));
}
public void DeletePhepNamByMaChamCong(PhepNamDTO _phepNamDTO)
{
this._phepNamDAL.Delete_PhepNamByMaChamCong(_phepNamDTO);
}
public void DeletePhepNamByID(PhepNamDTO _phepNamDTO)
{
this._phepNamDAL.Delete_PhepNamByID(_phepNamDTO);
}
public void XoaTatCaPhepNam(PhepNamDTO _phepNamDTO)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
base.Procedure("PHEPNAM_deleteAll", sqlParams);
}
