using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace fitnes
{
    public partial class MainClient : Form
    {
        private DataTable _chto;
        private DataTable _kto;

        public MainClient()
        {
            InitializeComponent();
            monthCalendar1.DateSelected += monthCalendar1_DateSelected;
            _chto = DbConnector.ExecuteQuery("SELECT  DISTINCT idWorkers, Position FROM Workers ");
            comboBox1.DataSource = _chto;
            comboBox1.DisplayMember = "Position";
            comboBox1.ValueMember = "Position";


            string op = comboBox1.SelectedIndex.ToString();
            MessageBox.Show(op);
            _kto = DbConnector.ExecuteQuery($"SELECT FirstName, LastName FROM  Users AS U JOIN Workers AS W on U.idUsers = W.idUser WHERE W.Position = '{comboBox1.SelectedText}'");
            comboBox2.DataSource = _kto;
            comboBox2.DisplayMember = "FirstName";

        }
        void monthCalendar1_DateSelected(object sender, DateRangeEventArgs e)
        {
            label1.Text = e.Start.ToShortDateString();
            // или так - аналогичный код
            //label1.Text = String.Format("Вы выбрали: {0}", monthCalendar1.SelectionStart.ToLongDateString());
        }

        private void button1_Click(object sender, EventArgs e)
        {
            Hide();
            new Aboniment().Show();
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {

        }
    }
}