public static List <LearningEpisode> GetEpisodes()
{
List <LearningEpisode> episodes = new List <LearningEpisode>();
DataSet ds = db.GetDataSetByQuery("GetEpisodes", System.Data.CommandType.StoredProcedure);
foreach (DataRow dr in ds.Tables[0].Rows)
{
LearningEpisode episode = new LearningEpisode();
episode.Code = int.Parse(dr[0].ToString());
episode.Name = dr[1].ToString();
episode.Phases = LearningEpisodePhase.GetPhases(episode.Code);
episodes.Add(episode);
}
return(episodes);
}
public static List <LearningEpisodePhase> GetPhases(int episodeCode)
{
List <LearningEpisodePhase> phases = new List <LearningEpisodePhase>();
SqlParameter parameter = new SqlParameter("@epiCode", episodeCode);
DataSet ds = db.GetDataSetByQuery("GetPhases", System.Data.CommandType.StoredProcedure, parameter);
foreach (DataRow dr in ds.Tables[0].Rows)
{
LearningEpisodePhase phase = new LearningEpisodePhase();
phase.Code = int.Parse(dr[0].ToString());
phase.EpisodeCode = int.Parse(dr[1].ToString());
phase.Name = dr[2].ToString();
phases.Add(phase);
}
return(phases);
}
