public List <CategoryEntity> SearchCategories(CategorySearchEntity searchObject)
{
IBaseDataSvc channel = CreateChannel();
var result = channel.SearchCategories(searchObject);
channel.Dispose();
return(result);
}
public int Count(CategorySearchEntity CategorySearchEntity)
{
if (CategorySearchEntity == null)
{
CategorySearchEntity = new CategorySearchEntity();
}
IQueryable <Category> Categories = context.Categories;
Apply(Categories, CategorySearchEntity);
return(Categories.Count());
}
public List <Category> List(CategorySearchEntity CategorySearchEntity)
{
if (CategorySearchEntity == null)
{
CategorySearchEntity = new CategorySearchEntity();
}
IQueryable <Category> Categories = context.Categories
.Include(c => c.Parent)
.Include(c => c.CategoryNames)
.ThenInclude(cn => cn.Language);
Apply(Categories, CategorySearchEntity);
SkipAndTake(Categories, CategorySearchEntity);
return(Categories.ToList());
}
private IQueryable <Category> Apply(IQueryable <Category> Categories, CategorySearchEntity CategorySearchEntity)
{
if (CategorySearchEntity.Id.HasValue)
{
Categories = Categories.Where(wh => wh.Id == CategorySearchEntity.Id.Value);
}
if (!string.IsNullOrEmpty(CategorySearchEntity.Code))
{
Categories = Categories.Where(T => T.Code.ToLower().Contains(CategorySearchEntity.Code.ToLower()));
}
if (CategorySearchEntity.ParentId.HasValue)
{
Categories = Categories.Where(T => T.ParentId.HasValue && T.ParentId.Value == CategorySearchEntity.ParentId.Value);
}
return(Categories);
}
public List <CategoryEntity> SearchCategories(CategorySearchEntity searchObject)
{
//execute
using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance())
{
try
{
db.OpenConnection();
return(db.Resolve <ICategoryDB>().SearchCategories(searchObject));
}
finally
{
db.CloseConnection();
}
}
}
public List <CategoryEntity> SearchCategories(CategorySearchEntity searchObject)
{
List <CategoryEntity> result = null;
string sqlStatement = "SELECT " + Environment.NewLine +
"Category.CategoryId," + Environment.NewLine +
"Category.Description," + Environment.NewLine +
"Category.Deleted" + Environment.NewLine +
"FROM Category " + Environment.NewLine +
"WHERE Deleted=0 " + Environment.NewLine;
if (searchObject.SearchText != null && searchObject.SearchText.Length > 0)
{
sqlStatement += "AND (Description LIKE N'%" + searchObject.SearchText + "%')" + Environment.NewLine;
}
//execute
result = Connection.Query <CategoryEntity>(sqlStatement, null, Transaction).ToList();
return(result);
}
public List <CategoryEntity> SearchCategories(CategorySearchEntity searchObject)
{
return(Factory.Resolve <ICategoryBL>().SearchCategories(searchObject));
}
public List <CategoryEntity> Get(CategorySearchEntity SearchCategoryEntity)
{
return(CategoryService.Get(EmployeeEntity, SearchCategoryEntity));
}
public long Count(CategorySearchEntity SearchCategoryEntity)
{
return(CategoryService.Count(EmployeeEntity, SearchCategoryEntity));
}
public List <CategoryEntity> Get(EmployeeEntity EmployeeEntity, CategorySearchEntity CategorySearchEntity)
{
List <Category> Categories = UnitOfWork.CategoryRepository.List(CategorySearchEntity);
return(Categories.ToList().Select(c => new CategoryEntity(c, c.Parent, c.CategoryNames)).ToList());
}
public int Count(EmployeeEntity EmployeeEntity, CategorySearchEntity CategorySearchEntity)
{
return(UnitOfWork.CategoryRepository.Count(CategorySearchEntity));
}
