public async Task <NewGetListByCategoryIdResponse> NewGetListByCategoryId(NewGetListByCategoryIdRequest request)
{
try
{
using (IDbConnection connection = new SqlConnection(_configuration.GetValue <string>("ConnectionStrings:DefaultConnection")))
{
List <NewObject> lstData = new List <NewObject>();
DynamicParameters parameters = new DynamicParameters();
parameters.Add("subtractIds", request.SubtractIds);
parameters.Add("CategoryId", request.CategoryId);
parameters.Add("portalId", request.PortalId);
parameters.Add("LanguageId", request.Language);
parameters.Add("PageIndex", request.PageIndex);
parameters.Add("PageSize", request.PageSize);
parameters.Add("isImage", request.IsImage);
await Task.Run(() =>
lstData = connection.Query <NewObject>("News_News_ShowSelect_Index", parameters, null, true, null, CommandType.StoredProcedure).AsList <NewObject>()
);
int totalRecords = lstData.Count > 0 ? lstData[0].TotalRecords : 0;
return(new NewGetListByCategoryIdResponse
{
Status = ResponseStatus.Success,
Message = ResponseStatus.Success.ToString(),
LstData = lstData,
TotalRecords = totalRecords,
});
}
}
catch (Exception ex)
{
return(new NewGetListByCategoryIdResponse
{
Status = ResponseStatus.Faile,
Message = ex.Message,
});
}
}
public async Task <NewGetListByCategoryIdResponse> NewGetListByCategoryId([FromQuery] NewGetListByCategoryIdRequest request)
{
return(await _businessLogic.NewGetListByCategoryId(request));
}
