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

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235
  1. //------------------------------------------------------------------------------
  2. // <auto-generated>
  3. // Этот код создан программой.
  4. // Исполняемая версия:4.0.30319.42000
  5. //
  6. // Изменения в этом файле могут привести к неправильной работе и будут потеряны в случае
  7. // повторной генерации кода.
  8. // </auto-generated>
  9. //------------------------------------------------------------------------------
  10. #pragma warning disable 1591
  11. namespace Юсову_Владислав_ИСП_11._18._3 {
  12. /// <summary>
  13. ///Represents a strongly typed in-memory cache of data.
  14. ///</summary>
  15. [global::System.Serializable()]
  16. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  17. [global::System.ComponentModel.ToolboxItem(true)]
  18. [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")]
  19. [global::System.Xml.Serialization.XmlRootAttribute("_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6")]
  20. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
  21. public partial class _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6 : global::System.Data.DataSet {
  22. private yusov1DataTable tableyusov1;
  23. private Yusov2DataTable tableYusov2;
  24. private Yusov3DataTable tableYusov3;
  25. private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
  26. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  27. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  28. public _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6() {
  29. this.BeginInit();
  30. this.InitClass();
  31. global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
  32. base.Tables.CollectionChanged += schemaChangedHandler;
  33. base.Relations.CollectionChanged += schemaChangedHandler;
  34. this.EndInit();
  35. }
  36. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  37. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  38. protected _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
  39. base(info, context, false) {
  40. if ((this.IsBinarySerialized(info, context) == true)) {
  41. this.InitVars(false);
  42. global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
  43. this.Tables.CollectionChanged += schemaChangedHandler1;
  44. this.Relations.CollectionChanged += schemaChangedHandler1;
  45. return;
  46. }
  47. string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
  48. if ((this.DetermineSchemaSerializationMode(info, context) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
  49. global::System.Data.DataSet ds = new global::System.Data.DataSet();
  50. ds.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
  51. if ((ds.Tables["yusov1"] != null)) {
  52. base.Tables.Add(new yusov1DataTable(ds.Tables["yusov1"]));
  53. }
  54. if ((ds.Tables["Yusov2"] != null)) {
  55. base.Tables.Add(new Yusov2DataTable(ds.Tables["Yusov2"]));
  56. }
  57. if ((ds.Tables["Yusov3"] != null)) {
  58. base.Tables.Add(new Yusov3DataTable(ds.Tables["Yusov3"]));
  59. }
  60. this.DataSetName = ds.DataSetName;
  61. this.Prefix = ds.Prefix;
  62. this.Namespace = ds.Namespace;
  63. this.Locale = ds.Locale;
  64. this.CaseSensitive = ds.CaseSensitive;
  65. this.EnforceConstraints = ds.EnforceConstraints;
  66. this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
  67. this.InitVars();
  68. }
  69. else {
  70. this.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
  71. }
  72. this.GetSerializationData(info, context);
  73. global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
  74. base.Tables.CollectionChanged += schemaChangedHandler;
  75. this.Relations.CollectionChanged += schemaChangedHandler;
  76. }
  77. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  78. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  79. [global::System.ComponentModel.Browsable(false)]
  80. [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
  81. public yusov1DataTable yusov1 {
  82. get {
  83. return this.tableyusov1;
  84. }
  85. }
  86. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  87. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  88. [global::System.ComponentModel.Browsable(false)]
  89. [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
  90. public Yusov2DataTable Yusov2 {
  91. get {
  92. return this.tableYusov2;
  93. }
  94. }
  95. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  96. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  97. [global::System.ComponentModel.Browsable(false)]
  98. [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
  99. public Yusov3DataTable Yusov3 {
  100. get {
  101. return this.tableYusov3;
  102. }
  103. }
  104. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  105. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  106. [global::System.ComponentModel.BrowsableAttribute(true)]
  107. [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Visible)]
  108. public override global::System.Data.SchemaSerializationMode SchemaSerializationMode {
  109. get {
  110. return this._schemaSerializationMode;
  111. }
  112. set {
  113. this._schemaSerializationMode = value;
  114. }
  115. }
  116. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  117. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  118. [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
  119. public new global::System.Data.DataTableCollection Tables {
  120. get {
  121. return base.Tables;
  122. }
  123. }
  124. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  125. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  126. [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
  127. public new global::System.Data.DataRelationCollection Relations {
  128. get {
  129. return base.Relations;
  130. }
  131. }
  132. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  133. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  134. protected override void InitializeDerivedDataSet() {
  135. this.BeginInit();
  136. this.InitClass();
  137. this.EndInit();
  138. }
  139. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  140. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  141. public override global::System.Data.DataSet Clone() {
  142. _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6 cln = ((_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6)(base.Clone()));
  143. cln.InitVars();
  144. cln.SchemaSerializationMode = this.SchemaSerializationMode;
  145. return cln;
  146. }
  147. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  148. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  149. protected override bool ShouldSerializeTables() {
  150. return false;
  151. }
  152. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  153. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  154. protected override bool ShouldSerializeRelations() {
  155. return false;
  156. }
  157. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  158. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  159. protected override void ReadXmlSerializable(global::System.Xml.XmlReader reader) {
  160. if ((this.DetermineSchemaSerializationMode(reader) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
  161. this.Reset();
  162. global::System.Data.DataSet ds = new global::System.Data.DataSet();
  163. ds.ReadXml(reader);
  164. if ((ds.Tables["yusov1"] != null)) {
  165. base.Tables.Add(new yusov1DataTable(ds.Tables["yusov1"]));
  166. }
  167. if ((ds.Tables["Yusov2"] != null)) {
  168. base.Tables.Add(new Yusov2DataTable(ds.Tables["Yusov2"]));
  169. }
  170. if ((ds.Tables["Yusov3"] != null)) {
  171. base.Tables.Add(new Yusov3DataTable(ds.Tables["Yusov3"]));
  172. }
  173. this.DataSetName = ds.DataSetName;
  174. this.Prefix = ds.Prefix;
  175. this.Namespace = ds.Namespace;
  176. this.Locale = ds.Locale;
  177. this.CaseSensitive = ds.CaseSensitive;
  178. this.EnforceConstraints = ds.EnforceConstraints;
  179. this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
  180. this.InitVars();
  181. }
  182. else {
  183. this.ReadXml(reader);
  184. this.InitVars();
  185. }
  186. }
  187. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  188. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  189. protected override global::System.Xml.Schema.XmlSchema GetSchemaSerializable() {
  190. global::System.IO.MemoryStream stream = new global::System.IO.MemoryStream();
  191. this.WriteXmlSchema(new global::System.Xml.XmlTextWriter(stream, null));
  192. stream.Position = 0;
  193. return global::System.Xml.Schema.XmlSchema.Read(new global::System.Xml.XmlTextReader(stream), null);
  194. }
  195. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  196. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  197. internal void InitVars() {
  198. this.InitVars(true);
  199. }
  200. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  201. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  202. internal void InitVars(bool initTable) {
  203. this.tableyusov1 = ((yusov1DataTable)(base.Tables["yusov1"]));
  204. if ((initTable == true)) {
  205. if ((this.tableyusov1 != null)) {
  206. this.tableyusov1.InitVars();
  207. }
  208. }
  209. this.tableYusov2 = ((Yusov2DataTable)(base.Tables["Yusov2"]));
  210. if ((initTable == true)) {
  211. if ((this.tableYusov2 != null)) {
  212. this.tableYusov2.InitVars();
  213. }
  214. }
  215. this.tableYusov3 = ((Yusov3DataTable)(base.Tables["Yusov3"]));
  216. if ((initTable == true)) {
  217. if ((this.tableYusov3 != null)) {
  218. this.tableYusov3.InitVars();
  219. }
  220. }
  221. }
  222. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  223. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  224. private void InitClass() {
  225. this.DataSetName = "_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6";
  226. this.Prefix = "";
  227. this.Namespace = "http://tempuri.org/_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.xsd";
  228. this.EnforceConstraints = true;
  229. this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
  230. this.tableyusov1 = new yusov1DataTable();
  231. base.Tables.Add(this.tableyusov1);
  232. this.tableYusov2 = new Yusov2DataTable();
  233. base.Tables.Add(this.tableYusov2);
  234. this.tableYusov3 = new Yusov3DataTable();
  235. base.Tables.Add(this.tableYusov3);
  236. }
  237. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  238. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  239. private bool ShouldSerializeyusov1() {
  240. return false;
  241. }
  242. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  243. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  244. private bool ShouldSerializeYusov2() {
  245. return false;
  246. }
  247. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  248. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  249. private bool ShouldSerializeYusov3() {
  250. return false;
  251. }
  252. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  253. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  254. private void SchemaChanged(object sender, global::System.ComponentModel.CollectionChangeEventArgs e) {
  255. if ((e.Action == global::System.ComponentModel.CollectionChangeAction.Remove)) {
  256. this.InitVars();
  257. }
  258. }
  259. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  260. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  261. public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
  262. _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6 ds = new _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6();
  263. global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
  264. global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
  265. global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
  266. any.Namespace = ds.Namespace;
  267. sequence.Items.Add(any);
  268. type.Particle = sequence;
  269. global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
  270. if (xs.Contains(dsSchema.TargetNamespace)) {
  271. global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
  272. global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
  273. try {
  274. global::System.Xml.Schema.XmlSchema schema = null;
  275. dsSchema.Write(s1);
  276. for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
  277. schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
  278. s2.SetLength(0);
  279. schema.Write(s2);
  280. if ((s1.Length == s2.Length)) {
  281. s1.Position = 0;
  282. s2.Position = 0;
  283. for (; ((s1.Position != s1.Length)
  284. && (s1.ReadByte() == s2.ReadByte())); ) {
  285. ;
  286. }
  287. if ((s1.Position == s1.Length)) {
  288. return type;
  289. }
  290. }
  291. }
  292. }
  293. finally {
  294. if ((s1 != null)) {
  295. s1.Close();
  296. }
  297. if ((s2 != null)) {
  298. s2.Close();
  299. }
  300. }
  301. }
  302. xs.Add(dsSchema);
  303. return type;
  304. }
  305. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  306. public delegate void yusov1RowChangeEventHandler(object sender, yusov1RowChangeEvent e);
  307. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  308. public delegate void Yusov2RowChangeEventHandler(object sender, Yusov2RowChangeEvent e);
  309. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  310. public delegate void Yusov3RowChangeEventHandler(object sender, Yusov3RowChangeEvent e);
  311. /// <summary>
  312. ///Represents the strongly named DataTable class.
  313. ///</summary>
  314. [global::System.Serializable()]
  315. [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
  316. public partial class yusov1DataTable : global::System.Data.TypedTableBase<yusov1Row> {
  317. private global::System.Data.DataColumn columnФамилия;
  318. private global::System.Data.DataColumn columnИмя;
  319. private global::System.Data.DataColumn columnОтчество;
  320. private global::System.Data.DataColumn columnПол;
  321. private global::System.Data.DataColumn columnТелефон;
  322. private global::System.Data.DataColumn columnДата_рождения;
  323. private global::System.Data.DataColumn columnEmail;
  324. private global::System.Data.DataColumn columnДата_регистрации;
  325. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  326. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  327. public yusov1DataTable() {
  328. this.TableName = "yusov1";
  329. this.BeginInit();
  330. this.InitClass();
  331. this.EndInit();
  332. }
  333. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  334. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  335. internal yusov1DataTable(global::System.Data.DataTable table) {
  336. this.TableName = table.TableName;
  337. if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
  338. this.CaseSensitive = table.CaseSensitive;
  339. }
  340. if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
  341. this.Locale = table.Locale;
  342. }
  343. if ((table.Namespace != table.DataSet.Namespace)) {
  344. this.Namespace = table.Namespace;
  345. }
  346. this.Prefix = table.Prefix;
  347. this.MinimumCapacity = table.MinimumCapacity;
  348. }
  349. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  350. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  351. protected yusov1DataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
  352. base(info, context) {
  353. this.InitVars();
  354. }
  355. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  356. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  357. public global::System.Data.DataColumn ФамилияColumn {
  358. get {
  359. return this.columnФамилия;
  360. }
  361. }
  362. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  363. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  364. public global::System.Data.DataColumn ИмяColumn {
  365. get {
  366. return this.columnИмя;
  367. }
  368. }
  369. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  370. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  371. public global::System.Data.DataColumn ОтчествоColumn {
  372. get {
  373. return this.columnОтчество;
  374. }
  375. }
  376. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  377. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  378. public global::System.Data.DataColumn ПолColumn {
  379. get {
  380. return this.columnПол;
  381. }
  382. }
  383. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  384. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  385. public global::System.Data.DataColumn ТелефонColumn {
  386. get {
  387. return this.columnТелефон;
  388. }
  389. }
  390. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  391. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  392. public global::System.Data.DataColumn Дата_рожденияColumn {
  393. get {
  394. return this.columnДата_рождения;
  395. }
  396. }
  397. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  398. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  399. public global::System.Data.DataColumn EmailColumn {
  400. get {
  401. return this.columnEmail;
  402. }
  403. }
  404. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  405. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  406. public global::System.Data.DataColumn Дата_регистрацииColumn {
  407. get {
  408. return this.columnДата_регистрации;
  409. }
  410. }
  411. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  412. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  413. [global::System.ComponentModel.Browsable(false)]
  414. public int Count {
  415. get {
  416. return this.Rows.Count;
  417. }
  418. }
  419. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  420. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  421. public yusov1Row this[int index] {
  422. get {
  423. return ((yusov1Row)(this.Rows[index]));
  424. }
  425. }
  426. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  427. public event yusov1RowChangeEventHandler yusov1RowChanging;
  428. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  429. public event yusov1RowChangeEventHandler yusov1RowChanged;
  430. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  431. public event yusov1RowChangeEventHandler yusov1RowDeleting;
  432. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  433. public event yusov1RowChangeEventHandler yusov1RowDeleted;
  434. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  435. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  436. public void Addyusov1Row(yusov1Row row) {
  437. this.Rows.Add(row);
  438. }
  439. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  440. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  441. public yusov1Row Addyusov1Row(string Фамилия, string Имя, string Отчество, string Пол, string Телефон, System.DateTime Дата_рождения, string Email, System.DateTime Дата_регистрации) {
  442. yusov1Row rowyusov1Row = ((yusov1Row)(this.NewRow()));
  443. object[] columnValuesArray = new object[] {
  444. Фамилия,
  445. Имя,
  446. Отчество,
  447. Пол,
  448. Телефон,
  449. Дата_рождения,
  450. Email,
  451. Дата_регистрации};
  452. rowyusov1Row.ItemArray = columnValuesArray;
  453. this.Rows.Add(rowyusov1Row);
  454. return rowyusov1Row;
  455. }
  456. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  457. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  458. public override global::System.Data.DataTable Clone() {
  459. yusov1DataTable cln = ((yusov1DataTable)(base.Clone()));
  460. cln.InitVars();
  461. return cln;
  462. }
  463. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  464. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  465. protected override global::System.Data.DataTable CreateInstance() {
  466. return new yusov1DataTable();
  467. }
  468. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  469. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  470. internal void InitVars() {
  471. this.columnФамилия = base.Columns["Фамилия"];
  472. this.columnИмя = base.Columns["Имя"];
  473. this.columnОтчество = base.Columns["Отчество"];
  474. this.columnПол = base.Columns["Пол"];
  475. this.columnТелефон = base.Columns["Телефон"];
  476. this.columnДата_рождения = base.Columns["Дата_рождения"];
  477. this.columnEmail = base.Columns["Email"];
  478. this.columnДата_регистрации = base.Columns["Дата_регистрации"];
  479. }
  480. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  481. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  482. private void InitClass() {
  483. this.columnФамилия = new global::System.Data.DataColumn("Фамилия", typeof(string), null, global::System.Data.MappingType.Element);
  484. base.Columns.Add(this.columnФамилия);
  485. this.columnИмя = new global::System.Data.DataColumn("Имя", typeof(string), null, global::System.Data.MappingType.Element);
  486. base.Columns.Add(this.columnИмя);
  487. this.columnОтчество = new global::System.Data.DataColumn("Отчество", typeof(string), null, global::System.Data.MappingType.Element);
  488. base.Columns.Add(this.columnОтчество);
  489. this.columnПол = new global::System.Data.DataColumn("Пол", typeof(string), null, global::System.Data.MappingType.Element);
  490. base.Columns.Add(this.columnПол);
  491. this.columnТелефон = new global::System.Data.DataColumn("Телефон", typeof(string), null, global::System.Data.MappingType.Element);
  492. base.Columns.Add(this.columnТелефон);
  493. this.columnДата_рождения = new global::System.Data.DataColumn("Дата_рождения", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
  494. base.Columns.Add(this.columnДата_рождения);
  495. this.columnEmail = new global::System.Data.DataColumn("Email", typeof(string), null, global::System.Data.MappingType.Element);
  496. base.Columns.Add(this.columnEmail);
  497. this.columnДата_регистрации = new global::System.Data.DataColumn("Дата_регистрации", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
  498. base.Columns.Add(this.columnДата_регистрации);
  499. this.columnФамилия.MaxLength = 50;
  500. this.columnИмя.MaxLength = 50;
  501. this.columnОтчество.MaxLength = 50;
  502. this.columnПол.MaxLength = 50;
  503. this.columnТелефон.MaxLength = 50;
  504. this.columnEmail.MaxLength = 50;
  505. }
  506. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  507. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  508. public yusov1Row Newyusov1Row() {
  509. return ((yusov1Row)(this.NewRow()));
  510. }
  511. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  512. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  513. protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
  514. return new yusov1Row(builder);
  515. }
  516. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  517. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  518. protected override global::System.Type GetRowType() {
  519. return typeof(yusov1Row);
  520. }
  521. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  522. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  523. protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
  524. base.OnRowChanged(e);
  525. if ((this.yusov1RowChanged != null)) {
  526. this.yusov1RowChanged(this, new yusov1RowChangeEvent(((yusov1Row)(e.Row)), e.Action));
  527. }
  528. }
  529. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  530. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  531. protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
  532. base.OnRowChanging(e);
  533. if ((this.yusov1RowChanging != null)) {
  534. this.yusov1RowChanging(this, new yusov1RowChangeEvent(((yusov1Row)(e.Row)), e.Action));
  535. }
  536. }
  537. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  538. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  539. protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
  540. base.OnRowDeleted(e);
  541. if ((this.yusov1RowDeleted != null)) {
  542. this.yusov1RowDeleted(this, new yusov1RowChangeEvent(((yusov1Row)(e.Row)), e.Action));
  543. }
  544. }
  545. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  546. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  547. protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
  548. base.OnRowDeleting(e);
  549. if ((this.yusov1RowDeleting != null)) {
  550. this.yusov1RowDeleting(this, new yusov1RowChangeEvent(((yusov1Row)(e.Row)), e.Action));
  551. }
  552. }
  553. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  554. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  555. public void Removeyusov1Row(yusov1Row row) {
  556. this.Rows.Remove(row);
  557. }
  558. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  559. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  560. public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
  561. global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
  562. global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
  563. _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6 ds = new _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6();
  564. global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
  565. any1.Namespace = "http://www.w3.org/2001/XMLSchema";
  566. any1.MinOccurs = new decimal(0);
  567. any1.MaxOccurs = decimal.MaxValue;
  568. any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  569. sequence.Items.Add(any1);
  570. global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
  571. any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  572. any2.MinOccurs = new decimal(1);
  573. any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  574. sequence.Items.Add(any2);
  575. global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
  576. attribute1.Name = "namespace";
  577. attribute1.FixedValue = ds.Namespace;
  578. type.Attributes.Add(attribute1);
  579. global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
  580. attribute2.Name = "tableTypeName";
  581. attribute2.FixedValue = "yusov1DataTable";
  582. type.Attributes.Add(attribute2);
  583. type.Particle = sequence;
  584. global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
  585. if (xs.Contains(dsSchema.TargetNamespace)) {
  586. global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
  587. global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
  588. try {
  589. global::System.Xml.Schema.XmlSchema schema = null;
  590. dsSchema.Write(s1);
  591. for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
  592. schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
  593. s2.SetLength(0);
  594. schema.Write(s2);
  595. if ((s1.Length == s2.Length)) {
  596. s1.Position = 0;
  597. s2.Position = 0;
  598. for (; ((s1.Position != s1.Length)
  599. && (s1.ReadByte() == s2.ReadByte())); ) {
  600. ;
  601. }
  602. if ((s1.Position == s1.Length)) {
  603. return type;
  604. }
  605. }
  606. }
  607. }
  608. finally {
  609. if ((s1 != null)) {
  610. s1.Close();
  611. }
  612. if ((s2 != null)) {
  613. s2.Close();
  614. }
  615. }
  616. }
  617. xs.Add(dsSchema);
  618. return type;
  619. }
  620. }
  621. /// <summary>
  622. ///Represents the strongly named DataTable class.
  623. ///</summary>
  624. [global::System.Serializable()]
  625. [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
  626. public partial class Yusov2DataTable : global::System.Data.TypedTableBase<Yusov2Row> {
  627. private global::System.Data.DataColumn columnНаименование_услуги;
  628. private global::System.Data.DataColumn columnГлавное_изображение;
  629. private global::System.Data.DataColumn columnДлительность;
  630. private global::System.Data.DataColumn columnСтоимость;
  631. private global::System.Data.DataColumn columnДействующая_скидка;
  632. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  633. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  634. public Yusov2DataTable() {
  635. this.TableName = "Yusov2";
  636. this.BeginInit();
  637. this.InitClass();
  638. this.EndInit();
  639. }
  640. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  641. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  642. internal Yusov2DataTable(global::System.Data.DataTable table) {
  643. this.TableName = table.TableName;
  644. if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
  645. this.CaseSensitive = table.CaseSensitive;
  646. }
  647. if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
  648. this.Locale = table.Locale;
  649. }
  650. if ((table.Namespace != table.DataSet.Namespace)) {
  651. this.Namespace = table.Namespace;
  652. }
  653. this.Prefix = table.Prefix;
  654. this.MinimumCapacity = table.MinimumCapacity;
  655. }
  656. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  657. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  658. protected Yusov2DataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
  659. base(info, context) {
  660. this.InitVars();
  661. }
  662. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  663. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  664. public global::System.Data.DataColumn Наименование_услугиColumn {
  665. get {
  666. return this.columnНаименование_услуги;
  667. }
  668. }
  669. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  670. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  671. public global::System.Data.DataColumn Главное_изображениеColumn {
  672. get {
  673. return this.columnГлавное_изображение;
  674. }
  675. }
  676. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  677. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  678. public global::System.Data.DataColumn ДлительностьColumn {
  679. get {
  680. return this.columnДлительность;
  681. }
  682. }
  683. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  684. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  685. public global::System.Data.DataColumn СтоимостьColumn {
  686. get {
  687. return this.columnСтоимость;
  688. }
  689. }
  690. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  691. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  692. public global::System.Data.DataColumn Действующая_скидкаColumn {
  693. get {
  694. return this.columnДействующая_скидка;
  695. }
  696. }
  697. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  698. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  699. [global::System.ComponentModel.Browsable(false)]
  700. public int Count {
  701. get {
  702. return this.Rows.Count;
  703. }
  704. }
  705. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  706. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  707. public Yusov2Row this[int index] {
  708. get {
  709. return ((Yusov2Row)(this.Rows[index]));
  710. }
  711. }
  712. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  713. public event Yusov2RowChangeEventHandler Yusov2RowChanging;
  714. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  715. public event Yusov2RowChangeEventHandler Yusov2RowChanged;
  716. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  717. public event Yusov2RowChangeEventHandler Yusov2RowDeleting;
  718. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  719. public event Yusov2RowChangeEventHandler Yusov2RowDeleted;
  720. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  721. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  722. public void AddYusov2Row(Yusov2Row row) {
  723. this.Rows.Add(row);
  724. }
  725. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  726. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  727. public Yusov2Row AddYusov2Row(string Наименование_услуги, string Главное_изображение, string Длительность, string Стоимость, string Действующая_скидка) {
  728. Yusov2Row rowYusov2Row = ((Yusov2Row)(this.NewRow()));
  729. object[] columnValuesArray = new object[] {
  730. Наименование_услуги,
  731. Главное_изображение,
  732. Длительность,
  733. Стоимость,
  734. Действующая_скидка};
  735. rowYusov2Row.ItemArray = columnValuesArray;
  736. this.Rows.Add(rowYusov2Row);
  737. return rowYusov2Row;
  738. }
  739. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  740. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  741. public override global::System.Data.DataTable Clone() {
  742. Yusov2DataTable cln = ((Yusov2DataTable)(base.Clone()));
  743. cln.InitVars();
  744. return cln;
  745. }
  746. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  747. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  748. protected override global::System.Data.DataTable CreateInstance() {
  749. return new Yusov2DataTable();
  750. }
  751. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  752. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  753. internal void InitVars() {
  754. this.columnНаименование_услуги = base.Columns["Наименование_услуги"];
  755. this.columnГлавное_изображение = base.Columns["Главное_изображение"];
  756. this.columnДлительность = base.Columns["Длительность"];
  757. this.columnСтоимость = base.Columns["Стоимость"];
  758. this.columnДействующая_скидка = base.Columns["Действующая_скидка"];
  759. }
  760. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  761. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  762. private void InitClass() {
  763. this.columnНаименование_услуги = new global::System.Data.DataColumn("Наименование_услуги", typeof(string), null, global::System.Data.MappingType.Element);
  764. base.Columns.Add(this.columnНаименование_услуги);
  765. this.columnГлавное_изображение = new global::System.Data.DataColumn("Главное_изображение", typeof(string), null, global::System.Data.MappingType.Element);
  766. base.Columns.Add(this.columnГлавное_изображение);
  767. this.columnДлительность = new global::System.Data.DataColumn("Длительность", typeof(string), null, global::System.Data.MappingType.Element);
  768. base.Columns.Add(this.columnДлительность);
  769. this.columnСтоимость = new global::System.Data.DataColumn("Стоимость", typeof(string), null, global::System.Data.MappingType.Element);
  770. base.Columns.Add(this.columnСтоимость);
  771. this.columnДействующая_скидка = new global::System.Data.DataColumn("Действующая_скидка", typeof(string), null, global::System.Data.MappingType.Element);
  772. base.Columns.Add(this.columnДействующая_скидка);
  773. this.columnНаименование_услуги.MaxLength = 50;
  774. this.columnГлавное_изображение.MaxLength = 100;
  775. this.columnДлительность.MaxLength = 50;
  776. this.columnСтоимость.MaxLength = 50;
  777. this.columnДействующая_скидка.MaxLength = 50;
  778. }
  779. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  780. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  781. public Yusov2Row NewYusov2Row() {
  782. return ((Yusov2Row)(this.NewRow()));
  783. }
  784. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  785. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  786. protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
  787. return new Yusov2Row(builder);
  788. }
  789. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  790. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  791. protected override global::System.Type GetRowType() {
  792. return typeof(Yusov2Row);
  793. }
  794. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  795. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  796. protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
  797. base.OnRowChanged(e);
  798. if ((this.Yusov2RowChanged != null)) {
  799. this.Yusov2RowChanged(this, new Yusov2RowChangeEvent(((Yusov2Row)(e.Row)), e.Action));
  800. }
  801. }
  802. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  803. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  804. protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
  805. base.OnRowChanging(e);
  806. if ((this.Yusov2RowChanging != null)) {
  807. this.Yusov2RowChanging(this, new Yusov2RowChangeEvent(((Yusov2Row)(e.Row)), e.Action));
  808. }
  809. }
  810. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  811. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  812. protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
  813. base.OnRowDeleted(e);
  814. if ((this.Yusov2RowDeleted != null)) {
  815. this.Yusov2RowDeleted(this, new Yusov2RowChangeEvent(((Yusov2Row)(e.Row)), e.Action));
  816. }
  817. }
  818. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  819. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  820. protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
  821. base.OnRowDeleting(e);
  822. if ((this.Yusov2RowDeleting != null)) {
  823. this.Yusov2RowDeleting(this, new Yusov2RowChangeEvent(((Yusov2Row)(e.Row)), e.Action));
  824. }
  825. }
  826. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  827. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  828. public void RemoveYusov2Row(Yusov2Row row) {
  829. this.Rows.Remove(row);
  830. }
  831. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  832. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  833. public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
  834. global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
  835. global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
  836. _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6 ds = new _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6();
  837. global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
  838. any1.Namespace = "http://www.w3.org/2001/XMLSchema";
  839. any1.MinOccurs = new decimal(0);
  840. any1.MaxOccurs = decimal.MaxValue;
  841. any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  842. sequence.Items.Add(any1);
  843. global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
  844. any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  845. any2.MinOccurs = new decimal(1);
  846. any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  847. sequence.Items.Add(any2);
  848. global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
  849. attribute1.Name = "namespace";
  850. attribute1.FixedValue = ds.Namespace;
  851. type.Attributes.Add(attribute1);
  852. global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
  853. attribute2.Name = "tableTypeName";
  854. attribute2.FixedValue = "Yusov2DataTable";
  855. type.Attributes.Add(attribute2);
  856. type.Particle = sequence;
  857. global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
  858. if (xs.Contains(dsSchema.TargetNamespace)) {
  859. global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
  860. global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
  861. try {
  862. global::System.Xml.Schema.XmlSchema schema = null;
  863. dsSchema.Write(s1);
  864. for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
  865. schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
  866. s2.SetLength(0);
  867. schema.Write(s2);
  868. if ((s1.Length == s2.Length)) {
  869. s1.Position = 0;
  870. s2.Position = 0;
  871. for (; ((s1.Position != s1.Length)
  872. && (s1.ReadByte() == s2.ReadByte())); ) {
  873. ;
  874. }
  875. if ((s1.Position == s1.Length)) {
  876. return type;
  877. }
  878. }
  879. }
  880. }
  881. finally {
  882. if ((s1 != null)) {
  883. s1.Close();
  884. }
  885. if ((s2 != null)) {
  886. s2.Close();
  887. }
  888. }
  889. }
  890. xs.Add(dsSchema);
  891. return type;
  892. }
  893. }
  894. /// <summary>
  895. ///Represents the strongly named DataTable class.
  896. ///</summary>
  897. [global::System.Serializable()]
  898. [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
  899. public partial class Yusov3DataTable : global::System.Data.TypedTableBase<Yusov3Row> {
  900. private global::System.Data.DataColumn columnУслуга;
  901. private global::System.Data.DataColumn columnНачало_оказания_услуги;
  902. private global::System.Data.DataColumn columnКлиент;
  903. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  904. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  905. public Yusov3DataTable() {
  906. this.TableName = "Yusov3";
  907. this.BeginInit();
  908. this.InitClass();
  909. this.EndInit();
  910. }
  911. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  912. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  913. internal Yusov3DataTable(global::System.Data.DataTable table) {
  914. this.TableName = table.TableName;
  915. if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
  916. this.CaseSensitive = table.CaseSensitive;
  917. }
  918. if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
  919. this.Locale = table.Locale;
  920. }
  921. if ((table.Namespace != table.DataSet.Namespace)) {
  922. this.Namespace = table.Namespace;
  923. }
  924. this.Prefix = table.Prefix;
  925. this.MinimumCapacity = table.MinimumCapacity;
  926. }
  927. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  928. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  929. protected Yusov3DataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
  930. base(info, context) {
  931. this.InitVars();
  932. }
  933. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  934. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  935. public global::System.Data.DataColumn УслугаColumn {
  936. get {
  937. return this.columnУслуга;
  938. }
  939. }
  940. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  941. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  942. public global::System.Data.DataColumn Начало_оказания_услугиColumn {
  943. get {
  944. return this.columnНачало_оказания_услуги;
  945. }
  946. }
  947. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  948. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  949. public global::System.Data.DataColumn КлиентColumn {
  950. get {
  951. return this.columnКлиент;
  952. }
  953. }
  954. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  955. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  956. [global::System.ComponentModel.Browsable(false)]
  957. public int Count {
  958. get {
  959. return this.Rows.Count;
  960. }
  961. }
  962. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  963. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  964. public Yusov3Row this[int index] {
  965. get {
  966. return ((Yusov3Row)(this.Rows[index]));
  967. }
  968. }
  969. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  970. public event Yusov3RowChangeEventHandler Yusov3RowChanging;
  971. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  972. public event Yusov3RowChangeEventHandler Yusov3RowChanged;
  973. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  974. public event Yusov3RowChangeEventHandler Yusov3RowDeleting;
  975. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  976. public event Yusov3RowChangeEventHandler Yusov3RowDeleted;
  977. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  978. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  979. public void AddYusov3Row(Yusov3Row row) {
  980. this.Rows.Add(row);
  981. }
  982. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  983. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  984. public Yusov3Row AddYusov3Row(string Услуга, System.DateTime Начало_оказания_услуги, string Клиент) {
  985. Yusov3Row rowYusov3Row = ((Yusov3Row)(this.NewRow()));
  986. object[] columnValuesArray = new object[] {
  987. Услуга,
  988. Начало_оказания_услуги,
  989. Клиент};
  990. rowYusov3Row.ItemArray = columnValuesArray;
  991. this.Rows.Add(rowYusov3Row);
  992. return rowYusov3Row;
  993. }
  994. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  995. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  996. public override global::System.Data.DataTable Clone() {
  997. Yusov3DataTable cln = ((Yusov3DataTable)(base.Clone()));
  998. cln.InitVars();
  999. return cln;
  1000. }
  1001. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1002. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1003. protected override global::System.Data.DataTable CreateInstance() {
  1004. return new Yusov3DataTable();
  1005. }
  1006. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1007. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1008. internal void InitVars() {
  1009. this.columnУслуга = base.Columns["Услуга"];
  1010. this.columnНачало_оказания_услуги = base.Columns["Начало_оказания_услуги"];
  1011. this.columnКлиент = base.Columns["Клиент"];
  1012. }
  1013. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1014. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1015. private void InitClass() {
  1016. this.columnУслуга = new global::System.Data.DataColumn("Услуга", typeof(string), null, global::System.Data.MappingType.Element);
  1017. base.Columns.Add(this.columnУслуга);
  1018. this.columnНачало_оказания_услуги = new global::System.Data.DataColumn("Начало_оказания_услуги", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
  1019. base.Columns.Add(this.columnНачало_оказания_услуги);
  1020. this.columnКлиент = new global::System.Data.DataColumn("Клиент", typeof(string), null, global::System.Data.MappingType.Element);
  1021. base.Columns.Add(this.columnКлиент);
  1022. this.columnУслуга.MaxLength = 50;
  1023. this.columnКлиент.MaxLength = 50;
  1024. }
  1025. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1026. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1027. public Yusov3Row NewYusov3Row() {
  1028. return ((Yusov3Row)(this.NewRow()));
  1029. }
  1030. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1031. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1032. protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
  1033. return new Yusov3Row(builder);
  1034. }
  1035. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1036. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1037. protected override global::System.Type GetRowType() {
  1038. return typeof(Yusov3Row);
  1039. }
  1040. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1041. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1042. protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
  1043. base.OnRowChanged(e);
  1044. if ((this.Yusov3RowChanged != null)) {
  1045. this.Yusov3RowChanged(this, new Yusov3RowChangeEvent(((Yusov3Row)(e.Row)), e.Action));
  1046. }
  1047. }
  1048. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1049. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1050. protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
  1051. base.OnRowChanging(e);
  1052. if ((this.Yusov3RowChanging != null)) {
  1053. this.Yusov3RowChanging(this, new Yusov3RowChangeEvent(((Yusov3Row)(e.Row)), e.Action));
  1054. }
  1055. }
  1056. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1057. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1058. protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
  1059. base.OnRowDeleted(e);
  1060. if ((this.Yusov3RowDeleted != null)) {
  1061. this.Yusov3RowDeleted(this, new Yusov3RowChangeEvent(((Yusov3Row)(e.Row)), e.Action));
  1062. }
  1063. }
  1064. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1065. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1066. protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
  1067. base.OnRowDeleting(e);
  1068. if ((this.Yusov3RowDeleting != null)) {
  1069. this.Yusov3RowDeleting(this, new Yusov3RowChangeEvent(((Yusov3Row)(e.Row)), e.Action));
  1070. }
  1071. }
  1072. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1073. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1074. public void RemoveYusov3Row(Yusov3Row row) {
  1075. this.Rows.Remove(row);
  1076. }
  1077. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1078. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1079. public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
  1080. global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
  1081. global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
  1082. _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6 ds = new _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6();
  1083. global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
  1084. any1.Namespace = "http://www.w3.org/2001/XMLSchema";
  1085. any1.MinOccurs = new decimal(0);
  1086. any1.MaxOccurs = decimal.MaxValue;
  1087. any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  1088. sequence.Items.Add(any1);
  1089. global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
  1090. any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  1091. any2.MinOccurs = new decimal(1);
  1092. any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  1093. sequence.Items.Add(any2);
  1094. global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
  1095. attribute1.Name = "namespace";
  1096. attribute1.FixedValue = ds.Namespace;
  1097. type.Attributes.Add(attribute1);
  1098. global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
  1099. attribute2.Name = "tableTypeName";
  1100. attribute2.FixedValue = "Yusov3DataTable";
  1101. type.Attributes.Add(attribute2);
  1102. type.Particle = sequence;
  1103. global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
  1104. if (xs.Contains(dsSchema.TargetNamespace)) {
  1105. global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
  1106. global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
  1107. try {
  1108. global::System.Xml.Schema.XmlSchema schema = null;
  1109. dsSchema.Write(s1);
  1110. for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
  1111. schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
  1112. s2.SetLength(0);
  1113. schema.Write(s2);
  1114. if ((s1.Length == s2.Length)) {
  1115. s1.Position = 0;
  1116. s2.Position = 0;
  1117. for (; ((s1.Position != s1.Length)
  1118. && (s1.ReadByte() == s2.ReadByte())); ) {
  1119. ;
  1120. }
  1121. if ((s1.Position == s1.Length)) {
  1122. return type;
  1123. }
  1124. }
  1125. }
  1126. }
  1127. finally {
  1128. if ((s1 != null)) {
  1129. s1.Close();
  1130. }
  1131. if ((s2 != null)) {
  1132. s2.Close();
  1133. }
  1134. }
  1135. }
  1136. xs.Add(dsSchema);
  1137. return type;
  1138. }
  1139. }
  1140. /// <summary>
  1141. ///Represents strongly named DataRow class.
  1142. ///</summary>
  1143. public partial class yusov1Row : global::System.Data.DataRow {
  1144. private yusov1DataTable tableyusov1;
  1145. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1146. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1147. internal yusov1Row(global::System.Data.DataRowBuilder rb) :
  1148. base(rb) {
  1149. this.tableyusov1 = ((yusov1DataTable)(this.Table));
  1150. }
  1151. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1152. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1153. public string Фамилия {
  1154. get {
  1155. try {
  1156. return ((string)(this[this.tableyusov1.ФамилияColumn]));
  1157. }
  1158. catch (global::System.InvalidCastException e) {
  1159. throw new global::System.Data.StrongTypingException("Значение для столбца \'Фамилия\' в таблице \'yusov1\' равно DBNull.", e);
  1160. }
  1161. }
  1162. set {
  1163. this[this.tableyusov1.ФамилияColumn] = value;
  1164. }
  1165. }
  1166. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1167. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1168. public string Имя {
  1169. get {
  1170. try {
  1171. return ((string)(this[this.tableyusov1.ИмяColumn]));
  1172. }
  1173. catch (global::System.InvalidCastException e) {
  1174. throw new global::System.Data.StrongTypingException("Значение для столбца \'Имя\' в таблице \'yusov1\' равно DBNull.", e);
  1175. }
  1176. }
  1177. set {
  1178. this[this.tableyusov1.ИмяColumn] = value;
  1179. }
  1180. }
  1181. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1182. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1183. public string Отчество {
  1184. get {
  1185. try {
  1186. return ((string)(this[this.tableyusov1.ОтчествоColumn]));
  1187. }
  1188. catch (global::System.InvalidCastException e) {
  1189. throw new global::System.Data.StrongTypingException("Значение для столбца \'Отчество\' в таблице \'yusov1\' равно DBNull.", e);
  1190. }
  1191. }
  1192. set {
  1193. this[this.tableyusov1.ОтчествоColumn] = value;
  1194. }
  1195. }
  1196. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1197. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1198. public string Пол {
  1199. get {
  1200. try {
  1201. return ((string)(this[this.tableyusov1.ПолColumn]));
  1202. }
  1203. catch (global::System.InvalidCastException e) {
  1204. throw new global::System.Data.StrongTypingException("Значение для столбца \'Пол\' в таблице \'yusov1\' равно DBNull.", e);
  1205. }
  1206. }
  1207. set {
  1208. this[this.tableyusov1.ПолColumn] = value;
  1209. }
  1210. }
  1211. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1212. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1213. public string Телефон {
  1214. get {
  1215. try {
  1216. return ((string)(this[this.tableyusov1.ТелефонColumn]));
  1217. }
  1218. catch (global::System.InvalidCastException e) {
  1219. throw new global::System.Data.StrongTypingException("Значение для столбца \'Телефон\' в таблице \'yusov1\' равно DBNull.", e);
  1220. }
  1221. }
  1222. set {
  1223. this[this.tableyusov1.ТелефонColumn] = value;
  1224. }
  1225. }
  1226. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1227. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1228. public System.DateTime Дата_рождения {
  1229. get {
  1230. try {
  1231. return ((global::System.DateTime)(this[this.tableyusov1.Дата_рожденияColumn]));
  1232. }
  1233. catch (global::System.InvalidCastException e) {
  1234. throw new global::System.Data.StrongTypingException("Значение для столбца \'Дата_рождения\' в таблице \'yusov1\' равно DBNull.", e);
  1235. }
  1236. }
  1237. set {
  1238. this[this.tableyusov1.Дата_рожденияColumn] = value;
  1239. }
  1240. }
  1241. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1242. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1243. public string Email {
  1244. get {
  1245. try {
  1246. return ((string)(this[this.tableyusov1.EmailColumn]));
  1247. }
  1248. catch (global::System.InvalidCastException e) {
  1249. throw new global::System.Data.StrongTypingException("Значение для столбца \'Email\' в таблице \'yusov1\' равно DBNull.", e);
  1250. }
  1251. }
  1252. set {
  1253. this[this.tableyusov1.EmailColumn] = value;
  1254. }
  1255. }
  1256. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1257. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1258. public System.DateTime Дата_регистрации {
  1259. get {
  1260. try {
  1261. return ((global::System.DateTime)(this[this.tableyusov1.Дата_регистрацииColumn]));
  1262. }
  1263. catch (global::System.InvalidCastException e) {
  1264. throw new global::System.Data.StrongTypingException("Значение для столбца \'Дата_регистрации\' в таблице \'yusov1\' равно DBNull.", e);
  1265. }
  1266. }
  1267. set {
  1268. this[this.tableyusov1.Дата_регистрацииColumn] = value;
  1269. }
  1270. }
  1271. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1272. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1273. public bool IsФамилияNull() {
  1274. return this.IsNull(this.tableyusov1.ФамилияColumn);
  1275. }
  1276. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1277. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1278. public void SetФамилияNull() {
  1279. this[this.tableyusov1.ФамилияColumn] = global::System.Convert.DBNull;
  1280. }
  1281. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1282. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1283. public bool IsИмяNull() {
  1284. return this.IsNull(this.tableyusov1.ИмяColumn);
  1285. }
  1286. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1287. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1288. public void SetИмяNull() {
  1289. this[this.tableyusov1.ИмяColumn] = global::System.Convert.DBNull;
  1290. }
  1291. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1292. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1293. public bool IsОтчествоNull() {
  1294. return this.IsNull(this.tableyusov1.ОтчествоColumn);
  1295. }
  1296. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1297. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1298. public void SetОтчествоNull() {
  1299. this[this.tableyusov1.ОтчествоColumn] = global::System.Convert.DBNull;
  1300. }
  1301. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1302. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1303. public bool IsПолNull() {
  1304. return this.IsNull(this.tableyusov1.ПолColumn);
  1305. }
  1306. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1307. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1308. public void SetПолNull() {
  1309. this[this.tableyusov1.ПолColumn] = global::System.Convert.DBNull;
  1310. }
  1311. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1312. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1313. public bool IsТелефонNull() {
  1314. return this.IsNull(this.tableyusov1.ТелефонColumn);
  1315. }
  1316. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1317. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1318. public void SetТелефонNull() {
  1319. this[this.tableyusov1.ТелефонColumn] = global::System.Convert.DBNull;
  1320. }
  1321. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1322. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1323. public bool IsДата_рожденияNull() {
  1324. return this.IsNull(this.tableyusov1.Дата_рожденияColumn);
  1325. }
  1326. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1327. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1328. public void SetДата_рожденияNull() {
  1329. this[this.tableyusov1.Дата_рожденияColumn] = global::System.Convert.DBNull;
  1330. }
  1331. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1332. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1333. public bool IsEmailNull() {
  1334. return this.IsNull(this.tableyusov1.EmailColumn);
  1335. }
  1336. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1337. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1338. public void SetEmailNull() {
  1339. this[this.tableyusov1.EmailColumn] = global::System.Convert.DBNull;
  1340. }
  1341. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1342. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1343. public bool IsДата_регистрацииNull() {
  1344. return this.IsNull(this.tableyusov1.Дата_регистрацииColumn);
  1345. }
  1346. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1347. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1348. public void SetДата_регистрацииNull() {
  1349. this[this.tableyusov1.Дата_регистрацииColumn] = global::System.Convert.DBNull;
  1350. }
  1351. }
  1352. /// <summary>
  1353. ///Represents strongly named DataRow class.
  1354. ///</summary>
  1355. public partial class Yusov2Row : global::System.Data.DataRow {
  1356. private Yusov2DataTable tableYusov2;
  1357. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1358. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1359. internal Yusov2Row(global::System.Data.DataRowBuilder rb) :
  1360. base(rb) {
  1361. this.tableYusov2 = ((Yusov2DataTable)(this.Table));
  1362. }
  1363. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1364. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1365. public string Наименование_услуги {
  1366. get {
  1367. try {
  1368. return ((string)(this[this.tableYusov2.Наименование_услугиColumn]));
  1369. }
  1370. catch (global::System.InvalidCastException e) {
  1371. throw new global::System.Data.StrongTypingException("Значение для столбца \'Наименование_услуги\' в таблице \'Yusov2\' равно DBNull.", e);
  1372. }
  1373. }
  1374. set {
  1375. this[this.tableYusov2.Наименование_услугиColumn] = value;
  1376. }
  1377. }
  1378. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1379. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1380. public string Главное_изображение {
  1381. get {
  1382. try {
  1383. return ((string)(this[this.tableYusov2.Главное_изображениеColumn]));
  1384. }
  1385. catch (global::System.InvalidCastException e) {
  1386. throw new global::System.Data.StrongTypingException("Значение для столбца \'Главное_изображение\' в таблице \'Yusov2\' равно DBNull.", e);
  1387. }
  1388. }
  1389. set {
  1390. this[this.tableYusov2.Главное_изображениеColumn] = value;
  1391. }
  1392. }
  1393. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1394. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1395. public string Длительность {
  1396. get {
  1397. try {
  1398. return ((string)(this[this.tableYusov2.ДлительностьColumn]));
  1399. }
  1400. catch (global::System.InvalidCastException e) {
  1401. throw new global::System.Data.StrongTypingException("Значение для столбца \'Длительность\' в таблице \'Yusov2\' равно DBNull.", e);
  1402. }
  1403. }
  1404. set {
  1405. this[this.tableYusov2.ДлительностьColumn] = value;
  1406. }
  1407. }
  1408. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1409. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1410. public string Стоимость {
  1411. get {
  1412. try {
  1413. return ((string)(this[this.tableYusov2.СтоимостьColumn]));
  1414. }
  1415. catch (global::System.InvalidCastException e) {
  1416. throw new global::System.Data.StrongTypingException("Значение для столбца \'Стоимость\' в таблице \'Yusov2\' равно DBNull.", e);
  1417. }
  1418. }
  1419. set {
  1420. this[this.tableYusov2.СтоимостьColumn] = value;
  1421. }
  1422. }
  1423. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1424. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1425. public string Действующая_скидка {
  1426. get {
  1427. try {
  1428. return ((string)(this[this.tableYusov2.Действующая_скидкаColumn]));
  1429. }
  1430. catch (global::System.InvalidCastException e) {
  1431. throw new global::System.Data.StrongTypingException("Значение для столбца \'Действующая_скидка\' в таблице \'Yusov2\' равно DBNull.", e);
  1432. }
  1433. }
  1434. set {
  1435. this[this.tableYusov2.Действующая_скидкаColumn] = value;
  1436. }
  1437. }
  1438. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1439. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1440. public bool IsНаименование_услугиNull() {
  1441. return this.IsNull(this.tableYusov2.Наименование_услугиColumn);
  1442. }
  1443. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1444. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1445. public void SetНаименование_услугиNull() {
  1446. this[this.tableYusov2.Наименование_услугиColumn] = global::System.Convert.DBNull;
  1447. }
  1448. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1449. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1450. public bool IsГлавное_изображениеNull() {
  1451. return this.IsNull(this.tableYusov2.Главное_изображениеColumn);
  1452. }
  1453. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1454. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1455. public void SetГлавное_изображениеNull() {
  1456. this[this.tableYusov2.Главное_изображениеColumn] = global::System.Convert.DBNull;
  1457. }
  1458. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1459. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1460. public bool IsДлительностьNull() {
  1461. return this.IsNull(this.tableYusov2.ДлительностьColumn);
  1462. }
  1463. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1464. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1465. public void SetДлительностьNull() {
  1466. this[this.tableYusov2.ДлительностьColumn] = global::System.Convert.DBNull;
  1467. }
  1468. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1469. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1470. public bool IsСтоимостьNull() {
  1471. return this.IsNull(this.tableYusov2.СтоимостьColumn);
  1472. }
  1473. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1474. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1475. public void SetСтоимостьNull() {
  1476. this[this.tableYusov2.СтоимостьColumn] = global::System.Convert.DBNull;
  1477. }
  1478. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1479. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1480. public bool IsДействующая_скидкаNull() {
  1481. return this.IsNull(this.tableYusov2.Действующая_скидкаColumn);
  1482. }
  1483. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1484. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1485. public void SetДействующая_скидкаNull() {
  1486. this[this.tableYusov2.Действующая_скидкаColumn] = global::System.Convert.DBNull;
  1487. }
  1488. }
  1489. /// <summary>
  1490. ///Represents strongly named DataRow class.
  1491. ///</summary>
  1492. public partial class Yusov3Row : global::System.Data.DataRow {
  1493. private Yusov3DataTable tableYusov3;
  1494. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1495. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1496. internal Yusov3Row(global::System.Data.DataRowBuilder rb) :
  1497. base(rb) {
  1498. this.tableYusov3 = ((Yusov3DataTable)(this.Table));
  1499. }
  1500. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1501. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1502. public string Услуга {
  1503. get {
  1504. try {
  1505. return ((string)(this[this.tableYusov3.УслугаColumn]));
  1506. }
  1507. catch (global::System.InvalidCastException e) {
  1508. throw new global::System.Data.StrongTypingException("Значение для столбца \'Услуга\' в таблице \'Yusov3\' равно DBNull.", e);
  1509. }
  1510. }
  1511. set {
  1512. this[this.tableYusov3.УслугаColumn] = value;
  1513. }
  1514. }
  1515. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1516. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1517. public System.DateTime Начало_оказания_услуги {
  1518. get {
  1519. try {
  1520. return ((global::System.DateTime)(this[this.tableYusov3.Начало_оказания_услугиColumn]));
  1521. }
  1522. catch (global::System.InvalidCastException e) {
  1523. throw new global::System.Data.StrongTypingException("Значение для столбца \'Начало_оказания_услуги\' в таблице \'Yusov3\' равно DBNull.", e);
  1524. }
  1525. }
  1526. set {
  1527. this[this.tableYusov3.Начало_оказания_услугиColumn] = value;
  1528. }
  1529. }
  1530. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1531. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1532. public string Клиент {
  1533. get {
  1534. try {
  1535. return ((string)(this[this.tableYusov3.КлиентColumn]));
  1536. }
  1537. catch (global::System.InvalidCastException e) {
  1538. throw new global::System.Data.StrongTypingException("Значение для столбца \'Клиент\' в таблице \'Yusov3\' равно DBNull.", e);
  1539. }
  1540. }
  1541. set {
  1542. this[this.tableYusov3.КлиентColumn] = value;
  1543. }
  1544. }
  1545. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1546. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1547. public bool IsУслугаNull() {
  1548. return this.IsNull(this.tableYusov3.УслугаColumn);
  1549. }
  1550. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1551. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1552. public void SetУслугаNull() {
  1553. this[this.tableYusov3.УслугаColumn] = global::System.Convert.DBNull;
  1554. }
  1555. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1556. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1557. public bool IsНачало_оказания_услугиNull() {
  1558. return this.IsNull(this.tableYusov3.Начало_оказания_услугиColumn);
  1559. }
  1560. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1561. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1562. public void SetНачало_оказания_услугиNull() {
  1563. this[this.tableYusov3.Начало_оказания_услугиColumn] = global::System.Convert.DBNull;
  1564. }
  1565. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1566. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1567. public bool IsКлиентNull() {
  1568. return this.IsNull(this.tableYusov3.КлиентColumn);
  1569. }
  1570. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1571. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1572. public void SetКлиентNull() {
  1573. this[this.tableYusov3.КлиентColumn] = global::System.Convert.DBNull;
  1574. }
  1575. }
  1576. /// <summary>
  1577. ///Row event argument class
  1578. ///</summary>
  1579. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1580. public class yusov1RowChangeEvent : global::System.EventArgs {
  1581. private yusov1Row eventRow;
  1582. private global::System.Data.DataRowAction eventAction;
  1583. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1584. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1585. public yusov1RowChangeEvent(yusov1Row row, global::System.Data.DataRowAction action) {
  1586. this.eventRow = row;
  1587. this.eventAction = action;
  1588. }
  1589. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1590. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1591. public yusov1Row Row {
  1592. get {
  1593. return this.eventRow;
  1594. }
  1595. }
  1596. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1597. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1598. public global::System.Data.DataRowAction Action {
  1599. get {
  1600. return this.eventAction;
  1601. }
  1602. }
  1603. }
  1604. /// <summary>
  1605. ///Row event argument class
  1606. ///</summary>
  1607. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1608. public class Yusov2RowChangeEvent : global::System.EventArgs {
  1609. private Yusov2Row eventRow;
  1610. private global::System.Data.DataRowAction eventAction;
  1611. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1612. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1613. public Yusov2RowChangeEvent(Yusov2Row row, global::System.Data.DataRowAction action) {
  1614. this.eventRow = row;
  1615. this.eventAction = action;
  1616. }
  1617. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1618. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1619. public Yusov2Row Row {
  1620. get {
  1621. return this.eventRow;
  1622. }
  1623. }
  1624. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1625. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1626. public global::System.Data.DataRowAction Action {
  1627. get {
  1628. return this.eventAction;
  1629. }
  1630. }
  1631. }
  1632. /// <summary>
  1633. ///Row event argument class
  1634. ///</summary>
  1635. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1636. public class Yusov3RowChangeEvent : global::System.EventArgs {
  1637. private Yusov3Row eventRow;
  1638. private global::System.Data.DataRowAction eventAction;
  1639. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1640. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1641. public Yusov3RowChangeEvent(Yusov3Row row, global::System.Data.DataRowAction action) {
  1642. this.eventRow = row;
  1643. this.eventAction = action;
  1644. }
  1645. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1646. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1647. public Yusov3Row Row {
  1648. get {
  1649. return this.eventRow;
  1650. }
  1651. }
  1652. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1653. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1654. public global::System.Data.DataRowAction Action {
  1655. get {
  1656. return this.eventAction;
  1657. }
  1658. }
  1659. }
  1660. }
  1661. }
  1662. namespace Юсову_Владислав_ИСП_11._18._3._Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6TableAdapters {
  1663. /// <summary>
  1664. ///Represents the connection and commands used to retrieve and save data.
  1665. ///</summary>
  1666. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  1667. [global::System.ComponentModel.ToolboxItem(true)]
  1668. [global::System.ComponentModel.DataObjectAttribute(true)]
  1669. [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
  1670. ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
  1671. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1672. public partial class yusov1TableAdapter : global::System.ComponentModel.Component {
  1673. private global::System.Data.SqlClient.SqlDataAdapter _adapter;
  1674. private global::System.Data.SqlClient.SqlConnection _connection;
  1675. private global::System.Data.SqlClient.SqlTransaction _transaction;
  1676. private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
  1677. private bool _clearBeforeFill;
  1678. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1679. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1680. public yusov1TableAdapter() {
  1681. this.ClearBeforeFill = true;
  1682. }
  1683. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1684. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1685. protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
  1686. get {
  1687. if ((this._adapter == null)) {
  1688. this.InitAdapter();
  1689. }
  1690. return this._adapter;
  1691. }
  1692. }
  1693. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1694. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1695. internal global::System.Data.SqlClient.SqlConnection Connection {
  1696. get {
  1697. if ((this._connection == null)) {
  1698. this.InitConnection();
  1699. }
  1700. return this._connection;
  1701. }
  1702. set {
  1703. this._connection = value;
  1704. if ((this.Adapter.InsertCommand != null)) {
  1705. this.Adapter.InsertCommand.Connection = value;
  1706. }
  1707. if ((this.Adapter.DeleteCommand != null)) {
  1708. this.Adapter.DeleteCommand.Connection = value;
  1709. }
  1710. if ((this.Adapter.UpdateCommand != null)) {
  1711. this.Adapter.UpdateCommand.Connection = value;
  1712. }
  1713. for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  1714. if ((this.CommandCollection[i] != null)) {
  1715. ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
  1716. }
  1717. }
  1718. }
  1719. }
  1720. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1721. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1722. internal global::System.Data.SqlClient.SqlTransaction Transaction {
  1723. get {
  1724. return this._transaction;
  1725. }
  1726. set {
  1727. this._transaction = value;
  1728. for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  1729. this.CommandCollection[i].Transaction = this._transaction;
  1730. }
  1731. if (((this.Adapter != null)
  1732. && (this.Adapter.DeleteCommand != null))) {
  1733. this.Adapter.DeleteCommand.Transaction = this._transaction;
  1734. }
  1735. if (((this.Adapter != null)
  1736. && (this.Adapter.InsertCommand != null))) {
  1737. this.Adapter.InsertCommand.Transaction = this._transaction;
  1738. }
  1739. if (((this.Adapter != null)
  1740. && (this.Adapter.UpdateCommand != null))) {
  1741. this.Adapter.UpdateCommand.Transaction = this._transaction;
  1742. }
  1743. }
  1744. }
  1745. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1746. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1747. protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
  1748. get {
  1749. if ((this._commandCollection == null)) {
  1750. this.InitCommandCollection();
  1751. }
  1752. return this._commandCollection;
  1753. }
  1754. }
  1755. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1756. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1757. public bool ClearBeforeFill {
  1758. get {
  1759. return this._clearBeforeFill;
  1760. }
  1761. set {
  1762. this._clearBeforeFill = value;
  1763. }
  1764. }
  1765. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1766. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1767. private void InitAdapter() {
  1768. this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
  1769. global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
  1770. tableMapping.SourceTable = "Table";
  1771. tableMapping.DataSetTable = "yusov1";
  1772. tableMapping.ColumnMappings.Add("Фамилия", "Фамилия");
  1773. tableMapping.ColumnMappings.Add("Имя", "Имя");
  1774. tableMapping.ColumnMappings.Add("Отчество", "Отчество");
  1775. tableMapping.ColumnMappings.Add("Пол", "Пол");
  1776. tableMapping.ColumnMappings.Add("Телефон", "Телефон");
  1777. tableMapping.ColumnMappings.Add("Дата_рождения", "Дата_рождения");
  1778. tableMapping.ColumnMappings.Add("Email", "Email");
  1779. tableMapping.ColumnMappings.Add("Дата_регистрации", "Дата_регистрации");
  1780. this._adapter.TableMappings.Add(tableMapping);
  1781. this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
  1782. this._adapter.InsertCommand.Connection = this.Connection;
  1783. this._adapter.InsertCommand.CommandText = "INSERT INTO [dbo].[yusov1] ([Фамилия], [Имя], [Отчество], [Пол], [Телефон], [Дата" +
  1784. "_рождения], [Email], [Дата_регистрации]) VALUES (@Фамилия, @Имя, @Отчество, @Пол" +
  1785. ", @Телефон, @Дата_рождения, @Email, @Дата_регистрации)";
  1786. this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
  1787. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Фамилия", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Фамилия", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  1788. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Имя", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Имя", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  1789. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Отчество", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Отчество", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  1790. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Пол", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Пол", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  1791. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Телефон", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Телефон", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  1792. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Дата_рождения", global::System.Data.SqlDbType.DateTime2, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Дата_рождения", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  1793. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Email", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Email", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  1794. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Дата_регистрации", global::System.Data.SqlDbType.DateTime2, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Дата_регистрации", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  1795. }
  1796. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1797. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1798. private void InitConnection() {
  1799. this._connection = new global::System.Data.SqlClient.SqlConnection();
  1800. this._connection.ConnectionString = global::Юсову_Владислав_ИСП_11._18._3.Properties.Settings.Default.Юсов_Владислав_Сергеевич_ИСП_11_18_3ConnectionString;
  1801. }
  1802. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1803. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1804. private void InitCommandCollection() {
  1805. this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
  1806. this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
  1807. this._commandCollection[0].Connection = this.Connection;
  1808. this._commandCollection[0].CommandText = "SELECT Фамилия, Имя, Отчество, Пол, Телефон, Дата_рождения, Email, Дата_регистрац" +
  1809. "ии FROM dbo.yusov1";
  1810. this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
  1811. }
  1812. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1813. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1814. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1815. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
  1816. public virtual int Fill(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.yusov1DataTable dataTable) {
  1817. this.Adapter.SelectCommand = this.CommandCollection[0];
  1818. if ((this.ClearBeforeFill == true)) {
  1819. dataTable.Clear();
  1820. }
  1821. int returnValue = this.Adapter.Fill(dataTable);
  1822. return returnValue;
  1823. }
  1824. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1825. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1826. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1827. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
  1828. public virtual _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.yusov1DataTable GetData() {
  1829. this.Adapter.SelectCommand = this.CommandCollection[0];
  1830. _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.yusov1DataTable dataTable = new _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.yusov1DataTable();
  1831. this.Adapter.Fill(dataTable);
  1832. return dataTable;
  1833. }
  1834. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1835. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1836. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1837. public virtual int Update(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.yusov1DataTable dataTable) {
  1838. return this.Adapter.Update(dataTable);
  1839. }
  1840. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1841. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1842. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1843. public virtual int Update(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6 dataSet) {
  1844. return this.Adapter.Update(dataSet, "yusov1");
  1845. }
  1846. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1847. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1848. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1849. public virtual int Update(global::System.Data.DataRow dataRow) {
  1850. return this.Adapter.Update(new global::System.Data.DataRow[] {
  1851. dataRow});
  1852. }
  1853. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1854. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1855. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1856. public virtual int Update(global::System.Data.DataRow[] dataRows) {
  1857. return this.Adapter.Update(dataRows);
  1858. }
  1859. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1860. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1861. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1862. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
  1863. public virtual int Insert(string Фамилия, string Имя, string Отчество, string Пол, string Телефон, global::System.Nullable<global::System.DateTime> Дата_рождения, string Email, global::System.Nullable<global::System.DateTime> Дата_регистрации) {
  1864. if ((Фамилия == null)) {
  1865. this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;
  1866. }
  1867. else {
  1868. this.Adapter.InsertCommand.Parameters[0].Value = ((string)(Фамилия));
  1869. }
  1870. if ((Имя == null)) {
  1871. this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
  1872. }
  1873. else {
  1874. this.Adapter.InsertCommand.Parameters[1].Value = ((string)(Имя));
  1875. }
  1876. if ((Отчество == null)) {
  1877. this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
  1878. }
  1879. else {
  1880. this.Adapter.InsertCommand.Parameters[2].Value = ((string)(Отчество));
  1881. }
  1882. if ((Пол == null)) {
  1883. this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
  1884. }
  1885. else {
  1886. this.Adapter.InsertCommand.Parameters[3].Value = ((string)(Пол));
  1887. }
  1888. if ((Телефон == null)) {
  1889. this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
  1890. }
  1891. else {
  1892. this.Adapter.InsertCommand.Parameters[4].Value = ((string)(Телефон));
  1893. }
  1894. if ((Дата_рождения.HasValue == true)) {
  1895. this.Adapter.InsertCommand.Parameters[5].Value = ((System.DateTime)(Дата_рождения.Value));
  1896. }
  1897. else {
  1898. this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
  1899. }
  1900. if ((Email == null)) {
  1901. this.Adapter.InsertCommand.Parameters[6].Value = global::System.DBNull.Value;
  1902. }
  1903. else {
  1904. this.Adapter.InsertCommand.Parameters[6].Value = ((string)(Email));
  1905. }
  1906. if ((Дата_регистрации.HasValue == true)) {
  1907. this.Adapter.InsertCommand.Parameters[7].Value = ((System.DateTime)(Дата_регистрации.Value));
  1908. }
  1909. else {
  1910. this.Adapter.InsertCommand.Parameters[7].Value = global::System.DBNull.Value;
  1911. }
  1912. global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
  1913. if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
  1914. != global::System.Data.ConnectionState.Open)) {
  1915. this.Adapter.InsertCommand.Connection.Open();
  1916. }
  1917. try {
  1918. int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
  1919. return returnValue;
  1920. }
  1921. finally {
  1922. if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
  1923. this.Adapter.InsertCommand.Connection.Close();
  1924. }
  1925. }
  1926. }
  1927. }
  1928. /// <summary>
  1929. ///Represents the connection and commands used to retrieve and save data.
  1930. ///</summary>
  1931. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  1932. [global::System.ComponentModel.ToolboxItem(true)]
  1933. [global::System.ComponentModel.DataObjectAttribute(true)]
  1934. [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
  1935. ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
  1936. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1937. public partial class Yusov2TableAdapter : global::System.ComponentModel.Component {
  1938. private global::System.Data.SqlClient.SqlDataAdapter _adapter;
  1939. private global::System.Data.SqlClient.SqlConnection _connection;
  1940. private global::System.Data.SqlClient.SqlTransaction _transaction;
  1941. private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
  1942. private bool _clearBeforeFill;
  1943. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1944. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1945. public Yusov2TableAdapter() {
  1946. this.ClearBeforeFill = true;
  1947. }
  1948. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1949. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1950. protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
  1951. get {
  1952. if ((this._adapter == null)) {
  1953. this.InitAdapter();
  1954. }
  1955. return this._adapter;
  1956. }
  1957. }
  1958. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1959. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1960. internal global::System.Data.SqlClient.SqlConnection Connection {
  1961. get {
  1962. if ((this._connection == null)) {
  1963. this.InitConnection();
  1964. }
  1965. return this._connection;
  1966. }
  1967. set {
  1968. this._connection = value;
  1969. if ((this.Adapter.InsertCommand != null)) {
  1970. this.Adapter.InsertCommand.Connection = value;
  1971. }
  1972. if ((this.Adapter.DeleteCommand != null)) {
  1973. this.Adapter.DeleteCommand.Connection = value;
  1974. }
  1975. if ((this.Adapter.UpdateCommand != null)) {
  1976. this.Adapter.UpdateCommand.Connection = value;
  1977. }
  1978. for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  1979. if ((this.CommandCollection[i] != null)) {
  1980. ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
  1981. }
  1982. }
  1983. }
  1984. }
  1985. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1986. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  1987. internal global::System.Data.SqlClient.SqlTransaction Transaction {
  1988. get {
  1989. return this._transaction;
  1990. }
  1991. set {
  1992. this._transaction = value;
  1993. for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  1994. this.CommandCollection[i].Transaction = this._transaction;
  1995. }
  1996. if (((this.Adapter != null)
  1997. && (this.Adapter.DeleteCommand != null))) {
  1998. this.Adapter.DeleteCommand.Transaction = this._transaction;
  1999. }
  2000. if (((this.Adapter != null)
  2001. && (this.Adapter.InsertCommand != null))) {
  2002. this.Adapter.InsertCommand.Transaction = this._transaction;
  2003. }
  2004. if (((this.Adapter != null)
  2005. && (this.Adapter.UpdateCommand != null))) {
  2006. this.Adapter.UpdateCommand.Transaction = this._transaction;
  2007. }
  2008. }
  2009. }
  2010. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2011. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2012. protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
  2013. get {
  2014. if ((this._commandCollection == null)) {
  2015. this.InitCommandCollection();
  2016. }
  2017. return this._commandCollection;
  2018. }
  2019. }
  2020. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2021. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2022. public bool ClearBeforeFill {
  2023. get {
  2024. return this._clearBeforeFill;
  2025. }
  2026. set {
  2027. this._clearBeforeFill = value;
  2028. }
  2029. }
  2030. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2031. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2032. private void InitAdapter() {
  2033. this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
  2034. global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
  2035. tableMapping.SourceTable = "Table";
  2036. tableMapping.DataSetTable = "Yusov2";
  2037. tableMapping.ColumnMappings.Add("Наименование_услуги", "Наименование_услуги");
  2038. tableMapping.ColumnMappings.Add("Главное_изображение", "Главное_изображение");
  2039. tableMapping.ColumnMappings.Add("Длительность", "Длительность");
  2040. tableMapping.ColumnMappings.Add("Стоимость", "Стоимость");
  2041. tableMapping.ColumnMappings.Add("Действующая_скидка", "Действующая_скидка");
  2042. this._adapter.TableMappings.Add(tableMapping);
  2043. this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
  2044. this._adapter.InsertCommand.Connection = this.Connection;
  2045. this._adapter.InsertCommand.CommandText = "INSERT INTO [dbo].[Yusov2] ([Наименование_услуги], [Главное_изображение], [Длител" +
  2046. "ьность], [Стоимость], [Действующая_скидка]) VALUES (@Наименование_услуги, @Главн" +
  2047. "ое_изображение, @Длительность, @Стоимость, @Действующая_скидка)";
  2048. this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
  2049. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Наименование_услуги", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Наименование_услуги", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  2050. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Главное_изображение", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Главное_изображение", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  2051. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Длительность", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Длительность", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  2052. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Стоимость", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Стоимость", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  2053. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Действующая_скидка", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Действующая_скидка", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  2054. }
  2055. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2056. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2057. private void InitConnection() {
  2058. this._connection = new global::System.Data.SqlClient.SqlConnection();
  2059. this._connection.ConnectionString = global::Юсову_Владислав_ИСП_11._18._3.Properties.Settings.Default.Юсов_Владислав_Сергеевич_ИСП_11_18_3ConnectionString;
  2060. }
  2061. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2062. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2063. private void InitCommandCollection() {
  2064. this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
  2065. this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
  2066. this._commandCollection[0].Connection = this.Connection;
  2067. this._commandCollection[0].CommandText = "SELECT Наименование_услуги, Главное_изображение, Длительность, Стоимость, Действу" +
  2068. "ющая_скидка FROM dbo.Yusov2";
  2069. this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
  2070. }
  2071. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2072. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2073. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2074. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
  2075. public virtual int Fill(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.Yusov2DataTable dataTable) {
  2076. this.Adapter.SelectCommand = this.CommandCollection[0];
  2077. if ((this.ClearBeforeFill == true)) {
  2078. dataTable.Clear();
  2079. }
  2080. int returnValue = this.Adapter.Fill(dataTable);
  2081. return returnValue;
  2082. }
  2083. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2084. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2085. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2086. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
  2087. public virtual _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.Yusov2DataTable GetData() {
  2088. this.Adapter.SelectCommand = this.CommandCollection[0];
  2089. _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.Yusov2DataTable dataTable = new _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.Yusov2DataTable();
  2090. this.Adapter.Fill(dataTable);
  2091. return dataTable;
  2092. }
  2093. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2094. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2095. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2096. public virtual int Update(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.Yusov2DataTable dataTable) {
  2097. return this.Adapter.Update(dataTable);
  2098. }
  2099. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2100. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2101. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2102. public virtual int Update(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6 dataSet) {
  2103. return this.Adapter.Update(dataSet, "Yusov2");
  2104. }
  2105. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2106. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2107. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2108. public virtual int Update(global::System.Data.DataRow dataRow) {
  2109. return this.Adapter.Update(new global::System.Data.DataRow[] {
  2110. dataRow});
  2111. }
  2112. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2113. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2114. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2115. public virtual int Update(global::System.Data.DataRow[] dataRows) {
  2116. return this.Adapter.Update(dataRows);
  2117. }
  2118. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2119. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2120. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2121. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
  2122. public virtual int Insert(string Наименование_услуги, string Главное_изображение, string Длительность, string Стоимость, string Действующая_скидка) {
  2123. if ((Наименование_услуги == null)) {
  2124. this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;
  2125. }
  2126. else {
  2127. this.Adapter.InsertCommand.Parameters[0].Value = ((string)(Наименование_услуги));
  2128. }
  2129. if ((Главное_изображение == null)) {
  2130. this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
  2131. }
  2132. else {
  2133. this.Adapter.InsertCommand.Parameters[1].Value = ((string)(Главное_изображение));
  2134. }
  2135. if ((Длительность == null)) {
  2136. this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
  2137. }
  2138. else {
  2139. this.Adapter.InsertCommand.Parameters[2].Value = ((string)(Длительность));
  2140. }
  2141. if ((Стоимость == null)) {
  2142. this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
  2143. }
  2144. else {
  2145. this.Adapter.InsertCommand.Parameters[3].Value = ((string)(Стоимость));
  2146. }
  2147. if ((Действующая_скидка == null)) {
  2148. this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
  2149. }
  2150. else {
  2151. this.Adapter.InsertCommand.Parameters[4].Value = ((string)(Действующая_скидка));
  2152. }
  2153. global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
  2154. if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
  2155. != global::System.Data.ConnectionState.Open)) {
  2156. this.Adapter.InsertCommand.Connection.Open();
  2157. }
  2158. try {
  2159. int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
  2160. return returnValue;
  2161. }
  2162. finally {
  2163. if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
  2164. this.Adapter.InsertCommand.Connection.Close();
  2165. }
  2166. }
  2167. }
  2168. }
  2169. /// <summary>
  2170. ///Represents the connection and commands used to retrieve and save data.
  2171. ///</summary>
  2172. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  2173. [global::System.ComponentModel.ToolboxItem(true)]
  2174. [global::System.ComponentModel.DataObjectAttribute(true)]
  2175. [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
  2176. ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
  2177. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2178. public partial class Yusov3TableAdapter : global::System.ComponentModel.Component {
  2179. private global::System.Data.SqlClient.SqlDataAdapter _adapter;
  2180. private global::System.Data.SqlClient.SqlConnection _connection;
  2181. private global::System.Data.SqlClient.SqlTransaction _transaction;
  2182. private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
  2183. private bool _clearBeforeFill;
  2184. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2185. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2186. public Yusov3TableAdapter() {
  2187. this.ClearBeforeFill = true;
  2188. }
  2189. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2190. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2191. protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
  2192. get {
  2193. if ((this._adapter == null)) {
  2194. this.InitAdapter();
  2195. }
  2196. return this._adapter;
  2197. }
  2198. }
  2199. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2200. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2201. internal global::System.Data.SqlClient.SqlConnection Connection {
  2202. get {
  2203. if ((this._connection == null)) {
  2204. this.InitConnection();
  2205. }
  2206. return this._connection;
  2207. }
  2208. set {
  2209. this._connection = value;
  2210. if ((this.Adapter.InsertCommand != null)) {
  2211. this.Adapter.InsertCommand.Connection = value;
  2212. }
  2213. if ((this.Adapter.DeleteCommand != null)) {
  2214. this.Adapter.DeleteCommand.Connection = value;
  2215. }
  2216. if ((this.Adapter.UpdateCommand != null)) {
  2217. this.Adapter.UpdateCommand.Connection = value;
  2218. }
  2219. for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  2220. if ((this.CommandCollection[i] != null)) {
  2221. ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
  2222. }
  2223. }
  2224. }
  2225. }
  2226. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2227. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2228. internal global::System.Data.SqlClient.SqlTransaction Transaction {
  2229. get {
  2230. return this._transaction;
  2231. }
  2232. set {
  2233. this._transaction = value;
  2234. for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  2235. this.CommandCollection[i].Transaction = this._transaction;
  2236. }
  2237. if (((this.Adapter != null)
  2238. && (this.Adapter.DeleteCommand != null))) {
  2239. this.Adapter.DeleteCommand.Transaction = this._transaction;
  2240. }
  2241. if (((this.Adapter != null)
  2242. && (this.Adapter.InsertCommand != null))) {
  2243. this.Adapter.InsertCommand.Transaction = this._transaction;
  2244. }
  2245. if (((this.Adapter != null)
  2246. && (this.Adapter.UpdateCommand != null))) {
  2247. this.Adapter.UpdateCommand.Transaction = this._transaction;
  2248. }
  2249. }
  2250. }
  2251. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2252. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2253. protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
  2254. get {
  2255. if ((this._commandCollection == null)) {
  2256. this.InitCommandCollection();
  2257. }
  2258. return this._commandCollection;
  2259. }
  2260. }
  2261. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2262. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2263. public bool ClearBeforeFill {
  2264. get {
  2265. return this._clearBeforeFill;
  2266. }
  2267. set {
  2268. this._clearBeforeFill = value;
  2269. }
  2270. }
  2271. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2272. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2273. private void InitAdapter() {
  2274. this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
  2275. global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
  2276. tableMapping.SourceTable = "Table";
  2277. tableMapping.DataSetTable = "Yusov3";
  2278. tableMapping.ColumnMappings.Add("Услуга", "Услуга");
  2279. tableMapping.ColumnMappings.Add("Начало_оказания_услуги", "Начало_оказания_услуги");
  2280. tableMapping.ColumnMappings.Add("Клиент", "Клиент");
  2281. this._adapter.TableMappings.Add(tableMapping);
  2282. this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
  2283. this._adapter.InsertCommand.Connection = this.Connection;
  2284. this._adapter.InsertCommand.CommandText = "INSERT INTO [dbo].[Yusov3] ([Услуга], [Начало_оказания_услуги], [Клиент]) VALUES " +
  2285. "(@Услуга, @Начало_оказания_услуги, @Клиент)";
  2286. this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
  2287. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Услуга", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Услуга", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  2288. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Начало_оказания_услуги", global::System.Data.SqlDbType.DateTime2, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Начало_оказания_услуги", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  2289. this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Клиент", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Клиент", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
  2290. }
  2291. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2292. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2293. private void InitConnection() {
  2294. this._connection = new global::System.Data.SqlClient.SqlConnection();
  2295. this._connection.ConnectionString = global::Юсову_Владислав_ИСП_11._18._3.Properties.Settings.Default.Юсов_Владислав_Сергеевич_ИСП_11_18_3ConnectionString;
  2296. }
  2297. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2298. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2299. private void InitCommandCollection() {
  2300. this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
  2301. this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
  2302. this._commandCollection[0].Connection = this.Connection;
  2303. this._commandCollection[0].CommandText = "SELECT Услуга, Начало_оказания_услуги, Клиент FROM dbo.Yusov3";
  2304. this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
  2305. }
  2306. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2307. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2308. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2309. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
  2310. public virtual int Fill(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.Yusov3DataTable dataTable) {
  2311. this.Adapter.SelectCommand = this.CommandCollection[0];
  2312. if ((this.ClearBeforeFill == true)) {
  2313. dataTable.Clear();
  2314. }
  2315. int returnValue = this.Adapter.Fill(dataTable);
  2316. return returnValue;
  2317. }
  2318. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2319. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2320. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2321. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
  2322. public virtual _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.Yusov3DataTable GetData() {
  2323. this.Adapter.SelectCommand = this.CommandCollection[0];
  2324. _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.Yusov3DataTable dataTable = new _Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.Yusov3DataTable();
  2325. this.Adapter.Fill(dataTable);
  2326. return dataTable;
  2327. }
  2328. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2329. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2330. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2331. public virtual int Update(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6.Yusov3DataTable dataTable) {
  2332. return this.Adapter.Update(dataTable);
  2333. }
  2334. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2335. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2336. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2337. public virtual int Update(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6 dataSet) {
  2338. return this.Adapter.Update(dataSet, "Yusov3");
  2339. }
  2340. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2341. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2342. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2343. public virtual int Update(global::System.Data.DataRow dataRow) {
  2344. return this.Adapter.Update(new global::System.Data.DataRow[] {
  2345. dataRow});
  2346. }
  2347. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2348. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2349. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2350. public virtual int Update(global::System.Data.DataRow[] dataRows) {
  2351. return this.Adapter.Update(dataRows);
  2352. }
  2353. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2354. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2355. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  2356. [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
  2357. public virtual int Insert(string Услуга, global::System.Nullable<global::System.DateTime> Начало_оказания_услуги, string Клиент) {
  2358. if ((Услуга == null)) {
  2359. this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;
  2360. }
  2361. else {
  2362. this.Adapter.InsertCommand.Parameters[0].Value = ((string)(Услуга));
  2363. }
  2364. if ((Начало_оказания_услуги.HasValue == true)) {
  2365. this.Adapter.InsertCommand.Parameters[1].Value = ((System.DateTime)(Начало_оказания_услуги.Value));
  2366. }
  2367. else {
  2368. this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
  2369. }
  2370. if ((Клиент == null)) {
  2371. this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
  2372. }
  2373. else {
  2374. this.Adapter.InsertCommand.Parameters[2].Value = ((string)(Клиент));
  2375. }
  2376. global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
  2377. if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
  2378. != global::System.Data.ConnectionState.Open)) {
  2379. this.Adapter.InsertCommand.Connection.Open();
  2380. }
  2381. try {
  2382. int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
  2383. return returnValue;
  2384. }
  2385. finally {
  2386. if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
  2387. this.Adapter.InsertCommand.Connection.Close();
  2388. }
  2389. }
  2390. }
  2391. }
  2392. /// <summary>
  2393. ///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
  2394. ///</summary>
  2395. [global::System.ComponentModel.DesignerCategoryAttribute("code")]
  2396. [global::System.ComponentModel.ToolboxItem(true)]
  2397. [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
  2398. "esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
  2399. [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
  2400. public partial class TableAdapterManager : global::System.ComponentModel.Component {
  2401. private UpdateOrderOption _updateOrder;
  2402. private yusov1TableAdapter _yusov1TableAdapter;
  2403. private Yusov2TableAdapter _yusov2TableAdapter;
  2404. private Yusov3TableAdapter _yusov3TableAdapter;
  2405. private bool _backupDataSetBeforeUpdate;
  2406. private global::System.Data.IDbConnection _connection;
  2407. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2408. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2409. public UpdateOrderOption UpdateOrder {
  2410. get {
  2411. return this._updateOrder;
  2412. }
  2413. set {
  2414. this._updateOrder = value;
  2415. }
  2416. }
  2417. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2418. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2419. [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
  2420. "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
  2421. "a", "System.Drawing.Design.UITypeEditor")]
  2422. public yusov1TableAdapter yusov1TableAdapter {
  2423. get {
  2424. return this._yusov1TableAdapter;
  2425. }
  2426. set {
  2427. this._yusov1TableAdapter = value;
  2428. }
  2429. }
  2430. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2431. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2432. [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
  2433. "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
  2434. "a", "System.Drawing.Design.UITypeEditor")]
  2435. public Yusov2TableAdapter Yusov2TableAdapter {
  2436. get {
  2437. return this._yusov2TableAdapter;
  2438. }
  2439. set {
  2440. this._yusov2TableAdapter = value;
  2441. }
  2442. }
  2443. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2444. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2445. [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
  2446. "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
  2447. "a", "System.Drawing.Design.UITypeEditor")]
  2448. public Yusov3TableAdapter Yusov3TableAdapter {
  2449. get {
  2450. return this._yusov3TableAdapter;
  2451. }
  2452. set {
  2453. this._yusov3TableAdapter = value;
  2454. }
  2455. }
  2456. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2457. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2458. public bool BackupDataSetBeforeUpdate {
  2459. get {
  2460. return this._backupDataSetBeforeUpdate;
  2461. }
  2462. set {
  2463. this._backupDataSetBeforeUpdate = value;
  2464. }
  2465. }
  2466. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2467. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2468. [global::System.ComponentModel.Browsable(false)]
  2469. public global::System.Data.IDbConnection Connection {
  2470. get {
  2471. if ((this._connection != null)) {
  2472. return this._connection;
  2473. }
  2474. if (((this._yusov1TableAdapter != null)
  2475. && (this._yusov1TableAdapter.Connection != null))) {
  2476. return this._yusov1TableAdapter.Connection;
  2477. }
  2478. if (((this._yusov2TableAdapter != null)
  2479. && (this._yusov2TableAdapter.Connection != null))) {
  2480. return this._yusov2TableAdapter.Connection;
  2481. }
  2482. if (((this._yusov3TableAdapter != null)
  2483. && (this._yusov3TableAdapter.Connection != null))) {
  2484. return this._yusov3TableAdapter.Connection;
  2485. }
  2486. return null;
  2487. }
  2488. set {
  2489. this._connection = value;
  2490. }
  2491. }
  2492. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2493. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2494. [global::System.ComponentModel.Browsable(false)]
  2495. public int TableAdapterInstanceCount {
  2496. get {
  2497. int count = 0;
  2498. if ((this._yusov1TableAdapter != null)) {
  2499. count = (count + 1);
  2500. }
  2501. if ((this._yusov2TableAdapter != null)) {
  2502. count = (count + 1);
  2503. }
  2504. if ((this._yusov3TableAdapter != null)) {
  2505. count = (count + 1);
  2506. }
  2507. return count;
  2508. }
  2509. }
  2510. /// <summary>
  2511. ///Update rows in top-down order.
  2512. ///</summary>
  2513. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2514. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2515. private int UpdateUpdatedRows(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  2516. int result = 0;
  2517. if ((this._yusov1TableAdapter != null)) {
  2518. global::System.Data.DataRow[] updatedRows = dataSet.yusov1.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
  2519. updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
  2520. if (((updatedRows != null)
  2521. && (0 < updatedRows.Length))) {
  2522. result = (result + this._yusov1TableAdapter.Update(updatedRows));
  2523. allChangedRows.AddRange(updatedRows);
  2524. }
  2525. }
  2526. if ((this._yusov2TableAdapter != null)) {
  2527. global::System.Data.DataRow[] updatedRows = dataSet.Yusov2.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
  2528. updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
  2529. if (((updatedRows != null)
  2530. && (0 < updatedRows.Length))) {
  2531. result = (result + this._yusov2TableAdapter.Update(updatedRows));
  2532. allChangedRows.AddRange(updatedRows);
  2533. }
  2534. }
  2535. if ((this._yusov3TableAdapter != null)) {
  2536. global::System.Data.DataRow[] updatedRows = dataSet.Yusov3.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
  2537. updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
  2538. if (((updatedRows != null)
  2539. && (0 < updatedRows.Length))) {
  2540. result = (result + this._yusov3TableAdapter.Update(updatedRows));
  2541. allChangedRows.AddRange(updatedRows);
  2542. }
  2543. }
  2544. return result;
  2545. }
  2546. /// <summary>
  2547. ///Insert rows in top-down order.
  2548. ///</summary>
  2549. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2550. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2551. private int UpdateInsertedRows(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  2552. int result = 0;
  2553. if ((this._yusov1TableAdapter != null)) {
  2554. global::System.Data.DataRow[] addedRows = dataSet.yusov1.Select(null, null, global::System.Data.DataViewRowState.Added);
  2555. if (((addedRows != null)
  2556. && (0 < addedRows.Length))) {
  2557. result = (result + this._yusov1TableAdapter.Update(addedRows));
  2558. allAddedRows.AddRange(addedRows);
  2559. }
  2560. }
  2561. if ((this._yusov2TableAdapter != null)) {
  2562. global::System.Data.DataRow[] addedRows = dataSet.Yusov2.Select(null, null, global::System.Data.DataViewRowState.Added);
  2563. if (((addedRows != null)
  2564. && (0 < addedRows.Length))) {
  2565. result = (result + this._yusov2TableAdapter.Update(addedRows));
  2566. allAddedRows.AddRange(addedRows);
  2567. }
  2568. }
  2569. if ((this._yusov3TableAdapter != null)) {
  2570. global::System.Data.DataRow[] addedRows = dataSet.Yusov3.Select(null, null, global::System.Data.DataViewRowState.Added);
  2571. if (((addedRows != null)
  2572. && (0 < addedRows.Length))) {
  2573. result = (result + this._yusov3TableAdapter.Update(addedRows));
  2574. allAddedRows.AddRange(addedRows);
  2575. }
  2576. }
  2577. return result;
  2578. }
  2579. /// <summary>
  2580. ///Delete rows in bottom-up order.
  2581. ///</summary>
  2582. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2583. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2584. private int UpdateDeletedRows(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows) {
  2585. int result = 0;
  2586. if ((this._yusov3TableAdapter != null)) {
  2587. global::System.Data.DataRow[] deletedRows = dataSet.Yusov3.Select(null, null, global::System.Data.DataViewRowState.Deleted);
  2588. if (((deletedRows != null)
  2589. && (0 < deletedRows.Length))) {
  2590. result = (result + this._yusov3TableAdapter.Update(deletedRows));
  2591. allChangedRows.AddRange(deletedRows);
  2592. }
  2593. }
  2594. if ((this._yusov2TableAdapter != null)) {
  2595. global::System.Data.DataRow[] deletedRows = dataSet.Yusov2.Select(null, null, global::System.Data.DataViewRowState.Deleted);
  2596. if (((deletedRows != null)
  2597. && (0 < deletedRows.Length))) {
  2598. result = (result + this._yusov2TableAdapter.Update(deletedRows));
  2599. allChangedRows.AddRange(deletedRows);
  2600. }
  2601. }
  2602. if ((this._yusov1TableAdapter != null)) {
  2603. global::System.Data.DataRow[] deletedRows = dataSet.yusov1.Select(null, null, global::System.Data.DataViewRowState.Deleted);
  2604. if (((deletedRows != null)
  2605. && (0 < deletedRows.Length))) {
  2606. result = (result + this._yusov1TableAdapter.Update(deletedRows));
  2607. allChangedRows.AddRange(deletedRows);
  2608. }
  2609. }
  2610. return result;
  2611. }
  2612. /// <summary>
  2613. ///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
  2614. ///</summary>
  2615. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2616. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2617. private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
  2618. if (((updatedRows == null)
  2619. || (updatedRows.Length < 1))) {
  2620. return updatedRows;
  2621. }
  2622. if (((allAddedRows == null)
  2623. || (allAddedRows.Count < 1))) {
  2624. return updatedRows;
  2625. }
  2626. global::System.Collections.Generic.List<global::System.Data.DataRow> realUpdatedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  2627. for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
  2628. global::System.Data.DataRow row = updatedRows[i];
  2629. if ((allAddedRows.Contains(row) == false)) {
  2630. realUpdatedRows.Add(row);
  2631. }
  2632. }
  2633. return realUpdatedRows.ToArray();
  2634. }
  2635. /// <summary>
  2636. ///Update all changes to the dataset.
  2637. ///</summary>
  2638. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2639. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2640. public virtual int UpdateAll(_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet6 dataSet) {
  2641. if ((dataSet == null)) {
  2642. throw new global::System.ArgumentNullException("dataSet");
  2643. }
  2644. if ((dataSet.HasChanges() == false)) {
  2645. return 0;
  2646. }
  2647. if (((this._yusov1TableAdapter != null)
  2648. && (this.MatchTableAdapterConnection(this._yusov1TableAdapter.Connection) == false))) {
  2649. throw new global::System.ArgumentException("Все адаптеры таблицы, управляемые диспетчером адаптера таблицы TableAdapterManage" +
  2650. "r, должны использовать одинаковую строку подключения.");
  2651. }
  2652. if (((this._yusov2TableAdapter != null)
  2653. && (this.MatchTableAdapterConnection(this._yusov2TableAdapter.Connection) == false))) {
  2654. throw new global::System.ArgumentException("Все адаптеры таблицы, управляемые диспетчером адаптера таблицы TableAdapterManage" +
  2655. "r, должны использовать одинаковую строку подключения.");
  2656. }
  2657. if (((this._yusov3TableAdapter != null)
  2658. && (this.MatchTableAdapterConnection(this._yusov3TableAdapter.Connection) == false))) {
  2659. throw new global::System.ArgumentException("Все адаптеры таблицы, управляемые диспетчером адаптера таблицы TableAdapterManage" +
  2660. "r, должны использовать одинаковую строку подключения.");
  2661. }
  2662. global::System.Data.IDbConnection workConnection = this.Connection;
  2663. if ((workConnection == null)) {
  2664. throw new global::System.ApplicationException("TableAdapterManager не содержит сведений о подключении. Укажите для каждого адапт" +
  2665. "ера таблицы TableAdapterManager допустимый экземпляр адаптера таблицы.");
  2666. }
  2667. bool workConnOpened = false;
  2668. if (((workConnection.State & global::System.Data.ConnectionState.Broken)
  2669. == global::System.Data.ConnectionState.Broken)) {
  2670. workConnection.Close();
  2671. }
  2672. if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
  2673. workConnection.Open();
  2674. workConnOpened = true;
  2675. }
  2676. global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
  2677. if ((workTransaction == null)) {
  2678. throw new global::System.ApplicationException("Не удается начать транзакцию. Текущее соединение данных не поддерживает транзакци" +
  2679. "и или текущее состояние не позволяет начать транзакцию.");
  2680. }
  2681. global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  2682. global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
  2683. global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter> adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter>();
  2684. global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection> revertConnections = new global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection>();
  2685. int result = 0;
  2686. global::System.Data.DataSet backupDataSet = null;
  2687. if (this.BackupDataSetBeforeUpdate) {
  2688. backupDataSet = new global::System.Data.DataSet();
  2689. backupDataSet.Merge(dataSet);
  2690. }
  2691. try {
  2692. // ---- Prepare for update -----------
  2693. //
  2694. if ((this._yusov1TableAdapter != null)) {
  2695. revertConnections.Add(this._yusov1TableAdapter, this._yusov1TableAdapter.Connection);
  2696. this._yusov1TableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(workConnection));
  2697. this._yusov1TableAdapter.Transaction = ((global::System.Data.SqlClient.SqlTransaction)(workTransaction));
  2698. if (this._yusov1TableAdapter.Adapter.AcceptChangesDuringUpdate) {
  2699. this._yusov1TableAdapter.Adapter.AcceptChangesDuringUpdate = false;
  2700. adaptersWithAcceptChangesDuringUpdate.Add(this._yusov1TableAdapter.Adapter);
  2701. }
  2702. }
  2703. if ((this._yusov2TableAdapter != null)) {
  2704. revertConnections.Add(this._yusov2TableAdapter, this._yusov2TableAdapter.Connection);
  2705. this._yusov2TableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(workConnection));
  2706. this._yusov2TableAdapter.Transaction = ((global::System.Data.SqlClient.SqlTransaction)(workTransaction));
  2707. if (this._yusov2TableAdapter.Adapter.AcceptChangesDuringUpdate) {
  2708. this._yusov2TableAdapter.Adapter.AcceptChangesDuringUpdate = false;
  2709. adaptersWithAcceptChangesDuringUpdate.Add(this._yusov2TableAdapter.Adapter);
  2710. }
  2711. }
  2712. if ((this._yusov3TableAdapter != null)) {
  2713. revertConnections.Add(this._yusov3TableAdapter, this._yusov3TableAdapter.Connection);
  2714. this._yusov3TableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(workConnection));
  2715. this._yusov3TableAdapter.Transaction = ((global::System.Data.SqlClient.SqlTransaction)(workTransaction));
  2716. if (this._yusov3TableAdapter.Adapter.AcceptChangesDuringUpdate) {
  2717. this._yusov3TableAdapter.Adapter.AcceptChangesDuringUpdate = false;
  2718. adaptersWithAcceptChangesDuringUpdate.Add(this._yusov3TableAdapter.Adapter);
  2719. }
  2720. }
  2721. //
  2722. //---- Perform updates -----------
  2723. //
  2724. if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) {
  2725. result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
  2726. result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
  2727. }
  2728. else {
  2729. result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
  2730. result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
  2731. }
  2732. result = (result + this.UpdateDeletedRows(dataSet, allChangedRows));
  2733. //
  2734. //---- Commit updates -----------
  2735. //
  2736. workTransaction.Commit();
  2737. if ((0 < allAddedRows.Count)) {
  2738. global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
  2739. allAddedRows.CopyTo(rows);
  2740. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  2741. global::System.Data.DataRow row = rows[i];
  2742. row.AcceptChanges();
  2743. }
  2744. }
  2745. if ((0 < allChangedRows.Count)) {
  2746. global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count];
  2747. allChangedRows.CopyTo(rows);
  2748. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  2749. global::System.Data.DataRow row = rows[i];
  2750. row.AcceptChanges();
  2751. }
  2752. }
  2753. }
  2754. catch (global::System.Exception ex) {
  2755. workTransaction.Rollback();
  2756. // ---- Restore the dataset -----------
  2757. if (this.BackupDataSetBeforeUpdate) {
  2758. global::System.Diagnostics.Debug.Assert((backupDataSet != null));
  2759. dataSet.Clear();
  2760. dataSet.Merge(backupDataSet);
  2761. }
  2762. else {
  2763. if ((0 < allAddedRows.Count)) {
  2764. global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
  2765. allAddedRows.CopyTo(rows);
  2766. for (int i = 0; (i < rows.Length); i = (i + 1)) {
  2767. global::System.Data.DataRow row = rows[i];
  2768. row.AcceptChanges();
  2769. row.SetAdded();
  2770. }
  2771. }
  2772. }
  2773. throw ex;
  2774. }
  2775. finally {
  2776. if (workConnOpened) {
  2777. workConnection.Close();
  2778. }
  2779. if ((this._yusov1TableAdapter != null)) {
  2780. this._yusov1TableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(revertConnections[this._yusov1TableAdapter]));
  2781. this._yusov1TableAdapter.Transaction = null;
  2782. }
  2783. if ((this._yusov2TableAdapter != null)) {
  2784. this._yusov2TableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(revertConnections[this._yusov2TableAdapter]));
  2785. this._yusov2TableAdapter.Transaction = null;
  2786. }
  2787. if ((this._yusov3TableAdapter != null)) {
  2788. this._yusov3TableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(revertConnections[this._yusov3TableAdapter]));
  2789. this._yusov3TableAdapter.Transaction = null;
  2790. }
  2791. if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) {
  2792. global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count];
  2793. adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters);
  2794. for (int i = 0; (i < adapters.Length); i = (i + 1)) {
  2795. global::System.Data.Common.DataAdapter adapter = adapters[i];
  2796. adapter.AcceptChangesDuringUpdate = true;
  2797. }
  2798. }
  2799. }
  2800. return result;
  2801. }
  2802. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2803. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2804. protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) {
  2805. global::System.Array.Sort<global::System.Data.DataRow>(rows, new SelfReferenceComparer(relation, childFirst));
  2806. }
  2807. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2808. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2809. protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) {
  2810. if ((this._connection != null)) {
  2811. return true;
  2812. }
  2813. if (((this.Connection == null)
  2814. || (inputConnection == null))) {
  2815. return true;
  2816. }
  2817. if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) {
  2818. return true;
  2819. }
  2820. return false;
  2821. }
  2822. /// <summary>
  2823. ///Update Order Option
  2824. ///</summary>
  2825. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2826. public enum UpdateOrderOption {
  2827. InsertUpdateDelete = 0,
  2828. UpdateInsertDelete = 1,
  2829. }
  2830. /// <summary>
  2831. ///Used to sort self-referenced table's rows
  2832. ///</summary>
  2833. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2834. private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer<global::System.Data.DataRow> {
  2835. private global::System.Data.DataRelation _relation;
  2836. private int _childFirst;
  2837. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2838. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2839. internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) {
  2840. this._relation = relation;
  2841. if (childFirst) {
  2842. this._childFirst = -1;
  2843. }
  2844. else {
  2845. this._childFirst = 1;
  2846. }
  2847. }
  2848. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2849. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2850. private global::System.Data.DataRow GetRoot(global::System.Data.DataRow row, out int distance) {
  2851. global::System.Diagnostics.Debug.Assert((row != null));
  2852. global::System.Data.DataRow root = row;
  2853. distance = 0;
  2854. 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>();
  2855. traversedRows[row] = row;
  2856. global::System.Data.DataRow parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
  2857. for (
  2858. ; ((parent != null)
  2859. && (traversedRows.ContainsKey(parent) == false));
  2860. ) {
  2861. distance = (distance + 1);
  2862. root = parent;
  2863. traversedRows[parent] = parent;
  2864. parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
  2865. }
  2866. if ((distance == 0)) {
  2867. traversedRows.Clear();
  2868. traversedRows[row] = row;
  2869. parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
  2870. for (
  2871. ; ((parent != null)
  2872. && (traversedRows.ContainsKey(parent) == false));
  2873. ) {
  2874. distance = (distance + 1);
  2875. root = parent;
  2876. traversedRows[parent] = parent;
  2877. parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
  2878. }
  2879. }
  2880. return root;
  2881. }
  2882. [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
  2883. [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
  2884. public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) {
  2885. if (object.ReferenceEquals(row1, row2)) {
  2886. return 0;
  2887. }
  2888. if ((row1 == null)) {
  2889. return -1;
  2890. }
  2891. if ((row2 == null)) {
  2892. return 1;
  2893. }
  2894. int distance1 = 0;
  2895. global::System.Data.DataRow root1 = this.GetRoot(row1, out distance1);
  2896. int distance2 = 0;
  2897. global::System.Data.DataRow root2 = this.GetRoot(row2, out distance2);
  2898. if (object.ReferenceEquals(root1, root2)) {
  2899. return (this._childFirst * distance1.CompareTo(distance2));
  2900. }
  2901. else {
  2902. global::System.Diagnostics.Debug.Assert(((root1.Table != null)
  2903. && (root2.Table != null)));
  2904. if ((root1.Table.Rows.IndexOf(root1) < root2.Table.Rows.IndexOf(root2))) {
  2905. return -1;
  2906. }
  2907. else {
  2908. return 1;
  2909. }
  2910. }
  2911. }
  2912. }
  2913. }
  2914. }
  2915. #pragma warning restore 1591