Practika24/СУБД Швейная фабрика/pracFabricaDataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="pracFabricaDataSet" targetNamespace="http://tempuri.org/pracFabricaDataSet.xsd" xmlns:mstns="http://tempuri.org/pracFabricaDataSet.xsd" xmlns="http://tempuri.org/pracFabricaDataSet.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="pracFabricaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="pracFabricaConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.СУБД_Швейная_фабрика.Properties.Settings.GlobalReference.Default.pracFabricaConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ColorTableAdapter" GeneratorDataComponentClassName="ColorTableAdapter" Name="Color" UserDataComponentName="ColorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="pracFabricaConnectionString (Settings)" DbObjectName="pracFabrica.dbo.Color" 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].[Color] WHERE (([id_colors] = @Original_id_colors) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_colors" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_colors" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Color] ([Title]) VALUES (@Title);
SELECT id_colors, Title FROM Color WHERE (id_colors = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id_colors, Title FROM dbo.Color</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Color] SET [Title] = @Title WHERE (([id_colors] = @Original_id_colors) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)));
SELECT id_colors, Title FROM Color WHERE (id_colors = @id_colors)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_colors" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_colors" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id_colors" ColumnName="id_colors" DataSourceName="pracFabrica.dbo.Color" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id_colors" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id_colors" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id_colors" DataSetColumn="id_colors" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FurnituraTableAdapter" GeneratorDataComponentClassName="FurnituraTableAdapter" Name="Furnitura" UserDataComponentName="FurnituraTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="pracFabricaConnectionString (Settings)" DbObjectName="pracFabrica.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 (([id_fur] = @Original_id_fur) AND ((@IsNull_namefur = 1 AND [namefur] IS NULL) OR ([namefur] = @Original_namefur)) AND ((@IsNull_photo = 1 AND [photo] IS NULL) OR ([photo] = @Original_photo)) 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_id_fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_fur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_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_photo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="photo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="photo" 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 id_fur, namefur, photo, countfur FROM Furnitura WHERE (id_fur = 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="String" Direction="Input" ParameterName="@photo" Precision="0" ProviderType="NVarChar" 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 id_fur, 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 (([id_fur] = @Original_id_fur) AND ((@IsNull_namefur = 1 AND [namefur] IS NULL) OR ([namefur] = @Original_namefur)) AND ((@IsNull_photo = 1 AND [photo] IS NULL) OR ([photo] = @Original_photo)) AND ((@IsNull_countfur = 1 AND [countfur] IS NULL) OR ([countfur] = @Original_countfur)));
SELECT id_fur, namefur, photo, countfur FROM Furnitura WHERE (id_fur = @id_fur)</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="String" Direction="Input" ParameterName="@photo" Precision="0" ProviderType="NVarChar" 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_id_fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_fur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_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_photo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="photo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="photo" 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="id_fur" ColumnName="id_fur" DataSourceName="pracFabrica.dbo.Furnitura" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id_fur" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id_fur" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id_fur" DataSetColumn="id_fur" />
              <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="pracFabricaConnectionString (Settings)" DbObjectName="pracFabrica.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_izd] = @Original_id_izd) 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_izd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_izd" 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_izd, name_izd, length, width FROM Izdelie WHERE (id_izd = 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_izd, 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_izd] = @Original_id_izd) 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_izd, name_izd, length, width FROM Izdelie WHERE (id_izd = @id_izd)</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_izd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_izd" 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_izd" ColumnName="id_izd" DataSourceName="pracFabrica.dbo.Izdelie" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id_izd" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id_izd" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id_izd" DataSetColumn="id_izd" />
              <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="pracFabricaConnectionString (Settings)" DbObjectName="pracFabrica.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_izd = 1 AND [id_izd] IS NULL) OR ([id_izd] = @Original_id_izd)) AND ((@IsNull_id_zak = 1 AND [id_zak] IS NULL) OR ([id_zak] = @Original_id_zak)) AND ((@IsNull_id_men = 1 AND [id_men] IS NULL) OR ([id_men] = @Original_id_men)) AND ((@IsNull_id_tkan = 1 AND [id_tkan] IS NULL) OR ([id_tkan] = @Original_id_tkan)) AND ((@IsNull_id_fur = 1 AND [id_fur] IS NULL) OR ([id_fur] = @Original_id_fur)) AND ((@IsNull_CountFur = 1 AND [CountFur] IS NULL) OR ([CountFur] = @Original_CountFur)) AND ((@IsNull_CountIzd = 1 AND [CountIzd] IS NULL) OR ([CountIzd] = @Original_CountIzd)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_order" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_izd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_izd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_izd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_izd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_zak" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_zak" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_zak" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_zak" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_men" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_men" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_men" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_men" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_tkan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tkan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_tkan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tkan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_fur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_fur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Orders] ([id_izd], [id_zak], [id_men], [id_tkan], [id_fur], [CountFur], [CountIzd]) VALUES (@id_izd, @id_zak, @id_men, @id_tkan, @id_fur, @CountFur, @CountIzd);
SELECT id_order, id_izd, id_zak, id_men, id_tkan, id_fur, CountFur, CountIzd FROM Orders WHERE (id_order = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_izd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_izd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_zak" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_zak" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_men" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_men" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_tkan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tkan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_fur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id_order, id_izd, id_zak, id_men, id_tkan, id_fur, CountFur, CountIzd FROM dbo.Orders</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Orders] SET [id_izd] = @id_izd, [id_zak] = @id_zak, [id_men] = @id_men, [id_tkan] = @id_tkan, [id_fur] = @id_fur, [CountFur] = @CountFur, [CountIzd] = @CountIzd WHERE (([id_order] = @Original_id_order) AND ((@IsNull_id_izd = 1 AND [id_izd] IS NULL) OR ([id_izd] = @Original_id_izd)) AND ((@IsNull_id_zak = 1 AND [id_zak] IS NULL) OR ([id_zak] = @Original_id_zak)) AND ((@IsNull_id_men = 1 AND [id_men] IS NULL) OR ([id_men] = @Original_id_men)) AND ((@IsNull_id_tkan = 1 AND [id_tkan] IS NULL) OR ([id_tkan] = @Original_id_tkan)) AND ((@IsNull_id_fur = 1 AND [id_fur] IS NULL) OR ([id_fur] = @Original_id_fur)) AND ((@IsNull_CountFur = 1 AND [CountFur] IS NULL) OR ([CountFur] = @Original_CountFur)) AND ((@IsNull_CountIzd = 1 AND [CountIzd] IS NULL) OR ([CountIzd] = @Original_CountIzd)));
SELECT id_order, id_izd, id_zak, id_men, id_tkan, id_fur, CountFur, CountIzd FROM Orders WHERE (id_order = @id_order)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_izd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_izd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_zak" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_zak" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_men" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_men" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_tkan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tkan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_fur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_order" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_izd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_izd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_izd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_izd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_zak" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_zak" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_zak" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_zak" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_men" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_men" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_men" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_men" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_tkan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tkan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_tkan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tkan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_fur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_fur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_fur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountIzd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountIzd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id_order" ColumnName="id_order" DataSourceName="pracFabrica.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_izd" DataSetColumn="id_izd" />
              <Mapping SourceColumn="id_zak" DataSetColumn="id_zak" />
              <Mapping SourceColumn="id_men" DataSetColumn="id_men" />
              <Mapping SourceColumn="id_tkan" DataSetColumn="id_tkan" />
              <Mapping SourceColumn="id_fur" DataSetColumn="id_fur" />
              <Mapping SourceColumn="CountFur" DataSetColumn="CountFur" />
              <Mapping SourceColumn="CountIzd" DataSetColumn="CountIzd" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RolesTableAdapter" GeneratorDataComponentClassName="RolesTableAdapter" Name="Roles" UserDataComponentName="RolesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="pracFabricaConnectionString (Settings)" DbObjectName="pracFabrica.dbo.Roles" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Roles] WHERE (([id_Roles] = @Original_id_Roles) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_Roles" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_Roles" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Roles] ([Title]) VALUES (@Title);
SELECT id_Roles, Title FROM Roles WHERE (id_Roles = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id_Roles, Title FROM dbo.Roles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Roles] SET [Title] = @Title WHERE (([id_Roles] = @Original_id_Roles) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)));
SELECT id_Roles, Title FROM Roles WHERE (id_Roles = @id_Roles)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_Roles" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_Roles" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id_Roles" ColumnName="id_Roles" DataSourceName="pracFabrica.dbo.Roles" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id_Roles" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id_Roles" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id_Roles" DataSetColumn="id_Roles" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TkanTableAdapter" GeneratorDataComponentClassName="TkanTableAdapter" Name="Tkan" UserDataComponentName="TkanTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="pracFabricaConnectionString (Settings)" DbObjectName="pracFabrica.dbo.Tkan" 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].[Tkan] WHERE (([id_Tkan] = @Original_id_Tkan) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_id_color = 1 AND [id_color] IS NULL) OR ([id_color] = @Original_id_color)) AND ((@IsNull_Length = 1 AND [Length] IS NULL) OR ([Length] = @Original_Length)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)) AND ((@IsNull_Comment = 1 AND [Comment] IS NULL) OR ([Comment] = @Original_Comment)) AND ((@IsNull_NamePhoto = 1 AND [NamePhoto] IS NULL) OR ([NamePhoto] = @Original_NamePhoto)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_Tkan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_Tkan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_color" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Comment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NamePhoto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NamePhoto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NamePhoto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NamePhoto" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Tkan] ([Title], [id_color], [Length], [Width], [Comment], [NamePhoto]) VALUES (@Title, @id_color, @Length, @Width, @Comment, @NamePhoto);
SELECT id_Tkan, Title, id_color, Length, Width, Comment, NamePhoto FROM Tkan WHERE (id_Tkan = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NamePhoto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NamePhoto" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id_Tkan, Title, id_color, Length, Width, Comment, NamePhoto FROM dbo.Tkan</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Tkan] SET [Title] = @Title, [id_color] = @id_color, [Length] = @Length, [Width] = @Width, [Comment] = @Comment, [NamePhoto] = @NamePhoto WHERE (([id_Tkan] = @Original_id_Tkan) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_id_color = 1 AND [id_color] IS NULL) OR ([id_color] = @Original_id_color)) AND ((@IsNull_Length = 1 AND [Length] IS NULL) OR ([Length] = @Original_Length)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)) AND ((@IsNull_Comment = 1 AND [Comment] IS NULL) OR ([Comment] = @Original_Comment)) AND ((@IsNull_NamePhoto = 1 AND [NamePhoto] IS NULL) OR ([NamePhoto] = @Original_NamePhoto)));
SELECT id_Tkan, Title, id_color, Length, Width, Comment, NamePhoto FROM Tkan WHERE (id_Tkan = @id_Tkan)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NamePhoto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NamePhoto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_Tkan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_Tkan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_color" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Length" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Width" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Comment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NamePhoto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NamePhoto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NamePhoto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NamePhoto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id_Tkan" ColumnName="id_Tkan" DataSourceName="pracFabrica.dbo.Tkan" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id_Tkan" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id_Tkan" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id_Tkan" DataSetColumn="id_Tkan" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="id_color" DataSetColumn="id_color" />
              <Mapping SourceColumn="Length" DataSetColumn="Length" />
              <Mapping SourceColumn="Width" DataSetColumn="Width" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="NamePhoto" DataSetColumn="NamePhoto" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="pracFabricaConnectionString (Settings)" DbObjectName="pracFabrica.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_pass = 1 AND [pass] IS NULL) OR ([pass] = @Original_pass)) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_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_pass" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pass" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_pass" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pass" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="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], [pass], [Role], [Surname], [Name], [Otch], [Phone]) VALUES (@login, @pass, @Role, @Surname, @Name, @Otch, @Phone);
SELECT id_User, login, pass, 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="@pass" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pass" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="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, pass, 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, [pass] = @pass, [Role] = @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_pass = 1 AND [pass] IS NULL) OR ([pass] = @Original_pass)) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_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, pass, 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="@pass" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pass" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="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_pass" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pass" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_pass" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pass" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Role" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="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="pracFabrica.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="pass" DataSetColumn="pass" />
              <Mapping SourceColumn="Role" DataSetColumn="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="pracFabricaDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_UserDSName="pracFabricaDataSet" msprop:Generator_DataSetName="pracFabricaDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Color" msprop:Generator_RowEvHandlerName="ColorRowChangeEventHandler" msprop:Generator_RowDeletedName="ColorRowDeleted" msprop:Generator_RowDeletingName="ColorRowDeleting" msprop:Generator_RowEvArgName="ColorRowChangeEvent" msprop:Generator_TablePropName="Color" msprop:Generator_RowChangedName="ColorRowChanged" msprop:Generator_RowChangingName="ColorRowChanging" msprop:Generator_TableClassName="ColorDataTable" msprop:Generator_RowClassName="ColorRow" msprop:Generator_TableVarName="tableColor" msprop:Generator_UserTableName="Color">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id_colors" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="id_colors" msprop:Generator_ColumnPropNameInTable="id_colorsColumn" msprop:Generator_ColumnVarNameInTable="columnid_colors" msprop:Generator_UserColumnName="id_colors" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_UserColumnName="Title" 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="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="id_fur" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="id_fur" msprop:Generator_ColumnPropNameInTable="id_furColumn" msprop:Generator_ColumnVarNameInTable="columnid_fur" msprop:Generator_UserColumnName="id_fur" type="xs:int" />
              <xs:element name="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" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <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_izd" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="id_izd" msprop:Generator_ColumnPropNameInTable="id_izdColumn" msprop:Generator_ColumnVarNameInTable="columnid_izd" msprop:Generator_UserColumnName="id_izd" 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_izd" msprop:Generator_ColumnPropNameInRow="id_izd" msprop:Generator_ColumnPropNameInTable="id_izdColumn" msprop:Generator_ColumnVarNameInTable="columnid_izd" msprop:Generator_UserColumnName="id_izd" type="xs:int" minOccurs="0" />
              <xs:element name="id_zak" msprop:Generator_ColumnPropNameInRow="id_zak" msprop:Generator_ColumnPropNameInTable="id_zakColumn" msprop:Generator_ColumnVarNameInTable="columnid_zak" msprop:Generator_UserColumnName="id_zak" type="xs:int" minOccurs="0" />
              <xs:element name="id_men" msprop:Generator_ColumnPropNameInRow="id_men" msprop:Generator_ColumnPropNameInTable="id_menColumn" msprop:Generator_ColumnVarNameInTable="columnid_men" msprop:Generator_UserColumnName="id_men" type="xs:int" minOccurs="0" />
              <xs:element name="id_tkan" msprop:Generator_ColumnPropNameInRow="id_tkan" msprop:Generator_ColumnPropNameInTable="id_tkanColumn" msprop:Generator_ColumnVarNameInTable="columnid_tkan" msprop:Generator_UserColumnName="id_tkan" type="xs:int" minOccurs="0" />
              <xs:element name="id_fur" msprop:Generator_ColumnPropNameInRow="id_fur" msprop:Generator_ColumnPropNameInTable="id_furColumn" msprop:Generator_ColumnVarNameInTable="columnid_fur" msprop:Generator_UserColumnName="id_fur" type="xs:int" 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:element name="CountIzd" msprop:Generator_ColumnPropNameInRow="CountIzd" msprop:Generator_ColumnPropNameInTable="CountIzdColumn" msprop:Generator_ColumnVarNameInTable="columnCountIzd" msprop:Generator_UserColumnName="CountIzd" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Roles" msprop:Generator_RowEvHandlerName="RolesRowChangeEventHandler" msprop:Generator_RowDeletedName="RolesRowDeleted" msprop:Generator_RowDeletingName="RolesRowDeleting" msprop:Generator_RowEvArgName="RolesRowChangeEvent" msprop:Generator_TablePropName="Roles" msprop:Generator_RowChangedName="RolesRowChanged" msprop:Generator_RowChangingName="RolesRowChanging" msprop:Generator_TableClassName="RolesDataTable" msprop:Generator_RowClassName="RolesRow" msprop:Generator_TableVarName="tableRoles" msprop:Generator_UserTableName="Roles">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id_Roles" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="id_Roles" msprop:Generator_ColumnPropNameInTable="id_RolesColumn" msprop:Generator_ColumnVarNameInTable="columnid_Roles" msprop:Generator_UserColumnName="id_Roles" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_UserColumnName="Title" 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="Tkan" msprop:Generator_RowEvHandlerName="TkanRowChangeEventHandler" msprop:Generator_RowDeletedName="TkanRowDeleted" msprop:Generator_RowDeletingName="TkanRowDeleting" msprop:Generator_RowEvArgName="TkanRowChangeEvent" msprop:Generator_TablePropName="Tkan" msprop:Generator_RowChangedName="TkanRowChanged" msprop:Generator_RowChangingName="TkanRowChanging" msprop:Generator_TableClassName="TkanDataTable" msprop:Generator_RowClassName="TkanRow" msprop:Generator_TableVarName="tableTkan" msprop:Generator_UserTableName="Tkan">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id_Tkan" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="id_Tkan" msprop:Generator_ColumnPropNameInTable="id_TkanColumn" msprop:Generator_ColumnVarNameInTable="columnid_Tkan" msprop:Generator_UserColumnName="id_Tkan" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_UserColumnName="Title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id_color" msprop:Generator_ColumnPropNameInRow="id_color" msprop:Generator_ColumnPropNameInTable="id_colorColumn" msprop:Generator_ColumnVarNameInTable="columnid_color" msprop:Generator_UserColumnName="id_color" type="xs:int" minOccurs="0" />
              <xs:element name="Length" msprop:Generator_ColumnPropNameInRow="Length" msprop:Generator_ColumnPropNameInTable="LengthColumn" msprop:Generator_ColumnVarNameInTable="columnLength" msprop:Generator_UserColumnName="Length" type="xs:int" minOccurs="0" />
              <xs:element name="Width" msprop:Generator_ColumnPropNameInRow="Width" msprop:Generator_ColumnPropNameInTable="WidthColumn" msprop:Generator_ColumnVarNameInTable="columnWidth" msprop:Generator_UserColumnName="Width" type="xs:int" minOccurs="0" />
              <xs:element name="Comment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_UserColumnName="Comment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NamePhoto" msprop:Generator_ColumnPropNameInRow="NamePhoto" msprop:Generator_ColumnPropNameInTable="NamePhotoColumn" msprop:Generator_ColumnVarNameInTable="columnNamePhoto" msprop:Generator_UserColumnName="NamePhoto" 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="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="pass" msprop:Generator_ColumnPropNameInRow="pass" msprop:Generator_ColumnPropNameInTable="passColumn" msprop:Generator_ColumnVarNameInTable="columnpass" msprop:Generator_UserColumnName="pass" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Role" msprop:Generator_ColumnPropNameInRow="Role" msprop:Generator_ColumnPropNameInTable="RoleColumn" msprop:Generator_ColumnVarNameInTable="columnRole" msprop:Generator_UserColumnName="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:Color" />
      <xs:field xpath="mstns:id_colors" />
    </xs:unique>
    <xs:unique name="Furnitura_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Furnitura" />
      <xs:field xpath="mstns:id_fur" />
    </xs:unique>
    <xs:unique name="Izdelie_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Izdelie" />
      <xs:field xpath="mstns:id_izd" />
    </xs:unique>
    <xs:unique name="Orders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Orders" />
      <xs:field xpath="mstns:id_order" />
    </xs:unique>
    <xs:unique name="Roles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Roles" />
      <xs:field xpath="mstns:id_Roles" />
    </xs:unique>
    <xs:unique name="Tkan_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tkan" />
      <xs:field xpath="mstns:id_Tkan" />
    </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="id_fur" msdata:childkey="id_fur" 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_izd" msdata:childkey="id_izd" 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_Tkan" msdata:parent="Tkan" msdata:child="Orders" msdata:parentkey="id_Tkan" msdata:childkey="id_tkan" msprop:Generator_UserParentTable="Tkan" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Tkan" msprop:Generator_UserRelationName="FK_Orders_Tkan" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_ParentPropName="TkanRow" />
      <msdata:Relationship name="FK_Orders_Users1" msdata:parent="Users" msdata:child="Orders" msdata:parentkey="id_User" msdata:childkey="id_men" msprop:Generator_UserParentTable="Users" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Users1" msprop:Generator_UserRelationName="FK_Orders_Users1" msprop:Generator_ChildPropName="GetOrdersRowsByFK_Orders_Users1" msprop:Generator_ParentPropName="UsersRowByFK_Orders_Users1" />
      <msdata:Relationship name="FK_Orders_Users2" msdata:parent="Users" msdata:child="Orders" msdata:parentkey="id_User" msdata:childkey="id_zak" msprop:Generator_UserParentTable="Users" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Users2" msprop:Generator_UserRelationName="FK_Orders_Users2" msprop:Generator_ChildPropName="GetOrdersRowsByFK_Orders_Users2" msprop:Generator_ParentPropName="UsersRowByFK_Orders_Users2" />
      <msdata:Relationship name="FK_Tkan_Color" msdata:parent="Color" msdata:child="Tkan" msdata:parentkey="id_colors" msdata:childkey="id_color" msprop:Generator_UserParentTable="Color" msprop:Generator_UserChildTable="Tkan" msprop:Generator_RelationVarName="relationFK_Tkan_Color" msprop:Generator_ChildPropName="GetTkanRows" msprop:Generator_ParentPropName="ColorRow" msprop:Generator_UserRelationName="FK_Tkan_Color" />
      <msdata:Relationship name="FK_Users_Roles" msdata:parent="Roles" msdata:child="Users" msdata:parentkey="id_Roles" msdata:childkey="Role" msprop:Generator_UserParentTable="Roles" msprop:Generator_UserChildTable="Users" msprop:Generator_RelationVarName="relationFK_Users_Roles" msprop:Generator_ChildPropName="GetUsersRows" msprop:Generator_ParentPropName="RolesRow" msprop:Generator_UserRelationName="FK_Users_Roles" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>