public IActionResult ImportTests(ImportTestsViewModel viewModel)
        {
            var tests         = ImportExportUtil.CreateTests(viewModel.Separator, viewModel.Text);
            var allCategories = _database.Categories.ToList();

            tests.ForEach(t =>
            {
                var category = _database.Categories.FirstOrDefault(c => c.Name == t.CategoryName);
                if (category == null)
                {
                    category = new CategoryModel
                    {
                        Name = t.CategoryName
                    };

                    _database.Categories.Add(category);
                    _database.SaveChanges();
                }

                t.CategoryID = category.ID;

                _database.CategoryTests.Add(t);
            });

            _database.SaveChanges();

            return(RedirectToAction("Index"));
        }
        public IActionResult ImportTests()
        {
            var viewModel = new ImportTestsViewModel
            {
                Instructions = Strings.ImportTests,
                Separator    = ','
            };

            return(View(viewModel));
        }