1 //------------------------------------------------------------------------------
2 // <auto-generated>
3 // This code was generated by a tool.
4 // Runtime Version:4.0.30319.18408
5 //
6 // Changes to this file may cause incorrect behavior and will be lost if
7 // the code is regenerated.
8 // </auto-generated>
9 //------------------------------------------------------------------------------
10
11 #pragma warning disable 1591
12
13 namespace GymManagementSystem {
14
15
16 /// <summary>
17 ///Represents a strongly typed in-memory cache of data.
18 ///</summary>
19 [global::System.Serializable()]
20 [global::System.ComponentModel.DesignerCategoryAttribute("code")]
21 [global::System.ComponentModel.ToolboxItem(true)]
22 [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")]
23 [global::System.Xml.Serialization.XmlRootAttribute("GymDataSet1")]
24 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
25 public partial class GymDataSet1 : global::System.Data.DataSet {
26
27 private membersDataTable tablemembers;
28
29 private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
30
31 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
32 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
33 public GymDataSet1() {
34 this.BeginInit();
35 this.InitClass();
36 global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
37 base.Tables.CollectionChanged += schemaChangedHandler;
38 base.Relations.CollectionChanged += schemaChangedHandler;
39 this.EndInit();
40 }
41
42 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
43 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
44 protected GymDataSet1(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
45 base(info, context, false) {
46 if ((this.IsBinarySerialized(info, context) == true)) {
47 this.InitVars(false);
48 global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
49 this.Tables.CollectionChanged += schemaChangedHandler1;
50 this.Relations.CollectionChanged += schemaChangedHandler1;
51 return;
52 }
53 string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
54 if ((this.DetermineSchemaSerializationMode(info, context) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
55 global::System.Data.DataSet ds = new global::System.Data.DataSet();
56 ds.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
57 if ((ds.Tables["members"] != null)) {
58 base.Tables.Add(new membersDataTable(ds.Tables["members"]));
59 }
60 this.DataSetName = ds.DataSetName;
61 this.Prefix = ds.Prefix;
62 this.Namespace = ds.Namespace;
63 this.Locale = ds.Locale;
64 this.CaseSensitive = ds.CaseSensitive;
65 this.EnforceConstraints = ds.EnforceConstraints;
66 this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
67 this.InitVars();
68 }
69 else {
70 this.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
71 }
72 this.GetSerializationData(info, context);
73 global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
74 base.Tables.CollectionChanged += schemaChangedHandler;
75 this.Relations.CollectionChanged += schemaChangedHandler;
76 }
77
78 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
79 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
80 [global::System.ComponentModel.Browsable(false)]
81 [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
82 public membersDataTable members {
83 get {
84 return this.tablemembers;
85 }
86 }
87
88 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
89 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
90 [global::System.ComponentModel.BrowsableAttribute(true)]
91 [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Visible)]
92 public override global::System.Data.SchemaSerializationMode SchemaSerializationMode {
93 get {
94 return this._schemaSerializationMode;
95 }
96 set {
97 this._schemaSerializationMode = value;
98 }
99 }
100
101 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
102 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
103 [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
104 public new global::System.Data.DataTableCollection Tables {
105 get {
106 return base.Tables;
107 }
108 }
109
110 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
111 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
112 [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
113 public new global::System.Data.DataRelationCollection Relations {
114 get {
115 return base.Relations;
116 }
117 }
118
119 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
120 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
121 protected override void InitializeDerivedDataSet() {
122 this.BeginInit();
123 this.InitClass();
124 this.EndInit();
125 }
126
127 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
128 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
129 public override global::System.Data.DataSet Clone() {
130 GymDataSet1 cln = ((GymDataSet1)(base.Clone()));
131 cln.InitVars();
132 cln.SchemaSerializationMode = this.SchemaSerializationMode;
133 return cln;
134 }
135
136 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
137 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
138 protected override bool ShouldSerializeTables() {
139 return false;
140 }
141
142 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
143 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
144 protected override bool ShouldSerializeRelations() {
145 return false;
146 }
147
148 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
149 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
150 protected override void ReadXmlSerializable(global::System.Xml.XmlReader reader) {
151 if ((this.DetermineSchemaSerializationMode(reader) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
152 this.Reset();
153 global::System.Data.DataSet ds = new global::System.Data.DataSet();
154 ds.ReadXml(reader);
155 if ((ds.Tables["members"] != null)) {
156 base.Tables.Add(new membersDataTable(ds.Tables["members"]));
157 }
158 this.DataSetName = ds.DataSetName;
159 this.Prefix = ds.Prefix;
160 this.Namespace = ds.Namespace;
161 this.Locale = ds.Locale;
162 this.CaseSensitive = ds.CaseSensitive;
163 this.EnforceConstraints = ds.EnforceConstraints;
164 this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
165 this.InitVars();
166 }
167 else {
168 this.ReadXml(reader);
169 this.InitVars();
170 }
171 }
172
173 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
174 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
175 protected override global::System.Xml.Schema.XmlSchema GetSchemaSerializable() {
176 global::System.IO.MemoryStream stream = new global::System.IO.MemoryStream();
177 this.WriteXmlSchema(new global::System.Xml.XmlTextWriter(stream, null));
178 stream.Position = 0;
179 return global::System.Xml.Schema.XmlSchema.Read(new global::System.Xml.XmlTextReader(stream), null);
180 }
181
182 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
183 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
184 internal void InitVars() {
185 this.InitVars(true);
186 }
187
188 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
189 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
190 internal void InitVars(bool initTable) {
191 this.tablemembers = ((membersDataTable)(base.Tables["members"]));
192 if ((initTable == true)) {
193 if ((this.tablemembers != null)) {
194 this.tablemembers.InitVars();
195 }
196 }
197 }
198
199 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
200 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
201 private void InitClass() {
202 this.DataSetName = "GymDataSet1";
203 this.Prefix = "";
204 this.Namespace = "http://tempuri.org/GymDataSet1.xsd";
205 this.EnforceConstraints = true;
206 this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
207 this.tablemembers = new membersDataTable();
208 base.Tables.Add(this.tablemembers);
209 }
210
211 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
212 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
213 private bool ShouldSerializemembers() {
214 return false;
215 }
216
217 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
218 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
219 private void SchemaChanged(object sender, global::System.ComponentModel.CollectionChangeEventArgs e) {
220 if ((e.Action == global::System.ComponentModel.CollectionChangeAction.Remove)) {
221 this.InitVars();
222 }
223 }
224
225 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
226 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
227 public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
228 GymDataSet1 ds = new GymDataSet1();
229 global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
230 global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
231 global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
232 any.Namespace = ds.Namespace;
233 sequence.Items.Add(any);
234 type.Particle = sequence;
235 global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
236 if (xs.Contains(dsSchema.TargetNamespace)) {
237 global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
238 global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
239 try {
240 global::System.Xml.Schema.XmlSchema schema = null;
241 dsSchema.Write(s1);
242 for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
243 schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
244 s2.SetLength(0);
245 schema.Write(s2);
246 if ((s1.Length == s2.Length)) {
247 s1.Position = 0;
248 s2.Position = 0;
249 for (; ((s1.Position != s1.Length)
250 && (s1.ReadByte() == s2.ReadByte())); ) {
251 ;
252 }
253 if ((s1.Position == s1.Length)) {
254 return type;
255 }
256 }
257 }
258 }
259 finally {
260 if ((s1 != null)) {
261 s1.Close();
262 }
263 if ((s2 != null)) {
264 s2.Close();
265 }
266 }
267 }
268 xs.Add(dsSchema);
269 return type;
270 }
271
272 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
273 public delegate void membersRowChangeEventHandler(object sender, membersRowChangeEvent e);
274
275 /// <summary>
276 ///Represents the strongly named DataTable class.
277 ///</summary>
278 [global::System.Serializable()]
279 [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
280 public partial class membersDataTable : global::System.Data.TypedTableBase<membersRow> {
281
282 private global::System.Data.DataColumn columnm_id;
283
284 private global::System.Data.DataColumn columnf_name;
285
286 private global::System.Data.DataColumn columnl_name;
287
288 private global::System.Data.DataColumn columngender;
289
290 private global::System.Data.DataColumn columndob;
291
292 private global::System.Data.DataColumn columnmobile;
293
294 private global::System.Data.DataColumn columnemail;
295
296 private global::System.Data.DataColumn columnjod;
297
298 private global::System.Data.DataColumn columntime;
299
300 private global::System.Data.DataColumn columnaddress;
301
302 private global::System.Data.DataColumn columnmem_time;
303
304 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
305 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
306 public membersDataTable() {
307 this.TableName = "members";
308 this.BeginInit();
309 this.InitClass();
310 this.EndInit();
311 }
312
313 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
314 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
315 internal membersDataTable(global::System.Data.DataTable table) {
316 this.TableName = table.TableName;
317 if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
318 this.CaseSensitive = table.CaseSensitive;
319 }
320 if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
321 this.Locale = table.Locale;
322 }
323 if ((table.Namespace != table.DataSet.Namespace)) {
324 this.Namespace = table.Namespace;
325 }
326 this.Prefix = table.Prefix;
327 this.MinimumCapacity = table.MinimumCapacity;
328 }
329
330 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
331 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
332 protected membersDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
333 base(info, context) {
334 this.InitVars();
335 }
336
337 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
338 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
339 public global::System.Data.DataColumn m_idColumn {
340 get {
341 return this.columnm_id;
342 }
343 }
344
345 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
346 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
347 public global::System.Data.DataColumn f_nameColumn {
348 get {
349 return this.columnf_name;
350 }
351 }
352
353 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
354 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
355 public global::System.Data.DataColumn l_nameColumn {
356 get {
357 return this.columnl_name;
358 }
359 }
360
361 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
362 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
363 public global::System.Data.DataColumn genderColumn {
364 get {
365 return this.columngender;
366 }
367 }
368
369 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
370 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
371 public global::System.Data.DataColumn dobColumn {
372 get {
373 return this.columndob;
374 }
375 }
376
377 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
378 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
379 public global::System.Data.DataColumn mobileColumn {
380 get {
381 return this.columnmobile;
382 }
383 }
384
385 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
386 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
387 public global::System.Data.DataColumn emailColumn {
388 get {
389 return this.columnemail;
390 }
391 }
392
393 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
394 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
395 public global::System.Data.DataColumn jodColumn {
396 get {
397 return this.columnjod;
398 }
399 }
400
401 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
402 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
403 public global::System.Data.DataColumn timeColumn {
404 get {
405 return this.columntime;
406 }
407 }
408
409 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
410 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
411 public global::System.Data.DataColumn addressColumn {
412 get {
413 return this.columnaddress;
414 }
415 }
416
417 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
418 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
419 public global::System.Data.DataColumn mem_timeColumn {
420 get {
421 return this.columnmem_time;
422 }
423 }
424
425 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
426 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
427 [global::System.ComponentModel.Browsable(false)]
428 public int Count {
429 get {
430 return this.Rows.Count;
431 }
432 }
433
434 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
435 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
436 public membersRow this[int index] {
437 get {
438 return ((membersRow)(this.Rows[index]));
439 }
440 }
441
442 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
443 public event membersRowChangeEventHandler membersRowChanging;
444
445 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
446 public event membersRowChangeEventHandler membersRowChanged;
447
448 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
449 public event membersRowChangeEventHandler membersRowDeleting;
450
451 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
452 public event membersRowChangeEventHandler membersRowDeleted;
453
454 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
455 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
456 public void AddmembersRow(membersRow row) {
457 this.Rows.Add(row);
458 }
459
460 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
461 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
462 public membersRow AddmembersRow(string f_name, string l_name, string gender, string dob, string mobile, string email, string jod, string time, string address, string mem_time) {
463 membersRow rowmembersRow = ((membersRow)(this.NewRow()));
464 object[] columnValuesArray = new object[] {
465 null,
466 f_name,
467 l_name,
468 gender,
469 dob,
470 mobile,
471 email,
472 jod,
473 time,
474 address,
475 mem_time};
476 rowmembersRow.ItemArray = columnValuesArray;
477 this.Rows.Add(rowmembersRow);
478 return rowmembersRow;
479 }
480
481 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
482 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
483 public override global::System.Data.DataTable Clone() {
484 membersDataTable cln = ((membersDataTable)(base.Clone()));
485 cln.InitVars();
486 return cln;
487 }
488
489 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
490 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
491 protected override global::System.Data.DataTable CreateInstance() {
492 return new membersDataTable();
493 }
494
495 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
496 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
497 internal void InitVars() {
498 this.columnm_id = base.Columns["m_id"];
499 this.columnf_name = base.Columns["f_name"];
500 this.columnl_name = base.Columns["l_name"];
501 this.columngender = base.Columns["gender"];
502 this.columndob = base.Columns["dob"];
503 this.columnmobile = base.Columns["mobile"];
504 this.columnemail = base.Columns["email"];
505 this.columnjod = base.Columns["jod"];
506 this.columntime = base.Columns["time"];
507 this.columnaddress = base.Columns["address"];
508 this.columnmem_time = base.Columns["mem_time"];
509 }
510
511 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
512 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
513 private void InitClass() {
514 this.columnm_id = new global::System.Data.DataColumn("m_id", typeof(int), null, global::System.Data.MappingType.Element);
515 base.Columns.Add(this.columnm_id);
516 this.columnf_name = new global::System.Data.DataColumn("f_name", typeof(string), null, global::System.Data.MappingType.Element);
517 base.Columns.Add(this.columnf_name);
518 this.columnl_name = new global::System.Data.DataColumn("l_name", typeof(string), null, global::System.Data.MappingType.Element);
519 base.Columns.Add(this.columnl_name);
520 this.columngender = new global::System.Data.DataColumn("gender", typeof(string), null, global::System.Data.MappingType.Element);
521 base.Columns.Add(this.columngender);
522 this.columndob = new global::System.Data.DataColumn("dob", typeof(string), null, global::System.Data.MappingType.Element);
523 base.Columns.Add(this.columndob);
524 this.columnmobile = new global::System.Data.DataColumn("mobile", typeof(string), null, global::System.Data.MappingType.Element);
525 base.Columns.Add(this.columnmobile);
526 this.columnemail = new global::System.Data.DataColumn("email", typeof(string), null, global::System.Data.MappingType.Element);
527 base.Columns.Add(this.columnemail);
528 this.columnjod = new global::System.Data.DataColumn("jod", typeof(string), null, global::System.Data.MappingType.Element);
529 base.Columns.Add(this.columnjod);
530 this.columntime = new global::System.Data.DataColumn("time", typeof(string), null, global::System.Data.MappingType.Element);
531 base.Columns.Add(this.columntime);
532 this.columnaddress = new global::System.Data.DataColumn("address", typeof(string), null, global::System.Data.MappingType.Element);
533 base.Columns.Add(this.columnaddress);
534 this.columnmem_time = new global::System.Data.DataColumn("mem_time", typeof(string), null, global::System.Data.MappingType.Element);
535 base.Columns.Add(this.columnmem_time);
536 this.columnm_id.AutoIncrement = true;
537 this.columnm_id.AutoIncrementSeed = -1;
538 this.columnm_id.AutoIncrementStep = -1;
539 this.columnm_id.AllowDBNull = false;
540 this.columnm_id.ReadOnly = true;
541 this.columnf_name.MaxLength = 50;
542 this.columnl_name.MaxLength = 50;
543 this.columngender.MaxLength = 50;
544 this.columndob.MaxLength = 50;
545 this.columnmobile.MaxLength = 50;
546 this.columnemail.MaxLength = 50;
547 this.columnjod.MaxLength = 50;
548 this.columntime.MaxLength = 50;
549 this.columnaddress.MaxLength = 50;
550 this.columnmem_time.MaxLength = 50;
551 }
552
553 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
554 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
555 public membersRow NewmembersRow() {
556 return ((membersRow)(this.NewRow()));
557 }
558
559 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
560 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
561 protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
562 return new membersRow(builder);
563 }
564
565 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
566 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
567 protected override global::System.Type GetRowType() {
568 return typeof(membersRow);
569 }
570
571 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
572 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
573 protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
574 base.OnRowChanged(e);
575 if ((this.membersRowChanged != null)) {
576 this.membersRowChanged(this, new membersRowChangeEvent(((membersRow)(e.Row)), e.Action));
577 }
578 }
579
580 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
581 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
582 protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
583 base.OnRowChanging(e);
584 if ((this.membersRowChanging != null)) {
585 this.membersRowChanging(this, new membersRowChangeEvent(((membersRow)(e.Row)), e.Action));
586 }
587 }
588
589 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
590 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
591 protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
592 base.OnRowDeleted(e);
593 if ((this.membersRowDeleted != null)) {
594 this.membersRowDeleted(this, new membersRowChangeEvent(((membersRow)(e.Row)), e.Action));
595 }
596 }
597
598 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
599 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
600 protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
601 base.OnRowDeleting(e);
602 if ((this.membersRowDeleting != null)) {
603 this.membersRowDeleting(this, new membersRowChangeEvent(((membersRow)(e.Row)), e.Action));
604 }
605 }
606
607 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
608 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
609 public void RemovemembersRow(membersRow row) {
610 this.Rows.Remove(row);
611 }
612
613 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
614 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
615 public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
616 global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
617 global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
618 GymDataSet1 ds = new GymDataSet1();
619 global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
620 any1.Namespace = "http://www.w3.org/2001/XMLSchema";
621 any1.MinOccurs = new decimal(0);
622 any1.MaxOccurs = decimal.MaxValue;
623 any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
624 sequence.Items.Add(any1);
625 global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
626 any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
627 any2.MinOccurs = new decimal(1);
628 any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
629 sequence.Items.Add(any2);
630 global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
631 attribute1.Name = "namespace";
632 attribute1.FixedValue = ds.Namespace;
633 type.Attributes.Add(attribute1);
634 global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
635 attribute2.Name = "tableTypeName";
636 attribute2.FixedValue = "membersDataTable";
637 type.Attributes.Add(attribute2);
638 type.Particle = sequence;
639 global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
640 if (xs.Contains(dsSchema.TargetNamespace)) {
641 global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
642 global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
643 try {
644 global::System.Xml.Schema.XmlSchema schema = null;
645 dsSchema.Write(s1);
646 for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
647 schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
648 s2.SetLength(0);
649 schema.Write(s2);
650 if ((s1.Length == s2.Length)) {
651 s1.Position = 0;
652 s2.Position = 0;
653 for (; ((s1.Position != s1.Length)
654 && (s1.ReadByte() == s2.ReadByte())); ) {
655 ;
656 }
657 if ((s1.Position == s1.Length)) {
658 return type;
659 }
660 }
661 }
662 }
663 finally {
664 if ((s1 != null)) {
665 s1.Close();
666 }
667 if ((s2 != null)) {
668 s2.Close();
669 }
670 }
671 }
672 xs.Add(dsSchema);
673 return type;
674 }
675 }
676
677 /// <summary>
678 ///Represents strongly named DataRow class.
679 ///</summary>
680 public partial class membersRow : global::System.Data.DataRow {
681
682 private membersDataTable tablemembers;
683
684 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
685 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
686 internal membersRow(global::System.Data.DataRowBuilder rb) :
687 base(rb) {
688 this.tablemembers = ((membersDataTable)(this.Table));
689 }
690
691 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
692 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
693 public int m_id {
694 get {
695 return ((int)(this[this.tablemembers.m_idColumn]));
696 }
697 set {
698 this[this.tablemembers.m_idColumn] = value;
699 }
700 }
701
702 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
703 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
704 public string f_name {
705 get {
706 try {
707 return ((string)(this[this.tablemembers.f_nameColumn]));
708 }
709 catch (global::System.InvalidCastException e) {
710 throw new global::System.Data.StrongTypingException("The value for column \'f_name\' in table \'members\' is DBNull.", e);
711 }
712 }
713 set {
714 this[this.tablemembers.f_nameColumn] = value;
715 }
716 }
717
718 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
719 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
720 public string l_name {
721 get {
722 try {
723 return ((string)(this[this.tablemembers.l_nameColumn]));
724 }
725 catch (global::System.InvalidCastException e) {
726 throw new global::System.Data.StrongTypingException("The value for column \'l_name\' in table \'members\' is DBNull.", e);
727 }
728 }
729 set {
730 this[this.tablemembers.l_nameColumn] = value;
731 }
732 }
733
734 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
735 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
736 public string gender {
737 get {
738 try {
739 return ((string)(this[this.tablemembers.genderColumn]));
740 }
741 catch (global::System.InvalidCastException e) {
742 throw new global::System.Data.StrongTypingException("The value for column \'gender\' in table \'members\' is DBNull.", e);
743 }
744 }
745 set {
746 this[this.tablemembers.genderColumn] = value;
747 }
748 }
749
750 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
751 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
752 public string dob {
753 get {
754 try {
755 return ((string)(this[this.tablemembers.dobColumn]));
756 }
757 catch (global::System.InvalidCastException e) {
758 throw new global::System.Data.StrongTypingException("The value for column \'dob\' in table \'members\' is DBNull.", e);
759 }
760 }
761 set {
762 this[this.tablemembers.dobColumn] = value;
763 }
764 }
765
766 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
767 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
768 public string mobile {
769 get {
770 try {
771 return ((string)(this[this.tablemembers.mobileColumn]));
772 }
773 catch (global::System.InvalidCastException e) {
774 throw new global::System.Data.StrongTypingException("The value for column \'mobile\' in table \'members\' is DBNull.", e);
775 }
776 }
777 set {
778 this[this.tablemembers.mobileColumn] = value;
779 }
780 }
781
782 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
783 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
784 public string email {
785 get {
786 try {
787 return ((string)(this[this.tablemembers.emailColumn]));
788 }
789 catch (global::System.InvalidCastException e) {
790 throw new global::System.Data.StrongTypingException("The value for column \'email\' in table \'members\' is DBNull.", e);
791 }
792 }
793 set {
794 this[this.tablemembers.emailColumn] = value;
795 }
796 }
797
798 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
799 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
800 public string jod {
801 get {
802 try {
803 return ((string)(this[this.tablemembers.jodColumn]));
804 }
805 catch (global::System.InvalidCastException e) {
806 throw new global::System.Data.StrongTypingException("The value for column \'jod\' in table \'members\' is DBNull.", e);
807 }
808 }
809 set {
810 this[this.tablemembers.jodColumn] = value;
811 }
812 }
813
814 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
815 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
816 public string time {
817 get {
818 try {
819 return ((string)(this[this.tablemembers.timeColumn]));
820 }
821 catch (global::System.InvalidCastException e) {
822 throw new global::System.Data.StrongTypingException("The value for column \'time\' in table \'members\' is DBNull.", e);
823 }
824 }
825 set {
826 this[this.tablemembers.timeColumn] = value;
827 }
828 }
829
830 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
831 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
832 public string address {
833 get {
834 try {
835 return ((string)(this[this.tablemembers.addressColumn]));
836 }
837 catch (global::System.InvalidCastException e) {
838 throw new global::System.Data.StrongTypingException("The value for column \'address\' in table \'members\' is DBNull.", e);
839 }
840 }
841 set {
842 this[this.tablemembers.addressColumn] = value;
843 }
844 }
845
846 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
847 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
848 public string mem_time {
849 get {
850 try {
851 return ((string)(this[this.tablemembers.mem_timeColumn]));
852 }
853 catch (global::System.InvalidCastException e) {
854 throw new global::System.Data.StrongTypingException("The value for column \'mem_time\' in table \'members\' is DBNull.", e);
855 }
856 }
857 set {
858 this[this.tablemembers.mem_timeColumn] = value;
859 }
860 }
861
862 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
863 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
864 public bool Isf_nameNull() {
865 return this.IsNull(this.tablemembers.f_nameColumn);
866 }
867
868 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
869 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
870 public void Setf_nameNull() {
871 this[this.tablemembers.f_nameColumn] = global::System.Convert.DBNull;
872 }
873
874 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
875 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
876 public bool Isl_nameNull() {
877 return this.IsNull(this.tablemembers.l_nameColumn);
878 }
879
880 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
881 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
882 public void Setl_nameNull() {
883 this[this.tablemembers.l_nameColumn] = global::System.Convert.DBNull;
884 }
885
886 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
887 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
888 public bool IsgenderNull() {
889 return this.IsNull(this.tablemembers.genderColumn);
890 }
891
892 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
893 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
894 public void SetgenderNull() {
895 this[this.tablemembers.genderColumn] = global::System.Convert.DBNull;
896 }
897
898 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
899 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
900 public bool IsdobNull() {
901 return this.IsNull(this.tablemembers.dobColumn);
902 }
903
904 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
905 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
906 public void SetdobNull() {
907 this[this.tablemembers.dobColumn] = global::System.Convert.DBNull;
908 }
909
910 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
911 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
912 public bool IsmobileNull() {
913 return this.IsNull(this.tablemembers.mobileColumn);
914 }
915
916 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
917 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
918 public void SetmobileNull() {
919 this[this.tablemembers.mobileColumn] = global::System.Convert.DBNull;
920 }
921
922 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
923 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
924 public bool IsemailNull() {
925 return this.IsNull(this.tablemembers.emailColumn);
926 }
927
928 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
929 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
930 public void SetemailNull() {
931 this[this.tablemembers.emailColumn] = global::System.Convert.DBNull;
932 }
933
934 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
935 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
936 public bool IsjodNull() {
937 return this.IsNull(this.tablemembers.jodColumn);
938 }
939
940 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
941 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
942 public void SetjodNull() {
943 this[this.tablemembers.jodColumn] = global::System.Convert.DBNull;
944 }
945
946 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
947 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
948 public bool IstimeNull() {
949 return this.IsNull(this.tablemembers.timeColumn);
950 }
951
952 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
953 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
954 public void SettimeNull() {
955 this[this.tablemembers.timeColumn] = global::System.Convert.DBNull;
956 }
957
958 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
959 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
960 public bool IsaddressNull() {
961 return this.IsNull(this.tablemembers.addressColumn);
962 }
963
964 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
965 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
966 public void SetaddressNull() {
967 this[this.tablemembers.addressColumn] = global::System.Convert.DBNull;
968 }
969
970 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
971 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
972 public bool Ismem_timeNull() {
973 return this.IsNull(this.tablemembers.mem_timeColumn);
974 }
975
976 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
977 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
978 public void Setmem_timeNull() {
979 this[this.tablemembers.mem_timeColumn] = global::System.Convert.DBNull;
980 }
981 }
982
983 /// <summary>
984 ///Row event argument class
985 ///</summary>
986 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
987 public class membersRowChangeEvent : global::System.EventArgs {
988
989 private membersRow eventRow;
990
991 private global::System.Data.DataRowAction eventAction;
992
993 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
994 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
995 public membersRowChangeEvent(membersRow row, global::System.Data.DataRowAction action) {
996 this.eventRow = row;
997 this.eventAction = action;
998 }
999
1000 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1001 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1002 public membersRow Row {
1003 get {
1004 return this.eventRow;
1005 }
1006 }
1007
1008 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1009 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1010 public global::System.Data.DataRowAction Action {
1011 get {
1012 return this.eventAction;
1013 }
1014 }
1015 }
1016 }
1017 }
1018 namespace GymManagementSystem.GymDataSet1TableAdapters {
1019
1020
1021 /// <summary>
1022 ///Represents the connection and commands used to retrieve and save data.
1023 ///</summary>
1024 [global::System.ComponentModel.DesignerCategoryAttribute("code")]
1025 [global::System.ComponentModel.ToolboxItem(true)]
1026 [global::System.ComponentModel.DataObjectAttribute(true)]
1027 [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
1028 ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
1029 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1030 public partial class membersTableAdapter : global::System.ComponentModel.Component {
1031
1032 private global::System.Data.SqlClient.SqlDataAdapter _adapter;
1033
1034 private global::System.Data.SqlClient.SqlConnection _connection;
1035
1036 private global::System.Data.SqlClient.SqlTransaction _transaction;
1037
1038 private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
1039
1040 private bool _clearBeforeFill;
1041
1042 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1043 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1044 public membersTableAdapter() {
1045 this.ClearBeforeFill = true;
1046 }
1047
1048 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1049 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1050 protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
1051 get {
1052 if ((this._adapter == null)) {
1053 this.InitAdapter();
1054 }
1055 return this._adapter;
1056 }
1057 }
1058
1059 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1060 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1061 internal global::System.Data.SqlClient.SqlConnection Connection {
1062 get {
1063 if ((this._connection == null)) {
1064 this.InitConnection();
1065 }
1066 return this._connection;
1067 }
1068 set {
1069 this._connection = value;
1070 if ((this.Adapter.InsertCommand != null)) {
1071 this.Adapter.InsertCommand.Connection = value;
1072 }
1073 if ((this.Adapter.DeleteCommand != null)) {
1074 this.Adapter.DeleteCommand.Connection = value;
1075 }
1076 if ((this.Adapter.UpdateCommand != null)) {
1077 this.Adapter.UpdateCommand.Connection = value;
1078 }
1079 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
1080 if ((this.CommandCollection[i] != null)) {
1081 ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
1082 }
1083 }
1084 }
1085 }
1086
1087 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1088 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1089 internal global::System.Data.SqlClient.SqlTransaction Transaction {
1090 get {
1091 return this._transaction;
1092 }
1093 set {
1094 this._transaction = value;
1095 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
1096 this.CommandCollection[i].Transaction = this._transaction;
1097 }
1098 if (((this.Adapter != null)
1099 && (this.Adapter.DeleteCommand != null))) {
1100 this.Adapter.DeleteCommand.Transaction = this._transaction;
1101 }
1102 if (((this.Adapter != null)
1103 && (this.Adapter.InsertCommand != null))) {
1104 this.Adapter.InsertCommand.Transaction = this._transaction;
1105 }
1106 if (((this.Adapter != null)
1107 && (this.Adapter.UpdateCommand != null))) {
1108 this.Adapter.UpdateCommand.Transaction = this._transaction;
1109 }
1110 }
1111 }
1112
1113 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1114 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1115 protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
1116 get {
1117 if ((this._commandCollection == null)) {
1118 this.InitCommandCollection();
1119 }
1120 return this._commandCollection;
1121 }
1122 }
1123
1124 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1125 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1126 public bool ClearBeforeFill {
1127 get {
1128 return this._clearBeforeFill;
1129 }
1130 set {
1131 this._clearBeforeFill = value;
1132 }
1133 }
1134
1135 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1136 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1137 private void InitAdapter() {
1138 this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
1139 global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
1140 tableMapping.SourceTable = "Table";
1141 tableMapping.DataSetTable = "members";
1142 tableMapping.ColumnMappings.Add("m_id", "m_id");
1143 tableMapping.ColumnMappings.Add("f_name", "f_name");
1144 tableMapping.ColumnMappings.Add("l_name", "l_name");
1145 tableMapping.ColumnMappings.Add("gender", "gender");
1146 tableMapping.ColumnMappings.Add("dob", "dob");
1147 tableMapping.ColumnMappings.Add("mobile", "mobile");
1148 tableMapping.ColumnMappings.Add("email", "email");
1149 tableMapping.ColumnMappings.Add("jod", "jod");
1150 tableMapping.ColumnMappings.Add("time", "time");
1151 tableMapping.ColumnMappings.Add("address", "address");
1152 tableMapping.ColumnMappings.Add("mem_time", "mem_time");
1153 this._adapter.TableMappings.Add(tableMapping);
1154 this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
1155 this._adapter.InsertCommand.Connection = this.Connection;
1156 this._adapter.InsertCommand.CommandText = "INSERT INTO [dbo].[members] ([f_name], [l_name], [gender], [dob], [mobile], [emai" +
1157 "l], [jod], [time], [address], [mem_time]) VALUES (@f_name, @l_name, @gender, @do" +
1158 "b, @mobile, @email, @jod, @time, @address, @mem_time)";
1159 this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
1160 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@f_name", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "f_name", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1161 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@l_name", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "l_name", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1162 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@gender", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "gender", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1163 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@dob", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "dob", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1164 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@mobile", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "mobile", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1165 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@email", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "email", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1166 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@jod", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "jod", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1167 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@time", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "time", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1168 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@address", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "address", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1169 this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@mem_time", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "mem_time", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1170 }
1171
1172 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1173 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1174 private void InitConnection() {
1175 this._connection = new global::System.Data.SqlClient.SqlConnection();
1176 this._connection.ConnectionString = global::GymManagementSystem.Properties.Settings.Default.GymConnectionString;
1177 }
1178
1179 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1180 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1181 private void InitCommandCollection() {
1182 this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
1183 this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
1184 this._commandCollection[0].Connection = this.Connection;
1185 this._commandCollection[0].CommandText = "SELECT m_id, f_name, l_name, gender, dob, mobile, email, jod, time, address, mem_" +
1186 "time FROM dbo.members";
1187 this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
1188 }
1189
1190 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1191 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1192 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1193 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
1194 public virtual int Fill(GymDataSet1.membersDataTable dataTable) {
1195 this.Adapter.SelectCommand = this.CommandCollection[0];
1196 if ((this.ClearBeforeFill == true)) {
1197 dataTable.Clear();
1198 }
1199 int returnValue = this.Adapter.Fill(dataTable);
1200 return returnValue;
1201 }
1202
1203 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1204 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1205 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1206 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
1207 public virtual GymDataSet1.membersDataTable GetData() {
1208 this.Adapter.SelectCommand = this.CommandCollection[0];
1209 GymDataSet1.membersDataTable dataTable = new GymDataSet1.membersDataTable();
1210 this.Adapter.Fill(dataTable);
1211 return dataTable;
1212 }
1213
1214 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1215 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1216 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1217 public virtual int Update(GymDataSet1.membersDataTable dataTable) {
1218 return this.Adapter.Update(dataTable);
1219 }
1220
1221 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1222 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1223 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1224 public virtual int Update(GymDataSet1 dataSet) {
1225 return this.Adapter.Update(dataSet, "members");
1226 }
1227
1228 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1229 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1230 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1231 public virtual int Update(global::System.Data.DataRow dataRow) {
1232 return this.Adapter.Update(new global::System.Data.DataRow[] {
1233 dataRow});
1234 }
1235
1236 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1237 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1238 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1239 public virtual int Update(global::System.Data.DataRow[] dataRows) {
1240 return this.Adapter.Update(dataRows);
1241 }
1242
1243 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1244 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1245 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1246 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
1247 public virtual int Insert(string f_name, string l_name, string gender, string dob, string mobile, string email, string jod, string time, string address, string mem_time) {
1248 if ((f_name == null)) {
1249 this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;
1250 }
1251 else {
1252 this.Adapter.InsertCommand.Parameters[0].Value = ((string)(f_name));
1253 }
1254 if ((l_name == null)) {
1255 this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
1256 }
1257 else {
1258 this.Adapter.InsertCommand.Parameters[1].Value = ((string)(l_name));
1259 }
1260 if ((gender == null)) {
1261 this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
1262 }
1263 else {
1264 this.Adapter.InsertCommand.Parameters[2].Value = ((string)(gender));
1265 }
1266 if ((dob == null)) {
1267 this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
1268 }
1269 else {
1270 this.Adapter.InsertCommand.Parameters[3].Value = ((string)(dob));
1271 }
1272 if ((mobile == null)) {
1273 this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
1274 }
1275 else {
1276 this.Adapter.InsertCommand.Parameters[4].Value = ((string)(mobile));
1277 }
1278 if ((email == null)) {
1279 this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
1280 }
1281 else {
1282 this.Adapter.InsertCommand.Parameters[5].Value = ((string)(email));
1283 }
1284 if ((jod == null)) {
1285 this.Adapter.InsertCommand.Parameters[6].Value = global::System.DBNull.Value;
1286 }
1287 else {
1288 this.Adapter.InsertCommand.Parameters[6].Value = ((string)(jod));
1289 }
1290 if ((time == null)) {
1291 this.Adapter.InsertCommand.Parameters[7].Value = global::System.DBNull.Value;
1292 }
1293 else {
1294 this.Adapter.InsertCommand.Parameters[7].Value = ((string)(time));
1295 }
1296 if ((address == null)) {
1297 this.Adapter.InsertCommand.Parameters[8].Value = global::System.DBNull.Value;
1298 }
1299 else {
1300 this.Adapter.InsertCommand.Parameters[8].Value = ((string)(address));
1301 }
1302 if ((mem_time == null)) {
1303 this.Adapter.InsertCommand.Parameters[9].Value = global::System.DBNull.Value;
1304 }
1305 else {
1306 this.Adapter.InsertCommand.Parameters[9].Value = ((string)(mem_time));
1307 }
1308 global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
1309 if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
1310 != global::System.Data.ConnectionState.Open)) {
1311 this.Adapter.InsertCommand.Connection.Open();
1312 }
1313 try {
1314 int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
1315 return returnValue;
1316 }
1317 finally {
1318 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
1319 this.Adapter.InsertCommand.Connection.Close();
1320 }
1321 }
1322 }
1323 }
1324
1325 /// <summary>
1326 ///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
1327 ///</summary>
1328 [global::System.ComponentModel.DesignerCategoryAttribute("code")]
1329 [global::System.ComponentModel.ToolboxItem(true)]
1330 [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
1331 "esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
1332 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
1333 public partial class TableAdapterManager : global::System.ComponentModel.Component {
1334
1335 private UpdateOrderOption _updateOrder;
1336
1337 private membersTableAdapter _membersTableAdapter;
1338
1339 private bool _backupDataSetBeforeUpdate;
1340
1341 private global::System.Data.IDbConnection _connection;
1342
1343 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1344 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1345 public UpdateOrderOption UpdateOrder {
1346 get {
1347 return this._updateOrder;
1348 }
1349 set {
1350 this._updateOrder = value;
1351 }
1352 }
1353
1354 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1355 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1356 [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
1357 "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
1358 "a", "System.Drawing.Design.UITypeEditor")]
1359 public membersTableAdapter membersTableAdapter {
1360 get {
1361 return this._membersTableAdapter;
1362 }
1363 set {
1364 this._membersTableAdapter = value;
1365 }
1366 }
1367
1368 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1369 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1370 public bool BackupDataSetBeforeUpdate {
1371 get {
1372 return this._backupDataSetBeforeUpdate;
1373 }
1374 set {
1375 this._backupDataSetBeforeUpdate = value;
1376 }
1377 }
1378
1379 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1380 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1381 [global::System.ComponentModel.Browsable(false)]
1382 public global::System.Data.IDbConnection Connection {
1383 get {
1384 if ((this._connection != null)) {
1385 return this._connection;
1386 }
1387 if (((this._membersTableAdapter != null)
1388 && (this._membersTableAdapter.Connection != null))) {
1389 return this._membersTableAdapter.Connection;
1390 }
1391 return null;
1392 }
1393 set {
1394 this._connection = value;
1395 }
1396 }
1397
1398 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1399 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1400 [global::System.ComponentModel.Browsable(false)]
1401 public int TableAdapterInstanceCount {
1402 get {
1403 int count = 0;
1404 if ((this._membersTableAdapter != null)) {
1405 count = (count + 1);
1406 }
1407 return count;
1408 }
1409 }
1410
1411 /// <summary>
1412 ///Update rows in top-down order.
1413 ///</summary>
1414 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1415 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1416 private int UpdateUpdatedRows(GymDataSet1 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
1417 int result = 0;
1418 if ((this._membersTableAdapter != null)) {
1419 global::System.Data.DataRow[] updatedRows = dataSet.members.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
1420 updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
1421 if (((updatedRows != null)
1422 && (0 < updatedRows.Length))) {
1423 result = (result + this._membersTableAdapter.Update(updatedRows));
1424 allChangedRows.AddRange(updatedRows);
1425 }
1426 }
1427 return result;
1428 }
1429
1430 /// <summary>
1431 ///Insert rows in top-down order.
1432 ///</summary>
1433 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1434 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1435 private int UpdateInsertedRows(GymDataSet1 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
1436 int result = 0;
1437 if ((this._membersTableAdapter != null)) {
1438 global::System.Data.DataRow[] addedRows = dataSet.members.Select(null, null, global::System.Data.DataViewRowState.Added);
1439 if (((addedRows != null)
1440 && (0 < addedRows.Length))) {
1441 result = (result + this._membersTableAdapter.Update(addedRows));
1442 allAddedRows.AddRange(addedRows);
1443 }
1444 }
1445 return result;
1446 }
1447
1448 /// <summary>
1449 ///Delete rows in bottom-up order.
1450 ///</summary>
1451 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1452 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1453 private int UpdateDeletedRows(GymDataSet1 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows) {
1454 int result = 0;
1455 if ((this._membersTableAdapter != null)) {
1456 global::System.Data.DataRow[] deletedRows = dataSet.members.Select(null, null, global::System.Data.DataViewRowState.Deleted);
1457 if (((deletedRows != null)
1458 && (0 < deletedRows.Length))) {
1459 result = (result + this._membersTableAdapter.Update(deletedRows));
1460 allChangedRows.AddRange(deletedRows);
1461 }
1462 }
1463 return result;
1464 }
1465
1466 /// <summary>
1467 ///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
1468 ///</summary>
1469 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1470 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1471 private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
1472 if (((updatedRows == null)
1473 || (updatedRows.Length < 1))) {
1474 return updatedRows;
1475 }
1476 if (((allAddedRows == null)
1477 || (allAddedRows.Count < 1))) {
1478 return updatedRows;
1479 }
1480 global::System.Collections.Generic.List<global::System.Data.DataRow> realUpdatedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
1481 for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
1482 global::System.Data.DataRow row = updatedRows[i];
1483 if ((allAddedRows.Contains(row) == false)) {
1484 realUpdatedRows.Add(row);
1485 }
1486 }
1487 return realUpdatedRows.ToArray();
1488 }
1489
1490 /// <summary>
1491 ///Update all changes to the dataset.
1492 ///</summary>
1493 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1494 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1495 public virtual int UpdateAll(GymDataSet1 dataSet) {
1496 if ((dataSet == null)) {
1497 throw new global::System.ArgumentNullException("dataSet");
1498 }
1499 if ((dataSet.HasChanges() == false)) {
1500 return 0;
1501 }
1502 if (((this._membersTableAdapter != null)
1503 && (this.MatchTableAdapterConnection(this._membersTableAdapter.Connection) == false))) {
1504 throw new global::System.ArgumentException("All TableAdapters managed by a TableAdapterManager must use the same connection s" +
1505 "tring.");
1506 }
1507 global::System.Data.IDbConnection workConnection = this.Connection;
1508 if ((workConnection == null)) {
1509 throw new global::System.ApplicationException("TableAdapterManager contains no connection information. Set each TableAdapterMana" +
1510 "ger TableAdapter property to a valid TableAdapter instance.");
1511 }
1512 bool workConnOpened = false;
1513 if (((workConnection.State & global::System.Data.ConnectionState.Broken)
1514 == global::System.Data.ConnectionState.Broken)) {
1515 workConnection.Close();
1516 }
1517 if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
1518 workConnection.Open();
1519 workConnOpened = true;
1520 }
1521 global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
1522 if ((workTransaction == null)) {
1523 throw new global::System.ApplicationException("The transaction cannot begin. The current data connection does not support transa" +
1524 "ctions or the current state is not allowing the transaction to begin.");
1525 }
1526 global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
1527 global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
1528 global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter> adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter>();
1529 global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection> revertConnections = new global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection>();
1530 int result = 0;
1531 global::System.Data.DataSet backupDataSet = null;
1532 if (this.BackupDataSetBeforeUpdate) {
1533 backupDataSet = new global::System.Data.DataSet();
1534 backupDataSet.Merge(dataSet);
1535 }
1536 try {
1537 // ---- Prepare for update -----------
1538 //
1539 if ((this._membersTableAdapter != null)) {
1540 revertConnections.Add(this._membersTableAdapter, this._membersTableAdapter.Connection);
1541 this._membersTableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(workConnection));
1542 this._membersTableAdapter.Transaction = ((global::System.Data.SqlClient.SqlTransaction)(workTransaction));
1543 if (this._membersTableAdapter.Adapter.AcceptChangesDuringUpdate) {
1544 this._membersTableAdapter.Adapter.AcceptChangesDuringUpdate = false;
1545 adaptersWithAcceptChangesDuringUpdate.Add(this._membersTableAdapter.Adapter);
1546 }
1547 }
1548 //
1549 //---- Perform updates -----------
1550 //
1551 if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) {
1552 result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
1553 result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
1554 }
1555 else {
1556 result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
1557 result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
1558 }
1559 result = (result + this.UpdateDeletedRows(dataSet, allChangedRows));
1560 //
1561 //---- Commit updates -----------
1562 //
1563 workTransaction.Commit();
1564 if ((0 < allAddedRows.Count)) {
1565 global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
1566 allAddedRows.CopyTo(rows);
1567 for (int i = 0; (i < rows.Length); i = (i + 1)) {
1568 global::System.Data.DataRow row = rows[i];
1569 row.AcceptChanges();
1570 }
1571 }
1572 if ((0 < allChangedRows.Count)) {
1573 global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count];
1574 allChangedRows.CopyTo(rows);
1575 for (int i = 0; (i < rows.Length); i = (i + 1)) {
1576 global::System.Data.DataRow row = rows[i];
1577 row.AcceptChanges();
1578 }
1579 }
1580 }
1581 catch (global::System.Exception ex) {
1582 workTransaction.Rollback();
1583 // ---- Restore the dataset -----------
1584 if (this.BackupDataSetBeforeUpdate) {
1585 global::System.Diagnostics.Debug.Assert((backupDataSet != null));
1586 dataSet.Clear();
1587 dataSet.Merge(backupDataSet);
1588 }
1589 else {
1590 if ((0 < allAddedRows.Count)) {
1591 global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
1592 allAddedRows.CopyTo(rows);
1593 for (int i = 0; (i < rows.Length); i = (i + 1)) {
1594 global::System.Data.DataRow row = rows[i];
1595 row.AcceptChanges();
1596 row.SetAdded();
1597 }
1598 }
1599 }
1600 throw ex;
1601 }
1602 finally {
1603 if (workConnOpened) {
1604 workConnection.Close();
1605 }
1606 if ((this._membersTableAdapter != null)) {
1607 this._membersTableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(revertConnections[this._membersTableAdapter]));
1608 this._membersTableAdapter.Transaction = null;
1609 }
1610 if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) {
1611 global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count];
1612 adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters);
1613 for (int i = 0; (i < adapters.Length); i = (i + 1)) {
1614 global::System.Data.Common.DataAdapter adapter = adapters[i];
1615 adapter.AcceptChangesDuringUpdate = true;
1616 }
1617 }
1618 }
1619 return result;
1620 }
1621
1622 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1623 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1624 protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) {
1625 global::System.Array.Sort<global::System.Data.DataRow>(rows, new SelfReferenceComparer(relation, childFirst));
1626 }
1627
1628 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1629 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1630 protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) {
1631 if ((this._connection != null)) {
1632 return true;
1633 }
1634 if (((this.Connection == null)
1635 || (inputConnection == null))) {
1636 return true;
1637 }
1638 if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) {
1639 return true;
1640 }
1641 return false;
1642 }
1643
1644 /// <summary>
1645 ///Update Order Option
1646 ///</summary>
1647 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1648 public enum UpdateOrderOption {
1649
1650 InsertUpdateDelete = 0,
1651
1652 UpdateInsertDelete = 1,
1653 }
1654
1655 /// <summary>
1656 ///Used to sort self-referenced table's rows
1657 ///</summary>
1658 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1659 private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer<global::System.Data.DataRow> {
1660
1661 private global::System.Data.DataRelation _relation;
1662
1663 private int _childFirst;
1664
1665 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1666 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1667 internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) {
1668 this._relation = relation;
1669 if (childFirst) {
1670 this._childFirst = -1;
1671 }
1672 else {
1673 this._childFirst = 1;
1674 }
1675 }
1676
1677 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1678 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1679 private global::System.Data.DataRow GetRoot(global::System.Data.DataRow row, out int distance) {
1680 global::System.Diagnostics.Debug.Assert((row != null));
1681 global::System.Data.DataRow root = row;
1682 distance = 0;
1683
1684 global::System.Collections.Generic.IDictionary<global::System.Data.DataRow, global::System.Data.DataRow> traversedRows = new global::System.Collections.Generic.Dictionary<global::System.Data.DataRow, global::System.Data.DataRow>();
1685 traversedRows[row] = row;
1686
1687 global::System.Data.DataRow parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
1688 for (
1689 ; ((parent != null)
1690 && (traversedRows.ContainsKey(parent) == false));
1691 ) {
1692 distance = (distance + 1);
1693 root = parent;
1694 traversedRows[parent] = parent;
1695 parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
1696 }
1697
1698 if ((distance == 0)) {
1699 traversedRows.Clear();
1700 traversedRows[row] = row;
1701 parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
1702 for (
1703 ; ((parent != null)
1704 && (traversedRows.ContainsKey(parent) == false));
1705 ) {
1706 distance = (distance + 1);
1707 root = parent;
1708 traversedRows[parent] = parent;
1709 parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
1710 }
1711 }
1712
1713 return root;
1714 }
1715
1716 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1717 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1718 public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) {
1719 if (object.ReferenceEquals(row1, row2)) {
1720 return 0;
1721 }
1722 if ((row1 == null)) {
1723 return -1;
1724 }
1725 if ((row2 == null)) {
1726 return 1;
1727 }
1728
1729 int distance1 = 0;
1730 global::System.Data.DataRow root1 = this.GetRoot(row1, out distance1);
1731
1732 int distance2 = 0;
1733 global::System.Data.DataRow root2 = this.GetRoot(row2, out distance2);
1734
1735 if (object.ReferenceEquals(root1, root2)) {
1736 return (this._childFirst * distance1.CompareTo(distance2));
1737 }
1738 else {
1739 global::System.Diagnostics.Debug.Assert(((root1.Table != null)
1740 && (root2.Table != null)));
1741 if ((root1.Table.Rows.IndexOf(root1) < root2.Table.Rows.IndexOf(root2))) {
1742 return -1;
1743 }
1744 else {
1745 return 1;
1746 }
1747 }
1748 }
1749 }
1750 }
1751 }
1752
1753 #pragma warning restore 1591
