public void CreatedBySetInRequest()
{
SimpleDataWebServiceClient webServiceClient = new SimpleDataWebServiceClient(module, location);
InMemoryRecord record = ProductionRecords.NewRecord().MarkAsNew();
record.SetFieldValue("CreatedBy", "UnitTests");
record.SetFieldValue("CreatedDateTime", DateTime.Today);
SubmitDataRequest request = new SubmitDataRequest
{
Credentials = CreateCredentials(),
SubmitDataRecords = new[]
{
record.ConvertToSubmitDataRecord()
}
};
SubmitDataResponse response = webServiceClient.SubmitData(request);
Assert.That(response, Is.Not.Null);
Assert.That(webServiceClient.DatabaseRecords.Count, Is.EqualTo(1));
InMemoryRecord inserted = webServiceClient.DatabaseRecords[0];
Assert.That(inserted.GetFieldValue("CreatedBy", "null"), Is.EqualTo("UnitTests"));
Assert.That(inserted.GetFieldValue("CreatedDateTime", DateTime.MinValue), Is.EqualTo(DateTime.Today.ToUniversalTime()));
}
public void CreatedByDefault()
{
SimpleDataWebServiceClient webServiceClient = new SimpleDataWebServiceClient(module, location);
InMemoryRecord record = ProductionRecords.NewRecord().MarkAsNew();
SubmitDataRequest request = new SubmitDataRequest
{
Credentials = CreateCredentials(),
SubmitDataRecords = new[]
{
record.ConvertToSubmitDataRecord()
}
};
DateTime before = DateTime.Now.AddSeconds(-10).ToUniversalTime();
DateTime after = before.AddSeconds(+20);
SubmitDataResponse response = webServiceClient.SubmitData(request);
Assert.That(response, Is.Not.Null);
Assert.That(webServiceClient.DatabaseRecords.Count, Is.EqualTo(1));
InMemoryRecord inserted = webServiceClient.DatabaseRecords[0];
Assert.That(inserted.GetFieldValue("CreatedBy", "null"), Is.EqualTo("User"));
Assert.That(inserted.GetFieldValue("CreatedDateTime", DateTime.MinValue), Is.InRange(before, after));
}
protected override void OnTearDown()
{
repository = null;
webServiceClient = null;
database = null;
base.OnTearDown();
}
protected override void OnTearDown()
{
base.OnTearDown();
webServiceClient = null;
listLogger = null;
if (repository != null)
{
repository.Dispose();
repository = null;
}
}
protected override void OnSetUp()
{
base.OnSetUp();
SimpleSecurityWebServiceClient securityWebService = new SimpleSecurityWebServiceClient("User");
SimpleAmplaDatabase amplaDatabase = new SimpleAmplaDatabase();
SimpleAmplaConfiguration configuration = new SimpleAmplaConfiguration();
SimpleDataWebServiceClient client = new SimpleDataWebServiceClient(amplaDatabase, configuration, securityWebService);
DataWebServiceFactory.Factory = () => client;
Strategy = new T();
}
protected override void OnSetUp()
{
base.OnSetUp();
database = new SimpleAmplaDatabase();
database.EnableModule(module);
configuration = new SimpleAmplaConfiguration();
configuration.EnableModule(module);
configuration.AddLocation(module, location);
configuration.SetDefaultView(module, ProductionViews.AreaValueModelView());
webServiceClient = new SimpleDataWebServiceClient(database, configuration, new SimpleSecurityWebServiceClient("User"));
repository = new AmplaReadOnlyRepository <AreaValueModel>(new AmplaRepository <AreaValueModel>(webServiceClient, credentialsProvider));
}
public void GetAuditData()
{
SimpleDataWebServiceClient webServiceClient = new SimpleDataWebServiceClient(module, location);
GetAuditDataRequest request = new GetAuditDataRequest
{
Credentials = CreateCredentials(),
Filter = new GetAuditDataFilter {Location = location, Module = AmplaModules.Production}
};
GetAuditDataResponse response = webServiceClient.GetAuditData(request);
Assert.That(response.RowSets, Is.Not.Empty);
Assert.That(response.RowSets[0].Rows, Is.Empty);
}
protected override void OnSetUp()
{
base.OnSetUp();
database = new SimpleAmplaDatabase();
database.EnableModule(module);
configuration = new SimpleAmplaConfiguration();
configuration.EnableModule(module);
configuration.AddLocation(module, location);
configuration.SetDefaultView(module, ProductionViews.StandardView());
SimpleSecurityWebServiceClient securityWebService = new SimpleSecurityWebServiceClient("User");
webServiceClient = new SimpleDataWebServiceClient(database, configuration, securityWebService);
DataWebServiceFactory.Factory = () => webServiceClient;
dynamicViewPoint = new DynamicViewPoint(location, module);
}
protected override void OnSetUp()
{
base.OnSetUp();
database = new SimpleAmplaDatabase();
database.EnableModule(module);
configuration = new SimpleAmplaConfiguration();
configuration.EnableModule(module);
foreach (string location in locations)
{
configuration.AddLocation(module, location);
}
configuration.SetDefaultView(module, getViewFunc());
webServiceClient = new SimpleDataWebServiceClient(database, configuration, new SimpleSecurityWebServiceClient("User"));
listLogger = new ListLogger();
repository = new AmplaRepository <TModel>(new LoggingDataWebServiceClient(webServiceClient, listLogger),
CredentialsProvider.ForUsernameAndPassword(userName, password));
}
public void Update()
{
SimpleDataWebServiceClient webServiceClient = new SimpleDataWebServiceClient(module, location);
InMemoryRecord record = ProductionRecords.NewRecord().MarkAsNew();
InMemoryRecord update = record.Clone();
update.Fields.Clear();
update.Location = record.Location;
update.Fields.Add(new FieldValue("New Field", "100"));
SubmitDataRequest request = new SubmitDataRequest
{
Credentials = CreateCredentials(),
SubmitDataRecords = new[]
{
record.ConvertToSubmitDataRecord()
}
};
SubmitDataResponse response = webServiceClient.SubmitData(request);
Assert.That(response.DataSubmissionResults, Is.Not.Null);
Assert.That(response.DataSubmissionResults.Length, Is.EqualTo(1));
Assert.That(response.DataSubmissionResults[0].RecordAction, Is.EqualTo(RecordAction.Insert));
Assert.That(response.DataSubmissionResults[0].SetId, Is.GreaterThan(100));
Assert.That(webServiceClient.DatabaseRecords.Count, Is.EqualTo(1));
Assert.That(webServiceClient.DatabaseRecords[0].Find("New Field"), Is.Null);
update.RecordId = (int) response.DataSubmissionResults[0].SetId;
request = new SubmitDataRequest
{
Credentials = CreateCredentials(),
SubmitDataRecords = new[]
{
update.ConvertToSubmitDataRecord()
}
};
response = webServiceClient.SubmitData(request);
Assert.That(response.DataSubmissionResults, Is.Not.Null);
Assert.That(response.DataSubmissionResults.Length, Is.EqualTo(1));
Assert.That(response.DataSubmissionResults[0].RecordAction, Is.EqualTo(RecordAction.Update));
Assert.That(response.DataSubmissionResults[0].SetId, Is.EqualTo(update.RecordId));
Assert.That(webServiceClient.DatabaseRecords.Count, Is.EqualTo(1));
Assert.That(webServiceClient.DatabaseRecords[0].Find("New Field"), Is.Not.Null);
Assert.That(webServiceClient.DatabaseRecords[0].Find("New Field").Value, Is.EqualTo("100"));
}
public void InsertInvalidLocation()
{
SimpleDataWebServiceClient webServiceClient = new SimpleDataWebServiceClient(module, location);
InMemoryRecord record = ProductionRecords.NewRecord().MarkAsNew();
record.Location = record.Location + ".Invalid";
SubmitDataRequest request = new SubmitDataRequest
{
Credentials = CreateCredentials(),
SubmitDataRecords = new[]
{
record.ConvertToSubmitDataRecord()
}
};
Assert.Throws<FaultException>(() => webServiceClient.SubmitData(request));
}
public void Insert()
{
SimpleDataWebServiceClient webServiceClient = new SimpleDataWebServiceClient(module, location);
InMemoryRecord record = ProductionRecords.NewRecord().MarkAsNew();
SubmitDataRequest request = new SubmitDataRequest
{
Credentials = CreateCredentials(),
SubmitDataRecords = new[]
{
record.ConvertToSubmitDataRecord()
}
};
SubmitDataResponse response = webServiceClient.SubmitData(request);
Assert.That(response.DataSubmissionResults, Is.Not.Null);
Assert.That(response.DataSubmissionResults.Length, Is.EqualTo(1));
Assert.That(response.DataSubmissionResults[0].RecordAction, Is.EqualTo(RecordAction.Insert));
Assert.That(response.DataSubmissionResults[0].SetId, Is.GreaterThan(100));
Assert.That(webServiceClient.DatabaseRecords.Count, Is.EqualTo(1));
}
public static int SaveTo(this InMemoryRecord record, SimpleDataWebServiceClient webServiceClient)
{
return(webServiceClient.AddExistingRecord(record));
}
public void GetDataWithNoMetaDataReturnsZeroColumns()
{
SimpleDataWebServiceClient webServiceClient = new SimpleDataWebServiceClient(module, location);
webServiceClient.GetViewFunc = ProductionViews.StandardView;
GetDataRequest request = new GetDataRequest
{
Credentials = CreateCredentials(),
Filter = new DataFilter { Location = location, Criteria = new FilterEntry[0] },
View = new GetDataView { Context = NavigationContext.Plant, Mode = NavigationMode.Location, Module = AmplaModules.Production },
Metadata = false,
OutputOptions = new GetDataOutputOptions { ResolveIdentifiers = false },
};
GetDataResponse response = webServiceClient.GetData(request);
Assert.That(response.RowSets, Is.Not.Empty);
Assert.That(response.RowSets[0].Columns, Is.Null);
}
public void GetDataReturnsLocation()
{
SimpleDataWebServiceClient webServiceClient = new SimpleDataWebServiceClient(module, location);
InMemoryRecord record = ProductionRecords.NewRecord().MarkAsNew();
SubmitDataRequest submitRequest = new SubmitDataRequest
{
Credentials = CreateCredentials(),
SubmitDataRecords = new[]
{
record.ConvertToSubmitDataRecord()
}
};
SubmitDataResponse submitResponse = webServiceClient.SubmitData(submitRequest);
Assert.That(submitResponse.DataSubmissionResults, Is.Not.Null);
Assert.That(submitResponse.DataSubmissionResults.Length, Is.EqualTo(1));
Assert.That(submitResponse.DataSubmissionResults[0].RecordAction, Is.EqualTo(RecordAction.Insert));
Assert.That(submitResponse.DataSubmissionResults[0].SetId, Is.GreaterThan(100));
string recordId = Convert.ToString(submitResponse.DataSubmissionResults[0].SetId);
Assert.That(webServiceClient.DatabaseRecords.Count, Is.EqualTo(1));
Assert.That(webServiceClient.DatabaseRecords[0].Location, Is.EqualTo(location));
GetDataRequest request = new GetDataRequest
{
Credentials = CreateCredentials(),
Filter = new DataFilter { Location = record.Location, Criteria = new[] { new FilterEntry { Name = "Id", Value = recordId } } },
View = new GetDataView { Context = NavigationContext.Plant, Mode = NavigationMode.Location, Module = AmplaModules.Production },
Metadata = true,
OutputOptions = new GetDataOutputOptions { ResolveIdentifiers = false },
};
GetDataResponse response = webServiceClient.GetData(request);
AssertResponseContainsValue(response, "Duration", "90");
AssertResponseContainsValue(response, "Location", location);
}
public void GetAuditDataWithARecordWithNoChanges()
{
SimpleDataWebServiceClient webServiceClient = new SimpleDataWebServiceClient(module, location);
InMemoryRecord record = ProductionRecords.NewRecord().MarkAsNew();
SubmitDataRequest submitRequest = new SubmitDataRequest
{
Credentials = CreateCredentials(),
SubmitDataRecords = new[]
{
record.ConvertToSubmitDataRecord()
}
};
webServiceClient.SubmitData(submitRequest);
Assert.That(webServiceClient.DatabaseRecords, Is.Not.Empty);
int recordId = webServiceClient.DatabaseRecords[0].RecordId;
GetAuditDataRequest request = new GetAuditDataRequest
{
Credentials = CreateCredentials(),
Filter = new GetAuditDataFilter { Location = location, Module = AmplaModules.Production, SetId = Convert.ToString(recordId)}
};
GetAuditDataResponse response = webServiceClient.GetAuditData(request);
Assert.That(response.RowSets, Is.Not.Empty);
Assert.That(response.RowSets[0].Rows, Is.Empty);
}
public void GetAuditDataWithARecordWithChanges()
{
SimpleDataWebServiceClient webServiceClient = new SimpleDataWebServiceClient(module, location);
InMemoryRecord record = ProductionRecords.NewRecord().MarkAsNew();
record.SetFieldValue("Field 1", 150);
SubmitDataRequest submitRequest = new SubmitDataRequest
{
Credentials = CreateCredentials(),
SubmitDataRecords = new[]
{
record.ConvertToSubmitDataRecord()
}
};
webServiceClient.SubmitData(submitRequest);
Assert.That(webServiceClient.DatabaseRecords, Is.Not.Empty);
int recordId = webServiceClient.DatabaseRecords[0].RecordId;
InMemoryRecord updateRecord = new InMemoryRecord
{
Location = record.Location,
Module = record.Module,
RecordId = recordId
};
updateRecord.SetFieldValue("Field 1", 200);
SubmitDataRequest update = new SubmitDataRequest
{
Credentials = CreateCredentials(),
SubmitDataRecords = new[]
{
updateRecord.ConvertToSubmitDataRecord()
}
};
webServiceClient.SubmitData(update);
GetAuditDataRequest request = new GetAuditDataRequest
{
Credentials = CreateCredentials(),
Filter = new GetAuditDataFilter { Location = location, Module = AmplaModules.Production, SetId = Convert.ToString(recordId) }
};
GetAuditDataResponse response = webServiceClient.GetAuditData(request);
AssertAuditTableContains(response, location, recordId, "Field 1", "150", "200");
}
public void GetData_ResolveIdentifiers_True()
{
InMemoryRecord record = DowntimeRecords.NewRecord().MarkAsNew();
record.SetFieldIdValue("Cause", "Shutdown", 100);
record.SetFieldIdValue("Classification", "Unplanned Process", 200);
SimpleDataWebServiceClient webServiceClient = new SimpleDataWebServiceClient(record.Module,
record.Location);
record.SaveTo(webServiceClient);
Assert.That(webServiceClient.DatabaseRecords, Is.Not.Empty);
string recordId = Convert.ToString(webServiceClient.DatabaseRecords[0].RecordId);
GetDataRequest request = new GetDataRequest
{
Credentials = CreateCredentials(),
Filter = new DataFilter {Location = record.Location, Criteria = new [] { new FilterEntry {Name = "Id", Value = recordId}}},
View = new GetDataView { Context = NavigationContext.Plant, Mode = NavigationMode.Location, Module = AmplaModules.Downtime},
Metadata = true,
OutputOptions = new GetDataOutputOptions {ResolveIdentifiers = true}
};
GetDataResponse response = webServiceClient.GetData(request);
AssertResponseContainsValue(response, "Cause", "Shutdown");
AssertResponseContainsValue(response, "Classification", "Unplanned Process");
}
public static int SaveTo(this InMemoryRecord record, SimpleDataWebServiceClient webServiceClient)
{
return webServiceClient.AddExistingRecord(record);
}
public void GetNavigationHierarchy()
{
SimpleDataWebServiceClient webServiceClient = new SimpleDataWebServiceClient(module, location);
GetNavigationHierarchyResponse response = webServiceClient.GetNavigationHierarchy(new GetNavigationHierarchyRequest { Module = AmplaModules.Production });
Assert.That(response, Is.Not.Null);
Assert.That(response.Hierarchy, Is.Not.Null);
CheckViewPoints(response.Hierarchy.ViewPoints, "", "Enterprise");
CheckViewPoints(response.Hierarchy.ViewPoints[0].ViewPoints, "Enterprise", "Site");
CheckViewPoints(response.Hierarchy.ViewPoints[0].ViewPoints[0].ViewPoints, "Enterprise.Site", "Area");
CheckViewPoints(response.Hierarchy.ViewPoints[0].ViewPoints[0].ViewPoints[0].ReportingPoints, "Enterprise.Site.Area", "Production");
}
public void GetNavigationHierarchyTwoLocations()
{
string[] locations = new [] { "Plant.Area.Production", "Plant.Area.Equipment.Production"};
SimpleDataWebServiceClient webServiceClient = new SimpleDataWebServiceClient("Production",
locations);
GetNavigationHierarchyResponse response = webServiceClient.GetNavigationHierarchy(new GetNavigationHierarchyRequest { Module = AmplaModules.Production });
Assert.That(response, Is.Not.Null);
Assert.That(response.Hierarchy, Is.Not.Null);
CheckViewPoints(response.Hierarchy.ViewPoints, "", "Plant");
CheckViewPoints(response.Hierarchy.ViewPoints[0].ViewPoints, "Plant", "Area");
CheckViewPoints(response.Hierarchy.ViewPoints[0].ViewPoints[0].ViewPoints, "Plant.Area", "Equipment");
CheckViewPoints(response.Hierarchy.ViewPoints[0].ViewPoints[0].ReportingPoints, "Plant.Area", "Production");
CheckViewPoints(response.Hierarchy.ViewPoints[0].ViewPoints[0].ViewPoints[0].ReportingPoints, "Plant.Area.Equipment", "Production");
}
protected override void OnSetUp()
{
base.OnSetUp();
SimpleDataWebServiceClient client = new SimpleDataWebServiceClient(module, location)
{
GetViewFunc = ProductionViews.StandardView
};
id = client.AddExistingRecord(ProductionRecords.NewRecord());
DataWebServiceFactory.Factory = () => client;
}
