public void CreatedBySetInRequest()
{
SimpleDataWebServiceClient webServiceClient = Create();
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(DatabaseRecords.Count, Is.EqualTo(1));
InMemoryRecord inserted = DatabaseRecords[0];
Assert.That(inserted.GetFieldValue("CreatedBy", "null"), Is.EqualTo("UnitTests"));
Assert.That(inserted.GetFieldValue("CreatedDateTime", DateTime.MinValue), Is.EqualTo(DateTime.Today.ToUniversalTime()));
}
public static InMemoryRecord NewRecord()
{
InMemoryRecord record = new InMemoryRecord { Location = "Enterprise.Site.Area.Downtime", Module = "Downtime" };
record.SetFieldValue("IsManual", false);
record.SetFieldValue("Deleted", false);
record.SetFieldValue("Confirmed", false);
record.SetFieldValue("Start Time", DateTime.Now.TrimToSeconds());
record.SetFieldValue("Duration", 90);
record.RecordId = _recordId++;
return record;
}
public static InMemoryRecord NewRecord()
{
InMemoryRecord record = new InMemoryRecord(MaintenanceViews.StandardView())
{
Location = "Enterprise.Site.Area.Maintenance", Module = "Maintenance"
};
record.SetFieldValue("IsManual", false);
record.SetFieldValue("Deleted", false);
record.SetFieldValue("Confirmed", false);
record.SetFieldValue("Sample Period", DateTime.Now.TrimToSeconds());
record.SetFieldValue("Duration", 90);
record.RecordId = _recordId++;
return(record);
}
private void AddDefault <T>(InMemoryRecord amplaRecord, string field, T defaultValue)
{
if (amplaRecord.Find(field) == null)
{
amplaRecord.SetFieldValue(field, defaultValue);
}
}
public static InMemoryRecord NewRecord()
{
InMemoryRecord record = new InMemoryRecord(PlanningViews.StandardView())
{
Location = "Enterprise.Site.Area.Planning",
Module = "Planning"
};
record.SetFieldValue("IsManual", false);
record.SetFieldValue("Deleted", false);
DateTime now = DateTime.Now.TrimToSeconds();
record.SetFieldValue("Planned Start Time", now);
record.SetFieldValue("Planned End Time", now.AddHours(1));
record.SetFieldValue("ActivityId", "New Activity Id");
record.RecordId = _recordId++;
return(record);
}
public void GetAuditDataWithARecordWithChanges()
{
SimpleDataWebServiceClient webServiceClient = Create();
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(DatabaseRecords, Is.Not.Empty);
int recordId = DatabaseRecords[0].RecordId;
InMemoryRecord updateRecord = new InMemoryRecord(ProductionViews.StandardView())
{
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 FindById()
{
InMemoryRecord record = ProductionRecords.NewRecord();
record.SetFieldValue("Value", 100);
record.SetFieldValue("Area", "ROM");
record.Location = location;
record.MarkAsNew();
int recordId = record.SaveTo(webServiceClient);
Assert.That(recordId, Is.GreaterThan(0));
Assert.That(DatabaseRecords, Is.Not.Empty);
AreaValueModel model = repository.FindById(recordId);
Assert.That(model.Id, Is.EqualTo(recordId));
Assert.That(model.Value, Is.EqualTo(100));
Assert.That(model.Area, Is.EqualTo("ROM"));
Assert.That(repository.FindById(recordId + 1), Is.Null);
}
public static InMemoryRecord NewRecord()
{
InMemoryRecord record = new InMemoryRecord { Location = "Enterprise.Site.Area.Production", Module = "Production" };
record.SetFieldValue("IsManual", false);
record.SetFieldValue("Deleted", false);
record.SetFieldValue("Confirmed", false);
record.SetFieldValue("Sample Period", DateTime.Now.TrimToSeconds());
record.SetFieldValue("Duration", 90);
record.SetFieldValue("Field 1", 100);
record.SetFieldValue("Unique", Guid.NewGuid());
record.RecordId = _recordId++;
return record;
}
public void GetVersion_NotRelevantChanges()
{
Assert.That(Records, Is.Empty);
AreaValueModel model = new AreaValueModel {
Area = "ROM", Value = 100
};
Repository.Add(model);
Assert.That(Records.Count, Is.EqualTo(1));
int recordId = Records[0].RecordId;
InMemoryRecord record = new InMemoryRecord(ProductionViews.AreaValueModelView())
{
Module = module,
Location = location,
RecordId = recordId
};
record.SetFieldValue("Sample Period", DateTime.Today);
UpdateRecord(record);
Assert.That(Records.Count, Is.EqualTo(1));
Assert.That(Records[0].GetFieldValue("Sample Period", DateTime.MinValue), Is.EqualTo(DateTime.Today.ToUniversalTime()));
ModelVersions versions = Repository.GetVersions(model.Id);
Assert.That(versions, Is.Not.Null);
Assert.That(versions.Versions, Is.Not.Empty);
Assert.That(versions.Versions.Count, Is.EqualTo(2)); // one version change ('Sample Period') is not relevant
ModelVersion <AreaValueModel> last = (ModelVersion <AreaValueModel>)versions.Versions[0];
ModelVersion <AreaValueModel> current = (ModelVersion <AreaValueModel>)versions.Versions[1];
Assert.That(last.Model, Is.Not.Null);
Assert.That(last.IsCurrentVersion, Is.False);
Assert.That(last.Model.Id, Is.EqualTo(model.Id));
Assert.That(last.Model.Value, Is.EqualTo(model.Value));
Assert.That(last.Model.Area, Is.EqualTo(model.Area));
Assert.That(current.Model, Is.Not.Null);
Assert.That(current.IsCurrentVersion, Is.True);
Assert.That(current.Model.Id, Is.EqualTo(model.Id));
Assert.That(current.Model.Value, Is.EqualTo(model.Value));
Assert.That(current.Model.Area, Is.EqualTo(model.Area));
}
public static InMemoryRecord NewRecord()
{
InMemoryRecord record = new InMemoryRecord(MetricsViews.StandardView())
{
Location = "Enterprise.Site.Area.Metrics",
Module = "Metrics"
};
record.SetFieldValue("IsManual", false);
record.SetFieldValue("Deleted", false);
record.SetFieldValue("Start Time", DateTime.Today);
record.SetFieldValue("End Time", DateTime.Today.AddHours(1));
record.SetFieldValue("Period", "Hour");
record.SetFieldValue("Duration", 3600);
record.RecordId = _recordId++;
return(record);
}
public void LoadModelWithStrings()
{
InMemoryRecord record = EnergyRecords.NewRecord().MarkAsNew();
Assert.That(record.Location, Is.EqualTo(location));
record.SetFieldValue("Cause Location", "Plant.Area");
record.SetFieldIdValue("Cause", "Shutdown", 100);
record.SetFieldIdValue("Classification", "Unplanned Process", 200);
SaveRecord(record);
Assert.That(Records, Is.Not.Empty);
int recordId = Records[0].RecordId;
Assert.That(recordId, Is.GreaterThan(0));
IdentifierEnergyModel model = Repository.FindById(recordId);
Assert.That(model, Is.Not.Null);
Assert.That(model.Cause, Is.EqualTo(100));
Assert.That(model.Classification, Is.EqualTo(200));
}
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");
}
