public SPAdAssignedHistortyEntity FindAssignedHistortybyAdPack(SPAdPackEntity spAdPackEntity)
        {
            NHibernateDynamicQueryGenerator <SPAdAssignedHistortyEntity> query = this.GetNewQueryBuilder();

            query.AddWhereClause(PROPERTY_ENDDATE.IsNull());

            query.AddWhereClause(PROPERTY_SPADPACKID.Eq(spAdPackEntity));

            return(FindSingleEntityByQueryBuilder(query));
        }
        public List <SPAdAssignedHistortyEntity> FindAllCLientAssignedAdPack(SPSClientEntity client)
        {
            NHibernateDynamicQueryGenerator <SPAdAssignedHistortyEntity> query = this.GetNewQueryBuilder();

            query.AddWhereClause(PROPERTY_ENDDATE.IsNull());

            query.AddWhereClause(PROPERTY_SPCLIENTID.Eq(client));

            return(FindListByQueryBuilder(query));
        }