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); }