public List <SPClientEntity> FindAllNotInClientGroup(SPClientGroupEntity spClientGroupEntity)
{
NHibernateDynamicQueryGenerator <SPClientEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(Or(Not(PROPERTY_SPCLIENTGROUPID.Eq(spClientGroupEntity)), PROPERTY_SPCLIENTGROUPID.IsNull()));
return(this.FindListByQueryBuilder(queryGenerator));
}
public SPClientPriceEntity GetClientPriceByClientID(int clientid, int clientGroupid)
{
NHibernateDynamicQueryGenerator <SPClientPriceEntity> queryGenerator = this.GetNewQueryBuilder();
queryGenerator.AddWhereClause(PROPERTY_SPCLIENTID.Eq(clientid));
queryGenerator.AddWhereClause(PROPERTY_SPCLIENTGROUPID.Eq(clientGroupid));
return(this.FindSingleEntityByQueryBuilder(queryGenerator));
}
