Known bugs

Error executing template "Designs/dwdoc/Paragraph/Workitem_List.cshtml"
System.AggregateException: One or more errors occurred. ---> System.Net.Http.HttpRequestException: Response status code does not indicate success: 400 (Bad Request).
   at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()
   at BugList.DevOpsConnector.<GetWorkItems>d__12.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at BugList.DevOpsConnector.<GetQueryWorkItems>d__13.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at BugList.DevOpsConnector.<TableDataList>d__14.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at BugList.DevOpsConnector.<GetAllQueryWorkItems>d__11.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
   at CompiledRazorTemplates.Dynamic.RazorEngine_5b8a6477385a4866a93ed6f89bf9ff81.<GetAllItemsInQueryAsync>d__0.MoveNext() in E:\Dynamicweb.net\Solutions\Dynamicweb\doc.dynamicweb-cms.com\Files\Templates\Designs\dwdoc\Paragraph\Workitem_List.cshtml:line 45
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
   at CompiledRazorTemplates.Dynamic.RazorEngine_5b8a6477385a4866a93ed6f89bf9ff81.Execute() in E:\Dynamicweb.net\Solutions\Dynamicweb\doc.dynamicweb-cms.com\Files\Templates\Designs\dwdoc\Paragraph\Workitem_List.cshtml:line 64
   at RazorEngine.Templating.TemplateBase.RazorEngine.Templating.ITemplate.Run(ExecuteContext context, TextWriter reader)
   at RazorEngine.Templating.RazorEngineService.RunCompile(ITemplateKey key, TextWriter writer, Type modelType, Object model, DynamicViewBag viewBag)
   at RazorEngine.Templating.RazorEngineServiceExtensions.<>c__DisplayClass16_0.<RunCompile>b__0(TextWriter writer)
   at RazorEngine.Templating.RazorEngineServiceExtensions.WithWriter(Action`1 withWriter)
   at Dynamicweb.Rendering.RazorTemplateRenderingProvider.Render(Template template)
   at Dynamicweb.Rendering.TemplateRenderingService.Render(Template template)
   at Dynamicweb.Rendering.Template.RenderRazorTemplate()
---> (Inner Exception #0) System.Net.Http.HttpRequestException: Response status code does not indicate success: 400 (Bad Request).
   at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()
   at BugList.DevOpsConnector.<GetWorkItems>d__12.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at BugList.DevOpsConnector.<GetQueryWorkItems>d__13.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at BugList.DevOpsConnector.<TableDataList>d__14.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at BugList.DevOpsConnector.<GetAllQueryWorkItems>d__11.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
   at CompiledRazorTemplates.Dynamic.RazorEngine_5b8a6477385a4866a93ed6f89bf9ff81.<GetAllItemsInQueryAsync>d__0.MoveNext() in E:\Dynamicweb.net\Solutions\Dynamicweb\doc.dynamicweb-cms.com\Files\Templates\Designs\dwdoc\Paragraph\Workitem_List.cshtml:line 45<---



  1     @using BugList;
  2     @using System.Threading.Tasks;
  3     
  4     @{
  5         string pat = @GetString("Item.Personal_Access_Token.Value");
  6         string project = @GetString("Item.Project.Value");
  7         string query = @GetString("Item.Query_ID.Value");
  8         string[] states = @GetString("Item.State").Split(',');
  9         string build = @GetString("Item.Build");
 10         string tag = @GetString("Item.Tag");
 11     
 12         var currentuser = Dynamicweb.Security.UserManagement.User.GetCurrentExtranetUser();
 13     
 14     }
 15     
 16     @{
 17     
 18         //Default values
 19     	//ppwv7tco4guxzhriv2rbmfcmnbhlqiw7l7ku5ckfrbdnnaqdwl6a (old)
 20         if (string.IsNullOrWhiteSpace(pat))
 21         {
 22             pat = "wgrwooqweum24kpm2ahyxyuxcflbd66ckc6wk2hy7krcc75m3bcq";
 23         }
 24         if (string.IsNullOrWhiteSpace(project))
 25         {
 26             project = "dynamicweb";
 27         }
 28     
 29         if (string.IsNullOrWhiteSpace(query))
 30         {
 31             query = "6b8fb4d1-fe99-4f0a-9fd4-c554dabc0d66"; //All customer bugs (Non-Rapido)
 32         }
 33     
 34     }
 35     
 36     @functions{
 37     
 38         /// <summary>
 39         /// Query: Open Bugs (Customer Bugs), all work items
 40         /// </summary>
 41         /// <returns></returns>
 42         async Task<List<Table>> GetAllItemsInQueryAsync(string pat, string projectName, string queryId)
 43         {
 44             DevOpsConnector connector = new DevOpsConnector();
 45             return await connector.GetAllQueryWorkItems(pat: pat, projectName: projectName, queryId: queryId).ConfigureAwait(false);
 46         }
 47     
 48         /// <summary>
 49         /// Open bugs (rapido) query, work item 1499
 50         /// </summary>
 51         /// <returns></returns>
 52         async Task<List<Table>> GetSpecificWorkItem()
 53         {
 54             DevOpsConnector connector = new DevOpsConnector();
 55             return await connector.GetQueryItem(pat: "gwiajvcl3qzdekknpjh6t4djinfwheml6oxxbbgnkizcjbuxwsjq", projectName: "dynamicweb", queryId: "985c9f68-7140-4ae0-a2d6-d0fa6403a921", workItemId: "1499").ConfigureAwait(false);
 56         }
 57     }
 58     
 59     @{
 60         //Fetches query data
 61     
 62         DevOpsConnector connector = new DevOpsConnector();
 63     
 64         List<Table> workitems = GetAllItemsInQueryAsync(@pat, @project, @query).Result;
 65     
 66         string queryinfo = connector.GetQueryInfo(pat, project, query).Result;
 67         string[] stringSeparators = new string[] { "Query name: ", "Path: " };
 68         var queryinfoParsed = queryinfo.Split(stringSeparators, StringSplitOptions.None);
 69     
 70     }
 71     
 72     <div class="col-md-12">
 73     
 74         <table class="table table-responsive">
 75             <thead>
 76                 <tr>
 77                     <th>ID</th>
 78                     <th>Type</th>
 79                     <th>Description</th>
 80                     <th>State</th>
 81     
 82                     <th>Fixed in</th>
 83                 </tr>
 84             </thead>
 85             <tbody>
 86                 @foreach (var workitem in workitems)
 87                 {
 88                     if (states.Contains(workitem.SystemState))
 89                     {
 90                         if (string.IsNullOrWhiteSpace(build) || workitem.IntegratedInBuild == build)
 91                         {
 92     
 93                             if (workitem.SystemTags.Contains(tag) || string.IsNullOrWhiteSpace(tag))
 94                             {
 95                                 <tr>
 96                                     <td>@workitem.Id</td>
 97                                     <td>@workitem.WorkItemType</td>
 98                                     <td>
 99                                         @workitem.Title
100                                         <br />
101                                         <em><small>@workitem.AreaPath</small></em>
102                                         <br />
103                                         <small style="font-size:80%">Date Created: @workitem.SystemCreatedDate.ToShortDateString()</small>
104                                         <br />
105                                         @if (workitem.MicrosoftVSTSCommonResolvedDate.HasValue)
106                                         {
107                                             DateTime FixedIn = workitem.MicrosoftVSTSCommonResolvedDate.Value;
108                                             <small style="font-size:80%">Date Fixed: @FixedIn.ToShortDateString()</small>
109                                         }
110                                      @if(workitem.MicrosoftVSTSBuildFoundIn != null){<small style="font-size:80%; display:block;">Found in version: @workitem.MicrosoftVSTSBuildFoundIn</small>}
111                                     </td>
112                                     <td>@workitem.SystemState</td>
113                                     <td>@workitem.IntegratedInBuild</td>
114                                 </tr>
115                             }
116                         }
117                     }
118                 }
119                 <tr>
120                     <td align="center" colspan="5">
121                         @if (currentuser != null)
122                         {
123                             foreach (var customfield in currentuser.CustomFieldValues)
124                             {
125                                 if (customfield.CustomField.SystemName == "AccessUser_DWEmployee" && customfield.Value.ToString() == "True")
126                                 {
127                                     <div><em><small><b>Query:</b> @queryinfoParsed[1]</small></em></div>
128                                     <div><em><small><b>Path:</b> /@queryinfoParsed[2]</small></em></div>
129                                     <br />
130                                     <div>
131                                         <em>
132                                             <small>
133                                                 <b>Applied Filters</b>
134                                                 @if (!string.IsNullOrWhiteSpace(states[0]))
135                                                 {
136                                                     <div>
137                                                         States (@foreach (var state in states){<text>@state;</text>})
138                                                     </div>
139                                                 }
140                                                 @if (!string.IsNullOrWhiteSpace(build))
141                                                 {
142                                                     <div> Build (@build)</div>
143                                                 }
144                                                 @if (!string.IsNullOrWhiteSpace(tag))
145                                                 {
146                                                     <div>Tags (@tag)</div>
147                                                 }
148                                             </small>
149                                         </em>
150                                     </div>
151                                 }
152                             }
153                         }
154                     </td>
155                 </tr>
156             </tbody>
157     
158         </table>
159     
160     </div>