internal static List <ExerciseViewModel> GetExercises(int exerciseTypeId) { List <ExerciseViewModel> exerciseViewModelList = new List <ExerciseViewModel>(); List <Exercise> list; try { using (dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes()) { list = dbContext.Exercises.Where(e => e.ExerciseTypeId.Equals(exerciseTypeId)).ToList(); } foreach (Exercise exercise in list) { exerciseViewModelList.Add(new ExerciseViewModel { Id = exercise.Id, Name = exercise.Name }); } return(exerciseViewModelList); } catch (Exception ex) { if (null != dbContext) { dbContext.Dispose(); } GetExercises(exerciseTypeId); } return(exerciseViewModelList); }
internal static void InsertUserExerciseTypeSelections(List <UserExerciseTypeSelection> userExerciseTypeSelectionList) { try { foreach (UserExerciseTypeSelection entity in userExerciseTypeSelectionList) { entity.ExerciseTypeName = GetExerciseTypeName(entity.ExerciseTypeId); entity.ExerciseName = GetExerciseName(entity.ExerciseId); } } catch (Exception ex1) { throw ex1; } try { using (dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes()) { dbContext.UserExerciseTypeSelections.AddRange(userExerciseTypeSelectionList); dbContext.SaveChanges(); } } catch (Exception ex) { throw ex; } }
internal static List <ExerciseType> GetExerciseTypesForCurrentPlan(int exercisePlanId) { dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes(); var result = dbContext.ExerciseTypes.Where(e => e.ExercisePlanId.Equals(exercisePlanId)).ToList(); return(result); }
internal static void InsertPurchases(Purchase purchase) { using (dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes()) { dbContext.Purchases.Add(purchase); dbContext.SaveChanges(); } }
internal static List <UserExerciseWeightSelection> GetUserExerciseWeightSelectionsWeekly(string userExerciseTypeSelectionIds, string weekNumber) { using (dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes()) { var param = new SqlParameter[] { new SqlParameter("@UserExerciseTypeSelectionId", userExerciseTypeSelectionIds), new SqlParameter("@WeekNumber", weekNumber) }; var lst = dbContext.UserExerciseWeightSelections.SqlQuery("GetUserExerciseWeightSelectionsWeekly @UserExerciseTypeSelectionId,@WeekNumber", param).ToList(); return(lst); } }
internal static List <ExercisePlan> GetExercisePlans() { List <ExercisePlan> listExercisePlan; try { dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes(); listExercisePlan = dbContext.ExercisePlans.Include(p => p.ExerciseTypes).ToList(); return(listExercisePlan); } catch (Exception ex) { throw ex; } }
internal static ExercisePlan GetExercisePlan(int exercisePlanId) { ExercisePlan exercisePlan; try { dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes(); exercisePlan = dbContext.ExercisePlans.Find(exercisePlanId); return(exercisePlan); } catch (Exception ex) { throw ex; } }
internal static string GetExerciseName(int exerciseId) { try { using (dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes()) { Exercise exercise = dbContext.Exercises.SingleOrDefault(e => e.Id.Equals(exerciseId)); return(exercise.Name); } } catch (Exception ex) { throw ex; } }
internal static UserExerciseTypeSelection GetUserExerciseTypeSelectionById(int userExerciseTypeSelectionId) { try { using (dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes()) { UserExerciseTypeSelection userExerciseTypeSelection = dbContext.UserExerciseTypeSelections.SingleOrDefault(e => e.Id.Equals(userExerciseTypeSelectionId)); return(userExerciseTypeSelection); } } catch (Exception ex) { throw ex; } }
internal static List <ExercisePlan> GetActiveExercisePlans() { List <ExercisePlan> listExercisePlan; try { dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes(); dbContext.Configuration.LazyLoadingEnabled = true; listExercisePlan = dbContext.ExercisePlans.Where(e => e.IsActive).ToList(); return(listExercisePlan); } catch (Exception ex) { throw ex; } }
internal static int InsertUserExercisePlanSelection(UserExercisePlanSelection userExercisePlanSelection) { try { using (dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes()) { dbContext.UserExercisePlanSelections.Add(userExercisePlanSelection); dbContext.SaveChanges(); return(userExercisePlanSelection.Id); } } catch (Exception ex) { throw ex; } }
internal static SelectViewModel GetSelectView(int id) { try { List <ExerciseType> list; dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes(); list = dbContext.ExerciseTypes.Where(e => e.ExercisePlanId.Equals(id)).ToList(); return(new SelectViewModel() { ExercisePlanId = id, ExerciseTypeList = list, ExerciseTypeCount = list.Count, }); } catch (Exception ex) { throw ex; } }
internal static void UpdatePlanStatus(int id, bool isActive) { try { using (dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes()) { var result = dbContext.ExercisePlans.SingleOrDefault(p => p.Id == id); if (result != null) { result.IsActive = isActive; dbContext.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
internal static UserExercisePlanSelection GetUserExercisePlanSelection(int userExercisePlanSelectionId, string userId) { try { using (dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes()) { UserExercisePlanSelection userExercisePlanSelection = dbContext.UserExercisePlanSelections.Include(e => e.UserExerciseTypeSelections).SingleOrDefault(u => u.Id.Equals(userExercisePlanSelectionId) && u.UserId.Equals(userId)); //List<UserExerciseTypeSelection> lst = new List<UserExerciseTypeSelection>(); //lst.AddRange(userExercisePlanSelection.UserExerciseTypeSelections.Where(u => u.WeightRequired == true)); //userExercisePlanSelection.UserExerciseTypeSelections = lst; return(userExercisePlanSelection); } } catch (Exception ex) { throw ex; } }
public static bool Import(ExercisePlan exercisePlan) { try { exercisePlan.EntryDate = DateTime.Now; exercisePlan.IsActive = true; using (dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes()) { dbContext.ExercisePlans.Add(exercisePlan); dbContext.SaveChanges(); exercisePlan.ExerciseTypes = ImportExcerciseTypesFromExcel(exercisePlan); return(true); } } catch (Exception ex) { throw ex; } }
private static ICollection <ExerciseType> ImportExcerciseTypesFromExcel(ExercisePlan exercisePlan) { List <ExerciseType> listExerciseType = new List <ExerciseType>(); using (ExcelPackage xlPackage = new ExcelPackage(new System.IO.FileInfo(exercisePlan.ExcelFilePath))) { // get the first worksheet in the workbook ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets[1]; var rowCnt = worksheet.Dimension.End.Row; var colCnt = worksheet.Dimension.End.Column; //1. Loop each column & get Exercise Type with its excercises for (int i = 1; i <= colCnt; i++)//starting from two since 1 will have WeightRequired. { if (!string.IsNullOrEmpty(Convert.ToString(worksheet.Cells[2, i].Value))) { listExerciseType.Add(new ExerciseType { ExercisePlanId = exercisePlan.Id, Name = (string)worksheet.Cells[2, i].Value,//starting from two since 1 will have WeightRequired. WeightRequired = GetWeightRequired(Convert.ToString(worksheet.Cells[1, i].Value)), EntryDate = DateTime.Now, }); } } using (dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes()) { dbContext.ExerciseTypes.AddRange(listExerciseType); dbContext.SaveChanges(); } //2. Add Exercises to ExerciseType for (int c = 1; c <= colCnt; c++) { List <Exercise> list = new List <Exercise>(); for (int r = 3; r <= rowCnt; r++) { string cellVal = (string)worksheet.Cells[r, c].Value; if (!string.IsNullOrEmpty(cellVal)) { list.Add(new Exercise { Name = cellVal, ExerciseTypeId = listExerciseType[c - 1].Id, EntryDate = DateTime.Now, IsActive = true }); } } using (dbContext = new ClinicalAthletes.Core.Data.ClinicalAthletes()) { dbContext.Exercises.AddRange(list); dbContext.SaveChanges(); } } } return(listExerciseType); }