alfafloor_subd/СУБД Альфапол/AlfafloorGDVDataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="AlfafloorGDVDataSet" targetNamespace="http://tempuri.org/AlfafloorGDVDataSet.xsd" xmlns:mstns="http://tempuri.org/AlfafloorGDVDataSet.xsd" xmlns="http://tempuri.org/AlfafloorGDVDataSet.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="AlfafloorGDVConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="AlfafloorGDVConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.СУБД_Альфапол.Properties.Settings.GlobalReference.Default.AlfafloorGDVConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CityTableAdapter" GeneratorDataComponentClassName="CityTableAdapter" Name="City" UserDataComponentName="CityTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AlfafloorGDVConnectionString (Settings)" DbObjectName="AlfafloorGDV.dbo.City" 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].[City] WHERE (([IDCity] = @Original_IDCity) AND ((@IsNull_City = 1 AND [City] IS NULL) OR ([City] = @Original_City)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDCity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_City" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[City] ([City]) VALUES (@City);
SELECT IDCity, City FROM City WHERE (IDCity = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@City" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDCity, City FROM dbo.City</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[City] SET [City] = @City WHERE (([IDCity] = @Original_IDCity) AND ((@IsNull_City = 1 AND [City] IS NULL) OR ([City] = @Original_City)));
SELECT IDCity, City FROM City WHERE (IDCity = @IDCity)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@City" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDCity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_City" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDCity" ColumnName="IDCity" DataSourceName="AlfafloorGDV.dbo.City" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDCity" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDCity" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDCity" DataSetColumn="IDCity" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ManagerTableAdapter" GeneratorDataComponentClassName="ManagerTableAdapter" Name="Manager" UserDataComponentName="ManagerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AlfafloorGDVConnectionString (Settings)" DbObjectName="AlfafloorGDV.dbo.Manager" 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].[Manager] WHERE (([IDManager] = @Original_IDManager) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronomyc = 1 AND [Patronomyc] IS NULL) OR ([Patronomyc] = @Original_Patronomyc)) 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_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" 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_Surname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Patronomyc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Patronomyc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Patronomyc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronomyc" 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_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].[Manager] ([Surname], [Name], [Patronomyc], [Login], [Password], [Photo]) VALUES (@Surname, @Name, @Patronomyc, @Login, @Password, @Photo);
SELECT IDManager, Surname, Name, Patronomyc, Login, Password, Photo FROM Manager WHERE (IDManager = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Patronomyc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronomyc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <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="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 IDManager, Surname, Name, Patronomyc, Login, Password, Photo FROM dbo.Manager</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Manager] SET [Surname] = @Surname, [Name] = @Name, [Patronomyc] = @Patronomyc, [Login] = @Login, [Password] = @Password, [Photo] = @Photo WHERE (([IDManager] = @Original_IDManager) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronomyc = 1 AND [Patronomyc] IS NULL) OR ([Patronomyc] = @Original_Patronomyc)) 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_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo)));
SELECT IDManager, Surname, Name, Patronomyc, Login, Password, Photo FROM Manager WHERE (IDManager = @IDManager)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Patronomyc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronomyc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <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="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_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_Surname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Patronomyc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Patronomyc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Patronomyc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronomyc" 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_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="IDManager" ColumnName="IDManager" DataSourceName="AlfafloorGDV.dbo.Manager" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDManager" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDManager" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDManager" DataSetColumn="IDManager" />
              <Mapping SourceColumn="Surname" DataSetColumn="Surname" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Patronomyc" DataSetColumn="Patronomyc" />
              <Mapping SourceColumn="Login" DataSetColumn="Login" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="Photo" DataSetColumn="Photo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PartnerTableAdapter" GeneratorDataComponentClassName="PartnerTableAdapter" Name="Partner" UserDataComponentName="PartnerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AlfafloorGDVConnectionString (Settings)" DbObjectName="AlfafloorGDV.dbo.Partner" 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].[Partner] WHERE (([IDPartner] = @Original_IDPartner) AND ([IDTypePartner] = @Original_IDTypePartner) AND ((@IsNull_Namepartner = 1 AND [Namepartner] IS NULL) OR ([Namepartner] = @Original_Namepartner)) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronomyc = 1 AND [Patronomyc] IS NULL) OR ([Patronomyc] = @Original_Patronomyc)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_IDPostCode = 1 AND [IDPostCode] IS NULL) OR ([IDPostCode] = @Original_IDPostCode)) AND ((@IsNull_IDRegion = 1 AND [IDRegion] IS NULL) OR ([IDRegion] = @Original_IDRegion)) AND ((@IsNull_IDCity = 1 AND [IDCity] IS NULL) OR ([IDCity] = @Original_IDCity)) AND ((@IsNull_IDStreet = 1 AND [IDStreet] IS NULL) OR ([IDStreet] = @Original_IDStreet)) AND ((@IsNull_House = 1 AND [House] IS NULL) OR ([House] = @Original_House)) AND ((@IsNull_INN = 1 AND [INN] IS NULL) OR ([INN] = @Original_INN)) AND ((@IsNull_Rating = 1 AND [Rating] IS NULL) OR ([Rating] = @Original_Rating)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDPartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartner" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDTypePartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTypePartner" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Namepartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Namepartner" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Namepartner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Namepartner" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Surname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Patronomyc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Patronomyc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Patronomyc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronomyc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDPostCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPostCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDPostCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPostCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDRegion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDRegion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDRegion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDRegion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDCity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCity" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDCity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDStreet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDStreet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDStreet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDStreet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_House" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="House" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_House" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="House" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_INN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Rating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Partner] ([IDTypePartner], [Namepartner], [Surname], [Name], [Patronomyc], [Email], [Phone], [IDPostCode], [IDRegion], [IDCity], [IDStreet], [House], [INN], [Rating]) VALUES (@IDTypePartner, @Namepartner, @Surname, @Name, @Patronomyc, @Email, @Phone, @IDPostCode, @IDRegion, @IDCity, @IDStreet, @House, @INN, @Rating);
SELECT IDPartner, IDTypePartner, Namepartner, Surname, Name, Patronomyc, Email, Phone, IDPostCode, IDRegion, IDCity, IDStreet, House, INN, Rating FROM Partner WHERE (IDPartner = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDTypePartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTypePartner" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Namepartner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Namepartner" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Patronomyc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronomyc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDPostCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPostCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDRegion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDRegion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDCity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDStreet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDStreet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@House" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="House" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@INN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Rating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDPartner, IDTypePartner, Namepartner, Surname, Name, Patronomyc, Email, Phone, IDPostCode, IDRegion, IDCity, IDStreet, House, INN, Rating FROM dbo.Partner</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Partner] SET [IDTypePartner] = @IDTypePartner, [Namepartner] = @Namepartner, [Surname] = @Surname, [Name] = @Name, [Patronomyc] = @Patronomyc, [Email] = @Email, [Phone] = @Phone, [IDPostCode] = @IDPostCode, [IDRegion] = @IDRegion, [IDCity] = @IDCity, [IDStreet] = @IDStreet, [House] = @House, [INN] = @INN, [Rating] = @Rating WHERE (([IDPartner] = @Original_IDPartner) AND ([IDTypePartner] = @Original_IDTypePartner) AND ((@IsNull_Namepartner = 1 AND [Namepartner] IS NULL) OR ([Namepartner] = @Original_Namepartner)) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronomyc = 1 AND [Patronomyc] IS NULL) OR ([Patronomyc] = @Original_Patronomyc)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_IDPostCode = 1 AND [IDPostCode] IS NULL) OR ([IDPostCode] = @Original_IDPostCode)) AND ((@IsNull_IDRegion = 1 AND [IDRegion] IS NULL) OR ([IDRegion] = @Original_IDRegion)) AND ((@IsNull_IDCity = 1 AND [IDCity] IS NULL) OR ([IDCity] = @Original_IDCity)) AND ((@IsNull_IDStreet = 1 AND [IDStreet] IS NULL) OR ([IDStreet] = @Original_IDStreet)) AND ((@IsNull_House = 1 AND [House] IS NULL) OR ([House] = @Original_House)) AND ((@IsNull_INN = 1 AND [INN] IS NULL) OR ([INN] = @Original_INN)) AND ((@IsNull_Rating = 1 AND [Rating] IS NULL) OR ([Rating] = @Original_Rating)));
SELECT IDPartner, IDTypePartner, Namepartner, Surname, Name, Patronomyc, Email, Phone, IDPostCode, IDRegion, IDCity, IDStreet, House, INN, Rating FROM Partner WHERE (IDPartner = @IDPartner)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDTypePartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTypePartner" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Namepartner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Namepartner" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Patronomyc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronomyc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDPostCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPostCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDRegion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDRegion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDCity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDStreet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDStreet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@House" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="House" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@INN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Rating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDPartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartner" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDTypePartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTypePartner" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Namepartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Namepartner" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Namepartner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Namepartner" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Surname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Patronomyc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Patronomyc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Patronomyc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronomyc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDPostCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPostCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDPostCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPostCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDRegion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDRegion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDRegion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDRegion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDCity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCity" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDCity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDCity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDStreet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDStreet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDStreet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDStreet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_House" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="House" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_House" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="House" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_INN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="INN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Rating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDPartner" ColumnName="IDPartner" DataSourceName="AlfafloorGDV.dbo.Partner" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDPartner" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDPartner" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDPartner" DataSetColumn="IDPartner" />
              <Mapping SourceColumn="IDTypePartner" DataSetColumn="IDTypePartner" />
              <Mapping SourceColumn="Namepartner" DataSetColumn="Namepartner" />
              <Mapping SourceColumn="Surname" DataSetColumn="Surname" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Patronomyc" DataSetColumn="Patronomyc" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="IDPostCode" DataSetColumn="IDPostCode" />
              <Mapping SourceColumn="IDRegion" DataSetColumn="IDRegion" />
              <Mapping SourceColumn="IDCity" DataSetColumn="IDCity" />
              <Mapping SourceColumn="IDStreet" DataSetColumn="IDStreet" />
              <Mapping SourceColumn="House" DataSetColumn="House" />
              <Mapping SourceColumn="INN" DataSetColumn="INN" />
              <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PartnerProductsTableAdapter" GeneratorDataComponentClassName="PartnerProductsTableAdapter" Name="PartnerProducts" UserDataComponentName="PartnerProductsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AlfafloorGDVConnectionString (Settings)" DbObjectName="AlfafloorGDV.dbo.PartnerProducts" 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].[PartnerProducts] WHERE (([IDPartnerProduct] = @Original_IDPartnerProduct) AND ((@IsNull_IDProduct = 1 AND [IDProduct] IS NULL) OR ([IDProduct] = @Original_IDProduct)) AND ((@IsNull_IDPartner = 1 AND [IDPartner] IS NULL) OR ([IDPartner] = @Original_IDPartner)) AND ((@IsNull_CountProduct = 1 AND [CountProduct] IS NULL) OR ([CountProduct] = @Original_CountProduct)) AND ((@IsNull_DateSale = 1 AND [DateSale] IS NULL) OR ([DateSale] = @Original_DateSale)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDPartnerProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartnerProduct" 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_IDPartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartner" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDPartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartner" 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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateSale" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateSale" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DateSale" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateSale" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PartnerProducts] ([IDProduct], [IDPartner], [CountProduct], [DateSale]) VALUES (@IDProduct, @IDPartner, @CountProduct, @DateSale);
SELECT IDPartnerProduct, IDProduct, IDPartner, CountProduct, DateSale FROM PartnerProducts WHERE (IDPartnerProduct = 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="@IDPartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartner" 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="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateSale" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateSale" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDPartnerProduct, IDProduct, IDPartner, CountProduct, DateSale FROM dbo.PartnerProducts</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PartnerProducts] SET [IDProduct] = @IDProduct, [IDPartner] = @IDPartner, [CountProduct] = @CountProduct, [DateSale] = @DateSale WHERE (([IDPartnerProduct] = @Original_IDPartnerProduct) AND ((@IsNull_IDProduct = 1 AND [IDProduct] IS NULL) OR ([IDProduct] = @Original_IDProduct)) AND ((@IsNull_IDPartner = 1 AND [IDPartner] IS NULL) OR ([IDPartner] = @Original_IDPartner)) AND ((@IsNull_CountProduct = 1 AND [CountProduct] IS NULL) OR ([CountProduct] = @Original_CountProduct)) AND ((@IsNull_DateSale = 1 AND [DateSale] IS NULL) OR ([DateSale] = @Original_DateSale)));
SELECT IDPartnerProduct, IDProduct, IDPartner, CountProduct, DateSale FROM PartnerProducts WHERE (IDPartnerProduct = @IDPartnerProduct)</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="@IDPartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartner" 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="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateSale" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateSale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDPartnerProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartnerProduct" 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_IDPartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartner" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDPartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartner" 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="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateSale" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateSale" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DateSale" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateSale" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDPartnerProduct" ColumnName="IDPartnerProduct" DataSourceName="AlfafloorGDV.dbo.PartnerProducts" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDPartnerProduct" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDPartnerProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDPartnerProduct" DataSetColumn="IDPartnerProduct" />
              <Mapping SourceColumn="IDProduct" DataSetColumn="IDProduct" />
              <Mapping SourceColumn="IDPartner" DataSetColumn="IDPartner" />
              <Mapping SourceColumn="CountProduct" DataSetColumn="CountProduct" />
              <Mapping SourceColumn="DateSale" DataSetColumn="DateSale" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PostCodeTableAdapter" GeneratorDataComponentClassName="PostCodeTableAdapter" Name="PostCode" UserDataComponentName="PostCodeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AlfafloorGDVConnectionString (Settings)" DbObjectName="AlfafloorGDV.dbo.PostCode" 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].[PostCode] WHERE (([IDPostCode] = @Original_IDPostCode) AND ((@IsNull_PostCode = 1 AND [PostCode] IS NULL) OR ([PostCode] = @Original_PostCode)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDPostCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPostCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PostCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PostCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PostCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PostCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PostCode] ([PostCode]) VALUES (@PostCode);
SELECT IDPostCode, PostCode FROM PostCode WHERE (IDPostCode = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PostCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PostCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDPostCode, PostCode FROM dbo.PostCode</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PostCode] SET [PostCode] = @PostCode WHERE (([IDPostCode] = @Original_IDPostCode) AND ((@IsNull_PostCode = 1 AND [PostCode] IS NULL) OR ([PostCode] = @Original_PostCode)));
SELECT IDPostCode, PostCode FROM PostCode WHERE (IDPostCode = @IDPostCode)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PostCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PostCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDPostCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPostCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PostCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PostCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PostCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PostCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDPostCode" ColumnName="IDPostCode" DataSourceName="AlfafloorGDV.dbo.PostCode" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDPostCode" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDPostCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDPostCode" DataSetColumn="IDPostCode" />
              <Mapping SourceColumn="PostCode" DataSetColumn="PostCode" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductTableAdapter" GeneratorDataComponentClassName="ProductTableAdapter" Name="Product" UserDataComponentName="ProductTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AlfafloorGDVConnectionString (Settings)" DbObjectName="AlfafloorGDV.dbo.Product" 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].[Product] WHERE (([IDProduct] = @Original_IDProduct) AND ((@IsNull_IDProductType = 1 AND [IDProductType] IS NULL) OR ([IDProductType] = @Original_IDProductType)) AND ((@IsNull_ProductName = 1 AND [ProductName] IS NULL) OR ([ProductName] = @Original_ProductName)) AND ((@IsNull_Article = 1 AND [Article] IS NULL) OR ([Article] = @Original_Article)) AND ((@IsNull_Cost = 1 AND [Cost] IS NULL) OR ([Cost] = @Original_Cost)))</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_IDProductType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProductType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDProductType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProductType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Article" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Article" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Article" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Article" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Cost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Product] ([IDProductType], [ProductName], [Article], [Cost]) VALUES (@IDProductType, @ProductName, @Article, @Cost);
SELECT IDProduct, IDProductType, ProductName, Article, Cost FROM Product WHERE (IDProduct = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDProductType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProductType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Article" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Article" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Cost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDProduct, IDProductType, ProductName, Article, Cost FROM dbo.Product</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Product] SET [IDProductType] = @IDProductType, [ProductName] = @ProductName, [Article] = @Article, [Cost] = @Cost WHERE (([IDProduct] = @Original_IDProduct) AND ((@IsNull_IDProductType = 1 AND [IDProductType] IS NULL) OR ([IDProductType] = @Original_IDProductType)) AND ((@IsNull_ProductName = 1 AND [ProductName] IS NULL) OR ([ProductName] = @Original_ProductName)) AND ((@IsNull_Article = 1 AND [Article] IS NULL) OR ([Article] = @Original_Article)) AND ((@IsNull_Cost = 1 AND [Cost] IS NULL) OR ([Cost] = @Original_Cost)));
SELECT IDProduct, IDProductType, ProductName, Article, Cost FROM Product WHERE (IDProduct = @IDProduct)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDProductType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProductType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Article" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Article" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Cost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Cost" 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_IDProductType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProductType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDProductType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProductType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Article" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Article" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Article" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Article" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Cost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDProduct" ColumnName="IDProduct" DataSourceName="AlfafloorGDV.dbo.Product" 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="IDProductType" DataSetColumn="IDProductType" />
              <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
              <Mapping SourceColumn="Article" DataSetColumn="Article" />
              <Mapping SourceColumn="Cost" DataSetColumn="Cost" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductTypeTableAdapter" GeneratorDataComponentClassName="ProductTypeTableAdapter" Name="ProductType" UserDataComponentName="ProductTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AlfafloorGDVConnectionString (Settings)" DbObjectName="AlfafloorGDV.dbo.ProductType" 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].[ProductType] WHERE (([IDProductType] = @Original_IDProductType) AND ((@IsNull_ProductType = 1 AND [ProductType] IS NULL) OR ([ProductType] = @Original_ProductType)) AND ((@IsNull_Сoefficient = 1 AND [Сoefficient] IS NULL) OR ([Сoefficient] = @Original_Сoefficient)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDProductType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProductType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Сoefficient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Сoefficient" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Сoefficient" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Сoefficient" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ProductType] ([ProductType], [Сoefficient]) VALUES (@ProductType, @Сoefficient);
SELECT IDProductType, ProductType, Сoefficient FROM ProductType WHERE (IDProductType = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Сoefficient" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Сoefficient" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDProductType, ProductType, Сoefficient FROM dbo.ProductType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ProductType] SET [ProductType] = @ProductType, [Сoefficient] = @Сoefficient WHERE (([IDProductType] = @Original_IDProductType) AND ((@IsNull_ProductType = 1 AND [ProductType] IS NULL) OR ([ProductType] = @Original_ProductType)) AND ((@IsNull_Сoefficient = 1 AND [Сoefficient] IS NULL) OR ([Сoefficient] = @Original_Сoefficient)));
SELECT IDProductType, ProductType, Сoefficient FROM ProductType WHERE (IDProductType = @IDProductType)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProductType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Сoefficient" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Сoefficient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDProductType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDProductType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProductType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProductType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Сoefficient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Сoefficient" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Сoefficient" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Сoefficient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDProductType" ColumnName="IDProductType" DataSourceName="AlfafloorGDV.dbo.ProductType" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDProductType" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDProductType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDProductType" DataSetColumn="IDProductType" />
              <Mapping SourceColumn="ProductType" DataSetColumn="ProductType" />
              <Mapping SourceColumn="Сoefficient" DataSetColumn="Сoefficient" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RegionTableAdapter" GeneratorDataComponentClassName="RegionTableAdapter" Name="Region" UserDataComponentName="RegionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AlfafloorGDVConnectionString (Settings)" DbObjectName="AlfafloorGDV.dbo.Region" 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].[Region] WHERE (([IDRegion] = @Original_IDRegion) AND ((@IsNull_Region = 1 AND [Region] IS NULL) OR ([Region] = @Original_Region)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDRegion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDRegion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Region" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Region" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Region" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Region" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Region] ([Region]) VALUES (@Region);
SELECT IDRegion, Region FROM Region WHERE (IDRegion = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Region" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Region" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDRegion, Region FROM dbo.Region</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Region] SET [Region] = @Region WHERE (([IDRegion] = @Original_IDRegion) AND ((@IsNull_Region = 1 AND [Region] IS NULL) OR ([Region] = @Original_Region)));
SELECT IDRegion, Region FROM Region WHERE (IDRegion = @IDRegion)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Region" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Region" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDRegion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDRegion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Region" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Region" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Region" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Region" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDRegion" ColumnName="IDRegion" DataSourceName="AlfafloorGDV.dbo.Region" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDRegion" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDRegion" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDRegion" DataSetColumn="IDRegion" />
              <Mapping SourceColumn="Region" DataSetColumn="Region" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StreetTableAdapter" GeneratorDataComponentClassName="StreetTableAdapter" Name="Street" UserDataComponentName="StreetTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AlfafloorGDVConnectionString (Settings)" DbObjectName="AlfafloorGDV.dbo.Street" 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].[Street] WHERE (([IDStreet] = @Original_IDStreet) AND ((@IsNull_Street = 1 AND [Street] IS NULL) OR ([Street] = @Original_Street)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDStreet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDStreet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Street" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Street" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Street] ([Street]) VALUES (@Street);
SELECT IDStreet, Street FROM Street WHERE (IDStreet = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Street" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDStreet, Street FROM dbo.Street</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Street] SET [Street] = @Street WHERE (([IDStreet] = @Original_IDStreet) AND ((@IsNull_Street = 1 AND [Street] IS NULL) OR ([Street] = @Original_Street)));
SELECT IDStreet, Street FROM Street WHERE (IDStreet = @IDStreet)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Street" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDStreet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDStreet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Street" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Street" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDStreet" ColumnName="IDStreet" DataSourceName="AlfafloorGDV.dbo.Street" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDStreet" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDStreet" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDStreet" DataSetColumn="IDStreet" />
              <Mapping SourceColumn="Street" DataSetColumn="Street" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TypeMaterialTableAdapter" GeneratorDataComponentClassName="TypeMaterialTableAdapter" Name="TypeMaterial" UserDataComponentName="TypeMaterialTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AlfafloorGDVConnectionString (Settings)" DbObjectName="AlfafloorGDV.dbo.TypeMaterial" 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].[TypeMaterial] WHERE (([IDTypeMaterial] = @Original_IDTypeMaterial) AND ((@IsNull_TypeMaterial = 1 AND [TypeMaterial] IS NULL) OR ([TypeMaterial] = @Original_TypeMaterial)) AND ((@IsNull_DefectPercent = 1 AND [DefectPercent] IS NULL) OR ([DefectPercent] = @Original_DefectPercent)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDTypeMaterial" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTypeMaterial" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TypeMaterial" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeMaterial" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TypeMaterial" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeMaterial" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DefectPercent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DefectPercent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DefectPercent" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DefectPercent" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TypeMaterial] ([TypeMaterial], [DefectPercent]) VALUES (@TypeMaterial, @DefectPercent);
SELECT IDTypeMaterial, TypeMaterial, DefectPercent FROM TypeMaterial WHERE (IDTypeMaterial = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TypeMaterial" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeMaterial" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DefectPercent" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DefectPercent" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDTypeMaterial, TypeMaterial, DefectPercent FROM dbo.TypeMaterial</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TypeMaterial] SET [TypeMaterial] = @TypeMaterial, [DefectPercent] = @DefectPercent WHERE (([IDTypeMaterial] = @Original_IDTypeMaterial) AND ((@IsNull_TypeMaterial = 1 AND [TypeMaterial] IS NULL) OR ([TypeMaterial] = @Original_TypeMaterial)) AND ((@IsNull_DefectPercent = 1 AND [DefectPercent] IS NULL) OR ([DefectPercent] = @Original_DefectPercent)));
SELECT IDTypeMaterial, TypeMaterial, DefectPercent FROM TypeMaterial WHERE (IDTypeMaterial = @IDTypeMaterial)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TypeMaterial" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeMaterial" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DefectPercent" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DefectPercent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDTypeMaterial" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTypeMaterial" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TypeMaterial" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeMaterial" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TypeMaterial" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeMaterial" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DefectPercent" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DefectPercent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DefectPercent" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DefectPercent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDTypeMaterial" ColumnName="IDTypeMaterial" DataSourceName="AlfafloorGDV.dbo.TypeMaterial" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDTypeMaterial" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDTypeMaterial" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDTypeMaterial" DataSetColumn="IDTypeMaterial" />
              <Mapping SourceColumn="TypeMaterial" DataSetColumn="TypeMaterial" />
              <Mapping SourceColumn="DefectPercent" DataSetColumn="DefectPercent" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TypePartnerTableAdapter" GeneratorDataComponentClassName="TypePartnerTableAdapter" Name="TypePartner" UserDataComponentName="TypePartnerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AlfafloorGDVConnectionString (Settings)" DbObjectName="AlfafloorGDV.dbo.TypePartner" 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].[TypePartner] WHERE (([IDTypePartner] = @Original_IDTypePartner) AND ((@IsNull_TypePartner = 1 AND [TypePartner] IS NULL) OR ([TypePartner] = @Original_TypePartner)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDTypePartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTypePartner" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TypePartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypePartner" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TypePartner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypePartner" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TypePartner] ([TypePartner]) VALUES (@TypePartner);
SELECT IDTypePartner, TypePartner FROM TypePartner WHERE (IDTypePartner = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TypePartner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypePartner" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDTypePartner, TypePartner FROM dbo.TypePartner</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TypePartner] SET [TypePartner] = @TypePartner WHERE (([IDTypePartner] = @Original_IDTypePartner) AND ((@IsNull_TypePartner = 1 AND [TypePartner] IS NULL) OR ([TypePartner] = @Original_TypePartner)));
SELECT IDTypePartner, TypePartner FROM TypePartner WHERE (IDTypePartner = @IDTypePartner)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TypePartner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypePartner" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDTypePartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTypePartner" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TypePartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypePartner" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TypePartner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypePartner" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDTypePartner" ColumnName="IDTypePartner" DataSourceName="AlfafloorGDV.dbo.TypePartner" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDTypePartner" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDTypePartner" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDTypePartner" DataSetColumn="IDTypePartner" />
              <Mapping SourceColumn="TypePartner" DataSetColumn="TypePartner" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="AlfafloorGDVDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_UserDSName="AlfafloorGDVDataSet" msprop:Generator_DataSetName="AlfafloorGDVDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="City" msprop:Generator_RowEvHandlerName="CityRowChangeEventHandler" msprop:Generator_RowDeletedName="CityRowDeleted" msprop:Generator_RowDeletingName="CityRowDeleting" msprop:Generator_RowEvArgName="CityRowChangeEvent" msprop:Generator_TablePropName="City" msprop:Generator_RowChangedName="CityRowChanged" msprop:Generator_RowChangingName="CityRowChanging" msprop:Generator_TableClassName="CityDataTable" msprop:Generator_RowClassName="CityRow" msprop:Generator_TableVarName="tableCity" msprop:Generator_UserTableName="City">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDCity" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDCity" msprop:Generator_ColumnPropNameInTable="IDCityColumn" msprop:Generator_ColumnVarNameInTable="columnIDCity" msprop:Generator_UserColumnName="IDCity" type="xs:int" />
              <xs:element name="City" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_UserColumnName="City" 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="Manager" msprop:Generator_RowEvHandlerName="ManagerRowChangeEventHandler" msprop:Generator_RowDeletedName="ManagerRowDeleted" msprop:Generator_RowDeletingName="ManagerRowDeleting" msprop:Generator_RowEvArgName="ManagerRowChangeEvent" msprop:Generator_TablePropName="Manager" msprop:Generator_RowChangedName="ManagerRowChanged" msprop:Generator_RowChangingName="ManagerRowChanging" msprop:Generator_TableClassName="ManagerDataTable" msprop:Generator_RowClassName="ManagerRow" msprop:Generator_TableVarName="tableManager" msprop:Generator_UserTableName="Manager">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDManager" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDManager" msprop:Generator_ColumnPropNameInTable="IDManagerColumn" msprop:Generator_ColumnVarNameInTable="columnIDManager" msprop:Generator_UserColumnName="IDManager" type="xs:int" />
              <xs:element name="Surname" msprop:Generator_ColumnPropNameInRow="Surname" msprop:Generator_ColumnPropNameInTable="SurnameColumn" msprop:Generator_ColumnVarNameInTable="columnSurname" msprop:Generator_UserColumnName="Surname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Patronomyc" msprop:Generator_ColumnPropNameInRow="Patronomyc" msprop:Generator_ColumnPropNameInTable="PatronomycColumn" msprop:Generator_ColumnVarNameInTable="columnPatronomyc" msprop:Generator_UserColumnName="Patronomyc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <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="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="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Partner" msprop:Generator_RowEvHandlerName="PartnerRowChangeEventHandler" msprop:Generator_RowDeletedName="PartnerRowDeleted" msprop:Generator_RowDeletingName="PartnerRowDeleting" msprop:Generator_RowEvArgName="PartnerRowChangeEvent" msprop:Generator_TablePropName="Partner" msprop:Generator_RowChangedName="PartnerRowChanged" msprop:Generator_RowChangingName="PartnerRowChanging" msprop:Generator_TableClassName="PartnerDataTable" msprop:Generator_RowClassName="PartnerRow" msprop:Generator_TableVarName="tablePartner" msprop:Generator_UserTableName="Partner">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDPartner" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDPartner" msprop:Generator_ColumnPropNameInTable="IDPartnerColumn" msprop:Generator_ColumnVarNameInTable="columnIDPartner" msprop:Generator_UserColumnName="IDPartner" type="xs:int" />
              <xs:element name="IDTypePartner" msprop:Generator_ColumnPropNameInRow="IDTypePartner" msprop:Generator_ColumnPropNameInTable="IDTypePartnerColumn" msprop:Generator_ColumnVarNameInTable="columnIDTypePartner" msprop:Generator_UserColumnName="IDTypePartner" type="xs:int" />
              <xs:element name="Namepartner" msprop:Generator_ColumnPropNameInRow="Namepartner" msprop:Generator_ColumnPropNameInTable="NamepartnerColumn" msprop:Generator_ColumnVarNameInTable="columnNamepartner" msprop:Generator_UserColumnName="Namepartner" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Surname" msprop:Generator_ColumnPropNameInRow="Surname" msprop:Generator_ColumnPropNameInTable="SurnameColumn" msprop:Generator_ColumnVarNameInTable="columnSurname" msprop:Generator_UserColumnName="Surname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Patronomyc" msprop:Generator_ColumnPropNameInRow="Patronomyc" msprop:Generator_ColumnPropNameInTable="PatronomycColumn" msprop:Generator_ColumnVarNameInTable="columnPatronomyc" msprop:Generator_UserColumnName="Patronomyc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPostCode" msprop:Generator_ColumnPropNameInRow="IDPostCode" msprop:Generator_ColumnPropNameInTable="IDPostCodeColumn" msprop:Generator_ColumnVarNameInTable="columnIDPostCode" msprop:Generator_UserColumnName="IDPostCode" type="xs:int" minOccurs="0" />
              <xs:element name="IDRegion" msprop:Generator_ColumnPropNameInRow="IDRegion" msprop:Generator_ColumnPropNameInTable="IDRegionColumn" msprop:Generator_ColumnVarNameInTable="columnIDRegion" msprop:Generator_UserColumnName="IDRegion" type="xs:int" minOccurs="0" />
              <xs:element name="IDCity" msprop:Generator_ColumnPropNameInRow="IDCity" msprop:Generator_ColumnPropNameInTable="IDCityColumn" msprop:Generator_ColumnVarNameInTable="columnIDCity" msprop:Generator_UserColumnName="IDCity" type="xs:int" minOccurs="0" />
              <xs:element name="IDStreet" msprop:Generator_ColumnPropNameInRow="IDStreet" msprop:Generator_ColumnPropNameInTable="IDStreetColumn" msprop:Generator_ColumnVarNameInTable="columnIDStreet" msprop:Generator_UserColumnName="IDStreet" type="xs:int" minOccurs="0" />
              <xs:element name="House" msprop:Generator_ColumnPropNameInRow="House" msprop:Generator_ColumnPropNameInTable="HouseColumn" msprop:Generator_ColumnVarNameInTable="columnHouse" msprop:Generator_UserColumnName="House" type="xs:int" minOccurs="0" />
              <xs:element name="INN" msprop:Generator_ColumnPropNameInRow="INN" msprop:Generator_ColumnPropNameInTable="INNColumn" msprop:Generator_ColumnVarNameInTable="columnINN" msprop:Generator_UserColumnName="INN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnPropNameInTable="RatingColumn" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_UserColumnName="Rating" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PartnerProducts" msprop:Generator_RowEvHandlerName="PartnerProductsRowChangeEventHandler" msprop:Generator_RowDeletedName="PartnerProductsRowDeleted" msprop:Generator_RowDeletingName="PartnerProductsRowDeleting" msprop:Generator_RowEvArgName="PartnerProductsRowChangeEvent" msprop:Generator_TablePropName="PartnerProducts" msprop:Generator_RowChangedName="PartnerProductsRowChanged" msprop:Generator_RowChangingName="PartnerProductsRowChanging" msprop:Generator_TableClassName="PartnerProductsDataTable" msprop:Generator_RowClassName="PartnerProductsRow" msprop:Generator_TableVarName="tablePartnerProducts" msprop:Generator_UserTableName="PartnerProducts">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDPartnerProduct" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDPartnerProduct" msprop:Generator_ColumnPropNameInTable="IDPartnerProductColumn" msprop:Generator_ColumnVarNameInTable="columnIDPartnerProduct" msprop:Generator_UserColumnName="IDPartnerProduct" 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="IDPartner" msprop:Generator_ColumnPropNameInRow="IDPartner" msprop:Generator_ColumnPropNameInTable="IDPartnerColumn" msprop:Generator_ColumnVarNameInTable="columnIDPartner" msprop:Generator_UserColumnName="IDPartner" 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:element name="DateSale" msprop:Generator_ColumnPropNameInRow="DateSale" msprop:Generator_ColumnPropNameInTable="DateSaleColumn" msprop:Generator_ColumnVarNameInTable="columnDateSale" msprop:Generator_UserColumnName="DateSale" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PostCode" msprop:Generator_RowEvHandlerName="PostCodeRowChangeEventHandler" msprop:Generator_RowDeletedName="PostCodeRowDeleted" msprop:Generator_RowDeletingName="PostCodeRowDeleting" msprop:Generator_RowEvArgName="PostCodeRowChangeEvent" msprop:Generator_TablePropName="PostCode" msprop:Generator_RowChangedName="PostCodeRowChanged" msprop:Generator_RowChangingName="PostCodeRowChanging" msprop:Generator_TableClassName="PostCodeDataTable" msprop:Generator_RowClassName="PostCodeRow" msprop:Generator_TableVarName="tablePostCode" msprop:Generator_UserTableName="PostCode">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDPostCode" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDPostCode" msprop:Generator_ColumnPropNameInTable="IDPostCodeColumn" msprop:Generator_ColumnVarNameInTable="columnIDPostCode" msprop:Generator_UserColumnName="IDPostCode" type="xs:int" />
              <xs:element name="PostCode" msprop:Generator_ColumnPropNameInRow="PostCode" msprop:Generator_ColumnPropNameInTable="PostCodeColumn" msprop:Generator_ColumnVarNameInTable="columnPostCode" msprop:Generator_UserColumnName="PostCode" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Product" msprop:Generator_RowEvHandlerName="ProductRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductRowDeleted" msprop:Generator_RowDeletingName="ProductRowDeleting" msprop:Generator_RowEvArgName="ProductRowChangeEvent" msprop:Generator_TablePropName="Product" msprop:Generator_RowChangedName="ProductRowChanged" msprop:Generator_RowChangingName="ProductRowChanging" msprop:Generator_TableClassName="ProductDataTable" msprop:Generator_RowClassName="ProductRow" msprop:Generator_TableVarName="tableProduct" msprop:Generator_UserTableName="Product">
          <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="IDProductType" msprop:Generator_ColumnPropNameInRow="IDProductType" msprop:Generator_ColumnPropNameInTable="IDProductTypeColumn" msprop:Generator_ColumnVarNameInTable="columnIDProductType" msprop:Generator_UserColumnName="IDProductType" type="xs:int" minOccurs="0" />
              <xs:element name="ProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_UserColumnName="ProductName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Article" msprop:Generator_ColumnPropNameInRow="Article" msprop:Generator_ColumnPropNameInTable="ArticleColumn" msprop:Generator_ColumnVarNameInTable="columnArticle" msprop:Generator_UserColumnName="Article" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cost" msprop:Generator_ColumnPropNameInRow="Cost" msprop:Generator_ColumnPropNameInTable="CostColumn" msprop:Generator_ColumnVarNameInTable="columnCost" msprop:Generator_UserColumnName="Cost" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ProductType" msprop:Generator_RowEvHandlerName="ProductTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductTypeRowDeleted" msprop:Generator_RowDeletingName="ProductTypeRowDeleting" msprop:Generator_RowEvArgName="ProductTypeRowChangeEvent" msprop:Generator_TablePropName="ProductType" msprop:Generator_RowChangedName="ProductTypeRowChanged" msprop:Generator_RowChangingName="ProductTypeRowChanging" msprop:Generator_TableClassName="ProductTypeDataTable" msprop:Generator_RowClassName="ProductTypeRow" msprop:Generator_TableVarName="tableProductType" msprop:Generator_UserTableName="ProductType">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDProductType" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDProductType" msprop:Generator_ColumnPropNameInTable="IDProductTypeColumn" msprop:Generator_ColumnVarNameInTable="columnIDProductType" msprop:Generator_UserColumnName="IDProductType" type="xs:int" />
              <xs:element name="ProductType" msprop:Generator_ColumnPropNameInRow="ProductType" msprop:Generator_ColumnPropNameInTable="ProductTypeColumn" msprop:Generator_ColumnVarNameInTable="columnProductType" msprop:Generator_UserColumnName="ProductType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Сoefficient" msprop:Generator_ColumnPropNameInRow="Сoefficient" msprop:Generator_ColumnPropNameInTable="СoefficientColumn" msprop:Generator_ColumnVarNameInTable="columnСoefficient" msprop:Generator_UserColumnName="Сoefficient" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Region" msprop:Generator_RowEvHandlerName="RegionRowChangeEventHandler" msprop:Generator_RowDeletedName="RegionRowDeleted" msprop:Generator_RowDeletingName="RegionRowDeleting" msprop:Generator_RowEvArgName="RegionRowChangeEvent" msprop:Generator_TablePropName="Region" msprop:Generator_RowChangedName="RegionRowChanged" msprop:Generator_RowChangingName="RegionRowChanging" msprop:Generator_TableClassName="RegionDataTable" msprop:Generator_RowClassName="RegionRow" msprop:Generator_TableVarName="tableRegion" msprop:Generator_UserTableName="Region">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDRegion" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDRegion" msprop:Generator_ColumnPropNameInTable="IDRegionColumn" msprop:Generator_ColumnVarNameInTable="columnIDRegion" msprop:Generator_UserColumnName="IDRegion" type="xs:int" />
              <xs:element name="Region" msprop:Generator_ColumnPropNameInRow="Region" msprop:Generator_ColumnPropNameInTable="RegionColumn" msprop:Generator_ColumnVarNameInTable="columnRegion" msprop:Generator_UserColumnName="Region" 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="Street" msprop:Generator_RowEvHandlerName="StreetRowChangeEventHandler" msprop:Generator_RowDeletedName="StreetRowDeleted" msprop:Generator_RowDeletingName="StreetRowDeleting" msprop:Generator_RowEvArgName="StreetRowChangeEvent" msprop:Generator_TablePropName="Street" msprop:Generator_RowChangedName="StreetRowChanged" msprop:Generator_RowChangingName="StreetRowChanging" msprop:Generator_TableClassName="StreetDataTable" msprop:Generator_RowClassName="StreetRow" msprop:Generator_TableVarName="tableStreet" msprop:Generator_UserTableName="Street">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDStreet" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDStreet" msprop:Generator_ColumnPropNameInTable="IDStreetColumn" msprop:Generator_ColumnVarNameInTable="columnIDStreet" msprop:Generator_UserColumnName="IDStreet" type="xs:int" />
              <xs:element name="Street" msprop:Generator_ColumnPropNameInRow="Street" msprop:Generator_ColumnPropNameInTable="StreetColumn" msprop:Generator_ColumnVarNameInTable="columnStreet" msprop:Generator_UserColumnName="Street" 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="TypeMaterial" msprop:Generator_RowEvHandlerName="TypeMaterialRowChangeEventHandler" msprop:Generator_RowDeletedName="TypeMaterialRowDeleted" msprop:Generator_RowDeletingName="TypeMaterialRowDeleting" msprop:Generator_RowEvArgName="TypeMaterialRowChangeEvent" msprop:Generator_TablePropName="TypeMaterial" msprop:Generator_RowChangedName="TypeMaterialRowChanged" msprop:Generator_RowChangingName="TypeMaterialRowChanging" msprop:Generator_TableClassName="TypeMaterialDataTable" msprop:Generator_RowClassName="TypeMaterialRow" msprop:Generator_TableVarName="tableTypeMaterial" msprop:Generator_UserTableName="TypeMaterial">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDTypeMaterial" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDTypeMaterial" msprop:Generator_ColumnPropNameInTable="IDTypeMaterialColumn" msprop:Generator_ColumnVarNameInTable="columnIDTypeMaterial" msprop:Generator_UserColumnName="IDTypeMaterial" type="xs:int" />
              <xs:element name="TypeMaterial" msprop:Generator_ColumnPropNameInRow="TypeMaterial" msprop:Generator_ColumnPropNameInTable="TypeMaterialColumn" msprop:Generator_ColumnVarNameInTable="columnTypeMaterial" msprop:Generator_UserColumnName="TypeMaterial" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DefectPercent" msprop:Generator_ColumnPropNameInRow="DefectPercent" msprop:Generator_ColumnPropNameInTable="DefectPercentColumn" msprop:Generator_ColumnVarNameInTable="columnDefectPercent" msprop:Generator_UserColumnName="DefectPercent" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TypePartner" msprop:Generator_RowEvHandlerName="TypePartnerRowChangeEventHandler" msprop:Generator_RowDeletedName="TypePartnerRowDeleted" msprop:Generator_RowDeletingName="TypePartnerRowDeleting" msprop:Generator_RowEvArgName="TypePartnerRowChangeEvent" msprop:Generator_TablePropName="TypePartner" msprop:Generator_RowChangedName="TypePartnerRowChanged" msprop:Generator_RowChangingName="TypePartnerRowChanging" msprop:Generator_TableClassName="TypePartnerDataTable" msprop:Generator_RowClassName="TypePartnerRow" msprop:Generator_TableVarName="tableTypePartner" msprop:Generator_UserTableName="TypePartner">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDTypePartner" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IDTypePartner" msprop:Generator_ColumnPropNameInTable="IDTypePartnerColumn" msprop:Generator_ColumnVarNameInTable="columnIDTypePartner" msprop:Generator_UserColumnName="IDTypePartner" type="xs:int" />
              <xs:element name="TypePartner" msprop:Generator_ColumnPropNameInRow="TypePartner" msprop:Generator_ColumnPropNameInTable="TypePartnerColumn" msprop:Generator_ColumnVarNameInTable="columnTypePartner" msprop:Generator_UserColumnName="TypePartner" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:City" />
      <xs:field xpath="mstns:IDCity" />
    </xs:unique>
    <xs:unique name="Manager_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Manager" />
      <xs:field xpath="mstns:IDManager" />
    </xs:unique>
    <xs:unique name="Partner_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Partner" />
      <xs:field xpath="mstns:IDPartner" />
    </xs:unique>
    <xs:unique name="PartnerProducts_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PartnerProducts" />
      <xs:field xpath="mstns:IDPartnerProduct" />
    </xs:unique>
    <xs:unique name="PostCode_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PostCode" />
      <xs:field xpath="mstns:IDPostCode" />
    </xs:unique>
    <xs:unique name="Product_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Product" />
      <xs:field xpath="mstns:IDProduct" />
    </xs:unique>
    <xs:unique name="ProductType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ProductType" />
      <xs:field xpath="mstns:IDProductType" />
    </xs:unique>
    <xs:unique name="Region_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Region" />
      <xs:field xpath="mstns:IDRegion" />
    </xs:unique>
    <xs:unique name="Street_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Street" />
      <xs:field xpath="mstns:IDStreet" />
    </xs:unique>
    <xs:unique name="TypeMaterial_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TypeMaterial" />
      <xs:field xpath="mstns:IDTypeMaterial" />
    </xs:unique>
    <xs:unique name="TypePartner_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TypePartner" />
      <xs:field xpath="mstns:IDTypePartner" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Partner_City" msdata:parent="City" msdata:child="Partner" msdata:parentkey="IDCity" msdata:childkey="IDCity" msprop:Generator_UserParentTable="City" msprop:Generator_UserChildTable="Partner" msprop:Generator_RelationVarName="relationFK_Partner_City" msprop:Generator_ChildPropName="GetPartnerRows" msprop:Generator_ParentPropName="CityRow" msprop:Generator_UserRelationName="FK_Partner_City" />
      <msdata:Relationship name="FK_Partner_PostCode" msdata:parent="PostCode" msdata:child="Partner" msdata:parentkey="IDPostCode" msdata:childkey="IDPostCode" msprop:Generator_UserParentTable="PostCode" msprop:Generator_UserChildTable="Partner" msprop:Generator_RelationVarName="relationFK_Partner_PostCode" msprop:Generator_UserRelationName="FK_Partner_PostCode" msprop:Generator_ChildPropName="GetPartnerRows" msprop:Generator_ParentPropName="PostCodeRow" />
      <msdata:Relationship name="FK_Partner_Region" msdata:parent="Region" msdata:child="Partner" msdata:parentkey="IDRegion" msdata:childkey="IDRegion" msprop:Generator_UserParentTable="Region" msprop:Generator_UserChildTable="Partner" msprop:Generator_RelationVarName="relationFK_Partner_Region" msprop:Generator_UserRelationName="FK_Partner_Region" msprop:Generator_ChildPropName="GetPartnerRows" msprop:Generator_ParentPropName="RegionRow" />
      <msdata:Relationship name="FK_Partner_Street" msdata:parent="Street" msdata:child="Partner" msdata:parentkey="IDStreet" msdata:childkey="IDStreet" msprop:Generator_UserParentTable="Street" msprop:Generator_UserChildTable="Partner" msprop:Generator_RelationVarName="relationFK_Partner_Street" msprop:Generator_UserRelationName="FK_Partner_Street" msprop:Generator_ChildPropName="GetPartnerRows" msprop:Generator_ParentPropName="StreetRow" />
      <msdata:Relationship name="FK_Partner_TypePartner" msdata:parent="TypePartner" msdata:child="Partner" msdata:parentkey="IDTypePartner" msdata:childkey="IDTypePartner" msprop:Generator_UserParentTable="TypePartner" msprop:Generator_UserChildTable="Partner" msprop:Generator_RelationVarName="relationFK_Partner_TypePartner" msprop:Generator_UserRelationName="FK_Partner_TypePartner" msprop:Generator_ChildPropName="GetPartnerRows" msprop:Generator_ParentPropName="TypePartnerRow" />
      <msdata:Relationship name="FK_PartnerProducts_Partner" msdata:parent="Partner" msdata:child="PartnerProducts" msdata:parentkey="IDPartner" msdata:childkey="IDPartner" msprop:Generator_UserParentTable="Partner" msprop:Generator_UserChildTable="PartnerProducts" msprop:Generator_RelationVarName="relationFK_PartnerProducts_Partner" msprop:Generator_ChildPropName="GetPartnerProductsRows" msprop:Generator_ParentPropName="PartnerRow" msprop:Generator_UserRelationName="FK_PartnerProducts_Partner" />
      <msdata:Relationship name="FK_PartnerProducts_Product" msdata:parent="Product" msdata:child="PartnerProducts" msdata:parentkey="IDProduct" msdata:childkey="IDProduct" msprop:Generator_UserParentTable="Product" msprop:Generator_UserChildTable="PartnerProducts" msprop:Generator_RelationVarName="relationFK_PartnerProducts_Product" msprop:Generator_UserRelationName="FK_PartnerProducts_Product" msprop:Generator_ChildPropName="GetPartnerProductsRows" msprop:Generator_ParentPropName="ProductRow" />
      <msdata:Relationship name="FK_Product_ProductType" msdata:parent="ProductType" msdata:child="Product" msdata:parentkey="IDProductType" msdata:childkey="IDProductType" msprop:Generator_UserParentTable="ProductType" msprop:Generator_UserChildTable="Product" msprop:Generator_RelationVarName="relationFK_Product_ProductType" msprop:Generator_UserRelationName="FK_Product_ProductType" msprop:Generator_ChildPropName="GetProductRows" msprop:Generator_ParentPropName="ProductTypeRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>