private async Task InsertWorkoutGroup_User(WorkoutGroup_User wgu)
{
using (var context = new GasContext())
{
try
{
context.SetupServer();
context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
for (int i = 0; i < 5; ++i)
{
Debug.WriteLine($"{i} - Find the error!");
}
await Task.Run(() => context.WorkoutGroups_Users.Add(wgu));
//await Task.Run(() => _gasContext.WorkoutGroups_Users.Add(wgu));
for (int i = 0; i < 5; ++i)
{
Debug.WriteLine($"{i} - Find the error!");
}
//await context.SaveChangesAsync();
context.SaveChanges();
//_gasContext.SaveChanges();
}
catch (Exception e)
{
Debug.WriteLine(e.InnerException.Message);
}
}
}
private void DeleteWorkoutGroup_User(WorkoutGroup_User wgu)
{
using (var context = new GasContext())
{
context.SetupServer();
context.WorkoutGroups_Users.Remove(wgu);
context.SaveChanges();
}
}
private async void UpdateWorkoutGroup_User(WorkoutGroup_User updatedWorkoutGroup_User)
{
using (var context = new GasContext())
{
context.SetupServer();
var oldWorkoutGroupUser = FindWorkoutGroup_User(updatedWorkoutGroup_User.WorkoutGroupId,
updatedWorkoutGroup_User.GasUserId);
DeleteWorkoutGroup_User(oldWorkoutGroupUser);
await InsertWorkoutGroup_User(updatedWorkoutGroup_User);
context.SaveChanges();
}
}
public async Task CreateGasWorkoutGroup_User(WorkoutGroup_User wgu)
{
try
{
if (wgu == null)
{
throw new Exception("!!! Cannot add null workout group user !!!");
}
await InsertWorkoutGroup_User(wgu);
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
}
public void DeleteGasWorkoutGroup_User(WorkoutGroup_User wgu)
{
try
{
var wguExists = FindWorkoutGroup_User(wgu.WorkoutGroupId, wgu.GasUserId);
if (wguExists == null)
{
throw new Exception("!!! Cannot delete a workout group user that does not exist!!!");
}
DeleteWorkoutGroup_User(wguExists);
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
}
public void UpdateGasWorkoutGroup_User(WorkoutGroup_User wgu)
{
try
{
if (wgu == null)
{
throw new Exception("!!! Cannot update null workout group !!!");
}
var wguExists = FindWorkoutGroup_User(wgu.WorkoutGroupId, wgu.GasUserId);
if (wguExists == null)
{
throw new Exception("!!! A workout group user does not exist with that id !!!");
}
UpdateWorkoutGroup_User(wgu);
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
}
