private void ProcessForm()
{
var issue = new JiraIssueProvider(i => Regex.IsMatch(i.epic, ".*BOD 18-02.*2021.*") && Regex.IsMatch(i.title, ".*8156.*"))
.Items.FirstOrDefault();
string source = "";
string src = "";
using (TextReader tr = System.IO.File.OpenText(@"D:\dev\CyberScope\CyberScopeBranch\CSwebdev\database\DB_Update7.34_BOD_2021.sql"))
src = tr.ReadToEnd();
int qsorter = 0;
foreach (JiraIssueItem item in ParseIssueItems(src))
{
QPK++;
if (item.control.Contains("Select all"))
{
using (TextReader tr = System.IO.File.OpenText(@"C:\_som\_src\MULTICHECKBOX.aspx"))
source = tr.ReadToEnd();
}
Body += string.Format(source, item.metricid, "");
//Control
}
Body = Body.Substring(0, Body.Length - 1);
}
public void OnGet()
{
string source;
using (TextReader tr = System.IO.File.OpenText(@"D:\dev\CyberScope\CyberScopeBranch\CSwebdev\database\DB_Update7.34_BOD_2021.sql"))
source = tr.ReadToEnd();
var issues = new JiraIssueProvider(i => Regex.IsMatch(i.epic, $".*EINSTEIN.*")).Items;
foreach (var issue in issues)
{
All += $"\n{issue.link}";
string isu = Regex.Match(issue.description.Replace("\n", ""), $"ISSUE:(.*)WHERE")?.Groups[1]?.Value ?? issue.description;
All += $"{ isu}";
}
}
public void OnGet()
{
string source;
using (TextReader tr = System.IO.File.OpenText(@"D:\dev\CyberScope\CyberScopeBranch\CSwebdev\database\DB_Update7.34_BOD_2021.sql"))
source = tr.ReadToEnd();
var issues = new JiraIssueProvider(i => Regex.IsMatch(i.epic, $".*BOD 18.*2021.*") && Regex.IsMatch(i.title, $".*Section.*")).Items;
foreach (var issue in issues)
{
All += $"\n\n{issue.section}\n";
foreach (var item in issue.issueitems)
{
All += $"\n{item.metricid}\n{item.metrictext}\n\n";
if (!source.Hash().ToLower().Contains(item.metrictext.Hash().ToLower()))
{
Diff += $"{issue.title}\n\n{item.metrictext.StripHTML() }\n\n\n";
}
}
}
var prev = new JiraIssueProvider(i => Regex.IsMatch(i.epic, $".*BOD 18-02.*2020.*{Title}.*") && Regex.IsMatch(i.title, $".*Section.*")).Items;
foreach (var issue in prev)
{
//Left += $"\n{issue.section }\n";
Left += $"\n{issue.description.Hash()}\n";
}
var next = new JiraIssueProvider(i => Regex.IsMatch(i.epic, $".*BOD 18-02.*2021.*{Title}.*") && Regex.IsMatch(i.title, $".*Section.*")).Items;
foreach (var issue in next)
{
//Right += $"\n{issue.section}\n";
Right += $"\n{issue.description.Hash()}\n";
}
}
private void ProcessForm()
{
var issue = new JiraIssueProvider(i => Regex.IsMatch(i.epic, ".*BOD 18-02.*2021.*") && Regex.IsMatch(i.title, ".*8156.*"))
.Items.FirstOrDefault();
HtmlAgilityPack.HtmlDocument doc = new HtmlAgilityPack.HtmlDocument();
string src = HttpUtility.HtmlDecode(issue.content);
doc.LoadHtml(src);
src = doc.DocumentNode.SelectSingleNode("//description").InnerHtml;
src = Regex.Replace(src, @"[\^]", "");
src = Regex.Replace(src, @"[“|”]", "\"");
int qsorter = 0;
foreach (JiraIssueItem item in ParseIssueItems(src))
{
QPK++;
var picklistitems = item.control.Split("·").Select(s => s.Trim().Replace("(Text Box)", "")).Skip(1).ToList();
string metrictext = item.metrictext;
if (picklistitems.Count > 0)
{
PLT++;
PL += 2;
int cnt = 1;
Footer += string.Format(PicktypeInsert, PLT, $"BODHVA-{PLT}-{item.metricid}", $"BODHVA IDT-{item.metricid}");
Left += $"\nEnum Metric_{item.metricid.Replace(".","_")}";
Footer += "\nSET IDENTITY_INSERT [dbo].[PickLists] ON";
Footer += "\nINSERT INTO PickLists(PK_PickList, PK_PickListType, CodeValue,DisplayValue, SortPos, LastUpdated, isActive) VALUES ";
foreach (string c in picklistitems)
{
PL++;
PickList pl = new PickList(c);
Footer += $"\n({PL},@PKT, N'{pl.CodeValue}','{c.Trim()}',{cnt++}, GETDATE(), 1),";
Left += $"\n\t{pl.CodeValue} = {PL} '{c.Trim()}";
}
Left += $"\nEnd Enum";
Footer = Footer.Substring(0, Footer.Length - 1);
Footer += $"\nSET IDENTITY_INSERT [dbo].[PickLists] OFF";
if (item.control.Contains("Select all"))
{
Body += string.Format(MetricInsert, QPK, $"{qsorter++}", $"{item.metricid}", "43", $"{PLT}", $"{metrictext}");
}
else
{
Body += string.Format(MetricInsert, QPK, $"{qsorter++}", $"{item.metricid}", "17", $"{PLT}", $"{metrictext}");
}
}
else if (item.control.Contains("Y/N/Unknown"))
{
Body += string.Format(MetricInsert, QPK, $"{qsorter++}", $"{item.metricid}", "5", "NULL", $"{metrictext}");
}
else if (item.control.Contains("Y/N"))
{
Body += string.Format(MetricInsert, QPK, $"{qsorter++}", $"{item.metricid}", "1", "NULL", $"{metrictext}");
}
else if (item.control.Contains("STTL"))
{
Body += string.Format(MetricInsert, QPK, $"{qsorter++}", $"", "63", "NULL", $"{metrictext}");
}
else
{
Body += string.Format(MetricInsert, QPK, $"{qsorter++}", $"{item.metricid}", "9", "NULL", $"{metrictext}");
}
}
Body = Body.Substring(0, Body.Length - 1);
}
public void IssueProvider_Providers()
{
var issues = new JiraIssueProvider(issue => Regex.IsMatch(issue.epic, ".*")).Items;
Assert.IsNotNull(issues);
}
