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);
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
AppRole.OnModelCreating(modelBuilder);
AppUser.OnModelCreating(modelBuilder);
Course.OnModelCreating(modelBuilder);
Scenario.OnModelCreating(modelBuilder);
Track.OnModelCreating(modelBuilder);
TrackCourse.OnModelCreating(modelBuilder);
TrainingCode.OnModelCreating(modelBuilder);
TrainingCodeAppUser.OnModelCreating(modelBuilder);
TrainingCodeTrack.OnModelCreating(modelBuilder);
}
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)
{
CourseTrack prereq = new CourseTrack();
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 <CourseTrack>();
}
track.Prerequisites.Add(prereq);
}
}
}
});
return(list);
}
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)
{
CourseTrack prereq = new CourseTrack();
int startingIndex = 0;
prereq.CourseName = reader.GetSafeString(startingIndex++);
prereq.Id = reader.GetSafeInt32(startingIndex);
if (item.Prerequisites == null)
{
item.Prerequisites = new List <CourseTrack>();
}
item.Prerequisites.Add(prereq);
}
});
return(item);
}
