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)); }