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