public User SelectByUsernameAndPassword(string username, string password)
{
return(PerformQuery(() =>
{
return AsyncConnection.Table <User>()
.Where(x => x.Username.ToLower().Equals(username.ToLower()) && x.Password.Equals(password))
.FirstOrDefaultAsync();
}));
}
/// <summary>
/// Select the Accelerometer-records between 2 DateTime-objects.
/// </summary>
/// <param name="start">The start DateTime.</param>
/// <param name="end">The end DateTime.</param>
/// <returns>A collection of Accelerometer-records.</returns>
public IEnumerable <Accelerometer> SelectBetweenDates(DateTime start, DateTime end)
{
return(PerformQuery(() =>
{
return AsyncConnection.Table <Accelerometer>()
.Where(x => x.DateTime >= start && x.DateTime <= end)
.ToListAsync();
}));
}