public string GetArtifactCodeOfArtifactType(ArtifactTypeEnum artifactTypeEnum)
{
Session session = null;
string artifactTypeCode = null;
try
{
session = XpoHelper.GetNewSession();
artifactTypeCode = Enum.GetName(typeof(ArtifactTypeEnum), artifactTypeEnum);
ArtifactType artifactType =
Util.getXPCollection <ArtifactType>(session, "Code", artifactTypeCode).FirstOrDefault();
return(GetArtifactCodeOfArtifactType(artifactType.ArtifactTypeId));
}
catch (Exception)
{
throw;
}
finally
{
if (session != null)
{
session.Dispose();
}
}
}
/// <summary>Takes an input string and tries to get the artifact type ID and the artifact ID.</summary>
/// <param name="input">The input string.</param>
/// <param name="artType">The ID of the artifact type.</param>
/// <param name="artId">The ID of the artifact.</param>
/// <remarks>Returns -1 and -1 if there is not both an artAType and artId.</remarks>
private void retrieveArtTypeAndId(string strType, string strId, out ArtifactTypeEnum artType, out int artId)
{
artType = ArtifactTypeEnum.None;
artId = -1;
//The first part should be the token.
switch (strType.ToUpperInvariant().Trim())
{
case "RQ": //Requirement
artType = ArtifactTypeEnum.Requirement;
break;
case "TC": //Test Case
artType = ArtifactTypeEnum.Test_Case;
break;
case "IN": //Incident
artType = ArtifactTypeEnum.Incident;
break;
case "RL":
artType = ArtifactTypeEnum.Release;
break;
case "TK":
artType = ArtifactTypeEnum.Task;
break;
case "TX":
artType = ArtifactTypeEnum.Test_Set;
break;
case "PR": // Project
artType = ArtifactTypeEnum.Project;
break;
case "TR": // Test Run
case "TS": // Test Step
case "AH": // Automation Host
case "AE": // Automation Engine
default:
artType = ArtifactTypeEnum.None;
return;
}
//Now ge tthe number..
if (!int.TryParse(strId, out artId))
{
artId = -1;
artType = ArtifactTypeEnum.None;
}
return;
}
private void LinkDeveloperAndArtifact(int developerId, FileRevision fileRevision, ArtifactTypeEnum artifactType)
{
var artifactTypeId = (int)artifactType;
using (var repository = new ExpertiseDBEntities())
{
var developerExpertise = repository.DeveloperExpertises.SingleOrDefault(
de => de.DeveloperId == developerId && de.Artifact.Name == fileRevision.Filename.Name);
if (developerExpertise == null)
{
var artifact = repository.Artifacts.SingleOrDefault(a => a.Name == fileRevision.Filename.Name && a.RepositoryId == RepositoryId)
??
new Artifact {
ArtifactTypeId = artifactTypeId, Name = fileRevision.Filename.Name, RepositoryId = RepositoryId
};
developerExpertise = repository.DeveloperExpertises.Add(
new DeveloperExpertise
{
Artifact = artifact,
DeveloperId = developerId
});
}
developerExpertise.Artifact.ModificationCount++;
if (fileRevision.IsNew)
{
developerExpertise.IsFirstAuthor = true;
}
else
{
developerExpertise.DeliveriesCount++;
}
repository.SaveChanges();
}
}
public Artifact FindOrCreateArtifact(ExpertiseDBEntities repository, string FileName, ArtifactTypeEnum artifactType)
{
Artifact artifact = repository.Artifacts.SingleOrDefault(a => a.Name == FileName && a.RepositoryId == RepositoryId);
if (null == artifact) // thread-safe artifact insertion
{
lock (artifactLocks.acquireLock(FileName))
{
using (ExpertiseDBEntities freshRepository = new ExpertiseDBEntities())
{
artifact = freshRepository.Artifacts.SingleOrDefault(a => a.Name == FileName && a.RepositoryId == RepositoryId);
if (null == artifact)
{
artifact = new Artifact {
ArtifactTypeId = (int)artifactType, Name = FileName, RepositoryId = RepositoryId
};
freshRepository.Artifacts.Add(artifact);
freshRepository.SaveChanges();
}
}
}
artifactLocks.releaseLock(FileName);
artifact = repository.Artifacts.SingleOrDefault(a => a.Name == FileName && a.RepositoryId == RepositoryId); // re-retrieve from other repository
}
return(artifact);
}
public DeveloperExpertise FindOrCreateDeveloperExpertise(ExpertiseDBEntities repository, int developerId, string filename, ArtifactTypeEnum artifactType, bool isInferred)
{
int artifactId = FindOrCreateArtifact(repository, filename, artifactType).ArtifactId;
return(FindOrCreateDeveloperExpertise(repository, developerId, artifactId, isInferred));
}
private void LinkDeveloperAndArtifact(int developerId, FileRevision fileRevision, ArtifactTypeEnum artifactType)
{
using (var repository = new ExpertiseDBEntities())
{
string FileName = fileRevision.Filename.Name;
var developerExpertise = FindOrCreateDeveloperExpertise(repository, developerId, FileName, artifactType, false);
developerExpertise.Artifact.ModificationCount++;
if (fileRevision.IsNew)
{
developerExpertise.IsFirstAuthor = true;
}
else
{
developerExpertise.DeliveriesCount++;
}
repository.SaveChanges();
}
}
private void processSpiraAccount(Pop3Client clientPOP3, AccountDetails account, ApplicationSystem appServer)
{
const string METHOD = CLASS + "processSpiraAccount()";
this._eventLog.EntryLog(METHOD);
//Create the application client and connect to our project and get users..
SoapServiceClient clientAppl = (SoapServiceClient)this.CreateApplicationClient(appServer, account);
//Get users in the project..
List <RemoteProjectUser> spiraUsers = clientAppl.Project_RetrieveUserMembership();
//Get the known message IDs..
List <string> seenUIDs = this.readMessageIDsForAccount(account.AccountID.Value);
//Get new emails from the client.
List <Message> newMsgs = this.popGetNewMessages(clientPOP3, account, seenUIDs);
//Get all projects..
List <RemoteProject> spiraProjs = clientAppl.Project_Retrieve();
//Loop through each email.
foreach (Message msg in newMsgs)
{
this._eventLog.WriteTrace(METHOD, "Starting on message " + msg.MessageLogID + "...");
//Make sure we have a from address, otherwise skip (Delivery Returned messages have no FROM address)
//First see if the message should be skipped. (Keywords, Headers, or Email Addresses)
if (msg.Headers != null &&
msg.Headers.From != null &&
!String.IsNullOrWhiteSpace(msg.Headers.From.Address) &&
msg.Headers.From.Address.ToLowerInvariant().Trim() != account.AccountEmail.ToLowerInvariant().Trim())
{
string filterMsg;
if (this.doesMessageClearFilters(msg, out filterMsg))
{
//First see if there's a header we can get the artifact ID from..
ArtifactTypeEnum artType = ArtifactTypeEnum.None;
int artId = -1;
if (msg.Headers.UnknownHeaders[Common.MESSAGEHEADER_SPIRA_ARTIFACT] != null && rgxArtifactToken.IsMatch(msg.Headers.UnknownHeaders[Common.MESSAGEHEADER_SPIRA_ARTIFACT]))
{
//Get the art type and the id..
Match matches = rgxArtifactToken.Match(msg.Headers.UnknownHeaders[Common.MESSAGEHEADER_SPIRA_ARTIFACT]);
this.retrieveArtTypeAndId(matches.Groups["type"].Value, matches.Groups["id"].Value, out artType, out artId);
}
if (artId == -1 || artType == ArtifactTypeEnum.None)
{
if (rgxArtifactToken.IsMatch(msg.Headers.Subject))
{
//Get the art type and the id..
Match matches = rgxArtifactToken.Match(msg.Headers.Subject);
this.retrieveArtTypeAndId(matches.Groups["type"].Value, matches.Groups["id"].Value, out artType, out artId);
}
}
//Change projects, if necessary, and if we're able to..
try
{
int projNum = clientAppl.System_GetProjectIdForArtifact((int)artType, artId);
if (projNum != 0)
{
bool succNewProject = clientAppl.Connection_ConnectToProject(projNum);
if (!succNewProject)
{
//Couldn't connect to the project this item belongs to. Throw an error.
this._eventLog.WriteMessage("Message " + msg.MessageLogID + " contains information for a project [PR:" + projNum.ToString() + "] that the client could not connect to. Skipping.", System.Diagnostics.EventLogEntryType.Information);
artType = ArtifactTypeEnum.Skip;
artId = 0;
}
}
}
catch (Exception ex)
{
this._eventLog.WriteMessage(METHOD, ex, "Message " + msg.MessageLogID + " - while trying to retrieve project number from artifact. Skipping.");
}
//If we have a match, find the user..
if (artId > 0 && artType != ArtifactTypeEnum.None)
{
//Detect if more than one user is found..
int userCnt = spiraUsers.Where(su => su.EmailAddress.ToLowerInvariant() == msg.Headers.From.MailAddress.Address.ToLowerInvariant()).Count();
if (userCnt == 1)
{
RemoteProjectUser selUser = spiraUsers.Where(su => su.EmailAddress.ToLowerInvariant() == msg.Headers.From.MailAddress.Address.ToLowerInvariant()).Single();
//See if the item exists in the server..
RemoteArtifact remArt = null;
try
{
switch (artType)
{
case ArtifactTypeEnum.Requirement:
remArt = clientAppl.Requirement_RetrieveById(artId);
break;
case ArtifactTypeEnum.Test_Case:
remArt = clientAppl.TestCase_RetrieveById(artId);
break;
case ArtifactTypeEnum.Incident:
remArt = clientAppl.Incident_RetrieveById(artId);
break;
case ArtifactTypeEnum.Release:
remArt = clientAppl.Release_RetrieveById(artId);
break;
case ArtifactTypeEnum.Task:
remArt = clientAppl.Task_RetrieveById(artId);
break;
case ArtifactTypeEnum.Test_Set:
remArt = clientAppl.TestSet_RetrieveById(artId);
break;
}
if (remArt == null)
{
throw new Exception("Artifact did not exist: " + artType.ToString() + " #" + artId.ToString());
}
}
catch (Exception ex)
{
this._eventLog.WriteMessage(METHOD, ex, "For message " + msg.MessageLogID + ", referenced artifact did not exist.");
continue;
}
try
{
//The artifact exists, let's add a comment..
RemoteComment comment = new RemoteComment();
comment.ArtifactId = artId;
comment.CreationDate = DateTime.UtcNow;
comment.UserId = selUser.UserId;
comment.Text = this.getTextFromMessage(msg, true, true);
switch (artType)
{
case ArtifactTypeEnum.Requirement:
comment = clientAppl.Requirement_CreateComment(comment);
break;
case ArtifactTypeEnum.Test_Case:
comment = clientAppl.TestCase_CreateComment(comment);
break;
case ArtifactTypeEnum.Incident:
comment = clientAppl.Incident_AddComments(new List <RemoteComment>()
{
comment
}).FirstOrDefault();
break;
case ArtifactTypeEnum.Release:
comment = clientAppl.Release_CreateComment(comment);
break;
case ArtifactTypeEnum.Task:
comment = clientAppl.Task_CreateComment(comment);
break;
case ArtifactTypeEnum.Test_Set:
comment = clientAppl.TestSet_CreateComment(comment);
break;
}
if (comment != null && comment.CommentId.HasValue)
{
//Now check for attachments
try
{
foreach (MessagePart attach in msg.FindAllAttachments().Where(aa => aa.IsMultiPart == false && aa.IsText == false))
{
//Add the file..
RemoteLinkedArtifact artifactLink = new RemoteLinkedArtifact();
artifactLink.ArtifactId = comment.ArtifactId;
artifactLink.ArtifactTypeId = (int)artType;
RemoteDocument newDoc = new RemoteDocument();
newDoc.AttachedArtifacts = new List <RemoteLinkedArtifact>()
{
artifactLink
};
newDoc.AttachmentTypeId = 1;
newDoc.AuthorId = selUser.UserId;
newDoc.FilenameOrUrl = attach.FileName;
newDoc.UploadDate = DateTime.UtcNow;
//Check for string overrun and add extension if necessary.
if (newDoc.FilenameOrUrl.Length > 250)
{
newDoc.FilenameOrUrl = newDoc.FilenameOrUrl.Substring(0, 250);
}
if (string.IsNullOrWhiteSpace(Path.GetExtension(newDoc.FilenameOrUrl)) && attach.ContentType != null)
{
string tempFileExtension = Utils.GetExtensionFromMimeType(attach.ContentType.MediaType);
if (!string.IsNullOrWhiteSpace(tempFileExtension))
{
newDoc.FilenameOrUrl += "." + tempFileExtension;
}
}
//Call the function to upload the file to Spira
newDoc = clientAppl.Document_AddFile(newDoc, attach.Body);
//Log it.
this._eventLog.WriteMessage("Attachment #" + newDoc.AttachmentId.ToSafeString() + " created from file '" + attach.FileName + "' for Artifact " + artType + " #:" + comment.ArtifactId + " from message " + msg.MessageLogID + ".", System.Diagnostics.EventLogEntryType.Information);
}
}
catch (Exception ex)
{
//Log and continue
this._eventLog.WriteMessage(METHOD, ex, "Saving attachment for message " + msg.MessageLogID);
}
}
}
catch (Exception ex)
{
this._eventLog.WriteMessage(METHOD, ex, "While trying to save message '" + msg.MessageLogID + "' as a new comment.");
continue;
}
//If we get this far, mark the message as processed.
try
{
//Add it to our list..
seenUIDs.Add(msg.MessageUID);
if (account.RemoveFromServer)
{
clientPOP3.DeleteMessage(msg.MessageIndex);
}
}
catch (Exception ex)
{
this._eventLog.WriteMessage(METHOD, ex, "Trying to delete message " + msg.MessageLogID + " from server.");
}
}
else
{
string msgLog = "";
if (userCnt == 0)
{
msgLog = "Message " + msg.MessageLogID + " was sent from a user not a mamber of the specified project. Not importing unknown users.";
}
else if (userCnt > 1)
{
msgLog = "Message " + msg.MessageLogID + " was sent from a user that did not have a unique email address. Cannot import to avoid selecting the wrong user.";
}
this._eventLog.WriteMessage(msgLog, System.Diagnostics.EventLogEntryType.Information);
}
}
else
{
if (artType != ArtifactTypeEnum.Skip)
{
int userCnt = spiraUsers.Where(su => su.EmailAddress.ToLowerInvariant() == msg.Headers.From.MailAddress.Address.ToLowerInvariant()).Count();
if (userCnt == 1)
{
RemoteProjectUser selUser = spiraUsers.Where(su => su.EmailAddress.ToLowerInvariant() == msg.Headers.From.MailAddress.Address.ToLowerInvariant()).Single();
//Create a new Incident..
RemoteIncident newIncident = new RemoteIncident();
newIncident.CreationDate = DateTime.Now;
newIncident.Description = this.getTextFromMessage(msg, true, false);
newIncident.Name = msg.Headers.Subject;
newIncident.OpenerId = selUser.UserId;
//Check regex other projects
if (account.UseRegexToMatch)
{
Regex regProj1 = new Regex(@"\[PR[\:\-\s](\d*?)\]", RegexOptions.IgnoreCase | RegexOptions.CultureInvariant);
if (regProj1.IsMatch(newIncident.Description) || regProj1.IsMatch(newIncident.Name))
{
//Someone used the PR tag in the email body, we'll use it, if possible.
string matchNum = "";
if (regProj1.IsMatch(newIncident.Name))
{
matchNum = regProj1.Matches(newIncident.Name)[0].Groups[1].Value;
}
else if (regProj1.IsMatch(newIncident.Description))
{
matchNum = regProj1.Matches(newIncident.Description)[0].Groups[1].Value;
}
else
{
this._eventLog.WriteMessage("ERROR: At least one RegEx returned IsMatch, but none contained match.", System.Diagnostics.EventLogEntryType.Information);
continue;
}
int projNum = 0;
if (int.TryParse(matchNum, out projNum))
{
//We had a number, let's see if it's a valid product.
RemoteProject proj = spiraProjs.FirstOrDefault(prd => prd.ProjectId == projNum);
if (proj != null)
{
//Connect to project..
if (clientAppl.Connection_ConnectToProject(proj.ProjectId.Value))
{
newIncident.ProjectId = proj.ProjectId.Value;
this._eventLog.WriteMessage("Message " + msg.MessageLogID + " changed to Project '" + proj.Name + "' due to having [PR:xx] tag.", System.Diagnostics.EventLogEntryType.Information);
}
else
{
this._eventLog.WriteMessage("Message " + msg.MessageLogID + " contained project token for project '" + proj.Name + "', but email import has no access to that project. Using default.", System.Diagnostics.EventLogEntryType.Information);
}
}
else
{
this._eventLog.WriteMessage("Message '" + msg.MessageLogID + "' contained token for project " + projNum.ToString() + " but project was inaccessible. Using default.", System.Diagnostics.EventLogEntryType.Information);
}
}
}
else
{
foreach (RemoteProject prod in spiraProjs)
{
Regex regProd3 = new Regex(@"\b" + prod.Name + @"\b", RegexOptions.CultureInvariant | RegexOptions.IgnoreCase);
if (regProd3.IsMatch(newIncident.Description) || regProd3.IsMatch(newIncident.Name))
{
newIncident.ProjectId = prod.ProjectId.Value;
this._eventLog.WriteMessage("Message " + msg.MessageLogID + " changed to Product '" + prod.Name + "' due to having Product name '" + prod.Name + "'", System.Diagnostics.EventLogEntryType.Information);
break;
}
}
}
}
//Now save the Incident..
try
{
newIncident = clientAppl.Incident_Create(newIncident);
if (newIncident.IncidentId.HasValue)
{
//Now check for attachments
try
{
foreach (MessagePart attach in msg.FindAllAttachments().Where(aa => aa.IsMultiPart == false && aa.IsText == false))
{
//Add the file..
RemoteLinkedArtifact artifactLink = new RemoteLinkedArtifact();
artifactLink.ArtifactId = newIncident.IncidentId.Value;
artifactLink.ArtifactTypeId = 3; /* Incident */
RemoteDocument newDoc = new RemoteDocument();
newDoc.AttachedArtifacts = new List <RemoteLinkedArtifact>()
{
artifactLink
};
newDoc.AttachmentTypeId = 1;
newDoc.AuthorId = selUser.UserId;
newDoc.FilenameOrUrl = attach.FileName;
newDoc.UploadDate = DateTime.UtcNow;
//Check for string overrun and add extension if necessary.
if (newDoc.FilenameOrUrl.Length > 250)
{
newDoc.FilenameOrUrl = newDoc.FilenameOrUrl.Substring(0, 250);
}
if (string.IsNullOrWhiteSpace(Path.GetExtension(newDoc.FilenameOrUrl)) && attach.ContentType != null)
{
string tempFileExtension = Utils.GetExtensionFromMimeType(attach.ContentType.MediaType);
if (!string.IsNullOrWhiteSpace(tempFileExtension))
{
newDoc.FilenameOrUrl += "." + tempFileExtension;
}
}
//Call the function to upload the file to Spira
newDoc = clientAppl.Document_AddFile(newDoc, attach.Body);
//Log it.
this._eventLog.WriteMessage("Attachment #" + newDoc.AttachmentId.ToSafeString() + " created from file '" + attach.FileName + "' for Incident IN:" + newIncident.IncidentId.Value + " from message " + msg.MessageLogID + ".", System.Diagnostics.EventLogEntryType.Information);
}
}
catch (Exception ex)
{
//Log and continue
this._eventLog.WriteMessage(METHOD, ex, "Saving attachment for message " + msg.MessageLogID);
}
}
//If we get this far, mark the message as processed.
try
{
//Add it to our list..
seenUIDs.Add(msg.MessageUID);
if (account.RemoveFromServer)
{
clientPOP3.DeleteMessage(msg.MessageIndex);
}
}
catch (Exception ex)
{
this._eventLog.WriteMessage(METHOD, ex, "Trying to delete message " + msg.MessageLogID + " from server.");
}
}
catch (Exception ex)
{
this._eventLog.WriteMessage(METHOD, ex, "While trying to save message '" + msg.MessageLogID + "' as an incident.");
}
}
else
{
string msgLog = "";
if (userCnt == 0)
{
msgLog = "Message " + msg.MessageLogID + " was sent from a user not a mamber of the specified project. Not importing unknown users.";
}
else if (userCnt > 1)
{
msgLog = "Message " + msg.MessageLogID + " was sent from a user that did not have a unique email address. Cannot import to avoid selecting the wrong user.";
}
this._eventLog.WriteMessage(msgLog, System.Diagnostics.EventLogEntryType.Information);
}
}
else
{
}
}
}
else
{
//Log it..
this._eventLog.WriteMessage("Message " + msg.MessageLogID + " on the server did not pass filters:" + Environment.NewLine + "Subject: " + msg.Headers.Subject + Environment.NewLine + "Reasons: " + Environment.NewLine + filterMsg, System.Diagnostics.EventLogEntryType.Warning);
}
}
else
{
//Log it..
this._eventLog.WriteMessage("Message " + msg.MessageLogID + " had no From address or was from the import account --" + Environment.NewLine + "Subject: " + msg.Headers.Subject + Environment.NewLine + "Msg UID: " + msg.Headers.MessageId + Environment.NewLine + "For reason: From Email address same as importing account, or was null.", System.Diagnostics.EventLogEntryType.Warning);
}
}
//Save the seen message IDs..
this.saveMessageIDsForAccount(account.AccountID.Value, seenUIDs);
//Disconnect client and POP3..
try
{
clientPOP3.Disconnect();
clientAppl.Connection_Disconnect();
}
catch (Exception ex)
{
this._eventLog.WriteMessage(METHOD, ex, "Trying to close connections.");
}
}
