public void Execute(object parameter)
{
ToDoList.Clear();
List <PostIt> toDoPostits = PersistenceHandler.LoadTodoList();
foreach (var postIt in toDoPostits)
{
ToDoList.Add(postIt);
}
DoingList.Clear();
List <PostIt> doingPostits = PersistenceHandler.LoadDoingList();
foreach (var postIt in doingPostits)
{
DoingList.Add(postIt);
}
DoneList.Clear();
List <PostIt> donePostits = PersistenceHandler.loadDoneList();
foreach (var postIt in donePostits)
{
DoneList.Add(postIt);
}
}
protected void Practice_Done()
{
string userId = Session["userId"].ToString();
string sql = "select * from PracticeInfo inner join SCInfo on PracticeInfo.courseId = SCInfo.CourseId inner join CourseInfo on CourseInfo.courseId = SCInfo.CourseId inner join VideoInfo on VideoInfo.VideoId = PracticeInfo.videoId inner join AnswerResult on PracticeInfo.practiceId = AnswerResult.practiceId where PracticeInfo.practiceId in (select practiceId from AnswerResult where stuId = '" + userId + "') and SCInfo.StuId = '" + userId + "'";
DoneList.DataSource = DataOperate.GetDataset(sql, "PracticeInfo");
DoneList.DataKeyNames = new string[] { "practiceId" };
DoneList.DataBind();
}
public void Done_List()
{
using (moyEntities db = new moyEntities())
{
int userid = Convert.ToInt32(Session["Id"]);
List <Done> done = db.Dones.Where(a => a.UserId == userid).OrderBy(a => a.DONE1).ToList();
DoneList.DataSource = done;
DoneList.DataTextField = "Done1";
DoneList.DataValueField = "Id";
DoneList.DataBind();
}
}