public IEnumerable <Pattern> GetPatterns()
        {
            var patterns = Startup.database.getpat();

            foreach (var pattern in patterns)
            {
                _context.db_patterns.Add(pattern);
            }
            _context.SaveChanges();


            var categories = Startup.database.getcat();

            foreach (var category in categories)
            {
                _context.db_categories.Add(category);
            }
            _context.SaveChanges();

            return(_context.GetPatterns());
        }