public void WithoutBranch(int branchId) { if (branchId.IsNotZero()) { var branchDealerQuery = new SqlServerExpressionVisitor <BranchDealer>(); branchDealerQuery.Where(branchDealer => branchDealer.BranchId == branchId); var dealerIds = _dataBaseSqlServerOrmLite.FindExpressionVisitor(branchDealerQuery).Select(branchDealer => branchDealer.DealerId); dealerIds = dealerIds.Count().IsNotZero() ? dealerIds : new[] { int.MinValue }; _query.Where(dealer => !Sql.In(dealer.Id, dealerIds)); } }
public void WithPermission(int permissionId) { if (permissionId.IsNotZero()) { var permissionAccessLevelQuery = new SqlServerExpressionVisitor <PermissionAccessLevel>(); permissionAccessLevelQuery.Where(permissionAccessLevel => permissionAccessLevel.PermissionId == permissionId); var accessLevelIds = _dataBaseSqlServerOrmLite.FindExpressionVisitor(permissionAccessLevelQuery).Select(permissionAccessLevel => permissionAccessLevel.AccessLevelId); accessLevelIds = accessLevelIds.Count().IsNotZero() ? accessLevelIds : new[] { int.MinValue }; _query.Where(accessLevel => Sql.In(accessLevel.Id, accessLevelIds)); } }
public void WithoutDealer(int dealerId) { if (dealerId.IsNotZero()) { var dealerSaucerQuery = new SqlServerExpressionVisitor <DealerSaucer>(); dealerSaucerQuery.Where(dealerSaucer => dealerSaucer.DealerId == dealerId); var saucerIds = _dataBaseSqlServerOrmLite.FindExpressionVisitor(dealerSaucerQuery).Select(dealerSaucer => dealerSaucer.SaucerId); saucerIds = saucerIds.Count().IsNotZero() ? saucerIds : new[] { int.MinValue }; _query.Where(saucer => !Sql.In(saucer.Id, saucerIds)); } }
public RegionQuery(IDataBaseSqlServerOrmLite dataBaseSqlServerOrmLite) { _dataBaseSqlServerOrmLite = dataBaseSqlServerOrmLite; _query = new SqlServerExpressionVisitor <Region>(); }
public CompanyQuery(IDataBaseSqlServerOrmLite dataBaseSqlServerOrmLite) { _dataBaseSqlServerOrmLite = dataBaseSqlServerOrmLite; _query = new SqlServerExpressionVisitor <Company>(); }
public SaucerConfigurationQuery(IDataBaseSqlServerOrmLite dataBaseSqlServerOrmLite) { _dataBaseSqlServerOrmLite = dataBaseSqlServerOrmLite; _query = new SqlServerExpressionVisitor <SaucerConfiguration>(); }
public IEnumerable <T> FindExpressionVisitor <T>(SqlServerExpressionVisitor <T> sqlExpressionVisitor) where T : new() { var items = DbConnection.Select(sqlExpressionVisitor); return(items); }
public int Count <T>(SqlServerExpressionVisitor <T> sqlExpressionVisitor) where T : new() { var totalCount = DbConnection.Count(sqlExpressionVisitor); return(Convert.ToInt32(totalCount)); }
public WarningQuery(IDataBaseSqlServerOrmLite dataBaseSqlServerOrmLite) { _dataBaseSqlServerOrmLite = dataBaseSqlServerOrmLite; _query = new SqlServerExpressionVisitor <Warning>(); }
public ReservationDetailQuery(IDataBaseSqlServerOrmLite dataBaseSqlServerOrmLite) { _dataBaseSqlServerOrmLite = dataBaseSqlServerOrmLite; _query = new SqlServerExpressionVisitor <ReservationDetail>(); }
public DiseaseQuery(IDataBaseSqlServerOrmLite dataBaseSqlServerOrmLite) { _dataBaseSqlServerOrmLite = dataBaseSqlServerOrmLite; _query = new SqlServerExpressionVisitor <Disease>(); }
public BranchQuery(IDataBaseSqlServerOrmLite dataBaseSqlServerOrmLite) { _dataBaseSqlServerOrmLite = dataBaseSqlServerOrmLite; _query = new SqlServerExpressionVisitor <Branch>(); }
public DepartmentQuery(IDataBaseSqlServerOrmLite dataBaseSqlServerOrmLite) { _dataBaseSqlServerOrmLite = dataBaseSqlServerOrmLite; _query = new SqlServerExpressionVisitor <Department>(); }
public SaucerMultimediaQuery(IDataBaseSqlServerOrmLite dataBaseSqlServerOrmLite) { _dataBaseSqlServerOrmLite = dataBaseSqlServerOrmLite; _query = new SqlServerExpressionVisitor <SaucerMultimedia>(); }
public IngredientQuery(IDataBaseSqlServerOrmLite dataBaseSqlServerOrmLite) { _dataBaseSqlServerOrmLite = dataBaseSqlServerOrmLite; _query = new SqlServerExpressionVisitor <Ingredient>(); }
public JobQuery(IDataBaseSqlServerOrmLite dataBaseSqlServerOrmLite) { _dataBaseSqlServerOrmLite = dataBaseSqlServerOrmLite; _query = new SqlServerExpressionVisitor <Job>(); }
public WorkerQuery(IDataBaseSqlServerOrmLite dataBaseSqlServerOrmLite) { _dataBaseSqlServerOrmLite = dataBaseSqlServerOrmLite; _query = new SqlServerExpressionVisitor <Worker>(); }
public AccessLevelQuery(IDataBaseSqlServerOrmLite dataBaseSqlServerOrmLite) { _dataBaseSqlServerOrmLite = dataBaseSqlServerOrmLite; _query = new SqlServerExpressionVisitor <AccessLevel>(); }