/// <summary>
/// Somecomment
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public HttpResponseMessage GetJiraItem(int id)
{
JiraItem gettingJiraItem = FindJiraItem(id);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, gettingJiraItem);
return(response);
}
public List <JiraItem> GetItems()
{
List <JiraItem> output = new List <JiraItem>();
List <string> urls = new List <string>()
{
"http://chzhbapp521.ch.kworld.kpmg.com:8080/projects/SIM/issues/SIM-1?filter=allopenissues"
//"http://chzhbapp521.ch.kworld.kpmg.com:8080/projects/SIM/issues/SIM-2?filter=allopenissues",
//"http://chzhbapp521.ch.kworld.kpmg.com:8080/projects/SIM/issues/SIM-3?filter=allopenissues",
//"http://chzhbapp521.ch.kworld.kpmg.com:8080/projects/SIM/issues/SIM-4?filter=allopenissues",
//"http://chzhbapp521.ch.kworld.kpmg.com:8080/projects/SIM/issues/SIM-5?filter=allopenissues",
//"http://chzhbapp521.ch.kworld.kpmg.com:8080/projects/SIM/issues/SIM-6?filter=allopenissues",
//"http://chzhbapp521.ch.kworld.kpmg.com:8080/projects/SIM/issues/SIM-7?filter=allopenissues",
//"http://chzhbapp521.ch.kworld.kpmg.com:8080/projects/SIM/issues/SIM-8?filter=allopenissues",
//"http://chzhbapp521.ch.kworld.kpmg.com:8080/projects/SIM/issues/SIM-9?filter=allopenissues",
//"http://chzhbapp521.ch.kworld.kpmg.com:8080/projects/SIM/issues/SIM-10?filter=allopenissues",
//"http://chzhbapp521.ch.kworld.kpmg.com:8080/projects/SIM/issues/SIM-11?filter=allopenissues"
};
foreach (string url in urls)
{
Regex regex = new Regex(@"\d\\"",\\""status\\"":\\""(?<status>[^\\]+)\\"",\\""summary\\"":\\""(?<summary>[^\\]+)", RegexOptions.Compiled); //SIM\-\\""\,\\""
var resoult = new HttpClient().GetStringAsync(url).Result;
MatchCollection matches = regex.Matches(resoult);
foreach (Match match in matches)
{
JiraItem item = new JiraItem();
item.Country = match.Groups["summary"].Value;
switch (match.Groups["status"].Value.Trim())
{
case "To Do":
item.status = Data.JiraStatusEnum.To_do;
break;
case "Sign-off":
item.status = Data.JiraStatusEnum.Sign_off;
break;
}
output.Add(item);
}
List <string> countrysTmp = new List <string>();
List <JiraItem> tmpOutput = new List <JiraItem>();
foreach (var item in output)
{
if (!countrysTmp.Any(i => i == item.Country))
{
countrysTmp.Add(item.Country);
tmpOutput.Add(item);
}
}
output = tmpOutput;
}
return(output);
}
public static string transExpectedResults(JiraItem jiraItem)
{
string actualItem = "";
foreach (var item in jiraItem.expectedResultList)
{
actualItem += "<ExpectedResults>" + item + "</ExpectedResults>" + "\n";
}
return(actualItem);
}
public static string transActualResults(JiraItem jiraItem)
{
string actualItem = "";
foreach (var item in jiraItem.actualResultList)
{
actualItem += "<ActualResults>" + item + "</ActualResults>" + "\n";
}
return(actualItem);
}
public static string transStepsList(JiraItem jiraItem)
{
string actualItem = "";
foreach (var item in jiraItem.stepsList)
{
actualItem += "<StepsToReproduce>" + item + "</StepsToReproduce>" + "\n";
}
return(actualItem);
}
public static string transPrerequisites(JiraItem jiraItem)
{
string actualItem = "";
foreach (var item in jiraItem.prerequisitesList)
{
actualItem += "<Prerequisites>" + item + "</Prerequisites>" + "\n";
}
return(actualItem);
}
internal static JiraItem FindJiraItem(int jiraItemId)
{
JiraItem searchingJiraItem = _jiraItems.FirstOrDefault(j => j.JiraItemId == jiraItemId);
if (searchingJiraItem == null)
{
throw new NoExistItemException("JiraItem", jiraItemId);
}
return(searchingJiraItem);
}
public static void Main(string[] args)
{
var config = new ConfigManager();
var driver = new ChromeDriver(ChromeDriverService.CreateDefaultService(), new ChromeOptions(), TimeSpan.FromMinutes(5));
driver.Navigate().GoToUrl(config.BaseUri + "/jira/login.jsp");
driver.Wait();
var jiraHelper = new JiraHelper();
jiraHelper.Login(driver);
var jqlQuery = HttpUtility.UrlEncode("updated >= " + config.Period + " and timespent > 0 and project in" + config.Projects);
driver.Navigate().GoToUrl(config.BaseUri + "/jira/secure/IssueNavigator!executeAdvanced.jspa?jqlQuery=" + jqlQuery + "&runQuery=true&clear=true");
driver.Wait();
var totalCount = int.Parse(driver.FindElementByClassName("results-count-total").Text);
var lastUpdated = driver.FindElements(By.CssSelector("td[class^='nav updated']")).Select(x => x.Text).ToList();
var issues = driver.FindElements(By.CssSelector("td[class^='nav issuekey']")).Select(x => x.Text).ToList();
for (var j = 50; j <= totalCount + 50; j = j + 50)
{
driver.Navigate().GoToUrl(config.BaseUri + "/jira/secure/IssueNavigator.jspa?pager/start=" + j);
driver.Wait();
lastUpdated.AddRange(driver.FindElements(By.CssSelector("td[class^='nav updated']")).Select(x => x.Text));
issues.AddRange(driver.FindElements(By.CssSelector("td[class^='nav issuekey']")).Select(x => x.Text));
}
var i = 0;
var jiraItems = new List <JiraItem>();
foreach (var issue in issues)
{
var jiraItem = new JiraItem();
var date = DateTime.Parse(lastUpdated[i]);
jiraItem.JiraId = issue;
jiraItem.LastUpdated = date;
jiraItem.WorkLog = jiraHelper.GetLog(driver, config.BaseUri, issue, config.Assignees);
jiraItems.Add(jiraItem);
i++;
}
var logs = jiraItems.SelectMany(x => x.WorkLog).Where(x => x.DateTimeLogged > config.CutoffDate).OrderBy(x => x.DisplayName);
var frankLog = logs.Where(x => x.JiraName == "fzhong");
}
public static string transEnviromentAndVersion(JiraItem jiraItem)
{
return("<Enviroment-Version>" + jiraItem.enviroment.ToString() + "</Enviroment-Version>");
}
public static string transTittle(JiraItem jiraItem)
{
return("<Title>" + jiraItem.title.ToString() + "</Title>");
}
public static string transDate(JiraItem jiraItem)
{
return("<Date>" + jiraItem.date.ToString() + "</Date>");
}
public static string transAuthor(JiraItem jiraItem)
{
return("<Author>" + jiraItem.author.ToString() + "</Author>");
}
public static string transID(JiraItem jiraItem)
{
return("<ID>" + jiraItem.ID.ToString() + "</ID>");
}
protected override void Seed(ApplicationContext db)
{
var attachment1 = new Attachment
{
Id = 1,
MailId = 1,
FileExtention = "pdf",
FileName = "Pdf attachment",
Path = "somepath",
StatusId = 1
};
var attachment2 = new Attachment
{
Id = 2,
MailId = 1,
FileExtention = "txt",
FileName = "Txt attachment",
Path = "somepath",
StatusId = 1
};
var attachment3 = new Attachment
{
Id = 3,
MailId = 2,
FileExtention = "pdf",
FileName = "Pdf attachment",
Path = "somepath",
StatusId = 1
};
var attachment4 = new Attachment
{
Id = 4,
MailId = 3,
FileExtention = "pdf",
FileName = "Pdf attachment",
Path = "somepath",
StatusId = 1
};
var attachment5 = new Attachment
{
Id = 5,
MailId = 3,
FileExtention = "txt",
FileName = "Txt attachment",
Path = "somepath",
StatusId = 1
};
var attachment6 = new Attachment
{
Id = 6,
MailId = 3,
FileExtention = "jpg",
FileName = "Jpg attachment",
Path = "somepath",
StatusId = 1
};
var attachment7 = new Attachment
{
Id = 7,
MailId = 4,
FileExtention = "Jpg",
FileName = "Jpg attachment",
Path = "somepath",
StatusId = 1
};
var mail1 = new Mail
{
Id = 1,
AttachementIds = new List <int>(new [] { 1, 2 }),
Body = "1st mail",
Priority = Priority.Medium,
Cc = "mail",
Sender = "Anonym",
Subject = "Work",
Received = DateTime.Now,
Saved = DateTime.Now
};
var mail2 = new Mail
{
Id = 2,
AttachementIds = new List <int>(new[] { 3 }),
Body = "2nd mail",
Priority = Priority.Medium,
Cc = "mail",
Sender = "Anonym",
Subject = "Spam",
Received = DateTime.Now,
Saved = DateTime.Now
};
var mail3 = new Mail
{
Id = 3,
AttachementIds = new List <int>(new[] { 4, 5, 6 }),
Body = "3rd mail",
Priority = Priority.Medium,
Cc = "mail",
Sender = "Anonym",
Subject = "",
Received = DateTime.Now,
Saved = DateTime.Now
};
var mail4 = new Mail
{
Id = 2,
AttachementIds = new List <int>(new[] { 7 }),
Body = "4th mail",
Priority = Priority.Medium,
Cc = "mail",
Sender = "Anonym",
Subject = "Help",
Received = DateTime.Now,
Saved = DateTime.Now
};
var jira1 = new JiraItem
{
Id = 1,
JiraNumber = 1,
JiraSourceId = 1,
};
var jira2 = new JiraItem
{
Id = 2,
JiraNumber = 2,
JiraSourceId = 2,
};
var jira3 = new JiraItem
{
Id = 3,
JiraNumber = 3,
JiraSourceId = 3,
};
var jira4 = new JiraItem
{
Id = 4,
JiraNumber = 4,
JiraSourceId = 4,
};
db.Attachments.Add(attachment1);
db.Attachments.Add(attachment2);
db.Attachments.Add(attachment3);
db.Attachments.Add(attachment4);
db.Attachments.Add(attachment5);
db.Attachments.Add(attachment6);
db.Attachments.Add(attachment7);
db.Mails.Add(mail1);
db.Mails.Add(mail2);
db.Mails.Add(mail3);
db.Mails.Add(mail4);
db.JiraItems.Add(jira1);
db.JiraItems.Add(jira2);
db.JiraItems.Add(jira3);
db.JiraItems.Add(jira4);
}
