/// <summary> /// single object add /// </summary> /// <param name="session">the session to be added</param> public void AddSession(Session session) { using (WorkoutPlannerContext context = new WorkoutPlannerContext()) { context.Sessions.Add(session); context.SaveChanges(); } }
/// <summary> /// single object add /// </summary> /// <param name="comment">comment to be added</param> public void AddComment(Comment comment) { using (WorkoutPlannerContext context = new WorkoutPlannerContext()) { context.Comments.Add(comment); context.SaveChanges(); } }
/// <summary> /// single object add /// </summary> /// <param name="achievement">the Achievement to be added</param> public void AddAchievement(Achievement achievement) { using (WorkoutPlannerContext context = new WorkoutPlannerContext()) { context.Achievements.Add(achievement); context.SaveChanges(); } }
/// <summary> /// single object add /// </summary> /// <param name="userAchievement">UserAchievement to be added</param> public void AddUserAchievement(UserAchievement userAchievement) { using (WorkoutPlannerContext context = new WorkoutPlannerContext()) { context.UserAchievements.Add(userAchievement); context.SaveChanges(); } }
/// <summary> /// multiple object add /// </summary> /// <param name="tracks">the track collection to be added to the databse</param> public void AddTracks(ICollection <Track> tracks) { using (WorkoutPlannerContext context = new WorkoutPlannerContext()) { context.Tracks.AddRange(tracks); context.SaveChanges(); } }
/// <summary> /// single object add /// </summary> /// <param name="workout">Workout to be added</param> public void AddWorkout(Workout workout) { using (WorkoutPlannerContext context = new WorkoutPlannerContext()) { context.Workouts.Add(workout); context.SaveChanges(); } }
/// <summary> /// Single object add /// </summary> /// <param name="track"> The track object to be added to database</param> public void AddTrack(Track track) { using (WorkoutPlannerContext context = new WorkoutPlannerContext()) { context.Tracks.Add(track); context.SaveChanges(); } }
/// <summary> /// single object add /// </summary> /// <param name="user">User to be added</param> public void AddUser(User user) { using (WorkoutPlannerContext context = new WorkoutPlannerContext()) { context.Users.Add(user); context.SaveChanges(); } }
/// <summary> /// single object delete /// </summary> /// <param name="sessionId">id of session to be deleted</param> public void RemoveSessionById(int sessionId) { using (WorkoutPlannerContext context = new WorkoutPlannerContext()) { Session session = context.Sessions.Find(sessionId); context.Sessions.Remove(session); context.SaveChanges(); } }
/// <summary> /// single object update /// </summary> /// <param name="workout"></param> public void UpdateWorkoutTime(Workout workout) { using (WorkoutPlannerContext context = new WorkoutPlannerContext()) { var targetWorkout = context.Workouts.Find(workout.Id); targetWorkout.Minutes = workout.Minutes; context.Workouts.Update(targetWorkout); context.SaveChanges(); } }
/// <summary> /// multiple object delete, /// deletes all sessions from a user /// </summary> /// <param name="userId">user id to be matched</param> public void RemoveSessionsByUserId(int userId) { using (WorkoutPlannerContext context = new WorkoutPlannerContext()) { var sessions = context.Sessions .Where(s => s.UserId == userId) .ToList(); context.Sessions.RemoveRange(sessions); context.SaveChanges(); } }