// Method ListForExcel
public List <CategoriesModel> ListForExcel(string keyword, string sortColumn, string sortBy)
{
DataTable dt = DataProvider.Instance.Query(CategoriesQuerys.ListForExcel(keyword, sortColumn, sortBy));
return(HelperDao.GenerateList <CategoriesModel>(dt));
}
// Method List
public List <CategoriesModel> List(bool?status = null)
{
DataTable dt = DataProvider.Instance.Query(CategoriesQuerys.List(status));
return(HelperDao.GenerateList <CategoriesModel>(dt));
}