public IIssueFilter[] GetFilters()
{
List <IIssueFilter> filters = new List <IIssueFilter>();
try
{
// foreach (RemoteFilter filter in _service.getSavedFilters(Token))
foreach (JiraNamedEntity JNE in jira.GetFilters())
{ // Need to convert a JiraNamedEntitiy to RemoteFilter
RemoteFilter filter = new RemoteFilter {
name = JNE.Name, id = JNE.Id
};
Log.Info("The filter is {0}", filter.name);
filters.Add(new JiraFilter(this, filter));
}
}
catch (Exception e) { Log.Warning(e); }
filters.Sort(new NameSorter <IIssueFilter>());
//RemoteServerInfo jiraInfo = _service.getServerInfo(_token);
//if (new Version(jiraInfo.version) < new Version("4.0"))
filters.Add(new JiraAllFilter(this));
return(filters.ToArray());
}
/// <summary>Generates a filter for pulling information from the Spira server.</summary>
/// <param name="UserNum">The user number of the data to pull for.</param>
/// <param name="IncludeComplete">Whether or not to include completed/closed items.</param>
/// <param name="IncTypeCode">The string type code of the artifact. "TK", "IN", "RQ"</param>
/// <returns>A RemoteFilter set.</returns>
public static List <RemoteFilter> GenerateFilter(int UserNum, bool IncludeComplete, string IncTypeCode)
{
try
{
RemoteFilter userFilter = new RemoteFilter()
{
PropertyName = "OwnerId", IntValue = UserNum
};
RemoteFilter statusFilter = new RemoteFilter();
if (!IncludeComplete)
{
switch (IncTypeCode.ToUpperInvariant())
{
case "IN":
{
statusFilter = new RemoteFilter()
{
PropertyName = "IncidentStatusId", IntValue = -2
};
}
break;
case "TK":
{
MultiValueFilter multiValue = new MultiValueFilter();
multiValue.Values = new List <int> {
1, 2, 4, 5
};
statusFilter = new RemoteFilter()
{
PropertyName = "TaskStatusId", MultiValue = multiValue
};
}
break;
case "RQ":
{
MultiValueFilter multiValue = new MultiValueFilter();
multiValue.Values = new List <int> {
1, 2, 3, 5, 7
};
statusFilter = new RemoteFilter()
{
PropertyName = "ScopeLevelId", MultiValue = multiValue
};
}
break;
}
}
return(new List <RemoteFilter> {
userFilter, statusFilter
});
}
catch (Exception ex)
{
Logger.LogMessage(ex);
return(null);
}
}
/// <summary>Generates a filter for pulling information from the Spira server.</summary>
/// <param name="UserNum">The user number of the data to pull for.</param>
/// <param name="IncludeComplete">Whether or not to include completed/closed items.</param>
/// <param name="IncTypeCode">The string type code of the artifact. "TK", "IN", "RQ"</param>
/// <returns>A RemoteFilter set.</returns>
private RemoteFilter[] GenerateFilter(int UserNum, bool IncludeComplete, string IncTypeCode)
{
try
{
RemoteFilter userFilter = new RemoteFilter()
{
PropertyName = "OwnerId", IntValue = UserNum
};
RemoteFilter statusFilter = new RemoteFilter();
if (!IncludeComplete)
{
switch (IncTypeCode.ToUpperInvariant())
{
case "IN":
{
statusFilter = new RemoteFilter()
{
PropertyName = "IncidentStatusId", IntValue = -2
};
}
break;
case "TK":
{
MultiValueFilter multiValue = new MultiValueFilter();
multiValue.Values = new int[] { 1, 2, 4, 5 };
statusFilter = new RemoteFilter()
{
PropertyName = "TaskStatusId", MultiValue = multiValue
};
}
break;
case "RQ":
{
MultiValueFilter multiValue = new MultiValueFilter();
multiValue.Values = new int[] { 1, 2, 3, 5, 7 };
statusFilter = new RemoteFilter()
{
PropertyName = "ScopeLevelId", MultiValue = multiValue
};
}
break;
}
}
return(new RemoteFilter[] { userFilter, statusFilter });
}
catch (Exception ex)
{
Connect.logEventMessage("wpfProjectTree::GenerateFilter", ex, System.Diagnostics.EventLogEntryType.Error);
return(null);
}
}
public int Count(
[DekiExtParam("filter name")] string filter
)
{
InitializeService();
InitializeFilters();
RemoteFilter f = RetrieveFilter(filter);
return((int)_jira.getIssueCountForFilter(_jiraToken, f.id));
}
private RemoteFilter RetrieveFilter(string filterName)
{
RemoteFilter f = null;
_filters.TryGetValue(filterName.ToLowerInvariant(), out f);
if (f == null)
{
//If a filter wasn't found, try refetching them from the server while ignoring cache
InitializeFilters(true);
_filters.TryGetValue(filterName.ToLowerInvariant(), out f);
if (f == null)
{
throw new ArgumentException(string.Format("Unable to find filter '{0}'", filterName), "filterName");
}
}
return(f);
}
public XDoc Table(
[DekiExtParam("filter name")] string filter
)
{
InitializeService();
InitializeStatuses();
InitializeFilters();
InitializePriorities();
RemoteFilter f = RetrieveFilter(filter);
RemoteIssue[] issues = _jira.getIssuesFromFilter(_jiraToken, f.id);
XDoc bugList = BuildBugListHTMLTable(issues);
XDoc ret = new XDoc("html");
ret.Start("head")
.Start("script").Attr("type", "text/javascript").Attr("src", Files.At("sorttable.js")).End()
.Start("link").Attr("type", "text/css").Attr("rel", "stylesheet").Attr("href", Files.At("Jira.css")).End()
.Start("style").Attr("type", "text/css").Value(@".feedtable {
border:1px solid #999;
line-height:1.5em;
overflow:hidden;
width:100%;
}
.feedtable th {
background-color:#ddd;
border-bottom:1px solid #999;
font-size:14px;
}
.feedtable tr {
background-color:#FFFFFF;
}
.feedtable tr.feedroweven td {
background-color:#ededed;
}").End()
.End();
ret.Start("body").Add(bugList).End();
return(ret);
}
static void Main(string[] args)
{
_options = new Settings();
if (Parser.Default.ParseArguments(args, _options))
{
//Make sure that the Spira string is a URL.
Uri serverUrl = null;
string servicePath = _options.SpiraServer +
((_options.SpiraServer.EndsWith("/") ? "" : "/")) +
"Services/v5_0/SoapService.svc";
if (!Uri.TryCreate(servicePath, UriKind.Absolute, out serverUrl))
{
//Throw error: URL given not a URL.
return;
}
//See if we have a mappings file specified, if so, make sure it exists
List <ArtifactMapping> artifactMappings = null;
string customPropertyField = null;
if (!String.IsNullOrWhiteSpace(_options.SpiraMappingsFile))
{
if (!File.Exists(_options.SpiraMappingsFile))
{
//Throw error: Bad path.
ConsoleLog(LogLevelEnum.Normal, "Cannot access the mapping file, please check the location and try again!");
Environment.Exit(-1);
}
artifactMappings = new List <ArtifactMapping>();
//Read in the lines, the first column should contain:
//Filename,ArtifactTypeId,Custom_03
//where the number in the third column is the name of the custom property that the IDs will be using
using (StreamReader streamReader = File.OpenText(_options.SpiraMappingsFile))
{
string firstLine = streamReader.ReadLine();
string[] headings = firstLine.Split(',');
//See if we have a match on the custom property number
if (headings.Length > 2 && !String.IsNullOrWhiteSpace(headings[2]))
{
customPropertyField = headings[2].Trim();
//Now read in the rows of mappings
while (!streamReader.EndOfStream)
{
string mappingLine = streamReader.ReadLine();
ArtifactMapping artifactMapping = new ArtifactMapping();
string[] components = mappingLine.Split(',');
artifactMapping.Filename = components[0];
artifactMapping.ArtifactTypeId = Int32.Parse(components[1]);
artifactMapping.ExternalKey = components[2];
artifactMappings.Add(artifactMapping);
}
streamReader.Close();
}
}
}
//Make sure the path given is a real path..
try
{
Directory.GetCreationTime(_options.ImportPath);
}
catch
{
//Throw error: Bad path.
ConsoleLog(LogLevelEnum.Normal, "Cannot access the import path, please check the location and try again!");
Environment.Exit(-1);
}
//Tell user we're operating.
ConsoleLog(LogLevelEnum.Normal, "Importing files in " + _options.ImportPath);
//Now run through connecting procedures.
ConsoleLog(LogLevelEnum.Verbose, "Connecting to Spira server...");
SoapServiceClient client = CreateClient_Spira5(serverUrl);
client.Open();
if (client.Connection_Authenticate2(_options.SpiraLogin, _options.SpiraPass, "DocumentImporter"))
{
ConsoleLog(LogLevelEnum.Verbose, "Selecting Spira project...");
var Projects = client.Project_Retrieve();
RemoteProject proj = Projects.FirstOrDefault(p => p.ProjectId == _options.SpiraProject);
if (proj != null)
{
//Connect to the project.
if (client.Connection_ConnectToProject((int)_options.SpiraProject))
{
ConsoleLog(LogLevelEnum.Normal, "Uploading files...");
//Now let's get a list of all the files..
SearchOption opt = ((_options.PathRecursive) ? SearchOption.AllDirectories : SearchOption.TopDirectoryOnly);
List <string> files = Directory.EnumerateFiles(_options.ImportPath, _options.ImportFilter, opt).ToList();
//Loop through each file and upload it.
ConsoleLog(LogLevelEnum.Verbose, "Files:");
foreach (string file in files)
{
string conLog = Path.GetFileName(file);
try
{
//Get the file details..
FileInfo fileInf = new FileInfo(file);
string size = "";
if (fileInf.Length >= 1000000000)
{
size = (fileInf.Length / 1000000000).ToString() + "Gb";
}
else if (fileInf.Length >= 1000000)
{
size = (fileInf.Length / 1000000).ToString() + "Mb";
}
else if (fileInf.Length >= 1000)
{
size = (fileInf.Length / 1000).ToString() + "Kb";
}
else
{
size = fileInf.Length.ToString() + "b";
}
conLog += " (" + size + ")";
//Generate the RemoteDocument object.
RemoteDocument newFile = new RemoteDocument();
newFile.AttachmentTypeId = 1;
newFile.FilenameOrUrl = Path.GetFileName(file);
newFile.Size = (int)fileInf.Length;
newFile.UploadDate = DateTime.UtcNow;
//Now we see if have mapped artifact
ArtifactMapping mappedArtifact = artifactMappings.FirstOrDefault(m => m.Filename.ToLowerInvariant() == newFile.FilenameOrUrl.ToLowerInvariant());
if (mappedArtifact != null && !String.IsNullOrEmpty(customPropertyField))
{
//We have to lookup the artifact, currently only incidents are supported
if (mappedArtifact.ArtifactTypeId == 3)
{
//Retrieve the incident
RemoteSort sort = new RemoteSort();
sort.PropertyName = "IncidentId";
sort.SortAscending = true;
List <RemoteFilter> filters = new List <RemoteFilter>();
RemoteFilter filter = new RemoteFilter();
filter.PropertyName = customPropertyField;
filter.StringValue = mappedArtifact.ExternalKey;
filters.Add(filter);
RemoteIncident remoteIncident = client.Incident_Retrieve(filters, sort, 1, 1).FirstOrDefault();
if (remoteIncident != null)
{
RemoteLinkedArtifact remoteLinkedArtifact = new SpiraService.RemoteLinkedArtifact();
remoteLinkedArtifact.ArtifactTypeId = mappedArtifact.ArtifactTypeId;
remoteLinkedArtifact.ArtifactId = remoteIncident.IncidentId.Value;
newFile.AttachedArtifacts = new List <RemoteLinkedArtifact>();
newFile.AttachedArtifacts.Add(remoteLinkedArtifact);
}
}
else
{
ConsoleLog(LogLevelEnum.Normal, "Warning: Only incident mapped artifacts currently supported, so ignoring the mapped artifacts of type: " + mappedArtifact.ArtifactTypeId);
}
}
//Read the file contents. (Into memory! Beware, large files!)
byte[] fileContents = null;
fileContents = File.ReadAllBytes(file);
ConsoleLog(LogLevelEnum.Verbose, conLog);
if (fileContents != null && fileContents.Length > 1)
{
newFile.AttachmentId = client.Document_AddFile(newFile, fileContents).AttachmentId.Value;
}
else
{
throw new FileEmptyException();
}
}
catch (Exception ex)
{
conLog += " - Error. (" + ex.GetType().ToString() + ")";
ConsoleLog(LogLevelEnum.Normal, conLog);
}
}
}
else
{
ConsoleLog(LogLevelEnum.Normal, "Cannot connect to project. Verify your Project Role.");
Environment.Exit(-1);
}
}
else
{
ConsoleLog(LogLevelEnum.Normal, "Cannot connect to project. Project #" + _options.SpiraProject.ToString() + " does not exist.");
Environment.Exit(-1);
}
}
else
{
ConsoleLog(LogLevelEnum.Normal, "Cannot log in. Check username and password.");
Environment.Exit(-1);
}
}
else
{
Environment.Exit(-1);
}
}