Praktika/Фабрика/dbFabrika2024DataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dbFabrika2024DataSet" targetNamespace="http://tempuri.org/dbFabrika2024DataSet.xsd" xmlns:mstns="http://tempuri.org/dbFabrika2024DataSet.xsd" xmlns="http://tempuri.org/dbFabrika2024DataSet.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="dbFabrika2024ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dbFabrika2024ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Фабрика.Properties.Settings.GlobalReference.Default.dbFabrika2024ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CvetaTableAdapter" GeneratorDataComponentClassName="CvetaTableAdapter" Name="Cveta" UserDataComponentName="CvetaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbFabrika2024ConnectionString (Settings)" DbObjectName="dbFabrika2024.dbo.Cveta" 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].[Cveta] WHERE (([id_cvet] = @Original_id_cvet))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_cvet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cvet" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Cveta] ([Name_cvet]) VALUES (@Name_cvet);
SELECT id_cvet, Name_cvet FROM Cveta WHERE (id_cvet = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_cvet" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_cvet" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id_cvet, Name_cvet FROM dbo.Cveta</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Cveta] SET [Name_cvet] = @Name_cvet WHERE (([id_cvet] = @Original_id_cvet));
SELECT id_cvet, Name_cvet FROM Cveta WHERE (id_cvet = @id_cvet)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_cvet" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_cvet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_cvet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cvet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id_cvet" ColumnName="id_cvet" DataSourceName="dbFabrika2024.dbo.Cveta" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id_cvet" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id_cvet" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id_cvet" DataSetColumn="id_cvet" />
              <Mapping SourceColumn="Name_cvet" DataSetColumn="Name_cvet" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FurnituraTableAdapter" GeneratorDataComponentClassName="FurnituraTableAdapter" Name="Furnitura" UserDataComponentName="FurnituraTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbFabrika2024ConnectionString (Settings)" DbObjectName="dbFabrika2024.dbo.Furnitura" 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].[Furnitura] WHERE (([idfur] = @Original_idfur) AND ((@IsNull_namefur = 1 AND [namefur] IS NULL) OR ([namefur] = @Original_namefur)) AND ((@IsNull_countfur = 1 AND [countfur] IS NULL) OR ([countfur] = @Original_countfur)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idfur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idfur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_namefur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="namefur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_namefur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="namefur" 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" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Furnitura] ([namefur], [photo], [countfur]) VALUES (@namefur, @photo, @countfur);
SELECT idfur, namefur, photo, countfur FROM Furnitura WHERE (idfur = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@namefur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="namefur" 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="@countfur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="countfur" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idfur, namefur, photo, countfur FROM dbo.Furnitura</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Furnitura] SET [namefur] = @namefur, [photo] = @photo, [countfur] = @countfur WHERE (([idfur] = @Original_idfur) AND ((@IsNull_namefur = 1 AND [namefur] IS NULL) OR ([namefur] = @Original_namefur)) AND ((@IsNull_countfur = 1 AND [countfur] IS NULL) OR ([countfur] = @Original_countfur)));
SELECT idfur, namefur, photo, countfur FROM Furnitura WHERE (idfur = @idfur)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@namefur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="namefur" 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="@countfur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="countfur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idfur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idfur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_namefur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="namefur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_namefur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="namefur" 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="false" AutogeneratedName="idfur" ColumnName="idfur" DataSourceName="dbFabrika2024.dbo.Furnitura" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idfur" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idfur" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idfur" DataSetColumn="idfur" />
              <Mapping SourceColumn="namefur" DataSetColumn="namefur" />
              <Mapping SourceColumn="photo" DataSetColumn="photo" />
              <Mapping SourceColumn="countfur" DataSetColumn="countfur" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IzdelieTableAdapter" GeneratorDataComponentClassName="IzdelieTableAdapter" Name="Izdelie" UserDataComponentName="IzdelieTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbFabrika2024ConnectionString (Settings)" DbObjectName="dbFabrika2024.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_izd = 1 AND [Name_izd] IS NULL) OR ([Name_izd] = @Original_Name_izd)) 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_izd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name_izd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_izd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_izd" 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] ([Name_izd], [length], [width]) VALUES (@Name_izd, @length, @width);
SELECT id_izdelie, Name_izd, length, width FROM Izdelie WHERE (id_izdelie = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_izd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_izd" 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_izd, length, width FROM dbo.Izdelie</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Izdelie] SET [Name_izd] = @Name_izd, [length] = @length, [width] = @width WHERE (([id_izdelie] = @Original_id_izdelie) AND ((@IsNull_Name_izd = 1 AND [Name_izd] IS NULL) OR ([Name_izd] = @Original_Name_izd)) 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_izd, length, width FROM Izdelie WHERE (id_izdelie = @id_izdelie)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_izd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_izd" 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_izd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name_izd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_izd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_izd" 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="false" AutogeneratedName="id_izdelie" ColumnName="id_izdelie" DataSourceName="dbFabrika2024.dbo.Izdelie" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id_izdelie" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id_izdelie" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id_izdelie" DataSetColumn="id_izdelie" />
              <Mapping SourceColumn="Name_izd" DataSetColumn="Name_izd" />
              <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="dbFabrika2024ConnectionString (Settings)" DbObjectName="dbFabrika2024.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 ((@IsNull_id_izdelie = 1 AND [id_izdelie] IS NULL) OR ([id_izdelie] = @Original_id_izdelie)) AND ((@IsNull_id_zakaz = 1 AND [id_zakaz] IS NULL) OR ([id_zakaz] = @Original_id_zakaz)) AND ((@IsNull_id_manager = 1 AND [id_manager] IS NULL) OR ([id_manager] = @Original_id_manager)) AND ((@IsNull_id_tkani = 1 AND [id_tkani] IS NULL) OR ([id_tkani] = @Original_id_tkani)) AND ((@IsNull_id_furnitur = 1 AND [id_furnitur] IS NULL) OR ([id_furnitur] = @Original_id_furnitur)) AND ((@IsNull_CountFurnit = 1 AND [CountFurnit] IS NULL) OR ([CountFurnit] = @Original_CountFurnit)) AND ((@IsNull_CountIzdel = 1 AND [CountIzdel] IS NULL) OR ([CountIzdel] = @Original_CountIzdel)))</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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_izdelie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_izdelie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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_id_zakaz" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_zakaz" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_zakaz" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_zakaz" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_manager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_manager" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_tkani" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tkani" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_tkani" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tkani" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_furnitur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_furnitur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_furnitur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_furnitur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountFurnit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFurnit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountFurnit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFurnit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountIzdel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzdel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountIzdel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzdel" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Orders] ([id_izdelie], [id_zakaz], [id_manager], [id_tkani], [id_furnitur], [CountFurnit], [CountIzdel]) VALUES (@id_izdelie, @id_zakaz, @id_manager, @id_tkani, @id_furnitur, @CountFurnit, @CountIzdel);
SELECT id_order, id_izdelie, id_zakaz, id_manager, id_tkani, id_furnitur, CountFurnit, CountIzdel FROM Orders WHERE (id_order = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" 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="Int32" Direction="Input" ParameterName="@id_zakaz" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_zakaz" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" 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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_tkani" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tkani" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_furnitur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_furnitur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountFurnit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFurnit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountIzdel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzdel" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id_order, id_izdelie, id_zakaz, id_manager, id_tkani, id_furnitur, CountFurnit, CountIzdel FROM dbo.Orders</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Orders] SET [id_izdelie] = @id_izdelie, [id_zakaz] = @id_zakaz, [id_manager] = @id_manager, [id_tkani] = @id_tkani, [id_furnitur] = @id_furnitur, [CountFurnit] = @CountFurnit, [CountIzdel] = @CountIzdel WHERE (([id_order] = @Original_id_order) AND ((@IsNull_id_izdelie = 1 AND [id_izdelie] IS NULL) OR ([id_izdelie] = @Original_id_izdelie)) AND ((@IsNull_id_zakaz = 1 AND [id_zakaz] IS NULL) OR ([id_zakaz] = @Original_id_zakaz)) AND ((@IsNull_id_manager = 1 AND [id_manager] IS NULL) OR ([id_manager] = @Original_id_manager)) AND ((@IsNull_id_tkani = 1 AND [id_tkani] IS NULL) OR ([id_tkani] = @Original_id_tkani)) AND ((@IsNull_id_furnitur = 1 AND [id_furnitur] IS NULL) OR ([id_furnitur] = @Original_id_furnitur)) AND ((@IsNull_CountFurnit = 1 AND [CountFurnit] IS NULL) OR ([CountFurnit] = @Original_CountFurnit)) AND ((@IsNull_CountIzdel = 1 AND [CountIzdel] IS NULL) OR ([CountIzdel] = @Original_CountIzdel)));
SELECT id_order, id_izdelie, id_zakaz, id_manager, id_tkani, id_furnitur, CountFurnit, CountIzdel FROM Orders WHERE (id_order = @id_order)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" 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="Int32" Direction="Input" ParameterName="@id_zakaz" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_zakaz" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" 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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_tkani" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tkani" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_furnitur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_furnitur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountFurnit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFurnit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountIzdel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzdel" 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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_izdelie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_izdelie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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_id_zakaz" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_zakaz" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_zakaz" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_zakaz" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_manager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_manager" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_tkani" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tkani" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_tkani" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tkani" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_furnitur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_furnitur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_furnitur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_furnitur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountFurnit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFurnit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountFurnit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFurnit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountIzdel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzdel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountIzdel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzdel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id_order" ColumnName="id_order" DataSourceName="dbFabrika2024.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_zakaz" DataSetColumn="id_zakaz" />
              <Mapping SourceColumn="id_manager" DataSetColumn="id_manager" />
              <Mapping SourceColumn="id_tkani" DataSetColumn="id_tkani" />
              <Mapping SourceColumn="id_furnitur" DataSetColumn="id_furnitur" />
              <Mapping SourceColumn="CountFurnit" DataSetColumn="CountFurnit" />
              <Mapping SourceColumn="CountIzdel" DataSetColumn="CountIzdel" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoleTableAdapter" GeneratorDataComponentClassName="RoleTableAdapter" Name="Role" UserDataComponentName="RoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbFabrika2024ConnectionString (Settings)" DbObjectName="dbFabrika2024.dbo.Role" 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].[Role] WHERE (([id_role] = @Original_id_role) AND ((@IsNull_Name_Role = 1 AND [Name_Role] IS NULL) OR ([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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name_Role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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].[Role] ([Name_Role]) VALUES (@Name_Role);
SELECT id_role, Name_Role FROM Role WHERE (id_role = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" 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.Role</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Role] SET [Name_Role] = @Name_Role WHERE (([id_role] = @Original_id_role) AND ((@IsNull_Name_Role = 1 AND [Name_Role] IS NULL) OR ([Name_Role] = @Original_Name_Role)));
SELECT id_role, Name_Role FROM Role WHERE (id_role = @id_role)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" 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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name_Role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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="dbFabrika2024.dbo.Role" 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="TkaniTableAdapter" GeneratorDataComponentClassName="TkaniTableAdapter" Name="Tkani" UserDataComponentName="TkaniTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbFabrika2024ConnectionString (Settings)" DbObjectName="dbFabrika2024.dbo.Tkani" 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].[Tkani] WHERE (([Id_Tkani] = @Original_Id_Tkani) AND ([id_cvet] = @Original_id_cvet) AND ((@IsNull_Shirina = 1 AND [Shirina] IS NULL) OR ([Shirina] = @Original_Shirina)) AND ((@IsNull_Dlina = 1 AND [Dlina] IS NULL) OR ([Dlina] = @Original_Dlina)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id_Tkani" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id_Tkani" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_cvet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cvet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Shirina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Shirina" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Shirina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Shirina" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Dlina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dlina" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Dlina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dlina" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Tkani] ([Nazvanie], [id_cvet], [Shirina], [Dlina], [Primechanie], [Photo]) VALUES (@Nazvanie, @id_cvet, @Shirina, @Dlina, @Primechanie, @Photo);
SELECT Id_Tkani, Nazvanie, id_cvet, Shirina, Dlina, Primechanie, Photo FROM Tkani WHERE (Id_Tkani = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nazvanie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_cvet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cvet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Shirina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Shirina" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Dlina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dlina" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Primechanie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Primechanie" 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_Tkani, Nazvanie, id_cvet, Shirina, Dlina, Primechanie, Photo FROM dbo.Tkani</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Tkani] SET [Nazvanie] = @Nazvanie, [id_cvet] = @id_cvet, [Shirina] = @Shirina, [Dlina] = @Dlina, [Primechanie] = @Primechanie, [Photo] = @Photo WHERE (([Id_Tkani] = @Original_Id_Tkani) AND ([id_cvet] = @Original_id_cvet) AND ((@IsNull_Shirina = 1 AND [Shirina] IS NULL) OR ([Shirina] = @Original_Shirina)) AND ((@IsNull_Dlina = 1 AND [Dlina] IS NULL) OR ([Dlina] = @Original_Dlina)));
SELECT Id_Tkani, Nazvanie, id_cvet, Shirina, Dlina, Primechanie, Photo FROM Tkani WHERE (Id_Tkani = @Id_Tkani)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nazvanie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nazvanie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_cvet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cvet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Shirina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Shirina" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Dlina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dlina" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Primechanie" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Primechanie" 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_Tkani" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id_Tkani" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_cvet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cvet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Shirina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Shirina" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Shirina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Shirina" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Dlina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dlina" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Dlina" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Dlina" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Id_Tkani" ColumnName="Id_Tkani" DataSourceName="dbFabrika2024.dbo.Tkani" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id_Tkani" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id_Tkani" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id_Tkani" DataSetColumn="Id_Tkani" />
              <Mapping SourceColumn="Nazvanie" DataSetColumn="Nazvanie" />
              <Mapping SourceColumn="id_cvet" DataSetColumn="id_cvet" />
              <Mapping SourceColumn="Shirina" DataSetColumn="Shirina" />
              <Mapping SourceColumn="Dlina" DataSetColumn="Dlina" />
              <Mapping SourceColumn="Primechanie" DataSetColumn="Primechanie" />
              <Mapping SourceColumn="Photo" DataSetColumn="Photo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbFabrika2024ConnectionString (Settings)" DbObjectName="dbFabrika2024.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_Passw = 1 AND [Passw] IS NULL) OR ([Passw] = @Original_Passw)) 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_Otch = 1 AND [Otch] IS NULL) OR ([Otch] = @Original_Otch)) 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_Passw" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Passw" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Passw" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Passw" 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_Otch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Otch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Otch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Otch" 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], [Passw], [id_role], [Surname], [Name], [Otch], [Phone]) VALUES (@login, @Passw, @id_role, @Surname, @Name, @Otch, @Phone);
SELECT Id_user, login, Passw, id_role, Surname, Name, Otch, 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="@Passw" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Passw" 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="@Otch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Otch" 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, Passw, id_role, Surname, Name, Otch, Phone FROM dbo.Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Users] SET [login] = @login, [Passw] = @Passw, [id_role] = @id_role, [Surname] = @Surname, [Name] = @Name, [Otch] = @Otch, [Phone] = @Phone WHERE (([Id_user] = @Original_Id_user) AND ((@IsNull_login = 1 AND [login] IS NULL) OR ([login] = @Original_login)) AND ((@IsNull_Passw = 1 AND [Passw] IS NULL) OR ([Passw] = @Original_Passw)) 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_Otch = 1 AND [Otch] IS NULL) OR ([Otch] = @Original_Otch)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)));
SELECT Id_user, login, Passw, id_role, Surname, Name, Otch, 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="@Passw" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Passw" 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="@Otch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Otch" 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_Passw" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Passw" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Passw" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Passw" 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_Otch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Otch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Otch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Otch" 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="dbFabrika2024.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="Passw" DataSetColumn="Passw" />
              <Mapping SourceColumn="id_role" DataSetColumn="id_role" />
              <Mapping SourceColumn="Surname" DataSetColumn="Surname" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Otch" DataSetColumn="Otch" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dbFabrika2024DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_UserDSName="dbFabrika2024DataSet" msprop:Generator_DataSetName="dbFabrika2024DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Cveta" msprop:Generator_RowEvHandlerName="CvetaRowChangeEventHandler" msprop:Generator_RowDeletedName="CvetaRowDeleted" msprop:Generator_RowDeletingName="CvetaRowDeleting" msprop:Generator_RowEvArgName="CvetaRowChangeEvent" msprop:Generator_TablePropName="Cveta" msprop:Generator_RowChangedName="CvetaRowChanged" msprop:Generator_RowChangingName="CvetaRowChanging" msprop:Generator_TableClassName="CvetaDataTable" msprop:Generator_RowClassName="CvetaRow" msprop:Generator_TableVarName="tableCveta" msprop:Generator_UserTableName="Cveta">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id_cvet" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="id_cvet" msprop:Generator_ColumnPropNameInTable="id_cvetColumn" msprop:Generator_ColumnVarNameInTable="columnid_cvet" msprop:Generator_UserColumnName="id_cvet" type="xs:int" />
              <xs:element name="Name_cvet" msprop:Generator_ColumnPropNameInRow="Name_cvet" msprop:Generator_ColumnPropNameInTable="Name_cvetColumn" msprop:Generator_ColumnVarNameInTable="columnName_cvet" msprop:Generator_UserColumnName="Name_cvet" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Furnitura" msprop:Generator_RowEvHandlerName="FurnituraRowChangeEventHandler" msprop:Generator_RowDeletedName="FurnituraRowDeleted" msprop:Generator_RowDeletingName="FurnituraRowDeleting" msprop:Generator_RowEvArgName="FurnituraRowChangeEvent" msprop:Generator_TablePropName="Furnitura" msprop:Generator_RowChangedName="FurnituraRowChanged" msprop:Generator_RowChangingName="FurnituraRowChanging" msprop:Generator_TableClassName="FurnituraDataTable" msprop:Generator_RowClassName="FurnituraRow" msprop:Generator_TableVarName="tableFurnitura" msprop:Generator_UserTableName="Furnitura">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idfur" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="idfur" msprop:Generator_ColumnPropNameInTable="idfurColumn" msprop:Generator_ColumnVarNameInTable="columnidfur" msprop:Generator_UserColumnName="idfur" type="xs:int" />
              <xs:element name="namefur" msprop:Generator_ColumnPropNameInRow="namefur" msprop:Generator_ColumnPropNameInTable="namefurColumn" msprop:Generator_ColumnVarNameInTable="columnnamefur" msprop:Generator_UserColumnName="namefur" 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: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: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" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" 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_izd" msprop:Generator_ColumnPropNameInRow="Name_izd" msprop:Generator_ColumnPropNameInTable="Name_izdColumn" msprop:Generator_ColumnVarNameInTable="columnName_izd" msprop:Generator_UserColumnName="Name_izd" 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" minOccurs="0" />
              <xs:element name="id_zakaz" msprop:Generator_ColumnPropNameInRow="id_zakaz" msprop:Generator_ColumnPropNameInTable="id_zakazColumn" msprop:Generator_ColumnVarNameInTable="columnid_zakaz" msprop:Generator_UserColumnName="id_zakaz" type="xs:int" minOccurs="0" />
              <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" minOccurs="0" />
              <xs:element name="id_tkani" msprop:Generator_ColumnPropNameInRow="id_tkani" msprop:Generator_ColumnPropNameInTable="id_tkaniColumn" msprop:Generator_ColumnVarNameInTable="columnid_tkani" msprop:Generator_UserColumnName="id_tkani" type="xs:int" minOccurs="0" />
              <xs:element name="id_furnitur" msprop:Generator_ColumnPropNameInRow="id_furnitur" msprop:Generator_ColumnPropNameInTable="id_furniturColumn" msprop:Generator_ColumnVarNameInTable="columnid_furnitur" msprop:Generator_UserColumnName="id_furnitur" type="xs:int" minOccurs="0" />
              <xs:element name="CountFurnit" msprop:Generator_ColumnPropNameInRow="CountFurnit" msprop:Generator_ColumnPropNameInTable="CountFurnitColumn" msprop:Generator_ColumnVarNameInTable="columnCountFurnit" msprop:Generator_UserColumnName="CountFurnit" type="xs:int" minOccurs="0" />
              <xs:element name="CountIzdel" msprop:Generator_ColumnPropNameInRow="CountIzdel" msprop:Generator_ColumnPropNameInTable="CountIzdelColumn" msprop:Generator_ColumnVarNameInTable="columnCountIzdel" msprop:Generator_UserColumnName="CountIzdel" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Role" msprop:Generator_RowEvHandlerName="RoleRowChangeEventHandler" msprop:Generator_RowDeletedName="RoleRowDeleted" msprop:Generator_RowDeletingName="RoleRowDeleting" msprop:Generator_RowEvArgName="RoleRowChangeEvent" msprop:Generator_TablePropName="Role" msprop:Generator_RowChangedName="RoleRowChanged" msprop:Generator_RowChangingName="RoleRowChanging" msprop:Generator_TableClassName="RoleDataTable" msprop:Generator_RowClassName="RoleRow" msprop:Generator_TableVarName="tableRole" msprop:Generator_UserTableName="Role">
          <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" 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="Tkani" msprop:Generator_RowEvHandlerName="TkaniRowChangeEventHandler" msprop:Generator_RowDeletedName="TkaniRowDeleted" msprop:Generator_RowDeletingName="TkaniRowDeleting" msprop:Generator_RowEvArgName="TkaniRowChangeEvent" msprop:Generator_TablePropName="Tkani" msprop:Generator_RowChangedName="TkaniRowChanged" msprop:Generator_RowChangingName="TkaniRowChanging" msprop:Generator_TableClassName="TkaniDataTable" msprop:Generator_RowClassName="TkaniRow" msprop:Generator_TableVarName="tableTkani" msprop:Generator_UserTableName="Tkani">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id_Tkani" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="Id_Tkani" msprop:Generator_ColumnPropNameInTable="Id_TkaniColumn" msprop:Generator_ColumnVarNameInTable="columnId_Tkani" msprop:Generator_UserColumnName="Id_Tkani" type="xs:int" />
              <xs:element name="Nazvanie" msprop:Generator_ColumnPropNameInRow="Nazvanie" msprop:Generator_ColumnPropNameInTable="NazvanieColumn" msprop:Generator_ColumnVarNameInTable="columnNazvanie" msprop:Generator_UserColumnName="Nazvanie">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id_cvet" msprop:Generator_ColumnPropNameInRow="id_cvet" msprop:Generator_ColumnPropNameInTable="id_cvetColumn" msprop:Generator_ColumnVarNameInTable="columnid_cvet" msprop:Generator_UserColumnName="id_cvet" type="xs:int" />
              <xs:element name="Shirina" msprop:Generator_ColumnPropNameInRow="Shirina" msprop:Generator_ColumnPropNameInTable="ShirinaColumn" msprop:Generator_ColumnVarNameInTable="columnShirina" msprop:Generator_UserColumnName="Shirina" type="xs:int" minOccurs="0" />
              <xs:element name="Dlina" msprop:Generator_ColumnPropNameInRow="Dlina" msprop:Generator_ColumnPropNameInTable="DlinaColumn" msprop:Generator_ColumnVarNameInTable="columnDlina" msprop:Generator_UserColumnName="Dlina" type="xs:int" minOccurs="0" />
              <xs:element name="Primechanie" msprop:Generator_ColumnPropNameInRow="Primechanie" msprop:Generator_ColumnPropNameInTable="PrimechanieColumn" msprop:Generator_ColumnVarNameInTable="columnPrimechanie" msprop:Generator_UserColumnName="Primechanie" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </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="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="Passw" msprop:Generator_ColumnPropNameInRow="Passw" msprop:Generator_ColumnPropNameInTable="PasswColumn" msprop:Generator_ColumnVarNameInTable="columnPassw" msprop:Generator_UserColumnName="Passw" 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="Otch" msprop:Generator_ColumnPropNameInRow="Otch" msprop:Generator_ColumnPropNameInTable="OtchColumn" msprop:Generator_ColumnVarNameInTable="columnOtch" msprop:Generator_UserColumnName="Otch" 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:Cveta" />
      <xs:field xpath="mstns:id_cvet" />
    </xs:unique>
    <xs:unique name="Furnitura_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Furnitura" />
      <xs:field xpath="mstns:idfur" />
    </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="Role_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Role" />
      <xs:field xpath="mstns:id_role" />
    </xs:unique>
    <xs:unique name="Tkani_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tkani" />
      <xs:field xpath="mstns:Id_Tkani" />
    </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_Orders_Furnitura" msdata:parent="Furnitura" msdata:child="Orders" msdata:parentkey="idfur" msdata:childkey="id_furnitur" msprop:Generator_UserParentTable="Furnitura" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Furnitura" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_ParentPropName="FurnituraRow" msprop:Generator_UserRelationName="FK_Orders_Furnitura" />
      <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_Tkani" msdata:parent="Tkani" msdata:child="Orders" msdata:parentkey="Id_Tkani" msdata:childkey="id_tkani" msprop:Generator_UserParentTable="Tkani" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Tkani" msprop:Generator_UserRelationName="FK_Orders_Tkani" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_ParentPropName="TkaniRow" />
      <msdata:Relationship name="FK_Orders_Users" 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_Users" msprop:Generator_UserRelationName="FK_Orders_Users" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_ParentPropName="UsersRow" />
      <msdata:Relationship name="FK_Tkani_Cveta" msdata:parent="Cveta" msdata:child="Tkani" msdata:parentkey="id_cvet" msdata:childkey="id_cvet" msprop:Generator_UserParentTable="Cveta" msprop:Generator_UserChildTable="Tkani" msprop:Generator_RelationVarName="relationFK_Tkani_Cveta" msprop:Generator_ChildPropName="GetTkaniRows" msprop:Generator_ParentPropName="CvetaRow" msprop:Generator_UserRelationName="FK_Tkani_Cveta" />
      <msdata:Relationship name="FK_Users_Role" msdata:parent="Role" msdata:child="Users" msdata:parentkey="id_role" msdata:childkey="id_role" msprop:Generator_UserParentTable="Role" msprop:Generator_UserChildTable="Users" msprop:Generator_RelationVarName="relationFK_Users_Role" msprop:Generator_ChildPropName="GetUsersRows" msprop:Generator_ParentPropName="RoleRow" msprop:Generator_UserRelationName="FK_Users_Role" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>