public void Deserialize_seed_data() { //var file = File.Open("seedData.json", FileMode.Open); using (var db = new LiftBroContext()) { SeedData data = JsonConvert.DeserializeObject<SeedData>(File.ReadAllText("seedData.json")); db.UserPrograms.AddOrUpdate(data.UserPrograms.First()); db.SaveChanges(); var exercise = new UserExercise() { Exercise = db.Exercises.First(), Id = new Guid(), OneRepetitionMax = 44, User = db.Users.First() }; db.UserExercises.AddOrUpdate(exercise); db.SaveChanges(); } }
public void UpdateUserExercise(UserExercise userExercise) { if (userExercise.User == null) userExercise.User = User.GetApplicationUser(); if (userExercise.Exercise == null) throw new Exception("Exercise but be set"); using (var db = new LiftBroContext()) { db.Exercises.Attach(userExercise.Exercise); var foundExercise = db.UserExercises //.Include(exc => exc.) .FirstOrDefault(exercise => exercise.User.Username == userExercise.User.Username && exercise.Exercise.Name == userExercise.Exercise.Name); if (foundExercise != null) { foundExercise.OneRepetitionMax = userExercise.OneRepetitionMax; } else { db.UserExercises.Add(new UserExercise() { User = db.Users.Find(userExercise.User.Username), Exercise = userExercise.Exercise, Id = Guid.NewGuid(), OneRepetitionMax = userExercise.OneRepetitionMax }); } db.SaveChanges(); } }