//Add new user
internal static async Task addPersonalData(PersonalData personalData)
{
query = "INSERT INTO PersonalData " +
"(FirstName, LastName, BirthDate, IDUser)" +
"VALUES " +
$"('{personalData.FirstName}','{personalData.LastName}'," +
$"'{personalData.BirthDate}','{personalData.IDUser}');";
using (var connection = new NpgsqlConnection(AppSettingProvider.connString))
{
connection.Open();
await connection.ExecuteAsync(query);
}
}
internal static PersonalData getPersonalDataByUserID(string userID)
{
query = "SELECT * FROM PersonalData AS PD " +
"LEFT JOIN \"user\" AS U " +
"ON PD.IDUser = U.ID_User " +
$"WHERE PD.IDUser = '******';";
PersonalData ps = null;
using (var connection = new NpgsqlConnection(AppSettingProvider.connString))
{
connection.Open();
ps = connection.Query <PersonalData>(query).FirstOrDefault();
}
return(ps);
}