public async Task <bool> Authenticate(string userName, string hashPass)
{
var DatabaseManager = Shared.DBconnection.GetManager();
try
{
MSSQLQueryBuilder QBuilder = new MSSQLQueryBuilder();
Query query = QBuilder.BuildQuery("users", new[] { "userName", "hashString" });
object[][] table = await DatabaseManager.ExecuteTableAsync(DatabaseManager.GetConnection(), query.QueryString).ConfigureAwait(false);
for (int i = 0; i < table.Length; i++)
{
if (table[i][0].Equals(userName) && table[i][1].Equals(hashPass))
{
return(true);
}
}
}
finally
{
DatabaseManager.GetConnection().Close();
}
return(false);
}
