-
Notifications
You must be signed in to change notification settings - Fork 0
/
CovidAirlinesDataSetRoutes.xsd
165 lines (165 loc) · 33.9 KB
/
CovidAirlinesDataSetRoutes.xsd
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
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CovidAirlinesDataSetRoutes" targetNamespace="http://tempuri.org/CovidAirlinesDataSetRoutes.xsd" xmlns:mstns="http://tempuri.org/CovidAirlinesDataSetRoutes.xsd" xmlns="http://tempuri.org/CovidAirlinesDataSetRoutes.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
<xs:annotation>
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
<Connections>
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CovidAirlinesConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CovidAirlinesConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.CovidAirlines.Properties.Settings.GlobalReference.Default.CovidAirlinesConnectionString" Provider="System.Data.SqlClient" />
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RouteTableAdapter" GeneratorDataComponentClassName="RouteTableAdapter" Name="Route" UserDataComponentName="RouteTableAdapter">
<MainSource>
<DbSource ConnectionRef="CovidAirlinesConnectionString (Settings)" DbObjectName="CovidAirlines.dbo.Route" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[Route] WHERE (([RouteID] = @Original_RouteID) AND ([OriginCityID] = @Original_OriginCityID) AND ([DestinationCityID] = @Original_DestinationCityID) AND ([DepartureTime] = @Original_DepartureTime) AND ([ArrivalTime] = @Original_ArrivalTime) AND ((@IsNull_Stop1CityID = 1 AND [Stop1CityID] IS NULL) OR ([Stop1CityID] = @Original_Stop1CityID)) AND ((@IsNull_Stop1ArrivalTime = 1 AND [Stop1ArrivalTime] IS NULL) OR ([Stop1ArrivalTime] = @Original_Stop1ArrivalTime)) AND ((@IsNull_Stop1DepartureTime = 1 AND [Stop1DepartureTime] IS NULL) OR ([Stop1DepartureTime] = @Original_Stop1DepartureTime)) AND ((@IsNull_Stop2CityID = 1 AND [Stop2CityID] IS NULL) OR ([Stop2CityID] = @Original_Stop2CityID)) AND ((@IsNull_Stop2ArrivalTime = 1 AND [Stop2ArrivalTime] IS NULL) OR ([Stop2ArrivalTime] = @Original_Stop2ArrivalTime)) AND ((@IsNull_Stop2DepartureTime = 1 AND [Stop2DepartureTime] IS NULL) OR ([Stop2DepartureTime] = @Original_Stop2DepartureTime)) AND ([AirplaneID] = @Original_AirplaneID) AND ([TicketPrice] = @Original_TicketPrice) AND ([PointsAwarded] = @Original_PointsAwarded))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RouteID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RouteID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OriginCityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OriginCityID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DestinationCityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DestinationCityID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DepartureTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DepartureTime" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ArrivalTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ArrivalTime" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Stop1CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop1CityID" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Stop1CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop1CityID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Stop1ArrivalTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop1ArrivalTime" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Stop1ArrivalTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop1ArrivalTime" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Stop1DepartureTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop1DepartureTime" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Stop1DepartureTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop1DepartureTime" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Stop2CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop2CityID" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Stop2CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop2CityID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Stop2ArrivalTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop2ArrivalTime" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Stop2ArrivalTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop2ArrivalTime" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Stop2DepartureTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop2DepartureTime" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Stop2DepartureTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop2DepartureTime" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AirplaneID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AirplaneID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TicketPrice" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TicketPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PointsAwarded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PointsAwarded" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[Route] ([RouteID], [OriginCityID], [DestinationCityID], [DepartureTime], [ArrivalTime], [Stop1CityID], [Stop1ArrivalTime], [Stop1DepartureTime], [Stop2CityID], [Stop2ArrivalTime], [Stop2DepartureTime], [AirplaneID], [TicketPrice], [PointsAwarded]) VALUES (@RouteID, @OriginCityID, @DestinationCityID, @DepartureTime, @ArrivalTime, @Stop1CityID, @Stop1ArrivalTime, @Stop1DepartureTime, @Stop2CityID, @Stop2ArrivalTime, @Stop2DepartureTime, @AirplaneID, @TicketPrice, @PointsAwarded);
SELECT RouteID, OriginCityID, DestinationCityID, DepartureTime, ArrivalTime, Stop1CityID, Stop1ArrivalTime, Stop1DepartureTime, Stop2CityID, Stop2ArrivalTime, Stop2DepartureTime, AirplaneID, TicketPrice, PointsAwarded FROM Route WHERE (RouteID = @RouteID)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RouteID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RouteID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OriginCityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OriginCityID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DestinationCityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DestinationCityID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DepartureTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DepartureTime" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ArrivalTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ArrivalTime" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Stop1CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop1CityID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Stop1ArrivalTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop1ArrivalTime" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Stop1DepartureTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop1DepartureTime" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Stop2CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop2CityID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Stop2ArrivalTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop2ArrivalTime" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Stop2DepartureTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop2DepartureTime" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AirplaneID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AirplaneID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TicketPrice" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TicketPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PointsAwarded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PointsAwarded" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT RouteID, OriginCityID, DestinationCityID, DepartureTime, ArrivalTime, Stop1CityID, Stop1ArrivalTime, Stop1DepartureTime, Stop2CityID, Stop2ArrivalTime, Stop2DepartureTime, AirplaneID, TicketPrice, PointsAwarded FROM dbo.Route</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[Route] SET [RouteID] = @RouteID, [OriginCityID] = @OriginCityID, [DestinationCityID] = @DestinationCityID, [DepartureTime] = @DepartureTime, [ArrivalTime] = @ArrivalTime, [Stop1CityID] = @Stop1CityID, [Stop1ArrivalTime] = @Stop1ArrivalTime, [Stop1DepartureTime] = @Stop1DepartureTime, [Stop2CityID] = @Stop2CityID, [Stop2ArrivalTime] = @Stop2ArrivalTime, [Stop2DepartureTime] = @Stop2DepartureTime, [AirplaneID] = @AirplaneID, [TicketPrice] = @TicketPrice, [PointsAwarded] = @PointsAwarded WHERE (([RouteID] = @Original_RouteID) AND ([OriginCityID] = @Original_OriginCityID) AND ([DestinationCityID] = @Original_DestinationCityID) AND ([DepartureTime] = @Original_DepartureTime) AND ([ArrivalTime] = @Original_ArrivalTime) AND ((@IsNull_Stop1CityID = 1 AND [Stop1CityID] IS NULL) OR ([Stop1CityID] = @Original_Stop1CityID)) AND ((@IsNull_Stop1ArrivalTime = 1 AND [Stop1ArrivalTime] IS NULL) OR ([Stop1ArrivalTime] = @Original_Stop1ArrivalTime)) AND ((@IsNull_Stop1DepartureTime = 1 AND [Stop1DepartureTime] IS NULL) OR ([Stop1DepartureTime] = @Original_Stop1DepartureTime)) AND ((@IsNull_Stop2CityID = 1 AND [Stop2CityID] IS NULL) OR ([Stop2CityID] = @Original_Stop2CityID)) AND ((@IsNull_Stop2ArrivalTime = 1 AND [Stop2ArrivalTime] IS NULL) OR ([Stop2ArrivalTime] = @Original_Stop2ArrivalTime)) AND ((@IsNull_Stop2DepartureTime = 1 AND [Stop2DepartureTime] IS NULL) OR ([Stop2DepartureTime] = @Original_Stop2DepartureTime)) AND ([AirplaneID] = @Original_AirplaneID) AND ([TicketPrice] = @Original_TicketPrice) AND ([PointsAwarded] = @Original_PointsAwarded));
SELECT RouteID, OriginCityID, DestinationCityID, DepartureTime, ArrivalTime, Stop1CityID, Stop1ArrivalTime, Stop1DepartureTime, Stop2CityID, Stop2ArrivalTime, Stop2DepartureTime, AirplaneID, TicketPrice, PointsAwarded FROM Route WHERE (RouteID = @RouteID)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RouteID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RouteID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OriginCityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OriginCityID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DestinationCityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DestinationCityID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DepartureTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DepartureTime" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ArrivalTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ArrivalTime" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Stop1CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop1CityID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Stop1ArrivalTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop1ArrivalTime" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Stop1DepartureTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop1DepartureTime" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Stop2CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop2CityID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Stop2ArrivalTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop2ArrivalTime" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Stop2DepartureTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop2DepartureTime" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AirplaneID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AirplaneID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TicketPrice" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TicketPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PointsAwarded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PointsAwarded" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RouteID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RouteID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OriginCityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OriginCityID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DestinationCityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DestinationCityID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DepartureTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DepartureTime" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ArrivalTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ArrivalTime" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Stop1CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop1CityID" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Stop1CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop1CityID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Stop1ArrivalTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop1ArrivalTime" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Stop1ArrivalTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop1ArrivalTime" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Stop1DepartureTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop1DepartureTime" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Stop1DepartureTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop1DepartureTime" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Stop2CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop2CityID" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Stop2CityID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop2CityID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Stop2ArrivalTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop2ArrivalTime" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Stop2ArrivalTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop2ArrivalTime" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Stop2DepartureTime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Stop2DepartureTime" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Stop2DepartureTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Stop2DepartureTime" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AirplaneID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AirplaneID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TicketPrice" Precision="4" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TicketPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PointsAwarded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PointsAwarded" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="RouteID" DataSetColumn="RouteID" />
<Mapping SourceColumn="OriginCityID" DataSetColumn="OriginCityID" />
<Mapping SourceColumn="DestinationCityID" DataSetColumn="DestinationCityID" />
<Mapping SourceColumn="DepartureTime" DataSetColumn="DepartureTime" />
<Mapping SourceColumn="ArrivalTime" DataSetColumn="ArrivalTime" />
<Mapping SourceColumn="Stop1CityID" DataSetColumn="Stop1CityID" />
<Mapping SourceColumn="Stop1ArrivalTime" DataSetColumn="Stop1ArrivalTime" />
<Mapping SourceColumn="Stop1DepartureTime" DataSetColumn="Stop1DepartureTime" />
<Mapping SourceColumn="Stop2CityID" DataSetColumn="Stop2CityID" />
<Mapping SourceColumn="Stop2ArrivalTime" DataSetColumn="Stop2ArrivalTime" />
<Mapping SourceColumn="Stop2DepartureTime" DataSetColumn="Stop2DepartureTime" />
<Mapping SourceColumn="AirplaneID" DataSetColumn="AirplaneID" />
<Mapping SourceColumn="TicketPrice" DataSetColumn="TicketPrice" />
<Mapping SourceColumn="PointsAwarded" DataSetColumn="PointsAwarded" />
</Mappings>
<Sources />
</TableAdapter>
</Tables>
<Sources />
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="CovidAirlinesDataSetRoutes" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="CovidAirlinesDataSetRoutes" msprop:Generator_UserDSName="CovidAirlinesDataSetRoutes">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Route" msprop:Generator_TableClassName="RouteDataTable" msprop:Generator_TableVarName="tableRoute" msprop:Generator_TablePropName="Route" msprop:Generator_RowDeletingName="RouteRowDeleting" msprop:Generator_RowChangingName="RouteRowChanging" msprop:Generator_RowEvHandlerName="RouteRowChangeEventHandler" msprop:Generator_RowDeletedName="RouteRowDeleted" msprop:Generator_UserTableName="Route" msprop:Generator_RowChangedName="RouteRowChanged" msprop:Generator_RowEvArgName="RouteRowChangeEvent" msprop:Generator_RowClassName="RouteRow">
<xs:complexType>
<xs:sequence>
<xs:element name="RouteID" msprop:Generator_ColumnVarNameInTable="columnRouteID" msprop:Generator_ColumnPropNameInRow="RouteID" msprop:Generator_ColumnPropNameInTable="RouteIDColumn" msprop:Generator_UserColumnName="RouteID" type="xs:int" />
<xs:element name="OriginCityID" msprop:Generator_ColumnVarNameInTable="columnOriginCityID" msprop:Generator_ColumnPropNameInRow="OriginCityID" msprop:Generator_ColumnPropNameInTable="OriginCityIDColumn" msprop:Generator_UserColumnName="OriginCityID" type="xs:int" />
<xs:element name="DestinationCityID" msprop:Generator_ColumnVarNameInTable="columnDestinationCityID" msprop:Generator_ColumnPropNameInRow="DestinationCityID" msprop:Generator_ColumnPropNameInTable="DestinationCityIDColumn" msprop:Generator_UserColumnName="DestinationCityID" type="xs:int" />
<xs:element name="DepartureTime" msprop:Generator_ColumnVarNameInTable="columnDepartureTime" msprop:Generator_ColumnPropNameInRow="DepartureTime" msprop:Generator_ColumnPropNameInTable="DepartureTimeColumn" msprop:Generator_UserColumnName="DepartureTime" type="xs:dateTime" />
<xs:element name="ArrivalTime" msprop:Generator_ColumnVarNameInTable="columnArrivalTime" msprop:Generator_ColumnPropNameInRow="ArrivalTime" msprop:Generator_ColumnPropNameInTable="ArrivalTimeColumn" msprop:Generator_UserColumnName="ArrivalTime" type="xs:dateTime" />
<xs:element name="Stop1CityID" msprop:Generator_ColumnVarNameInTable="columnStop1CityID" msprop:Generator_ColumnPropNameInRow="Stop1CityID" msprop:Generator_ColumnPropNameInTable="Stop1CityIDColumn" msprop:Generator_UserColumnName="Stop1CityID" type="xs:int" minOccurs="0" />
<xs:element name="Stop1ArrivalTime" msprop:Generator_ColumnVarNameInTable="columnStop1ArrivalTime" msprop:Generator_ColumnPropNameInRow="Stop1ArrivalTime" msprop:Generator_ColumnPropNameInTable="Stop1ArrivalTimeColumn" msprop:Generator_UserColumnName="Stop1ArrivalTime" type="xs:dateTime" minOccurs="0" />
<xs:element name="Stop1DepartureTime" msprop:Generator_ColumnVarNameInTable="columnStop1DepartureTime" msprop:Generator_ColumnPropNameInRow="Stop1DepartureTime" msprop:Generator_ColumnPropNameInTable="Stop1DepartureTimeColumn" msprop:Generator_UserColumnName="Stop1DepartureTime" type="xs:dateTime" minOccurs="0" />
<xs:element name="Stop2CityID" msprop:Generator_ColumnVarNameInTable="columnStop2CityID" msprop:Generator_ColumnPropNameInRow="Stop2CityID" msprop:Generator_ColumnPropNameInTable="Stop2CityIDColumn" msprop:Generator_UserColumnName="Stop2CityID" type="xs:int" minOccurs="0" />
<xs:element name="Stop2ArrivalTime" msprop:Generator_ColumnVarNameInTable="columnStop2ArrivalTime" msprop:Generator_ColumnPropNameInRow="Stop2ArrivalTime" msprop:Generator_ColumnPropNameInTable="Stop2ArrivalTimeColumn" msprop:Generator_UserColumnName="Stop2ArrivalTime" type="xs:dateTime" minOccurs="0" />
<xs:element name="Stop2DepartureTime" msprop:Generator_ColumnVarNameInTable="columnStop2DepartureTime" msprop:Generator_ColumnPropNameInRow="Stop2DepartureTime" msprop:Generator_ColumnPropNameInTable="Stop2DepartureTimeColumn" msprop:Generator_UserColumnName="Stop2DepartureTime" type="xs:dateTime" minOccurs="0" />
<xs:element name="AirplaneID" msprop:Generator_ColumnVarNameInTable="columnAirplaneID" msprop:Generator_ColumnPropNameInRow="AirplaneID" msprop:Generator_ColumnPropNameInTable="AirplaneIDColumn" msprop:Generator_UserColumnName="AirplaneID" type="xs:int" />
<xs:element name="TicketPrice" msprop:Generator_ColumnVarNameInTable="columnTicketPrice" msprop:Generator_ColumnPropNameInRow="TicketPrice" msprop:Generator_ColumnPropNameInTable="TicketPriceColumn" msprop:Generator_UserColumnName="TicketPrice" type="xs:decimal" />
<xs:element name="PointsAwarded" msprop:Generator_ColumnVarNameInTable="columnPointsAwarded" msprop:Generator_ColumnPropNameInRow="PointsAwarded" msprop:Generator_ColumnPropNameInTable="PointsAwardedColumn" msprop:Generator_UserColumnName="PointsAwarded" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Route" />
<xs:field xpath="mstns:RouteID" />
</xs:unique>
</xs:element>
</xs:schema>