public UpdatingWaiter(string input)
        {
            InitializeComponent();
            wname =(input.Split(' '))[0];
            wsurname = (input.Split(' '))[1];

            w = (from r in context.Waiters
                where (r.WaiterName==wname) &&(r.WaiterSurname==wsurname)
                select r).First();

            name.Text = w.WaiterName;
            surname.Text = w.WaiterSurname;
            login.Text = w.WaiterLogin;
            pass.Text = w.WaiterPassword;
        }
        public UpdatingWaiter(string input)
        {
            InitializeComponent();
            wname    = (input.Split(' '))[0];
            wsurname = (input.Split(' '))[1];

            w = (from r in context.Waiters
                 where (r.WaiterName == wname) && (r.WaiterSurname == wsurname)
                 select r).First();

            name.Text    = w.WaiterName;
            surname.Text = w.WaiterSurname;
            login.Text   = w.WaiterLogin;
            pass.Text    = w.WaiterPassword;
        }
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            bool check = Requests.MethodsAdmininstrator.Check(new Context(), Login.Text, Password.Text);

            if (check == true)
            {
                Entities.Waiter w  = Requests.MethodsWaiter.GetWaiterByLogin(context, Login.Text);
                MakingOrder     mo = new MakingOrder(w.WaiterID);
                mo.Show();

                MainWindow mw = new MainWindow();
                mw.Show();
                this.Close();
            }
            else
            {
                MessageBox.Show("Логин или пароль введены неверно.");
            }
        }
        public List <Entities.Waiter> GetAllWaiters()
        {
            List <Entities.Waiter> listWaiters = new List <Entities.Waiter>();

            using (TeamProjectEntities6 entities = new TeamProjectEntities6())
            {
                var waiters = from r in entities.Waiter
                              select r;
                foreach (Waiter singleWaiter in waiters)
                {
                    Entities.Waiter w = new Entities.Waiter();
                    w.WaiterID      = singleWaiter.id;
                    w.WaiterName    = singleWaiter.name_Waiter;
                    w.WaiterSurname = singleWaiter.surname_Waiter;

                    listWaiters.Add(w);
                }
            }
            return(listWaiters);
        }
        private void add_Click(object sender, RoutedEventArgs e)
        {
            Context context = new Context();

            try
            {
                Entities.Waiter w = new Entities.Waiter();
                w.WaiterName = name.Text;
                w.WaiterSurname = surname.Text;
                w.WaiterLogin = login.Text;
                w.WaiterPassword = pass.Text;

                Requests.MethodsAdmininstrator.InsertWaiter(context, w);

                name.Text = "";
                surname.Text = "";
                login.Text = "";
                pass.Text = "";
            }
            catch (Exception ex) { MessageBox.Show("Проверьте правильность ввода данных."); }
        }
        private void add_Click(object sender, RoutedEventArgs e)
        {
            Context context = new Context();

            try
            {
                Entities.Waiter w = new Entities.Waiter();
                w.WaiterName     = name.Text;
                w.WaiterSurname  = surname.Text;
                w.WaiterLogin    = login.Text;
                w.WaiterPassword = pass.Text;

                Requests.MethodsAdmininstrator.InsertWaiter(context, w);

                name.Text    = "";
                surname.Text = "";
                login.Text   = "";
                pass.Text    = "";
            }
            catch (Exception ex) { MessageBox.Show("Проверьте правильность ввода данных."); }
        }
        public List<Entities.Waiter> GetAllWaiters()
        {
            List<Entities.Waiter> listWaiters = new List<Entities.Waiter>();
            using (TeamProjectEntities6 entities = new TeamProjectEntities6())
            {
                var waiters = from r in entities.Waiter
                             select r;
                foreach (Waiter singleWaiter in waiters)
                {
                    Entities.Waiter w = new Entities.Waiter();
                    w.WaiterID = singleWaiter.id;
                    w.WaiterName = singleWaiter.name_Waiter;
                    w.WaiterSurname = singleWaiter.surname_Waiter;

                    listWaiters.Add(w);
                }
            }
            return listWaiters;
        }