using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.SqlTypes;


namespace AutReg
{
    /// <summary>
    /// Логика взаимодействия для MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
        gr683_gddEntities db;

        public MainWindow()
        {
            InitializeComponent();
            db = new gr683_gddEntities();
        }

        private void Auto_Click(object sender, RoutedEventArgs e)
        {
            Aut(login.Text,passwordbox.Password);
        }

        public bool Aut(string log,string pass)
        {
           if(string.IsNullOrEmpty(log) || string.IsNullOrEmpty(pass))
            {
                MessageBox.Show("Введите логин и пароль");
                return false;
            }

           using(var db = new gr683_gddEntities())
            {

                var user = db.Users.AsNoTracking().FirstOrDefault(u => u.Login == login.Text && u.Password == passwordbox.Password);
                
                if (user == null)
                {
                    MessageBox.Show("User non detected");
                    return false;
                }

                MessageBox.Show("user detected");
                return true;
            }

        }

        private void Button_Click(object sender, RoutedEventArgs e)
        {
            Window1 w1 = new Window1();
            w1.Show();
            this.Close();
        }

        private void Progect2_Click(object sender, RoutedEventArgs e)
        {
            Window3 w3 = new Window3();
            w3.Show();
            this.Close();
        }
    }
}