public async Task <ServiceResponse> GetAll(CommonSpParameterInputDto input)
{
var dataCount = 0;
var sqlParams = new List <SqlParameter>
{
new SqlParameter("@PageNo", (input.PageNo + 1)),
new SqlParameter("@PageSize", input.MaxResultCount),
new SqlParameter("@SortColumn", input.Sorting),
new SqlParameter("@Filter", input.Filter),
new SqlParameter("@CategoryNameFilter", input.CategoryNameFilter),
//new SqlParameter("@StatusFilter", input.IsActiveFilter)
};
var spList = new List <CategoryDto>();
var dataset = await _storedProcedureRepository.GetQueryDatatableAsync(StoredProcedureConstants.SP_GetAllCategoriesForList, sqlParams.ToArray());
spList = _storedProcedureRepository.CreateListFromTable <CategoryDto>(dataset.Tables[0]);
if (spList.Count != 0)
{
dataCount = spList.FirstOrDefault().TotalCount;
}
return(new ServiceResponse {
status = 1, isSuccess = true, message = "Category data",
jsonObj = new { data = spList, dataCount = dataCount }
});
}
public async Task <ServiceResponse> GetCategoryList(CommonSpParameterInputDto input)
{
return(await _categoryRepository.GetAll(input));
}
