public async Task <IHttpActionResult> GetData([FromBody] ExcelDataRequestArgs args)
{
var ds = await _s2SService.GetDataAsync(args);
var rs = new
{
Data = ds,
args.TotalRows
};
return(Ok(rs));
}
public async Task <ExcelDataResult> GetDataAsync(ExcelDataRequestArgs requestArgs)
{
var result = new ExcelDataResult();
var data = await DbContext.ExecuteDataSetAsync(DataConstants.PR_GET_DATA, CommandType.StoredProcedure,
args1 =>
{
args1.Add("@TestID", requestArgs.TestID);
//args1.Add("@User", userContext.GetContext().FullName);
args1.Add("@Page", requestArgs.PageNumber);
args1.Add("@PageSize", requestArgs.PageSize);
args1.Add("@FilterQuery", requestArgs.ToFilterString());
});
if (data.Tables.Count == 2)
{
result.Success = true;
var table0 = data.Tables[0];
if (table0.Columns.Contains("TotalRows"))
{
if (table0.Rows.Count > 0)
{
result.Total = table0.Rows[0]["TotalRows"].ToInt32();
}
table0.Columns.Remove("TotalRows");
}
if (table0.Columns.Contains("Total"))
{
if (table0.Rows.Count > 0)
{
result.TotalCount = table0.Rows[0]["Total"].ToInt32();
}
table0.Columns.Remove("Total");
}
result.DataResult = new ExcelData
{
Columns = data.Tables[1],
Data = table0
};
}
else
{
result.Success = false;
result.Errors.Add("Problem while fetching data.");
}
return(result);
}
public Task <ExcelDataResult> GetDataAsync(ExcelDataRequestArgs requestArgs)
{
return(_cNTRepository.GetDataAsync(requestArgs));
}
public async Task <ExcelDataResult> GetDataAsync(ExcelDataRequestArgs requestArgs)
{
return(await excelDataRepository.GetDataAsync(requestArgs));
}
public async Task <IHttpActionResult> GetData([FromBody] ExcelDataRequestArgs args)
{
var result = await _rdtService.GetDataAsync(args);
return(Ok(result));
}
