public Chapter GetChapterDetailByChapterId(int chapterId)
{
var chapterFromSql = _sqlHelper.GetDataRow("select * from ChapterCaterogyContent where ChapterId=" + chapterId);
var chapter=new Chapter
{
ChapterName = chapterFromSql["Title"].ToString(),
Content = chapterFromSql["Description"].ToString(),
ImageUrl = chapterFromSql["ImageUrl"].ToString()
};
return chapter;
}
public ChapterCollection GetAllChapter()
{
var dataTable = _sqlHelper.GetDataTable("select * from Chapter");
var chapterCollection = new ChapterCollection();
for (var i = 0; i < dataTable.Rows.Count; i++)
{
var chapter = new Chapter()
{
Id = Convert.ToInt32(dataTable.Rows[i]["Id"].ToString()),
ChapterName = dataTable.Rows[i]["ChapterName"].ToString()
};
chapterCollection.Add(chapter);
}
return chapterCollection;
}