Alphapol/СУБД Альфапол/dbAlphapolAGDataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dbAlphapolAGDataSet" targetNamespace="http://tempuri.org/dbAlphapolAGDataSet.xsd" xmlns:mstns="http://tempuri.org/dbAlphapolAGDataSet.xsd" xmlns="http://tempuri.org/dbAlphapolAGDataSet.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="dbAlphapolAGConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dbAlphapolAGConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.СУБД_Альфапол.Properties.Settings.GlobalReference.Default.dbAlphapolAGConnectionString" 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="dbAlphapolAGConnectionString (Settings)" DbObjectName="dbAlphapolAG.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="dbAlphapolAG.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="IndexPartnerTableAdapter" GeneratorDataComponentClassName="IndexPartnerTableAdapter" Name="IndexPartner" UserDataComponentName="IndexPartnerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbAlphapolAGConnectionString (Settings)" DbObjectName="dbAlphapolAG.dbo.IndexPartner" 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].[IndexPartner] WHERE (([idIndex] = @Original_idIndex) AND ((@IsNull_CodePartner = 1 AND [CodePartner] IS NULL) OR ([CodePartner] = @Original_CodePartner)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idIndex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idIndex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodePartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodePartner" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodePartner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodePartner" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[IndexPartner] ([CodePartner]) VALUES (@CodePartner);
SELECT idIndex, CodePartner FROM IndexPartner WHERE (idIndex = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodePartner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodePartner" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idIndex, CodePartner FROM dbo.IndexPartner</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[IndexPartner] SET [CodePartner] = @CodePartner WHERE (([idIndex] = @Original_idIndex) AND ((@IsNull_CodePartner = 1 AND [CodePartner] IS NULL) OR ([CodePartner] = @Original_CodePartner)));
SELECT idIndex, CodePartner FROM IndexPartner WHERE (idIndex = @idIndex)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CodePartner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodePartner" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idIndex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idIndex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodePartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodePartner" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CodePartner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CodePartner" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idIndex" ColumnName="idIndex" DataSourceName="dbAlphapolAG.dbo.IndexPartner" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idIndex" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idIndex" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idIndex" DataSetColumn="idIndex" />
              <Mapping SourceColumn="CodePartner" DataSetColumn="CodePartner" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ManagerTableAdapter" GeneratorDataComponentClassName="ManagerTableAdapter" Name="Manager" UserDataComponentName="ManagerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbAlphapolAGConnectionString (Settings)" DbObjectName="dbAlphapolAG.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_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) 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_Patronymic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" 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], [Patronymic], [Login], [Password], [Photo]) VALUES (@Surname, @Name, @Patronymic, @Login, @Password, @Photo);
SELECT idManager, Surname, Name, Patronymic, 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="@Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" 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, Patronymic, 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, [Patronymic] = @Patronymic, [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_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) 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, Patronymic, 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="@Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" 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_Patronymic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" 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="dbAlphapolAG.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="Patronymic" DataSetColumn="Patronymic" />
              <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="dbAlphapolAGConnectionString (Settings)" DbObjectName="dbAlphapolAG.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 ((@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_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) 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_idIndex = 1 AND [idIndex] IS NULL) OR ([idIndex] = @Original_idIndex)) 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)) AND ((@IsNull_idRegion = 1 AND [idRegion] IS NULL) OR ([idRegion] = @Original_idRegion)) AND ((@IsNull_idTypePartner = 1 AND [idTypePartner] IS NULL) OR ([idTypePartner] = @Original_idTypePartner)) AND ((@IsNull_NamePartner = 1 AND [NamePartner] IS NULL) OR ([NamePartner] = @Original_NamePartner)))</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="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_Patronymic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" 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_idIndex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idIndex" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idIndex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idIndex" 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="String" Direction="Input" ParameterName="@Original_Rating" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Rating" 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_idTypePartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTypePartner" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Partner] ([Surname], [Name], [Patronymic], [Email], [Phone], [idIndex], [idCity], [idStreet], [House], [INN], [Rating], [idRegion], [idTypePartner], [NamePartner]) VALUES (@Surname, @Name, @Patronymic, @Email, @Phone, @idIndex, @idCity, @idStreet, @House, @INN, @Rating, @idRegion, @idTypePartner, @NamePartner);
SELECT idPartner, Surname, Name, Patronymic, Email, Phone, idIndex, idCity, idStreet, House, INN, Rating, idRegion, idTypePartner, NamePartner FROM Partner WHERE (idPartner = 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="@Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" 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="@idIndex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idIndex" 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="String" Direction="Input" ParameterName="@Rating" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Rating" 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="@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" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idPartner, Surname, Name, Patronymic, Email, Phone, idIndex, idCity, idStreet, House, INN, Rating, idRegion, idTypePartner, NamePartner FROM dbo.Partner</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Partner] SET [Surname] = @Surname, [Name] = @Name, [Patronymic] = @Patronymic, [Email] = @Email, [Phone] = @Phone, [idIndex] = @idIndex, [idCity] = @idCity, [idStreet] = @idStreet, [House] = @House, [INN] = @INN, [Rating] = @Rating, [idRegion] = @idRegion, [idTypePartner] = @idTypePartner, [NamePartner] = @NamePartner WHERE (([idPartner] = @Original_idPartner) 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_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) 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_idIndex = 1 AND [idIndex] IS NULL) OR ([idIndex] = @Original_idIndex)) 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)) AND ((@IsNull_idRegion = 1 AND [idRegion] IS NULL) OR ([idRegion] = @Original_idRegion)) AND ((@IsNull_idTypePartner = 1 AND [idTypePartner] IS NULL) OR ([idTypePartner] = @Original_idTypePartner)) AND ((@IsNull_NamePartner = 1 AND [NamePartner] IS NULL) OR ([NamePartner] = @Original_NamePartner)));
SELECT idPartner, Surname, Name, Patronymic, Email, Phone, idIndex, idCity, idStreet, House, INN, Rating, idRegion, idTypePartner, NamePartner FROM Partner WHERE (idPartner = @idPartner)</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="@Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" 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="@idIndex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idIndex" 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="String" Direction="Input" ParameterName="@Rating" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Rating" 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="@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="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="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_Patronymic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" 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_idIndex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idIndex" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idIndex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idIndex" 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="String" Direction="Input" ParameterName="@Original_Rating" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Rating" 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_idTypePartner" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTypePartner" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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="false" AutogeneratedName="idPartner" ColumnName="idPartner" DataSourceName="dbAlphapolAG.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="Surname" DataSetColumn="Surname" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Patronymic" DataSetColumn="Patronymic" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="idIndex" DataSetColumn="idIndex" />
              <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" />
              <Mapping SourceColumn="idRegion" DataSetColumn="idRegion" />
              <Mapping SourceColumn="idTypePartner" DataSetColumn="idTypePartner" />
              <Mapping SourceColumn="NamePartner" DataSetColumn="NamePartner" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductPartnerTableAdapter" GeneratorDataComponentClassName="ProductPartnerTableAdapter" Name="ProductPartner" UserDataComponentName="ProductPartnerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbAlphapolAGConnectionString (Settings)" DbObjectName="dbAlphapolAG.dbo.ProductPartner" 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].[ProductPartner] 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].[ProductPartner] ([idProduct], [idPartner], [CountProduct], [DateSale]) VALUES (@idProduct, @idPartner, @CountProduct, @DateSale);
SELECT idPartnerProduct, idProduct, idPartner, CountProduct, DateSale FROM ProductPartner 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.ProductPartner</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ProductPartner] 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 ProductPartner 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="dbAlphapolAG.dbo.ProductPartner" 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="ProductsTableAdapter" GeneratorDataComponentClassName="ProductsTableAdapter" Name="Products" UserDataComponentName="ProductsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbAlphapolAGConnectionString (Settings)" DbObjectName="dbAlphapolAG.dbo.Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Products] WHERE (([idProduct] = @Original_idProduct) AND ((@IsNull_idTypeProduct = 1 AND [idTypeProduct] IS NULL) OR ([idTypeProduct] = @Original_idTypeProduct)) AND ((@IsNull_Article = 1 AND [Article] IS NULL) OR ([Article] = @Original_Article)) AND ((@IsNull_MinCost = 1 AND [MinCost] IS NULL) OR ([MinCost] = @Original_MinCost)))</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_idTypeProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTypeProduct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTypeProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTypeProduct" 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="Int32" Direction="Input" ParameterName="@Original_Article" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Article" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MinCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_MinCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="MinCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Products] ([idTypeProduct], [NameProduct], [Article], [MinCost]) VALUES (@idTypeProduct, @NameProduct, @Article, @MinCost);
SELECT idProduct, idTypeProduct, NameProduct, Article, MinCost FROM Products WHERE (idProduct = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idTypeProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTypeProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NameProduct" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NameProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Article" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Article" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@MinCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="MinCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idProduct, idTypeProduct, NameProduct, Article, MinCost FROM dbo.Products</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Products] SET [idTypeProduct] = @idTypeProduct, [NameProduct] = @NameProduct, [Article] = @Article, [MinCost] = @MinCost WHERE (([idProduct] = @Original_idProduct) AND ((@IsNull_idTypeProduct = 1 AND [idTypeProduct] IS NULL) OR ([idTypeProduct] = @Original_idTypeProduct)) AND ((@IsNull_Article = 1 AND [Article] IS NULL) OR ([Article] = @Original_Article)) AND ((@IsNull_MinCost = 1 AND [MinCost] IS NULL) OR ([MinCost] = @Original_MinCost)));
SELECT idProduct, idTypeProduct, NameProduct, Article, MinCost FROM Products WHERE (idProduct = @idProduct)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idTypeProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTypeProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NameProduct" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NameProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Article" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Article" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@MinCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="MinCost" 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_idTypeProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTypeProduct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTypeProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTypeProduct" 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="Int32" Direction="Input" ParameterName="@Original_Article" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Article" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MinCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MinCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_MinCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="MinCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idProduct" ColumnName="idProduct" DataSourceName="dbAlphapolAG.dbo.Products" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idProduct" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idProduct" DataSetColumn="idProduct" />
              <Mapping SourceColumn="idTypeProduct" DataSetColumn="idTypeProduct" />
              <Mapping SourceColumn="NameProduct" DataSetColumn="NameProduct" />
              <Mapping SourceColumn="Article" DataSetColumn="Article" />
              <Mapping SourceColumn="MinCost" DataSetColumn="MinCost" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RegionTableAdapter" GeneratorDataComponentClassName="RegionTableAdapter" Name="Region" UserDataComponentName="RegionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbAlphapolAGConnectionString (Settings)" DbObjectName="dbAlphapolAG.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="dbAlphapolAG.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="dbAlphapolAGConnectionString (Settings)" DbObjectName="dbAlphapolAG.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="dbAlphapolAG.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="dbAlphapolAGConnectionString (Settings)" DbObjectName="dbAlphapolAG.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_PercentDefect = 1 AND [PercentDefect] IS NULL) OR ([PercentDefect] = @Original_PercentDefect)))</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_PercentDefect" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PercentDefect" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PercentDefect" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PercentDefect" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TypeMaterial] ([TypeMaterial], [PercentDefect]) VALUES (@TypeMaterial, @PercentDefect);
SELECT idTypeMaterial, TypeMaterial, PercentDefect 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="Decimal" Direction="Input" ParameterName="@PercentDefect" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PercentDefect" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idTypeMaterial, TypeMaterial, PercentDefect FROM dbo.TypeMaterial</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TypeMaterial] SET [TypeMaterial] = @TypeMaterial, [PercentDefect] = @PercentDefect WHERE (([idTypeMaterial] = @Original_idTypeMaterial) AND ((@IsNull_TypeMaterial = 1 AND [TypeMaterial] IS NULL) OR ([TypeMaterial] = @Original_TypeMaterial)) AND ((@IsNull_PercentDefect = 1 AND [PercentDefect] IS NULL) OR ([PercentDefect] = @Original_PercentDefect)));
SELECT idTypeMaterial, TypeMaterial, PercentDefect 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="Decimal" Direction="Input" ParameterName="@PercentDefect" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PercentDefect" 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_PercentDefect" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PercentDefect" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PercentDefect" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PercentDefect" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idTypeMaterial" ColumnName="idTypeMaterial" DataSourceName="dbAlphapolAG.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="PercentDefect" DataSetColumn="PercentDefect" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TypePartnerTableAdapter" GeneratorDataComponentClassName="TypePartnerTableAdapter" Name="TypePartner" UserDataComponentName="TypePartnerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbAlphapolAGConnectionString (Settings)" DbObjectName="dbAlphapolAG.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_Type = 1 AND [Type] IS NULL) OR ([Type] = @Original_Type)))</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_Type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TypePartner] ([Type]) VALUES (@Type);
SELECT idTypePartner, Type FROM TypePartner WHERE (idTypePartner = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idTypePartner, Type FROM dbo.TypePartner</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TypePartner] SET [Type] = @Type WHERE (([idTypePartner] = @Original_idTypePartner) AND ((@IsNull_Type = 1 AND [Type] IS NULL) OR ([Type] = @Original_Type)));
SELECT idTypePartner, Type FROM TypePartner WHERE (idTypePartner = @idTypePartner)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type" 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_Type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idTypePartner" ColumnName="idTypePartner" DataSourceName="dbAlphapolAG.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="Type" DataSetColumn="Type" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TypeProductTableAdapter" GeneratorDataComponentClassName="TypeProductTableAdapter" Name="TypeProduct" UserDataComponentName="TypeProductTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbAlphapolAGConnectionString (Settings)" DbObjectName="dbAlphapolAG.dbo.TypeProduct" 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].[TypeProduct] WHERE (([idTypeProduct] = @Original_idTypeProduct) AND ((@IsNull_TypeProduct = 1 AND [TypeProduct] IS NULL) OR ([TypeProduct] = @Original_TypeProduct)) AND ((@IsNull_Coefficient = 1 AND [Coefficient] IS NULL) OR ([Coefficient] = @Original_Coefficient)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTypeProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTypeProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TypeProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeProduct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TypeProduct" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Coefficient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Coefficient" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Coefficient" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Coefficient" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TypeProduct] ([TypeProduct], [Coefficient]) VALUES (@TypeProduct, @Coefficient);
SELECT idTypeProduct, TypeProduct, Coefficient FROM TypeProduct WHERE (idTypeProduct = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TypeProduct" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Coefficient" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Coefficient" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idTypeProduct, TypeProduct, Coefficient FROM dbo.TypeProduct</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TypeProduct] SET [TypeProduct] = @TypeProduct, [Coefficient] = @Coefficient WHERE (([idTypeProduct] = @Original_idTypeProduct) AND ((@IsNull_TypeProduct = 1 AND [TypeProduct] IS NULL) OR ([TypeProduct] = @Original_TypeProduct)) AND ((@IsNull_Coefficient = 1 AND [Coefficient] IS NULL) OR ([Coefficient] = @Original_Coefficient)));
SELECT idTypeProduct, TypeProduct, Coefficient FROM TypeProduct WHERE (idTypeProduct = @idTypeProduct)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TypeProduct" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Coefficient" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Coefficient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTypeProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTypeProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TypeProduct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeProduct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TypeProduct" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypeProduct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Coefficient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Coefficient" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Coefficient" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Coefficient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idTypeProduct" ColumnName="idTypeProduct" DataSourceName="dbAlphapolAG.dbo.TypeProduct" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idTypeProduct" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idTypeProduct" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idTypeProduct" DataSetColumn="idTypeProduct" />
              <Mapping SourceColumn="TypeProduct" DataSetColumn="TypeProduct" />
              <Mapping SourceColumn="Coefficient" DataSetColumn="Coefficient" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TypeForFilterTableAdapter" GeneratorDataComponentClassName="TypeForFilterTableAdapter" Name="TypeForFilter" UserDataComponentName="TypeForFilterTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbAlphapolAGConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" 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">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select 'Все типы'
union all
select type 
from TypePartner</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Column1" DataSetColumn="Type" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HistorySaleTableAdapter" GeneratorDataComponentClassName="HistorySaleTableAdapter" Name="HistorySale" UserDataComponentName="HistorySaleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dbAlphapolAGConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" 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">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ProductPartner.idPartner, Products.NameProduct, ProductPartner.CountProduct, ProductPartner.DateSale
FROM            ProductPartner INNER JOIN
                         Products ON ProductPartner.idProduct = Products.idProduct</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idPartner" DataSetColumn="idPartner" />
              <Mapping SourceColumn="NameProduct" DataSetColumn="NameProduct" />
              <Mapping SourceColumn="CountProduct" DataSetColumn="CountProduct" />
              <Mapping SourceColumn="DateSale" DataSetColumn="DateSale" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dbAlphapolAGDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dbAlphapolAGDataSet" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="dbAlphapolAGDataSet">
    <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_UserTableName="City" msprop:Generator_RowChangingName="CityRowChanging" msprop:Generator_RowClassName="CityRow" msprop:Generator_TableClassName="CityDataTable" msprop:Generator_TableVarName="tableCity">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idCity" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnPropNameInTable="idCityColumn" msprop:Generator_ColumnPropNameInRow="idCity" msprop:Generator_UserColumnName="idCity" msprop:Generator_ColumnVarNameInTable="columnidCity" type="xs:int" />
              <xs:element name="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_UserColumnName="City" msprop:Generator_ColumnVarNameInTable="columnCity" 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="IndexPartner" msprop:Generator_RowEvHandlerName="IndexPartnerRowChangeEventHandler" msprop:Generator_RowDeletedName="IndexPartnerRowDeleted" msprop:Generator_RowDeletingName="IndexPartnerRowDeleting" msprop:Generator_RowEvArgName="IndexPartnerRowChangeEvent" msprop:Generator_TablePropName="IndexPartner" msprop:Generator_RowChangedName="IndexPartnerRowChanged" msprop:Generator_UserTableName="IndexPartner" msprop:Generator_RowChangingName="IndexPartnerRowChanging" msprop:Generator_RowClassName="IndexPartnerRow" msprop:Generator_TableClassName="IndexPartnerDataTable" msprop:Generator_TableVarName="tableIndexPartner">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idIndex" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnPropNameInTable="idIndexColumn" msprop:Generator_ColumnPropNameInRow="idIndex" msprop:Generator_UserColumnName="idIndex" msprop:Generator_ColumnVarNameInTable="columnidIndex" type="xs:int" />
              <xs:element name="CodePartner" msprop:Generator_ColumnPropNameInTable="CodePartnerColumn" msprop:Generator_ColumnPropNameInRow="CodePartner" msprop:Generator_UserColumnName="CodePartner" msprop:Generator_ColumnVarNameInTable="columnCodePartner" 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_UserTableName="Manager" msprop:Generator_RowChangingName="ManagerRowChanging" msprop:Generator_RowClassName="ManagerRow" msprop:Generator_TableClassName="ManagerDataTable" msprop:Generator_TableVarName="tableManager">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idManager" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnPropNameInTable="idManagerColumn" msprop:Generator_ColumnPropNameInRow="idManager" msprop:Generator_UserColumnName="idManager" msprop:Generator_ColumnVarNameInTable="columnidManager" type="xs:int" />
              <xs:element name="Surname" msprop:Generator_ColumnPropNameInTable="SurnameColumn" msprop:Generator_ColumnPropNameInRow="Surname" msprop:Generator_UserColumnName="Surname" msprop:Generator_ColumnVarNameInTable="columnSurname" 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_ColumnPropNameInTable="NameColumn" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Patronymic" msprop:Generator_ColumnPropNameInTable="PatronymicColumn" msprop:Generator_ColumnPropNameInRow="Patronymic" msprop:Generator_UserColumnName="Patronymic" msprop:Generator_ColumnVarNameInTable="columnPatronymic" 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_ColumnPropNameInTable="LoginColumn" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_UserColumnName="Login" msprop:Generator_ColumnVarNameInTable="columnLogin" 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_ColumnPropNameInTable="PasswordColumn" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_UserColumnName="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" 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_ColumnPropNameInTable="PhotoColumn" msprop:Generator_ColumnPropNameInRow="Photo" msprop:Generator_UserColumnName="Photo" msprop:Generator_ColumnVarNameInTable="columnPhoto" 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="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_UserTableName="Partner" msprop:Generator_RowChangingName="PartnerRowChanging" msprop:Generator_RowClassName="PartnerRow" msprop:Generator_TableClassName="PartnerDataTable" msprop:Generator_TableVarName="tablePartner">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idPartner" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnPropNameInTable="idPartnerColumn" msprop:Generator_ColumnPropNameInRow="idPartner" msprop:Generator_UserColumnName="idPartner" msprop:Generator_ColumnVarNameInTable="columnidPartner" type="xs:int" />
              <xs:element name="Surname" msprop:Generator_ColumnPropNameInTable="SurnameColumn" msprop:Generator_ColumnPropNameInRow="Surname" msprop:Generator_UserColumnName="Surname" msprop:Generator_ColumnVarNameInTable="columnSurname" 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_ColumnPropNameInTable="NameColumn" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Patronymic" msprop:Generator_ColumnPropNameInTable="PatronymicColumn" msprop:Generator_ColumnPropNameInRow="Patronymic" msprop:Generator_UserColumnName="Patronymic" msprop:Generator_ColumnVarNameInTable="columnPatronymic" 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_ColumnPropNameInTable="EmailColumn" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" 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_ColumnPropNameInTable="PhoneColumn" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_UserColumnName="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="idIndex" msprop:Generator_ColumnPropNameInTable="idIndexColumn" msprop:Generator_ColumnPropNameInRow="idIndex" msprop:Generator_UserColumnName="idIndex" msprop:Generator_ColumnVarNameInTable="columnidIndex" type="xs:int" minOccurs="0" />
              <xs:element name="idCity" msprop:Generator_ColumnPropNameInTable="idCityColumn" msprop:Generator_ColumnPropNameInRow="idCity" msprop:Generator_UserColumnName="idCity" msprop:Generator_ColumnVarNameInTable="columnidCity" type="xs:int" minOccurs="0" />
              <xs:element name="idStreet" msprop:Generator_ColumnPropNameInTable="idStreetColumn" msprop:Generator_ColumnPropNameInRow="idStreet" msprop:Generator_UserColumnName="idStreet" msprop:Generator_ColumnVarNameInTable="columnidStreet" type="xs:int" minOccurs="0" />
              <xs:element name="House" msprop:Generator_ColumnPropNameInTable="HouseColumn" msprop:Generator_ColumnPropNameInRow="House" msprop:Generator_UserColumnName="House" msprop:Generator_ColumnVarNameInTable="columnHouse" type="xs:int" minOccurs="0" />
              <xs:element name="INN" msprop:Generator_ColumnPropNameInTable="INNColumn" msprop:Generator_ColumnPropNameInRow="INN" msprop:Generator_UserColumnName="INN" msprop:Generator_ColumnVarNameInTable="columnINN" 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_ColumnPropNameInTable="RatingColumn" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_UserColumnName="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="idRegion" msprop:Generator_ColumnPropNameInTable="idRegionColumn" msprop:Generator_ColumnPropNameInRow="idRegion" msprop:Generator_UserColumnName="idRegion" msprop:Generator_ColumnVarNameInTable="columnidRegion" type="xs:int" minOccurs="0" />
              <xs:element name="idTypePartner" msprop:Generator_ColumnPropNameInTable="idTypePartnerColumn" msprop:Generator_ColumnPropNameInRow="idTypePartner" msprop:Generator_UserColumnName="idTypePartner" msprop:Generator_ColumnVarNameInTable="columnidTypePartner" type="xs:int" minOccurs="0" />
              <xs:element name="NamePartner" msprop:Generator_ColumnPropNameInTable="NamePartnerColumn" msprop:Generator_ColumnPropNameInRow="NamePartner" msprop:Generator_UserColumnName="NamePartner" msprop:Generator_ColumnVarNameInTable="columnNamePartner" 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="ProductPartner" msprop:Generator_RowEvHandlerName="ProductPartnerRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductPartnerRowDeleted" msprop:Generator_RowDeletingName="ProductPartnerRowDeleting" msprop:Generator_RowEvArgName="ProductPartnerRowChangeEvent" msprop:Generator_TablePropName="ProductPartner" msprop:Generator_RowChangedName="ProductPartnerRowChanged" msprop:Generator_UserTableName="ProductPartner" msprop:Generator_RowChangingName="ProductPartnerRowChanging" msprop:Generator_RowClassName="ProductPartnerRow" msprop:Generator_TableClassName="ProductPartnerDataTable" msprop:Generator_TableVarName="tableProductPartner">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idPartnerProduct" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnPropNameInTable="idPartnerProductColumn" msprop:Generator_ColumnPropNameInRow="idPartnerProduct" msprop:Generator_UserColumnName="idPartnerProduct" msprop:Generator_ColumnVarNameInTable="columnidPartnerProduct" type="xs:int" />
              <xs:element name="idProduct" msprop:Generator_ColumnPropNameInTable="idProductColumn" msprop:Generator_ColumnPropNameInRow="idProduct" msprop:Generator_UserColumnName="idProduct" msprop:Generator_ColumnVarNameInTable="columnidProduct" type="xs:int" minOccurs="0" />
              <xs:element name="idPartner" msprop:Generator_ColumnPropNameInTable="idPartnerColumn" msprop:Generator_ColumnPropNameInRow="idPartner" msprop:Generator_UserColumnName="idPartner" msprop:Generator_ColumnVarNameInTable="columnidPartner" type="xs:int" minOccurs="0" />
              <xs:element name="CountProduct" msprop:Generator_ColumnPropNameInTable="CountProductColumn" msprop:Generator_ColumnPropNameInRow="CountProduct" msprop:Generator_UserColumnName="CountProduct" msprop:Generator_ColumnVarNameInTable="columnCountProduct" type="xs:int" minOccurs="0" />
              <xs:element name="DateSale" msprop:Generator_ColumnPropNameInTable="DateSaleColumn" msprop:Generator_ColumnPropNameInRow="DateSale" msprop:Generator_UserColumnName="DateSale" msprop:Generator_ColumnVarNameInTable="columnDateSale" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Products" msprop:Generator_RowEvHandlerName="ProductsRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductsRowDeleted" msprop:Generator_RowDeletingName="ProductsRowDeleting" msprop:Generator_RowEvArgName="ProductsRowChangeEvent" msprop:Generator_TablePropName="Products" msprop:Generator_RowChangedName="ProductsRowChanged" msprop:Generator_UserTableName="Products" msprop:Generator_RowChangingName="ProductsRowChanging" msprop:Generator_RowClassName="ProductsRow" msprop:Generator_TableClassName="ProductsDataTable" msprop:Generator_TableVarName="tableProducts">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idProduct" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnPropNameInTable="idProductColumn" msprop:Generator_ColumnPropNameInRow="idProduct" msprop:Generator_UserColumnName="idProduct" msprop:Generator_ColumnVarNameInTable="columnidProduct" type="xs:int" />
              <xs:element name="idTypeProduct" msprop:Generator_ColumnPropNameInTable="idTypeProductColumn" msprop:Generator_ColumnPropNameInRow="idTypeProduct" msprop:Generator_UserColumnName="idTypeProduct" msprop:Generator_ColumnVarNameInTable="columnidTypeProduct" type="xs:int" minOccurs="0" />
              <xs:element name="NameProduct" msprop:Generator_ColumnPropNameInTable="NameProductColumn" msprop:Generator_ColumnPropNameInRow="NameProduct" msprop:Generator_UserColumnName="NameProduct" msprop:Generator_ColumnVarNameInTable="columnNameProduct" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Article" msprop:Generator_ColumnPropNameInTable="ArticleColumn" msprop:Generator_ColumnPropNameInRow="Article" msprop:Generator_UserColumnName="Article" msprop:Generator_ColumnVarNameInTable="columnArticle" type="xs:int" minOccurs="0" />
              <xs:element name="MinCost" msprop:Generator_ColumnPropNameInTable="MinCostColumn" msprop:Generator_ColumnPropNameInRow="MinCost" msprop:Generator_UserColumnName="MinCost" msprop:Generator_ColumnVarNameInTable="columnMinCost" type="xs:decimal" 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_UserTableName="Region" msprop:Generator_RowChangingName="RegionRowChanging" msprop:Generator_RowClassName="RegionRow" msprop:Generator_TableClassName="RegionDataTable" msprop:Generator_TableVarName="tableRegion">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idRegion" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnPropNameInTable="idRegionColumn" msprop:Generator_ColumnPropNameInRow="idRegion" msprop:Generator_UserColumnName="idRegion" msprop:Generator_ColumnVarNameInTable="columnidRegion" type="xs:int" />
              <xs:element name="Region" msprop:Generator_ColumnPropNameInTable="RegionColumn" msprop:Generator_ColumnPropNameInRow="Region" msprop:Generator_UserColumnName="Region" msprop:Generator_ColumnVarNameInTable="columnRegion" 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_UserTableName="Street" msprop:Generator_RowChangingName="StreetRowChanging" msprop:Generator_RowClassName="StreetRow" msprop:Generator_TableClassName="StreetDataTable" msprop:Generator_TableVarName="tableStreet">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idStreet" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnPropNameInTable="idStreetColumn" msprop:Generator_ColumnPropNameInRow="idStreet" msprop:Generator_UserColumnName="idStreet" msprop:Generator_ColumnVarNameInTable="columnidStreet" type="xs:int" />
              <xs:element name="Street" msprop:Generator_ColumnPropNameInTable="StreetColumn" msprop:Generator_ColumnPropNameInRow="Street" msprop:Generator_UserColumnName="Street" msprop:Generator_ColumnVarNameInTable="columnStreet" 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_UserTableName="TypeMaterial" msprop:Generator_RowChangingName="TypeMaterialRowChanging" msprop:Generator_RowClassName="TypeMaterialRow" msprop:Generator_TableClassName="TypeMaterialDataTable" msprop:Generator_TableVarName="tableTypeMaterial">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idTypeMaterial" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnPropNameInTable="idTypeMaterialColumn" msprop:Generator_ColumnPropNameInRow="idTypeMaterial" msprop:Generator_UserColumnName="idTypeMaterial" msprop:Generator_ColumnVarNameInTable="columnidTypeMaterial" type="xs:int" />
              <xs:element name="TypeMaterial" msprop:Generator_ColumnPropNameInTable="TypeMaterialColumn" msprop:Generator_ColumnPropNameInRow="TypeMaterial" msprop:Generator_UserColumnName="TypeMaterial" msprop:Generator_ColumnVarNameInTable="columnTypeMaterial" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PercentDefect" msprop:Generator_ColumnPropNameInTable="PercentDefectColumn" msprop:Generator_ColumnPropNameInRow="PercentDefect" msprop:Generator_UserColumnName="PercentDefect" msprop:Generator_ColumnVarNameInTable="columnPercentDefect" type="xs:decimal" 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_UserTableName="TypePartner" msprop:Generator_RowChangingName="TypePartnerRowChanging" msprop:Generator_RowClassName="TypePartnerRow" msprop:Generator_TableClassName="TypePartnerDataTable" msprop:Generator_TableVarName="tableTypePartner">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idTypePartner" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnPropNameInTable="idTypePartnerColumn" msprop:Generator_ColumnPropNameInRow="idTypePartner" msprop:Generator_UserColumnName="idTypePartner" msprop:Generator_ColumnVarNameInTable="columnidTypePartner" type="xs:int" />
              <xs:element name="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnVarNameInTable="columnType" 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="TypeProduct" msprop:Generator_RowEvHandlerName="TypeProductRowChangeEventHandler" msprop:Generator_RowDeletedName="TypeProductRowDeleted" msprop:Generator_RowDeletingName="TypeProductRowDeleting" msprop:Generator_RowEvArgName="TypeProductRowChangeEvent" msprop:Generator_TablePropName="TypeProduct" msprop:Generator_RowChangedName="TypeProductRowChanged" msprop:Generator_UserTableName="TypeProduct" msprop:Generator_RowChangingName="TypeProductRowChanging" msprop:Generator_RowClassName="TypeProductRow" msprop:Generator_TableClassName="TypeProductDataTable" msprop:Generator_TableVarName="tableTypeProduct">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idTypeProduct" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnPropNameInTable="idTypeProductColumn" msprop:Generator_ColumnPropNameInRow="idTypeProduct" msprop:Generator_UserColumnName="idTypeProduct" msprop:Generator_ColumnVarNameInTable="columnidTypeProduct" type="xs:int" />
              <xs:element name="TypeProduct" msprop:Generator_ColumnPropNameInTable="TypeProductColumn" msprop:Generator_ColumnPropNameInRow="TypeProduct" msprop:Generator_UserColumnName="TypeProduct" msprop:Generator_ColumnVarNameInTable="columnTypeProduct" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Coefficient" msprop:Generator_ColumnPropNameInTable="CoefficientColumn" msprop:Generator_ColumnPropNameInRow="Coefficient" msprop:Generator_UserColumnName="Coefficient" msprop:Generator_ColumnVarNameInTable="columnCoefficient" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TypeForFilter" msprop:Generator_RowClassName="TypeForFilterRow" msprop:Generator_RowEvHandlerName="TypeForFilterRowChangeEventHandler" msprop:Generator_RowDeletedName="TypeForFilterRowDeleted" msprop:Generator_RowDeletingName="TypeForFilterRowDeleting" msprop:Generator_RowEvArgName="TypeForFilterRowChangeEvent" msprop:Generator_TablePropName="TypeForFilter" msprop:Generator_RowChangedName="TypeForFilterRowChanged" msprop:Generator_UserTableName="TypeForFilter" msprop:Generator_RowChangingName="TypeForFilterRowChanging" msprop:Generator_TableClassName="TypeForFilterDataTable" msprop:Generator_TableVarName="tableTypeForFilter">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Type" msdata:ReadOnly="true" msdata:Caption="Column1" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" 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="HistorySale" msprop:Generator_RowEvHandlerName="HistorySaleRowChangeEventHandler" msprop:Generator_RowDeletedName="HistorySaleRowDeleted" msprop:Generator_RowDeletingName="HistorySaleRowDeleting" msprop:Generator_RowEvArgName="HistorySaleRowChangeEvent" msprop:Generator_TablePropName="HistorySale" msprop:Generator_RowChangedName="HistorySaleRowChanged" msprop:Generator_RowChangingName="HistorySaleRowChanging" msprop:Generator_TableClassName="HistorySaleDataTable" msprop:Generator_RowClassName="HistorySaleRow" msprop:Generator_TableVarName="tableHistorySale" msprop:Generator_UserTableName="HistorySale">
          <xs:complexType>
            <xs:sequence>
              <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="NameProduct" msprop:Generator_ColumnPropNameInRow="NameProduct" msprop:Generator_ColumnPropNameInTable="NameProductColumn" msprop:Generator_ColumnVarNameInTable="columnNameProduct" msprop:Generator_UserColumnName="NameProduct" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <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: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="IndexPartner_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IndexPartner" />
      <xs:field xpath="mstns:idIndex" />
    </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="ProductPartner_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ProductPartner" />
      <xs:field xpath="mstns:idPartnerProduct" />
    </xs:unique>
    <xs:unique name="Products_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Products" />
      <xs:field xpath="mstns:idProduct" />
    </xs:unique>
    <xs:unique name="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:unique name="TypeProduct_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TypeProduct" />
      <xs:field xpath="mstns:idTypeProduct" />
    </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_IndexPartner" msdata:parent="IndexPartner" msdata:child="Partner" msdata:parentkey="idIndex" msdata:childkey="idIndex" msprop:Generator_UserParentTable="IndexPartner" msprop:Generator_UserChildTable="Partner" msprop:Generator_RelationVarName="relationFK_Partner_IndexPartner" msprop:Generator_ChildPropName="GetPartnerRows" msprop:Generator_ParentPropName="IndexPartnerRow" msprop:Generator_UserRelationName="FK_Partner_IndexPartner" />
      <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_ChildPropName="GetPartnerRows" msprop:Generator_UserRelationName="FK_Partner_Region" 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_ChildPropName="GetPartnerRows" msprop:Generator_UserRelationName="FK_Partner_Street" 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_ChildPropName="GetPartnerRows" msprop:Generator_UserRelationName="FK_Partner_TypePartner" msprop:Generator_ParentPropName="TypePartnerRow" />
      <msdata:Relationship name="FK_ProductPartner_Partner" msdata:parent="Partner" msdata:child="ProductPartner" msdata:parentkey="idPartner" msdata:childkey="idPartner" msprop:Generator_UserParentTable="Partner" msprop:Generator_UserChildTable="ProductPartner" msprop:Generator_RelationVarName="relationFK_ProductPartner_Partner" msprop:Generator_ChildPropName="GetProductPartnerRows" msprop:Generator_ParentPropName="PartnerRow" msprop:Generator_UserRelationName="FK_ProductPartner_Partner" />
      <msdata:Relationship name="FK_ProductPartner_Products" msdata:parent="Products" msdata:child="ProductPartner" msdata:parentkey="idProduct" msdata:childkey="idProduct" msprop:Generator_UserParentTable="Products" msprop:Generator_UserChildTable="ProductPartner" msprop:Generator_RelationVarName="relationFK_ProductPartner_Products" msprop:Generator_ChildPropName="GetProductPartnerRows" msprop:Generator_UserRelationName="FK_ProductPartner_Products" msprop:Generator_ParentPropName="ProductsRow" />
      <msdata:Relationship name="FK_Products_TypeProduct" msdata:parent="TypeProduct" msdata:child="Products" msdata:parentkey="idTypeProduct" msdata:childkey="idTypeProduct" msprop:Generator_UserParentTable="TypeProduct" msprop:Generator_UserChildTable="Products" msprop:Generator_RelationVarName="relationFK_Products_TypeProduct" msprop:Generator_ChildPropName="GetProductsRows" msprop:Generator_UserRelationName="FK_Products_TypeProduct" msprop:Generator_ParentPropName="TypeProductRow" />
      <msdata:Relationship name="FK_ProductPartner_Partner1" msdata:parent="Partner" msdata:child="HistorySale" msdata:parentkey="idPartner" msdata:childkey="idPartner" msprop:Generator_UserParentTable="Partner" msprop:Generator_UserChildTable="HistorySale" msprop:Generator_RelationVarName="relationFK_ProductPartner_Partner1" msprop:Generator_ChildPropName="GetHistorySaleRows" msprop:Generator_ParentPropName="PartnerRow" msprop:Generator_UserRelationName="FK_ProductPartner_Partner1" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>