public async Task <MaterialsWithMarkerResult> GetMaterialWithtTestsAsync(MaterialsWithMarkerRequestArgs args) { var result = new MaterialsWithMarkerResult(); DbContext.CommandTimeout = 2 * 60; //time out is set to 2 minutes var data = await DbContext.ExecuteDataSetAsync(DataConstants.PR_RDT_GET_MATERIAL_WITH_TESTS, CommandType.StoredProcedure, args1 => { args1.Add("@TestID", args.TestID); args1.Add("@Page", args.PageNumber); args1.Add("@PageSize", args.PageSize); args1.Add("@Filter", args.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"); } result.Data = new { Columns = data.Tables[1], Data = table0 }; } return(result); }
public async Task <MaterialsWithMarkerResult> GetMaterialsWithDeterminationsForExternalTestAsync(MaterialsWithMarkerRequestArgs request) { var result = new MaterialsWithMarkerResult(); //DbContext.CommandTimeout = 2 * 60; //time out is set to 2 minutes var data = await DbContext.ExecuteDataSetAsync(DataConstants.PR_GET_MATERIAL_WITH_MARKER_FOR_EXTERNAL_TEST, CommandType.StoredProcedure, args => { args.Add("@TestID", request.TestID); //args.Add("@UserID", 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"); } 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>(); }