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