public void WithOnlyActivated(bool onlyActivated)
{
if (onlyActivated)
{
_query.Where(ingredientGroup => ingredientGroup.IsActive);
}
}
public void WithOnlyActivated(bool onlyActivated)
{
if (onlyActivated)
{
_query.Where(department => department.IsActive);
}
}
public void WithOnlyActivated(bool onlyActivated)
{
if (onlyActivated)
{
_query.Where(job => job.IsActive);
}
}
public void WithOnlyActivated(bool onlyActivated)
{
if (onlyActivated)
{
_query.Where(region => region.IsActive);
}
}
public void WithOnlyActivated(bool onlyActivated)
{
if (onlyActivated)
{
_query.Where(saucerConfiguration => saucerConfiguration.IsActive);
}
}
public void WithOnlyActivated(bool onlyActivated)
{
if (onlyActivated)
{
_query.Where(company => company.IsActive);
}
}
public void WithOnlyActivated(bool onlyActivated)
{
if (onlyActivated)
{
_query.Where(role => role.IsActive);
}
}
public void WithOnlyActivated(bool onlyActivated)
{
if (onlyActivated)
{
_query.Where(disease => disease.IsActive);
}
}
public void WithRole(int roleId)
{
if (roleId.IsNotZero())
{
_query.Where(roleConfiguration => roleConfiguration.RoleId == roleId);
}
}
public void WithOnlyActivated(bool onlyActivated)
{
if (onlyActivated)
{
_query.Where(saucerMultimedia => saucerMultimedia.IsActive);
}
}
public void WithOnlyActivated(bool onlyActivated)
{
if (onlyActivated)
{
_query.Where(tip => tip.IsActive);
}
}
public void WithOnlyActivated(bool onlyActivated)
{
if (onlyActivated)
{
_query.Where(menu => menu.IsActive);
}
}
public void WithReservation(int reservationId)
{
if (reservationId.IsNotZero())
{
_query.Where(reservationDetail => reservationDetail.ReservationId == reservationId);
}
}
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 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 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 WithOnlyActivated(bool onlyActivated)
{
if (onlyActivated)
{
_query.Where(branch => branch.IsActive);
}
}
public void WithOnlyActivated(bool onlyActivated)
{
if (onlyActivated)
{
_query.Where(dealer => dealer.IsActive);
}
}
public void WithOnlyActivated(bool onlyActivated)
{
if (onlyActivated)
{
_query.Where(warning => warning.IsActive);
}
}