public async Task <DataWithMarkerResult> GetDataWithDeterminationsAsync(DataWithMarkerRequestArgs request) { var result = new DataWithMarkerResult(); DbContext.CommandTimeout = 120; var data = await DbContext.ExecuteDataSetAsync(DataConstants.PR_GET_DATA_WITH_MARKERS, CommandType.StoredProcedure, args => { args.Add("@TestID", request.TestID); //args.Add("@User", userContext.GetContext().FullName); args.Add("@Page", request.PageNumber); args.Add("@PageSize", request.PageSize); args.Add("@Filter", request.ToFilterString()); }); if (data.Tables.Count == 2) { 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.Data = new { Columns = data.Tables[1], Data = table0 }; } return(result); }
public async Task <DataWithMarkerResult> GetSelectedDataAsync(AddMaterialRequestArgs requestArgs) { var result = new DataWithMarkerResult(); var data = await DbContext.ExecuteDataSetAsync(DataConstants.PR_GET_SELECTED_DATA, CommandType.StoredProcedure, args => { args.Add("@TestID", requestArgs.TestID); args.Add("@Page", requestArgs.PageNumber); args.Add("@PageSize", requestArgs.PageSize); args.Add("@FilterQuery", requestArgs.ToFilterString()); }); if (data.Tables.Count == 2) { 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.Data = new { Columns = data.Tables[1], Data = table0 }; } return(result); }
public DeterminationServiceUnitTests() { builder = new ContainerBuilder(); builder.RegisterModule <AutofacModule>(); IEnumerable <DeterminationResult> determinationlists = new List <DeterminationResult>() { new DeterminationResult { DeterminationID = 1, DeterminationName = "Test1", DeterminationAlias = "T1", ColumnLabel = "Col1" }, new DeterminationResult { DeterminationID = 2, DeterminationName = "Test2", DeterminationAlias = "T2", ColumnLabel = "Col2" } }; determinationRequestArgs = new DeterminationRequestArgs { CropCode = "TO", TestID = 1, TestTypeID = 1 }; dataWithMarkerRequestArgs = new Entities.Args.DataWithMarkerRequestArgs { TestID = 1, PageNumber = 1, PageSize = 100 }; materialsWithMarkerRequestArgs = new Entities.Args.MaterialsWithMarkerRequestArgs { TestID = 1, PageNumber = 1, PageSize = 100 }; externalDeterminationRequestArgs = new Entities.Args.ExternalDeterminationRequestArgs { CropCode = "TO", TestTypeID = 1 }; var dataWithMarker = new DataWithMarkerResult { Data = new DataTable(), Total = 5 }; var materialWithMarker = new MaterialsWithMarkerResult { Total = 5, Data = new DataTable() }; var determinationRepo = A.Fake <IDeterminationRepository>(); A.CallTo(() => determinationRepo.GetDeterminationsAsync(determinationRequestArgs)).Returns(determinationlists); A.CallTo(() => determinationRepo.GetDataWithDeterminationsAsync(dataWithMarkerRequestArgs)).Returns(dataWithMarker); A.CallTo(() => determinationRepo.GetMaterialsWithDeterminationsAsync(materialsWithMarkerRequestArgs)).Returns(materialWithMarker); A.CallTo(() => determinationRepo.GetDeterminationsForExternalTestsAsync(externalDeterminationRequestArgs)).Returns(determinationlists); A.CallTo(() => determinationRepo.GetMaterialsWithDeterminationsForExternalTestAsync(materialsWithMarkerRequestArgs)).Returns(materialWithMarker); builder.RegisterInstance(determinationRepo).As <IDeterminationRepository>().SingleInstance(); var container = builder.Build(); _determinationService = container.Resolve <IDeterminationService>(); }