public static void LoadS2ImportTestData(RSMDB.RSMDataModelDataContext context, string prefix)
{
var s2 = context.ExternalSystems.FirstOrDefault(x => x.Id == S2In.Id);
var factory = new StageFactory(context);
factory.createSetting(s2, prefix, S2Import.Repeat);
factory.createSetting(s2, prefix, S2Import.RepeatInterval, "3");
factory.createSetting(s2, prefix, S2Import.LastAccessed);
factory.createSetting(s2, prefix, S2Import.PersonImport, "true");
factory.createSetting(s2, prefix, S2Import.ServiceAddress, "http://localhost");
factory.createSetting(s2, prefix, S2Import.ServiceAccount, "asdfasasdfasd");
factory.createSetting(s2, prefix, S2Import.ServicePassword, "admin");
var location = factory.createLocation("Location1", action: EntityAction.InsertAndSubmit);
factory.createExternalApplicationKey(EntityType.Location, "Location1", s2.Id, location.LocationID);
var portal = factory.createPortal("Portal1", location.LocationID, action: EntityAction.InsertAndSubmit);
factory.createExternalApplicationKey(EntityType.Portal, "Portal1", s2.Id, portal.Id);
var reader = factory.createReader("Reader1", portal.Id, action: EntityAction.InsertAndSubmit);
factory.createExternalApplicationKey(EntityType.Reader, "Reader1", s2.Id, reader.Id);
context.SubmitChanges();
}
public static void LoadS2ImportTestData(RSMDB.RSMDataModelDataContext context, string prefix)
{
var s2 = context.ExternalSystems.FirstOrDefault(x => x.Id == S2In.Id);
var factory = new StageFactory(context);
factory.createSetting(s2, prefix, S2PeopleImport.Available);
factory.createSetting(s2, prefix, S2PeopleImport.Repeat);
factory.createSetting(s2, prefix, S2PeopleImport.RepeatInterval);
factory.createSetting(s2, prefix, S2PeopleImport.ServiceAccount);
factory.createSetting(s2, prefix, S2PeopleImport.ServicePassword);
factory.createSetting(s2, prefix, S2PeopleImport.ImageImport);
factory.createSetting(s2, prefix, S2PeopleImport.ServiceAddress, value: "http://localhost:8766/RSM.Integration.S2.Stub/RestService.svc/test");
//Note: MiddleName intentionally left out for tests
factory.createSetting(s2, prefix, S2PeopleImport.FieldsToUpdate, value: "FirstName,LastName,ExternalUpdated,Image,"
+ "udf1,udf2,udf3,udf4,udf5,udf6,udf7,udf8,udf9,udf10,udf11,udf12,udf13,udf14,udf15,udf16,udf17,udf18,udf19,udf20");
//Field filter to exclude unwanted person records
factory.createSetting("Filter.Person.udf4", "Field filter that excludes records with an empty udf4 value.", ".+", prefix, viewable: false, system: s2);
context.SubmitChanges();
}
public virtual void Initialize()
{
Cleanup();
using (var context = new RSMDB.RSMDataModelDataContext())
{
var sysList = new List <RSMDB.ExternalSystem>()
{
StageFactory.CreateExternalSystem(1, Constants.R1SMSystemName, RSMDB.ExternalSystemDirection.None),
StageFactory.CreateExternalSystem(2, "S2 Import", RSMDB.ExternalSystemDirection.Incoming),
StageFactory.CreateExternalSystem(3, "Track", RSMDB.ExternalSystemDirection.Outgoing),
StageFactory.CreateExternalSystem(4, "S2 Export", RSMDB.ExternalSystemDirection.Outgoing),
StageFactory.CreateExternalSystem(5, "PeopleSoft", RSMDB.ExternalSystemDirection.Incoming),
StageFactory.CreateExternalSystem(6, "Lubrizol In", RSMDB.ExternalSystemDirection.Incoming),
StageFactory.CreateExternalSystem(7, "Lubrizol Out", RSMDB.ExternalSystemDirection.Outgoing),
};
var factory = new StageFactory(context);
var settingsList = new List <RSMDB.Setting>()
{
factory.createSetting(sysList[0], R1Setting.DefaultPrefix, R1Setting.RuleEngineAllow),
factory.createSetting(sysList[0], R1Setting.DefaultPrefix, R1Setting.JobCodesFirst),
factory.createSetting(sysList[0], R1Setting.DefaultPrefix, R1Setting.RequireAccessApproval),
factory.createSetting(sysList[0], R1Setting.DefaultPrefix, R1Setting.AdminPass, "Testing"),
factory.createSetting(sysList[1], S2Import.DefaultPrefix, S2Import.ServiceAddress, "http://localhost"),
factory.createSetting(sysList[1], S2Import.DefaultPrefix, S2Import.PersonImport),
factory.createSetting(sysList[1], S2Import.DefaultPrefix, S2Import.ServiceAccount, "asdfasasdfasd"),
factory.createSetting(sysList[1], S2Import.DefaultPrefix, S2Import.ServicePassword),
factory.createSetting(sysList[1], S2Import.DefaultPrefix, S2Import.Repeat),
factory.createSetting(sysList[1], S2Import.DefaultPrefix, S2Import.RepeatInterval, "3"),
factory.createSetting(sysList[1], S2Import.DefaultPrefix, S2Import.LastAccessed),
factory.createSetting(sysList[1], S2PeopleImport.DefaultPrefix, S2PeopleImport.Available),
factory.createSetting(sysList[1], S2PeopleImport.DefaultPrefix, S2PeopleImport.Repeat),
factory.createSetting(sysList[1], S2PeopleImport.DefaultPrefix, S2PeopleImport.RepeatInterval),
factory.createSetting(sysList[1], S2PeopleImport.DefaultPrefix, S2PeopleImport.ServiceAddress, "http://10.1.1.234/goforms/nbapi"),
factory.createSetting(sysList[1], S2PeopleImport.DefaultPrefix, S2PeopleImport.ServiceAccount, "admin"),
factory.createSetting(sysList[1], S2PeopleImport.DefaultPrefix, S2PeopleImport.ServicePassword, "072159245241245031239120017047219193126250124056"),
factory.createSetting(sysList[1], S2PeopleImport.DefaultPrefix, S2PeopleImport.ImageImport),
factory.createSetting(sysList[1], S2PeopleImport.DefaultPrefix, S2PeopleImport.FieldsToUpdate, "FirstName,MiddleName,LastName,ExternalUpdated,Image,"
+ "udf1,udf2,udf3,udf4,udf5,udf6,udf7,udf8,udf9,udf10,udf11,udf12,udf13,udf14,udf15,udf16,udf17,udf18,udf19,udf20"),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.Available),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.Repeat),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.RepeatInterval),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.ServiceAddress, "http://localhost"),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.Account),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.Password),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.SourceSystem, ""),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.PersonExport),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.LocationExport),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.AccessExport),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.LastAccessEvent),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.LocationId),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.EventCode, ""),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.SysId, ""),
factory.createSetting(sysList[2], TrackExport.DefaultPrefix, TrackExport.DataSource, ""),
factory.createSetting(sysList[5], LubrizolImport.DefaultPrefix, LubrizolImport.Available),
factory.createSetting(sysList[5], LubrizolImport.DefaultPrefix, LubrizolImport.Repeat),
factory.createSetting(sysList[5], LubrizolImport.DefaultPrefix, LubrizolImport.RepeatInterval),
factory.createSetting(sysList[5], LubrizolImport.DefaultPrefix, LubrizolImport.SqlConnection),
factory.createSetting(sysList[6], LubrizolExport.DefaultPrefix, LubrizolExport.Available),
factory.createSetting(sysList[6], LubrizolExport.DefaultPrefix, LubrizolExport.Repeat),
factory.createSetting(sysList[6], LubrizolExport.DefaultPrefix, LubrizolExport.RepeatInterval),
factory.createSetting(sysList[6], LubrizolExport.DefaultPrefix, LubrizolExport.ServiceAddress),
factory.createSetting(sysList[6], LubrizolExport.DefaultPrefix, LubrizolExport.Account),
factory.createSetting(sysList[6], LubrizolExport.DefaultPrefix, LubrizolExport.Password),
factory.createSetting(sysList[6], LubrizolExport.DefaultPrefix, LubrizolExport.LastUpdated),
factory.createSetting(sysList[6], LubrizolExport.DefaultPrefix, LubrizolExport.SourceSystem),
factory.createSetting(sysList[6], LubrizolExport.DefaultPrefix, LubrizolExport.ActiveEmployeeLibrary),
factory.createSetting(sysList[6], LubrizolExport.DefaultPrefix, LubrizolExport.InactiveEmployeeLibrary),
factory.createSetting(sysList[6], LubrizolExport.DefaultPrefix, LubrizolExport.SqlConnection),
};
context.ExternalSystems.InsertAllOnSubmit(sysList);
context.Settings.InsertAllOnSubmit(settingsList);
context.SubmitChanges();
}
}
public static void LoadTrackExportTestData(RSMDB.RSMDataModelDataContext context, string prefix)
{
var s2 = context.ExternalSystems.FirstOrDefault(x => x.Id == S2In.Id);
var trackOut = context.ExternalSystems.FirstOrDefault(x => x.Id == TrackOut.Id);
var factory = new StageFactory(context);
factory.createSetting(1001, string.Format("{0}.Repeat", prefix), "Allow task to repeat.", "true", 0, false, InputTypes.Checkbox, trackOut);
factory.createSetting(1002, string.Format("{0}.RepeatInterval", prefix), "repeat interval in minutes.", "3", 0, false, InputTypes.Text, trackOut);
factory.createSetting(1003, string.Format("{0}.LastAccessEvent", prefix), "Date time on last record exported.", "", 0, false, InputTypes.Text, trackOut);
factory.createSetting(1004, string.Format("{0}.PersonExport", prefix), "Allow export of People.", "true", 0, false, InputTypes.Checkbox, trackOut);
factory.createSetting(1005, string.Format("{0}.ServiceAddress", prefix), "Appliance Address", "http://localhost:8088/mockACS2TrackWebSvcSoap12", 2, true, InputTypes.Text, trackOut);
factory.createSetting(1006, string.Format("{0}.ServiceAccount", prefix), "Service User Id", "asdfasasdfasd", 3, true, InputTypes.Text, trackOut);
factory.createSetting(1007, string.Format("{0}.ServicePassword", prefix), "Service Password", "admin", 4, true, InputTypes.Password, trackOut);
factory.createSetting(1008, string.Format("{0}.SourceSystem", prefix), "System whose data will be exported to Track.", s2.Id.ToString(), 0, false, InputTypes.Text, trackOut);
factory.createSetting(1009, string.Format("{0}.LocationExport", prefix), "Allow exporting of Locations to Track", "true", 1, true, InputTypes.Checkbox, trackOut);
factory.createSetting(10010, string.Format("{0}.AccessExport", prefix), "Allow exporting of Access History to Track", "true", 2, true, InputTypes.Checkbox, trackOut);
factory.createSetting(10011, string.Format("{0}.EventCode", prefix), "Event Code value for export to Track.", "8", 0, false, InputTypes.Text, trackOut);
factory.createSetting(10012, string.Format("{0}.SysId", prefix), "System Id value for export to Track.", "1", 0, false, InputTypes.Text, trackOut);
factory.createSetting(10013, string.Format("{0}.DataSource", prefix), "DataSource value for export to Track.", "TSTLBZDB", 0, false, InputTypes.Text, trackOut);
factory.createSetting(10014, string.Format("{0}.CompanyExport", prefix), "Allow exporting of Companies to Track", "true", 1, true, InputTypes.Checkbox, trackOut);
var location = factory.createLocation("Location1", action: EntityAction.InsertAndSubmit);
factory.createExternalApplicationKey(EntityType.Location, "Location1", s2.Id, location.LocationID);
factory.createExternalApplicationKey(EntityType.Location, "1", trackOut.Id, location.LocationID);
var portal = factory.createPortal("Portal 1001", location.LocationID, action: EntityAction.InsertAndSubmit);
factory.createExternalApplicationKey(EntityType.Portal, "1001", s2.Id, portal.Id);
var reader = factory.createReader("Reader1", portal.Id, action: EntityAction.InsertAndSubmit);
factory.createExternalApplicationKey(EntityType.Reader, "Reader1", s2.Id, reader.Id);
var person = factory.createPerson("Jane", "Smith", null, UDFs: new Dictionary <int, string> {
{ 4, "Contractor Co1" }
}, action: EntityAction.InsertAndSubmit);
factory.createExternalApplicationKey(EntityType.Person, "Person1", s2.Id, person.Id);
var start = DateTime.Now;
for (var i = 0; i < 5; i++)
{
var extId = string.Format("access{0}", i);
var access = factory.createAccessHistory(extId, person.Id, portal.Id, reader.Id, (int)AccessType.Valid, accessed: start.Subtract(TimeSpan.FromMinutes(i)), action: EntityAction.InsertAndSubmit);
factory.createExternalApplicationKey(EntityType.AccessLog, extId, s2.Id, access.Id);
}
context.SubmitChanges();
}
public static void LoadTrackExportTestData(RSMDB.RSMDataModelDataContext context, string prefix)
{
var s2 = context.ExternalSystems.FirstOrDefault(x => x.Id == S2In.Id);
var trackOut = context.ExternalSystems.FirstOrDefault(x => x.Id == TrackOut.Id);
var factory = new StageFactory(context);
factory.createSetting(trackOut, prefix, TrackExport.Repeat);
factory.createSetting(trackOut, prefix, TrackExport.RepeatInterval);
factory.createSetting(trackOut, prefix, TrackExport.LastAccessEvent);
factory.createSetting(trackOut, prefix, TrackExport.PersonExport);
factory.createSetting(trackOut, prefix, TrackExport.ServiceAddress, "http://localhost:8088/mockACS2TrackWebSvcSoap12");
factory.createSetting(trackOut, prefix, TrackExport.Account);
factory.createSetting(trackOut, prefix, TrackExport.Password);
factory.createSetting(trackOut, prefix, TrackExport.SourceSystem, s2.Id.ToString());
factory.createSetting(trackOut, prefix, TrackExport.LocationExport);
factory.createSetting(trackOut, prefix, TrackExport.AccessExport);
factory.createSetting(trackOut, prefix, TrackExport.EventCode);
factory.createSetting(trackOut, prefix, TrackExport.SysId);
factory.createSetting(trackOut, prefix, TrackExport.DataSource);
factory.createSetting(trackOut, prefix, TrackExport.CompanyExport);
var location = factory.createLocation("Location1", action: EntityAction.InsertAndSubmit);
factory.createExternalApplicationKey(EntityType.Location, "Location1", s2.Id, location.LocationID);
factory.createExternalApplicationKey(EntityType.Location, "1", trackOut.Id, location.LocationID);
var portal = factory.createPortal("Portal 1001", location.LocationID, action: EntityAction.InsertAndSubmit);
factory.createExternalApplicationKey(EntityType.Portal, "1001", s2.Id, portal.Id);
var reader = factory.createReader("Reader1", portal.Id, action: EntityAction.InsertAndSubmit);
factory.createExternalApplicationKey(EntityType.Reader, "Reader1", s2.Id, reader.Id);
var person = factory.createPerson("Jane", "Smith", null, UDFs: new Dictionary <int, string> {
{ 4, "Contractor Co1" }
}, action: EntityAction.InsertAndSubmit);
factory.createExternalApplicationKey(EntityType.Person, "Person1", s2.Id, person.Id);
var start = DateTime.Now;
for (var i = 0; i < 5; i++)
{
var extId = string.Format("access{0}", i);
var access = factory.createAccessHistory(extId, person.Id, portal.Id, reader.Id, (int)AccessType.Valid, accessed: start.Subtract(TimeSpan.FromMinutes(i)), action: EntityAction.InsertAndSubmit);
factory.createExternalApplicationKey(EntityType.AccessLog, extId, s2.Id, access.Id);
}
context.SubmitChanges();
}
