public async Task <IHttpActionResult> GetTraitDeterminationResultRDT([FromBody] TraitDeterminationResultRequestArgs args) { var cropCodes = await _masterService.GetUserCropCodesAsync(User); args.Crops = string.Join(",", cropCodes); var items = await service.GetTraitDeterminationResultRDTAsync(args); return(Ok(new { args.TotalRows, Data = items })); }
public async Task <DataTable> SaveTraitDeterminationResultRDTAsync(RDTSaveTraitDeterminationResultRequestArgs requestArgs) { await repository.SaveTraitDeterminationResultRDTAsync(requestArgs); var args = new TraitDeterminationResultRequestArgs { Crops = requestArgs.Crops, Filter = requestArgs.Filter, PageNumber = requestArgs.PageNumber, PageSize = requestArgs.PageSize }; var dt = await GetTraitDeterminationResultRDTAsync(args); //return totalrows back to controller requestArgs.TotalRows = args.TotalRows; return(dt); }
public async Task <DataTable> GetTraitDeterminationResultAsync(TraitDeterminationResultRequestArgs requestArgs) { var ds = await DbContext.ExecuteDataSetAsync(DataConstants.PR_GET_TRAIT_DETERMINATION_RESULT, CommandType.StoredProcedure, args => { args.Add("@PageSize", requestArgs.PageSize); args.Add("@PageNumber", requestArgs.PageNumber); args.Add("@Crops", requestArgs.Crops); args.Add("@Filter", requestArgs.ToFilterString()); }); var dt = ds.Tables[0]; if (dt.Rows.Count > 0) { requestArgs.TotalRows = dt.Rows[0]["TotalRows"].ToInt32(); } dt.Columns.Remove("TotalRows"); return(dt); }
public Task <DataTable> GetTraitDeterminationResultRDTAsync(TraitDeterminationResultRequestArgs args) { return(repository.GetTraitDeterminationResultRDTAsync(args)); }