_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7.Designer.cs 90 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618
  1. //------------------------------------------------------------------------------
  2. // <auto-generated>
  3. // Этот код создан программой.
  4. // Исполняемая версия:4.0.30319.42000
  5. //
  6. // Изменения в этом файле могут привести к неправильной работе и будут потеряны в случае
  7. // повторной генерации кода.
  8. // </auto-generated>
  9. //------------------------------------------------------------------------------
  10. #pragma warning disable 1591
  11. namespace Юсову_Владислав_ИСП_11._18._3 {
  12. /// <summary>
  13. ///Represents a strongly typed in-memory cache of data.
  14. ///</summary>
  15. [global::System.Serializable()]
  16. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  17. [global::System.ComponentModel.ToolboxItem(true)]
  18. [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")]
  19. [global::System.Xml.Serialization.XmlRootAttribute("_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7")]
  20. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
  21. public partial class _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7 : global::System.Data.DataSet {
  22. private yusov1DataTable tableyusov1;
  23. private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
  24. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  25. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  26. public _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7() {
  27. this.BeginInit();
  28. this.InitClass();
  29. global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
  30. base.Tables.CollectionChanged += schemaChangedHandler;
  31. base.Relations.CollectionChanged += schemaChangedHandler;
  32. this.EndInit();
  33. }
  34. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  35. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  36. protected _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
  37. base(info, context, false) {
  38. if ((this.IsBinarySerialized(info, context) == true)) {
  39. this.InitVars(false);
  40. global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
  41. this.Tables.CollectionChanged += schemaChangedHandler1;
  42. this.Relations.CollectionChanged += schemaChangedHandler1;
  43. return;
  44. }
  45. string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
  46. if ((this.DetermineSchemaSerializationMode(info, context) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
  47. global::System.Data.DataSet ds = new global::System.Data.DataSet();
  48. ds.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
  49. if ((ds.Tables["yusov1"] != null)) {
  50. base.Tables.Add(new yusov1DataTable(ds.Tables["yusov1"]));
  51. }
  52. this.DataSetName = ds.DataSetName;
  53. this.Prefix = ds.Prefix;
  54. this.Namespace = ds.Namespace;
  55. this.Locale = ds.Locale;
  56. this.CaseSensitive = ds.CaseSensitive;
  57. this.EnforceConstraints = ds.EnforceConstraints;
  58. this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
  59. this.InitVars();
  60. }
  61. else {
  62. this.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
  63. }
  64. this.GetSerializationData(info, context);
  65. global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
  66. base.Tables.CollectionChanged += schemaChangedHandler;
  67. this.Relations.CollectionChanged += schemaChangedHandler;
  68. }
  69. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  70. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  71. [global::System.ComponentModel.Browsable(false)]
  72. [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
  73. public yusov1DataTable yusov1 {
  74. get {
  75. return this.tableyusov1;
  76. }
  77. }
  78. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  79. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  80. [global::System.ComponentModel.BrowsableAttribute(true)]
  81. [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Visible)]
  82. public override global::System.Data.SchemaSerializationMode SchemaSerializationMode {
  83. get {
  84. return this._schemaSerializationMode;
  85. }
  86. set {
  87. this._schemaSerializationMode = value;
  88. }
  89. }
  90. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  91. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  92. [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
  93. public new global::System.Data.DataTableCollection Tables {
  94. get {
  95. return base.Tables;
  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.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
  101. public new global::System.Data.DataRelationCollection Relations {
  102. get {
  103. return base.Relations;
  104. }
  105. }
  106. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  107. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  108. protected override void InitializeDerivedDataSet() {
  109. this.BeginInit();
  110. this.InitClass();
  111. this.EndInit();
  112. }
  113. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  114. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  115. public override global::System.Data.DataSet Clone() {
  116. _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7 cln = ((_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7)(base.Clone()));
  117. cln.InitVars();
  118. cln.SchemaSerializationMode = this.SchemaSerializationMode;
  119. return cln;
  120. }
  121. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  122. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  123. protected override bool ShouldSerializeTables() {
  124. return false;
  125. }
  126. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  127. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  128. protected override bool ShouldSerializeRelations() {
  129. return false;
  130. }
  131. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  132. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  133. protected override void ReadXmlSerializable(global::System.Xml.XmlReader reader) {
  134. if ((this.DetermineSchemaSerializationMode(reader) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
  135. this.Reset();
  136. global::System.Data.DataSet ds = new global::System.Data.DataSet();
  137. ds.ReadXml(reader);
  138. if ((ds.Tables["yusov1"] != null)) {
  139. base.Tables.Add(new yusov1DataTable(ds.Tables["yusov1"]));
  140. }
  141. this.DataSetName = ds.DataSetName;
  142. this.Prefix = ds.Prefix;
  143. this.Namespace = ds.Namespace;
  144. this.Locale = ds.Locale;
  145. this.CaseSensitive = ds.CaseSensitive;
  146. this.EnforceConstraints = ds.EnforceConstraints;
  147. this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
  148. this.InitVars();
  149. }
  150. else {
  151. this.ReadXml(reader);
  152. this.InitVars();
  153. }
  154. }
  155. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  156. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  157. protected override global::System.Xml.Schema.XmlSchema GetSchemaSerializable() {
  158. global::System.IO.MemoryStream stream = new global::System.IO.MemoryStream();
  159. this.WriteXmlSchema(new global::System.Xml.XmlTextWriter(stream, null));
  160. stream.Position = 0;
  161. return global::System.Xml.Schema.XmlSchema.Read(new global::System.Xml.XmlTextReader(stream), null);
  162. }
  163. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  164. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  165. internal void InitVars() {
  166. this.InitVars(true);
  167. }
  168. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  169. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  170. internal void InitVars(bool initTable) {
  171. this.tableyusov1 = ((yusov1DataTable)(base.Tables["yusov1"]));
  172. if ((initTable == true)) {
  173. if ((this.tableyusov1 != null)) {
  174. this.tableyusov1.InitVars();
  175. }
  176. }
  177. }
  178. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  179. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  180. private void InitClass() {
  181. this.DataSetName = "_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7";
  182. this.Prefix = "";
  183. this.Namespace = "http://tempuri.org/_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7.xsd";
  184. this.EnforceConstraints = true;
  185. this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
  186. this.tableyusov1 = new yusov1DataTable();
  187. base.Tables.Add(this.tableyusov1);
  188. }
  189. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  190. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  191. private bool ShouldSerializeyusov1() {
  192. return false;
  193. }
  194. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  195. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  196. private void SchemaChanged(object sender, global::System.ComponentModel.CollectionChangeEventArgs e) {
  197. if ((e.Action == global::System.ComponentModel.CollectionChangeAction.Remove)) {
  198. this.InitVars();
  199. }
  200. }
  201. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  202. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  203. public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
  204. _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7 ds = new _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7();
  205. global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
  206. global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
  207. global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
  208. any.Namespace = ds.Namespace;
  209. sequence.Items.Add(any);
  210. type.Particle = sequence;
  211. global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
  212. if (xs.Contains(dsSchema.TargetNamespace)) {
  213. global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
  214. global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
  215. try {
  216. global::System.Xml.Schema.XmlSchema schema = null;
  217. dsSchema.Write(s1);
  218. for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
  219. schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
  220. s2.SetLength(0);
  221. schema.Write(s2);
  222. if ((s1.Length == s2.Length)) {
  223. s1.Position = 0;
  224. s2.Position = 0;
  225. for (; ((s1.Position != s1.Length)
  226. && (s1.ReadByte() == s2.ReadByte())); ) {
  227. ;
  228. }
  229. if ((s1.Position == s1.Length)) {
  230. return type;
  231. }
  232. }
  233. }
  234. }
  235. finally {
  236. if ((s1 != null)) {
  237. s1.Close();
  238. }
  239. if ((s2 != null)) {
  240. s2.Close();
  241. }
  242. }
  243. }
  244. xs.Add(dsSchema);
  245. return type;
  246. }
  247. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  248. public delegate void yusov1RowChangeEventHandler(object sender, yusov1RowChangeEvent e);
  249. /// <summary>
  250. ///Represents the strongly named DataTable class.
  251. ///</summary>
  252. [global::System.Serializable()]
  253. [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
  254. public partial class yusov1DataTable : global::System.Data.TypedTableBase<yusov1Row> {
  255. private global::System.Data.DataColumn columnФамилия;
  256. private global::System.Data.DataColumn columnИмя;
  257. private global::System.Data.DataColumn columnОтчество;
  258. private global::System.Data.DataColumn columnПол;
  259. private global::System.Data.DataColumn columnТелефон;
  260. private global::System.Data.DataColumn columnДата_рождения;
  261. private global::System.Data.DataColumn columnEmail;
  262. private global::System.Data.DataColumn columnДата_регистрации;
  263. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  264. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  265. public yusov1DataTable() {
  266. this.TableName = "yusov1";
  267. this.BeginInit();
  268. this.InitClass();
  269. this.EndInit();
  270. }
  271. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  272. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  273. internal yusov1DataTable(global::System.Data.DataTable table) {
  274. this.TableName = table.TableName;
  275. if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
  276. this.CaseSensitive = table.CaseSensitive;
  277. }
  278. if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
  279. this.Locale = table.Locale;
  280. }
  281. if ((table.Namespace != table.DataSet.Namespace)) {
  282. this.Namespace = table.Namespace;
  283. }
  284. this.Prefix = table.Prefix;
  285. this.MinimumCapacity = table.MinimumCapacity;
  286. }
  287. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  288. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  289. protected yusov1DataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
  290. base(info, context) {
  291. this.InitVars();
  292. }
  293. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  294. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  295. public global::System.Data.DataColumn ФамилияColumn {
  296. get {
  297. return this.columnФамилия;
  298. }
  299. }
  300. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  301. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  302. public global::System.Data.DataColumn ИмяColumn {
  303. get {
  304. return this.columnИмя;
  305. }
  306. }
  307. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  308. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  309. public global::System.Data.DataColumn ОтчествоColumn {
  310. get {
  311. return this.columnОтчество;
  312. }
  313. }
  314. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  315. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  316. public global::System.Data.DataColumn ПолColumn {
  317. get {
  318. return this.columnПол;
  319. }
  320. }
  321. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  322. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  323. public global::System.Data.DataColumn ТелефонColumn {
  324. get {
  325. return this.columnТелефон;
  326. }
  327. }
  328. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  329. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  330. public global::System.Data.DataColumn Дата_рожденияColumn {
  331. get {
  332. return this.columnДата_рождения;
  333. }
  334. }
  335. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  336. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  337. public global::System.Data.DataColumn EmailColumn {
  338. get {
  339. return this.columnEmail;
  340. }
  341. }
  342. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  343. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  344. public global::System.Data.DataColumn Дата_регистрацииColumn {
  345. get {
  346. return this.columnДата_регистрации;
  347. }
  348. }
  349. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  350. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  351. [global::System.ComponentModel.Browsable(false)]
  352. public int Count {
  353. get {
  354. return this.Rows.Count;
  355. }
  356. }
  357. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  358. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  359. public yusov1Row this[int index] {
  360. get {
  361. return ((yusov1Row)(this.Rows[index]));
  362. }
  363. }
  364. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  365. public event yusov1RowChangeEventHandler yusov1RowChanging;
  366. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  367. public event yusov1RowChangeEventHandler yusov1RowChanged;
  368. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  369. public event yusov1RowChangeEventHandler yusov1RowDeleting;
  370. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  371. public event yusov1RowChangeEventHandler yusov1RowDeleted;
  372. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  373. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  374. public void Addyusov1Row(yusov1Row row) {
  375. this.Rows.Add(row);
  376. }
  377. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  378. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  379. public yusov1Row Addyusov1Row(string Фамилия, string Имя, string Отчество, string Пол, string Телефон, System.DateTime Дата_рождения, string Email, System.DateTime Дата_регистрации) {
  380. yusov1Row rowyusov1Row = ((yusov1Row)(this.NewRow()));
  381. object[] columnValuesArray = new object[] {
  382. Фамилия,
  383. Имя,
  384. Отчество,
  385. Пол,
  386. Телефон,
  387. Дата_рождения,
  388. Email,
  389. Дата_регистрации};
  390. rowyusov1Row.ItemArray = columnValuesArray;
  391. this.Rows.Add(rowyusov1Row);
  392. return rowyusov1Row;
  393. }
  394. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  395. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  396. public override global::System.Data.DataTable Clone() {
  397. yusov1DataTable cln = ((yusov1DataTable)(base.Clone()));
  398. cln.InitVars();
  399. return cln;
  400. }
  401. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  402. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  403. protected override global::System.Data.DataTable CreateInstance() {
  404. return new yusov1DataTable();
  405. }
  406. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  407. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  408. internal void InitVars() {
  409. this.columnФамилия = base.Columns["Фамилия"];
  410. this.columnИмя = base.Columns["Имя"];
  411. this.columnОтчество = base.Columns["Отчество"];
  412. this.columnПол = base.Columns["Пол"];
  413. this.columnТелефон = base.Columns["Телефон"];
  414. this.columnДата_рождения = base.Columns["Дата_рождения"];
  415. this.columnEmail = base.Columns["Email"];
  416. this.columnДата_регистрации = base.Columns["Дата_регистрации"];
  417. }
  418. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  419. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  420. private void InitClass() {
  421. this.columnФамилия = new global::System.Data.DataColumn("Фамилия", typeof(string), null, global::System.Data.MappingType.Element);
  422. base.Columns.Add(this.columnФамилия);
  423. this.columnИмя = new global::System.Data.DataColumn("Имя", typeof(string), null, global::System.Data.MappingType.Element);
  424. base.Columns.Add(this.columnИмя);
  425. this.columnОтчество = new global::System.Data.DataColumn("Отчество", typeof(string), null, global::System.Data.MappingType.Element);
  426. base.Columns.Add(this.columnОтчество);
  427. this.columnПол = new global::System.Data.DataColumn("Пол", typeof(string), null, global::System.Data.MappingType.Element);
  428. base.Columns.Add(this.columnПол);
  429. this.columnТелефон = new global::System.Data.DataColumn("Телефон", typeof(string), null, global::System.Data.MappingType.Element);
  430. base.Columns.Add(this.columnТелефон);
  431. this.columnДата_рождения = new global::System.Data.DataColumn("Дата_рождения", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
  432. base.Columns.Add(this.columnДата_рождения);
  433. this.columnEmail = new global::System.Data.DataColumn("Email", typeof(string), null, global::System.Data.MappingType.Element);
  434. base.Columns.Add(this.columnEmail);
  435. this.columnДата_регистрации = new global::System.Data.DataColumn("Дата_регистрации", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
  436. base.Columns.Add(this.columnДата_регистрации);
  437. this.columnФамилия.MaxLength = 50;
  438. this.columnИмя.MaxLength = 50;
  439. this.columnОтчество.MaxLength = 50;
  440. this.columnПол.MaxLength = 50;
  441. this.columnТелефон.MaxLength = 50;
  442. this.columnEmail.MaxLength = 50;
  443. }
  444. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  445. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  446. public yusov1Row Newyusov1Row() {
  447. return ((yusov1Row)(this.NewRow()));
  448. }
  449. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  450. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  451. protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
  452. return new yusov1Row(builder);
  453. }
  454. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  455. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  456. protected override global::System.Type GetRowType() {
  457. return typeof(yusov1Row);
  458. }
  459. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  460. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  461. protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
  462. base.OnRowChanged(e);
  463. if ((this.yusov1RowChanged != null)) {
  464. this.yusov1RowChanged(this, new yusov1RowChangeEvent(((yusov1Row)(e.Row)), e.Action));
  465. }
  466. }
  467. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  468. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  469. protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
  470. base.OnRowChanging(e);
  471. if ((this.yusov1RowChanging != null)) {
  472. this.yusov1RowChanging(this, new yusov1RowChangeEvent(((yusov1Row)(e.Row)), e.Action));
  473. }
  474. }
  475. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  476. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  477. protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
  478. base.OnRowDeleted(e);
  479. if ((this.yusov1RowDeleted != null)) {
  480. this.yusov1RowDeleted(this, new yusov1RowChangeEvent(((yusov1Row)(e.Row)), e.Action));
  481. }
  482. }
  483. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  484. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  485. protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
  486. base.OnRowDeleting(e);
  487. if ((this.yusov1RowDeleting != null)) {
  488. this.yusov1RowDeleting(this, new yusov1RowChangeEvent(((yusov1Row)(e.Row)), e.Action));
  489. }
  490. }
  491. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  492. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  493. public void Removeyusov1Row(yusov1Row row) {
  494. this.Rows.Remove(row);
  495. }
  496. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  497. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  498. public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
  499. global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
  500. global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
  501. _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7 ds = new _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7();
  502. global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
  503. any1.Namespace = "http://www.w3.org/2001/XMLSchema";
  504. any1.MinOccurs = new decimal(0);
  505. any1.MaxOccurs = decimal.MaxValue;
  506. any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  507. sequence.Items.Add(any1);
  508. global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
  509. any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  510. any2.MinOccurs = new decimal(1);
  511. any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  512. sequence.Items.Add(any2);
  513. global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
  514. attribute1.Name = "namespace";
  515. attribute1.FixedValue = ds.Namespace;
  516. type.Attributes.Add(attribute1);
  517. global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
  518. attribute2.Name = "tableTypeName";
  519. attribute2.FixedValue = "yusov1DataTable";
  520. type.Attributes.Add(attribute2);
  521. type.Particle = sequence;
  522. global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
  523. if (xs.Contains(dsSchema.TargetNamespace)) {
  524. global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
  525. global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
  526. try {
  527. global::System.Xml.Schema.XmlSchema schema = null;
  528. dsSchema.Write(s1);
  529. for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
  530. schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
  531. s2.SetLength(0);
  532. schema.Write(s2);
  533. if ((s1.Length == s2.Length)) {
  534. s1.Position = 0;
  535. s2.Position = 0;
  536. for (; ((s1.Position != s1.Length)
  537. && (s1.ReadByte() == s2.ReadByte())); ) {
  538. ;
  539. }
  540. if ((s1.Position == s1.Length)) {
  541. return type;
  542. }
  543. }
  544. }
  545. }
  546. finally {
  547. if ((s1 != null)) {
  548. s1.Close();
  549. }
  550. if ((s2 != null)) {
  551. s2.Close();
  552. }
  553. }
  554. }
  555. xs.Add(dsSchema);
  556. return type;
  557. }
  558. }
  559. /// <summary>
  560. ///Represents strongly named DataRow class.
  561. ///</summary>
  562. public partial class yusov1Row : global::System.Data.DataRow {
  563. private yusov1DataTable tableyusov1;
  564. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  565. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  566. internal yusov1Row(global::System.Data.DataRowBuilder rb) :
  567. base(rb) {
  568. this.tableyusov1 = ((yusov1DataTable)(this.Table));
  569. }
  570. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  571. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  572. public string Фамилия {
  573. get {
  574. try {
  575. return ((string)(this[this.tableyusov1.ФамилияColumn]));
  576. }
  577. catch (global::System.InvalidCastException e) {
  578. throw new global::System.Data.StrongTypingException("Значение для столбца \'Фамилия\' в таблице \'yusov1\' равно DBNull.", e);
  579. }
  580. }
  581. set {
  582. this[this.tableyusov1.ФамилияColumn] = value;
  583. }
  584. }
  585. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  586. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  587. public string Имя {
  588. get {
  589. try {
  590. return ((string)(this[this.tableyusov1.ИмяColumn]));
  591. }
  592. catch (global::System.InvalidCastException e) {
  593. throw new global::System.Data.StrongTypingException("Значение для столбца \'Имя\' в таблице \'yusov1\' равно DBNull.", e);
  594. }
  595. }
  596. set {
  597. this[this.tableyusov1.ИмяColumn] = value;
  598. }
  599. }
  600. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  601. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  602. public string Отчество {
  603. get {
  604. try {
  605. return ((string)(this[this.tableyusov1.ОтчествоColumn]));
  606. }
  607. catch (global::System.InvalidCastException e) {
  608. throw new global::System.Data.StrongTypingException("Значение для столбца \'Отчество\' в таблице \'yusov1\' равно DBNull.", e);
  609. }
  610. }
  611. set {
  612. this[this.tableyusov1.ОтчествоColumn] = value;
  613. }
  614. }
  615. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  616. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  617. public string Пол {
  618. get {
  619. try {
  620. return ((string)(this[this.tableyusov1.ПолColumn]));
  621. }
  622. catch (global::System.InvalidCastException e) {
  623. throw new global::System.Data.StrongTypingException("Значение для столбца \'Пол\' в таблице \'yusov1\' равно DBNull.", e);
  624. }
  625. }
  626. set {
  627. this[this.tableyusov1.ПолColumn] = value;
  628. }
  629. }
  630. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  631. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  632. public string Телефон {
  633. get {
  634. try {
  635. return ((string)(this[this.tableyusov1.ТелефонColumn]));
  636. }
  637. catch (global::System.InvalidCastException e) {
  638. throw new global::System.Data.StrongTypingException("Значение для столбца \'Телефон\' в таблице \'yusov1\' равно DBNull.", e);
  639. }
  640. }
  641. set {
  642. this[this.tableyusov1.ТелефонColumn] = value;
  643. }
  644. }
  645. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  646. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  647. public System.DateTime Дата_рождения {
  648. get {
  649. try {
  650. return ((global::System.DateTime)(this[this.tableyusov1.Дата_рожденияColumn]));
  651. }
  652. catch (global::System.InvalidCastException e) {
  653. throw new global::System.Data.StrongTypingException("Значение для столбца \'Дата_рождения\' в таблице \'yusov1\' равно DBNull.", e);
  654. }
  655. }
  656. set {
  657. this[this.tableyusov1.Дата_рожденияColumn] = value;
  658. }
  659. }
  660. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  661. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  662. public string Email {
  663. get {
  664. try {
  665. return ((string)(this[this.tableyusov1.EmailColumn]));
  666. }
  667. catch (global::System.InvalidCastException e) {
  668. throw new global::System.Data.StrongTypingException("Значение для столбца \'Email\' в таблице \'yusov1\' равно DBNull.", e);
  669. }
  670. }
  671. set {
  672. this[this.tableyusov1.EmailColumn] = value;
  673. }
  674. }
  675. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  676. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  677. public System.DateTime Дата_регистрации {
  678. get {
  679. try {
  680. return ((global::System.DateTime)(this[this.tableyusov1.Дата_регистрацииColumn]));
  681. }
  682. catch (global::System.InvalidCastException e) {
  683. throw new global::System.Data.StrongTypingException("Значение для столбца \'Дата_регистрации\' в таблице \'yusov1\' равно DBNull.", e);
  684. }
  685. }
  686. set {
  687. this[this.tableyusov1.Дата_регистрацииColumn] = value;
  688. }
  689. }
  690. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  691. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  692. public bool IsФамилияNull() {
  693. return this.IsNull(this.tableyusov1.ФамилияColumn);
  694. }
  695. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  696. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  697. public void SetФамилияNull() {
  698. this[this.tableyusov1.ФамилияColumn] = global::System.Convert.DBNull;
  699. }
  700. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  701. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  702. public bool IsИмяNull() {
  703. return this.IsNull(this.tableyusov1.ИмяColumn);
  704. }
  705. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  706. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  707. public void SetИмяNull() {
  708. this[this.tableyusov1.ИмяColumn] = global::System.Convert.DBNull;
  709. }
  710. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  711. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  712. public bool IsОтчествоNull() {
  713. return this.IsNull(this.tableyusov1.ОтчествоColumn);
  714. }
  715. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  716. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  717. public void SetОтчествоNull() {
  718. this[this.tableyusov1.ОтчествоColumn] = global::System.Convert.DBNull;
  719. }
  720. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  721. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  722. public bool IsПолNull() {
  723. return this.IsNull(this.tableyusov1.ПолColumn);
  724. }
  725. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  726. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  727. public void SetПолNull() {
  728. this[this.tableyusov1.ПолColumn] = global::System.Convert.DBNull;
  729. }
  730. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  731. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  732. public bool IsТелефонNull() {
  733. return this.IsNull(this.tableyusov1.ТелефонColumn);
  734. }
  735. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  736. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  737. public void SetТелефонNull() {
  738. this[this.tableyusov1.ТелефонColumn] = global::System.Convert.DBNull;
  739. }
  740. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  741. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  742. public bool IsДата_рожденияNull() {
  743. return this.IsNull(this.tableyusov1.Дата_рожденияColumn);
  744. }
  745. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  746. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  747. public void SetДата_рожденияNull() {
  748. this[this.tableyusov1.Дата_рожденияColumn] = global::System.Convert.DBNull;
  749. }
  750. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  751. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  752. public bool IsEmailNull() {
  753. return this.IsNull(this.tableyusov1.EmailColumn);
  754. }
  755. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  756. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  757. public void SetEmailNull() {
  758. this[this.tableyusov1.EmailColumn] = global::System.Convert.DBNull;
  759. }
  760. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  761. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  762. public bool IsДата_регистрацииNull() {
  763. return this.IsNull(this.tableyusov1.Дата_регистрацииColumn);
  764. }
  765. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  766. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  767. public void SetДата_регистрацииNull() {
  768. this[this.tableyusov1.Дата_регистрацииColumn] = global::System.Convert.DBNull;
  769. }
  770. }
  771. /// <summary>
  772. ///Row event argument class
  773. ///</summary>
  774. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  775. public class yusov1RowChangeEvent : global::System.EventArgs {
  776. private yusov1Row eventRow;
  777. private global::System.Data.DataRowAction eventAction;
  778. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  779. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  780. public yusov1RowChangeEvent(yusov1Row row, global::System.Data.DataRowAction action) {
  781. this.eventRow = row;
  782. this.eventAction = action;
  783. }
  784. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  785. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  786. public yusov1Row Row {
  787. get {
  788. return this.eventRow;
  789. }
  790. }
  791. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  792. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  793. public global::System.Data.DataRowAction Action {
  794. get {
  795. return this.eventAction;
  796. }
  797. }
  798. }
  799. }
  800. }
  801. namespace Юсову_Владислав_ИСП_11._18._3._Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7TableAdapters {
  802. /// <summary>
  803. ///Represents the connection and commands used to retrieve and save data.
  804. ///</summary>
  805. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  806. [global::System.ComponentModel.ToolboxItem(true)]
  807. [global::System.ComponentModel.DataObjectAttribute(true)]
  808. [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
  809. ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
  810. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  811. public partial class yusov1TableAdapter : global::System.ComponentModel.Component {
  812. private global::System.Data.SqlClient.SqlDataAdapter _adapter;
  813. private global::System.Data.SqlClient.SqlConnection _connection;
  814. private global::System.Data.SqlClient.SqlTransaction _transaction;
  815. private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
  816. private bool _clearBeforeFill;
  817. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  818. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  819. public yusov1TableAdapter() {
  820. this.ClearBeforeFill = true;
  821. }
  822. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  823. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  824. protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
  825. get {
  826. if ((this._adapter == null)) {
  827. this.InitAdapter();
  828. }
  829. return this._adapter;
  830. }
  831. }
  832. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  833. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  834. internal global::System.Data.SqlClient.SqlConnection Connection {
  835. get {
  836. if ((this._connection == null)) {
  837. this.InitConnection();
  838. }
  839. return this._connection;
  840. }
  841. set {
  842. this._connection = value;
  843. if ((this.Adapter.InsertCommand != null)) {
  844. this.Adapter.InsertCommand.Connection = value;
  845. }
  846. if ((this.Adapter.DeleteCommand != null)) {
  847. this.Adapter.DeleteCommand.Connection = value;
  848. }
  849. if ((this.Adapter.UpdateCommand != null)) {
  850. this.Adapter.UpdateCommand.Connection = value;
  851. }
  852. for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  853. if ((this.CommandCollection[i] != null)) {
  854. ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
  855. }
  856. }
  857. }
  858. }
  859. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  860. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  861. internal global::System.Data.SqlClient.SqlTransaction Transaction {
  862. get {
  863. return this._transaction;
  864. }
  865. set {
  866. this._transaction = value;
  867. for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  868. this.CommandCollection[i].Transaction = this._transaction;
  869. }
  870. if (((this.Adapter != null)
  871. && (this.Adapter.DeleteCommand != null))) {
  872. this.Adapter.DeleteCommand.Transaction = this._transaction;
  873. }
  874. if (((this.Adapter != null)
  875. && (this.Adapter.InsertCommand != null))) {
  876. this.Adapter.InsertCommand.Transaction = this._transaction;
  877. }
  878. if (((this.Adapter != null)
  879. && (this.Adapter.UpdateCommand != null))) {
  880. this.Adapter.UpdateCommand.Transaction = this._transaction;
  881. }
  882. }
  883. }
  884. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  885. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  886. protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
  887. get {
  888. if ((this._commandCollection == null)) {
  889. this.InitCommandCollection();
  890. }
  891. return this._commandCollection;
  892. }
  893. }
  894. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  895. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  896. public bool ClearBeforeFill {
  897. get {
  898. return this._clearBeforeFill;
  899. }
  900. set {
  901. this._clearBeforeFill = value;
  902. }
  903. }
  904. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  905. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  906. private void InitAdapter() {
  907. this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
  908. global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
  909. tableMapping.SourceTable = "Table";
  910. tableMapping.DataSetTable = "yusov1";
  911. tableMapping.ColumnMappings.Add("Фамилия", "Фамилия");
  912. tableMapping.ColumnMappings.Add("Имя", "Имя");
  913. tableMapping.ColumnMappings.Add("Отчество", "Отчество");
  914. tableMapping.ColumnMappings.Add("Пол", "Пол");
  915. tableMapping.ColumnMappings.Add("Телефон", "Телефон");
  916. tableMapping.ColumnMappings.Add("Дата_рождения", "Дата_рождения");
  917. tableMapping.ColumnMappings.Add("Email", "Email");
  918. tableMapping.ColumnMappings.Add("Дата_регистрации", "Дата_регистрации");
  919. this._adapter.TableMappings.Add(tableMapping);
  920. this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
  921. this._adapter.InsertCommand.Connection = this.Connection;
  922. this._adapter.InsertCommand.CommandText = "INSERT INTO [dbo].[yusov1] ([Фамилия], [Имя], [Отчество], [Пол], [Телефон], [Дата" +
  923. "_рождения], [Email], [Дата_регистрации]) VALUES (@Фамилия, @Имя, @Отчество, @Пол" +
  924. ", @Телефон, @Дата_рождения, @Email, @Дата_регистрации)";
  925. this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
  926. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Фамилия", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Фамилия", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  927. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Имя", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Имя", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  928. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Отчество", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Отчество", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  929. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Пол", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Пол", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  930. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Телефон", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Телефон", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  931. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Дата_рождения", global::System.Data.SqlDbType.DateTime2, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Дата_рождения", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  932. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Email", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Email", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  933. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Дата_регистрации", global::System.Data.SqlDbType.DateTime2, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Дата_регистрации", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  934. }
  935. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  936. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  937. private void InitConnection() {
  938. this._connection = new global::System.Data.SqlClient.SqlConnection();
  939. this._connection.ConnectionString = global::Юсову_Владислав_ИСП_11._18._3.Properties.Settings.Default.Юсов_Владислав_Сергеевич_ИСП_11_18_3ConnectionString;
  940. }
  941. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  942. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  943. private void InitCommandCollection() {
  944. this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
  945. this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
  946. this._commandCollection[0].Connection = this.Connection;
  947. this._commandCollection[0].CommandText = "SELECT Фамилия, Имя, Отчество, Пол, Телефон, Дата_рождения, Email, Дата_регистрац" +
  948. "ии FROM dbo.yusov1";
  949. this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
  950. }
  951. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  952. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  953. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  954. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
  955. public virtual int Fill(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7.yusov1DataTable dataTable) {
  956. this.Adapter.SelectCommand = this.CommandCollection[0];
  957. if ((this.ClearBeforeFill == true)) {
  958. dataTable.Clear();
  959. }
  960. int returnValue = this.Adapter.Fill(dataTable);
  961. return returnValue;
  962. }
  963. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  964. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  965. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  966. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
  967. public virtual _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7.yusov1DataTable GetData() {
  968. this.Adapter.SelectCommand = this.CommandCollection[0];
  969. _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7.yusov1DataTable dataTable = new _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7.yusov1DataTable();
  970. this.Adapter.Fill(dataTable);
  971. return dataTable;
  972. }
  973. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  974. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  975. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  976. public virtual int Update(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7.yusov1DataTable dataTable) {
  977. return this.Adapter.Update(dataTable);
  978. }
  979. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  980. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  981. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  982. public virtual int Update(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7 dataSet) {
  983. return this.Adapter.Update(dataSet, "yusov1");
  984. }
  985. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  986. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  987. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  988. public virtual int Update(global::System.Data.DataRow dataRow) {
  989. return this.Adapter.Update(new global::System.Data.DataRow[] {
  990. dataRow});
  991. }
  992. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  993. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  994. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  995. public virtual int Update(global::System.Data.DataRow[] dataRows) {
  996. return this.Adapter.Update(dataRows);
  997. }
  998. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  999. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1000. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1001. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
  1002. public virtual int Insert(string Фамилия, string Имя, string Отчество, string Пол, string Телефон, global::System.Nullable<global::System.DateTime> Дата_рождения, string Email, global::System.Nullable<global::System.DateTime> Дата_регистрации) {
  1003. if ((Фамилия == null)) {
  1004. this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;
  1005. }
  1006. else {
  1007. this.Adapter.InsertCommand.Parameters[0].Value = ((string)(Фамилия));
  1008. }
  1009. if ((Имя == null)) {
  1010. this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
  1011. }
  1012. else {
  1013. this.Adapter.InsertCommand.Parameters[1].Value = ((string)(Имя));
  1014. }
  1015. if ((Отчество == null)) {
  1016. this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
  1017. }
  1018. else {
  1019. this.Adapter.InsertCommand.Parameters[2].Value = ((string)(Отчество));
  1020. }
  1021. if ((Пол == null)) {
  1022. this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
  1023. }
  1024. else {
  1025. this.Adapter.InsertCommand.Parameters[3].Value = ((string)(Пол));
  1026. }
  1027. if ((Телефон == null)) {
  1028. this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
  1029. }
  1030. else {
  1031. this.Adapter.InsertCommand.Parameters[4].Value = ((string)(Телефон));
  1032. }
  1033. if ((Дата_рождения.HasValue == true)) {
  1034. this.Adapter.InsertCommand.Parameters[5].Value = ((System.DateTime)(Дата_рождения.Value));
  1035. }
  1036. else {
  1037. this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
  1038. }
  1039. if ((Email == null)) {
  1040. this.Adapter.InsertCommand.Parameters[6].Value = global::System.DBNull.Value;
  1041. }
  1042. else {
  1043. this.Adapter.InsertCommand.Parameters[6].Value = ((string)(Email));
  1044. }
  1045. if ((Дата_регистрации.HasValue == true)) {
  1046. this.Adapter.InsertCommand.Parameters[7].Value = ((System.DateTime)(Дата_регистрации.Value));
  1047. }
  1048. else {
  1049. this.Adapter.InsertCommand.Parameters[7].Value = global::System.DBNull.Value;
  1050. }
  1051. global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
  1052. if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
  1053. != global::System.Data.ConnectionState.Open)) {
  1054. this.Adapter.InsertCommand.Connection.Open();
  1055. }
  1056. try {
  1057. int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
  1058. return returnValue;
  1059. }
  1060. finally {
  1061. if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
  1062. this.Adapter.InsertCommand.Connection.Close();
  1063. }
  1064. }
  1065. }
  1066. }
  1067. /// <summary>
  1068. ///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
  1069. ///</summary>
  1070. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  1071. [global::System.ComponentModel.ToolboxItem(true)]
  1072. [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
  1073. "esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
  1074. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
  1075. public partial class TableAdapterManager : global::System.ComponentModel.Component {
  1076. private UpdateOrderOption _updateOrder;
  1077. private yusov1TableAdapter _yusov1TableAdapter;
  1078. private bool _backupDataSetBeforeUpdate;
  1079. private global::System.Data.IDbConnection _connection;
  1080. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1081. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1082. public UpdateOrderOption UpdateOrder {
  1083. get {
  1084. return this._updateOrder;
  1085. }
  1086. set {
  1087. this._updateOrder = value;
  1088. }
  1089. }
  1090. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1091. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1092. [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
  1093. "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
  1094. "a", "System.Drawing.Design.UITypeEditor")]
  1095. public yusov1TableAdapter yusov1TableAdapter {
  1096. get {
  1097. return this._yusov1TableAdapter;
  1098. }
  1099. set {
  1100. this._yusov1TableAdapter = value;
  1101. }
  1102. }
  1103. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1104. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1105. public bool BackupDataSetBeforeUpdate {
  1106. get {
  1107. return this._backupDataSetBeforeUpdate;
  1108. }
  1109. set {
  1110. this._backupDataSetBeforeUpdate = value;
  1111. }
  1112. }
  1113. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1114. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1115. [global::System.ComponentModel.Browsable(false)]
  1116. public global::System.Data.IDbConnection Connection {
  1117. get {
  1118. if ((this._connection != null)) {
  1119. return this._connection;
  1120. }
  1121. if (((this._yusov1TableAdapter != null)
  1122. && (this._yusov1TableAdapter.Connection != null))) {
  1123. return this._yusov1TableAdapter.Connection;
  1124. }
  1125. return null;
  1126. }
  1127. set {
  1128. this._connection = value;
  1129. }
  1130. }
  1131. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1132. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1133. [global::System.ComponentModel.Browsable(false)]
  1134. public int TableAdapterInstanceCount {
  1135. get {
  1136. int count = 0;
  1137. if ((this._yusov1TableAdapter != null)) {
  1138. count = (count + 1);
  1139. }
  1140. return count;
  1141. }
  1142. }
  1143. /// <summary>
  1144. ///Update rows in top-down order.
  1145. ///</summary>
  1146. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1147. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1148. private int UpdateUpdatedRows(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  1149. int result = 0;
  1150. if ((this._yusov1TableAdapter != null)) {
  1151. global::System.Data.DataRow[] updatedRows = dataSet.yusov1.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
  1152. updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
  1153. if (((updatedRows != null)
  1154. && (0 < updatedRows.Length))) {
  1155. result = (result + this._yusov1TableAdapter.Update(updatedRows));
  1156. allChangedRows.AddRange(updatedRows);
  1157. }
  1158. }
  1159. return result;
  1160. }
  1161. /// <summary>
  1162. ///Insert rows in top-down order.
  1163. ///</summary>
  1164. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1165. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1166. private int UpdateInsertedRows(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  1167. int result = 0;
  1168. if ((this._yusov1TableAdapter != null)) {
  1169. global::System.Data.DataRow[] addedRows = dataSet.yusov1.Select(null, null, global::System.Data.DataViewRowState.Added);
  1170. if (((addedRows != null)
  1171. && (0 < addedRows.Length))) {
  1172. result = (result + this._yusov1TableAdapter.Update(addedRows));
  1173. allAddedRows.AddRange(addedRows);
  1174. }
  1175. }
  1176. return result;
  1177. }
  1178. /// <summary>
  1179. ///Delete rows in bottom-up order.
  1180. ///</summary>
  1181. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1182. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1183. private int UpdateDeletedRows(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows) {
  1184. int result = 0;
  1185. if ((this._yusov1TableAdapter != null)) {
  1186. global::System.Data.DataRow[] deletedRows = dataSet.yusov1.Select(null, null, global::System.Data.DataViewRowState.Deleted);
  1187. if (((deletedRows != null)
  1188. && (0 < deletedRows.Length))) {
  1189. result = (result + this._yusov1TableAdapter.Update(deletedRows));
  1190. allChangedRows.AddRange(deletedRows);
  1191. }
  1192. }
  1193. return result;
  1194. }
  1195. /// <summary>
  1196. ///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
  1197. ///</summary>
  1198. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1199. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1200. private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  1201. if (((updatedRows == null)
  1202. || (updatedRows.Length < 1))) {
  1203. return updatedRows;
  1204. }
  1205. if (((allAddedRows == null)
  1206. || (allAddedRows.Count < 1))) {
  1207. return updatedRows;
  1208. }
  1209. global::System.Collections.Generic.List<global::System.Data.DataRow> realUpdatedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  1210. for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
  1211. global::System.Data.DataRow row = updatedRows[i];
  1212. if ((allAddedRows.Contains(row) == false)) {
  1213. realUpdatedRows.Add(row);
  1214. }
  1215. }
  1216. return realUpdatedRows.ToArray();
  1217. }
  1218. /// <summary>
  1219. ///Update all changes to the dataset.
  1220. ///</summary>
  1221. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1222. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1223. public virtual int UpdateAll(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet7 dataSet) {
  1224. if ((dataSet == null)) {
  1225. throw new global::System.ArgumentNullException("dataSet");
  1226. }
  1227. if ((dataSet.HasChanges() == false)) {
  1228. return 0;
  1229. }
  1230. if (((this._yusov1TableAdapter != null)
  1231. && (this.MatchTableAdapterConnection(this._yusov1TableAdapter.Connection) == false))) {
  1232. throw new global::System.ArgumentException("Все адаптеры таблицы, управляемые диспетчером адаптера таблицы TableAdapterManage" +
  1233. "r, должны использовать одинаковую строку подключения.");
  1234. }
  1235. global::System.Data.IDbConnection workConnection = this.Connection;
  1236. if ((workConnection == null)) {
  1237. throw new global::System.ApplicationException("TableAdapterManager не содержит сведений о подключении. Укажите для каждого адапт" +
  1238. "ера таблицы TableAdapterManager допустимый экземпляр адаптера таблицы.");
  1239. }
  1240. bool workConnOpened = false;
  1241. if (((workConnection.State & global::System.Data.ConnectionState.Broken)
  1242. == global::System.Data.ConnectionState.Broken)) {
  1243. workConnection.Close();
  1244. }
  1245. if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
  1246. workConnection.Open();
  1247. workConnOpened = true;
  1248. }
  1249. global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
  1250. if ((workTransaction == null)) {
  1251. throw new global::System.ApplicationException("Не удается начать транзакцию. Текущее соединение данных не поддерживает транзакци" +
  1252. "и или текущее состояние не позволяет начать транзакцию.");
  1253. }
  1254. global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  1255. global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  1256. global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter> adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter>();
  1257. global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection> revertConnections = new global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection>();
  1258. int result = 0;
  1259. global::System.Data.DataSet backupDataSet = null;
  1260. if (this.BackupDataSetBeforeUpdate) {
  1261. backupDataSet = new global::System.Data.DataSet();
  1262. backupDataSet.Merge(dataSet);
  1263. }
  1264. try {
  1265. // ---- Prepare for update -----------
  1266. //
  1267. if ((this._yusov1TableAdapter != null)) {
  1268. revertConnections.Add(this._yusov1TableAdapter, this._yusov1TableAdapter.Connection);
  1269. this._yusov1TableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(workConnection));
  1270. this._yusov1TableAdapter.Transaction = ((global::System.Data.SqlClient.SqlTransaction)(workTransaction));
  1271. if (this._yusov1TableAdapter.Adapter.AcceptChangesDuringUpdate) {
  1272. this._yusov1TableAdapter.Adapter.AcceptChangesDuringUpdate = false;
  1273. adaptersWithAcceptChangesDuringUpdate.Add(this._yusov1TableAdapter.Adapter);
  1274. }
  1275. }
  1276. //
  1277. //---- Perform updates -----------
  1278. //
  1279. if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) {
  1280. result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
  1281. result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
  1282. }
  1283. else {
  1284. result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
  1285. result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
  1286. }
  1287. result = (result + this.UpdateDeletedRows(dataSet, allChangedRows));
  1288. //
  1289. //---- Commit updates -----------
  1290. //
  1291. workTransaction.Commit();
  1292. if ((0 < allAddedRows.Count)) {
  1293. global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
  1294. allAddedRows.CopyTo(rows);
  1295. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  1296. global::System.Data.DataRow row = rows[i];
  1297. row.AcceptChanges();
  1298. }
  1299. }
  1300. if ((0 < allChangedRows.Count)) {
  1301. global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count];
  1302. allChangedRows.CopyTo(rows);
  1303. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  1304. global::System.Data.DataRow row = rows[i];
  1305. row.AcceptChanges();
  1306. }
  1307. }
  1308. }
  1309. catch (global::System.Exception ex) {
  1310. workTransaction.Rollback();
  1311. // ---- Restore the dataset -----------
  1312. if (this.BackupDataSetBeforeUpdate) {
  1313. global::System.Diagnostics.Debug.Assert((backupDataSet != null));
  1314. dataSet.Clear();
  1315. dataSet.Merge(backupDataSet);
  1316. }
  1317. else {
  1318. if ((0 < allAddedRows.Count)) {
  1319. global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
  1320. allAddedRows.CopyTo(rows);
  1321. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  1322. global::System.Data.DataRow row = rows[i];
  1323. row.AcceptChanges();
  1324. row.SetAdded();
  1325. }
  1326. }
  1327. }
  1328. throw ex;
  1329. }
  1330. finally {
  1331. if (workConnOpened) {
  1332. workConnection.Close();
  1333. }
  1334. if ((this._yusov1TableAdapter != null)) {
  1335. this._yusov1TableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(revertConnections[this._yusov1TableAdapter]));
  1336. this._yusov1TableAdapter.Transaction = null;
  1337. }
  1338. if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) {
  1339. global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count];
  1340. adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters);
  1341. for (int i = 0; (i < adapters.Length); i = (i + 1)) {
  1342. global::System.Data.Common.DataAdapter adapter = adapters[i];
  1343. adapter.AcceptChangesDuringUpdate = true;
  1344. }
  1345. }
  1346. }
  1347. return result;
  1348. }
  1349. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1350. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1351. protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) {
  1352. global::System.Array.Sort<global::System.Data.DataRow>(rows, new SelfReferenceComparer(relation, childFirst));
  1353. }
  1354. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1355. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1356. protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) {
  1357. if ((this._connection != null)) {
  1358. return true;
  1359. }
  1360. if (((this.Connection == null)
  1361. || (inputConnection == null))) {
  1362. return true;
  1363. }
  1364. if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) {
  1365. return true;
  1366. }
  1367. return false;
  1368. }
  1369. /// <summary>
  1370. ///Update Order Option
  1371. ///</summary>
  1372. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1373. public enum UpdateOrderOption {
  1374. InsertUpdateDelete = 0,
  1375. UpdateInsertDelete = 1,
  1376. }
  1377. /// <summary>
  1378. ///Used to sort self-referenced table's rows
  1379. ///</summary>
  1380. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1381. private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer<global::System.Data.DataRow> {
  1382. private global::System.Data.DataRelation _relation;
  1383. private int _childFirst;
  1384. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1385. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1386. internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) {
  1387. this._relation = relation;
  1388. if (childFirst) {
  1389. this._childFirst = -1;
  1390. }
  1391. else {
  1392. this._childFirst = 1;
  1393. }
  1394. }
  1395. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1396. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1397. private global::System.Data.DataRow GetRoot(global::System.Data.DataRow row, out int distance) {
  1398. global::System.Diagnostics.Debug.Assert((row != null));
  1399. global::System.Data.DataRow root = row;
  1400. distance = 0;
  1401. 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>();
  1402. traversedRows[row] = row;
  1403. global::System.Data.DataRow parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
  1404. for (
  1405. ; ((parent != null)
  1406. && (traversedRows.ContainsKey(parent) == false));
  1407. ) {
  1408. distance = (distance + 1);
  1409. root = parent;
  1410. traversedRows[parent] = parent;
  1411. parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
  1412. }
  1413. if ((distance == 0)) {
  1414. traversedRows.Clear();
  1415. traversedRows[row] = row;
  1416. parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
  1417. for (
  1418. ; ((parent != null)
  1419. && (traversedRows.ContainsKey(parent) == false));
  1420. ) {
  1421. distance = (distance + 1);
  1422. root = parent;
  1423. traversedRows[parent] = parent;
  1424. parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
  1425. }
  1426. }
  1427. return root;
  1428. }
  1429. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1430. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1431. public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) {
  1432. if (object.ReferenceEquals(row1, row2)) {
  1433. return 0;
  1434. }
  1435. if ((row1 == null)) {
  1436. return -1;
  1437. }
  1438. if ((row2 == null)) {
  1439. return 1;
  1440. }
  1441. int distance1 = 0;
  1442. global::System.Data.DataRow root1 = this.GetRoot(row1, out distance1);
  1443. int distance2 = 0;
  1444. global::System.Data.DataRow root2 = this.GetRoot(row2, out distance2);
  1445. if (object.ReferenceEquals(root1, root2)) {
  1446. return (this._childFirst * distance1.CompareTo(distance2));
  1447. }
  1448. else {
  1449. global::System.Diagnostics.Debug.Assert(((root1.Table != null)
  1450. && (root2.Table != null)));
  1451. if ((root1.Table.Rows.IndexOf(root1) < root2.Table.Rows.IndexOf(root2))) {
  1452. return -1;
  1453. }
  1454. else {
  1455. return 1;
  1456. }
  1457. }
  1458. }
  1459. }
  1460. }
  1461. }
  1462. #pragma warning restore 1591