-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathFeePayment_DBDataSet.xsd
More file actions
321 lines (321 loc) · 60.5 KB
/
FeePayment_DBDataSet.xsd
File metadata and controls
321 lines (321 loc) · 60.5 KB
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
316
317
318
319
320
321
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="FeePayment_DBDataSet" targetNamespace="http://tempuri.org/FeePayment_DBDataSet.xsd" xmlns:mstns="http://tempuri.org/FeePayment_DBDataSet.xsd" xmlns="http://tempuri.org/FeePayment_DBDataSet.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="CMS_DBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CMS_DBConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.College_Management_System.Properties.Settings.GlobalReference.Default.CMS_DBConnectionString" Provider="System.Data.SqlClient" />
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FeePaymentTableAdapter" GeneratorDataComponentClassName="FeePaymentTableAdapter" Name="FeePayment" UserDataComponentName="FeePaymentTableAdapter">
<MainSource>
<DbSource ConnectionRef="CMS_DBConnectionString (Settings)" DbObjectName="dbo.FeePayment" 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].[FeePayment] WHERE (([FeePaymentID] = @Original_FeePaymentID) AND ((@IsNull_ScholarNo = 1 AND [ScholarNo] IS NULL) OR ([ScholarNo] = @Original_ScholarNo)) AND ((@IsNull_StudentName = 1 AND [StudentName] IS NULL) OR ([StudentName] = @Original_StudentName)) AND ((@IsNull_Course = 1 AND [Course] IS NULL) OR ([Course] = @Original_Course)) AND ((@IsNull_Branch = 1 AND [Branch] IS NULL) OR ([Branch] = @Original_Branch)) AND ((@IsNull_FeeID = 1 AND [FeeID] IS NULL) OR ([FeeID] = @Original_FeeID)) AND ((@IsNull_FDCourse = 1 AND [FDCourse] IS NULL) OR ([FDCourse] = @Original_FDCourse)) AND ((@IsNull_FDBranch = 1 AND [FDBranch] IS NULL) OR ([FDBranch] = @Original_FDBranch)) AND ((@IsNull_Semester = 1 AND [Semester] IS NULL) OR ([Semester] = @Original_Semester)) AND ((@IsNull_TutionFees = 1 AND [TutionFees] IS NULL) OR ([TutionFees] = @Original_TutionFees)) AND ((@IsNull_LibraryFees = 1 AND [LibraryFees] IS NULL) OR ([LibraryFees] = @Original_LibraryFees)) AND ((@IsNull_UniversityDevelopmentFees = 1 AND [UniversityDevelopmentFees] IS NULL) OR ([UniversityDevelopmentFees] = @Original_UniversityDevelopmentFees)) AND ((@IsNull_UniversityStudentWelfareFees = 1 AND [UniversityStudentWelfareFees] IS NULL) OR ([UniversityStudentWelfareFees] = @Original_UniversityStudentWelfareFees)) AND ((@IsNull_CautionMoney = 1 AND [CautionMoney] IS NULL) OR ([CautionMoney] = @Original_CautionMoney)) AND ((@IsNull_OtherFees = 1 AND [OtherFees] IS NULL) OR ([OtherFees] = @Original_OtherFees)) AND ((@IsNull_TotalFees = 1 AND [TotalFees] IS NULL) OR ([TotalFees] = @Original_TotalFees)) AND ((@IsNull_DateOfPayment = 1 AND [DateOfPayment] IS NULL) OR ([DateOfPayment] = @Original_DateOfPayment)) AND ((@IsNull_ModeOfPayment = 1 AND [ModeOfPayment] IS NULL) OR ([ModeOfPayment] = @Original_ModeOfPayment)) AND ((@IsNull_PaymentModeDetails = 1 AND [PaymentModeDetails] IS NULL) OR ([PaymentModeDetails] = @Original_PaymentModeDetails)) AND ((@IsNull_TotalPaid = 1 AND [TotalPaid] IS NULL) OR ([TotalPaid] = @Original_TotalPaid)) AND ((@IsNull_Fine = 1 AND [Fine] IS NULL) OR ([Fine] = @Original_Fine)) AND ((@IsNull_DueFees = 1 AND [DueFees] IS NULL) OR ([DueFees] = @Original_DueFees)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FeePaymentID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FeePaymentID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScholarNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScholarNo" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ScholarNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ScholarNo" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StudentName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StudentName" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_StudentName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StudentName" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Course" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Course" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Course" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Course" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Branch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Branch" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Branch" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Branch" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FeeID" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FeeID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FeeID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FDCourse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FDCourse" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FDCourse" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FDCourse" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FDBranch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FDBranch" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FDBranch" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FDBranch" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Semester" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Semester" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TutionFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TutionFees" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TutionFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TutionFees" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LibraryFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LibraryFees" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LibraryFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LibraryFees" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UniversityDevelopmentFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniversityDevelopmentFees" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UniversityDevelopmentFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniversityDevelopmentFees" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UniversityStudentWelfareFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniversityStudentWelfareFees" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UniversityStudentWelfareFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniversityStudentWelfareFees" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CautionMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CautionMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CautionMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CautionMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OtherFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OtherFees" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OtherFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OtherFees" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalFees" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TotalFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalFees" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateOfPayment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateOfPayment" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_DateOfPayment" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DateOfPayment" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModeOfPayment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModeOfPayment" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ModeOfPayment" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModeOfPayment" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PaymentModeDetails" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PaymentModeDetails" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PaymentModeDetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PaymentModeDetails" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalPaid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TotalPaid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fine" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Fine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fine" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DueFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DueFees" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_DueFees" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DueFees" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[FeePayment] ([FeePaymentID], [ScholarNo], [StudentName], [Course], [Branch], [FeeID], [FDCourse], [FDBranch], [Semester], [TutionFees], [LibraryFees], [UniversityDevelopmentFees], [UniversityStudentWelfareFees], [CautionMoney], [OtherFees], [TotalFees], [DateOfPayment], [ModeOfPayment], [PaymentModeDetails], [TotalPaid], [Fine], [DueFees]) VALUES (@FeePaymentID, @ScholarNo, @StudentName, @Course, @Branch, @FeeID, @FDCourse, @FDBranch, @Semester, @TutionFees, @LibraryFees, @UniversityDevelopmentFees, @UniversityStudentWelfareFees, @CautionMoney, @OtherFees, @TotalFees, @DateOfPayment, @ModeOfPayment, @PaymentModeDetails, @TotalPaid, @Fine, @DueFees);
SELECT FeePaymentID, ScholarNo, StudentName, Course, Branch, FeeID, FDCourse, FDBranch, Semester, TutionFees, LibraryFees, UniversityDevelopmentFees, UniversityStudentWelfareFees, CautionMoney, OtherFees, TotalFees, DateOfPayment, ModeOfPayment, PaymentModeDetails, TotalPaid, Fine, DueFees FROM FeePayment WHERE (FeePaymentID = @FeePaymentID)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FeePaymentID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FeePaymentID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ScholarNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ScholarNo" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@StudentName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StudentName" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Course" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Course" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Branch" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Branch" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FeeID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FeeID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FDCourse" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FDCourse" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FDBranch" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FDBranch" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Semester" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TutionFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TutionFees" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LibraryFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LibraryFees" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UniversityDevelopmentFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniversityDevelopmentFees" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UniversityStudentWelfareFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniversityStudentWelfareFees" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CautionMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CautionMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OtherFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OtherFees" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TotalFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalFees" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DateOfPayment" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DateOfPayment" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ModeOfPayment" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModeOfPayment" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PaymentModeDetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PaymentModeDetails" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TotalPaid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Fine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fine" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DueFees" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DueFees" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT FeePaymentID, ScholarNo, StudentName, Course, Branch, FeeID, FDCourse, FDBranch, Semester, TutionFees, LibraryFees, UniversityDevelopmentFees, UniversityStudentWelfareFees, CautionMoney, OtherFees, TotalFees, DateOfPayment, ModeOfPayment, PaymentModeDetails, TotalPaid, Fine, DueFees FROM dbo.FeePayment</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[FeePayment] SET [FeePaymentID] = @FeePaymentID, [ScholarNo] = @ScholarNo, [StudentName] = @StudentName, [Course] = @Course, [Branch] = @Branch, [FeeID] = @FeeID, [FDCourse] = @FDCourse, [FDBranch] = @FDBranch, [Semester] = @Semester, [TutionFees] = @TutionFees, [LibraryFees] = @LibraryFees, [UniversityDevelopmentFees] = @UniversityDevelopmentFees, [UniversityStudentWelfareFees] = @UniversityStudentWelfareFees, [CautionMoney] = @CautionMoney, [OtherFees] = @OtherFees, [TotalFees] = @TotalFees, [DateOfPayment] = @DateOfPayment, [ModeOfPayment] = @ModeOfPayment, [PaymentModeDetails] = @PaymentModeDetails, [TotalPaid] = @TotalPaid, [Fine] = @Fine, [DueFees] = @DueFees WHERE (([FeePaymentID] = @Original_FeePaymentID) AND ((@IsNull_ScholarNo = 1 AND [ScholarNo] IS NULL) OR ([ScholarNo] = @Original_ScholarNo)) AND ((@IsNull_StudentName = 1 AND [StudentName] IS NULL) OR ([StudentName] = @Original_StudentName)) AND ((@IsNull_Course = 1 AND [Course] IS NULL) OR ([Course] = @Original_Course)) AND ((@IsNull_Branch = 1 AND [Branch] IS NULL) OR ([Branch] = @Original_Branch)) AND ((@IsNull_FeeID = 1 AND [FeeID] IS NULL) OR ([FeeID] = @Original_FeeID)) AND ((@IsNull_FDCourse = 1 AND [FDCourse] IS NULL) OR ([FDCourse] = @Original_FDCourse)) AND ((@IsNull_FDBranch = 1 AND [FDBranch] IS NULL) OR ([FDBranch] = @Original_FDBranch)) AND ((@IsNull_Semester = 1 AND [Semester] IS NULL) OR ([Semester] = @Original_Semester)) AND ((@IsNull_TutionFees = 1 AND [TutionFees] IS NULL) OR ([TutionFees] = @Original_TutionFees)) AND ((@IsNull_LibraryFees = 1 AND [LibraryFees] IS NULL) OR ([LibraryFees] = @Original_LibraryFees)) AND ((@IsNull_UniversityDevelopmentFees = 1 AND [UniversityDevelopmentFees] IS NULL) OR ([UniversityDevelopmentFees] = @Original_UniversityDevelopmentFees)) AND ((@IsNull_UniversityStudentWelfareFees = 1 AND [UniversityStudentWelfareFees] IS NULL) OR ([UniversityStudentWelfareFees] = @Original_UniversityStudentWelfareFees)) AND ((@IsNull_CautionMoney = 1 AND [CautionMoney] IS NULL) OR ([CautionMoney] = @Original_CautionMoney)) AND ((@IsNull_OtherFees = 1 AND [OtherFees] IS NULL) OR ([OtherFees] = @Original_OtherFees)) AND ((@IsNull_TotalFees = 1 AND [TotalFees] IS NULL) OR ([TotalFees] = @Original_TotalFees)) AND ((@IsNull_DateOfPayment = 1 AND [DateOfPayment] IS NULL) OR ([DateOfPayment] = @Original_DateOfPayment)) AND ((@IsNull_ModeOfPayment = 1 AND [ModeOfPayment] IS NULL) OR ([ModeOfPayment] = @Original_ModeOfPayment)) AND ((@IsNull_PaymentModeDetails = 1 AND [PaymentModeDetails] IS NULL) OR ([PaymentModeDetails] = @Original_PaymentModeDetails)) AND ((@IsNull_TotalPaid = 1 AND [TotalPaid] IS NULL) OR ([TotalPaid] = @Original_TotalPaid)) AND ((@IsNull_Fine = 1 AND [Fine] IS NULL) OR ([Fine] = @Original_Fine)) AND ((@IsNull_DueFees = 1 AND [DueFees] IS NULL) OR ([DueFees] = @Original_DueFees)));
SELECT FeePaymentID, ScholarNo, StudentName, Course, Branch, FeeID, FDCourse, FDBranch, Semester, TutionFees, LibraryFees, UniversityDevelopmentFees, UniversityStudentWelfareFees, CautionMoney, OtherFees, TotalFees, DateOfPayment, ModeOfPayment, PaymentModeDetails, TotalPaid, Fine, DueFees FROM FeePayment WHERE (FeePaymentID = @FeePaymentID)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FeePaymentID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FeePaymentID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ScholarNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ScholarNo" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@StudentName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StudentName" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Course" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Course" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Branch" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Branch" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FeeID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FeeID" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FDCourse" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FDCourse" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FDBranch" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FDBranch" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Semester" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TutionFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TutionFees" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LibraryFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LibraryFees" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UniversityDevelopmentFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniversityDevelopmentFees" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UniversityStudentWelfareFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniversityStudentWelfareFees" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CautionMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CautionMoney" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OtherFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OtherFees" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TotalFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalFees" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DateOfPayment" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DateOfPayment" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ModeOfPayment" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModeOfPayment" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PaymentModeDetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PaymentModeDetails" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TotalPaid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Fine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fine" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DueFees" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DueFees" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FeePaymentID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FeePaymentID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScholarNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScholarNo" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ScholarNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ScholarNo" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StudentName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StudentName" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_StudentName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="StudentName" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Course" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Course" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Course" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Course" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Branch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Branch" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Branch" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Branch" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FeeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FeeID" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FeeID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FeeID" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FDCourse" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FDCourse" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FDCourse" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FDCourse" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FDBranch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FDBranch" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FDBranch" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FDBranch" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Semester" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Semester" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Semester" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TutionFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TutionFees" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TutionFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TutionFees" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LibraryFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LibraryFees" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LibraryFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LibraryFees" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UniversityDevelopmentFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniversityDevelopmentFees" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UniversityDevelopmentFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniversityDevelopmentFees" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UniversityStudentWelfareFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniversityStudentWelfareFees" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UniversityStudentWelfareFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniversityStudentWelfareFees" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CautionMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CautionMoney" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CautionMoney" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CautionMoney" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OtherFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OtherFees" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OtherFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OtherFees" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalFees" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TotalFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalFees" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateOfPayment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateOfPayment" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_DateOfPayment" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DateOfPayment" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModeOfPayment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModeOfPayment" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ModeOfPayment" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ModeOfPayment" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PaymentModeDetails" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PaymentModeDetails" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PaymentModeDetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PaymentModeDetails" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalPaid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TotalPaid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalPaid" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fine" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Fine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fine" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DueFees" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DueFees" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_DueFees" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DueFees" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="FeePaymentID" DataSetColumn="FeePaymentID" />
<Mapping SourceColumn="ScholarNo" DataSetColumn="ScholarNo" />
<Mapping SourceColumn="StudentName" DataSetColumn="StudentName" />
<Mapping SourceColumn="Course" DataSetColumn="Course" />
<Mapping SourceColumn="Branch" DataSetColumn="Branch" />
<Mapping SourceColumn="FeeID" DataSetColumn="FeeID" />
<Mapping SourceColumn="FDCourse" DataSetColumn="FDCourse" />
<Mapping SourceColumn="FDBranch" DataSetColumn="FDBranch" />
<Mapping SourceColumn="Semester" DataSetColumn="Semester" />
<Mapping SourceColumn="TutionFees" DataSetColumn="TutionFees" />
<Mapping SourceColumn="LibraryFees" DataSetColumn="LibraryFees" />
<Mapping SourceColumn="UniversityDevelopmentFees" DataSetColumn="UniversityDevelopmentFees" />
<Mapping SourceColumn="UniversityStudentWelfareFees" DataSetColumn="UniversityStudentWelfareFees" />
<Mapping SourceColumn="CautionMoney" DataSetColumn="CautionMoney" />
<Mapping SourceColumn="OtherFees" DataSetColumn="OtherFees" />
<Mapping SourceColumn="TotalFees" DataSetColumn="TotalFees" />
<Mapping SourceColumn="DateOfPayment" DataSetColumn="DateOfPayment" />
<Mapping SourceColumn="ModeOfPayment" DataSetColumn="ModeOfPayment" />
<Mapping SourceColumn="PaymentModeDetails" DataSetColumn="PaymentModeDetails" />
<Mapping SourceColumn="TotalPaid" DataSetColumn="TotalPaid" />
<Mapping SourceColumn="Fine" DataSetColumn="Fine" />
<Mapping SourceColumn="DueFees" DataSetColumn="DueFees" />
</Mappings>
<Sources />
</TableAdapter>
</Tables>
<Sources />
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="FeePayment_DBDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="FeePayment_DBDataSet" msprop:Generator_UserDSName="FeePayment_DBDataSet">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="FeePayment" msprop:Generator_TableClassName="FeePaymentDataTable" msprop:Generator_TableVarName="tableFeePayment" msprop:Generator_TablePropName="FeePayment" msprop:Generator_RowDeletingName="FeePaymentRowDeleting" msprop:Generator_RowChangingName="FeePaymentRowChanging" msprop:Generator_RowEvHandlerName="FeePaymentRowChangeEventHandler" msprop:Generator_RowDeletedName="FeePaymentRowDeleted" msprop:Generator_UserTableName="FeePayment" msprop:Generator_RowChangedName="FeePaymentRowChanged" msprop:Generator_RowEvArgName="FeePaymentRowChangeEvent" msprop:Generator_RowClassName="FeePaymentRow">
<xs:complexType>
<xs:sequence>
<xs:element name="FeePaymentID" msprop:Generator_ColumnVarNameInTable="columnFeePaymentID" msprop:Generator_ColumnPropNameInRow="FeePaymentID" msprop:Generator_ColumnPropNameInTable="FeePaymentIDColumn" msprop:Generator_UserColumnName="FeePaymentID">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="20" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ScholarNo" msprop:Generator_ColumnVarNameInTable="columnScholarNo" msprop:Generator_ColumnPropNameInRow="ScholarNo" msprop:Generator_ColumnPropNameInTable="ScholarNoColumn" msprop:Generator_UserColumnName="ScholarNo" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="15" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="StudentName" msprop:Generator_ColumnVarNameInTable="columnStudentName" msprop:Generator_ColumnPropNameInRow="StudentName" msprop:Generator_ColumnPropNameInTable="StudentNameColumn" msprop:Generator_UserColumnName="StudentName" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="30" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Course" msprop:Generator_ColumnVarNameInTable="columnCourse" msprop:Generator_ColumnPropNameInRow="Course" msprop:Generator_ColumnPropNameInTable="CourseColumn" msprop:Generator_UserColumnName="Course" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="20" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Branch" msprop:Generator_ColumnVarNameInTable="columnBranch" msprop:Generator_ColumnPropNameInRow="Branch" msprop:Generator_ColumnPropNameInTable="BranchColumn" msprop:Generator_UserColumnName="Branch" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="30" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="FeeID" msprop:Generator_ColumnVarNameInTable="columnFeeID" msprop:Generator_ColumnPropNameInRow="FeeID" msprop:Generator_ColumnPropNameInTable="FeeIDColumn" msprop:Generator_UserColumnName="FeeID" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="20" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="FDCourse" msprop:Generator_ColumnVarNameInTable="columnFDCourse" msprop:Generator_ColumnPropNameInRow="FDCourse" msprop:Generator_ColumnPropNameInTable="FDCourseColumn" msprop:Generator_UserColumnName="FDCourse" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="20" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="FDBranch" msprop:Generator_ColumnVarNameInTable="columnFDBranch" msprop:Generator_ColumnPropNameInRow="FDBranch" msprop:Generator_ColumnPropNameInTable="FDBranchColumn" msprop:Generator_UserColumnName="FDBranch" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="30" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Semester" msprop:Generator_ColumnVarNameInTable="columnSemester" msprop:Generator_ColumnPropNameInRow="Semester" msprop:Generator_ColumnPropNameInTable="SemesterColumn" msprop:Generator_UserColumnName="Semester" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="TutionFees" msprop:Generator_ColumnVarNameInTable="columnTutionFees" msprop:Generator_ColumnPropNameInRow="TutionFees" msprop:Generator_ColumnPropNameInTable="TutionFeesColumn" msprop:Generator_UserColumnName="TutionFees" type="xs:int" minOccurs="0" />
<xs:element name="LibraryFees" msprop:Generator_ColumnVarNameInTable="columnLibraryFees" msprop:Generator_ColumnPropNameInRow="LibraryFees" msprop:Generator_ColumnPropNameInTable="LibraryFeesColumn" msprop:Generator_UserColumnName="LibraryFees" type="xs:int" minOccurs="0" />
<xs:element name="UniversityDevelopmentFees" msprop:Generator_ColumnVarNameInTable="columnUniversityDevelopmentFees" msprop:Generator_ColumnPropNameInRow="UniversityDevelopmentFees" msprop:Generator_ColumnPropNameInTable="UniversityDevelopmentFeesColumn" msprop:Generator_UserColumnName="UniversityDevelopmentFees" type="xs:int" minOccurs="0" />
<xs:element name="UniversityStudentWelfareFees" msprop:Generator_ColumnVarNameInTable="columnUniversityStudentWelfareFees" msprop:Generator_ColumnPropNameInRow="UniversityStudentWelfareFees" msprop:Generator_ColumnPropNameInTable="UniversityStudentWelfareFeesColumn" msprop:Generator_UserColumnName="UniversityStudentWelfareFees" type="xs:int" minOccurs="0" />
<xs:element name="CautionMoney" msprop:Generator_ColumnVarNameInTable="columnCautionMoney" msprop:Generator_ColumnPropNameInRow="CautionMoney" msprop:Generator_ColumnPropNameInTable="CautionMoneyColumn" msprop:Generator_UserColumnName="CautionMoney" type="xs:int" minOccurs="0" />
<xs:element name="OtherFees" msprop:Generator_ColumnVarNameInTable="columnOtherFees" msprop:Generator_ColumnPropNameInRow="OtherFees" msprop:Generator_ColumnPropNameInTable="OtherFeesColumn" msprop:Generator_UserColumnName="OtherFees" type="xs:int" minOccurs="0" />
<xs:element name="TotalFees" msprop:Generator_ColumnVarNameInTable="columnTotalFees" msprop:Generator_ColumnPropNameInRow="TotalFees" msprop:Generator_ColumnPropNameInTable="TotalFeesColumn" msprop:Generator_UserColumnName="TotalFees" type="xs:int" minOccurs="0" />
<xs:element name="DateOfPayment" msprop:Generator_ColumnVarNameInTable="columnDateOfPayment" msprop:Generator_ColumnPropNameInRow="DateOfPayment" msprop:Generator_ColumnPropNameInTable="DateOfPaymentColumn" msprop:Generator_UserColumnName="DateOfPayment" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="30" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ModeOfPayment" msprop:Generator_ColumnVarNameInTable="columnModeOfPayment" msprop:Generator_ColumnPropNameInRow="ModeOfPayment" msprop:Generator_ColumnPropNameInTable="ModeOfPaymentColumn" msprop:Generator_UserColumnName="ModeOfPayment" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="20" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="PaymentModeDetails" msprop:Generator_ColumnVarNameInTable="columnPaymentModeDetails" msprop:Generator_ColumnPropNameInRow="PaymentModeDetails" msprop:Generator_ColumnPropNameInTable="PaymentModeDetailsColumn" msprop:Generator_UserColumnName="PaymentModeDetails" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="200" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="TotalPaid" msprop:Generator_ColumnVarNameInTable="columnTotalPaid" msprop:Generator_ColumnPropNameInRow="TotalPaid" msprop:Generator_ColumnPropNameInTable="TotalPaidColumn" msprop:Generator_UserColumnName="TotalPaid" type="xs:int" minOccurs="0" />
<xs:element name="Fine" msprop:Generator_ColumnVarNameInTable="columnFine" msprop:Generator_ColumnPropNameInRow="Fine" msprop:Generator_ColumnPropNameInTable="FineColumn" msprop:Generator_UserColumnName="Fine" type="xs:int" minOccurs="0" />
<xs:element name="DueFees" msprop:Generator_ColumnVarNameInTable="columnDueFees" msprop:Generator_ColumnPropNameInRow="DueFees" msprop:Generator_ColumnPropNameInTable="DueFeesColumn" msprop:Generator_UserColumnName="DueFees" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:FeePayment" />
<xs:field xpath="mstns:FeePaymentID" />
</xs:unique>
</xs:element>
</xs:schema>