/// <summary>
/// Put information form person type into personseeking type.
/// </summary>
/// <returns> A list of PersonSeeking type. </returns>
public List <PersonSeeking> GetPersonSeeking2(string name, string query)
{
List <object> translated = new List <object>();
List <PersonSeeking> personS = new List <PersonSeeking>();
List <Person> person = new List <Person>();
person = GetPerson(name, query);
foreach (Person p in person)
{
// Populate the list of the translated information.
translated = Translator(p);
// Create a new person and populate it.
PersonSeeking ps = new PersonSeeking
{
Firstname = p.Firstname,
Lastname = p.Lastname,
Mail = p.Mail,
Seeking = p.Seeking,
Picture = p.Picture,
City = translated[1].ToString()
};
// Add the new person to the list.
personS.Add(ps);
}
return(personS);
}
/// <summary>
/// Click handler for Query button.
/// Has multiple query string into the databse based on the input given.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonQuery_Click(object sender, EventArgs e)
{
string box = nameIDBox.Text;
// Columns - Empty for picture
string[] columns = { "Name:150", "City:100", "Mail:100", "Seeks:50", ":0" };
int testInput;
try
{
try
{
testInput = Convert.ToInt32(box);
}
catch
{
testInput = -1;
}
if (box != "" && box != null)
{
// If contain "-" then birthday is provided.
if (box.Contains("-"))
{
// Query by birthday
peopleSeeking = db.GetPersonSeeking2("DateApp", $"SELECT * FROM person WHERE birthday like '{box}%'");
}
// If the test int is higher then -1 (correct id) then an id is provided.
else if (testInput >= 0)
{
// Query ID - And call display image.
peopleSeeking = db.GetPersonSeeking("DateApp", "ID", box);
// Instaziate a new person to extract profile picture.
PersonSeeking person = peopleSeeking[0];
// Only call show picture code if there is an image.
if (person.Picture != null)
{
// Call the function to show the profile picture.
showProfilePicture(person.Picture);
}
}
// Name most be provided.
else
{
box = box.Trim();
peopleSeeking = db.GetPersonSeeking("DateApp", "Name", $"'{box}%'");
}
gh.ListPeopleView(listViewPerson, peopleSeeking, columns);
}
else
{
// Show message
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
