public IEnumerable <IGrouping <string, TutorailChapter> > GetTutorailMenuAndContent(out TutorailChapter chapter)
{
TutorailChapter tcChapter = null;
chapter = tcChapter;
if (Request.QueryString["item"] == "" ||
Request.QueryString["chapter"] == "")
{
return(null);
}
int intItemId;
int intChapterId;
if (!int.TryParse(Request.QueryString["item"], out intItemId))
{
return(null);
}
if (!int.TryParse(Request.QueryString["chapter"], out intChapterId))
{
return(null);
}
List <TutorailChapter> chapters;
Stopwatch sw = new Stopwatch();
using (var db = new TutorailsDBContext())
{
sw.Start();
chapters = (from c in db.Chapters
where c.tutorialitem == intItemId
select c
).OrderBy(c => c.chapter_seq).ToList <TutorailChapter>();
sw.Stop();
long t1 = sw.ElapsedMilliseconds;
//var sqlParameter = new MySqlParameter("@tutorialitem", Request.QueryString["item"]);
//sw.Start();
//chapters = db.Chapters.SqlQuery("select * from dt_tutorial_chapter where tutorialitem = @tutorialitem", sqlParameter).ToList();
//sw.Stop();
//long t2 = sw.ElapsedMilliseconds;
if (chapters == null || chapters.Count == 0)
{
return(null);
}
chapter = (from c in db.Chapters
where c.id == intChapterId
select c).Single();
var listChapterGroups = chapters.GroupBy(p => p.chapter_group);
foreach (var group in listChapterGroups)
{
group.OrderBy(c => c.chapter_seq);
}
return(listChapterGroups);
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.drpCategory.SelectedIndexChanged += drpCategory_SelectedIndexChanged;
this.drpTutorail.SelectedIndexChanged += drpTutorail_SelectedIndexChanged;
this.btnGoto.Click += btnGoto_Click;
if (!IsPostBack)
{
using (var tutoraildb = new TutorailsDBContext())
{
List <TutorailCategory> categorys = tutoraildb.Categorys.ToList <TutorailCategory>();
this.drpCategory.DataSource = categorys;
this.drpCategory.DataValueField = "id";
this.drpCategory.DataTextField = "module_name";
this.drpCategory.DataBind();
this.drpCategory.SelectedIndex = 0;
}
}
}
void drpCategory_SelectedIndexChanged(object sender, EventArgs e)
{
List <TutorailItem> tutorails;
int selectValue = int.Parse(drpCategory.SelectedValue);
using (var tutoraildb = new TutorailsDBContext())
{
tutorails = (from i in tutoraildb.Items
where i.category == selectValue
select i).ToList <TutorailItem>();
if (tutorails != null)
{
this.drpTutorail.DataSource = tutorails;
this.drpTutorail.DataTextField = "item_name";
this.drpTutorail.DataValueField = "id";
this.drpTutorail.DataBind();
}
}
}
void drpTutorail_SelectedIndexChanged(object sender, EventArgs e)
{
List <TutorailChapter> chapters;
int selectValue = int.Parse(drpTutorail.SelectedValue);
using (var tutoraildb = new TutorailsDBContext())
{
chapters = (from i in tutoraildb.Chapters
where i.tutorialitem == selectValue
select i).ToList <TutorailChapter>();
if (chapters != null)
{
this.drpChapter.DataSource = chapters;
this.drpChapter.DataTextField = "chapter_name";
this.drpChapter.DataValueField = "id";
this.drpChapter.DataBind();
}
}
}
