Kafe09/Kafe09DataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Kafe09DataSet" targetNamespace="http://tempuri.org/Kafe09DataSet.xsd" xmlns:mstns="http://tempuri.org/Kafe09DataSet.xsd" xmlns="http://tempuri.org/Kafe09DataSet.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="Kafe09ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Kafe09ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Kafe09.Properties.Settings.GlobalReference.Default.Kafe09ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BludaTableAdapter" GeneratorDataComponentClassName="BludaTableAdapter" Name="Bluda" UserDataComponentName="BludaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Kafe09ConnectionString (Settings)" DbObjectName="Kafe09.dbo.Bluda" 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].[Bluda] WHERE (([id] = @Original_id) AND ((@IsNull_Название = 1 AND [Название] IS NULL) OR ([Название] = @Original_Название)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Название" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Bluda] ([id], [Название]) VALUES (@id, @Название);
SELECT id, Название FROM Bluda 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="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, Название FROM dbo.Bluda</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Bluda] SET [id] = @id, [Название] = @Название WHERE (([id] = @Original_id) AND ((@IsNull_Название = 1 AND [Название] IS NULL) OR ([Название] = @Original_Название)));
SELECT id, Название FROM Bluda 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="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Название" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="Название" DataSetColumn="Название" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DoljnostiTableAdapter" GeneratorDataComponentClassName="DoljnostiTableAdapter" Name="Doljnosti" UserDataComponentName="DoljnostiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Kafe09ConnectionString (Settings)" DbObjectName="Kafe09.dbo.Doljnosti" 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].[Doljnosti] WHERE (([id] = @Original_id) AND ((@IsNull_НазваниеДолжности = 1 AND [НазваниеДолжности] IS NULL) OR ([НазваниеДолжности] = @Original_НазваниеДолжности)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_НазваниеДолжности" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="НазваниеДолжности" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_НазваниеДолжности" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="НазваниеДолжности" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Doljnosti] ([НазваниеДолжности]) VALUES (@НазваниеДолжности);
SELECT id, НазваниеДолжности FROM Doljnosti WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@НазваниеДолжности" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="НазваниеДолжности" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, НазваниеДолжности FROM dbo.Doljnosti</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Doljnosti] SET [НазваниеДолжности] = @НазваниеДолжности WHERE (([id] = @Original_id) AND ((@IsNull_НазваниеДолжности = 1 AND [НазваниеДолжности] IS NULL) OR ([НазваниеДолжности] = @Original_НазваниеДолжности)));
SELECT id, НазваниеДолжности FROM Doljnosti WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@НазваниеДолжности" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="НазваниеДолжности" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_НазваниеДолжности" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="НазваниеДолжности" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_НазваниеДолжности" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="НазваниеДолжности" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="Kafe09.dbo.Doljnosti" 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="НазваниеДолжности" DataSetColumn="НазваниеДолжности" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PolzovateliTableAdapter" GeneratorDataComponentClassName="PolzovateliTableAdapter" Name="Polzovateli" UserDataComponentName="PolzovateliTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Kafe09ConnectionString (Settings)" DbObjectName="Kafe09.dbo.Polzovateli" 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].[Polzovateli] WHERE (([id] = @Original_id) AND ((@IsNull_Фармилия = 1 AND [Фармилия] IS NULL) OR ([Фармилия] = @Original_Фармилия)) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчетсво = 1 AND [Отчетсво] IS NULL) OR ([Отчетсво] = @Original_Отчетсво)) AND ((@IsNull_Doljnost = 1 AND [Doljnost] IS NULL) OR ([Doljnost] = @Original_Doljnost)) AND ((@IsNull_ДатаПринятияНаРаботу = 1 AND [ДатаПринятияНаРаботу] IS NULL) OR ([ДатаПринятияНаРаботу] = @Original_ДатаПринятияНаРаботу)) AND ((@IsNull_Телефон = 1 AND [Телефон] IS NULL) OR ([Телефон] = @Original_Телефон)) AND ((@IsNull_Адрес = 1 AND [Адрес] IS NULL) OR ([Адрес] = @Original_Адрес)) AND ((@IsNull_СтатусПользователя = 1 AND [СтатусПользователя] IS NULL) OR ([СтатусПользователя] = @Original_СтатусПользователя)) AND ((@IsNull_username = 1 AND [username] IS NULL) OR ([username] = @Original_username)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Фармилия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Фармилия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фармилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фармилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчетсво" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчетсво" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отчетсво" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчетсво" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Doljnost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Doljnost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Doljnost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Doljnost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ДатаПринятияНаРаботу" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ДатаПринятияНаРаботу" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_ДатаПринятияНаРаботу" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаПринятияНаРаботу" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Телефон" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Телефон" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Адрес" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Адрес" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_СтатусПользователя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусПользователя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_СтатусПользователя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусПользователя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" 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" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Polzovateli] ([Фармилия], [Имя], [Отчетсво], [Doljnost], [ДатаПринятияНаРаботу], [Телефон], [Адрес], [СтатусПользователя], [username], [password]) VALUES (@Фармилия, @Имя, @Отчетсво, @Doljnost, @ДатаПринятияНаРаботу, @Телефон, @Адрес, @СтатусПользователя, @username, @password);
SELECT id, Фармилия, Имя, Отчетсво, Doljnost, ДатаПринятияНаРаботу, Телефон, Адрес, СтатусПользователя, username, password FROM Polzovateli WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фармилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фармилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчетсво" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчетсво" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Doljnost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Doljnost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ДатаПринятияНаРаботу" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаПринятияНаРаботу" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Телефон" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Адрес" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@СтатусПользователя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусПользователя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" 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" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, Фармилия, Имя, Отчетсво, Doljnost, ДатаПринятияНаРаботу, Телефон, Адрес, СтатусПользователя, username, password FROM dbo.Polzovateli</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Polzovateli] SET [Фармилия] = @Фармилия, [Имя] = @Имя, [Отчетсво] = @Отчетсво, [Doljnost] = @Doljnost, [ДатаПринятияНаРаботу] = @ДатаПринятияНаРаботу, [Телефон] = @Телефон, [Адрес] = @Адрес, [СтатусПользователя] = @СтатусПользователя, [username] = @username, [password] = @password WHERE (([id] = @Original_id) AND ((@IsNull_Фармилия = 1 AND [Фармилия] IS NULL) OR ([Фармилия] = @Original_Фармилия)) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчетсво = 1 AND [Отчетсво] IS NULL) OR ([Отчетсво] = @Original_Отчетсво)) AND ((@IsNull_Doljnost = 1 AND [Doljnost] IS NULL) OR ([Doljnost] = @Original_Doljnost)) AND ((@IsNull_ДатаПринятияНаРаботу = 1 AND [ДатаПринятияНаРаботу] IS NULL) OR ([ДатаПринятияНаРаботу] = @Original_ДатаПринятияНаРаботу)) AND ((@IsNull_Телефон = 1 AND [Телефон] IS NULL) OR ([Телефон] = @Original_Телефон)) AND ((@IsNull_Адрес = 1 AND [Адрес] IS NULL) OR ([Адрес] = @Original_Адрес)) AND ((@IsNull_СтатусПользователя = 1 AND [СтатусПользователя] IS NULL) OR ([СтатусПользователя] = @Original_СтатусПользователя)) AND ((@IsNull_username = 1 AND [username] IS NULL) OR ([username] = @Original_username)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)));
SELECT id, Фармилия, Имя, Отчетсво, Doljnost, ДатаПринятияНаРаботу, Телефон, Адрес, СтатусПользователя, username, password FROM Polzovateli WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Фармилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фармилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Отчетсво" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчетсво" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Doljnost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Doljnost" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ДатаПринятияНаРаботу" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаПринятияНаРаботу" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Телефон" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Адрес" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@СтатусПользователя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусПользователя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" 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="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Фармилия" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Фармилия" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Фармилия" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Фармилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчетсво" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчетсво" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Отчетсво" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Отчетсво" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Doljnost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Doljnost" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Doljnost" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Doljnost" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ДатаПринятияНаРаботу" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ДатаПринятияНаРаботу" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_ДатаПринятияНаРаботу" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ДатаПринятияНаРаботу" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Телефон" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Телефон" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Адрес" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Адрес" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Адрес" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_СтатусПользователя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусПользователя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_СтатусПользователя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусПользователя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" 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="false" AutogeneratedName="id" ColumnName="id" DataSourceName="Kafe09.dbo.Polzovateli" 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="Фармилия" DataSetColumn="Фармилия" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Отчетсво" DataSetColumn="Отчетсво" />
              <Mapping SourceColumn="Doljnost" DataSetColumn="Doljnost" />
              <Mapping SourceColumn="ДатаПринятияНаРаботу" DataSetColumn="ДатаПринятияНаРаботу" />
              <Mapping SourceColumn="Телефон" DataSetColumn="Телефон" />
              <Mapping SourceColumn="Адрес" DataSetColumn="Адрес" />
              <Mapping SourceColumn="СтатусПользователя" DataSetColumn="СтатусПользователя" />
              <Mapping SourceColumn="username" DataSetColumn="username" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SmeniTableAdapter" GeneratorDataComponentClassName="SmeniTableAdapter" Name="Smeni" UserDataComponentName="SmeniTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Kafe09ConnectionString (Settings)" DbObjectName="Kafe09.dbo.Smeni" 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].[Smeni] WHERE (([id] = @Original_id) AND ((@IsNull_Пользователь = 1 AND [Пользователь] IS NULL) OR ([Пользователь] = @Original_Пользователь)) AND ((@IsNull_Дата = 1 AND [Дата] IS NULL) OR ([Дата] = @Original_Дата)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Пользователь" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пользователь" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Пользователь" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пользователь" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Smeni] ([Пользователь], [Дата]) VALUES (@Пользователь, @Дата);
SELECT id, Пользователь, Дата FROM Smeni WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Пользователь" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пользователь" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, Пользователь, Дата FROM dbo.Smeni</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Smeni] SET [Пользователь] = @Пользователь, [Дата] = @Дата WHERE (([id] = @Original_id) AND ((@IsNull_Пользователь = 1 AND [Пользователь] IS NULL) OR ([Пользователь] = @Original_Пользователь)) AND ((@IsNull_Дата = 1 AND [Дата] IS NULL) OR ([Дата] = @Original_Дата)));
SELECT id, Пользователь, Дата FROM Smeni WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Пользователь" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пользователь" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Пользователь" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пользователь" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Пользователь" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пользователь" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="Kafe09.dbo.Smeni" 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="Пользователь" DataSetColumn="Пользователь" />
              <Mapping SourceColumn="Дата" DataSetColumn="Дата" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StatusiPolzovateleyTableAdapter" GeneratorDataComponentClassName="StatusiPolzovateleyTableAdapter" Name="StatusiPolzovateley" UserDataComponentName="StatusiPolzovateleyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Kafe09ConnectionString (Settings)" DbObjectName="Kafe09.dbo.StatusiPolzovateley" 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].[StatusiPolzovateley] WHERE (([id] = @Original_id) AND ((@IsNull_НазваниеСтатуса = 1 AND [НазваниеСтатуса] IS NULL) OR ([НазваниеСтатуса] = @Original_НазваниеСтатуса)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_НазваниеСтатуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="НазваниеСтатуса" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_НазваниеСтатуса" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="НазваниеСтатуса" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[StatusiPolzovateley] ([НазваниеСтатуса]) VALUES (@НазваниеСтатуса);
SELECT id, НазваниеСтатуса FROM StatusiPolzovateley WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@НазваниеСтатуса" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="НазваниеСтатуса" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, НазваниеСтатуса FROM dbo.StatusiPolzovateley</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[StatusiPolzovateley] SET [НазваниеСтатуса] = @НазваниеСтатуса WHERE (([id] = @Original_id) AND ((@IsNull_НазваниеСтатуса = 1 AND [НазваниеСтатуса] IS NULL) OR ([НазваниеСтатуса] = @Original_НазваниеСтатуса)));
SELECT id, НазваниеСтатуса FROM StatusiPolzovateley WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@НазваниеСтатуса" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="НазваниеСтатуса" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_НазваниеСтатуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="НазваниеСтатуса" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_НазваниеСтатуса" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="НазваниеСтатуса" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="Kafe09.dbo.StatusiPolzovateley" 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="НазваниеСтатуса" DataSetColumn="НазваниеСтатуса" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StatusiZakazaTableAdapter" GeneratorDataComponentClassName="StatusiZakazaTableAdapter" Name="StatusiZakaza" UserDataComponentName="StatusiZakazaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Kafe09ConnectionString (Settings)" DbObjectName="Kafe09.dbo.StatusiZakaza" 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].[StatusiZakaza] WHERE (([id] = @Original_id) AND ((@IsNull_НазваниеСтатуса = 1 AND [НазваниеСтатуса] IS NULL) OR ([НазваниеСтатуса] = @Original_НазваниеСтатуса)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_НазваниеСтатуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="НазваниеСтатуса" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_НазваниеСтатуса" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="НазваниеСтатуса" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[StatusiZakaza] ([НазваниеСтатуса]) VALUES (@НазваниеСтатуса);
SELECT id, НазваниеСтатуса FROM StatusiZakaza WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@НазваниеСтатуса" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="НазваниеСтатуса" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, НазваниеСтатуса FROM dbo.StatusiZakaza</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[StatusiZakaza] SET [НазваниеСтатуса] = @НазваниеСтатуса WHERE (([id] = @Original_id) AND ((@IsNull_НазваниеСтатуса = 1 AND [НазваниеСтатуса] IS NULL) OR ([НазваниеСтатуса] = @Original_НазваниеСтатуса)));
SELECT id, НазваниеСтатуса FROM StatusiZakaza WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@НазваниеСтатуса" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="НазваниеСтатуса" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_НазваниеСтатуса" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="НазваниеСтатуса" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_НазваниеСтатуса" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="НазваниеСтатуса" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="Kafe09.dbo.StatusiZakaza" 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="НазваниеСтатуса" DataSetColumn="НазваниеСтатуса" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StolikiTableAdapter" GeneratorDataComponentClassName="StolikiTableAdapter" Name="Stoliki" UserDataComponentName="StolikiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Kafe09ConnectionString (Settings)" DbObjectName="Kafe09.dbo.Stoliki" 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].[Stoliki] WHERE (([id] = @Original_id))</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" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Stoliki] ([id]) VALUES (@id);
SELECT id FROM Stoliki 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" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id FROM dbo.Stoliki</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Stoliki] SET [id] = @id WHERE (([id] = @Original_id));
SELECT id FROM Stoliki 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="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TipiOplatiTableAdapter" GeneratorDataComponentClassName="TipiOplatiTableAdapter" Name="TipiOplati" UserDataComponentName="TipiOplatiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Kafe09ConnectionString (Settings)" DbObjectName="Kafe09.dbo.TipiOplati" 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].[TipiOplati] WHERE (([id] = @Original_id) AND ((@IsNull_Название = 1 AND [Название] IS NULL) OR ([Название] = @Original_Название)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Название" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TipiOplati] ([Название]) VALUES (@Название);
SELECT id, Название FROM TipiOplati WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, Название FROM dbo.TipiOplati</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TipiOplati] SET [Название] = @Название WHERE (([id] = @Original_id) AND ((@IsNull_Название = 1 AND [Название] IS NULL) OR ([Название] = @Original_Название)));
SELECT id, Название FROM TipiOplati WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Название" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Название" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Название" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="Kafe09.dbo.TipiOplati" 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="Название" DataSetColumn="Название" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ZakazannieBludaTableAdapter" GeneratorDataComponentClassName="ZakazannieBludaTableAdapter" Name="ZakazannieBluda" UserDataComponentName="ZakazannieBludaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Kafe09ConnectionString (Settings)" DbObjectName="Kafe09.dbo.ZakazannieBluda" 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].[ZakazannieBluda] WHERE (([id] = @Original_id) AND ((@IsNull_ЗаказанныеБлюда = 1 AND [ЗаказанныеБлюда] IS NULL) OR ([ЗаказанныеБлюда] = @Original_ЗаказанныеБлюда)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ЗаказанныеБлюда" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЗаказанныеБлюда" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ЗаказанныеБлюда" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЗаказанныеБлюда" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ZakazannieBluda] ([ЗаказанныеБлюда]) VALUES (@ЗаказанныеБлюда);
SELECT id, ЗаказанныеБлюда FROM ZakazannieBluda WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ЗаказанныеБлюда" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЗаказанныеБлюда" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, ЗаказанныеБлюда FROM dbo.ZakazannieBluda</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ZakazannieBluda] SET [ЗаказанныеБлюда] = @ЗаказанныеБлюда WHERE (([id] = @Original_id) AND ((@IsNull_ЗаказанныеБлюда = 1 AND [ЗаказанныеБлюда] IS NULL) OR ([ЗаказанныеБлюда] = @Original_ЗаказанныеБлюда)));
SELECT id, ЗаказанныеБлюда FROM ZakazannieBluda WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ЗаказанныеБлюда" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЗаказанныеБлюда" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ЗаказанныеБлюда" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЗаказанныеБлюда" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ЗаказанныеБлюда" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЗаказанныеБлюда" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="Kafe09.dbo.ZakazannieBluda" 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="ЗаказанныеБлюда" DataSetColumn="ЗаказанныеБлюда" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ZakaziTableAdapter" GeneratorDataComponentClassName="ZakaziTableAdapter" Name="Zakazi" UserDataComponentName="ZakaziTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Kafe09ConnectionString (Settings)" DbObjectName="Kafe09.dbo.Zakazi" 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].[Zakazi] WHERE (([id] = @Original_id) AND ((@IsNull_СтатусЗаказа = 1 AND [СтатусЗаказа] IS NULL) OR ([СтатусЗаказа] = @Original_СтатусЗаказа)) AND ((@IsNull_Дата = 1 AND [Дата] IS NULL) OR ([Дата] = @Original_Дата)) AND ((@IsNull_ТипОплаты = 1 AND [ТипОплаты] IS NULL) OR ([ТипОплаты] = @Original_ТипОплаты)) AND ((@IsNull_Смена = 1 AND [Смена] IS NULL) OR ([Смена] = @Original_Смена)) AND ((@IsNull_Столик = 1 AND [Столик] IS NULL) OR ([Столик] = @Original_Столик)) AND ((@IsNull_Блюда = 1 AND [Блюда] IS NULL) OR ([Блюда] = @Original_Блюда)) AND ((@IsNull_ЗаказанныеБлюда = 1 AND [ЗаказанныеБлюда] IS NULL) OR ([ЗаказанныеБлюда] = @Original_ЗаказанныеБлюда)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_СтатусЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусЗаказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_СтатусЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусЗаказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ТипОплаты" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ТипОплаты" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ТипОплаты" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ТипОплаты" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Смена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Смена" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Смена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Смена" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Столик" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Столик" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Столик" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Столик" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Блюда" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Блюда" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Блюда" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Блюда" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ЗаказанныеБлюда" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЗаказанныеБлюда" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ЗаказанныеБлюда" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЗаказанныеБлюда" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Zakazi] ([СтатусЗаказа], [Дата], [ТипОплаты], [Смена], [Столик], [Блюда], [ЗаказанныеБлюда]) VALUES (@СтатусЗаказа, @Дата, @ТипОплаты, @Смена, @Столик, @Блюда, @ЗаказанныеБлюда);
SELECT id, СтатусЗаказа, Дата, ТипОплаты, Смена, Столик, Блюда, ЗаказанныеБлюда FROM Zakazi WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@СтатусЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусЗаказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ТипОплаты" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ТипОплаты" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Смена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Смена" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Столик" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Столик" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Блюда" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Блюда" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ЗаказанныеБлюда" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЗаказанныеБлюда" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, СтатусЗаказа, Дата, ТипОплаты, Смена, Столик, Блюда, ЗаказанныеБлюда FROM dbo.Zakazi</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Zakazi] SET [СтатусЗаказа] = @СтатусЗаказа, [Дата] = @Дата, [ТипОплаты] = @ТипОплаты, [Смена] = @Смена, [Столик] = @Столик, [Блюда] = @Блюда, [ЗаказанныеБлюда] = @ЗаказанныеБлюда WHERE (([id] = @Original_id) AND ((@IsNull_СтатусЗаказа = 1 AND [СтатусЗаказа] IS NULL) OR ([СтатусЗаказа] = @Original_СтатусЗаказа)) AND ((@IsNull_Дата = 1 AND [Дата] IS NULL) OR ([Дата] = @Original_Дата)) AND ((@IsNull_ТипОплаты = 1 AND [ТипОплаты] IS NULL) OR ([ТипОплаты] = @Original_ТипОплаты)) AND ((@IsNull_Смена = 1 AND [Смена] IS NULL) OR ([Смена] = @Original_Смена)) AND ((@IsNull_Столик = 1 AND [Столик] IS NULL) OR ([Столик] = @Original_Столик)) AND ((@IsNull_Блюда = 1 AND [Блюда] IS NULL) OR ([Блюда] = @Original_Блюда)) AND ((@IsNull_ЗаказанныеБлюда = 1 AND [ЗаказанныеБлюда] IS NULL) OR ([ЗаказанныеБлюда] = @Original_ЗаказанныеБлюда)));
SELECT id, СтатусЗаказа, Дата, ТипОплаты, Смена, Столик, Блюда, ЗаказанныеБлюда FROM Zakazi WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@СтатусЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусЗаказа" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ТипОплаты" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ТипОплаты" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Смена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Смена" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Столик" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Столик" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Блюда" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Блюда" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ЗаказанныеБлюда" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЗаказанныеБлюда" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_СтатусЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусЗаказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_СтатусЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="СтатусЗаказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ТипОплаты" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ТипОплаты" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ТипОплаты" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ТипОплаты" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Смена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Смена" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Смена" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Смена" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Столик" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Столик" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Столик" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Столик" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Блюда" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Блюда" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Блюда" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Блюда" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ЗаказанныеБлюда" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЗаказанныеБлюда" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ЗаказанныеБлюда" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ЗаказанныеБлюда" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="Kafe09.dbo.Zakazi" 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="СтатусЗаказа" DataSetColumn="СтатусЗаказа" />
              <Mapping SourceColumn="Дата" DataSetColumn="Дата" />
              <Mapping SourceColumn="ТипОплаты" DataSetColumn="ТипОплаты" />
              <Mapping SourceColumn="Смена" DataSetColumn="Смена" />
              <Mapping SourceColumn="Столик" DataSetColumn="Столик" />
              <Mapping SourceColumn="Блюда" DataSetColumn="Блюда" />
              <Mapping SourceColumn="ЗаказанныеБлюда" DataSetColumn="ЗаказанныеБлюда" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Kafe09DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Kafe09DataSet" msprop:Generator_UserDSName="Kafe09DataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Bluda" msprop:Generator_TableClassName="BludaDataTable" msprop:Generator_TableVarName="tableBluda" msprop:Generator_TablePropName="Bluda" msprop:Generator_RowDeletingName="BludaRowDeleting" msprop:Generator_RowChangingName="BludaRowChanging" msprop:Generator_RowEvHandlerName="BludaRowChangeEventHandler" msprop:Generator_RowDeletedName="BludaRowDeleted" msprop:Generator_UserTableName="Bluda" msprop:Generator_RowChangedName="BludaRowChanged" msprop:Generator_RowEvArgName="BludaRowChangeEvent" msprop:Generator_RowClassName="BludaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="Название" msprop:Generator_ColumnVarNameInTable="columnНазвание" msprop:Generator_ColumnPropNameInRow="Название" msprop:Generator_ColumnPropNameInTable="НазваниеColumn" msprop:Generator_UserColumnName="Название" 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="Doljnosti" msprop:Generator_TableClassName="DoljnostiDataTable" msprop:Generator_TableVarName="tableDoljnosti" msprop:Generator_TablePropName="Doljnosti" msprop:Generator_RowDeletingName="DoljnostiRowDeleting" msprop:Generator_RowChangingName="DoljnostiRowChanging" msprop:Generator_RowEvHandlerName="DoljnostiRowChangeEventHandler" msprop:Generator_RowDeletedName="DoljnostiRowDeleted" msprop:Generator_UserTableName="Doljnosti" msprop:Generator_RowChangedName="DoljnostiRowChanged" msprop:Generator_RowEvArgName="DoljnostiRowChangeEvent" msprop:Generator_RowClassName="DoljnostiRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="НазваниеДолжности" msprop:Generator_ColumnVarNameInTable="columnНазваниеДолжности" msprop:Generator_ColumnPropNameInRow="НазваниеДолжности" msprop:Generator_ColumnPropNameInTable="НазваниеДолжностиColumn" msprop:Generator_UserColumnName="НазваниеДолжности" 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="Polzovateli" msprop:Generator_TableClassName="PolzovateliDataTable" msprop:Generator_TableVarName="tablePolzovateli" msprop:Generator_TablePropName="Polzovateli" msprop:Generator_RowDeletingName="PolzovateliRowDeleting" msprop:Generator_RowChangingName="PolzovateliRowChanging" msprop:Generator_RowEvHandlerName="PolzovateliRowChangeEventHandler" msprop:Generator_RowDeletedName="PolzovateliRowDeleted" msprop:Generator_UserTableName="Polzovateli" msprop:Generator_RowChangedName="PolzovateliRowChanged" msprop:Generator_RowEvArgName="PolzovateliRowChangeEvent" msprop:Generator_RowClassName="PolzovateliRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="Фармилия" msprop:Generator_ColumnVarNameInTable="columnФармилия" msprop:Generator_ColumnPropNameInRow="Фармилия" msprop:Generator_ColumnPropNameInTable="ФармилияColumn" msprop:Generator_UserColumnName="Фармилия" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Имя" msprop:Generator_ColumnVarNameInTable="columnИмя" msprop:Generator_ColumnPropNameInRow="Имя" msprop:Generator_ColumnPropNameInTable="ИмяColumn" msprop:Generator_UserColumnName="Имя" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Отчетсво" msprop:Generator_ColumnVarNameInTable="columnОтчетсво" msprop:Generator_ColumnPropNameInRow="Отчетсво" msprop:Generator_ColumnPropNameInTable="ОтчетсвоColumn" msprop:Generator_UserColumnName="Отчетсво" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Doljnost" msprop:Generator_ColumnVarNameInTable="columnDoljnost" msprop:Generator_ColumnPropNameInRow="Doljnost" msprop:Generator_ColumnPropNameInTable="DoljnostColumn" msprop:Generator_UserColumnName="Doljnost" type="xs:int" minOccurs="0" />
              <xs:element name="ДатаПринятияНаРаботу" msprop:Generator_ColumnVarNameInTable="columnДатаПринятияНаРаботу" msprop:Generator_ColumnPropNameInRow="ДатаПринятияНаРаботу" msprop:Generator_ColumnPropNameInTable="ДатаПринятияНаРаботуColumn" msprop:Generator_UserColumnName="ДатаПринятияНаРаботу" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Телефон" msprop:Generator_ColumnVarNameInTable="columnТелефон" msprop:Generator_ColumnPropNameInRow="Телефон" msprop:Generator_ColumnPropNameInTable="ТелефонColumn" msprop:Generator_UserColumnName="Телефон" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Адрес" msprop:Generator_ColumnVarNameInTable="columnАдрес" msprop:Generator_ColumnPropNameInRow="Адрес" msprop:Generator_ColumnPropNameInTable="АдресColumn" msprop:Generator_UserColumnName="Адрес" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="СтатусПользователя" msprop:Generator_ColumnVarNameInTable="columnСтатусПользователя" msprop:Generator_ColumnPropNameInRow="СтатусПользователя" msprop:Generator_ColumnPropNameInTable="СтатусПользователяColumn" msprop:Generator_UserColumnName="СтатусПользователя" type="xs:int" minOccurs="0" />
              <xs:element name="username" msprop:Generator_ColumnVarNameInTable="columnusername" msprop:Generator_ColumnPropNameInRow="username" msprop:Generator_ColumnPropNameInTable="usernameColumn" msprop:Generator_UserColumnName="username" 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_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password" 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="Smeni" msprop:Generator_TableClassName="SmeniDataTable" msprop:Generator_TableVarName="tableSmeni" msprop:Generator_TablePropName="Smeni" msprop:Generator_RowDeletingName="SmeniRowDeleting" msprop:Generator_RowChangingName="SmeniRowChanging" msprop:Generator_RowEvHandlerName="SmeniRowChangeEventHandler" msprop:Generator_RowDeletedName="SmeniRowDeleted" msprop:Generator_UserTableName="Smeni" msprop:Generator_RowChangedName="SmeniRowChanged" msprop:Generator_RowEvArgName="SmeniRowChangeEvent" msprop:Generator_RowClassName="SmeniRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="Пользователь" msprop:Generator_ColumnVarNameInTable="columnПользователь" msprop:Generator_ColumnPropNameInRow="Пользователь" msprop:Generator_ColumnPropNameInTable="ПользовательColumn" msprop:Generator_UserColumnName="Пользователь" type="xs:int" minOccurs="0" />
              <xs:element name="Дата" msprop:Generator_ColumnVarNameInTable="columnДата" msprop:Generator_ColumnPropNameInRow="Дата" msprop:Generator_ColumnPropNameInTable="ДатаColumn" msprop:Generator_UserColumnName="Дата" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="StatusiPolzovateley" msprop:Generator_TableClassName="StatusiPolzovateleyDataTable" msprop:Generator_TableVarName="tableStatusiPolzovateley" msprop:Generator_TablePropName="StatusiPolzovateley" msprop:Generator_RowDeletingName="StatusiPolzovateleyRowDeleting" msprop:Generator_RowChangingName="StatusiPolzovateleyRowChanging" msprop:Generator_RowEvHandlerName="StatusiPolzovateleyRowChangeEventHandler" msprop:Generator_RowDeletedName="StatusiPolzovateleyRowDeleted" msprop:Generator_UserTableName="StatusiPolzovateley" msprop:Generator_RowChangedName="StatusiPolzovateleyRowChanged" msprop:Generator_RowEvArgName="StatusiPolzovateleyRowChangeEvent" msprop:Generator_RowClassName="StatusiPolzovateleyRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="НазваниеСтатуса" msprop:Generator_ColumnVarNameInTable="columnНазваниеСтатуса" msprop:Generator_ColumnPropNameInRow="НазваниеСтатуса" msprop:Generator_ColumnPropNameInTable="НазваниеСтатусаColumn" msprop:Generator_UserColumnName="НазваниеСтатуса" 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="StatusiZakaza" msprop:Generator_TableClassName="StatusiZakazaDataTable" msprop:Generator_TableVarName="tableStatusiZakaza" msprop:Generator_TablePropName="StatusiZakaza" msprop:Generator_RowDeletingName="StatusiZakazaRowDeleting" msprop:Generator_RowChangingName="StatusiZakazaRowChanging" msprop:Generator_RowEvHandlerName="StatusiZakazaRowChangeEventHandler" msprop:Generator_RowDeletedName="StatusiZakazaRowDeleted" msprop:Generator_UserTableName="StatusiZakaza" msprop:Generator_RowChangedName="StatusiZakazaRowChanged" msprop:Generator_RowEvArgName="StatusiZakazaRowChangeEvent" msprop:Generator_RowClassName="StatusiZakazaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="НазваниеСтатуса" msprop:Generator_ColumnVarNameInTable="columnНазваниеСтатуса" msprop:Generator_ColumnPropNameInRow="НазваниеСтатуса" msprop:Generator_ColumnPropNameInTable="НазваниеСтатусаColumn" msprop:Generator_UserColumnName="НазваниеСтатуса" 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="Stoliki" msprop:Generator_TableClassName="StolikiDataTable" msprop:Generator_TableVarName="tableStoliki" msprop:Generator_TablePropName="Stoliki" msprop:Generator_RowDeletingName="StolikiRowDeleting" msprop:Generator_RowChangingName="StolikiRowChanging" msprop:Generator_RowEvHandlerName="StolikiRowChangeEventHandler" msprop:Generator_RowDeletedName="StolikiRowDeleted" msprop:Generator_UserTableName="Stoliki" msprop:Generator_RowChangedName="StolikiRowChanged" msprop:Generator_RowEvArgName="StolikiRowChangeEvent" msprop:Generator_RowClassName="StolikiRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TipiOplati" msprop:Generator_TableClassName="TipiOplatiDataTable" msprop:Generator_TableVarName="tableTipiOplati" msprop:Generator_TablePropName="TipiOplati" msprop:Generator_RowDeletingName="TipiOplatiRowDeleting" msprop:Generator_RowChangingName="TipiOplatiRowChanging" msprop:Generator_RowEvHandlerName="TipiOplatiRowChangeEventHandler" msprop:Generator_RowDeletedName="TipiOplatiRowDeleted" msprop:Generator_UserTableName="TipiOplati" msprop:Generator_RowChangedName="TipiOplatiRowChanged" msprop:Generator_RowEvArgName="TipiOplatiRowChangeEvent" msprop:Generator_RowClassName="TipiOplatiRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="Название" msprop:Generator_ColumnVarNameInTable="columnНазвание" msprop:Generator_ColumnPropNameInRow="Название" msprop:Generator_ColumnPropNameInTable="НазваниеColumn" msprop:Generator_UserColumnName="Название" 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="ZakazannieBluda" msprop:Generator_TableClassName="ZakazannieBludaDataTable" msprop:Generator_TableVarName="tableZakazannieBluda" msprop:Generator_TablePropName="ZakazannieBluda" msprop:Generator_RowDeletingName="ZakazannieBludaRowDeleting" msprop:Generator_RowChangingName="ZakazannieBludaRowChanging" msprop:Generator_RowEvHandlerName="ZakazannieBludaRowChangeEventHandler" msprop:Generator_RowDeletedName="ZakazannieBludaRowDeleted" msprop:Generator_UserTableName="ZakazannieBluda" msprop:Generator_RowChangedName="ZakazannieBludaRowChanged" msprop:Generator_RowEvArgName="ZakazannieBludaRowChangeEvent" msprop:Generator_RowClassName="ZakazannieBludaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="ЗаказанныеБлюда" msprop:Generator_ColumnVarNameInTable="columnЗаказанныеБлюда" msprop:Generator_ColumnPropNameInRow="ЗаказанныеБлюда" msprop:Generator_ColumnPropNameInTable="ЗаказанныеБлюдаColumn" msprop:Generator_UserColumnName="ЗаказанныеБлюда" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Zakazi" msprop:Generator_TableClassName="ZakaziDataTable" msprop:Generator_TableVarName="tableZakazi" msprop:Generator_TablePropName="Zakazi" msprop:Generator_RowDeletingName="ZakaziRowDeleting" msprop:Generator_RowChangingName="ZakaziRowChanging" msprop:Generator_RowEvHandlerName="ZakaziRowChangeEventHandler" msprop:Generator_RowDeletedName="ZakaziRowDeleted" msprop:Generator_UserTableName="Zakazi" msprop:Generator_RowChangedName="ZakaziRowChanged" msprop:Generator_RowEvArgName="ZakaziRowChangeEvent" msprop:Generator_RowClassName="ZakaziRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="СтатусЗаказа" msprop:Generator_ColumnVarNameInTable="columnСтатусЗаказа" msprop:Generator_ColumnPropNameInRow="СтатусЗаказа" msprop:Generator_ColumnPropNameInTable="СтатусЗаказаColumn" msprop:Generator_UserColumnName="СтатусЗаказа" type="xs:int" minOccurs="0" />
              <xs:element name="Дата" msprop:Generator_ColumnVarNameInTable="columnДата" msprop:Generator_ColumnPropNameInRow="Дата" msprop:Generator_ColumnPropNameInTable="ДатаColumn" msprop:Generator_UserColumnName="Дата" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ТипОплаты" msprop:Generator_ColumnVarNameInTable="columnТипОплаты" msprop:Generator_ColumnPropNameInRow="ТипОплаты" msprop:Generator_ColumnPropNameInTable="ТипОплатыColumn" msprop:Generator_UserColumnName="ТипОплаты" type="xs:int" minOccurs="0" />
              <xs:element name="Смена" msprop:Generator_ColumnVarNameInTable="columnСмена" msprop:Generator_ColumnPropNameInRow="Смена" msprop:Generator_ColumnPropNameInTable="СменаColumn" msprop:Generator_UserColumnName="Смена" type="xs:int" minOccurs="0" />
              <xs:element name="Столик" msprop:Generator_ColumnVarNameInTable="columnСтолик" msprop:Generator_ColumnPropNameInRow="Столик" msprop:Generator_ColumnPropNameInTable="СтоликColumn" msprop:Generator_UserColumnName="Столик" type="xs:int" minOccurs="0" />
              <xs:element name="Блюда" msprop:Generator_ColumnVarNameInTable="columnБлюда" msprop:Generator_ColumnPropNameInRow="Блюда" msprop:Generator_ColumnPropNameInTable="БлюдаColumn" msprop:Generator_UserColumnName="Блюда" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ЗаказанныеБлюда" msprop:Generator_ColumnVarNameInTable="columnЗаказанныеБлюда" msprop:Generator_ColumnPropNameInRow="ЗаказанныеБлюда" msprop:Generator_ColumnPropNameInTable="ЗаказанныеБлюдаColumn" msprop:Generator_UserColumnName="ЗаказанныеБлюда" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Bluda" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Doljnosti_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Doljnosti" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Polzovateli_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Polzovateli" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Smeni_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Smeni" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="StatusiPolzovateley_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:StatusiPolzovateley" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="StatusiZakaza_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:StatusiZakaza" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Stoliki_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Stoliki" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="TipiOplati_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TipiOplati" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="ZakazannieBluda_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ZakazannieBluda" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Zakazi_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Zakazi" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Polzovateli_StatusiPolzovateley" msdata:parent="StatusiPolzovateley" msdata:child="Polzovateli" msdata:parentkey="id" msdata:childkey="СтатусПользователя" msprop:Generator_UserChildTable="Polzovateli" msprop:Generator_ChildPropName="GetPolzovateliRows" msprop:Generator_UserRelationName="FK_Polzovateli_StatusiPolzovateley" msprop:Generator_RelationVarName="relationFK_Polzovateli_StatusiPolzovateley" msprop:Generator_UserParentTable="StatusiPolzovateley" msprop:Generator_ParentPropName="StatusiPolzovateleyRow" />
      <msdata:Relationship name="FK_Polzovateli_Должность" msdata:parent="Doljnosti" msdata:child="Polzovateli" msdata:parentkey="id" msdata:childkey="Doljnost" msprop:Generator_UserChildTable="Polzovateli" msprop:Generator_ChildPropName="GetPolzovateliRows" msprop:Generator_UserRelationName="FK_Polzovateli_Должность" msprop:Generator_ParentPropName="DoljnostiRow" msprop:Generator_RelationVarName="relationFK_Polzovateli_Должность" msprop:Generator_UserParentTable="Doljnosti" />
      <msdata:Relationship name="FK_Smeni_Polzovateli" msdata:parent="Polzovateli" msdata:child="Smeni" msdata:parentkey="id" msdata:childkey="id" msprop:Generator_UserChildTable="Smeni" msprop:Generator_ChildPropName="GetSmeniRows" msprop:Generator_UserRelationName="FK_Smeni_Polzovateli" msprop:Generator_ParentPropName="PolzovateliRow" msprop:Generator_RelationVarName="relationFK_Smeni_Polzovateli" msprop:Generator_UserParentTable="Polzovateli" />
      <msdata:Relationship name="FK_ZakazannieBluda_Bluda" msdata:parent="Bluda" msdata:child="ZakazannieBluda" msdata:parentkey="id" msdata:childkey="ЗаказанныеБлюда" msprop:Generator_UserChildTable="ZakazannieBluda" msprop:Generator_ChildPropName="GetZakazannieBludaRows" msprop:Generator_UserRelationName="FK_ZakazannieBluda_Bluda" msprop:Generator_ParentPropName="BludaRow" msprop:Generator_RelationVarName="relationFK_ZakazannieBluda_Bluda" msprop:Generator_UserParentTable="Bluda" />
      <msdata:Relationship name="FK_Zakazi_Smeni" msdata:parent="Smeni" msdata:child="Zakazi" msdata:parentkey="id" msdata:childkey="Смена" msprop:Generator_UserChildTable="Zakazi" msprop:Generator_ChildPropName="GetZakaziRows" msprop:Generator_UserRelationName="FK_Zakazi_Smeni" msprop:Generator_ParentPropName="SmeniRow" msprop:Generator_RelationVarName="relationFK_Zakazi_Smeni" msprop:Generator_UserParentTable="Smeni" />
      <msdata:Relationship name="FK_Zakazi_StatusZakaza" msdata:parent="StatusiZakaza" msdata:child="Zakazi" msdata:parentkey="id" msdata:childkey="СтатусЗаказа" msprop:Generator_UserChildTable="Zakazi" msprop:Generator_ChildPropName="GetZakaziRows" msprop:Generator_UserRelationName="FK_Zakazi_StatusZakaza" msprop:Generator_ParentPropName="StatusiZakazaRow" msprop:Generator_RelationVarName="relationFK_Zakazi_StatusZakaza" msprop:Generator_UserParentTable="StatusiZakaza" />
      <msdata:Relationship name="FK_Zakazi_Stoliki" msdata:parent="Stoliki" msdata:child="Zakazi" msdata:parentkey="id" msdata:childkey="Столик" msprop:Generator_UserChildTable="Zakazi" msprop:Generator_ChildPropName="GetZakaziRows" msprop:Generator_UserRelationName="FK_Zakazi_Stoliki" msprop:Generator_ParentPropName="StolikiRow" msprop:Generator_RelationVarName="relationFK_Zakazi_Stoliki" msprop:Generator_UserParentTable="Stoliki" />
      <msdata:Relationship name="FK_Zakazi_TipOplati" msdata:parent="TipiOplati" msdata:child="Zakazi" msdata:parentkey="id" msdata:childkey="ТипОплаты" msprop:Generator_UserChildTable="Zakazi" msprop:Generator_ChildPropName="GetZakaziRows" msprop:Generator_UserRelationName="FK_Zakazi_TipOplati" msprop:Generator_ParentPropName="TipiOplatiRow" msprop:Generator_RelationVarName="relationFK_Zakazi_TipOplati" msprop:Generator_UserParentTable="TipiOplati" />
      <msdata:Relationship name="FK_Zakazi_ZakazannieBluda" msdata:parent="ZakazannieBluda" msdata:child="Zakazi" msdata:parentkey="id" msdata:childkey="ЗаказанныеБлюда" msprop:Generator_UserChildTable="Zakazi" msprop:Generator_ChildPropName="GetZakaziRows" msprop:Generator_UserRelationName="FK_Zakazi_ZakazannieBluda" msprop:Generator_ParentPropName="ZakazannieBludaRow" msprop:Generator_RelationVarName="relationFK_Zakazi_ZakazannieBluda" msprop:Generator_UserParentTable="ZakazannieBluda" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>