konkursDataSet.Designer.cs 122 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971
  1. //------------------------------------------------------------------------------
  2. // <auto-generated>
  3. // Этот код создан программой.
  4. // Исполняемая версия:4.0.30319.42000
  5. //
  6. // Изменения в этом файле могут привести к неправильной работе и будут потеряны в случае
  7. // повторной генерации кода.
  8. // </auto-generated>
  9. //------------------------------------------------------------------------------
  10. #pragma warning disable 1591
  11. namespace konkurs {
  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("konkursDataSet")]
  20. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
  21. public partial class konkursDataSet : global::System.Data.DataSet {
  22. private bronirovenieDataTable tablebronirovenie;
  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 konkursDataSet() {
  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 konkursDataSet(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["bronirovenie"] != null)) {
  50. base.Tables.Add(new bronirovenieDataTable(ds.Tables["bronirovenie"]));
  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 bronirovenieDataTable bronirovenie {
  74. get {
  75. return this.tablebronirovenie;
  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. konkursDataSet cln = ((konkursDataSet)(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["bronirovenie"] != null)) {
  139. base.Tables.Add(new bronirovenieDataTable(ds.Tables["bronirovenie"]));
  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.tablebronirovenie = ((bronirovenieDataTable)(base.Tables["bronirovenie"]));
  172. if ((initTable == true)) {
  173. if ((this.tablebronirovenie != null)) {
  174. this.tablebronirovenie.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 = "konkursDataSet";
  182. this.Prefix = "";
  183. this.Namespace = "http://tempuri.org/konkursDataSet.xsd";
  184. this.EnforceConstraints = true;
  185. this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
  186. this.tablebronirovenie = new bronirovenieDataTable();
  187. base.Tables.Add(this.tablebronirovenie);
  188. }
  189. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  190. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  191. private bool ShouldSerializebronirovenie() {
  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. konkursDataSet ds = new konkursDataSet();
  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 bronirovenieRowChangeEventHandler(object sender, bronirovenieRowChangeEvent 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 bronirovenieDataTable : global::System.Data.TypedTableBase<bronirovenieRow> {
  255. private global::System.Data.DataColumn columnnomer_kvitancii;
  256. private global::System.Data.DataColumn columndate_broni;
  257. private global::System.Data.DataColumn columndate_zaezda;
  258. private global::System.Data.DataColumn columnnomer_mesta;
  259. private global::System.Data.DataColumn columnkod_clients;
  260. private global::System.Data.DataColumn columnchislo_days;
  261. private global::System.Data.DataColumn columndate_oplati;
  262. private global::System.Data.DataColumn columnsale_oplata;
  263. private global::System.Data.DataColumn columnsale_season;
  264. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  265. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  266. public bronirovenieDataTable() {
  267. this.TableName = "bronirovenie";
  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 bronirovenieDataTable(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 bronirovenieDataTable(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 nomer_kvitanciiColumn {
  297. get {
  298. return this.columnnomer_kvitancii;
  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 date_broniColumn {
  304. get {
  305. return this.columndate_broni;
  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 date_zaezdaColumn {
  311. get {
  312. return this.columndate_zaezda;
  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 nomer_mestaColumn {
  318. get {
  319. return this.columnnomer_mesta;
  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 kod_clientsColumn {
  325. get {
  326. return this.columnkod_clients;
  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 chislo_daysColumn {
  332. get {
  333. return this.columnchislo_days;
  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 date_oplatiColumn {
  339. get {
  340. return this.columndate_oplati;
  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 sale_oplataColumn {
  346. get {
  347. return this.columnsale_oplata;
  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 sale_seasonColumn {
  353. get {
  354. return this.columnsale_season;
  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 bronirovenieRow this[int index] {
  368. get {
  369. return ((bronirovenieRow)(this.Rows[index]));
  370. }
  371. }
  372. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  373. public event bronirovenieRowChangeEventHandler bronirovenieRowChanging;
  374. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  375. public event bronirovenieRowChangeEventHandler bronirovenieRowChanged;
  376. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  377. public event bronirovenieRowChangeEventHandler bronirovenieRowDeleting;
  378. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  379. public event bronirovenieRowChangeEventHandler bronirovenieRowDeleted;
  380. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  381. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  382. public void AddbronirovenieRow(bronirovenieRow 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 bronirovenieRow AddbronirovenieRow(int nomer_kvitancii, System.DateTime date_broni, System.DateTime date_zaezda, string nomer_mesta, string kod_clients, string chislo_days, System.DateTime date_oplati, string sale_oplata, string sale_season) {
  388. bronirovenieRow rowbronirovenieRow = ((bronirovenieRow)(this.NewRow()));
  389. object[] columnValuesArray = new object[] {
  390. nomer_kvitancii,
  391. date_broni,
  392. date_zaezda,
  393. nomer_mesta,
  394. kod_clients,
  395. chislo_days,
  396. date_oplati,
  397. sale_oplata,
  398. sale_season};
  399. rowbronirovenieRow.ItemArray = columnValuesArray;
  400. this.Rows.Add(rowbronirovenieRow);
  401. return rowbronirovenieRow;
  402. }
  403. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  404. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  405. public bronirovenieRow FindBynomer_kvitancii(int nomer_kvitancii) {
  406. return ((bronirovenieRow)(this.Rows.Find(new object[] {
  407. nomer_kvitancii})));
  408. }
  409. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  410. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  411. public override global::System.Data.DataTable Clone() {
  412. bronirovenieDataTable cln = ((bronirovenieDataTable)(base.Clone()));
  413. cln.InitVars();
  414. return cln;
  415. }
  416. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  417. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  418. protected override global::System.Data.DataTable CreateInstance() {
  419. return new bronirovenieDataTable();
  420. }
  421. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  422. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  423. internal void InitVars() {
  424. this.columnnomer_kvitancii = base.Columns["nomer_kvitancii"];
  425. this.columndate_broni = base.Columns["date_broni"];
  426. this.columndate_zaezda = base.Columns["date_zaezda"];
  427. this.columnnomer_mesta = base.Columns["nomer_mesta"];
  428. this.columnkod_clients = base.Columns["kod_clients"];
  429. this.columnchislo_days = base.Columns["chislo_days"];
  430. this.columndate_oplati = base.Columns["date_oplati"];
  431. this.columnsale_oplata = base.Columns["sale_oplata"];
  432. this.columnsale_season = base.Columns["sale_season"];
  433. }
  434. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  435. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  436. private void InitClass() {
  437. this.columnnomer_kvitancii = new global::System.Data.DataColumn("nomer_kvitancii", typeof(int), null, global::System.Data.MappingType.Element);
  438. base.Columns.Add(this.columnnomer_kvitancii);
  439. this.columndate_broni = new global::System.Data.DataColumn("date_broni", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
  440. base.Columns.Add(this.columndate_broni);
  441. this.columndate_zaezda = new global::System.Data.DataColumn("date_zaezda", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
  442. base.Columns.Add(this.columndate_zaezda);
  443. this.columnnomer_mesta = new global::System.Data.DataColumn("nomer_mesta", typeof(string), null, global::System.Data.MappingType.Element);
  444. base.Columns.Add(this.columnnomer_mesta);
  445. this.columnkod_clients = new global::System.Data.DataColumn("kod_clients", typeof(string), null, global::System.Data.MappingType.Element);
  446. base.Columns.Add(this.columnkod_clients);
  447. this.columnchislo_days = new global::System.Data.DataColumn("chislo_days", typeof(string), null, global::System.Data.MappingType.Element);
  448. base.Columns.Add(this.columnchislo_days);
  449. this.columndate_oplati = new global::System.Data.DataColumn("date_oplati", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
  450. base.Columns.Add(this.columndate_oplati);
  451. this.columnsale_oplata = new global::System.Data.DataColumn("sale_oplata", typeof(string), null, global::System.Data.MappingType.Element);
  452. base.Columns.Add(this.columnsale_oplata);
  453. this.columnsale_season = new global::System.Data.DataColumn("sale_season", typeof(string), null, global::System.Data.MappingType.Element);
  454. base.Columns.Add(this.columnsale_season);
  455. this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
  456. this.columnnomer_kvitancii}, true));
  457. this.columnnomer_kvitancii.AllowDBNull = false;
  458. this.columnnomer_kvitancii.Unique = true;
  459. this.columnnomer_mesta.MaxLength = 10;
  460. this.columnkod_clients.MaxLength = 10;
  461. this.columnchislo_days.MaxLength = 10;
  462. this.columnsale_oplata.MaxLength = 10;
  463. this.columnsale_season.MaxLength = 10;
  464. }
  465. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  466. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  467. public bronirovenieRow NewbronirovenieRow() {
  468. return ((bronirovenieRow)(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 bronirovenieRow(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(bronirovenieRow);
  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.bronirovenieRowChanged != null)) {
  485. this.bronirovenieRowChanged(this, new bronirovenieRowChangeEvent(((bronirovenieRow)(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.bronirovenieRowChanging != null)) {
  493. this.bronirovenieRowChanging(this, new bronirovenieRowChangeEvent(((bronirovenieRow)(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.bronirovenieRowDeleted != null)) {
  501. this.bronirovenieRowDeleted(this, new bronirovenieRowChangeEvent(((bronirovenieRow)(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.bronirovenieRowDeleting != null)) {
  509. this.bronirovenieRowDeleting(this, new bronirovenieRowChangeEvent(((bronirovenieRow)(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 RemovebronirovenieRow(bronirovenieRow 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. konkursDataSet ds = new konkursDataSet();
  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 = "bronirovenieDataTable";
  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 bronirovenieRow : global::System.Data.DataRow {
  584. private bronirovenieDataTable tablebronirovenie;
  585. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  586. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  587. internal bronirovenieRow(global::System.Data.DataRowBuilder rb) :
  588. base(rb) {
  589. this.tablebronirovenie = ((bronirovenieDataTable)(this.Table));
  590. }
  591. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  592. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  593. public int nomer_kvitancii {
  594. get {
  595. return ((int)(this[this.tablebronirovenie.nomer_kvitanciiColumn]));
  596. }
  597. set {
  598. this[this.tablebronirovenie.nomer_kvitanciiColumn] = value;
  599. }
  600. }
  601. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  602. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  603. public System.DateTime date_broni {
  604. get {
  605. try {
  606. return ((global::System.DateTime)(this[this.tablebronirovenie.date_broniColumn]));
  607. }
  608. catch (global::System.InvalidCastException e) {
  609. throw new global::System.Data.StrongTypingException("Значение для столбца \'date_broni\' в таблице \'bronirovenie\' равно DBNull.", e);
  610. }
  611. }
  612. set {
  613. this[this.tablebronirovenie.date_broniColumn] = value;
  614. }
  615. }
  616. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  617. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  618. public System.DateTime date_zaezda {
  619. get {
  620. try {
  621. return ((global::System.DateTime)(this[this.tablebronirovenie.date_zaezdaColumn]));
  622. }
  623. catch (global::System.InvalidCastException e) {
  624. throw new global::System.Data.StrongTypingException("Значение для столбца \'date_zaezda\' в таблице \'bronirovenie\' равно DBNull.", e);
  625. }
  626. }
  627. set {
  628. this[this.tablebronirovenie.date_zaezdaColumn] = 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 nomer_mesta {
  634. get {
  635. try {
  636. return ((string)(this[this.tablebronirovenie.nomer_mestaColumn]));
  637. }
  638. catch (global::System.InvalidCastException e) {
  639. throw new global::System.Data.StrongTypingException("Значение для столбца \'nomer_mesta\' в таблице \'bronirovenie\' равно DBNull.", e);
  640. }
  641. }
  642. set {
  643. this[this.tablebronirovenie.nomer_mestaColumn] = value;
  644. }
  645. }
  646. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  647. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  648. public string kod_clients {
  649. get {
  650. try {
  651. return ((string)(this[this.tablebronirovenie.kod_clientsColumn]));
  652. }
  653. catch (global::System.InvalidCastException e) {
  654. throw new global::System.Data.StrongTypingException("Значение для столбца \'kod_clients\' в таблице \'bronirovenie\' равно DBNull.", e);
  655. }
  656. }
  657. set {
  658. this[this.tablebronirovenie.kod_clientsColumn] = value;
  659. }
  660. }
  661. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  662. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  663. public string chislo_days {
  664. get {
  665. try {
  666. return ((string)(this[this.tablebronirovenie.chislo_daysColumn]));
  667. }
  668. catch (global::System.InvalidCastException e) {
  669. throw new global::System.Data.StrongTypingException("Значение для столбца \'chislo_days\' в таблице \'bronirovenie\' равно DBNull.", e);
  670. }
  671. }
  672. set {
  673. this[this.tablebronirovenie.chislo_daysColumn] = value;
  674. }
  675. }
  676. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  677. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  678. public System.DateTime date_oplati {
  679. get {
  680. try {
  681. return ((global::System.DateTime)(this[this.tablebronirovenie.date_oplatiColumn]));
  682. }
  683. catch (global::System.InvalidCastException e) {
  684. throw new global::System.Data.StrongTypingException("Значение для столбца \'date_oplati\' в таблице \'bronirovenie\' равно DBNull.", e);
  685. }
  686. }
  687. set {
  688. this[this.tablebronirovenie.date_oplatiColumn] = value;
  689. }
  690. }
  691. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  692. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  693. public string sale_oplata {
  694. get {
  695. try {
  696. return ((string)(this[this.tablebronirovenie.sale_oplataColumn]));
  697. }
  698. catch (global::System.InvalidCastException e) {
  699. throw new global::System.Data.StrongTypingException("Значение для столбца \'sale_oplata\' в таблице \'bronirovenie\' равно DBNull.", e);
  700. }
  701. }
  702. set {
  703. this[this.tablebronirovenie.sale_oplataColumn] = value;
  704. }
  705. }
  706. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  707. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  708. public string sale_season {
  709. get {
  710. try {
  711. return ((string)(this[this.tablebronirovenie.sale_seasonColumn]));
  712. }
  713. catch (global::System.InvalidCastException e) {
  714. throw new global::System.Data.StrongTypingException("Значение для столбца \'sale_season\' в таблице \'bronirovenie\' равно DBNull.", e);
  715. }
  716. }
  717. set {
  718. this[this.tablebronirovenie.sale_seasonColumn] = value;
  719. }
  720. }
  721. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  722. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  723. public bool Isdate_broniNull() {
  724. return this.IsNull(this.tablebronirovenie.date_broniColumn);
  725. }
  726. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  727. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  728. public void Setdate_broniNull() {
  729. this[this.tablebronirovenie.date_broniColumn] = global::System.Convert.DBNull;
  730. }
  731. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  732. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  733. public bool Isdate_zaezdaNull() {
  734. return this.IsNull(this.tablebronirovenie.date_zaezdaColumn);
  735. }
  736. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  737. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  738. public void Setdate_zaezdaNull() {
  739. this[this.tablebronirovenie.date_zaezdaColumn] = global::System.Convert.DBNull;
  740. }
  741. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  742. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  743. public bool Isnomer_mestaNull() {
  744. return this.IsNull(this.tablebronirovenie.nomer_mestaColumn);
  745. }
  746. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  747. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  748. public void Setnomer_mestaNull() {
  749. this[this.tablebronirovenie.nomer_mestaColumn] = global::System.Convert.DBNull;
  750. }
  751. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  752. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  753. public bool Iskod_clientsNull() {
  754. return this.IsNull(this.tablebronirovenie.kod_clientsColumn);
  755. }
  756. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  757. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  758. public void Setkod_clientsNull() {
  759. this[this.tablebronirovenie.kod_clientsColumn] = global::System.Convert.DBNull;
  760. }
  761. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  762. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  763. public bool Ischislo_daysNull() {
  764. return this.IsNull(this.tablebronirovenie.chislo_daysColumn);
  765. }
  766. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  767. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  768. public void Setchislo_daysNull() {
  769. this[this.tablebronirovenie.chislo_daysColumn] = global::System.Convert.DBNull;
  770. }
  771. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  772. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  773. public bool Isdate_oplatiNull() {
  774. return this.IsNull(this.tablebronirovenie.date_oplatiColumn);
  775. }
  776. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  777. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  778. public void Setdate_oplatiNull() {
  779. this[this.tablebronirovenie.date_oplatiColumn] = global::System.Convert.DBNull;
  780. }
  781. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  782. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  783. public bool Issale_oplataNull() {
  784. return this.IsNull(this.tablebronirovenie.sale_oplataColumn);
  785. }
  786. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  787. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  788. public void Setsale_oplataNull() {
  789. this[this.tablebronirovenie.sale_oplataColumn] = global::System.Convert.DBNull;
  790. }
  791. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  792. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  793. public bool Issale_seasonNull() {
  794. return this.IsNull(this.tablebronirovenie.sale_seasonColumn);
  795. }
  796. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  797. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  798. public void Setsale_seasonNull() {
  799. this[this.tablebronirovenie.sale_seasonColumn] = global::System.Convert.DBNull;
  800. }
  801. }
  802. /// <summary>
  803. ///Row event argument class
  804. ///</summary>
  805. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  806. public class bronirovenieRowChangeEvent : global::System.EventArgs {
  807. private bronirovenieRow eventRow;
  808. private global::System.Data.DataRowAction eventAction;
  809. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  810. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  811. public bronirovenieRowChangeEvent(bronirovenieRow row, global::System.Data.DataRowAction action) {
  812. this.eventRow = row;
  813. this.eventAction = action;
  814. }
  815. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  816. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  817. public bronirovenieRow Row {
  818. get {
  819. return this.eventRow;
  820. }
  821. }
  822. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  823. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  824. public global::System.Data.DataRowAction Action {
  825. get {
  826. return this.eventAction;
  827. }
  828. }
  829. }
  830. }
  831. }
  832. namespace konkurs.konkursDataSetTableAdapters {
  833. /// <summary>
  834. ///Represents the connection and commands used to retrieve and save data.
  835. ///</summary>
  836. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  837. [global::System.ComponentModel.ToolboxItem(true)]
  838. [global::System.ComponentModel.DataObjectAttribute(true)]
  839. [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
  840. ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
  841. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  842. public partial class bronirovenieTableAdapter : global::System.ComponentModel.Component {
  843. private global::System.Data.SqlClient.SqlDataAdapter _adapter;
  844. private global::System.Data.SqlClient.SqlConnection _connection;
  845. private global::System.Data.SqlClient.SqlTransaction _transaction;
  846. private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
  847. private bool _clearBeforeFill;
  848. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  849. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  850. public bronirovenieTableAdapter() {
  851. this.ClearBeforeFill = true;
  852. }
  853. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  854. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  855. protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
  856. get {
  857. if ((this._adapter == null)) {
  858. this.InitAdapter();
  859. }
  860. return this._adapter;
  861. }
  862. }
  863. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  864. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  865. internal global::System.Data.SqlClient.SqlConnection Connection {
  866. get {
  867. if ((this._connection == null)) {
  868. this.InitConnection();
  869. }
  870. return this._connection;
  871. }
  872. set {
  873. this._connection = value;
  874. if ((this.Adapter.InsertCommand != null)) {
  875. this.Adapter.InsertCommand.Connection = value;
  876. }
  877. if ((this.Adapter.DeleteCommand != null)) {
  878. this.Adapter.DeleteCommand.Connection = value;
  879. }
  880. if ((this.Adapter.UpdateCommand != null)) {
  881. this.Adapter.UpdateCommand.Connection = value;
  882. }
  883. for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  884. if ((this.CommandCollection[i] != null)) {
  885. ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
  886. }
  887. }
  888. }
  889. }
  890. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  891. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  892. internal global::System.Data.SqlClient.SqlTransaction Transaction {
  893. get {
  894. return this._transaction;
  895. }
  896. set {
  897. this._transaction = value;
  898. for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  899. this.CommandCollection[i].Transaction = this._transaction;
  900. }
  901. if (((this.Adapter != null)
  902. && (this.Adapter.DeleteCommand != null))) {
  903. this.Adapter.DeleteCommand.Transaction = this._transaction;
  904. }
  905. if (((this.Adapter != null)
  906. && (this.Adapter.InsertCommand != null))) {
  907. this.Adapter.InsertCommand.Transaction = this._transaction;
  908. }
  909. if (((this.Adapter != null)
  910. && (this.Adapter.UpdateCommand != null))) {
  911. this.Adapter.UpdateCommand.Transaction = this._transaction;
  912. }
  913. }
  914. }
  915. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  916. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  917. protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
  918. get {
  919. if ((this._commandCollection == null)) {
  920. this.InitCommandCollection();
  921. }
  922. return this._commandCollection;
  923. }
  924. }
  925. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  926. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  927. public bool ClearBeforeFill {
  928. get {
  929. return this._clearBeforeFill;
  930. }
  931. set {
  932. this._clearBeforeFill = value;
  933. }
  934. }
  935. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  936. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  937. private void InitAdapter() {
  938. this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
  939. global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
  940. tableMapping.SourceTable = "Table";
  941. tableMapping.DataSetTable = "bronirovenie";
  942. tableMapping.ColumnMappings.Add("nomer_kvitancii", "nomer_kvitancii");
  943. tableMapping.ColumnMappings.Add("date_broni", "date_broni");
  944. tableMapping.ColumnMappings.Add("date_zaezda", "date_zaezda");
  945. tableMapping.ColumnMappings.Add("nomer_mesta", "nomer_mesta");
  946. tableMapping.ColumnMappings.Add("kod_clients", "kod_clients");
  947. tableMapping.ColumnMappings.Add("chislo_days", "chislo_days");
  948. tableMapping.ColumnMappings.Add("date_oplati", "date_oplati");
  949. tableMapping.ColumnMappings.Add("sale_oplata", "sale_oplata");
  950. tableMapping.ColumnMappings.Add("sale_season", "sale_season");
  951. this._adapter.TableMappings.Add(tableMapping);
  952. this._adapter.DeleteCommand = new global::System.Data.SqlClient.SqlCommand();
  953. this._adapter.DeleteCommand.Connection = this.Connection;
  954. this._adapter.DeleteCommand.CommandText = @"DELETE FROM [dbo].[bronirovenie] WHERE (([nomer_kvitancii] = @Original_nomer_kvitancii) AND ((@IsNull_date_broni = 1 AND [date_broni] IS NULL) OR ([date_broni] = @Original_date_broni)) AND ((@IsNull_date_zaezda = 1 AND [date_zaezda] IS NULL) OR ([date_zaezda] = @Original_date_zaezda)) AND ((@IsNull_nomer_mesta = 1 AND [nomer_mesta] IS NULL) OR ([nomer_mesta] = @Original_nomer_mesta)) AND ((@IsNull_kod_clients = 1 AND [kod_clients] IS NULL) OR ([kod_clients] = @Original_kod_clients)) AND ((@IsNull_chislo_days = 1 AND [chislo_days] IS NULL) OR ([chislo_days] = @Original_chislo_days)) AND ((@IsNull_date_oplati = 1 AND [date_oplati] IS NULL) OR ([date_oplati] = @Original_date_oplati)) AND ((@IsNull_sale_oplata = 1 AND [sale_oplata] IS NULL) OR ([sale_oplata] = @Original_sale_oplata)) AND ((@IsNull_sale_season = 1 AND [sale_season] IS NULL) OR ([sale_season] = @Original_sale_season)))";
  955. this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
  956. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_nomer_kvitancii", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "nomer_kvitancii", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  957. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_date_broni", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_broni", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  958. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_date_broni", global::System.Data.SqlDbType.Date, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_broni", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  959. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_date_zaezda", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_zaezda", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  960. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_date_zaezda", global::System.Data.SqlDbType.Date, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_zaezda", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  961. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_nomer_mesta", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "nomer_mesta", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  962. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_nomer_mesta", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "nomer_mesta", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  963. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_kod_clients", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "kod_clients", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  964. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_kod_clients", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "kod_clients", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  965. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_chislo_days", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "chislo_days", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  966. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_chislo_days", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "chislo_days", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  967. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_date_oplati", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_oplati", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  968. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_date_oplati", global::System.Data.SqlDbType.Date, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_oplati", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  969. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_sale_oplata", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "sale_oplata", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  970. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_sale_oplata", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "sale_oplata", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  971. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_sale_season", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "sale_season", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  972. this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_sale_season", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "sale_season", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  973. this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
  974. this._adapter.InsertCommand.Connection = this.Connection;
  975. this._adapter.InsertCommand.CommandText = @"INSERT INTO [dbo].[bronirovenie] ([nomer_kvitancii], [date_broni], [date_zaezda], [nomer_mesta], [kod_clients], [chislo_days], [date_oplati], [sale_oplata], [sale_season]) VALUES (@nomer_kvitancii, @date_broni, @date_zaezda, @nomer_mesta, @kod_clients, @chislo_days, @date_oplati, @sale_oplata, @sale_season);
  976. SELECT nomer_kvitancii, date_broni, date_zaezda, nomer_mesta, kod_clients, chislo_days, date_oplati, sale_oplata, sale_season FROM bronirovenie WHERE (nomer_kvitancii = @nomer_kvitancii)";
  977. this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
  978. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@nomer_kvitancii", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "nomer_kvitancii", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  979. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@date_broni", global::System.Data.SqlDbType.Date, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_broni", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  980. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@date_zaezda", global::System.Data.SqlDbType.Date, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_zaezda", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  981. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@nomer_mesta", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "nomer_mesta", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  982. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@kod_clients", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "kod_clients", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  983. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@chislo_days", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "chislo_days", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  984. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@date_oplati", global::System.Data.SqlDbType.Date, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_oplati", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  985. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@sale_oplata", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "sale_oplata", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  986. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@sale_season", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "sale_season", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  987. this._adapter.UpdateCommand = new global::System.Data.SqlClient.SqlCommand();
  988. this._adapter.UpdateCommand.Connection = this.Connection;
  989. this._adapter.UpdateCommand.CommandText = @"UPDATE [dbo].[bronirovenie] SET [nomer_kvitancii] = @nomer_kvitancii, [date_broni] = @date_broni, [date_zaezda] = @date_zaezda, [nomer_mesta] = @nomer_mesta, [kod_clients] = @kod_clients, [chislo_days] = @chislo_days, [date_oplati] = @date_oplati, [sale_oplata] = @sale_oplata, [sale_season] = @sale_season WHERE (([nomer_kvitancii] = @Original_nomer_kvitancii) AND ((@IsNull_date_broni = 1 AND [date_broni] IS NULL) OR ([date_broni] = @Original_date_broni)) AND ((@IsNull_date_zaezda = 1 AND [date_zaezda] IS NULL) OR ([date_zaezda] = @Original_date_zaezda)) AND ((@IsNull_nomer_mesta = 1 AND [nomer_mesta] IS NULL) OR ([nomer_mesta] = @Original_nomer_mesta)) AND ((@IsNull_kod_clients = 1 AND [kod_clients] IS NULL) OR ([kod_clients] = @Original_kod_clients)) AND ((@IsNull_chislo_days = 1 AND [chislo_days] IS NULL) OR ([chislo_days] = @Original_chislo_days)) AND ((@IsNull_date_oplati = 1 AND [date_oplati] IS NULL) OR ([date_oplati] = @Original_date_oplati)) AND ((@IsNull_sale_oplata = 1 AND [sale_oplata] IS NULL) OR ([sale_oplata] = @Original_sale_oplata)) AND ((@IsNull_sale_season = 1 AND [sale_season] IS NULL) OR ([sale_season] = @Original_sale_season)));
  990. SELECT nomer_kvitancii, date_broni, date_zaezda, nomer_mesta, kod_clients, chislo_days, date_oplati, sale_oplata, sale_season FROM bronirovenie WHERE (nomer_kvitancii = @nomer_kvitancii)";
  991. this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
  992. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@nomer_kvitancii", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "nomer_kvitancii", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  993. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@date_broni", global::System.Data.SqlDbType.Date, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_broni", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  994. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@date_zaezda", global::System.Data.SqlDbType.Date, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_zaezda", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  995. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@nomer_mesta", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "nomer_mesta", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  996. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@kod_clients", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "kod_clients", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  997. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@chislo_days", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "chislo_days", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  998. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@date_oplati", global::System.Data.SqlDbType.Date, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_oplati", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  999. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@sale_oplata", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "sale_oplata", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  1000. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@sale_season", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "sale_season", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  1001. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_nomer_kvitancii", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "nomer_kvitancii", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  1002. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_date_broni", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_broni", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  1003. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_date_broni", global::System.Data.SqlDbType.Date, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_broni", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  1004. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_date_zaezda", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_zaezda", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  1005. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_date_zaezda", global::System.Data.SqlDbType.Date, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_zaezda", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  1006. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_nomer_mesta", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "nomer_mesta", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  1007. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_nomer_mesta", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "nomer_mesta", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  1008. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_kod_clients", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "kod_clients", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  1009. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_kod_clients", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "kod_clients", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  1010. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_chislo_days", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "chislo_days", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  1011. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_chislo_days", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "chislo_days", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  1012. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_date_oplati", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_oplati", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  1013. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_date_oplati", global::System.Data.SqlDbType.Date, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date_oplati", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  1014. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_sale_oplata", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "sale_oplata", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  1015. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_sale_oplata", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "sale_oplata", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  1016. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_sale_season", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "sale_season", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
  1017. this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_sale_season", global::System.Data.SqlDbType.NChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "sale_season", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
  1018. }
  1019. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1020. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1021. private void InitConnection() {
  1022. this._connection = new global::System.Data.SqlClient.SqlConnection();
  1023. this._connection.ConnectionString = global::konkurs.Properties.Settings.Default.konkursConnectionString;
  1024. }
  1025. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1026. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1027. private void InitCommandCollection() {
  1028. this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
  1029. this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
  1030. this._commandCollection[0].Connection = this.Connection;
  1031. this._commandCollection[0].CommandText = "SELECT nomer_kvitancii, date_broni, date_zaezda, nomer_mesta, kod_clients, chislo" +
  1032. "_days, date_oplati, sale_oplata, sale_season FROM dbo.bronirovenie";
  1033. this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
  1034. }
  1035. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1036. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1037. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1038. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
  1039. public virtual int Fill(konkursDataSet.bronirovenieDataTable dataTable) {
  1040. this.Adapter.SelectCommand = this.CommandCollection[0];
  1041. if ((this.ClearBeforeFill == true)) {
  1042. dataTable.Clear();
  1043. }
  1044. int returnValue = this.Adapter.Fill(dataTable);
  1045. return returnValue;
  1046. }
  1047. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1048. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1049. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1050. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
  1051. public virtual konkursDataSet.bronirovenieDataTable GetData() {
  1052. this.Adapter.SelectCommand = this.CommandCollection[0];
  1053. konkursDataSet.bronirovenieDataTable dataTable = new konkursDataSet.bronirovenieDataTable();
  1054. this.Adapter.Fill(dataTable);
  1055. return dataTable;
  1056. }
  1057. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1058. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1059. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1060. public virtual int Update(konkursDataSet.bronirovenieDataTable dataTable) {
  1061. return this.Adapter.Update(dataTable);
  1062. }
  1063. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1064. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1065. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1066. public virtual int Update(konkursDataSet dataSet) {
  1067. return this.Adapter.Update(dataSet, "bronirovenie");
  1068. }
  1069. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1070. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1071. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1072. public virtual int Update(global::System.Data.DataRow dataRow) {
  1073. return this.Adapter.Update(new global::System.Data.DataRow[] {
  1074. dataRow});
  1075. }
  1076. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1077. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1078. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1079. public virtual int Update(global::System.Data.DataRow[] dataRows) {
  1080. return this.Adapter.Update(dataRows);
  1081. }
  1082. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1083. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1084. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1085. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)]
  1086. public virtual int Delete(int Original_nomer_kvitancii, global::System.Nullable<global::System.DateTime> Original_date_broni, global::System.Nullable<global::System.DateTime> Original_date_zaezda, string Original_nomer_mesta, string Original_kod_clients, string Original_chislo_days, global::System.Nullable<global::System.DateTime> Original_date_oplati, string Original_sale_oplata, string Original_sale_season) {
  1087. this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(Original_nomer_kvitancii));
  1088. if ((Original_date_broni.HasValue == true)) {
  1089. this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(0));
  1090. this.Adapter.DeleteCommand.Parameters[2].Value = ((System.DateTime)(Original_date_broni.Value));
  1091. }
  1092. else {
  1093. this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(1));
  1094. this.Adapter.DeleteCommand.Parameters[2].Value = global::System.DBNull.Value;
  1095. }
  1096. if ((Original_date_zaezda.HasValue == true)) {
  1097. this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0));
  1098. this.Adapter.DeleteCommand.Parameters[4].Value = ((System.DateTime)(Original_date_zaezda.Value));
  1099. }
  1100. else {
  1101. this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(1));
  1102. this.Adapter.DeleteCommand.Parameters[4].Value = global::System.DBNull.Value;
  1103. }
  1104. if ((Original_nomer_mesta == null)) {
  1105. this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(1));
  1106. this.Adapter.DeleteCommand.Parameters[6].Value = global::System.DBNull.Value;
  1107. }
  1108. else {
  1109. this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(0));
  1110. this.Adapter.DeleteCommand.Parameters[6].Value = ((string)(Original_nomer_mesta));
  1111. }
  1112. if ((Original_kod_clients == null)) {
  1113. this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(1));
  1114. this.Adapter.DeleteCommand.Parameters[8].Value = global::System.DBNull.Value;
  1115. }
  1116. else {
  1117. this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(0));
  1118. this.Adapter.DeleteCommand.Parameters[8].Value = ((string)(Original_kod_clients));
  1119. }
  1120. if ((Original_chislo_days == null)) {
  1121. this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(1));
  1122. this.Adapter.DeleteCommand.Parameters[10].Value = global::System.DBNull.Value;
  1123. }
  1124. else {
  1125. this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(0));
  1126. this.Adapter.DeleteCommand.Parameters[10].Value = ((string)(Original_chislo_days));
  1127. }
  1128. if ((Original_date_oplati.HasValue == true)) {
  1129. this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(0));
  1130. this.Adapter.DeleteCommand.Parameters[12].Value = ((System.DateTime)(Original_date_oplati.Value));
  1131. }
  1132. else {
  1133. this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(1));
  1134. this.Adapter.DeleteCommand.Parameters[12].Value = global::System.DBNull.Value;
  1135. }
  1136. if ((Original_sale_oplata == null)) {
  1137. this.Adapter.DeleteCommand.Parameters[13].Value = ((object)(1));
  1138. this.Adapter.DeleteCommand.Parameters[14].Value = global::System.DBNull.Value;
  1139. }
  1140. else {
  1141. this.Adapter.DeleteCommand.Parameters[13].Value = ((object)(0));
  1142. this.Adapter.DeleteCommand.Parameters[14].Value = ((string)(Original_sale_oplata));
  1143. }
  1144. if ((Original_sale_season == null)) {
  1145. this.Adapter.DeleteCommand.Parameters[15].Value = ((object)(1));
  1146. this.Adapter.DeleteCommand.Parameters[16].Value = global::System.DBNull.Value;
  1147. }
  1148. else {
  1149. this.Adapter.DeleteCommand.Parameters[15].Value = ((object)(0));
  1150. this.Adapter.DeleteCommand.Parameters[16].Value = ((string)(Original_sale_season));
  1151. }
  1152. global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
  1153. if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
  1154. != global::System.Data.ConnectionState.Open)) {
  1155. this.Adapter.DeleteCommand.Connection.Open();
  1156. }
  1157. try {
  1158. int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
  1159. return returnValue;
  1160. }
  1161. finally {
  1162. if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
  1163. this.Adapter.DeleteCommand.Connection.Close();
  1164. }
  1165. }
  1166. }
  1167. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1168. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1169. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1170. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
  1171. public virtual int Insert(int nomer_kvitancii, global::System.Nullable<global::System.DateTime> date_broni, global::System.Nullable<global::System.DateTime> date_zaezda, string nomer_mesta, string kod_clients, string chislo_days, global::System.Nullable<global::System.DateTime> date_oplati, string sale_oplata, string sale_season) {
  1172. this.Adapter.InsertCommand.Parameters[0].Value = ((int)(nomer_kvitancii));
  1173. if ((date_broni.HasValue == true)) {
  1174. this.Adapter.InsertCommand.Parameters[1].Value = ((System.DateTime)(date_broni.Value));
  1175. }
  1176. else {
  1177. this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
  1178. }
  1179. if ((date_zaezda.HasValue == true)) {
  1180. this.Adapter.InsertCommand.Parameters[2].Value = ((System.DateTime)(date_zaezda.Value));
  1181. }
  1182. else {
  1183. this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
  1184. }
  1185. if ((nomer_mesta == null)) {
  1186. this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
  1187. }
  1188. else {
  1189. this.Adapter.InsertCommand.Parameters[3].Value = ((string)(nomer_mesta));
  1190. }
  1191. if ((kod_clients == null)) {
  1192. this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
  1193. }
  1194. else {
  1195. this.Adapter.InsertCommand.Parameters[4].Value = ((string)(kod_clients));
  1196. }
  1197. if ((chislo_days == null)) {
  1198. this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
  1199. }
  1200. else {
  1201. this.Adapter.InsertCommand.Parameters[5].Value = ((string)(chislo_days));
  1202. }
  1203. if ((date_oplati.HasValue == true)) {
  1204. this.Adapter.InsertCommand.Parameters[6].Value = ((System.DateTime)(date_oplati.Value));
  1205. }
  1206. else {
  1207. this.Adapter.InsertCommand.Parameters[6].Value = global::System.DBNull.Value;
  1208. }
  1209. if ((sale_oplata == null)) {
  1210. this.Adapter.InsertCommand.Parameters[7].Value = global::System.DBNull.Value;
  1211. }
  1212. else {
  1213. this.Adapter.InsertCommand.Parameters[7].Value = ((string)(sale_oplata));
  1214. }
  1215. if ((sale_season == null)) {
  1216. this.Adapter.InsertCommand.Parameters[8].Value = global::System.DBNull.Value;
  1217. }
  1218. else {
  1219. this.Adapter.InsertCommand.Parameters[8].Value = ((string)(sale_season));
  1220. }
  1221. global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
  1222. if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
  1223. != global::System.Data.ConnectionState.Open)) {
  1224. this.Adapter.InsertCommand.Connection.Open();
  1225. }
  1226. try {
  1227. int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
  1228. return returnValue;
  1229. }
  1230. finally {
  1231. if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
  1232. this.Adapter.InsertCommand.Connection.Close();
  1233. }
  1234. }
  1235. }
  1236. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1237. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1238. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1239. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
  1240. public virtual int Update(
  1241. int nomer_kvitancii,
  1242. global::System.Nullable<global::System.DateTime> date_broni,
  1243. global::System.Nullable<global::System.DateTime> date_zaezda,
  1244. string nomer_mesta,
  1245. string kod_clients,
  1246. string chislo_days,
  1247. global::System.Nullable<global::System.DateTime> date_oplati,
  1248. string sale_oplata,
  1249. string sale_season,
  1250. int Original_nomer_kvitancii,
  1251. global::System.Nullable<global::System.DateTime> Original_date_broni,
  1252. global::System.Nullable<global::System.DateTime> Original_date_zaezda,
  1253. string Original_nomer_mesta,
  1254. string Original_kod_clients,
  1255. string Original_chislo_days,
  1256. global::System.Nullable<global::System.DateTime> Original_date_oplati,
  1257. string Original_sale_oplata,
  1258. string Original_sale_season) {
  1259. this.Adapter.UpdateCommand.Parameters[0].Value = ((int)(nomer_kvitancii));
  1260. if ((date_broni.HasValue == true)) {
  1261. this.Adapter.UpdateCommand.Parameters[1].Value = ((System.DateTime)(date_broni.Value));
  1262. }
  1263. else {
  1264. this.Adapter.UpdateCommand.Parameters[1].Value = global::System.DBNull.Value;
  1265. }
  1266. if ((date_zaezda.HasValue == true)) {
  1267. this.Adapter.UpdateCommand.Parameters[2].Value = ((System.DateTime)(date_zaezda.Value));
  1268. }
  1269. else {
  1270. this.Adapter.UpdateCommand.Parameters[2].Value = global::System.DBNull.Value;
  1271. }
  1272. if ((nomer_mesta == null)) {
  1273. this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
  1274. }
  1275. else {
  1276. this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(nomer_mesta));
  1277. }
  1278. if ((kod_clients == null)) {
  1279. this.Adapter.UpdateCommand.Parameters[4].Value = global::System.DBNull.Value;
  1280. }
  1281. else {
  1282. this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(kod_clients));
  1283. }
  1284. if ((chislo_days == null)) {
  1285. this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value;
  1286. }
  1287. else {
  1288. this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(chislo_days));
  1289. }
  1290. if ((date_oplati.HasValue == true)) {
  1291. this.Adapter.UpdateCommand.Parameters[6].Value = ((System.DateTime)(date_oplati.Value));
  1292. }
  1293. else {
  1294. this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value;
  1295. }
  1296. if ((sale_oplata == null)) {
  1297. this.Adapter.UpdateCommand.Parameters[7].Value = global::System.DBNull.Value;
  1298. }
  1299. else {
  1300. this.Adapter.UpdateCommand.Parameters[7].Value = ((string)(sale_oplata));
  1301. }
  1302. if ((sale_season == null)) {
  1303. this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value;
  1304. }
  1305. else {
  1306. this.Adapter.UpdateCommand.Parameters[8].Value = ((string)(sale_season));
  1307. }
  1308. this.Adapter.UpdateCommand.Parameters[9].Value = ((int)(Original_nomer_kvitancii));
  1309. if ((Original_date_broni.HasValue == true)) {
  1310. this.Adapter.UpdateCommand.Parameters[10].Value = ((object)(0));
  1311. this.Adapter.UpdateCommand.Parameters[11].Value = ((System.DateTime)(Original_date_broni.Value));
  1312. }
  1313. else {
  1314. this.Adapter.UpdateCommand.Parameters[10].Value = ((object)(1));
  1315. this.Adapter.UpdateCommand.Parameters[11].Value = global::System.DBNull.Value;
  1316. }
  1317. if ((Original_date_zaezda.HasValue == true)) {
  1318. this.Adapter.UpdateCommand.Parameters[12].Value = ((object)(0));
  1319. this.Adapter.UpdateCommand.Parameters[13].Value = ((System.DateTime)(Original_date_zaezda.Value));
  1320. }
  1321. else {
  1322. this.Adapter.UpdateCommand.Parameters[12].Value = ((object)(1));
  1323. this.Adapter.UpdateCommand.Parameters[13].Value = global::System.DBNull.Value;
  1324. }
  1325. if ((Original_nomer_mesta == null)) {
  1326. this.Adapter.UpdateCommand.Parameters[14].Value = ((object)(1));
  1327. this.Adapter.UpdateCommand.Parameters[15].Value = global::System.DBNull.Value;
  1328. }
  1329. else {
  1330. this.Adapter.UpdateCommand.Parameters[14].Value = ((object)(0));
  1331. this.Adapter.UpdateCommand.Parameters[15].Value = ((string)(Original_nomer_mesta));
  1332. }
  1333. if ((Original_kod_clients == null)) {
  1334. this.Adapter.UpdateCommand.Parameters[16].Value = ((object)(1));
  1335. this.Adapter.UpdateCommand.Parameters[17].Value = global::System.DBNull.Value;
  1336. }
  1337. else {
  1338. this.Adapter.UpdateCommand.Parameters[16].Value = ((object)(0));
  1339. this.Adapter.UpdateCommand.Parameters[17].Value = ((string)(Original_kod_clients));
  1340. }
  1341. if ((Original_chislo_days == null)) {
  1342. this.Adapter.UpdateCommand.Parameters[18].Value = ((object)(1));
  1343. this.Adapter.UpdateCommand.Parameters[19].Value = global::System.DBNull.Value;
  1344. }
  1345. else {
  1346. this.Adapter.UpdateCommand.Parameters[18].Value = ((object)(0));
  1347. this.Adapter.UpdateCommand.Parameters[19].Value = ((string)(Original_chislo_days));
  1348. }
  1349. if ((Original_date_oplati.HasValue == true)) {
  1350. this.Adapter.UpdateCommand.Parameters[20].Value = ((object)(0));
  1351. this.Adapter.UpdateCommand.Parameters[21].Value = ((System.DateTime)(Original_date_oplati.Value));
  1352. }
  1353. else {
  1354. this.Adapter.UpdateCommand.Parameters[20].Value = ((object)(1));
  1355. this.Adapter.UpdateCommand.Parameters[21].Value = global::System.DBNull.Value;
  1356. }
  1357. if ((Original_sale_oplata == null)) {
  1358. this.Adapter.UpdateCommand.Parameters[22].Value = ((object)(1));
  1359. this.Adapter.UpdateCommand.Parameters[23].Value = global::System.DBNull.Value;
  1360. }
  1361. else {
  1362. this.Adapter.UpdateCommand.Parameters[22].Value = ((object)(0));
  1363. this.Adapter.UpdateCommand.Parameters[23].Value = ((string)(Original_sale_oplata));
  1364. }
  1365. if ((Original_sale_season == null)) {
  1366. this.Adapter.UpdateCommand.Parameters[24].Value = ((object)(1));
  1367. this.Adapter.UpdateCommand.Parameters[25].Value = global::System.DBNull.Value;
  1368. }
  1369. else {
  1370. this.Adapter.UpdateCommand.Parameters[24].Value = ((object)(0));
  1371. this.Adapter.UpdateCommand.Parameters[25].Value = ((string)(Original_sale_season));
  1372. }
  1373. global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
  1374. if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
  1375. != global::System.Data.ConnectionState.Open)) {
  1376. this.Adapter.UpdateCommand.Connection.Open();
  1377. }
  1378. try {
  1379. int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
  1380. return returnValue;
  1381. }
  1382. finally {
  1383. if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
  1384. this.Adapter.UpdateCommand.Connection.Close();
  1385. }
  1386. }
  1387. }
  1388. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1389. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1390. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1391. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
  1392. public virtual int Update(
  1393. global::System.Nullable<global::System.DateTime> date_broni,
  1394. global::System.Nullable<global::System.DateTime> date_zaezda,
  1395. string nomer_mesta,
  1396. string kod_clients,
  1397. string chislo_days,
  1398. global::System.Nullable<global::System.DateTime> date_oplati,
  1399. string sale_oplata,
  1400. string sale_season,
  1401. int Original_nomer_kvitancii,
  1402. global::System.Nullable<global::System.DateTime> Original_date_broni,
  1403. global::System.Nullable<global::System.DateTime> Original_date_zaezda,
  1404. string Original_nomer_mesta,
  1405. string Original_kod_clients,
  1406. string Original_chislo_days,
  1407. global::System.Nullable<global::System.DateTime> Original_date_oplati,
  1408. string Original_sale_oplata,
  1409. string Original_sale_season) {
  1410. return this.Update(Original_nomer_kvitancii, date_broni, date_zaezda, nomer_mesta, kod_clients, chislo_days, date_oplati, sale_oplata, sale_season, Original_nomer_kvitancii, Original_date_broni, Original_date_zaezda, Original_nomer_mesta, Original_kod_clients, Original_chislo_days, Original_date_oplati, Original_sale_oplata, Original_sale_season);
  1411. }
  1412. }
  1413. /// <summary>
  1414. ///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
  1415. ///</summary>
  1416. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  1417. [global::System.ComponentModel.ToolboxItem(true)]
  1418. [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
  1419. "esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
  1420. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
  1421. public partial class TableAdapterManager : global::System.ComponentModel.Component {
  1422. private UpdateOrderOption _updateOrder;
  1423. private bronirovenieTableAdapter _bronirovenieTableAdapter;
  1424. private bool _backupDataSetBeforeUpdate;
  1425. private global::System.Data.IDbConnection _connection;
  1426. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1427. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1428. public UpdateOrderOption UpdateOrder {
  1429. get {
  1430. return this._updateOrder;
  1431. }
  1432. set {
  1433. this._updateOrder = value;
  1434. }
  1435. }
  1436. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1437. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1438. [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
  1439. "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
  1440. "a", "System.Drawing.Design.UITypeEditor")]
  1441. public bronirovenieTableAdapter bronirovenieTableAdapter {
  1442. get {
  1443. return this._bronirovenieTableAdapter;
  1444. }
  1445. set {
  1446. this._bronirovenieTableAdapter = value;
  1447. }
  1448. }
  1449. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1450. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1451. public bool BackupDataSetBeforeUpdate {
  1452. get {
  1453. return this._backupDataSetBeforeUpdate;
  1454. }
  1455. set {
  1456. this._backupDataSetBeforeUpdate = value;
  1457. }
  1458. }
  1459. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1460. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1461. [global::System.ComponentModel.Browsable(false)]
  1462. public global::System.Data.IDbConnection Connection {
  1463. get {
  1464. if ((this._connection != null)) {
  1465. return this._connection;
  1466. }
  1467. if (((this._bronirovenieTableAdapter != null)
  1468. && (this._bronirovenieTableAdapter.Connection != null))) {
  1469. return this._bronirovenieTableAdapter.Connection;
  1470. }
  1471. return null;
  1472. }
  1473. set {
  1474. this._connection = value;
  1475. }
  1476. }
  1477. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1478. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1479. [global::System.ComponentModel.Browsable(false)]
  1480. public int TableAdapterInstanceCount {
  1481. get {
  1482. int count = 0;
  1483. if ((this._bronirovenieTableAdapter != null)) {
  1484. count = (count + 1);
  1485. }
  1486. return count;
  1487. }
  1488. }
  1489. /// <summary>
  1490. ///Update rows in top-down order.
  1491. ///</summary>
  1492. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1493. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1494. private int UpdateUpdatedRows(konkursDataSet dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  1495. int result = 0;
  1496. if ((this._bronirovenieTableAdapter != null)) {
  1497. global::System.Data.DataRow[] updatedRows = dataSet.bronirovenie.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
  1498. updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
  1499. if (((updatedRows != null)
  1500. && (0 < updatedRows.Length))) {
  1501. result = (result + this._bronirovenieTableAdapter.Update(updatedRows));
  1502. allChangedRows.AddRange(updatedRows);
  1503. }
  1504. }
  1505. return result;
  1506. }
  1507. /// <summary>
  1508. ///Insert rows in top-down order.
  1509. ///</summary>
  1510. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1511. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1512. private int UpdateInsertedRows(konkursDataSet dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  1513. int result = 0;
  1514. if ((this._bronirovenieTableAdapter != null)) {
  1515. global::System.Data.DataRow[] addedRows = dataSet.bronirovenie.Select(null, null, global::System.Data.DataViewRowState.Added);
  1516. if (((addedRows != null)
  1517. && (0 < addedRows.Length))) {
  1518. result = (result + this._bronirovenieTableAdapter.Update(addedRows));
  1519. allAddedRows.AddRange(addedRows);
  1520. }
  1521. }
  1522. return result;
  1523. }
  1524. /// <summary>
  1525. ///Delete rows in bottom-up order.
  1526. ///</summary>
  1527. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1528. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1529. private int UpdateDeletedRows(konkursDataSet dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows) {
  1530. int result = 0;
  1531. if ((this._bronirovenieTableAdapter != null)) {
  1532. global::System.Data.DataRow[] deletedRows = dataSet.bronirovenie.Select(null, null, global::System.Data.DataViewRowState.Deleted);
  1533. if (((deletedRows != null)
  1534. && (0 < deletedRows.Length))) {
  1535. result = (result + this._bronirovenieTableAdapter.Update(deletedRows));
  1536. allChangedRows.AddRange(deletedRows);
  1537. }
  1538. }
  1539. return result;
  1540. }
  1541. /// <summary>
  1542. ///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
  1543. ///</summary>
  1544. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1545. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1546. private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  1547. if (((updatedRows == null)
  1548. || (updatedRows.Length < 1))) {
  1549. return updatedRows;
  1550. }
  1551. if (((allAddedRows == null)
  1552. || (allAddedRows.Count < 1))) {
  1553. return updatedRows;
  1554. }
  1555. global::System.Collections.Generic.List<global::System.Data.DataRow> realUpdatedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  1556. for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
  1557. global::System.Data.DataRow row = updatedRows[i];
  1558. if ((allAddedRows.Contains(row) == false)) {
  1559. realUpdatedRows.Add(row);
  1560. }
  1561. }
  1562. return realUpdatedRows.ToArray();
  1563. }
  1564. /// <summary>
  1565. ///Update all changes to the dataset.
  1566. ///</summary>
  1567. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1568. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1569. public virtual int UpdateAll(konkursDataSet dataSet) {
  1570. if ((dataSet == null)) {
  1571. throw new global::System.ArgumentNullException("dataSet");
  1572. }
  1573. if ((dataSet.HasChanges() == false)) {
  1574. return 0;
  1575. }
  1576. if (((this._bronirovenieTableAdapter != null)
  1577. && (this.MatchTableAdapterConnection(this._bronirovenieTableAdapter.Connection) == false))) {
  1578. throw new global::System.ArgumentException("Все адаптеры таблицы, управляемые диспетчером адаптера таблицы TableAdapterManage" +
  1579. "r, должны использовать одинаковую строку подключения.");
  1580. }
  1581. global::System.Data.IDbConnection workConnection = this.Connection;
  1582. if ((workConnection == null)) {
  1583. throw new global::System.ApplicationException("TableAdapterManager не содержит сведений о подключении. Укажите для каждого адапт" +
  1584. "ера таблицы TableAdapterManager допустимый экземпляр адаптера таблицы.");
  1585. }
  1586. bool workConnOpened = false;
  1587. if (((workConnection.State & global::System.Data.ConnectionState.Broken)
  1588. == global::System.Data.ConnectionState.Broken)) {
  1589. workConnection.Close();
  1590. }
  1591. if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
  1592. workConnection.Open();
  1593. workConnOpened = true;
  1594. }
  1595. global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
  1596. if ((workTransaction == null)) {
  1597. throw new global::System.ApplicationException("Не удается начать транзакцию. Текущее соединение данных не поддерживает транзакци" +
  1598. "и или текущее состояние не позволяет начать транзакцию.");
  1599. }
  1600. global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  1601. global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  1602. global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter> adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter>();
  1603. global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection> revertConnections = new global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection>();
  1604. int result = 0;
  1605. global::System.Data.DataSet backupDataSet = null;
  1606. if (this.BackupDataSetBeforeUpdate) {
  1607. backupDataSet = new global::System.Data.DataSet();
  1608. backupDataSet.Merge(dataSet);
  1609. }
  1610. try {
  1611. // ---- Prepare for update -----------
  1612. //
  1613. if ((this._bronirovenieTableAdapter != null)) {
  1614. revertConnections.Add(this._bronirovenieTableAdapter, this._bronirovenieTableAdapter.Connection);
  1615. this._bronirovenieTableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(workConnection));
  1616. this._bronirovenieTableAdapter.Transaction = ((global::System.Data.SqlClient.SqlTransaction)(workTransaction));
  1617. if (this._bronirovenieTableAdapter.Adapter.AcceptChangesDuringUpdate) {
  1618. this._bronirovenieTableAdapter.Adapter.AcceptChangesDuringUpdate = false;
  1619. adaptersWithAcceptChangesDuringUpdate.Add(this._bronirovenieTableAdapter.Adapter);
  1620. }
  1621. }
  1622. //
  1623. //---- Perform updates -----------
  1624. //
  1625. if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) {
  1626. result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
  1627. result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
  1628. }
  1629. else {
  1630. result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
  1631. result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
  1632. }
  1633. result = (result + this.UpdateDeletedRows(dataSet, allChangedRows));
  1634. //
  1635. //---- Commit updates -----------
  1636. //
  1637. workTransaction.Commit();
  1638. if ((0 < allAddedRows.Count)) {
  1639. global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
  1640. allAddedRows.CopyTo(rows);
  1641. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  1642. global::System.Data.DataRow row = rows[i];
  1643. row.AcceptChanges();
  1644. }
  1645. }
  1646. if ((0 < allChangedRows.Count)) {
  1647. global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count];
  1648. allChangedRows.CopyTo(rows);
  1649. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  1650. global::System.Data.DataRow row = rows[i];
  1651. row.AcceptChanges();
  1652. }
  1653. }
  1654. }
  1655. catch (global::System.Exception ex) {
  1656. workTransaction.Rollback();
  1657. // ---- Restore the dataset -----------
  1658. if (this.BackupDataSetBeforeUpdate) {
  1659. global::System.Diagnostics.Debug.Assert((backupDataSet != null));
  1660. dataSet.Clear();
  1661. dataSet.Merge(backupDataSet);
  1662. }
  1663. else {
  1664. if ((0 < allAddedRows.Count)) {
  1665. global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
  1666. allAddedRows.CopyTo(rows);
  1667. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  1668. global::System.Data.DataRow row = rows[i];
  1669. row.AcceptChanges();
  1670. row.SetAdded();
  1671. }
  1672. }
  1673. }
  1674. throw ex;
  1675. }
  1676. finally {
  1677. if (workConnOpened) {
  1678. workConnection.Close();
  1679. }
  1680. if ((this._bronirovenieTableAdapter != null)) {
  1681. this._bronirovenieTableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(revertConnections[this._bronirovenieTableAdapter]));
  1682. this._bronirovenieTableAdapter.Transaction = null;
  1683. }
  1684. if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) {
  1685. global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count];
  1686. adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters);
  1687. for (int i = 0; (i < adapters.Length); i = (i + 1)) {
  1688. global::System.Data.Common.DataAdapter adapter = adapters[i];
  1689. adapter.AcceptChangesDuringUpdate = true;
  1690. }
  1691. }
  1692. }
  1693. return result;
  1694. }
  1695. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1696. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1697. protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) {
  1698. global::System.Array.Sort<global::System.Data.DataRow>(rows, new SelfReferenceComparer(relation, childFirst));
  1699. }
  1700. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1701. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1702. protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) {
  1703. if ((this._connection != null)) {
  1704. return true;
  1705. }
  1706. if (((this.Connection == null)
  1707. || (inputConnection == null))) {
  1708. return true;
  1709. }
  1710. if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) {
  1711. return true;
  1712. }
  1713. return false;
  1714. }
  1715. /// <summary>
  1716. ///Update Order Option
  1717. ///</summary>
  1718. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1719. public enum UpdateOrderOption {
  1720. InsertUpdateDelete = 0,
  1721. UpdateInsertDelete = 1,
  1722. }
  1723. /// <summary>
  1724. ///Used to sort self-referenced table's rows
  1725. ///</summary>
  1726. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1727. private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer<global::System.Data.DataRow> {
  1728. private global::System.Data.DataRelation _relation;
  1729. private int _childFirst;
  1730. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1731. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1732. internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) {
  1733. this._relation = relation;
  1734. if (childFirst) {
  1735. this._childFirst = -1;
  1736. }
  1737. else {
  1738. this._childFirst = 1;
  1739. }
  1740. }
  1741. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1742. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1743. private global::System.Data.DataRow GetRoot(global::System.Data.DataRow row, out int distance) {
  1744. global::System.Diagnostics.Debug.Assert((row != null));
  1745. global::System.Data.DataRow root = row;
  1746. distance = 0;
  1747. 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>();
  1748. traversedRows[row] = row;
  1749. global::System.Data.DataRow parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
  1750. for (
  1751. ; ((parent != null)
  1752. && (traversedRows.ContainsKey(parent) == false));
  1753. ) {
  1754. distance = (distance + 1);
  1755. root = parent;
  1756. traversedRows[parent] = parent;
  1757. parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
  1758. }
  1759. if ((distance == 0)) {
  1760. traversedRows.Clear();
  1761. traversedRows[row] = row;
  1762. parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
  1763. for (
  1764. ; ((parent != null)
  1765. && (traversedRows.ContainsKey(parent) == false));
  1766. ) {
  1767. distance = (distance + 1);
  1768. root = parent;
  1769. traversedRows[parent] = parent;
  1770. parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
  1771. }
  1772. }
  1773. return root;
  1774. }
  1775. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1776. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1777. public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) {
  1778. if (object.ReferenceEquals(row1, row2)) {
  1779. return 0;
  1780. }
  1781. if ((row1 == null)) {
  1782. return -1;
  1783. }
  1784. if ((row2 == null)) {
  1785. return 1;
  1786. }
  1787. int distance1 = 0;
  1788. global::System.Data.DataRow root1 = this.GetRoot(row1, out distance1);
  1789. int distance2 = 0;
  1790. global::System.Data.DataRow root2 = this.GetRoot(row2, out distance2);
  1791. if (object.ReferenceEquals(root1, root2)) {
  1792. return (this._childFirst * distance1.CompareTo(distance2));
  1793. }
  1794. else {
  1795. global::System.Diagnostics.Debug.Assert(((root1.Table != null)
  1796. && (root2.Table != null)));
  1797. if ((root1.Table.Rows.IndexOf(root1) < root2.Table.Rows.IndexOf(root2))) {
  1798. return -1;
  1799. }
  1800. else {
  1801. return 1;
  1802. }
  1803. }
  1804. }
  1805. }
  1806. }
  1807. }
  1808. #pragma warning restore 1591