public async Task <Abp.Application.Services.Dto.ListResultDto <CategoryReportOutputDto> > GetCategoryReport(GetCategoryReportInput input)
{
return(await _reportRepository.GetCategoryReport(input));
}
public async Task <ListResultDto <CategoryReportOutputDto> > GetCategoryReport(GetCategoryReportInput input)
{
try
{
// TODO
//var creatorUserIdParameter = new SqlParameter("@creatorUserId", input.UserId);
//var startDateParameter = new SqlParameter("@startDate", input.StartDate);
//var endDateParameter = new SqlParameter("@endDate", input.EndDate);
//var output = await Context.Database.SqlQuery<CategoryReportOutputDto>("exec GetCategoryReport @creatorUserId, @startDate, @endDate", creatorUserIdParameter, startDateParameter, endDateParameter).ToListAsync();
return(new ListResultDto <CategoryReportOutputDto>());
}
catch (Exception ex)
{
// TODO : log
return(null);
}
}
public async Task <ListResultDto <CategoryReportListItem> > GetCategoryReport(GetCategoryReportInput input)
{
await using var dbConn = new SqlConnection(Context.Database.GetDbConnection().ConnectionString);
dbConn.Open();
var output = await dbConn.QueryAsync <CategoryReportListItem>("GetCategoryReport", new { creatorUserId = input.UserId, startDate = input.StartDate, endDate = input.EndDate }, commandType : CommandType.StoredProcedure);
return(new ListResultDto <CategoryReportListItem>(output.ToList()));
}
