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