private static void ListAllFirearms() { FirearmRepositorySQL firearmRepository = new FirearmRepositorySQL(); List <Firearm> firearm; using (firearmRepository) { firearm = firearmRepository.SelectAll(); ConsoleView.DisplayAllFirearms(firearm); ConsoleView.DisplayContinuePrompt(); } }
private static void AddFirearm() { FirearmRepositorySQL firearmRepository = new FirearmRepositorySQL(); Firearm firearm = new Firearm(); firearm = ConsoleView.AddFirearm(); using (firearmRepository) { firearmRepository.Insert(firearm); } ConsoleView.DisplayContinuePrompt(); }
private static void UpdateSkiRun() { FirearmRepositorySQL firearmRepository = new FirearmRepositorySQL(); List <Firearm> firearms = firearmRepository.SelectAll(); Firearm firearm = new Firearm(); int firearmID; using (firearmRepository) { firearms = firearmRepository.SelectAll(); firearmID = ConsoleView.GetFirearmID(firearms); firearm = firearmRepository.SelectById(firearmID); firearm = ConsoleView.UpdateFirearm(firearm); firearmRepository.Update(firearm); } }
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(); }
private static void QueryFirearmsById() { FirearmRepositorySQL firearmRepository = new FirearmRepositorySQL(); IEnumerable <Firearm> matchingFirearms = new List <Firearm>(); int lowerId; int higherId; ConsoleView.GetIdQueryLowHiValues(out lowerId, out higherId); using (firearmRepository) { matchingFirearms = firearmRepository.QueryById(lowerId, higherId); } ConsoleView.DisplayQueryResults(matchingFirearms); ConsoleView.DisplayContinuePrompt(); }
private static void DeleteFirearm() { FirearmRepositorySQL firearmRepository = new FirearmRepositorySQL(); List <Firearm> firearms = firearmRepository.SelectAll(); Firearm firearm = new Firearm(); int firearmID; string message; firearmID = ConsoleView.GetFirearmID(firearms); using (firearmRepository) { firearmRepository.Delete(firearmID); } ConsoleView.DisplayReset(); message = String.Format("Firearm ID: {0} had been deleted.", firearmID); ConsoleView.DisplayMessage(message); ConsoleView.DisplayContinuePrompt(); }