up/Учебная практика 25-27 гр. 2 сем. - 1/СУБД Агентство автономный 2021/СУБД Агентство/DBAgentstvoDataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DBAgentstvoDataSet" targetNamespace="http://tempuri.org/DBAgentstvoDataSet.xsd" xmlns:mstns="http://tempuri.org/DBAgentstvoDataSet.xsd" xmlns="http://tempuri.org/DBAgentstvoDataSet.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="DBAgentstvoConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="DBAgentstvoConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.СУБД_Агентство.Properties.Settings.GlobalReference.Default.DBAgentstvoConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PotrebnostTableAdapter" GeneratorDataComponentClassName="PotrebnostTableAdapter" Name="Potrebnost" UserDataComponentName="PotrebnostTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DBAgentstvoConnectionString (Settings)" DbObjectName="DBAgentstvo.dbo.Potrebnost" 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].[Potrebnost] WHERE (([idpotrebnost] = @Original_idpotrebnost) AND ([idklient] = @Original_idklient) AND ([idrielter] = @Original_idrielter) AND ((@IsNull_minplosh = 1 AND [minplosh] IS NULL) OR ([minplosh] = @Original_minplosh)) AND ((@IsNull_maxplosh = 1 AND [maxplosh] IS NULL) OR ([maxplosh] = @Original_maxplosh)) AND ((@IsNull_minetazh = 1 AND [minetazh] IS NULL) OR ([minetazh] = @Original_minetazh)) AND ((@IsNull_maxetazh = 1 AND [maxetazh] IS NULL) OR ([maxetazh] = @Original_maxetazh)) AND ((@IsNull_minkomnat = 1 AND [minkomnat] IS NULL) OR ([minkomnat] = @Original_minkomnat)) AND ((@IsNull_maxkomnat = 1 AND [maxkomnat] IS NULL) OR ([maxkomnat] = @Original_maxkomnat)) AND ((@IsNull_mincena = 1 AND [mincena] IS NULL) OR ([mincena] = @Original_mincena)) AND ((@IsNull_maxcena = 1 AND [maxcena] IS NULL) OR ([maxcena] = @Original_maxcena)) AND ((@IsNull_zaversheno = 1 AND [zaversheno] IS NULL) OR ([zaversheno] = @Original_zaversheno)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idpotrebnost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idpotrebnost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idklient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idklient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idrielter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idrielter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_minplosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minplosh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_minplosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minplosh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maxplosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxplosh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_maxplosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxplosh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_minetazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minetazh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_minetazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minetazh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maxetazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxetazh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_maxetazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxetazh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_minkomnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minkomnat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_minkomnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minkomnat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maxkomnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxkomnat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_maxkomnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxkomnat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mincena" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mincena" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_mincena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="mincena" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maxcena" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxcena" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_maxcena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="maxcena" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_zaversheno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="zaversheno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_zaversheno" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="zaversheno" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Potrebnost] ([idklient], [idrielter], [minplosh], [maxplosh], [minetazh], [maxetazh], [minkomnat], [maxkomnat], [mincena], [maxcena], [zaversheno]) VALUES (@idklient, @idrielter, @minplosh, @maxplosh, @minetazh, @maxetazh, @minkomnat, @maxkomnat, @mincena, @maxcena, @zaversheno);
SELECT idpotrebnost, idklient, idrielter, minplosh, maxplosh, minetazh, maxetazh, minkomnat, maxkomnat, mincena, maxcena, zaversheno FROM Potrebnost WHERE (idpotrebnost = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idklient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idklient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idrielter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idrielter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@minplosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minplosh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@maxplosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxplosh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@minetazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minetazh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@maxetazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxetazh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@minkomnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minkomnat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@maxkomnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxkomnat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@mincena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="mincena" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@maxcena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="maxcena" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@zaversheno" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="zaversheno" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idpotrebnost, idklient, idrielter, minplosh, maxplosh, minetazh, maxetazh, minkomnat, maxkomnat, mincena, maxcena, zaversheno FROM dbo.Potrebnost</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Potrebnost] SET [idklient] = @idklient, [idrielter] = @idrielter, [minplosh] = @minplosh, [maxplosh] = @maxplosh, [minetazh] = @minetazh, [maxetazh] = @maxetazh, [minkomnat] = @minkomnat, [maxkomnat] = @maxkomnat, [mincena] = @mincena, [maxcena] = @maxcena, [zaversheno] = @zaversheno WHERE (([idpotrebnost] = @Original_idpotrebnost) AND ([idklient] = @Original_idklient) AND ([idrielter] = @Original_idrielter) AND ((@IsNull_minplosh = 1 AND [minplosh] IS NULL) OR ([minplosh] = @Original_minplosh)) AND ((@IsNull_maxplosh = 1 AND [maxplosh] IS NULL) OR ([maxplosh] = @Original_maxplosh)) AND ((@IsNull_minetazh = 1 AND [minetazh] IS NULL) OR ([minetazh] = @Original_minetazh)) AND ((@IsNull_maxetazh = 1 AND [maxetazh] IS NULL) OR ([maxetazh] = @Original_maxetazh)) AND ((@IsNull_minkomnat = 1 AND [minkomnat] IS NULL) OR ([minkomnat] = @Original_minkomnat)) AND ((@IsNull_maxkomnat = 1 AND [maxkomnat] IS NULL) OR ([maxkomnat] = @Original_maxkomnat)) AND ((@IsNull_mincena = 1 AND [mincena] IS NULL) OR ([mincena] = @Original_mincena)) AND ((@IsNull_maxcena = 1 AND [maxcena] IS NULL) OR ([maxcena] = @Original_maxcena)) AND ((@IsNull_zaversheno = 1 AND [zaversheno] IS NULL) OR ([zaversheno] = @Original_zaversheno)));
SELECT idpotrebnost, idklient, idrielter, minplosh, maxplosh, minetazh, maxetazh, minkomnat, maxkomnat, mincena, maxcena, zaversheno FROM Potrebnost WHERE (idpotrebnost = @idpotrebnost)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idklient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idklient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idrielter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idrielter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@minplosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minplosh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@maxplosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxplosh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@minetazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minetazh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@maxetazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxetazh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@minkomnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minkomnat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@maxkomnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxkomnat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@mincena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="mincena" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@maxcena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="maxcena" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@zaversheno" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="zaversheno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idpotrebnost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idpotrebnost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idklient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idklient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idrielter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idrielter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_minplosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minplosh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_minplosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minplosh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maxplosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxplosh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_maxplosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxplosh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_minetazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minetazh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_minetazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minetazh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maxetazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxetazh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_maxetazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxetazh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_minkomnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minkomnat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_minkomnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="minkomnat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maxkomnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxkomnat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_maxkomnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxkomnat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mincena" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mincena" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_mincena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="mincena" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_maxcena" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="maxcena" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_maxcena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="maxcena" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_zaversheno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="zaversheno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_zaversheno" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="zaversheno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idpotrebnost" ColumnName="idpotrebnost" DataSourceName="DBAgentstvo.dbo.Potrebnost" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idpotrebnost" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idpotrebnost" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idpotrebnost" DataSetColumn="idpotrebnost" />
              <Mapping SourceColumn="idklient" DataSetColumn="idklient" />
              <Mapping SourceColumn="idrielter" DataSetColumn="idrielter" />
              <Mapping SourceColumn="minplosh" DataSetColumn="minplosh" />
              <Mapping SourceColumn="maxplosh" DataSetColumn="maxplosh" />
              <Mapping SourceColumn="minetazh" DataSetColumn="minetazh" />
              <Mapping SourceColumn="maxetazh" DataSetColumn="maxetazh" />
              <Mapping SourceColumn="minkomnat" DataSetColumn="minkomnat" />
              <Mapping SourceColumn="maxkomnat" DataSetColumn="maxkomnat" />
              <Mapping SourceColumn="mincena" DataSetColumn="mincena" />
              <Mapping SourceColumn="maxcena" DataSetColumn="maxcena" />
              <Mapping SourceColumn="zaversheno" DataSetColumn="zaversheno" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="predlozhenieTableAdapter" GeneratorDataComponentClassName="predlozhenieTableAdapter" Name="predlozhenie" UserDataComponentName="predlozhenieTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DBAgentstvoConnectionString (Settings)" DbObjectName="DBAgentstvo.dbo.predlozhenie" 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].[predlozhenie] WHERE (([idpredlozhenie] = @Original_idpredlozhenie) AND ([idklient] = @Original_idklient) AND ([idrielter] = @Original_idrielter) AND ((@IsNull_adres = 1 AND [adres] IS NULL) OR ([adres] = @Original_adres)) AND ((@IsNull_plosh = 1 AND [plosh] IS NULL) OR ([plosh] = @Original_plosh)) AND ((@IsNull_etazh = 1 AND [etazh] IS NULL) OR ([etazh] = @Original_etazh)) AND ((@IsNull_komnat = 1 AND [komnat] IS NULL) OR ([komnat] = @Original_komnat)) AND ((@IsNull_cena = 1 AND [cena] IS NULL) OR ([cena] = @Original_cena)) AND ((@IsNull_zaversheno = 1 AND [zaversheno] IS NULL) OR ([zaversheno] = @Original_zaversheno)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idpredlozhenie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idpredlozhenie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idklient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idklient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idrielter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idrielter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_adres" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="adres" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_adres" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="adres" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_plosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="plosh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_plosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="plosh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_etazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="etazh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_etazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="etazh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_komnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="komnat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_komnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="komnat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cena" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cena" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_cena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="cena" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_zaversheno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="zaversheno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_zaversheno" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="zaversheno" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[predlozhenie] ([idklient], [idrielter], [adres], [plosh], [etazh], [komnat], [cena], [zaversheno]) VALUES (@idklient, @idrielter, @adres, @plosh, @etazh, @komnat, @cena, @zaversheno);
SELECT idpredlozhenie, idklient, idrielter, adres, plosh, etazh, komnat, cena, zaversheno FROM predlozhenie WHERE (idpredlozhenie = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idklient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idklient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idrielter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idrielter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@adres" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="adres" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@plosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="plosh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@etazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="etazh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@komnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="komnat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@cena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="cena" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@zaversheno" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="zaversheno" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idpredlozhenie, idklient, idrielter, adres, plosh, etazh, komnat, cena, zaversheno FROM dbo.predlozhenie</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[predlozhenie] SET [idklient] = @idklient, [idrielter] = @idrielter, [adres] = @adres, [plosh] = @plosh, [etazh] = @etazh, [komnat] = @komnat, [cena] = @cena, [zaversheno] = @zaversheno WHERE (([idpredlozhenie] = @Original_idpredlozhenie) AND ([idklient] = @Original_idklient) AND ([idrielter] = @Original_idrielter) AND ((@IsNull_adres = 1 AND [adres] IS NULL) OR ([adres] = @Original_adres)) AND ((@IsNull_plosh = 1 AND [plosh] IS NULL) OR ([plosh] = @Original_plosh)) AND ((@IsNull_etazh = 1 AND [etazh] IS NULL) OR ([etazh] = @Original_etazh)) AND ((@IsNull_komnat = 1 AND [komnat] IS NULL) OR ([komnat] = @Original_komnat)) AND ((@IsNull_cena = 1 AND [cena] IS NULL) OR ([cena] = @Original_cena)) AND ((@IsNull_zaversheno = 1 AND [zaversheno] IS NULL) OR ([zaversheno] = @Original_zaversheno)));
SELECT idpredlozhenie, idklient, idrielter, adres, plosh, etazh, komnat, cena, zaversheno FROM predlozhenie WHERE (idpredlozhenie = @idpredlozhenie)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idklient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idklient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idrielter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idrielter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@adres" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="adres" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@plosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="plosh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@etazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="etazh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@komnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="komnat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@cena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="cena" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@zaversheno" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="zaversheno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idpredlozhenie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idpredlozhenie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idklient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idklient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idrielter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idrielter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_adres" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="adres" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_adres" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="adres" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_plosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="plosh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_plosh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="plosh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_etazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="etazh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_etazh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="etazh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_komnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="komnat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_komnat" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="komnat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cena" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cena" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_cena" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="cena" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_zaversheno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="zaversheno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_zaversheno" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="zaversheno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idpredlozhenie" ColumnName="idpredlozhenie" DataSourceName="DBAgentstvo.dbo.predlozhenie" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idpredlozhenie" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idpredlozhenie" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idpredlozhenie" DataSetColumn="idpredlozhenie" />
              <Mapping SourceColumn="idklient" DataSetColumn="idklient" />
              <Mapping SourceColumn="idrielter" DataSetColumn="idrielter" />
              <Mapping SourceColumn="adres" DataSetColumn="adres" />
              <Mapping SourceColumn="plosh" DataSetColumn="plosh" />
              <Mapping SourceColumn="etazh" DataSetColumn="etazh" />
              <Mapping SourceColumn="komnat" DataSetColumn="komnat" />
              <Mapping SourceColumn="cena" DataSetColumn="cena" />
              <Mapping SourceColumn="zaversheno" DataSetColumn="zaversheno" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SdelkaTableAdapter" GeneratorDataComponentClassName="SdelkaTableAdapter" Name="Sdelka" UserDataComponentName="SdelkaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DBAgentstvoConnectionString (Settings)" DbObjectName="DBAgentstvo.dbo.Sdelka" 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].[Sdelka] WHERE (([idsdelka] = @Original_idsdelka) AND ([idpotrebnost] = @Original_idpotrebnost) AND ([idpredlozhenie] = @Original_idpredlozhenie) AND ((@IsNull_datesdelka = 1 AND [datesdelka] IS NULL) OR ([datesdelka] = @Original_datesdelka)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idsdelka" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idsdelka" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idpotrebnost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idpotrebnost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idpredlozhenie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idpredlozhenie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_datesdelka" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="datesdelka" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_datesdelka" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="datesdelka" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Sdelka] ([idpotrebnost], [idpredlozhenie], [datesdelka]) VALUES (@idpotrebnost, @idpredlozhenie, @datesdelka);
SELECT idsdelka, idpotrebnost, idpredlozhenie, datesdelka FROM Sdelka WHERE (idsdelka = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idpotrebnost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idpotrebnost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idpredlozhenie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idpredlozhenie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@datesdelka" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="datesdelka" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idsdelka, idpotrebnost, idpredlozhenie, datesdelka FROM dbo.Sdelka</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Sdelka] SET [idpotrebnost] = @idpotrebnost, [idpredlozhenie] = @idpredlozhenie, [datesdelka] = @datesdelka WHERE (([idsdelka] = @Original_idsdelka) AND ([idpotrebnost] = @Original_idpotrebnost) AND ([idpredlozhenie] = @Original_idpredlozhenie) AND ((@IsNull_datesdelka = 1 AND [datesdelka] IS NULL) OR ([datesdelka] = @Original_datesdelka)));
SELECT idsdelka, idpotrebnost, idpredlozhenie, datesdelka FROM Sdelka WHERE (idsdelka = @idsdelka)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idpotrebnost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idpotrebnost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idpredlozhenie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idpredlozhenie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@datesdelka" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="datesdelka" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idsdelka" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idsdelka" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idpotrebnost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idpotrebnost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idpredlozhenie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idpredlozhenie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_datesdelka" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="datesdelka" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_datesdelka" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="datesdelka" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idsdelka" ColumnName="idsdelka" DataSourceName="DBAgentstvo.dbo.Sdelka" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idsdelka" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idsdelka" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idsdelka" DataSetColumn="idsdelka" />
              <Mapping SourceColumn="idpotrebnost" DataSetColumn="idpotrebnost" />
              <Mapping SourceColumn="idpredlozhenie" DataSetColumn="idpredlozhenie" />
              <Mapping SourceColumn="datesdelka" DataSetColumn="datesdelka" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DBAgentstvoConnectionString (Settings)" DbObjectName="DBAgentstvo.dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Users] WHERE (([idusers] = @Original_idusers) AND ((@IsNull_fam = 1 AND [fam] IS NULL) OR ([fam] = @Original_fam)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ([login] = @Original_login) AND ([password] = @Original_password) AND ([type] = @Original_type))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idusers" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusers" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fam" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" 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="false" 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="false" 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].[Users] ([fam], [name], [login], [password], [type], [photo]) VALUES (@fam, @name, @login, @password, @type, @photo);
SELECT idusers, fam, name, login, password, type, photo FROM Users WHERE (idusers = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@photo" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idusers, fam, name, login, password, type, photo FROM dbo.Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Users] SET [fam] = @fam, [name] = @name, [login] = @login, [password] = @password, [type] = @type, [photo] = @photo WHERE (([idusers] = @Original_idusers) AND ((@IsNull_fam = 1 AND [fam] IS NULL) OR ([fam] = @Original_fam)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ([login] = @Original_login) AND ([password] = @Original_password) AND ([type] = @Original_type));
SELECT idusers, fam, name, login, password, type, photo FROM Users WHERE (idusers = @idusers)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@photo" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idusers" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idusers" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fam" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fam" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" 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="false" 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="false" 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="idusers" ColumnName="idusers" DataSourceName="DBAgentstvo.dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idusers" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idusers" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idusers" DataSetColumn="idusers" />
              <Mapping SourceColumn="fam" DataSetColumn="fam" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="login" DataSetColumn="login" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
              <Mapping SourceColumn="type" DataSetColumn="type" />
              <Mapping SourceColumn="photo" DataSetColumn="photo" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DBAgentstvoDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="DBAgentstvoDataSet" msprop:Generator_UserDSName="DBAgentstvoDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Potrebnost" msprop:Generator_TableClassName="PotrebnostDataTable" msprop:Generator_TableVarName="tablePotrebnost" msprop:Generator_TablePropName="Potrebnost" msprop:Generator_RowDeletingName="PotrebnostRowDeleting" msprop:Generator_RowChangingName="PotrebnostRowChanging" msprop:Generator_RowEvHandlerName="PotrebnostRowChangeEventHandler" msprop:Generator_RowDeletedName="PotrebnostRowDeleted" msprop:Generator_UserTableName="Potrebnost" msprop:Generator_RowChangedName="PotrebnostRowChanged" msprop:Generator_RowEvArgName="PotrebnostRowChangeEvent" msprop:Generator_RowClassName="PotrebnostRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idpotrebnost" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnVarNameInTable="columnidpotrebnost" msprop:Generator_ColumnPropNameInRow="idpotrebnost" msprop:Generator_ColumnPropNameInTable="idpotrebnostColumn" msprop:Generator_UserColumnName="idpotrebnost" type="xs:int" />
              <xs:element name="idklient" msprop:Generator_ColumnVarNameInTable="columnidklient" msprop:Generator_ColumnPropNameInRow="idklient" msprop:Generator_ColumnPropNameInTable="idklientColumn" msprop:Generator_UserColumnName="idklient" type="xs:int" />
              <xs:element name="idrielter" msprop:Generator_ColumnVarNameInTable="columnidrielter" msprop:Generator_ColumnPropNameInRow="idrielter" msprop:Generator_ColumnPropNameInTable="idrielterColumn" msprop:Generator_UserColumnName="idrielter" type="xs:int" />
              <xs:element name="minplosh" msprop:Generator_ColumnVarNameInTable="columnminplosh" msprop:Generator_ColumnPropNameInRow="minplosh" msprop:Generator_ColumnPropNameInTable="minploshColumn" msprop:Generator_UserColumnName="minplosh" type="xs:int" minOccurs="0" />
              <xs:element name="maxplosh" msprop:Generator_ColumnVarNameInTable="columnmaxplosh" msprop:Generator_ColumnPropNameInRow="maxplosh" msprop:Generator_ColumnPropNameInTable="maxploshColumn" msprop:Generator_UserColumnName="maxplosh" type="xs:int" minOccurs="0" />
              <xs:element name="minetazh" msprop:Generator_ColumnVarNameInTable="columnminetazh" msprop:Generator_ColumnPropNameInRow="minetazh" msprop:Generator_ColumnPropNameInTable="minetazhColumn" msprop:Generator_UserColumnName="minetazh" type="xs:int" minOccurs="0" />
              <xs:element name="maxetazh" msprop:Generator_ColumnVarNameInTable="columnmaxetazh" msprop:Generator_ColumnPropNameInRow="maxetazh" msprop:Generator_ColumnPropNameInTable="maxetazhColumn" msprop:Generator_UserColumnName="maxetazh" type="xs:int" minOccurs="0" />
              <xs:element name="minkomnat" msprop:Generator_ColumnVarNameInTable="columnminkomnat" msprop:Generator_ColumnPropNameInRow="minkomnat" msprop:Generator_ColumnPropNameInTable="minkomnatColumn" msprop:Generator_UserColumnName="minkomnat" type="xs:int" minOccurs="0" />
              <xs:element name="maxkomnat" msprop:Generator_ColumnVarNameInTable="columnmaxkomnat" msprop:Generator_ColumnPropNameInRow="maxkomnat" msprop:Generator_ColumnPropNameInTable="maxkomnatColumn" msprop:Generator_UserColumnName="maxkomnat" type="xs:int" minOccurs="0" />
              <xs:element name="mincena" msprop:Generator_ColumnVarNameInTable="columnmincena" msprop:Generator_ColumnPropNameInRow="mincena" msprop:Generator_ColumnPropNameInTable="mincenaColumn" msprop:Generator_UserColumnName="mincena" type="xs:decimal" minOccurs="0" />
              <xs:element name="maxcena" msprop:Generator_ColumnVarNameInTable="columnmaxcena" msprop:Generator_ColumnPropNameInRow="maxcena" msprop:Generator_ColumnPropNameInTable="maxcenaColumn" msprop:Generator_UserColumnName="maxcena" type="xs:decimal" minOccurs="0" />
              <xs:element name="zaversheno" msprop:Generator_ColumnVarNameInTable="columnzaversheno" msprop:Generator_ColumnPropNameInRow="zaversheno" msprop:Generator_ColumnPropNameInTable="zavershenoColumn" msprop:Generator_UserColumnName="zaversheno" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="predlozhenie" msprop:Generator_TableClassName="predlozhenieDataTable" msprop:Generator_TableVarName="tablepredlozhenie" msprop:Generator_TablePropName="predlozhenie" msprop:Generator_RowDeletingName="predlozhenieRowDeleting" msprop:Generator_RowChangingName="predlozhenieRowChanging" msprop:Generator_RowEvHandlerName="predlozhenieRowChangeEventHandler" msprop:Generator_RowDeletedName="predlozhenieRowDeleted" msprop:Generator_UserTableName="predlozhenie" msprop:Generator_RowChangedName="predlozhenieRowChanged" msprop:Generator_RowEvArgName="predlozhenieRowChangeEvent" msprop:Generator_RowClassName="predlozhenieRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idpredlozhenie" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnVarNameInTable="columnidpredlozhenie" msprop:Generator_ColumnPropNameInRow="idpredlozhenie" msprop:Generator_ColumnPropNameInTable="idpredlozhenieColumn" msprop:Generator_UserColumnName="idpredlozhenie" type="xs:int" />
              <xs:element name="idklient" msprop:Generator_ColumnVarNameInTable="columnidklient" msprop:Generator_ColumnPropNameInRow="idklient" msprop:Generator_ColumnPropNameInTable="idklientColumn" msprop:Generator_UserColumnName="idklient" type="xs:int" />
              <xs:element name="idrielter" msprop:Generator_ColumnVarNameInTable="columnidrielter" msprop:Generator_ColumnPropNameInRow="idrielter" msprop:Generator_ColumnPropNameInTable="idrielterColumn" msprop:Generator_UserColumnName="idrielter" type="xs:int" />
              <xs:element name="adres" msprop:Generator_ColumnVarNameInTable="columnadres" msprop:Generator_ColumnPropNameInRow="adres" msprop:Generator_ColumnPropNameInTable="adresColumn" msprop:Generator_UserColumnName="adres" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="plosh" msprop:Generator_ColumnVarNameInTable="columnplosh" msprop:Generator_ColumnPropNameInRow="plosh" msprop:Generator_ColumnPropNameInTable="ploshColumn" msprop:Generator_UserColumnName="plosh" type="xs:int" minOccurs="0" />
              <xs:element name="etazh" msprop:Generator_ColumnVarNameInTable="columnetazh" msprop:Generator_ColumnPropNameInRow="etazh" msprop:Generator_ColumnPropNameInTable="etazhColumn" msprop:Generator_UserColumnName="etazh" type="xs:int" minOccurs="0" />
              <xs:element name="komnat" msprop:Generator_ColumnVarNameInTable="columnkomnat" msprop:Generator_ColumnPropNameInRow="komnat" msprop:Generator_ColumnPropNameInTable="komnatColumn" msprop:Generator_UserColumnName="komnat" type="xs:int" minOccurs="0" />
              <xs:element name="cena" msprop:Generator_ColumnVarNameInTable="columncena" msprop:Generator_ColumnPropNameInRow="cena" msprop:Generator_ColumnPropNameInTable="cenaColumn" msprop:Generator_UserColumnName="cena" type="xs:decimal" minOccurs="0" />
              <xs:element name="zaversheno" msprop:Generator_ColumnVarNameInTable="columnzaversheno" msprop:Generator_ColumnPropNameInRow="zaversheno" msprop:Generator_ColumnPropNameInTable="zavershenoColumn" msprop:Generator_UserColumnName="zaversheno" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Sdelka" msprop:Generator_TableClassName="SdelkaDataTable" msprop:Generator_TableVarName="tableSdelka" msprop:Generator_TablePropName="Sdelka" msprop:Generator_RowDeletingName="SdelkaRowDeleting" msprop:Generator_RowChangingName="SdelkaRowChanging" msprop:Generator_RowEvHandlerName="SdelkaRowChangeEventHandler" msprop:Generator_RowDeletedName="SdelkaRowDeleted" msprop:Generator_UserTableName="Sdelka" msprop:Generator_RowChangedName="SdelkaRowChanged" msprop:Generator_RowEvArgName="SdelkaRowChangeEvent" msprop:Generator_RowClassName="SdelkaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idsdelka" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnVarNameInTable="columnidsdelka" msprop:Generator_ColumnPropNameInRow="idsdelka" msprop:Generator_ColumnPropNameInTable="idsdelkaColumn" msprop:Generator_UserColumnName="idsdelka" type="xs:int" />
              <xs:element name="idpotrebnost" msprop:Generator_ColumnVarNameInTable="columnidpotrebnost" msprop:Generator_ColumnPropNameInRow="idpotrebnost" msprop:Generator_ColumnPropNameInTable="idpotrebnostColumn" msprop:Generator_UserColumnName="idpotrebnost" type="xs:int" />
              <xs:element name="idpredlozhenie" msprop:Generator_ColumnVarNameInTable="columnidpredlozhenie" msprop:Generator_ColumnPropNameInRow="idpredlozhenie" msprop:Generator_ColumnPropNameInTable="idpredlozhenieColumn" msprop:Generator_UserColumnName="idpredlozhenie" type="xs:int" />
              <xs:element name="datesdelka" msprop:Generator_ColumnVarNameInTable="columndatesdelka" msprop:Generator_ColumnPropNameInRow="datesdelka" msprop:Generator_ColumnPropNameInTable="datesdelkaColumn" msprop:Generator_UserColumnName="datesdelka" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_TablePropName="Users" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_UserTableName="Users" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowClassName="UsersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idusers" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnVarNameInTable="columnidusers" msprop:Generator_ColumnPropNameInRow="idusers" msprop:Generator_ColumnPropNameInTable="idusersColumn" msprop:Generator_UserColumnName="idusers" type="xs:int" />
              <xs:element name="fam" msprop:Generator_ColumnVarNameInTable="columnfam" msprop:Generator_ColumnPropNameInRow="fam" msprop:Generator_ColumnPropNameInTable="famColumn" msprop:Generator_UserColumnName="fam" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="login" msprop:Generator_ColumnVarNameInTable="columnlogin" msprop:Generator_ColumnPropNameInRow="login" msprop:Generator_ColumnPropNameInTable="loginColumn" msprop:Generator_UserColumnName="login">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="type" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnPropNameInTable="typeColumn" msprop:Generator_UserColumnName="type" default="1">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="photo" msprop:Generator_ColumnVarNameInTable="columnphoto" msprop:Generator_ColumnPropNameInRow="photo" msprop:Generator_ColumnPropNameInTable="photoColumn" msprop:Generator_UserColumnName="photo" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Potrebnost" />
      <xs:field xpath="mstns:idpotrebnost" />
    </xs:unique>
    <xs:unique name="predlozhenie_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:predlozhenie" />
      <xs:field xpath="mstns:idpredlozhenie" />
    </xs:unique>
    <xs:unique name="Sdelka_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Sdelka" />
      <xs:field xpath="mstns:idsdelka" />
    </xs:unique>
    <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:idusers" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Potrebnost_Users" msdata:parent="Users" msdata:child="Potrebnost" msdata:parentkey="idusers" msdata:childkey="idklient" msprop:Generator_UserChildTable="Potrebnost" msprop:Generator_ChildPropName="GetPotrebnostRowsByFK_Potrebnost_Users" msprop:Generator_UserRelationName="FK_Potrebnost_Users" msprop:Generator_RelationVarName="relationFK_Potrebnost_Users" msprop:Generator_UserParentTable="Users" msprop:Generator_ParentPropName="UsersRowByFK_Potrebnost_Users" />
      <msdata:Relationship name="FK_Potrebnost_Users1" msdata:parent="Users" msdata:child="Potrebnost" msdata:parentkey="idusers" msdata:childkey="idrielter" msprop:Generator_UserChildTable="Potrebnost" msprop:Generator_ChildPropName="GetPotrebnostRowsByFK_Potrebnost_Users1" msprop:Generator_UserRelationName="FK_Potrebnost_Users1" msprop:Generator_RelationVarName="relationFK_Potrebnost_Users1" msprop:Generator_UserParentTable="Users" msprop:Generator_ParentPropName="UsersRowByFK_Potrebnost_Users1" />
      <msdata:Relationship name="FK_predlozhenie_Users" msdata:parent="Users" msdata:child="predlozhenie" msdata:parentkey="idusers" msdata:childkey="idklient" msprop:Generator_UserChildTable="predlozhenie" msprop:Generator_ChildPropName="GetpredlozhenieRowsByFK_predlozhenie_Users" msprop:Generator_UserRelationName="FK_predlozhenie_Users" msprop:Generator_RelationVarName="relationFK_predlozhenie_Users" msprop:Generator_UserParentTable="Users" msprop:Generator_ParentPropName="UsersRowByFK_predlozhenie_Users" />
      <msdata:Relationship name="FK_predlozhenie_Users1" msdata:parent="Users" msdata:child="predlozhenie" msdata:parentkey="idusers" msdata:childkey="idrielter" msprop:Generator_UserChildTable="predlozhenie" msprop:Generator_ChildPropName="GetpredlozhenieRowsByFK_predlozhenie_Users1" msprop:Generator_UserRelationName="FK_predlozhenie_Users1" msprop:Generator_RelationVarName="relationFK_predlozhenie_Users1" msprop:Generator_UserParentTable="Users" msprop:Generator_ParentPropName="UsersRowByFK_predlozhenie_Users1" />
      <msdata:Relationship name="FK_Sdelka_Potrebnost" msdata:parent="Potrebnost" msdata:child="Sdelka" msdata:parentkey="idpotrebnost" msdata:childkey="idpotrebnost" msprop:Generator_UserChildTable="Sdelka" msprop:Generator_ChildPropName="GetSdelkaRows" msprop:Generator_UserRelationName="FK_Sdelka_Potrebnost" msprop:Generator_ParentPropName="PotrebnostRow" msprop:Generator_RelationVarName="relationFK_Sdelka_Potrebnost" msprop:Generator_UserParentTable="Potrebnost" />
      <msdata:Relationship name="FK_Sdelka_predlozhenie" msdata:parent="predlozhenie" msdata:child="Sdelka" msdata:parentkey="idpredlozhenie" msdata:childkey="idpredlozhenie" msprop:Generator_UserChildTable="Sdelka" msprop:Generator_ChildPropName="GetSdelkaRows" msprop:Generator_UserRelationName="FK_Sdelka_predlozhenie" msprop:Generator_ParentPropName="predlozhenieRow" msprop:Generator_RelationVarName="relationFK_Sdelka_predlozhenie" msprop:Generator_UserParentTable="predlozhenie" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>