TechServise/СУБД Техносервис/TechServiceBAUDataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="TechServiceBAUDataSet" targetNamespace="http://tempuri.org/TechServiceBAUDataSet.xsd" xmlns:mstns="http://tempuri.org/TechServiceBAUDataSet.xsd" xmlns="http://tempuri.org/TechServiceBAUDataSet.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="TechServiceBAUConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="TechServiceBAUConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.СУБД_Техносервис.Properties.Settings.GlobalReference.Default.TechServiceBAUConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientTableAdapter" GeneratorDataComponentClassName="ClientTableAdapter" Name="Client" UserDataComponentName="ClientTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TechServiceBAUConnectionString (Settings)" DbObjectName="TechServiceBAU.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 (([IdClient] = @Original_IdClient) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Surname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Patronymic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Client] ([Surname], [Name], [Patronymic]) VALUES (@Surname, @Name, @Patronymic);
SELECT IdClient, Surname, Name, Patronymic FROM Client WHERE (IdClient = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdClient, Surname, Name, Patronymic FROM dbo.Client</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Client] SET [Surname] = @Surname, [Name] = @Name, [Patronymic] = @Patronymic WHERE (([IdClient] = @Original_IdClient) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)));
SELECT IdClient, Surname, Name, Patronymic FROM Client WHERE (IdClient = @IdClient)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Surname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Patronymic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdClient" ColumnName="IdClient" DataSourceName="TechServiceBAU.dbo.Client" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdClient" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdClient" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdClient" DataSetColumn="IdClient" />
              <Mapping SourceColumn="Surname" DataSetColumn="Surname" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Patronymic" DataSetColumn="Patronymic" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmployeeTableAdapter" GeneratorDataComponentClassName="EmployeeTableAdapter" Name="Employee" UserDataComponentName="EmployeeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TechServiceBAUConnectionString (Settings)" DbObjectName="TechServiceBAU.dbo.Employee" 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].[Employee] WHERE (([IdEmployee] = @Original_IdEmployee) AND ((@IsNull_IdRole = 1 AND [IdRole] IS NULL) OR ([IdRole] = @Original_IdRole)) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdEmployee" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdEmployee" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRole" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Surname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Patronymic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Photo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Employee] ([IdRole], [Surname], [Name], [Patronymic], [Login], [Password], [Photo]) VALUES (@IdRole, @Surname, @Name, @Patronymic, @Login, @Password, @Photo);
SELECT IdEmployee, IdRole, Surname, Name, Patronymic, Login, Password, Photo FROM Employee WHERE (IdEmployee = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdEmployee, IdRole, Surname, Name, Patronymic, Login, Password, Photo FROM dbo.Employee</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Employee] SET [IdRole] = @IdRole, [Surname] = @Surname, [Name] = @Name, [Patronymic] = @Patronymic, [Login] = @Login, [Password] = @Password, [Photo] = @Photo WHERE (([IdEmployee] = @Original_IdEmployee) AND ((@IsNull_IdRole = 1 AND [IdRole] IS NULL) OR ([IdRole] = @Original_IdRole)) AND ((@IsNull_Surname = 1 AND [Surname] IS NULL) OR ([Surname] = @Original_Surname)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) AND ((@IsNull_Photo = 1 AND [Photo] IS NULL) OR ([Photo] = @Original_Photo)));
SELECT IdEmployee, IdRole, Surname, Name, Patronymic, Login, Password, Photo FROM Employee WHERE (IdEmployee = @IdEmployee)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdEmployee" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdEmployee" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRole" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Surname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Surname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Surname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Patronymic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Patronymic" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Patronymic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Login" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Photo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Photo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdEmployee" ColumnName="IdEmployee" DataSourceName="TechServiceBAU.dbo.Employee" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdEmployee" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdEmployee" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdEmployee" DataSetColumn="IdEmployee" />
              <Mapping SourceColumn="IdRole" DataSetColumn="IdRole" />
              <Mapping SourceColumn="Surname" DataSetColumn="Surname" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Patronymic" DataSetColumn="Patronymic" />
              <Mapping SourceColumn="Login" DataSetColumn="Login" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="Photo" DataSetColumn="Photo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ExecutionRequestTableAdapter" GeneratorDataComponentClassName="ExecutionRequestTableAdapter" Name="ExecutionRequest" UserDataComponentName="ExecutionRequestTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TechServiceBAUConnectionString (Settings)" DbObjectName="TechServiceBAU.dbo.ExecutionRequest" 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].[ExecutionRequest] WHERE (([IdExecution] = @Original_IdExecution) AND ((@IsNull_IdRequest = 1 AND [IdRequest] IS NULL) OR ([IdRequest] = @Original_IdRequest)) AND ((@IsNull_IdMaster = 1 AND [IdMaster] IS NULL) OR ([IdMaster] = @Original_IdMaster)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdExecution" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdExecution" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRequest" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRequest" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdMaster" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdMaster" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdMaster" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdMaster" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ExecutionRequest] ([IdRequest], [IdMaster]) VALUES (@IdRequest, @IdMaster);
SELECT IdExecution, IdRequest, IdMaster FROM ExecutionRequest WHERE (IdExecution = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRequest" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdMaster" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdMaster" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdExecution, IdRequest, IdMaster FROM dbo.ExecutionRequest</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ExecutionRequest] SET [IdRequest] = @IdRequest, [IdMaster] = @IdMaster WHERE (([IdExecution] = @Original_IdExecution) AND ((@IsNull_IdRequest = 1 AND [IdRequest] IS NULL) OR ([IdRequest] = @Original_IdRequest)) AND ((@IsNull_IdMaster = 1 AND [IdMaster] IS NULL) OR ([IdMaster] = @Original_IdMaster)));
SELECT IdExecution, IdRequest, IdMaster FROM ExecutionRequest WHERE (IdExecution = @IdExecution)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRequest" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdMaster" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdMaster" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdExecution" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdExecution" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRequest" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRequest" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdMaster" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdMaster" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdMaster" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdMaster" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdExecution" ColumnName="IdExecution" DataSourceName="TechServiceBAU.dbo.ExecutionRequest" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdExecution" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdExecution" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdExecution" DataSetColumn="IdExecution" />
              <Mapping SourceColumn="IdRequest" DataSetColumn="IdRequest" />
              <Mapping SourceColumn="IdMaster" DataSetColumn="IdMaster" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RequestTableAdapter" GeneratorDataComponentClassName="RequestTableAdapter" Name="Request" UserDataComponentName="RequestTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TechServiceBAUConnectionString (Settings)" DbObjectName="TechServiceBAU.dbo.Request" 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].[Request] WHERE (([IdRequest] = @Original_IdRequest) AND ((@IsNull_IdStatus = 1 AND [IdStatus] IS NULL) OR ([IdStatus] = @Original_IdStatus)) AND ((@IsNull_IdTypeDefect = 1 AND [IdTypeDefect] IS NULL) OR ([IdTypeDefect] = @Original_IdTypeDefect)) AND ((@IsNull_IdClient = 1 AND [IdClient] IS NULL) OR ([IdClient] = @Original_IdClient)) AND ((@IsNull_IdManager = 1 AND [IdManager] IS NULL) OR ([IdManager] = @Original_IdManager)) AND ((@IsNull_DateAccepting = 1 AND [DateAccepting] IS NULL) OR ([DateAccepting] = @Original_DateAccepting)) AND ((@IsNull_DateCompletion = 1 AND [DateCompletion] IS NULL) OR ([DateCompletion] = @Original_DateCompletion)) AND ((@IsNull_EquipmentDefect = 1 AND [EquipmentDefect] IS NULL) OR ([EquipmentDefect] = @Original_EquipmentDefect)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRequest" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdTypeDefect" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTypeDefect" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTypeDefect" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTypeDefect" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdManager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdManager" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdManager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdManager" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateAccepting" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateAccepting" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DateAccepting" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateAccepting" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateCompletion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateCompletion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DateCompletion" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateCompletion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipmentDefect" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipmentDefect" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EquipmentDefect" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EquipmentDefect" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Request] ([IdStatus], [IdTypeDefect], [IdClient], [IdManager], [DateAccepting], [DateCompletion], [EquipmentDefect], [Description], [Comment]) VALUES (@IdStatus, @IdTypeDefect, @IdClient, @IdManager, @DateAccepting, @DateCompletion, @EquipmentDefect, @Description, @Comment);
SELECT IdRequest, IdStatus, IdTypeDefect, IdClient, IdManager, DateAccepting, DateCompletion, EquipmentDefect, Description, Comment FROM Request WHERE (IdRequest = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTypeDefect" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTypeDefect" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdManager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdManager" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateAccepting" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateAccepting" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateCompletion" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateCompletion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EquipmentDefect" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EquipmentDefect" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdRequest, IdStatus, IdTypeDefect, IdClient, IdManager, DateAccepting, DateCompletion, EquipmentDefect, Description, Comment FROM dbo.Request</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Request] SET [IdStatus] = @IdStatus, [IdTypeDefect] = @IdTypeDefect, [IdClient] = @IdClient, [IdManager] = @IdManager, [DateAccepting] = @DateAccepting, [DateCompletion] = @DateCompletion, [EquipmentDefect] = @EquipmentDefect, [Description] = @Description, [Comment] = @Comment WHERE (([IdRequest] = @Original_IdRequest) AND ((@IsNull_IdStatus = 1 AND [IdStatus] IS NULL) OR ([IdStatus] = @Original_IdStatus)) AND ((@IsNull_IdTypeDefect = 1 AND [IdTypeDefect] IS NULL) OR ([IdTypeDefect] = @Original_IdTypeDefect)) AND ((@IsNull_IdClient = 1 AND [IdClient] IS NULL) OR ([IdClient] = @Original_IdClient)) AND ((@IsNull_IdManager = 1 AND [IdManager] IS NULL) OR ([IdManager] = @Original_IdManager)) AND ((@IsNull_DateAccepting = 1 AND [DateAccepting] IS NULL) OR ([DateAccepting] = @Original_DateAccepting)) AND ((@IsNull_DateCompletion = 1 AND [DateCompletion] IS NULL) OR ([DateCompletion] = @Original_DateCompletion)) AND ((@IsNull_EquipmentDefect = 1 AND [EquipmentDefect] IS NULL) OR ([EquipmentDefect] = @Original_EquipmentDefect)));
SELECT IdRequest, IdStatus, IdTypeDefect, IdClient, IdManager, DateAccepting, DateCompletion, EquipmentDefect, Description, Comment FROM Request WHERE (IdRequest = @IdRequest)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTypeDefect" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTypeDefect" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdManager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdManager" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateAccepting" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateAccepting" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DateCompletion" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateCompletion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EquipmentDefect" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EquipmentDefect" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRequest" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdTypeDefect" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTypeDefect" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTypeDefect" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTypeDefect" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IdManager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdManager" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdManager" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdManager" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateAccepting" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateAccepting" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DateAccepting" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateAccepting" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateCompletion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateCompletion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DateCompletion" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateCompletion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EquipmentDefect" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EquipmentDefect" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EquipmentDefect" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EquipmentDefect" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdRequest" ColumnName="IdRequest" DataSourceName="TechServiceBAU.dbo.Request" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdRequest" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdRequest" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdRequest" DataSetColumn="IdRequest" />
              <Mapping SourceColumn="IdStatus" DataSetColumn="IdStatus" />
              <Mapping SourceColumn="IdTypeDefect" DataSetColumn="IdTypeDefect" />
              <Mapping SourceColumn="IdClient" DataSetColumn="IdClient" />
              <Mapping SourceColumn="IdManager" DataSetColumn="IdManager" />
              <Mapping SourceColumn="DateAccepting" DataSetColumn="DateAccepting" />
              <Mapping SourceColumn="DateCompletion" DataSetColumn="DateCompletion" />
              <Mapping SourceColumn="EquipmentDefect" DataSetColumn="EquipmentDefect" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoleTableAdapter" GeneratorDataComponentClassName="RoleTableAdapter" Name="Role" UserDataComponentName="RoleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TechServiceBAUConnectionString (Settings)" DbObjectName="TechServiceBAU.dbo.Role" 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].[Role] WHERE (([IdRole] = @Original_IdRole) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Role] ([Title]) VALUES (@Title);
SELECT IdRole, Title FROM Role WHERE (IdRole = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdRole, Title FROM dbo.Role</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Role] SET [Title] = @Title WHERE (([IdRole] = @Original_IdRole) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)));
SELECT IdRole, Title FROM Role WHERE (IdRole = @IdRole)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdRole" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdRole" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdRole" ColumnName="IdRole" DataSourceName="TechServiceBAU.dbo.Role" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdRole" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdRole" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdRole" DataSetColumn="IdRole" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StatusTableAdapter" GeneratorDataComponentClassName="StatusTableAdapter" Name="Status" UserDataComponentName="StatusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TechServiceBAUConnectionString (Settings)" DbObjectName="TechServiceBAU.dbo.Status" 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].[Status] WHERE (([IdStatus] = @Original_IdStatus) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Status] ([Title]) VALUES (@Title);
SELECT IdStatus, Title FROM Status WHERE (IdStatus = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdStatus, Title FROM dbo.Status</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Status] SET [Title] = @Title WHERE (([IdStatus] = @Original_IdStatus) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)));
SELECT IdStatus, Title FROM Status WHERE (IdStatus = @IdStatus)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdStatus" ColumnName="IdStatus" DataSourceName="TechServiceBAU.dbo.Status" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdStatus" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdStatus" DataSetColumn="IdStatus" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TypeDefectTableAdapter" GeneratorDataComponentClassName="TypeDefectTableAdapter" Name="TypeDefect" UserDataComponentName="TypeDefectTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TechServiceBAUConnectionString (Settings)" DbObjectName="TechServiceBAU.dbo.TypeDefect" 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].[TypeDefect] WHERE (([IdTypeDefect] = @Original_IdTypeDefect) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTypeDefect" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTypeDefect" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TypeDefect] ([Title]) VALUES (@Title);
SELECT IdTypeDefect, Title FROM TypeDefect WHERE (IdTypeDefect = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdTypeDefect, Title FROM dbo.TypeDefect</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TypeDefect] SET [Title] = @Title WHERE (([IdTypeDefect] = @Original_IdTypeDefect) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)));
SELECT IdTypeDefect, Title FROM TypeDefect WHERE (IdTypeDefect = @IdTypeDefect)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTypeDefect" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTypeDefect" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdTypeDefect" ColumnName="IdTypeDefect" DataSourceName="TechServiceBAU.dbo.TypeDefect" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdTypeDefect" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdTypeDefect" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdTypeDefect" DataSetColumn="IdTypeDefect" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AllTypeDefectTableAdapter" GeneratorDataComponentClassName="AllTypeDefectTableAdapter" Name="AllTypeDefect" UserDataComponentName="AllTypeDefectTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TechServiceBAUConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>Select 'Все заявки'
union all
Select Title
From TypeDefect</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Column1" DataSetColumn="TypeDefect" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientFIOTableAdapter" GeneratorDataComponentClassName="ClientFIOTableAdapter" Name="ClientFIO" UserDataComponentName="ClientFIOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TechServiceBAUConnectionString (Settings)" DbObjectName="TechServiceBAU.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 [Client] WHERE (([IdClient] = @Original_IdClient))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdClient" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdClient" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Client] DEFAULT VALUES;
SELECT IdClient, Surname + ' ' + Name + ' ' + Patronymic AS FIO FROM Client WHERE (IdClient = SCOPE_IDENTITY())</CommandText>
                    <Parameters />
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IdClient, (Surname + ' ' + Name + ' ' + Patronymic) as FIO
FROM            Client</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdClient" DataSetColumn="IdClient" />
              <Mapping SourceColumn="FIO" DataSetColumn="FIO" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="TechServiceBAUDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="TechServiceBAUDataSet" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="TechServiceBAUDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Client" msprop:Generator_RowEvHandlerName="ClientRowChangeEventHandler" msprop:Generator_RowDeletedName="ClientRowDeleted" msprop:Generator_RowDeletingName="ClientRowDeleting" msprop:Generator_RowEvArgName="ClientRowChangeEvent" msprop:Generator_TablePropName="Client" msprop:Generator_RowChangedName="ClientRowChanged" msprop:Generator_UserTableName="Client" msprop:Generator_RowChangingName="ClientRowChanging" msprop:Generator_RowClassName="ClientRow" msprop:Generator_TableClassName="ClientDataTable" msprop:Generator_TableVarName="tableClient">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdClient" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="IdClientColumn" msprop:Generator_ColumnPropNameInRow="IdClient" msprop:Generator_UserColumnName="IdClient" msprop:Generator_ColumnVarNameInTable="columnIdClient" type="xs:int" />
              <xs:element name="Surname" msprop:Generator_ColumnPropNameInTable="SurnameColumn" msprop:Generator_ColumnPropNameInRow="Surname" msprop:Generator_UserColumnName="Surname" msprop:Generator_ColumnVarNameInTable="columnSurname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Patronymic" msprop:Generator_ColumnPropNameInTable="PatronymicColumn" msprop:Generator_ColumnPropNameInRow="Patronymic" msprop:Generator_UserColumnName="Patronymic" msprop:Generator_ColumnVarNameInTable="columnPatronymic" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Employee" msprop:Generator_RowEvHandlerName="EmployeeRowChangeEventHandler" msprop:Generator_RowDeletedName="EmployeeRowDeleted" msprop:Generator_RowDeletingName="EmployeeRowDeleting" msprop:Generator_RowEvArgName="EmployeeRowChangeEvent" msprop:Generator_TablePropName="Employee" msprop:Generator_RowChangedName="EmployeeRowChanged" msprop:Generator_UserTableName="Employee" msprop:Generator_RowChangingName="EmployeeRowChanging" msprop:Generator_RowClassName="EmployeeRow" msprop:Generator_TableClassName="EmployeeDataTable" msprop:Generator_TableVarName="tableEmployee">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdEmployee" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="IdEmployeeColumn" msprop:Generator_ColumnPropNameInRow="IdEmployee" msprop:Generator_UserColumnName="IdEmployee" msprop:Generator_ColumnVarNameInTable="columnIdEmployee" type="xs:int" />
              <xs:element name="IdRole" msprop:Generator_ColumnPropNameInTable="IdRoleColumn" msprop:Generator_ColumnPropNameInRow="IdRole" msprop:Generator_UserColumnName="IdRole" msprop:Generator_ColumnVarNameInTable="columnIdRole" type="xs:int" minOccurs="0" />
              <xs:element name="Surname" msprop:Generator_ColumnPropNameInTable="SurnameColumn" msprop:Generator_ColumnPropNameInRow="Surname" msprop:Generator_UserColumnName="Surname" msprop:Generator_ColumnVarNameInTable="columnSurname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Patronymic" msprop:Generator_ColumnPropNameInTable="PatronymicColumn" msprop:Generator_ColumnPropNameInRow="Patronymic" msprop:Generator_UserColumnName="Patronymic" msprop:Generator_ColumnVarNameInTable="columnPatronymic" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Login" msprop:Generator_ColumnPropNameInTable="LoginColumn" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_UserColumnName="Login" msprop:Generator_ColumnVarNameInTable="columnLogin" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_UserColumnName="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Photo" msprop:Generator_ColumnPropNameInTable="PhotoColumn" msprop:Generator_ColumnPropNameInRow="Photo" msprop:Generator_UserColumnName="Photo" msprop:Generator_ColumnVarNameInTable="columnPhoto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ExecutionRequest" msprop:Generator_RowEvHandlerName="ExecutionRequestRowChangeEventHandler" msprop:Generator_RowDeletedName="ExecutionRequestRowDeleted" msprop:Generator_RowDeletingName="ExecutionRequestRowDeleting" msprop:Generator_RowEvArgName="ExecutionRequestRowChangeEvent" msprop:Generator_TablePropName="ExecutionRequest" msprop:Generator_RowChangedName="ExecutionRequestRowChanged" msprop:Generator_UserTableName="ExecutionRequest" msprop:Generator_RowChangingName="ExecutionRequestRowChanging" msprop:Generator_RowClassName="ExecutionRequestRow" msprop:Generator_TableClassName="ExecutionRequestDataTable" msprop:Generator_TableVarName="tableExecutionRequest">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdExecution" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="IdExecutionColumn" msprop:Generator_ColumnPropNameInRow="IdExecution" msprop:Generator_UserColumnName="IdExecution" msprop:Generator_ColumnVarNameInTable="columnIdExecution" type="xs:int" />
              <xs:element name="IdRequest" msprop:Generator_ColumnPropNameInTable="IdRequestColumn" msprop:Generator_ColumnPropNameInRow="IdRequest" msprop:Generator_UserColumnName="IdRequest" msprop:Generator_ColumnVarNameInTable="columnIdRequest" type="xs:int" minOccurs="0" />
              <xs:element name="IdMaster" msprop:Generator_ColumnPropNameInTable="IdMasterColumn" msprop:Generator_ColumnPropNameInRow="IdMaster" msprop:Generator_UserColumnName="IdMaster" msprop:Generator_ColumnVarNameInTable="columnIdMaster" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Request" msprop:Generator_RowEvHandlerName="RequestRowChangeEventHandler" msprop:Generator_RowDeletedName="RequestRowDeleted" msprop:Generator_RowDeletingName="RequestRowDeleting" msprop:Generator_RowEvArgName="RequestRowChangeEvent" msprop:Generator_TablePropName="Request" msprop:Generator_RowChangedName="RequestRowChanged" msprop:Generator_UserTableName="Request" msprop:Generator_RowChangingName="RequestRowChanging" msprop:Generator_RowClassName="RequestRow" msprop:Generator_TableClassName="RequestDataTable" msprop:Generator_TableVarName="tableRequest">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdRequest" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_ColumnPropNameInTable="IdRequestColumn" msprop:Generator_ColumnPropNameInRow="IdRequest" msprop:Generator_UserColumnName="IdRequest" msprop:Generator_ColumnVarNameInTable="columnIdRequest" type="xs:int" />
              <xs:element name="IdStatus" msprop:Generator_ColumnPropNameInTable="IdStatusColumn" msprop:Generator_ColumnPropNameInRow="IdStatus" msprop:Generator_UserColumnName="IdStatus" msprop:Generator_ColumnVarNameInTable="columnIdStatus" type="xs:int" minOccurs="0" />
              <xs:element name="IdTypeDefect" msprop:Generator_ColumnPropNameInTable="IdTypeDefectColumn" msprop:Generator_ColumnPropNameInRow="IdTypeDefect" msprop:Generator_UserColumnName="IdTypeDefect" msprop:Generator_ColumnVarNameInTable="columnIdTypeDefect" type="xs:int" minOccurs="0" />
              <xs:element name="IdClient" msprop:Generator_ColumnPropNameInTable="IdClientColumn" msprop:Generator_ColumnPropNameInRow="IdClient" msprop:Generator_UserColumnName="IdClient" msprop:Generator_ColumnVarNameInTable="columnIdClient" type="xs:int" minOccurs="0" />
              <xs:element name="IdManager" msprop:Generator_ColumnPropNameInTable="IdManagerColumn" msprop:Generator_ColumnPropNameInRow="IdManager" msprop:Generator_UserColumnName="IdManager" msprop:Generator_ColumnVarNameInTable="columnIdManager" type="xs:int" minOccurs="0" />
              <xs:element name="DateAccepting" msprop:Generator_ColumnPropNameInTable="DateAcceptingColumn" msprop:Generator_ColumnPropNameInRow="DateAccepting" msprop:Generator_UserColumnName="DateAccepting" msprop:Generator_ColumnVarNameInTable="columnDateAccepting" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DateCompletion" msprop:Generator_ColumnPropNameInTable="DateCompletionColumn" msprop:Generator_ColumnPropNameInRow="DateCompletion" msprop:Generator_UserColumnName="DateCompletion" msprop:Generator_ColumnVarNameInTable="columnDateCompletion" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EquipmentDefect" msprop:Generator_ColumnPropNameInTable="EquipmentDefectColumn" msprop:Generator_ColumnPropNameInRow="EquipmentDefect" msprop:Generator_UserColumnName="EquipmentDefect" msprop:Generator_ColumnVarNameInTable="columnEquipmentDefect" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_UserColumnName="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Role" msprop:Generator_RowEvHandlerName="RoleRowChangeEventHandler" msprop:Generator_RowDeletedName="RoleRowDeleted" msprop:Generator_RowDeletingName="RoleRowDeleting" msprop:Generator_RowEvArgName="RoleRowChangeEvent" msprop:Generator_TablePropName="Role" msprop:Generator_RowChangedName="RoleRowChanged" msprop:Generator_UserTableName="Role" msprop:Generator_RowChangingName="RoleRowChanging" msprop:Generator_RowClassName="RoleRow" msprop:Generator_TableClassName="RoleDataTable" msprop:Generator_TableVarName="tableRole">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdRole" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="IdRoleColumn" msprop:Generator_ColumnPropNameInRow="IdRole" msprop:Generator_UserColumnName="IdRole" msprop:Generator_ColumnVarNameInTable="columnIdRole" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Status" msprop:Generator_RowEvHandlerName="StatusRowChangeEventHandler" msprop:Generator_RowDeletedName="StatusRowDeleted" msprop:Generator_RowDeletingName="StatusRowDeleting" msprop:Generator_RowEvArgName="StatusRowChangeEvent" msprop:Generator_TablePropName="Status" msprop:Generator_RowChangedName="StatusRowChanged" msprop:Generator_UserTableName="Status" msprop:Generator_RowChangingName="StatusRowChanging" msprop:Generator_RowClassName="StatusRow" msprop:Generator_TableClassName="StatusDataTable" msprop:Generator_TableVarName="tableStatus">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdStatus" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="IdStatusColumn" msprop:Generator_ColumnPropNameInRow="IdStatus" msprop:Generator_UserColumnName="IdStatus" msprop:Generator_ColumnVarNameInTable="columnIdStatus" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TypeDefect" msprop:Generator_RowEvHandlerName="TypeDefectRowChangeEventHandler" msprop:Generator_RowDeletedName="TypeDefectRowDeleted" msprop:Generator_RowDeletingName="TypeDefectRowDeleting" msprop:Generator_RowEvArgName="TypeDefectRowChangeEvent" msprop:Generator_TablePropName="TypeDefect" msprop:Generator_RowChangedName="TypeDefectRowChanged" msprop:Generator_UserTableName="TypeDefect" msprop:Generator_RowChangingName="TypeDefectRowChanging" msprop:Generator_RowClassName="TypeDefectRow" msprop:Generator_TableClassName="TypeDefectDataTable" msprop:Generator_TableVarName="tableTypeDefect">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdTypeDefect" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="IdTypeDefectColumn" msprop:Generator_ColumnPropNameInRow="IdTypeDefect" msprop:Generator_UserColumnName="IdTypeDefect" msprop:Generator_ColumnVarNameInTable="columnIdTypeDefect" type="xs:int" />
              <xs:element name="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="AllTypeDefect" msprop:Generator_RowEvHandlerName="AllTypeDefectRowChangeEventHandler" msprop:Generator_RowDeletedName="AllTypeDefectRowDeleted" msprop:Generator_RowDeletingName="AllTypeDefectRowDeleting" msprop:Generator_RowEvArgName="AllTypeDefectRowChangeEvent" msprop:Generator_TablePropName="AllTypeDefect" msprop:Generator_RowChangedName="AllTypeDefectRowChanged" msprop:Generator_UserTableName="AllTypeDefect" msprop:Generator_RowChangingName="AllTypeDefectRowChanging" msprop:Generator_RowClassName="AllTypeDefectRow" msprop:Generator_TableClassName="AllTypeDefectDataTable" msprop:Generator_TableVarName="tableAllTypeDefect">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TypeDefect" msdata:ReadOnly="true" msdata:Caption="Column1" msprop:Generator_ColumnPropNameInTable="TypeDefectColumn" msprop:Generator_ColumnPropNameInRow="TypeDefect" msprop:Generator_UserColumnName="TypeDefect" msprop:Generator_ColumnVarNameInTable="columnTypeDefect" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ClientFIO" msprop:Generator_RowEvHandlerName="ClientFIORowChangeEventHandler" msprop:Generator_RowDeletedName="ClientFIORowDeleted" msprop:Generator_RowDeletingName="ClientFIORowDeleting" msprop:Generator_RowEvArgName="ClientFIORowChangeEvent" msprop:Generator_TablePropName="ClientFIO" msprop:Generator_RowChangedName="ClientFIORowChanged" msprop:Generator_RowChangingName="ClientFIORowChanging" msprop:Generator_TableClassName="ClientFIODataTable" msprop:Generator_RowClassName="ClientFIORow" msprop:Generator_TableVarName="tableClientFIO" msprop:Generator_UserTableName="ClientFIO">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdClient" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="IdClient" msprop:Generator_ColumnPropNameInTable="IdClientColumn" msprop:Generator_ColumnVarNameInTable="columnIdClient" msprop:Generator_UserColumnName="IdClient" type="xs:int" />
              <xs:element name="FIO" msdata:ReadOnly="true" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_ColumnVarNameInTable="columnFIO" msprop:Generator_UserColumnName="FIO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="152" />
                  </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:Client" />
      <xs:field xpath="mstns:IdClient" />
    </xs:unique>
    <xs:unique name="Employee_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Employee" />
      <xs:field xpath="mstns:IdEmployee" />
    </xs:unique>
    <xs:unique name="ExecutionRequest_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ExecutionRequest" />
      <xs:field xpath="mstns:IdExecution" />
    </xs:unique>
    <xs:unique name="Request_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Request" />
      <xs:field xpath="mstns:IdRequest" />
    </xs:unique>
    <xs:unique name="Role_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Role" />
      <xs:field xpath="mstns:IdRole" />
    </xs:unique>
    <xs:unique name="Status_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Status" />
      <xs:field xpath="mstns:IdStatus" />
    </xs:unique>
    <xs:unique name="TypeDefect_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TypeDefect" />
      <xs:field xpath="mstns:IdTypeDefect" />
    </xs:unique>
    <xs:unique name="ClientFIO_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ClientFIO" />
      <xs:field xpath="mstns:IdClient" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Employee_Role" msdata:parent="Role" msdata:child="Employee" msdata:parentkey="IdRole" msdata:childkey="IdRole" msprop:Generator_UserParentTable="Role" msprop:Generator_UserChildTable="Employee" msprop:Generator_RelationVarName="relationFK_Employee_Role" msprop:Generator_ChildPropName="GetEmployeeRows" msprop:Generator_ParentPropName="RoleRow" msprop:Generator_UserRelationName="FK_Employee_Role" />
      <msdata:Relationship name="FK_ExecutionRequest_Employee" msdata:parent="Employee" msdata:child="ExecutionRequest" msdata:parentkey="IdEmployee" msdata:childkey="IdMaster" msprop:Generator_UserParentTable="Employee" msprop:Generator_UserChildTable="ExecutionRequest" msprop:Generator_RelationVarName="relationFK_ExecutionRequest_Employee" msprop:Generator_ChildPropName="GetExecutionRequestRows" msprop:Generator_UserRelationName="FK_ExecutionRequest_Employee" msprop:Generator_ParentPropName="EmployeeRow" />
      <msdata:Relationship name="FK_ExecutionRequest_Request" msdata:parent="Request" msdata:child="ExecutionRequest" msdata:parentkey="IdRequest" msdata:childkey="IdRequest" msprop:Generator_UserParentTable="Request" msprop:Generator_UserChildTable="ExecutionRequest" msprop:Generator_RelationVarName="relationFK_ExecutionRequest_Request" msprop:Generator_ChildPropName="GetExecutionRequestRows" msprop:Generator_ParentPropName="RequestRow" msprop:Generator_UserRelationName="FK_ExecutionRequest_Request" />
      <msdata:Relationship name="FK_Request_Client" msdata:parent="Client" msdata:child="Request" msdata:parentkey="IdClient" msdata:childkey="IdClient" msprop:Generator_UserParentTable="Client" msprop:Generator_UserChildTable="Request" msprop:Generator_RelationVarName="relationFK_Request_Client" msprop:Generator_ChildPropName="GetRequestRows" msprop:Generator_UserRelationName="FK_Request_Client" msprop:Generator_ParentPropName="ClientRow" />
      <msdata:Relationship name="FK_Request_Employee" msdata:parent="Employee" msdata:child="Request" msdata:parentkey="IdEmployee" msdata:childkey="IdManager" msprop:Generator_UserParentTable="Employee" msprop:Generator_UserChildTable="Request" msprop:Generator_RelationVarName="relationFK_Request_Employee" msprop:Generator_ChildPropName="GetRequestRows" msprop:Generator_UserRelationName="FK_Request_Employee" msprop:Generator_ParentPropName="EmployeeRow" />
      <msdata:Relationship name="FK_Request_Status" msdata:parent="Status" msdata:child="Request" msdata:parentkey="IdStatus" msdata:childkey="IdStatus" msprop:Generator_UserParentTable="Status" msprop:Generator_UserChildTable="Request" msprop:Generator_RelationVarName="relationFK_Request_Status" msprop:Generator_ChildPropName="GetRequestRows" msprop:Generator_ParentPropName="StatusRow" msprop:Generator_UserRelationName="FK_Request_Status" />
      <msdata:Relationship name="FK_Request_TypeDefect" msdata:parent="TypeDefect" msdata:child="Request" msdata:parentkey="IdTypeDefect" msdata:childkey="IdTypeDefect" msprop:Generator_UserParentTable="TypeDefect" msprop:Generator_UserChildTable="Request" msprop:Generator_RelationVarName="relationFK_Request_TypeDefect" msprop:Generator_ChildPropName="GetRequestRows" msprop:Generator_ParentPropName="TypeDefectRow" msprop:Generator_UserRelationName="FK_Request_TypeDefect" />
      <msdata:Relationship name="FK_Request_Client1" msdata:parent="ClientFIO" msdata:child="Request" msdata:parentkey="IdClient" msdata:childkey="IdClient" msprop:Generator_UserParentTable="ClientFIO" msprop:Generator_UserChildTable="Request" msprop:Generator_RelationVarName="relationFK_Request_Client1" msprop:Generator_UserRelationName="FK_Request_Client1" msprop:Generator_ChildPropName="GetRequestRows" msprop:Generator_ParentPropName="ClientFIORow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>