123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971 |
- //------------------------------------------------------------------------------
- // <auto-generated>
- // Этот код создан программой.
- // Исполняемая версия:4.0.30319.42000
- //
- // Изменения в этом файле могут привести к неправильной работе и будут потеряны в случае
- // повторной генерации кода.
- // </auto-generated>
- //------------------------------------------------------------------------------
- #pragma warning disable 1591
- namespace konkurs {
-
-
- /// <summary>
- ///Represents a strongly typed in-memory cache of data.
- ///</summary>
- [global::System.Serializable()]
- [global::System.ComponentModel.DesignerCategoryAttribute("code")]
- [global::System.ComponentModel.ToolboxItem(true)]
- [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")]
- [global::System.Xml.Serialization.XmlRootAttribute("konkursDataSet")]
- [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
- public partial class konkursDataSet : global::System.Data.DataSet {
-
- private bronirovenieDataTable tablebronirovenie;
-
- private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public konkursDataSet() {
- this.BeginInit();
- this.InitClass();
- global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
- base.Tables.CollectionChanged += schemaChangedHandler;
- base.Relations.CollectionChanged += schemaChangedHandler;
- this.EndInit();
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected konkursDataSet(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
- base(info, context, false) {
- if ((this.IsBinarySerialized(info, context) == true)) {
- this.InitVars(false);
- global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
- this.Tables.CollectionChanged += schemaChangedHandler1;
- this.Relations.CollectionChanged += schemaChangedHandler1;
- return;
- }
- string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
- if ((this.DetermineSchemaSerializationMode(info, context) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
- global::System.Data.DataSet ds = new global::System.Data.DataSet();
- ds.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
- if ((ds.Tables["bronirovenie"] != null)) {
- base.Tables.Add(new bronirovenieDataTable(ds.Tables["bronirovenie"]));
- }
- this.DataSetName = ds.DataSetName;
- this.Prefix = ds.Prefix;
- this.Namespace = ds.Namespace;
- this.Locale = ds.Locale;
- this.CaseSensitive = ds.CaseSensitive;
- this.EnforceConstraints = ds.EnforceConstraints;
- this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
- this.InitVars();
- }
- else {
- this.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
- }
- this.GetSerializationData(info, context);
- global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
- base.Tables.CollectionChanged += schemaChangedHandler;
- this.Relations.CollectionChanged += schemaChangedHandler;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.Browsable(false)]
- [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
- public bronirovenieDataTable bronirovenie {
- get {
- return this.tablebronirovenie;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.BrowsableAttribute(true)]
- [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Visible)]
- public override global::System.Data.SchemaSerializationMode SchemaSerializationMode {
- get {
- return this._schemaSerializationMode;
- }
- set {
- this._schemaSerializationMode = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
- public new global::System.Data.DataTableCollection Tables {
- get {
- return base.Tables;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
- public new global::System.Data.DataRelationCollection Relations {
- get {
- return base.Relations;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected override void InitializeDerivedDataSet() {
- this.BeginInit();
- this.InitClass();
- this.EndInit();
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public override global::System.Data.DataSet Clone() {
- konkursDataSet cln = ((konkursDataSet)(base.Clone()));
- cln.InitVars();
- cln.SchemaSerializationMode = this.SchemaSerializationMode;
- return cln;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected override bool ShouldSerializeTables() {
- return false;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected override bool ShouldSerializeRelations() {
- return false;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected override void ReadXmlSerializable(global::System.Xml.XmlReader reader) {
- if ((this.DetermineSchemaSerializationMode(reader) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
- this.Reset();
- global::System.Data.DataSet ds = new global::System.Data.DataSet();
- ds.ReadXml(reader);
- if ((ds.Tables["bronirovenie"] != null)) {
- base.Tables.Add(new bronirovenieDataTable(ds.Tables["bronirovenie"]));
- }
- this.DataSetName = ds.DataSetName;
- this.Prefix = ds.Prefix;
- this.Namespace = ds.Namespace;
- this.Locale = ds.Locale;
- this.CaseSensitive = ds.CaseSensitive;
- this.EnforceConstraints = ds.EnforceConstraints;
- this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
- this.InitVars();
- }
- else {
- this.ReadXml(reader);
- this.InitVars();
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected override global::System.Xml.Schema.XmlSchema GetSchemaSerializable() {
- global::System.IO.MemoryStream stream = new global::System.IO.MemoryStream();
- this.WriteXmlSchema(new global::System.Xml.XmlTextWriter(stream, null));
- stream.Position = 0;
- return global::System.Xml.Schema.XmlSchema.Read(new global::System.Xml.XmlTextReader(stream), null);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- internal void InitVars() {
- this.InitVars(true);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- internal void InitVars(bool initTable) {
- this.tablebronirovenie = ((bronirovenieDataTable)(base.Tables["bronirovenie"]));
- if ((initTable == true)) {
- if ((this.tablebronirovenie != null)) {
- this.tablebronirovenie.InitVars();
- }
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- private void InitClass() {
- this.DataSetName = "konkursDataSet";
- this.Prefix = "";
- this.Namespace = "http://tempuri.org/konkursDataSet.xsd";
- this.EnforceConstraints = true;
- this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
- this.tablebronirovenie = new bronirovenieDataTable();
- base.Tables.Add(this.tablebronirovenie);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- private bool ShouldSerializebronirovenie() {
- return false;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- private void SchemaChanged(object sender, global::System.ComponentModel.CollectionChangeEventArgs e) {
- if ((e.Action == global::System.ComponentModel.CollectionChangeAction.Remove)) {
- this.InitVars();
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
- konkursDataSet ds = new konkursDataSet();
- global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
- global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
- global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
- any.Namespace = ds.Namespace;
- sequence.Items.Add(any);
- type.Particle = sequence;
- global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
- if (xs.Contains(dsSchema.TargetNamespace)) {
- global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
- global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
- try {
- global::System.Xml.Schema.XmlSchema schema = null;
- dsSchema.Write(s1);
- for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
- schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
- s2.SetLength(0);
- schema.Write(s2);
- if ((s1.Length == s2.Length)) {
- s1.Position = 0;
- s2.Position = 0;
- for (; ((s1.Position != s1.Length)
- && (s1.ReadByte() == s2.ReadByte())); ) {
- ;
- }
- if ((s1.Position == s1.Length)) {
- return type;
- }
- }
- }
- }
- finally {
- if ((s1 != null)) {
- s1.Close();
- }
- if ((s2 != null)) {
- s2.Close();
- }
- }
- }
- xs.Add(dsSchema);
- return type;
- }
-
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public delegate void bronirovenieRowChangeEventHandler(object sender, bronirovenieRowChangeEvent e);
-
- /// <summary>
- ///Represents the strongly named DataTable class.
- ///</summary>
- [global::System.Serializable()]
- [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
- public partial class bronirovenieDataTable : global::System.Data.TypedTableBase<bronirovenieRow> {
-
- private global::System.Data.DataColumn columnnomer_kvitancii;
-
- private global::System.Data.DataColumn columndate_broni;
-
- private global::System.Data.DataColumn columndate_zaezda;
-
- private global::System.Data.DataColumn columnnomer_mesta;
-
- private global::System.Data.DataColumn columnkod_clients;
-
- private global::System.Data.DataColumn columnchislo_days;
-
- private global::System.Data.DataColumn columndate_oplati;
-
- private global::System.Data.DataColumn columnsale_oplata;
-
- private global::System.Data.DataColumn columnsale_season;
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bronirovenieDataTable() {
- this.TableName = "bronirovenie";
- this.BeginInit();
- this.InitClass();
- this.EndInit();
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- internal bronirovenieDataTable(global::System.Data.DataTable table) {
- this.TableName = table.TableName;
- if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
- this.CaseSensitive = table.CaseSensitive;
- }
- if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
- this.Locale = table.Locale;
- }
- if ((table.Namespace != table.DataSet.Namespace)) {
- this.Namespace = table.Namespace;
- }
- this.Prefix = table.Prefix;
- this.MinimumCapacity = table.MinimumCapacity;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected bronirovenieDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
- base(info, context) {
- this.InitVars();
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public global::System.Data.DataColumn nomer_kvitanciiColumn {
- get {
- return this.columnnomer_kvitancii;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public global::System.Data.DataColumn date_broniColumn {
- get {
- return this.columndate_broni;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public global::System.Data.DataColumn date_zaezdaColumn {
- get {
- return this.columndate_zaezda;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public global::System.Data.DataColumn nomer_mestaColumn {
- get {
- return this.columnnomer_mesta;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public global::System.Data.DataColumn kod_clientsColumn {
- get {
- return this.columnkod_clients;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public global::System.Data.DataColumn chislo_daysColumn {
- get {
- return this.columnchislo_days;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public global::System.Data.DataColumn date_oplatiColumn {
- get {
- return this.columndate_oplati;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public global::System.Data.DataColumn sale_oplataColumn {
- get {
- return this.columnsale_oplata;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public global::System.Data.DataColumn sale_seasonColumn {
- get {
- return this.columnsale_season;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.Browsable(false)]
- public int Count {
- get {
- return this.Rows.Count;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bronirovenieRow this[int index] {
- get {
- return ((bronirovenieRow)(this.Rows[index]));
- }
- }
-
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public event bronirovenieRowChangeEventHandler bronirovenieRowChanging;
-
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public event bronirovenieRowChangeEventHandler bronirovenieRowChanged;
-
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public event bronirovenieRowChangeEventHandler bronirovenieRowDeleting;
-
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public event bronirovenieRowChangeEventHandler bronirovenieRowDeleted;
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public void AddbronirovenieRow(bronirovenieRow row) {
- this.Rows.Add(row);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- 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) {
- bronirovenieRow rowbronirovenieRow = ((bronirovenieRow)(this.NewRow()));
- object[] columnValuesArray = new object[] {
- nomer_kvitancii,
- date_broni,
- date_zaezda,
- nomer_mesta,
- kod_clients,
- chislo_days,
- date_oplati,
- sale_oplata,
- sale_season};
- rowbronirovenieRow.ItemArray = columnValuesArray;
- this.Rows.Add(rowbronirovenieRow);
- return rowbronirovenieRow;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bronirovenieRow FindBynomer_kvitancii(int nomer_kvitancii) {
- return ((bronirovenieRow)(this.Rows.Find(new object[] {
- nomer_kvitancii})));
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public override global::System.Data.DataTable Clone() {
- bronirovenieDataTable cln = ((bronirovenieDataTable)(base.Clone()));
- cln.InitVars();
- return cln;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected override global::System.Data.DataTable CreateInstance() {
- return new bronirovenieDataTable();
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- internal void InitVars() {
- this.columnnomer_kvitancii = base.Columns["nomer_kvitancii"];
- this.columndate_broni = base.Columns["date_broni"];
- this.columndate_zaezda = base.Columns["date_zaezda"];
- this.columnnomer_mesta = base.Columns["nomer_mesta"];
- this.columnkod_clients = base.Columns["kod_clients"];
- this.columnchislo_days = base.Columns["chislo_days"];
- this.columndate_oplati = base.Columns["date_oplati"];
- this.columnsale_oplata = base.Columns["sale_oplata"];
- this.columnsale_season = base.Columns["sale_season"];
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- private void InitClass() {
- this.columnnomer_kvitancii = new global::System.Data.DataColumn("nomer_kvitancii", typeof(int), null, global::System.Data.MappingType.Element);
- base.Columns.Add(this.columnnomer_kvitancii);
- this.columndate_broni = new global::System.Data.DataColumn("date_broni", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
- base.Columns.Add(this.columndate_broni);
- this.columndate_zaezda = new global::System.Data.DataColumn("date_zaezda", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
- base.Columns.Add(this.columndate_zaezda);
- this.columnnomer_mesta = new global::System.Data.DataColumn("nomer_mesta", typeof(string), null, global::System.Data.MappingType.Element);
- base.Columns.Add(this.columnnomer_mesta);
- this.columnkod_clients = new global::System.Data.DataColumn("kod_clients", typeof(string), null, global::System.Data.MappingType.Element);
- base.Columns.Add(this.columnkod_clients);
- this.columnchislo_days = new global::System.Data.DataColumn("chislo_days", typeof(string), null, global::System.Data.MappingType.Element);
- base.Columns.Add(this.columnchislo_days);
- this.columndate_oplati = new global::System.Data.DataColumn("date_oplati", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
- base.Columns.Add(this.columndate_oplati);
- this.columnsale_oplata = new global::System.Data.DataColumn("sale_oplata", typeof(string), null, global::System.Data.MappingType.Element);
- base.Columns.Add(this.columnsale_oplata);
- this.columnsale_season = new global::System.Data.DataColumn("sale_season", typeof(string), null, global::System.Data.MappingType.Element);
- base.Columns.Add(this.columnsale_season);
- this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
- this.columnnomer_kvitancii}, true));
- this.columnnomer_kvitancii.AllowDBNull = false;
- this.columnnomer_kvitancii.Unique = true;
- this.columnnomer_mesta.MaxLength = 10;
- this.columnkod_clients.MaxLength = 10;
- this.columnchislo_days.MaxLength = 10;
- this.columnsale_oplata.MaxLength = 10;
- this.columnsale_season.MaxLength = 10;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bronirovenieRow NewbronirovenieRow() {
- return ((bronirovenieRow)(this.NewRow()));
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
- return new bronirovenieRow(builder);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected override global::System.Type GetRowType() {
- return typeof(bronirovenieRow);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
- base.OnRowChanged(e);
- if ((this.bronirovenieRowChanged != null)) {
- this.bronirovenieRowChanged(this, new bronirovenieRowChangeEvent(((bronirovenieRow)(e.Row)), e.Action));
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
- base.OnRowChanging(e);
- if ((this.bronirovenieRowChanging != null)) {
- this.bronirovenieRowChanging(this, new bronirovenieRowChangeEvent(((bronirovenieRow)(e.Row)), e.Action));
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
- base.OnRowDeleted(e);
- if ((this.bronirovenieRowDeleted != null)) {
- this.bronirovenieRowDeleted(this, new bronirovenieRowChangeEvent(((bronirovenieRow)(e.Row)), e.Action));
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
- base.OnRowDeleting(e);
- if ((this.bronirovenieRowDeleting != null)) {
- this.bronirovenieRowDeleting(this, new bronirovenieRowChangeEvent(((bronirovenieRow)(e.Row)), e.Action));
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public void RemovebronirovenieRow(bronirovenieRow row) {
- this.Rows.Remove(row);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
- global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
- global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
- konkursDataSet ds = new konkursDataSet();
- global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
- any1.Namespace = "http://www.w3.org/2001/XMLSchema";
- any1.MinOccurs = new decimal(0);
- any1.MaxOccurs = decimal.MaxValue;
- any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
- sequence.Items.Add(any1);
- global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
- any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
- any2.MinOccurs = new decimal(1);
- any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
- sequence.Items.Add(any2);
- global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
- attribute1.Name = "namespace";
- attribute1.FixedValue = ds.Namespace;
- type.Attributes.Add(attribute1);
- global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
- attribute2.Name = "tableTypeName";
- attribute2.FixedValue = "bronirovenieDataTable";
- type.Attributes.Add(attribute2);
- type.Particle = sequence;
- global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
- if (xs.Contains(dsSchema.TargetNamespace)) {
- global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
- global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
- try {
- global::System.Xml.Schema.XmlSchema schema = null;
- dsSchema.Write(s1);
- for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
- schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
- s2.SetLength(0);
- schema.Write(s2);
- if ((s1.Length == s2.Length)) {
- s1.Position = 0;
- s2.Position = 0;
- for (; ((s1.Position != s1.Length)
- && (s1.ReadByte() == s2.ReadByte())); ) {
- ;
- }
- if ((s1.Position == s1.Length)) {
- return type;
- }
- }
- }
- }
- finally {
- if ((s1 != null)) {
- s1.Close();
- }
- if ((s2 != null)) {
- s2.Close();
- }
- }
- }
- xs.Add(dsSchema);
- return type;
- }
- }
-
- /// <summary>
- ///Represents strongly named DataRow class.
- ///</summary>
- public partial class bronirovenieRow : global::System.Data.DataRow {
-
- private bronirovenieDataTable tablebronirovenie;
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- internal bronirovenieRow(global::System.Data.DataRowBuilder rb) :
- base(rb) {
- this.tablebronirovenie = ((bronirovenieDataTable)(this.Table));
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public int nomer_kvitancii {
- get {
- return ((int)(this[this.tablebronirovenie.nomer_kvitanciiColumn]));
- }
- set {
- this[this.tablebronirovenie.nomer_kvitanciiColumn] = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public System.DateTime date_broni {
- get {
- try {
- return ((global::System.DateTime)(this[this.tablebronirovenie.date_broniColumn]));
- }
- catch (global::System.InvalidCastException e) {
- throw new global::System.Data.StrongTypingException("Значение для столбца \'date_broni\' в таблице \'bronirovenie\' равно DBNull.", e);
- }
- }
- set {
- this[this.tablebronirovenie.date_broniColumn] = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public System.DateTime date_zaezda {
- get {
- try {
- return ((global::System.DateTime)(this[this.tablebronirovenie.date_zaezdaColumn]));
- }
- catch (global::System.InvalidCastException e) {
- throw new global::System.Data.StrongTypingException("Значение для столбца \'date_zaezda\' в таблице \'bronirovenie\' равно DBNull.", e);
- }
- }
- set {
- this[this.tablebronirovenie.date_zaezdaColumn] = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public string nomer_mesta {
- get {
- try {
- return ((string)(this[this.tablebronirovenie.nomer_mestaColumn]));
- }
- catch (global::System.InvalidCastException e) {
- throw new global::System.Data.StrongTypingException("Значение для столбца \'nomer_mesta\' в таблице \'bronirovenie\' равно DBNull.", e);
- }
- }
- set {
- this[this.tablebronirovenie.nomer_mestaColumn] = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public string kod_clients {
- get {
- try {
- return ((string)(this[this.tablebronirovenie.kod_clientsColumn]));
- }
- catch (global::System.InvalidCastException e) {
- throw new global::System.Data.StrongTypingException("Значение для столбца \'kod_clients\' в таблице \'bronirovenie\' равно DBNull.", e);
- }
- }
- set {
- this[this.tablebronirovenie.kod_clientsColumn] = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public string chislo_days {
- get {
- try {
- return ((string)(this[this.tablebronirovenie.chislo_daysColumn]));
- }
- catch (global::System.InvalidCastException e) {
- throw new global::System.Data.StrongTypingException("Значение для столбца \'chislo_days\' в таблице \'bronirovenie\' равно DBNull.", e);
- }
- }
- set {
- this[this.tablebronirovenie.chislo_daysColumn] = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public System.DateTime date_oplati {
- get {
- try {
- return ((global::System.DateTime)(this[this.tablebronirovenie.date_oplatiColumn]));
- }
- catch (global::System.InvalidCastException e) {
- throw new global::System.Data.StrongTypingException("Значение для столбца \'date_oplati\' в таблице \'bronirovenie\' равно DBNull.", e);
- }
- }
- set {
- this[this.tablebronirovenie.date_oplatiColumn] = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public string sale_oplata {
- get {
- try {
- return ((string)(this[this.tablebronirovenie.sale_oplataColumn]));
- }
- catch (global::System.InvalidCastException e) {
- throw new global::System.Data.StrongTypingException("Значение для столбца \'sale_oplata\' в таблице \'bronirovenie\' равно DBNull.", e);
- }
- }
- set {
- this[this.tablebronirovenie.sale_oplataColumn] = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public string sale_season {
- get {
- try {
- return ((string)(this[this.tablebronirovenie.sale_seasonColumn]));
- }
- catch (global::System.InvalidCastException e) {
- throw new global::System.Data.StrongTypingException("Значение для столбца \'sale_season\' в таблице \'bronirovenie\' равно DBNull.", e);
- }
- }
- set {
- this[this.tablebronirovenie.sale_seasonColumn] = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bool Isdate_broniNull() {
- return this.IsNull(this.tablebronirovenie.date_broniColumn);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public void Setdate_broniNull() {
- this[this.tablebronirovenie.date_broniColumn] = global::System.Convert.DBNull;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bool Isdate_zaezdaNull() {
- return this.IsNull(this.tablebronirovenie.date_zaezdaColumn);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public void Setdate_zaezdaNull() {
- this[this.tablebronirovenie.date_zaezdaColumn] = global::System.Convert.DBNull;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bool Isnomer_mestaNull() {
- return this.IsNull(this.tablebronirovenie.nomer_mestaColumn);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public void Setnomer_mestaNull() {
- this[this.tablebronirovenie.nomer_mestaColumn] = global::System.Convert.DBNull;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bool Iskod_clientsNull() {
- return this.IsNull(this.tablebronirovenie.kod_clientsColumn);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public void Setkod_clientsNull() {
- this[this.tablebronirovenie.kod_clientsColumn] = global::System.Convert.DBNull;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bool Ischislo_daysNull() {
- return this.IsNull(this.tablebronirovenie.chislo_daysColumn);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public void Setchislo_daysNull() {
- this[this.tablebronirovenie.chislo_daysColumn] = global::System.Convert.DBNull;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bool Isdate_oplatiNull() {
- return this.IsNull(this.tablebronirovenie.date_oplatiColumn);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public void Setdate_oplatiNull() {
- this[this.tablebronirovenie.date_oplatiColumn] = global::System.Convert.DBNull;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bool Issale_oplataNull() {
- return this.IsNull(this.tablebronirovenie.sale_oplataColumn);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public void Setsale_oplataNull() {
- this[this.tablebronirovenie.sale_oplataColumn] = global::System.Convert.DBNull;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bool Issale_seasonNull() {
- return this.IsNull(this.tablebronirovenie.sale_seasonColumn);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public void Setsale_seasonNull() {
- this[this.tablebronirovenie.sale_seasonColumn] = global::System.Convert.DBNull;
- }
- }
-
- /// <summary>
- ///Row event argument class
- ///</summary>
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public class bronirovenieRowChangeEvent : global::System.EventArgs {
-
- private bronirovenieRow eventRow;
-
- private global::System.Data.DataRowAction eventAction;
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bronirovenieRowChangeEvent(bronirovenieRow row, global::System.Data.DataRowAction action) {
- this.eventRow = row;
- this.eventAction = action;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bronirovenieRow Row {
- get {
- return this.eventRow;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public global::System.Data.DataRowAction Action {
- get {
- return this.eventAction;
- }
- }
- }
- }
- }
- namespace konkurs.konkursDataSetTableAdapters {
-
-
- /// <summary>
- ///Represents the connection and commands used to retrieve and save data.
- ///</summary>
- [global::System.ComponentModel.DesignerCategoryAttribute("code")]
- [global::System.ComponentModel.ToolboxItem(true)]
- [global::System.ComponentModel.DataObjectAttribute(true)]
- [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
- ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
- [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
- public partial class bronirovenieTableAdapter : global::System.ComponentModel.Component {
-
- private global::System.Data.SqlClient.SqlDataAdapter _adapter;
-
- private global::System.Data.SqlClient.SqlConnection _connection;
-
- private global::System.Data.SqlClient.SqlTransaction _transaction;
-
- private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
-
- private bool _clearBeforeFill;
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bronirovenieTableAdapter() {
- this.ClearBeforeFill = true;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
- get {
- if ((this._adapter == null)) {
- this.InitAdapter();
- }
- return this._adapter;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- internal global::System.Data.SqlClient.SqlConnection Connection {
- get {
- if ((this._connection == null)) {
- this.InitConnection();
- }
- return this._connection;
- }
- set {
- this._connection = value;
- if ((this.Adapter.InsertCommand != null)) {
- this.Adapter.InsertCommand.Connection = value;
- }
- if ((this.Adapter.DeleteCommand != null)) {
- this.Adapter.DeleteCommand.Connection = value;
- }
- if ((this.Adapter.UpdateCommand != null)) {
- this.Adapter.UpdateCommand.Connection = value;
- }
- for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
- if ((this.CommandCollection[i] != null)) {
- ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
- }
- }
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- internal global::System.Data.SqlClient.SqlTransaction Transaction {
- get {
- return this._transaction;
- }
- set {
- this._transaction = value;
- for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
- this.CommandCollection[i].Transaction = this._transaction;
- }
- if (((this.Adapter != null)
- && (this.Adapter.DeleteCommand != null))) {
- this.Adapter.DeleteCommand.Transaction = this._transaction;
- }
- if (((this.Adapter != null)
- && (this.Adapter.InsertCommand != null))) {
- this.Adapter.InsertCommand.Transaction = this._transaction;
- }
- if (((this.Adapter != null)
- && (this.Adapter.UpdateCommand != null))) {
- this.Adapter.UpdateCommand.Transaction = this._transaction;
- }
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
- get {
- if ((this._commandCollection == null)) {
- this.InitCommandCollection();
- }
- return this._commandCollection;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bool ClearBeforeFill {
- get {
- return this._clearBeforeFill;
- }
- set {
- this._clearBeforeFill = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- private void InitAdapter() {
- this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
- global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
- tableMapping.SourceTable = "Table";
- tableMapping.DataSetTable = "bronirovenie";
- tableMapping.ColumnMappings.Add("nomer_kvitancii", "nomer_kvitancii");
- tableMapping.ColumnMappings.Add("date_broni", "date_broni");
- tableMapping.ColumnMappings.Add("date_zaezda", "date_zaezda");
- tableMapping.ColumnMappings.Add("nomer_mesta", "nomer_mesta");
- tableMapping.ColumnMappings.Add("kod_clients", "kod_clients");
- tableMapping.ColumnMappings.Add("chislo_days", "chislo_days");
- tableMapping.ColumnMappings.Add("date_oplati", "date_oplati");
- tableMapping.ColumnMappings.Add("sale_oplata", "sale_oplata");
- tableMapping.ColumnMappings.Add("sale_season", "sale_season");
- this._adapter.TableMappings.Add(tableMapping);
- this._adapter.DeleteCommand = new global::System.Data.SqlClient.SqlCommand();
- this._adapter.DeleteCommand.Connection = this.Connection;
- 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)))";
- this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
- this._adapter.InsertCommand.Connection = this.Connection;
- 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);
- 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)";
- this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- this._adapter.UpdateCommand = new global::System.Data.SqlClient.SqlCommand();
- this._adapter.UpdateCommand.Connection = this.Connection;
- 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)));
- 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)";
- this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- 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, "", "", ""));
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- private void InitConnection() {
- this._connection = new global::System.Data.SqlClient.SqlConnection();
- this._connection.ConnectionString = global::konkurs.Properties.Settings.Default.konkursConnectionString;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- private void InitCommandCollection() {
- this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
- this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
- this._commandCollection[0].Connection = this.Connection;
- this._commandCollection[0].CommandText = "SELECT nomer_kvitancii, date_broni, date_zaezda, nomer_mesta, kod_clients, chislo" +
- "_days, date_oplati, sale_oplata, sale_season FROM dbo.bronirovenie";
- this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
- [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
- public virtual int Fill(konkursDataSet.bronirovenieDataTable dataTable) {
- this.Adapter.SelectCommand = this.CommandCollection[0];
- if ((this.ClearBeforeFill == true)) {
- dataTable.Clear();
- }
- int returnValue = this.Adapter.Fill(dataTable);
- return returnValue;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
- [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
- public virtual konkursDataSet.bronirovenieDataTable GetData() {
- this.Adapter.SelectCommand = this.CommandCollection[0];
- konkursDataSet.bronirovenieDataTable dataTable = new konkursDataSet.bronirovenieDataTable();
- this.Adapter.Fill(dataTable);
- return dataTable;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
- public virtual int Update(konkursDataSet.bronirovenieDataTable dataTable) {
- return this.Adapter.Update(dataTable);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
- public virtual int Update(konkursDataSet dataSet) {
- return this.Adapter.Update(dataSet, "bronirovenie");
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
- public virtual int Update(global::System.Data.DataRow dataRow) {
- return this.Adapter.Update(new global::System.Data.DataRow[] {
- dataRow});
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
- public virtual int Update(global::System.Data.DataRow[] dataRows) {
- return this.Adapter.Update(dataRows);
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
- [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)]
- 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) {
- this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(Original_nomer_kvitancii));
- if ((Original_date_broni.HasValue == true)) {
- this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(0));
- this.Adapter.DeleteCommand.Parameters[2].Value = ((System.DateTime)(Original_date_broni.Value));
- }
- else {
- this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(1));
- this.Adapter.DeleteCommand.Parameters[2].Value = global::System.DBNull.Value;
- }
- if ((Original_date_zaezda.HasValue == true)) {
- this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0));
- this.Adapter.DeleteCommand.Parameters[4].Value = ((System.DateTime)(Original_date_zaezda.Value));
- }
- else {
- this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(1));
- this.Adapter.DeleteCommand.Parameters[4].Value = global::System.DBNull.Value;
- }
- if ((Original_nomer_mesta == null)) {
- this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(1));
- this.Adapter.DeleteCommand.Parameters[6].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(0));
- this.Adapter.DeleteCommand.Parameters[6].Value = ((string)(Original_nomer_mesta));
- }
- if ((Original_kod_clients == null)) {
- this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(1));
- this.Adapter.DeleteCommand.Parameters[8].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(0));
- this.Adapter.DeleteCommand.Parameters[8].Value = ((string)(Original_kod_clients));
- }
- if ((Original_chislo_days == null)) {
- this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(1));
- this.Adapter.DeleteCommand.Parameters[10].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(0));
- this.Adapter.DeleteCommand.Parameters[10].Value = ((string)(Original_chislo_days));
- }
- if ((Original_date_oplati.HasValue == true)) {
- this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(0));
- this.Adapter.DeleteCommand.Parameters[12].Value = ((System.DateTime)(Original_date_oplati.Value));
- }
- else {
- this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(1));
- this.Adapter.DeleteCommand.Parameters[12].Value = global::System.DBNull.Value;
- }
- if ((Original_sale_oplata == null)) {
- this.Adapter.DeleteCommand.Parameters[13].Value = ((object)(1));
- this.Adapter.DeleteCommand.Parameters[14].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.DeleteCommand.Parameters[13].Value = ((object)(0));
- this.Adapter.DeleteCommand.Parameters[14].Value = ((string)(Original_sale_oplata));
- }
- if ((Original_sale_season == null)) {
- this.Adapter.DeleteCommand.Parameters[15].Value = ((object)(1));
- this.Adapter.DeleteCommand.Parameters[16].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.DeleteCommand.Parameters[15].Value = ((object)(0));
- this.Adapter.DeleteCommand.Parameters[16].Value = ((string)(Original_sale_season));
- }
- global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
- if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
- != global::System.Data.ConnectionState.Open)) {
- this.Adapter.DeleteCommand.Connection.Open();
- }
- try {
- int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
- return returnValue;
- }
- finally {
- if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
- this.Adapter.DeleteCommand.Connection.Close();
- }
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
- [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
- 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) {
- this.Adapter.InsertCommand.Parameters[0].Value = ((int)(nomer_kvitancii));
- if ((date_broni.HasValue == true)) {
- this.Adapter.InsertCommand.Parameters[1].Value = ((System.DateTime)(date_broni.Value));
- }
- else {
- this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
- }
- if ((date_zaezda.HasValue == true)) {
- this.Adapter.InsertCommand.Parameters[2].Value = ((System.DateTime)(date_zaezda.Value));
- }
- else {
- this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
- }
- if ((nomer_mesta == null)) {
- this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.InsertCommand.Parameters[3].Value = ((string)(nomer_mesta));
- }
- if ((kod_clients == null)) {
- this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.InsertCommand.Parameters[4].Value = ((string)(kod_clients));
- }
- if ((chislo_days == null)) {
- this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.InsertCommand.Parameters[5].Value = ((string)(chislo_days));
- }
- if ((date_oplati.HasValue == true)) {
- this.Adapter.InsertCommand.Parameters[6].Value = ((System.DateTime)(date_oplati.Value));
- }
- else {
- this.Adapter.InsertCommand.Parameters[6].Value = global::System.DBNull.Value;
- }
- if ((sale_oplata == null)) {
- this.Adapter.InsertCommand.Parameters[7].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.InsertCommand.Parameters[7].Value = ((string)(sale_oplata));
- }
- if ((sale_season == null)) {
- this.Adapter.InsertCommand.Parameters[8].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.InsertCommand.Parameters[8].Value = ((string)(sale_season));
- }
- global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
- if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
- != global::System.Data.ConnectionState.Open)) {
- this.Adapter.InsertCommand.Connection.Open();
- }
- try {
- int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
- return returnValue;
- }
- finally {
- if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
- this.Adapter.InsertCommand.Connection.Close();
- }
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
- [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
- public virtual int Update(
- 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,
- 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) {
- this.Adapter.UpdateCommand.Parameters[0].Value = ((int)(nomer_kvitancii));
- if ((date_broni.HasValue == true)) {
- this.Adapter.UpdateCommand.Parameters[1].Value = ((System.DateTime)(date_broni.Value));
- }
- else {
- this.Adapter.UpdateCommand.Parameters[1].Value = global::System.DBNull.Value;
- }
- if ((date_zaezda.HasValue == true)) {
- this.Adapter.UpdateCommand.Parameters[2].Value = ((System.DateTime)(date_zaezda.Value));
- }
- else {
- this.Adapter.UpdateCommand.Parameters[2].Value = global::System.DBNull.Value;
- }
- if ((nomer_mesta == null)) {
- this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(nomer_mesta));
- }
- if ((kod_clients == null)) {
- this.Adapter.UpdateCommand.Parameters[4].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(kod_clients));
- }
- if ((chislo_days == null)) {
- this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(chislo_days));
- }
- if ((date_oplati.HasValue == true)) {
- this.Adapter.UpdateCommand.Parameters[6].Value = ((System.DateTime)(date_oplati.Value));
- }
- else {
- this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value;
- }
- if ((sale_oplata == null)) {
- this.Adapter.UpdateCommand.Parameters[7].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.UpdateCommand.Parameters[7].Value = ((string)(sale_oplata));
- }
- if ((sale_season == null)) {
- this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.UpdateCommand.Parameters[8].Value = ((string)(sale_season));
- }
- this.Adapter.UpdateCommand.Parameters[9].Value = ((int)(Original_nomer_kvitancii));
- if ((Original_date_broni.HasValue == true)) {
- this.Adapter.UpdateCommand.Parameters[10].Value = ((object)(0));
- this.Adapter.UpdateCommand.Parameters[11].Value = ((System.DateTime)(Original_date_broni.Value));
- }
- else {
- this.Adapter.UpdateCommand.Parameters[10].Value = ((object)(1));
- this.Adapter.UpdateCommand.Parameters[11].Value = global::System.DBNull.Value;
- }
- if ((Original_date_zaezda.HasValue == true)) {
- this.Adapter.UpdateCommand.Parameters[12].Value = ((object)(0));
- this.Adapter.UpdateCommand.Parameters[13].Value = ((System.DateTime)(Original_date_zaezda.Value));
- }
- else {
- this.Adapter.UpdateCommand.Parameters[12].Value = ((object)(1));
- this.Adapter.UpdateCommand.Parameters[13].Value = global::System.DBNull.Value;
- }
- if ((Original_nomer_mesta == null)) {
- this.Adapter.UpdateCommand.Parameters[14].Value = ((object)(1));
- this.Adapter.UpdateCommand.Parameters[15].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.UpdateCommand.Parameters[14].Value = ((object)(0));
- this.Adapter.UpdateCommand.Parameters[15].Value = ((string)(Original_nomer_mesta));
- }
- if ((Original_kod_clients == null)) {
- this.Adapter.UpdateCommand.Parameters[16].Value = ((object)(1));
- this.Adapter.UpdateCommand.Parameters[17].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.UpdateCommand.Parameters[16].Value = ((object)(0));
- this.Adapter.UpdateCommand.Parameters[17].Value = ((string)(Original_kod_clients));
- }
- if ((Original_chislo_days == null)) {
- this.Adapter.UpdateCommand.Parameters[18].Value = ((object)(1));
- this.Adapter.UpdateCommand.Parameters[19].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.UpdateCommand.Parameters[18].Value = ((object)(0));
- this.Adapter.UpdateCommand.Parameters[19].Value = ((string)(Original_chislo_days));
- }
- if ((Original_date_oplati.HasValue == true)) {
- this.Adapter.UpdateCommand.Parameters[20].Value = ((object)(0));
- this.Adapter.UpdateCommand.Parameters[21].Value = ((System.DateTime)(Original_date_oplati.Value));
- }
- else {
- this.Adapter.UpdateCommand.Parameters[20].Value = ((object)(1));
- this.Adapter.UpdateCommand.Parameters[21].Value = global::System.DBNull.Value;
- }
- if ((Original_sale_oplata == null)) {
- this.Adapter.UpdateCommand.Parameters[22].Value = ((object)(1));
- this.Adapter.UpdateCommand.Parameters[23].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.UpdateCommand.Parameters[22].Value = ((object)(0));
- this.Adapter.UpdateCommand.Parameters[23].Value = ((string)(Original_sale_oplata));
- }
- if ((Original_sale_season == null)) {
- this.Adapter.UpdateCommand.Parameters[24].Value = ((object)(1));
- this.Adapter.UpdateCommand.Parameters[25].Value = global::System.DBNull.Value;
- }
- else {
- this.Adapter.UpdateCommand.Parameters[24].Value = ((object)(0));
- this.Adapter.UpdateCommand.Parameters[25].Value = ((string)(Original_sale_season));
- }
- global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
- if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
- != global::System.Data.ConnectionState.Open)) {
- this.Adapter.UpdateCommand.Connection.Open();
- }
- try {
- int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
- return returnValue;
- }
- finally {
- if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
- this.Adapter.UpdateCommand.Connection.Close();
- }
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
- [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
- public virtual int Update(
- 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,
- 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) {
- 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);
- }
- }
-
- /// <summary>
- ///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
- ///</summary>
- [global::System.ComponentModel.DesignerCategoryAttribute("code")]
- [global::System.ComponentModel.ToolboxItem(true)]
- [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
- "esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
- [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
- public partial class TableAdapterManager : global::System.ComponentModel.Component {
-
- private UpdateOrderOption _updateOrder;
-
- private bronirovenieTableAdapter _bronirovenieTableAdapter;
-
- private bool _backupDataSetBeforeUpdate;
-
- private global::System.Data.IDbConnection _connection;
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public UpdateOrderOption UpdateOrder {
- get {
- return this._updateOrder;
- }
- set {
- this._updateOrder = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
- "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
- "a", "System.Drawing.Design.UITypeEditor")]
- public bronirovenieTableAdapter bronirovenieTableAdapter {
- get {
- return this._bronirovenieTableAdapter;
- }
- set {
- this._bronirovenieTableAdapter = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public bool BackupDataSetBeforeUpdate {
- get {
- return this._backupDataSetBeforeUpdate;
- }
- set {
- this._backupDataSetBeforeUpdate = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.Browsable(false)]
- public global::System.Data.IDbConnection Connection {
- get {
- if ((this._connection != null)) {
- return this._connection;
- }
- if (((this._bronirovenieTableAdapter != null)
- && (this._bronirovenieTableAdapter.Connection != null))) {
- return this._bronirovenieTableAdapter.Connection;
- }
- return null;
- }
- set {
- this._connection = value;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- [global::System.ComponentModel.Browsable(false)]
- public int TableAdapterInstanceCount {
- get {
- int count = 0;
- if ((this._bronirovenieTableAdapter != null)) {
- count = (count + 1);
- }
- return count;
- }
- }
-
- /// <summary>
- ///Update rows in top-down order.
- ///</summary>
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- 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) {
- int result = 0;
- if ((this._bronirovenieTableAdapter != null)) {
- global::System.Data.DataRow[] updatedRows = dataSet.bronirovenie.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
- updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
- if (((updatedRows != null)
- && (0 < updatedRows.Length))) {
- result = (result + this._bronirovenieTableAdapter.Update(updatedRows));
- allChangedRows.AddRange(updatedRows);
- }
- }
- return result;
- }
-
- /// <summary>
- ///Insert rows in top-down order.
- ///</summary>
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- private int UpdateInsertedRows(konkursDataSet dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
- int result = 0;
- if ((this._bronirovenieTableAdapter != null)) {
- global::System.Data.DataRow[] addedRows = dataSet.bronirovenie.Select(null, null, global::System.Data.DataViewRowState.Added);
- if (((addedRows != null)
- && (0 < addedRows.Length))) {
- result = (result + this._bronirovenieTableAdapter.Update(addedRows));
- allAddedRows.AddRange(addedRows);
- }
- }
- return result;
- }
-
- /// <summary>
- ///Delete rows in bottom-up order.
- ///</summary>
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- private int UpdateDeletedRows(konkursDataSet dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows) {
- int result = 0;
- if ((this._bronirovenieTableAdapter != null)) {
- global::System.Data.DataRow[] deletedRows = dataSet.bronirovenie.Select(null, null, global::System.Data.DataViewRowState.Deleted);
- if (((deletedRows != null)
- && (0 < deletedRows.Length))) {
- result = (result + this._bronirovenieTableAdapter.Update(deletedRows));
- allChangedRows.AddRange(deletedRows);
- }
- }
- return result;
- }
-
- /// <summary>
- ///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
- ///</summary>
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
- if (((updatedRows == null)
- || (updatedRows.Length < 1))) {
- return updatedRows;
- }
- if (((allAddedRows == null)
- || (allAddedRows.Count < 1))) {
- return updatedRows;
- }
- global::System.Collections.Generic.List<global::System.Data.DataRow> realUpdatedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
- for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
- global::System.Data.DataRow row = updatedRows[i];
- if ((allAddedRows.Contains(row) == false)) {
- realUpdatedRows.Add(row);
- }
- }
- return realUpdatedRows.ToArray();
- }
-
- /// <summary>
- ///Update all changes to the dataset.
- ///</summary>
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public virtual int UpdateAll(konkursDataSet dataSet) {
- if ((dataSet == null)) {
- throw new global::System.ArgumentNullException("dataSet");
- }
- if ((dataSet.HasChanges() == false)) {
- return 0;
- }
- if (((this._bronirovenieTableAdapter != null)
- && (this.MatchTableAdapterConnection(this._bronirovenieTableAdapter.Connection) == false))) {
- throw new global::System.ArgumentException("Все адаптеры таблицы, управляемые диспетчером адаптера таблицы TableAdapterManage" +
- "r, должны использовать одинаковую строку подключения.");
- }
- global::System.Data.IDbConnection workConnection = this.Connection;
- if ((workConnection == null)) {
- throw new global::System.ApplicationException("TableAdapterManager не содержит сведений о подключении. Укажите для каждого адапт" +
- "ера таблицы TableAdapterManager допустимый экземпляр адаптера таблицы.");
- }
- bool workConnOpened = false;
- if (((workConnection.State & global::System.Data.ConnectionState.Broken)
- == global::System.Data.ConnectionState.Broken)) {
- workConnection.Close();
- }
- if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
- workConnection.Open();
- workConnOpened = true;
- }
- global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
- if ((workTransaction == null)) {
- throw new global::System.ApplicationException("Не удается начать транзакцию. Текущее соединение данных не поддерживает транзакци" +
- "и или текущее состояние не позволяет начать транзакцию.");
- }
- global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
- global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
- global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter> adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter>();
- global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection> revertConnections = new global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection>();
- int result = 0;
- global::System.Data.DataSet backupDataSet = null;
- if (this.BackupDataSetBeforeUpdate) {
- backupDataSet = new global::System.Data.DataSet();
- backupDataSet.Merge(dataSet);
- }
- try {
- // ---- Prepare for update -----------
- //
- if ((this._bronirovenieTableAdapter != null)) {
- revertConnections.Add(this._bronirovenieTableAdapter, this._bronirovenieTableAdapter.Connection);
- this._bronirovenieTableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(workConnection));
- this._bronirovenieTableAdapter.Transaction = ((global::System.Data.SqlClient.SqlTransaction)(workTransaction));
- if (this._bronirovenieTableAdapter.Adapter.AcceptChangesDuringUpdate) {
- this._bronirovenieTableAdapter.Adapter.AcceptChangesDuringUpdate = false;
- adaptersWithAcceptChangesDuringUpdate.Add(this._bronirovenieTableAdapter.Adapter);
- }
- }
- //
- //---- Perform updates -----------
- //
- if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) {
- result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
- result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
- }
- else {
- result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
- result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
- }
- result = (result + this.UpdateDeletedRows(dataSet, allChangedRows));
- //
- //---- Commit updates -----------
- //
- workTransaction.Commit();
- if ((0 < allAddedRows.Count)) {
- global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
- allAddedRows.CopyTo(rows);
- for (int i = 0; (i < rows.Length); i = (i + 1)) {
- global::System.Data.DataRow row = rows[i];
- row.AcceptChanges();
- }
- }
- if ((0 < allChangedRows.Count)) {
- global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count];
- allChangedRows.CopyTo(rows);
- for (int i = 0; (i < rows.Length); i = (i + 1)) {
- global::System.Data.DataRow row = rows[i];
- row.AcceptChanges();
- }
- }
- }
- catch (global::System.Exception ex) {
- workTransaction.Rollback();
- // ---- Restore the dataset -----------
- if (this.BackupDataSetBeforeUpdate) {
- global::System.Diagnostics.Debug.Assert((backupDataSet != null));
- dataSet.Clear();
- dataSet.Merge(backupDataSet);
- }
- else {
- if ((0 < allAddedRows.Count)) {
- global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
- allAddedRows.CopyTo(rows);
- for (int i = 0; (i < rows.Length); i = (i + 1)) {
- global::System.Data.DataRow row = rows[i];
- row.AcceptChanges();
- row.SetAdded();
- }
- }
- }
- throw ex;
- }
- finally {
- if (workConnOpened) {
- workConnection.Close();
- }
- if ((this._bronirovenieTableAdapter != null)) {
- this._bronirovenieTableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(revertConnections[this._bronirovenieTableAdapter]));
- this._bronirovenieTableAdapter.Transaction = null;
- }
- if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) {
- global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count];
- adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters);
- for (int i = 0; (i < adapters.Length); i = (i + 1)) {
- global::System.Data.Common.DataAdapter adapter = adapters[i];
- adapter.AcceptChangesDuringUpdate = true;
- }
- }
- }
- return result;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) {
- global::System.Array.Sort<global::System.Data.DataRow>(rows, new SelfReferenceComparer(relation, childFirst));
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) {
- if ((this._connection != null)) {
- return true;
- }
- if (((this.Connection == null)
- || (inputConnection == null))) {
- return true;
- }
- if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) {
- return true;
- }
- return false;
- }
-
- /// <summary>
- ///Update Order Option
- ///</summary>
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public enum UpdateOrderOption {
-
- InsertUpdateDelete = 0,
-
- UpdateInsertDelete = 1,
- }
-
- /// <summary>
- ///Used to sort self-referenced table's rows
- ///</summary>
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer<global::System.Data.DataRow> {
-
- private global::System.Data.DataRelation _relation;
-
- private int _childFirst;
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) {
- this._relation = relation;
- if (childFirst) {
- this._childFirst = -1;
- }
- else {
- this._childFirst = 1;
- }
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- private global::System.Data.DataRow GetRoot(global::System.Data.DataRow row, out int distance) {
- global::System.Diagnostics.Debug.Assert((row != null));
- global::System.Data.DataRow root = row;
- distance = 0;
- 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>();
- traversedRows[row] = row;
- global::System.Data.DataRow parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
- for (
- ; ((parent != null)
- && (traversedRows.ContainsKey(parent) == false));
- ) {
- distance = (distance + 1);
- root = parent;
- traversedRows[parent] = parent;
- parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
- }
- if ((distance == 0)) {
- traversedRows.Clear();
- traversedRows[row] = row;
- parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
- for (
- ; ((parent != null)
- && (traversedRows.ContainsKey(parent) == false));
- ) {
- distance = (distance + 1);
- root = parent;
- traversedRows[parent] = parent;
- parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
- }
- }
- return root;
- }
-
- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
- public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) {
- if (object.ReferenceEquals(row1, row2)) {
- return 0;
- }
- if ((row1 == null)) {
- return -1;
- }
- if ((row2 == null)) {
- return 1;
- }
- int distance1 = 0;
- global::System.Data.DataRow root1 = this.GetRoot(row1, out distance1);
- int distance2 = 0;
- global::System.Data.DataRow root2 = this.GetRoot(row2, out distance2);
- if (object.ReferenceEquals(root1, root2)) {
- return (this._childFirst * distance1.CompareTo(distance2));
- }
- else {
- global::System.Diagnostics.Debug.Assert(((root1.Table != null)
- && (root2.Table != null)));
- if ((root1.Table.Rows.IndexOf(root1) < root2.Table.Rows.IndexOf(root2))) {
- return -1;
- }
- else {
- return 1;
- }
- }
- }
- }
- }
- }
- #pragma warning restore 1591
|