public void CreateCommandAction()
 {
     if (String.IsNullOrWhiteSpace(_seriesName) || String.IsNullOrWhiteSpace(_seriesShort) || String.IsNullOrWhiteSpace(_sanctioningBody))
     {
         ShowDialog("Please enter all required inputs!");
     }
     else
     {
         Series temp = new Series
         {
             SeriesName      = SeriesName,
             SeriesShort     = SeriesShort,
             SeriesLogo      = SeriesLogo,
             SanctioningLogo = SanctioningLogo,
         };
         try
         {
             SeriesQueries.CreateSeries(temp);
         } catch (ArgumentException e)
         {
             ShowDialog(e.Message);
         }
         Clear();
     }
 }
        public void LoadSeries()
        {
            var allSeries = SeriesQueries.GetSeries();

            _series = new ObservableCollection <SelectableViewModel>();
            foreach (Series series in allSeries)
            {
                StringBuilder sb = new StringBuilder(series.SeriesName);
                sb.Append(" - ");
                sb.Append(series.Seasons.Count);
                sb.Append(series.Seasons.Count == 1 ? " Season" : " Seasons");

                _series.Add(new SelectableViewModel
                {
                    Name        = series.SeriesShort,
                    Description = sb.ToString(),
                    Code        = series.SeriesName[0],
                });
            }
        }