public void Test_Project_CRUD()
{
#region Arrange
//Add code to create required resources
#endregion Arrange
IProjectConnector connector = new ProjectConnector();
#region CREATE
var newProject = new Project()
{
Description = "TestProject",
Status = Status.Ongoing,
StartDate = new DateTime(2019, 10, 10),
EndDate = new DateTime(2021, 10, 10),
ProjectLeader = "TestProjectLeader",
ContactPerson = "TestContactPerson",
Comments = "TestComments"
};
var createdProject = connector.Create(newProject);
MyAssert.HasNoError(connector);
Assert.AreEqual("TestProject", createdProject.Description);
#endregion CREATE
#region UPDATE
createdProject.Description = "UpdatedProject";
var updatedProject = connector.Update(createdProject);
MyAssert.HasNoError(connector);
Assert.AreEqual("UpdatedProject", updatedProject.Description);
#endregion UPDATE
#region READ / GET
var retrievedProject = connector.Get(createdProject.ProjectNumber);
MyAssert.HasNoError(connector);
Assert.AreEqual("UpdatedProject", retrievedProject.Description);
#endregion READ / GET
#region DELETE
connector.Delete(createdProject.ProjectNumber);
MyAssert.HasNoError(connector);
retrievedProject = connector.Get(createdProject.ProjectNumber);
Assert.AreEqual(null, retrievedProject, "Entity still exists after Delete!");
#endregion DELETE
#region Delete arranged resources
//Add code to delete temporary resources
#endregion Delete arranged resources
}
public void Test_Find_By_Description()
{
#region Arrange
//Add code to create required resources
#endregion Arrange
IProjectConnector connector = new ProjectConnector();
var existingEntries = connector.Find().Entities.Count;
var description = TestUtils.RandomString();
var newProject = new Project()
{
Description = description,
Status = Status.Ongoing,
StartDate = new DateTime(2019, 10, 10),
EndDate = new DateTime(2021, 10, 10),
ProjectLeader = "TestProjectLeader",
ContactPerson = "TestContactPerson",
Comments = "TestComments"
};
//Add entries
for (var i = 0; i < 5; i++)
{
connector.Create(newProject);
}
var otherDescription = TestUtils.RandomString();
newProject.Description = otherDescription;
for (var i = 0; i < 5; i++)
{
connector.Create(newProject);
}
var fullCollection = connector.Find();
MyAssert.HasNoError(connector);
Assert.AreEqual(existingEntries + 5 + 5, fullCollection.Entities.Count);
Assert.AreEqual(5, fullCollection.Entities.Count(e => e.Description == description));
Assert.AreEqual(5, fullCollection.Entities.Count(e => e.Description == otherDescription));
//Apply filter
connector.Search.Description = otherDescription;
var filteredCollection = connector.Find();
MyAssert.HasNoError(connector);
Assert.AreEqual(5, filteredCollection.TotalResources);
Assert.AreEqual(5, filteredCollection.Entities.Count);
//Delete entries
foreach (var entry in fullCollection.Entities)
{
connector.Delete(entry.ProjectNumber);
}
#region Delete arranged resources
//Add code to delete temporary resources
#endregion Delete arranged resources
}
public void Test_Find()
{
#region Arrange
//Add code to create required resources
#endregion Arrange
IProjectConnector connector = new ProjectConnector();
var existingEntries = connector.Find(null).Entities.Count;
var testKeyMark = TestUtils.RandomString();
var newProject = new Project()
{
Description = testKeyMark,
Status = Status.Ongoing,
StartDate = new DateTime(2019, 10, 10),
EndDate = new DateTime(2021, 10, 10),
ProjectLeader = "TestProjectLeader",
ContactPerson = "TestContactPerson",
Comments = "TestComments"
};
//Add entries
for (var i = 0; i < 5; i++)
{
connector.Create(newProject);
}
//No filter supported
var fullCollection = connector.Find(null);
Assert.AreEqual(existingEntries + 5, fullCollection.Entities.Count);
Assert.AreEqual(5, fullCollection.Entities.Count(e => e.Description == testKeyMark));
//Apply Limit
var searchSettings = new ProjectSearch();
searchSettings.Limit = 2;
var limitedCollection = connector.Find(searchSettings);
Assert.AreEqual(existingEntries + 5, limitedCollection.TotalResources);
Assert.AreEqual(2, limitedCollection.Entities.Count);
//Delete entries
foreach (var entry in fullCollection.Entities)
{
connector.Delete(entry.ProjectNumber);
}
#region Delete arranged resources
//Add code to delete temporary resources
#endregion Delete arranged resources
}
public void Test_Project_CRUD()
{
var connector = new ProjectConnector();
#region CREATE
var newProject = new Project()
{
Description = "TestProject",
Status = Status.ONGOING,
StartDate = new DateTime(2019, 10, 10).ToString(APIConstants.DateFormat),
EndDate = new DateTime(2021, 10, 10).ToString(APIConstants.DateFormat),
ProjectLeader = "TestProjectLeader",
ContactPerson = "TestContactPerson",
Comments = "TestComments"
};
var createdProject = connector.Create(newProject);
MyAssert.HasNoError(connector);
Assert.AreEqual(createdProject.Description, "TestProject");
#endregion CREATE
#region UPDATE
createdProject.Description = "UpdatedTestProject";
var updatedProject = connector.Update(createdProject);
MyAssert.HasNoError(connector);
Assert.AreEqual("UpdatedTestProject", updatedProject.Description);
#endregion UPDATE
#region READ / GET
var retrievedProject = connector.Get(createdProject.ProjectNumber);
MyAssert.HasNoError(connector);
Assert.AreEqual("UpdatedTestProject", retrievedProject.Description);
#endregion READ / GET
#region DELETE
connector.Delete(createdProject.ProjectNumber);
MyAssert.HasNoError(connector);
retrievedProject = connector.Get(createdProject.ProjectNumber);
Assert.AreEqual(null, retrievedProject, "Entity still exists after Delete!");
#endregion DELETE
}
public void Test_Find()
{
#region Arrange
var tmpEmployee = new EmployeeConnector().Get("TEST_EMP") ?? new EmployeeConnector().Create(new Employee()
{
EmployeeId = "TEST_EMP"
});
var tmpProject = new ProjectConnector().Create(new Project()
{
Description = "TmpProject"
});
var tmpCostCenter = new CostCenterConnector().Get("TMP") ?? new CostCenterConnector().Create(new CostCenter()
{
Code = "TMP", Description = "TmpCostCenter"
});
for (var i = 0; i < 5; i++)
{
new AttendanceTransactionsConnector().Delete(tmpEmployee.EmployeeId, new DateTime(2018, 01, 01).AddDays(i), AttendanceCauseCode.TID);
}
#endregion Arrange
IAttendanceTransactionsConnector connector = new AttendanceTransactionsConnector();
var newAttendenceTransaction = new AttendanceTransaction()
{
EmployeeId = tmpEmployee.EmployeeId,
CauseCode = AttendanceCauseCode.TID,
Date = new DateTime(2018, 01, 01),
Hours = 1,
CostCenter = tmpCostCenter.Code,
Project = tmpProject.ProjectNumber
};
//Add entries
for (var i = 0; i < 5; i++)
{
newAttendenceTransaction.Date = new DateTime(2018, 01, 01).AddDays(i);
connector.Create(newAttendenceTransaction);
MyAssert.HasNoError(connector);
}
connector.Search.EmployeeId = tmpEmployee.EmployeeId;
var fullCollection = connector.Find();
MyAssert.HasNoError(connector);
Assert.AreEqual(5, fullCollection.TotalResources);
Assert.AreEqual(5, fullCollection.Entities.Count);
Assert.AreEqual(1, fullCollection.TotalPages);
Assert.AreEqual(tmpEmployee.EmployeeId, fullCollection.Entities.First().EmployeeId);
//Apply Limit
connector.Search.Limit = 2;
var limitedCollection = connector.Find();
MyAssert.HasNoError(connector);
Assert.AreEqual(5, limitedCollection.TotalResources);
Assert.AreEqual(2, limitedCollection.Entities.Count);
Assert.AreEqual(3, limitedCollection.TotalPages);
//Delete entries
foreach (var entry in fullCollection.Entities)
{
connector.Delete(entry.EmployeeId, entry.Date, entry.CauseCode);
}
#region Delete arranged resources
new CostCenterConnector().Delete(tmpCostCenter.Code);
new ProjectConnector().Delete(tmpProject.ProjectNumber);
#endregion Delete arranged resources
}
public void Test_AttendanceTransactions_CRUD()
{
#region Arrange
var tmpEmployee = new EmployeeConnector().Get("TEST_EMP") ?? new EmployeeConnector().Create(new Employee()
{
EmployeeId = "TEST_EMP"
});
var tmpProject = new ProjectConnector().Create(new Project()
{
Description = "TmpProject"
});
var tmpCostCenter = new CostCenterConnector().Get("TMP") ?? new CostCenterConnector().Create(new CostCenter()
{
Code = "TMP", Description = "TmpCostCenter"
});
#endregion Arrange
IAttendanceTransactionsConnector connector = new AttendanceTransactionsConnector();
#region CREATE
var newAttendanceTransaction = new AttendanceTransaction()
{
EmployeeId = tmpEmployee.EmployeeId,
CauseCode = AttendanceCauseCode.TID,
Date = new DateTime(2018, 01, 01),
Hours = 5.5m,
CostCenter = tmpCostCenter.Code,
Project = tmpProject.ProjectNumber
};
var createdAttendanceTransaction = connector.Create(newAttendanceTransaction);
MyAssert.HasNoError(connector);
Assert.AreEqual(5.5m, createdAttendanceTransaction.Hours);
#endregion CREATE
#region UPDATE
createdAttendanceTransaction.Hours = 8;
var updatedAttendanceTransaction = connector.Update(createdAttendanceTransaction);
MyAssert.HasNoError(connector);
Assert.AreEqual(8, updatedAttendanceTransaction.Hours);
#endregion UPDATE
#region READ / GET
var retrievedAttendanceTransaction = connector.Get(createdAttendanceTransaction.EmployeeId, createdAttendanceTransaction.Date, createdAttendanceTransaction.CauseCode);
MyAssert.HasNoError(connector);
Assert.AreEqual(8, retrievedAttendanceTransaction.Hours);
#endregion READ / GET
#region DELETE
connector.Delete(createdAttendanceTransaction.EmployeeId, createdAttendanceTransaction.Date, createdAttendanceTransaction.CauseCode);
MyAssert.HasNoError(connector);
retrievedAttendanceTransaction = connector.Get(createdAttendanceTransaction.EmployeeId, createdAttendanceTransaction.Date, createdAttendanceTransaction.CauseCode);
Assert.AreEqual(null, retrievedAttendanceTransaction, "Entity still exists after Delete!");
#endregion DELETE
#region Delete arranged resources
new CostCenterConnector().Delete(tmpCostCenter.Code);
new ProjectConnector().Delete(tmpProject.ProjectNumber);
#endregion Delete arranged resources
}
protected override ActivityExecutionStatus Execute(ActivityExecutionContext executionContext)
{
try
{
//System.Threading.Thread.Sleep(10000); //makes debugging easier.
if (ConnectorId == null)
{
throw new ArgumentNullException("ConnectorId is null.");
}
startTime = DateTime.UtcNow; //set the start time.
//setup event log access
if (!EventLog.SourceExists(strEventLogTitle)) //check if WF account is non-admin
{
EventLog.CreateEventSource(strEventLogTitle, "Operations Manager");
}
#region Setup connection to EMG and get objects.
emg = new EnterpriseManagementGroup("localhost");
setEnterpriseManagementObjects();
//get the last run date time so we can get projects with a last modified date greater than the last run. Check for UTC on project...
DateTime lastRun = emoStatus[null, "LastRunFinishTime"].Value == null ? DateTime.MinValue : (DateTime)emoStatus[null, "LastRunFinishTime"].Value;
//check to see if retention is enabled. If so, and this is the first run, change the lastRun date.
var retentionEnabled = emoSettings[null, "IsRetentionEnabled"].Value == null ? false : (bool)emoSettings[null, "IsRetentionEnabled"].Value;
if (retentionEnabled && DateTime.Equals(lastRun, DateTime.MinValue))
{
lastRun = DateTime.Now.AddDays(-(Convert.ToDouble(emoSettings[null, "RetentionDays"].Value)));
}
//set the start time on the status object.
emoStatus[null, "LastRunStartTime"].Value = startTime;
emoStatus[null, "LastRunFinishTime"].Value = null;
emoStatus[null, "Status"].Value = mpeSyncStatusEnums.First(mpe => mpe.Name == "Microsoft.SystemCenter.LinkingFramework.SyncStatusEnum.Running");
emoStatus[null, "MinValue"].Value = 0;
emoStatus[null, "MaxValue"].Value = 100;
#endregion
#region Get connector credentails
NetworkCredential creds = NetworkCredentialsHelper.GetProjectCredentials(emoConnector[null, "RunAsAccount"].Value.ToString(), emoConnector[null, "Id"].ToString(), emg.Name);
#endregion
EventLog.WriteEntry(strEventLogTitle, string.Format("Starting Project CI sync from Project Server...\r\n\r\nProject Server: {0}\r\nUser Name: {1}", emoConnector[null, "ProjectServerURL"].Value.ToString(), creds.Domain + "\\" + creds.UserName));
#region license check
var licenseExpiration = checkLicense(); //method will throw an exception if no license exists.
EventLog.WriteEntry(strEventLogTitle, string.Format("License Expiration: {0}", licenseExpiration));
#endregion
#region Connect to Project Server and read data
ProjectConnector projectConnector = new ProjectConnector(emoConnector[null, "ProjectServerURL"].Value.ToString(), creds);
projectConnector.Connect();
#endregion
#region Read data from Project Server
if (lastRun == DateTime.MinValue)
{
EventLog.WriteEntry(strEventLogTitle, "Querying Project Server for a full list of projects...");
}
else
{
EventLog.WriteEntry(strEventLogTitle, string.Format("Querying Project Server for Projects created or modified since: {0} UTC...", lastRun));
}
projectConnector.LoadProjects(lastRun);
#endregion
#region Write data to the Service Manager DB.
totalToProcess = projectConnector.Projects.Count();
if (totalToProcess > 0)
{
EventLog.WriteEntry(strEventLogTitle, string.Format("Processing {0} projects returned from Project Server...", totalToProcess), EventLogEntryType.Information, 0);
iddObjects = new IncrementalDiscoveryData();
List <Exception> exceptionsList = new List <Exception>();
foreach (PublishedProject project in projectConnector.Projects)
{
try
{
projectConnector.LoadProjectTaskData(project);
projectConnector.LoadProjectMetaData(project);
iddObjects.Add(buildProjectCI(project, mpcClasses.First(c => c.Name == "Cireson.ProjectAutomation.Project")));
}
catch (EnterpriseManagementException ex)
{
exceptionsList.Add(new ProjectImportException(string.Format("An error occured while importing the following project:\r\n\r\nProject Name: {0}\r\n{1}\r\n", project.Name, ex)));
hasImportFailure = true;
}
//catch SP exceptions
finally
{
totalProcessed++;
updateWorkflowStatus(false, ((totalProcessed * 100) / totalToProcess));
}
}//end of foreach.
#endregion
//commit the changes to the database
iddObjects.Overwrite(emg);
if (exceptionsList.Count > 0)
{
throw new AggregateException(string.Format("{0} projects failed to sync. ", (totalToProcess - exceptionsList.Count).ToString()), exceptionsList);
}
else
{
EventLog.WriteEntry(strEventLogTitle, string.Format("{0} projects successfully committed. Elapsed Time: {1} seconds.", totalProcessed, getRunTime(startTime).Seconds), EventLogEntryType.Information, 0);
}
}
else
{
EventLog.WriteEntry(strEventLogTitle, string.Format("No updated projects exist. Project Connector workflow is exiting. Elapsed Time: {0} seconds.", getRunTime(startTime).Seconds));
}
}
catch (AggregateException ex)
{
TrackData(ex.Message);
StringBuilder exceptionStrings = new StringBuilder();
foreach (var innerEx in ex.InnerExceptions)
{
exceptionStrings.AppendLine(string.Format(strExceptionMessage, innerEx.Message, innerEx.InnerException, innerEx.StackTrace, innerEx.Source));
}
EventLog.WriteEntry(strEventLogTitle, string.Format(ex.Message + "Elapsed Time: {0} seconds. The following projects failed to sync: \r\n\r\n{1}", getRunTime(startTime).Seconds, exceptionStrings.ToString()), EventLogEntryType.Error, 1);
hasImportFailure = true;
}
catch (EnterpriseManagementException ex)
{
TrackData(ex.Message);
EventLog.WriteEntry(strEventLogTitle, string.Format(strExceptionMessage, ex.Message, ex.InnerException, ex.StackTrace, ex.Source), EventLogEntryType.Error, 1);
hasImportFailure = true;
throw;
}
catch (Exception ex)
{
TrackData(ex.Message);
EventLog.WriteEntry(strEventLogTitle, string.Format(strExceptionMessage, ex.Message, ex.InnerException, ex.StackTrace, ex.Source), EventLogEntryType.Error, 1);
hasImportFailure = true;
throw;
}
finally
{
updateWorkflowStatus(true, 100);
if (emg != null)
{
emg.Dispose();
}
}
return(ActivityExecutionStatus.Closed);
}
public void Test_Find()
{
#region Arrange
var tmpEmployee = new EmployeeConnector().Create(new Employee()
{
EmployeeId = TestUtils.RandomString()
});
var tmpProject = new ProjectConnector().Create(new Project()
{
Description = "TmpProject"
});
var tmpCostCenter = new CostCenterConnector().Create(new CostCenter()
{
Code = "TMP", Description = "TmpCostCenter"
});
#endregion Arrange
IAbsenceTransactionConnector connector = new AbsenceTransactionConnector();
var newAbsenceTransaction = new AbsenceTransaction()
{
EmployeeId = tmpEmployee.EmployeeId,
CauseCode = AbsenceCauseCode.MIL,
Date = new DateTime(2018, 01, 01),
Hours = 1,
CostCenter = tmpCostCenter.Code,
Project = tmpProject.ProjectNumber
};
//Add entries
for (var i = 0; i < 5; i++)
{
newAbsenceTransaction.Date = new DateTime(2018, 01, 01).AddDays(i);
connector.Create(newAbsenceTransaction);
}
var searchSettings = new AbsenceTransactionSearch();
searchSettings.EmployeeId = tmpEmployee.EmployeeId;
var fullCollection = connector.Find(searchSettings);
Assert.AreEqual(5, fullCollection.TotalResources);
Assert.AreEqual(5, fullCollection.Entities.Count);
Assert.AreEqual(1, fullCollection.TotalPages);
Assert.AreEqual(tmpEmployee.EmployeeId, fullCollection.Entities.First().EmployeeId);
//Apply Limit
searchSettings.Limit = 2;
var limitedCollection = connector.Find(searchSettings);
Assert.AreEqual(5, limitedCollection.TotalResources);
Assert.AreEqual(2, limitedCollection.Entities.Count);
Assert.AreEqual(3, limitedCollection.TotalPages);
//Delete entries
foreach (var entry in fullCollection.Entities)
{
connector.Delete(entry.EmployeeId, entry.Date, entry.CauseCode);
}
#region Delete arranged resources
new CostCenterConnector().Delete(tmpCostCenter.Code);
new ProjectConnector().Delete(tmpProject.ProjectNumber);
#endregion Delete arranged resources
}
public void Test_AbsenceTransaction_CRUD()
{
#region Arrange
var tmpEmployee = new EmployeeConnector().Create(new Employee()
{
EmployeeId = TestUtils.RandomString()
});
var tmpProject = new ProjectConnector().Create(new Project()
{
Description = "TmpProject"
});
var tmpCostCenter = new CostCenterConnector().Create(new CostCenter()
{
Code = "TMP", Description = "TmpCostCenter"
});
#endregion Arrange
IAbsenceTransactionConnector connector = new AbsenceTransactionConnector();
#region CREATE
var newAbsenceTransaction = new AbsenceTransaction()
{
EmployeeId = tmpEmployee.EmployeeId,
CauseCode = AbsenceCauseCode.MIL,
Date = new DateTime(2018, 01, 01),
Hours = 5.5m,
CostCenter = tmpCostCenter.Code,
Project = tmpProject.ProjectNumber
};
var createdAbsenceTransaction = connector.Create(newAbsenceTransaction);
Assert.AreEqual(5.5m, createdAbsenceTransaction.Hours);
#endregion CREATE
#region UPDATE
createdAbsenceTransaction.Hours = 8;
var updatedAbsenceTransaction = connector.Update(createdAbsenceTransaction);
Assert.AreEqual(8, updatedAbsenceTransaction.Hours);
#endregion UPDATE
#region READ / GET
var retrievedAbsenceTransaction = connector.Get(createdAbsenceTransaction.EmployeeId, createdAbsenceTransaction.Date, createdAbsenceTransaction.CauseCode);
Assert.AreEqual(8, retrievedAbsenceTransaction.Hours);
#endregion READ / GET
#region DELETE
connector.Delete(createdAbsenceTransaction.EmployeeId, createdAbsenceTransaction.Date, createdAbsenceTransaction.CauseCode);
Assert.ThrowsException <FortnoxApiException>(
() => connector.Get(createdAbsenceTransaction.EmployeeId, createdAbsenceTransaction.Date, createdAbsenceTransaction.CauseCode),
"Entity still exists after Delete!");
#endregion DELETE
#region Delete arranged resources
new CostCenterConnector().Delete(tmpCostCenter.Code);
new ProjectConnector().Delete(tmpProject.ProjectNumber);
#endregion Delete arranged resources
}
public void Connect(string url, string username, string password)
{
connector = new ProjectConnector(url, username, password);
connector.Connect();
}
protected override ActivityExecutionStatus Execute(ActivityExecutionContext executionContext)
{
try
{
//setup event log access
if (!EventLog.SourceExists(strEventLogTitle))
{
EventLog.CreateEventSource(strEventLogTitle, "Operations Manager");
}
startTime = DateTime.UtcNow; //set the start time
EventLog.WriteEntry(strEventLogTitle, string.Format("Starting {0}.", strEventLogTitle));
exceptionsList = new List <Exception>();
#region setup connection to EMG and get objects
emg = new EnterpriseManagementGroup("localhost");
//sleep so I can debug...
//System.Threading.Thread.Sleep(10000);
setupEnterpriseManagementObjects();
#endregion
var licenseExpiration = checkLicense();
EventLog.WriteEntry(strEventLogTitle, string.Format("License Expiration: {0}", licenseExpiration));
#region Connect to Project Server.
//get connector credentails
NetworkCredential creds = NetworkCredentialsHelper.GetProjectCredentials(emoConnector[null, "RunAsAccount"].Value.ToString(), emoConnector[null, "Id"].ToString(), emg.Name);
projectConnector = new ProjectConnector(emoConnector[null, "ProjectServerURL"].Value.ToString(), creds);
projectConnector.Connect();
#endregion
//setup the bucket
iddBucket = new IncrementalDiscoveryData();
if ((bool)emoProjectAutomationSettings[null, "IsChangeProcessingEnabled"].Value)
{
processChangeRequests();
}
else
{
processReleaseRecords();
}
iddBucket.Overwrite(emg); //commit changes to DB and dispose connection.
if (exceptionsList.Count > 0)
{
throw new AggregateException("Errors occured while processing Project Tasks.", exceptionsList);
}
EventLog.WriteEntry(strEventLogTitle, string.Format("Ending {0}. Elapsed Time: {1} seconds", strEventLogTitle, getRunTime(startTime).Seconds));
}
catch (AggregateException ex)
{
TrackData(ex.Message);
StringBuilder exceptionStrings = new StringBuilder();
foreach (var innerEx in ex.InnerExceptions)
{
exceptionStrings.AppendLine(string.Format(strExceptionMessage, innerEx.Message, innerEx.InnerException, innerEx.StackTrace, innerEx.Source));
}
EventLog.WriteEntry(strEventLogTitle, string.Format("{0}\r\n\r\nElapsed Time: {1} seconds.\r\n\r\nExceptions List: {2}", ex.Message, getRunTime(startTime).Seconds, exceptionsList.ToString()));
}
catch (EnterpriseManagementException ex)
{
TrackData(ex.Message);
EventLog.WriteEntry(strEventLogTitle, string.Format(strExceptionMessage, ex.Message, ex.InnerException, ex.StackTrace, ex.Source), EventLogEntryType.Error, 1);
throw;
}
catch (Exception ex)
{
TrackData(ex.Message);
EventLog.WriteEntry(strEventLogTitle, string.Format(strExceptionMessage, ex.Message, ex.InnerException, ex.StackTrace, ex.Source), EventLogEntryType.Error, 1);
throw;
}
finally
{
if (emg != null)
{
emg.Dispose();
}
}
return(ActivityExecutionStatus.Closed);
}
