-
Notifications
You must be signed in to change notification settings - Fork 0
/
Main.xaml
177 lines (177 loc) · 11.3 KB
/
Main.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
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
<Activity mc:Ignorable="sap sap2010 sads" x:Class="Main" mva:VisualBasic.Settings="{x:Null}" sap2010:WorkflowViewState.IdRef="Main_1"
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:sads="http://schemas.microsoft.com/netfx/2010/xaml/activities/debugger"
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:sco="clr-namespace:System.Collections.ObjectModel;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">
<TextExpression.NamespacesForImplementation>
<sco:Collection x:TypeArguments="x:String">
<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.Xml.Serialization</x:String>
</sco:Collection>
</TextExpression.NamespacesForImplementation>
<TextExpression.ReferencesForImplementation>
<sco:Collection x:TypeArguments="AssemblyReference">
<AssemblyReference>System.Activities</AssemblyReference>
<AssemblyReference>Microsoft.VisualBasic</AssemblyReference>
<AssemblyReference>mscorlib</AssemblyReference>
<AssemblyReference>System.Data</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.UiAutomation.Activities</AssemblyReference>
<AssemblyReference>UiPath.System.Activities</AssemblyReference>
<AssemblyReference>System.Data.DataSetExtensions</AssemblyReference>
<AssemblyReference>System.ServiceModel</AssemblyReference>
<AssemblyReference>System.ValueTuple</AssemblyReference>
<AssemblyReference>UiPath.Excel</AssemblyReference>
<AssemblyReference>UiPath.Mail</AssemblyReference>
<AssemblyReference>UiPath.Studio.Plugin.Workflow</AssemblyReference>
</sco:Collection>
</TextExpression.ReferencesForImplementation>
<Sequence DisplayName="Main" sap2010:WorkflowViewState.IdRef="Sequence_1">
<Sequence.Variables>
<Variable x:TypeArguments="ui:DatabaseConnection" Name="db_Connection" />
<Variable x:TypeArguments="x:Int32" Name="AffectedRecords" />
<Variable x:TypeArguments="sd:DataTable" Name="dt_Test" />
<Variable x:TypeArguments="x:Int32" Name="index_Column" />
<Variable x:TypeArguments="ui:GenericValue" Name="columnName_List" />
</Sequence.Variables>
<ui:DatabaseConnect sap2010:Annotation.AnnotationText="Connecting a excel like a MS Access db.

So that we can handle this by SQL queries." DatabaseConnection="[db_Connection]" DisplayName="Connect" sap2010:WorkflowViewState.IdRef="DatabaseConnect_1" ProviderName="System.Data.Odbc" ConnectionString="Dsn=Excel Files;dbq=D:\RPA\ManojV\DeleteData_ExcelSheet\TEST.xlsx;defaultdir=D:\RPA\ManojV\DeleteData_ExcelSheet;driverid=1046;maxbuffersize=2048;pagetimeout=5" />
<ui:ExecuteQuery ContinueOnError="{x:Null}" TimeoutMS="{x:Null}" CommandType="Text" DataTable="[dt_Test]" DisplayName="Execute Query" ExistingDbConnection="[db_Connection]" sap2010:WorkflowViewState.IdRef="ExecuteQuery_1" Sql="SELECT * FROM [Sheet1$]">
<ui:ExecuteQuery.Parameters>
<scg:Dictionary x:TypeArguments="x:String, Argument" />
</ui:ExecuteQuery.Parameters>
</ui:ExecuteQuery>
<WriteLine DisplayName="Write Line" sap2010:WorkflowViewState.IdRef="WriteLine_2" Text="[dt_Test.Rows.Count.ToString]" />
<ui:ForEach x:TypeArguments="x:Object" CurrentIndex="[index_Column]" DisplayName="Looping - Columns" sap2010:WorkflowViewState.IdRef="ForEach`1_2" Values="[dt_Test.Columns]">
<ui:ForEach.Body>
<ActivityAction x:TypeArguments="x:Object">
<ActivityAction.Argument>
<DelegateInArgument x:TypeArguments="x:Object" Name="column" />
</ActivityAction.Argument>
<If sap2010:Annotation.AnnotationText="Appending columns for update query" Condition="[index_Column > 0]" sap2010:WorkflowViewState.IdRef="If_1">
<If.Then>
<Assign sap2010:WorkflowViewState.IdRef="Assign_1">
<Assign.To>
<OutArgument x:TypeArguments="ui:GenericValue">[columnName_List]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="ui:GenericValue">[columnName_List + ", [" + column.ToString + "] = NULL"]</InArgument>
</Assign.Value>
</Assign>
</If.Then>
<If.Else>
<Assign sap2010:WorkflowViewState.IdRef="Assign_2">
<Assign.To>
<OutArgument x:TypeArguments="ui:GenericValue">[columnName_List]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="ui:GenericValue">["[" + column.ToString + "] = NULL"]</InArgument>
</Assign.Value>
</Assign>
</If.Else>
</If>
</ActivityAction>
</ui:ForEach.Body>
</ui:ForEach>
<WriteLine DisplayName="Write Line" sap2010:WorkflowViewState.IdRef="WriteLine_3" Text="["UPDATE [Sheet1$] SET " + columnName_List]" />
<ui:ExecuteNonQuery ContinueOnError="{x:Null}" TimeoutMS="{x:Null}" AffectedRecords="[AffectedRecords]" sap2010:Annotation.AnnotationText="Update a all the columns as null instead of deleting." CommandType="Text" DisplayName="Execute - Delete All Data" ExistingDbConnection="[db_Connection]" sap2010:WorkflowViewState.IdRef="ExecuteNonQuery_1" Sql="["UPDATE [Sheet1$] SET " + columnName_List]">
<ui:ExecuteNonQuery.Parameters>
<scg:Dictionary x:TypeArguments="x:String, Argument" />
</ui:ExecuteNonQuery.Parameters>
</ui:ExecuteNonQuery>
<WriteLine DisplayName="Write Line" sap2010:WorkflowViewState.IdRef="WriteLine_1" Text="[AffectedRecords.ToString]" />
<sads:DebugSymbol.Symbol>dy1EOlxSUEFcTWFub2pWXERlbGV0ZURhdGFfRXhjZWxTaGVldFxNYWluLnhhbWweQAN2DgIBAUgFSOcDAgEnSQVNFwIBIU4FTn4CAR9PBW0SAgENbgVulgECAQtvBXMaAgEFdAV0ewIBAkifAkixAgIBK0jDAkjkAwIBKki2AUjHAQIBKEmgAUmxAQIBJUljSW4CASNJ5wFJgAICASJOXE57AgEgT58BT7IBAgEeTzlPSQIBHFULahACAQ5uXG6TAQIBDG+XAm+oAgIBCW/hAm+YAwIBCG9Zb2wCAQZ0XHR4AgEDVWBVdwIBD1cPXhgCARZhD2gYAgERXEFceQIBGVlCWVMCARdmQWZlAgEUY0JjUwIBEg==</sads:DebugSymbol.Symbol>
</Sequence>
<sap2010:WorkflowViewState.ViewStateManager>
<sap2010:ViewStateManager>
<sap2010:ViewStateData Id="DatabaseConnect_1" sap:VirtualizedContainerService.HintSize="314,116">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</sap2010:ViewStateData>
<sap2010:ViewStateData Id="ExecuteQuery_1" sap:VirtualizedContainerService.HintSize="314,88">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</sap2010:ViewStateData>
<sap2010:ViewStateData Id="WriteLine_2" sap:VirtualizedContainerService.HintSize="314,61" />
<sap2010:ViewStateData Id="Assign_1" sap:VirtualizedContainerService.HintSize="242,60" />
<sap2010:ViewStateData Id="Assign_2" sap:VirtualizedContainerService.HintSize="242,60" />
<sap2010:ViewStateData Id="If_1" sap:VirtualizedContainerService.HintSize="200,93">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
<x:Boolean x:Key="IsExpanded">False</x:Boolean>
<x:Boolean x:Key="IsPinned">False</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</sap2010:ViewStateData>
<sap2010:ViewStateData Id="ForEach`1_2" sap:VirtualizedContainerService.HintSize="314,51">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">False</x:Boolean>
<x:Boolean x:Key="IsPinned">False</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</sap2010:ViewStateData>
<sap2010:ViewStateData Id="WriteLine_3" sap:VirtualizedContainerService.HintSize="314,61" />
<sap2010:ViewStateData Id="ExecuteNonQuery_1" sap:VirtualizedContainerService.HintSize="314,93">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
<x:Boolean x:Key="IsExpanded">False</x:Boolean>
<x:Boolean x:Key="IsPinned">False</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</sap2010:ViewStateData>
<sap2010:ViewStateData Id="WriteLine_1" sap:VirtualizedContainerService.HintSize="314,61" />
<sap2010:ViewStateData Id="Sequence_1" sap:VirtualizedContainerService.HintSize="336,895">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
</sap2010:ViewStateData>
<sap2010:ViewStateData Id="Main_1" sap:VirtualizedContainerService.HintSize="376,975" />
</sap2010:ViewStateManager>
</sap2010:WorkflowViewState.ViewStateManager>
</Activity>