RozenbergBrDataSet1.Designer.cs 70 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339
  1. //------------------------------------------------------------------------------
  2. // <auto-generated>
  3. // Этот код создан программой.
  4. // Исполняемая версия:4.0.30319.42000
  5. //
  6. // Изменения в этом файле могут привести к неправильной работе и будут потеряны в случае
  7. // повторной генерации кода.
  8. // </auto-generated>
  9. //------------------------------------------------------------------------------
  10. #pragma warning disable 1591
  11. namespace RozenbergBrovki {
  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("RozenbergBrDataSet1")]
  20. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
  21. public partial class RozenbergBrDataSet1 : global::System.Data.DataSet {
  22. private PrDataTable tablePr;
  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 RozenbergBrDataSet1() {
  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 RozenbergBrDataSet1(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["Pr"] != null)) {
  50. base.Tables.Add(new PrDataTable(ds.Tables["Pr"]));
  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 PrDataTable Pr {
  74. get {
  75. return this.tablePr;
  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. RozenbergBrDataSet1 cln = ((RozenbergBrDataSet1)(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["Pr"] != null)) {
  139. base.Tables.Add(new PrDataTable(ds.Tables["Pr"]));
  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.tablePr = ((PrDataTable)(base.Tables["Pr"]));
  172. if ((initTable == true)) {
  173. if ((this.tablePr != null)) {
  174. this.tablePr.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 = "RozenbergBrDataSet1";
  182. this.Prefix = "";
  183. this.Namespace = "http://tempuri.org/RozenbergBrDataSet1.xsd";
  184. this.EnforceConstraints = true;
  185. this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
  186. this.tablePr = new PrDataTable();
  187. base.Tables.Add(this.tablePr);
  188. }
  189. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  190. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  191. private bool ShouldSerializePr() {
  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. RozenbergBrDataSet1 ds = new RozenbergBrDataSet1();
  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 PrRowChangeEventHandler(object sender, PrRowChangeEvent 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 PrDataTable : global::System.Data.TypedTableBase<PrRow> {
  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 columnEmail;
  261. private global::System.Data.DataColumn columnНаименование_услуги;
  262. private global::System.Data.DataColumn columnДата_регистрации;
  263. private global::System.Data.DataColumn columnДата_рождения;
  264. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  265. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  266. public PrDataTable() {
  267. this.TableName = "Pr";
  268. this.BeginInit();
  269. this.InitClass();
  270. this.EndInit();
  271. }
  272. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  273. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  274. internal PrDataTable(global::System.Data.DataTable table) {
  275. this.TableName = table.TableName;
  276. if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
  277. this.CaseSensitive = table.CaseSensitive;
  278. }
  279. if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
  280. this.Locale = table.Locale;
  281. }
  282. if ((table.Namespace != table.DataSet.Namespace)) {
  283. this.Namespace = table.Namespace;
  284. }
  285. this.Prefix = table.Prefix;
  286. this.MinimumCapacity = table.MinimumCapacity;
  287. }
  288. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  289. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  290. protected PrDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
  291. base(info, context) {
  292. this.InitVars();
  293. }
  294. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  295. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  296. public global::System.Data.DataColumn ФамилияColumn {
  297. get {
  298. return this.columnФамилия;
  299. }
  300. }
  301. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  302. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  303. public global::System.Data.DataColumn ИмяColumn {
  304. get {
  305. return this.columnИмя;
  306. }
  307. }
  308. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  309. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  310. public global::System.Data.DataColumn ОтчествоColumn {
  311. get {
  312. return this.columnОтчество;
  313. }
  314. }
  315. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  316. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  317. public global::System.Data.DataColumn ПолColumn {
  318. get {
  319. return this.columnПол;
  320. }
  321. }
  322. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  323. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  324. public global::System.Data.DataColumn ТелефонColumn {
  325. get {
  326. return this.columnТелефон;
  327. }
  328. }
  329. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  330. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  331. public global::System.Data.DataColumn EmailColumn {
  332. get {
  333. return this.columnEmail;
  334. }
  335. }
  336. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  337. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  338. public global::System.Data.DataColumn Наименование_услугиColumn {
  339. get {
  340. return this.columnНаименование_услуги;
  341. }
  342. }
  343. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  344. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  345. public global::System.Data.DataColumn Дата_регистрацииColumn {
  346. get {
  347. return this.columnДата_регистрации;
  348. }
  349. }
  350. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  351. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  352. public global::System.Data.DataColumn Дата_рожденияColumn {
  353. get {
  354. return this.columnДата_рождения;
  355. }
  356. }
  357. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  358. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  359. [global::System.ComponentModel.Browsable(false)]
  360. public int Count {
  361. get {
  362. return this.Rows.Count;
  363. }
  364. }
  365. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  366. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  367. public PrRow this[int index] {
  368. get {
  369. return ((PrRow)(this.Rows[index]));
  370. }
  371. }
  372. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  373. public event PrRowChangeEventHandler PrRowChanging;
  374. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  375. public event PrRowChangeEventHandler PrRowChanged;
  376. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  377. public event PrRowChangeEventHandler PrRowDeleting;
  378. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  379. public event PrRowChangeEventHandler PrRowDeleted;
  380. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  381. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  382. public void AddPrRow(PrRow row) {
  383. this.Rows.Add(row);
  384. }
  385. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  386. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  387. public PrRow AddPrRow(string Фамилия, string Имя, string Отчество, int Пол, string Телефон, string Email, string Наименование_услуги, System.DateTime Дата_регистрации, System.DateTime Дата_рождения) {
  388. PrRow rowPrRow = ((PrRow)(this.NewRow()));
  389. object[] columnValuesArray = new object[] {
  390. Фамилия,
  391. Имя,
  392. Отчество,
  393. Пол,
  394. Телефон,
  395. Email,
  396. Наименование_услуги,
  397. Дата_регистрации,
  398. Дата_рождения};
  399. rowPrRow.ItemArray = columnValuesArray;
  400. this.Rows.Add(rowPrRow);
  401. return rowPrRow;
  402. }
  403. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  404. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  405. public override global::System.Data.DataTable Clone() {
  406. PrDataTable cln = ((PrDataTable)(base.Clone()));
  407. cln.InitVars();
  408. return cln;
  409. }
  410. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  411. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  412. protected override global::System.Data.DataTable CreateInstance() {
  413. return new PrDataTable();
  414. }
  415. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  416. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  417. internal void InitVars() {
  418. this.columnФамилия = base.Columns["Фамилия"];
  419. this.columnИмя = base.Columns["Имя"];
  420. this.columnОтчество = base.Columns["Отчество"];
  421. this.columnПол = base.Columns["Пол"];
  422. this.columnТелефон = base.Columns["Телефон"];
  423. this.columnEmail = base.Columns["Email"];
  424. this.columnНаименование_услуги = base.Columns["Наименование_услуги"];
  425. this.columnДата_регистрации = base.Columns["Дата_регистрации"];
  426. this.columnДата_рождения = base.Columns["Дата_рождения"];
  427. }
  428. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  429. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  430. private void InitClass() {
  431. this.columnФамилия = new global::System.Data.DataColumn("Фамилия", typeof(string), null, global::System.Data.MappingType.Element);
  432. base.Columns.Add(this.columnФамилия);
  433. this.columnИмя = new global::System.Data.DataColumn("Имя", typeof(string), null, global::System.Data.MappingType.Element);
  434. base.Columns.Add(this.columnИмя);
  435. this.columnОтчество = new global::System.Data.DataColumn("Отчество", typeof(string), null, global::System.Data.MappingType.Element);
  436. base.Columns.Add(this.columnОтчество);
  437. this.columnПол = new global::System.Data.DataColumn("Пол", typeof(int), null, global::System.Data.MappingType.Element);
  438. base.Columns.Add(this.columnПол);
  439. this.columnТелефон = new global::System.Data.DataColumn("Телефон", typeof(string), null, global::System.Data.MappingType.Element);
  440. base.Columns.Add(this.columnТелефон);
  441. this.columnEmail = new global::System.Data.DataColumn("Email", typeof(string), null, global::System.Data.MappingType.Element);
  442. base.Columns.Add(this.columnEmail);
  443. this.columnНаименование_услуги = new global::System.Data.DataColumn("Наименование_услуги", typeof(string), null, global::System.Data.MappingType.Element);
  444. base.Columns.Add(this.columnНаименование_услуги);
  445. this.columnДата_регистрации = new global::System.Data.DataColumn("Дата_регистрации", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
  446. base.Columns.Add(this.columnДата_регистрации);
  447. this.columnДата_рождения = new global::System.Data.DataColumn("Дата_рождения", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
  448. base.Columns.Add(this.columnДата_рождения);
  449. this.columnФамилия.AllowDBNull = false;
  450. this.columnФамилия.MaxLength = 50;
  451. this.columnИмя.AllowDBNull = false;
  452. this.columnИмя.MaxLength = 50;
  453. this.columnОтчество.AllowDBNull = false;
  454. this.columnОтчество.MaxLength = 50;
  455. this.columnПол.AllowDBNull = false;
  456. this.columnТелефон.AllowDBNull = false;
  457. this.columnТелефон.MaxLength = 50;
  458. this.columnEmail.AllowDBNull = false;
  459. this.columnEmail.MaxLength = 50;
  460. this.columnНаименование_услуги.AllowDBNull = false;
  461. this.columnНаименование_услуги.MaxLength = 50;
  462. this.columnДата_регистрации.AllowDBNull = false;
  463. this.columnДата_рождения.AllowDBNull = false;
  464. }
  465. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  466. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  467. public PrRow NewPrRow() {
  468. return ((PrRow)(this.NewRow()));
  469. }
  470. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  471. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  472. protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
  473. return new PrRow(builder);
  474. }
  475. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  476. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  477. protected override global::System.Type GetRowType() {
  478. return typeof(PrRow);
  479. }
  480. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  481. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  482. protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
  483. base.OnRowChanged(e);
  484. if ((this.PrRowChanged != null)) {
  485. this.PrRowChanged(this, new PrRowChangeEvent(((PrRow)(e.Row)), e.Action));
  486. }
  487. }
  488. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  489. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  490. protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
  491. base.OnRowChanging(e);
  492. if ((this.PrRowChanging != null)) {
  493. this.PrRowChanging(this, new PrRowChangeEvent(((PrRow)(e.Row)), e.Action));
  494. }
  495. }
  496. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  497. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  498. protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
  499. base.OnRowDeleted(e);
  500. if ((this.PrRowDeleted != null)) {
  501. this.PrRowDeleted(this, new PrRowChangeEvent(((PrRow)(e.Row)), e.Action));
  502. }
  503. }
  504. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  505. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  506. protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
  507. base.OnRowDeleting(e);
  508. if ((this.PrRowDeleting != null)) {
  509. this.PrRowDeleting(this, new PrRowChangeEvent(((PrRow)(e.Row)), e.Action));
  510. }
  511. }
  512. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  513. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  514. public void RemovePrRow(PrRow row) {
  515. this.Rows.Remove(row);
  516. }
  517. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  518. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  519. public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
  520. global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
  521. global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
  522. RozenbergBrDataSet1 ds = new RozenbergBrDataSet1();
  523. global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
  524. any1.Namespace = "http://www.w3.org/2001/XMLSchema";
  525. any1.MinOccurs = new decimal(0);
  526. any1.MaxOccurs = decimal.MaxValue;
  527. any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  528. sequence.Items.Add(any1);
  529. global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
  530. any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  531. any2.MinOccurs = new decimal(1);
  532. any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  533. sequence.Items.Add(any2);
  534. global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
  535. attribute1.Name = "namespace";
  536. attribute1.FixedValue = ds.Namespace;
  537. type.Attributes.Add(attribute1);
  538. global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
  539. attribute2.Name = "tableTypeName";
  540. attribute2.FixedValue = "PrDataTable";
  541. type.Attributes.Add(attribute2);
  542. type.Particle = sequence;
  543. global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
  544. if (xs.Contains(dsSchema.TargetNamespace)) {
  545. global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
  546. global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
  547. try {
  548. global::System.Xml.Schema.XmlSchema schema = null;
  549. dsSchema.Write(s1);
  550. for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
  551. schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
  552. s2.SetLength(0);
  553. schema.Write(s2);
  554. if ((s1.Length == s2.Length)) {
  555. s1.Position = 0;
  556. s2.Position = 0;
  557. for (; ((s1.Position != s1.Length)
  558. && (s1.ReadByte() == s2.ReadByte())); ) {
  559. ;
  560. }
  561. if ((s1.Position == s1.Length)) {
  562. return type;
  563. }
  564. }
  565. }
  566. }
  567. finally {
  568. if ((s1 != null)) {
  569. s1.Close();
  570. }
  571. if ((s2 != null)) {
  572. s2.Close();
  573. }
  574. }
  575. }
  576. xs.Add(dsSchema);
  577. return type;
  578. }
  579. }
  580. /// <summary>
  581. ///Represents strongly named DataRow class.
  582. ///</summary>
  583. public partial class PrRow : global::System.Data.DataRow {
  584. private PrDataTable tablePr;
  585. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  586. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  587. internal PrRow(global::System.Data.DataRowBuilder rb) :
  588. base(rb) {
  589. this.tablePr = ((PrDataTable)(this.Table));
  590. }
  591. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  592. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  593. public string Фамилия {
  594. get {
  595. return ((string)(this[this.tablePr.ФамилияColumn]));
  596. }
  597. set {
  598. this[this.tablePr.ФамилияColumn] = value;
  599. }
  600. }
  601. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  602. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  603. public string Имя {
  604. get {
  605. return ((string)(this[this.tablePr.ИмяColumn]));
  606. }
  607. set {
  608. this[this.tablePr.ИмяColumn] = value;
  609. }
  610. }
  611. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  612. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  613. public string Отчество {
  614. get {
  615. return ((string)(this[this.tablePr.ОтчествоColumn]));
  616. }
  617. set {
  618. this[this.tablePr.ОтчествоColumn] = value;
  619. }
  620. }
  621. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  622. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  623. public int Пол {
  624. get {
  625. return ((int)(this[this.tablePr.ПолColumn]));
  626. }
  627. set {
  628. this[this.tablePr.ПолColumn] = value;
  629. }
  630. }
  631. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  632. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  633. public string Телефон {
  634. get {
  635. return ((string)(this[this.tablePr.ТелефонColumn]));
  636. }
  637. set {
  638. this[this.tablePr.ТелефонColumn] = value;
  639. }
  640. }
  641. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  642. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  643. public string Email {
  644. get {
  645. return ((string)(this[this.tablePr.EmailColumn]));
  646. }
  647. set {
  648. this[this.tablePr.EmailColumn] = value;
  649. }
  650. }
  651. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  652. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  653. public string Наименование_услуги {
  654. get {
  655. return ((string)(this[this.tablePr.Наименование_услугиColumn]));
  656. }
  657. set {
  658. this[this.tablePr.Наименование_услугиColumn] = value;
  659. }
  660. }
  661. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  662. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  663. public System.DateTime Дата_регистрации {
  664. get {
  665. return ((global::System.DateTime)(this[this.tablePr.Дата_регистрацииColumn]));
  666. }
  667. set {
  668. this[this.tablePr.Дата_регистрацииColumn] = value;
  669. }
  670. }
  671. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  672. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  673. public System.DateTime Дата_рождения {
  674. get {
  675. return ((global::System.DateTime)(this[this.tablePr.Дата_рожденияColumn]));
  676. }
  677. set {
  678. this[this.tablePr.Дата_рожденияColumn] = value;
  679. }
  680. }
  681. }
  682. /// <summary>
  683. ///Row event argument class
  684. ///</summary>
  685. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  686. public class PrRowChangeEvent : global::System.EventArgs {
  687. private PrRow eventRow;
  688. private global::System.Data.DataRowAction eventAction;
  689. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  690. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  691. public PrRowChangeEvent(PrRow row, global::System.Data.DataRowAction action) {
  692. this.eventRow = row;
  693. this.eventAction = action;
  694. }
  695. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  696. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  697. public PrRow Row {
  698. get {
  699. return this.eventRow;
  700. }
  701. }
  702. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  703. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  704. public global::System.Data.DataRowAction Action {
  705. get {
  706. return this.eventAction;
  707. }
  708. }
  709. }
  710. }
  711. }
  712. namespace RozenbergBrovki.RozenbergBrDataSet1TableAdapters {
  713. /// <summary>
  714. ///Represents the connection and commands used to retrieve and save data.
  715. ///</summary>
  716. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  717. [global::System.ComponentModel.ToolboxItem(true)]
  718. [global::System.ComponentModel.DataObjectAttribute(true)]
  719. [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
  720. ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
  721. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  722. public partial class PrTableAdapter : global::System.ComponentModel.Component {
  723. private global::System.Data.SqlClient.SqlDataAdapter _adapter;
  724. private global::System.Data.SqlClient.SqlConnection _connection;
  725. private global::System.Data.SqlClient.SqlTransaction _transaction;
  726. private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
  727. private bool _clearBeforeFill;
  728. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  729. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  730. public PrTableAdapter() {
  731. this.ClearBeforeFill = true;
  732. }
  733. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  734. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  735. protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
  736. get {
  737. if ((this._adapter == null)) {
  738. this.InitAdapter();
  739. }
  740. return this._adapter;
  741. }
  742. }
  743. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  744. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  745. internal global::System.Data.SqlClient.SqlConnection Connection {
  746. get {
  747. if ((this._connection == null)) {
  748. this.InitConnection();
  749. }
  750. return this._connection;
  751. }
  752. set {
  753. this._connection = value;
  754. if ((this.Adapter.InsertCommand != null)) {
  755. this.Adapter.InsertCommand.Connection = value;
  756. }
  757. if ((this.Adapter.DeleteCommand != null)) {
  758. this.Adapter.DeleteCommand.Connection = value;
  759. }
  760. if ((this.Adapter.UpdateCommand != null)) {
  761. this.Adapter.UpdateCommand.Connection = value;
  762. }
  763. for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  764. if ((this.CommandCollection[i] != null)) {
  765. ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
  766. }
  767. }
  768. }
  769. }
  770. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  771. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  772. internal global::System.Data.SqlClient.SqlTransaction Transaction {
  773. get {
  774. return this._transaction;
  775. }
  776. set {
  777. this._transaction = value;
  778. for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  779. this.CommandCollection[i].Transaction = this._transaction;
  780. }
  781. if (((this.Adapter != null)
  782. && (this.Adapter.DeleteCommand != null))) {
  783. this.Adapter.DeleteCommand.Transaction = this._transaction;
  784. }
  785. if (((this.Adapter != null)
  786. && (this.Adapter.InsertCommand != null))) {
  787. this.Adapter.InsertCommand.Transaction = this._transaction;
  788. }
  789. if (((this.Adapter != null)
  790. && (this.Adapter.UpdateCommand != null))) {
  791. this.Adapter.UpdateCommand.Transaction = this._transaction;
  792. }
  793. }
  794. }
  795. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  796. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  797. protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
  798. get {
  799. if ((this._commandCollection == null)) {
  800. this.InitCommandCollection();
  801. }
  802. return this._commandCollection;
  803. }
  804. }
  805. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  806. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  807. public bool ClearBeforeFill {
  808. get {
  809. return this._clearBeforeFill;
  810. }
  811. set {
  812. this._clearBeforeFill = value;
  813. }
  814. }
  815. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  816. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  817. private void InitAdapter() {
  818. this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
  819. global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
  820. tableMapping.SourceTable = "Table";
  821. tableMapping.DataSetTable = "Pr";
  822. tableMapping.ColumnMappings.Add("Фамилия", "Фамилия");
  823. tableMapping.ColumnMappings.Add("Имя", "Имя");
  824. tableMapping.ColumnMappings.Add("Отчество", "Отчество");
  825. tableMapping.ColumnMappings.Add("Пол", "Пол");
  826. tableMapping.ColumnMappings.Add("Телефон", "Телефон");
  827. tableMapping.ColumnMappings.Add("Email", "Email");
  828. tableMapping.ColumnMappings.Add("Наименование_услуги", "Наименование_услуги");
  829. tableMapping.ColumnMappings.Add("Дата_регистрации", "Дата_регистрации");
  830. tableMapping.ColumnMappings.Add("Дата_рождения", "Дата_рождения");
  831. this._adapter.TableMappings.Add(tableMapping);
  832. }
  833. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  834. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  835. private void InitConnection() {
  836. this._connection = new global::System.Data.SqlClient.SqlConnection();
  837. this._connection.ConnectionString = global::RozenbergBrovki.Properties.Settings.Default.RozenbergBrConnectionString;
  838. }
  839. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  840. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  841. private void InitCommandCollection() {
  842. this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
  843. this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
  844. this._commandCollection[0].Connection = this.Connection;
  845. this._commandCollection[0].CommandText = "SELECT Фамилия, Имя, Отчество, Пол, Телефон, Email, Наименование_услуги, Дата_рег" +
  846. "истрации, Дата_рождения FROM dbo.Pr";
  847. this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
  848. }
  849. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  850. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  851. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  852. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
  853. public virtual int Fill(RozenbergBrDataSet1.PrDataTable dataTable) {
  854. this.Adapter.SelectCommand = this.CommandCollection[0];
  855. if ((this.ClearBeforeFill == true)) {
  856. dataTable.Clear();
  857. }
  858. int returnValue = this.Adapter.Fill(dataTable);
  859. return returnValue;
  860. }
  861. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  862. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  863. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  864. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
  865. public virtual RozenbergBrDataSet1.PrDataTable GetData() {
  866. this.Adapter.SelectCommand = this.CommandCollection[0];
  867. RozenbergBrDataSet1.PrDataTable dataTable = new RozenbergBrDataSet1.PrDataTable();
  868. this.Adapter.Fill(dataTable);
  869. return dataTable;
  870. }
  871. }
  872. /// <summary>
  873. ///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
  874. ///</summary>
  875. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  876. [global::System.ComponentModel.ToolboxItem(true)]
  877. [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
  878. "esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
  879. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
  880. public partial class TableAdapterManager : global::System.ComponentModel.Component {
  881. private UpdateOrderOption _updateOrder;
  882. private bool _backupDataSetBeforeUpdate;
  883. private global::System.Data.IDbConnection _connection;
  884. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  885. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  886. public UpdateOrderOption UpdateOrder {
  887. get {
  888. return this._updateOrder;
  889. }
  890. set {
  891. this._updateOrder = value;
  892. }
  893. }
  894. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  895. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  896. public bool BackupDataSetBeforeUpdate {
  897. get {
  898. return this._backupDataSetBeforeUpdate;
  899. }
  900. set {
  901. this._backupDataSetBeforeUpdate = value;
  902. }
  903. }
  904. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  905. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  906. [global::System.ComponentModel.Browsable(false)]
  907. public global::System.Data.IDbConnection Connection {
  908. get {
  909. if ((this._connection != null)) {
  910. return this._connection;
  911. }
  912. return null;
  913. }
  914. set {
  915. this._connection = value;
  916. }
  917. }
  918. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  919. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  920. [global::System.ComponentModel.Browsable(false)]
  921. public int TableAdapterInstanceCount {
  922. get {
  923. int count = 0;
  924. return count;
  925. }
  926. }
  927. /// <summary>
  928. ///Update rows in top-down order.
  929. ///</summary>
  930. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  931. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  932. private int UpdateUpdatedRows(RozenbergBrDataSet1 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  933. int result = 0;
  934. return result;
  935. }
  936. /// <summary>
  937. ///Insert rows in top-down order.
  938. ///</summary>
  939. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  940. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  941. private int UpdateInsertedRows(RozenbergBrDataSet1 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  942. int result = 0;
  943. return result;
  944. }
  945. /// <summary>
  946. ///Delete rows in bottom-up order.
  947. ///</summary>
  948. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  949. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  950. private int UpdateDeletedRows(RozenbergBrDataSet1 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows) {
  951. int result = 0;
  952. return result;
  953. }
  954. /// <summary>
  955. ///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
  956. ///</summary>
  957. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  958. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  959. private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  960. if (((updatedRows == null)
  961. || (updatedRows.Length < 1))) {
  962. return updatedRows;
  963. }
  964. if (((allAddedRows == null)
  965. || (allAddedRows.Count < 1))) {
  966. return updatedRows;
  967. }
  968. global::System.Collections.Generic.List<global::System.Data.DataRow> realUpdatedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  969. for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
  970. global::System.Data.DataRow row = updatedRows[i];
  971. if ((allAddedRows.Contains(row) == false)) {
  972. realUpdatedRows.Add(row);
  973. }
  974. }
  975. return realUpdatedRows.ToArray();
  976. }
  977. /// <summary>
  978. ///Update all changes to the dataset.
  979. ///</summary>
  980. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  981. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  982. public virtual int UpdateAll(RozenbergBrDataSet1 dataSet) {
  983. if ((dataSet == null)) {
  984. throw new global::System.ArgumentNullException("dataSet");
  985. }
  986. if ((dataSet.HasChanges() == false)) {
  987. return 0;
  988. }
  989. global::System.Data.IDbConnection workConnection = this.Connection;
  990. if ((workConnection == null)) {
  991. throw new global::System.ApplicationException("TableAdapterManager не содержит сведений о подключении. Укажите для каждого адапт" +
  992. "ера таблицы TableAdapterManager допустимый экземпляр адаптера таблицы.");
  993. }
  994. bool workConnOpened = false;
  995. if (((workConnection.State & global::System.Data.ConnectionState.Broken)
  996. == global::System.Data.ConnectionState.Broken)) {
  997. workConnection.Close();
  998. }
  999. if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
  1000. workConnection.Open();
  1001. workConnOpened = true;
  1002. }
  1003. global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
  1004. if ((workTransaction == null)) {
  1005. throw new global::System.ApplicationException("Не удается начать транзакцию. Текущее соединение данных не поддерживает транзакци" +
  1006. "и или текущее состояние не позволяет начать транзакцию.");
  1007. }
  1008. global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  1009. global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  1010. global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter> adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter>();
  1011. global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection> revertConnections = new global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection>();
  1012. int result = 0;
  1013. global::System.Data.DataSet backupDataSet = null;
  1014. if (this.BackupDataSetBeforeUpdate) {
  1015. backupDataSet = new global::System.Data.DataSet();
  1016. backupDataSet.Merge(dataSet);
  1017. }
  1018. try {
  1019. // ---- Prepare for update -----------
  1020. //
  1021. //
  1022. //---- Perform updates -----------
  1023. //
  1024. if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) {
  1025. result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
  1026. result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
  1027. }
  1028. else {
  1029. result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
  1030. result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
  1031. }
  1032. result = (result + this.UpdateDeletedRows(dataSet, allChangedRows));
  1033. //
  1034. //---- Commit updates -----------
  1035. //
  1036. workTransaction.Commit();
  1037. if ((0 < allAddedRows.Count)) {
  1038. global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
  1039. allAddedRows.CopyTo(rows);
  1040. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  1041. global::System.Data.DataRow row = rows[i];
  1042. row.AcceptChanges();
  1043. }
  1044. }
  1045. if ((0 < allChangedRows.Count)) {
  1046. global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count];
  1047. allChangedRows.CopyTo(rows);
  1048. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  1049. global::System.Data.DataRow row = rows[i];
  1050. row.AcceptChanges();
  1051. }
  1052. }
  1053. }
  1054. catch (global::System.Exception ex) {
  1055. workTransaction.Rollback();
  1056. // ---- Restore the dataset -----------
  1057. if (this.BackupDataSetBeforeUpdate) {
  1058. global::System.Diagnostics.Debug.Assert((backupDataSet != null));
  1059. dataSet.Clear();
  1060. dataSet.Merge(backupDataSet);
  1061. }
  1062. else {
  1063. if ((0 < allAddedRows.Count)) {
  1064. global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
  1065. allAddedRows.CopyTo(rows);
  1066. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  1067. global::System.Data.DataRow row = rows[i];
  1068. row.AcceptChanges();
  1069. row.SetAdded();
  1070. }
  1071. }
  1072. }
  1073. throw ex;
  1074. }
  1075. finally {
  1076. if (workConnOpened) {
  1077. workConnection.Close();
  1078. }
  1079. if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) {
  1080. global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count];
  1081. adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters);
  1082. for (int i = 0; (i < adapters.Length); i = (i + 1)) {
  1083. global::System.Data.Common.DataAdapter adapter = adapters[i];
  1084. adapter.AcceptChangesDuringUpdate = true;
  1085. }
  1086. }
  1087. }
  1088. return result;
  1089. }
  1090. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1091. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1092. protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) {
  1093. global::System.Array.Sort<global::System.Data.DataRow>(rows, new SelfReferenceComparer(relation, childFirst));
  1094. }
  1095. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1096. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1097. protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) {
  1098. if ((this._connection != null)) {
  1099. return true;
  1100. }
  1101. if (((this.Connection == null)
  1102. || (inputConnection == null))) {
  1103. return true;
  1104. }
  1105. if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) {
  1106. return true;
  1107. }
  1108. return false;
  1109. }
  1110. /// <summary>
  1111. ///Update Order Option
  1112. ///</summary>
  1113. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1114. public enum UpdateOrderOption {
  1115. InsertUpdateDelete = 0,
  1116. UpdateInsertDelete = 1,
  1117. }
  1118. /// <summary>
  1119. ///Used to sort self-referenced table's rows
  1120. ///</summary>
  1121. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1122. private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer<global::System.Data.DataRow> {
  1123. private global::System.Data.DataRelation _relation;
  1124. private int _childFirst;
  1125. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1126. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1127. internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) {
  1128. this._relation = relation;
  1129. if (childFirst) {
  1130. this._childFirst = -1;
  1131. }
  1132. else {
  1133. this._childFirst = 1;
  1134. }
  1135. }
  1136. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1137. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1138. private global::System.Data.DataRow GetRoot(global::System.Data.DataRow row, out int distance) {
  1139. global::System.Diagnostics.Debug.Assert((row != null));
  1140. global::System.Data.DataRow root = row;
  1141. distance = 0;
  1142. 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>();
  1143. traversedRows[row] = row;
  1144. global::System.Data.DataRow parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
  1145. for (
  1146. ; ((parent != null)
  1147. && (traversedRows.ContainsKey(parent) == false));
  1148. ) {
  1149. distance = (distance + 1);
  1150. root = parent;
  1151. traversedRows[parent] = parent;
  1152. parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
  1153. }
  1154. if ((distance == 0)) {
  1155. traversedRows.Clear();
  1156. traversedRows[row] = row;
  1157. parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
  1158. for (
  1159. ; ((parent != null)
  1160. && (traversedRows.ContainsKey(parent) == false));
  1161. ) {
  1162. distance = (distance + 1);
  1163. root = parent;
  1164. traversedRows[parent] = parent;
  1165. parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
  1166. }
  1167. }
  1168. return root;
  1169. }
  1170. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1171. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1172. public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) {
  1173. if (object.ReferenceEquals(row1, row2)) {
  1174. return 0;
  1175. }
  1176. if ((row1 == null)) {
  1177. return -1;
  1178. }
  1179. if ((row2 == null)) {
  1180. return 1;
  1181. }
  1182. int distance1 = 0;
  1183. global::System.Data.DataRow root1 = this.GetRoot(row1, out distance1);
  1184. int distance2 = 0;
  1185. global::System.Data.DataRow root2 = this.GetRoot(row2, out distance2);
  1186. if (object.ReferenceEquals(root1, root2)) {
  1187. return (this._childFirst * distance1.CompareTo(distance2));
  1188. }
  1189. else {
  1190. global::System.Diagnostics.Debug.Assert(((root1.Table != null)
  1191. && (root2.Table != null)));
  1192. if ((root1.Table.Rows.IndexOf(root1) < root2.Table.Rows.IndexOf(root2))) {
  1193. return -1;
  1194. }
  1195. else {
  1196. return 1;
  1197. }
  1198. }
  1199. }
  1200. }
  1201. }
  1202. }
  1203. #pragma warning restore 1591