void createOnTrackSprintSession(int athleteSelected) { Lesson lesson = new Lesson(); string location = "On-Track Sesssion Summary"; lesson.LessonDate = System.DateTime.Now; Movie movie = new Movie(); movie.DateRecorded = System.DateTime.Now; MovieClip moviclip = new MovieClip(); bool customerprofileisexist = false; Customer custmer = DataRepository.CustomerProvider.GetByCustomerId(athleteSelected); try { customerprofile1 = DataRepository.CustomerProfileProvider.GetByCustomerId(custmer.CustomerId)[0]; customerprofileisexist = true; } catch { customerprofile1 = new CustomerProfile(); } DataSet dstecher = sae.GetPrimaryCoach(custmer.CustomerId); if (dstecher != null) { if (dstecher.Tables[0].Rows.Count > 0) { lesson.TeacherId = Convert.ToInt32(dstecher.Tables[0].Rows[0]["TeacherId"].ToString()); } else { lesson.TeacherId = 7; } } else { lesson.TeacherId = 7; } if (customerprofileisexist) { lesson.SiteId = customerprofile1.CustomerSite; } else { lesson.SiteId = 11; } lesson.CustomerId = custmer.CustomerId; lesson.LessonTypeId = 2; lesson.MachineNumber = 1; string sprint_InitialDataId = string.Empty; string sprint_FinalDataId = string.Empty; string sprint_modelSummary = string.Empty; if (_onTrackSessionlessonId == 0) { DataRepository.LessonProvider.Insert(lesson); sae.UpdateLessonLocation(location, lesson.LessonId); if (sprint_InitialDataId == string.Empty && _initialCount > 1) { int MovieIdInitialSide = sae.InsertMovieOnTrack(0, movie.DateRecorded, "Users/MovieFiles/ModelSprint-Initial-Side.mp4", lesson.LessonId); InsertMovieClip(MovieIdInitialSide); int MovieIdInitialBack = sae.InsertMovieOnTrack(1, movie.DateRecorded, "Users/MovieFiles/ModelSprint-Initial-Back.mp4", lesson.LessonId); InsertMovieClip(MovieIdInitialBack); } if (sprint_FinalDataId == string.Empty && _finalCount > 1) { int MovieIdCurrentSide = sae.InsertMovieOnTrack(2, movie.DateRecorded, "Users/MovieFiles/ModelSprint-Current-Side.mp4", lesson.LessonId); InsertMovieClip(MovieIdCurrentSide); int MovieIdCurrentBack = sae.InsertMovieOnTrack(3, movie.DateRecorded, "Users/MovieFiles/ModelSprint-Current-Back.mp4", lesson.LessonId); InsertMovieClip(MovieIdCurrentBack); } } else { sae.UpdateOntrackLessonLocation(location, _onTrackSessionlessonId, DateTime.Now); if (sprint_InitialDataId == string.Empty && _initialCount > 1) { int MovieIdInitialSide = sae.UpdateMovieOnTrack(0, DateTime.Now, "Users/MovieFiles/ModelSprint-Initial-Side.mp4", _onTrackSessionlessonId); int MovieIdInitialBack = sae.UpdateMovieOnTrack(1, DateTime.Now, "Users/MovieFiles/ModelSprint-Initial-Back.mp4", _onTrackSessionlessonId); } if (sprint_FinalDataId == string.Empty && _finalCount > 1) { int MovieIdCurrentSide = sae.UpdateMovieOnTrack(2, DateTime.Now, "Users/MovieFiles/ModelSprint-Current-Side.mp4", _onTrackSessionlessonId); int MovieIdCurrentBack = sae.UpdateMovieOnTrack(3, DateTime.Now, "Users/MovieFiles/ModelSprint-Current-Back.mp4", _onTrackSessionlessonId); } sprint_InitialDataId = sae.SelectSprintInitialDataid(_onTrackSessionlessonId.ToString()); sprint_FinalDataId = sae.SelectSprintCurrentDataid(_onTrackSessionlessonId.ToString()); sprint_modelSummary = sae.SelectSprintModelDataid(_onTrackSessionlessonId.ToString()); } if (sprint_InitialDataId == string.Empty && _initialCount > 1) { _initialSummary.LessonId = lesson.LessonId; _initialSummary.InsertIntoSprintInitialData(); } else { _initialSummary.LessonId = _onTrackSessionlessonId; _initialSummary.UpdateSprinttInitialData(); } if (sprint_FinalDataId == string.Empty && _finalCount > 1) { _finalSummary.LessonId = lesson.LessonId; _finalSummary.InsertIntoSprintCurrentData(); } else { _finalSummary.LessonId = _onTrackSessionlessonId; _finalSummary.UpdateSprintCurrentData(); } if (sprint_modelSummary == string.Empty && _modelCount > 1) { _modelSummary.LessonId = lesson.LessonId; _modelSummary.InsertIntoSprintModelData(); // _modelSummary.InsertIntoSprintOntrackModelData(); } else { _modelSummary.LessonId = _onTrackSessionlessonId; _modelSummary.UpdateSprintModelData(); // _modelSummary.UpadteIntoSprintOntrackModelData(); } }