private static void DisplayFirearmDetail()
        {
            FirearmRepositorySQL firearmRepository = new FirearmRepositorySQL();
            List <Firearm>       firearms;
            Firearm firearm = new Firearm();
            int     firearmID;

            using (firearmRepository)
            {
                firearms  = firearmRepository.SelectAll();
                firearmID = ConsoleView.GetFirearmID(firearms);
                firearm   = firearmRepository.SelectById(firearmID);
            }

            ConsoleView.DisplayFirearm(firearm);
            ConsoleView.DisplayContinuePrompt();
        }