public ICommand AddCommand => new Command(async () => await Add());
async Task Add()
{
using var conn = new NpgsqlConnection(connString);
await conn.OpenAsync();
var cmd = new NpgsqlCommand("INSERT INTO users (username,password) VALUES (@username, @password)", conn);
cmd.Parameters.AddWithValue("password",Password);
cmd.Parameters.AddWithValue("username", Login);
await cmd.ExecuteNonQueryAsync();
int id = await InfoIdent();
await Application.Current.MainPage.DisplayAlert("Successful!", $"Create Account!\nWelcome {Login}\nYour ID:{id}", "Ok");
}
async Task<int> InfoIdent()
{
using var conn = new NpgsqlConnection(connString);
await conn.OpenAsync();
var cmd = new NpgsqlCommand(
"SELECT id FROM users WHERE username = @username",
conn);
cmd.Parameters.AddWithValue("username", Login);
var result = await cmd.ExecuteScalarAsync();
return Convert.ToInt32(result);
}