public bool updateRate(int userid, string questionid, int rate)
{
LessonBL lessonbl = new LessonBL();
ctx = new ST_LMSEntities();
Result getRate = ctx.Results.Where(x => x.user_id == userid && x.question_id == questionid).FirstOrDefault();
if (getRate.pre == null)
{
getRate.pre = rate;
ctx.SaveChanges();
return(true);
}
else
if (getRate.post == null)
{
getRate.post = rate;
getRate.complete = true;
ctx.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public Result getUserLesson(int userid, string lessonid)
{
ctx = new ST_LMSEntities();
Result getResult = ctx.Results.Where(x => x.user_id == userid && x.lesson_id == lessonid).FirstOrDefault();
return(getResult);
}
protected void btnStart_Click(object sender, EventArgs e)
{
ctx = new ST_LMSEntities();
Cours SelectedCourses = (Cours)Session["SelectedCourses"];
string CourseID = SelectedCourses.course_id.ToString();
Session["SelectedCourseID"] = CourseID;
Response.Redirect("LessonForm.aspx");
}
public User getLoginUser(string userName, string password)
{
ctx = new ST_LMSEntities();
User getUser = ctx.Users.Where(x => x.user_name == userName && x.password == password).FirstOrDefault();
if (getUser != null)
{
return(getUser);
}
else
{
return(null);
}
}
public bool checkLoginUser(string userName, string password)
{
ctx = new ST_LMSEntities();
User login = ctx.Users.Where(x => x.user_name == userName && x.password == password).FirstOrDefault();
if (login == null)
{
return(false);
}
else
{
return(true);
}
}
public bool updateincrease(int userid, string questionid)
{
LessonBL lessonbl = new LessonBL();
ctx = new ST_LMSEntities();
Result getRate = ctx.Results.Where(x => x.user_id == userid && x.question_id == questionid).FirstOrDefault();
if (getRate.complete == true)
{
int increase = Convert.ToInt32(getRate.post) - Convert.ToInt32(getRate.pre);
getRate.increase = increase;
ctx.SaveChanges();
return(true);
}
else
{
return(true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
ctx = new ST_LMSEntities();
Cours SelectedCourses = (Cours)Session["SelectedCourses"];
int userid = Convert.ToInt32(SelectedCourses.user_id);
lblCourseName.Text = SelectedCourses.course_name.ToString();
lblDescription.Text = SelectedCourses.description.ToString();
lblUpdateDate.Text = SelectedCourses.update_date.ToString();
lblDuration.Text = SelectedCourses.duration.ToString();
User author = CourseBl.getUser(userid);
lblContactNo.Text = author.contact_no.ToString();
lblEmail.Text = author.email.ToString();
lblUserName.Text = author.user_name.ToString();
}
public List <Lesson> getLessonList(string course_id)
{
ctx = new ST_LMSEntities();
return(ctx.Lessons.Where(x => x.course_id == course_id).ToList());
}
public Lesson getLesson(string lesson_id)
{
ctx = new ST_LMSEntities();
return(ctx.Lessons.Where(x => x.lesson_id == lesson_id).FirstOrDefault());
}
public List <Cours> getCourseList(string role)
{
ctx = new ST_LMSEntities();
return(ctx.Courses.Where(x => x.role == role).ToList());
}
public User getUser(int userID)
{
ctx = new ST_LMSEntities();
return((User)ctx.Users.Where(x => x.user_id == userID).FirstOrDefault());
}
public Cours courseList(string courseID)
{
ctx = new ST_LMSEntities();
return((Cours)ctx.Courses.Where(x => x.course_id == courseID));
}
