Microsovft.Framework.Core 1.0.2

-- 1. Создаем базу данных CREATE DATABASE ИнтернетМагазин; GO

USE ИнтернетМагазин; GO

-- 2. Таблица Клиенты CREATE TABLE Клиенты ( ID_Клиента INT PRIMARY KEY IDENTITY(1,1), Имя_Клиента NVARCHAR(100) NOT NULL, Email_Клиента NVARCHAR(100) UNIQUE NOT NULL, Телефон NVARCHAR(20) ); GO

-- 3. Таблица Адреса_клиентов CREATE TABLE Адреса_клиентов ( ID_Адреса INT PRIMARY KEY IDENTITY(1,1), ID_Клиента INT NOT NULL, Город NVARCHAR(50) NOT NULL, Улица NVARCHAR(100) NOT NULL, Дом NVARCHAR(10) NOT NULL, FOREIGN KEY (ID_Клиента) REFERENCES Клиенты(ID_Клиента) ON DELETE CASCADE ); GO

-- 4. Таблица Категории_товаров CREATE TABLE Категории_товаров ( ID_Категории INT PRIMARY KEY IDENTITY(1,1), Название_категории NVARCHAR(50) NOT NULL UNIQUE ); GO

-- 5. Таблица Товары CREATE TABLE Товары ( ID_Товара INT PRIMARY KEY IDENTITY(1,1), Название_товара NVARCHAR(100) NOT NULL, ID_Категории INT NOT NULL, Текущая_цена DECIMAL(10,2) NOT NULL CHECK (Текущая_цена >= 0), FOREIGN KEY (ID_Категории) REFERENCES Категории_товаров(ID_Категории) ); GO

-- 6. Таблица Статусы_заказов CREATE TABLE Статусы_заказов ( ID_Статуса INT PRIMARY KEY IDENTITY(1,1), Название_статуса NVARCHAR(30) NOT NULL UNIQUE ); GO

-- 7. Таблица Заказы CREATE TABLE Заказы ( ID_Заказа INT PRIMARY KEY IDENTITY(1001,1), Дата_заказа DATE DEFAULT GETDATE(), ID_Статуса INT NOT NULL, ID_Клиента INT NOT NULL, ID_Адреса_доставки INT NOT NULL, FOREIGN KEY (ID_Статуса) REFERENCES Статусы_заказов(ID_Статуса), FOREIGN KEY (ID_Клиента) REFERENCES Клиенты(ID_Клиента), FOREIGN KEY (ID_Адреса_доставки) REFERENCES Адреса_клиентов(ID_Адреса) ); GO

-- 8. Таблица Состав_заказа CREATE TABLE Состав_заказа ( ID_Позиции INT PRIMARY KEY IDENTITY(1,1), ID_Заказа INT NOT NULL, ID_Товара INT NOT NULL, Количество INT NOT NULL CHECK (Количество > 0), Цена_на_момент_заказа DECIMAL(10,2) NOT NULL CHECK (Цена_на_момент_заказа >= 0), FOREIGN KEY (ID_Заказа) REFERENCES Заказы(ID_Заказа), FOREIGN KEY (ID_Товара) REFERENCES Товары(ID_Товара) ); GO

public static class Account { public static Users acc { get; set; } }

<Window x:Class="ConferenceApp.MainWindow"

    Title="Просмотр мероприятий" 
    Height="450" Width="800"
    MaxHeight="550" MaxWidth="900"
    MinHeight="350" MinWidth="700">
<Grid >
    <Grid.RowDefinitions>
        <RowDefinition Height="0.5*"/>
        <RowDefinition Height="3*"/>
        <RowDefinition/>
    </Grid.RowDefinitions>

    <Grid.ColumnDefinitions>
        <ColumnDefinition/>
        <ColumnDefinition/>
        <ColumnDefinition/>
        <ColumnDefinition/>
    </Grid.ColumnDefinitions>

    <Label Content="Направление"
           HorizontalAlignment="Center"/>

    <ComboBox x:Name="ComboBoxDirectionFilter"
              Grid.Column="1" Grid.Row="0"
              Margin="5"
              SelectedIndex="0"
              DisplayMemberPath="Name" 
              SelectionChanged="ComboBoxDirectionFilter_SelectionChanged"/>

    <Label Content="Дата"
           Grid.Column="2"
           HorizontalAlignment="Center"/>

    <DatePicker x:Name="DatePickerDateFilter"
              Grid.Column="3" Grid.Row="0"
              Margin="5"
              SelectedDateChanged="DatePickerDateFilter_SelectedDateChanged"/>

    <DataGrid x:Name="DataGridEvents" 
        Grid.Row="1" Grid.Column="0"
        Grid.ColumnSpan="4"
        AutoGenerateColumns="False"
        CanUserAddRows="False"
        CanUserResizeColumns="False"
        CanUserDeleteRows="False"
        CanUserReorderColumns="False">
        <DataGrid.Columns>
            <DataGridTemplateColumn Header="Логотип"
                                   IsReadOnly="True" Width="3*">
                <DataGridTemplateColumn.CellTemplate>
                    <DataTemplate>
                        <Image Source="{Binding ImagePath}"
                               Stretch="UniformToFill"/>
                    </DataTemplate>
                </DataGridTemplateColumn.CellTemplate>    
            </DataGridTemplateColumn>

            <DataGridTextColumn Header="Наименование" Binding="{Binding Name}" 
                                Width="6*"/>

            <DataGridTextColumn Header="Направление" Binding="{Binding DirectionName}"
                                Width="2*"/>

            <DataGridTextColumn Header="Дата" Binding="{Binding StartDate}"
                                Width="2*"/>
        </DataGrid.Columns>
    </DataGrid>

    <Button x:Name="ButtonAuthorization"
            Grid.Column="1" Grid.Row="3"
            Grid.ColumnSpan="2"
            Margin="10"
            Content="Авторизация" Click="ButtonAuthorization_Click"/>
</Grid>

</Window> /// <summary> /// Логика взаимодействия для MainWindow.xaml /// </summary> public partial class MainWindow : Window { public MainWindow() { InitializeComponent(); Load();

        var directions = ConferenceDBEntities.GetContext().Directions.Select(x => new
        {
            Id = (int?)x.Id,
            Name = x.Name
        }).ToList();

        directions.Insert(0, new
        {
            Id = (int?)null,
            Name = "Все данные"
        });

        ComboBoxDirectionFilter.ItemsSource = directions;
    }

    public void Load()
    {
        DataGridEvents.ItemsSource = ConferenceDBEntities.GetContext().Events.ToList();
    }

    private void ComboBoxDirectionFilter_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {
        ApplyFilters();
    }

    private void DatePickerDateFilter_SelectedDateChanged(object sender, SelectionChangedEventArgs e)
    {
        ApplyFilters();
    }

    private void ApplyFilters()
    {
        var events = ConferenceDBEntities.GetContext().Events.AsQueryable();
        var selectedDirection = ComboBoxDirectionFilter.SelectedItem as dynamic;

        if (selectedDirection?.Id != null)
        {
            events = events.Where(d => d.DirectionId == ComboBoxDirectionFilter.SelectedIndex);
        }

        if (DatePickerDateFilter.SelectedDate != null) 
        {
            var selectedDate = DatePickerDateFilter.SelectedDate.Value;
            events = events.Where(d => d.StartDate == DatePickerDateFilter.SelectedDate);
        }

        DataGridEvents.ItemsSource = events.ToList();
    }

    private void ButtonAuthorization_Click(object sender, RoutedEventArgs e)
    {
        new AuthorizationWindow().Show();
        this.Close();
    }
}

<Window x:Class="ConferenceApp.Windows.OrganizerWindow" Title="Окно организатора" WindowStartupLocation="CenterScreen" Height="550" Width="800" MaxHeight="650" MaxWidth="900" MinHeight="500" MinWidth="700"> <Grid> <Grid.ColumnDefinitions> <ColumnDefinition/> <ColumnDefinition/> <ColumnDefinition/> </Grid.ColumnDefinitions>

    <Grid.RowDefinitions>
        <RowDefinition/>
        <RowDefinition Height="0.5*"/>
        <RowDefinition Height="0.5*"/>
        <RowDefinition/>
        <RowDefinition/>
        <RowDefinition/>
    </Grid.RowDefinitions>

    <Label Grid.Row="0" Grid.Column="0"
           Grid.ColumnSpan="3"
           FontSize="18"
           HorizontalAlignment="Center"
           Content="Окно организатора"/>

    <Label x:Name="LabelMeetPhrase" 
        Grid.Row="1" Grid.Column="1"/>

    <Label x:Name="LabelSNP"
           Grid.Row="2" Grid.Column="1"/>

    <Viewbox Grid.Row="1" Grid.Column="0"
             Grid.RowSpan="4"
             Margin="50 20 50 20">
        <Image x:Name="ImageProfile"
               Stretch="UniformToFill"/>
    </Viewbox>

    <Button x:Name="ButtonEvents"
            Grid.Column="1" Grid.Row="3"
            Content="Мероприятия"
            Click="ButtonEvents_Click"/>

    <Button x:Name="ButtonPlayers"
            Grid.Column="1" Grid.Row="4"
            Content="Участники"
            Click="ButtonPlayers_Click"/>

    <Button x:Name="ButtonJuries"
            Grid.Column="1" Grid.Row="5"
            Content="Жюри"
            Click="ButtonJuries_Click"/>

    <Button x:Name="ButtonProfile"
            Grid.Column="0" Grid.Row="5"
            Content="Мой профиль"
            Click="ButtonProfile_Click"/>
</Grid>

</Window> { /// <summary> /// Логика взаимодействия для OrganizerWindow.xaml /// </summary> public partial class OrganizerWindow : Window { public OrganizerWindow() { InitializeComponent();

            if (Account.acc.GenderId == 1)
                LabelSNP.Content = "Мистер " + Account.acc.SNP;
            else
                LabelSNP.Content = "Mисс " + Account.acc.SNP;

            if (DateTime.Now.Hour >= 9 && DateTime.Now.Hour < 11)
                LabelMeetPhrase.Content = "Доброе утро!";
            if (DateTime.Now.Hour >= 11 && DateTime.Now.Hour < 18)
                LabelMeetPhrase.Content = "Добрый день!";
            if (DateTime.Now.Hour >= 18 && DateTime.Now.Hour < 24)
                LabelMeetPhrase.Content = "Добрый вечер!";
            if (DateTime.Now.Hour >= 0 && DateTime.Now.Hour < 9)
                LabelMeetPhrase.Content = "Доброй ночи!";

            var imageUri = new Uri($"pack://application:,,,/Images/Users/{Account.acc.Image}");
            var bitmap = new BitmapImage();

            bitmap.BeginInit();
            bitmap.UriSource = imageUri;
            bitmap.EndInit();

            ImageProfile.Source = bitmap;
        }

        private void ButtonEvents_Click(object sender, RoutedEventArgs e)
        {
            new EventWindow().ShowDialog();
        }

        private void ButtonProfile_Click(object sender, RoutedEventArgs e)
        {
            new ProfileWindow().ShowDialog();
        }

        private void ButtonJuries_Click(object sender, RoutedEventArgs e)
        {
            new JuryWindow().ShowDialog();
        }

        private void ButtonPlayers_Click(object sender, RoutedEventArgs e)
        {
            new PlayerWindow().ShowDialog();
        }
    }
}