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

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="FabrikaLDADataSet" targetNamespace="http://tempuri.org/FabrikaLDADataSet.xsd" xmlns:mstns="http://tempuri.org/FabrikaLDADataSet.xsd" xmlns="http://tempuri.org/FabrikaLDADataSet.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="FabrikaLDAConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="FabrikaLDAConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.СУБД_Швейная_фабрика.Properties.Settings.GlobalReference.Default.FabrikaLDAConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClothTableAdapter" GeneratorDataComponentClassName="ClothTableAdapter" Name="Cloth" UserDataComponentName="ClothTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FabrikaLDAConnectionString (Settings)" DbObjectName="FabrikaLDA.dbo.Cloth" 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].[Cloth] WHERE (([IdCloth] = @Original_IdCloth) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_IdColor = 1 AND [IdColor] IS NULL) OR ([IdColor] = @Original_IdColor)) AND ((@IsNull_Weight = 1 AND [Weight] IS NULL) OR ([Weight] = @Original_Weight)) AND ((@IsNull_Height = 1 AND [Height] IS NULL) OR ([Height] = @Original_Height)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdCloth" 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_IdColor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdColor" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdColor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdColor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Height" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Height" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Height" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Height" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" 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" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Cloth] ([Title], [IdColor], [Weight], [Height], [Note], [Photo]) VALUES (@Title, @IdColor, @Weight, @Height, @Note, @Photo);
SELECT IdCloth, Title, IdColor, Weight, Height, Note, Photo FROM Cloth WHERE (IdCloth = 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="@IdColor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdColor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Height" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Height" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" 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" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdCloth, Title, IdColor, Weight, Height, Note, Photo FROM dbo.Cloth</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Cloth] SET [Title] = @Title, [IdColor] = @IdColor, [Weight] = @Weight, [Height] = @Height, [Note] = @Note, [Photo] = @Photo WHERE (([IdCloth] = @Original_IdCloth) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_IdColor = 1 AND [IdColor] IS NULL) OR ([IdColor] = @Original_IdColor)) AND ((@IsNull_Weight = 1 AND [Weight] IS NULL) OR ([Weight] = @Original_Weight)) AND ((@IsNull_Height = 1 AND [Height] IS NULL) OR ([Height] = @Original_Height)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo)));
SELECT IdCloth, Title, IdColor, Weight, Height, Note, Photo FROM Cloth WHERE (IdCloth = @IdCloth)</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="@IdColor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdColor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Height" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Height" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" 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="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdCloth" 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_IdColor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdColor" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdColor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdColor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Weight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Weight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Height" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Height" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Height" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Height" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Note" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" 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="false" AutogeneratedName="IdCloth" ColumnName="IdCloth" DataSourceName="FabrikaLDA.dbo.Cloth" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdCloth" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdCloth" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdCloth" DataSetColumn="IdCloth" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="IdColor" DataSetColumn="IdColor" />
              <Mapping SourceColumn="Weight" DataSetColumn="Weight" />
              <Mapping SourceColumn="Height" DataSetColumn="Height" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="Photo" DataSetColumn="Photo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ColorsTableAdapter" GeneratorDataComponentClassName="ColorsTableAdapter" Name="Colors" UserDataComponentName="ColorsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FabrikaLDAConnectionString (Settings)" DbObjectName="FabrikaLDA.dbo.Colors" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Colors] WHERE (([IdColor] = @Original_IdColor) 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_IdColor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdColor" 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].[Colors] ([Title]) VALUES (@Title);
SELECT IdColor, Title FROM Colors WHERE (IdColor = 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 IdColor, Title FROM dbo.Colors</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Colors] SET [Title] = @Title WHERE (([IdColor] = @Original_IdColor) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)));
SELECT IdColor, Title FROM Colors WHERE (IdColor = @IdColor)</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_IdColor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdColor" 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="IdColor" ColumnName="IdColor" DataSourceName="FabrikaLDA.dbo.Colors" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdColor" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdColor" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdColor" DataSetColumn="IdColor" />
              <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="FabrikaLDAConnectionString (Settings)" DbObjectName="FabrikaLDA.dbo.Furnitura" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Furnitura] WHERE (([idfur] = @Original_idfur) AND ((@IsNull_namefur = 1 AND [namefur] IS NULL) OR ([namefur] = @Original_namefur)) AND ((@IsNull_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_idfur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idfur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_namefur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="namefur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_namefur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="namefur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_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 idfur, namefur, photo, countfur FROM Furnitura WHERE (idfur = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@namefur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="namefur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="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 idfur, namefur, photo, countfur FROM dbo.Furnitura</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Furnitura] SET [namefur] = @namefur, [photo] = @photo, [countfur] = @countfur WHERE (([idfur] = @Original_idfur) AND ((@IsNull_namefur = 1 AND [namefur] IS NULL) OR ([namefur] = @Original_namefur)) AND ((@IsNull_photo = 1 AND [photo] IS NULL) OR ([photo] = @Original_photo)) AND ((@IsNull_countfur = 1 AND [countfur] IS NULL) OR ([countfur] = @Original_countfur)));
SELECT idfur, namefur, photo, countfur FROM Furnitura WHERE (idfur = @idfur)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@namefur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="namefur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="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_idfur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idfur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_namefur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="namefur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_namefur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="namefur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_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="idfur" ColumnName="idfur" DataSourceName="FabrikaLDA.dbo.Furnitura" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idfur" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idfur" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idfur" DataSetColumn="idfur" />
              <Mapping SourceColumn="namefur" DataSetColumn="namefur" />
              <Mapping SourceColumn="photo" DataSetColumn="photo" />
              <Mapping SourceColumn="countfur" DataSetColumn="countfur" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrdersTableAdapter" GeneratorDataComponentClassName="OrdersTableAdapter" Name="Orders" UserDataComponentName="OrdersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FabrikaLDAConnectionString (Settings)" DbObjectName="FabrikaLDA.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 (([IdOrder] = @Original_IdOrder) AND ((@IsNull_IdProduct = 1 AND [IdProduct] IS NULL) OR ([IdProduct] = @Original_IdProduct)) AND ((@IsNull_IdClient = 1 AND [IdClient] IS NULL) OR ([IdClient] = @Original_IdClient)) AND ((@IsNull_IdManager = 1 AND [IdManager] IS NULL) OR ([IdManager] = @Original_IdManager)) AND ((@IsNull_IdCloth = 1 AND [IdCloth] IS NULL) OR ([IdCloth] = @Original_IdCloth)) AND ((@IsNull_IdFur = 1 AND [IdFur] IS NULL) OR ([IdFur] = @Original_IdFur)) AND ((@IsNull_CountFurnitura = 1 AND [CountFurnitura] IS NULL) OR ([CountFurnitura] = @Original_CountFurnitura)) AND ((@IsNull_CountProduct = 1 AND [CountProduct] IS NULL) OR ([CountProduct] = @Original_CountProduct)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdOrder" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdOrder" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProduct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdManager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdManager" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdManager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdManager" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdCloth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdCloth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdFur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdFur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountFurnitura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFurnitura" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountFurnitura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFurnitura" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountProduct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Orders] ([IdProduct], [IdClient], [IdManager], [IdCloth], [IdFur], [CountFurnitura], [CountProduct]) VALUES (@IdProduct, @IdClient, @IdManager, @IdCloth, @IdFur, @CountFurnitura, @CountProduct);
SELECT IdOrder, IdProduct, IdClient, IdManager, IdCloth, IdFur, CountFurnitura, CountProduct FROM Orders WHERE (IdOrder = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdManager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdManager" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdCloth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdFur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountFurnitura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFurnitura" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdOrder, IdProduct, IdClient, IdManager, IdCloth, IdFur, CountFurnitura, CountProduct FROM dbo.Orders</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Orders] SET [IdProduct] = @IdProduct, [IdClient] = @IdClient, [IdManager] = @IdManager, [IdCloth] = @IdCloth, [IdFur] = @IdFur, [CountFurnitura] = @CountFurnitura, [CountProduct] = @CountProduct WHERE (([IdOrder] = @Original_IdOrder) AND ((@IsNull_IdProduct = 1 AND [IdProduct] IS NULL) OR ([IdProduct] = @Original_IdProduct)) AND ((@IsNull_IdClient = 1 AND [IdClient] IS NULL) OR ([IdClient] = @Original_IdClient)) AND ((@IsNull_IdManager = 1 AND [IdManager] IS NULL) OR ([IdManager] = @Original_IdManager)) AND ((@IsNull_IdCloth = 1 AND [IdCloth] IS NULL) OR ([IdCloth] = @Original_IdCloth)) AND ((@IsNull_IdFur = 1 AND [IdFur] IS NULL) OR ([IdFur] = @Original_IdFur)) AND ((@IsNull_CountFurnitura = 1 AND [CountFurnitura] IS NULL) OR ([CountFurnitura] = @Original_CountFurnitura)) AND ((@IsNull_CountProduct = 1 AND [CountProduct] IS NULL) OR ([CountProduct] = @Original_CountProduct)));
SELECT IdOrder, IdProduct, IdClient, IdManager, IdCloth, IdFur, CountFurnitura, CountProduct FROM Orders WHERE (IdOrder = @IdOrder)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdManager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdManager" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdCloth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdFur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountFurnitura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFurnitura" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CountProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdOrder" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdOrder" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProduct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdManager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdManager" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdManager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdManager" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdCloth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdCloth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdCloth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdFur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdFur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdFur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountFurnitura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFurnitura" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountFurnitura" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountFurnitura" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountProduct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CountProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdOrder" ColumnName="IdOrder" DataSourceName="FabrikaLDA.dbo.Orders" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdOrder" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdOrder" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdOrder" DataSetColumn="IdOrder" />
              <Mapping SourceColumn="IdProduct" DataSetColumn="IdProduct" />
              <Mapping SourceColumn="IdClient" DataSetColumn="IdClient" />
              <Mapping SourceColumn="IdManager" DataSetColumn="IdManager" />
              <Mapping SourceColumn="IdCloth" DataSetColumn="IdCloth" />
              <Mapping SourceColumn="IdFur" DataSetColumn="IdFur" />
              <Mapping SourceColumn="CountFurnitura" DataSetColumn="CountFurnitura" />
              <Mapping SourceColumn="CountProduct" DataSetColumn="CountProduct" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductsTableAdapter" GeneratorDataComponentClassName="ProductsTableAdapter" Name="Products" UserDataComponentName="ProductsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FabrikaLDAConnectionString (Settings)" DbObjectName="FabrikaLDA.dbo.Products" 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].[Products] WHERE (([IdProduct] = @Original_IdProduct) AND ((@IsNull_TitleProduct = 1 AND [TitleProduct] IS NULL) OR ([TitleProduct] = @Original_TitleProduct)) AND ((@IsNull_Lenght = 1 AND [Lenght] IS NULL) OR ([Lenght] = @Original_Lenght)) 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_IdProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TitleProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TitleProduct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TitleProduct" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TitleProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Lenght" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lenght" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Lenght" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lenght" 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].[Products] ([TitleProduct], [Lenght], [Width]) VALUES (@TitleProduct, @Lenght, @Width);
SELECT IdProduct, TitleProduct, Lenght, Width FROM Products WHERE (IdProduct = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TitleProduct" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TitleProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Lenght" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lenght" 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 IdProduct, TitleProduct, Lenght, Width FROM dbo.Products</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Products] SET [TitleProduct] = @TitleProduct, [Lenght] = @Lenght, [Width] = @Width WHERE (([IdProduct] = @Original_IdProduct) AND ((@IsNull_TitleProduct = 1 AND [TitleProduct] IS NULL) OR ([TitleProduct] = @Original_TitleProduct)) AND ((@IsNull_Lenght = 1 AND [Lenght] IS NULL) OR ([Lenght] = @Original_Lenght)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)));
SELECT IdProduct, TitleProduct, Lenght, Width FROM Products WHERE (IdProduct = @IdProduct)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TitleProduct" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TitleProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Lenght" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lenght" 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_IdProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TitleProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TitleProduct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TitleProduct" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TitleProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Lenght" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lenght" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Lenght" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lenght" 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="IdProduct" ColumnName="IdProduct" DataSourceName="FabrikaLDA.dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdProduct" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdProduct" DataSetColumn="IdProduct" />
              <Mapping SourceColumn="TitleProduct" DataSetColumn="TitleProduct" />
              <Mapping SourceColumn="Lenght" DataSetColumn="Lenght" />
              <Mapping SourceColumn="Width" DataSetColumn="Width" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RolesTableAdapter" GeneratorDataComponentClassName="RolesTableAdapter" Name="Roles" UserDataComponentName="RolesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FabrikaLDAConnectionString (Settings)" DbObjectName="FabrikaLDA.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 (([IdRole] = @Original_IdRole) AND ([Title] = @Original_Title))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" 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] ([IdRole], [Title]) VALUES (@IdRole, @Title);
SELECT IdRole, Title FROM Roles WHERE (IdRole = @IdRole)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" 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 IdRole, Title FROM dbo.Roles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Roles] SET [IdRole] = @IdRole, [Title] = @Title WHERE (([IdRole] = @Original_IdRole) AND ([Title] = @Original_Title));
SELECT IdRole, Title FROM Roles WHERE (IdRole = @IdRole)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" 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_IdRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" 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>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdRole" DataSetColumn="IdRole" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FabrikaLDAConnectionString (Settings)" DbObjectName="FabrikaLDA.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 (([IdUser] = @Original_IdUser) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_Role)) AND ((@IsNull_Fam = 1 AND [Fam] IS NULL) OR ([Fam] = @Original_Fam)) 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_IdUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_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_Fam" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fam" 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="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Users] ([Login], [Password], [Role], [Fam], [Name], [Otch], [Phone]) VALUES (@Login, @Password, @Role, @Fam, @Name, @Otch, @Phone);
SELECT IdUser, Login, Password, Role, Fam, Name, Otch, Phone FROM Users WHERE (IdUser = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@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="@Fam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fam" 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="AnsiStringFixedLength" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdUser, Login, Password, Role, Fam, Name, Otch, Phone FROM dbo.Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Users] SET [Login] = @Login, [Password] = @Password, [Role] = @Role, [Fam] = @Fam, [Name] = @Name, [Otch] = @Otch, [Phone] = @Phone WHERE (([IdUser] = @Original_IdUser) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Role = 1 AND [Role] IS NULL) OR ([Role] = @Original_Role)) AND ((@IsNull_Fam = 1 AND [Fam] IS NULL) OR ([Fam] = @Original_Fam)) 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 IdUser, Login, Password, Role, Fam, Name, Otch, Phone FROM Users WHERE (IdUser = @IdUser)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@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="@Fam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fam" 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="AnsiStringFixedLength" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_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_Fam" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Fam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Fam" 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="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdUser" ColumnName="IdUser" DataSourceName="FabrikaLDA.dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdUser" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdUser" DataSetColumn="IdUser" />
              <Mapping SourceColumn="Login" DataSetColumn="Login" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="Role" DataSetColumn="Role" />
              <Mapping SourceColumn="Fam" DataSetColumn="Fam" />
              <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="FabrikaLDADataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_UserDSName="FabrikaLDADataSet" msprop:Generator_DataSetName="FabrikaLDADataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Cloth" msprop:Generator_RowEvHandlerName="ClothRowChangeEventHandler" msprop:Generator_RowDeletedName="ClothRowDeleted" msprop:Generator_RowDeletingName="ClothRowDeleting" msprop:Generator_RowEvArgName="ClothRowChangeEvent" msprop:Generator_TablePropName="Cloth" msprop:Generator_RowChangedName="ClothRowChanged" msprop:Generator_RowChangingName="ClothRowChanging" msprop:Generator_TableClassName="ClothDataTable" msprop:Generator_RowClassName="ClothRow" msprop:Generator_TableVarName="tableCloth" msprop:Generator_UserTableName="Cloth">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdCloth" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IdCloth" msprop:Generator_ColumnPropNameInTable="IdClothColumn" msprop:Generator_ColumnVarNameInTable="columnIdCloth" msprop:Generator_UserColumnName="IdCloth" 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="IdColor" msprop:Generator_ColumnPropNameInRow="IdColor" msprop:Generator_ColumnPropNameInTable="IdColorColumn" msprop:Generator_ColumnVarNameInTable="columnIdColor" msprop:Generator_UserColumnName="IdColor" type="xs:int" minOccurs="0" />
              <xs:element name="Weight" msprop:Generator_ColumnPropNameInRow="Weight" msprop:Generator_ColumnPropNameInTable="WeightColumn" msprop:Generator_ColumnVarNameInTable="columnWeight" msprop:Generator_UserColumnName="Weight" type="xs:int" minOccurs="0" />
              <xs:element name="Height" msprop:Generator_ColumnPropNameInRow="Height" msprop:Generator_ColumnPropNameInTable="HeightColumn" msprop:Generator_ColumnVarNameInTable="columnHeight" msprop:Generator_UserColumnName="Height" type="xs:int" minOccurs="0" />
              <xs:element name="Note" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_UserColumnName="Note" 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:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Colors" msprop:Generator_RowEvHandlerName="ColorsRowChangeEventHandler" msprop:Generator_RowDeletedName="ColorsRowDeleted" msprop:Generator_RowDeletingName="ColorsRowDeleting" msprop:Generator_RowEvArgName="ColorsRowChangeEvent" msprop:Generator_TablePropName="Colors" msprop:Generator_RowChangedName="ColorsRowChanged" msprop:Generator_RowChangingName="ColorsRowChanging" msprop:Generator_TableClassName="ColorsDataTable" msprop:Generator_RowClassName="ColorsRow" msprop:Generator_TableVarName="tableColors" msprop:Generator_UserTableName="Colors">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdColor" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IdColor" msprop:Generator_ColumnPropNameInTable="IdColorColumn" msprop:Generator_ColumnVarNameInTable="columnIdColor" msprop:Generator_UserColumnName="IdColor" 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="idfur" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="idfur" msprop:Generator_ColumnPropNameInTable="idfurColumn" msprop:Generator_ColumnVarNameInTable="columnidfur" msprop:Generator_UserColumnName="idfur" type="xs:int" />
              <xs:element name="namefur" msprop:Generator_ColumnPropNameInRow="namefur" msprop:Generator_ColumnPropNameInTable="namefurColumn" msprop:Generator_ColumnVarNameInTable="columnnamefur" msprop:Generator_UserColumnName="namefur" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="photo" msprop:Generator_ColumnPropNameInRow="photo" msprop:Generator_ColumnPropNameInTable="photoColumn" msprop:Generator_ColumnVarNameInTable="columnphoto" msprop:Generator_UserColumnName="photo" 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="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="IdOrder" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IdOrder" msprop:Generator_ColumnPropNameInTable="IdOrderColumn" msprop:Generator_ColumnVarNameInTable="columnIdOrder" msprop:Generator_UserColumnName="IdOrder" type="xs:int" />
              <xs:element name="IdProduct" msprop:Generator_ColumnPropNameInRow="IdProduct" msprop:Generator_ColumnPropNameInTable="IdProductColumn" msprop:Generator_ColumnVarNameInTable="columnIdProduct" msprop:Generator_UserColumnName="IdProduct" type="xs:int" minOccurs="0" />
              <xs:element name="IdClient" msprop:Generator_ColumnPropNameInRow="IdClient" msprop:Generator_ColumnPropNameInTable="IdClientColumn" msprop:Generator_ColumnVarNameInTable="columnIdClient" msprop:Generator_UserColumnName="IdClient" type="xs:int" minOccurs="0" />
              <xs:element name="IdManager" msprop:Generator_ColumnPropNameInRow="IdManager" msprop:Generator_ColumnPropNameInTable="IdManagerColumn" msprop:Generator_ColumnVarNameInTable="columnIdManager" msprop:Generator_UserColumnName="IdManager" type="xs:int" minOccurs="0" />
              <xs:element name="IdCloth" msprop:Generator_ColumnPropNameInRow="IdCloth" msprop:Generator_ColumnPropNameInTable="IdClothColumn" msprop:Generator_ColumnVarNameInTable="columnIdCloth" msprop:Generator_UserColumnName="IdCloth" type="xs:int" minOccurs="0" />
              <xs:element name="IdFur" msprop:Generator_ColumnPropNameInRow="IdFur" msprop:Generator_ColumnPropNameInTable="IdFurColumn" msprop:Generator_ColumnVarNameInTable="columnIdFur" msprop:Generator_UserColumnName="IdFur" type="xs:int" minOccurs="0" />
              <xs:element name="CountFurnitura" msprop:Generator_ColumnPropNameInRow="CountFurnitura" msprop:Generator_ColumnPropNameInTable="CountFurnituraColumn" msprop:Generator_ColumnVarNameInTable="columnCountFurnitura" msprop:Generator_UserColumnName="CountFurnitura" type="xs:int" minOccurs="0" />
              <xs:element name="CountProduct" msprop:Generator_ColumnPropNameInRow="CountProduct" msprop:Generator_ColumnPropNameInTable="CountProductColumn" msprop:Generator_ColumnVarNameInTable="columnCountProduct" msprop:Generator_UserColumnName="CountProduct" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Products" msprop:Generator_RowEvHandlerName="ProductsRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductsRowDeleted" msprop:Generator_RowDeletingName="ProductsRowDeleting" msprop:Generator_RowEvArgName="ProductsRowChangeEvent" msprop:Generator_TablePropName="Products" msprop:Generator_RowChangedName="ProductsRowChanged" msprop:Generator_RowChangingName="ProductsRowChanging" msprop:Generator_TableClassName="ProductsDataTable" msprop:Generator_RowClassName="ProductsRow" msprop:Generator_TableVarName="tableProducts" msprop:Generator_UserTableName="Products">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdProduct" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IdProduct" msprop:Generator_ColumnPropNameInTable="IdProductColumn" msprop:Generator_ColumnVarNameInTable="columnIdProduct" msprop:Generator_UserColumnName="IdProduct" type="xs:int" />
              <xs:element name="TitleProduct" msprop:Generator_ColumnPropNameInRow="TitleProduct" msprop:Generator_ColumnPropNameInTable="TitleProductColumn" msprop:Generator_ColumnVarNameInTable="columnTitleProduct" msprop:Generator_UserColumnName="TitleProduct" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Lenght" msprop:Generator_ColumnPropNameInRow="Lenght" msprop:Generator_ColumnPropNameInTable="LenghtColumn" msprop:Generator_ColumnVarNameInTable="columnLenght" msprop:Generator_UserColumnName="Lenght" 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="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="IdRole" msprop:Generator_ColumnPropNameInRow="IdRole" msprop:Generator_ColumnPropNameInTable="IdRoleColumn" msprop:Generator_ColumnVarNameInTable="columnIdRole" msprop:Generator_UserColumnName="IdRole" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_UserColumnName="Title">
                <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="IdUser" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IdUser" msprop:Generator_ColumnPropNameInTable="IdUserColumn" msprop:Generator_ColumnVarNameInTable="columnIdUser" msprop:Generator_UserColumnName="IdUser" type="xs:int" />
              <xs:element name="Login" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnPropNameInTable="LoginColumn" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_UserColumnName="Login" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_UserColumnName="Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="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="Fam" msprop:Generator_ColumnPropNameInRow="Fam" msprop:Generator_ColumnPropNameInTable="FamColumn" msprop:Generator_ColumnVarNameInTable="columnFam" msprop:Generator_UserColumnName="Fam" 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="20" />
                  </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:Cloth" />
      <xs:field xpath="mstns:IdCloth" />
    </xs:unique>
    <xs:unique name="Colors_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Colors" />
      <xs:field xpath="mstns:IdColor" />
    </xs:unique>
    <xs:unique name="Furnitura_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Furnitura" />
      <xs:field xpath="mstns:idfur" />
    </xs:unique>
    <xs:unique name="Orders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Orders" />
      <xs:field xpath="mstns:IdOrder" />
    </xs:unique>
    <xs:unique name="Products_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Products" />
      <xs:field xpath="mstns:IdProduct" />
    </xs:unique>
    <xs:unique name="Roles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Roles" />
      <xs:field xpath="mstns:IdRole" />
    </xs:unique>
    <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:IdUser" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Cloth_Colors" msdata:parent="Colors" msdata:child="Cloth" msdata:parentkey="IdColor" msdata:childkey="IdColor" msprop:Generator_UserParentTable="Colors" msprop:Generator_UserChildTable="Cloth" msprop:Generator_RelationVarName="relationFK_Cloth_Colors" msprop:Generator_UserRelationName="FK_Cloth_Colors" msprop:Generator_ChildPropName="GetClothRows" msprop:Generator_ParentPropName="ColorsRow" />
      <msdata:Relationship name="FK_Orders_Cloth" msdata:parent="Cloth" msdata:child="Orders" msdata:parentkey="IdCloth" msdata:childkey="IdCloth" msprop:Generator_UserParentTable="Cloth" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Cloth" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_ParentPropName="ClothRow" msprop:Generator_UserRelationName="FK_Orders_Cloth" />
      <msdata:Relationship name="FK_Orders_Furnitura" msdata:parent="Furnitura" msdata:child="Orders" msdata:parentkey="idfur" msdata:childkey="IdFur" 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_Products" msdata:parent="Products" msdata:child="Orders" msdata:parentkey="IdProduct" msdata:childkey="IdProduct" msprop:Generator_UserParentTable="Products" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Products" msprop:Generator_UserRelationName="FK_Orders_Products" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_ParentPropName="ProductsRow" />
      <msdata:Relationship name="FK_Orders_Users_Client" msdata:parent="Users" msdata:child="Orders" msdata:parentkey="IdUser" msdata:childkey="IdClient" msprop:Generator_UserParentTable="Users" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Users_Client" msprop:Generator_UserRelationName="FK_Orders_Users_Client" msprop:Generator_ChildPropName="GetOrdersRowsByFK_Orders_Users_Client" msprop:Generator_ParentPropName="UsersRowByFK_Orders_Users_Client" />
      <msdata:Relationship name="FK_Orders_Users_Manager" msdata:parent="Users" msdata:child="Orders" msdata:parentkey="IdUser" msdata:childkey="IdManager" msprop:Generator_UserParentTable="Users" msprop:Generator_UserChildTable="Orders" msprop:Generator_RelationVarName="relationFK_Orders_Users_Manager" msprop:Generator_UserRelationName="FK_Orders_Users_Manager" msprop:Generator_ChildPropName="GetOrdersRowsByFK_Orders_Users_Manager" msprop:Generator_ParentPropName="UsersRowByFK_Orders_Users_Manager" />
      <msdata:Relationship name="FK_Users_Roles" msdata:parent="Roles" msdata:child="Users" msdata:parentkey="IdRole" 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>