public async Task <DocumentGetListResponse> GetList(DocumentGetListRequest request)
{
try
{
using (IDbConnection connection = new SqlConnection(_configuration.GetValue <string>("ConnectionStrings:DefaultConnection")))
{
List <DocumentGetList> lstData = new List <DocumentGetList>();
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Name", request.Name ?? "");
parameters.Add("@Code", request.Code ?? "");
parameters.Add("@CategoryIds", request.CategoryIds ?? "0");
parameters.Add("@IsPublish", request.IsPublish);
parameters.Add("@IssuedDate", request.IssuedDate ?? "");
parameters.Add("@CreatedUser", request.CreatedUser);
parameters.Add("@Field", request.Field);
parameters.Add("@Source", request.Source);
parameters.Add("@Type", request.Type);
parameters.Add("@PortalId", request.PortalId);
parameters.Add("@LanguageId", request.Language);
parameters.Add("@PageSize", request.PageSize);
parameters.Add("@PageIndex", request.PageIndex);
parameters.Add("@Status", request.Status);
parameters.Add("@IsRole", request.IsRole ?? "-1");
await Task.Run(() =>
lstData = connection.Query <DocumentGetList>("Docs_SearchAdvance", parameters, null, true, null, CommandType.StoredProcedure).AsList <DocumentGetList>()
);
int totalRecords = lstData.Count > 0 ? lstData[0].TotalRecords : 0;
if (lstData != null)
{
foreach (var item in lstData)
{
parameters = new DynamicParameters();
parameters.Add("@DocId", item.Id);
await Task.Run(() =>
item.DocsFiles = connection.Query <DocsFile>("DocsFiles_GetByDocId", parameters, null, true, null, CommandType.StoredProcedure).AsList <DocsFile>()
);
}
}
return(new DocumentGetListResponse
{
Status = ResponseStatus.Success,
Message = ResponseStatus.Success.ToString(),
LstData = lstData,
TotalRecords = totalRecords,
});
}
}
catch (Exception ex)
{
return(new DocumentGetListResponse
{
Status = ResponseStatus.Faile,
Message = ex.Message,
});
}
}
public async Task <DocumentGetListResponse> GetList([FromQuery] DocumentGetListRequest request)
{
return(await _businessLogic.GetList(request));
}
