public List <Products> GetProducts(SortDefinitions sortDefinitions, int startIndex, int pageSize)
{
string sqlText;
var sortText = GetSortText(sortDefinitions);
if (startIndex > -1 && pageSize > 0)
{
sqlText = GetPagedQuery(sortText, startIndex, pageSize);
}
else
{
sqlText = GetProductsSQL();
}
return(_database.CreateSqlStringAccessor <Products>(sqlText).Execute().ToList());
}
private string GetSortText(SortDefinitions sortDefinitions)
{
string sortDefinition;
if (sortDefinitions != null && sortDefinitions.SoftItems.Count > 0)
{
sortDefinition = string.Join(" , ", sortDefinitions.SoftItems.Select(p => string.Format("{0} {1}", p.ColumnName, (p.SortOrder == SortOrder.None)?"":p.SortOrder.ToString())));
sortDefinition = string.Format(" ORDER BY {0}", sortDefinition);
}
else
{
sortDefinition = "ORDER BY " + string.Join(",", KeyColumns);
}
return(sortDefinition);
}
public List <Products> GetAllBySortingAndPaged(SortDefinitions sortDefinitions, int startIndex, int pageSize)
{
return(_productsDao.GetProducts(sortDefinitions, startIndex, pageSize));
}
public List <Categories> GetAllBySorting(SortDefinitions sortDefinitions)
{
return(_categoriesDao.GetCategories(sortDefinitions, -1, 0));
}
public List <Categories> GetAllBySortingAndPaged(SortDefinitions sortDefinitions, int startIndex, int pageSize)
{
return(_categoriesDao.GetCategories(sortDefinitions, startIndex, pageSize));
}
public List <Customers> GetAllBySorting(SortDefinitions sortDefinitions)
{
return(_customersDao.GetCustomers(sortDefinitions, -1, 0));
}
public List <Customers> GetAllBySortingAndPaged(SortDefinitions sortDefinitions, int startIndex, int pageSize)
{
return(_customersDao.GetCustomers(sortDefinitions, startIndex, pageSize));
}
public List <Products> GetAllBySorting(SortDefinitions sortDefinitions)
{
return(_productsDao.GetProducts(sortDefinitions, -1, 0));
}