private void CreateBaseline(BaselineInfo baselineInfo)
{
string cmdString =
$"INSERT INTO baseline (id,Name,CreatedBy, CreatedDate) VALUES ({baselineInfo.BaselineId}, '{baselineInfo.BaselineName}', '{baselineInfo.CreatedBy}','{baselineInfo.CreatedDate}')";
InsertCommand(cmdString);
}
/// <summary>
/// name is a unique identifier (example name) for each example, currently module name
/// </summary>
/// <param name="name"></param>
/// <param name="currDir"></param>
/// <param name="srcPath"></param>
/// <param name="baseDir"></param>
/// <param name="hrg"></param>
private static void ProcessSingleModule(string name, string currDir, string srcPath, string baseDir, HtmlReportGeneration hrg)
{
var ari1 = new AvnResultInfo(currDir, srcPath, name); ari1.LoadResultInfo();
try
{
AvnResultInfo ari2 = null;
BaselineInfo bi = null;
if (baseDir != null)
{
ari2 = new AvnResultInfo(baseDir, srcPath, name); ari2.LoadResultInfo();
bi = new BaselineInfo(ari1, ari2);
bi.MatchResults();
}
hrg.WriteHtml(ari1, ari2, bi);
} catch (Exception e)
{
Console.WriteLine(string.Format("ERROR: Skipping {0} due to exception {1}", currDir, e.Message));
}
}
private void CreateBaseline_OnClick(object sender, RoutedEventArgs e)
{
//Get selected work items
if (txtBaselineName.Text.Length < 1)
{
MessageBox.Show("Please enter Baseline Name", "Baseline", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
var workItems = (ObservableCollection <WorkItemInfo>)dataGrid.DataContext;
var selectedItems = workItems.Where(o => o.Select);
//Call Insert to insert into SQL
BaselineInfo baselineInfo = new BaselineInfo()
{
CreatedBy = "User",
CreatedDate = DateTime.Now,
BaselineName = txtBaselineName.Text,
BaselineId = new Random().Next(1, 10000)
};
_baselineDBWrapper.InsertRecords(baselineInfo, selectedItems.ToList());
MessageBox.Show("Baseline Created", "Baseline", MessageBoxButton.OK, MessageBoxImage.Information);
_baselineManager.BaselineInfoViewModel.Baselines.Add(baselineInfo);
foreach (var workItemInfo in _tfsWorkItemManager.WorkItemViewModel.WorkItemInfos)
{
workItemInfo.Select = false;
}
stkViewBaseline.Visibility = Visibility.Visible;
stkCreateBaseline.Visibility = Visibility.Collapsed;
stkWorkItems.Visibility = Visibility.Visible;
stkBaselinedWorkItems.Visibility = Visibility.Collapsed;
}
public List <BaselineInfo> GetAllBaselineInfos()
{
string query = $"Select * from Baseline";
var baselineInfos = new List <BaselineInfo>();
using (SqlConnection conn = new SqlConnection(connString))
{
using (SqlCommand comm = new SqlCommand(query))
{
comm.Connection = conn;
try
{
conn.Open();
using (SqlDataReader reader = comm.ExecuteReader())
{
while (reader.Read())
{
var baseline = new BaselineInfo();
baseline.BaselineId = (int)reader["Id"];
baseline.BaselineName = (string)reader["Name"];
baseline.CreatedBy = (string)reader["CreatedBy"];
baseline.CreatedDate = reader.GetDateTime(reader.GetOrdinal("CreatedDate"));
baselineInfos.Add(baseline);
}
}
}
catch (SqlException e)
{
// do something with the exception
// don't hide it
}
}
}
return(baselineInfos);
}
/// <summary>
/// bi = null means that we are only given one version
/// </summary>
/// <param name="ar1"></param>
/// <param name="ar2"></param>
/// <param name="bi"></param>
public void WriteHtml(AvnResultInfo ar1, AvnResultInfo ar2, BaselineInfo bi)
{
var name = ar1.Name;
////row1
htmlWriter.AddAttribute(HtmlTextWriterAttribute.Valign, "top");
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Tr);
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Td); //need more info in this column
//htmlWriter.Write(ar1.ResultsDir.Replace("\\\\", "\\"));
htmlWriter.Write(ar1.Name);
htmlWriter.WriteBreak();
htmlWriter.RenderBeginTag(HtmlTextWriterTag.B);
htmlWriter.Write("STATS:");
htmlWriter.RenderEndTag(); //B
htmlWriter.Write(ar1.Summary);
htmlWriter.WriteBreak(); //B
htmlWriter.RenderBeginTag(HtmlTextWriterTag.B);
htmlWriter.Write("PREfix link:");
htmlWriter.RenderEndTag(); //B
if (!Options.hideAnnotTextarea)
{
htmlWriter.RenderBeginTag(HtmlTextWriterTag.P);
htmlWriter.AddAttribute(HtmlTextWriterAttribute.Id, "displayAllAnnotsFor_" + name);
htmlWriter.AddAttribute(HtmlTextWriterAttribute.Rows, (ar1.AngelicTraces.Count).ToString());
htmlWriter.AddAttribute(HtmlTextWriterAttribute.Cols, "30");
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Textarea);
htmlWriter.Write("Display annots for " + name + " here");
htmlWriter.RenderEndTag(); //textarea
htmlWriter.WriteBreak();
//button
htmlWriter.AddAttribute(HtmlTextWriterAttribute.Type, "button");
htmlWriter.AddAttribute(HtmlTextWriterAttribute.Onclick, "enumAnnots(" + "\"" + name + "\"" + ")");
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Button);
//var traceFile = ar1.ResultsDir.Replace("\\\\", "\\") + @"\trace_annots.xml";
var traceFile = @"trace_annots.xml";
htmlWriter.Write("Generate content of annots");
htmlWriter.WriteBreak();
htmlWriter.Write(string.Format("Copy/paste into {0}", traceFile));
htmlWriter.RenderEndTag(); //button
htmlWriter.RenderEndTag(); //P
}
htmlWriter.RenderEndTag(); //td
//MkTableHeaderColumn(htmlWriter, ar1.AllTraces.Count().ToString());
if (!baseline)
{
MkTableHeaderColumn(htmlWriter, "Total = " + ar1.AngelicTraces.Count().ToString());
}
else
{
MkTableHeaderColumn(htmlWriter, "Total/Matched = " + ar1.AngelicTraces.Count().ToString() +
"/" + bi.matchedTraces.Count);
}
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Td);
var matchedTraces = //if not baseline, then all traces
ar1.AngelicTraces.Where(t => !baseline || bi.matchedTraces.Any(x => x.Item1 == t));
WriteTracesInHtml(ar1, ar1.AngelicTraces, matchedTraces, htmlWriter);
htmlWriter.RenderEndTag(); //td
if (baseline)
{
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Td);
var unMatchedTraces = ar1.AngelicTraces.Where(t => !bi.matchedTraces.Any(x => x.Item1 == t));
WriteTracesInHtml(ar1, ar1.AngelicTraces, unMatchedTraces, htmlWriter);
htmlWriter.RenderEndTag(); //td
htmlWriter.RenderBeginTag(HtmlTextWriterTag.Td);
var missingTraces = ar2.AngelicTraces.Where(t => !bi.matchedTraces.Any(x => x.Item2 == t));
WriteTracesInHtml(ar2, ar2.AngelicTraces, missingTraces, htmlWriter, true); //don't update the ar1\trace_annots
htmlWriter.RenderEndTag(); //td
}
htmlWriter.RenderEndTag(); //tr
}
public void InsertRecords(BaselineInfo baselineInfo, List <WorkItemInfo> lstWorkItemInfos)
{
CreateBaseline(baselineInfo);
LinkWorkItemsToBaseLine(baselineInfo.BaselineId, lstWorkItemInfos, connString);
}
