public async Task UpdateLastEntryToNowAsync(long Id)
{
LoginCredentialsDataModel loginCred = await _clientDbContext.LoginCredentials.FindAsync(Id);
loginCred.LastEntry = DateTime.Now;
await _clientDbContext.SaveChangesAsync();
}
public async Task SaveLoginCredentialsAsync(LoginCredentialsDataModel loginCredentials)
{
_dbContext.LoginCredentials.RemoveRange(_dbContext.LoginCredentials);
_dbContext.LoginCredentials.Add(loginCredentials);
await _dbContext.SaveChangesAsync();
}
public async Task UpdateIsLogoutAsync(long Id, bool IsLogout)
{
LoginCredentialsDataModel loginCred = await _clientDbContext.LoginCredentials.FindAsync(Id);
loginCred.IsLogout = IsLogout;
await _clientDbContext.SaveChangesAsync();
}
public async Task UpdateUserWhenLogin(long userIdWhichUpdate, string Jwt, string RefreshToken)
{
LoginCredentialsDataModel loginCred = await _clientDbContext.LoginCredentials.FindAsync(userIdWhichUpdate);
loginCred.Jwt = Jwt;
loginCred.RefreshToken = RefreshToken;
await _clientDbContext.SaveChangesAsync();
}
// ToDo: Подумать ещё раз
public async Task UpdateTokensAsync(LoginCredentialsDataModel LoginCred, string Jwt, string RefreshToken)
{
LoginCredentialsDataModel loginCred = await _clientDbContext.LoginCredentials.FindAsync(LoginCred.Id);
loginCred.Jwt = Jwt;
loginCred.RefreshToken = RefreshToken;
await _clientDbContext.SaveChangesAsync();
}
public async Task UpdateEmailAndTokenAsync(LoginCredentialsDataModel LoginCred)
{
LoginCredentialsDataModel loginCred = await _clientDbContext.LoginCredentials.FindAsync(LoginCred.Id);
loginCred.Email = LoginCred.Email;
loginCred.Jwt = LoginCred.Jwt;
await _clientDbContext.SaveChangesAsync();
}
/// <summary>
/// Stores the given login credentials to the backing data store
/// </summary>
/// <param name="loginCredentials">The login credentials to save</param>
/// <returns>Returns a task that will finish once save is complete</returns>
public async Task SaveLoginCredentialsAsync(LoginCredentialsDataModel loginCredentials)
{
// Clear all entries
mDbContext.LoginCredentials.RemoveRange(mDbContext.LoginCredentials);
// Add new one
mDbContext.LoginCredentials.Add(loginCredentials);
// Save changes
await mDbContext.SaveChangesAsync();
}
/// <summary>
/// Saves the user's login credentials locally
/// </summary>
/// <param name="loginCredentials"> The credentials to save </param>
/// <returns></returns>
public async Task SaveLoginCredentialsAsync(LoginCredentialsDataModel loginCredentials)
{
// To ensure no duplicates and other unexpected behaviours
// Delete all Login credentials
_clientDataStoreDBContext.LoginCredentials.RemoveRange(_clientDataStoreDBContext.LoginCredentials);
// Add the new credentials
_clientDataStoreDBContext.LoginCredentials.Add(loginCredentials);
// Save changes
await _clientDataStoreDBContext.SaveChangesAsync();
}
/// <summary>
/// Stores the given login credentials to the backing data store
/// </summary>
/// <param name="loginCredentials">The login credentials to save</param>
/// <returns>Returns a task that will finish once the save is complete</returns>
public async Task SaveLoginCredentialsAsync(LoginCredentialsDataModel loginCredentials)
{
// TODO: Replace with stored procedure/Transactions
// Clear all entries
mDbContext.LoginCredentials.RemoveRange(mDbContext.LoginCredentials);
// Add new one
mDbContext.LoginCredentials.Add(loginCredentials);
// Save changes
await mDbContext.SaveChangesAsync();
}
public async Task RegisterUserAsync(LoginCredentialsDataModel LoginCred)
{
LoginCredentialsDataModel loginCred = new LoginCredentialsDataModel
{
Email = LoginCred.Email,
Jwt = LoginCred.Jwt,
RefreshToken = LoginCred.RefreshToken,
LastEntry = DateTime.Now,
IsLogout = false,
};
await _clientDbContext.LoginCredentials.AddAsync(loginCred);
_clientDbContext.SaveChanges();
}
/// <summary>
/// Save the users login credentials to data store
/// </summary>
/// <returns></returns>
private async Task SaveLoginCredentials()
{
var loginCredentials = new LoginCredentialsDataModel
{
Id = Guid.NewGuid().ToString(),
Email = "*****@*****.**",
FirstName = "Peter",
LastName = "Ayobami",
Username = "******",
Token = Guid.NewGuid().ToString()
};
await ClientDataStore.SaveLoginCredentialsAsync(loginCredentials);
}
//ToDo: переназвать
public async Task EntryToAppAsync(string Email, string Jwt, string RefreshToken)
{
LoginCredentialsDataModel loginCredentials = new LoginCredentialsDataModel()
{
Email = Email,
Jwt = Jwt,
RefreshToken = RefreshToken,
LastEntry = DateTime.Now,
IsLogout = false
};
await _clientRepo.UpdateOrAddUserAsync(loginCredentials);
//PageChanged?.Invoke(this, new ApplicationWindowEventArgs(prevPage));
}
public async Task UpdateOrAddUserAsync(LoginCredentialsDataModel LoginCred)
{
LoginCredentialsDataModel loginCred = await(Task.Run(() => _clientDbContext.LoginCredentials.SingleOrDefault(creds => creds.Email == LoginCred.Email)));
if (loginCred != null)
{
loginCred.Jwt = LoginCred.Jwt;
loginCred.RefreshToken = LoginCred.RefreshToken;
loginCred.IsLogout = LoginCred.IsLogout;
loginCred.LastEntry = LoginCred.LastEntry;
}
else
{
await _clientDbContext.LoginCredentials.AddAsync(LoginCred);
}
await _clientDbContext.SaveChangesAsync();
}
public Task <LoginResultDataModel> CheckLoginAsync(LoginCredentialsDataModel loginCredentials)
{
if (string.IsNullOrWhiteSpace(loginCredentials.Email))
{
return(null);
}
var user = dbContext.LoginCredentials.Where(e => e.Email == loginCredentials.Email && e.Password == HashString(loginCredentials.Password)).FirstOrDefault();
if (user == null)
{
return(null);
}
return(Task.FromResult(new LoginResultDataModel {
Email = user.Email,
Successful = true,
UserId = user.UserId
}));
}
public async Task <bool> AddNewUserAsync(LoginCredentialsDataModel loginCredentials)
{
if (string.IsNullOrWhiteSpace(loginCredentials.Email))
{
return(false);
}
var user = dbContext.LoginCredentials.Where(e => e.Email == loginCredentials.Email && e.Password == HashString(loginCredentials.Password)).FirstOrDefault();
if (user != null)
{
return(false);
}
string userId = Guid.NewGuid().ToString("N");
bool unique;
do
{
unique = true;
if (dbContext.LoginCredentials.Where(e => e.UserId == userId).Any())
{
userId = Guid.NewGuid().ToString("N");
unique = false;
}
} while (!unique);
dbContext.LoginCredentials.Add(new LoginDatabaseModel {
Email = loginCredentials.Email,
Password = HashString(loginCredentials.Password),
UserId = userId
});
await dbContext.SaveChangesAsync();
return(true);
}
public string GetEmail(long Id)
{
LoginCredentialsDataModel user = _clientDbContext.LoginCredentials.FirstOrDefault(creds => creds.Id == Id);
return(user.Email);
}
public async Task <LoginCredentialsDataModel> GetUserLoginCredentialsAsync(string Email)
{
LoginCredentialsDataModel user = await _clientDbContext.LoginCredentials.FindAsync(Email);
return(user);
}
public async Task <LoginCredentialsDataModel> GetUserLoginCredentialsAsync(long Id)
{
LoginCredentialsDataModel user = await _clientDbContext.LoginCredentials.FindAsync(Id);
return(user);
}
public async Task AddUserAsync(LoginCredentialsDataModel LoginCred)
{
await _clientDbContext.LoginCredentials.AddAsync(LoginCred);
_clientDbContext.SaveChanges();
}
