Kafe03/KafeKazarin03/KazarinKafeDataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="KazarinKafeDataSet" targetNamespace="http://tempuri.org/KazarinKafeDataSet.xsd" xmlns:mstns="http://tempuri.org/KazarinKafeDataSet.xsd" xmlns="http://tempuri.org/KazarinKafeDataSet.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="KazarinKafeConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="KazarinKafeConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.KafeKazarin03.Properties.Settings.GlobalReference.Default.KazarinKafeConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CooksTableAdapter" GeneratorDataComponentClassName="CooksTableAdapter" Name="Cooks" UserDataComponentName="CooksTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinKafeConnectionString (Settings)" DbObjectName="KazarinKafe.dbo.Cooks" 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].[Cooks] 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_Отчество)))</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" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Cooks] ([IDПовара], [Фамилия], [Имя], [Отчество]) VALUES (@IDПовара, @Фамилия, @Имя, @Отчество);
SELECT IDПовара, Фамилия, Имя, Отчество FROM Cooks 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="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" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDПовара, Фамилия, Имя, Отчество FROM dbo.Cooks</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Cooks] SET [IDПовара] = @IDПовара, [Фамилия] = @Фамилия, [Имя] = @Имя, [Отчество] = @Отчество 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_Отчество)));
SELECT IDПовара, Фамилия, Имя, Отчество FROM Cooks 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="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="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" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDПовара" DataSetColumn="IDПовара" />
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Отчество" DataSetColumn="Отчество" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmployeesTableAdapter" GeneratorDataComponentClassName="EmployeesTableAdapter" Name="Employees" UserDataComponentName="EmployeesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinKafeConnectionString (Settings)" DbObjectName="KazarinKafe.dbo.Employees" 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].[Employees] 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_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_Password = 1 AND [Password] IS NULL) OR ([Password] = @Original_Password)) 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="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_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="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].[Employees] ([Роль], [ДатаРождения], [Телефон], [Адрес], [Username], [Password], [Статус]) VALUES (@Роль, @ДатаРождения, @Телефон, @Адрес, @Username, @Password, @Статус);
SELECT ID, Роль, ДатаРождения, Телефон, Адрес, Username, Password, Статус FROM Employees 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="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="@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="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, Роль, ДатаРождения, Телефон, Адрес, Username, Password, Статус FROM dbo.Employees</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Employees] SET [Роль] = @Роль, [ДатаРождения] = @ДатаРождения, [Телефон] = @Телефон, [Адрес] = @Адрес, [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_Адрес = 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)) AND ((@IsNull_Статус = 1 AND [Статус] IS NULL) OR ([Статус] = @Original_Статус)));
SELECT ID, Роль, ДатаРождения, Телефон, Адрес, Username, Password, Статус FROM Employees 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="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="@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="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="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_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="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="KazarinKafe.dbo.Employees" 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="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="Статус" DataSetColumn="Статус" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrderedDishesTableAdapter" GeneratorDataComponentClassName="OrderedDishesTableAdapter" Name="OrderedDishes" UserDataComponentName="OrderedDishesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinKafeConnectionString (Settings)" DbObjectName="KazarinKafe.dbo.OrderedDishes" 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].[OrderedDishes] WHERE (([ID] = @Original_ID) AND ((@IsNull_IDЗаказа = 1 AND [IDЗаказа] IS NULL) OR ([IDЗаказа] = @Original_IDЗаказа)) AND ((@IsNull_IDПродукт = 1 AND [IDПродукт] IS NULL) OR ([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_IDЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDЗаказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDЗаказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDПродукт" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDПродукт" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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].[OrderedDishes] ([IDЗаказа], [IDПродукт], [Количество]) VALUES (@IDЗаказа, @IDПродукт, @Количество);
SELECT ID, IDЗаказа, IDПродукт, Количество FROM OrderedDishes WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" 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="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="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, IDЗаказа, IDПродукт, Количество FROM dbo.OrderedDishes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[OrderedDishes] SET [IDЗаказа] = @IDЗаказа, [IDПродукт] = @IDПродукт, [Количество] = @Количество WHERE (([ID] = @Original_ID) AND ((@IsNull_IDЗаказа = 1 AND [IDЗаказа] IS NULL) OR ([IDЗаказа] = @Original_IDЗаказа)) AND ((@IsNull_IDПродукт = 1 AND [IDПродукт] IS NULL) OR ([IDПродукт] = @Original_IDПродукт)) AND ((@IsNull_Количество = 1 AND [Количество] IS NULL) OR ([Количество] = @Original_Количество)));
SELECT ID, IDЗаказа, IDПродукт, Количество FROM OrderedDishes WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" 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="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="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_IDЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDЗаказа" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDЗаказа" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDЗаказа" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDПродукт" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDПродукт" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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="KazarinKafe.dbo.OrderedDishes" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="IDЗаказа" DataSetColumn="IDЗаказа" />
              <Mapping SourceColumn="IDПродукт" DataSetColumn="IDПродукт" />
              <Mapping SourceColumn="Количество" DataSetColumn="Количество" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrdersTableAdapter" GeneratorDataComponentClassName="OrdersTableAdapter" Name="Orders" UserDataComponentName="OrdersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinKafeConnectionString (Settings)" DbObjectName="KazarinKafe.dbo.Orders" 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].[Orders] 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_IDСмены = 1 AND [IDСмены] IS NULL) OR ([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" />
                      <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="DateTime" Direction="Input" ParameterName="@Original_ДатаЗаказа" Precision="0" ProviderType="DateTime" 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="Decimal" Direction="Input" ParameterName="@Original_Стоимость" Precision="18" ProviderType="Decimal" Scale="2" 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_IDСмены" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDСмены" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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].[Orders] ([ДатаЗаказа], [СтатусЗаказа], [СпособОплаты], [Стоимость], [Столик], [IDСмены]) VALUES (@ДатаЗаказа, @СтатусЗаказа, @СпособОплаты, @Стоимость, @Столик, @IDСмены);
SELECT ID, ДатаЗаказа, СтатусЗаказа, СпособОплаты, Стоимость, Столик, IDСмены FROM Orders WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ДатаЗаказа" Precision="0" ProviderType="DateTime" 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="Decimal" Direction="Input" ParameterName="@Стоимость" Precision="18" ProviderType="Decimal" Scale="2" 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="@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, ДатаЗаказа, СтатусЗаказа, СпособОплаты, Стоимость, Столик, IDСмены FROM dbo.Orders</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Orders] SET [ДатаЗаказа] = @ДатаЗаказа, [СтатусЗаказа] = @СтатусЗаказа, [СпособОплаты] = @СпособОплаты, [Стоимость] = @Стоимость, [Столик] = @Столик, [IDСмены] = @IDСмены 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_IDСмены = 1 AND [IDСмены] IS NULL) OR ([IDСмены] = @Original_IDСмены)));
SELECT ID, ДатаЗаказа, СтатусЗаказа, СпособОплаты, Стоимость, Столик, IDСмены FROM Orders WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ДатаЗаказа" Precision="0" ProviderType="DateTime" 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="Decimal" Direction="Input" ParameterName="@Стоимость" Precision="18" ProviderType="Decimal" Scale="2" 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="@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" />
                      <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="DateTime" Direction="Input" ParameterName="@Original_ДатаЗаказа" Precision="0" ProviderType="DateTime" 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="Decimal" Direction="Input" ParameterName="@Original_Стоимость" Precision="18" ProviderType="Decimal" Scale="2" 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_IDСмены" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDСмены" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDСмены" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDСмены" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="KazarinKafe.dbo.Orders" 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="IDСмены" DataSetColumn="IDСмены" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrderStatusTableAdapter" GeneratorDataComponentClassName="OrderStatusTableAdapter" Name="OrderStatus" UserDataComponentName="OrderStatusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinKafeConnectionString (Settings)" DbObjectName="KazarinKafe.dbo.OrderStatus" 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].[OrderStatus] 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].[OrderStatus] ([Название]) VALUES (@Название);
SELECT ID, Название FROM OrderStatus 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.OrderStatus</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[OrderStatus] SET [Название] = @Название WHERE (([ID] = @Original_ID) AND ((@IsNull_Название = 1 AND [Название] IS NULL) OR ([Название] = @Original_Название)));
SELECT ID, Название FROM OrderStatus 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="KazarinKafe.dbo.OrderStatus" 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="PaymentMethodTableAdapter" GeneratorDataComponentClassName="PaymentMethodTableAdapter" Name="PaymentMethod" UserDataComponentName="PaymentMethodTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinKafeConnectionString (Settings)" DbObjectName="KazarinKafe.dbo.PaymentMethod" 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].[PaymentMethod] 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].[PaymentMethod] ([Название]) VALUES (@Название);
SELECT ID, Название FROM PaymentMethod 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.PaymentMethod</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PaymentMethod] SET [Название] = @Название WHERE (([ID] = @Original_ID) AND ((@IsNull_Название = 1 AND [Название] IS NULL) OR ([Название] = @Original_Название)));
SELECT ID, Название FROM PaymentMethod 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="KazarinKafe.dbo.PaymentMethod" 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="ProductTableAdapter" GeneratorDataComponentClassName="ProductTableAdapter" Name="Product" UserDataComponentName="ProductTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinKafeConnectionString (Settings)" DbObjectName="KazarinKafe.dbo.Product" 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].[Product] 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_Цена)))</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="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" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Product] ([Название], [Категория], [Описание], [Цена]) VALUES (@Название, @Категория, @Описание, @Цена);
SELECT ID, Название, Категория, Описание, Цена FROM Product 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="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="@Описание" Precision="0" ProviderType="NVarChar" 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" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Название, Категория, Описание, Цена FROM dbo.Product</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Product] 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_Цена)));
SELECT ID, Название, Категория, Описание, Цена FROM Product 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="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="@Описание" Precision="0" ProviderType="NVarChar" 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="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="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="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="KazarinKafe.dbo.Product" 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="Цена" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RolesTableAdapter" GeneratorDataComponentClassName="RolesTableAdapter" Name="Roles" UserDataComponentName="RolesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinKafeConnectionString (Settings)" DbObjectName="KazarinKafe.dbo.Roles" 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].[Roles] 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].[Roles] ([Название]) VALUES (@Название);
SELECT ID, Название FROM Roles 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.Roles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Roles] SET [Название] = @Название WHERE (([ID] = @Original_ID) AND ((@IsNull_Название = 1 AND [Название] IS NULL) OR ([Название] = @Original_Название)));
SELECT ID, Название FROM Roles 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="KazarinKafe.dbo.Roles" 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="TablesTableAdapter" GeneratorDataComponentClassName="TablesTableAdapter" Name="Tables" UserDataComponentName="TablesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinKafeConnectionString (Settings)" DbObjectName="KazarinKafe.dbo.Tables" 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].[Tables] 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].[Tables] ([Название]) VALUES (@Название);
SELECT ID, Название FROM Tables 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.Tables</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Tables] SET [Название] = @Название WHERE (([ID] = @Original_ID) AND ((@IsNull_Название = 1 AND [Название] IS NULL) OR ([Название] = @Original_Название)));
SELECT ID, Название FROM Tables 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="KazarinKafe.dbo.Tables" 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="WaitersTableAdapter" GeneratorDataComponentClassName="WaitersTableAdapter" Name="Waiters" UserDataComponentName="WaitersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinKafeConnectionString (Settings)" DbObjectName="KazarinKafe.dbo.Waiters" 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].[Waiters] 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_Отчество)))</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" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Waiters] ([IDОфицианта], [Фамилия], [Имя], [Отчество]) VALUES (@IDОфицианта, @Фамилия, @Имя, @Отчество);
SELECT IDОфицианта, Фамилия, Имя, Отчество FROM Waiters 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="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" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDОфицианта, Фамилия, Имя, Отчество FROM dbo.Waiters</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Waiters] SET [IDОфицианта] = @IDОфицианта, [Фамилия] = @Фамилия, [Имя] = @Имя, [Отчество] = @Отчество 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_Отчество)));
SELECT IDОфицианта, Фамилия, Имя, Отчество FROM Waiters 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="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="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" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDОфицианта" DataSetColumn="IDОфицианта" />
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Отчество" DataSetColumn="Отчество" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WorkShiftTableAdapter" GeneratorDataComponentClassName="WorkShiftTableAdapter" Name="WorkShift" UserDataComponentName="WorkShiftTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinKafeConnectionString (Settings)" DbObjectName="KazarinKafe.dbo.WorkShift" 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].[WorkShift] WHERE (([ID] = @Original_ID) AND ((@IsNull_IDОфицианта = 1 AND [IDОфицианта] IS NULL) OR ([IDОфицианта] = @Original_IDОфицианта)) AND ((@IsNull_IDПовара = 1 AND [IDПовара] IS NULL) OR ([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_IDОфицианта" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDОфицианта" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDОфицианта" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDОфицианта" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDПовара" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDПовара" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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="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].[WorkShift] ([IDОфицианта], [IDПовара], [ДатаСмены]) VALUES (@IDОфицианта, @IDПовара, @ДатаСмены);
SELECT ID, IDОфицианта, IDПовара, ДатаСмены FROM WorkShift WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" 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="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="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, IDОфицианта, IDПовара, ДатаСмены FROM dbo.WorkShift</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[WorkShift] SET [IDОфицианта] = @IDОфицианта, [IDПовара] = @IDПовара, [ДатаСмены] = @ДатаСмены WHERE (([ID] = @Original_ID) AND ((@IsNull_IDОфицианта = 1 AND [IDОфицианта] IS NULL) OR ([IDОфицианта] = @Original_IDОфицианта)) AND ((@IsNull_IDПовара = 1 AND [IDПовара] IS NULL) OR ([IDПовара] = @Original_IDПовара)) AND ((@IsNull_ДатаСмены = 1 AND [ДатаСмены] IS NULL) OR ([ДатаСмены] = @Original_ДатаСмены)));
SELECT ID, IDОфицианта, IDПовара, ДатаСмены FROM WorkShift WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" 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="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="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_IDОфицианта" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDОфицианта" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDОфицианта" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDОфицианта" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDПовара" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDПовара" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" 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="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="KazarinKafe.dbo.WorkShift" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="IDОфицианта" DataSetColumn="IDОфицианта" />
              <Mapping SourceColumn="IDПовара" DataSetColumn="IDПовара" />
              <Mapping SourceColumn="ДатаСмены" DataSetColumn="ДатаСмены" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="СategoriesTableAdapter" GeneratorDataComponentClassName="СategoriesTableAdapter" Name="Сategories" UserDataComponentName="СategoriesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinKafeConnectionString (Settings)" DbObjectName="KazarinKafe.dbo.Сategories" 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].[Сategories] 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].[Сategories] ([Название]) VALUES (@Название);
SELECT ID, Название FROM Сategories 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.Сategories</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Сategories] SET [Название] = @Название WHERE (([ID] = @Original_ID) AND ((@IsNull_Название = 1 AND [Название] IS NULL) OR ([Название] = @Original_Название)));
SELECT ID, Название FROM Сategories 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="KazarinKafe.dbo.Сategories" 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="СменыTableAdapter" GeneratorDataComponentClassName="СменыTableAdapter" Name="Смены" UserDataComponentName="СменыTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="KazarinKafeConnectionString (Settings)" DbObjectName="KazarinKafe.dbo.Смены" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ДатаСмены, Повар, Официант FROM dbo.Смены</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ДатаСмены" DataSetColumn="ДатаСмены" />
              <Mapping SourceColumn="Повар" DataSetColumn="Повар" />
              <Mapping SourceColumn="Официант" DataSetColumn="Официант" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="KazarinKafeDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="KazarinKafeDataSet" msprop:Generator_UserDSName="KazarinKafeDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Cooks" msprop:Generator_TableClassName="CooksDataTable" msprop:Generator_TableVarName="tableCooks" msprop:Generator_RowChangedName="CooksRowChanged" msprop:Generator_TablePropName="Cooks" msprop:Generator_RowDeletingName="CooksRowDeleting" msprop:Generator_RowChangingName="CooksRowChanging" msprop:Generator_RowEvHandlerName="CooksRowChangeEventHandler" msprop:Generator_RowDeletedName="CooksRowDeleted" msprop:Generator_RowClassName="CooksRow" msprop:Generator_UserTableName="Cooks" msprop:Generator_RowEvArgName="CooksRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDПовара" msprop:Generator_ColumnVarNameInTable="columnIDПовара" msprop:Generator_ColumnPropNameInRow="IDПовара" msprop:Generator_ColumnPropNameInTable="IDПовараColumn" 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:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Employees" msprop:Generator_TableClassName="EmployeesDataTable" msprop:Generator_TableVarName="tableEmployees" msprop:Generator_RowChangedName="EmployeesRowChanged" msprop:Generator_TablePropName="Employees" msprop:Generator_RowDeletingName="EmployeesRowDeleting" msprop:Generator_RowChangingName="EmployeesRowChanging" msprop:Generator_RowEvHandlerName="EmployeesRowChangeEventHandler" msprop:Generator_RowDeletedName="EmployeesRowDeleted" msprop:Generator_RowClassName="EmployeesRow" msprop:Generator_UserTableName="Employees" msprop:Generator_RowEvArgName="EmployeesRowChangeEvent">
          <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="Телефон" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </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="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <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: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="OrderedDishes" msprop:Generator_TableClassName="OrderedDishesDataTable" msprop:Generator_TableVarName="tableOrderedDishes" msprop:Generator_RowChangedName="OrderedDishesRowChanged" msprop:Generator_TablePropName="OrderedDishes" msprop:Generator_RowDeletingName="OrderedDishesRowDeleting" msprop:Generator_RowChangingName="OrderedDishesRowChanging" msprop:Generator_RowEvHandlerName="OrderedDishesRowChangeEventHandler" msprop:Generator_RowDeletedName="OrderedDishesRowDeleted" msprop:Generator_RowClassName="OrderedDishesRow" msprop:Generator_UserTableName="OrderedDishes" msprop:Generator_RowEvArgName="OrderedDishesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="IDЗаказа" msprop:Generator_ColumnVarNameInTable="columnIDЗаказа" msprop:Generator_ColumnPropNameInRow="IDЗаказа" msprop:Generator_ColumnPropNameInTable="IDЗаказаColumn" msprop:Generator_UserColumnName="IDЗаказа" type="xs:int" minOccurs="0" />
              <xs:element name="IDПродукт" msprop:Generator_ColumnVarNameInTable="columnIDПродукт" msprop:Generator_ColumnPropNameInRow="IDПродукт" msprop:Generator_ColumnPropNameInTable="IDПродуктColumn" msprop:Generator_UserColumnName="IDПродукт" 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:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Orders" msprop:Generator_TableClassName="OrdersDataTable" msprop:Generator_TableVarName="tableOrders" msprop:Generator_RowChangedName="OrdersRowChanged" msprop:Generator_TablePropName="Orders" msprop:Generator_RowDeletingName="OrdersRowDeleting" msprop:Generator_RowChangingName="OrdersRowChanging" msprop:Generator_RowEvHandlerName="OrdersRowChangeEventHandler" msprop:Generator_RowDeletedName="OrdersRowDeleted" msprop:Generator_RowClassName="OrdersRow" msprop:Generator_UserTableName="Orders" msprop:Generator_RowEvArgName="OrdersRowChangeEvent">
          <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: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:decimal" 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="IDСмены" msprop:Generator_ColumnVarNameInTable="columnIDСмены" msprop:Generator_ColumnPropNameInRow="IDСмены" msprop:Generator_ColumnPropNameInTable="IDСменыColumn" msprop:Generator_UserColumnName="IDСмены" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OrderStatus" msprop:Generator_TableClassName="OrderStatusDataTable" msprop:Generator_TableVarName="tableOrderStatus" msprop:Generator_RowChangedName="OrderStatusRowChanged" msprop:Generator_TablePropName="OrderStatus" msprop:Generator_RowDeletingName="OrderStatusRowDeleting" msprop:Generator_RowChangingName="OrderStatusRowChanging" msprop:Generator_RowEvHandlerName="OrderStatusRowChangeEventHandler" msprop:Generator_RowDeletedName="OrderStatusRowDeleted" msprop:Generator_RowClassName="OrderStatusRow" msprop:Generator_UserTableName="OrderStatus" msprop:Generator_RowEvArgName="OrderStatusRowChangeEvent">
          <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="PaymentMethod" msprop:Generator_TableClassName="PaymentMethodDataTable" msprop:Generator_TableVarName="tablePaymentMethod" msprop:Generator_RowChangedName="PaymentMethodRowChanged" msprop:Generator_TablePropName="PaymentMethod" msprop:Generator_RowDeletingName="PaymentMethodRowDeleting" msprop:Generator_RowChangingName="PaymentMethodRowChanging" msprop:Generator_RowEvHandlerName="PaymentMethodRowChangeEventHandler" msprop:Generator_RowDeletedName="PaymentMethodRowDeleted" msprop:Generator_RowClassName="PaymentMethodRow" msprop:Generator_UserTableName="PaymentMethod" msprop:Generator_RowEvArgName="PaymentMethodRowChangeEvent">
          <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="Product" msprop:Generator_TableClassName="ProductDataTable" msprop:Generator_TableVarName="tableProduct" msprop:Generator_RowChangedName="ProductRowChanged" msprop:Generator_TablePropName="Product" msprop:Generator_RowDeletingName="ProductRowDeleting" msprop:Generator_RowChangingName="ProductRowChanging" msprop:Generator_RowEvHandlerName="ProductRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductRowDeleted" msprop:Generator_RowClassName="ProductRow" msprop:Generator_UserTableName="Product" msprop:Generator_RowEvArgName="ProductRowChangeEvent">
          <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="Категория" 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="2147483647" />
                  </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="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Roles" msprop:Generator_TableClassName="RolesDataTable" msprop:Generator_TableVarName="tableRoles" msprop:Generator_RowChangedName="RolesRowChanged" msprop:Generator_TablePropName="Roles" msprop:Generator_RowDeletingName="RolesRowDeleting" msprop:Generator_RowChangingName="RolesRowChanging" msprop:Generator_RowEvHandlerName="RolesRowChangeEventHandler" msprop:Generator_RowDeletedName="RolesRowDeleted" msprop:Generator_RowClassName="RolesRow" msprop:Generator_UserTableName="Roles" msprop:Generator_RowEvArgName="RolesRowChangeEvent">
          <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="Tables" msprop:Generator_TableClassName="TablesDataTable" msprop:Generator_TableVarName="tableTables" msprop:Generator_RowChangedName="TablesRowChanged" msprop:Generator_TablePropName="_Tables" msprop:Generator_RowDeletingName="TablesRowDeleting" msprop:Generator_RowChangingName="TablesRowChanging" msprop:Generator_RowEvHandlerName="TablesRowChangeEventHandler" msprop:Generator_RowDeletedName="TablesRowDeleted" msprop:Generator_RowClassName="TablesRow" msprop:Generator_UserTableName="Tables" msprop:Generator_RowEvArgName="TablesRowChangeEvent">
          <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="Waiters" msprop:Generator_TableClassName="WaitersDataTable" msprop:Generator_TableVarName="tableWaiters" msprop:Generator_RowChangedName="WaitersRowChanged" msprop:Generator_TablePropName="Waiters" msprop:Generator_RowDeletingName="WaitersRowDeleting" msprop:Generator_RowChangingName="WaitersRowChanging" msprop:Generator_RowEvHandlerName="WaitersRowChangeEventHandler" msprop:Generator_RowDeletedName="WaitersRowDeleted" msprop:Generator_RowClassName="WaitersRow" msprop:Generator_UserTableName="Waiters" msprop:Generator_RowEvArgName="WaitersRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDОфицианта" msprop:Generator_ColumnVarNameInTable="columnIDОфицианта" msprop:Generator_ColumnPropNameInRow="IDОфицианта" msprop:Generator_ColumnPropNameInTable="IDОфициантаColumn" 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:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="WorkShift" msprop:Generator_TableClassName="WorkShiftDataTable" msprop:Generator_TableVarName="tableWorkShift" msprop:Generator_RowChangedName="WorkShiftRowChanged" msprop:Generator_TablePropName="WorkShift" msprop:Generator_RowDeletingName="WorkShiftRowDeleting" msprop:Generator_RowChangingName="WorkShiftRowChanging" msprop:Generator_RowEvHandlerName="WorkShiftRowChangeEventHandler" msprop:Generator_RowDeletedName="WorkShiftRowDeleted" msprop:Generator_RowClassName="WorkShiftRow" msprop:Generator_UserTableName="WorkShift" msprop:Generator_RowEvArgName="WorkShiftRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="IDОфицианта" msprop:Generator_ColumnVarNameInTable="columnIDОфицианта" msprop:Generator_ColumnPropNameInRow="IDОфицианта" msprop:Generator_ColumnPropNameInTable="IDОфициантаColumn" msprop:Generator_UserColumnName="IDОфицианта" type="xs:int" minOccurs="0" />
              <xs:element name="IDПовара" msprop:Generator_ColumnVarNameInTable="columnIDПовара" msprop:Generator_ColumnPropNameInRow="IDПовара" msprop:Generator_ColumnPropNameInTable="IDПовараColumn" msprop:Generator_UserColumnName="IDПовара" 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="Сategories" msprop:Generator_TableClassName="СategoriesDataTable" msprop:Generator_TableVarName="tableСategories" msprop:Generator_RowChangedName="СategoriesRowChanged" msprop:Generator_TablePropName="Сategories" msprop:Generator_RowDeletingName="СategoriesRowDeleting" msprop:Generator_RowChangingName="СategoriesRowChanging" msprop:Generator_RowEvHandlerName="СategoriesRowChangeEventHandler" msprop:Generator_RowDeletedName="СategoriesRowDeleted" msprop:Generator_RowClassName="СategoriesRow" msprop:Generator_UserTableName="Сategories" msprop:Generator_RowEvArgName="СategoriesRowChangeEvent">
          <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="Смены" msprop:Generator_TableClassName="СменыDataTable" msprop:Generator_TableVarName="tableСмены" msprop:Generator_TablePropName="Смены" msprop:Generator_RowDeletingName="СменыRowDeleting" msprop:Generator_RowChangingName="СменыRowChanging" msprop:Generator_RowEvHandlerName="СменыRowChangeEventHandler" msprop:Generator_RowDeletedName="СменыRowDeleted" msprop:Generator_UserTableName="Смены" msprop:Generator_RowChangedName="СменыRowChanged" msprop:Generator_RowEvArgName="СменыRowChangeEvent" msprop:Generator_RowClassName="СменыRow">
          <xs:complexType>
            <xs:sequence>
              <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="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:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Cooks" />
      <xs:field xpath="mstns:IDПовара" />
    </xs:unique>
    <xs:unique name="Employees_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Employees" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="OrderedDishes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:OrderedDishes" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Orders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Orders" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="OrderStatus_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:OrderStatus" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="PaymentMethod_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PaymentMethod" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Product_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Product" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Roles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Roles" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Tables_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tables" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Waiters_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Waiters" />
      <xs:field xpath="mstns:IDОфицианта" />
    </xs:unique>
    <xs:unique name="WorkShift_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:WorkShift" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Сategories_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Сategories" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Cooks_Employees1" msdata:parent="Employees" msdata:child="Cooks" msdata:parentkey="ID" msdata:childkey="IDПовара" msprop:Generator_UserChildTable="Cooks" msprop:Generator_ChildPropName="GetCooksRows" msprop:Generator_UserRelationName="FK_Cooks_Employees1" msprop:Generator_ParentPropName="EmployeesRow" msprop:Generator_RelationVarName="relationFK_Cooks_Employees1" msprop:Generator_UserParentTable="Employees" />
      <msdata:Relationship name="FK_Employees_Roles" msdata:parent="Roles" msdata:child="Employees" msdata:parentkey="ID" msdata:childkey="Роль" msprop:Generator_UserChildTable="Employees" msprop:Generator_ChildPropName="GetEmployeesRows" msprop:Generator_UserRelationName="FK_Employees_Roles" msprop:Generator_ParentPropName="RolesRow" msprop:Generator_RelationVarName="relationFK_Employees_Roles" msprop:Generator_UserParentTable="Roles" />
      <msdata:Relationship name="FK_OrderedDishes_Orders" msdata:parent="Orders" msdata:child="OrderedDishes" msdata:parentkey="ID" msdata:childkey="IDЗаказа" msprop:Generator_UserChildTable="OrderedDishes" msprop:Generator_ChildPropName="GetOrderedDishesRows" msprop:Generator_UserRelationName="FK_OrderedDishes_Orders" msprop:Generator_ParentPropName="OrdersRow" msprop:Generator_RelationVarName="relationFK_OrderedDishes_Orders" msprop:Generator_UserParentTable="Orders" />
      <msdata:Relationship name="FK_OrderedDishes_Product" msdata:parent="Product" msdata:child="OrderedDishes" msdata:parentkey="ID" msdata:childkey="IDПродукт" msprop:Generator_UserChildTable="OrderedDishes" msprop:Generator_ChildPropName="GetOrderedDishesRows" msprop:Generator_UserRelationName="FK_OrderedDishes_Product" msprop:Generator_ParentPropName="ProductRow" msprop:Generator_RelationVarName="relationFK_OrderedDishes_Product" msprop:Generator_UserParentTable="Product" />
      <msdata:Relationship name="FK_Orders_OrderStatus" msdata:parent="OrderStatus" msdata:child="Orders" msdata:parentkey="ID" msdata:childkey="СтатусЗаказа" msprop:Generator_UserChildTable="Orders" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_UserRelationName="FK_Orders_OrderStatus" msprop:Generator_ParentPropName="OrderStatusRow" msprop:Generator_RelationVarName="relationFK_Orders_OrderStatus" msprop:Generator_UserParentTable="OrderStatus" />
      <msdata:Relationship name="FK_Orders_PaymentMethod" msdata:parent="PaymentMethod" msdata:child="Orders" msdata:parentkey="ID" msdata:childkey="СпособОплаты" msprop:Generator_UserChildTable="Orders" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_UserRelationName="FK_Orders_PaymentMethod" msprop:Generator_ParentPropName="PaymentMethodRow" msprop:Generator_RelationVarName="relationFK_Orders_PaymentMethod" msprop:Generator_UserParentTable="PaymentMethod" />
      <msdata:Relationship name="FK_Orders_Tables" msdata:parent="Tables" msdata:child="Orders" msdata:parentkey="ID" msdata:childkey="Столик" msprop:Generator_UserChildTable="Orders" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_UserRelationName="FK_Orders_Tables" msprop:Generator_ParentPropName="TablesRow" msprop:Generator_RelationVarName="relationFK_Orders_Tables" msprop:Generator_UserParentTable="Tables" />
      <msdata:Relationship name="FK_Orders_WorkShift" msdata:parent="WorkShift" msdata:child="Orders" msdata:parentkey="ID" msdata:childkey="IDСмены" msprop:Generator_UserChildTable="Orders" msprop:Generator_ChildPropName="GetOrdersRows" msprop:Generator_UserRelationName="FK_Orders_WorkShift" msprop:Generator_ParentPropName="WorkShiftRow" msprop:Generator_RelationVarName="relationFK_Orders_WorkShift" msprop:Generator_UserParentTable="WorkShift" />
      <msdata:Relationship name="FK_Product_Сategories" msdata:parent="Сategories" msdata:child="Product" msdata:parentkey="ID" msdata:childkey="Категория" msprop:Generator_UserChildTable="Product" msprop:Generator_ChildPropName="GetProductRows" msprop:Generator_UserRelationName="FK_Product_Сategories" msprop:Generator_ParentPropName="СategoriesRow" msprop:Generator_RelationVarName="relationFK_Product_Сategories" msprop:Generator_UserParentTable="Сategories" />
      <msdata:Relationship name="FK_Waiters_Employees1" msdata:parent="Employees" msdata:child="Waiters" msdata:parentkey="ID" msdata:childkey="IDОфицианта" msprop:Generator_UserChildTable="Waiters" msprop:Generator_ChildPropName="GetWaitersRows" msprop:Generator_UserRelationName="FK_Waiters_Employees1" msprop:Generator_RelationVarName="relationFK_Waiters_Employees1" msprop:Generator_UserParentTable="Employees" msprop:Generator_ParentPropName="EmployeesRow" />
      <msdata:Relationship name="FK_WorkShift_Cooks" msdata:parent="Cooks" msdata:child="WorkShift" msdata:parentkey="IDПовара" msdata:childkey="IDПовара" msprop:Generator_UserChildTable="WorkShift" msprop:Generator_ChildPropName="GetWorkShiftRows" msprop:Generator_UserRelationName="FK_WorkShift_Cooks" msprop:Generator_RelationVarName="relationFK_WorkShift_Cooks" msprop:Generator_UserParentTable="Cooks" msprop:Generator_ParentPropName="CooksRow" />
      <msdata:Relationship name="FK_WorkShift_Waiters" msdata:parent="Waiters" msdata:child="WorkShift" msdata:parentkey="IDОфицианта" msdata:childkey="IDОфицианта" msprop:Generator_UserChildTable="WorkShift" msprop:Generator_ChildPropName="GetWorkShiftRows" msprop:Generator_UserRelationName="FK_WorkShift_Waiters" msprop:Generator_RelationVarName="relationFK_WorkShift_Waiters" msprop:Generator_UserParentTable="Waiters" msprop:Generator_ParentPropName="WaitersRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>