public void TreeMonDbContext_Context_Update_Async()
{
Task.Run(async() =>
{
TreeMonDbContext context = new TreeMonDbContext("MSSQL_TEST");
_userAsync = context.GetAll <User>().FirstOrDefault();
_userAsync.Name = "UPDATE_ASYNC_TEST";
int res = await context.UpdateAsync <User>(_userAsync);
Assert.AreEqual(res, 1);
Assert.AreEqual(context.Get <User>(_userAsync.Id).Name, "UPDATE_ASYNC_TEST");
}).GetAwaiter().GetResult();
}
/// <summary>
/// </summary>
/// <param name="userName"></param>
/// <param name="password"></param>
/// <param name="ip"></param>
/// <returns></returns>
public async Task <ServiceResult> AuthenticateUserAsync(string userName, string password, string ip)
{
if (string.IsNullOrWhiteSpace(userName))
{
using (var context = new TreeMonDbContext(this._connectionKey))
{
await context.InsertAsync <AuthenticationLog>(new AuthenticationLog()
{
Authenticated = false, AuthenticationDate = DateTime.UtcNow, IPAddress = ip, FailType = "Blank Username", UserName = userName, UUIDType = "AuthenticationLog", Vector = "UserManager.AuthenticateUser"
});
}
return(ServiceResponse.Error("Invalid username or password."));
}
User user = null;
try
{
using (var context = new TreeMonDbContext(this._connectionKey))
{
user = (await context.GetAllAsync <User>()).FirstOrDefault(uw => (uw.Name?.EqualsIgnoreCase(userName) ?? false));
if (user == null)
{
return(ServiceResponse.Error("Invalid username or password."));
}
user.LastActivityDate = DateTime.UtcNow;
if (!PasswordHash.ValidatePassword(password, user.PasswordHashIterations + ":" + user.PasswordSalt + ":" + user.Password))
{
context.Insert <AuthenticationLog>(new AuthenticationLog()
{
Authenticated = false, AuthenticationDate = DateTime.UtcNow, IPAddress = ip, FailType = "Invalid Password", UserName = userName, UUIDType = "AuthenticationLog", Vector = "UserManager.AuthenticateUser"
});
user.FailedPasswordAttemptCount++;
context.Update <User>(user);
return(ServiceResponse.Error("Invalid username or password."));
}
ServiceResult sr = IsUserAuthorized(user, ip);
if (sr.Status == "ERROR")
{
return(sr);
}
user.Online = true;
user.LastLoginDate = DateTime.UtcNow;
await context.UpdateAsync <User>(user);
}
}
catch (Exception ex)
{
_logger.InsertError(ex.Message, "UserManager", "AuthenticateUserAsync:" + userName + " IP:" + ip);
return(ServiceResponse.Error(ex.Message));
}
return(ServiceResponse.OK());
}
