Avtodrive_02/Avtodrive_02DataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Avtodrive_02DataSet" targetNamespace="http://tempuri.org/Avtodrive_02DataSet.xsd" xmlns:mstns="http://tempuri.org/Avtodrive_02DataSet.xsd" xmlns="http://tempuri.org/Avtodrive_02DataSet.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="Avtodrive_02ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Avtodrive_02ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Avtoprok.Properties.Settings.GlobalReference.Default.Avtodrive_02ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CarTableAdapter" GeneratorDataComponentClassName="CarTableAdapter" Name="Car" UserDataComponentName="CarTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Avtodrive_02ConnectionString (Settings)" DbObjectName="Avtodrive_02.dbo.Car" 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].[Car] WHERE (([ID] = @Original_ID) AND ((@IsNull_Model = 1 AND [Model] IS NULL) OR ([Model] = @Original_Model)) AND ((@IsNull_Color = 1 AND [Color] IS NULL) OR ([Color] = @Original_Color)) AND ((@IsNull_CarManufactureDate = 1 AND [CarManufactureDate] IS NULL) OR ([CarManufactureDate] = @Original_CarManufactureDate)) AND ((@IsNull_GovermantNumber = 1 AND [GovermantNumber] IS NULL) OR ([GovermantNumber] = @Original_GovermantNumber)) AND ((@IsNull_CarInsuranceCost = 1 AND [CarInsuranceCost] IS NULL) OR ([CarInsuranceCost] = @Original_CarInsuranceCost)) AND ((@IsNull_OneDayCost = 1 AND [OneDayCost] IS NULL) OR ([OneDayCost] = @Original_OneDayCost)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Model" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Model" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Color" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CarManufactureDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CarManufactureDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_CarManufactureDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CarManufactureDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GovermantNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GovermantNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GovermantNumber" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GovermantNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CarInsuranceCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CarInsuranceCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_CarInsuranceCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="CarInsuranceCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OneDayCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OneDayCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_OneDayCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="OneDayCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Car] ([Model], [Color], [CarManufactureDate], [GovermantNumber], [CarInsuranceCost], [OneDayCost]) VALUES (@Model, @Color, @CarManufactureDate, @GovermantNumber, @CarInsuranceCost, @OneDayCost);
SELECT ID, Model, Color, CarManufactureDate, GovermantNumber, CarInsuranceCost, OneDayCost FROM Car WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Model" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Color" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@CarManufactureDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CarManufactureDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GovermantNumber" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GovermantNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@CarInsuranceCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="CarInsuranceCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@OneDayCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="OneDayCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Model, Color, CarManufactureDate, GovermantNumber, CarInsuranceCost, OneDayCost FROM dbo.Car</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Car] SET [Model] = @Model, [Color] = @Color, [CarManufactureDate] = @CarManufactureDate, [GovermantNumber] = @GovermantNumber, [CarInsuranceCost] = @CarInsuranceCost, [OneDayCost] = @OneDayCost WHERE (([ID] = @Original_ID) AND ((@IsNull_Model = 1 AND [Model] IS NULL) OR ([Model] = @Original_Model)) AND ((@IsNull_Color = 1 AND [Color] IS NULL) OR ([Color] = @Original_Color)) AND ((@IsNull_CarManufactureDate = 1 AND [CarManufactureDate] IS NULL) OR ([CarManufactureDate] = @Original_CarManufactureDate)) AND ((@IsNull_GovermantNumber = 1 AND [GovermantNumber] IS NULL) OR ([GovermantNumber] = @Original_GovermantNumber)) AND ((@IsNull_CarInsuranceCost = 1 AND [CarInsuranceCost] IS NULL) OR ([CarInsuranceCost] = @Original_CarInsuranceCost)) AND ((@IsNull_OneDayCost = 1 AND [OneDayCost] IS NULL) OR ([OneDayCost] = @Original_OneDayCost)));
SELECT ID, Model, Color, CarManufactureDate, GovermantNumber, CarInsuranceCost, OneDayCost FROM Car WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Model" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Color" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@CarManufactureDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CarManufactureDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GovermantNumber" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GovermantNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@CarInsuranceCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="CarInsuranceCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@OneDayCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="OneDayCost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Model" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Model" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Color" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Color" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CarManufactureDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CarManufactureDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_CarManufactureDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="CarManufactureDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GovermantNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GovermantNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GovermantNumber" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GovermantNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CarInsuranceCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CarInsuranceCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_CarInsuranceCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="CarInsuranceCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OneDayCost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OneDayCost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_OneDayCost" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="OneDayCost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="Avtodrive_02.dbo.Car" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Model" DataSetColumn="Model" />
              <Mapping SourceColumn="Color" DataSetColumn="Color" />
              <Mapping SourceColumn="CarManufactureDate" DataSetColumn="CarManufactureDate" />
              <Mapping SourceColumn="GovermantNumber" DataSetColumn="GovermantNumber" />
              <Mapping SourceColumn="CarInsuranceCost" DataSetColumn="CarInsuranceCost" />
              <Mapping SourceColumn="OneDayCost" DataSetColumn="OneDayCost" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientTableAdapter" GeneratorDataComponentClassName="ClientTableAdapter" Name="Client" UserDataComponentName="ClientTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Avtodrive_02ConnectionString (Settings)" DbObjectName="Avtodrive_02.dbo.Client" 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].[Client] WHERE (([ID] = @Original_ID) AND ((@IsNull_FIO = 1 AND [FIO] IS NULL) OR ([FIO] = @Original_FIO)) AND ((@IsNull_Pasport = 1 AND [Pasport] IS NULL) OR ([Pasport] = @Original_Pasport)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FIO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FIO" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pasport" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pasport" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Pasport" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Pasport" 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="StringFixedLength" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Client] ([FIO], [Pasport], [Phone], [Address]) VALUES (@FIO, @Pasport, @Phone, @Address);
SELECT ID, FIO, Pasport, Phone, Address FROM Client WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FIO" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Pasport" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Pasport" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, FIO, Pasport, Phone, Address FROM dbo.Client</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Client] SET [FIO] = @FIO, [Pasport] = @Pasport, [Phone] = @Phone, [Address] = @Address WHERE (([ID] = @Original_ID) AND ((@IsNull_FIO = 1 AND [FIO] IS NULL) OR ([FIO] = @Original_FIO)) AND ((@IsNull_Pasport = 1 AND [Pasport] IS NULL) OR ([Pasport] = @Original_Pasport)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)));
SELECT ID, FIO, Pasport, Phone, Address FROM Client WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@FIO" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Pasport" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Pasport" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FIO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_FIO" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="FIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pasport" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pasport" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Pasport" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Pasport" 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="StringFixedLength" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="Avtodrive_02.dbo.Client" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
              <Mapping SourceColumn="Pasport" DataSetColumn="Pasport" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Order_TableAdapter" GeneratorDataComponentClassName="Order_TableAdapter" Name="Order_" UserDataComponentName="Order_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Avtodrive_02ConnectionString (Settings)" DbObjectName="Avtodrive_02.dbo.Order_" 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].[Order_] WHERE (([ID] = @Original_ID) AND ((@IsNull_ID_Client = 1 AND [ID_Client] IS NULL) OR ([ID_Client] = @Original_ID_Client)) AND ((@IsNull_ID_Car = 1 AND [ID_Car] IS NULL) OR ([ID_Car] = @Original_ID_Car)) AND ((@IsNull_Date_order = 1 AND [Date_order] IS NULL) OR ([Date_order] = @Original_Date_order)) AND ((@IsNull_OrderTimeDay = 1 AND [OrderTimeDay] IS NULL) OR ([OrderTimeDay] = @Original_OrderTimeDay)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Client" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Client" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Client" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Client" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Car" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Car" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Car" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Car" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Date_order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Date_order" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Date_order" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date_order" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrderTimeDay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderTimeDay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderTimeDay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderTimeDay" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Order_] ([ID_Client], [ID_Car], [Date_order], [OrderTimeDay]) VALUES (@ID_Client, @ID_Car, @Date_order, @OrderTimeDay);
SELECT ID, ID_Client, ID_Car, Date_order, OrderTimeDay FROM Order_ WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Client" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Client" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Car" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Car" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Date_order" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date_order" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderTimeDay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderTimeDay" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, ID_Client, ID_Car, Date_order, OrderTimeDay FROM dbo.Order_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Order_] SET [ID_Client] = @ID_Client, [ID_Car] = @ID_Car, [Date_order] = @Date_order, [OrderTimeDay] = @OrderTimeDay WHERE (([ID] = @Original_ID) AND ((@IsNull_ID_Client = 1 AND [ID_Client] IS NULL) OR ([ID_Client] = @Original_ID_Client)) AND ((@IsNull_ID_Car = 1 AND [ID_Car] IS NULL) OR ([ID_Car] = @Original_ID_Car)) AND ((@IsNull_Date_order = 1 AND [Date_order] IS NULL) OR ([Date_order] = @Original_Date_order)) AND ((@IsNull_OrderTimeDay = 1 AND [OrderTimeDay] IS NULL) OR ([OrderTimeDay] = @Original_OrderTimeDay)));
SELECT ID, ID_Client, ID_Car, Date_order, OrderTimeDay FROM Order_ WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Client" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Client" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_Car" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Car" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Date_order" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date_order" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderTimeDay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderTimeDay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Client" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Client" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Client" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Client" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ID_Car" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Car" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_Car" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_Car" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Date_order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Date_order" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Date_order" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date_order" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrderTimeDay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderTimeDay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderTimeDay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderTimeDay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="Avtodrive_02.dbo.Order_" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="ID_Client" DataSetColumn="ID_Client" />
              <Mapping SourceColumn="ID_Car" DataSetColumn="ID_Car" />
              <Mapping SourceColumn="Date_order" DataSetColumn="Date_order" />
              <Mapping SourceColumn="OrderTimeDay" DataSetColumn="OrderTimeDay" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Task1TableAdapter" GeneratorDataComponentClassName="Task1TableAdapter" Name="Task1" UserDataComponentName="Task1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Avtodrive_02ConnectionString (Settings)" DbObjectName="Avtodrive_02.dbo.Task1" DbObjectType="StoredProcedure" 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">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Task1</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@value1" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nchar" DbType="StringFixedLength" Direction="Input" ParameterName="@value2" Precision="0" ProviderType="NChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Model" DataSetColumn="Model" />
              <Mapping SourceColumn="Color" DataSetColumn="Color" />
              <Mapping SourceColumn="CarManufactureDate" DataSetColumn="CarManufactureDate" />
              <Mapping SourceColumn="GovermantNumber" DataSetColumn="GovermantNumber" />
              <Mapping SourceColumn="CarInsuranceCost" DataSetColumn="CarInsuranceCost" />
              <Mapping SourceColumn="OneDayCost" DataSetColumn="OneDayCost" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Task2TableAdapter" GeneratorDataComponentClassName="Task2TableAdapter" Name="Task2" UserDataComponentName="Task2TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Avtodrive_02ConnectionString (Settings)" DbObjectName="Avtodrive_02.dbo.Task2" DbObjectType="StoredProcedure" 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">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Task2</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nchar" DbType="StringFixedLength" Direction="Input" ParameterName="@Value1" Precision="0" ProviderType="NChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Model" DataSetColumn="Model" />
              <Mapping SourceColumn="Color" DataSetColumn="Color" />
              <Mapping SourceColumn="CarManufactureDate" DataSetColumn="CarManufactureDate" />
              <Mapping SourceColumn="GovermantNumber" DataSetColumn="GovermantNumber" />
              <Mapping SourceColumn="CarInsuranceCost" DataSetColumn="CarInsuranceCost" />
              <Mapping SourceColumn="OneDayCost" DataSetColumn="OneDayCost" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Task3TableAdapter" GeneratorDataComponentClassName="Task3TableAdapter" Name="Task3" UserDataComponentName="Task3TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Avtodrive_02ConnectionString (Settings)" DbObjectName="Avtodrive_02.dbo.Task3" DbObjectType="StoredProcedure" 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">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Task3</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@value1" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@value2" Precision="10" ProviderType="Date" Scale="0" Size="3" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
              <Mapping SourceColumn="Model" DataSetColumn="Model" />
              <Mapping SourceColumn="GovermantNumber" DataSetColumn="GovermantNumber" />
              <Mapping SourceColumn="Date_order" DataSetColumn="Date_order" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Task4TableAdapter" GeneratorDataComponentClassName="Task4TableAdapter" Name="Task4" UserDataComponentName="Task4TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Avtodrive_02ConnectionString (Settings)" DbObjectName="Avtodrive_02.dbo.Task4" DbObjectType="StoredProcedure" 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">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Task4</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="GovermantNumber" DataSetColumn="GovermantNumber" />
              <Mapping SourceColumn="Model" DataSetColumn="Model" />
              <Mapping SourceColumn="OneDayCost" DataSetColumn="OneDayCost" />
              <Mapping SourceColumn="OrderTimeDay" DataSetColumn="OrderTimeDay" />
              <Mapping SourceColumn="Стоимость" DataSetColumn="Стоимость" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Task5TableAdapter" GeneratorDataComponentClassName="Task5TableAdapter" Name="Task5" UserDataComponentName="Task5TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Avtodrive_02ConnectionString (Settings)" DbObjectName="Avtodrive_02.dbo.Task5" DbObjectType="StoredProcedure" 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">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Task5</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Model" DataSetColumn="Model" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Avtodrive_02DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Avtodrive_02DataSet" msprop:Generator_UserDSName="Avtodrive_02DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Car" msprop:Generator_TableClassName="CarDataTable" msprop:Generator_TableVarName="tableCar" msprop:Generator_TablePropName="Car" msprop:Generator_RowDeletingName="CarRowDeleting" msprop:Generator_RowChangingName="CarRowChanging" msprop:Generator_RowEvHandlerName="CarRowChangeEventHandler" msprop:Generator_RowDeletedName="CarRowDeleted" msprop:Generator_UserTableName="Car" msprop:Generator_RowChangedName="CarRowChanged" msprop:Generator_RowEvArgName="CarRowChangeEvent" msprop:Generator_RowClassName="CarRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Model" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnPropNameInTable="ModelColumn" msprop:Generator_UserColumnName="Model" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Color" msprop:Generator_ColumnVarNameInTable="columnColor" msprop:Generator_ColumnPropNameInRow="Color" msprop:Generator_ColumnPropNameInTable="ColorColumn" msprop:Generator_UserColumnName="Color" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CarManufactureDate" msprop:Generator_ColumnVarNameInTable="columnCarManufactureDate" msprop:Generator_ColumnPropNameInRow="CarManufactureDate" msprop:Generator_ColumnPropNameInTable="CarManufactureDateColumn" msprop:Generator_UserColumnName="CarManufactureDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="GovermantNumber" msprop:Generator_ColumnVarNameInTable="columnGovermantNumber" msprop:Generator_ColumnPropNameInRow="GovermantNumber" msprop:Generator_ColumnPropNameInTable="GovermantNumberColumn" msprop:Generator_UserColumnName="GovermantNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CarInsuranceCost" msprop:Generator_ColumnVarNameInTable="columnCarInsuranceCost" msprop:Generator_ColumnPropNameInRow="CarInsuranceCost" msprop:Generator_ColumnPropNameInTable="CarInsuranceCostColumn" msprop:Generator_UserColumnName="CarInsuranceCost" type="xs:decimal" minOccurs="0" />
              <xs:element name="OneDayCost" msprop:Generator_ColumnVarNameInTable="columnOneDayCost" msprop:Generator_ColumnPropNameInRow="OneDayCost" msprop:Generator_ColumnPropNameInTable="OneDayCostColumn" msprop:Generator_UserColumnName="OneDayCost" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Client" msprop:Generator_TableClassName="ClientDataTable" msprop:Generator_TableVarName="tableClient" msprop:Generator_TablePropName="Client" msprop:Generator_RowDeletingName="ClientRowDeleting" msprop:Generator_RowChangingName="ClientRowChanging" msprop:Generator_RowEvHandlerName="ClientRowChangeEventHandler" msprop:Generator_RowDeletedName="ClientRowDeleted" msprop:Generator_UserTableName="Client" msprop:Generator_RowChangedName="ClientRowChanged" msprop:Generator_RowEvArgName="ClientRowChangeEvent" msprop:Generator_RowClassName="ClientRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Pasport" msprop:Generator_ColumnVarNameInTable="columnPasport" msprop:Generator_ColumnPropNameInRow="Pasport" msprop:Generator_ColumnPropNameInTable="PasportColumn" msprop:Generator_UserColumnName="Pasport" 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_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Order_" msprop:Generator_TableClassName="Order_DataTable" msprop:Generator_TableVarName="tableOrder_" msprop:Generator_TablePropName="Order_" msprop:Generator_RowDeletingName="Order_RowDeleting" msprop:Generator_RowChangingName="Order_RowChanging" msprop:Generator_RowEvHandlerName="Order_RowChangeEventHandler" msprop:Generator_RowDeletedName="Order_RowDeleted" msprop:Generator_UserTableName="Order_" msprop:Generator_RowChangedName="Order_RowChanged" msprop:Generator_RowEvArgName="Order_RowChangeEvent" msprop:Generator_RowClassName="Order_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="ID_Client" msprop:Generator_ColumnVarNameInTable="columnID_Client" msprop:Generator_ColumnPropNameInRow="ID_Client" msprop:Generator_ColumnPropNameInTable="ID_ClientColumn" msprop:Generator_UserColumnName="ID_Client" type="xs:int" minOccurs="0" />
              <xs:element name="ID_Car" msprop:Generator_ColumnVarNameInTable="columnID_Car" msprop:Generator_ColumnPropNameInRow="ID_Car" msprop:Generator_ColumnPropNameInTable="ID_CarColumn" msprop:Generator_UserColumnName="ID_Car" type="xs:int" minOccurs="0" />
              <xs:element name="Date_order" msprop:Generator_ColumnVarNameInTable="columnDate_order" msprop:Generator_ColumnPropNameInRow="Date_order" msprop:Generator_ColumnPropNameInTable="Date_orderColumn" msprop:Generator_UserColumnName="Date_order" type="xs:dateTime" minOccurs="0" />
              <xs:element name="OrderTimeDay" msprop:Generator_ColumnVarNameInTable="columnOrderTimeDay" msprop:Generator_ColumnPropNameInRow="OrderTimeDay" msprop:Generator_ColumnPropNameInTable="OrderTimeDayColumn" msprop:Generator_UserColumnName="OrderTimeDay" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Task1" msprop:Generator_TableClassName="Task1DataTable" msprop:Generator_TableVarName="tableTask1" msprop:Generator_TablePropName="Task1" msprop:Generator_RowDeletingName="Task1RowDeleting" msprop:Generator_RowChangingName="Task1RowChanging" msprop:Generator_RowEvHandlerName="Task1RowChangeEventHandler" msprop:Generator_RowDeletedName="Task1RowDeleted" msprop:Generator_UserTableName="Task1" msprop:Generator_RowChangedName="Task1RowChanged" msprop:Generator_RowEvArgName="Task1RowChangeEvent" msprop:Generator_RowClassName="Task1Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Model" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnPropNameInTable="ModelColumn" msprop:Generator_UserColumnName="Model" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Color" msprop:Generator_ColumnVarNameInTable="columnColor" msprop:Generator_ColumnPropNameInRow="Color" msprop:Generator_ColumnPropNameInTable="ColorColumn" msprop:Generator_UserColumnName="Color" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CarManufactureDate" msprop:Generator_ColumnVarNameInTable="columnCarManufactureDate" msprop:Generator_ColumnPropNameInRow="CarManufactureDate" msprop:Generator_ColumnPropNameInTable="CarManufactureDateColumn" msprop:Generator_UserColumnName="CarManufactureDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="GovermantNumber" msprop:Generator_ColumnVarNameInTable="columnGovermantNumber" msprop:Generator_ColumnPropNameInRow="GovermantNumber" msprop:Generator_ColumnPropNameInTable="GovermantNumberColumn" msprop:Generator_UserColumnName="GovermantNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CarInsuranceCost" msprop:Generator_ColumnVarNameInTable="columnCarInsuranceCost" msprop:Generator_ColumnPropNameInRow="CarInsuranceCost" msprop:Generator_ColumnPropNameInTable="CarInsuranceCostColumn" msprop:Generator_UserColumnName="CarInsuranceCost" type="xs:decimal" minOccurs="0" />
              <xs:element name="OneDayCost" msprop:Generator_ColumnVarNameInTable="columnOneDayCost" msprop:Generator_ColumnPropNameInRow="OneDayCost" msprop:Generator_ColumnPropNameInTable="OneDayCostColumn" msprop:Generator_UserColumnName="OneDayCost" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Task2" msprop:Generator_TableClassName="Task2DataTable" msprop:Generator_TableVarName="tableTask2" msprop:Generator_TablePropName="Task2" msprop:Generator_RowDeletingName="Task2RowDeleting" msprop:Generator_RowChangingName="Task2RowChanging" msprop:Generator_RowEvHandlerName="Task2RowChangeEventHandler" msprop:Generator_RowDeletedName="Task2RowDeleted" msprop:Generator_UserTableName="Task2" msprop:Generator_RowChangedName="Task2RowChanged" msprop:Generator_RowEvArgName="Task2RowChangeEvent" msprop:Generator_RowClassName="Task2Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Model" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnPropNameInTable="ModelColumn" msprop:Generator_UserColumnName="Model" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Color" msprop:Generator_ColumnVarNameInTable="columnColor" msprop:Generator_ColumnPropNameInRow="Color" msprop:Generator_ColumnPropNameInTable="ColorColumn" msprop:Generator_UserColumnName="Color" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CarManufactureDate" msprop:Generator_ColumnVarNameInTable="columnCarManufactureDate" msprop:Generator_ColumnPropNameInRow="CarManufactureDate" msprop:Generator_ColumnPropNameInTable="CarManufactureDateColumn" msprop:Generator_UserColumnName="CarManufactureDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="GovermantNumber" msprop:Generator_ColumnVarNameInTable="columnGovermantNumber" msprop:Generator_ColumnPropNameInRow="GovermantNumber" msprop:Generator_ColumnPropNameInTable="GovermantNumberColumn" msprop:Generator_UserColumnName="GovermantNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CarInsuranceCost" msprop:Generator_ColumnVarNameInTable="columnCarInsuranceCost" msprop:Generator_ColumnPropNameInRow="CarInsuranceCost" msprop:Generator_ColumnPropNameInTable="CarInsuranceCostColumn" msprop:Generator_UserColumnName="CarInsuranceCost" type="xs:decimal" minOccurs="0" />
              <xs:element name="OneDayCost" msprop:Generator_ColumnVarNameInTable="columnOneDayCost" msprop:Generator_ColumnPropNameInRow="OneDayCost" msprop:Generator_ColumnPropNameInTable="OneDayCostColumn" msprop:Generator_UserColumnName="OneDayCost" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Task3" msprop:Generator_TableClassName="Task3DataTable" msprop:Generator_TableVarName="tableTask3" msprop:Generator_TablePropName="Task3" msprop:Generator_RowDeletingName="Task3RowDeleting" msprop:Generator_RowChangingName="Task3RowChanging" msprop:Generator_RowEvHandlerName="Task3RowChangeEventHandler" msprop:Generator_RowDeletedName="Task3RowDeleted" msprop:Generator_UserTableName="Task3" msprop:Generator_RowChangedName="Task3RowChanged" msprop:Generator_RowEvArgName="Task3RowChangeEvent" msprop:Generator_RowClassName="Task3Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_UserColumnName="FIO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Model" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnPropNameInTable="ModelColumn" msprop:Generator_UserColumnName="Model" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GovermantNumber" msprop:Generator_ColumnVarNameInTable="columnGovermantNumber" msprop:Generator_ColumnPropNameInRow="GovermantNumber" msprop:Generator_ColumnPropNameInTable="GovermantNumberColumn" msprop:Generator_UserColumnName="GovermantNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Date_order" msprop:Generator_ColumnVarNameInTable="columnDate_order" msprop:Generator_ColumnPropNameInRow="Date_order" msprop:Generator_ColumnPropNameInTable="Date_orderColumn" msprop:Generator_UserColumnName="Date_order" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Task4" msprop:Generator_TableClassName="Task4DataTable" msprop:Generator_TableVarName="tableTask4" msprop:Generator_TablePropName="Task4" msprop:Generator_RowDeletingName="Task4RowDeleting" msprop:Generator_RowChangingName="Task4RowChanging" msprop:Generator_RowEvHandlerName="Task4RowChangeEventHandler" msprop:Generator_RowDeletedName="Task4RowDeleted" msprop:Generator_UserTableName="Task4" msprop:Generator_RowChangedName="Task4RowChanged" msprop:Generator_RowEvArgName="Task4RowChangeEvent" msprop:Generator_RowClassName="Task4Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="GovermantNumber" msprop:Generator_ColumnVarNameInTable="columnGovermantNumber" msprop:Generator_ColumnPropNameInRow="GovermantNumber" msprop:Generator_ColumnPropNameInTable="GovermantNumberColumn" msprop:Generator_UserColumnName="GovermantNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Model" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnPropNameInTable="ModelColumn" msprop:Generator_UserColumnName="Model" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OneDayCost" msprop:Generator_ColumnVarNameInTable="columnOneDayCost" msprop:Generator_ColumnPropNameInRow="OneDayCost" msprop:Generator_ColumnPropNameInTable="OneDayCostColumn" msprop:Generator_UserColumnName="OneDayCost" type="xs:decimal" minOccurs="0" />
              <xs:element name="OrderTimeDay" msprop:Generator_ColumnVarNameInTable="columnOrderTimeDay" msprop:Generator_ColumnPropNameInRow="OrderTimeDay" msprop:Generator_ColumnPropNameInTable="OrderTimeDayColumn" msprop:Generator_UserColumnName="OrderTimeDay" type="xs:int" minOccurs="0" />
              <xs:element name="Стоимость" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnСтоимость" msprop:Generator_ColumnPropNameInRow="Стоимость" msprop:Generator_ColumnPropNameInTable="СтоимостьColumn" msprop:Generator_UserColumnName="Стоимость" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Task5" msprop:Generator_TableClassName="Task5DataTable" msprop:Generator_TableVarName="tableTask5" msprop:Generator_TablePropName="Task5" msprop:Generator_RowDeletingName="Task5RowDeleting" msprop:Generator_RowChangingName="Task5RowChanging" msprop:Generator_RowEvHandlerName="Task5RowChangeEventHandler" msprop:Generator_RowDeletedName="Task5RowDeleted" msprop:Generator_UserTableName="Task5" msprop:Generator_RowChangedName="Task5RowChanged" msprop:Generator_RowEvArgName="Task5RowChangeEvent" msprop:Generator_RowClassName="Task5Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Model" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnPropNameInTable="ModelColumn" msprop:Generator_UserColumnName="Model" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Car" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Client_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Client" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Order__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Order_" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Task1_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Task1" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Task2_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Task2" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Order__Car" msdata:parent="Car" msdata:child="Order_" msdata:parentkey="ID" msdata:childkey="ID_Car" msprop:Generator_UserChildTable="Order_" msprop:Generator_ChildPropName="GetOrder_Rows" msprop:Generator_UserRelationName="FK_Order__Car" msprop:Generator_ParentPropName="CarRow" msprop:Generator_RelationVarName="relationFK_Order__Car" msprop:Generator_UserParentTable="Car" />
      <msdata:Relationship name="FK_Order__Client" msdata:parent="Client" msdata:child="Order_" msdata:parentkey="ID" msdata:childkey="ID_Client" msprop:Generator_UserChildTable="Order_" msprop:Generator_ChildPropName="GetOrder_Rows" msprop:Generator_UserRelationName="FK_Order__Client" msprop:Generator_ParentPropName="ClientRow" msprop:Generator_RelationVarName="relationFK_Order__Client" msprop:Generator_UserParentTable="Client" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>