Dipl/ImpulseVision/ImpulseVisionAppDataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ImpulseVisionAppDataSet" targetNamespace="http://tempuri.org/ImpulseVisionAppDataSet.xsd" xmlns:mstns="http://tempuri.org/ImpulseVisionAppDataSet.xsd" xmlns="http://tempuri.org/ImpulseVisionAppDataSet.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="ImpulseVisionAppConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ImpulseVisionAppConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ImpulseVision.Properties.Settings.GlobalReference.Default.ImpulseVisionAppConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FaceImagesTableAdapter" GeneratorDataComponentClassName="FaceImagesTableAdapter" Name="FaceImages" UserDataComponentName="FaceImagesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ImpulseVisionAppConnectionString (Settings)" DbObjectName="ImpulseVisionApp.dbo.FaceImages" 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].[FaceImages] WHERE (([ID] = @Original_ID) AND ([UserID] = @Original_UserID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[FaceImages] ([ID], [UserID], [Picture]) VALUES (@ID, @UserID, @Picture);
SELECT ID, UserID, Picture FROM FaceImages WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Picture" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Picture" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, UserID, Picture FROM dbo.FaceImages</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[FaceImages] SET [ID] = @ID, [UserID] = @UserID, [Picture] = @Picture WHERE (([ID] = @Original_ID) AND ([UserID] = @Original_UserID));
SELECT ID, UserID, Picture FROM FaceImages WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Picture" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Picture" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="Picture" DataSetColumn="Picture" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HistoryLoginTableAdapter" GeneratorDataComponentClassName="HistoryLoginTableAdapter" Name="HistoryLogin" UserDataComponentName="HistoryLoginTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ImpulseVisionAppConnectionString (Settings)" DbObjectName="ImpulseVisionApp.dbo.HistoryLogin" 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].[HistoryLogin] WHERE (([ID] = @Original_ID) AND ([StaffsID] = @Original_StaffsID) AND ([TimeLogin] = @Original_TimeLogin))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StaffsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StaffsID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TimeLogin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeLogin" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[HistoryLogin] ([StaffsID], [TimeLogin]) VALUES (@StaffsID, @TimeLogin);
SELECT ID, StaffsID, TimeLogin FROM HistoryLogin WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StaffsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StaffsID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TimeLogin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeLogin" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, StaffsID, TimeLogin FROM dbo.HistoryLogin</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[HistoryLogin] SET [StaffsID] = @StaffsID, [TimeLogin] = @TimeLogin WHERE (([ID] = @Original_ID) AND ([StaffsID] = @Original_StaffsID) AND ([TimeLogin] = @Original_TimeLogin));
SELECT ID, StaffsID, TimeLogin FROM HistoryLogin WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StaffsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StaffsID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TimeLogin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeLogin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StaffsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StaffsID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TimeLogin" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeLogin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="ImpulseVisionApp.dbo.HistoryLogin" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="StaffsID" DataSetColumn="StaffsID" />
              <Mapping SourceColumn="TimeLogin" DataSetColumn="TimeLogin" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StaffsTableAdapter" GeneratorDataComponentClassName="StaffsTableAdapter" Name="Staffs" UserDataComponentName="StaffsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ImpulseVisionAppConnectionString (Settings)" DbObjectName="ImpulseVisionApp.dbo.Staffs" 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].[Staffs] WHERE (([ID] = @Original_ID) AND ([Lastname] = @Original_Lastname) AND ([Firstname] = @Original_Firstname) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ([PassportSeria] = @Original_PassportSeria) AND ([PassportNum] = @Original_PassportNum) AND ([Login] = @Original_Login) AND ([Password] = @Original_Password) AND ([IDStaffsType] = @Original_IDStaffsType))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Lastname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Lastname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Firstname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Firstname" 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="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PassportSeria" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportSeria" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PassportNum" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDStaffsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDStaffsType" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Staffs] ([Lastname], [Firstname], [Patronymic], [PassportSeria], [PassportNum], [Login], [Password], [IDStaffsType]) VALUES (@Lastname, @Firstname, @Patronymic, @PassportSeria, @PassportNum, @Login, @Password, @IDStaffsType);
SELECT ID, Lastname, Firstname, Patronymic, PassportSeria, PassportNum, Login, Password, IDStaffsType FROM Staffs WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Lastname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Lastname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Firstname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Firstname" 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="AnsiStringFixedLength" Direction="Input" ParameterName="@PassportSeria" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportSeria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PassportNum" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDStaffsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDStaffsType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Lastname, Firstname, Patronymic, PassportSeria, PassportNum, Login, Password, IDStaffsType FROM dbo.Staffs</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Staffs] SET [Lastname] = @Lastname, [Firstname] = @Firstname, [Patronymic] = @Patronymic, [PassportSeria] = @PassportSeria, [PassportNum] = @PassportNum, [Login] = @Login, [Password] = @Password, [IDStaffsType] = @IDStaffsType WHERE (([ID] = @Original_ID) AND ([Lastname] = @Original_Lastname) AND ([Firstname] = @Original_Firstname) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ([PassportSeria] = @Original_PassportSeria) AND ([PassportNum] = @Original_PassportNum) AND ([Login] = @Original_Login) AND ([Password] = @Original_Password) AND ([IDStaffsType] = @Original_IDStaffsType));
SELECT ID, Lastname, Firstname, Patronymic, PassportSeria, PassportNum, Login, Password, IDStaffsType FROM Staffs WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Lastname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Lastname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Firstname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Firstname" 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="AnsiStringFixedLength" Direction="Input" ParameterName="@PassportSeria" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportSeria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PassportNum" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDStaffsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDStaffsType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Lastname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Lastname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Firstname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Firstname" 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="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PassportSeria" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportSeria" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PassportNum" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Login" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDStaffsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDStaffsType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="ImpulseVisionApp.dbo.Staffs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Lastname" DataSetColumn="Lastname" />
              <Mapping SourceColumn="Firstname" DataSetColumn="Firstname" />
              <Mapping SourceColumn="Patronymic" DataSetColumn="Patronymic" />
              <Mapping SourceColumn="PassportSeria" DataSetColumn="PassportSeria" />
              <Mapping SourceColumn="PassportNum" DataSetColumn="PassportNum" />
              <Mapping SourceColumn="Login" DataSetColumn="Login" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="IDStaffsType" DataSetColumn="IDStaffsType" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ImpulseVisionAppConnectionString (Settings)" DbObjectName="ImpulseVisionApp.dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Users] WHERE (([ID] = @Original_ID) AND ([Lastname] = @Original_Lastname) AND ([Firstname] = @Original_Firstname) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ([PassportSeria] = @Original_PassportSeria) AND ([PassportNum] = @Original_PassportNum) AND ([Phone] = @Original_Phone) AND ([IDUserType] = @Original_IDUserType))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Lastname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Lastname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Firstname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Firstname" 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="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PassportSeria" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportSeria" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PassportNum" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDUserType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDUserType" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Users] ([Lastname], [Firstname], [Patronymic], [PassportSeria], [PassportNum], [Phone], [IDUserType]) VALUES (@Lastname, @Firstname, @Patronymic, @PassportSeria, @PassportNum, @Phone, @IDUserType);
SELECT ID, Lastname, Firstname, Patronymic, PassportSeria, PassportNum, Phone, IDUserType FROM Users WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Lastname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Lastname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Firstname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Firstname" 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="AnsiStringFixedLength" Direction="Input" ParameterName="@PassportSeria" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportSeria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PassportNum" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDUserType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDUserType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ID, Lastname, Firstname, Patronymic, PassportSeria, PassportNum, Phone, IDUserType
FROM            Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Users] SET [Lastname] = @Lastname, [Firstname] = @Firstname, [Patronymic] = @Patronymic, [PassportSeria] = @PassportSeria, [PassportNum] = @PassportNum, [Phone] = @Phone, [IDUserType] = @IDUserType WHERE (([ID] = @Original_ID) AND ([Lastname] = @Original_Lastname) AND ([Firstname] = @Original_Firstname) AND ((@IsNull_Patronymic = 1 AND [Patronymic] IS NULL) OR ([Patronymic] = @Original_Patronymic)) AND ([PassportSeria] = @Original_PassportSeria) AND ([PassportNum] = @Original_PassportNum) AND ([Phone] = @Original_Phone) AND ([IDUserType] = @Original_IDUserType));
SELECT ID, Lastname, Firstname, Patronymic, PassportSeria, PassportNum, Phone, IDUserType FROM Users WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Lastname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Lastname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Firstname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Firstname" 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="AnsiStringFixedLength" Direction="Input" ParameterName="@PassportSeria" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportSeria" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@PassportNum" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDUserType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDUserType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Lastname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Lastname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Firstname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Firstname" 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="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PassportSeria" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportSeria" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_PassportNum" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="PassportNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDUserType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDUserType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="ImpulseVisionApp.dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Lastname" DataSetColumn="Lastname" />
              <Mapping SourceColumn="Firstname" DataSetColumn="Firstname" />
              <Mapping SourceColumn="Patronymic" DataSetColumn="Patronymic" />
              <Mapping SourceColumn="PassportSeria" DataSetColumn="PassportSeria" />
              <Mapping SourceColumn="PassportNum" DataSetColumn="PassportNum" />
              <Mapping SourceColumn="IDUserType" DataSetColumn="IDUserType" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserTrafficTableAdapter" GeneratorDataComponentClassName="UserTrafficTableAdapter" Name="UserTraffic" UserDataComponentName="UserTrafficTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ImpulseVisionAppConnectionString (Settings)" DbObjectName="ImpulseVisionApp.dbo.UserTraffic" 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].[UserTraffic] WHERE (([ID] = @Original_ID) AND ([UserID] = @Original_UserID) AND ((@IsNull_TimeEntrance = 1 AND [TimeEntrance] IS NULL) OR ([TimeEntrance] = @Original_TimeEntrance)) AND ((@IsNull_TimeExit = 1 AND [TimeExit] IS NULL) OR ([TimeExit] = @Original_TimeExit)) AND ([Identification] = @Original_Identification))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TimeEntrance" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeEntrance" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TimeEntrance" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeEntrance" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TimeExit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeExit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TimeExit" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeExit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Identification" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Identification" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[UserTraffic] ([UserID], [TimeEntrance], [TimeExit], [Identification]) VALUES (@UserID, @TimeEntrance, @TimeExit, @Identification);
SELECT ID, UserID, TimeEntrance, TimeExit, Identification FROM UserTraffic WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TimeEntrance" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeEntrance" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TimeExit" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeExit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Identification" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Identification" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, UserID, TimeEntrance, TimeExit, Identification FROM dbo.UserTraffic</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[UserTraffic] SET [UserID] = @UserID, [TimeEntrance] = @TimeEntrance, [TimeExit] = @TimeExit, [Identification] = @Identification WHERE (([ID] = @Original_ID) AND ([UserID] = @Original_UserID) AND ((@IsNull_TimeEntrance = 1 AND [TimeEntrance] IS NULL) OR ([TimeEntrance] = @Original_TimeEntrance)) AND ((@IsNull_TimeExit = 1 AND [TimeExit] IS NULL) OR ([TimeExit] = @Original_TimeExit)) AND ([Identification] = @Original_Identification));
SELECT ID, UserID, TimeEntrance, TimeExit, Identification FROM UserTraffic WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TimeEntrance" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeEntrance" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TimeExit" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeExit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Identification" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Identification" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TimeEntrance" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeEntrance" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TimeEntrance" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeEntrance" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TimeExit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeExit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TimeExit" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeExit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Identification" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Identification" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="ImpulseVisionApp.dbo.UserTraffic" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="TimeEntrance" DataSetColumn="TimeEntrance" />
              <Mapping SourceColumn="TimeExit" DataSetColumn="TimeExit" />
              <Mapping SourceColumn="Identification" DataSetColumn="Identification" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserTypeTableAdapter" GeneratorDataComponentClassName="UserTypeTableAdapter" Name="UserType" UserDataComponentName="UserTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ImpulseVisionAppConnectionString (Settings)" DbObjectName="ImpulseVisionApp.dbo.UserType" 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].[UserType] WHERE (([ID] = @Original_ID) AND ([UserType] = @Original_UserType))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UserType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[UserType] ([UserType]) VALUES (@UserType);
SELECT ID, UserType FROM UserType WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UserType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, UserType FROM dbo.UserType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[UserType] SET [UserType] = @UserType WHERE (([ID] = @Original_ID) AND ([UserType] = @Original_UserType));
SELECT ID, UserType FROM UserType WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UserType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UserType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="ImpulseVisionApp.dbo.UserType" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="UserType" DataSetColumn="UserType" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ImpulseVisionAppDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ImpulseVisionAppDataSet" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ImpulseVisionAppDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="FaceImages" msprop:Generator_RowEvHandlerName="FaceImagesRowChangeEventHandler" msprop:Generator_RowDeletedName="FaceImagesRowDeleted" msprop:Generator_RowDeletingName="FaceImagesRowDeleting" msprop:Generator_RowEvArgName="FaceImagesRowChangeEvent" msprop:Generator_TablePropName="FaceImages" msprop:Generator_RowChangedName="FaceImagesRowChanged" msprop:Generator_UserTableName="FaceImages" msprop:Generator_RowChangingName="FaceImagesRowChanging" msprop:Generator_RowClassName="FaceImagesRow" msprop:Generator_TableClassName="FaceImagesDataTable" msprop:Generator_TableVarName="tableFaceImages">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" type="xs:int" />
              <xs:element name="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" type="xs:int" />
              <xs:element name="Picture" msprop:Generator_ColumnPropNameInTable="PictureColumn" msprop:Generator_ColumnPropNameInRow="Picture" msprop:Generator_UserColumnName="Picture" msprop:Generator_ColumnVarNameInTable="columnPicture">
                <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="HistoryLogin" msprop:Generator_RowEvHandlerName="HistoryLoginRowChangeEventHandler" msprop:Generator_RowDeletedName="HistoryLoginRowDeleted" msprop:Generator_RowDeletingName="HistoryLoginRowDeleting" msprop:Generator_RowEvArgName="HistoryLoginRowChangeEvent" msprop:Generator_TablePropName="HistoryLogin" msprop:Generator_RowChangedName="HistoryLoginRowChanged" msprop:Generator_UserTableName="HistoryLogin" msprop:Generator_RowChangingName="HistoryLoginRowChanging" msprop:Generator_RowClassName="HistoryLoginRow" msprop:Generator_TableClassName="HistoryLoginDataTable" msprop:Generator_TableVarName="tableHistoryLogin">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" type="xs:int" />
              <xs:element name="StaffsID" msprop:Generator_ColumnPropNameInTable="StaffsIDColumn" msprop:Generator_ColumnPropNameInRow="StaffsID" msprop:Generator_UserColumnName="StaffsID" msprop:Generator_ColumnVarNameInTable="columnStaffsID" type="xs:int" />
              <xs:element name="TimeLogin" msprop:Generator_ColumnPropNameInTable="TimeLoginColumn" msprop:Generator_ColumnPropNameInRow="TimeLogin" msprop:Generator_UserColumnName="TimeLogin" msprop:Generator_ColumnVarNameInTable="columnTimeLogin" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Staffs" msprop:Generator_RowEvHandlerName="StaffsRowChangeEventHandler" msprop:Generator_RowDeletedName="StaffsRowDeleted" msprop:Generator_RowDeletingName="StaffsRowDeleting" msprop:Generator_RowEvArgName="StaffsRowChangeEvent" msprop:Generator_TablePropName="Staffs" msprop:Generator_RowChangedName="StaffsRowChanged" msprop:Generator_UserTableName="Staffs" msprop:Generator_RowChangingName="StaffsRowChanging" msprop:Generator_RowClassName="StaffsRow" msprop:Generator_TableClassName="StaffsDataTable" msprop:Generator_TableVarName="tableStaffs">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" type="xs:int" />
              <xs:element name="Lastname" msprop:Generator_ColumnPropNameInTable="LastnameColumn" msprop:Generator_ColumnPropNameInRow="Lastname" msprop:Generator_UserColumnName="Lastname" msprop:Generator_ColumnVarNameInTable="columnLastname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Firstname" msprop:Generator_ColumnPropNameInTable="FirstnameColumn" msprop:Generator_ColumnPropNameInRow="Firstname" msprop:Generator_UserColumnName="Firstname" msprop:Generator_ColumnVarNameInTable="columnFirstname">
                <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="PassportSeria" msprop:Generator_ColumnPropNameInTable="PassportSeriaColumn" msprop:Generator_ColumnPropNameInRow="PassportSeria" msprop:Generator_UserColumnName="PassportSeria" msprop:Generator_ColumnVarNameInTable="columnPassportSeria">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PassportNum" msprop:Generator_ColumnPropNameInTable="PassportNumColumn" msprop:Generator_ColumnPropNameInRow="PassportNum" msprop:Generator_UserColumnName="PassportNum" msprop:Generator_ColumnVarNameInTable="columnPassportNum">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </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">
                <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">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDStaffsType" msprop:Generator_ColumnPropNameInTable="IDStaffsTypeColumn" msprop:Generator_ColumnPropNameInRow="IDStaffsType" msprop:Generator_UserColumnName="IDStaffsType" msprop:Generator_ColumnVarNameInTable="columnIDStaffsType" type="xs:int" />
              <xs:element name="FIO" msdata:ReadOnly="true" msdata:Expression="Lastname+' '+Firstname+' '+Patronymic" msprop:Generator_UserColumnName="FIO" msprop:Generator_ColumnPropNameInTable="FIOColumn" msprop:Generator_ColumnPropNameInRow="FIO" msprop:Generator_ColumnVarNameInTable="columnFIO" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_TablePropName="Users" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_UserTableName="Users" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowClassName="UsersRow" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" type="xs:int" />
              <xs:element name="Lastname" msprop:Generator_ColumnPropNameInTable="LastnameColumn" msprop:Generator_ColumnPropNameInRow="Lastname" msprop:Generator_UserColumnName="Lastname" msprop:Generator_ColumnVarNameInTable="columnLastname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Firstname" msprop:Generator_ColumnPropNameInTable="FirstnameColumn" msprop:Generator_ColumnPropNameInRow="Firstname" msprop:Generator_UserColumnName="Firstname" msprop:Generator_ColumnVarNameInTable="columnFirstname">
                <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="PassportSeria" msprop:Generator_ColumnPropNameInTable="PassportSeriaColumn" msprop:Generator_ColumnPropNameInRow="PassportSeria" msprop:Generator_UserColumnName="PassportSeria" msprop:Generator_ColumnVarNameInTable="columnPassportSeria">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PassportNum" msprop:Generator_ColumnPropNameInTable="PassportNumColumn" msprop:Generator_ColumnPropNameInRow="PassportNum" msprop:Generator_UserColumnName="PassportNum" msprop:Generator_ColumnVarNameInTable="columnPassportNum">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDUserType" msprop:Generator_ColumnPropNameInTable="IDUserTypeColumn" msprop:Generator_ColumnPropNameInRow="IDUserType" msprop:Generator_UserColumnName="IDUserType" msprop:Generator_ColumnVarNameInTable="columnIDUserType" type="xs:int" />
              <xs:element name="Phone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_UserColumnName="Phone">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UserTraffic" msprop:Generator_RowEvHandlerName="UserTrafficRowChangeEventHandler" msprop:Generator_RowDeletedName="UserTrafficRowDeleted" msprop:Generator_RowDeletingName="UserTrafficRowDeleting" msprop:Generator_RowEvArgName="UserTrafficRowChangeEvent" msprop:Generator_TablePropName="UserTraffic" msprop:Generator_RowChangedName="UserTrafficRowChanged" msprop:Generator_UserTableName="UserTraffic" msprop:Generator_RowChangingName="UserTrafficRowChanging" msprop:Generator_RowClassName="UserTrafficRow" msprop:Generator_TableClassName="UserTrafficDataTable" msprop:Generator_TableVarName="tableUserTraffic">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" type="xs:int" />
              <xs:element name="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" type="xs:int" />
              <xs:element name="TimeEntrance" msprop:Generator_ColumnPropNameInTable="TimeEntranceColumn" msprop:Generator_ColumnPropNameInRow="TimeEntrance" msprop:Generator_UserColumnName="TimeEntrance" msprop:Generator_ColumnVarNameInTable="columnTimeEntrance" type="xs:dateTime" minOccurs="0" />
              <xs:element name="TimeExit" msprop:Generator_ColumnPropNameInTable="TimeExitColumn" msprop:Generator_ColumnPropNameInRow="TimeExit" msprop:Generator_UserColumnName="TimeExit" msprop:Generator_ColumnVarNameInTable="columnTimeExit" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Identification" msprop:Generator_ColumnPropNameInTable="IdentificationColumn" msprop:Generator_ColumnPropNameInRow="Identification" msprop:Generator_UserColumnName="Identification" msprop:Generator_ColumnVarNameInTable="columnIdentification" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UserType" msprop:Generator_RowEvHandlerName="UserTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="UserTypeRowDeleted" msprop:Generator_RowDeletingName="UserTypeRowDeleting" msprop:Generator_RowEvArgName="UserTypeRowChangeEvent" msprop:Generator_TablePropName="UserType" msprop:Generator_RowChangedName="UserTypeRowChanged" msprop:Generator_UserTableName="UserType" msprop:Generator_RowChangingName="UserTypeRowChanging" msprop:Generator_RowClassName="UserTypeRow" msprop:Generator_TableClassName="UserTypeDataTable" msprop:Generator_TableVarName="tableUserType">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" type="xs:int" />
              <xs:element name="UserType" msprop:Generator_ColumnPropNameInTable="UserTypeColumn" msprop:Generator_ColumnPropNameInRow="UserType" msprop:Generator_UserColumnName="UserType" msprop:Generator_ColumnVarNameInTable="columnUserType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FaceImages" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="HistoryLogin_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:HistoryLogin" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Staffs_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Staffs" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="UserTraffic_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserTraffic" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="UserType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserType" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_FaceImages_Users" msdata:parent="Users" msdata:child="FaceImages" msdata:parentkey="ID" msdata:childkey="UserID" msprop:Generator_UserParentTable="Users" msprop:Generator_UserChildTable="FaceImages" msprop:Generator_RelationVarName="relationFK_FaceImages_Users" msprop:Generator_ChildPropName="GetFaceImagesRows" msprop:Generator_UserRelationName="FK_FaceImages_Users" msprop:Generator_ParentPropName="UsersRow" />
      <msdata:Relationship name="FK_HistoryLogin_Staffs" msdata:parent="Staffs" msdata:child="HistoryLogin" msdata:parentkey="ID" msdata:childkey="StaffsID" msprop:Generator_UserParentTable="Staffs" msprop:Generator_UserChildTable="HistoryLogin" msprop:Generator_RelationVarName="relationFK_HistoryLogin_Staffs" msprop:Generator_ChildPropName="GetHistoryLoginRows" msprop:Generator_UserRelationName="FK_HistoryLogin_Staffs" msprop:Generator_ParentPropName="StaffsRow" />
      <msdata:Relationship name="FK_Staffs_UserType" msdata:parent="UserType" msdata:child="Staffs" msdata:parentkey="ID" msdata:childkey="IDStaffsType" msprop:Generator_UserParentTable="UserType" msprop:Generator_UserChildTable="Staffs" msprop:Generator_RelationVarName="relationFK_Staffs_UserType" msprop:Generator_ChildPropName="GetStaffsRows" msprop:Generator_UserRelationName="FK_Staffs_UserType" msprop:Generator_ParentPropName="UserTypeRow" />
      <msdata:Relationship name="FK_Users_UserType" msdata:parent="UserType" msdata:child="Users" msdata:parentkey="ID" msdata:childkey="IDUserType" msprop:Generator_UserParentTable="UserType" msprop:Generator_UserChildTable="Users" msprop:Generator_RelationVarName="relationFK_Users_UserType" msprop:Generator_ChildPropName="GetUsersRows" msprop:Generator_UserRelationName="FK_Users_UserType" msprop:Generator_ParentPropName="UserTypeRow" />
      <msdata:Relationship name="FK_UserTraffic_Users" msdata:parent="Users" msdata:child="UserTraffic" msdata:parentkey="ID" msdata:childkey="UserID" msprop:Generator_UserParentTable="Users" msprop:Generator_UserChildTable="UserTraffic" msprop:Generator_RelationVarName="relationFK_UserTraffic_Users" msprop:Generator_ChildPropName="GetUserTrafficRows" msprop:Generator_ParentPropName="UsersRow" msprop:Generator_UserRelationName="FK_UserTraffic_Users" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>