MainWindow.xaml

<Window x:Class="hotelAdm.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:gif="http://wpfanimatedgif.codeplex.com"
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
        xmlns:local="clr-namespace:hotelAdm"
        mc:Ignorable="d"
        Title="Hotel" Height="700" Width="1200" WindowStartupLocation="CenterScreen" ResizeMode="CanMinimize">
    <Grid>
        <Grid x:Name="ContentGrid">
            <Grid.ColumnDefinitions>
                <ColumnDefinition Width="*"/>
                <ColumnDefinition Width="4*"/>
            </Grid.ColumnDefinitions>
            <Grid x:Name="MenuGrid" Grid.Column="0" Background="Gray">
                <Grid.RowDefinitions>
                    <RowDefinition Height="*"/>
                    <RowDefinition Height="5*"/>
                </Grid.RowDefinitions>
                <Grid x:Name="UserNameBox" Grid.Row="0" Background="#FF525252">
                    <Label x:Name="NameLabel" Style="{StaticResource ForUserLabels}" Content="NameLabel"  Margin="10,24,10.4,0" Width="218" Height="41" FontSize="24" FontWeight="Bold"/>
                    <Label x:Name="PositionLabel" Style="{StaticResource ForUserLabels}" Content="PositionLabel"  Margin="10,70,10.4,0"  Width="218"/>
                </Grid>
                <Grid x:Name="MenuBox" Grid.Row="1">
                    <StackPanel x:Name="MenuButtons">
                        <Button x:Name="NewOfferBtn" Content="Новый заказ" Style="{StaticResource ForMenuButtons}" Click="NewOfferBtn_Click" Visibility="Collapsed"/>
                        <Button x:Name="ApartsBtn" Content="Номера" Style="{StaticResource ForMenuButtons}" Click="ApartsBtn_Click" Visibility="Collapsed"/>
                        <Button x:Name="OffersBtn" Content="Список заказов" Style="{StaticResource ForMenuButtons}" Click="OffersBtn_Click" Visibility="Collapsed"/>
                        <Button x:Name="StokBtn" Content="Склад" Style="{StaticResource ForMenuButtons}" Click="StokBtn_Click" Visibility="Collapsed"/>
                        <Button x:Name="GuestsBtn" Content="Клиенты" Style="{StaticResource ForMenuButtons}" Click="GuestsBtn_Click" Visibility="Collapsed"/>
                        <Button x:Name="SBSettingsBtn" Content="Настройки"  Style="{StaticResource ForMenuButtons}" Click="SBSettingsBtn_Click" Margin="7,15,3.4,15" Visibility="Collapsed"/>
                    </StackPanel>
                </Grid>
            </Grid>
            <Grid x:Name="DataGrid" Grid.Column="1">
                <Image Source="img/logo.png" Margin="245,146,245,146"/>
                <Grid x:Name="SettingsGrid" Visibility="Hidden" Background="White">
                    <TabControl x:Name="DBSettingsTab">
                        <TabItem x:Name="ConnectionSettings">
                            <TabItem.Header>
                                <TextBlock Text="Подключение к БД"/>
                            </TabItem.Header>
                            <TabItem.Content>
                                <Grid>
                                    <Grid.ColumnDefinitions>
                                        <ColumnDefinition Width="*"/>
                                        <ColumnDefinition Width="2*"/>
                                        <ColumnDefinition Width="*"/>
                                    </Grid.ColumnDefinitions>
                                    <Grid.RowDefinitions>
                                        <RowDefinition Height="2*"/>
                                        <RowDefinition Height="3*"/>
                                        <RowDefinition Height="*"/>
                                    </Grid.RowDefinitions>
                                    <Label Grid.Column="1" Content="Настройка подключения БД" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="34"/>
                                    <Grid Grid.Column="1" Grid.Row="1">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="2*"/>
                                            <RowDefinition Height="*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition/>
                                            <ColumnDefinition/>
                                        </Grid.ColumnDefinitions>
                                        <StackPanel Grid.Column="0" Grid.Row="0">
                                            <Label Content="Сервер" Style="{StaticResource ForSettingsLabels}"/>
                                            <Label Content="Порт" Style="{StaticResource ForSettingsLabels}"/>
                                            <Label Content="Имя базы данных" Style="{StaticResource ForSettingsLabels}"/>
                                            <Label Content="Пользователь" Style="{StaticResource ForSettingsLabels}"/>
                                            <Label Content="Пароль" Style="{StaticResource ForSettingsLabels}"/>
                                        </StackPanel>
                                        <StackPanel Grid.Column="1" Grid.Row="0">
                                            <TextBox x:Name="DBServerSettingsTextbox" Style="{StaticResource ForSettingsTextboxes}"/>
                                            <TextBox x:Name="DBPortSettingsTextbox" Style="{StaticResource ForSettingsTextboxes}"/>
                                            <TextBox x:Name="DBNameSettingsTextbox" Style="{StaticResource ForSettingsTextboxes}"/>
                                            <TextBox x:Name="DBUserSettingsTextbox" Style="{StaticResource ForSettingsTextboxes}"/>
                                            <TextBox x:Name="DBPassSettingsTextbox" Style="{StaticResource ForSettingsTextboxes}"/>
                                        </StackPanel>
                                        <Grid Grid.Row="1" Grid.ColumnSpan="2">
                                            <Button x:Name="SaveSettingsBtn" Content="Сохранить" Style="{StaticResource ForMenuButtons}" Click="SaveSettingsBtn_Click"/>
                                        </Grid>
                                    </Grid>
                                    <StackPanel Grid.Row="2" Grid.ColumnSpan="3" Orientation="Horizontal">
                                        <Button x:Name="SaveDBBtn" Content="Резервная копия" Style="{StaticResource ForMenuButtons}" Click="SaveDBBtn_Click" Margin="5,57,5,15.2" Width="239"/>
                                        <Button x:Name="AnyQueryBtn" Content="Пользовательские запросы" Style="{StaticResource ForMenuButtons}" Click="AnyQueryBtn_Click" Margin="5,57,5,15.2" Width="357"/>
                                        <Button x:Name="ReportBtn" Content="Отчет" Style="{StaticResource ForMenuButtons}" Margin="5,57,5,15.2" Width="108" Click="ReportBtn_Click"/>
                                    </StackPanel>
                                </Grid>
                            </TabItem.Content>
                        </TabItem>
                        <TabItem x:Name="UsersSettings">
                            <TabItem.Header>
                                <TextBlock Text="Пользователи"/>
                            </TabItem.Header>
                            <TabItem.Content>
                                <Grid>
                                    <Grid.RowDefinitions>
                                        <RowDefinition Height="*"/>
                                        <RowDefinition Height="6*"/>
                                        <RowDefinition Height="3*"/>
                                    </Grid.RowDefinitions>
                                    <Grid.ColumnDefinitions>
                                        <ColumnDefinition Width="*"/>
                                        <ColumnDefinition Width="6*"/>
                                        <ColumnDefinition Width="*"/>
                                    </Grid.ColumnDefinitions>
                                    <Grid Grid.Column="1" Grid.Row="1">
                                        <ScrollViewer>
                                            <DataGrid  x:Name="usersDataGrid" IsReadOnly="True" AutoGenerateColumns="True" HorizontalGridLinesBrush="DarkGray"
    RowBackground="LightGray" AlternatingRowBackground="White" FontSize="14">
                                                <DataGrid.Columns>
                                                    <DataGridTextColumn Header="ID" Binding="{Binding Path=id}"/>
                                                    <DataGridTextColumn Header="Логин" Binding="{Binding Path=login}"/>
                                                    <DataGridTextColumn Header="Пароль" Binding="{Binding Path=password}"/>
                                                    <DataGridTextColumn Header="ФИО" Binding="{Binding Path=FIO}"/>
                                                    <DataGridTextColumn Header="Тип" Binding="{Binding Path=type}"/>
                                                    <DataGridTextColumn Header="Должность" Binding="{Binding Path=position_name}"/>
                                                </DataGrid.Columns>
                                            </DataGrid>
                                        </ScrollViewer>
                                    </Grid>
                                    <Grid x:Name="UsersControlBtnGrid" Grid.Column="1" Grid.Row="2" Background="White" Visibility="Visible">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="*"/>
                                            <RowDefinition Height="*"/>
                                            <RowDefinition Height="2*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                        </Grid.ColumnDefinitions>
                                        <Button x:Name="AddUserBtn" Content="Создать" Grid.Row="1" Grid.Column="1" Style="{StaticResource ForAddBtn}" Click="AddUserBtn_Click"/>
                                        <Button x:Name="UpdateUserBtn" Content="Изменить" Grid.Row="1" Grid.Column="3" Style="{StaticResource ForEditBtn}" Click="UpdateUserBtn_Click"/>
                                        <Button x:Name="DeleteUserBtn" Content="Удалить" Grid.Row="1" Grid.Column="5" Style="{StaticResource ForDeleteBtn}" Click="DeleteUserBtn_Click"/>
                                    </Grid>
                                    <Grid x:Name="CreateUserGrid" Grid.Column="1" Grid.Row="2" Visibility="Hidden">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="4*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="2*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                        </Grid.ColumnDefinitions>
                                        <Label Content="Добавление пользователя" Grid.Column="2" Grid.ColumnSpan="5" FontSize="20" HorizontalAlignment="Center"/>
                                        <StackPanel x:Name="CreateUserLoginPanel" Grid.Row="1">
                                            <Label Content="Логин"/>
                                            <TextBox x:Name="CreateUserLoginTextBox"/>
                                        </StackPanel>
                                        <StackPanel x:Name="CreateUserPasswordPanel" Grid.Row="1" Grid.Column="2">
                                            <Label Content="Пароль"/>
                                            <TextBox x:Name="CreateUserPasswordTextBox"/>
                                        </StackPanel>
                                        <StackPanel x:Name="CreateUserFIOPanel" Grid.Row="1" Grid.Column="4">
                                            <Label Content="ФИО"/>
                                            <TextBox x:Name="CreateUserFIOTextBox"/>
                                        </StackPanel>
                                        <StackPanel x:Name="CreateUserTypePanel" Grid.Row="1" Grid.Column="6">
                                            <Label Content="Тип"/>
                                            <ComboBox x:Name="CreateUserTypeTextBox" IsEditable="True" IsReadOnly="True" Text="Выберите"/>
                                        </StackPanel>
                                        <StackPanel x:Name="CreateUserPositionPanel"  Grid.Row="1" Grid.Column="8">
                                            <Label Content="Должность"/>
                                            <ComboBox x:Name="CreateUserPositionTextBox" IsEditable="True" IsReadOnly="True" Text="Выберите"/>
                                        </StackPanel>
                                        <Button x:Name="CreateUserCanselBtn" Content="Отменить" Grid.Column="6" Grid.Row="3" Style="{StaticResource ForDeleteBtn}" Click="CreateUserCanselBtn_Click"/>
                                        <Button x:Name="CreateUserSaveBtn" Content="Сохранить" Grid.Column="8" Grid.Row="3" Style="{StaticResource ForAddBtn}" Click="CreateUserSaveBtn_Click"/>
                                    </Grid>
                                    <Grid x:Name="UpdateUserGrid" Grid.Column="1" Grid.Row="2" Visibility="Hidden">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="4*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="2*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                        </Grid.ColumnDefinitions>
                                        <TextBox x:Name="UserIdForUpdate" Visibility="Collapsed"/>
                                        <Label Content="Редактирование пользователя" Grid.Column="2" Grid.ColumnSpan="5" FontSize="20" HorizontalAlignment="Center"/>
                                        <StackPanel x:Name="UpdateUserLoginPanel" Grid.Row="1">
                                            <Label Content="Логин"/>
                                            <TextBox x:Name="UpdateUserLoginTextBox"/>
                                        </StackPanel>
                                        <StackPanel x:Name="UpdateUserPasswordPanel" Grid.Row="1" Grid.Column="2">
                                            <Label Content="Пароль"/>
                                            <TextBox x:Name="UpdateUserPasswordTextBox"/>
                                        </StackPanel>
                                        <StackPanel x:Name="UpdateUserFIOPanel" Grid.Row="1" Grid.Column="4">
                                            <Label Content="ФИО"/>
                                            <TextBox x:Name="UpdateUserFIOTextBox"/>
                                        </StackPanel>
                                        <StackPanel x:Name="UpdateUserTypePanel" Grid.Row="1" Grid.Column="6">
                                            <Label Content="Тип"/>
                                            <ComboBox x:Name="UpdateUserTypeTextBox"/>
                                        </StackPanel>
                                        <StackPanel x:Name="UpdateUserPositionPanel" Grid.Row="1" Grid.Column="8">
                                            <Label Content="Должность"/>
                                            <ComboBox x:Name="UpdateUserPositionTextBox"/>
                                        </StackPanel>
                                        <Button x:Name="UpdateUserCanselBtn" Content="Отменить" Grid.Column="6" Grid.Row="3" Style="{StaticResource ForDeleteBtn}" Click="UpdateUserCanselBtn_Click"/>
                                        <Button x:Name="UpdateUserSaveBtn" Content="Сохранить" Grid.Column="8" Grid.Row="3" Style="{StaticResource ForAddBtn}" Click="UpdateUserSaveBtn_Click"/>
                                    </Grid>
                                </Grid>
                            </TabItem.Content>
                        </TabItem>
                        <TabItem x:Name="ApartSettings">
                            <TabItem.Header>
                                <TextBlock Text="Номера"/>
                            </TabItem.Header>
                            <TabItem.Content>
                                <Grid>
                                    <Grid.RowDefinitions>
                                        <RowDefinition Height="*"/>
                                        <RowDefinition Height="6*"/>
                                        <RowDefinition Height="3*"/>
                                    </Grid.RowDefinitions>
                                    <Grid.ColumnDefinitions>
                                        <ColumnDefinition Width="*"/>
                                        <ColumnDefinition Width="6*"/>
                                        <ColumnDefinition Width="*"/>
                                    </Grid.ColumnDefinitions>
                                    <Grid Grid.Column="1" Grid.Row="1">
                                        <ScrollViewer>
                                            <DataGrid  x:Name="ApartsDataGrid" AutoGenerateColumns="True" HorizontalGridLinesBrush="DarkGray"
    RowBackground="LightGray" AlternatingRowBackground="White" FontSize="14">
                                                <DataGrid.Columns>
                                                    <DataGridTextColumn Header="ID" Binding="{Binding Path=id}"/>
                                                    <DataGridTextColumn Header="Количество комнат" Binding="{Binding Path=countOfRooms}"/>
                                                    <DataGridTextColumn Header="Тип номера" Binding="{Binding Path=roomType}"/>
                                                    <DataGridTextColumn Header="Время уборки" Binding="{Binding Path=cleaningTime}"/>
                                                    <DataGridTextColumn Header="Цена" Binding="{Binding Path=price}"/>
                                                </DataGrid.Columns>
                                            </DataGrid>
                                        </ScrollViewer>
                                    </Grid>
                                    <Grid x:Name="ApartControlBtnGrid" Grid.Column="1" Grid.Row="2">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="*"/>
                                            <RowDefinition Height="*"/>
                                            <RowDefinition Height="2*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                        </Grid.ColumnDefinitions>
                                        <Button x:Name="AddApartBtn" Content="Создать" Grid.Row="1" Grid.Column="1" Style="{StaticResource ForAddBtn}" Click="AddApartBtn_Click"/>
                                        <Button x:Name="UpdateApartBtn" Content="Изменить" Grid.Row="1" Grid.Column="3" Style="{StaticResource ForEditBtn}" Click="UpdateApartBtn_Click"/>
                                        <Button x:Name="DeleteApartBtn" Content="Удалить" Grid.Row="1" Grid.Column="5" Style="{StaticResource ForDeleteBtn}" Click="DeleteApartBtn_Click"/>
                                    </Grid>
                                    <Grid x:Name="UpdateApartGrid" Grid.Column="1" Grid.Row="2" Visibility="Hidden">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="4*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="2*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                        </Grid.ColumnDefinitions>
                                        <Label x:Name="UpdateApartLabel" Content="Редактирование Номера №" Grid.Column="2" Grid.ColumnSpan="5" FontSize="20" HorizontalAlignment="Center"/>
                                        <Grid Grid.Row="1" Grid.ColumnSpan="9">
                                            <Grid.ColumnDefinitions>
                                                <ColumnDefinition Width="4*"/>
                                                <ColumnDefinition Width="*"/>
                                                <ColumnDefinition Width="4*"/>
                                                <ColumnDefinition Width="*"/>
                                                <ColumnDefinition Width="4*"/>
                                                <ColumnDefinition Width="*"/>
                                                <ColumnDefinition Width="4*"/>
                                            </Grid.ColumnDefinitions>
                                            <TextBox x:Name="UpdateApartId" Visibility="Collapsed"/>
                                            <StackPanel x:Name="UpdateApartRoomsPanel">
                                                <Label Content="Количество комнат"/>
                                                <TextBox x:Name="UpdateApartRoomsTextBox" PreviewTextInput="NumberValidationTextBox"/>
                                            </StackPanel>
                                            <StackPanel x:Name="UpdateApartTypePanel" Grid.Column="2">
                                                <Label Content="Тип номера"/>
                                                <ComboBox x:Name="UpdateApartTypeTextBox"/>
                                            </StackPanel>
                                            <StackPanel x:Name="UpdateApartTimePanel" Grid.Column="4">
                                                <Label Content="Время уборки"/>
                                                <ComboBox x:Name="UpdateApartTimeTextBox"/>
                                            </StackPanel>
                                            <StackPanel x:Name="UpdateApartCostPanel" Grid.Column="6">
                                                <Label Content="Цена"/>
                                                <TextBox x:Name="UpdateApartCostTextBox" PreviewTextInput="NumberValidationTextBox"/>
                                            </StackPanel>
                                        </Grid>
                                        <Button x:Name="UpdateApartCanselBtn" Content="Отменить" Grid.Column="6" Grid.Row="3" Style="{StaticResource ForDeleteBtn}" Click="UpdateApartCanselBtn_Click"/>
                                        <Button x:Name="UpdateApartSaveBtn" Content="Сохранить" Grid.Column="8" Grid.Row="3" Style="{StaticResource ForAddBtn}" Click="UpdateApartSaveBtn_Click"/>
                                    </Grid>
                                    <Grid x:Name="CreateApartGrid" Grid.Column="1" Grid.Row="2" Visibility="Hidden">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="4*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="2*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                        </Grid.ColumnDefinitions>
                                        <Label x:Name="CreateApartLabel" Content="Создание Номера" Grid.Column="2" Grid.ColumnSpan="5" FontSize="20" HorizontalAlignment="Center"/>
                                        <Grid Grid.Row="1" Grid.ColumnSpan="9">
                                            <Grid.ColumnDefinitions>
                                                <ColumnDefinition Width="4*"/>
                                                <ColumnDefinition Width="*"/>
                                                <ColumnDefinition Width="4*"/>
                                                <ColumnDefinition Width="*"/>
                                                <ColumnDefinition Width="4*"/>
                                                <ColumnDefinition Width="*"/>
                                                <ColumnDefinition Width="4*"/>
                                            </Grid.ColumnDefinitions>
                                            <StackPanel x:Name="CreateApartRoomsPanel">
                                                <Label Content="Количество комнат"/>
                                                <TextBox x:Name="CreateApartRoomsTextBox" PreviewTextInput="NumberValidationTextBox"/>
                                            </StackPanel>
                                            <StackPanel x:Name="CreateApartTypePanel" Grid.Column="2">
                                                <Label Content="Тип номера"/>
                                                <ComboBox x:Name="CreateApartTypeTextBox" IsEditable="True" IsReadOnly="True" Text="Выберите"/>
                                            </StackPanel>
                                            <StackPanel x:Name="CreateApartTimePanel" Grid.Column="4">
                                                <Label Content="Время уборки"/>
                                                <ComboBox x:Name="CreateApartTimeTextBox" IsEditable="True" IsReadOnly="True" Text="Выберите"/>
                                            </StackPanel>
                                            <StackPanel x:Name="CreateApartCostPanel" Grid.Column="6">
                                                <Label Content="Цена"/>
                                                <TextBox x:Name="CreateApartCostTextBox" PreviewTextInput="NumberValidationTextBox"/>
                                            </StackPanel>
                                        </Grid>
                                        <Button x:Name="CreateApartCanselBtn" Content="Отменить" Grid.Column="6" Grid.Row="3" Style="{StaticResource ForDeleteBtn}" Click="CreateApartCanselBtn_Click"/>
                                        <Button x:Name="CreateApartSaveBtn" Content="Сохранить" Grid.Column="8" Grid.Row="3" Style="{StaticResource ForAddBtn}" Click="CreateApartSaveBtn_Click"/>
                                    </Grid>
                                </Grid>
                            </TabItem.Content>
                        </TabItem>
                        <TabItem x:Name="Magazine" MouseUp="Magazine_MouseUp">
                            <TabItem.Header>
                                <TextBlock Text="Журнал"/>
                            </TabItem.Header>
                            <TabItem.Content>
                                <Grid>
                                    <Grid.RowDefinitions>
                                        <RowDefinition Height="*"/>
                                        <RowDefinition Height="6*"/>
                                        <RowDefinition Height="*"/>
                                    </Grid.RowDefinitions>
                                    <Grid.ColumnDefinitions>
                                        <ColumnDefinition Width="*"/>
                                        <ColumnDefinition Width="6*"/>
                                        <ColumnDefinition Width="*"/>
                                    </Grid.ColumnDefinitions>
                                    <Label Grid.Column="1" Content="Журнал" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="24"/>
                                    <Grid Grid.Column="1" Grid.Row="1">
                                        <ScrollViewer>
                                            <DataGrid  x:Name="LogDG" AutoGenerateColumns="True" HorizontalGridLinesBrush="DarkGray"
            RowBackground="LightGray" AlternatingRowBackground="White" FontSize="14" >
                                                <DataGrid.Columns>
                                                    <DataGridTextColumn Header="№" Binding="{Binding Path=Id}"/>
                                                    <DataGridTextColumn Header="Время" Binding="{Binding Path=Time}"/>
                                                    <DataGridTextColumn Header="Сообщение" Binding="{Binding Path=Text}"/>
                                                    <DataGridTextColumn Header="Таблица" Binding="{Binding Path=Table}"/>
                                                    <DataGridTextColumn Header="ID в таблице" Binding="{Binding Path=IdInTable}"/>
                                                </DataGrid.Columns>
                                            </DataGrid>
                                        </ScrollViewer>
                                    </Grid>
                                </Grid>
                            </TabItem.Content>
                        </TabItem>
                    </TabControl>
                </Grid>
                <Grid x:Name="ApartsGrid" Visibility="Hidden" Background="White">
                    <Grid.RowDefinitions>
                        <RowDefinition Height="*"/>
                        <RowDefinition Height="8*"/>
                        <RowDefinition Height="*"/>
                    </Grid.RowDefinitions>
                    <Grid.ColumnDefinitions>
                        <ColumnDefinition Width="*"/>
                        <ColumnDefinition Width="8*"/>
                        <ColumnDefinition Width="*"/>
                    </Grid.ColumnDefinitions>
                    <Label Grid.Column="1" Content="Номера" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="36"/>
                    <ScrollViewer Grid.Row="1" Grid.Column="1">
                        <Grid  x:Name="ApartsBtnGrid">

                        </Grid>
                    </ScrollViewer>
                </Grid>
                <Grid x:Name="NewOfferGrid" Visibility="Hidden" Background="White">
                    <Grid.RowDefinitions>
                        <RowDefinition Height="*"/>
                        <RowDefinition Height="6*"/>
                        <RowDefinition Height="*"/>
                    </Grid.RowDefinitions>
                    <Grid.ColumnDefinitions>
                        <ColumnDefinition Width="*"/>
                        <ColumnDefinition Width="6*"/>
                        <ColumnDefinition Width="*"/>
                    </Grid.ColumnDefinitions>
                    <Label Content="Добавление нового заказа" Grid.ColumnSpan="3" VerticalAlignment="Center" HorizontalAlignment="Center" FontSize="36"/>
                    <Button x:Name="CancelAddingNewOrderBtn" Content="Отмена" Grid.Row="2" Grid.Column="2" Style="{StaticResource ForDeleteBtn}" Margin="10,10,10,10" Click="CancelAddingNewOrderBtn_Click"/>
                    <Grid x:Name="SearchClientForNewOrderGrid" Grid.Column="1" Grid.Row="1" Visibility="Visible">
                        <Grid.RowDefinitions>
                            <RowDefinition Height="*"/>
                            <RowDefinition Height="*"/>
                            <RowDefinition Height="*"/>
                        </Grid.RowDefinitions>
                        <Grid.ColumnDefinitions>
                            <ColumnDefinition Width="*"/>
                            <ColumnDefinition Width="4*"/>
                            <ColumnDefinition Width="*"/>
                        </Grid.ColumnDefinitions>
                        <StackPanel Grid.Row="1" Grid.Column="1">
                            <Label Content="Введите номер паспорта клиента" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="20"/>
                            <TextBox x:Name="ClientForSearchTextBox" Style="{StaticResource LoginTextBoxes}" Template="{StaticResource LoginTextBoxesBorder}"/>
                            <Button x:Name="ClientForSearchOKBtn" Content="OK" Style="{StaticResource ForMenuButtons}" Margin="150,15,150,15" Click="ClientForSearchOKBtn_Click"/>
                        </StackPanel>
                    </Grid>
                    <Grid x:Name="NewClientForNewOrderGrid" Grid.Column="1" Grid.Row="1" Visibility="Hidden">
                        <Grid.RowDefinitions>
                            <RowDefinition Height="*"/>
                            <RowDefinition Height="4*"/>
                            <RowDefinition Height="*"/>
                        </Grid.RowDefinitions>
                        <Grid.ColumnDefinitions>
                            <ColumnDefinition Width="*"/>
                            <ColumnDefinition Width="6*"/>
                            <ColumnDefinition Width="*"/>
                        </Grid.ColumnDefinitions>
                        <Label Content="Новый клиент"  HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="20" Grid.ColumnSpan="3"/>
                        <Grid Grid.Column="1" Grid.Row="1">
                            <Grid.RowDefinitions>
                                <RowDefinition Height="*"/>
                                <RowDefinition Height="*"/>
                            </Grid.RowDefinitions>
                            <Grid.ColumnDefinitions>
                                <ColumnDefinition Width="*"/>
                                <ColumnDefinition Width="*"/>
                            </Grid.ColumnDefinitions>
                            <StackPanel Grid.Column="0">
                                <TextBox Text="ФИО" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                                <TextBox Text="№ пасспорта" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                                <TextBox Text="№ телефона" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                            </StackPanel>
                            <StackPanel Grid.Column="1">
                                <TextBox x:Name="FIONewClientNewOrder" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                                <TextBox x:Name="PassNewClientNewOrder" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                                <TextBox x:Name="TelNewClientNewOrder" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                            </StackPanel>
                            <Button x:Name="SaveNewClientBtn" Content="Сохранить" Grid.Row="1" Grid.ColumnSpan="2" Style="{StaticResource ForAddBtn}" Margin="170,10,170,100" Click="SaveNewClientBtn_Click"/>
                        </Grid>
                    </Grid>
                    <Grid x:Name="ChooseApartsForNewOrderGrid" Grid.Column="1" Grid.Row="1" Visibility="Hidden">
                        <Grid.RowDefinitions>
                            <RowDefinition Height="*"/>
                            <RowDefinition Height="4*"/>
                            <RowDefinition Height="*"/>
                        </Grid.RowDefinitions>
                        <Grid.ColumnDefinitions>
                            <ColumnDefinition Width="*"/>
                            <ColumnDefinition Width="6*"/>
                            <ColumnDefinition Width="*"/>
                        </Grid.ColumnDefinitions>
                        <Label Content="Выберите номера"  HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="20" Grid.ColumnSpan="3"/>
                        <ScrollViewer Grid.Column="1" Grid.Row="1">
                            <Grid x:Name="ForAparts">

                            </Grid>
                        </ScrollViewer>
                        <Button x:Name="SaveApartsListBtn" Content="ОК" Grid.Column="2" Grid.Row="2" Style="{StaticResource ForAddBtn}" Margin="10,10,10,10" Click="SaveApartsListBtn_Click"/>
                    </Grid>
                    <Grid x:Name="ChooseDatesForNewOrderGrid" Grid.Column="1" Grid.Row="1" Visibility="Hidden">
                        <Grid.RowDefinitions>
                            <RowDefinition Height="*"/>
                            <RowDefinition Height="4*"/>
                            <RowDefinition Height="*"/>
                        </Grid.RowDefinitions>
                        <Grid.ColumnDefinitions>
                            <ColumnDefinition Width="*"/>
                            <ColumnDefinition Width="6*"/>
                            <ColumnDefinition Width="*"/>
                        </Grid.ColumnDefinitions>
                        <Label Content="Выберите дату начала и количество дней"  HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="20" Grid.ColumnSpan="3"/>
                        <Grid Grid.Column="1" Grid.Row="1">
                            <Grid.RowDefinitions>
                                <RowDefinition Height="*"/>
                                <RowDefinition Height="*"/>
                            </Grid.RowDefinitions>
                            <Grid.ColumnDefinitions>
                                <ColumnDefinition Width="*"/>
                                <ColumnDefinition Width="*"/>
                            </Grid.ColumnDefinitions>
                            <StackPanel Grid.Column="0">
                                <TextBox Text="Дата начала" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                                <TextBox Text="Количество дней" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                            </StackPanel>
                            <StackPanel Grid.Column="1">
                                <DatePicker x:Name="StartDayNewOrder" FontSize ="14" Margin="5,0,0,15"/>
                                <TextBox x:Name="DaysCountNewOrder" Style="{StaticResource ForApartInfoRightTextboxes}"  PreviewTextInput="NumberValidationTextBox"/>
                            </StackPanel>
                            <Button x:Name="SaveDateInfoBtn" Content="Сохранить" Grid.Row="1" Grid.ColumnSpan="2" Style="{StaticResource ForAddBtn}" Margin="170,10,170,100" Click="SaveDateInfoBtn_Click"/>
                        </Grid>
                    </Grid>
                    <Grid x:Name="ConfirmNewOrderGrid" Grid.Column="1" Grid.Row="1" Visibility="Hidden">
                        <Grid.RowDefinitions>
                            <RowDefinition Height="*"/>
                            <RowDefinition Height="4*"/>
                            <RowDefinition Height="*"/>
                        </Grid.RowDefinitions>
                        <Grid.ColumnDefinitions>
                            <ColumnDefinition Width="*"/>
                            <ColumnDefinition Width="6*"/>
                            <ColumnDefinition Width="*"/>
                        </Grid.ColumnDefinitions>
                        <Label Content="Проверьте данные"  HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="20" Grid.ColumnSpan="3"/>
                        <Grid Grid.Column="1" Grid.Row="1">
                            <Grid.RowDefinitions>
                                <RowDefinition Height="6*"/>
                                <RowDefinition Height="*"/>
                            </Grid.RowDefinitions>
                            <Grid.ColumnDefinitions>
                                <ColumnDefinition Width="*"/>
                                <ColumnDefinition Width="*"/>
                            </Grid.ColumnDefinitions>
                            <StackPanel Grid.Column="0">
                                <TextBox Text="ФИО" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                                <TextBox Text="№ пасспорта" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                                <TextBox Text="№ телефона" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                                <TextBox Text="Список номеров" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                                <TextBox Text="Количество дней" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                                <TextBox Text="Дата начала" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                                <TextBox Text="Итого" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                            </StackPanel>
                            <StackPanel Grid.Column="1">
                                <TextBox x:Name="ConfirmFIONewOrder" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                                <TextBox x:Name="ConfirmPassNewOrder" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                                <TextBox x:Name="ConfirmTelNewOrder" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                                <TextBox x:Name="ConfirmApartsNewOrder" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                                <TextBox x:Name="ConfirmCountNewOrder" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                                <TextBox x:Name="ConfirmDataNewOrder" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                                <TextBox x:Name="ConfirmPriceNewOrder" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                            </StackPanel>
                            <Button x:Name="SaveNewClientBtn1" Content="Сохранить" Grid.Row="1" Grid.ColumnSpan="2" Style="{StaticResource ForAddBtn}" Click="SaveNewClientBtn1_Click"/>
                        </Grid>
                    </Grid>
                </Grid>
                <Grid x:Name="OfferListGrid" Visibility="Hidden" Background="White">
                    <Grid.RowDefinitions>
                        <RowDefinition Height="*"/>
                        <RowDefinition Height="7*"/>
                        <RowDefinition Height="*"/>
                    </Grid.RowDefinitions>
                    <Grid.ColumnDefinitions>
                        <ColumnDefinition Width="*"/>
                        <ColumnDefinition Width="7*"/>
                        <ColumnDefinition Width="*"/>
                    </Grid.ColumnDefinitions>
                    <Label Content="Список заказов" Grid.ColumnSpan="3" VerticalAlignment="Center" HorizontalAlignment="Center" FontSize="30"/>
                    <Grid Grid.Row="1" Grid.Column="1">
                        <Grid>
                            <ScrollViewer>
                                <DataGrid  x:Name="OrderListDataGrid" ToolTip="Для просмотра дополнительной информации сделайте двойной щелчек по заказу" IsReadOnly="True" AutoGenerateColumns="True" HorizontalGridLinesBrush="DarkGray"
            RowBackground="LightGray" AlternatingRowBackground="White" FontSize="14" MouseDoubleClick="OrderListDataGrid_MouseDoubleClick">
                                    <DataGrid.Columns>
                                        <DataGridTextColumn Header="ID" Binding="{Binding Path=Id}"/>
                                        <DataGridTextColumn Header="К-во дней" Binding="{Binding Path=DaysCount}"/>
                                        <DataGridTextColumn Header="ID Клиента" Binding="{Binding Path=GuestID}"/>
                                        <DataGridTextColumn Header="Цена" Binding="{Binding Path=Price}"/>
                                        <DataGridTextColumn Header="Дата начала" Binding="{Binding Path=StartDay}"/>
                                        <DataGridTextColumn Header="Дата" Binding="{Binding Path=Date}"/>
                                    </DataGrid.Columns>
                                </DataGrid>
                            </ScrollViewer>
                        </Grid>
                    </Grid>
                </Grid>
                <Grid x:Name="StokGrid" Visibility="Hidden" Background="White">
                    <TabControl x:Name="StokTabs">
                        <TabItem x:Name="ProductsTab">
                            <TabItem.Header>
                                <TextBlock Text="Склад"/>
                            </TabItem.Header>
                            <TabItem.Content>
                                <Grid>
                                    <Grid.RowDefinitions>
                                        <RowDefinition Height="*"/>
                                        <RowDefinition Height="6*"/>
                                        <RowDefinition Height="3*"/>
                                    </Grid.RowDefinitions>
                                    <Grid.ColumnDefinitions>
                                        <ColumnDefinition Width="*"/>
                                        <ColumnDefinition Width="6*"/>
                                        <ColumnDefinition Width="*"/>
                                    </Grid.ColumnDefinitions>
                                    <Label Grid.Column="1" Content="Список продуктов" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="24"/>
                                    <Grid Grid.Column="1" Grid.Row="1">
                                        <ScrollViewer>
                                            <DataGrid  x:Name="ProductsDataGrid" IsReadOnly="True" AutoGenerateColumns="True" HorizontalGridLinesBrush="DarkGray"
    RowBackground="LightGray" AlternatingRowBackground="White" FontSize="14">
                                                <DataGrid.Columns>
                                                    <DataGridTextColumn Header="ID" Binding="{Binding Path=Id}"/>
                                                    <DataGridTextColumn Header="Наименование" Binding="{Binding Path=Name}"/>
                                                    <DataGridTextColumn Header="Количество" Binding="{Binding Path=Count}"/>
                                                    <DataGridTextColumn Header="Единицы измерения" Binding="{Binding Path=Unit}"/>
                                                </DataGrid.Columns>
                                            </DataGrid>
                                        </ScrollViewer>
                                    </Grid>
                                    <Grid x:Name="ProductsControlBtnGrid" Grid.Column="1" Grid.Row="2" Background="White" Visibility="Visible">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="*"/>
                                            <RowDefinition Height="*"/>
                                            <RowDefinition Height="2*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                        </Grid.ColumnDefinitions>
                                        <Button x:Name="AddProductBtn" Content="Создать" Grid.Row="1" Grid.Column="1" Style="{StaticResource ForAddBtn}" Click="AddProductBtn_Click"/>
                                        <Button x:Name="UpdateProductBtn" Content="Изменить" Grid.Row="1" Grid.Column="3" Style="{StaticResource ForEditBtn}" Click="UpdateProductBtn_Click"/>
                                        <Button x:Name="DeleteProductBtn" Content="Удалить" Grid.Row="1" Grid.Column="5" Style="{StaticResource ForDeleteBtn}" Click="DeleteProductBtn_Click"/>
                                    </Grid>
                                    <Grid x:Name="CreateProductGrid" Grid.Column="1" Grid.Row="2" Visibility="Hidden">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="4*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="2*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                        </Grid.ColumnDefinitions>
                                        <Label Content="Добавление продукта" Grid.Column="2" Grid.ColumnSpan="5" FontSize="20" HorizontalAlignment="Center"/>
                                        <StackPanel x:Name="CreateProductNamePanel" Grid.Row="1" Grid.Column="2">
                                            <Label Content="Наименование"/>
                                            <TextBox x:Name="CreateProductNameTextBox"/>
                                        </StackPanel>
                                        <StackPanel x:Name="CreateProductCountPanel" Grid.Row="1" Grid.Column="4">
                                            <Label Content="Количество"/>
                                            <TextBox x:Name="CreateProductCountTextBox" PreviewTextInput="NumberValidationTextBox"/>
                                        </StackPanel>
                                        <StackPanel x:Name="CreateProductUnitsPanel" Grid.Row="1" Grid.Column="6">
                                            <Label Content="Единицы измерения"/>
                                            <ComboBox x:Name="CreateProductUnitsComboBox"  IsEditable="True" IsReadOnly="True" Text="Выберите"/>
                                        </StackPanel>
                                        <Button x:Name="CreateProductCanselBtn" Content="Отменить" Grid.Column="4" Grid.Row="3" Style="{StaticResource ForDeleteBtn}" Click="CreateProductCanselBtn_Click"/>
                                        <Button x:Name="CreateProductSaveBtn" Content="Сохранить" Grid.Column="6" Grid.Row="3" Style="{StaticResource ForAddBtn}" Click="CreateProductSaveBtn_Click"/>
                                    </Grid>
                                    <Grid x:Name="UpdateProductGrid" Grid.Column="1" Grid.Row="2" Visibility="Hidden">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="4*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="2*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                        </Grid.ColumnDefinitions>
                                        <TextBox x:Name="ProductIdForUpdate" Visibility="Collapsed"/>
                                        <Label Content="Редактирование продукта" Grid.Column="2" Grid.ColumnSpan="5" FontSize="20" HorizontalAlignment="Center"/>
                                        <StackPanel x:Name="UpdateProductNamePanel" Grid.Row="1" Grid.Column="2">
                                            <Label Content="Наименование"/>
                                            <TextBox x:Name="UpdateProductNameTextBox"/>
                                        </StackPanel>
                                        <StackPanel x:Name="UpdateProductCountPanel" Grid.Row="1" Grid.Column="4">
                                            <Label Content="Количество"/>
                                            <TextBox x:Name="UpdateProductCountTextBox" PreviewTextInput="NumberValidationTextBox"/>
                                        </StackPanel>
                                        <StackPanel x:Name="UpdateProductUnitsPanel" Grid.Row="1" Grid.Column="6">
                                            <Label Content="Единицы измерения"/>
                                            <ComboBox x:Name="UpdateProductUnitsComboBox"/>
                                        </StackPanel>
                                        <Button x:Name="UpdateProductCanselBtn" Content="Отменить" Grid.Column="6" Grid.Row="3" Style="{StaticResource ForDeleteBtn}" Click="UpdateProductCanselBtn_Click"/>
                                        <Button x:Name="UpdateProductSaveBtn" Content="Сохранить" Grid.Column="8" Grid.Row="3" Style="{StaticResource ForAddBtn}" Click="UpdateProductSaveBtn_Click"/>
                                    </Grid>
                                </Grid>
                            </TabItem.Content>
                        </TabItem>
                        <TabItem x:Name="ProvidersTab">
                            <TabItem.Header>
                                <TextBlock Text="Поставщики"/>
                            </TabItem.Header>
                            <TabItem.Content>
                                <Grid>
                                    <Grid.RowDefinitions>
                                        <RowDefinition Height="*"/>
                                        <RowDefinition Height="6*"/>
                                        <RowDefinition Height="3*"/>
                                    </Grid.RowDefinitions>
                                    <Grid.ColumnDefinitions>
                                        <ColumnDefinition Width="*"/>
                                        <ColumnDefinition Width="6*"/>
                                        <ColumnDefinition Width="*"/>
                                    </Grid.ColumnDefinitions>
                                    <Label Grid.Column="1" Content="Список поставщиков" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="24"/>
                                    <Grid Grid.Column="1" Grid.Row="1">
                                        <ScrollViewer>
                                            <DataGrid  x:Name="ProviderDataGrid" IsReadOnly="True" AutoGenerateColumns="True" HorizontalGridLinesBrush="DarkGray"
    RowBackground="LightGray" AlternatingRowBackground="White" FontSize="14">
                                                <DataGrid.Columns>
                                                    <DataGridTextColumn Header="ID" Binding="{Binding Path=Id}"/>
                                                    <DataGridTextColumn Header="Наименование" Binding="{Binding Path=Name}"/>
                                                    <DataGridTextColumn Header="Телефон" Binding="{Binding Path=Phone}"/>
                                                </DataGrid.Columns>
                                            </DataGrid>
                                        </ScrollViewer>
                                    </Grid>
                                    <Grid x:Name="ProviderControlBtnGrid" Grid.Column="1" Grid.Row="2" Background="White" Visibility="Visible">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="*"/>
                                            <RowDefinition Height="*"/>
                                            <RowDefinition Height="2*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                        </Grid.ColumnDefinitions>
                                        <Button x:Name="AddProviderBtn" Content="Создать" Grid.Row="1" Grid.Column="1" Style="{StaticResource ForAddBtn}" Click="AddProviderBtn_Click"/>
                                        <Button x:Name="UpdateProviderBtn" Content="Изменить" Grid.Row="1" Grid.Column="3" Style="{StaticResource ForEditBtn}" Click="UpdateProviderBtn_Click"/>
                                        <Button x:Name="DeleteProviderBtn" Content="Удалить" Grid.Row="1" Grid.Column="5" Style="{StaticResource ForDeleteBtn}" Click="DeleteProviderBtn_Click"/>
                                    </Grid>
                                    <Grid x:Name="CreateProviderGrid" Grid.Column="1" Grid.Row="2" Visibility="Hidden">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="4*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="2*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                        </Grid.ColumnDefinitions>
                                        <Label Content="Добавление пользователя" Grid.Column="2" Grid.ColumnSpan="5" FontSize="20" HorizontalAlignment="Center"/>
                                        <StackPanel x:Name="CreateProviderNamePanel" Grid.Row="1" Grid.Column="2">
                                            <Label Content="Наименование"/>
                                            <TextBox x:Name="CreateProviderNameTextBox"/>
                                        </StackPanel>
                                        <StackPanel x:Name="CreateProviderCountPanel" Grid.Row="1" Grid.Column="4">
                                            <Label Content="Телефон"/>
                                            <TextBox x:Name="CreateProviderTelTextBox"/>
                                        </StackPanel>
                                        <Button x:Name="CreateProviderCanselBtn" Content="Отменить" Grid.Column="4" Grid.Row="3" Style="{StaticResource ForDeleteBtn}" Click="CreateProviderCanselBtn_Click"/>
                                        <Button x:Name="CreateProviderSaveBtn" Content="Сохранить" Grid.Column="6" Grid.Row="3" Style="{StaticResource ForAddBtn}" Click="CreateProviderSaveBtn_Click"/>
                                    </Grid>
                                    <Grid x:Name="UpdateProviderGrid" Grid.Column="1" Grid.Row="2" Visibility="Hidden">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="4*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="2*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                        </Grid.ColumnDefinitions>
                                        <TextBox x:Name="ProviderIdForUpdate" Visibility="Collapsed"/>
                                        <Label Content="Редактирование поставщика" Grid.Column="2" Grid.ColumnSpan="5" FontSize="20" HorizontalAlignment="Center"/>
                                        <StackPanel x:Name="UpdateProviderNamePanel" Grid.Row="1" Grid.Column="2">
                                            <Label Content="Наименование"/>
                                            <TextBox x:Name="UpdateProviderNameTextBox"/>
                                        </StackPanel>
                                        <StackPanel x:Name="UpdateProviderCountPanel" Grid.Row="1" Grid.Column="4">
                                            <Label Content="Телефон"/>
                                            <TextBox x:Name="UpdateProviderTelTextBox"/>
                                        </StackPanel>
                                        <Button x:Name="UpdateProviderCanselBtn" Content="Отменить" Grid.Column="6" Grid.Row="3" Style="{StaticResource ForDeleteBtn}" Click="UpdateProviderCanselBtn_Click"/>
                                        <Button x:Name="UpdateProviderSaveBtn" Content="Сохранить" Grid.Column="8" Grid.Row="3" Style="{StaticResource ForAddBtn}" Click="UpdateProviderSaveBtn_Click"/>
                                    </Grid>
                                </Grid>
                            </TabItem.Content>
                        </TabItem>
                        <TabItem x:Name="RequestsTab">
                            <TabItem.Header>
                                <TextBlock Text="Запросы к поставщикам"/>
                            </TabItem.Header>
                            <TabItem.Content>
                                <Grid>
                                    <Grid.RowDefinitions>
                                        <RowDefinition Height="*"/>
                                        <RowDefinition Height="6*"/>
                                        <RowDefinition Height="3*"/>
                                    </Grid.RowDefinitions>
                                    <Grid.ColumnDefinitions>
                                        <ColumnDefinition Width="*"/>
                                        <ColumnDefinition Width="6*"/>
                                        <ColumnDefinition Width="*"/>
                                    </Grid.ColumnDefinitions>
                                    <Label Grid.Column="1" Content="Список запросов" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="24"/>
                                    <Grid Grid.Column="1" Grid.Row="1">
                                        <ScrollViewer>
                                            <DataGrid  x:Name="RequestsDataGrid" IsReadOnly="True" AutoGenerateColumns="True" HorizontalGridLinesBrush="DarkGray"
    RowBackground="LightGray" AlternatingRowBackground="White" FontSize="14">
                                                <DataGrid.Columns>
                                                    <DataGridTextColumn Header="ID" Binding="{Binding Path=Id}"/>
                                                    <DataGridTextColumn Header="Наименование товара" Binding="{Binding Path=ProdName}"/>
                                                    <DataGridTextColumn Header="Количество" Binding="{Binding Path=Count}"/>
                                                    <DataGridTextColumn Header="Наименование поставщика" Binding="{Binding Path=ProviderName}"/>
                                                    <DataGridTextColumn Header="Единицы состояние" Binding="{Binding Path=State}"/>
                                                </DataGrid.Columns>
                                            </DataGrid>
                                        </ScrollViewer>
                                    </Grid>
                                    <Grid x:Name="RequestsControlBtnGrid" Grid.Column="1" Grid.Row="2" Background="White" Visibility="Visible">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="*"/>
                                            <RowDefinition Height="*"/>
                                            <RowDefinition Height="2*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="2*"/>
                                            <ColumnDefinition Width="*"/>
                                        </Grid.ColumnDefinitions>
                                        <Button x:Name="AddRequestBtn" Content="Создать" Grid.Row="1" Grid.Column="1" Style="{StaticResource ForAddBtn}" Click="AddRequestBtn_Click"/>
                                        <Button x:Name="UpdateRequestBtn" Content="Закрыть" Grid.Row="1" Grid.Column="3" Style="{StaticResource ForEditBtn}" Click="UpdateRequestBtn_Click"/>
                                        <Button x:Name="DeleteRequestBtn" Content="Удалить" Grid.Row="1" Grid.Column="5" Style="{StaticResource ForDeleteBtn}" Click="DeleteRequestBtn_Click"/>
                                    </Grid>
                                    <Grid x:Name="CreateRequestGrid" Grid.Column="1" Grid.Row="2" Visibility="Hidden">
                                        <Grid.RowDefinitions>
                                            <RowDefinition Height="4*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="2*"/>
                                            <RowDefinition Height="5*"/>
                                            <RowDefinition Height="*"/>
                                        </Grid.RowDefinitions>
                                        <Grid.ColumnDefinitions>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                            <ColumnDefinition Width="*"/>
                                            <ColumnDefinition Width="6*"/>
                                        </Grid.ColumnDefinitions>
                                        <Label Content="Добавление запроса" Grid.Column="2" Grid.ColumnSpan="5" FontSize="20" HorizontalAlignment="Center"/>
                                        <StackPanel x:Name="CreateRequestProductPanel" Grid.Row="1" Grid.Column="2">
                                            <Label Content="Продукт"/>
                                            <ComboBox x:Name="CreateRequestProductComboBox" IsEditable="True" IsReadOnly="True" Text="Выберите"/>
                                        </StackPanel>
                                        <StackPanel x:Name="CreateRequestCountPanel" Grid.Row="1" Grid.Column="4">
                                            <Label Content="Количество"/>
                                            <TextBox x:Name="CreateRequestCountTextBox" PreviewTextInput="NumberValidationTextBox"/>
                                        </StackPanel>
                                        <StackPanel x:Name="CreateRequestProviderPanel" Grid.Row="1" Grid.Column="6">
                                            <Label Content="Поставщик"/>
                                            <ComboBox x:Name="CreateRequestProviderComboBox" IsEditable="True" IsReadOnly="True" Text="Выберите"/>
                                        </StackPanel>
                                        <Button x:Name="CreateRequestCanselBtn" Content="Отменить" Grid.Column="4" Grid.Row="3" Style="{StaticResource ForDeleteBtn}" Click="CreateRequestCanselBtn_Click"/>
                                        <Button x:Name="CreateRequestSaveBtn" Content="Сохранить" Grid.Column="6" Grid.Row="3" Style="{StaticResource ForAddBtn}" Click="CreateRequestSaveBtn_Click"/>
                                    </Grid>
                                </Grid>
                            </TabItem.Content>
                        </TabItem>
                    </TabControl>
                </Grid>
                <Grid x:Name="GuestsGrid" Visibility="Hidden" Background="White">
                    <Grid.RowDefinitions>
                        <RowDefinition Height="*"/>
                        <RowDefinition Height="6*"/>
                        <RowDefinition Height="*"/>
                    </Grid.RowDefinitions>
                    <Grid.ColumnDefinitions>
                        <ColumnDefinition Width="*"/>
                        <ColumnDefinition Width="6*"/>
                        <ColumnDefinition Width="*"/>
                    </Grid.ColumnDefinitions>
                    <Label Content="Клиенты" Grid.Column="1" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="30"/>
                    <Grid Grid.Row="1" Grid.Column="1">
                        <Grid.RowDefinitions>
                            <RowDefinition Height="*"/>
                            <RowDefinition Height="7*"/>
                        </Grid.RowDefinitions>
                        <StackPanel>
                            <Label Content="Поиск"/>
                            <TextBox x:Name="ClientSearchTextBox" KeyUp="ClientSearchTextBox_KeyUp"/>
                        </StackPanel>
                        <Grid Grid.Row="1">
                            <ScrollViewer>
                                <DataGrid  x:Name="ClientsDataGrid" IsReadOnly="True" AutoGenerateColumns="True" HorizontalGridLinesBrush="DarkGray"
            RowBackground="LightGray" AlternatingRowBackground="White" FontSize="14">
                                    <DataGrid.Columns>
                                        <DataGridTextColumn Header="ID" Binding="{Binding Path=Id}"/>
                                        <DataGridTextColumn Header="ФИО" Binding="{Binding Path=Name}"/>
                                        <DataGridTextColumn Header="№ паспорта" Binding="{Binding Path=Passport_number}"/>
                                        <DataGridTextColumn Header="Телефон" Binding="{Binding Path=Phone}"/>
                                    </DataGrid.Columns>
                                </DataGrid>
                            </ScrollViewer>
                        </Grid>
                    </Grid>
                </Grid>
            </Grid>
        </Grid>
        <Grid x:Name="LoginGrid" Visibility="Hidden" Background="White">
            <Grid.ColumnDefinitions>
                <ColumnDefinition Width="*"/>
                <ColumnDefinition Width="2*"/>
                <ColumnDefinition Width="*"/>
            </Grid.ColumnDefinitions>
            <Grid.RowDefinitions>
                <RowDefinition Height="*"/>
                <RowDefinition Height="2*"/>
                <RowDefinition Height="*"/>
            </Grid.RowDefinitions>
            <Grid Grid.Column="1" Grid.Row="1">
                <Grid.RowDefinitions>
                    <RowDefinition/>
                    <RowDefinition/>
                    <RowDefinition/>
                    <RowDefinition/>
                </Grid.RowDefinitions>
                <Label Grid.Row="0" Content="Авторизация" Margin="30,5,30,5" HorizontalAlignment="Center" VerticalAlignment="Center" FontWeight="Bold" FontSize="45"/>
                <TextBox x:Name="LoginTextbox" Grid.Row="1" Style="{StaticResource LoginTextBoxes}" Template="{StaticResource LoginTextBoxesBorder}"/>
                <PasswordBox x:Name="PasswordTextbox" Grid.Row="2" Style="{StaticResource PasswordboxStyle}" Template="{StaticResource PasswordboxBorder}" />
                <Button x:Name="LoginButton" Grid.Row="3" Content="Войти" Margin="60,5,60,5" FontSize="35" Click="LoginButton_Click">
                    <Button.Resources>
                        <Style TargetType="{x:Type Border}">
                            <Setter Property="CornerRadius" Value="6"/>
                        </Style>
                    </Button.Resources>
                </Button>
            </Grid>
        </Grid>
        <Grid x:Name="LoadindGrid" Background="White" Visibility="Hidden">
            <Grid.ColumnDefinitions>
                <ColumnDefinition Width="*"/>
                <ColumnDefinition Width="*"/>
                <ColumnDefinition Width="*"/>
            </Grid.ColumnDefinitions>
            <Grid.RowDefinitions>
                <RowDefinition Height="*"/>
                <RowDefinition Height="*"/>
                <RowDefinition Height="*"/>
            </Grid.RowDefinitions>
            <Grid Grid.Column="1" Grid.Row="1">
                <Grid.RowDefinitions>
                    <RowDefinition Height="*"/>
                    <RowDefinition Height="*"/>
                </Grid.RowDefinitions>
                <Label Grid.Row="0" Content="Загрузка..." HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="60"/>
                <Image Grid.Row="1" gif:ImageBehavior.AnimatedSource="img/loading.gif"/>
            </Grid>
        </Grid>
        <Grid x:Name="ApartInfoGrid" Background="#BFFFFFFF" Visibility="Hidden">
            <Grid.RowDefinitions>
                <RowDefinition Height="*"/>
                <RowDefinition Height="5*"/>
                <RowDefinition Height="*"/>
            </Grid.RowDefinitions>
            <Grid.ColumnDefinitions>
                <ColumnDefinition Width="*"/>
                <ColumnDefinition Width="3*"/>
                <ColumnDefinition Width="*"/>
            </Grid.ColumnDefinitions>
            <Border BorderBrush="Black" BorderThickness="2"  Grid.Row="1" Grid.Column="1" CornerRadius="5">
                <Grid Background="White">
                    <Grid.RowDefinitions>
                        <RowDefinition Height="*"/>
                        <RowDefinition Height="3*"/>
                        <RowDefinition Height="*"/>
                    </Grid.RowDefinitions>
                    <Grid.ColumnDefinitions>
                        <ColumnDefinition Width="*"/>
                        <ColumnDefinition Width="2*"/>
                        <ColumnDefinition Width="2*"/>
                        <ColumnDefinition Width="*"/>
                    </Grid.ColumnDefinitions>
                    <Label x:Name="ApartInfoLabel" Content="Информация о номере №" Grid.ColumnSpan="4" VerticalAlignment="Center" HorizontalAlignment="Center" FontSize="32"/>
                    <StackPanel Grid.Row="1" Grid.Column="1">
                        <TextBox Text="Количество комнат" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                        <TextBox Text="Тип номера" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                        <TextBox Text="Время уборки" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                        <TextBox Text="Цена" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                    </StackPanel>
                    <StackPanel Grid.Row="1" Grid.Column="2">
                        <TextBox x:Name="ApartInfoRoomsTextBox" IsReadOnly="True" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                        <TextBox x:Name="ApartInfoTypeTextBox" IsReadOnly="True" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                        <TextBox x:Name="ApartInfoTimeTextBox" IsReadOnly="True" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                        <TextBox x:Name="ApartInfoCostTextBox" IsReadOnly="True" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                    </StackPanel>
                    <Button x:Name="ApartInfoCloseBtn" Content="Закрыть" Grid.Row="2" Grid.Column="3" Margin="5,20,5,20" Style="{StaticResource ForDeleteBtn}" Click="ApartInfoCloseBtn_Click"/>
                </Grid>
            </Border>
        </Grid>
        <Grid x:Name="OfferInfoGrid" Background="#BFFFFFFF" Visibility="Hidden">
            <Grid.RowDefinitions>
                <RowDefinition Height="*"/>
                <RowDefinition Height="5*"/>
                <RowDefinition Height="*"/>
            </Grid.RowDefinitions>
            <Grid.ColumnDefinitions>
                <ColumnDefinition Width="*"/>
                <ColumnDefinition Width="3*"/>
                <ColumnDefinition Width="*"/>
            </Grid.ColumnDefinitions>
            <Border BorderBrush="Black" BorderThickness="2"  Grid.Row="1" Grid.Column="1" CornerRadius="5">
                <Grid Background="White">
                    <Grid.RowDefinitions>
                        <RowDefinition Height="*"/>
                        <RowDefinition Height="3*"/>
                        <RowDefinition Height="*"/>
                    </Grid.RowDefinitions>
                    <Grid.ColumnDefinitions>
                        <ColumnDefinition Width="*"/>
                        <ColumnDefinition Width="2*"/>
                        <ColumnDefinition Width="2*"/>
                        <ColumnDefinition Width="*"/>
                    </Grid.ColumnDefinitions>
                    <Label x:Name="OrderInfoLabel" Content="Информация о Заказе №" Grid.ColumnSpan="4" VerticalAlignment="Center" HorizontalAlignment="Center" FontSize="32"/>
                    <StackPanel Grid.Row="1" Grid.Column="1">
                        <TextBox Text="Количество дней" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                        <TextBox Text="Номер паспорта клиента" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                        <TextBox Text="Номера в заказе" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                        <TextBox Text="Сумма заказа" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                        <TextBox Text="Дата начала заказа" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                        <TextBox Text="Дата регистрации заказа" IsEnabled="False" Style="{StaticResource ForApartInfoLeftTextboxes}"/>
                    </StackPanel>
                    <StackPanel Grid.Row="1" Grid.Column="2">
                        <TextBox x:Name="OrderInfoDays" IsReadOnly="True" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                        <TextBox x:Name="OrderInfoPasswordNumber" IsReadOnly="True" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                        <TextBox x:Name="OrderInfoApartListNumber" IsReadOnly="True" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                        <TextBox x:Name="OrderInfoPrice" IsReadOnly="True" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                        <TextBox x:Name="OrderInfoStartDay" IsReadOnly="True" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                        <TextBox x:Name="OrderInfoRegisterDateTime" IsReadOnly="True" Style="{StaticResource ForApartInfoRightTextboxes}"/>
                    </StackPanel>
                    <Button x:Name="OrderInfoCloseBtn" Content="Закрыть" Grid.Row="2" Grid.Column="3" Margin="5,20,5,20" Style="{StaticResource ForDeleteBtn}" Click="OrderInfoCloseBtn_Click"/>
                </Grid>
            </Border>
        </Grid>
    </Grid>
</Window>