public static IEnumerable <Training> GetTrainingsByUserId(decimal?Id) { var result = Enumerable.Empty <Training>(); if (Id != null && Id != 0) { using (var db = new GymTrainingContext()) { result = db.Trainings .Include(x => x.User) .Include(x => x.Excersises) .Where(x => x.User.Id == Id).ToList(); } } else { using (var db = new GymTrainingContext()) { result = db.Trainings .Include(x => x.User) .Include(x => x.Excersises).ToList(); } } return(result); }
public static void SaveOrUpdateTraining(Training val) { var context = new GymTrainingContext(); context.Entry(val).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); }
public static void DeleteTraining(decimal id) { var context = new GymTrainingContext(); var remove = context.Trainings.Single(x => x.Id == id); context.Trainings.Remove(remove); context.SaveChanges(); }
public static IEnumerable <Training> GetTrainings() { using (var db = new GymTrainingContext()) { return(db.Trainings .Include(x => x.User) .ToList()); } }
public static Training GetTrainingById(decimal Id) { using (var db = new GymTrainingContext()) { return(db.Trainings .Include(x => x.User) .Include(x => x.Excersises) .FirstOrDefault(x => x.Id == Id)); } }
public static IEnumerable <Excersise> GetExcersises() { using (var db = new GymTrainingContext()) { return(db.Excersises .Include(x => x.ExcersiseType) .Include(x => x.RepeatSets.Select(y => y.WeightUnit)) .ToList()); } }
public static IEnumerable <User> GetUsers() { using (var db = new GymTrainingContext()) { var t = db.Users .Where(x => x.IsActive) .ToList(); return(t); } }
public static User GetUserWithTrainingsByUserId(decimal?Id) { User result = null; if (Id != null && Id != 0) { using (var db = new GymTrainingContext()) { result = db.Users .Include(x => x.Trainings) .FirstOrDefault(x => x.Id == Id); } } return(result); }