public static async Task <List <Workout> > GetAllWorkouts(SQLiteAsyncConnection _connection)
{
var users = await UsersCredentials.GetAllUsers(_connection);
var user = users[0];
return(await _connection.Table <Workout>()
.Where(g => g.UserGuid == user.UserGuid)
.ToListAsync());
}
public static async Task <List <Workout> > GetAllWorkoutRecordsByDate(SQLiteAsyncConnection _connection, DateTime date)
{
var users = await UsersCredentials.GetAllUsers(_connection);
var user = users[0];
return(await _connection.Table <Models.Persistence.Workout>()
.Where(w => w.WorkoutDate == date)
.Where(g => g.UserGuid == user.UserGuid)
.ToListAsync());
}
public static async Task <List <Workout> > GetAllWorkoutRecordsForTheLast30Days(SQLiteAsyncConnection _connection)
{
var users = await UsersCredentials.GetAllUsers(_connection);
var user = users[0];
var date = DateTime.Now.AddDays(-30);
return(await _connection.Table <Models.Persistence.Workout>()
.Where(w => w.WorkoutDate > date)
.Where(g => g.UserGuid == user.UserGuid)
.ToListAsync());
}