---

using System;
using Microsoft.Maui.Controls;
using System.Data.SqlClient;

namespace MauiApp1
{
    public partial class MainPage : ContentPage
    {
        private string connectionString = "Data Source=stud-mssql.sttec.yar.ru,38325;Initial Catalog=user284_db;User ID=user300_db;Password=user300;Encrypt=True;TrustServerCertificate=True;";

        public MainPage()
        {
            InitializeComponent();
        }

        private async void OnRegisterClicked(object sender, EventArgs e)
        {
            string username = UsernameEntry.Text;
            string password = PasswordEntry.Text;
            string repeatPassword = RepeatPasswordEntry.Text;
            string city = CityEntry.Text;
            DateTime birthDate = BirthDatePicker.Date;

            string gender = MaleRadio.IsChecked ? "Мужской" :
                            FemaleRadio.IsChecked ? "Женский" : "";

            string securityQuestion = SecurityQuestionPicker.SelectedItem?.ToString();
            string securityAnswer = SecurityAnswerEntry.Text;

            if (password != repeatPassword)
            {
                await DisplayAlert("Ошибка", "Пароли не совпадают", "ОК");
                return;
            }

            try
            {
                using (SqlConnection connection = new SqlConnection(connectionString))
                {
                    connection.Open();

                    string query = @"INSERT INTO Users 
                    (Username, Password, FullName, Role, [Group]) 
                    VALUES (@Username, @Password, @FullName, @Role, @Group)";

                    SqlCommand command = new SqlCommand(query, connection);

                    command.Parameters.AddWithValue("@Username", username);
                    command.Parameters.AddWithValue("@Password", password);
                    command.Parameters.AddWithValue("@FullName", username);
                    command.Parameters.AddWithValue("@Role", "User");
                    command.Parameters.AddWithValue("@Group", city);

                    command.ExecuteNonQuery();

                    await DisplayAlert("Успех", "Регистрация прошла успешно!", "ОК");
                }
            }
            catch (Exception ex)
            {
                await DisplayAlert("Ошибка", ex.Message, "ОК");
            }
        }
    }
}



<?xml version="1.0" encoding="utf-8" ?>
<ContentPage xmlns="http://schemas.microsoft.com/dotnet/2021/maui"
             xmlns:x="http://schemas.microsoft.com/winfx/2009/xaml"
             x:Class="MauiApp1.MainPage">

    <ScrollView Padding="20">
        <StackLayout Spacing="12">

            <Label Text="Регистрация" FontSize="24" HorizontalOptions="Center"/>

            <Entry x:Name="UsernameEntry" Placeholder="Имя пользователя" />

            <Label Text="Дата рождения" />
            <DatePicker x:Name="BirthDatePicker" />

            <Entry x:Name="CityEntry" Placeholder="Город" />

            <Label Text="Пол" />
            <StackLayout Orientation="Horizontal">
                <RadioButton x:Name="MaleRadio" Content="Мужской" GroupName="Gender"/>
                <RadioButton x:Name="FemaleRadio" Content="Женский" GroupName="Gender"/>
            </StackLayout>

            <Entry x:Name="PasswordEntry" Placeholder="Пароль" IsPassword="True"/>
            <Entry x:Name="RepeatPasswordEntry" Placeholder="Повторите пароль" IsPassword="True"/>

            <Picker x:Name="SecurityQuestionPicker" Title="Секретный вопрос">
                <Picker.Items>
                    <x:String>Ваш первый автомобиль?</x:String>
                    <x:String>Имя питомца?</x:String>
                    <x:String>Любимый учитель?</x:String>
                </Picker.Items>
            </Picker>

            <Entry x:Name="SecurityAnswerEntry" Placeholder="Ответ"/>

            <Button Text="Зарегистрироваться"
                    BackgroundColor="#0078D7"
                    TextColor="White"
                    Clicked="OnRegisterClicked"/>

        </StackLayout>
    </ScrollView>
</ContentPage>