-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathAyuboDrive_TaxiDBDataSet11.xsd
315 lines (315 loc) · 66.4 KB
/
AyuboDrive_TaxiDBDataSet11.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
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
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="AyuboDrive_TaxiDBDataSet11" targetNamespace="http://tempuri.org/AyuboDrive_TaxiDBDataSet11.xsd" xmlns:mstns="http://tempuri.org/AyuboDrive_TaxiDBDataSet11.xsd" xmlns="http://tempuri.org/AyuboDrive_TaxiDBDataSet11.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="AyuboDrive_TaxiDBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="AyuboDrive_TaxiDBConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Ayubo_Drive.Properties.Settings.GlobalReference.Default.AyuboDrive_TaxiDBConnectionString" Provider="System.Data.SqlClient" />
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RentTableAdapter" GeneratorDataComponentClassName="RentTableAdapter" Name="Rent" UserDataComponentName="RentTableAdapter">
<MainSource>
<DbSource ConnectionRef="AyuboDrive_TaxiDBConnectionString (Settings)" DbObjectName="AyuboDrive_TaxiDB.dbo.Rent" 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].[Rent] WHERE (([Rent_ID] = @Original_Rent_ID) AND ((@IsNull_Customer_ID = 1 AND [Customer_ID] IS NULL) OR ([Customer_ID] = @Original_Customer_ID)) AND ((@IsNull_First_Name = 1 AND [First_Name] IS NULL) OR ([First_Name] = @Original_First_Name)) AND ((@IsNull_Identity_No = 1 AND [Identity_No] IS NULL) OR ([Identity_No] = @Original_Identity_No)) AND ((@IsNull_Phone_No = 1 AND [Phone_No] IS NULL) OR ([Phone_No] = @Original_Phone_No)) AND ((@IsNull_Gender = 1 AND [Gender] IS NULL) OR ([Gender] = @Original_Gender)) AND ((@IsNull_Driver_ID = 1 AND [Driver_ID] IS NULL) OR ([Driver_ID] = @Original_Driver_ID)) AND ((@IsNull_D_First_Name = 1 AND [D_First_Name] IS NULL) OR ([D_First_Name] = @Original_D_First_Name)) AND ((@IsNull_License_No = 1 AND [License_No] IS NULL) OR ([License_No] = @Original_License_No)) AND ((@IsNull_Vehicle_ID = 1 AND [Vehicle_ID] IS NULL) OR ([Vehicle_ID] = @Original_Vehicle_ID)) AND ((@IsNull_Vehicle_No = 1 AND [Vehicle_No] IS NULL) OR ([Vehicle_No] = @Original_Vehicle_No)) AND ((@IsNull_Vehicle_Type = 1 AND [Vehicle_Type] IS NULL) OR ([Vehicle_Type] = @Original_Vehicle_Type)) AND ((@IsNull_Rent_Start_Date_W = 1 AND [Rent_Start_Date_W] IS NULL) OR ([Rent_Start_Date_W] = @Original_Rent_Start_Date_W)) AND ((@IsNull_Rent_End_Date_W = 1 AND [Rent_End_Date_W] IS NULL) OR ([Rent_End_Date_W] = @Original_Rent_End_Date_W)) AND ((@IsNull_No_Of_Days_W = 1 AND [No_Of_Days_W] IS NULL) OR ([No_Of_Days_W] = @Original_No_Of_Days_W)) AND ((@IsNull_Driver_Payment = 1 AND [Driver_Payment] IS NULL) OR ([Driver_Payment] = @Original_Driver_Payment)) AND ((@IsNull_Rent_Start_Date_W_O = 1 AND [Rent_Start_Date_W_O] IS NULL) OR ([Rent_Start_Date_W_O] = @Original_Rent_Start_Date_W_O)) AND ((@IsNull_Rent_End_Date_W_O = 1 AND [Rent_End_Date_W_O] IS NULL) OR ([Rent_End_Date_W_O] = @Original_Rent_End_Date_W_O)) AND ((@IsNull_No_Of_Days = 1 AND [No_Of_Days] IS NULL) OR ([No_Of_Days] = @Original_No_Of_Days)) AND ((@IsNull_No_Of_Week = 1 AND [No_Of_Week] IS NULL) OR ([No_Of_Week] = @Original_No_Of_Week)) AND ((@IsNull_No_Of_Month = 1 AND [No_Of_Month] IS NULL) OR ([No_Of_Month] = @Original_No_Of_Month)) AND ((@IsNull_Per_day = 1 AND [Per_day] IS NULL) OR ([Per_day] = @Original_Per_day)) AND ((@IsNull_Per_Week = 1 AND [Per_Week] IS NULL) OR ([Per_Week] = @Original_Per_Week)) AND ((@IsNull_Per_Month = 1 AND [Per_Month] IS NULL) OR ([Per_Month] = @Original_Per_Month)) AND ((@IsNull_Total_Payment = 1 AND [Total_Payment] IS NULL) OR ([Total_Payment] = @Original_Total_Payment)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Rent_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rent_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Customer_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Customer_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Customer_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Customer_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_First_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="First_Name" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_First_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="First_Name" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Identity_No" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Identity_No" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Identity_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Identity_No" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone_No" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone_No" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Phone_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone_No" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gender" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Gender" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Driver_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Driver_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Driver_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Driver_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_D_First_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="D_First_Name" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_D_First_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="D_First_Name" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_License_No" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="License_No" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_License_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="License_No" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Vehicle_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Vehicle_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Vehicle_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Vehicle_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Vehicle_No" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Vehicle_No" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Vehicle_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Vehicle_No" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Vehicle_Type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Vehicle_Type" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Vehicle_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Vehicle_Type" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rent_Start_Date_W" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rent_Start_Date_W" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Rent_Start_Date_W" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_Start_Date_W" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rent_End_Date_W" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rent_End_Date_W" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Rent_End_Date_W" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_End_Date_W" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_No_Of_Days_W" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Days_W" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_No_Of_Days_W" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Days_W" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Driver_Payment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Driver_Payment" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Driver_Payment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Driver_Payment" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rent_Start_Date_W_O" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rent_Start_Date_W_O" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Rent_Start_Date_W_O" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_Start_Date_W_O" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rent_End_Date_W_O" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rent_End_Date_W_O" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Rent_End_Date_W_O" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_End_Date_W_O" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_No_Of_Days" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Days" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_No_Of_Days" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Days" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_No_Of_Week" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Week" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_No_Of_Week" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Week" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_No_Of_Month" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Month" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_No_Of_Month" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Month" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Per_day" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_day" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Per_day" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_day" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Per_Week" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_Week" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Per_Week" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_Week" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Per_Month" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_Month" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Per_Month" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_Month" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Total_Payment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Total_Payment" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Total_Payment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Total_Payment" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[Rent] ([Rent_ID], [Customer_ID], [First_Name], [Identity_No], [Phone_No], [Gender], [Driver_ID], [D_First_Name], [License_No], [Vehicle_ID], [Vehicle_No], [Vehicle_Type], [Rent_Start_Date_W], [Rent_End_Date_W], [No_Of_Days_W], [Driver_Payment], [Rent_Start_Date_W_O], [Rent_End_Date_W_O], [No_Of_Days], [No_Of_Week], [No_Of_Month], [Per_day], [Per_Week], [Per_Month], [Total_Payment]) VALUES (@Rent_ID, @Customer_ID, @First_Name, @Identity_No, @Phone_No, @Gender, @Driver_ID, @D_First_Name, @License_No, @Vehicle_ID, @Vehicle_No, @Vehicle_Type, @Rent_Start_Date_W, @Rent_End_Date_W, @No_Of_Days_W, @Driver_Payment, @Rent_Start_Date_W_O, @Rent_End_Date_W_O, @No_Of_Days, @No_Of_Week, @No_Of_Month, @Per_day, @Per_Week, @Per_Month, @Total_Payment);
SELECT Rent_ID, Customer_ID, First_Name, Identity_No, Phone_No, Gender, Driver_ID, D_First_Name, License_No, Vehicle_ID, Vehicle_No, Vehicle_Type, Rent_Start_Date_W, Rent_End_Date_W, No_Of_Days_W, Driver_Payment, Rent_Start_Date_W_O, Rent_End_Date_W_O, No_Of_Days, No_Of_Week, No_Of_Month, Per_day, Per_Week, Per_Month, Total_Payment FROM Rent WHERE (Rent_ID = @Rent_ID)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Rent_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rent_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Customer_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Customer_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@First_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="First_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Identity_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Identity_No" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Phone_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone_No" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Gender" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Driver_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Driver_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@D_First_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="D_First_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@License_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="License_No" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Vehicle_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Vehicle_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Vehicle_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Vehicle_No" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Vehicle_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Vehicle_Type" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Rent_Start_Date_W" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_Start_Date_W" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Rent_End_Date_W" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_End_Date_W" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@No_Of_Days_W" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Days_W" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Driver_Payment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Driver_Payment" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Rent_Start_Date_W_O" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_Start_Date_W_O" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Rent_End_Date_W_O" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_End_Date_W_O" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@No_Of_Days" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Days" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@No_Of_Week" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Week" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@No_Of_Month" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Month" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Per_day" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_day" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Per_Week" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_Week" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Per_Month" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_Month" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Total_Payment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Total_Payment" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT Rent_ID, Customer_ID, First_Name, Identity_No, Phone_No, Gender, Driver_ID, D_First_Name, License_No, Vehicle_ID, Vehicle_No, Vehicle_Type, Rent_Start_Date_W, Rent_End_Date_W, No_Of_Days_W, Driver_Payment, Rent_Start_Date_W_O, Rent_End_Date_W_O, No_Of_Days, No_Of_Week, No_Of_Month, Per_day, Per_Week, Per_Month, Total_Payment FROM dbo.Rent</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[Rent] SET [Rent_ID] = @Rent_ID, [Customer_ID] = @Customer_ID, [First_Name] = @First_Name, [Identity_No] = @Identity_No, [Phone_No] = @Phone_No, [Gender] = @Gender, [Driver_ID] = @Driver_ID, [D_First_Name] = @D_First_Name, [License_No] = @License_No, [Vehicle_ID] = @Vehicle_ID, [Vehicle_No] = @Vehicle_No, [Vehicle_Type] = @Vehicle_Type, [Rent_Start_Date_W] = @Rent_Start_Date_W, [Rent_End_Date_W] = @Rent_End_Date_W, [No_Of_Days_W] = @No_Of_Days_W, [Driver_Payment] = @Driver_Payment, [Rent_Start_Date_W_O] = @Rent_Start_Date_W_O, [Rent_End_Date_W_O] = @Rent_End_Date_W_O, [No_Of_Days] = @No_Of_Days, [No_Of_Week] = @No_Of_Week, [No_Of_Month] = @No_Of_Month, [Per_day] = @Per_day, [Per_Week] = @Per_Week, [Per_Month] = @Per_Month, [Total_Payment] = @Total_Payment WHERE (([Rent_ID] = @Original_Rent_ID) AND ((@IsNull_Customer_ID = 1 AND [Customer_ID] IS NULL) OR ([Customer_ID] = @Original_Customer_ID)) AND ((@IsNull_First_Name = 1 AND [First_Name] IS NULL) OR ([First_Name] = @Original_First_Name)) AND ((@IsNull_Identity_No = 1 AND [Identity_No] IS NULL) OR ([Identity_No] = @Original_Identity_No)) AND ((@IsNull_Phone_No = 1 AND [Phone_No] IS NULL) OR ([Phone_No] = @Original_Phone_No)) AND ((@IsNull_Gender = 1 AND [Gender] IS NULL) OR ([Gender] = @Original_Gender)) AND ((@IsNull_Driver_ID = 1 AND [Driver_ID] IS NULL) OR ([Driver_ID] = @Original_Driver_ID)) AND ((@IsNull_D_First_Name = 1 AND [D_First_Name] IS NULL) OR ([D_First_Name] = @Original_D_First_Name)) AND ((@IsNull_License_No = 1 AND [License_No] IS NULL) OR ([License_No] = @Original_License_No)) AND ((@IsNull_Vehicle_ID = 1 AND [Vehicle_ID] IS NULL) OR ([Vehicle_ID] = @Original_Vehicle_ID)) AND ((@IsNull_Vehicle_No = 1 AND [Vehicle_No] IS NULL) OR ([Vehicle_No] = @Original_Vehicle_No)) AND ((@IsNull_Vehicle_Type = 1 AND [Vehicle_Type] IS NULL) OR ([Vehicle_Type] = @Original_Vehicle_Type)) AND ((@IsNull_Rent_Start_Date_W = 1 AND [Rent_Start_Date_W] IS NULL) OR ([Rent_Start_Date_W] = @Original_Rent_Start_Date_W)) AND ((@IsNull_Rent_End_Date_W = 1 AND [Rent_End_Date_W] IS NULL) OR ([Rent_End_Date_W] = @Original_Rent_End_Date_W)) AND ((@IsNull_No_Of_Days_W = 1 AND [No_Of_Days_W] IS NULL) OR ([No_Of_Days_W] = @Original_No_Of_Days_W)) AND ((@IsNull_Driver_Payment = 1 AND [Driver_Payment] IS NULL) OR ([Driver_Payment] = @Original_Driver_Payment)) AND ((@IsNull_Rent_Start_Date_W_O = 1 AND [Rent_Start_Date_W_O] IS NULL) OR ([Rent_Start_Date_W_O] = @Original_Rent_Start_Date_W_O)) AND ((@IsNull_Rent_End_Date_W_O = 1 AND [Rent_End_Date_W_O] IS NULL) OR ([Rent_End_Date_W_O] = @Original_Rent_End_Date_W_O)) AND ((@IsNull_No_Of_Days = 1 AND [No_Of_Days] IS NULL) OR ([No_Of_Days] = @Original_No_Of_Days)) AND ((@IsNull_No_Of_Week = 1 AND [No_Of_Week] IS NULL) OR ([No_Of_Week] = @Original_No_Of_Week)) AND ((@IsNull_No_Of_Month = 1 AND [No_Of_Month] IS NULL) OR ([No_Of_Month] = @Original_No_Of_Month)) AND ((@IsNull_Per_day = 1 AND [Per_day] IS NULL) OR ([Per_day] = @Original_Per_day)) AND ((@IsNull_Per_Week = 1 AND [Per_Week] IS NULL) OR ([Per_Week] = @Original_Per_Week)) AND ((@IsNull_Per_Month = 1 AND [Per_Month] IS NULL) OR ([Per_Month] = @Original_Per_Month)) AND ((@IsNull_Total_Payment = 1 AND [Total_Payment] IS NULL) OR ([Total_Payment] = @Original_Total_Payment)));
SELECT Rent_ID, Customer_ID, First_Name, Identity_No, Phone_No, Gender, Driver_ID, D_First_Name, License_No, Vehicle_ID, Vehicle_No, Vehicle_Type, Rent_Start_Date_W, Rent_End_Date_W, No_Of_Days_W, Driver_Payment, Rent_Start_Date_W_O, Rent_End_Date_W_O, No_Of_Days, No_Of_Week, No_Of_Month, Per_day, Per_Week, Per_Month, Total_Payment FROM Rent WHERE (Rent_ID = @Rent_ID)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Rent_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rent_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Customer_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Customer_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@First_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="First_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Identity_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Identity_No" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Phone_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone_No" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Gender" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Driver_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Driver_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@D_First_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="D_First_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@License_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="License_No" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Vehicle_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Vehicle_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Vehicle_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Vehicle_No" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Vehicle_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Vehicle_Type" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Rent_Start_Date_W" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_Start_Date_W" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Rent_End_Date_W" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_End_Date_W" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@No_Of_Days_W" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Days_W" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Driver_Payment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Driver_Payment" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Rent_Start_Date_W_O" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_Start_Date_W_O" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Rent_End_Date_W_O" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_End_Date_W_O" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@No_Of_Days" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Days" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@No_Of_Week" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Week" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@No_Of_Month" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Month" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Per_day" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_day" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Per_Week" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_Week" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Per_Month" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_Month" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Total_Payment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Total_Payment" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Rent_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rent_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Customer_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Customer_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Customer_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Customer_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_First_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="First_Name" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_First_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="First_Name" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Identity_No" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Identity_No" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Identity_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Identity_No" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone_No" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone_No" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Phone_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Phone_No" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gender" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Gender" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Driver_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Driver_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Driver_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Driver_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_D_First_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="D_First_Name" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_D_First_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="D_First_Name" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_License_No" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="License_No" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_License_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="License_No" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Vehicle_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Vehicle_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Vehicle_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Vehicle_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Vehicle_No" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Vehicle_No" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Vehicle_No" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Vehicle_No" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Vehicle_Type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Vehicle_Type" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Vehicle_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Vehicle_Type" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rent_Start_Date_W" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rent_Start_Date_W" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Rent_Start_Date_W" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_Start_Date_W" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rent_End_Date_W" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rent_End_Date_W" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Rent_End_Date_W" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_End_Date_W" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_No_Of_Days_W" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Days_W" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_No_Of_Days_W" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Days_W" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Driver_Payment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Driver_Payment" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Driver_Payment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Driver_Payment" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rent_Start_Date_W_O" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rent_Start_Date_W_O" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Rent_Start_Date_W_O" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_Start_Date_W_O" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rent_End_Date_W_O" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rent_End_Date_W_O" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Rent_End_Date_W_O" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Rent_End_Date_W_O" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_No_Of_Days" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Days" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_No_Of_Days" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Days" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_No_Of_Week" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Week" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_No_Of_Week" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Week" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_No_Of_Month" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Month" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_No_Of_Month" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="No_Of_Month" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Per_day" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_day" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Per_day" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_day" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Per_Week" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_Week" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Per_Week" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_Week" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Per_Month" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_Month" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Per_Month" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Per_Month" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Total_Payment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Total_Payment" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Total_Payment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Total_Payment" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="Rent_ID" DataSetColumn="Rent_ID" />
<Mapping SourceColumn="Customer_ID" DataSetColumn="Customer_ID" />
<Mapping SourceColumn="First_Name" DataSetColumn="First_Name" />
<Mapping SourceColumn="Identity_No" DataSetColumn="Identity_No" />
<Mapping SourceColumn="Phone_No" DataSetColumn="Phone_No" />
<Mapping SourceColumn="Gender" DataSetColumn="Gender" />
<Mapping SourceColumn="Driver_ID" DataSetColumn="Driver_ID" />
<Mapping SourceColumn="D_First_Name" DataSetColumn="D_First_Name" />
<Mapping SourceColumn="License_No" DataSetColumn="License_No" />
<Mapping SourceColumn="Vehicle_ID" DataSetColumn="Vehicle_ID" />
<Mapping SourceColumn="Vehicle_No" DataSetColumn="Vehicle_No" />
<Mapping SourceColumn="Vehicle_Type" DataSetColumn="Vehicle_Type" />
<Mapping SourceColumn="Rent_Start_Date_W" DataSetColumn="Rent_Start_Date_W" />
<Mapping SourceColumn="Rent_End_Date_W" DataSetColumn="Rent_End_Date_W" />
<Mapping SourceColumn="No_Of_Days_W" DataSetColumn="No_Of_Days_W" />
<Mapping SourceColumn="Driver_Payment" DataSetColumn="Driver_Payment" />
<Mapping SourceColumn="Rent_Start_Date_W_O" DataSetColumn="Rent_Start_Date_W_O" />
<Mapping SourceColumn="Rent_End_Date_W_O" DataSetColumn="Rent_End_Date_W_O" />
<Mapping SourceColumn="No_Of_Days" DataSetColumn="No_Of_Days" />
<Mapping SourceColumn="No_Of_Week" DataSetColumn="No_Of_Week" />
<Mapping SourceColumn="No_Of_Month" DataSetColumn="No_Of_Month" />
<Mapping SourceColumn="Per_day" DataSetColumn="Per_day" />
<Mapping SourceColumn="Per_Week" DataSetColumn="Per_Week" />
<Mapping SourceColumn="Per_Month" DataSetColumn="Per_Month" />
<Mapping SourceColumn="Total_Payment" DataSetColumn="Total_Payment" />
</Mappings>
<Sources />
</TableAdapter>
</Tables>
<Sources />
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="AyuboDrive_TaxiDBDataSet11" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="AyuboDrive_TaxiDBDataSet11" msprop:Generator_UserDSName="AyuboDrive_TaxiDBDataSet11">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Rent" msprop:Generator_TableClassName="RentDataTable" msprop:Generator_TableVarName="tableRent" msprop:Generator_TablePropName="Rent" msprop:Generator_RowDeletingName="RentRowDeleting" msprop:Generator_RowChangingName="RentRowChanging" msprop:Generator_RowEvHandlerName="RentRowChangeEventHandler" msprop:Generator_RowDeletedName="RentRowDeleted" msprop:Generator_UserTableName="Rent" msprop:Generator_RowChangedName="RentRowChanged" msprop:Generator_RowEvArgName="RentRowChangeEvent" msprop:Generator_RowClassName="RentRow">
<xs:complexType>
<xs:sequence>
<xs:element name="Rent_ID" msprop:Generator_ColumnVarNameInTable="columnRent_ID" msprop:Generator_ColumnPropNameInRow="Rent_ID" msprop:Generator_ColumnPropNameInTable="Rent_IDColumn" msprop:Generator_UserColumnName="Rent_ID" type="xs:int" />
<xs:element name="Customer_ID" msprop:Generator_ColumnVarNameInTable="columnCustomer_ID" msprop:Generator_ColumnPropNameInRow="Customer_ID" msprop:Generator_ColumnPropNameInTable="Customer_IDColumn" msprop:Generator_UserColumnName="Customer_ID" type="xs:int" minOccurs="0" />
<xs:element name="First_Name" msprop:Generator_ColumnVarNameInTable="columnFirst_Name" msprop:Generator_ColumnPropNameInRow="First_Name" msprop:Generator_ColumnPropNameInTable="First_NameColumn" msprop:Generator_UserColumnName="First_Name" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="30" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Identity_No" msprop:Generator_ColumnVarNameInTable="columnIdentity_No" msprop:Generator_ColumnPropNameInRow="Identity_No" msprop:Generator_ColumnPropNameInTable="Identity_NoColumn" msprop:Generator_UserColumnName="Identity_No" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="15" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Phone_No" msprop:Generator_ColumnVarNameInTable="columnPhone_No" msprop:Generator_ColumnPropNameInRow="Phone_No" msprop:Generator_ColumnPropNameInTable="Phone_NoColumn" msprop:Generator_UserColumnName="Phone_No" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="15" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Gender" msprop:Generator_ColumnVarNameInTable="columnGender" msprop:Generator_ColumnPropNameInRow="Gender" msprop:Generator_ColumnPropNameInTable="GenderColumn" msprop:Generator_UserColumnName="Gender" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Driver_ID" msprop:Generator_ColumnVarNameInTable="columnDriver_ID" msprop:Generator_ColumnPropNameInRow="Driver_ID" msprop:Generator_ColumnPropNameInTable="Driver_IDColumn" msprop:Generator_UserColumnName="Driver_ID" type="xs:int" minOccurs="0" />
<xs:element name="D_First_Name" msprop:Generator_ColumnVarNameInTable="columnD_First_Name" msprop:Generator_ColumnPropNameInRow="D_First_Name" msprop:Generator_ColumnPropNameInTable="D_First_NameColumn" msprop:Generator_UserColumnName="D_First_Name" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="30" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="License_No" msprop:Generator_ColumnVarNameInTable="columnLicense_No" msprop:Generator_ColumnPropNameInRow="License_No" msprop:Generator_ColumnPropNameInTable="License_NoColumn" msprop:Generator_UserColumnName="License_No" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="15" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Vehicle_ID" msprop:Generator_ColumnVarNameInTable="columnVehicle_ID" msprop:Generator_ColumnPropNameInRow="Vehicle_ID" msprop:Generator_ColumnPropNameInTable="Vehicle_IDColumn" msprop:Generator_UserColumnName="Vehicle_ID" type="xs:int" minOccurs="0" />
<xs:element name="Vehicle_No" msprop:Generator_ColumnVarNameInTable="columnVehicle_No" msprop:Generator_ColumnPropNameInRow="Vehicle_No" msprop:Generator_ColumnPropNameInTable="Vehicle_NoColumn" msprop:Generator_UserColumnName="Vehicle_No" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="15" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Vehicle_Type" msprop:Generator_ColumnVarNameInTable="columnVehicle_Type" msprop:Generator_ColumnPropNameInRow="Vehicle_Type" msprop:Generator_ColumnPropNameInTable="Vehicle_TypeColumn" msprop:Generator_UserColumnName="Vehicle_Type" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="15" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Rent_Start_Date_W" msprop:Generator_ColumnVarNameInTable="columnRent_Start_Date_W" msprop:Generator_ColumnPropNameInRow="Rent_Start_Date_W" msprop:Generator_ColumnPropNameInTable="Rent_Start_Date_WColumn" msprop:Generator_UserColumnName="Rent_Start_Date_W" type="xs:dateTime" minOccurs="0" />
<xs:element name="Rent_End_Date_W" msprop:Generator_ColumnVarNameInTable="columnRent_End_Date_W" msprop:Generator_ColumnPropNameInRow="Rent_End_Date_W" msprop:Generator_ColumnPropNameInTable="Rent_End_Date_WColumn" msprop:Generator_UserColumnName="Rent_End_Date_W" type="xs:dateTime" minOccurs="0" />
<xs:element name="No_Of_Days_W" msprop:Generator_ColumnVarNameInTable="columnNo_Of_Days_W" msprop:Generator_ColumnPropNameInRow="No_Of_Days_W" msprop:Generator_ColumnPropNameInTable="No_Of_Days_WColumn" msprop:Generator_UserColumnName="No_Of_Days_W" type="xs:int" minOccurs="0" />
<xs:element name="Driver_Payment" msprop:Generator_ColumnVarNameInTable="columnDriver_Payment" msprop:Generator_ColumnPropNameInRow="Driver_Payment" msprop:Generator_ColumnPropNameInTable="Driver_PaymentColumn" msprop:Generator_UserColumnName="Driver_Payment" type="xs:int" minOccurs="0" />
<xs:element name="Rent_Start_Date_W_O" msprop:Generator_ColumnVarNameInTable="columnRent_Start_Date_W_O" msprop:Generator_ColumnPropNameInRow="Rent_Start_Date_W_O" msprop:Generator_ColumnPropNameInTable="Rent_Start_Date_W_OColumn" msprop:Generator_UserColumnName="Rent_Start_Date_W_O" type="xs:dateTime" minOccurs="0" />
<xs:element name="Rent_End_Date_W_O" msprop:Generator_ColumnVarNameInTable="columnRent_End_Date_W_O" msprop:Generator_ColumnPropNameInRow="Rent_End_Date_W_O" msprop:Generator_ColumnPropNameInTable="Rent_End_Date_W_OColumn" msprop:Generator_UserColumnName="Rent_End_Date_W_O" type="xs:dateTime" minOccurs="0" />
<xs:element name="No_Of_Days" msprop:Generator_ColumnVarNameInTable="columnNo_Of_Days" msprop:Generator_ColumnPropNameInRow="No_Of_Days" msprop:Generator_ColumnPropNameInTable="No_Of_DaysColumn" msprop:Generator_UserColumnName="No_Of_Days" type="xs:int" minOccurs="0" />
<xs:element name="No_Of_Week" msprop:Generator_ColumnVarNameInTable="columnNo_Of_Week" msprop:Generator_ColumnPropNameInRow="No_Of_Week" msprop:Generator_ColumnPropNameInTable="No_Of_WeekColumn" msprop:Generator_UserColumnName="No_Of_Week" type="xs:int" minOccurs="0" />
<xs:element name="No_Of_Month" msprop:Generator_ColumnVarNameInTable="columnNo_Of_Month" msprop:Generator_ColumnPropNameInRow="No_Of_Month" msprop:Generator_ColumnPropNameInTable="No_Of_MonthColumn" msprop:Generator_UserColumnName="No_Of_Month" type="xs:int" minOccurs="0" />
<xs:element name="Per_day" msprop:Generator_ColumnVarNameInTable="columnPer_day" msprop:Generator_ColumnPropNameInRow="Per_day" msprop:Generator_ColumnPropNameInTable="Per_dayColumn" msprop:Generator_UserColumnName="Per_day" type="xs:int" minOccurs="0" />
<xs:element name="Per_Week" msprop:Generator_ColumnVarNameInTable="columnPer_Week" msprop:Generator_ColumnPropNameInRow="Per_Week" msprop:Generator_ColumnPropNameInTable="Per_WeekColumn" msprop:Generator_UserColumnName="Per_Week" type="xs:int" minOccurs="0" />
<xs:element name="Per_Month" msprop:Generator_ColumnVarNameInTable="columnPer_Month" msprop:Generator_ColumnPropNameInRow="Per_Month" msprop:Generator_ColumnPropNameInTable="Per_MonthColumn" msprop:Generator_UserColumnName="Per_Month" type="xs:int" minOccurs="0" />
<xs:element name="Total_Payment" msprop:Generator_ColumnVarNameInTable="columnTotal_Payment" msprop:Generator_ColumnPropNameInRow="Total_Payment" msprop:Generator_ColumnPropNameInTable="Total_PaymentColumn" msprop:Generator_UserColumnName="Total_Payment" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Rent" />
<xs:field xpath="mstns:Rent_ID" />
</xs:unique>
</xs:element>
</xs:schema>