/// <summary>
/// Sök Personer som börjar på ....
/// </summary>
private void ShowPeopleByLetter()
{
Console.Clear();
Utilitys.LogoSearch();
try
{
var db = new SQLDatabase();
Console.Write("Enter a letter: ");
var letter = Console.ReadLine();
if (letter == "")
{
Utilitys.PrintRed("Next time enter a letter");
}
else
{
var sql = "Where firstName LIKE @letter +'%'";
PrintAllPerson(db.ShowAllFrom(sql, ("@letter", letter)));
}
}
catch
{
Console.WriteLine("Invalid input, try again");
}
Console.WriteLine("Press any key to go back!");
Console.ReadLine();
}
/// <summary>
/// Visar föräldrar
/// </summary>
private void Parents()
{
Console.Clear();
Utilitys.LogoSearch();
var db = new SQLDatabase();
Console.WriteLine("Enter name on person you wanna display: ");
var name = Console.ReadLine();
var persons = db.GetPersons(name);
if (persons.Count > 0)
{
var ctr = 1;
foreach (var person in persons)
{
var info = $"{ctr++}. {person.FirstName} {person.LastName} Born: {person.Born}";
Console.WriteLine(info);
}
Console.WriteLine("0. None of the above");
var option = ChoosePerson(persons.Count);
try
{
var person = (persons[option - 1]);
var mother = db.GetPersons(person.Mother);
PrintPerson(person);
if (mother == null)
{
Console.WriteLine("No mother");
}
else
{
Console.WriteLine("Mother:");
PrintPerson(mother);
}
var father = db.GetPersons(person.Father);
if (father == null)
{
Console.WriteLine("No Father: ");
}
else
{
Console.WriteLine("Father: ");
PrintPerson(father);
}
}
catch
{
Console.WriteLine("Somthing went wrong, try again");
}
}
Console.WriteLine("Press any key to return: ");
Console.ReadKey();
}
/// <summary>
/// Visar syskon
/// </summary>
private void ShowSiblings()
{
Console.Clear();
Utilitys.LogoSearch();
var db = new SQLDatabase();
Console.WriteLine("Enter name on person you wanna display: ");
var name = Console.ReadLine();
var persons = db.GetPersons(name);
if (persons.Count > 0)
{
var ctr = 1;
foreach (var person in persons)
{
var info = $"{ctr++}. {person.FirstName} {person.LastName} Born: {person.Born}";
Console.WriteLine(info);
}
Console.WriteLine("0. None of the above");
var option = ChoosePerson(persons.Count);
if (option > 0)
{
try
{
var siblings = db.GetSiblings(persons[option - 1]);
if (siblings.Count > 0)
{
Console.WriteLine($"{persons[option - 1].FirstName}\nSiblings: ");
PrintList(siblings);
Console.Write("Press any key to return: ");
Console.ReadKey();
}
else
{
Console.WriteLine("No Siblings found\n Press enter to return");
Console.ReadKey();
}
}
catch
{
Console.WriteLine("Wrong input!");
}
}
}
else
{
Console.WriteLine("Person not found in DB");
}
Console.WriteLine("[Press any key to go back]");
Console.Clear();
}
private void ShowAllFromDatabase()
{
Console.Clear();
Utilitys.LogoSearch();
var db = new SQLDatabase();
var dt = db.ShowAllFrom();
foreach (DataRow row in dt.Rows)
{
Console.WriteLine($"ID: {row["Id"]} Name: {row["firstName"]} {row["lastName"]} " +
$"Born: {row["born"]} Mother Id: {row["motherId"]} Father Id: {row["fatherId"]}");
}
Console.WriteLine("[Press any key to go back]");
Console.ReadLine();
}
/// <summary>
/// Listar personer från databasen beroende på vad vi vill visa
/// </summary>
private void Search()
{
while (true)
{
Console.Clear();
Utilitys.LogoSearch();
var db = new SQLDatabase();
Console.WriteLine("What do you wanna search for? ");
Console.WriteLine("1. People starting with a certain letter");
Console.WriteLine("2. People born a certain year");
Console.WriteLine("3. People misssing data");
Console.WriteLine("4. Show parents to a certain person");
Console.WriteLine("5. Show siblings to a certain person");
Console.WriteLine("6. Show all in DB");
Console.WriteLine("7. Exit to main menu");
var input = Console.ReadLine();
switch (input)
{
case "1":
ShowPeopleByLetter();
break;
case "2":
ShowWhenPeopleBorn();
break;
case "3":
ShowPeopleMissingData();
break;
case "4":
Parents();
break;
case "5":
ShowSiblings();
break;
case "6":
ShowAllFromDatabase();
break;
case "7":
Menu();
break;
}
}
}
/// <summary>
/// Visar Personer som saknar data i databasen
/// </summary>
private void ShowPeopleMissingData()
{
while (true)
{
Console.Clear();
Utilitys.LogoSearch();
var db = new SQLDatabase();
Console.WriteLine("Missing Infos Menu");
Console.WriteLine("1. Show persons missing date of birth");
Console.WriteLine("2. Show persons missing date of death");
Console.WriteLine("3. Show persons missing MotherId");
Console.WriteLine("4. Show persons missing FatherID");
Console.WriteLine("5. Exit to main menu");
var sql = "";
var input = Console.ReadLine();
switch (input)
{
case "1":
sql = "Where born=0";
break;
case "2":
sql = "Where died=0";
break;
case "3":
sql = "Where motherId=0";
break;
case "4":
sql = "Where fatherId=0";
break;
case "5":
Menu();
break;
}
Console.Clear();
PrintAllPerson(db.ShowAllFrom(sql));
Console.WriteLine("Press any key to return: ");
Console.ReadKey();
}
}
/// <summary>
/// Listar personer efter år
/// </summary>
private void ShowWhenPeopleBorn()
{
Console.Clear();
Utilitys.LogoSearch();
try
{
var db = new SQLDatabase();
Console.Write("Enter year: ");
var year = Convert.ToInt32(Console.ReadLine());
var sql = "Where born = @born";
PrintAllPerson(db.ShowAllFrom(sql, ("@born", $"{year}")));
}
catch
{
Console.WriteLine("Invalid Input, try again! ");
}
Console.WriteLine("Press any key to go back!");
Console.ReadKey();
}
