UserSelectableModel.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.IO;
using System.Linq;
using System.Runtime.CompilerServices;
using System.Text;
using System.Threading.Tasks;
using System.Drawing;
using System.Windows.Media.Imaging;
using WpfAnimatedGif;
using System.Windows.Media;
using SQLWPF;
using System.Windows;
using System.Windows.Controls.Primitives;
using System.Drawing.Imaging;

namespace MaterialDesignColors.WpfExample.Domain
{
    public class UserSelectableModel : INotifyPropertyChanged
    {
        private bool _isSelected;
        private int _userID;


        private string _name;
        private string _mail;
        private ImageSource _icon;
        private string _initials;
        private int? _age;
        private string _userName;
        private string _playerNames;

        private Visibility _playerVisiblity;
        private string _playerNamesText;

        public UserSelectableModel(SQLWPF.Users User)
        {
            _userID = User.ID;

            _name = $"{User.FirstName.Trim()} {User.Lastname.Trim()}";
            _mail = User.Mail;
            _initials += $"{User.FirstName.Trim().First()}{User.Lastname.Trim().First()}";
            _age = User.Age;
            _userName = User.Username.Trim();


            System.Windows.Controls.Image image = new System.Windows.Controls.Image();

            if (User.UserIcon != null)
            {
                long hello = User.UserIcon.LongLength;

                if (hello > 0)
                {
                    _icon = DecodePhoto(User.UserIcon);
                }
                else
                    _icon = null;
            }

            using (permissionsDatabaseModel e = new permissionsDatabaseModel())
            {
                //int hello = e.Users.Max(p => p.ID);

                if (e.Users_Players.Any(p => p.UserID == _userID))
                {
                    var mål = new List<string>();
                    mål = (from UsersPlayers in e.Users_Players

                           join connectPlayer in e.Players
                           on UsersPlayers.PlayerID equals connectPlayer.ID

                           join connectUser in e.Users
                           on UsersPlayers.UserID equals connectUser.ID

                           where UsersPlayers.UserID == _userID

                           select UsersPlayers.Players1.PlayerName).ToList();

                    for (int i = 0; i < mål.Count(); i++)
                    {
                        if (i + 1 == mål.Count())
                            _playerNames += $"{mål[i].Trim()}";
                        else
                            _playerNames += $"{mål[i].Trim()}, ";
                    }

                    _playerNamesText = "PlayerNames: ";
                }
                else
                {
                    _playerVisiblity = Visibility.Hidden;

                    _playerNamesText = "";
                }
            }
        }

        public BitmapImage DecodePhoto(byte[] byteVal)
        {
            MemoryStream strmImg = new MemoryStream(byteVal);
            BitmapImage myBitmapImage = new BitmapImage();
            myBitmapImage.BeginInit();
            myBitmapImage.StreamSource = strmImg;
            myBitmapImage.EndInit();
            return myBitmapImage;

        }

        public bool IsSelected
        {
            get { return _isSelected; }
            set
            {
                if (_isSelected == value) return;
                _isSelected = value;
                OnPropertyChanged();
            }
        }

        public int UserID
        {
            get { return _userID; }
            set
            {
                if (_userID == value) return;
                _userID = value;
                OnPropertyChanged();
            }
        }

        public ImageSource Icon
        {
            get { return _icon; }
            set
            {
                if (_icon == value) return;
                _icon = value;
                OnPropertyChanged();
            }
        }

        public Visibility PlayerVisiblity
        {
            get { return _playerVisiblity; }
            set
            {
                if (_playerVisiblity == value) return;
                _playerVisiblity = value;
                OnPropertyChanged();
            }
        }

        public string Name
        {
            get { return _name; }
            set
            {
                if (_name == value) return;
                _name = value;
                OnPropertyChanged();
            }
        }

        public string PlayerNames
        {
            get { return _playerNames; }
            set
            {
                if (_playerNames == value) return;
                _playerNames = value;
                OnPropertyChanged();
            }
        }

        public string Initials
        {
            get { return _initials; }
            set
            {
                if (_initials == value) return;
                _initials = value;
                OnPropertyChanged();
            }
        }

        public string Mail
        {
            get { return _mail; }
            set
            {
                if (_mail == value) return;
                _mail = value;
                OnPropertyChanged();
            }
        }


        public string PlayerNamesText
        {
            get { return _playerNamesText; }
            set
            {
                if (_playerNamesText == value) return;
                _playerNamesText = value;
                OnPropertyChanged();
            }
        }

        public int? Age
        {
            get { return _age; }
            set
            {
                if (_age == value) return;
                _age = value;
                OnPropertyChanged();
            }
        }

        public string UserName
        {
            get { return _userName; }
            set
            {
                if (_userName == value) return;
                _userName = value;
                OnPropertyChanged();
            }
        }

        public event PropertyChangedEventHandler PropertyChanged;

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