Vfrdtyky

I started with ASP.Net Core 2.0, I'm trying to rewrite a method GetAll by search use stored procedure. Here is method search:

public async Task<List<DepartmentTypeDto>> SearchDepartmentType()

{

    EnsureConnectionOpen();



    using (var command = CreateCommand("CM_DEPT_GROUP_Search", CommandType.StoredProcedure))

    {

        using (var dataReader = await command.ExecuteReaderAsync())

        {

                List<DepartmentTypeDto> result = new List<DepartmentTypeDto>();



                while (dataReader.Read())

                {

                    DepartmentTypeDto departmentTypeDto = new DepartmentTypeDto

                    {

                        GROUP_ID = dataReader["GROUP_ID"].ToString(),

                        GROUP_CODE = dataReader["GROUP_CODE"].ToString(),

                        GROUP_NAME = dataReader["GROUP_NAME"].ToString(),

                        NOTES = dataReader["NOTES"].ToString(),

                        RECORD_STATUS = dataReader["RECORD_STATUS"].ToString(),

                        MAKER_ID = dataReader["MAKER_ID"].ToString(),

                        CREATE_DT = Convert.ToDateTime(dataReader["CREATE_DT"]),

                        AUTH_STATUS = dataReader["AUTH_STATUS"].ToString(),

                        CHECKER_ID = dataReader["CHECKER_ID"].ToString(),

                        APPROVE_DT = Convert.ToDateTime(dataReader["APPROVE_DT"]),

                        AUTH_STATUS_NAME = dataReader["AUTH_STATUS_NAME"].ToString(),

                        RECORD_STATUS_NAME = dataReader["RECORD_STATUS_NAME"].ToString()

                    };

                }

                return result;   

            }

        }

}

Here is the service:

public async Task<PagedResultDto<GetDepartmentTypeForView>> GetAll(GetAllDepartmentTypesInput input)

{

     var filteredDepartmentTypes = _departmentTypeRepository.SearchDepartmentType();



     var query = (from o in filteredDepartmentTypes

                  select new GetDepartmentTypeForView() { DepartmentType = ObjectMapper.Map<DepartmentTypeDto>(o) });



     var totalCount = await query.CountAsync();



     var departmentTypes = await query

            .OrderBy(input.Sorting ?? "departmentType.id asc")

            .PageBy(input)

            .ToListAsync();



     return new PagedResultDto<GetDepartmentTypeForView>(totalCount, departmentTypes);

}

But I get an error:

Task<List<DepartmentTypeDto>> does not contain a definition for Select

Does anyone know what I should do? I work on Asp.Net Zero.

I changed my search method

public IQueryable<DepartmentTypeView> SearchDepartmentType(GetAllDepartmentTypesInput input, int top)

    {

        try

        {

            var GROUP_FILTER = input.Filter;

            var GROUP_CODE = input.GROUP_CODEFilter;

            var GROUP_NAME = input.GROUP_NAMEFilter;

            var AUTH_STATUS = input.AUTH_STATUSFilter;



            var result = Context.Query<DepartmentTypeView>().FromSql($"EXEC CM_DEPT_GROUP_Search @p_GROUP_FILTER = {GROUP_FILTER}, @p_GROUP_CODE={GROUP_CODE}, @p_GROUP_NAME={GROUP_NAME}, @p_AUTH_STATUS={AUTH_STATUS}, @p_TOP={top}");



            return result;

        }

        catch

        {

            return null;

        }

    }

and in the service, I call that function

var filteredDepartmentTypes = _departmentTypeRepository.SearchDepartmentType(input,100);

I also create new class to keep the result and don't forget to map that class with DTO class

configuration.CreateMap<DepartmentTypeView, DepartmentTypeDto>();

It works for me.