public List<TrackCourse> GetByTrack(int id)
        {
            List<TrackCourse> list = null;

            DataProvider.ExecuteCmd(GetConnection, "dbo.TrackCourses_SelectByTrackID",
                inputParamMapper: delegate (SqlParameterCollection parameterCollection)
                {
                    parameterCollection.AddWithValue("@TracksId", id);

                },
                map: delegate (IDataReader reader, short set)
                {
                    TrackCourse s = new TrackCourse();
                    int startingIndex = 0;

                    s.CourseId = reader.GetSafeInt32(startingIndex++);
                    s.Order = reader.GetSafeInt32(startingIndex++);

                    if (list == null)
                    {
                        list = new List<TrackCourse>();
                    }
                    list.Add(s);
                }

                );
            return list;
        }
        public TrackCourse Get(int id)
        {
            TrackCourse s = null;

            DataProvider.ExecuteCmd(GetConnection, "dbo.TrackCourses_SelectById",
                inputParamMapper: delegate (SqlParameterCollection parameterCollection)
                {
                    parameterCollection.AddWithValue("@TracksId", id);
                },
                map: delegate (IDataReader reader, short set)
                {
                    s = new TrackCourse();
                    int startingIndex = 0;

                    s.CourseId = reader.GetSafeInt32(startingIndex++);
                    s.Order = reader.GetSafeInt32(startingIndex++);
                }

                );
            return s;
        }
Beispiel #3
0
        public Track Get(int id)
        {
            Track item = null;

            TrackCourse getTrackCourse = null;

            DataProvider.ExecuteCmd(GetConnection, "dbo.Tracks_SelectById"
               , inputParamMapper: delegate(SqlParameterCollection paramCollection)
               {
                   paramCollection.AddWithValue("@Id", id);
                   //model binding
               }, map: delegate(IDataReader reader, short set)
               {
                   if (set == 0)
                   {
                       item = new Track();
                       int startingIndex = 0; //startingOrdinal

                       item.Id = reader.GetSafeInt32(startingIndex++);
                       item.Name = reader.GetSafeString(startingIndex++);
                       item.Format = reader.GetSafeInt32(startingIndex++);
                       item.ExpectedOutcome = reader.GetSafeString(startingIndex++);
                       item.Cost = reader.GetSafeInt32(startingIndex++);
                       item.Description = reader.GetSafeString(startingIndex++);
                   }
                   else if (set == 1 && item != null)
                   {
                       getTrackCourse = new TrackCourse();
                       int startingIndex = 0;

                       getTrackCourse.CourseId = reader.GetSafeInt32(startingIndex++);
                       getTrackCourse.Order = reader.GetSafeInt32(startingIndex++);
                       getTrackCourse.CourseName = reader.GetSafeString(startingIndex);

                       if (item.TracksCourses == null)
                       {
                           item.TracksCourses = new List<TrackCourse>();
                       }

                       if( item.CourseIds == null)
                       {
                           item.CourseIds = new List<int>();
                       }

                       item.TracksCourses.Add(getTrackCourse);
                       item.CourseIds.Add(getTrackCourse.CourseId);

                   }

                   else if (set == 2 && item != null)
                   {
                       BaseCourse prereq = new BaseCourse();
                       int startingIndex = 0;

                       prereq.CourseName = reader.GetSafeString(startingIndex++);
                       prereq.Id = reader.GetSafeInt32(startingIndex);

                       if (item.Prerequisites == null)
                       {
                           item.Prerequisites = new List<BaseCourse>();
                       }

                       item.Prerequisites.Add(prereq);

                   }

               });

            return item;
        }
Beispiel #4
0
        public List<Track> GetTrackList()
        {
            List<Track> list = null;

            DataProvider.ExecuteCmd(GetConnection, "dbo.Tracks_SelectAll"
               , inputParamMapper: null
               , map: delegate(IDataReader reader, short set)
               {
                   if (set == 0)
                   {
                       Track ct = new Track();
                       int startingIndex = 0;

                       ct.Id = reader.GetSafeInt32(startingIndex++);
                       ct.Name = reader.GetSafeString(startingIndex++);
                       ct.Format = reader.GetSafeInt32(startingIndex++);
                       ct.ExpectedOutcome = reader.GetSafeString(startingIndex++);
                       ct.Cost = reader.GetSafeInt32(startingIndex++);
                       ct.Description = reader.GetSafeString(startingIndex++);

                       if (list == null)
                       {
                           list = new List<Track>();
                       }

                       list.Add(ct);
                   }
                   else if (set == 1 && list != null)
                   {
                       TrackCourse item = new TrackCourse();
                       int startingIndex = 0;

                       var TracksId = reader.GetSafeInt32(startingIndex++);
                       item.CourseId = reader.GetSafeInt32(startingIndex++);
                       item.Order = reader.GetSafeInt32(startingIndex++);
                       item.CourseName = reader.GetSafeString(startingIndex++);
                       foreach (var track in list)
                       {
                           if (track.Id == TracksId)
                           {
                               if (track.TracksCourses == null)
                               {
                                   track.TracksCourses = new List<TrackCourse>();
                               }

                               track.TracksCourses.Add(item);
                           }
                       }
                   }

                   else if (set == 2 && list != null)
                   {
                       BaseCourse prereq = new BaseCourse();
                       int startingIndex = 0;

                       prereq.TracksId = reader.GetSafeInt32(startingIndex++);
                       prereq.CourseName = reader.GetSafeString(startingIndex++);
                       prereq.Id = reader.GetSafeInt32(startingIndex);

                       foreach (var track in list)
                       {
                           if (track.Id == prereq.TracksId)
                           {
                               if (track.Prerequisites == null)
                               {
                                   track.Prerequisites = new List<BaseCourse>();
                               }
                               track.Prerequisites.Add(prereq);
                           }
                       }
                   }
               });

            return list;
        }