Digimedia86
Gestionnaire d'absences du personnel du réseau MediaTek86
projetcnedDataSet.Designer.cs
1//------------------------------------------------------------------------------
2// <auto-generated>
3// Ce code a été généré par un outil.
4// Version du runtime :4.0.30319.42000
5//
6// Les modifications apportées à ce fichier peuvent provoquer un comportement incorrect et seront perdues si
7// le code est régénéré.
8// </auto-generated>
9//------------------------------------------------------------------------------
10
11#pragma warning disable 1591
12
13namespace MediaTek.DataBase {
14
15
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("projetcnedDataSet")]
24 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
25 public partial class projetcnedDataSet : global::System.Data.DataSet {
26
27 private absenceDataTable tableabsence;
28
29 private motifDataTable tablemotif;
30
31 private personnelDataTable tablepersonnel;
32
33 private responsableDataTable tableresponsable;
34
35 private serviceDataTable tableservice;
36
37 private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
38
39 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
40 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
41 public projetcnedDataSet() {
42 this.BeginInit();
43 this.InitClass();
44 global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
45 base.Tables.CollectionChanged += schemaChangedHandler;
46 base.Relations.CollectionChanged += schemaChangedHandler;
47 this.EndInit();
48 }
49
50 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
51 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
52 protected projetcnedDataSet(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
53 base(info, context, false) {
54 if ((this.IsBinarySerialized(info, context) == true)) {
55 this.InitVars(false);
56 global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
57 this.Tables.CollectionChanged += schemaChangedHandler1;
58 this.Relations.CollectionChanged += schemaChangedHandler1;
59 return;
60 }
61 string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
62 if ((this.DetermineSchemaSerializationMode(info, context) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
63 global::System.Data.DataSet ds = new global::System.Data.DataSet();
64 ds.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
65 if ((ds.Tables["absence"] != null)) {
66 base.Tables.Add(new absenceDataTable(ds.Tables["absence"]));
67 }
68 if ((ds.Tables["motif"] != null)) {
69 base.Tables.Add(new motifDataTable(ds.Tables["motif"]));
70 }
71 if ((ds.Tables["personnel"] != null)) {
72 base.Tables.Add(new personnelDataTable(ds.Tables["personnel"]));
73 }
74 if ((ds.Tables["responsable"] != null)) {
75 base.Tables.Add(new responsableDataTable(ds.Tables["responsable"]));
76 }
77 if ((ds.Tables["service"] != null)) {
78 base.Tables.Add(new serviceDataTable(ds.Tables["service"]));
79 }
80 this.DataSetName = ds.DataSetName;
81 this.Prefix = ds.Prefix;
82 this.Namespace = ds.Namespace;
83 this.Locale = ds.Locale;
84 this.CaseSensitive = ds.CaseSensitive;
85 this.EnforceConstraints = ds.EnforceConstraints;
86 this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
87 this.InitVars();
88 }
89 else {
90 this.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
91 }
92 this.GetSerializationData(info, context);
93 global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
94 base.Tables.CollectionChanged += schemaChangedHandler;
95 this.Relations.CollectionChanged += schemaChangedHandler;
96 }
97
98 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
99 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
100 [global::System.ComponentModel.Browsable(false)]
101 [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
102 public absenceDataTable absence {
103 get {
104 return this.tableabsence;
105 }
106 }
107
108 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
109 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
110 [global::System.ComponentModel.Browsable(false)]
111 [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
112 public motifDataTable motif {
113 get {
114 return this.tablemotif;
115 }
116 }
117
118 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
119 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
120 [global::System.ComponentModel.Browsable(false)]
121 [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
122 public personnelDataTable personnel {
123 get {
124 return this.tablepersonnel;
125 }
126 }
127
128 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
129 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
130 [global::System.ComponentModel.Browsable(false)]
131 [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
132 public responsableDataTable responsable {
133 get {
134 return this.tableresponsable;
135 }
136 }
137
138 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
139 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
140 [global::System.ComponentModel.Browsable(false)]
141 [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
142 public serviceDataTable service {
143 get {
144 return this.tableservice;
145 }
146 }
147
148 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
149 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
150 [global::System.ComponentModel.BrowsableAttribute(true)]
151 [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Visible)]
152 public override global::System.Data.SchemaSerializationMode SchemaSerializationMode {
153 get {
154 return this._schemaSerializationMode;
155 }
156 set {
157 this._schemaSerializationMode = value;
158 }
159 }
160
161 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
162 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
163 [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
164 public new global::System.Data.DataTableCollection Tables {
165 get {
166 return base.Tables;
167 }
168 }
169
170 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
171 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
172 [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
173 public new global::System.Data.DataRelationCollection Relations {
174 get {
175 return base.Relations;
176 }
177 }
178
179 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
180 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
181 protected override void InitializeDerivedDataSet() {
182 this.BeginInit();
183 this.InitClass();
184 this.EndInit();
185 }
186
187 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
188 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
189 public override global::System.Data.DataSet Clone() {
190 projetcnedDataSet cln = ((projetcnedDataSet)(base.Clone()));
191 cln.InitVars();
192 cln.SchemaSerializationMode = this.SchemaSerializationMode;
193 return cln;
194 }
195
196 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
197 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
198 protected override bool ShouldSerializeTables() {
199 return false;
200 }
201
202 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
203 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
204 protected override bool ShouldSerializeRelations() {
205 return false;
206 }
207
208 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
209 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
210 protected override void ReadXmlSerializable(global::System.Xml.XmlReader reader) {
211 if ((this.DetermineSchemaSerializationMode(reader) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
212 this.Reset();
213 global::System.Data.DataSet ds = new global::System.Data.DataSet();
214 ds.ReadXml(reader);
215 if ((ds.Tables["absence"] != null)) {
216 base.Tables.Add(new absenceDataTable(ds.Tables["absence"]));
217 }
218 if ((ds.Tables["motif"] != null)) {
219 base.Tables.Add(new motifDataTable(ds.Tables["motif"]));
220 }
221 if ((ds.Tables["personnel"] != null)) {
222 base.Tables.Add(new personnelDataTable(ds.Tables["personnel"]));
223 }
224 if ((ds.Tables["responsable"] != null)) {
225 base.Tables.Add(new responsableDataTable(ds.Tables["responsable"]));
226 }
227 if ((ds.Tables["service"] != null)) {
228 base.Tables.Add(new serviceDataTable(ds.Tables["service"]));
229 }
230 this.DataSetName = ds.DataSetName;
231 this.Prefix = ds.Prefix;
232 this.Namespace = ds.Namespace;
233 this.Locale = ds.Locale;
234 this.CaseSensitive = ds.CaseSensitive;
235 this.EnforceConstraints = ds.EnforceConstraints;
236 this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
237 this.InitVars();
238 }
239 else {
240 this.ReadXml(reader);
241 this.InitVars();
242 }
243 }
244
245 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
246 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
247 protected override global::System.Xml.Schema.XmlSchema GetSchemaSerializable() {
248 global::System.IO.MemoryStream stream = new global::System.IO.MemoryStream();
249 this.WriteXmlSchema(new global::System.Xml.XmlTextWriter(stream, null));
250 stream.Position = 0;
251 return global::System.Xml.Schema.XmlSchema.Read(new global::System.Xml.XmlTextReader(stream), null);
252 }
253
254 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
255 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
256 internal void InitVars() {
257 this.InitVars(true);
258 }
259
260 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
261 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
262 internal void InitVars(bool initTable) {
263 this.tableabsence = ((absenceDataTable)(base.Tables["absence"]));
264 if ((initTable == true)) {
265 if ((this.tableabsence != null)) {
266 this.tableabsence.InitVars();
267 }
268 }
269 this.tablemotif = ((motifDataTable)(base.Tables["motif"]));
270 if ((initTable == true)) {
271 if ((this.tablemotif != null)) {
272 this.tablemotif.InitVars();
273 }
274 }
275 this.tablepersonnel = ((personnelDataTable)(base.Tables["personnel"]));
276 if ((initTable == true)) {
277 if ((this.tablepersonnel != null)) {
278 this.tablepersonnel.InitVars();
279 }
280 }
281 this.tableresponsable = ((responsableDataTable)(base.Tables["responsable"]));
282 if ((initTable == true)) {
283 if ((this.tableresponsable != null)) {
284 this.tableresponsable.InitVars();
285 }
286 }
287 this.tableservice = ((serviceDataTable)(base.Tables["service"]));
288 if ((initTable == true)) {
289 if ((this.tableservice != null)) {
290 this.tableservice.InitVars();
291 }
292 }
293 }
294
295 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
296 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
297 private void InitClass() {
298 this.DataSetName = "projetcnedDataSet";
299 this.Prefix = "";
300 this.Namespace = "http://tempuri.org/projetcnedDataSet.xsd";
301 this.EnforceConstraints = true;
302 this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
303 this.tableabsence = new absenceDataTable();
304 base.Tables.Add(this.tableabsence);
305 this.tablemotif = new motifDataTable();
306 base.Tables.Add(this.tablemotif);
307 this.tablepersonnel = new personnelDataTable();
308 base.Tables.Add(this.tablepersonnel);
309 this.tableresponsable = new responsableDataTable();
310 base.Tables.Add(this.tableresponsable);
311 this.tableservice = new serviceDataTable();
312 base.Tables.Add(this.tableservice);
313 }
314
315 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
316 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
317 private bool ShouldSerializeabsence() {
318 return false;
319 }
320
321 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
322 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
323 private bool ShouldSerializemotif() {
324 return false;
325 }
326
327 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
328 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
329 private bool ShouldSerializepersonnel() {
330 return false;
331 }
332
333 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
334 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
335 private bool ShouldSerializeresponsable() {
336 return false;
337 }
338
339 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
340 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
341 private bool ShouldSerializeservice() {
342 return false;
343 }
344
345 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
346 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
347 private void SchemaChanged(object sender, global::System.ComponentModel.CollectionChangeEventArgs e) {
348 if ((e.Action == global::System.ComponentModel.CollectionChangeAction.Remove)) {
349 this.InitVars();
350 }
351 }
352
353 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
354 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
355 public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
356 projetcnedDataSet ds = new projetcnedDataSet();
357 global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
358 global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
359 global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
360 any.Namespace = ds.Namespace;
361 sequence.Items.Add(any);
362 type.Particle = sequence;
363 global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
364 if (xs.Contains(dsSchema.TargetNamespace)) {
365 global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
366 global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
367 try {
368 global::System.Xml.Schema.XmlSchema schema = null;
369 dsSchema.Write(s1);
370 for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
371 schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
372 s2.SetLength(0);
373 schema.Write(s2);
374 if ((s1.Length == s2.Length)) {
375 s1.Position = 0;
376 s2.Position = 0;
377 for (; ((s1.Position != s1.Length)
378 && (s1.ReadByte() == s2.ReadByte())); ) {
379 ;
380 }
381 if ((s1.Position == s1.Length)) {
382 return type;
383 }
384 }
385 }
386 }
387 finally {
388 if ((s1 != null)) {
389 s1.Close();
390 }
391 if ((s2 != null)) {
392 s2.Close();
393 }
394 }
395 }
396 xs.Add(dsSchema);
397 return type;
398 }
399
400 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
401 public delegate void absenceRowChangeEventHandler(object sender, absenceRowChangeEvent e);
402
403 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
404 public delegate void motifRowChangeEventHandler(object sender, motifRowChangeEvent e);
405
406 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
407 public delegate void personnelRowChangeEventHandler(object sender, personnelRowChangeEvent e);
408
409 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
410 public delegate void responsableRowChangeEventHandler(object sender, responsableRowChangeEvent e);
411
412 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
413 public delegate void serviceRowChangeEventHandler(object sender, serviceRowChangeEvent e);
414
418 [global::System.Serializable()]
419 [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
420 public partial class absenceDataTable : global::System.Data.TypedTableBase<absenceRow> {
421
422 private global::System.Data.DataColumn columnIDPERSONNEL;
423
424 private global::System.Data.DataColumn columnDATEDEBUT;
425
426 private global::System.Data.DataColumn columnIDMOTIF;
427
428 private global::System.Data.DataColumn columnDATEFIN;
429
430 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
431 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
432 public absenceDataTable() {
433 this.TableName = "absence";
434 this.BeginInit();
435 this.InitClass();
436 this.EndInit();
437 }
438
439 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
440 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
441 internal absenceDataTable(global::System.Data.DataTable table) {
442 this.TableName = table.TableName;
443 if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
444 this.CaseSensitive = table.CaseSensitive;
445 }
446 if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
447 this.Locale = table.Locale;
448 }
449 if ((table.Namespace != table.DataSet.Namespace)) {
450 this.Namespace = table.Namespace;
451 }
452 this.Prefix = table.Prefix;
453 this.MinimumCapacity = table.MinimumCapacity;
454 }
455
456 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
457 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
458 protected absenceDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
459 base(info, context) {
460 this.InitVars();
461 }
462
463 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
464 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
465 public global::System.Data.DataColumn IDPERSONNELColumn {
466 get {
467 return this.columnIDPERSONNEL;
468 }
469 }
470
471 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
472 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
473 public global::System.Data.DataColumn DATEDEBUTColumn {
474 get {
475 return this.columnDATEDEBUT;
476 }
477 }
478
479 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
480 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
481 public global::System.Data.DataColumn IDMOTIFColumn {
482 get {
483 return this.columnIDMOTIF;
484 }
485 }
486
487 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
488 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
489 public global::System.Data.DataColumn DATEFINColumn {
490 get {
491 return this.columnDATEFIN;
492 }
493 }
494
495 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
496 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
497 [global::System.ComponentModel.Browsable(false)]
498 public int Count {
499 get {
500 return this.Rows.Count;
501 }
502 }
503
504 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
505 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
506 public absenceRow this[int index] {
507 get {
508 return ((absenceRow)(this.Rows[index]));
509 }
510 }
511
512 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
513 public event absenceRowChangeEventHandler absenceRowChanging;
514
515 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
516 public event absenceRowChangeEventHandler absenceRowChanged;
517
518 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
519 public event absenceRowChangeEventHandler absenceRowDeleting;
520
521 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
522 public event absenceRowChangeEventHandler absenceRowDeleted;
523
524 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
525 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
526 public void AddabsenceRow(absenceRow row) {
527 this.Rows.Add(row);
528 }
529
530 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
531 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
532 public absenceRow AddabsenceRow(int IDPERSONNEL, System.DateTime DATEDEBUT, int IDMOTIF, System.DateTime DATEFIN) {
533 absenceRow rowabsenceRow = ((absenceRow)(this.NewRow()));
534 object[] columnValuesArray = new object[] {
535 IDPERSONNEL,
536 DATEDEBUT,
537 IDMOTIF,
538 DATEFIN};
539 rowabsenceRow.ItemArray = columnValuesArray;
540 this.Rows.Add(rowabsenceRow);
541 return rowabsenceRow;
542 }
543
544 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
545 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
546 public absenceRow FindByIDPERSONNELDATEDEBUT(int IDPERSONNEL, System.DateTime DATEDEBUT) {
547 return ((absenceRow)(this.Rows.Find(new object[] {
548 IDPERSONNEL,
549 DATEDEBUT})));
550 }
551
552 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
553 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
554 public override global::System.Data.DataTable Clone() {
555 absenceDataTable cln = ((absenceDataTable)(base.Clone()));
556 cln.InitVars();
557 return cln;
558 }
559
560 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
561 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
562 protected override global::System.Data.DataTable CreateInstance() {
563 return new absenceDataTable();
564 }
565
566 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
567 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
568 internal void InitVars() {
569 this.columnIDPERSONNEL = base.Columns["IDPERSONNEL"];
570 this.columnDATEDEBUT = base.Columns["DATEDEBUT"];
571 this.columnIDMOTIF = base.Columns["IDMOTIF"];
572 this.columnDATEFIN = base.Columns["DATEFIN"];
573 }
574
575 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
576 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
577 private void InitClass() {
578 this.columnIDPERSONNEL = new global::System.Data.DataColumn("IDPERSONNEL", typeof(int), null, global::System.Data.MappingType.Element);
579 base.Columns.Add(this.columnIDPERSONNEL);
580 this.columnDATEDEBUT = new global::System.Data.DataColumn("DATEDEBUT", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
581 base.Columns.Add(this.columnDATEDEBUT);
582 this.columnIDMOTIF = new global::System.Data.DataColumn("IDMOTIF", typeof(int), null, global::System.Data.MappingType.Element);
583 base.Columns.Add(this.columnIDMOTIF);
584 this.columnDATEFIN = new global::System.Data.DataColumn("DATEFIN", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
585 base.Columns.Add(this.columnDATEFIN);
586 this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
587 this.columnIDPERSONNEL,
588 this.columnDATEDEBUT}, true));
589 this.columnIDPERSONNEL.AllowDBNull = false;
590 this.columnDATEDEBUT.AllowDBNull = false;
591 this.columnIDMOTIF.AllowDBNull = false;
592 }
593
594 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
595 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
596 public absenceRow NewabsenceRow() {
597 return ((absenceRow)(this.NewRow()));
598 }
599
600 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
601 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
602 protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
603 return new absenceRow(builder);
604 }
605
606 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
607 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
608 protected override global::System.Type GetRowType() {
609 return typeof(absenceRow);
610 }
611
612 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
613 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
614 protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
615 base.OnRowChanged(e);
616 if ((this.absenceRowChanged != null)) {
617 this.absenceRowChanged(this, new absenceRowChangeEvent(((absenceRow)(e.Row)), e.Action));
618 }
619 }
620
621 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
622 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
623 protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
624 base.OnRowChanging(e);
625 if ((this.absenceRowChanging != null)) {
626 this.absenceRowChanging(this, new absenceRowChangeEvent(((absenceRow)(e.Row)), e.Action));
627 }
628 }
629
630 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
631 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
632 protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
633 base.OnRowDeleted(e);
634 if ((this.absenceRowDeleted != null)) {
635 this.absenceRowDeleted(this, new absenceRowChangeEvent(((absenceRow)(e.Row)), e.Action));
636 }
637 }
638
639 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
640 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
641 protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
642 base.OnRowDeleting(e);
643 if ((this.absenceRowDeleting != null)) {
644 this.absenceRowDeleting(this, new absenceRowChangeEvent(((absenceRow)(e.Row)), e.Action));
645 }
646 }
647
648 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
649 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
650 public void RemoveabsenceRow(absenceRow row) {
651 this.Rows.Remove(row);
652 }
653
654 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
655 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
656 public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
657 global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
658 global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
659 projetcnedDataSet ds = new projetcnedDataSet();
660 global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
661 any1.Namespace = "http://www.w3.org/2001/XMLSchema";
662 any1.MinOccurs = new decimal(0);
663 any1.MaxOccurs = decimal.MaxValue;
664 any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
665 sequence.Items.Add(any1);
666 global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
667 any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
668 any2.MinOccurs = new decimal(1);
669 any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
670 sequence.Items.Add(any2);
671 global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
672 attribute1.Name = "namespace";
673 attribute1.FixedValue = ds.Namespace;
674 type.Attributes.Add(attribute1);
675 global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
676 attribute2.Name = "tableTypeName";
677 attribute2.FixedValue = "absenceDataTable";
678 type.Attributes.Add(attribute2);
679 type.Particle = sequence;
680 global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
681 if (xs.Contains(dsSchema.TargetNamespace)) {
682 global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
683 global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
684 try {
685 global::System.Xml.Schema.XmlSchema schema = null;
686 dsSchema.Write(s1);
687 for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
688 schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
689 s2.SetLength(0);
690 schema.Write(s2);
691 if ((s1.Length == s2.Length)) {
692 s1.Position = 0;
693 s2.Position = 0;
694 for (; ((s1.Position != s1.Length)
695 && (s1.ReadByte() == s2.ReadByte())); ) {
696 ;
697 }
698 if ((s1.Position == s1.Length)) {
699 return type;
700 }
701 }
702 }
703 }
704 finally {
705 if ((s1 != null)) {
706 s1.Close();
707 }
708 if ((s2 != null)) {
709 s2.Close();
710 }
711 }
712 }
713 xs.Add(dsSchema);
714 return type;
715 }
716 }
717
721 [global::System.Serializable()]
722 [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
723 public partial class motifDataTable : global::System.Data.TypedTableBase<motifRow> {
724
725 private global::System.Data.DataColumn columnIDMOTIF;
726
727 private global::System.Data.DataColumn columnLIBELLE;
728
729 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
730 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
731 public motifDataTable() {
732 this.TableName = "motif";
733 this.BeginInit();
734 this.InitClass();
735 this.EndInit();
736 }
737
738 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
739 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
740 internal motifDataTable(global::System.Data.DataTable table) {
741 this.TableName = table.TableName;
742 if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
743 this.CaseSensitive = table.CaseSensitive;
744 }
745 if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
746 this.Locale = table.Locale;
747 }
748 if ((table.Namespace != table.DataSet.Namespace)) {
749 this.Namespace = table.Namespace;
750 }
751 this.Prefix = table.Prefix;
752 this.MinimumCapacity = table.MinimumCapacity;
753 }
754
755 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
756 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
757 protected motifDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
758 base(info, context) {
759 this.InitVars();
760 }
761
762 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
763 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
764 public global::System.Data.DataColumn IDMOTIFColumn {
765 get {
766 return this.columnIDMOTIF;
767 }
768 }
769
770 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
771 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
772 public global::System.Data.DataColumn LIBELLEColumn {
773 get {
774 return this.columnLIBELLE;
775 }
776 }
777
778 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
779 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
780 [global::System.ComponentModel.Browsable(false)]
781 public int Count {
782 get {
783 return this.Rows.Count;
784 }
785 }
786
787 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
788 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
789 public motifRow this[int index] {
790 get {
791 return ((motifRow)(this.Rows[index]));
792 }
793 }
794
795 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
796 public event motifRowChangeEventHandler motifRowChanging;
797
798 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
799 public event motifRowChangeEventHandler motifRowChanged;
800
801 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
802 public event motifRowChangeEventHandler motifRowDeleting;
803
804 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
805 public event motifRowChangeEventHandler motifRowDeleted;
806
807 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
808 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
809 public void AddmotifRow(motifRow row) {
810 this.Rows.Add(row);
811 }
812
813 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
814 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
815 public motifRow AddmotifRow(string LIBELLE) {
816 motifRow rowmotifRow = ((motifRow)(this.NewRow()));
817 object[] columnValuesArray = new object[] {
818 null,
819 LIBELLE};
820 rowmotifRow.ItemArray = columnValuesArray;
821 this.Rows.Add(rowmotifRow);
822 return rowmotifRow;
823 }
824
825 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
826 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
827 public motifRow FindByIDMOTIF(int IDMOTIF) {
828 return ((motifRow)(this.Rows.Find(new object[] {
829 IDMOTIF})));
830 }
831
832 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
833 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
834 public override global::System.Data.DataTable Clone() {
835 motifDataTable cln = ((motifDataTable)(base.Clone()));
836 cln.InitVars();
837 return cln;
838 }
839
840 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
841 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
842 protected override global::System.Data.DataTable CreateInstance() {
843 return new motifDataTable();
844 }
845
846 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
847 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
848 internal void InitVars() {
849 this.columnIDMOTIF = base.Columns["IDMOTIF"];
850 this.columnLIBELLE = base.Columns["LIBELLE"];
851 }
852
853 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
854 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
855 private void InitClass() {
856 this.columnIDMOTIF = new global::System.Data.DataColumn("IDMOTIF", typeof(int), null, global::System.Data.MappingType.Element);
857 base.Columns.Add(this.columnIDMOTIF);
858 this.columnLIBELLE = new global::System.Data.DataColumn("LIBELLE", typeof(string), null, global::System.Data.MappingType.Element);
859 base.Columns.Add(this.columnLIBELLE);
860 this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
861 this.columnIDMOTIF}, true));
862 this.columnIDMOTIF.AutoIncrement = true;
863 this.columnIDMOTIF.AutoIncrementSeed = -1;
864 this.columnIDMOTIF.AutoIncrementStep = -1;
865 this.columnIDMOTIF.AllowDBNull = false;
866 this.columnIDMOTIF.Unique = true;
867 this.columnLIBELLE.MaxLength = 128;
868 }
869
870 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
871 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
872 public motifRow NewmotifRow() {
873 return ((motifRow)(this.NewRow()));
874 }
875
876 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
877 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
878 protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
879 return new motifRow(builder);
880 }
881
882 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
883 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
884 protected override global::System.Type GetRowType() {
885 return typeof(motifRow);
886 }
887
888 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
889 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
890 protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
891 base.OnRowChanged(e);
892 if ((this.motifRowChanged != null)) {
893 this.motifRowChanged(this, new motifRowChangeEvent(((motifRow)(e.Row)), e.Action));
894 }
895 }
896
897 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
898 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
899 protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
900 base.OnRowChanging(e);
901 if ((this.motifRowChanging != null)) {
902 this.motifRowChanging(this, new motifRowChangeEvent(((motifRow)(e.Row)), e.Action));
903 }
904 }
905
906 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
907 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
908 protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
909 base.OnRowDeleted(e);
910 if ((this.motifRowDeleted != null)) {
911 this.motifRowDeleted(this, new motifRowChangeEvent(((motifRow)(e.Row)), e.Action));
912 }
913 }
914
915 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
916 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
917 protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
918 base.OnRowDeleting(e);
919 if ((this.motifRowDeleting != null)) {
920 this.motifRowDeleting(this, new motifRowChangeEvent(((motifRow)(e.Row)), e.Action));
921 }
922 }
923
924 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
925 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
926 public void RemovemotifRow(motifRow row) {
927 this.Rows.Remove(row);
928 }
929
930 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
931 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
932 public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
933 global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
934 global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
935 projetcnedDataSet ds = new projetcnedDataSet();
936 global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
937 any1.Namespace = "http://www.w3.org/2001/XMLSchema";
938 any1.MinOccurs = new decimal(0);
939 any1.MaxOccurs = decimal.MaxValue;
940 any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
941 sequence.Items.Add(any1);
942 global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
943 any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
944 any2.MinOccurs = new decimal(1);
945 any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
946 sequence.Items.Add(any2);
947 global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
948 attribute1.Name = "namespace";
949 attribute1.FixedValue = ds.Namespace;
950 type.Attributes.Add(attribute1);
951 global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
952 attribute2.Name = "tableTypeName";
953 attribute2.FixedValue = "motifDataTable";
954 type.Attributes.Add(attribute2);
955 type.Particle = sequence;
956 global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
957 if (xs.Contains(dsSchema.TargetNamespace)) {
958 global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
959 global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
960 try {
961 global::System.Xml.Schema.XmlSchema schema = null;
962 dsSchema.Write(s1);
963 for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
964 schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
965 s2.SetLength(0);
966 schema.Write(s2);
967 if ((s1.Length == s2.Length)) {
968 s1.Position = 0;
969 s2.Position = 0;
970 for (; ((s1.Position != s1.Length)
971 && (s1.ReadByte() == s2.ReadByte())); ) {
972 ;
973 }
974 if ((s1.Position == s1.Length)) {
975 return type;
976 }
977 }
978 }
979 }
980 finally {
981 if ((s1 != null)) {
982 s1.Close();
983 }
984 if ((s2 != null)) {
985 s2.Close();
986 }
987 }
988 }
989 xs.Add(dsSchema);
990 return type;
991 }
992 }
993
997 [global::System.Serializable()]
998 [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
999 public partial class personnelDataTable : global::System.Data.TypedTableBase<personnelRow> {
1000
1001 private global::System.Data.DataColumn columnIDPERSONNEL;
1002
1003 private global::System.Data.DataColumn columnIDSERVICE;
1004
1005 private global::System.Data.DataColumn columnNOM;
1006
1007 private global::System.Data.DataColumn columnPRENOM;
1008
1009 private global::System.Data.DataColumn columnTEL;
1010
1011 private global::System.Data.DataColumn columnMAIL;
1012
1013 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1014 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1015 public personnelDataTable() {
1016 this.TableName = "personnel";
1017 this.BeginInit();
1018 this.InitClass();
1019 this.EndInit();
1020 }
1021
1022 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1023 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1024 internal personnelDataTable(global::System.Data.DataTable table) {
1025 this.TableName = table.TableName;
1026 if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
1027 this.CaseSensitive = table.CaseSensitive;
1028 }
1029 if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
1030 this.Locale = table.Locale;
1031 }
1032 if ((table.Namespace != table.DataSet.Namespace)) {
1033 this.Namespace = table.Namespace;
1034 }
1035 this.Prefix = table.Prefix;
1036 this.MinimumCapacity = table.MinimumCapacity;
1037 }
1038
1039 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1040 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1041 protected personnelDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
1042 base(info, context) {
1043 this.InitVars();
1044 }
1045
1046 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1047 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1048 public global::System.Data.DataColumn IDPERSONNELColumn {
1049 get {
1050 return this.columnIDPERSONNEL;
1051 }
1052 }
1053
1054 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1055 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1056 public global::System.Data.DataColumn IDSERVICEColumn {
1057 get {
1058 return this.columnIDSERVICE;
1059 }
1060 }
1061
1062 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1063 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1064 public global::System.Data.DataColumn NOMColumn {
1065 get {
1066 return this.columnNOM;
1067 }
1068 }
1069
1070 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1071 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1072 public global::System.Data.DataColumn PRENOMColumn {
1073 get {
1074 return this.columnPRENOM;
1075 }
1076 }
1077
1078 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1079 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1080 public global::System.Data.DataColumn TELColumn {
1081 get {
1082 return this.columnTEL;
1083 }
1084 }
1085
1086 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1087 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1088 public global::System.Data.DataColumn MAILColumn {
1089 get {
1090 return this.columnMAIL;
1091 }
1092 }
1093
1094 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1095 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1096 [global::System.ComponentModel.Browsable(false)]
1097 public int Count {
1098 get {
1099 return this.Rows.Count;
1100 }
1101 }
1102
1103 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1104 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1105 public personnelRow this[int index] {
1106 get {
1107 return ((personnelRow)(this.Rows[index]));
1108 }
1109 }
1110
1111 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1112 public event personnelRowChangeEventHandler personnelRowChanging;
1113
1114 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1115 public event personnelRowChangeEventHandler personnelRowChanged;
1116
1117 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1118 public event personnelRowChangeEventHandler personnelRowDeleting;
1119
1120 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1121 public event personnelRowChangeEventHandler personnelRowDeleted;
1122
1123 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1124 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1125 public void AddpersonnelRow(personnelRow row) {
1126 this.Rows.Add(row);
1127 }
1128
1129 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1130 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1131 public personnelRow AddpersonnelRow(int IDSERVICE, string NOM, string PRENOM, string TEL, string MAIL) {
1132 personnelRow rowpersonnelRow = ((personnelRow)(this.NewRow()));
1133 object[] columnValuesArray = new object[] {
1134 null,
1135 IDSERVICE,
1136 NOM,
1137 PRENOM,
1138 TEL,
1139 MAIL};
1140 rowpersonnelRow.ItemArray = columnValuesArray;
1141 this.Rows.Add(rowpersonnelRow);
1142 return rowpersonnelRow;
1143 }
1144
1145 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1146 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1147 public personnelRow FindByIDPERSONNEL(int IDPERSONNEL) {
1148 return ((personnelRow)(this.Rows.Find(new object[] {
1149 IDPERSONNEL})));
1150 }
1151
1152 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1153 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1154 public override global::System.Data.DataTable Clone() {
1155 personnelDataTable cln = ((personnelDataTable)(base.Clone()));
1156 cln.InitVars();
1157 return cln;
1158 }
1159
1160 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1161 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1162 protected override global::System.Data.DataTable CreateInstance() {
1163 return new personnelDataTable();
1164 }
1165
1166 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1167 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1168 internal void InitVars() {
1169 this.columnIDPERSONNEL = base.Columns["IDPERSONNEL"];
1170 this.columnIDSERVICE = base.Columns["IDSERVICE"];
1171 this.columnNOM = base.Columns["NOM"];
1172 this.columnPRENOM = base.Columns["PRENOM"];
1173 this.columnTEL = base.Columns["TEL"];
1174 this.columnMAIL = base.Columns["MAIL"];
1175 }
1176
1177 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1178 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1179 private void InitClass() {
1180 this.columnIDPERSONNEL = new global::System.Data.DataColumn("IDPERSONNEL", typeof(int), null, global::System.Data.MappingType.Element);
1181 base.Columns.Add(this.columnIDPERSONNEL);
1182 this.columnIDSERVICE = new global::System.Data.DataColumn("IDSERVICE", typeof(int), null, global::System.Data.MappingType.Element);
1183 base.Columns.Add(this.columnIDSERVICE);
1184 this.columnNOM = new global::System.Data.DataColumn("NOM", typeof(string), null, global::System.Data.MappingType.Element);
1185 base.Columns.Add(this.columnNOM);
1186 this.columnPRENOM = new global::System.Data.DataColumn("PRENOM", typeof(string), null, global::System.Data.MappingType.Element);
1187 base.Columns.Add(this.columnPRENOM);
1188 this.columnTEL = new global::System.Data.DataColumn("TEL", typeof(string), null, global::System.Data.MappingType.Element);
1189 base.Columns.Add(this.columnTEL);
1190 this.columnMAIL = new global::System.Data.DataColumn("MAIL", typeof(string), null, global::System.Data.MappingType.Element);
1191 base.Columns.Add(this.columnMAIL);
1192 this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
1193 this.columnIDPERSONNEL}, true));
1194 this.columnIDPERSONNEL.AutoIncrement = true;
1195 this.columnIDPERSONNEL.AutoIncrementSeed = -1;
1196 this.columnIDPERSONNEL.AutoIncrementStep = -1;
1197 this.columnIDPERSONNEL.AllowDBNull = false;
1198 this.columnIDPERSONNEL.Unique = true;
1199 this.columnIDSERVICE.AllowDBNull = false;
1200 this.columnNOM.MaxLength = 50;
1201 this.columnPRENOM.MaxLength = 50;
1202 this.columnTEL.MaxLength = 15;
1203 this.columnMAIL.MaxLength = 128;
1204 }
1205
1206 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1207 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1208 public personnelRow NewpersonnelRow() {
1209 return ((personnelRow)(this.NewRow()));
1210 }
1211
1212 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1213 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1214 protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
1215 return new personnelRow(builder);
1216 }
1217
1218 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1219 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1220 protected override global::System.Type GetRowType() {
1221 return typeof(personnelRow);
1222 }
1223
1224 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1225 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1226 protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
1227 base.OnRowChanged(e);
1228 if ((this.personnelRowChanged != null)) {
1229 this.personnelRowChanged(this, new personnelRowChangeEvent(((personnelRow)(e.Row)), e.Action));
1230 }
1231 }
1232
1233 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1234 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1235 protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
1236 base.OnRowChanging(e);
1237 if ((this.personnelRowChanging != null)) {
1238 this.personnelRowChanging(this, new personnelRowChangeEvent(((personnelRow)(e.Row)), e.Action));
1239 }
1240 }
1241
1242 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1243 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1244 protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
1245 base.OnRowDeleted(e);
1246 if ((this.personnelRowDeleted != null)) {
1247 this.personnelRowDeleted(this, new personnelRowChangeEvent(((personnelRow)(e.Row)), e.Action));
1248 }
1249 }
1250
1251 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1252 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1253 protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
1254 base.OnRowDeleting(e);
1255 if ((this.personnelRowDeleting != null)) {
1256 this.personnelRowDeleting(this, new personnelRowChangeEvent(((personnelRow)(e.Row)), e.Action));
1257 }
1258 }
1259
1260 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1261 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1262 public void RemovepersonnelRow(personnelRow row) {
1263 this.Rows.Remove(row);
1264 }
1265
1266 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1267 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1268 public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
1269 global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
1270 global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
1271 projetcnedDataSet ds = new projetcnedDataSet();
1272 global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
1273 any1.Namespace = "http://www.w3.org/2001/XMLSchema";
1274 any1.MinOccurs = new decimal(0);
1275 any1.MaxOccurs = decimal.MaxValue;
1276 any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
1277 sequence.Items.Add(any1);
1278 global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
1279 any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
1280 any2.MinOccurs = new decimal(1);
1281 any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
1282 sequence.Items.Add(any2);
1283 global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
1284 attribute1.Name = "namespace";
1285 attribute1.FixedValue = ds.Namespace;
1286 type.Attributes.Add(attribute1);
1287 global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
1288 attribute2.Name = "tableTypeName";
1289 attribute2.FixedValue = "personnelDataTable";
1290 type.Attributes.Add(attribute2);
1291 type.Particle = sequence;
1292 global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
1293 if (xs.Contains(dsSchema.TargetNamespace)) {
1294 global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
1295 global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
1296 try {
1297 global::System.Xml.Schema.XmlSchema schema = null;
1298 dsSchema.Write(s1);
1299 for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
1300 schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
1301 s2.SetLength(0);
1302 schema.Write(s2);
1303 if ((s1.Length == s2.Length)) {
1304 s1.Position = 0;
1305 s2.Position = 0;
1306 for (; ((s1.Position != s1.Length)
1307 && (s1.ReadByte() == s2.ReadByte())); ) {
1308 ;
1309 }
1310 if ((s1.Position == s1.Length)) {
1311 return type;
1312 }
1313 }
1314 }
1315 }
1316 finally {
1317 if ((s1 != null)) {
1318 s1.Close();
1319 }
1320 if ((s2 != null)) {
1321 s2.Close();
1322 }
1323 }
1324 }
1325 xs.Add(dsSchema);
1326 return type;
1327 }
1328 }
1329
1333 [global::System.Serializable()]
1334 [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
1335 public partial class responsableDataTable : global::System.Data.TypedTableBase<responsableRow> {
1336
1337 private global::System.Data.DataColumn columnlogin;
1338
1339 private global::System.Data.DataColumn columnpwd;
1340
1341 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1342 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1343 public responsableDataTable() {
1344 this.TableName = "responsable";
1345 this.BeginInit();
1346 this.InitClass();
1347 this.EndInit();
1348 }
1349
1350 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1351 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1352 internal responsableDataTable(global::System.Data.DataTable table) {
1353 this.TableName = table.TableName;
1354 if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
1355 this.CaseSensitive = table.CaseSensitive;
1356 }
1357 if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
1358 this.Locale = table.Locale;
1359 }
1360 if ((table.Namespace != table.DataSet.Namespace)) {
1361 this.Namespace = table.Namespace;
1362 }
1363 this.Prefix = table.Prefix;
1364 this.MinimumCapacity = table.MinimumCapacity;
1365 }
1366
1367 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1368 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1369 protected responsableDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
1370 base(info, context) {
1371 this.InitVars();
1372 }
1373
1374 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1375 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1376 public global::System.Data.DataColumn loginColumn {
1377 get {
1378 return this.columnlogin;
1379 }
1380 }
1381
1382 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1383 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1384 public global::System.Data.DataColumn pwdColumn {
1385 get {
1386 return this.columnpwd;
1387 }
1388 }
1389
1390 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1391 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1392 [global::System.ComponentModel.Browsable(false)]
1393 public int Count {
1394 get {
1395 return this.Rows.Count;
1396 }
1397 }
1398
1399 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1400 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1401 public responsableRow this[int index] {
1402 get {
1403 return ((responsableRow)(this.Rows[index]));
1404 }
1405 }
1406
1407 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1408 public event responsableRowChangeEventHandler responsableRowChanging;
1409
1410 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1411 public event responsableRowChangeEventHandler responsableRowChanged;
1412
1413 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1414 public event responsableRowChangeEventHandler responsableRowDeleting;
1415
1416 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1417 public event responsableRowChangeEventHandler responsableRowDeleted;
1418
1419 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1420 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1421 public void AddresponsableRow(responsableRow row) {
1422 this.Rows.Add(row);
1423 }
1424
1425 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1426 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1427 public responsableRow AddresponsableRow(string login, string pwd) {
1428 responsableRow rowresponsableRow = ((responsableRow)(this.NewRow()));
1429 object[] columnValuesArray = new object[] {
1430 login,
1431 pwd};
1432 rowresponsableRow.ItemArray = columnValuesArray;
1433 this.Rows.Add(rowresponsableRow);
1434 return rowresponsableRow;
1435 }
1436
1437 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1438 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1439 public override global::System.Data.DataTable Clone() {
1440 responsableDataTable cln = ((responsableDataTable)(base.Clone()));
1441 cln.InitVars();
1442 return cln;
1443 }
1444
1445 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1446 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1447 protected override global::System.Data.DataTable CreateInstance() {
1448 return new responsableDataTable();
1449 }
1450
1451 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1452 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1453 internal void InitVars() {
1454 this.columnlogin = base.Columns["login"];
1455 this.columnpwd = base.Columns["pwd"];
1456 }
1457
1458 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1459 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1460 private void InitClass() {
1461 this.columnlogin = new global::System.Data.DataColumn("login", typeof(string), null, global::System.Data.MappingType.Element);
1462 base.Columns.Add(this.columnlogin);
1463 this.columnpwd = new global::System.Data.DataColumn("pwd", typeof(string), null, global::System.Data.MappingType.Element);
1464 base.Columns.Add(this.columnpwd);
1465 this.columnlogin.AllowDBNull = false;
1466 this.columnlogin.MaxLength = 256;
1467 this.columnpwd.AllowDBNull = false;
1468 this.columnpwd.MaxLength = 256;
1469 }
1470
1471 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1472 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1473 public responsableRow NewresponsableRow() {
1474 return ((responsableRow)(this.NewRow()));
1475 }
1476
1477 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1478 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1479 protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
1480 return new responsableRow(builder);
1481 }
1482
1483 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1484 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1485 protected override global::System.Type GetRowType() {
1486 return typeof(responsableRow);
1487 }
1488
1489 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1490 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1491 protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
1492 base.OnRowChanged(e);
1493 if ((this.responsableRowChanged != null)) {
1494 this.responsableRowChanged(this, new responsableRowChangeEvent(((responsableRow)(e.Row)), e.Action));
1495 }
1496 }
1497
1498 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1499 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1500 protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
1501 base.OnRowChanging(e);
1502 if ((this.responsableRowChanging != null)) {
1503 this.responsableRowChanging(this, new responsableRowChangeEvent(((responsableRow)(e.Row)), e.Action));
1504 }
1505 }
1506
1507 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1508 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1509 protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
1510 base.OnRowDeleted(e);
1511 if ((this.responsableRowDeleted != null)) {
1512 this.responsableRowDeleted(this, new responsableRowChangeEvent(((responsableRow)(e.Row)), e.Action));
1513 }
1514 }
1515
1516 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1517 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1518 protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
1519 base.OnRowDeleting(e);
1520 if ((this.responsableRowDeleting != null)) {
1521 this.responsableRowDeleting(this, new responsableRowChangeEvent(((responsableRow)(e.Row)), e.Action));
1522 }
1523 }
1524
1525 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1526 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1527 public void RemoveresponsableRow(responsableRow row) {
1528 this.Rows.Remove(row);
1529 }
1530
1531 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1532 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1533 public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
1534 global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
1535 global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
1536 projetcnedDataSet ds = new projetcnedDataSet();
1537 global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
1538 any1.Namespace = "http://www.w3.org/2001/XMLSchema";
1539 any1.MinOccurs = new decimal(0);
1540 any1.MaxOccurs = decimal.MaxValue;
1541 any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
1542 sequence.Items.Add(any1);
1543 global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
1544 any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
1545 any2.MinOccurs = new decimal(1);
1546 any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
1547 sequence.Items.Add(any2);
1548 global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
1549 attribute1.Name = "namespace";
1550 attribute1.FixedValue = ds.Namespace;
1551 type.Attributes.Add(attribute1);
1552 global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
1553 attribute2.Name = "tableTypeName";
1554 attribute2.FixedValue = "responsableDataTable";
1555 type.Attributes.Add(attribute2);
1556 type.Particle = sequence;
1557 global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
1558 if (xs.Contains(dsSchema.TargetNamespace)) {
1559 global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
1560 global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
1561 try {
1562 global::System.Xml.Schema.XmlSchema schema = null;
1563 dsSchema.Write(s1);
1564 for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
1565 schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
1566 s2.SetLength(0);
1567 schema.Write(s2);
1568 if ((s1.Length == s2.Length)) {
1569 s1.Position = 0;
1570 s2.Position = 0;
1571 for (; ((s1.Position != s1.Length)
1572 && (s1.ReadByte() == s2.ReadByte())); ) {
1573 ;
1574 }
1575 if ((s1.Position == s1.Length)) {
1576 return type;
1577 }
1578 }
1579 }
1580 }
1581 finally {
1582 if ((s1 != null)) {
1583 s1.Close();
1584 }
1585 if ((s2 != null)) {
1586 s2.Close();
1587 }
1588 }
1589 }
1590 xs.Add(dsSchema);
1591 return type;
1592 }
1593 }
1594
1598 [global::System.Serializable()]
1599 [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
1600 public partial class serviceDataTable : global::System.Data.TypedTableBase<serviceRow> {
1601
1602 private global::System.Data.DataColumn columnIDSERVICE;
1603
1604 private global::System.Data.DataColumn columnNOM;
1605
1606 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1607 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1608 public serviceDataTable() {
1609 this.TableName = "service";
1610 this.BeginInit();
1611 this.InitClass();
1612 this.EndInit();
1613 }
1614
1615 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1616 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1617 internal serviceDataTable(global::System.Data.DataTable table) {
1618 this.TableName = table.TableName;
1619 if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
1620 this.CaseSensitive = table.CaseSensitive;
1621 }
1622 if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
1623 this.Locale = table.Locale;
1624 }
1625 if ((table.Namespace != table.DataSet.Namespace)) {
1626 this.Namespace = table.Namespace;
1627 }
1628 this.Prefix = table.Prefix;
1629 this.MinimumCapacity = table.MinimumCapacity;
1630 }
1631
1632 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1633 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1634 protected serviceDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
1635 base(info, context) {
1636 this.InitVars();
1637 }
1638
1639 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1640 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1641 public global::System.Data.DataColumn IDSERVICEColumn {
1642 get {
1643 return this.columnIDSERVICE;
1644 }
1645 }
1646
1647 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1648 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1649 public global::System.Data.DataColumn NOMColumn {
1650 get {
1651 return this.columnNOM;
1652 }
1653 }
1654
1655 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1656 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1657 [global::System.ComponentModel.Browsable(false)]
1658 public int Count {
1659 get {
1660 return this.Rows.Count;
1661 }
1662 }
1663
1664 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1665 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1666 public serviceRow this[int index] {
1667 get {
1668 return ((serviceRow)(this.Rows[index]));
1669 }
1670 }
1671
1672 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1673 public event serviceRowChangeEventHandler serviceRowChanging;
1674
1675 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1676 public event serviceRowChangeEventHandler serviceRowChanged;
1677
1678 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1679 public event serviceRowChangeEventHandler serviceRowDeleting;
1680
1681 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1682 public event serviceRowChangeEventHandler serviceRowDeleted;
1683
1684 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1685 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1686 public void AddserviceRow(serviceRow row) {
1687 this.Rows.Add(row);
1688 }
1689
1690 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1691 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1692 public serviceRow AddserviceRow(string NOM) {
1693 serviceRow rowserviceRow = ((serviceRow)(this.NewRow()));
1694 object[] columnValuesArray = new object[] {
1695 null,
1696 NOM};
1697 rowserviceRow.ItemArray = columnValuesArray;
1698 this.Rows.Add(rowserviceRow);
1699 return rowserviceRow;
1700 }
1701
1702 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1703 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1704 public serviceRow FindByIDSERVICE(int IDSERVICE) {
1705 return ((serviceRow)(this.Rows.Find(new object[] {
1706 IDSERVICE})));
1707 }
1708
1709 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1710 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1711 public override global::System.Data.DataTable Clone() {
1712 serviceDataTable cln = ((serviceDataTable)(base.Clone()));
1713 cln.InitVars();
1714 return cln;
1715 }
1716
1717 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1718 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1719 protected override global::System.Data.DataTable CreateInstance() {
1720 return new serviceDataTable();
1721 }
1722
1723 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1724 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1725 internal void InitVars() {
1726 this.columnIDSERVICE = base.Columns["IDSERVICE"];
1727 this.columnNOM = base.Columns["NOM"];
1728 }
1729
1730 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1731 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1732 private void InitClass() {
1733 this.columnIDSERVICE = new global::System.Data.DataColumn("IDSERVICE", typeof(int), null, global::System.Data.MappingType.Element);
1734 base.Columns.Add(this.columnIDSERVICE);
1735 this.columnNOM = new global::System.Data.DataColumn("NOM", typeof(string), null, global::System.Data.MappingType.Element);
1736 base.Columns.Add(this.columnNOM);
1737 this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
1738 this.columnIDSERVICE}, true));
1739 this.columnIDSERVICE.AutoIncrement = true;
1740 this.columnIDSERVICE.AutoIncrementSeed = -1;
1741 this.columnIDSERVICE.AutoIncrementStep = -1;
1742 this.columnIDSERVICE.AllowDBNull = false;
1743 this.columnIDSERVICE.Unique = true;
1744 this.columnNOM.MaxLength = 50;
1745 }
1746
1747 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1748 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1749 public serviceRow NewserviceRow() {
1750 return ((serviceRow)(this.NewRow()));
1751 }
1752
1753 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1754 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1755 protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
1756 return new serviceRow(builder);
1757 }
1758
1759 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1760 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1761 protected override global::System.Type GetRowType() {
1762 return typeof(serviceRow);
1763 }
1764
1765 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1766 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1767 protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
1768 base.OnRowChanged(e);
1769 if ((this.serviceRowChanged != null)) {
1770 this.serviceRowChanged(this, new serviceRowChangeEvent(((serviceRow)(e.Row)), e.Action));
1771 }
1772 }
1773
1774 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1775 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1776 protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
1777 base.OnRowChanging(e);
1778 if ((this.serviceRowChanging != null)) {
1779 this.serviceRowChanging(this, new serviceRowChangeEvent(((serviceRow)(e.Row)), e.Action));
1780 }
1781 }
1782
1783 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1784 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1785 protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
1786 base.OnRowDeleted(e);
1787 if ((this.serviceRowDeleted != null)) {
1788 this.serviceRowDeleted(this, new serviceRowChangeEvent(((serviceRow)(e.Row)), e.Action));
1789 }
1790 }
1791
1792 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1793 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1794 protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
1795 base.OnRowDeleting(e);
1796 if ((this.serviceRowDeleting != null)) {
1797 this.serviceRowDeleting(this, new serviceRowChangeEvent(((serviceRow)(e.Row)), e.Action));
1798 }
1799 }
1800
1801 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1802 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1803 public void RemoveserviceRow(serviceRow row) {
1804 this.Rows.Remove(row);
1805 }
1806
1807 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1808 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1809 public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
1810 global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
1811 global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
1812 projetcnedDataSet ds = new projetcnedDataSet();
1813 global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
1814 any1.Namespace = "http://www.w3.org/2001/XMLSchema";
1815 any1.MinOccurs = new decimal(0);
1816 any1.MaxOccurs = decimal.MaxValue;
1817 any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
1818 sequence.Items.Add(any1);
1819 global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
1820 any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
1821 any2.MinOccurs = new decimal(1);
1822 any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
1823 sequence.Items.Add(any2);
1824 global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
1825 attribute1.Name = "namespace";
1826 attribute1.FixedValue = ds.Namespace;
1827 type.Attributes.Add(attribute1);
1828 global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
1829 attribute2.Name = "tableTypeName";
1830 attribute2.FixedValue = "serviceDataTable";
1831 type.Attributes.Add(attribute2);
1832 type.Particle = sequence;
1833 global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
1834 if (xs.Contains(dsSchema.TargetNamespace)) {
1835 global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
1836 global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
1837 try {
1838 global::System.Xml.Schema.XmlSchema schema = null;
1839 dsSchema.Write(s1);
1840 for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
1841 schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
1842 s2.SetLength(0);
1843 schema.Write(s2);
1844 if ((s1.Length == s2.Length)) {
1845 s1.Position = 0;
1846 s2.Position = 0;
1847 for (; ((s1.Position != s1.Length)
1848 && (s1.ReadByte() == s2.ReadByte())); ) {
1849 ;
1850 }
1851 if ((s1.Position == s1.Length)) {
1852 return type;
1853 }
1854 }
1855 }
1856 }
1857 finally {
1858 if ((s1 != null)) {
1859 s1.Close();
1860 }
1861 if ((s2 != null)) {
1862 s2.Close();
1863 }
1864 }
1865 }
1866 xs.Add(dsSchema);
1867 return type;
1868 }
1869 }
1870
1874 public partial class absenceRow : global::System.Data.DataRow {
1875
1876 private absenceDataTable tableabsence;
1877
1878 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1879 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1880 internal absenceRow(global::System.Data.DataRowBuilder rb) :
1881 base(rb) {
1882 this.tableabsence = ((absenceDataTable)(this.Table));
1883 }
1884
1885 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1886 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1887 public int IDPERSONNEL {
1888 get {
1889 return ((int)(this[this.tableabsence.IDPERSONNELColumn]));
1890 }
1891 set {
1892 this[this.tableabsence.IDPERSONNELColumn] = value;
1893 }
1894 }
1895
1896 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1897 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1898 public System.DateTime DATEDEBUT {
1899 get {
1900 return ((global::System.DateTime)(this[this.tableabsence.DATEDEBUTColumn]));
1901 }
1902 set {
1903 this[this.tableabsence.DATEDEBUTColumn] = value;
1904 }
1905 }
1906
1907 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1908 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1909 public int IDMOTIF {
1910 get {
1911 return ((int)(this[this.tableabsence.IDMOTIFColumn]));
1912 }
1913 set {
1914 this[this.tableabsence.IDMOTIFColumn] = value;
1915 }
1916 }
1917
1918 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1919 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1920 public System.DateTime DATEFIN {
1921 get {
1922 try {
1923 return ((global::System.DateTime)(this[this.tableabsence.DATEFINColumn]));
1924 }
1925 catch (global::System.InvalidCastException e) {
1926 throw new global::System.Data.StrongTypingException("La valeur pour la colonne \'DATEFIN\' dans la table \'absence\' est DBNull.", e);
1927 }
1928 }
1929 set {
1930 this[this.tableabsence.DATEFINColumn] = value;
1931 }
1932 }
1933
1934 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1935 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1936 public bool IsDATEFINNull() {
1937 return this.IsNull(this.tableabsence.DATEFINColumn);
1938 }
1939
1940 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1941 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1942 public void SetDATEFINNull() {
1943 this[this.tableabsence.DATEFINColumn] = global::System.Convert.DBNull;
1944 }
1945 }
1946
1950 public partial class motifRow : global::System.Data.DataRow {
1951
1952 private motifDataTable tablemotif;
1953
1954 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1955 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1956 internal motifRow(global::System.Data.DataRowBuilder rb) :
1957 base(rb) {
1958 this.tablemotif = ((motifDataTable)(this.Table));
1959 }
1960
1961 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1962 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1963 public int IDMOTIF {
1964 get {
1965 return ((int)(this[this.tablemotif.IDMOTIFColumn]));
1966 }
1967 set {
1968 this[this.tablemotif.IDMOTIFColumn] = value;
1969 }
1970 }
1971
1972 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1973 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1974 public string LIBELLE {
1975 get {
1976 try {
1977 return ((string)(this[this.tablemotif.LIBELLEColumn]));
1978 }
1979 catch (global::System.InvalidCastException e) {
1980 throw new global::System.Data.StrongTypingException("La valeur pour la colonne \'LIBELLE\' dans la table \'motif\' est DBNull.", e);
1981 }
1982 }
1983 set {
1984 this[this.tablemotif.LIBELLEColumn] = value;
1985 }
1986 }
1987
1988 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1989 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1990 public bool IsLIBELLENull() {
1991 return this.IsNull(this.tablemotif.LIBELLEColumn);
1992 }
1993
1994 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1995 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
1996 public void SetLIBELLENull() {
1997 this[this.tablemotif.LIBELLEColumn] = global::System.Convert.DBNull;
1998 }
1999 }
2000
2004 public partial class personnelRow : global::System.Data.DataRow {
2005
2006 private personnelDataTable tablepersonnel;
2007
2008 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2009 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2010 internal personnelRow(global::System.Data.DataRowBuilder rb) :
2011 base(rb) {
2012 this.tablepersonnel = ((personnelDataTable)(this.Table));
2013 }
2014
2015 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2016 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2017 public int IDPERSONNEL {
2018 get {
2019 return ((int)(this[this.tablepersonnel.IDPERSONNELColumn]));
2020 }
2021 set {
2022 this[this.tablepersonnel.IDPERSONNELColumn] = value;
2023 }
2024 }
2025
2026 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2027 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2028 public int IDSERVICE {
2029 get {
2030 return ((int)(this[this.tablepersonnel.IDSERVICEColumn]));
2031 }
2032 set {
2033 this[this.tablepersonnel.IDSERVICEColumn] = value;
2034 }
2035 }
2036
2037 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2038 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2039 public string NOM {
2040 get {
2041 try {
2042 return ((string)(this[this.tablepersonnel.NOMColumn]));
2043 }
2044 catch (global::System.InvalidCastException e) {
2045 throw new global::System.Data.StrongTypingException("La valeur pour la colonne \'NOM\' dans la table \'personnel\' est DBNull.", e);
2046 }
2047 }
2048 set {
2049 this[this.tablepersonnel.NOMColumn] = value;
2050 }
2051 }
2052
2053 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2054 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2055 public string PRENOM {
2056 get {
2057 try {
2058 return ((string)(this[this.tablepersonnel.PRENOMColumn]));
2059 }
2060 catch (global::System.InvalidCastException e) {
2061 throw new global::System.Data.StrongTypingException("La valeur pour la colonne \'PRENOM\' dans la table \'personnel\' est DBNull.", e);
2062 }
2063 }
2064 set {
2065 this[this.tablepersonnel.PRENOMColumn] = value;
2066 }
2067 }
2068
2069 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2070 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2071 public string TEL {
2072 get {
2073 try {
2074 return ((string)(this[this.tablepersonnel.TELColumn]));
2075 }
2076 catch (global::System.InvalidCastException e) {
2077 throw new global::System.Data.StrongTypingException("La valeur pour la colonne \'TEL\' dans la table \'personnel\' est DBNull.", e);
2078 }
2079 }
2080 set {
2081 this[this.tablepersonnel.TELColumn] = value;
2082 }
2083 }
2084
2085 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2086 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2087 public string MAIL {
2088 get {
2089 try {
2090 return ((string)(this[this.tablepersonnel.MAILColumn]));
2091 }
2092 catch (global::System.InvalidCastException e) {
2093 throw new global::System.Data.StrongTypingException("La valeur pour la colonne \'MAIL\' dans la table \'personnel\' est DBNull.", e);
2094 }
2095 }
2096 set {
2097 this[this.tablepersonnel.MAILColumn] = value;
2098 }
2099 }
2100
2101 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2102 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2103 public bool IsNOMNull() {
2104 return this.IsNull(this.tablepersonnel.NOMColumn);
2105 }
2106
2107 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2108 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2109 public void SetNOMNull() {
2110 this[this.tablepersonnel.NOMColumn] = global::System.Convert.DBNull;
2111 }
2112
2113 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2114 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2115 public bool IsPRENOMNull() {
2116 return this.IsNull(this.tablepersonnel.PRENOMColumn);
2117 }
2118
2119 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2120 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2121 public void SetPRENOMNull() {
2122 this[this.tablepersonnel.PRENOMColumn] = global::System.Convert.DBNull;
2123 }
2124
2125 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2126 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2127 public bool IsTELNull() {
2128 return this.IsNull(this.tablepersonnel.TELColumn);
2129 }
2130
2131 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2132 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2133 public void SetTELNull() {
2134 this[this.tablepersonnel.TELColumn] = global::System.Convert.DBNull;
2135 }
2136
2137 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2138 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2139 public bool IsMAILNull() {
2140 return this.IsNull(this.tablepersonnel.MAILColumn);
2141 }
2142
2143 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2144 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2145 public void SetMAILNull() {
2146 this[this.tablepersonnel.MAILColumn] = global::System.Convert.DBNull;
2147 }
2148 }
2149
2153 public partial class responsableRow : global::System.Data.DataRow {
2154
2155 private responsableDataTable tableresponsable;
2156
2157 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2158 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2159 internal responsableRow(global::System.Data.DataRowBuilder rb) :
2160 base(rb) {
2161 this.tableresponsable = ((responsableDataTable)(this.Table));
2162 }
2163
2164 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2165 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2166 public string login {
2167 get {
2168 return ((string)(this[this.tableresponsable.loginColumn]));
2169 }
2170 set {
2171 this[this.tableresponsable.loginColumn] = value;
2172 }
2173 }
2174
2175 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2176 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2177 public string pwd {
2178 get {
2179 return ((string)(this[this.tableresponsable.pwdColumn]));
2180 }
2181 set {
2182 this[this.tableresponsable.pwdColumn] = value;
2183 }
2184 }
2185 }
2186
2190 public partial class serviceRow : global::System.Data.DataRow {
2191
2192 private serviceDataTable tableservice;
2193
2194 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2195 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2196 internal serviceRow(global::System.Data.DataRowBuilder rb) :
2197 base(rb) {
2198 this.tableservice = ((serviceDataTable)(this.Table));
2199 }
2200
2201 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2202 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2203 public int IDSERVICE {
2204 get {
2205 return ((int)(this[this.tableservice.IDSERVICEColumn]));
2206 }
2207 set {
2208 this[this.tableservice.IDSERVICEColumn] = value;
2209 }
2210 }
2211
2212 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2213 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2214 public string NOM {
2215 get {
2216 try {
2217 return ((string)(this[this.tableservice.NOMColumn]));
2218 }
2219 catch (global::System.InvalidCastException e) {
2220 throw new global::System.Data.StrongTypingException("La valeur pour la colonne \'NOM\' dans la table \'service\' est DBNull.", e);
2221 }
2222 }
2223 set {
2224 this[this.tableservice.NOMColumn] = value;
2225 }
2226 }
2227
2228 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2229 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2230 public bool IsNOMNull() {
2231 return this.IsNull(this.tableservice.NOMColumn);
2232 }
2233
2234 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2235 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2236 public void SetNOMNull() {
2237 this[this.tableservice.NOMColumn] = global::System.Convert.DBNull;
2238 }
2239 }
2240
2244 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2245 public class absenceRowChangeEvent : global::System.EventArgs {
2246
2247 private absenceRow eventRow;
2248
2249 private global::System.Data.DataRowAction eventAction;
2250
2251 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2252 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2253 public absenceRowChangeEvent(absenceRow row, global::System.Data.DataRowAction action) {
2254 this.eventRow = row;
2255 this.eventAction = action;
2256 }
2257
2258 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2259 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2260 public absenceRow Row {
2261 get {
2262 return this.eventRow;
2263 }
2264 }
2265
2266 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2267 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2268 public global::System.Data.DataRowAction Action {
2269 get {
2270 return this.eventAction;
2271 }
2272 }
2273 }
2274
2278 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2279 public class motifRowChangeEvent : global::System.EventArgs {
2280
2281 private motifRow eventRow;
2282
2283 private global::System.Data.DataRowAction eventAction;
2284
2285 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2286 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2287 public motifRowChangeEvent(motifRow row, global::System.Data.DataRowAction action) {
2288 this.eventRow = row;
2289 this.eventAction = action;
2290 }
2291
2292 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2293 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2294 public motifRow Row {
2295 get {
2296 return this.eventRow;
2297 }
2298 }
2299
2300 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2301 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2302 public global::System.Data.DataRowAction Action {
2303 get {
2304 return this.eventAction;
2305 }
2306 }
2307 }
2308
2312 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2313 public class personnelRowChangeEvent : global::System.EventArgs {
2314
2315 private personnelRow eventRow;
2316
2317 private global::System.Data.DataRowAction eventAction;
2318
2319 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2320 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2321 public personnelRowChangeEvent(personnelRow row, global::System.Data.DataRowAction action) {
2322 this.eventRow = row;
2323 this.eventAction = action;
2324 }
2325
2326 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2327 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2328 public personnelRow Row {
2329 get {
2330 return this.eventRow;
2331 }
2332 }
2333
2334 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2335 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2336 public global::System.Data.DataRowAction Action {
2337 get {
2338 return this.eventAction;
2339 }
2340 }
2341 }
2342
2346 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2347 public class responsableRowChangeEvent : global::System.EventArgs {
2348
2349 private responsableRow eventRow;
2350
2351 private global::System.Data.DataRowAction eventAction;
2352
2353 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2354 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2355 public responsableRowChangeEvent(responsableRow row, global::System.Data.DataRowAction action) {
2356 this.eventRow = row;
2357 this.eventAction = action;
2358 }
2359
2360 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2361 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2362 public responsableRow Row {
2363 get {
2364 return this.eventRow;
2365 }
2366 }
2367
2368 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2369 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2370 public global::System.Data.DataRowAction Action {
2371 get {
2372 return this.eventAction;
2373 }
2374 }
2375 }
2376
2380 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2381 public class serviceRowChangeEvent : global::System.EventArgs {
2382
2383 private serviceRow eventRow;
2384
2385 private global::System.Data.DataRowAction eventAction;
2386
2387 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2388 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2389 public serviceRowChangeEvent(serviceRow row, global::System.Data.DataRowAction action) {
2390 this.eventRow = row;
2391 this.eventAction = action;
2392 }
2393
2394 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2395 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2396 public serviceRow Row {
2397 get {
2398 return this.eventRow;
2399 }
2400 }
2401
2402 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2403 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2404 public global::System.Data.DataRowAction Action {
2405 get {
2406 return this.eventAction;
2407 }
2408 }
2409 }
2410 }
2411}
2412namespace MediaTek.DataBase.projetcnedDataSetTableAdapters {
2413
2414
2418 [global::System.ComponentModel.DesignerCategoryAttribute("code")]
2419 [global::System.ComponentModel.ToolboxItem(true)]
2420 [global::System.ComponentModel.DataObjectAttribute(true)]
2421 [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
2422 ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
2423 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
2424 public partial class absenceTableAdapter : global::System.ComponentModel.Component {
2425
2426 private global::MySql.Data.MySqlClient.MySqlDataAdapter _adapter;
2427
2428 private global::MySql.Data.MySqlClient.MySqlConnection _connection;
2429
2430 private global::MySql.Data.MySqlClient.MySqlTransaction _transaction;
2431
2432 private global::MySql.Data.MySqlClient.MySqlCommand[] _commandCollection;
2433
2434 private bool _clearBeforeFill;
2435
2436 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2437 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2438 public absenceTableAdapter() {
2439 this.ClearBeforeFill = true;
2440 }
2441
2442 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2443 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2444 protected internal global::MySql.Data.MySqlClient.MySqlDataAdapter Adapter {
2445 get {
2446 if ((this._adapter == null)) {
2447 this.InitAdapter();
2448 }
2449 return this._adapter;
2450 }
2451 }
2452
2453 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2454 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2455 internal global::MySql.Data.MySqlClient.MySqlConnection Connection {
2456 get {
2457 if ((this._connection == null)) {
2458 this.InitConnection();
2459 }
2460 return this._connection;
2461 }
2462 set {
2463 this._connection = value;
2464 if ((this.Adapter.InsertCommand != null)) {
2465 this.Adapter.InsertCommand.Connection = value;
2466 }
2467 if ((this.Adapter.DeleteCommand != null)) {
2468 this.Adapter.DeleteCommand.Connection = value;
2469 }
2470 if ((this.Adapter.UpdateCommand != null)) {
2471 this.Adapter.UpdateCommand.Connection = value;
2472 }
2473 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
2474 if ((this.CommandCollection[i] != null)) {
2475 ((global::MySql.Data.MySqlClient.MySqlCommand)(this.CommandCollection[i])).Connection = value;
2476 }
2477 }
2478 }
2479 }
2480
2481 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2482 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2483 internal global::MySql.Data.MySqlClient.MySqlTransaction Transaction {
2484 get {
2485 return this._transaction;
2486 }
2487 set {
2488 this._transaction = value;
2489 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
2490 this.CommandCollection[i].Transaction = this._transaction;
2491 }
2492 if (((this.Adapter != null)
2493 && (this.Adapter.DeleteCommand != null))) {
2494 this.Adapter.DeleteCommand.Transaction = this._transaction;
2495 }
2496 if (((this.Adapter != null)
2497 && (this.Adapter.InsertCommand != null))) {
2498 this.Adapter.InsertCommand.Transaction = this._transaction;
2499 }
2500 if (((this.Adapter != null)
2501 && (this.Adapter.UpdateCommand != null))) {
2502 this.Adapter.UpdateCommand.Transaction = this._transaction;
2503 }
2504 }
2505 }
2506
2507 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2508 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2509 protected global::MySql.Data.MySqlClient.MySqlCommand[] CommandCollection {
2510 get {
2511 if ((this._commandCollection == null)) {
2512 this.InitCommandCollection();
2513 }
2514 return this._commandCollection;
2515 }
2516 }
2517
2518 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2519 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2520 public bool ClearBeforeFill {
2521 get {
2522 return this._clearBeforeFill;
2523 }
2524 set {
2525 this._clearBeforeFill = value;
2526 }
2527 }
2528
2529 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2530 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2531 private void InitAdapter() {
2532 this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
2533 global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
2534 tableMapping.SourceTable = "Table";
2535 tableMapping.DataSetTable = "absence";
2536 tableMapping.ColumnMappings.Add("IDPERSONNEL", "IDPERSONNEL");
2537 tableMapping.ColumnMappings.Add("DATEDEBUT", "DATEDEBUT");
2538 tableMapping.ColumnMappings.Add("IDMOTIF", "IDMOTIF");
2539 tableMapping.ColumnMappings.Add("DATEFIN", "DATEFIN");
2540 this._adapter.TableMappings.Add(tableMapping);
2541 this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
2542 this._adapter.DeleteCommand.Connection = this.Connection;
2543 this._adapter.DeleteCommand.CommandText = "DELETE FROM `absence` WHERE ((`IDPERSONNEL` = @p1) AND (`DATEDEBUT` = @p2) AND (`" +
2544 "IDMOTIF` = @p3) AND ((@p4 = 1 AND `DATEFIN` IS NULL) OR (`DATEFIN` = @p5)))";
2545 this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
2546 global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
2547 param.ParameterName = "@p1";
2548 param.DbType = global::System.Data.DbType.Int32;
2549 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
2550 param.IsNullable = true;
2551 param.SourceColumn = "IDPERSONNEL";
2552 param.SourceVersion = global::System.Data.DataRowVersion.Original;
2553 this._adapter.DeleteCommand.Parameters.Add(param);
2554 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2555 param.ParameterName = "@p2";
2556 param.DbType = global::System.Data.DbType.DateTime;
2557 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
2558 param.IsNullable = true;
2559 param.SourceColumn = "DATEDEBUT";
2560 param.SourceVersion = global::System.Data.DataRowVersion.Original;
2561 this._adapter.DeleteCommand.Parameters.Add(param);
2562 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2563 param.ParameterName = "@p3";
2564 param.DbType = global::System.Data.DbType.Int32;
2565 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
2566 param.IsNullable = true;
2567 param.SourceColumn = "IDMOTIF";
2568 param.SourceVersion = global::System.Data.DataRowVersion.Original;
2569 this._adapter.DeleteCommand.Parameters.Add(param);
2570 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2571 param.ParameterName = "@p4";
2572 param.DbType = global::System.Data.DbType.Int32;
2573 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
2574 param.IsNullable = true;
2575 param.SourceColumn = "DATEFIN";
2576 param.SourceVersion = global::System.Data.DataRowVersion.Original;
2577 param.SourceColumnNullMapping = true;
2578 this._adapter.DeleteCommand.Parameters.Add(param);
2579 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2580 param.ParameterName = "@p5";
2581 param.DbType = global::System.Data.DbType.DateTime;
2582 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
2583 param.IsNullable = true;
2584 param.SourceColumn = "DATEFIN";
2585 param.SourceVersion = global::System.Data.DataRowVersion.Original;
2586 this._adapter.DeleteCommand.Parameters.Add(param);
2587 this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
2588 this._adapter.InsertCommand.Connection = this.Connection;
2589 this._adapter.InsertCommand.CommandText = "INSERT INTO `absence` (`IDPERSONNEL`, `DATEDEBUT`, `IDMOTIF`, `DATEFIN`) VALUES (" +
2590 "@p1, @p2, @p3, @p4)";
2591 this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
2592 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2593 param.ParameterName = "@p1";
2594 param.DbType = global::System.Data.DbType.Int32;
2595 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
2596 param.IsNullable = true;
2597 param.SourceColumn = "IDPERSONNEL";
2598 param.SourceVersion = global::System.Data.DataRowVersion.Current;
2599 this._adapter.InsertCommand.Parameters.Add(param);
2600 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2601 param.ParameterName = "@p2";
2602 param.DbType = global::System.Data.DbType.DateTime;
2603 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
2604 param.IsNullable = true;
2605 param.SourceColumn = "DATEDEBUT";
2606 param.SourceVersion = global::System.Data.DataRowVersion.Current;
2607 this._adapter.InsertCommand.Parameters.Add(param);
2608 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2609 param.ParameterName = "@p3";
2610 param.DbType = global::System.Data.DbType.Int32;
2611 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
2612 param.IsNullable = true;
2613 param.SourceColumn = "IDMOTIF";
2614 param.SourceVersion = global::System.Data.DataRowVersion.Current;
2615 this._adapter.InsertCommand.Parameters.Add(param);
2616 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2617 param.ParameterName = "@p4";
2618 param.DbType = global::System.Data.DbType.DateTime;
2619 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
2620 param.IsNullable = true;
2621 param.SourceColumn = "DATEFIN";
2622 param.SourceVersion = global::System.Data.DataRowVersion.Current;
2623 this._adapter.InsertCommand.Parameters.Add(param);
2624 this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
2625 this._adapter.UpdateCommand.Connection = this.Connection;
2626 this._adapter.UpdateCommand.CommandText = "UPDATE `absence` SET `IDPERSONNEL` = @p1, `DATEDEBUT` = @p2, `IDMOTIF` = @p3, `DA" +
2627 "TEFIN` = @p4 WHERE ((`IDPERSONNEL` = @p5) AND (`DATEDEBUT` = @p6) AND (`IDMOTIF`" +
2628 " = @p7) AND ((@p8 = 1 AND `DATEFIN` IS NULL) OR (`DATEFIN` = @p9)))";
2629 this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
2630 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2631 param.ParameterName = "@p1";
2632 param.DbType = global::System.Data.DbType.Int32;
2633 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
2634 param.IsNullable = true;
2635 param.SourceColumn = "IDPERSONNEL";
2636 param.SourceVersion = global::System.Data.DataRowVersion.Current;
2637 this._adapter.UpdateCommand.Parameters.Add(param);
2638 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2639 param.ParameterName = "@p2";
2640 param.DbType = global::System.Data.DbType.DateTime;
2641 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
2642 param.IsNullable = true;
2643 param.SourceColumn = "DATEDEBUT";
2644 param.SourceVersion = global::System.Data.DataRowVersion.Current;
2645 this._adapter.UpdateCommand.Parameters.Add(param);
2646 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2647 param.ParameterName = "@p3";
2648 param.DbType = global::System.Data.DbType.Int32;
2649 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
2650 param.IsNullable = true;
2651 param.SourceColumn = "IDMOTIF";
2652 param.SourceVersion = global::System.Data.DataRowVersion.Current;
2653 this._adapter.UpdateCommand.Parameters.Add(param);
2654 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2655 param.ParameterName = "@p4";
2656 param.DbType = global::System.Data.DbType.DateTime;
2657 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
2658 param.IsNullable = true;
2659 param.SourceColumn = "DATEFIN";
2660 param.SourceVersion = global::System.Data.DataRowVersion.Current;
2661 this._adapter.UpdateCommand.Parameters.Add(param);
2662 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2663 param.ParameterName = "@p5";
2664 param.DbType = global::System.Data.DbType.Int32;
2665 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
2666 param.IsNullable = true;
2667 param.SourceColumn = "IDPERSONNEL";
2668 param.SourceVersion = global::System.Data.DataRowVersion.Original;
2669 this._adapter.UpdateCommand.Parameters.Add(param);
2670 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2671 param.ParameterName = "@p6";
2672 param.DbType = global::System.Data.DbType.DateTime;
2673 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
2674 param.IsNullable = true;
2675 param.SourceColumn = "DATEDEBUT";
2676 param.SourceVersion = global::System.Data.DataRowVersion.Original;
2677 this._adapter.UpdateCommand.Parameters.Add(param);
2678 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2679 param.ParameterName = "@p7";
2680 param.DbType = global::System.Data.DbType.Int32;
2681 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
2682 param.IsNullable = true;
2683 param.SourceColumn = "IDMOTIF";
2684 param.SourceVersion = global::System.Data.DataRowVersion.Original;
2685 this._adapter.UpdateCommand.Parameters.Add(param);
2686 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2687 param.ParameterName = "@p8";
2688 param.DbType = global::System.Data.DbType.Int32;
2689 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
2690 param.IsNullable = true;
2691 param.SourceColumn = "DATEFIN";
2692 param.SourceVersion = global::System.Data.DataRowVersion.Original;
2693 param.SourceColumnNullMapping = true;
2694 this._adapter.UpdateCommand.Parameters.Add(param);
2695 param = new global::MySql.Data.MySqlClient.MySqlParameter();
2696 param.ParameterName = "@p9";
2697 param.DbType = global::System.Data.DbType.DateTime;
2698 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.DateTime;
2699 param.IsNullable = true;
2700 param.SourceColumn = "DATEFIN";
2701 param.SourceVersion = global::System.Data.DataRowVersion.Original;
2702 this._adapter.UpdateCommand.Parameters.Add(param);
2703 }
2704
2705 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2706 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2707 private void InitConnection() {
2708 this._connection = new global::MySql.Data.MySqlClient.MySqlConnection();
2709 this._connection.ConnectionString = global::MediaTek.Properties.Settings.Default.projetcnedConnectionString;
2710 }
2711
2712 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2713 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2714 private void InitCommandCollection() {
2715 this._commandCollection = new global::MySql.Data.MySqlClient.MySqlCommand[1];
2716 this._commandCollection[0] = new global::MySql.Data.MySqlClient.MySqlCommand();
2717 this._commandCollection[0].Connection = this.Connection;
2718 this._commandCollection[0].CommandText = "SELECT `IDPERSONNEL`, `DATEDEBUT`, `IDMOTIF`, `DATEFIN` FROM `absence`";
2719 this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
2720 }
2721
2722 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2723 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2724 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
2725 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
2726 public virtual int Fill(projetcnedDataSet.absenceDataTable dataTable) {
2727 this.Adapter.SelectCommand = this.CommandCollection[0];
2728 if ((this.ClearBeforeFill == true)) {
2729 dataTable.Clear();
2730 }
2731 int returnValue = this.Adapter.Fill(dataTable);
2732 return returnValue;
2733 }
2734
2735 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2736 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2737 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
2738 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
2739 public virtual projetcnedDataSet.absenceDataTable GetData() {
2740 this.Adapter.SelectCommand = this.CommandCollection[0];
2741 projetcnedDataSet.absenceDataTable dataTable = new projetcnedDataSet.absenceDataTable();
2742 this.Adapter.Fill(dataTable);
2743 return dataTable;
2744 }
2745
2746 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2747 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2748 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
2749 public virtual int Update(projetcnedDataSet.absenceDataTable dataTable) {
2750 return this.Adapter.Update(dataTable);
2751 }
2752
2753 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2754 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2755 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
2756 public virtual int Update(projetcnedDataSet dataSet) {
2757 return this.Adapter.Update(dataSet, "absence");
2758 }
2759
2760 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2761 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2762 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
2763 public virtual int Update(global::System.Data.DataRow dataRow) {
2764 return this.Adapter.Update(new global::System.Data.DataRow[] {
2765 dataRow});
2766 }
2767
2768 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2769 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2770 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
2771 public virtual int Update(global::System.Data.DataRow[] dataRows) {
2772 return this.Adapter.Update(dataRows);
2773 }
2774
2775 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2776 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2777 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
2778 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)]
2779 public virtual int Delete(int p1, System.DateTime p2, int p3, global::System.Nullable<global::System.DateTime> p5) {
2780 this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(p1));
2781 this.Adapter.DeleteCommand.Parameters[1].Value = ((System.DateTime)(p2));
2782 this.Adapter.DeleteCommand.Parameters[2].Value = ((int)(p3));
2783 if ((p5.HasValue == true)) {
2784 this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0));
2785 this.Adapter.DeleteCommand.Parameters[4].Value = ((System.DateTime)(p5.Value));
2786 }
2787 else {
2788 this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(1));
2789 this.Adapter.DeleteCommand.Parameters[4].Value = global::System.DBNull.Value;
2790 }
2791 global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
2792 if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
2793 != global::System.Data.ConnectionState.Open)) {
2794 this.Adapter.DeleteCommand.Connection.Open();
2795 }
2796 try {
2797 int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
2798 return returnValue;
2799 }
2800 finally {
2801 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
2802 this.Adapter.DeleteCommand.Connection.Close();
2803 }
2804 }
2805 }
2806
2807 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2808 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2809 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
2810 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
2811 public virtual int Insert(int p1, System.DateTime p2, int p3, global::System.Nullable<global::System.DateTime> p4) {
2812 this.Adapter.InsertCommand.Parameters[0].Value = ((int)(p1));
2813 this.Adapter.InsertCommand.Parameters[1].Value = ((System.DateTime)(p2));
2814 this.Adapter.InsertCommand.Parameters[2].Value = ((int)(p3));
2815 if ((p4.HasValue == true)) {
2816 this.Adapter.InsertCommand.Parameters[3].Value = ((System.DateTime)(p4.Value));
2817 }
2818 else {
2819 this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
2820 }
2821 global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
2822 if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
2823 != global::System.Data.ConnectionState.Open)) {
2824 this.Adapter.InsertCommand.Connection.Open();
2825 }
2826 try {
2827 int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
2828 return returnValue;
2829 }
2830 finally {
2831 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
2832 this.Adapter.InsertCommand.Connection.Close();
2833 }
2834 }
2835 }
2836
2837 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2838 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2839 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
2840 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
2841 public virtual int Update(int p1, System.DateTime p2, int p3, global::System.Nullable<global::System.DateTime> p4, int p5, System.DateTime p6, int p7, global::System.Nullable<global::System.DateTime> p9) {
2842 this.Adapter.UpdateCommand.Parameters[0].Value = ((int)(p1));
2843 this.Adapter.UpdateCommand.Parameters[1].Value = ((System.DateTime)(p2));
2844 this.Adapter.UpdateCommand.Parameters[2].Value = ((int)(p3));
2845 if ((p4.HasValue == true)) {
2846 this.Adapter.UpdateCommand.Parameters[3].Value = ((System.DateTime)(p4.Value));
2847 }
2848 else {
2849 this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
2850 }
2851 this.Adapter.UpdateCommand.Parameters[4].Value = ((int)(p5));
2852 this.Adapter.UpdateCommand.Parameters[5].Value = ((System.DateTime)(p6));
2853 this.Adapter.UpdateCommand.Parameters[6].Value = ((int)(p7));
2854 if ((p9.HasValue == true)) {
2855 this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(0));
2856 this.Adapter.UpdateCommand.Parameters[8].Value = ((System.DateTime)(p9.Value));
2857 }
2858 else {
2859 this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(1));
2860 this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value;
2861 }
2862 global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
2863 if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
2864 != global::System.Data.ConnectionState.Open)) {
2865 this.Adapter.UpdateCommand.Connection.Open();
2866 }
2867 try {
2868 int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
2869 return returnValue;
2870 }
2871 finally {
2872 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
2873 this.Adapter.UpdateCommand.Connection.Close();
2874 }
2875 }
2876 }
2877
2878 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2879 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2880 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
2881 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
2882 public virtual int Update(int p3, global::System.Nullable<global::System.DateTime> p4, int p5, System.DateTime p6, int p7, global::System.Nullable<global::System.DateTime> p9) {
2883 return this.Update(p5, p6, p3, p4, p5, p6, p7, p9);
2884 }
2885 }
2886
2890 [global::System.ComponentModel.DesignerCategoryAttribute("code")]
2891 [global::System.ComponentModel.ToolboxItem(true)]
2892 [global::System.ComponentModel.DataObjectAttribute(true)]
2893 [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
2894 ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
2895 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
2896 public partial class motifTableAdapter : global::System.ComponentModel.Component {
2897
2898 private global::MySql.Data.MySqlClient.MySqlDataAdapter _adapter;
2899
2900 private global::MySql.Data.MySqlClient.MySqlConnection _connection;
2901
2902 private global::MySql.Data.MySqlClient.MySqlTransaction _transaction;
2903
2904 private global::MySql.Data.MySqlClient.MySqlCommand[] _commandCollection;
2905
2906 private bool _clearBeforeFill;
2907
2908 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2909 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2910 public motifTableAdapter() {
2911 this.ClearBeforeFill = true;
2912 }
2913
2914 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2915 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2916 protected internal global::MySql.Data.MySqlClient.MySqlDataAdapter Adapter {
2917 get {
2918 if ((this._adapter == null)) {
2919 this.InitAdapter();
2920 }
2921 return this._adapter;
2922 }
2923 }
2924
2925 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2926 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2927 internal global::MySql.Data.MySqlClient.MySqlConnection Connection {
2928 get {
2929 if ((this._connection == null)) {
2930 this.InitConnection();
2931 }
2932 return this._connection;
2933 }
2934 set {
2935 this._connection = value;
2936 if ((this.Adapter.InsertCommand != null)) {
2937 this.Adapter.InsertCommand.Connection = value;
2938 }
2939 if ((this.Adapter.DeleteCommand != null)) {
2940 this.Adapter.DeleteCommand.Connection = value;
2941 }
2942 if ((this.Adapter.UpdateCommand != null)) {
2943 this.Adapter.UpdateCommand.Connection = value;
2944 }
2945 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
2946 if ((this.CommandCollection[i] != null)) {
2947 ((global::MySql.Data.MySqlClient.MySqlCommand)(this.CommandCollection[i])).Connection = value;
2948 }
2949 }
2950 }
2951 }
2952
2953 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2954 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2955 internal global::MySql.Data.MySqlClient.MySqlTransaction Transaction {
2956 get {
2957 return this._transaction;
2958 }
2959 set {
2960 this._transaction = value;
2961 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
2962 this.CommandCollection[i].Transaction = this._transaction;
2963 }
2964 if (((this.Adapter != null)
2965 && (this.Adapter.DeleteCommand != null))) {
2966 this.Adapter.DeleteCommand.Transaction = this._transaction;
2967 }
2968 if (((this.Adapter != null)
2969 && (this.Adapter.InsertCommand != null))) {
2970 this.Adapter.InsertCommand.Transaction = this._transaction;
2971 }
2972 if (((this.Adapter != null)
2973 && (this.Adapter.UpdateCommand != null))) {
2974 this.Adapter.UpdateCommand.Transaction = this._transaction;
2975 }
2976 }
2977 }
2978
2979 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2980 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2981 protected global::MySql.Data.MySqlClient.MySqlCommand[] CommandCollection {
2982 get {
2983 if ((this._commandCollection == null)) {
2984 this.InitCommandCollection();
2985 }
2986 return this._commandCollection;
2987 }
2988 }
2989
2990 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2991 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
2992 public bool ClearBeforeFill {
2993 get {
2994 return this._clearBeforeFill;
2995 }
2996 set {
2997 this._clearBeforeFill = value;
2998 }
2999 }
3000
3001 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3002 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3003 private void InitAdapter() {
3004 this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
3005 global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
3006 tableMapping.SourceTable = "Table";
3007 tableMapping.DataSetTable = "motif";
3008 tableMapping.ColumnMappings.Add("IDMOTIF", "IDMOTIF");
3009 tableMapping.ColumnMappings.Add("LIBELLE", "LIBELLE");
3010 this._adapter.TableMappings.Add(tableMapping);
3011 this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
3012 this._adapter.DeleteCommand.Connection = this.Connection;
3013 this._adapter.DeleteCommand.CommandText = "DELETE FROM `motif` WHERE ((`IDMOTIF` = @p1) AND ((@p2 = 1 AND `LIBELLE` IS NULL)" +
3014 " OR (`LIBELLE` = @p3)))";
3015 this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
3016 global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
3017 param.ParameterName = "@p1";
3018 param.DbType = global::System.Data.DbType.Int32;
3019 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3020 param.IsNullable = true;
3021 param.SourceColumn = "IDMOTIF";
3022 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3023 this._adapter.DeleteCommand.Parameters.Add(param);
3024 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3025 param.ParameterName = "@p2";
3026 param.DbType = global::System.Data.DbType.Int32;
3027 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3028 param.IsNullable = true;
3029 param.SourceColumn = "LIBELLE";
3030 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3031 param.SourceColumnNullMapping = true;
3032 this._adapter.DeleteCommand.Parameters.Add(param);
3033 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3034 param.ParameterName = "@p3";
3035 param.DbType = global::System.Data.DbType.String;
3036 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3037 param.IsNullable = true;
3038 param.SourceColumn = "LIBELLE";
3039 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3040 this._adapter.DeleteCommand.Parameters.Add(param);
3041 this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
3042 this._adapter.InsertCommand.Connection = this.Connection;
3043 this._adapter.InsertCommand.CommandText = "INSERT INTO `motif` (`LIBELLE`) VALUES (@p1)";
3044 this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
3045 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3046 param.ParameterName = "@p1";
3047 param.DbType = global::System.Data.DbType.String;
3048 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3049 param.IsNullable = true;
3050 param.SourceColumn = "LIBELLE";
3051 param.SourceVersion = global::System.Data.DataRowVersion.Current;
3052 this._adapter.InsertCommand.Parameters.Add(param);
3053 this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
3054 this._adapter.UpdateCommand.Connection = this.Connection;
3055 this._adapter.UpdateCommand.CommandText = "UPDATE `motif` SET `LIBELLE` = @p1 WHERE ((`IDMOTIF` = @p2) AND ((@p3 = 1 AND `LI" +
3056 "BELLE` IS NULL) OR (`LIBELLE` = @p4)))";
3057 this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
3058 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3059 param.ParameterName = "@p1";
3060 param.DbType = global::System.Data.DbType.String;
3061 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3062 param.IsNullable = true;
3063 param.SourceColumn = "LIBELLE";
3064 param.SourceVersion = global::System.Data.DataRowVersion.Current;
3065 this._adapter.UpdateCommand.Parameters.Add(param);
3066 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3067 param.ParameterName = "@p2";
3068 param.DbType = global::System.Data.DbType.Int32;
3069 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3070 param.IsNullable = true;
3071 param.SourceColumn = "IDMOTIF";
3072 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3073 this._adapter.UpdateCommand.Parameters.Add(param);
3074 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3075 param.ParameterName = "@p3";
3076 param.DbType = global::System.Data.DbType.Int32;
3077 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3078 param.IsNullable = true;
3079 param.SourceColumn = "LIBELLE";
3080 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3081 param.SourceColumnNullMapping = true;
3082 this._adapter.UpdateCommand.Parameters.Add(param);
3083 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3084 param.ParameterName = "@p4";
3085 param.DbType = global::System.Data.DbType.String;
3086 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3087 param.IsNullable = true;
3088 param.SourceColumn = "LIBELLE";
3089 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3090 this._adapter.UpdateCommand.Parameters.Add(param);
3091 }
3092
3093 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3094 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3095 private void InitConnection() {
3096 this._connection = new global::MySql.Data.MySqlClient.MySqlConnection();
3097 this._connection.ConnectionString = global::MediaTek.Properties.Settings.Default.projetcnedConnectionString;
3098 }
3099
3100 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3101 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3102 private void InitCommandCollection() {
3103 this._commandCollection = new global::MySql.Data.MySqlClient.MySqlCommand[1];
3104 this._commandCollection[0] = new global::MySql.Data.MySqlClient.MySqlCommand();
3105 this._commandCollection[0].Connection = this.Connection;
3106 this._commandCollection[0].CommandText = "SELECT `IDMOTIF`, `LIBELLE` FROM `motif`";
3107 this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
3108 }
3109
3110 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3111 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3112 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3113 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
3114 public virtual int Fill(projetcnedDataSet.motifDataTable dataTable) {
3115 this.Adapter.SelectCommand = this.CommandCollection[0];
3116 if ((this.ClearBeforeFill == true)) {
3117 dataTable.Clear();
3118 }
3119 int returnValue = this.Adapter.Fill(dataTable);
3120 return returnValue;
3121 }
3122
3123 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3124 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3125 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3126 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
3127 public virtual projetcnedDataSet.motifDataTable GetData() {
3128 this.Adapter.SelectCommand = this.CommandCollection[0];
3129 projetcnedDataSet.motifDataTable dataTable = new projetcnedDataSet.motifDataTable();
3130 this.Adapter.Fill(dataTable);
3131 return dataTable;
3132 }
3133
3134 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3135 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3136 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3137 public virtual int Update(projetcnedDataSet.motifDataTable dataTable) {
3138 return this.Adapter.Update(dataTable);
3139 }
3140
3141 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3142 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3143 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3144 public virtual int Update(projetcnedDataSet dataSet) {
3145 return this.Adapter.Update(dataSet, "motif");
3146 }
3147
3148 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3149 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3150 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3151 public virtual int Update(global::System.Data.DataRow dataRow) {
3152 return this.Adapter.Update(new global::System.Data.DataRow[] {
3153 dataRow});
3154 }
3155
3156 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3157 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3158 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3159 public virtual int Update(global::System.Data.DataRow[] dataRows) {
3160 return this.Adapter.Update(dataRows);
3161 }
3162
3163 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3164 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3165 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3166 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)]
3167 public virtual int Delete(int p1, string p3) {
3168 this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(p1));
3169 if ((p3 == null)) {
3170 this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(1));
3171 this.Adapter.DeleteCommand.Parameters[2].Value = global::System.DBNull.Value;
3172 }
3173 else {
3174 this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(0));
3175 this.Adapter.DeleteCommand.Parameters[2].Value = ((string)(p3));
3176 }
3177 global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
3178 if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
3179 != global::System.Data.ConnectionState.Open)) {
3180 this.Adapter.DeleteCommand.Connection.Open();
3181 }
3182 try {
3183 int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
3184 return returnValue;
3185 }
3186 finally {
3187 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
3188 this.Adapter.DeleteCommand.Connection.Close();
3189 }
3190 }
3191 }
3192
3193 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3194 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3195 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3196 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
3197 public virtual int Insert(string p1) {
3198 if ((p1 == null)) {
3199 this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;
3200 }
3201 else {
3202 this.Adapter.InsertCommand.Parameters[0].Value = ((string)(p1));
3203 }
3204 global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
3205 if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
3206 != global::System.Data.ConnectionState.Open)) {
3207 this.Adapter.InsertCommand.Connection.Open();
3208 }
3209 try {
3210 int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
3211 return returnValue;
3212 }
3213 finally {
3214 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
3215 this.Adapter.InsertCommand.Connection.Close();
3216 }
3217 }
3218 }
3219
3220 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3221 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3222 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3223 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
3224 public virtual int Update(string p1, int p2, string p4) {
3225 if ((p1 == null)) {
3226 this.Adapter.UpdateCommand.Parameters[0].Value = global::System.DBNull.Value;
3227 }
3228 else {
3229 this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(p1));
3230 }
3231 this.Adapter.UpdateCommand.Parameters[1].Value = ((int)(p2));
3232 if ((p4 == null)) {
3233 this.Adapter.UpdateCommand.Parameters[2].Value = ((object)(1));
3234 this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
3235 }
3236 else {
3237 this.Adapter.UpdateCommand.Parameters[2].Value = ((object)(0));
3238 this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(p4));
3239 }
3240 global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
3241 if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
3242 != global::System.Data.ConnectionState.Open)) {
3243 this.Adapter.UpdateCommand.Connection.Open();
3244 }
3245 try {
3246 int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
3247 return returnValue;
3248 }
3249 finally {
3250 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
3251 this.Adapter.UpdateCommand.Connection.Close();
3252 }
3253 }
3254 }
3255 }
3256
3260 [global::System.ComponentModel.DesignerCategoryAttribute("code")]
3261 [global::System.ComponentModel.ToolboxItem(true)]
3262 [global::System.ComponentModel.DataObjectAttribute(true)]
3263 [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
3264 ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
3265 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3266 public partial class personnelTableAdapter : global::System.ComponentModel.Component {
3267
3268 private global::MySql.Data.MySqlClient.MySqlDataAdapter _adapter;
3269
3270 private global::MySql.Data.MySqlClient.MySqlConnection _connection;
3271
3272 private global::MySql.Data.MySqlClient.MySqlTransaction _transaction;
3273
3274 private global::MySql.Data.MySqlClient.MySqlCommand[] _commandCollection;
3275
3276 private bool _clearBeforeFill;
3277
3278 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3279 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3280 public personnelTableAdapter() {
3281 this.ClearBeforeFill = true;
3282 }
3283
3284 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3285 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3286 protected internal global::MySql.Data.MySqlClient.MySqlDataAdapter Adapter {
3287 get {
3288 if ((this._adapter == null)) {
3289 this.InitAdapter();
3290 }
3291 return this._adapter;
3292 }
3293 }
3294
3295 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3296 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3297 internal global::MySql.Data.MySqlClient.MySqlConnection Connection {
3298 get {
3299 if ((this._connection == null)) {
3300 this.InitConnection();
3301 }
3302 return this._connection;
3303 }
3304 set {
3305 this._connection = value;
3306 if ((this.Adapter.InsertCommand != null)) {
3307 this.Adapter.InsertCommand.Connection = value;
3308 }
3309 if ((this.Adapter.DeleteCommand != null)) {
3310 this.Adapter.DeleteCommand.Connection = value;
3311 }
3312 if ((this.Adapter.UpdateCommand != null)) {
3313 this.Adapter.UpdateCommand.Connection = value;
3314 }
3315 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
3316 if ((this.CommandCollection[i] != null)) {
3317 ((global::MySql.Data.MySqlClient.MySqlCommand)(this.CommandCollection[i])).Connection = value;
3318 }
3319 }
3320 }
3321 }
3322
3323 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3324 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3325 internal global::MySql.Data.MySqlClient.MySqlTransaction Transaction {
3326 get {
3327 return this._transaction;
3328 }
3329 set {
3330 this._transaction = value;
3331 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
3332 this.CommandCollection[i].Transaction = this._transaction;
3333 }
3334 if (((this.Adapter != null)
3335 && (this.Adapter.DeleteCommand != null))) {
3336 this.Adapter.DeleteCommand.Transaction = this._transaction;
3337 }
3338 if (((this.Adapter != null)
3339 && (this.Adapter.InsertCommand != null))) {
3340 this.Adapter.InsertCommand.Transaction = this._transaction;
3341 }
3342 if (((this.Adapter != null)
3343 && (this.Adapter.UpdateCommand != null))) {
3344 this.Adapter.UpdateCommand.Transaction = this._transaction;
3345 }
3346 }
3347 }
3348
3349 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3350 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3351 protected global::MySql.Data.MySqlClient.MySqlCommand[] CommandCollection {
3352 get {
3353 if ((this._commandCollection == null)) {
3354 this.InitCommandCollection();
3355 }
3356 return this._commandCollection;
3357 }
3358 }
3359
3360 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3361 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3362 public bool ClearBeforeFill {
3363 get {
3364 return this._clearBeforeFill;
3365 }
3366 set {
3367 this._clearBeforeFill = value;
3368 }
3369 }
3370
3371 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3372 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3373 private void InitAdapter() {
3374 this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
3375 global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
3376 tableMapping.SourceTable = "Table";
3377 tableMapping.DataSetTable = "personnel";
3378 tableMapping.ColumnMappings.Add("IDPERSONNEL", "IDPERSONNEL");
3379 tableMapping.ColumnMappings.Add("IDSERVICE", "IDSERVICE");
3380 tableMapping.ColumnMappings.Add("NOM", "NOM");
3381 tableMapping.ColumnMappings.Add("PRENOM", "PRENOM");
3382 tableMapping.ColumnMappings.Add("TEL", "TEL");
3383 tableMapping.ColumnMappings.Add("MAIL", "MAIL");
3384 this._adapter.TableMappings.Add(tableMapping);
3385 this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
3386 this._adapter.DeleteCommand.Connection = this.Connection;
3387 this._adapter.DeleteCommand.CommandText = @"DELETE FROM `personnel` WHERE ((`IDPERSONNEL` = @p1) AND (`IDSERVICE` = @p2) AND ((@p3 = 1 AND `NOM` IS NULL) OR (`NOM` = @p4)) AND ((@p5 = 1 AND `PRENOM` IS NULL) OR (`PRENOM` = @p6)) AND ((@p7 = 1 AND `TEL` IS NULL) OR (`TEL` = @p8)) AND ((@p9 = 1 AND `MAIL` IS NULL) OR (`MAIL` = @p10)))";
3388 this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
3389 global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
3390 param.ParameterName = "@p1";
3391 param.DbType = global::System.Data.DbType.Int32;
3392 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3393 param.IsNullable = true;
3394 param.SourceColumn = "IDPERSONNEL";
3395 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3396 this._adapter.DeleteCommand.Parameters.Add(param);
3397 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3398 param.ParameterName = "@p2";
3399 param.DbType = global::System.Data.DbType.Int32;
3400 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3401 param.IsNullable = true;
3402 param.SourceColumn = "IDSERVICE";
3403 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3404 this._adapter.DeleteCommand.Parameters.Add(param);
3405 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3406 param.ParameterName = "@p3";
3407 param.DbType = global::System.Data.DbType.Int32;
3408 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3409 param.IsNullable = true;
3410 param.SourceColumn = "NOM";
3411 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3412 param.SourceColumnNullMapping = true;
3413 this._adapter.DeleteCommand.Parameters.Add(param);
3414 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3415 param.ParameterName = "@p4";
3416 param.DbType = global::System.Data.DbType.String;
3417 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3418 param.IsNullable = true;
3419 param.SourceColumn = "NOM";
3420 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3421 this._adapter.DeleteCommand.Parameters.Add(param);
3422 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3423 param.ParameterName = "@p5";
3424 param.DbType = global::System.Data.DbType.Int32;
3425 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3426 param.IsNullable = true;
3427 param.SourceColumn = "PRENOM";
3428 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3429 param.SourceColumnNullMapping = true;
3430 this._adapter.DeleteCommand.Parameters.Add(param);
3431 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3432 param.ParameterName = "@p6";
3433 param.DbType = global::System.Data.DbType.String;
3434 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3435 param.IsNullable = true;
3436 param.SourceColumn = "PRENOM";
3437 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3438 this._adapter.DeleteCommand.Parameters.Add(param);
3439 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3440 param.ParameterName = "@p7";
3441 param.DbType = global::System.Data.DbType.Int32;
3442 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3443 param.IsNullable = true;
3444 param.SourceColumn = "TEL";
3445 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3446 param.SourceColumnNullMapping = true;
3447 this._adapter.DeleteCommand.Parameters.Add(param);
3448 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3449 param.ParameterName = "@p8";
3450 param.DbType = global::System.Data.DbType.String;
3451 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3452 param.IsNullable = true;
3453 param.SourceColumn = "TEL";
3454 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3455 this._adapter.DeleteCommand.Parameters.Add(param);
3456 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3457 param.ParameterName = "@p9";
3458 param.DbType = global::System.Data.DbType.Int32;
3459 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3460 param.IsNullable = true;
3461 param.SourceColumn = "MAIL";
3462 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3463 param.SourceColumnNullMapping = true;
3464 this._adapter.DeleteCommand.Parameters.Add(param);
3465 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3466 param.ParameterName = "@p10";
3467 param.DbType = global::System.Data.DbType.String;
3468 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3469 param.IsNullable = true;
3470 param.SourceColumn = "MAIL";
3471 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3472 this._adapter.DeleteCommand.Parameters.Add(param);
3473 this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
3474 this._adapter.InsertCommand.Connection = this.Connection;
3475 this._adapter.InsertCommand.CommandText = "INSERT INTO `personnel` (`IDSERVICE`, `NOM`, `PRENOM`, `TEL`, `MAIL`) VALUES (@p1" +
3476 ", @p2, @p3, @p4, @p5)";
3477 this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
3478 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3479 param.ParameterName = "@p1";
3480 param.DbType = global::System.Data.DbType.Int32;
3481 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3482 param.IsNullable = true;
3483 param.SourceColumn = "IDSERVICE";
3484 param.SourceVersion = global::System.Data.DataRowVersion.Current;
3485 this._adapter.InsertCommand.Parameters.Add(param);
3486 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3487 param.ParameterName = "@p2";
3488 param.DbType = global::System.Data.DbType.String;
3489 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3490 param.IsNullable = true;
3491 param.SourceColumn = "NOM";
3492 param.SourceVersion = global::System.Data.DataRowVersion.Current;
3493 this._adapter.InsertCommand.Parameters.Add(param);
3494 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3495 param.ParameterName = "@p3";
3496 param.DbType = global::System.Data.DbType.String;
3497 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3498 param.IsNullable = true;
3499 param.SourceColumn = "PRENOM";
3500 param.SourceVersion = global::System.Data.DataRowVersion.Current;
3501 this._adapter.InsertCommand.Parameters.Add(param);
3502 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3503 param.ParameterName = "@p4";
3504 param.DbType = global::System.Data.DbType.String;
3505 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3506 param.IsNullable = true;
3507 param.SourceColumn = "TEL";
3508 param.SourceVersion = global::System.Data.DataRowVersion.Current;
3509 this._adapter.InsertCommand.Parameters.Add(param);
3510 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3511 param.ParameterName = "@p5";
3512 param.DbType = global::System.Data.DbType.String;
3513 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3514 param.IsNullable = true;
3515 param.SourceColumn = "MAIL";
3516 param.SourceVersion = global::System.Data.DataRowVersion.Current;
3517 this._adapter.InsertCommand.Parameters.Add(param);
3518 this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
3519 this._adapter.UpdateCommand.Connection = this.Connection;
3520 this._adapter.UpdateCommand.CommandText = @"UPDATE `personnel` SET `IDSERVICE` = @p1, `NOM` = @p2, `PRENOM` = @p3, `TEL` = @p4, `MAIL` = @p5 WHERE ((`IDPERSONNEL` = @p6) AND (`IDSERVICE` = @p7) AND ((@p8 = 1 AND `NOM` IS NULL) OR (`NOM` = @p9)) AND ((@p10 = 1 AND `PRENOM` IS NULL) OR (`PRENOM` = @p11)) AND ((@p12 = 1 AND `TEL` IS NULL) OR (`TEL` = @p13)) AND ((@p14 = 1 AND `MAIL` IS NULL) OR (`MAIL` = @p15)))";
3521 this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
3522 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3523 param.ParameterName = "@p1";
3524 param.DbType = global::System.Data.DbType.Int32;
3525 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3526 param.IsNullable = true;
3527 param.SourceColumn = "IDSERVICE";
3528 param.SourceVersion = global::System.Data.DataRowVersion.Current;
3529 this._adapter.UpdateCommand.Parameters.Add(param);
3530 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3531 param.ParameterName = "@p2";
3532 param.DbType = global::System.Data.DbType.String;
3533 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3534 param.IsNullable = true;
3535 param.SourceColumn = "NOM";
3536 param.SourceVersion = global::System.Data.DataRowVersion.Current;
3537 this._adapter.UpdateCommand.Parameters.Add(param);
3538 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3539 param.ParameterName = "@p3";
3540 param.DbType = global::System.Data.DbType.String;
3541 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3542 param.IsNullable = true;
3543 param.SourceColumn = "PRENOM";
3544 param.SourceVersion = global::System.Data.DataRowVersion.Current;
3545 this._adapter.UpdateCommand.Parameters.Add(param);
3546 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3547 param.ParameterName = "@p4";
3548 param.DbType = global::System.Data.DbType.String;
3549 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3550 param.IsNullable = true;
3551 param.SourceColumn = "TEL";
3552 param.SourceVersion = global::System.Data.DataRowVersion.Current;
3553 this._adapter.UpdateCommand.Parameters.Add(param);
3554 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3555 param.ParameterName = "@p5";
3556 param.DbType = global::System.Data.DbType.String;
3557 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3558 param.IsNullable = true;
3559 param.SourceColumn = "MAIL";
3560 param.SourceVersion = global::System.Data.DataRowVersion.Current;
3561 this._adapter.UpdateCommand.Parameters.Add(param);
3562 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3563 param.ParameterName = "@p6";
3564 param.DbType = global::System.Data.DbType.Int32;
3565 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3566 param.IsNullable = true;
3567 param.SourceColumn = "IDPERSONNEL";
3568 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3569 this._adapter.UpdateCommand.Parameters.Add(param);
3570 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3571 param.ParameterName = "@p7";
3572 param.DbType = global::System.Data.DbType.Int32;
3573 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3574 param.IsNullable = true;
3575 param.SourceColumn = "IDSERVICE";
3576 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3577 this._adapter.UpdateCommand.Parameters.Add(param);
3578 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3579 param.ParameterName = "@p8";
3580 param.DbType = global::System.Data.DbType.Int32;
3581 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3582 param.IsNullable = true;
3583 param.SourceColumn = "NOM";
3584 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3585 param.SourceColumnNullMapping = true;
3586 this._adapter.UpdateCommand.Parameters.Add(param);
3587 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3588 param.ParameterName = "@p9";
3589 param.DbType = global::System.Data.DbType.String;
3590 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3591 param.IsNullable = true;
3592 param.SourceColumn = "NOM";
3593 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3594 this._adapter.UpdateCommand.Parameters.Add(param);
3595 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3596 param.ParameterName = "@p10";
3597 param.DbType = global::System.Data.DbType.Int32;
3598 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3599 param.IsNullable = true;
3600 param.SourceColumn = "PRENOM";
3601 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3602 param.SourceColumnNullMapping = true;
3603 this._adapter.UpdateCommand.Parameters.Add(param);
3604 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3605 param.ParameterName = "@p11";
3606 param.DbType = global::System.Data.DbType.String;
3607 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3608 param.IsNullable = true;
3609 param.SourceColumn = "PRENOM";
3610 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3611 this._adapter.UpdateCommand.Parameters.Add(param);
3612 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3613 param.ParameterName = "@p12";
3614 param.DbType = global::System.Data.DbType.Int32;
3615 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3616 param.IsNullable = true;
3617 param.SourceColumn = "TEL";
3618 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3619 param.SourceColumnNullMapping = true;
3620 this._adapter.UpdateCommand.Parameters.Add(param);
3621 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3622 param.ParameterName = "@p13";
3623 param.DbType = global::System.Data.DbType.String;
3624 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3625 param.IsNullable = true;
3626 param.SourceColumn = "TEL";
3627 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3628 this._adapter.UpdateCommand.Parameters.Add(param);
3629 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3630 param.ParameterName = "@p14";
3631 param.DbType = global::System.Data.DbType.Int32;
3632 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
3633 param.IsNullable = true;
3634 param.SourceColumn = "MAIL";
3635 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3636 param.SourceColumnNullMapping = true;
3637 this._adapter.UpdateCommand.Parameters.Add(param);
3638 param = new global::MySql.Data.MySqlClient.MySqlParameter();
3639 param.ParameterName = "@p15";
3640 param.DbType = global::System.Data.DbType.String;
3641 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
3642 param.IsNullable = true;
3643 param.SourceColumn = "MAIL";
3644 param.SourceVersion = global::System.Data.DataRowVersion.Original;
3645 this._adapter.UpdateCommand.Parameters.Add(param);
3646 }
3647
3648 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3649 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3650 private void InitConnection() {
3651 this._connection = new global::MySql.Data.MySqlClient.MySqlConnection();
3652 this._connection.ConnectionString = global::MediaTek.Properties.Settings.Default.projetcnedConnectionString;
3653 }
3654
3655 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3656 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3657 private void InitCommandCollection() {
3658 this._commandCollection = new global::MySql.Data.MySqlClient.MySqlCommand[1];
3659 this._commandCollection[0] = new global::MySql.Data.MySqlClient.MySqlCommand();
3660 this._commandCollection[0].Connection = this.Connection;
3661 this._commandCollection[0].CommandText = "SELECT `IDPERSONNEL`, `IDSERVICE`, `NOM`, `PRENOM`, `TEL`, `MAIL` FROM `personnel" +
3662 "`";
3663 this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
3664 }
3665
3666 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3667 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3668 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3669 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
3670 public virtual int Fill(projetcnedDataSet.personnelDataTable dataTable) {
3671 this.Adapter.SelectCommand = this.CommandCollection[0];
3672 if ((this.ClearBeforeFill == true)) {
3673 dataTable.Clear();
3674 }
3675 int returnValue = this.Adapter.Fill(dataTable);
3676 return returnValue;
3677 }
3678
3679 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3680 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3681 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3682 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
3683 public virtual projetcnedDataSet.personnelDataTable GetData() {
3684 this.Adapter.SelectCommand = this.CommandCollection[0];
3685 projetcnedDataSet.personnelDataTable dataTable = new projetcnedDataSet.personnelDataTable();
3686 this.Adapter.Fill(dataTable);
3687 return dataTable;
3688 }
3689
3690 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3691 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3692 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3693 public virtual int Update(projetcnedDataSet.personnelDataTable dataTable) {
3694 return this.Adapter.Update(dataTable);
3695 }
3696
3697 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3698 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3699 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3700 public virtual int Update(projetcnedDataSet dataSet) {
3701 return this.Adapter.Update(dataSet, "personnel");
3702 }
3703
3704 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3705 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3706 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3707 public virtual int Update(global::System.Data.DataRow dataRow) {
3708 return this.Adapter.Update(new global::System.Data.DataRow[] {
3709 dataRow});
3710 }
3711
3712 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3713 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3714 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3715 public virtual int Update(global::System.Data.DataRow[] dataRows) {
3716 return this.Adapter.Update(dataRows);
3717 }
3718
3719 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3720 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3721 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3722 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)]
3723 public virtual int Delete(int p1, int p2, string p4, string p6, string p8, string p10) {
3724 this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(p1));
3725 this.Adapter.DeleteCommand.Parameters[1].Value = ((int)(p2));
3726 if ((p4 == null)) {
3727 this.Adapter.DeleteCommand.Parameters[2].Value = ((object)(1));
3728 this.Adapter.DeleteCommand.Parameters[3].Value = global::System.DBNull.Value;
3729 }
3730 else {
3731 this.Adapter.DeleteCommand.Parameters[2].Value = ((object)(0));
3732 this.Adapter.DeleteCommand.Parameters[3].Value = ((string)(p4));
3733 }
3734 if ((p6 == null)) {
3735 this.Adapter.DeleteCommand.Parameters[4].Value = ((object)(1));
3736 this.Adapter.DeleteCommand.Parameters[5].Value = global::System.DBNull.Value;
3737 }
3738 else {
3739 this.Adapter.DeleteCommand.Parameters[4].Value = ((object)(0));
3740 this.Adapter.DeleteCommand.Parameters[5].Value = ((string)(p6));
3741 }
3742 if ((p8 == null)) {
3743 this.Adapter.DeleteCommand.Parameters[6].Value = ((object)(1));
3744 this.Adapter.DeleteCommand.Parameters[7].Value = global::System.DBNull.Value;
3745 }
3746 else {
3747 this.Adapter.DeleteCommand.Parameters[6].Value = ((object)(0));
3748 this.Adapter.DeleteCommand.Parameters[7].Value = ((string)(p8));
3749 }
3750 if ((p10 == null)) {
3751 this.Adapter.DeleteCommand.Parameters[8].Value = ((object)(1));
3752 this.Adapter.DeleteCommand.Parameters[9].Value = global::System.DBNull.Value;
3753 }
3754 else {
3755 this.Adapter.DeleteCommand.Parameters[8].Value = ((object)(0));
3756 this.Adapter.DeleteCommand.Parameters[9].Value = ((string)(p10));
3757 }
3758 global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
3759 if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
3760 != global::System.Data.ConnectionState.Open)) {
3761 this.Adapter.DeleteCommand.Connection.Open();
3762 }
3763 try {
3764 int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
3765 return returnValue;
3766 }
3767 finally {
3768 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
3769 this.Adapter.DeleteCommand.Connection.Close();
3770 }
3771 }
3772 }
3773
3774 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3775 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3776 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3777 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
3778 public virtual int Insert(int p1, string p2, string p3, string p4, string p5) {
3779 this.Adapter.InsertCommand.Parameters[0].Value = ((int)(p1));
3780 if ((p2 == null)) {
3781 this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
3782 }
3783 else {
3784 this.Adapter.InsertCommand.Parameters[1].Value = ((string)(p2));
3785 }
3786 if ((p3 == null)) {
3787 this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
3788 }
3789 else {
3790 this.Adapter.InsertCommand.Parameters[2].Value = ((string)(p3));
3791 }
3792 if ((p4 == null)) {
3793 this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
3794 }
3795 else {
3796 this.Adapter.InsertCommand.Parameters[3].Value = ((string)(p4));
3797 }
3798 if ((p5 == null)) {
3799 this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
3800 }
3801 else {
3802 this.Adapter.InsertCommand.Parameters[4].Value = ((string)(p5));
3803 }
3804 global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
3805 if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
3806 != global::System.Data.ConnectionState.Open)) {
3807 this.Adapter.InsertCommand.Connection.Open();
3808 }
3809 try {
3810 int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
3811 return returnValue;
3812 }
3813 finally {
3814 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
3815 this.Adapter.InsertCommand.Connection.Close();
3816 }
3817 }
3818 }
3819
3820 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3821 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3822 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3823 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
3824 public virtual int Update(int p1, string p2, string p3, string p4, string p5, int p6, int p7, string p9, string p11, string p13, string p15) {
3825 this.Adapter.UpdateCommand.Parameters[0].Value = ((int)(p1));
3826 if ((p2 == null)) {
3827 this.Adapter.UpdateCommand.Parameters[1].Value = global::System.DBNull.Value;
3828 }
3829 else {
3830 this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(p2));
3831 }
3832 if ((p3 == null)) {
3833 this.Adapter.UpdateCommand.Parameters[2].Value = global::System.DBNull.Value;
3834 }
3835 else {
3836 this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(p3));
3837 }
3838 if ((p4 == null)) {
3839 this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
3840 }
3841 else {
3842 this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(p4));
3843 }
3844 if ((p5 == null)) {
3845 this.Adapter.UpdateCommand.Parameters[4].Value = global::System.DBNull.Value;
3846 }
3847 else {
3848 this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(p5));
3849 }
3850 this.Adapter.UpdateCommand.Parameters[5].Value = ((int)(p6));
3851 this.Adapter.UpdateCommand.Parameters[6].Value = ((int)(p7));
3852 if ((p9 == null)) {
3853 this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(1));
3854 this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value;
3855 }
3856 else {
3857 this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(0));
3858 this.Adapter.UpdateCommand.Parameters[8].Value = ((string)(p9));
3859 }
3860 if ((p11 == null)) {
3861 this.Adapter.UpdateCommand.Parameters[9].Value = ((object)(1));
3862 this.Adapter.UpdateCommand.Parameters[10].Value = global::System.DBNull.Value;
3863 }
3864 else {
3865 this.Adapter.UpdateCommand.Parameters[9].Value = ((object)(0));
3866 this.Adapter.UpdateCommand.Parameters[10].Value = ((string)(p11));
3867 }
3868 if ((p13 == null)) {
3869 this.Adapter.UpdateCommand.Parameters[11].Value = ((object)(1));
3870 this.Adapter.UpdateCommand.Parameters[12].Value = global::System.DBNull.Value;
3871 }
3872 else {
3873 this.Adapter.UpdateCommand.Parameters[11].Value = ((object)(0));
3874 this.Adapter.UpdateCommand.Parameters[12].Value = ((string)(p13));
3875 }
3876 if ((p15 == null)) {
3877 this.Adapter.UpdateCommand.Parameters[13].Value = ((object)(1));
3878 this.Adapter.UpdateCommand.Parameters[14].Value = global::System.DBNull.Value;
3879 }
3880 else {
3881 this.Adapter.UpdateCommand.Parameters[13].Value = ((object)(0));
3882 this.Adapter.UpdateCommand.Parameters[14].Value = ((string)(p15));
3883 }
3884 global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
3885 if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
3886 != global::System.Data.ConnectionState.Open)) {
3887 this.Adapter.UpdateCommand.Connection.Open();
3888 }
3889 try {
3890 int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
3891 return returnValue;
3892 }
3893 finally {
3894 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
3895 this.Adapter.UpdateCommand.Connection.Close();
3896 }
3897 }
3898 }
3899 }
3900
3904 [global::System.ComponentModel.DesignerCategoryAttribute("code")]
3905 [global::System.ComponentModel.ToolboxItem(true)]
3906 [global::System.ComponentModel.DataObjectAttribute(true)]
3907 [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
3908 ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
3909 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
3910 public partial class responsableTableAdapter : global::System.ComponentModel.Component {
3911
3912 private global::MySql.Data.MySqlClient.MySqlDataAdapter _adapter;
3913
3914 private global::MySql.Data.MySqlClient.MySqlConnection _connection;
3915
3916 private global::MySql.Data.MySqlClient.MySqlTransaction _transaction;
3917
3918 private global::MySql.Data.MySqlClient.MySqlCommand[] _commandCollection;
3919
3920 private bool _clearBeforeFill;
3921
3922 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3923 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3924 public responsableTableAdapter() {
3925 this.ClearBeforeFill = true;
3926 }
3927
3928 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3929 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3930 protected internal global::MySql.Data.MySqlClient.MySqlDataAdapter Adapter {
3931 get {
3932 if ((this._adapter == null)) {
3933 this.InitAdapter();
3934 }
3935 return this._adapter;
3936 }
3937 }
3938
3939 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3940 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3941 internal global::MySql.Data.MySqlClient.MySqlConnection Connection {
3942 get {
3943 if ((this._connection == null)) {
3944 this.InitConnection();
3945 }
3946 return this._connection;
3947 }
3948 set {
3949 this._connection = value;
3950 if ((this.Adapter.InsertCommand != null)) {
3951 this.Adapter.InsertCommand.Connection = value;
3952 }
3953 if ((this.Adapter.DeleteCommand != null)) {
3954 this.Adapter.DeleteCommand.Connection = value;
3955 }
3956 if ((this.Adapter.UpdateCommand != null)) {
3957 this.Adapter.UpdateCommand.Connection = value;
3958 }
3959 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
3960 if ((this.CommandCollection[i] != null)) {
3961 ((global::MySql.Data.MySqlClient.MySqlCommand)(this.CommandCollection[i])).Connection = value;
3962 }
3963 }
3964 }
3965 }
3966
3967 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3968 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3969 internal global::MySql.Data.MySqlClient.MySqlTransaction Transaction {
3970 get {
3971 return this._transaction;
3972 }
3973 set {
3974 this._transaction = value;
3975 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
3976 this.CommandCollection[i].Transaction = this._transaction;
3977 }
3978 if (((this.Adapter != null)
3979 && (this.Adapter.DeleteCommand != null))) {
3980 this.Adapter.DeleteCommand.Transaction = this._transaction;
3981 }
3982 if (((this.Adapter != null)
3983 && (this.Adapter.InsertCommand != null))) {
3984 this.Adapter.InsertCommand.Transaction = this._transaction;
3985 }
3986 if (((this.Adapter != null)
3987 && (this.Adapter.UpdateCommand != null))) {
3988 this.Adapter.UpdateCommand.Transaction = this._transaction;
3989 }
3990 }
3991 }
3992
3993 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
3994 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
3995 protected global::MySql.Data.MySqlClient.MySqlCommand[] CommandCollection {
3996 get {
3997 if ((this._commandCollection == null)) {
3998 this.InitCommandCollection();
3999 }
4000 return this._commandCollection;
4001 }
4002 }
4003
4004 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4005 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4006 public bool ClearBeforeFill {
4007 get {
4008 return this._clearBeforeFill;
4009 }
4010 set {
4011 this._clearBeforeFill = value;
4012 }
4013 }
4014
4015 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4016 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4017 private void InitAdapter() {
4018 this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
4019 global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
4020 tableMapping.SourceTable = "Table";
4021 tableMapping.DataSetTable = "responsable";
4022 tableMapping.ColumnMappings.Add("login", "login");
4023 tableMapping.ColumnMappings.Add("pwd", "pwd");
4024 this._adapter.TableMappings.Add(tableMapping);
4025 this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
4026 this._adapter.InsertCommand.Connection = this.Connection;
4027 this._adapter.InsertCommand.CommandText = "INSERT INTO `responsable` (`login`, `pwd`) VALUES (@p1, @p2)";
4028 this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
4029 global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
4030 param.ParameterName = "@p1";
4031 param.DbType = global::System.Data.DbType.String;
4032 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
4033 param.IsNullable = true;
4034 param.SourceColumn = "login";
4035 param.SourceVersion = global::System.Data.DataRowVersion.Current;
4036 this._adapter.InsertCommand.Parameters.Add(param);
4037 param = new global::MySql.Data.MySqlClient.MySqlParameter();
4038 param.ParameterName = "@p2";
4039 param.DbType = global::System.Data.DbType.String;
4040 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
4041 param.IsNullable = true;
4042 param.SourceColumn = "pwd";
4043 param.SourceVersion = global::System.Data.DataRowVersion.Current;
4044 this._adapter.InsertCommand.Parameters.Add(param);
4045 }
4046
4047 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4048 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4049 private void InitConnection() {
4050 this._connection = new global::MySql.Data.MySqlClient.MySqlConnection();
4051 this._connection.ConnectionString = global::MediaTek.Properties.Settings.Default.projetcnedConnectionString;
4052 }
4053
4054 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4055 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4056 private void InitCommandCollection() {
4057 this._commandCollection = new global::MySql.Data.MySqlClient.MySqlCommand[1];
4058 this._commandCollection[0] = new global::MySql.Data.MySqlClient.MySqlCommand();
4059 this._commandCollection[0].Connection = this.Connection;
4060 this._commandCollection[0].CommandText = "SELECT `login`, `pwd` FROM `responsable`";
4061 this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
4062 }
4063
4064 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4065 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4066 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4067 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
4068 public virtual int Fill(projetcnedDataSet.responsableDataTable dataTable) {
4069 this.Adapter.SelectCommand = this.CommandCollection[0];
4070 if ((this.ClearBeforeFill == true)) {
4071 dataTable.Clear();
4072 }
4073 int returnValue = this.Adapter.Fill(dataTable);
4074 return returnValue;
4075 }
4076
4077 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4078 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4079 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4080 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
4081 public virtual projetcnedDataSet.responsableDataTable GetData() {
4082 this.Adapter.SelectCommand = this.CommandCollection[0];
4083 projetcnedDataSet.responsableDataTable dataTable = new projetcnedDataSet.responsableDataTable();
4084 this.Adapter.Fill(dataTable);
4085 return dataTable;
4086 }
4087
4088 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4089 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4090 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4091 public virtual int Update(projetcnedDataSet.responsableDataTable dataTable) {
4092 return this.Adapter.Update(dataTable);
4093 }
4094
4095 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4096 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4097 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4098 public virtual int Update(projetcnedDataSet dataSet) {
4099 return this.Adapter.Update(dataSet, "responsable");
4100 }
4101
4102 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4103 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4104 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4105 public virtual int Update(global::System.Data.DataRow dataRow) {
4106 return this.Adapter.Update(new global::System.Data.DataRow[] {
4107 dataRow});
4108 }
4109
4110 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4111 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4112 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4113 public virtual int Update(global::System.Data.DataRow[] dataRows) {
4114 return this.Adapter.Update(dataRows);
4115 }
4116
4117 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4118 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4119 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4120 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
4121 public virtual int Insert(string p1, string p2) {
4122 if ((p1 == null)) {
4123 throw new global::System.ArgumentNullException("p1");
4124 }
4125 else {
4126 this.Adapter.InsertCommand.Parameters[0].Value = ((string)(p1));
4127 }
4128 if ((p2 == null)) {
4129 throw new global::System.ArgumentNullException("p2");
4130 }
4131 else {
4132 this.Adapter.InsertCommand.Parameters[1].Value = ((string)(p2));
4133 }
4134 global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
4135 if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
4136 != global::System.Data.ConnectionState.Open)) {
4137 this.Adapter.InsertCommand.Connection.Open();
4138 }
4139 try {
4140 int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
4141 return returnValue;
4142 }
4143 finally {
4144 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
4145 this.Adapter.InsertCommand.Connection.Close();
4146 }
4147 }
4148 }
4149 }
4150
4154 [global::System.ComponentModel.DesignerCategoryAttribute("code")]
4155 [global::System.ComponentModel.ToolboxItem(true)]
4156 [global::System.ComponentModel.DataObjectAttribute(true)]
4157 [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
4158 ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
4159 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4160 public partial class serviceTableAdapter : global::System.ComponentModel.Component {
4161
4162 private global::MySql.Data.MySqlClient.MySqlDataAdapter _adapter;
4163
4164 private global::MySql.Data.MySqlClient.MySqlConnection _connection;
4165
4166 private global::MySql.Data.MySqlClient.MySqlTransaction _transaction;
4167
4168 private global::MySql.Data.MySqlClient.MySqlCommand[] _commandCollection;
4169
4170 private bool _clearBeforeFill;
4171
4172 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4173 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4174 public serviceTableAdapter() {
4175 this.ClearBeforeFill = true;
4176 }
4177
4178 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4179 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4180 protected internal global::MySql.Data.MySqlClient.MySqlDataAdapter Adapter {
4181 get {
4182 if ((this._adapter == null)) {
4183 this.InitAdapter();
4184 }
4185 return this._adapter;
4186 }
4187 }
4188
4189 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4190 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4191 internal global::MySql.Data.MySqlClient.MySqlConnection Connection {
4192 get {
4193 if ((this._connection == null)) {
4194 this.InitConnection();
4195 }
4196 return this._connection;
4197 }
4198 set {
4199 this._connection = value;
4200 if ((this.Adapter.InsertCommand != null)) {
4201 this.Adapter.InsertCommand.Connection = value;
4202 }
4203 if ((this.Adapter.DeleteCommand != null)) {
4204 this.Adapter.DeleteCommand.Connection = value;
4205 }
4206 if ((this.Adapter.UpdateCommand != null)) {
4207 this.Adapter.UpdateCommand.Connection = value;
4208 }
4209 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
4210 if ((this.CommandCollection[i] != null)) {
4211 ((global::MySql.Data.MySqlClient.MySqlCommand)(this.CommandCollection[i])).Connection = value;
4212 }
4213 }
4214 }
4215 }
4216
4217 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4218 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4219 internal global::MySql.Data.MySqlClient.MySqlTransaction Transaction {
4220 get {
4221 return this._transaction;
4222 }
4223 set {
4224 this._transaction = value;
4225 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
4226 this.CommandCollection[i].Transaction = this._transaction;
4227 }
4228 if (((this.Adapter != null)
4229 && (this.Adapter.DeleteCommand != null))) {
4230 this.Adapter.DeleteCommand.Transaction = this._transaction;
4231 }
4232 if (((this.Adapter != null)
4233 && (this.Adapter.InsertCommand != null))) {
4234 this.Adapter.InsertCommand.Transaction = this._transaction;
4235 }
4236 if (((this.Adapter != null)
4237 && (this.Adapter.UpdateCommand != null))) {
4238 this.Adapter.UpdateCommand.Transaction = this._transaction;
4239 }
4240 }
4241 }
4242
4243 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4244 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4245 protected global::MySql.Data.MySqlClient.MySqlCommand[] CommandCollection {
4246 get {
4247 if ((this._commandCollection == null)) {
4248 this.InitCommandCollection();
4249 }
4250 return this._commandCollection;
4251 }
4252 }
4253
4254 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4255 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4256 public bool ClearBeforeFill {
4257 get {
4258 return this._clearBeforeFill;
4259 }
4260 set {
4261 this._clearBeforeFill = value;
4262 }
4263 }
4264
4265 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4266 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4267 private void InitAdapter() {
4268 this._adapter = new global::MySql.Data.MySqlClient.MySqlDataAdapter();
4269 global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
4270 tableMapping.SourceTable = "Table";
4271 tableMapping.DataSetTable = "service";
4272 tableMapping.ColumnMappings.Add("IDSERVICE", "IDSERVICE");
4273 tableMapping.ColumnMappings.Add("NOM", "NOM");
4274 this._adapter.TableMappings.Add(tableMapping);
4275 this._adapter.DeleteCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
4276 this._adapter.DeleteCommand.Connection = this.Connection;
4277 this._adapter.DeleteCommand.CommandText = "DELETE FROM `service` WHERE ((`IDSERVICE` = @p1) AND ((@p2 = 1 AND `NOM` IS NULL)" +
4278 " OR (`NOM` = @p3)))";
4279 this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
4280 global::MySql.Data.MySqlClient.MySqlParameter param = new global::MySql.Data.MySqlClient.MySqlParameter();
4281 param.ParameterName = "@p1";
4282 param.DbType = global::System.Data.DbType.Int32;
4283 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
4284 param.IsNullable = true;
4285 param.SourceColumn = "IDSERVICE";
4286 param.SourceVersion = global::System.Data.DataRowVersion.Original;
4287 this._adapter.DeleteCommand.Parameters.Add(param);
4288 param = new global::MySql.Data.MySqlClient.MySqlParameter();
4289 param.ParameterName = "@p2";
4290 param.DbType = global::System.Data.DbType.Int32;
4291 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
4292 param.IsNullable = true;
4293 param.SourceColumn = "NOM";
4294 param.SourceVersion = global::System.Data.DataRowVersion.Original;
4295 param.SourceColumnNullMapping = true;
4296 this._adapter.DeleteCommand.Parameters.Add(param);
4297 param = new global::MySql.Data.MySqlClient.MySqlParameter();
4298 param.ParameterName = "@p3";
4299 param.DbType = global::System.Data.DbType.String;
4300 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
4301 param.IsNullable = true;
4302 param.SourceColumn = "NOM";
4303 param.SourceVersion = global::System.Data.DataRowVersion.Original;
4304 this._adapter.DeleteCommand.Parameters.Add(param);
4305 this._adapter.InsertCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
4306 this._adapter.InsertCommand.Connection = this.Connection;
4307 this._adapter.InsertCommand.CommandText = "INSERT INTO `service` (`NOM`) VALUES (@p1)";
4308 this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
4309 param = new global::MySql.Data.MySqlClient.MySqlParameter();
4310 param.ParameterName = "@p1";
4311 param.DbType = global::System.Data.DbType.String;
4312 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
4313 param.IsNullable = true;
4314 param.SourceColumn = "NOM";
4315 param.SourceVersion = global::System.Data.DataRowVersion.Current;
4316 this._adapter.InsertCommand.Parameters.Add(param);
4317 this._adapter.UpdateCommand = new global::MySql.Data.MySqlClient.MySqlCommand();
4318 this._adapter.UpdateCommand.Connection = this.Connection;
4319 this._adapter.UpdateCommand.CommandText = "UPDATE `service` SET `NOM` = @p1 WHERE ((`IDSERVICE` = @p2) AND ((@p3 = 1 AND `NO" +
4320 "M` IS NULL) OR (`NOM` = @p4)))";
4321 this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
4322 param = new global::MySql.Data.MySqlClient.MySqlParameter();
4323 param.ParameterName = "@p1";
4324 param.DbType = global::System.Data.DbType.String;
4325 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
4326 param.IsNullable = true;
4327 param.SourceColumn = "NOM";
4328 param.SourceVersion = global::System.Data.DataRowVersion.Current;
4329 this._adapter.UpdateCommand.Parameters.Add(param);
4330 param = new global::MySql.Data.MySqlClient.MySqlParameter();
4331 param.ParameterName = "@p2";
4332 param.DbType = global::System.Data.DbType.Int32;
4333 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
4334 param.IsNullable = true;
4335 param.SourceColumn = "IDSERVICE";
4336 param.SourceVersion = global::System.Data.DataRowVersion.Original;
4337 this._adapter.UpdateCommand.Parameters.Add(param);
4338 param = new global::MySql.Data.MySqlClient.MySqlParameter();
4339 param.ParameterName = "@p3";
4340 param.DbType = global::System.Data.DbType.Int32;
4341 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.Int32;
4342 param.IsNullable = true;
4343 param.SourceColumn = "NOM";
4344 param.SourceVersion = global::System.Data.DataRowVersion.Original;
4345 param.SourceColumnNullMapping = true;
4346 this._adapter.UpdateCommand.Parameters.Add(param);
4347 param = new global::MySql.Data.MySqlClient.MySqlParameter();
4348 param.ParameterName = "@p4";
4349 param.DbType = global::System.Data.DbType.String;
4350 param.MySqlDbType = global::MySql.Data.MySqlClient.MySqlDbType.VarChar;
4351 param.IsNullable = true;
4352 param.SourceColumn = "NOM";
4353 param.SourceVersion = global::System.Data.DataRowVersion.Original;
4354 this._adapter.UpdateCommand.Parameters.Add(param);
4355 }
4356
4357 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4358 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4359 private void InitConnection() {
4360 this._connection = new global::MySql.Data.MySqlClient.MySqlConnection();
4361 this._connection.ConnectionString = global::MediaTek.Properties.Settings.Default.projetcnedConnectionString;
4362 }
4363
4364 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4365 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4366 private void InitCommandCollection() {
4367 this._commandCollection = new global::MySql.Data.MySqlClient.MySqlCommand[1];
4368 this._commandCollection[0] = new global::MySql.Data.MySqlClient.MySqlCommand();
4369 this._commandCollection[0].Connection = this.Connection;
4370 this._commandCollection[0].CommandText = "SELECT `IDSERVICE`, `NOM` FROM `service`";
4371 this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
4372 }
4373
4374 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4375 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4376 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4377 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
4378 public virtual int Fill(projetcnedDataSet.serviceDataTable dataTable) {
4379 this.Adapter.SelectCommand = this.CommandCollection[0];
4380 if ((this.ClearBeforeFill == true)) {
4381 dataTable.Clear();
4382 }
4383 int returnValue = this.Adapter.Fill(dataTable);
4384 return returnValue;
4385 }
4386
4387 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4388 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4389 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4390 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
4391 public virtual projetcnedDataSet.serviceDataTable GetData() {
4392 this.Adapter.SelectCommand = this.CommandCollection[0];
4393 projetcnedDataSet.serviceDataTable dataTable = new projetcnedDataSet.serviceDataTable();
4394 this.Adapter.Fill(dataTable);
4395 return dataTable;
4396 }
4397
4398 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4399 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4400 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4401 public virtual int Update(projetcnedDataSet.serviceDataTable dataTable) {
4402 return this.Adapter.Update(dataTable);
4403 }
4404
4405 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4406 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4407 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4408 public virtual int Update(projetcnedDataSet dataSet) {
4409 return this.Adapter.Update(dataSet, "service");
4410 }
4411
4412 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4413 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4414 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4415 public virtual int Update(global::System.Data.DataRow dataRow) {
4416 return this.Adapter.Update(new global::System.Data.DataRow[] {
4417 dataRow});
4418 }
4419
4420 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4421 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4422 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4423 public virtual int Update(global::System.Data.DataRow[] dataRows) {
4424 return this.Adapter.Update(dataRows);
4425 }
4426
4427 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4428 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4429 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4430 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)]
4431 public virtual int Delete(int p1, string p3) {
4432 this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(p1));
4433 if ((p3 == null)) {
4434 this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(1));
4435 this.Adapter.DeleteCommand.Parameters[2].Value = global::System.DBNull.Value;
4436 }
4437 else {
4438 this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(0));
4439 this.Adapter.DeleteCommand.Parameters[2].Value = ((string)(p3));
4440 }
4441 global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
4442 if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
4443 != global::System.Data.ConnectionState.Open)) {
4444 this.Adapter.DeleteCommand.Connection.Open();
4445 }
4446 try {
4447 int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
4448 return returnValue;
4449 }
4450 finally {
4451 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
4452 this.Adapter.DeleteCommand.Connection.Close();
4453 }
4454 }
4455 }
4456
4457 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4458 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4459 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4460 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
4461 public virtual int Insert(string p1) {
4462 if ((p1 == null)) {
4463 this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;
4464 }
4465 else {
4466 this.Adapter.InsertCommand.Parameters[0].Value = ((string)(p1));
4467 }
4468 global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
4469 if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
4470 != global::System.Data.ConnectionState.Open)) {
4471 this.Adapter.InsertCommand.Connection.Open();
4472 }
4473 try {
4474 int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
4475 return returnValue;
4476 }
4477 finally {
4478 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
4479 this.Adapter.InsertCommand.Connection.Close();
4480 }
4481 }
4482 }
4483
4484 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4485 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4486 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
4487 [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
4488 public virtual int Update(string p1, int p2, string p4) {
4489 if ((p1 == null)) {
4490 this.Adapter.UpdateCommand.Parameters[0].Value = global::System.DBNull.Value;
4491 }
4492 else {
4493 this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(p1));
4494 }
4495 this.Adapter.UpdateCommand.Parameters[1].Value = ((int)(p2));
4496 if ((p4 == null)) {
4497 this.Adapter.UpdateCommand.Parameters[2].Value = ((object)(1));
4498 this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
4499 }
4500 else {
4501 this.Adapter.UpdateCommand.Parameters[2].Value = ((object)(0));
4502 this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(p4));
4503 }
4504 global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
4505 if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
4506 != global::System.Data.ConnectionState.Open)) {
4507 this.Adapter.UpdateCommand.Connection.Open();
4508 }
4509 try {
4510 int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
4511 return returnValue;
4512 }
4513 finally {
4514 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
4515 this.Adapter.UpdateCommand.Connection.Close();
4516 }
4517 }
4518 }
4519 }
4520
4524 [global::System.ComponentModel.DesignerCategoryAttribute("code")]
4525 [global::System.ComponentModel.ToolboxItem(true)]
4526 [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
4527 "esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
4528 [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
4529 public partial class TableAdapterManager : global::System.ComponentModel.Component {
4530
4531 private UpdateOrderOption _updateOrder;
4532
4533 private absenceTableAdapter _absenceTableAdapter;
4534
4535 private motifTableAdapter _motifTableAdapter;
4536
4537 private personnelTableAdapter _personnelTableAdapter;
4538
4539 private responsableTableAdapter _responsableTableAdapter;
4540
4541 private serviceTableAdapter _serviceTableAdapter;
4542
4543 private bool _backupDataSetBeforeUpdate;
4544
4545 private global::System.Data.IDbConnection _connection;
4546
4547 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4548 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4549 public UpdateOrderOption UpdateOrder {
4550 get {
4551 return this._updateOrder;
4552 }
4553 set {
4554 this._updateOrder = value;
4555 }
4556 }
4557
4558 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4559 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4560 [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
4561 "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
4562 "a", "System.Drawing.Design.UITypeEditor")]
4563 public absenceTableAdapter absenceTableAdapter {
4564 get {
4565 return this._absenceTableAdapter;
4566 }
4567 set {
4568 this._absenceTableAdapter = value;
4569 }
4570 }
4571
4572 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4573 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4574 [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
4575 "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
4576 "a", "System.Drawing.Design.UITypeEditor")]
4577 public motifTableAdapter motifTableAdapter {
4578 get {
4579 return this._motifTableAdapter;
4580 }
4581 set {
4582 this._motifTableAdapter = value;
4583 }
4584 }
4585
4586 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4587 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4588 [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
4589 "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
4590 "a", "System.Drawing.Design.UITypeEditor")]
4591 public personnelTableAdapter personnelTableAdapter {
4592 get {
4593 return this._personnelTableAdapter;
4594 }
4595 set {
4596 this._personnelTableAdapter = value;
4597 }
4598 }
4599
4600 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4601 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4602 [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
4603 "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
4604 "a", "System.Drawing.Design.UITypeEditor")]
4605 public responsableTableAdapter responsableTableAdapter {
4606 get {
4607 return this._responsableTableAdapter;
4608 }
4609 set {
4610 this._responsableTableAdapter = value;
4611 }
4612 }
4613
4614 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4615 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4616 [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
4617 "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
4618 "a", "System.Drawing.Design.UITypeEditor")]
4619 public serviceTableAdapter serviceTableAdapter {
4620 get {
4621 return this._serviceTableAdapter;
4622 }
4623 set {
4624 this._serviceTableAdapter = value;
4625 }
4626 }
4627
4628 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4629 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4630 public bool BackupDataSetBeforeUpdate {
4631 get {
4632 return this._backupDataSetBeforeUpdate;
4633 }
4634 set {
4635 this._backupDataSetBeforeUpdate = value;
4636 }
4637 }
4638
4639 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4640 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4641 [global::System.ComponentModel.Browsable(false)]
4642 public global::System.Data.IDbConnection Connection {
4643 get {
4644 if ((this._connection != null)) {
4645 return this._connection;
4646 }
4647 if (((this._absenceTableAdapter != null)
4648 && (this._absenceTableAdapter.Connection != null))) {
4649 return this._absenceTableAdapter.Connection;
4650 }
4651 if (((this._motifTableAdapter != null)
4652 && (this._motifTableAdapter.Connection != null))) {
4653 return this._motifTableAdapter.Connection;
4654 }
4655 if (((this._personnelTableAdapter != null)
4656 && (this._personnelTableAdapter.Connection != null))) {
4657 return this._personnelTableAdapter.Connection;
4658 }
4659 if (((this._responsableTableAdapter != null)
4660 && (this._responsableTableAdapter.Connection != null))) {
4661 return this._responsableTableAdapter.Connection;
4662 }
4663 if (((this._serviceTableAdapter != null)
4664 && (this._serviceTableAdapter.Connection != null))) {
4665 return this._serviceTableAdapter.Connection;
4666 }
4667 return null;
4668 }
4669 set {
4670 this._connection = value;
4671 }
4672 }
4673
4674 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4675 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4676 [global::System.ComponentModel.Browsable(false)]
4677 public int TableAdapterInstanceCount {
4678 get {
4679 int count = 0;
4680 if ((this._absenceTableAdapter != null)) {
4681 count = (count + 1);
4682 }
4683 if ((this._motifTableAdapter != null)) {
4684 count = (count + 1);
4685 }
4686 if ((this._personnelTableAdapter != null)) {
4687 count = (count + 1);
4688 }
4689 if ((this._responsableTableAdapter != null)) {
4690 count = (count + 1);
4691 }
4692 if ((this._serviceTableAdapter != null)) {
4693 count = (count + 1);
4694 }
4695 return count;
4696 }
4697 }
4698
4702 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4703 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4704 private int UpdateUpdatedRows(projetcnedDataSet dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
4705 int result = 0;
4706 if ((this._absenceTableAdapter != null)) {
4707 global::System.Data.DataRow[] updatedRows = dataSet.absence.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
4708 updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
4709 if (((updatedRows != null)
4710 && (0 < updatedRows.Length))) {
4711 result = (result + this._absenceTableAdapter.Update(updatedRows));
4712 allChangedRows.AddRange(updatedRows);
4713 }
4714 }
4715 if ((this._motifTableAdapter != null)) {
4716 global::System.Data.DataRow[] updatedRows = dataSet.motif.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
4717 updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
4718 if (((updatedRows != null)
4719 && (0 < updatedRows.Length))) {
4720 result = (result + this._motifTableAdapter.Update(updatedRows));
4721 allChangedRows.AddRange(updatedRows);
4722 }
4723 }
4724 if ((this._personnelTableAdapter != null)) {
4725 global::System.Data.DataRow[] updatedRows = dataSet.personnel.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
4726 updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
4727 if (((updatedRows != null)
4728 && (0 < updatedRows.Length))) {
4729 result = (result + this._personnelTableAdapter.Update(updatedRows));
4730 allChangedRows.AddRange(updatedRows);
4731 }
4732 }
4733 if ((this._responsableTableAdapter != null)) {
4734 global::System.Data.DataRow[] updatedRows = dataSet.responsable.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
4735 updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
4736 if (((updatedRows != null)
4737 && (0 < updatedRows.Length))) {
4738 result = (result + this._responsableTableAdapter.Update(updatedRows));
4739 allChangedRows.AddRange(updatedRows);
4740 }
4741 }
4742 if ((this._serviceTableAdapter != null)) {
4743 global::System.Data.DataRow[] updatedRows = dataSet.service.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
4744 updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
4745 if (((updatedRows != null)
4746 && (0 < updatedRows.Length))) {
4747 result = (result + this._serviceTableAdapter.Update(updatedRows));
4748 allChangedRows.AddRange(updatedRows);
4749 }
4750 }
4751 return result;
4752 }
4753
4757 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4758 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4759 private int UpdateInsertedRows(projetcnedDataSet dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
4760 int result = 0;
4761 if ((this._absenceTableAdapter != null)) {
4762 global::System.Data.DataRow[] addedRows = dataSet.absence.Select(null, null, global::System.Data.DataViewRowState.Added);
4763 if (((addedRows != null)
4764 && (0 < addedRows.Length))) {
4765 result = (result + this._absenceTableAdapter.Update(addedRows));
4766 allAddedRows.AddRange(addedRows);
4767 }
4768 }
4769 if ((this._motifTableAdapter != null)) {
4770 global::System.Data.DataRow[] addedRows = dataSet.motif.Select(null, null, global::System.Data.DataViewRowState.Added);
4771 if (((addedRows != null)
4772 && (0 < addedRows.Length))) {
4773 result = (result + this._motifTableAdapter.Update(addedRows));
4774 allAddedRows.AddRange(addedRows);
4775 }
4776 }
4777 if ((this._personnelTableAdapter != null)) {
4778 global::System.Data.DataRow[] addedRows = dataSet.personnel.Select(null, null, global::System.Data.DataViewRowState.Added);
4779 if (((addedRows != null)
4780 && (0 < addedRows.Length))) {
4781 result = (result + this._personnelTableAdapter.Update(addedRows));
4782 allAddedRows.AddRange(addedRows);
4783 }
4784 }
4785 if ((this._responsableTableAdapter != null)) {
4786 global::System.Data.DataRow[] addedRows = dataSet.responsable.Select(null, null, global::System.Data.DataViewRowState.Added);
4787 if (((addedRows != null)
4788 && (0 < addedRows.Length))) {
4789 result = (result + this._responsableTableAdapter.Update(addedRows));
4790 allAddedRows.AddRange(addedRows);
4791 }
4792 }
4793 if ((this._serviceTableAdapter != null)) {
4794 global::System.Data.DataRow[] addedRows = dataSet.service.Select(null, null, global::System.Data.DataViewRowState.Added);
4795 if (((addedRows != null)
4796 && (0 < addedRows.Length))) {
4797 result = (result + this._serviceTableAdapter.Update(addedRows));
4798 allAddedRows.AddRange(addedRows);
4799 }
4800 }
4801 return result;
4802 }
4803
4807 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4808 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4809 private int UpdateDeletedRows(projetcnedDataSet dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows) {
4810 int result = 0;
4811 if ((this._serviceTableAdapter != null)) {
4812 global::System.Data.DataRow[] deletedRows = dataSet.service.Select(null, null, global::System.Data.DataViewRowState.Deleted);
4813 if (((deletedRows != null)
4814 && (0 < deletedRows.Length))) {
4815 result = (result + this._serviceTableAdapter.Update(deletedRows));
4816 allChangedRows.AddRange(deletedRows);
4817 }
4818 }
4819 if ((this._responsableTableAdapter != null)) {
4820 global::System.Data.DataRow[] deletedRows = dataSet.responsable.Select(null, null, global::System.Data.DataViewRowState.Deleted);
4821 if (((deletedRows != null)
4822 && (0 < deletedRows.Length))) {
4823 result = (result + this._responsableTableAdapter.Update(deletedRows));
4824 allChangedRows.AddRange(deletedRows);
4825 }
4826 }
4827 if ((this._personnelTableAdapter != null)) {
4828 global::System.Data.DataRow[] deletedRows = dataSet.personnel.Select(null, null, global::System.Data.DataViewRowState.Deleted);
4829 if (((deletedRows != null)
4830 && (0 < deletedRows.Length))) {
4831 result = (result + this._personnelTableAdapter.Update(deletedRows));
4832 allChangedRows.AddRange(deletedRows);
4833 }
4834 }
4835 if ((this._motifTableAdapter != null)) {
4836 global::System.Data.DataRow[] deletedRows = dataSet.motif.Select(null, null, global::System.Data.DataViewRowState.Deleted);
4837 if (((deletedRows != null)
4838 && (0 < deletedRows.Length))) {
4839 result = (result + this._motifTableAdapter.Update(deletedRows));
4840 allChangedRows.AddRange(deletedRows);
4841 }
4842 }
4843 if ((this._absenceTableAdapter != null)) {
4844 global::System.Data.DataRow[] deletedRows = dataSet.absence.Select(null, null, global::System.Data.DataViewRowState.Deleted);
4845 if (((deletedRows != null)
4846 && (0 < deletedRows.Length))) {
4847 result = (result + this._absenceTableAdapter.Update(deletedRows));
4848 allChangedRows.AddRange(deletedRows);
4849 }
4850 }
4851 return result;
4852 }
4853
4857 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4858 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4859 private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
4860 if (((updatedRows == null)
4861 || (updatedRows.Length < 1))) {
4862 return updatedRows;
4863 }
4864 if (((allAddedRows == null)
4865 || (allAddedRows.Count < 1))) {
4866 return updatedRows;
4867 }
4868 global::System.Collections.Generic.List<global::System.Data.DataRow> realUpdatedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
4869 for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
4870 global::System.Data.DataRow row = updatedRows[i];
4871 if ((allAddedRows.Contains(row) == false)) {
4872 realUpdatedRows.Add(row);
4873 }
4874 }
4875 return realUpdatedRows.ToArray();
4876 }
4877
4881 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
4882 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
4883 public virtual int UpdateAll(projetcnedDataSet dataSet) {
4884 if ((dataSet == null)) {
4885 throw new global::System.ArgumentNullException("dataSet");
4886 }
4887 if ((dataSet.HasChanges() == false)) {
4888 return 0;
4889 }
4890 if (((this._absenceTableAdapter != null)
4891 && (this.MatchTableAdapterConnection(this._absenceTableAdapter.Connection) == false))) {
4892 throw new global::System.ArgumentException("Tous les TableAdapters managés par un TableAdapterManager doivent utiliser la mêm" +
4893 "e chaîne de connexion.");
4894 }
4895 if (((this._motifTableAdapter != null)
4896 && (this.MatchTableAdapterConnection(this._motifTableAdapter.Connection) == false))) {
4897 throw new global::System.ArgumentException("Tous les TableAdapters managés par un TableAdapterManager doivent utiliser la mêm" +
4898 "e chaîne de connexion.");
4899 }
4900 if (((this._personnelTableAdapter != null)
4901 && (this.MatchTableAdapterConnection(this._personnelTableAdapter.Connection) == false))) {
4902 throw new global::System.ArgumentException("Tous les TableAdapters managés par un TableAdapterManager doivent utiliser la mêm" +
4903 "e chaîne de connexion.");
4904 }
4905 if (((this._responsableTableAdapter != null)
4906 && (this.MatchTableAdapterConnection(this._responsableTableAdapter.Connection) == false))) {
4907 throw new global::System.ArgumentException("Tous les TableAdapters managés par un TableAdapterManager doivent utiliser la mêm" +
4908 "e chaîne de connexion.");
4909 }
4910 if (((this._serviceTableAdapter != null)
4911 && (this.MatchTableAdapterConnection(this._serviceTableAdapter.Connection) == false))) {
4912 throw new global::System.ArgumentException("Tous les TableAdapters managés par un TableAdapterManager doivent utiliser la mêm" +
4913 "e chaîne de connexion.");
4914 }
4915 global::System.Data.IDbConnection workConnection = this.Connection;
4916 if ((workConnection == null)) {
4917 throw new global::System.ApplicationException("TableAdapterManager ne contient pas d\'informations de connexion. Définissez chaqu" +
4918 "e propriété TableAdapterManager TableAdapter à une instance valide de TableAdapt" +
4919 "er.");
4920 }
4921 bool workConnOpened = false;
4922 if (((workConnection.State & global::System.Data.ConnectionState.Broken)
4923 == global::System.Data.ConnectionState.Broken)) {
4924 workConnection.Close();
4925 }
4926 if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
4927 workConnection.Open();
4928 workConnOpened = true;
4929 }
4930 global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
4931 if ((workTransaction == null)) {
4932 throw new global::System.ApplicationException("La transaction ne peut pas commencer. La connexion de données actuelle ne prend p" +
4933 "as en charge les transactions ou l\'état actuel n\'autorise pas le début de la tra" +
4934 "nsaction.");
4935 }
4936 global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
4937 global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
4938 global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter> adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter>();
4939 global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection> revertConnections = new global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection>();
4940 int result = 0;
4941 global::System.Data.DataSet backupDataSet = null;
4942 if (this.BackupDataSetBeforeUpdate) {
4943 backupDataSet = new global::System.Data.DataSet();
4944 backupDataSet.Merge(dataSet);
4945 }
4946 try {
4947 // ---- Prepare for update -----------
4948 //
4949 if ((this._absenceTableAdapter != null)) {
4950 revertConnections.Add(this._absenceTableAdapter, this._absenceTableAdapter.Connection);
4951 this._absenceTableAdapter.Connection = ((global::MySql.Data.MySqlClient.MySqlConnection)(workConnection));
4952 this._absenceTableAdapter.Transaction = ((global::MySql.Data.MySqlClient.MySqlTransaction)(workTransaction));
4953 if (this._absenceTableAdapter.Adapter.AcceptChangesDuringUpdate) {
4954 this._absenceTableAdapter.Adapter.AcceptChangesDuringUpdate = false;
4955 adaptersWithAcceptChangesDuringUpdate.Add(this._absenceTableAdapter.Adapter);
4956 }
4957 }
4958 if ((this._motifTableAdapter != null)) {
4959 revertConnections.Add(this._motifTableAdapter, this._motifTableAdapter.Connection);
4960 this._motifTableAdapter.Connection = ((global::MySql.Data.MySqlClient.MySqlConnection)(workConnection));
4961 this._motifTableAdapter.Transaction = ((global::MySql.Data.MySqlClient.MySqlTransaction)(workTransaction));
4962 if (this._motifTableAdapter.Adapter.AcceptChangesDuringUpdate) {
4963 this._motifTableAdapter.Adapter.AcceptChangesDuringUpdate = false;
4964 adaptersWithAcceptChangesDuringUpdate.Add(this._motifTableAdapter.Adapter);
4965 }
4966 }
4967 if ((this._personnelTableAdapter != null)) {
4968 revertConnections.Add(this._personnelTableAdapter, this._personnelTableAdapter.Connection);
4969 this._personnelTableAdapter.Connection = ((global::MySql.Data.MySqlClient.MySqlConnection)(workConnection));
4970 this._personnelTableAdapter.Transaction = ((global::MySql.Data.MySqlClient.MySqlTransaction)(workTransaction));
4971 if (this._personnelTableAdapter.Adapter.AcceptChangesDuringUpdate) {
4972 this._personnelTableAdapter.Adapter.AcceptChangesDuringUpdate = false;
4973 adaptersWithAcceptChangesDuringUpdate.Add(this._personnelTableAdapter.Adapter);
4974 }
4975 }
4976 if ((this._responsableTableAdapter != null)) {
4977 revertConnections.Add(this._responsableTableAdapter, this._responsableTableAdapter.Connection);
4978 this._responsableTableAdapter.Connection = ((global::MySql.Data.MySqlClient.MySqlConnection)(workConnection));
4979 this._responsableTableAdapter.Transaction = ((global::MySql.Data.MySqlClient.MySqlTransaction)(workTransaction));
4980 if (this._responsableTableAdapter.Adapter.AcceptChangesDuringUpdate) {
4981 this._responsableTableAdapter.Adapter.AcceptChangesDuringUpdate = false;
4982 adaptersWithAcceptChangesDuringUpdate.Add(this._responsableTableAdapter.Adapter);
4983 }
4984 }
4985 if ((this._serviceTableAdapter != null)) {
4986 revertConnections.Add(this._serviceTableAdapter, this._serviceTableAdapter.Connection);
4987 this._serviceTableAdapter.Connection = ((global::MySql.Data.MySqlClient.MySqlConnection)(workConnection));
4988 this._serviceTableAdapter.Transaction = ((global::MySql.Data.MySqlClient.MySqlTransaction)(workTransaction));
4989 if (this._serviceTableAdapter.Adapter.AcceptChangesDuringUpdate) {
4990 this._serviceTableAdapter.Adapter.AcceptChangesDuringUpdate = false;
4991 adaptersWithAcceptChangesDuringUpdate.Add(this._serviceTableAdapter.Adapter);
4992 }
4993 }
4994 //
4995 //---- Perform updates -----------
4996 //
4997 if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) {
4998 result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
4999 result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
5000 }
5001 else {
5002 result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
5003 result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
5004 }
5005 result = (result + this.UpdateDeletedRows(dataSet, allChangedRows));
5006 //
5007 //---- Commit updates -----------
5008 //
5009 workTransaction.Commit();
5010 if ((0 < allAddedRows.Count)) {
5011 global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
5012 allAddedRows.CopyTo(rows);
5013 for (int i = 0; (i < rows.Length); i = (i + 1)) {
5014 global::System.Data.DataRow row = rows[i];
5015 row.AcceptChanges();
5016 }
5017 }
5018 if ((0 < allChangedRows.Count)) {
5019 global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count];
5020 allChangedRows.CopyTo(rows);
5021 for (int i = 0; (i < rows.Length); i = (i + 1)) {
5022 global::System.Data.DataRow row = rows[i];
5023 row.AcceptChanges();
5024 }
5025 }
5026 }
5027 catch (global::System.Exception ex) {
5028 workTransaction.Rollback();
5029 // ---- Restore the dataset -----------
5030 if (this.BackupDataSetBeforeUpdate) {
5031 global::System.Diagnostics.Debug.Assert((backupDataSet != null));
5032 dataSet.Clear();
5033 dataSet.Merge(backupDataSet);
5034 }
5035 else {
5036 if ((0 < allAddedRows.Count)) {
5037 global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
5038 allAddedRows.CopyTo(rows);
5039 for (int i = 0; (i < rows.Length); i = (i + 1)) {
5040 global::System.Data.DataRow row = rows[i];
5041 row.AcceptChanges();
5042 row.SetAdded();
5043 }
5044 }
5045 }
5046 throw ex;
5047 }
5048 finally {
5049 if (workConnOpened) {
5050 workConnection.Close();
5051 }
5052 if ((this._absenceTableAdapter != null)) {
5053 this._absenceTableAdapter.Connection = ((global::MySql.Data.MySqlClient.MySqlConnection)(revertConnections[this._absenceTableAdapter]));
5054 this._absenceTableAdapter.Transaction = null;
5055 }
5056 if ((this._motifTableAdapter != null)) {
5057 this._motifTableAdapter.Connection = ((global::MySql.Data.MySqlClient.MySqlConnection)(revertConnections[this._motifTableAdapter]));
5058 this._motifTableAdapter.Transaction = null;
5059 }
5060 if ((this._personnelTableAdapter != null)) {
5061 this._personnelTableAdapter.Connection = ((global::MySql.Data.MySqlClient.MySqlConnection)(revertConnections[this._personnelTableAdapter]));
5062 this._personnelTableAdapter.Transaction = null;
5063 }
5064 if ((this._responsableTableAdapter != null)) {
5065 this._responsableTableAdapter.Connection = ((global::MySql.Data.MySqlClient.MySqlConnection)(revertConnections[this._responsableTableAdapter]));
5066 this._responsableTableAdapter.Transaction = null;
5067 }
5068 if ((this._serviceTableAdapter != null)) {
5069 this._serviceTableAdapter.Connection = ((global::MySql.Data.MySqlClient.MySqlConnection)(revertConnections[this._serviceTableAdapter]));
5070 this._serviceTableAdapter.Transaction = null;
5071 }
5072 if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) {
5073 global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count];
5074 adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters);
5075 for (int i = 0; (i < adapters.Length); i = (i + 1)) {
5076 global::System.Data.Common.DataAdapter adapter = adapters[i];
5077 adapter.AcceptChangesDuringUpdate = true;
5078 }
5079 }
5080 }
5081 return result;
5082 }
5083
5084 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
5085 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
5086 protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) {
5087 global::System.Array.Sort<global::System.Data.DataRow>(rows, new SelfReferenceComparer(relation, childFirst));
5088 }
5089
5090 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
5091 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
5092 protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) {
5093 if ((this._connection != null)) {
5094 return true;
5095 }
5096 if (((this.Connection == null)
5097 || (inputConnection == null))) {
5098 return true;
5099 }
5100 if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) {
5101 return true;
5102 }
5103 return false;
5104 }
5105
5109 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
5110 public enum UpdateOrderOption {
5111
5112 InsertUpdateDelete = 0,
5113
5114 UpdateInsertDelete = 1,
5115 }
5116
5120 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
5121 private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer<global::System.Data.DataRow> {
5122
5123 private global::System.Data.DataRelation _relation;
5124
5125 private int _childFirst;
5126
5127 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
5128 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
5129 internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) {
5130 this._relation = relation;
5131 if (childFirst) {
5132 this._childFirst = -1;
5133 }
5134 else {
5135 this._childFirst = 1;
5136 }
5137 }
5138
5139 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
5140 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
5141 private global::System.Data.DataRow GetRoot(global::System.Data.DataRow row, out int distance) {
5142 global::System.Diagnostics.Debug.Assert((row != null));
5143 global::System.Data.DataRow root = row;
5144 distance = 0;
5145
5146 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>();
5147 traversedRows[row] = row;
5148
5149 global::System.Data.DataRow parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
5150 for (
5151 ; ((parent != null)
5152 && (traversedRows.ContainsKey(parent) == false));
5153 ) {
5154 distance = (distance + 1);
5155 root = parent;
5156 traversedRows[parent] = parent;
5157 parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
5158 }
5159
5160 if ((distance == 0)) {
5161 traversedRows.Clear();
5162 traversedRows[row] = row;
5163 parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
5164 for (
5165 ; ((parent != null)
5166 && (traversedRows.ContainsKey(parent) == false));
5167 ) {
5168 distance = (distance + 1);
5169 root = parent;
5170 traversedRows[parent] = parent;
5171 parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
5172 }
5173 }
5174
5175 return root;
5176 }
5177
5178 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
5179 [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
5180 public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) {
5181 if (object.ReferenceEquals(row1, row2)) {
5182 return 0;
5183 }
5184 if ((row1 == null)) {
5185 return -1;
5186 }
5187 if ((row2 == null)) {
5188 return 1;
5189 }
5190
5191 int distance1 = 0;
5192 global::System.Data.DataRow root1 = this.GetRoot(row1, out distance1);
5193
5194 int distance2 = 0;
5195 global::System.Data.DataRow root2 = this.GetRoot(row2, out distance2);
5196
5197 if (object.ReferenceEquals(root1, root2)) {
5198 return (this._childFirst * distance1.CompareTo(distance2));
5199 }
5200 else {
5201 global::System.Diagnostics.Debug.Assert(((root1.Table != null)
5202 && (root2.Table != null)));
5203 if ((root1.Table.Rows.IndexOf(root1) < root2.Table.Rows.IndexOf(root2))) {
5204 return -1;
5205 }
5206 else {
5207 return 1;
5208 }
5209 }
5210 }
5211 }
5212 }
5213}
5214
5215#pragma warning restore 1591
MediaTek.DataBase.projetcnedDataSet.absenceDataTable
Represents the strongly named DataTable class. /summary>
Definition: projetcnedDataSet.Designer.cs:420
MediaTek.DataBase.projetcnedDataSet.absenceRow
Represents strongly named DataRow class. /summary>
Definition: projetcnedDataSet.Designer.cs:1874
MediaTek.DataBase.projetcnedDataSet.motifDataTable
Represents the strongly named DataTable class. /summary>
Definition: projetcnedDataSet.Designer.cs:723
MediaTek.DataBase.projetcnedDataSet.motifRow
Represents strongly named DataRow class. /summary>
Definition: projetcnedDataSet.Designer.cs:1950
MediaTek.DataBase.projetcnedDataSet.personnelDataTable
Represents the strongly named DataTable class. /summary>
Definition: projetcnedDataSet.Designer.cs:999
MediaTek.DataBase.projetcnedDataSet.personnelRow
Represents strongly named DataRow class. /summary>
Definition: projetcnedDataSet.Designer.cs:2004
MediaTek.DataBase.projetcnedDataSet.responsableDataTable
Represents the strongly named DataTable class. /summary>
Definition: projetcnedDataSet.Designer.cs:1335
MediaTek.DataBase.projetcnedDataSet.responsableRow
Represents strongly named DataRow class. /summary>
Definition: projetcnedDataSet.Designer.cs:2153
MediaTek.DataBase.projetcnedDataSet.serviceDataTable
Represents the strongly named DataTable class. /summary>
Definition: projetcnedDataSet.Designer.cs:1600
MediaTek.DataBase.projetcnedDataSet.serviceRow
Represents strongly named DataRow class. /summary>
Definition: projetcnedDataSet.Designer.cs:2190
MediaTek.DataBase.projetcnedDataSet
Represents a strongly typed in-memory cache of data. /summary>
Definition: projetcnedDataSet.Designer.cs:25
MediaTek.DataBase.projetcnedDataSetTableAdapters.TableAdapterManager
TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update ...
Definition: projetcnedDataSet.Designer.cs:4529
MediaTek.DataBase.projetcnedDataSetTableAdapters.TableAdapterManager.UpdateInsertedRows
int UpdateInsertedRows(projetcnedDataSet dataSet, global::System.Collections.Generic.List< global::System.Data.DataRow > allAddedRows)
Insert rows in top-down order. /summary>
Definition: projetcnedDataSet.Designer.cs:4759
MediaTek.DataBase.projetcnedDataSetTableAdapters.TableAdapterManager.UpdateAll
virtual int UpdateAll(projetcnedDataSet dataSet)
Update all changes to the dataset. /summary>
Definition: projetcnedDataSet.Designer.cs:4883
MediaTek.DataBase.projetcnedDataSetTableAdapters.TableAdapterManager.UpdateUpdatedRows
int UpdateUpdatedRows(projetcnedDataSet dataSet, global::System.Collections.Generic.List< global::System.Data.DataRow > allChangedRows, global::System.Collections.Generic.List< global::System.Data.DataRow > allAddedRows)
Update rows in top-down order. /summary>
Definition: projetcnedDataSet.Designer.cs:4704
MediaTek.DataBase.projetcnedDataSetTableAdapters.TableAdapterManager.GetRealUpdatedRows
global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List< global::System.Data.DataRow > allAddedRows)
Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first ...
Definition: projetcnedDataSet.Designer.cs:4859
MediaTek.DataBase.projetcnedDataSetTableAdapters.TableAdapterManager.UpdateDeletedRows
int UpdateDeletedRows(projetcnedDataSet dataSet, global::System.Collections.Generic.List< global::System.Data.DataRow > allChangedRows)
Delete rows in bottom-up order. /summary>
Definition: projetcnedDataSet.Designer.cs:4809
MediaTek.DataBase.projetcnedDataSetTableAdapters.absenceTableAdapter
Represents the connection and commands used to retrieve and save data. /summary>
Definition: projetcnedDataSet.Designer.cs:2424
MediaTek.DataBase.projetcnedDataSetTableAdapters.motifTableAdapter
Represents the connection and commands used to retrieve and save data. /summary>
Definition: projetcnedDataSet.Designer.cs:2896
MediaTek.DataBase.projetcnedDataSetTableAdapters.personnelTableAdapter
Represents the connection and commands used to retrieve and save data. /summary>
Definition: projetcnedDataSet.Designer.cs:3266
MediaTek.DataBase.projetcnedDataSetTableAdapters.responsableTableAdapter
Represents the connection and commands used to retrieve and save data. /summary>
Definition: projetcnedDataSet.Designer.cs:3910
MediaTek.DataBase.projetcnedDataSetTableAdapters.serviceTableAdapter
Represents the connection and commands used to retrieve and save data. /summary>
Definition: projetcnedDataSet.Designer.cs:4160