private void UpdateTreeView() { PlanTreeView.Nodes.Clear(); DataTable ids = workoutByDayAdapter.GetData(dayId); DayCommentRichTextBox.Text = daysAdapter.GetDataById(dayId).Rows[0]["Comment"].ToString(); //List<string> exerciseNames = new List<string>(table.Rows.Count); foreach (DataRow idRow in ids.Rows) { TreeNode exerciseNode = PlanTreeView.Nodes.Add(idRow["Name_Exercise"].ToString()); exerciseNode.Tag = (idRow["ID_Workout"]); DataTable sets = setsAdapter.GetDataByWorkoutId((int)idRow["ID_Workout"]); foreach (DataRow setRow in sets.Rows) { exerciseNode.Nodes.Add(setRow["Num_Reps"].ToString() + " раз(и) по " + setRow["Weight"].ToString() + " кг"); } } PlanTreeView.ExpandAll(); }
private void UpdateTreeView() { ctx.Dispose(); ctx = new NewGymPlannerEntities(); PlanTreeView.Nodes.Clear(); var workouts = (from d in ctx.Days.Where(d => d.ID_Day == dayId) select d).SingleOrDefault().Workouts; DayCommentRichTextBox.Text = (from d in ctx.Days.Where(d => d.ID_Day == dayId) select d).SingleOrDefault().Comment.ToString(); foreach (Workouts workout in workouts) { TreeNode exerciseNode = PlanTreeView.Nodes.Add(workout.Exercises.SingleOrDefault().Name); exerciseNode.Tag = (workout.ID_Workout); var sets = (from w in ctx.Workouts.Where(w => w.ID_Workout == workout.ID_Workout) select w).SingleOrDefault().Sets; foreach (Sets set in sets) { exerciseNode.Nodes.Add(set.Num_Reps + " раз(и) по " + set.Weight + " кг"); } } PlanTreeView.ExpandAll(); }