private void backgroundWorker_DoWork(object sender, DoWorkEventArgs e)
{
try
{
CommentCount = 1;
rp("Logging in into Crucible...");
Stream auth = getHttpStream(
String.Format(Properties.Settings.Default.CrucibleLoginUrl, Properties.Settings.Default.CrucibleUserName,
Properties.Settings.Default.CruciblePassword));
XmlSerializer asr = new XmlSerializer(typeof(loginResult));
loginResult lr = (loginResult)asr.Deserialize(auth);
rp("Login complete...");
rp("Fetching reviews...");
Stream rvs = getHttpStream(String.Format(Properties.Settings.Default.CrucibleReviewsUrl,
Properties.Settings.Default.CrucibleProject, lr.token));
XmlSerializer rsr = new XmlSerializer(typeof(reviews));
reviews reviews = (reviews)rsr.Deserialize(rvs);
rp("Opening Excel...");
Excel.Application oXL = new Excel.Application();
Excel.Workbook workBook = oXL.Workbooks.Add(System.Reflection.Missing.Value);
rp("Preparing the workbook...");
PrepareExcelWorkbook(workBook);
Excel.Worksheet workSheet = (Excel.Worksheet)workBook.Sheets[1];
rp("Logging in into Jira...");
JiraSoapServiceService jss = new JiraSoapServiceService();
string token = jss.login(Properties.Settings.Default.CrucibleUserName,
Properties.Settings.Default.CruciblePassword);
rp("Loading Jira versions");
foreach (RemoteVersion ver in jss.getVersions(token,Properties.Settings.Default.JiraProjectName))
{
revHash[ver.id] = ver.name;
log(String.Format("Adding [{0}] : [{1}] to hash", ver.name, ver.id));
}
rp("Populating data into workbook...");
int rowIndex = 2;
foreach (reviewData rv in reviews.reviewData)
{
if(
(Properties.Settings.Default.CrucibleFetchAllReviews == false) &&
( rv.state != state.Closed )
)
{
log("Incomplete review, skipping " + rv.permaId.id);
continue;
}
else
{
rp("Processing " + rv.permaId.id);
Stream cms = getHttpStream(String.Format(Properties.Settings.Default.CrucibleCommentUrl, rv.permaId.id, lr.token));
XmlSerializer cmr = new XmlSerializer(typeof(comments));
comments rcomments = (comments)cmr.Deserialize(cms);
if (rcomments.Any != null)
{
foreach (System.Xml.XmlElement elem in rcomments.Any)
{
XmlSerializer vlcdr = new XmlSerializer(typeof(versionedLineCommentData));
versionedLineCommentData vlcd = (versionedLineCommentData)vlcdr.Deserialize(new StringReader(
decorate(elem.InnerXml, "versionedLineCommentData")));
WriteExcelRow(workSheet, rowIndex, rv, vlcd, jss, token);
rowIndex++;
}
}
else
{
rp("Skipping " + rv.permaId.id + ". No review comments detected.");
}
}
}
oXL.Visible = true;
oXL.UserControl = true;
}
catch (Exception exp)
{
rp("Sorry, exception occured, after all this is software and there is no CI for this :)\r\n" +
exp.Message + "\r\n" + exp.StackTrace);
}
rp("Completed...");
}
