/**
* @author Anthony Scheeres
*/
private bool isValideUsernamePasswordEmail(string username, string password, string email)
{
return(!ValidateInputUtilities.isNullOrEmty(username) && !ValidateInputUtilities.isNullOrEmty(password) && ValidateInputUtilities.IsValidEmail(email));
}
private double TokenToUserIdn(string token)
{
var sqlQueryForRegistingUser = "******";
using var connectionWithDatabase = ConnectionProvider.getProvide();
connectionWithDatabase.Open(); //open the connection
using var command = new NpgsqlCommand(sqlQueryForRegistingUser, connectionWithDatabase);
command.Parameters.AddWithValue("token", token);
command.Prepare(); //Construct and optimize query
var i = command.ExecuteReader();
int id = 0;
PsqlUtilities.GetAll(i).ForEach(r => { Console.WriteLine(r.GetValue(0).ToString()); if (ValidateInputUtilities.isNumeric(r.GetValue(0).ToString()))
{
id = int.Parse(r.GetValue(0).ToString());
}
});
connectionWithDatabase.Close(); //close the connection to save bandwith
return(id);
}
