// 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));
        }