Practice/SvFabricDataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SvFabricDataSet" targetNamespace="http://tempuri.org/SvFabricDataSet.xsd" xmlns:mstns="http://tempuri.org/SvFabricDataSet.xsd" xmlns="http://tempuri.org/SvFabricDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SvFabricConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SvFabricConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.СУБД_Швейная_фабрика.Properties.Settings.GlobalReference.Default.SvFabricConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClothessTableAdapter" GeneratorDataComponentClassName="ClothessTableAdapter" Name="Clothess" UserDataComponentName="ClothessTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SvFabricConnectionString (Settings)" DbObjectName="SvFabric.dbo.Clothess" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Clothess] WHERE (([ID_Cloth] = @Original_ID_Cloth) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_ID_Color = 1 AND [ID_Color] IS NULL) OR ([ID_Color] = @Original_ID_Color)) AND ((@IsNull_Length = 1 AND [Length] IS NULL) OR ([Length] = @Original_Length)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)) AND ((@IsNull_Comment = 1 AND [Comment] IS NULL) OR ([Comment] = @Original_Comment)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Cloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Cloth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Color" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Comment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Clothess] ([Name], [ID_Color], [Length], [Width], [Comment], [Photo]) VALUES (@Name, @ID_Color, @Length, @Width, @Comment, @Photo);
SELECT ID_Cloth, Name, ID_Color, Length, Width, Comment, Photo FROM Clothess WHERE (ID_Cloth = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Cloth, Name, ID_Color, Length, Width, Comment, Photo FROM dbo.Clothess</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Clothess] SET [Name] = @Name, [ID_Color] = @ID_Color, [Length] = @Length, [Width] = @Width, [Comment] = @Comment, [Photo] = @Photo WHERE (([ID_Cloth] = @Original_ID_Cloth) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_ID_Color = 1 AND [ID_Color] IS NULL) OR ([ID_Color] = @Original_ID_Color)) AND ((@IsNull_Length = 1 AND [Length] IS NULL) OR ([Length] = @Original_Length)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)) AND ((@IsNull_Comment = 1 AND [Comment] IS NULL) OR ([Comment] = @Original_Comment)));
SELECT ID_Cloth, Name, ID_Color, Length, Width, Comment, Photo FROM Clothess WHERE (ID_Cloth = @ID_Cloth)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Cloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Cloth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Color" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Comment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Cloth" ColumnName="ID_Cloth" DataSourceName="SvFabric.dbo.Clothess" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_Cloth" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_Cloth" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Cloth" DataSetColumn="ID_Cloth" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="ID_Color" DataSetColumn="ID_Color" />
              <Mapping SourceColumn="Length" DataSetColumn="Length" />
              <Mapping SourceColumn="Width" DataSetColumn="Width" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="Photo" DataSetColumn="Photo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ColorsTableAdapter" GeneratorDataComponentClassName="ColorsTableAdapter" Name="Colors" UserDataComponentName="ColorsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SvFabricConnectionString (Settings)" DbObjectName="SvFabric.dbo.Colors" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Colors] WHERE (([ID_Color] = @Original_ID_Color) AND ((@IsNull_Name_Color = 1 AND [Name_Color] IS NULL) OR ([Name_Color] = @Original_Name_Color)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name_Color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name_Color" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Color" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Colors] ([Name_Color]) VALUES (@Name_Color);
SELECT ID_Color, Name_Color FROM Colors WHERE (ID_Color = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Color, Name_Color FROM dbo.Colors</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Colors] SET [Name_Color] = @Name_Color WHERE (([ID_Color] = @Original_ID_Color) AND ((@IsNull_Name_Color = 1 AND [Name_Color] IS NULL) OR ([Name_Color] = @Original_Name_Color)));
SELECT ID_Color, Name_Color FROM Colors WHERE (ID_Color = @ID_Color)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name_Color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name_Color" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_Color" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Color" ColumnName="ID_Color" DataSourceName="SvFabric.dbo.Colors" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_Color" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Color" DataSetColumn="ID_Color" />
              <Mapping SourceColumn="Name_Color" DataSetColumn="Name_Color" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FurnituresTableAdapter" GeneratorDataComponentClassName="FurnituresTableAdapter" Name="Furnitures" UserDataComponentName="FurnituresTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SvFabricConnectionString (Settings)" DbObjectName="SvFabric.dbo.Furnitures" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Furnitures] WHERE (([ID_Fur] = @Original_ID_Fur) AND ([Name_Fur] = @Original_Name_Fur) AND ((@IsNull_Count_Fur = 1 AND [Count_Fur] IS NULL) OR ([Count_Fur] = @Original_Count_Fur)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Fur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_Fur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Fur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Count_Fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Count_Fur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Count_Fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Count_Fur" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Furnitures] ([ID_Fur], [Name_Fur], [Photo], [Count_Fur]) VALUES (@ID_Fur, @Name_Fur, @Photo, @Count_Fur);
SELECT ID_Fur, Name_Fur, Photo, Count_Fur FROM Furnitures WHERE (ID_Fur = @ID_Fur)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Fur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_Fur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Fur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Count_Fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Count_Fur" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Fur, Name_Fur, Photo, Count_Fur FROM dbo.Furnitures</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Furnitures] SET [ID_Fur] = @ID_Fur, [Name_Fur] = @Name_Fur, [Photo] = @Photo, [Count_Fur] = @Count_Fur WHERE (([ID_Fur] = @Original_ID_Fur) AND ([Name_Fur] = @Original_Name_Fur) AND ((@IsNull_Count_Fur = 1 AND [Count_Fur] IS NULL) OR ([Count_Fur] = @Original_Count_Fur)));
SELECT ID_Fur, Name_Fur, Photo, Count_Fur FROM Furnitures WHERE (ID_Fur = @ID_Fur)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Fur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_Fur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Fur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Count_Fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Count_Fur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Fur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_Fur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Fur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Count_Fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Count_Fur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Count_Fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Count_Fur" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Fur" DataSetColumn="ID_Fur" />
              <Mapping SourceColumn="Name_Fur" DataSetColumn="Name_Fur" />
              <Mapping SourceColumn="Photo" DataSetColumn="Photo" />
              <Mapping SourceColumn="Count_Fur" DataSetColumn="Count_Fur" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IzdelieTableAdapter" GeneratorDataComponentClassName="IzdelieTableAdapter" Name="Izdelie" UserDataComponentName="IzdelieTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SvFabricConnectionString (Settings)" DbObjectName="SvFabric.dbo.Izdelie" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Izdelie] WHERE (([ID_Izdelie] = @Original_ID_Izdelie) AND ((@IsNull_Name_Izdelie = 1 AND [Name_Izdelie] IS NULL) OR ([Name_Izdelie] = @Original_Name_Izdelie)) AND ((@IsNull_Length = 1 AND [Length] IS NULL) OR ([Length] = @Original_Length)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Izdelie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Izdelie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name_Izdelie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name_Izdelie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_Izdelie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Izdelie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Izdelie] ([ID_Izdelie], [Name_Izdelie], [Length], [Width]) VALUES (@ID_Izdelie, @Name_Izdelie, @Length, @Width);
SELECT ID_Izdelie, Name_Izdelie, Length, Width FROM Izdelie WHERE (ID_Izdelie = @ID_Izdelie)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Izdelie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Izdelie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_Izdelie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Izdelie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Izdelie, Name_Izdelie, Length, Width FROM dbo.Izdelie</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Izdelie] SET [ID_Izdelie] = @ID_Izdelie, [Name_Izdelie] = @Name_Izdelie, [Length] = @Length, [Width] = @Width WHERE (([ID_Izdelie] = @Original_ID_Izdelie) AND ((@IsNull_Name_Izdelie = 1 AND [Name_Izdelie] IS NULL) OR ([Name_Izdelie] = @Original_Name_Izdelie)) AND ((@IsNull_Length = 1 AND [Length] IS NULL) OR ([Length] = @Original_Length)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)));
SELECT ID_Izdelie, Name_Izdelie, Length, Width FROM Izdelie WHERE (ID_Izdelie = @ID_Izdelie)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Izdelie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Izdelie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_Izdelie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Izdelie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Izdelie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Izdelie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name_Izdelie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name_Izdelie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_Izdelie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Izdelie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Izdelie" DataSetColumn="ID_Izdelie" />
              <Mapping SourceColumn="Name_Izdelie" DataSetColumn="Name_Izdelie" />
              <Mapping SourceColumn="Length" DataSetColumn="Length" />
              <Mapping SourceColumn="Width" DataSetColumn="Width" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrdersTableAdapter" GeneratorDataComponentClassName="OrdersTableAdapter" Name="Orders" UserDataComponentName="OrdersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SvFabricConnectionString (Settings)" DbObjectName="SvFabric.dbo.Orders" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Orders] WHERE (([ID_Order] = @Original_ID_Order) AND ([ID_Izdelie] = @Original_ID_Izdelie) AND ([ID_Zakazchik] = @Original_ID_Zakazchik) AND ([ID_Manager] = @Original_ID_Manager) AND ([ID_Cloth] = @Original_ID_Cloth) AND ([ID_Fur] = @Original_ID_Fur) AND ((@IsNull_CountFur = 1 AND [CountFur] IS NULL) OR ([CountFur] = @Original_CountFur)) AND ((@IsNull_CountIzd = 1 AND [CountIzd] IS NULL) OR ([CountIzd] = @Original_CountIzd)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Order" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Izdelie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Izdelie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Zakazchik" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Zakazchik" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Manager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Manager" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Cloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Cloth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Fur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Orders] ([ID_Izdelie], [ID_Zakazchik], [ID_Manager], [ID_Cloth], [ID_Fur], [CountFur], [CountIzd]) VALUES (@ID_Izdelie, @ID_Zakazchik, @ID_Manager, @ID_Cloth, @ID_Fur, @CountFur, @CountIzd);
SELECT ID_Order, ID_Izdelie, ID_Zakazchik, ID_Manager, ID_Cloth, ID_Fur, CountFur, CountIzd FROM Orders WHERE (ID_Order = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Izdelie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Izdelie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Zakazchik" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Zakazchik" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Manager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Manager" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Cloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Cloth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Fur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Order, ID_Izdelie, ID_Zakazchik, ID_Manager, ID_Cloth, ID_Fur, CountFur, CountIzd FROM dbo.Orders</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Orders] SET [ID_Izdelie] = @ID_Izdelie, [ID_Zakazchik] = @ID_Zakazchik, [ID_Manager] = @ID_Manager, [ID_Cloth] = @ID_Cloth, [ID_Fur] = @ID_Fur, [CountFur] = @CountFur, [CountIzd] = @CountIzd WHERE (([ID_Order] = @Original_ID_Order) AND ([ID_Izdelie] = @Original_ID_Izdelie) AND ([ID_Zakazchik] = @Original_ID_Zakazchik) AND ([ID_Manager] = @Original_ID_Manager) AND ([ID_Cloth] = @Original_ID_Cloth) AND ([ID_Fur] = @Original_ID_Fur) AND ((@IsNull_CountFur = 1 AND [CountFur] IS NULL) OR ([CountFur] = @Original_CountFur)) AND ((@IsNull_CountIzd = 1 AND [CountIzd] IS NULL) OR ([CountIzd] = @Original_CountIzd)));
SELECT ID_Order, ID_Izdelie, ID_Zakazchik, ID_Manager, ID_Cloth, ID_Fur, CountFur, CountIzd FROM Orders WHERE (ID_Order = @ID_Order)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Izdelie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Izdelie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Zakazchik" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Zakazchik" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Manager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Manager" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Cloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Cloth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Fur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Order" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Izdelie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Izdelie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Zakazchik" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Zakazchik" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Manager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Manager" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Cloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Cloth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Fur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Order" ColumnName="ID_Order" DataSourceName="SvFabric.dbo.Orders" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_Order" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Order" DataSetColumn="ID_Order" />
              <Mapping SourceColumn="ID_Izdelie" DataSetColumn="ID_Izdelie" />
              <Mapping SourceColumn="ID_Zakazchik" DataSetColumn="ID_Zakazchik" />
              <Mapping SourceColumn="ID_Manager" DataSetColumn="ID_Manager" />
              <Mapping SourceColumn="ID_Cloth" DataSetColumn="ID_Cloth" />
              <Mapping SourceColumn="ID_Fur" DataSetColumn="ID_Fur" />
              <Mapping SourceColumn="CountFur" DataSetColumn="CountFur" />
              <Mapping SourceColumn="CountIzd" DataSetColumn="CountIzd" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RolesTableAdapter" GeneratorDataComponentClassName="RolesTableAdapter" Name="Roles" UserDataComponentName="RolesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SvFabricConnectionString (Settings)" DbObjectName="SvFabric.dbo.Roles" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Roles] WHERE (([ID_Role] = @Original_ID_Role) AND ([Name_Role] = @Original_Name_Role))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Role" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_Role" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Role" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Roles] ([Name_Role]) VALUES (@Name_Role);
SELECT ID_Role, Name_Role FROM Roles WHERE (ID_Role = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_Role" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_Role, Name_Role FROM dbo.Roles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Roles] SET [Name_Role] = @Name_Role WHERE (([ID_Role] = @Original_ID_Role) AND ([Name_Role] = @Original_Name_Role));
SELECT ID_Role, Name_Role FROM Roles WHERE (ID_Role = @ID_Role)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_Role" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Role" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_Role" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_Role" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_Role" ColumnName="ID_Role" DataSourceName="SvFabric.dbo.Roles" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_Role" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_Role" DataSetColumn="ID_Role" />
              <Mapping SourceColumn="Name_Role" DataSetColumn="Name_Role" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SvFabricConnectionString (Settings)" DbObjectName="SvFabric.dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Users] WHERE (([ID_User] = @Original_ID_User) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_ID_Role = 1 AND [ID_Role] IS NULL) OR ([ID_Role] = @Original_ID_Role)) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymicv = 1 AND [Patronymicv] IS NULL) OR ([Patronymicv] = @Original_Patronymicv)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_User" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_User" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Role" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Surname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Patronymicv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Patronymicv" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Patronymicv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymicv" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Users] ([Login], [Password], [ID_Role], [Surname], [Name], [Patronymicv], [Phone]) VALUES (@Login, @Password, @ID_Role, @Surname, @Name, @Patronymicv, @Phone);
SELECT ID_User, Login, Password, ID_Role, Surname, Name, Patronymicv, Phone FROM Users WHERE (ID_User = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Patronymicv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymicv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID_User, Login, Password, ID_Role, Surname, Name, Patronymicv, Phone FROM dbo.Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Users] SET [Login] = @Login, [Password] = @Password, [ID_Role] = @ID_Role, [Surname] = @Surname, [Name] = @Name, [Patronymicv] = @Patronymicv, [Phone] = @Phone WHERE (([ID_User] = @Original_ID_User) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_ID_Role = 1 AND [ID_Role] IS NULL) OR ([ID_Role] = @Original_ID_Role)) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymicv = 1 AND [Patronymicv] IS NULL) OR ([Patronymicv] = @Original_Patronymicv)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)));
SELECT ID_User, Login, Password, ID_Role, Surname, Name, Patronymicv, Phone FROM Users WHERE (ID_User = @ID_User)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Patronymicv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymicv" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_User" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_User" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Role" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Surname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Patronymicv" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Patronymicv" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Patronymicv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymicv" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID_User" ColumnName="ID_User" DataSourceName="SvFabric.dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID_User" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID_User" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID_User" DataSetColumn="ID_User" />
              <Mapping SourceColumn="Login" DataSetColumn="Login" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="ID_Role" DataSetColumn="ID_Role" />
              <Mapping SourceColumn="Surname" DataSetColumn="Surname" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Patronymicv" DataSetColumn="Patronymicv" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SvFabricDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_UserDSName="SvFabricDataSet" msprop:Generator_DataSetName="SvFabricDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Clothess" msprop:Generator_RowEvHandlerName="ClothessRowChangeEventHandler" msprop:Generator_RowDeletedName="ClothessRowDeleted" msprop:Generator_RowDeletingName="ClothessRowDeleting" msprop:Generator_RowEvArgName="ClothessRowChangeEvent" msprop:Generator_TablePropName="Clothess" msprop:Generator_RowChangedName="ClothessRowChanged" msprop:Generator_RowChangingName="ClothessRowChanging" msprop:Generator_TableClassName="ClothessDataTable" msprop:Generator_RowClassName="ClothessRow" msprop:Generator_TableVarName="tableClothess" msprop:Generator_UserTableName="Clothess">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Cloth" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="ID_Cloth" msprop:Generator_ColumnPropNameInTable="ID_ClothColumn" msprop:Generator_ColumnVarNameInTable="columnID_Cloth" msprop:Generator_UserColumnName="ID_Cloth" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID_Color" msprop:Generator_ColumnPropNameInRow="ID_Color" msprop:Generator_ColumnPropNameInTable="ID_ColorColumn" msprop:Generator_ColumnVarNameInTable="columnID_Color" msprop:Generator_UserColumnName="ID_Color" type="xs:int" minOccurs="0" />
              <xs:element name="Length" msprop:Generator_ColumnPropNameInRow="Length" msprop:Generator_ColumnPropNameInTable="LengthColumn" msprop:Generator_ColumnVarNameInTable="columnLength" msprop:Generator_UserColumnName="Length" type="xs:int" minOccurs="0" />
              <xs:element name="Width" msprop:Generator_ColumnPropNameInRow="Width" msprop:Generator_ColumnPropNameInTable="WidthColumn" msprop:Generator_ColumnVarNameInTable="columnWidth" msprop:Generator_UserColumnName="Width" type="xs:int" minOccurs="0" />
              <xs:element name="Comment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_UserColumnName="Comment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Photo" msprop:Generator_ColumnPropNameInRow="Photo" msprop:Generator_ColumnPropNameInTable="PhotoColumn" msprop:Generator_ColumnVarNameInTable="columnPhoto" msprop:Generator_UserColumnName="Photo" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Colors" msprop:Generator_RowEvHandlerName="ColorsRowChangeEventHandler" msprop:Generator_RowDeletedName="ColorsRowDeleted" msprop:Generator_RowDeletingName="ColorsRowDeleting" msprop:Generator_RowEvArgName="ColorsRowChangeEvent" msprop:Generator_TablePropName="Colors" msprop:Generator_RowChangedName="ColorsRowChanged" msprop:Generator_RowChangingName="ColorsRowChanging" msprop:Generator_TableClassName="ColorsDataTable" msprop:Generator_RowClassName="ColorsRow" msprop:Generator_TableVarName="tableColors" msprop:Generator_UserTableName="Colors">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Color" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="ID_Color" msprop:Generator_ColumnPropNameInTable="ID_ColorColumn" msprop:Generator_ColumnVarNameInTable="columnID_Color" msprop:Generator_UserColumnName="ID_Color" type="xs:int" />
              <xs:element name="Name_Color" msprop:Generator_ColumnPropNameInRow="Name_Color" msprop:Generator_ColumnPropNameInTable="Name_ColorColumn" msprop:Generator_ColumnVarNameInTable="columnName_Color" msprop:Generator_UserColumnName="Name_Color" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Furnitures" msprop:Generator_RowEvHandlerName="FurnituresRowChangeEventHandler" msprop:Generator_RowDeletedName="FurnituresRowDeleted" msprop:Generator_RowDeletingName="FurnituresRowDeleting" msprop:Generator_RowEvArgName="FurnituresRowChangeEvent" msprop:Generator_TablePropName="Furnitures" msprop:Generator_RowChangedName="FurnituresRowChanged" msprop:Generator_RowChangingName="FurnituresRowChanging" msprop:Generator_TableClassName="FurnituresDataTable" msprop:Generator_RowClassName="FurnituresRow" msprop:Generator_TableVarName="tableFurnitures" msprop:Generator_UserTableName="Furnitures">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Fur" msprop:Generator_ColumnPropNameInRow="ID_Fur" msprop:Generator_ColumnPropNameInTable="ID_FurColumn" msprop:Generator_ColumnVarNameInTable="columnID_Fur" msprop:Generator_UserColumnName="ID_Fur" type="xs:int" />
              <xs:element name="Name_Fur" msprop:Generator_ColumnPropNameInRow="Name_Fur" msprop:Generator_ColumnPropNameInTable="Name_FurColumn" msprop:Generator_ColumnVarNameInTable="columnName_Fur" msprop:Generator_UserColumnName="Name_Fur">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Photo" msprop:Generator_ColumnPropNameInRow="Photo" msprop:Generator_ColumnPropNameInTable="PhotoColumn" msprop:Generator_ColumnVarNameInTable="columnPhoto" msprop:Generator_UserColumnName="Photo" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="Count_Fur" msprop:Generator_ColumnPropNameInRow="Count_Fur" msprop:Generator_ColumnPropNameInTable="Count_FurColumn" msprop:Generator_ColumnVarNameInTable="columnCount_Fur" msprop:Generator_UserColumnName="Count_Fur" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Izdelie" msprop:Generator_RowEvHandlerName="IzdelieRowChangeEventHandler" msprop:Generator_RowDeletedName="IzdelieRowDeleted" msprop:Generator_RowDeletingName="IzdelieRowDeleting" msprop:Generator_RowEvArgName="IzdelieRowChangeEvent" msprop:Generator_TablePropName="Izdelie" msprop:Generator_RowChangedName="IzdelieRowChanged" msprop:Generator_RowChangingName="IzdelieRowChanging" msprop:Generator_TableClassName="IzdelieDataTable" msprop:Generator_RowClassName="IzdelieRow" msprop:Generator_TableVarName="tableIzdelie" msprop:Generator_UserTableName="Izdelie">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Izdelie" msprop:Generator_ColumnPropNameInRow="ID_Izdelie" msprop:Generator_ColumnPropNameInTable="ID_IzdelieColumn" msprop:Generator_ColumnVarNameInTable="columnID_Izdelie" msprop:Generator_UserColumnName="ID_Izdelie" type="xs:int" />
              <xs:element name="Name_Izdelie" msprop:Generator_ColumnPropNameInRow="Name_Izdelie" msprop:Generator_ColumnPropNameInTable="Name_IzdelieColumn" msprop:Generator_ColumnVarNameInTable="columnName_Izdelie" msprop:Generator_UserColumnName="Name_Izdelie" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Length" msprop:Generator_ColumnPropNameInRow="Length" msprop:Generator_ColumnPropNameInTable="LengthColumn" msprop:Generator_ColumnVarNameInTable="columnLength" msprop:Generator_UserColumnName="Length" type="xs:int" minOccurs="0" />
              <xs:element name="Width" msprop:Generator_ColumnPropNameInRow="Width" msprop:Generator_ColumnPropNameInTable="WidthColumn" msprop:Generator_ColumnVarNameInTable="columnWidth" msprop:Generator_UserColumnName="Width" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Orders" msprop:Generator_RowEvHandlerName="OrdersRowChangeEventHandler" msprop:Generator_RowDeletedName="OrdersRowDeleted" msprop:Generator_RowDeletingName="OrdersRowDeleting" msprop:Generator_RowEvArgName="OrdersRowChangeEvent" msprop:Generator_TablePropName="Orders" msprop:Generator_RowChangedName="OrdersRowChanged" msprop:Generator_RowChangingName="OrdersRowChanging" msprop:Generator_TableClassName="OrdersDataTable" msprop:Generator_RowClassName="OrdersRow" msprop:Generator_TableVarName="tableOrders" msprop:Generator_UserTableName="Orders">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Order" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="ID_Order" msprop:Generator_ColumnPropNameInTable="ID_OrderColumn" msprop:Generator_ColumnVarNameInTable="columnID_Order" msprop:Generator_UserColumnName="ID_Order" type="xs:int" />
              <xs:element name="ID_Izdelie" msprop:Generator_ColumnPropNameInRow="ID_Izdelie" msprop:Generator_ColumnPropNameInTable="ID_IzdelieColumn" msprop:Generator_ColumnVarNameInTable="columnID_Izdelie" msprop:Generator_UserColumnName="ID_Izdelie" type="xs:int" />
              <xs:element name="ID_Zakazchik" msprop:Generator_ColumnPropNameInRow="ID_Zakazchik" msprop:Generator_ColumnPropNameInTable="ID_ZakazchikColumn" msprop:Generator_ColumnVarNameInTable="columnID_Zakazchik" msprop:Generator_UserColumnName="ID_Zakazchik" type="xs:int" />
              <xs:element name="ID_Manager" msprop:Generator_ColumnPropNameInRow="ID_Manager" msprop:Generator_ColumnPropNameInTable="ID_ManagerColumn" msprop:Generator_ColumnVarNameInTable="columnID_Manager" msprop:Generator_UserColumnName="ID_Manager" type="xs:int" />
              <xs:element name="ID_Cloth" msprop:Generator_ColumnPropNameInRow="ID_Cloth" msprop:Generator_ColumnPropNameInTable="ID_ClothColumn" msprop:Generator_ColumnVarNameInTable="columnID_Cloth" msprop:Generator_UserColumnName="ID_Cloth" type="xs:int" />
              <xs:element name="ID_Fur" msprop:Generator_ColumnPropNameInRow="ID_Fur" msprop:Generator_ColumnPropNameInTable="ID_FurColumn" msprop:Generator_ColumnVarNameInTable="columnID_Fur" msprop:Generator_UserColumnName="ID_Fur" type="xs:int" />
              <xs:element name="CountFur" msprop:Generator_ColumnPropNameInRow="CountFur" msprop:Generator_ColumnPropNameInTable="CountFurColumn" msprop:Generator_ColumnVarNameInTable="columnCountFur" msprop:Generator_UserColumnName="CountFur" type="xs:int" minOccurs="0" />
              <xs:element name="CountIzd" msprop:Generator_ColumnPropNameInRow="CountIzd" msprop:Generator_ColumnPropNameInTable="CountIzdColumn" msprop:Generator_ColumnVarNameInTable="columnCountIzd" msprop:Generator_UserColumnName="CountIzd" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Roles" msprop:Generator_RowEvHandlerName="RolesRowChangeEventHandler" msprop:Generator_RowDeletedName="RolesRowDeleted" msprop:Generator_RowDeletingName="RolesRowDeleting" msprop:Generator_RowEvArgName="RolesRowChangeEvent" msprop:Generator_TablePropName="Roles" msprop:Generator_RowChangedName="RolesRowChanged" msprop:Generator_RowChangingName="RolesRowChanging" msprop:Generator_TableClassName="RolesDataTable" msprop:Generator_RowClassName="RolesRow" msprop:Generator_TableVarName="tableRoles" msprop:Generator_UserTableName="Roles">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_Role" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="ID_Role" msprop:Generator_ColumnPropNameInTable="ID_RoleColumn" msprop:Generator_ColumnVarNameInTable="columnID_Role" msprop:Generator_UserColumnName="ID_Role" type="xs:int" />
              <xs:element name="Name_Role" msprop:Generator_ColumnPropNameInRow="Name_Role" msprop:Generator_ColumnPropNameInTable="Name_RoleColumn" msprop:Generator_ColumnVarNameInTable="columnName_Role" msprop:Generator_UserColumnName="Name_Role">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_TablePropName="Users" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_RowClassName="UsersRow" msprop:Generator_TableVarName="tableUsers" msprop:Generator_UserTableName="Users">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID_User" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="ID_User" msprop:Generator_ColumnPropNameInTable="ID_UserColumn" msprop:Generator_ColumnVarNameInTable="columnID_User" msprop:Generator_UserColumnName="ID_User" type="xs:int" />
              <xs:element name="Login" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnPropNameInTable="LoginColumn" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_UserColumnName="Login" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_UserColumnName="Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID_Role" msprop:Generator_ColumnPropNameInRow="ID_Role" msprop:Generator_ColumnPropNameInTable="ID_RoleColumn" msprop:Generator_ColumnVarNameInTable="columnID_Role" msprop:Generator_UserColumnName="ID_Role" type="xs:int" minOccurs="0" />
              <xs:element name="Surname" msprop:Generator_ColumnPropNameInRow="Surname" msprop:Generator_ColumnPropNameInTable="SurnameColumn" msprop:Generator_ColumnVarNameInTable="columnSurname" msprop:Generator_UserColumnName="Surname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Patronymicv" msprop:Generator_ColumnPropNameInRow="Patronymicv" msprop:Generator_ColumnPropNameInTable="PatronymicvColumn" msprop:Generator_ColumnVarNameInTable="columnPatronymicv" msprop:Generator_UserColumnName="Patronymicv" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Clothess" />
      <xs:field xpath="mstns:ID_Cloth" />
    </xs:unique>
    <xs:unique name="Colors_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Colors" />
      <xs:field xpath="mstns:ID_Color" />
    </xs:unique>
    <xs:unique name="Furnitures_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Furnitures" />
      <xs:field xpath="mstns:ID_Fur" />
    </xs:unique>
    <xs:unique name="Izdelie_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Izdelie" />
      <xs:field xpath="mstns:ID_Izdelie" />
    </xs:unique>
    <xs:unique name="Orders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Orders" />
      <xs:field xpath="mstns:ID_Order" />
    </xs:unique>
    <xs:unique name="Roles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Roles" />
      <xs:field xpath="mstns:ID_Role" />
    </xs:unique>
    <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:ID_User" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Clothess_Colors" msdata:parent="Colors" msdata:child="Clothess" msdata:parentkey="ID_Color" msdata:childkey="ID_Color" msprop:Generator_UserParentTable="Colors" msprop:Generator_UserChildTable="Clothess" msprop:Generator_RelationVarName="relationFK_Clothess_Colors" msprop:Generator_UserRelationName="FK_Clothess_Colors" msprop:Generator_ChildPropName="GetClothessRows" msprop:Generator_ParentPropName="ColorsRow" />
      <msdata:Relationship name="FK_Orders_Clothess" msdata:parent="Clothess" msdata:child="Orders" msdata:parentkey="ID_Cloth" msdata:childkey="ID_Cloth" msprop:Generator_UserParentTable="Clothess" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Clothess" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_ParentPropName="ClothessRow" msprop:Generator_UserRelationName="FK_Orders_Clothess" />
      <msdata:Relationship name="FK_Orders_Izdelie" msdata:parent="Izdelie" msdata:child="Orders" msdata:parentkey="ID_Izdelie" msdata:childkey="ID_Izdelie" msprop:Generator_UserParentTable="Izdelie" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Izdelie" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_ParentPropName="IzdelieRow" msprop:Generator_UserRelationName="FK_Orders_Izdelie" />
      <msdata:Relationship name="FK_Orders_Users" msdata:parent="Users" msdata:child="Orders" msdata:parentkey="ID_User" msdata:childkey="ID_Zakazchik" msprop:Generator_UserParentTable="Users" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Users" msprop:Generator_UserRelationName="FK_Orders_Users" msprop:Generator_ChildPropName="GetOrdersRowsByFK_Orders_Users" msprop:Generator_ParentPropName="UsersRowByFK_Orders_Users" />
      <msdata:Relationship name="FK_Orders_Users1" msdata:parent="Users" msdata:child="Orders" msdata:parentkey="ID_User" msdata:childkey="ID_Manager" msprop:Generator_UserParentTable="Users" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Users1" msprop:Generator_UserRelationName="FK_Orders_Users1" msprop:Generator_ChildPropName="GetOrdersRowsByFK_Orders_Users1" msprop:Generator_ParentPropName="UsersRowByFK_Orders_Users1" />
      <msdata:Relationship name="FK_Users_Roles" msdata:parent="Roles" msdata:child="Users" msdata:parentkey="ID_Role" msdata:childkey="ID_Role" msprop:Generator_UserParentTable="Roles" msprop:Generator_UserChildTable="Users" msprop:Generator_RelationVarName="relationFK_Users_Roles" msprop:Generator_ChildPropName="GetUsersRows" msprop:Generator_ParentPropName="RolesRow" msprop:Generator_UserRelationName="FK_Users_Roles" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>