-
Notifications
You must be signed in to change notification settings - Fork 0
/
Saga_VerifyFinalAmount.xaml
151 lines (151 loc) · 11.4 KB
/
Saga_VerifyFinalAmount.xaml
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
<Activity mc:Ignorable="sap sap2010" x:Class="Saga_VerifyFinalAmount" xmlns="http://schemas.microsoft.com/netfx/2009/xaml/activities" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:mva="clr-namespace:Microsoft.VisualBasic.Activities;assembly=System.Activities" xmlns:sap="http://schemas.microsoft.com/netfx/2009/xaml/activities/presentation" xmlns:sap2010="http://schemas.microsoft.com/netfx/2010/xaml/activities/presentation" xmlns:scg="clr-namespace:System.Collections.Generic;assembly=mscorlib" xmlns:sd="clr-namespace:System.Data;assembly=System.Data" xmlns:ui="http://schemas.uipath.com/workflow/activities" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml">
<x:Members>
<x:Property Name="in_invoiceInfoDT" Type="InArgument(sd:DataTable)" />
</x:Members>
<mva:VisualBasic.Settings>
<x:Null />
</mva:VisualBasic.Settings>
<sap:VirtualizedContainerService.HintSize>1208,1229</sap:VirtualizedContainerService.HintSize>
<sap2010:WorkflowViewState.IdRef>Saga_VerifyFinalAmount_1</sap2010:WorkflowViewState.IdRef>
<TextExpression.NamespacesForImplementation>
<scg:List x:TypeArguments="x:String" Capacity="58">
<x:String>System.Activities</x:String>
<x:String>System.Activities.Statements</x:String>
<x:String>System.Activities.Expressions</x:String>
<x:String>System.Activities.Validation</x:String>
<x:String>System.Activities.XamlIntegration</x:String>
<x:String>Microsoft.VisualBasic</x:String>
<x:String>Microsoft.VisualBasic.Activities</x:String>
<x:String>System</x:String>
<x:String>System.Collections</x:String>
<x:String>System.Collections.Generic</x:String>
<x:String>System.Data</x:String>
<x:String>System.Diagnostics</x:String>
<x:String>System.Drawing</x:String>
<x:String>System.IO</x:String>
<x:String>System.Linq</x:String>
<x:String>System.Net.Mail</x:String>
<x:String>System.Xml</x:String>
<x:String>System.Xml.Linq</x:String>
<x:String>UiPath.Core</x:String>
<x:String>UiPath.Core.Activities</x:String>
<x:String>System.Windows.Markup</x:String>
<x:String>System.Collections.ObjectModel</x:String>
<x:String>System.Activities.DynamicUpdate</x:String>
<x:String>UiPath.Platform.ObjectLibrary</x:String>
<x:String>System.ComponentModel</x:String>
<x:String>System.Runtime.Serialization</x:String>
<x:String>System.Xml.Serialization</x:String>
<x:String>UiPath.Excel</x:String>
<x:String>UiPath.Excel.Activities</x:String>
<x:String>System.Runtime.InteropServices</x:String>
</scg:List>
</TextExpression.NamespacesForImplementation>
<TextExpression.ReferencesForImplementation>
<scg:List x:TypeArguments="AssemblyReference" Capacity="27">
<AssemblyReference>System.Activities</AssemblyReference>
<AssemblyReference>Microsoft.VisualBasic</AssemblyReference>
<AssemblyReference>mscorlib</AssemblyReference>
<AssemblyReference>System.Data</AssemblyReference>
<AssemblyReference>System.Data.DataSetExtensions</AssemblyReference>
<AssemblyReference>System</AssemblyReference>
<AssemblyReference>System.Drawing</AssemblyReference>
<AssemblyReference>System.Core</AssemblyReference>
<AssemblyReference>System.Xml</AssemblyReference>
<AssemblyReference>System.Xml.Linq</AssemblyReference>
<AssemblyReference>PresentationFramework</AssemblyReference>
<AssemblyReference>WindowsBase</AssemblyReference>
<AssemblyReference>PresentationCore</AssemblyReference>
<AssemblyReference>System.Xaml</AssemblyReference>
<AssemblyReference>UiPath.System.Activities</AssemblyReference>
<AssemblyReference>UiPath.UiAutomation.Activities</AssemblyReference>
<AssemblyReference>UiPath.System.Activities.Design</AssemblyReference>
<AssemblyReference>System.ValueTuple</AssemblyReference>
<AssemblyReference>UiPath.IntelligentOCR</AssemblyReference>
<AssemblyReference>UiPath.Excel</AssemblyReference>
<AssemblyReference>UiPath.CV</AssemblyReference>
<AssemblyReference>System.ServiceModel</AssemblyReference>
<AssemblyReference>System.ComponentModel.Composition</AssemblyReference>
<AssemblyReference>UiPath.Platform</AssemblyReference>
<AssemblyReference>System.Runtime.Serialization</AssemblyReference>
<AssemblyReference>UiPath.Excel.Activities</AssemblyReference>
</scg:List>
</TextExpression.ReferencesForImplementation>
<Sequence DisplayName="Saga_VerifyFinalAmount" sap:VirtualizedContainerService.HintSize="697,1064" sap2010:WorkflowViewState.IdRef="Sequence_1">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ui:LogMessage DisplayName="Log Message" sap:VirtualizedContainerService.HintSize="655,91" sap2010:WorkflowViewState.IdRef="LogMessage_1" Level="Info" Message="["Start Saga_VerifyFinalAmount"]" />
<ui:WindowScope ApplicationWindow="{x:Null}" SearchScope="{x:Null}" TimeoutMS="{x:Null}" Window="{x:Null}" DisplayName="Attach Window 'SAGAC3053 Sc9c'" sap:VirtualizedContainerService.HintSize="655,841" sap2010:WorkflowViewState.IdRef="WindowScope_1" InformativeScreenshot="182dca618ea9131ac5ca8be8085c7a5b" Selector="<wnd app='sc.exe' cls='sc9c*' title='SAGA C.3.0.535 test ADMIN ' />">
<ui:WindowScope.Body>
<ActivityAction x:TypeArguments="x:Object">
<ActivityAction.Argument>
<DelegateInArgument x:TypeArguments="x:Object" Name="ContextTarget" />
</ActivityAction.Argument>
<Sequence DisplayName="Do" sap:VirtualizedContainerService.HintSize="621,695" sap2010:WorkflowViewState.IdRef="Sequence_2">
<Sequence.Variables>
<Variable x:TypeArguments="sd:DataTable" Name="ExtractDataTable" />
<Variable x:TypeArguments="x:Boolean" Name="matching" />
</Sequence.Variables>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
<x:Boolean x:Key="IsPinned">False</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ui:ExtractData DelayBetweenPagesMS="{x:Null}" NextLinkSelector="{x:Null}" ContinueOnError="True" DataTable="[ExtractDataTable]" DisplayName="Extract Structured Data 'table View 1'" ExtractMetadata="<extract-table get_columns_name='1' get_empty_columns='1' columns_name_source='Longest' />" sap:VirtualizedContainerService.HintSize="579,106" sap2010:WorkflowViewState.IdRef="ExtractData_1" MaxNumberOfResults="0" SimulateClick="True">
<ui:ExtractData.Target>
<ui:Target ClippingRegion="{x:Null}" Element="{x:Null}" Id="5e06c0c6-0fb6-48db-ba45-7adc548d6a86" InformativeScreenshot="99964386c3e89a16fadaf2f2a6b1c565" Selector="<wnd cls='sc9c*' title='Intrari (facturi &amp; bonuri de casa &amp; avize)' /><ctrl name='Mygrid2' role='grouping' /><ctrl name='GridOp' role='table' /><ctrl name='View 1' role='table' />">
<ui:Target.TimeoutMS>
<InArgument x:TypeArguments="x:Int32" />
</ui:Target.TimeoutMS>
<ui:Target.WaitForReady>
<InArgument x:TypeArguments="ui:WaitForReady" />
</ui:Target.WaitForReady>
</ui:Target>
</ui:ExtractData.Target>
</ui:ExtractData>
<ui:InvokeCode ContinueOnError="{x:Null}" Code="Try
Dim dr As DataRow = in_sagaScraped.AsEnumerable.Where(Function(x) x(3).tostring.Trim.Contains(in_invoiceInfoDT.rows(0)("Nr factura").ToString.Trim)).First()

console.WriteLine("Total factura: "+in_invoiceInfoDT.rows(0)("Total de plata").ToString.Trim)
console.WriteLine("Total saga: "+dr(12).ToString)

If CDbl(in_invoiceInfoDT.rows(0)("Total de plata").ToString.Trim.Replace(".","").Replace(",","."))-0.2 < CDbl(dr(12).ToString) or CDbl(dr(12).ToString) > CDbl(in_invoiceInfoDT.rows(0)("Total de plata").ToString.Trim.Replace(".","").Replace(",","."))+0.2
	out_matching = True
Else
	out_matching =False
End If
Catch ex As Exception
	console.WriteLine(ex.Message)
	out_matching = True
end try" DisplayName="Invoke code" sap:VirtualizedContainerService.HintSize="579,164" sap2010:WorkflowViewState.IdRef="InvokeCode_1">
<ui:InvokeCode.Arguments>
<InArgument x:TypeArguments="sd:DataTable" x:Key="in_invoiceInfoDT">[in_invoiceInfoDT]</InArgument>
<InArgument x:TypeArguments="sd:DataTable" x:Key="in_sagaScraped">[ExtractDataTable]</InArgument>
<OutArgument x:TypeArguments="x:Boolean" x:Key="out_matching">[matching]</OutArgument>
</ui:InvokeCode.Arguments>
</ui:InvokeCode>
<If Condition="[matching]" sap:VirtualizedContainerService.HintSize="579,253" sap2010:WorkflowViewState.IdRef="If_1">
<If.Then>
<ui:Click AlterIfDisabled="{x:Null}" DelayBefore="{x:Null}" DelayMS="{x:Null}" SendWindowMessages="{x:Null}" SimulateClick="{x:Null}" ClickType="CLICK_SINGLE" DisplayName="Click 'push button Validez'" sap:VirtualizedContainerService.HintSize="334,106" sap2010:WorkflowViewState.IdRef="Click_1" KeyModifiers="None" MouseButton="BTN_LEFT">
<ui:Click.CursorPosition>
<ui:CursorPosition Position="Center">
<ui:CursorPosition.OffsetX>
<InArgument x:TypeArguments="x:Int32" />
</ui:CursorPosition.OffsetX>
<ui:CursorPosition.OffsetY>
<InArgument x:TypeArguments="x:Int32" />
</ui:CursorPosition.OffsetY>
</ui:CursorPosition>
</ui:Click.CursorPosition>
<ui:Click.Target>
<ui:Target ClippingRegion="{x:Null}" Element="{x:Null}" Id="dd7a82e4-c353-4270-b721-e95810927f53" InformativeScreenshot="26be8e1625ae1d2c538d7d47f2ba908e" Selector="<wnd cls='sc9c*' title='Intrari (facturi &amp; bonuri de casa &amp; avize)' /><ctrl name=' Validez' role='push button' />">
<ui:Target.TimeoutMS>
<InArgument x:TypeArguments="x:Int32" />
</ui:Target.TimeoutMS>
<ui:Target.WaitForReady>
<InArgument x:TypeArguments="ui:WaitForReady" />
</ui:Target.WaitForReady>
</ui:Target>
</ui:Click.Target>
</ui:Click>
</If.Then>
<If.Else>
<Throw Exception="[New BusinessRuleException("total nevalid")]" sap:VirtualizedContainerService.HintSize="200,22" sap2010:WorkflowViewState.IdRef="Throw_1" />
</If.Else>
</If>
</Sequence>
</ActivityAction>
</ui:WindowScope.Body>
</ui:WindowScope>
</Sequence>
</Activity>