aboutsummaryrefslogtreecommitdiffstats
path: root/Software/Visual_Studio/MachineStudio/Modules/Tango.MachineStudio.MachineDesigner/Tango.MachineStudio.MachineDesigner.csproj
blob: 69cc7546125c79183b821296eac9b404d20c2910 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="15.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />
  <PropertyGroup>
    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
    <ProjectGuid>{D0CE8122-077D-42A2-9490-028AE4769B52}</ProjectGuid>
    <OutputType>library</OutputType>
    <RootNamespace>Tango.MachineStudio.MachineDesigner</RootNamespace>
    <AssemblyName>Tango.MachineStudio.MachineDesigner</AssemblyName>
    <TargetFrameworkVersion>v4.6.1</TargetFrameworkVersion>
    <FileAlignment>512</FileAlignment>
    <ProjectTypeGuids>{60dc8134-eba5-43b8-bcc9-bb4bc16c2548};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}</ProjectTypeGuids>
    <WarningLevel>4</WarningLevel>
  </PropertyGroup>
  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
    <DebugSymbols>true</DebugSymbols>
    <DebugType>full</DebugType>
    <Optimize>false</Optimize>
    <OutputPath>..\..\..\Build\Machine Studio\Debug\</OutputPath>
    <DefineConstants>DEBUG;TRACE</DefineConstants>
    <ErrorReport>prompt</ErrorReport>
    <WarningLevel>4</WarningLevel>
  </PropertyGroup>
  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
    <DebugType>pdbonly</DebugType>
    <Optimize>true</Optimize>
    <OutputPath>..\..\..\Build\Machine Studio\Release\</OutputPath>
    <DefineConstants>TRACE</DefineConstants>
    <ErrorReport>prompt</ErrorReport>
    <WarningLevel>4</WarningLevel>
  </PropertyGroup>
  <ItemGroup>
    <Reference Include="EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL">
      <HintPath>..\..\..\packages\EntityFramework.6.2.0\lib\net45\EntityFramework.dll</HintPath>
    </Reference>
    <Reference Include="EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL">
      <HintPath>..\..\..\packages\EntityFramework.6.2.0\lib\net45\EntityFramework.SqlServer.dll</HintPath>
    </Reference>
    <Reference Include="FontAwesome.WPF, Version=4.7.0.37774, Culture=neutral, PublicKeyToken=0758b07a11a4f466, processorArchitecture=MSIL">
      <HintPath>..\..\..\packages\FontAwesome.WPF.4.7.0.9\lib\net40\FontAwesome.WPF.dll</HintPath>
    </Reference>
    <Reference Include="Google.Protobuf, Version=3.4.1.0, Culture=neutral, PublicKeyToken=a7d26565bac4d604, processorArchitecture=MSIL">
      <SpecificVersion>False</SpecificVersion>
      <HintPath>..\..\..\packages\Google.Protobuf.3.4.1\lib\net45\Google.Protobuf.dll</HintPath>
    </Reference>
    <Reference Include="MahApps.Metro, Version=1.5.0.23, Culture=neutral, PublicKeyToken=f4fb5a3c4d1e5b4f, processorArchitecture=MSIL">
      <HintPath>..\..\..\packages\MahApps.Metro.1.5.0\lib\net45\MahApps.Metro.dll</HintPath>
    </Reference>
    <Reference Include="MaterialDesignColors, Version=1.1.2.0, Culture=neutral, processorArchitecture=MSIL">
      <HintPath>..\..\..\packages\MaterialDesignColors.1.1.2\lib\net45\MaterialDesignColors.dll</HintPath>
    </Reference>
    <Reference Include="MaterialDesignThemes.Wpf, Version=2.3.1.953, Culture=neutral, processorArchitecture=MSIL">
      <HintPath>..\..\..\packages\MaterialDesignThemes.2.3.1.953\lib\net45\MaterialDesignThemes.Wpf.dll</HintPath>
    </Reference>
    <Reference Include="SimpleValidator, Version=0.6.1.0, Culture=neutral, processorArchitecture=MSIL">
      <HintPath>..\..\..\packages\SimpleValidator.0.6.1.0\lib\net40\SimpleValidator.dll</HintPath>
    </Reference>
    <Reference Include="System" />
    <Reference Include="System.ComponentModel.DataAnnotations" />
    <Reference Include="System.Data" />
    <Reference Include="System.Windows.Interactivity, Version=4.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
      <HintPath>..\..\..\packages\Expression.Blend.Sdk.1.0.2\lib\net45\System.Windows.Interactivity.dll</HintPath>
    </Reference>
    <Reference Include="System.Xml" />
    <Reference Include="Microsoft.CSharp" />
    <Reference Include="System.Core" />
    <Reference Include="System.Xml.Linq" />
    <Reference Include="System.Data.DataSetExtensions" />
    <Reference Include="System.Net.Http" />
    <Reference Include="System.Xaml">
      <RequiredTargetFramework>4.0</RequiredTargetFramework>
    </Reference>
    <Reference Include="WindowsBase" />
    <Reference Include="PresentationCore" />
    <Reference Include="PresentationFramework" />
  </ItemGroup>
  <ItemGroup>
    <Compile Include="..\..\..\Versioning\GlobalVersionInfo.cs">
      <Link>GlobalVersionInfo.cs</Link>
    </Compile>
    <Compile Include="AutoComplete\MachineVersionsProvider.cs" />
    <Compile Include="Contracts\IMainView.cs" />
    <Compile Include="Models\IHasDifference.cs" />
    <Compile Include="Models\HardwareCollection.cs" />
    <Compile Include="Models\HardwareComponent.cs" />
    <Compile Include="Models\HardwareParameter.cs" />
    <Compile Include="ViewModelLocator.cs" />
    <Compile Include="ViewModels\ColorCalibrationViewVM.cs" />
    <Compile Include="ViewModels\HardwareConfigurationViewVM.cs" />
    <Compile Include="ViewModels\MachineCreationDialogVM.cs" />
    <Compile Include="ViewModels\MachineUpdateDetailsDialogVM.cs" />
    <Compile Include="ViewModels\MachineUpdatesViewVM.cs" />
    <Compile Include="ViewModels\MachineVersionDialogVM.cs" />
    <Compile Include="ViewModels\MainViewVM.cs" />
    <Compile Include="ViewModels\TupViewVM.cs" />
    <Compile Include="Views\ColorCalibrationView.xaml.cs">
      <DependentUpon>ColorCalibrationView.xaml</DependentUpon>
    </Compile>
    <Compile Include="Views\HardwareConfigurationView.xaml.cs">
      <DependentUpon>HardwareConfigurationView.xaml</DependentUpon>
    </Compile>
    <Compile Include="Views\MachineUpdateDetailsDialog.xaml.cs">
      <DependentUpon>MachineUpdateDetailsDialog.xaml</DependentUpon>
    </Compile>
    <Compile Include="Views\MachineCreationDialog.xaml.cs">
      <DependentUpon>MachineCreationDialog.xaml</DependentUpon>
    </Compile>
    <Compile Include="Views\MachineDetailsView.xaml.cs">
      <DependentUpon>MachineDetailsView.xaml</DependentUpon>
    </Compile>
    <Compile Include="Views\MachineSettingsView.xaml.cs">
      <DependentUpon>MachineSettingsView.xaml</DependentUpon>
    </Compile>
    <Compile Include="Views\MachinesView.xaml.cs">
      <DependentUpon>MachinesView.xaml</DependentUpon>
    </Compile>
    <Compile Include="Views\MachineVersionDialog.xaml.cs">
      <DependentUpon>MachineVersionDialog.xaml</DependentUpon>
    </Compile>
    <Compile Include="Views\MachineView.xaml.cs">
      <DependentUpon>MachineView.xaml</DependentUpon>
    </Compile>
    <Compile Include="Views\ConfigurationView.xaml.cs">
      <DependentUpon>ConfigurationView.xaml</DependentUpon>
    </Compile>
    <Compile Include="MachineDesignerModule.cs" />
    <Compile Include="Views\MainView.xaml.cs">
      <DependentUpon>MainView.xaml</DependentUpon>
    </Compile>
    <Compile Include="Views\MachineUpdatesView.xaml.cs">
      <DependentUpon>MachineUpdatesView.xaml</DependentUpon>
    </Compile>
    <Compile Include="Views\TupView.xaml.cs">
      <DependentUpon>TupView.xaml</DependentUpon>
    </Compile>
    <Compile Include="Views\SpoolsView.xaml.cs">
      <DependentUpon>SpoolsView.xaml</DependentUpon>
    </Compile>
    <Page Include="App.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="Views\ColorCalibrationView.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="Views\HardwareConfigurationView.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="Views\MachineUpdateDetailsDialog.xaml">
      <Generator>MSBuild:Compile</Generator>
      <SubType>Designer</SubType>
    </Page>
    <Page Include="Views\MachineCreationDialog.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="Views\MachineDetailsView.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="Views\MachineSettingsView.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="Views\MachinesView.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="Views\MachineVersionDialog.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="Views\MachineView.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="Views\ConfigurationView.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="Views\MainView.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
    <Page Include="Views\MachineUpdatesView.xaml">
      <Generator>MSBuild:Compile</Generator>
      <SubType>Designer</SubType>
    </Page>
    <Page Include="Views\TupView.xaml">
      <Generator>MSBuild:Compile</Generator>
      <SubType>Designer</SubType>
    </Page>
    <Page Include="Views\SpoolsView.xaml">
      <SubType>Designer</SubType>
      <Generator>MSBuild:Compile</Generator>
    </Page>
  </ItemGroup>
  <ItemGroup>
    <Compile Include="Properties\AssemblyInfo.cs">
      <SubType>Code</SubType>
    </Compile>
    <Compile Include="Properties\Resources.Designer.cs">
      <AutoGen>True</AutoGen>
      <DesignTime>True</DesignTime>
      <DependentUpon>Resources.resx</DependentUpon>
    </Compile>
    <Compile Include="Properties\Settings.Designer.cs">
      <AutoGen>True</AutoGen>
      <DependentUpon>Settings.settings</DependentUpon>
      <DesignTimeSharedInput>True</DesignTimeSharedInput>
    </Compile>
    <EmbeddedResource Include="Properties\Resources.resx">
      <Generator>ResXFileCodeGenerator</Generator>
      <LastGenOutput>Resources.Designer.cs</LastGenOutput>
    </EmbeddedResource>
    <None Include="app.config">
      <SubType>Designer</SubType>
    </None>
    <None Include="packages.config" />
    <None Include="Properties\Settings.settings">
      <Generator>SettingsSingleFileGenerator</Generator>
      <LastGenOutput>Settings.Designer.cs</LastGenOutput>
    </None>
  </ItemGroup>
  <ItemGroup>
    <ProjectReference Include="..\..\..\SideChains\Tango.AutoComplete\Tango.AutoComplete.csproj">
      <Project>{bb2abb74-ba58-4812-83aa-ec8171f42df4}</Project>
      <Name>Tango.AutoComplete</Name>
    </ProjectReference>
    <ProjectReference Include="..\..\..\Tango.BL\Tango.BL.csproj">
      <Project>{f441feee-322a-4943-b566-110e12fd3b72}</Project>
      <Name>Tango.BL</Name>
    </ProjectReference>
    <ProjectReference Include="..\..\..\Tango.ColorPicker\Tango.ColorPicker.csproj">
      <Project>{a2f5af44-29ff-45d6-9d25-ecda5cce88b5}</Project>
      <Name>Tango.ColorPicker</Name>
    </ProjectReference>
    <ProjectReference Include="..\..\..\Tango.Core\Tango.Core.csproj">
      <Project>{a34ee0f0-649d-41c8-8489-b6f1cc6924ee}</Project>
      <Name>Tango.Core</Name>
    </ProjectReference>
    <ProjectReference Include="..\..\..\Tango.DAL.Remote\Tango.DAL.Remote.csproj">
      <Project>{38197109-8610-4d3f-92b9-16d48df94d7c}</Project>
      <Name>Tango.DAL.Remote</Name>
    </ProjectReference>
    <ProjectReference Include="..\..\..\Tango.DragAndDrop\Tango.DragAndDrop.csproj">
      <Project>{b112d89a-a106-41ae-a0c1-4abc84c477f5}</Project>
      <Name>Tango.DragAndDrop</Name>
    </ProjectReference>
    <ProjectReference Include="..\..\..\Tango.Integration\Tango.Integration.csproj">
      <Project>{4206ac58-3b57-4699-8835-90bf6db01a61}</Project>
      <Name>Tango.Integration</Name>
    </ProjectReference>
    <ProjectReference Include="..\..\..\Tango.Logging\Tango.Logging.csproj">
      <Project>{bc932dbd-7cdb-488c-99e4-f02cf441f55e}</Project>
      <Name>Tango.Logging</Name>
    </ProjectReference>
    <ProjectReference Include="..\..\..\Tango.PMR\Tango.PMR.csproj">
      <Project>{e4927038-348d-4295-aaf4-861c58cb3943}</Project>
      <Name>Tango.PMR</Name>
    </ProjectReference>
    <ProjectReference Include="..\..\..\Tango.Settings\Tango.Settings.csproj">
      <Project>{d8f1ad85-526a-4f50-b6dc-d437af63d8d8}</Project>
      <Name>Tango.Settings</Name>
    </ProjectReference>
    <ProjectReference Include="..\..\..\Tango.SharedUI\Tango.SharedUI.csproj">
      <Project>{8491d07b-c1f6-4b62-a412-41b9fd2d6538}</Project>
      <Name>Tango.SharedUI</Name>
    </ProjectReference>
    <ProjectReference Include="..\..\..\Tango.Synchronization\Tango.Synchronization.csproj">
      <Project>{7ada4e86-cad7-4968-a210-3a8a9e5153ab}</Project>
      <Name>Tango.Synchronization</Name>
    </ProjectReference>
    <ProjectReference Include="..\..\..\Tango.Transport\Tango.Transport.csproj">
      <Project>{74e700b0-1156-4126-be40-ee450d3c3026}</Project>
      <Name>Tango.Transport</Name>
    </ProjectReference>
    <ProjectReference Include="..\..\Tango.MachineStudio.Common\Tango.MachineStudio.Common.csproj">
      <Project>{cb0b0aa2-bb24-4bca-a720-45e397684e12}</Project>
      <Name>Tango.MachineStudio.Common</Name>
    </ProjectReference>
    <ProjectReference Include="..\Tango.MachineStudio.RML\Tango.MachineStudio.RML.csproj">
      <Project>{d0186ac0-0fcf-4d3b-9619-54812b6e524b}</Project>
      <Name>Tango.MachineStudio.RML</Name>
    </ProjectReference>
  </ItemGroup>
  <ItemGroup>
    <Resource Include="Images\machine-full-fx.png" />
    <Resource Include="Images\machine-sketch.png" />
  </ItemGroup>
  <ItemGroup>
    <Resource Include="Images\mid-tank.png" />
  </ItemGroup>
  <ItemGroup>
    <Resource Include="Images\dispenser.png" />
  </ItemGroup>
  <ItemGroup>
    <Resource Include="Images\ti-tm4c129x.png" />
  </ItemGroup>
  <ItemGroup>
    <Resource Include="Images\cartridge.png" />
    <Resource Include="Images\injection.png" />
    <Resource Include="Images\liquid.png" />
    <Resource Include="Images\tank.png" />
  </ItemGroup>
  <ItemGroup>
    <Resource Include="Images\embedded.png" />
    <Resource Include="Images\tablet.png" />
  </ItemGroup>
  <ItemGroup>
    <Resource Include="Images\app.png" />
  </ItemGroup>
  <ItemGroup>
    <Resource Include="Images\embedded-software.png" />
  </ItemGroup>
  <ItemGroup>
    <Resource Include="Images\android.png" />
    <Resource Include="Images\hardware.png" />
  </ItemGroup>
  <ItemGroup>
    <Resource Include="Images\application-firmware.png" />
  </ItemGroup>
  <ItemGroup>
    <Resource Include="Images\machine-designer-module.jpg" />
  </ItemGroup>
  <ItemGroup>
    <Resource Include="Images\formula.png" />
  </ItemGroup>
  <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
  <ProjectExtensions>
    <VisualStudio>
      <UserProperties BuildVersion_StartDate="2000/1/1" BuildVersion_UseGlobalSettings="False" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" />
    </VisualStudio>
  </ProjectExtensions>
</Project>
n class="k">using Tango.AutoComplete.Editors; using System.Windows.Media; using LiveCharts.Wpf; using LiveCharts; using Tango.BL.ValueObjects; using System.Diagnostics; using Microsoft.Win32; using Tango.CSV; using System.ComponentModel; namespace Tango.MachineStudio.Statistics.ViewModels { public enum HeadCleaningSelectionEnum { [Description("Exclude")] Exclude = 0, [Description("Include")] Include = 1, [Description("Only")] Only = 2 }; public class JobRunsViewVM : ViewModel { private INotificationProvider _notification; private List<OrganisationToSiteModel> _organizations; private List<Machine> _allMachines; private List<User> _allUsers; private List<RmlModel> _rmlsModels; #region Properties private ObservableCollection<JobRunModel> _jobRuns; /// <summary> /// Gets or sets the job runs. Contains filtered data of JobRunModel. /// </summary> public ObservableCollection<JobRunModel> JobRuns { get { return _jobRuns; } set { _jobRuns = value; RaisePropertyChangedAuto(); } } private JobRunModel _selectedJobRun = null; /// <summary> /// Gets or sets the JobRunModel. Binding to selected item of grid items. /// </summary> public JobRunModel SelectedJobRun { get { return _selectedJobRun; } set { _selectedJobRun = value; RaisePropertyChangedAuto(); } } private SelectedObjectCollection<OrganisationToSiteModel> _selectedOrganizations; /// <summary> /// Gets or sets the selected machines. Contains all available machines and selected machines. Binding to ComboBox Machines. /// </summary> public SelectedObjectCollection<OrganisationToSiteModel> SelectedOrganizations { get { return _selectedOrganizations; } set { _selectedOrganizations = value; RaisePropertyChangedAuto(); } } private bool _IsEnabledSelectionSites; public bool IsEnabledSelectionSites { get { return _IsEnabledSelectionSites; } set { _IsEnabledSelectionSites = value; RaisePropertyChangedAuto(); } } private bool _allSelectedSites; public bool AllSelectedSites { get { return _allSelectedSites; } set { _allSelectedSites = value; RaisePropertyChangedAuto(); } } private SelectedObjectCollection<SiteModel> _selectedSites; /// <summary> /// Gets or sets the selected machines. Contains all available machines and selected machines. Binding to ComboBox Machines. /// </summary> public SelectedObjectCollection<SiteModel> SelectedSites { get { return _selectedSites; } set { _selectedSites = value; RaisePropertyChangedAuto(); } } private bool _allSelectedMachines; public bool AllSelectedMachines { get { return _allSelectedMachines; } set { _allSelectedMachines = value; RaisePropertyChangedAuto(); } } private SelectedObjectCollection<MachineModel> _selectedMachines; /// <summary> /// Gets or sets the selected machines. Contains all available machines and selected machines. Binding to ComboBox Machines. /// </summary> public SelectedObjectCollection<MachineModel> SelectedMachines { get { return _selectedMachines; } set { _selectedMachines = value; RaisePropertyChangedAuto(); } } private DateTime _startSelectedDate; /// <summary> /// Gets or sets the start selected date. /// </summary> public DateTime StartSelectedDate { get { return _startSelectedDate; } set { _startSelectedDate = value; RaisePropertyChangedAuto(); } } private DateTime _endSelectedDate; /// <summary> /// Gets or sets the end selected date. /// </summary> public DateTime EndSelectedDate { get { return _endSelectedDate; } set { _endSelectedDate = value; RaisePropertyChangedAuto(); } } protected Double _lengthLowerValue; /// <summary> /// Gets or sets the length lower value of Range Slider /// </summary> public Double LengthLowerValue { get { return _lengthLowerValue; } set { _lengthLowerValue = value; RaisePropertyChangedAuto(); } } protected Double _lengthUpperValue; /// <summary> /// Gets or sets the length upper value of Range Slider. /// </summary> public Double LengthUpperValue { get { return _lengthUpperValue; } set { _lengthUpperValue = value; RaisePropertyChangedAuto(); } } private SelectedObjectCollection<JobSource> _jobRunSelectedSources; /// <summary> /// Gets or sets the job run selected sources. Binding to ComboBox "Source". /// </summary> public SelectedObjectCollection<JobSource> JobRunSelectedSources { get { return _jobRunSelectedSources; } set { _jobRunSelectedSources = value; RaisePropertyChangedAuto(); } } private SelectedObjectCollection<JobRunStatus> _jobRunSelectedStatuses; /// <summary> /// Gets or sets the job run selected statuses. Binding to ComboBox "Status". /// </summary> public SelectedObjectCollection<JobRunStatus> JobRunSelectedStatuses { get { return _jobRunSelectedStatuses; } set { _jobRunSelectedStatuses = value; RaisePropertyChangedAuto(); } } public SelectedObjectCollection<bool> _isGradientSelection; /// <summary> /// Gets or sets the is gradient selection. Binding to ComboBox "IsGradient". /// </summary> public SelectedObjectCollection<bool> IsGradientSelection { get { return _isGradientSelection; } set { _isGradientSelection = value; RaisePropertyChangedAuto(); } } private SelectedObjectCollection<RmlModel> _selectedThreads; /// <summary> /// Gets or sets the selected threads. Contains all available threads and selected threads. Binding to ComboBox "Thread". /// </summary> public SelectedObjectCollection<RmlModel> SelectedThreads { get { return _selectedThreads; } set { _selectedThreads = value; RaisePropertyChangedAuto(); } } private HeadCleaningSelectionEnum _headCleaningSelected; public HeadCleaningSelectionEnum HeadCleaningSelected { get { return _headCleaningSelected; } set { _headCleaningSelected = value; RaisePropertyChangedAuto(); } } /// <summary> /// Gets or sets the JobRuns providers. /// </summary> public ISuggestionProvider JobsProvider { get; set; } private Job _selectedJob; /// <summary> /// Gets or sets the job. /// </summary> public Job SelectedJob { get { return _selectedJob; } set { _selectedJob = value; RaisePropertyChangedAuto(); } } /// <summary> /// Gets or sets the statistics value collection. Class - container included calculated statistic values. /// </summary> public StatisticsValueCollection StatisticsValueCollection { get; set; } #endregion public RelayCommand LoadJobRunsCommand { get; set; } public RelayCommand ExportToExcelCommand { get; set; } public JobRunsViewVM(INotificationProvider notificationProvider) { _notification = notificationProvider; JobRuns = new ObservableCollection<JobRunModel>(); LoadJobRunsCommand = new RelayCommand(async () => await LoadJobRuns(), () => IsFree && SelectedMachines!= null && SelectedMachines.Source.Count >0); ExportToExcelCommand = new RelayCommand(ExportToExcel, () => IsFree); LengthUpperValue = 100000.0; LengthLowerValue = 0.0; DateTime now = DateTime.Now; StartSelectedDate = now.AddMonths(-1); EndSelectedDate = now; JobRunSelectedSources = new SelectedObjectCollection<JobSource>(new ObservableCollection<JobSource>() { JobSource.Local, JobSource.Remote }, new ObservableCollection<JobSource>() { JobSource.Local, JobSource.Remote }); JobRunSelectedSources.SelectionChanged -= (x, y) => RaisePropertyChanged(nameof(JobRunSelectedSources)); JobRunSelectedSources.SelectionChanged += (x, y) => RaisePropertyChanged(nameof(JobRunSelectedSources)); JobRunSelectedStatuses = new SelectedObjectCollection<JobRunStatus>(new ObservableCollection<JobRunStatus>() { JobRunStatus.Aborted, JobRunStatus.Completed, JobRunStatus.Failed, }, new ObservableCollection<JobRunStatus>() { JobRunStatus.Aborted, JobRunStatus.Completed, JobRunStatus.Failed, }); JobRunSelectedStatuses.SelectionChanged -= (x, y) => RaisePropertyChanged(nameof(JobRunSelectedStatuses)); JobRunSelectedStatuses.SelectionChanged += (x, y) => RaisePropertyChanged(nameof(JobRunSelectedStatuses)); IsGradientSelection = new SelectedObjectCollection<bool>(new ObservableCollection<bool> { true, false }, new ObservableCollection<bool> { true, false }); IsGradientSelection.SelectionChanged -= (x, y) => RaisePropertyChanged(nameof(IsGradientSelection)); IsGradientSelection.SelectionChanged += (x, y) => RaisePropertyChanged(nameof(IsGradientSelection)); HeadCleaningSelected = HeadCleaningSelectionEnum.Exclude; JobsProvider = new SuggestionProvider((filter) => { try { if (filter != null) { using (ObservablesContext db = ObservablesContext.CreateDefault()) { return db.Jobs.Where(x => x.Name != null && x.Name.ToLower().Contains(filter.ToLower())).ToList(); } } else { return new List<Job>(); } } catch (Exception ex) { LogManager.Log(ex, "Error loading jobs."); return null; } }); StatisticsValueCollection = new StatisticsValueCollection(); } /// <summary> /// Initializes this instance. Called form main view VM in OnApplicationReady /// </summary> public async void Init() { using (_notification.PushTaskItem("Loading job runs...")) { try { IsFree = false; using (var db = ObservablesContext.CreateDefault()) { _organizations = await db.Organizations.Select(x => new OrganisationToSiteModel(){ Name = x.Name, Guid = x.Guid}).ToListAsync(); foreach(var org in _organizations) { org.Sites = await db.Sites.Where(y => y.OrganizationGuid == org.Guid).Select(y => new SiteModel(){ Guid = y.Guid,Name = y.Name,}).ToListAsync(); foreach(var site in org.Sites) { site.Machines = await db.Machines.Where(x => x.SiteGuid == site.Guid).Select(y => new MachineModel(){Guid = y.Guid,Name = y.Name,SerialNumber = y.SerialNumber}).ToListAsync(); } org.Machines = await db.Machines.Where(y=> y.OrganizationGuid == org.Guid).Select(y => new MachineModel() {Guid = y.Guid, Name = y.Name, SerialNumber = y.SerialNumber }).ToListAsync(); } _allMachines = await db.Machines.ToListAsync(); _allUsers = await db.Users.Include(x => x.Contact).ToListAsync(); _rmlsModels = await db.Rmls.Select(x => new RmlModel() { Name = x.Name, Guid = x.Guid }).ToListAsync(); } IsEnabledSelectionSites = false; SelectedMachines = new SelectedObjectCollection<MachineModel>(new ObservableCollection<MachineModel>(), new ObservableCollection<MachineModel>()); SelectedThreads = new SelectedObjectCollection<RmlModel>(_rmlsModels.ToObservableCollection(), new ObservableCollection<RmlModel>()); SelectedSites = new SelectedObjectCollection<SiteModel>(new ObservableCollection<SiteModel>(), new ObservableCollection<SiteModel>()); SelectedOrganizations = new SelectedObjectCollection<OrganisationToSiteModel>(_organizations.ToObservableCollection(), _organizations.ToObservableCollection()); SelectedOrganizations.SelectionChanged -= OnSelectedOrganizationsChanged; SelectedOrganizations.SelectionChanged += OnSelectedOrganizationsChanged; SelectedSites.SelectionChanged -= OnSelectedSitesChanged; SelectedSites.SelectionChanged += OnSelectedSitesChanged; AllSelectedSites = true; AllSelectedMachines = true; } catch (Exception ex) { LogManager.Log(ex, "Error loading job runs."); } finally { IsFree = true; } } } private void OnSelectedSitesChanged(object sender, EventArgs e) { if (SelectedSites.SynchedSource.Count > 0) { SelectedMachines = new SelectedObjectCollection<MachineModel>(SelectedSites.SynchedSource.SelectMany(x => x.Machines).ToObservableCollection(), SelectedSites.SynchedSource.SelectMany(x => x.Machines).ToObservableCollection()); } else { SelectedMachines = new SelectedObjectCollection<MachineModel>(SelectedOrganizations.SynchedSource.SelectMany(x => x.Machines).ToObservableCollection(), SelectedOrganizations.SynchedSource.SelectMany(x => x.Machines).ToObservableCollection()); } AllSelectedMachines = false; AllSelectedMachines = true; InvalidateRelayCommands(); } private void OnSelectedOrganizationsChanged(object sender, EventArgs e) { if (SelectedOrganizations.SynchedSource.Count != SelectedOrganizations.Source.Count) { IsEnabledSelectionSites = true; var selectedOrg = SelectedOrganizations.SynchedSource.ToList(); SelectedSites = new SelectedObjectCollection<SiteModel>(selectedOrg.SelectMany(x => x.Sites).ToObservableCollection(), selectedOrg.SelectMany(x => x.Sites).ToObservableCollection()); SelectedSites.SelectionChanged -= OnSelectedSitesChanged; SelectedSites.SelectionChanged += OnSelectedSitesChanged; SelectedMachines = new SelectedObjectCollection<MachineModel>(selectedOrg.SelectMany(x => x.Machines).ToObservableCollection(), selectedOrg.SelectMany(x => x.Machines).ToObservableCollection()); AllSelectedSites = false; AllSelectedSites = true; } else { SelectedSites = new SelectedObjectCollection<SiteModel>(SelectedOrganizations.SynchedSource.SelectMany(x => x.Sites).ToObservableCollection(), SelectedOrganizations.SynchedSource.SelectMany(x => x.Sites).ToObservableCollection()); AllSelectedSites = false; IsEnabledSelectionSites = false; SelectedMachines = new SelectedObjectCollection<MachineModel>(SelectedOrganizations.SynchedSource.SelectMany(x => x.Machines).ToObservableCollection(), SelectedOrganizations.SynchedSource.SelectMany(x => x.Machines).ToObservableCollection()); } AllSelectedMachines = false; AllSelectedMachines = true; InvalidateRelayCommands(); } /// <summary> /// Loads the job runs by filters. /// </summary> private async Task LoadJobRuns() { using (_notification.PushTaskItem("Loading job runs...")) { try { IsFree = false; using (var db = ObservablesContext.CreateDefault()) { DateTime startUtc = new DateTime(StartSelectedDate.Year, StartSelectedDate.Month, StartSelectedDate.Day, 0, 0, 0).ToUniversalTime(); TimeSpan offsetTime = (EndSelectedDate.Date == DateTime.Now.Date) ? DateTime.Now.TimeOfDay : new TimeSpan(23, 59, 59); DateTime endUtc = EndSelectedDate.ToUniversalTime() + offsetTime; string jobName = SelectedJob == null ? "" : SelectedJob.Name; var db_JobRuns = db.JobRuns.Where(x => (x.StartDate <= endUtc && x.StartDate >= startUtc)) .Select(x => new { x.ID, x.ActualStartDate, x.EndDate, x.EndPosition, x.GradientResolutionCm, x.Guid, x.HeatingStartDate, x.IsGradient, x.JobGuid, x.JobLength, x.JobName, x.JobSource, x.MachineGuid, x.RmlGuid, x.StartDate, x.Status, x.UploadingStartDate, x.UserGuid, x.CyanQuantity, x.MagentaQuantity, x.YellowQuantity, x.BlackQuantity, x.TransparentQuantity, x.LubricantQuantity, x.CleanerQuantity, x.LightCyanQuantity, x.LightMagentaQuantity, x.LightYellowQuantity, x.IsHeadCleaning }); var machineIDs = new HashSet<string>(SelectedMachines.SynchedSource.ToList().Select(p => p.Guid)); if (machineIDs.Count > 0) { db_JobRuns = db_JobRuns.Where(x => machineIDs.Contains(x.MachineGuid)); } int[] jobRunSourceArr = JobRunSelectedSources.SynchedSource.Select(x => (int)x).ToArray(); if (jobRunSourceArr.Length > 0) { db_JobRuns = db_JobRuns.Where(x => jobRunSourceArr.Contains(x.JobSource)); } int[] jobRunStatusArr = JobRunSelectedStatuses.SynchedSource.Select(x => (int)x).ToArray(); if (jobRunStatusArr.Length > 0) { db_JobRuns = db_JobRuns.Where(x => jobRunStatusArr.Contains(x.Status)); } bool[] isGradientArr = IsGradientSelection.SynchedSource.Select(x => (bool)x).ToArray(); if (isGradientArr.Length > 0) { db_JobRuns = db_JobRuns.Where(x => isGradientArr.Contains(x.IsGradient)); } if(HeadCleaningSelected != HeadCleaningSelectionEnum.Include) { bool isHeadCleaning = HeadCleaningSelected == HeadCleaningSelectionEnum.Only; db_JobRuns = db_JobRuns.Where(x => isHeadCleaning == x.IsHeadCleaning); } List<String> rmlGuids = SelectedThreads.SynchedSource.Select(y => y.Guid).ToList(); if (rmlGuids != null && rmlGuids.Count > 0) { db_JobRuns = db_JobRuns.Where(x => rmlGuids.Contains(x.RmlGuid)); } if (!String.IsNullOrEmpty(jobName)) { db_JobRuns = db_JobRuns.Where(x => x.JobName.ToLower().StartsWith(jobName.ToLower())); } var runs_db = await db_JobRuns.ToListAsync(); //Execute actual query. List<JobRun> runs = runs_db.Where(x => (x.JobLength < LengthUpperValue && x.JobLength >= LengthLowerValue)) .Select(x => new JobRun() { ID = x.ID, ActualStartDate = x.ActualStartDate, EndDate = x.EndDate, EndPosition = x.EndPosition, GradientResolutionCm = x.GradientResolutionCm, Guid = x.Guid, HeatingStartDate = x.HeatingStartDate, IsGradient = x.IsGradient, JobGuid = x.JobGuid, JobLength = x.JobLength, JobName = x.JobName, JobSource = x.JobSource, MachineGuid = x.MachineGuid, RmlGuid = x.RmlGuid, StartDate = x.StartDate, Status = x.Status, UploadingStartDate = x.UploadingStartDate, UserGuid = x.UserGuid, CyanQuantity = x.CyanQuantity, MagentaQuantity = x.MagentaQuantity, YellowQuantity = x.YellowQuantity, BlackQuantity = x.BlackQuantity, TransparentQuantity = x.TransparentQuantity, LubricantQuantity = x.LubricantQuantity, CleanerQuantity = x.CleanerQuantity, LightCyanQuantity = x.LightCyanQuantity, LightMagentaQuantity = x.LightMagentaQuantity, LightYellowQuantity = x.LightYellowQuantity, IsHeadCleaning = x.IsHeadCleaning }).ToList(); var modelList = runs.Select(x => new JobRunModel() { JobRun = x, Machine = _allMachines.FirstOrDefault(y => y.Guid == x.MachineGuid), User = _allUsers.SingleOrDefault(y => y.Guid == x.UserGuid), Rml = _rmlsModels.SingleOrDefault(y => y.Guid == x.RmlGuid), }).OrderByDescending(x => x.JobRun.StartDate).ToList(); modelList.ForEach(x => x.Init()); JobRuns = modelList.ToObservableCollection(); GenerateStatistics(); } } catch (Exception ex) { LogManager.Log(ex, "Error loading job runs."); } finally { IsFree = true; } } } private void ExportToExcel() { SaveFileDialog dlg = new SaveFileDialog(); dlg.Title = "Job Runs Statistic Report"; dlg.Filter = "CSV Files|*.csv"; dlg.FileName = $"Statistics_Job_runs"; dlg.DefaultExt = ".csv"; if (dlg.ShowDialog().Value) { try { CsvFile<ExcelModel> csvFile = new CsvFile<ExcelModel>(new CsvDestination(dlg.FileName), new CsvDefinition() { Columns = new List<String>() { "ID", "Machine", "User", "Job Name", "Thread", "Length", "Source", "Upload Duration", "Heating Duration", "Start Time", "IsGradient", "Gradient Resolution", "Status", "End Date", "Total dyeing time", "End Position", "Cyan", "Magenta", "Yellow", "Black", "Transparent", "Lubricant", "Cleaner", "LightCyan", "LightMagenta", "LightYellow" }, }); var selection = JobRuns;// item 5861 (all available jobs should be saved) .Where(z => z.JobRun.EndPosition > 0 && z.JobRun.EndDate != null && z.JobRun.ActualStartDate != null); foreach (var jobRunModel in selection) { ExcelModel excel_model = new ExcelModel(); excel_model.ID = jobRunModel.JobRun.ID.ToString(); excel_model.Machine = jobRunModel.Machine != null ? jobRunModel.Machine.SerialNumber : ""; excel_model.User = jobRunModel.User != null ? jobRunModel.User.Contact.FullName: ""; excel_model.JobName = jobRunModel.JobRun.JobName; excel_model.Thread = jobRunModel.Rml != null ? jobRunModel.Rml.Name : ""; excel_model.Length = String.Format("{0:0.##}", jobRunModel.JobRun.JobLength); excel_model.Source = jobRunModel.JobRun.Source.ToString(); excel_model.UploadDuration = jobRunModel.UploadDuration != null ? ((TimeSpan)(jobRunModel.UploadDuration)).ToString(@"hh\:mm\:ss") : TimeSpan.FromSeconds(0).ToString(@"hh\:mm\:ss"); excel_model.HeatingDuration = jobRunModel.HeatingDuration != null ? ((TimeSpan)(jobRunModel.HeatingDuration)).ToString(@"hh\:mm\:ss") : TimeSpan.FromSeconds(0).ToString(@"hh\:mm\:ss"); excel_model.StartTime = jobRunModel.JobRun.ActualStartDate != null ? ((DateTime)jobRunModel.JobRun.ActualStartDate).ToLocalTime().ToString("MM/dd/yy HH:mm"): ""; excel_model.IsGradient = jobRunModel.JobRun.IsGradient ? "Yes" : "No"; excel_model.GR = jobRunModel.JobRun.GradientResolutionCm.ToString(); excel_model.Status = jobRunModel.JobRun.JobRunStatus.ToString(); excel_model.EndTime = jobRunModel.JobRun.EndDate != null ? ((DateTime)jobRunModel.JobRun.EndDate).ToLocalTime().ToString("MM/dd/yy HH:mm"): ""; excel_model.TotalDyeingTime = jobRunModel.JobRun.TotalDyeingTime != default(TimeSpan) ? ((TimeSpan)jobRunModel.JobRun.TotalDyeingTime).ToString(@"hh\:mm\:ss") : TimeSpan.FromSeconds(0).ToString(@"hh\:mm\:ss"); excel_model.EndPosition = String.Format("{0:0.##}", jobRunModel.JobRun.EndPosition); excel_model.Cyan = jobRunModel.JobRun.CyanQuantity < 0 ? "" :jobRunModel.JobRun.CyanQuantity.ToString(); excel_model.Magenta = jobRunModel.JobRun.MagentaQuantity < 0 ? "" : jobRunModel.JobRun.MagentaQuantity.ToString(); excel_model.Yellow = jobRunModel.JobRun.YellowQuantity < 0 ? "" : jobRunModel.JobRun.YellowQuantity.ToString(); excel_model.Black = jobRunModel.JobRun.BlackQuantity < 0 ? "" : jobRunModel.JobRun.BlackQuantity.ToString(); excel_model.Transparent = jobRunModel.JobRun.TransparentQuantity < 0 ? "" : jobRunModel.JobRun.TransparentQuantity.ToString(); excel_model.Lubricant = jobRunModel.JobRun.LubricantQuantity < 0 ? "" : jobRunModel.JobRun.LubricantQuantity.ToString(); excel_model.Cleaner = jobRunModel.JobRun.CleanerQuantity < 0 ? "" : jobRunModel.JobRun.CleanerQuantity.ToString(); excel_model.LightCyan = jobRunModel.JobRun.LightCyanQuantity < 0 ? "" : jobRunModel.JobRun.LightCyanQuantity.ToString(); excel_model.LightMagenta = jobRunModel.JobRun.LightMagentaQuantity < 0 ? "" : jobRunModel.JobRun.LightMagentaQuantity.ToString(); excel_model.LightYellow = jobRunModel.JobRun.LightYellowQuantity < 0 ? "" : jobRunModel.JobRun.LightYellowQuantity.ToString(); csvFile.Append(excel_model); } csvFile.Dispose(); _notification.ShowInfo("Report generated successfully."); } catch (Exception ex) { LogManager.Log(ex, "Error generating Statistics Job Runs report."); _notification.ShowError($"Error generating Statistics Job Runs report..\n{ex.Message}"); } } } #region GenerateS_StatisticsValueCollection /// <summary> /// Generates the statistics. /// </summary> protected void GenerateStatistics() { StatisticsValueCollection.Clean(); if (JobRuns.Count() == 0) return; GenerateTotalRunsCount(); GenerateTotalRunsLength(); GenerateTotalThreadConsumption(); GenerateRunsDuration(); GenerateAverageUploadDuration(); GenerateAverageHeatingDuration(); GeneratePieCharts(); CreateThreadConsumptionPerThread(); GenerateAllLiquidQuantities(); } protected void GenerateTotalRunsCount() {//Total Runs: int val = JobRuns.Count(); StatisticsValueCollection.AddStatisticsValue("Total Runs ", val, " "); } /// <summary> /// Generates the total length of the job runs. /// </summary> protected void GenerateTotalRunsLength() { double val = JobRuns.Where(z => z.JobRun.EndPosition > 0).Sum(x => x.JobRun.JobLength); StatisticsValueCollection.AddStatisticsValue("Total Runs Length", val, " m"); } /// <summary> /// Generates the duration and average of the job runs. /// </summary> protected void GenerateRunsDuration() { var selection = JobRuns.Where(z => z.JobRun.EndPosition > 0 && z.JobRun.EndDate != null && z.JobRun.ActualStartDate != null); double val = 0d; double average = 0d; if (selection != null && selection.Count<JobRunModel>() > 0) { val = selection.Sum(x => (x.JobRun.EndDate - x.JobRun.ActualStartDate).Value.TotalHours); average = selection.Average(x => (x.JobRun.EndDate - x.JobRun.ActualStartDate).Value.TotalMilliseconds); } StatisticsValueCollection.AddStatisticsValue("Total Dyeing Time", val, " hours"); StatisticsValueCollection.AddStatisticsValue("Average Dyeing Time", Math.Max(TimeSpan.FromMilliseconds(average).TotalHours, 0), " hours"); } /// <summary> /// Generates the average upload duration of the job runs. /// </summary> protected void GenerateAverageUploadDuration() { var average = (long)JobRuns.Where(z => z.JobRun.EndPosition > 0 && z.UploadDuration != null).Average(x => x.UploadDuration.Value.TotalMilliseconds); StatisticsValueCollection.AddStatisticsValue("Average Upload Duration", Math.Max(TimeSpan.FromMilliseconds(average).TotalMinutes, 0), " minutes"); } /// <summary> /// Generates the average duration heating of the job runs. /// </summary> protected void GenerateAverageHeatingDuration() { var average = JobRuns.Where(z => z.JobRun.EndPosition > 0 && z.HeatingDuration != null && z.HeatingDuration.Value.Ticks > 0).Average(x => x.HeatingDuration.Value.TotalMilliseconds); StatisticsValueCollection.AddStatisticsValue("Average Heating Duration", Math.Max(TimeSpan.FromMilliseconds(average).TotalMinutes, 0), " minutes"); } /// <summary> /// Generates the total thread consumption by EndPosition. /// </summary> protected void GenerateTotalThreadConsumption() { double val = JobRuns.Where(z => z.JobRun.EndPosition > 0).Sum(x => x.JobRun.EndPosition); StatisticsValueCollection.AddStatisticsValue("Total Dyeing Length", val, " m"); } /// <summary> /// Generates the pie charts in percentage: JobSource, JobRunStatus, Gradient. /// </summary> protected void GeneratePieCharts() { int PPCCount = JobRuns.Count(x => x.JobRun.Source == JobSource.Local); int MSCount = JobRuns.Count(x => x.JobRun.Source == JobSource.Remote); StatisticsValueCollection.GeneratePieJobSource(PPCCount, MSCount); int failedCount = JobRuns.Count(x => x.JobRun.JobRunStatus == JobRunStatus.Failed); int abortedCount = JobRuns.Count(x => x.JobRun.JobRunStatus == JobRunStatus.Aborted); int completedCount = JobRuns.Count(x => x.JobRun.JobRunStatus == JobRunStatus.Completed); StatisticsValueCollection.GeneratePieJobRunStatus(failedCount, abortedCount, completedCount); int gradientCount = JobRuns.Count(x => x.JobRun.IsGradient == true); int solidCount = JobRuns.Count(x => x.JobRun.IsGradient == false); StatisticsValueCollection.GeneratePieGradientSolid(gradientCount, solidCount); } /// <summary> /// Creates the thread consumption per thread. /// </summary> protected void CreateThreadConsumptionPerThread() { var temp = JobRuns.Where(z => z.JobRun.EndPosition > 0 && z.Rml != null).GroupBy(x => x.Rml.Name); List<StatisticsValue> result = JobRuns.Where(z => z.JobRun.EndPosition > 0 && z.Rml != null && !String.IsNullOrEmpty(z.Rml.Name)).GroupBy(x => x.Rml.Name).Select(y => new StatisticsValue { Name = y.Key, Value = y.Sum(x => x.JobRun.EndPosition), Unit = "m" }).ToList(); StatisticsValueCollection.CreateThreadConsumptionPerThread(result); } /// <summary> /// Generates all liquid quantities. /// </summary> protected void GenerateAllLiquidQuantities() { var runs = JobRuns.Where(z => z.JobRun.EndPosition > 0 && z.JobRun.LiquidQuantitiesFast.Count > 0).ToList(); Dictionary<LiquidTypes, ulong> total_quantities = new Dictionary<LiquidTypes, ulong>(); foreach (LiquidTypes ltype in (LiquidTypes[])Enum.GetValues(typeof(LiquidTypes))) { total_quantities[ltype] = 0; } foreach (var run in runs) { foreach (var lq in run.JobRun.LiquidQuantitiesFast) { if (lq.Quantity < 0) { Debug.WriteLine($"Warning: JobRun '{run.JobRun.ID}' of machine '{run.Machine?.SerialNumber}' with user '{run.User?.Email}' started on '{run.JobRun.StartDate.ToLocalTime()}' ended on '{run.JobRun.EndDate.ToLocalTime()}' contains an invalid value '{lq.Quantity}' for {lq.LiquidType} quantity."); } total_quantities[lq.LiquidType] += Convert.ToUInt64(Math.Max(lq.Quantity, 0)); } } List<TotalLiquidQuantityModel> allLiquidQuantities = total_quantities.Select(x => new TotalLiquidQuantityModel() { LiquidType = x.Key, Quantity = x.Value }).ToList(); //foreach (LiquidTypes ltype in (LiquidTypes[])Enum.GetValues(typeof(LiquidTypes))) //{ // var liquidQuantityByTypeList = db_liquidQuantities.Select(x => x.FirstOrDefault(y => y.LiquidType == ltype)).Where(x => x != null); // var count = liquidQuantityByTypeList != null ? liquidQuantityByTypeList.Sum(x => x.Quantity) : 0; // JobRunLiquidQuantity lq = new JobRunLiquidQuantity() { LiquidType = ltype, Quantity = count }; // allLiquidQuantities.Add(lq); //} StatisticsValueCollection.GenerateStatisticsLiquidQuantity(allLiquidQuantities); } #endregion } }