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();
}
