-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSql Connection.xaml
115 lines (115 loc) · 10.8 KB
/
Sql Connection.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
<Activity mc:Ignorable="sap sap2010" x:Class="Sequence" mva:VisualBasic.Settings="{x:Null}" sap:VirtualizedContainerService.HintSize="709,1348" sap2010:WorkflowViewState.IdRef="Sequence_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: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">
<TextExpression.NamespacesForImplementation>
<scg:List x:TypeArguments="x:String" Capacity="30">
<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>UiPath.Database</x:String>
<x:String>UiPath.Database.Activities</x:String>
<x:String>System.Runtime.Serialization</x:String>
<x:String>System.ComponentModel</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.Collections.ObjectModel</x:String>
<x:String>System.Activities.DynamicUpdate</x:String>
</scg:List>
</TextExpression.NamespacesForImplementation>
<TextExpression.ReferencesForImplementation>
<scg:List x:TypeArguments="AssemblyReference" Capacity="23">
<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.Database</AssemblyReference>
<AssemblyReference>UiPath.Database.Activities</AssemblyReference>
<AssemblyReference>System.Runtime.Serialization</AssemblyReference>
<AssemblyReference>UiPath.System.Activities.Design</AssemblyReference>
<AssemblyReference>UiPath.Excel.Activities.Design</AssemblyReference>
<AssemblyReference>UiPath.Excel.Activities</AssemblyReference>
<AssemblyReference>UiPath.Excel</AssemblyReference>
</scg:List>
</TextExpression.ReferencesForImplementation>
<Sequence DisplayName="Sql Connect" sap:VirtualizedContainerService.HintSize="376,1183" sap2010:WorkflowViewState.IdRef="Sequence_1">
<Sequence.Variables>
<Variable x:TypeArguments="ui:DatabaseConnection" Name="DBConnection" />
<Variable x:TypeArguments="sd:DataTable" Name="dt_TransactionList" />
<Variable x:TypeArguments="x:String" Name="DogrulananBilgiler" />
<Variable x:TypeArguments="sd:DataTable" Name="dtTable" />
<Variable x:TypeArguments="sd:DataTable" Name="DB_Tablo" />
</Sequence.Variables>
<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:DatabaseConnect DatabaseConnection="[DBConnection]" DisplayName="Connect" sap:VirtualizedContainerService.HintSize="334,59" sap2010:WorkflowViewState.IdRef="DatabaseConnect_1" ProviderName="System.Data.SqlClient" ConnectionString="Data Source=(localdb)\tg;Initial Catalog=VKN_TCKN_DB;Integrated Security=True" />
<ui:LogMessage DisplayName="Log Message" sap:VirtualizedContainerService.HintSize="334,93" sap2010:WorkflowViewState.IdRef="LogMessage_1" Level="Info" Message="[DBConnection.ToString + " sağlandı."]" />
<ui:BuildDataTable DataTable="[dtTable]" DisplayName="Build Data Table" sap:VirtualizedContainerService.HintSize="334,59" sap2010:WorkflowViewState.IdRef="BuildDataTable_1" TableInfo="<NewDataSet>
 <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
 <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="TableName" msdata:UseCurrentLocale="true">
 <xs:complexType>
 <xs:choice minOccurs="0" maxOccurs="unbounded">
 <xs:element name="TableName">
 <xs:complexType>
 <xs:sequence>
 <xs:element name="TTBY_ID" msdata:Caption="" type="xs:string" minOccurs="0" />
 <xs:element name="VKN" msdata:Caption="" type="xs:string" minOccurs="0" />
 <xs:element name="TCKN" msdata:Caption="" type="xs:string" minOccurs="0" />
 <xs:element name="Unvan" msdata:Caption="" type="xs:string" minOccurs="0" />
 <xs:element name="VergiDairesi" msdata:Caption="" type="xs:string" minOccurs="0" />
 <xs:element name="FaalDurum" msdata:Caption="" type="xs:string" minOccurs="0" />
 <xs:element name="IslemKayıtTarihi" msdata:Caption="" type="xs:dateTime" minOccurs="0" />
 </xs:sequence>
 </xs:complexType>
 </xs:element>
 </xs:choice>
 </xs:complexType>
 </xs:element>
 </xs:schema>
 <TableName>
 <TTBY_ID>6456456</TTBY_ID>
 <VKN>46546456</VKN>
 <TCKN>7987979879</TCKN>
 <Unvan>hjljkuh</Unvan>
 <VergiDairesi>serdivan</VergiDairesi>
 <FaalDurum>ldkd</FaalDurum>
 </TableName>
</NewDataSet>" />
<Assign sap:VirtualizedContainerService.HintSize="334,60" sap2010:WorkflowViewState.IdRef="Assign_1">
<Assign.To>
<OutArgument x:TypeArguments="x:Object">[dtTable.Rows(0).Item("IslemKayıtTarihi")]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:Object">[Date.Now]</InArgument>
</Assign.Value>
</Assign>
<ui:ReadRange AddHeaders="False" DataTable="[dt_TransactionList]" DisplayName="Read Range" sap:VirtualizedContainerService.HintSize="334,87" sap2010:WorkflowViewState.IdRef="ReadRange_1" SheetName="Sayfa1" WorkbookPath="C:\Users\tesnim\Desktop\Test_data.xlsx">
<ui:ReadRange.Range>
<InArgument x:TypeArguments="x:String">
<Literal x:TypeArguments="x:String" Value="" />
</InArgument>
</ui:ReadRange.Range>
</ui:ReadRange>
<ui:ExecuteQuery ContinueOnError="{x:Null}" TimeoutMS="{x:Null}" CommandType="Text" DataTable="[DB_Tablo]" DisplayName="Execute Query" ExistingDbConnection="[DBConnection]" sap:VirtualizedContainerService.HintSize="334,88" sap2010:WorkflowViewState.IdRef="ExecuteQuery_1" Sql="SELECT * FROM [DogrulananBilgiler]">
<ui:ExecuteQuery.Parameters>
<scg:Dictionary x:TypeArguments="x:String, Argument" />
</ui:ExecuteQuery.Parameters>
</ui:ExecuteQuery>
<ui:InsertDataTable AffectedRecords="{x:Null}" ContinueOnError="{x:Null}" DataTable="[dtTable]" DisplayName="Insert" ExistingDbConnection="[DBConnection]" sap:VirtualizedContainerService.HintSize="334,115" sap2010:WorkflowViewState.IdRef="InsertDataTable_1" TableName="DogrulananBilgiler" />
<ui:ExecuteQuery ContinueOnError="{x:Null}" TimeoutMS="{x:Null}" CommandType="Text" DataTable="[DB_Tablo]" DisplayName="Execute Query" ExistingDbConnection="[DBConnection]" sap:VirtualizedContainerService.HintSize="334,88" sap2010:WorkflowViewState.IdRef="ExecuteQuery_2" Sql="SELECT * FROM [DogrulananBilgiler]">
<ui:ExecuteQuery.Parameters>
<scg:Dictionary x:TypeArguments="x:String, Argument" />
</ui:ExecuteQuery.Parameters>
</ui:ExecuteQuery>
<Assign sap:VirtualizedContainerService.HintSize="334,60" sap2010:WorkflowViewState.IdRef="Assign_2">
<Assign.To>
<OutArgument x:TypeArguments="sd:DataTable">[dt_TransactionList]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="sd:DataTable">[dt_TransactionList.AsEnumerable.Where(Function(row) not DB_Tablo.AsEnumerable.Where(Function(db) Convert.ToString(db.Field(Of Object)("TTBY_ID")).Contains(Convert.ToString(row.Field(Of Object)("TTBY_ID")))).ToArray.Count>0).CopyToDataTable()]</InArgument>
</Assign.Value>
</Assign>
<ui:DatabaseDisconnect DatabaseConnection="[DBConnection]" DisplayName="Disconnect" sap:VirtualizedContainerService.HintSize="334,22" sap2010:WorkflowViewState.IdRef="DatabaseDisconnect_1" />
</Sequence>
</Activity>