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); }