public SubcontractProfileLocationOutput GetListLocation(SearchSubcontractProfileLocationQuery data) { _logger.LogInformation($"LocationController::GetALL"); SubcontractProfileLocationOutput Output = new SubcontractProfileLocationOutput(); var entities = _service.SearchListLocation(data).Result.ToList(); if (entities == null) { _logger.LogWarning($"LocationController::", "GetALL NOT FOUND"); return(null); } else { Output.ListResult = entities; Output.filteredResultsCount = Output.ListResult.Count(); Output.TotalResultsCount = Output.ListResult[0].row_total; } return(Output); }
public async Task <IEnumerable <SubcontractProfileLocationList> > SearchListLocation(SearchSubcontractProfileLocationQuery data) { var p = new DynamicParameters(); p.Add("@company_name_th", data.company_name_th); p.Add("@company_name_en", data.company_name_en); p.Add("@company_alias", data.company_alias); p.Add("@company_code", data.company_code); p.Add("@location_name_th", data.location_name_th); p.Add("@location_name_en", data.location_name_en); p.Add("@location_code", data.location_code); p.Add("@distribution_channel", data.distribution_channel); p.Add("@channel_sale_group", data.channel_sale_group); p.Add("@page_index", data.page_index); p.Add("@page_size", data.page_size); p.Add("@sort_col", data.sort_col); p.Add("@sort_dir", data.sort_dir); var entity = await _dbContext.Connection.QueryAsync <SubcontractProfile.WebApi.Services.Model.SubcontractProfileLocationList> ("uspSubcontractProfileLocation_searchListLocation", p, commandType : CommandType.StoredProcedure); return(entity); }