public string GetConnectionString()
{
return(Type switch
{
Database.Mssql =>
$"Server={Server} ; {(Username.Any() ? "user id=" + Username + ";" : "")} {(Password.Any() ? "Password="******";" : "")} Database={DataBase}; {(!Username.Any() ? "Trusted_Connection=True" : "")}; Enlist=true",
Database.Postgres =>
$"Server={Server} ; Port={(Port == 0 ? "" : Port.ToString())}; {(Username.Any() ? "user id=" + Username + ";" : "")} {(Password.Any() ? "Password="******";" : "")} Database={DataBase}; {(!Username.Any() ? "Trusted_Connection=True" : "")}; Enlist=true",
Database.Mysql => "",
Database.SqlLite => "",
_ => throw new NotImplementedException("Database not recognized.")
});
private bool CanTryRegister(object parameter)
{
Password = (parameter as PasswordBox).Password;
if (String.IsNullOrEmpty(Username) || String.IsNullOrEmpty(Password))
{
return(false);
}
if (Username.Any(x => Char.IsWhiteSpace(x)) || Password.Any(x => Char.IsWhiteSpace(x)))
{
return(false);
}
return(true);
}
public bool ValidateUsername()
{
// Check account database for existing username
AccountDatabase database = new AccountDatabase();
database.OpenConnection();
// If there is an existing account, update the validation message
if (database.LookUpAccountRecord(Username, Password).ErrorString != "no record found")
{
usernameValidationMessage = "\u2022 Username already exists. \n";
}
else if (Username == null || Username.Trim().Length == 0)
{
UsernameValidationMessage = "\u2022 Username cannot be empty. \n";
}
else
{
UsernameValidationMessage = null;
if (Username.Trim().Length < 7)
{
UsernameValidationMessage += "\u2022 Username must be at least 7 characters long. \n";
}
if (Username.Trim().Length > 20)
{
UsernameValidationMessage += "\u2022 Username cannot be more than 20 characters long. \n";
}
if ((Username.Any(char.IsWhiteSpace)))
{
UsernameValidationMessage += "\u2022 Username cannot contain spaces. \n";
}
}
// Close connection to Account Database
database.CloseConnection();
// If username has not been disqualified, send an "acceptable" message
if (UsernameValidationMessage == null)
{
UsernameValidationMessage = "\u2022 Username is acceptable. \n";
return(true);
}
else
{
return(false);
}
}
private bool ContinueCommandCanExecute()
{
if (string.IsNullOrWhiteSpace(Username) || Username.Length < 4)
{
return(false);
}
if (Username.Any(ch => !Char.IsLetterOrDigit(ch)))
{
return(false);
}
if (string.IsNullOrWhiteSpace(Email) || Email.Length < 5)
{
return(false);
}
if (string.IsNullOrWhiteSpace(Password) || Password.Length < 5)
{
return(false);
}
if (string.IsNullOrWhiteSpace(Name) || Name.Length < 5)
{
return(false);
}
if (string.IsNullOrWhiteSpace(Nickname) || Nickname.Length < 5)
{
return(false);
}
if (string.IsNullOrWhiteSpace(AvatarSource))
{
return(false);
}
if (DateOfBirth == null ||
DateOfBirth.Year <= 1950 ||
DateOfBirth.Year >= DateTime.Now.AddYears(-12).Year)
{
return(false);
}
if (Gender == null)
{
return(false);
}
return(true);
}
