public static void createWithSimpleEntityMaximum(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string DataAreaId, string customerAccount) { Stopwatch sw = new Stopwatch(); sw.Start(); DataServiceCollection <SalesOrderHeaderV2EntityOnlySalesTable> SalesOrderCollection = new DataServiceCollection <SalesOrderHeaderV2EntityOnlySalesTable>(context); SalesOrderHeaderV2EntityOnlySalesTable SalesOrderHeaderV2EntityOnlySalesTable = new SalesOrderHeaderV2EntityOnlySalesTable(); SalesOrderCollection.Add(SalesOrderHeaderV2EntityOnlySalesTable); // Required Fields SalesOrderHeaderV2EntityOnlySalesTable.OrderingCustomerAccountNumber = customerAccount; SalesOrderHeaderV2EntityOnlySalesTable.InvoiceCustomerAccountNumber = customerAccount; SalesOrderHeaderV2EntityOnlySalesTable.dataAreaId = DataAreaId; SalesOrderHeaderV2EntityOnlySalesTable.CurrencyCode = "USD"; SalesOrderHeaderV2EntityOnlySalesTable.LanguageId = "en-us"; //SalesOrderHeaderV2EntityOnlySalesTable.CustGroup = "30"; //SalesOrderHeaderV2EntityOnlySalesTable.ShippingDateRequested = DateTime.UtcNow; // Optional Fields SalesOrderHeaderV2EntityOnlySalesTable.SalesOrderPromisingMethod = SalesDeliveryDateControlType.CTP; SalesOrderHeaderV2EntityOnlySalesTable.DeliveryModeCode = "10"; SalesOrderHeaderV2EntityOnlySalesTable.DeliveryTermsCode = "FOB"; SalesOrderHeaderV2EntityOnlySalesTable.PaymentTermsName = "Net10"; SalesOrderHeaderV2EntityOnlySalesTable.CustomerPaymentMethodName = "Check"; SalesOrderHeaderV2EntityOnlySalesTable.Email = "*****@*****.**"; SalesOrderHeaderV2EntityOnlySalesTable.CustomerPostingProfileId = "GEN"; SalesOrderHeaderV2EntityOnlySalesTable.SalesOrderName = "Test Sales Order Id"; SalesOrderHeaderV2EntityOnlySalesTable.SalesOrderOriginCode = "PHONE"; SalesOrderHeaderV2EntityOnlySalesTable.SalesOrderPoolId = "03"; SalesOrderHeaderV2EntityOnlySalesTable.SalesTaxGroupCode = "CA"; SalesOrderHeaderV2EntityOnlySalesTable.TaxExemptNumber = "35-12345"; context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset); sw.Stop(); Console.WriteLine("Created Sales Order " + SalesOrderHeaderV2EntityOnlySalesTable.SalesOrderNumber); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void updateWithSimpleEntityMaximum(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string DataAreaId, string SalesOrderNumber) { Stopwatch sw = new Stopwatch(); Entity = "SalesOrderHeadersV2EntityOnlySalesTable"; context.SalesOrderHeadersV2EntityOnlySalesTable.FirstOrDefault(); var SalesOrderHeadersV2EntityOnlySalesTable = context.SalesOrderHeadersV2EntityOnlySalesTable.Where(x => x.SalesOrderNumber == SalesOrderNumber && x.dataAreaId == DataAreaId).First(); if (SalesOrderHeadersV2EntityOnlySalesTable.SalesOrderNumber != null) { DataServiceCollection <SalesOrderHeaderV2EntityOnlySalesTable> SalesOrderCollection = new DataServiceCollection <SalesOrderHeaderV2EntityOnlySalesTable>(context); string salesURL = SalesOrderHeadersV2EntityOnlySalesTable.URL; string customerReference = SalesOrderHeadersV2EntityOnlySalesTable.CustomersOrderReference; string DeliveryAddressName = SalesOrderHeadersV2EntityOnlySalesTable.DeliveryAddressName; //string DeliveryAddressDescription = SalesOrderHeadersV2EntityOnlySalesTable.DeliveryAddressDescription; string SalesorderName = SalesOrderHeadersV2EntityOnlySalesTable.SalesOrderName; // replace whatever is there with this trash salesURL = "http://www." + Guid.NewGuid().ToString() + ".com"; customerReference = Guid.NewGuid().ToString(); DeliveryAddressName = Guid.NewGuid().ToString(); //DeliveryAddressDescription = Guid.NewGuid().ToString(); SalesorderName = Guid.NewGuid().ToString(); sw.Start(); SalesOrderCollection.Add(SalesOrderHeadersV2EntityOnlySalesTable); SalesOrderHeadersV2EntityOnlySalesTable.URL = salesURL; SalesOrderHeadersV2EntityOnlySalesTable.CustomersOrderReference = customerReference; SalesOrderHeadersV2EntityOnlySalesTable.DeliveryAddressName = DeliveryAddressName; //SalesOrderHeadersV2EntityOnlySalesTable.DeliveryAddressDescription = DeliveryAddressDescription; SalesOrderHeadersV2EntityOnlySalesTable.SalesOrderName = SalesorderName; context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); } }
public static void createAndDeleteWithSimpleEntity(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string DataAreaId, string customerAccount) { Stopwatch sw = new Stopwatch(); string SalesOrderNumber; Entity = "SalesOrderHeadersV2EntityOnlySalesTable"; DataServiceCollection <SalesOrderHeaderV2EntityOnlySalesTable> SalesOrderCollection = new DataServiceCollection <SalesOrderHeaderV2EntityOnlySalesTable>(context); SalesOrderHeaderV2EntityOnlySalesTable SalesOrderHeaderV2EntityOnlySalesTable = new SalesOrderHeaderV2EntityOnlySalesTable(); SalesOrderCollection.Add(SalesOrderHeaderV2EntityOnlySalesTable); //Required Fields SalesOrderHeaderV2EntityOnlySalesTable.OrderingCustomerAccountNumber = customerAccount; SalesOrderHeaderV2EntityOnlySalesTable.InvoiceCustomerAccountNumber = customerAccount; SalesOrderHeaderV2EntityOnlySalesTable.dataAreaId = DataAreaId; SalesOrderHeaderV2EntityOnlySalesTable.CurrencyCode = "USD"; SalesOrderHeaderV2EntityOnlySalesTable.LanguageId = "en-us"; context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset); SalesOrderNumber = SalesOrderHeaderV2EntityOnlySalesTable.SalesOrderNumber; SalesOrderHeaderV2EntityOnlySalesTable = null; context.SalesOrderHeadersV2EntityOnlySalesTable.FirstOrDefault(); sw.Start(); var SalesOrderHeadersV2EntityOnlySalesTable = context.SalesOrderHeadersV2EntityOnlySalesTable.Where(x => x.SalesOrderNumber == SalesOrderNumber && x.dataAreaId == DataAreaId).First(); context.DeleteObject(SalesOrderHeadersV2EntityOnlySalesTable); context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset); sw.Stop(); Console.WriteLine("Created and Deleted Sales Order " + SalesOrderNumber); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public WorkloadBuilder() { var jobs = new List <IJob>(); _workload = new TestWorkload { Id = Guid.NewGuid(), Capacity = Random.Next(1, 101), Jobs = jobs, Name = Guid.NewGuid().ToString() }; for (int i = 0; i < Random.Next(1, 5); i++) { jobs.Add(new JobBuilder().WithWorkloadId(_workload.Id).Build()); } }
public void SetUp() { _mutationProbability = 1; _crossoverProbability = 1; _minPopulationSize = 2; _maxPopulationSize = 4; _mutationOperator = A.Fake <IMutation>(); _crossoverOperator = A.Fake <ICrossover>(); _fitnessEvaluator = A.Fake <IFitnessEvaluator <TestWorkload> >(); _initialPopulationCreator = A.Fake <IInitialPopulationCreator>(); _terminationCondition = A.Fake <ITerminationCondition <TestState> >(); _selectionStrategy = A.Fake <ISelectionStrategy>(); _reinsertionStrategy = A.Fake <IReinsertionStrategy>(); _deploymentChromosomeFactory = A.Fake <IDeploymentChromosomeFactory>(); _currentState = new TestState(); _workload = new TestWorkload(); _randomProvider = new DefaultRandomProvider(); }
public static void updateWithCompoundEntityMinimum(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string DataAreaId, string SalesOrderNumber) { Stopwatch sw = new Stopwatch(); context.SalesOrderHeadersV2.FirstOrDefault(); var SalesOrderHeaderV2 = context.SalesOrderHeadersV2.Where(x => x.SalesOrderNumber == SalesOrderNumber && x.dataAreaId == DataAreaId).First(); if (SalesOrderHeaderV2.SalesOrderNumber != null) { DataServiceCollection <SalesOrderHeaderV2> SalesOrderCollection = new DataServiceCollection <SalesOrderHeaderV2>(context); string salesURL = SalesOrderHeaderV2.URL; // replace whatever is there with this trash salesURL = "http://www." + Guid.NewGuid().ToString() + ".com"; sw.Start(); SalesOrderCollection.Add(SalesOrderHeaderV2); SalesOrderHeaderV2.URL = salesURL; context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); } }
public static void createWithCompoundEntityMinimum(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string DataAreaId, string customerAccount) { Stopwatch sw = new Stopwatch(); sw.Start(); DataServiceCollection <SalesOrderHeaderV2> SalesOrderCollection = new DataServiceCollection <SalesOrderHeaderV2>(context); SalesOrderHeaderV2 salesOrderHeaderV2 = new SalesOrderHeaderV2(); SalesOrderCollection.Add(salesOrderHeaderV2); // Required Fields salesOrderHeaderV2.OrderingCustomerAccountNumber = customerAccount; salesOrderHeaderV2.InvoiceCustomerAccountNumber = customerAccount; salesOrderHeaderV2.dataAreaId = DataAreaId; salesOrderHeaderV2.CurrencyCode = "USD"; salesOrderHeaderV2.LanguageId = "en-us"; context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset); sw.Stop(); Console.WriteLine("Created Sales Order " + salesOrderHeaderV2.SalesOrderNumber); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runOneRead(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string SalesOrderNumber, string DataAreaId) { int tryCount = 0; Stopwatch sw = new Stopwatch(); sw.Start(); while (true) { try { tryCount++; AAXSalesTableReadOnly AAXSalesTableReadOnly = context.AAXSalesTablesReadOnly.Where(x => x.SalesId == SalesOrderNumber && x.dataAreaId == DataAreaId).First(); break; } catch (Exception e) { if (tryCount >= 3) { throw (e); } sw.Reset(); sw.Start(); } } sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runReadsWithSelect(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string DataAreaId, string customerAccount, int count) { Stopwatch sw = new Stopwatch(); sw.Start(); context.AAXSalesTablesReadOnly.Where(x => x.dataAreaId == DataAreaId && x.CustAccount == customerAccount) .Select(x => new { x.SalesId, x.CustAccount, x.InvoiceAccount, x.SalesStatus, x.dataAreaId }) .Take(count) .ToList(); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runOneRead(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string SalesOrderNumber, string DataAreaId) { Stopwatch sw = new Stopwatch(); sw.Start(); AAXSalesTableReadOnly AAXSalesTableReadOnly = context.AAXSalesTablesReadOnly.Where(x => x.SalesId == SalesOrderNumber && x.dataAreaId == DataAreaId).First(); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runReads(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string DataAreaId, string customerAccount, int count) { Stopwatch sw = new Stopwatch(); sw.Start(); context.SalesOrderHeadersV2EntityOnlySalesTablePostLoadExtended.Where(x => x.dataAreaId == DataAreaId && x.OrderingCustomerAccountNumber == customerAccount).Take(count).ToList(); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runReadsWithOrderByDescOnSalesOrderProcessingStatus(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string DataAreaId, int count) { Stopwatch sw = new Stopwatch(); sw.Start(); context.SalesOrderHeadersV2.Where(x => x.dataAreaId == DataAreaId).OrderByDescending(x => x.SalesOrderProcessingStatus).Take(count).ToList(); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runGetAllPages(Resources context, string filePath, TestType testType, TestWorkload testWorkload) { Stopwatch sw = new Stopwatch(); StreamWriter stream = File.AppendText(filePath); // DataServiceQueryContinuation<T> contains the next link DataServiceQueryContinuation <SalesOrderLine> nextLink = null; // Get the first page sw.Start(); var response = context.SalesOrderLines.Execute() as QueryOperationResponse <SalesOrderLine>; do { if (nextLink != null) { sw.Start(); response = context.Execute <SalesOrderLine>(nextLink) as QueryOperationResponse <SalesOrderLine>; sw.Stop(); } else { sw.Stop(); } stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); //forced loop to enumerate each item in the response foreach (SalesOrderLine salesLine in response) { } } // Loop if there is a next link while ((nextLink = response.GetContinuation()) != null); stream.Flush(); stream.Close(); }
public static void runGetAllPagesSkipTake(Resources context, string filePath, TestType testType, TestWorkload testWorkload) { Stopwatch sw = new Stopwatch(); StreamWriter stream = File.AppendText(filePath); int skip = 0; int take = 10000; //get count of records without getting any other data int numberOfRecords = context.SalesOrderLines.Take(0).Count(); sw.Start(); for (skip = 0; skip <= numberOfRecords; skip += take) { sw.Start(); context.SalesOrderLines.Skip(skip).Take(take).ToList(); sw.Stop(); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); } stream.Flush(); stream.Close(); }
public static void runOneCustCreatedDateIdxRead(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string CustAccount, DateTimeOffset CreatedDateTime, string DataAreaId) { Stopwatch sw = new Stopwatch(); sw.Start(); SalesOrderHeaderV2 SalesOrderHeaderV2 = context.SalesOrderHeadersV2.Where(x => x.OrderingCustomerAccountNumber == CustAccount) .Where(x => x.OrderCreationDateTime >= CreatedDateTime.AddDays(-1)) .Where(x => x.dataAreaId == DataAreaId).First(); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runOneStatusCustAccountIdxRead(Resources context, string filePath, TestType testType, TestWorkload testWorkload, int SalesStatus, string CustAccount, string DataAreaId) { Stopwatch sw = new Stopwatch(); sw.Start(); SalesOrderHeaderV2 SalesOrderHeaderV2 = context.SalesOrderHeadersV2.Where(x => x.SalesOrderStatus == (Microsoft.Dynamics.DataEntities.SalesStatus)SalesStatus) .Where(x => x.OrderingCustomerAccountNumber == CustAccount) .Where(x => x.dataAreaId == DataAreaId).First(); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runReadsOnInventLocationId(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string DataAreaId, string InventLocationId, int count) { Stopwatch sw = new Stopwatch(); sw.Start(); context.SalesOrderHeadersV2.Where(x => x.dataAreaId == DataAreaId && x.DefaultShippingWarehouseId == InventLocationId).Take(count).ToList(); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runOneCustIdxRead(Resources context, string filePath, TestType testType, TestWorkload testWorkload, String CustAccount, string SalesOrderNumber, String PurchOrderFormNum, string DataAreaId) { Stopwatch sw = new Stopwatch(); sw.Start(); SalesOrderHeaderV2 SalesOrderHeaderV2 = context.SalesOrderHeadersV2.Where(x => x.SalesOrderNumber == SalesOrderNumber) .Where(x => x.OrderingCustomerAccountNumber == CustAccount) .Where(x => x.CustomersOrderReference == PurchOrderFormNum) .Where(x => x.dataAreaId == DataAreaId).First(); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void createWithCompoundEntityMaximum(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string DataAreaId, string customerAccount) { Stopwatch sw = new Stopwatch(); sw.Start(); DataServiceCollection <SalesOrderHeaderV2> SalesOrderCollection = new DataServiceCollection <SalesOrderHeaderV2>(context); SalesOrderHeaderV2 salesOrderHeaderV2 = new SalesOrderHeaderV2(); SalesOrderCollection.Add(salesOrderHeaderV2); // Required Fields salesOrderHeaderV2.OrderingCustomerAccountNumber = customerAccount; salesOrderHeaderV2.InvoiceCustomerAccountNumber = customerAccount; salesOrderHeaderV2.dataAreaId = DataAreaId; salesOrderHeaderV2.CurrencyCode = "USD"; salesOrderHeaderV2.LanguageId = "en-us"; // Optional Fields salesOrderHeaderV2.SalesOrderPromisingMethod = SalesDeliveryDateControlType.CTP; salesOrderHeaderV2.DeliveryModeCode = "10"; salesOrderHeaderV2.DeliveryTermsCode = "FOB"; salesOrderHeaderV2.PaymentTermsName = "Net10"; salesOrderHeaderV2.CustomerPaymentMethodName = "Check"; salesOrderHeaderV2.Email = "*****@*****.**"; salesOrderHeaderV2.CustomerPostingProfileId = "GEN"; salesOrderHeaderV2.SalesOrderName = "Test Sales Order Id"; salesOrderHeaderV2.SalesOrderOriginCode = "PHONE"; salesOrderHeaderV2.SalesOrderPoolId = "03"; salesOrderHeaderV2.SalesTaxGroupCode = "CA"; salesOrderHeaderV2.TaxExemptNumber = "35-12345"; salesOrderHeaderV2.OrderResponsiblePersonnelNumber = "000002"; salesOrderHeaderV2.OrderTakerPersonnelNumber = "000002"; salesOrderHeaderV2.DefaultLedgerDimensionDisplayValue = "001--"; salesOrderHeaderV2.DeliveryAddressCity = "Detroit"; salesOrderHeaderV2.DeliveryAddressCountryRegionISOCode = "USA"; salesOrderHeaderV2.DeliveryAddressDescription = "Delivery"; salesOrderHeaderV2.DeliveryAddressName = "Delivery"; salesOrderHeaderV2.DeliveryAddressStateId = "MI"; salesOrderHeaderV2.DeliveryAddressStreet = "123 Main St"; salesOrderHeaderV2.DeliveryAddressZipCode = "01234"; context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset); sw.Stop(); Console.WriteLine("Created Sales Order " + salesOrderHeaderV2.SalesOrderNumber); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runReads(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string DataAreaId, string customerAccount, int count) { int tryCount = 0; Stopwatch sw = new Stopwatch(); sw.Start(); while (true) { try { tryCount++; context.AAXSalesTablesReadOnly.Where(x => x.dataAreaId == DataAreaId && x.CustAccount == customerAccount).Take(count).ToList(); break; } catch (Exception e) { if (tryCount >= 3) { throw (e); } sw.Reset(); sw.Start(); } } sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
/* * public static void runOneReadOnSalesRecId(Resources context, string filePath, TestType testType, TestWorkload testWorkload, Int64 SalesRecId, string DataAreaId) * { * Stopwatch sw = new Stopwatch(); * * sw.Start(); * * SalesOrderHeaderV2 SalesOrderHeaderV2 = context.SalesOrderHeadersV2.Where(x => x.RecId == SalesRecId && x.dataAreaId == DataAreaId).First(); * * sw.Stop(); * * StreamWriter stream = File.AppendText(filePath); * * stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); * stream.Flush(); * stream.Close(); * * } */ public static void runOneReadOnInventSiteId(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string InventSiteId, string DataAreaId) { Stopwatch sw = new Stopwatch(); sw.Start(); SalesOrderHeaderV2 SalesOrderHeaderV2 = context.SalesOrderHeadersV2.Where(x => x.DefaultShippingSiteId == InventSiteId && x.dataAreaId == DataAreaId).First(); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runReadWithSelect(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string SalesOrderNumber, string DataAreaId) { Stopwatch sw = new Stopwatch(); sw.Start(); //approximately what is shown in the SalesTableListPage form //Order Type, Channel not available, Release Status not available //declined on SalesTaker var AAXSalesTablesReadOnly = context.AAXSalesTablesReadOnly.Where(x => x.SalesId == SalesOrderNumber && x.dataAreaId == DataAreaId) .Select(x => new { x.SalesId, x.CustAccount, x.InvoiceAccount, x.SalesStatus, x.dataAreaId }) .First(); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runOneSalesTypeIdxRead(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string SalesId, string DataAreaId) { Stopwatch sw = new Stopwatch(); sw.Start(); //entity already has a filter on salesType of Sales SalesOrderHeaderV2 SalesOrderHeaderV2 = context.SalesOrderHeadersV2.Where(x => x.SalesOrderNumber == SalesId) .Where(x => x.dataAreaId == DataAreaId).First(); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runOneCombinedRead(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string SalesOrderNumber, string DataAreaId) { Stopwatch sw = new Stopwatch(); Entity = "SalesOrderLineV2+SalesOrderHeaderV2"; sw.Start(); SalesOrderLine SalesOrderLine = context.SalesOrderLines.Where(x => x.SalesOrderNumber == SalesOrderNumber && x.dataAreaId == DataAreaId).First(); SalesOrderHeaderV2 SalesOrderHeaderV2 = context.SalesOrderHeadersV2.Where(x => x.SalesOrderNumber == SalesOrderNumber && x.dataAreaId == DataAreaId).First(); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runOneGarbageRead(Resources context, string filePath, TestType testType, TestWorkload testWorkload, SalesValues salesValues) { Stopwatch sw = new Stopwatch(); sw.Start(); SalesOrderHeaderV2 SalesOrderHeaderV2 = context.SalesOrderHeadersV2.Where(x => x.SalesOrderNumber == salesValues.SalesId) .Where(x => x.OrderingCustomerAccountNumber == salesValues.CustAccount) .Where(x => x.CustomersOrderReference == salesValues.PurchOrderFormNum) .Where(x => x.SalesOrderStatus == (Microsoft.Dynamics.DataEntities.SalesStatus)salesValues.SalesStatus) //.Where(x => x.OrderCreationDateTime >= salesValues.CreatedDateTime.AddDays(-1)) .Where(x => x.Email == salesValues.Email) .Where(x => x.DefaultShippingSiteId == salesValues.InventSiteId) .Where(x => x.DefaultShippingWarehouseId == salesValues.InventLocationid) .Where(x => x.SalesOrderName == salesValues.SalesName) .Where(x => x.dataAreaId == salesValues.DataAreaId).First(); sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static void runOneRead(Resources context, string filePath, TestType testType, TestWorkload testWorkload, string CustomerAccount, string DataAreaId) { int tryCount = 0; Stopwatch sw = new Stopwatch(); sw.Start(); while (true) { try { tryCount++; CustomerV3 CustomerV3 = context.CustomersV3.Where(x => x.CustomerAccount == CustomerAccount && x.dataAreaId == DataAreaId).First(); break; } catch (Exception e) { if (tryCount >= 3) { throw (e); } sw.Reset(); sw.Start(); } } sw.Stop(); StreamWriter stream = File.AppendText(filePath); stream.WriteLine(Entity + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); stream.Flush(); stream.Close(); }
public static string runOneReadThread(Resources context, int threadCount, string filePath, TestType testType, TestWorkload testWorkload, string SalesOrderNumber, string DataAreaId) { Stopwatch sw = new Stopwatch(); sw.Start(); SalesOrderHeaderV2 SalesOrderHeaderV2 = context.SalesOrderHeadersV2.Where(x => x.SalesOrderNumber == SalesOrderNumber && x.dataAreaId == DataAreaId).First(); sw.Stop(); return(Entity + "," + threadCount + "," + testType + "," + testWorkload + "," + sw.Elapsed.TotalMilliseconds.ToString()); }