private static void ListAllGreatPeople() { GreatPeopleRepositorySQL greatPersonRepository = new GreatPeopleRepositorySQL(); List <GreatPeople> greatPeople; using (greatPersonRepository) { greatPeople = greatPersonRepository.SelectAll(); ConsoleView.DisplayAllGreatPeople(greatPeople); ConsoleView.DisplayContinuePromptInvisible(); } }
private static void AddGreatPerson() { GreatPeopleRepositorySQL greatPersonRepository = new GreatPeopleRepositorySQL(); GreatPeople greatPerson = new GreatPeople(); greatPerson = ConsoleView.AddGreatPerson(); using (greatPersonRepository) { greatPersonRepository.Insert(greatPerson); } //ConsoleView.DisplayContinuePromptInvisible(); }
private static void UpdateGreatPerson() { GreatPeopleRepositorySQL greatPeopleRepository = new GreatPeopleRepositorySQL(); List <GreatPeople> greatPerson = greatPeopleRepository.SelectAll(); GreatPeople greatPeople = new GreatPeople(); int greatPersonID; using (greatPeopleRepository) { greatPerson = greatPeopleRepository.SelectAll(); greatPersonID = ConsoleView.GetGreatPersonID(greatPerson); greatPeople = greatPeopleRepository.SelectById(greatPersonID); greatPeople = ConsoleView.UpdateGreatPerson(greatPeople); greatPeopleRepository.Update(greatPeople); } }
private static void DisplayGreatPersonDetail() { GreatPeopleRepositorySQL greatPeopleRepository = new GreatPeopleRepositorySQL(); List <GreatPeople> greatPeople; GreatPeople greatPerson = new GreatPeople(); int greatPersonID; using (greatPeopleRepository) { greatPeople = greatPeopleRepository.SelectAll(); greatPersonID = ConsoleView.GetGreatPersonID(greatPeople); greatPerson = greatPeopleRepository.SelectById(greatPersonID); } ConsoleView.DisplayGreatPerson(greatPerson); ConsoleView.DisplayContinuePromptInvisible(); }
private static void QueryByDateBorn() { GreatPeopleRepositorySQL greatPeopleRepository = new GreatPeopleRepositorySQL(); IEnumerable <GreatPeople> matchingDate = new List <GreatPeople>(); int minimumDate; int maximumDate; ConsoleView.GetDateMinMaxValues(out minimumDate, out maximumDate); using (greatPeopleRepository) { matchingDate = greatPeopleRepository.QueryByDateBorn(minimumDate, maximumDate); } ConsoleView.DisplayQueryResults(matchingDate); Console.WriteLine(); Console.WriteLine(); Console.ForegroundColor = System.Drawing.Color.LawnGreen; ConsoleView.DisplayContinuePromptInvisible(); }
private static void DeleteGreatPerson() { GreatPeopleRepositorySQL greatPeopleRepository = new GreatPeopleRepositorySQL(); List <GreatPeople> greatPeople = greatPeopleRepository.SelectAll(); GreatPeople greatPerson = new GreatPeople(); int greatPersonID; string message; greatPersonID = ConsoleView.GetGreatPersonID(greatPeople); using (greatPeopleRepository) { greatPeopleRepository.Delete(greatPersonID); } ConsoleView.DisplayReset(); message = String.Format("Great Person ID: {0} had been deleted.", greatPersonID); ConsoleView.DisplayMessage(message); ConsoleView.DisplayContinuePromptInvisible(); }