public bool IsReference(int branchId)
{
var amountOfReferences = _dataBaseSqlServerOrmLite.Count <BranchDealer>(branchDealer => branchDealer.BranchId == branchId);
amountOfReferences += _dataBaseSqlServerOrmLite.Count <Worker>(worker => worker.BranchId == branchId && worker.IsActive);
return(amountOfReferences.IsNotZero());
}
public bool IsReference(int roleId)
{
var amountOfReferences = _dataBaseSqlServerOrmLite.Count <User>(user => user.RoleId == roleId && user.IsActive);
amountOfReferences += _dataBaseSqlServerOrmLite.Count <Worker>(worker => worker.RoleId == roleId && worker.IsActive);
amountOfReferences += _dataBaseSqlServerOrmLite.Count <RoleConfiguration>(roleConfiguration => roleConfiguration.RoleId == roleId);
return(amountOfReferences.IsNotZero());
}
public bool IsReference(int saucerId)
{
var amountOfReferences = _dataBaseSqlServerOrmLite.Count <SaucerConfiguration>(saucerConfiguration => saucerConfiguration.SaucerId == saucerId && saucerConfiguration.IsActive);
amountOfReferences += _dataBaseSqlServerOrmLite.Count <SaucerMultimedia>(saucerMultimedia => saucerMultimedia.SaucerId == saucerId && saucerMultimedia.IsActive);
amountOfReferences += _dataBaseSqlServerOrmLite.Count <DealerSaucer>(dealerSaucer => dealerSaucer.SaucerId == saucerId);
amountOfReferences += _dataBaseSqlServerOrmLite.Count <Menu>(menu => menu.SaucerId == saucerId && menu.IsActive);
amountOfReferences += _dataBaseSqlServerOrmLite.Count <Reservation>(reservation => reservation.SaucerId == saucerId && reservation.IsActive);
return(amountOfReferences.IsNotZero());
}
public bool IsReference(int dealerId)
{
var amountOfReferences = _dataBaseSqlServerOrmLite.Count <BranchDealer>(branchDealer => branchDealer.DealerId == dealerId);
amountOfReferences += _dataBaseSqlServerOrmLite.Count <User>(user => user.DealerId == dealerId && user.IsActive);
amountOfReferences += _dataBaseSqlServerOrmLite.Count <DealerSaucer>(dealerSaucer => dealerSaucer.DealerId == dealerId);
amountOfReferences += _dataBaseSqlServerOrmLite.Count <Menu>(menu => menu.DealerId == dealerId && menu.IsActive);
amountOfReferences += _dataBaseSqlServerOrmLite.Count <Reservation>(reservation => reservation.DealerId == dealerId && reservation.IsActive);
return(amountOfReferences.IsNotZero());
}
public bool IsReference(int diseaseId)
{
var amountOfReferences = _dataBaseSqlServerOrmLite.Count <Warning>(warning => warning.DiseaseId == diseaseId && warning.IsActive);
return(amountOfReferences.IsNotZero());
}
public int TotalRecords()
{
return(_dataBaseSqlServerOrmLite.Count(_query));
}
public bool IsReference(int companyId)
{
var amountOfReferences = _dataBaseSqlServerOrmLite.Count <Branch>(branch => branch.CompanyId == companyId && branch.IsActive);
return(amountOfReferences.IsNotZero());
}
public bool IsReference(int departmentId)
{
var amountOfReferences = _dataBaseSqlServerOrmLite.Count <Worker>(worker => worker.DepartmentId == departmentId && worker.IsActive);
return(amountOfReferences.IsNotZero());
}
public bool IsReference(int regionId)
{
var amountOfReferences = _dataBaseSqlServerOrmLite.Count <Company>(company => company.RegionId == regionId && company.IsActive);
return(amountOfReferences.IsNotZero());
}
public bool IsReference(int workerId)
{
var amountOfReferences = _dataBaseSqlServerOrmLite.Count <Reservation>(reservation => reservation.WorkerId == workerId && reservation.IsActive);
return(amountOfReferences.IsNotZero());
}
public bool IsReference(int ingredientId)
{
var amountOfReferences = _dataBaseSqlServerOrmLite.Count <SaucerConfiguration>(saucerConfiguration => saucerConfiguration.IngredientId == ingredientId && saucerConfiguration.IsActive);
return(amountOfReferences.IsNotZero());
}
public bool IsReference(int ingredientGroupId)
{
var amountOfReferences = _dataBaseSqlServerOrmLite.Count <Ingredient>(ingredient => ingredient.IngredientGroupId == ingredientGroupId && ingredient.IsActive);
return(amountOfReferences.IsNotZero());
}