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