Dipl/ImpulseVision/FormMain.cs

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;
//подключение библиотек
using Emgu.CV;
using Emgu.CV.Structure;
using Emgu.CV.Face;
using Emgu.CV.CvEnum;
using System.IO;
using System.Threading;
using System.Xml;
using System.Drawing.Imaging;
using System.Data.SqlClient;
using DirectShowLib;
using Emgu.CV.Util;
using System.Runtime.CompilerServices;
using Timer = System.Windows.Forms.Timer;
using ZedGraph;
using static System.Windows.Forms.VisualStyles.VisualStyleElement.StartPanel;

namespace ImpulseVision
{
    public partial class FormMain : Form
    {
        #region <Переменные>

        public event PropertyChangedEventHandler PropertyChanged;
        private VideoCapture Capture;
        private CascadeClassifier HaarCascade;
        private Image<Bgr, Byte> BgrFrame = null;
        private Image<Gray, Byte> DetectedFace = null;
        private List<FaceData> FaceList = new List<FaceData>();
        private VectorOfMat ImageList = new VectorOfMat();
        private List<string> NameList = new List<string>();
        private VectorOfInt LabelList = new VectorOfInt();

        private EigenFaceRecognizer recognizer;
        private Timer CaptureTimer;
        #region FaceName
        private string UserName = string.Empty;
        private string faceName;
        public string FaceName
        {
            get { return faceName; }
            set
            {
                faceName = value.ToUpper();

                UserName = faceName;
                //PbxFaces.Invoke(DispatcherPriority.Normal, new Action(() => { lblFaceName.Content = faceName; }));
                NotifyPropertyChanged();
            }
        }
        #endregion
        #region CameraCaptureImage
        private Bitmap cameraCapture;
        public Bitmap CameraCapture
        {
            get { return cameraCapture; }
            set
            {
                cameraCapture = value;
                //imgCamera.Dispatcher.Invoke(DispatcherPriority.Normal, new Action(() => { imgCamera.Source = BitmapToImageSource(cameraCapture); }));

                PbxEther.Image = cameraCapture;
                //PbxFaces.Image = BitmapToImageSource(cameraCapture);
                NotifyPropertyChanged();
            }
        }
        #endregion
        #region CameraCaptureFaceImage
        private Bitmap cameraCaptureFace;
        public Bitmap CameraCaptureFace
        {
            get { return cameraCaptureFace; }
            set
            {
                cameraCaptureFace = value;
                PbxEther.Image = cameraCapture;

                NotifyPropertyChanged();
            }
        }
        #endregion

        int SelectedCameraID = -1;
        //доступные видеокамеры
        private DsDevice[] WebCams = null;

        int CountCams = -1;
        //множество для хранения списка камер
        HashSet<string> HtBefore = new HashSet<string>();
        //включена ли на данный момент камера
        bool IsWorking = false;

        public static string TxtCon = $@"Data Source=213.155.192.79,3002;Initial Catalog=ImpulseVisionApp;Persist Security Info=True;User ID=u20teresh;Password=bfg2";

        /// <summary>
        /// текущий выбранный пользователь из списка
        /// </summary>
        UserItem CurrentUser = null;
        /// <summary>
        /// выбранная плитка в окне "посещения"
        /// </summary>
        TileOvals CurrentOvals = null;
        /// <summary>
        /// выбранная плитка в окне "журнал отклонённых"
        /// </summary>
        CardJournal CurrentCard = null;

        SqlConnection SCon = new SqlConnection(Properties.Settings.Default.ImpulseVisionAppConnectionString);
        //список с пользователями системы
        List<Users> LstUsers = new List<Users>();
        //ID пользователя, который был только что добавлен
        string AddingUserID = string.Empty;
        //список, в котором хранятся пути изображений пользователей
        List<string> LstPathImage = new List<string>();
        //уведомление о том, что сохранение выполнено
        bool Saving = false;
        #endregion
        //пути доступа к изображениям пользователей
        List<Pictures> LstUserPictures = new List<Pictures>();

        struct Pictures
        {
            public string UserID, PicturePath;
        }


        struct Users
        {
            public string FIO, PassportSeria, PassportNum, UserID;
        }

        public FormMain()
        {
            InitializeComponent();
        }

        private void CaptureTimer_Tick(object sender, EventArgs e)
        {
            ProcessFrame();
        }

        /// <summary>
        /// получение данных с камеры и обработка изображений
        /// </summary>
        private void ProcessFrame()
        {
            BgrFrame = Capture.QueryFrame().ToImage<Bgr, Byte>().Flip(FlipType.Horizontal);

            if (BgrFrame != null)
            {
                try
                {
                    Image<Gray, byte> grayframe = BgrFrame.Convert<Gray, byte>();

                    Rectangle[] Faces = HaarCascade.DetectMultiScale(grayframe, 1.2, 10, new System.Drawing.Size(50, 50), new System.Drawing.Size(200, 200));

                    //detect face
                    FaceName = "No face detected";
                    foreach (var face in Faces)
                    {
                        BgrFrame.Draw(face, new Bgr(53, 23, 247), 2);
                        DetectedFace = BgrFrame.Copy(face).Convert<Gray, byte>();
                        FaceRecognition();
                        break;
                    }
                    CameraCapture = BgrFrame.ToBitmap();
                }
                catch (Exception ex)
                {

                    //todo log
                }

            }
        }
        /// <summary>
        /// получение данных об изображениях 
        /// </summary>
        public void GetFacesList()
        {
            //haar cascade classifier
            if (!File.Exists(Config.HaarCascadePath))
            {
                string text = "Cannot find Haar cascade data file:\n\n";
                text += Config.HaarCascadePath;
                DialogResult result = MessageBox.Show(text, "Error",
                        MessageBoxButtons.OK, MessageBoxIcon.Error);
            }

            HaarCascade = new CascadeClassifier(Config.HaarCascadePath);
            FaceList.Clear();

            // Создать директорию, если она отсутствовала
            if (!Directory.Exists(Config.FacePhotosPath))
            {
                Directory.CreateDirectory(Config.FacePhotosPath);
            }

            // Тренировать изображения
            if (ImageList.Size > 0)
            {
                recognizer = new EigenFaceRecognizer(ImageList.Size);
                recognizer.Train(ImageList, LabelList);
            }
        }

        /// <summary>
        /// распознавание лица
        /// </summary>
        private void FaceRecognition()
        {
            if (ImageList.Size != 0)
            {
                //Eigen Face Algorithm
                FaceRecognizer.PredictionResult result = recognizer.Predict(DetectedFace.Resize(100, 100, Inter.Cubic));
                FaceName = NameList[result.Label];
                CameraCaptureFace = DetectedFace.ToBitmap();
            }
            else
            {
                FaceName = "Пожалуйста добавьте лицо";
            }
        }

        protected virtual void NotifyPropertyChanged([CallerMemberName] String propertyName = "")
        {
            var handler = PropertyChanged;
            if (handler != null)
                handler(this, new PropertyChangedEventArgs(propertyName));
        }

        private void FormMain_Load(object sender, EventArgs e)
        {
            HideAdding();

            //скрытие заголовков вкладок в TabControl
            TabPages.Appearance = TabAppearance.FlatButtons;
            TabPages.ItemSize = new Size(0, 1);
            TabPages.SizeMode = TabSizeMode.Fixed;

            this.Show();

            GetCams();

            CmbCams.Visible = false;
            TslSelCamText.Visible = false;

            CmbSortDate.SelectedIndex = 0;
            DtpFiniteDate.Value = DateTime.Now.Date;

            GetUsersFromDB();
        }
        /// <summary>
        /// получение списка доступных камер
        /// </summary>
        private void GetCams()
        {
            WebCams = DsDevice.GetDevicesOfCat(FilterCategory.VideoInputDevice);
            CountCams = WebCams.Length;

            CmbCams.Items.Clear();
            for (int i = 0; i < CountCams; i++)
            {
                CmbCams.Items.Add(WebCams[i].Name);
                HtBefore.Add(WebCams[i].Name);
            }

            if (CountCams > 0)
            {
                CmbCams.SelectedIndex = 0;
                SelectedCameraID = 0;
            }
        }
        /// <summary>
        /// удаление пользователя из системы
        /// </summary>
        private void BtnDelUser_Click(object sender, EventArgs e)
        {
            string IdUser = string.Empty;

            IdUser = CurrentUser.UserID;
            DialogResult Res = MessageBox.Show("Подтверждение данной операции приведёт к безвозвратному удалению пользователя из системы.\r\nПодтвердить удаление?", "ImpulseVision", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
            if (Res == DialogResult.No)
                return;

            SCon.Open();
            string QueryDelUser = $@"delete
from FaceImages
where UserID = '{IdUser}'";

            SqlCommand Cmd = new SqlCommand(QueryDelUser, SCon);
            Cmd.ExecuteNonQuery();

            QueryDelUser = $@"delete
from Users
where ID = '{IdUser}'";
            Cmd = new SqlCommand(QueryDelUser, SCon);
            Cmd.ExecuteNonQuery();

            SCon.Close();

            string PhotoName = string.Empty;
            for (int i = 0; i < LstUsers.Count; i++)
            {
                if (LstUsers[i].UserID == IdUser)
                {
                    PhotoName = LstUsers[i].FIO.Split(' ')[1] + LstUsers[i].PassportSeria + LstUsers[i].PassportNum;
                }
            }
            try
            {
                //удалить из папки фотографию пользователя
                File.Delete(Application.StartupPath + "\\" + Config.FacePhotosPath + $"{PhotoName}.bmp");
            }
            catch
            {
                MessageBox.Show("Фотографии пользователя не найдены!", "ImpulseVision", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return;
            }

            GetUsersFromDB();

            MessageBox.Show("Пользователь безвозвратно удалён из системы!", "ImpulseVision", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }

        /// <summary>
        /// показ окна добавления
        /// </summary>
        private void ShowAdding()
        {
            this.TableLayoutWorks.BeginInvoke((MethodInvoker)(() => this.TableLayoutWorks.ColumnStyles[0].Width = 250));
            this.TableLayoutWorks.BeginInvoke((MethodInvoker)(() => this.TableLayoutWorks.BackColor = Color.White));
        }
        /// <summary>
        /// скрытие окна добавления
        /// </summary>
        private void HideAdding()
        {
            TableLayoutWorks.ColumnStyles[0].Width = 0;
            TableLayoutWorks.BackColor = Color.Black;
        }

        private void PbxEther_Click(object sender, EventArgs e)
        {
            HideAdding();
        }
        /// <summary>
        /// добавление нового пользоввателя
        /// </summary>
        private void BtnAddUser_Click(object sender, EventArgs e)
        {
            CmbCams.Visible = true;
            TslSelCamText.Visible = true;

            BtnEditUser.Visible = false;
            BtnDelUser.Visible = false;

            TbxLastname.Text = "";
            TbxFirstname.Text = "";
            TbxPatronymic.Text = "";
            TbxPasportSeria.Text = "";
            TbxPasportNum.Text = "";

            TabPages.SelectTab(1);
            PbxEther.Image = Properties.Resources.loading_7;

            CaptureTimer = new Timer()
            {
                Interval = Config.TimerResponseValue
            };
            CaptureTimer.Tick += CaptureTimer_Tick;

            if (IsWorking)
                return;

            TableLayoutWorks.BackColor = Color.Black;

            IsWorking = true;//камера включена

            GetFacesList();
            Capture = new VideoCapture(Config.ActiveCameraIndex);
            Capture.SetCaptureProperty(CapProp.Fps, 30);
            Capture.SetCaptureProperty(CapProp.FrameHeight, 450);
            Capture.SetCaptureProperty(CapProp.FrameWidth, 370);
            CaptureTimer.Start();

            ShowAdding();
        }

        /// <summary>
        /// выключение распознавания
        /// </summary>
        private void RecogniseOff()
        {
            HideAdding();

            if (BgrFrame != null)
            {
                BgrFrame = null;
                Capture.Dispose();
                CaptureTimer.Tick -= CaptureTimer_Tick;
            }

            PbxEther.Image = Properties.Resources._9110852_video_no_icon;

            TableLayoutWorks.BackColor = Color.Gray;
            IsWorking = false;
        }

        /// <summary>
        /// сохранение информации для нового пользователя
        /// </summary>
        private void BtnSave_Click(object sender, EventArgs e)
        {
            if (DetectedFace == null)
            {
                MessageBox.Show("Лица не обнаружены!\r\nУбедитесь что лицо находится в кадре и обведено красным прямоугольником.", "ImpulseVision", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            string PhotoPath = string.Empty;
            ProgressOperation.Value = 10;
            TslStatus.Text = "Добавление нового пользователя...";

            bool Flag = TbxLastname.Text.Trim() == "" || TbxFirstname.Text.Trim() == "" || TbxPasportSeria.Text.Trim() == "" || TbxPasportNum.Text.Trim() == "" || TbxPhone.Text.Trim() == "";

            if(Flag)
            {
                MessageBox.Show("Заполните все поля и повторите попытку!", "Ошибка добавления!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return;
            }

            SCon.Open();
            string QueryCheckPassport = $@"select PassportSeria,PassportNum
from Users
where PassportSeria = '{TbxPasportSeria.Text.Trim()}' and PassportNum = '{TbxPasportNum.Text.Trim()}'";
            SqlCommand CmdCheck = new SqlCommand(QueryCheckPassport, SCon);
            SqlDataReader Res = CmdCheck.ExecuteReader();
            if(Res.HasRows)
            {
                MessageBox.Show("Данные паспорта указаны неверно!", "ImpulseVision", MessageBoxButtons.OK, MessageBoxIcon.Error);
                SCon.Close();
                ProgressOperation.Value = 0;
                return;
            }
            SCon.Close();

            SCon.Open();
            string QueryAdd = $@"insert into Users (Lastname,Firstname, Patronymic, PassportSeria, PassportNum,Phone, IDUserType) values (@last,@first,@patr,@seria,@number,@phone,3)";
            SqlCommand Cmd = new SqlCommand(QueryAdd, SCon);
            Cmd.Parameters.AddWithValue("@last", TbxLastname.Text.Trim());
            Cmd.Parameters.AddWithValue("@first", TbxFirstname.Text.Trim());
            Cmd.Parameters.AddWithValue("@patr", TbxPatronymic.Text.Trim());
            Cmd.Parameters.AddWithValue("@seria", TbxPasportSeria.Text.Trim());
            Cmd.Parameters.AddWithValue("@number", TbxPasportNum.Text.Trim());
            Cmd.Parameters.AddWithValue("@phone", TbxPhone.Text.Trim());
            Cmd.ExecuteNonQuery();//выполнить запрос
            SCon.Close();

            SCon.Open();
            string QueryAddingUserID = $@"select MAX(ID) as LastID
            from Users";
            Cmd = new SqlCommand(QueryAddingUserID, SCon);
            SqlDataReader ResID = Cmd.ExecuteReader();
            if(ResID.HasRows)
            {
                ResID.Read();
                //получить id только что добавленного пользователя
                AddingUserID = ResID["LastID"].ToString();
            }
            SCon.Close();

            //изменить размеры изображения
            DetectedFace = DetectedFace.Resize(100, 100, Inter.Cubic);
            //сохранить изображение в папку
            DetectedFace.Save(Config.FacePhotosPath + $"{TbxFirstname.Text.Trim()}{TbxPasportSeria.Text.Trim()}{TbxPasportNum.Text.Trim()}" + Config.ImageFileExtension);

            PhotoPath = Config.FacePhotosPath + $"{TbxFirstname.Text.Trim()}{TbxPasportSeria.Text.Trim()}{TbxPasportNum.Text.Trim()}" + Config.ImageFileExtension;

            TslStatus.Text = "Сохранение данных о пользователе...";

            ProgressOperation.Value = 50;
            TslStatus.Text = "Добавление нового пользователя...";
            //сохранение пути до фотографии
            SCon.Open();
            string QueryAddPathImage = $@"insert into FaceImages (UserID,Picture)
values ({AddingUserID},'{PhotoPath}')";

            Cmd = new SqlCommand(QueryAddPathImage, SCon);
            Cmd.ExecuteNonQuery();//выполнить запрос на добавление пути фото для пользователя
            SCon.Close();
            MessageBox.Show("Успешно сохранено!", "ImpulseVision", MessageBoxButtons.OK, MessageBoxIcon.Information);

            TimerSaving.Enabled = true;
            TimerSaving.Start();

            TslStatus.Text = "Готов";
            ProgressOperation.Value = 100;
        }

        private void CmbCams_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                //если захват видео уже идёт
                //if(VideoCapture != null)
                //{
                //    VideoCapture.Pause();
                //    VideoCapture.Stop();
                //    VideoCapture.Dispose();
                //    VideoCapture = null;
                //    PbxEther.Image = null;
                //    SelectedCameraID = -1;
                //}
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message, "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }

            SelectedCameraID = CmbCams.SelectedIndex;

            if (IsWorking)
            {
                //VideoCapture = new VideoCapture(SelectedCameraID);
                //////VideoCapture.ImageGrabbed += VideoCapture_ImageGrabbed;
                //VideoCapture.Start();

                //FacesDetectionEnabled = true;//включить распознавание
                //CvInvoke.UseOpenCL = true;
            }
        }

        private void FormMain_FormClosing(object sender, FormClosingEventArgs e)
        {

        }

        private void TimerNewCam_Tick(object sender, EventArgs e)
        {
            DsDevice[] Cams = DsDevice.GetDevicesOfCat(FilterCategory.VideoInputDevice);

            int Count = Cams.Length;
            //если количество подключённых камер изменилось
            if(Count != CountCams)
            {
                if (Count > CountCams)
                {
                    StatusAddNewDevice(Cams);
                }
                else if(Count < CountCams)
                {
                    StatusOffDevice(Cams);
                }
                GetCams();
            }
        }
        /// <summary>
        /// уведомление об отключении web-камеры
        /// </summary>
        /// <param name="cams">массив с доступными камерами</param>
        async void StatusOffDevice(DsDevice[] cams)
        {
            HashSet<string> HtAfter = new HashSet<string>();
            foreach(DsDevice device in cams)
            {
                HtAfter.Add(device.Name);
            }
            HtBefore.Except(HtAfter);

            ProgressOperation.Value = 0;
            TslStatus.Text = $"Устройство: {string.Join(" ",HtBefore)} - отключено";
            await Task.Delay(1000);
            ProgressOperation.Value = 100;
            TslStatus.Text = "Готов";
        }
        /// <summary>
        /// уведомление о подключении нового устройствва
        /// </summary>
        /// <param name="Cams">массив с доступными web-камерами</param>
        async void StatusAddNewDevice(DsDevice[] Cams)
        {
            TslStatus.Text = "Добавление нового устройства..";
            ProgressOperation.Value = 0;
            while(ProgressOperation.Value < 100)
            {
                ProgressOperation.Value += 5;
                await Task.Delay(50);
            }
            TslStatus.Text = "Добавлено новое устройство";
            await Task.Delay(1000);
            TslStatus.Text = $"{Cams[Cams.Length-1].Name}";
            await Task.Delay(1000);
            ProgressOperation.Value = 100;
            TslStatus.Text = "Готов";
        }

        private void BtnCheck_Click(object sender, EventArgs e)
        {
            TslStatus.Text = "Подождите.. выполняется анализ лица..";
            ProgressOperation.Value = 45;
            //TrainImageFromDir();

            //FaceDifferent();

            //Task.Factory.StartNew(new Action(() => TrainImageFromDir()));
            //ProgressTrain.Value = 55;
            //TslStatus.Text = "Готов";
        }

        private void PbxEther_Click_1(object sender, EventArgs e)
        {
            //HideAdding();
        }

        private void STools_Click(object sender, EventArgs e)
        {
            BtnEditUser.Visible = false;
            BtnDelUser.Visible = false;
            BtnAddUser.Visible = true;
            TabPages.SelectTab(2);

            RecogniseOff();
        }

        /// <summary>
        /// получить список пользователй системы
        /// </summary>
        private void SUsers_Click(object sender, EventArgs e)
        {
            
        }
        /// <summary>
        /// получение пользователей из БД
        /// </summary>
        private void GetUsersFromDB()
        {
            SCon.Open();
            string QueryForGetUser = @"select ID, Lastname + ' ' + Firstname + ' ' + Patronymic as FIO, PassportSeria, PassportNum
                    from Users";

            SqlCommand Cmd = new SqlCommand(QueryForGetUser, SCon);
            SqlDataReader Res = Cmd.ExecuteReader();
            LstUsers.Clear();
            while (Res.Read())
            {
                Users user = new Users();
                user.FIO = Res["FIO"].ToString();
                user.UserID = Res["ID"].ToString();
                user.PassportSeria = Res["PassportSeria"].ToString();
                user.PassportNum = Res["PassportNum"].ToString();
                LstUsers.Add(user);
            }
            SCon.Close();

            TabPages.SelectTab(0);

            TableUsers.Controls.Clear();
            for (int i = 0; i < LstUsers.Count; i++)
            {
                UserItem Item = new UserItem();
                Item.UserID = LstUsers[i].UserID;
                Item.LblNameUser.Text = LstUsers[i].FIO;
                Item.Click += User_Click;
                Item.LblNameUser.Click += Object_Click;
                TableUsers.Controls.Add(Item);
                if (TableUsers.Controls.Count == 1)
                {
                    CurrentUser = Item;
                    CurrentUser.BackColor = ColorTranslator.FromHtml("#C3EB78");
                }
            }
        }

        /// <summary>
        /// выбор пользователя из списка
        /// </summary>
        private void Object_Click(object sender, EventArgs e)
        {
            CurrentUser.BackColor = Color.FromArgb(((int)(((byte)(184)))), ((int)(((byte)(184)))), ((int)(((byte)(255)))));
            CurrentUser = (sender as Control).Parent as UserItem;
            CurrentUser.BackColor = ColorTranslator.FromHtml("#C3EB78");
        }

        private void User_Click(object sender, EventArgs e)
        {
            CurrentUser.BackColor = Color.FromArgb(((int)(((byte)(184)))), ((int)(((byte)(184)))), ((int)(((byte)(255)))));
            CurrentUser = sender as UserItem;
            CurrentUser.BackColor = ColorTranslator.FromHtml("#C3EB78");
        }

        private void MExit_Click(object sender, EventArgs e)
        {
            Close();
        }

        private void MMain_Click(object sender, EventArgs e)
        {
            CmbCams.Visible = false;
            TslSelCamText.Visible = false;

            RecogniseOff();

            GetUsersFromDB();

            TabPages.SelectTab(0);

            BtnEditUser.Visible = true;
            BtnDelUser.Visible = true;
            BtnAddUser.Visible = true;
            BtnInfoTraffic.Visible = true;

            TslStatus.Text = "Готов";
            ProgressOperation.Value = 100;
        }

        private void BtnEditUser_Click(object sender, EventArgs e)
        {
            FormEditUser FEdit = new FormEditUser();
            FEdit.LblSelectUserID.Text = CurrentUser.UserID.ToString();
            if (FEdit.ShowDialog() == DialogResult.OK)
            {
                GetUsersFromDB();
            }
        }

        private void TimerSaving_Tick(object sender, EventArgs e)
        {
            if (Saving)
            {
                MMain_Click(sender, e);
                GetUsersFromDB();
                TimerSaving.Stop();
                TimerSaving.Enabled = false;
            }
        }

        private void BtnInfoTraffic_Click(object sender, EventArgs e)
        {
            BtnAddUser.Visible = false;
            BtnEditUser.Visible = false;
            BtnDelUser.Visible = false;
            TslSelCamText.Visible = false;
            CmbCams.Visible = false;

            TabPages.SelectTab(3);
            GetJournalVisits();
        }
        /// <summary>
        /// получение из БД списка посещений
        /// </summary>
        private void GetJournalVisits()
        {
            TslStatus.Text = "Загрузка данных...";
            ProgressOperation.Value = 10;

            SCon.Open();
            string QueryGetVisits = $@"set dateformat dmy
select Users.ID,Users.Lastname +' '+ Users.Firstname + ' '+Users.Patronymic as FIO,TimeEntrance,TimeExit,
[Date],Identification
from UserTraffic ut join Users on ut.UserID = Users.ID
";
            if(DtpFiniteDate.Visible)
            {
                QueryGetVisits += $"  where [Date] = '{DtpFiniteDate.Value.Date}'";
            }
            else
            {
                QueryGetVisits += $"  where [Date] between '{DtpDateStart.Value.Date}' and '{DtpDateEnd.Value.Date}'";
            }
            QueryGetVisits += $@"  and Users.Lastname +' '+ Users.Firstname + ' '+Users.Patronymic like '%{TbxFindUser.Text.Trim()}%'";
            SqlCommand Cmd = new SqlCommand(QueryGetVisits, SCon);
            SqlDataReader Res = Cmd.ExecuteReader();

            ProgressOperation.Value = 30;

            TabJournal.Controls.Clear();
            if (Res.HasRows)
            {
                while (Res.Read())
                {
                    TileOvals Ovals = new TileOvals();
                    Ovals.UserID = Res["ID"].ToString();
                    Ovals.LblNameUser.Text = Res["FIO"].ToString();
                    Ovals.LblTimeEntrance.Text = Res["TimeEntrance"].ToString();
                    Ovals.LblTimeExit.Text = Res["TimeExit"].ToString();
                    Ovals.IsIdentification = Res["Identification"].ToString();
                    Ovals.LblDate.Text = DateTime.Parse(Res["Date"].ToString()).ToString("dd.MM.yyyy");

                    if (Ovals.IsIdentification.ToLower() == "false")
                    {
                        Ovals.RPanelDate.BackColor = ColorTranslator.FromHtml("#f71735");
                        Ovals.RPanelName.BackColor = ColorTranslator.FromHtml("#f71735");
                        Ovals.RPanelTimeEntrance.BackColor = ColorTranslator.FromHtml("#f71735");
                        Ovals.RPanelTimeExit.BackColor = ColorTranslator.FromHtml("#f71735");
                    }
                    else
                    {
                        Ovals.RPanelDate.BackColor = Color.FromArgb(184, 184, 255);
                        Ovals.RPanelName.BackColor = Color.FromArgb(184, 184, 255);
                        Ovals.RPanelTimeEntrance.BackColor = Color.FromArgb(184, 184, 255);
                        Ovals.RPanelTimeExit.BackColor = Color.FromArgb(184, 184, 255);
                    }


                    Ovals.Click += Ovals_Click;
                    Ovals.LblDate.Click += OvalsObject_Click;
                    Ovals.LblNameUser.Click += OvalsObject_Click;
                    Ovals.LblTimeEntrance.Click += OvalsObject_Click;
                    Ovals.LblTimeExit.Click += OvalsObject_Click;
                    Ovals.RPanelName.Click += OvalsObject_Click;
                    Ovals.RPanelTimeEntrance.Click += OvalsObject_Click;
                    Ovals.RPanelTimeExit.Click += OvalsObject_Click;
                    Ovals.RPanelDate.Click += OvalsObject_Click;

                    TabJournal.Controls.Add(Ovals);
                    if (TabJournal.Controls.Count == 1)
                    {
                        CurrentOvals = Ovals;
                        CurrentOvals.RPanelDate.BackColor = ColorTranslator.FromHtml("#C3EB78");
                        CurrentOvals.RPanelName.BackColor = ColorTranslator.FromHtml("#C3EB78");
                        CurrentOvals.RPanelTimeEntrance.BackColor = ColorTranslator.FromHtml("#C3EB78");
                        CurrentOvals.RPanelTimeExit.BackColor = ColorTranslator.FromHtml("#C3EB78");
                    }
                }
            }
            else
            {
                MessageBox.Show("При выбранных параметрах сортировки, результаты отсутствуют!", "ImpulseVision", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
            SCon.Close();

            TslStatus.Text = "Готов";
            ProgressOperation.Value = 100;
        }

        private void OvalsObject_Click(object sender, EventArgs e)
        {
            if (CurrentOvals.IsIdentification.ToLower() == "false")
            {
                CurrentOvals.RPanelDate.BackColor = ColorTranslator.FromHtml("#f71735");
                CurrentOvals.RPanelName.BackColor = ColorTranslator.FromHtml("#f71735");
                CurrentOvals.RPanelTimeEntrance.BackColor = ColorTranslator.FromHtml("#f71735");
                CurrentOvals.RPanelTimeExit.BackColor = ColorTranslator.FromHtml("#f71735");
            }
            else
            {

                CurrentOvals.RPanelDate.BackColor = Color.FromArgb(184, 184, 255);
                CurrentOvals.RPanelName.BackColor = Color.FromArgb(184, 184, 255);
                CurrentOvals.RPanelTimeEntrance.BackColor = Color.FromArgb(184, 184, 255);
                CurrentOvals.RPanelTimeExit.BackColor = Color.FromArgb(184, 184, 255);
            }

            CurrentOvals = ((sender as Control).Parent as RPanel).Parent as TileOvals;

            CurrentOvals.RPanelDate.BackColor = ColorTranslator.FromHtml("#C3EB78");
            CurrentOvals.RPanelName.BackColor = ColorTranslator.FromHtml("#C3EB78");
            CurrentOvals.RPanelTimeEntrance.BackColor = ColorTranslator.FromHtml("#C3EB78");
            CurrentOvals.RPanelTimeExit.BackColor = ColorTranslator.FromHtml("#C3EB78");
        }

        private void Ovals_Click(object sender, EventArgs e)
        {
            if (CurrentOvals.IsIdentification.ToLower() == "false")
            {
                CurrentOvals.RPanelDate.BackColor = ColorTranslator.FromHtml("#f71735");
                CurrentOvals.RPanelName.BackColor = ColorTranslator.FromHtml("#f71735");
                CurrentOvals.RPanelTimeEntrance.BackColor = ColorTranslator.FromHtml("#f71735");
                CurrentOvals.RPanelTimeExit.BackColor = ColorTranslator.FromHtml("#f71735");
            }
            else
            {

                CurrentOvals.RPanelDate.BackColor = Color.FromArgb(184, 184, 255);
                CurrentOvals.RPanelName.BackColor = Color.FromArgb(184, 184, 255);
                CurrentOvals.RPanelTimeEntrance.BackColor = Color.FromArgb(184, 184, 255);
                CurrentOvals.RPanelTimeExit.BackColor = Color.FromArgb(184, 184, 255);
            }

            CurrentOvals = sender as TileOvals;

            CurrentOvals.RPanelDate.BackColor = ColorTranslator.FromHtml("#C3EB78");
            CurrentOvals.RPanelName.BackColor = ColorTranslator.FromHtml("#C3EB78");
            CurrentOvals.RPanelTimeEntrance.BackColor = ColorTranslator.FromHtml("#C3EB78");
            CurrentOvals.RPanelTimeExit.BackColor = ColorTranslator.FromHtml("#C3EB78");
        }

        private void CmbSortDate_SelectedIndexChanged(object sender, EventArgs e)
        {
            PanelPeriod.Visible = CmbSortDate.SelectedIndex == 1;
            DtpFiniteDate.Visible = CmbSortDate.SelectedIndex == 0;
        }
        int LocX = 0;
        private void TmAnim_Tick(object sender, EventArgs e)
        {
            //LocX = LblTest.Location.X;
            //LocX++;
            //LblTest.Location = new Point(LocX, LblTest.Location.Y);
        }

        private void DtpFiniteDate_ValueChanged(object sender, EventArgs e)
        {
            if (TabPages.SelectedIndex == 3)
            {
                GetJournalVisits();
            }
        }

        private void DtpDateStart_ValueChanged(object sender, EventArgs e)
        {
            if (TabPages.SelectedIndex == 3)
            {
                GetJournalVisits();
            }
        }

        private void DtpDateEnd_ValueChanged(object sender, EventArgs e)
        {
            if (TabPages.SelectedIndex == 3)
            {
                GetJournalVisits();
            }
        }

        private void TbxFindUser_TextChanged(object sender, EventArgs e)
        {
            GetJournalVisits();
        }

        private void SJournal_Click(object sender, EventArgs e)
        {
            BtnAddUser.Visible = true;
            BtnEditUser.Visible = false;
            BtnDelUser.Visible = false;
            TslSelCamText.Visible = false;
            CmbCams.Visible = false;

            TabPages.SelectTab(4);

            GetUserListJournal();
        }
        /// <summary>
        /// получение и вывод списка пользователей, которые не прошли опознание
        /// </summary>
        private void GetUserListJournal()
        {
            TabCard.Controls.Clear();
            DirectoryInfo Dir = new DirectoryInfo(Application.StartupPath + "\\Source\\log\\");
            FileInfo[] Files = Dir.GetFiles();

            Dictionary<string, string> Keys = new Dictionary<string, string>();
            List<string> LstID = new List<string>();
            foreach (var t in Files)
            {
                string[] Parts = t.ToString().Split('_');
                //добавить ID очередного пользователя в список
                LstID.Add(Parts[1]);
            }
            try
            {
                SCon.Open();
                string QueryGetUserName = $@"select ID, Lastname + ' '+Firstname + ' ' + Patronymic as FIO from Users where ID in ({string.Join(", ", LstID)}) ";
                SqlCommand Cmd = new SqlCommand(QueryGetUserName, SCon);
                SqlDataReader Res = Cmd.ExecuteReader();
                if (Res.HasRows)
                {
                    while (Res.Read())
                    {
                        Keys[Res["ID"].ToString()] = Res["FIO"].ToString();
                    }
                }
                else
                {
                    MessageBox.Show("В данный момент журнал отклонённых пуст!", "ImpulseVision", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    SCon.Close();
                    return;
                }
                SCon.Close();
            }
            catch
            {
                MessageBox.Show("Ошибка получени данных журнала, повторите попытку позже!", "ImpulseVision", MessageBoxButtons.OK, MessageBoxIcon.Error);
                SCon.Close();
                return;
            }
            foreach (var t in Files)
            {
                CardJournal card = new CardJournal();
                try
                {
                    card.PbxImage.Image = Image.FromFile(Application.StartupPath + "\\Source\\log\\" + t);
                }
                catch
                {
                    card.PbxImage.Image = Properties.Resources.Frame_1;
                }

                string[] Parts = t.ToString().Split('_');
                string Name = "";

                try
                {
                    Name = Keys[Parts[1]];
                }
                catch
                {
                    Name = "Неизвестно";
                }

                card.LblUserName.Text = Name;
                card.LblCheckTime.Text = $"{Parts[2].ToString().Substring(0, 2)}:{Parts[2].ToString().Substring(2, 2)}" + " " + Parts[3];

                card.Click += Card_Click;
                card.LblUserName.Click += Card_ObjectClick;
                card.LblCheckTime.Click += Card_ObjectClick;
                card.PbxImage.Click += OpenFullView;
                card.label1.Click += Card_ObjectClick;
                card.label3.Click += Card_ObjectClick;

                TabCard.Controls.Add(card);
                if (TabCard.Controls.Count == 1)
                {
                    CurrentCard = card;
                    CurrentCard.BackColor = Color.FromArgb(195, 235, 120);
                }
            }
        }

        private void OpenFullView(object sender, EventArgs e)
        {
            FormViewPhoto Fv = new FormViewPhoto();
            Fv.PbxImage.Image = (sender as PictureBox).Image;
            Fv.ShowDialog();
        }

        private void Card_ObjectClick(object sender, EventArgs e)
        {
            CurrentCard.BackColor = Color.FromArgb(184, 184, 255);
            CurrentCard = (sender as Control).Parent as CardJournal;
            CurrentCard.BackColor = Color.FromArgb(195, 235, 120);
        }

        private void Card_Click(object sender, EventArgs e)
        {
            CurrentCard.BackColor = Color.FromArgb(184, 184, 255);
            CurrentCard = sender as CardJournal;
            CurrentCard.BackColor = Color.FromArgb(195, 235, 120);
        }
    }
}