private void ApplyProfilePoints(int ProfileID, int QuizStatus, int ModuleID, int UserID)
{
BusinessServices.Profile objProfile = new BusinessServices.Profile();
bool ApplyToQuiz = objProfile.QuizRequiredForPoints(ProfileID);
bool ApplyToLesson = objProfile.LessonRequiredForPoints(ProfileID);
// If both Quiz and Lesson need to be completed to gain points
if (ApplyToQuiz && ApplyToLesson)
{
//Check if Lesson has been completed
if ((objProfile.CheckQuizComplete(UserID, ProfileID, ModuleID)) && (objProfile.CheckLessonComplete(UserID, ProfileID, ModuleID)))
{
if (!(objProfile.CheckLessonPointsAlreadyGivenForPeriod(ProfileID, UserID, ModuleID, 2)) || !(objProfile.CheckQuizPointsAlreadyGivenForPeriod(ProfileID, UserID, ModuleID, 2)))
{
objProfile.ApplyCPDPoints(ProfileID, UserID, ModuleID, 2);
}
}
}
else // then either quiz only or lesson only
{
if (ApplyToQuiz) // quiz only
{
// if quiz passed then apply points to user
// if(QuizStatus == 2)
// {
if (!(objProfile.CheckQuizPointsAlreadyGivenForPeriod(ProfileID, UserID, ModuleID, 1)))
{
objProfile.ApplyCPDPoints(ProfileID, UserID, ModuleID, 1);
}
// }
}
// not worried about lesson in this scenario as have just completed quiz
}
}
public string writeDMEs(int StudentID, int ModuleID, string strSessID1, DataSet xmlDS, string sessiondata, int ProfileId)
{
try
{
Boolean isLesson = false;
Boolean completed = false;
int score = 0;
int interactions = 0;
string strResult = "";
int currentpage = 0;
int Totalpage = 0;
Hashtable ht = new Hashtable();
foreach (DataRow r in xmlDS.Tables["dme"].Rows)
{
// get the salt variables here...
if (r["name"].ToString().ToLower().Contains("salt.variables.var"))
{
ht.Add(r["name"].ToString().ToLower(), r["value"].ToString());
}
if (r["name"].ToString().ToLower().Equals("salt.lessonorquiz"))
{
try
{
isLesson = (r["value"].ToString().ToLower() == "lesson");
}
catch
{
isLesson = true;
}
}
if (r["name"].ToString().Equals("cmi.core.lesson_status"))
{
if (r["value"].ToString().Equals("completed") || r["value"].ToString().Equals("passed"))
{
completed = true;
if (completed)
{
//break;
}
}
}
////if (r["name"].ToString().Equals("cmi.core.lesson_status"))
////{
//// completed = r["value"].ToString().Equals("passed");
//// if (completed)
//// {
//// //break;
//// }
////}Adaptive
//if (r["name"].ToString().Equals("salt.variables.VarPageInChapter"))
//{
// currentpage = int.Parse(r["value"].ToString());
//}
//if (r["name"].ToString().Equals("cmi.suspend_data"))
//{
// string phrase = r["value"].ToString();
// string[] strTallyVisited = phrase.Split(';');
// currentpage = Convert.ToInt32(strTallyVisited[0].Split('=')[1].ToString().Trim());
//}
//if (r["name"].ToString().Equals("salt.variables.VarPagesInChapter"))
//{
// Totalpage = int.Parse(r["value"].ToString());
// //if (Totalpage - 1 == currentpage && Totalpage != 0)
// //{
// // completed = true;
// // if (completed)
// // {
// // //break;
// // }
// //}
//}
//if (r["name"].ToString().Equals("salt.variables.VarRunningPageCount"))
//{
// string phrase = r["value"].ToString();
// string[] strTallyVisited = phrase.Split(' ');
// currentpage = Convert.ToInt32(strTallyVisited[1].ToString().Trim());
// Totalpage = Convert.ToInt32(strTallyVisited[3].ToString().Trim());
// if (Totalpage - 1 == currentpage && Totalpage != 0)
// {
// completed = true;
// if (completed)
// {
// //break;
// }
// }
//}
//if (Totalpage != 0 || currentpage != 0)
//{
// if (Totalpage == currentpage)
// {
// completed = true;
// if (completed)
// {
// //break;
// }
// }
//}
if (r["name"].ToString().Equals("cmi.core.score.raw"))
{
try
{
score = int.Parse(r["value"].ToString());
}
catch
{
score = 0;
}
}
if (r["name"].ToString().Equals("cmi.core.lesson_score"))
{
try
{
score = int.Parse(r["value"].ToString());
}
catch
{
score = 0;
}
}
if (r["name"].ToString().Equals("cmi.interactions._count"))
{
try
{
interactions = int.Parse(r["value"].ToString());
r["value"] = "0";
}
catch
{
// do nothing
}
}
if (r["value"].ToString() != "")
{
strResult = WriteDMEvalue(StudentID, ModuleID, r["name"].ToString(), r["value"].ToString());
}
}
if (!isLesson) // train tblQuizQuestion and tblQuizAnswer
{
int intAskedQuestion = 1;
int intWeighting = 1;
String strLatency = "";
String strTime = "";
String strText = "";
String strType = "";
String strID = "";
Boolean isCorrect = false;
String strCorrectResponse = "";
String strStudentResponse = "";
int intNextAskedQuestion = 0;
String[] strPosAskedQuestion;
BusinessServices.Toolbook objToolbook = new Toolbook();
DataTable endQuizInfo = objToolbook.BeforeQuizEnd2(StudentID, ModuleID, 46664, score);
DataRow tmpRow = endQuizInfo.Rows[0];
String SessionID = tmpRow["SessionID"].ToString();
foreach (DataRow r in xmlDS.Tables["dme"].Rows)
{
if (r["name"].ToString().Length > 16)
{
if (r["name"].ToString().Substring(0, 16).Equals("cmi.interactions"))
{
strPosAskedQuestion = r["name"].ToString().Split('.');
try
{
intNextAskedQuestion = int.Parse(strPosAskedQuestion[2]);
}
catch
{
}
if (intNextAskedQuestion != intAskedQuestion && strText != "")
{
saveQuestion(StudentID, intAskedQuestion, intWeighting, strLatency, strTime, strText, strID, isCorrect, strCorrectResponse, strStudentResponse, strType, ModuleID, SessionID);
intAskedQuestion = intNextAskedQuestion;
intWeighting = 1;
strLatency = "";
strTime = "";
strText = "";
strID = "";
isCorrect = false;
strCorrectResponse = "";
strStudentResponse = "";
strType = "";
}
try
{
if (strPosAskedQuestion[3].Equals("id"))
{
try { strID = r["value"].ToString(); }
catch { }
}
;
if (strPosAskedQuestion[3].Equals("latency"))
{
strLatency = r["value"].ToString();
}
if (strPosAskedQuestion[3].Equals("question"))
{
strText = r["value"].ToString().Replace("\\r", "");
foreach (DictionaryEntry entry in ht)
{
if (entry.Value.ToString().Equals(strText))
{
String[] arr = entry.Key.ToString().Split('_');
strStudentResponse = ht["salt.variables.varquestion_" + arr[1]].ToString();
strCorrectResponse = ht["salt.variables.varvarcorrectanswertext_" + arr[1]].ToString();
break;
}
}
}
if (strPosAskedQuestion[3].Equals("result"))
{
try { isCorrect = r["value"].ToString().ToLower().Equals("correct"); }
catch { }
}
;
if (strPosAskedQuestion[3].Equals("time"))
{
strTime = r["value"].ToString();
}
if (strPosAskedQuestion[3].Equals("type"))
{
strType = r["value"].ToString();
}
if (strPosAskedQuestion[3].Equals("weighting"))
{
try { intWeighting = int.Parse(r["value"].ToString()); }
catch { }
}
;
}
catch { };
}
}
}
if (!intAskedQuestion.Equals(1))
{
saveQuestion(StudentID, intAskedQuestion, intWeighting, strLatency, strTime, strText, strID, isCorrect, strCorrectResponse, strStudentResponse, strType, ModuleID, SessionID);
intAskedQuestion = 1;
}
if (!isLesson && interactions > 0)
{
int intUserID;
int intQuizID;
int intPassMark;
int intUnitID;
int intModuleID;
int intQuizFrequency;
int intOldCourseStatus;
int intNewCourseStatus;
int intNewQuizStatus;
int intCourseID;
DateTime dtmQuizCompletionDate;
intUserID = Int32.Parse(tmpRow["UserID"].ToString());
try
{
intQuizID = Int32.Parse(tmpRow["QuizID"].ToString());
}
catch { intQuizID = 0; }
intPassMark = Int32.Parse(tmpRow["PassMark"].ToString());
intUnitID = Int32.Parse(tmpRow["UnitID"].ToString());
intModuleID = Int32.Parse(tmpRow["ModuleID"].ToString());
intQuizFrequency = tmpRow["QuizFrequency"] == null?Int32.Parse(tmpRow["QuizFrequency"].ToString()) : 0;
intOldCourseStatus = Int32.Parse(tmpRow["OldCourseStatus"].ToString());
intNewCourseStatus = Int32.Parse(tmpRow["NewCourseStatus"].ToString());
intNewQuizStatus = Int32.Parse(tmpRow["NewQuizStatus"].ToString());
intCourseID = Int32.Parse(tmpRow["CourseID"].ToString());
dtmQuizCompletionDate = (tmpRow["QuizCompletionDate"] == System.DBNull.Value ? DateTime.Parse("1/1/1900") : (DateTime)tmpRow["QuizCompletionDate"]);
endQuizInfo = objToolbook.EndQuizSession_UpdateTables(SessionID, 46664, score, intUserID, intQuizID, intPassMark, intUnitID, ModuleID, intCourseID, intOldCourseStatus, intNewQuizStatus, intNewCourseStatus, intQuizFrequency, dtmQuizCompletionDate);
// read cert flag
tmpRow = endQuizInfo.Rows[0];
Boolean blnSendCert = (bool)tmpRow["sendcert"];
if (blnSendCert)
{
DefaultQuiz dq = new DefaultQuiz();
dq.certemail(intUserID, intCourseID, 0);
}
}
//code for adaptive
else
{
if (endQuizInfo.Rows[0]["toolbooklocation"].ToString().Trim().Contains("launchpage.html"))
{
if (!isLesson && sessiondata == SessionID && score == 100)
{
int intUserIDAdapt;
int intQuizIDAdapt;
int intPassMarkAdapt;
int intUnitIDAdapt;
int intModuleIDAdapt;
int intQuizFrequencyAdapt;
int intOldCourseStatusAdapt;
int intNewCourseStatusAdapt;
int intNewQuizStatusAdapt;
int intCourseIDAdapt;
DateTime dtmQuizCompletionDateAdapt;
intUserIDAdapt = Int32.Parse(tmpRow["UserID"].ToString());
try
{
intQuizIDAdapt = Int32.Parse(tmpRow["QuizID"].ToString());
}
catch { intQuizIDAdapt = 0; }
intPassMarkAdapt = Int32.Parse(tmpRow["PassMark"].ToString());
intUnitIDAdapt = Int32.Parse(tmpRow["UnitID"].ToString());
intModuleIDAdapt = Int32.Parse(tmpRow["ModuleID"].ToString());
intQuizFrequencyAdapt = tmpRow["adaptivequizfreq"] == null ? 0 : Int32.Parse(tmpRow["adaptivequizfreq"].ToString());
intOldCourseStatusAdapt = Int32.Parse(tmpRow["OldCourseStatus"].ToString());
intNewCourseStatusAdapt = Int32.Parse(tmpRow["NewCourseStatus"].ToString());
intNewQuizStatusAdapt = Int32.Parse(tmpRow["NewQuizStatus"].ToString());
intCourseIDAdapt = Int32.Parse(tmpRow["CourseID"].ToString());
dtmQuizCompletionDateAdapt = (tmpRow["QuizCompletionDate"] == System.DBNull.Value ? DateTime.Parse("1/1/1900") : (DateTime)tmpRow["QuizCompletionDate"]);
if (score == 100)
{
endQuizInfo = objToolbook.EndQuizSession_UpdateTables(SessionID, 46664, score, intUserIDAdapt, intQuizIDAdapt, intPassMarkAdapt, intUnitIDAdapt, ModuleID, intCourseIDAdapt, intOldCourseStatusAdapt, intNewQuizStatusAdapt, intNewCourseStatusAdapt, intQuizFrequencyAdapt, dtmQuizCompletionDateAdapt);
if (ProfileId > -1)
{
BusinessServices.Profile objProfile = new BusinessServices.Profile();
bool ApplyToQuiz = objProfile.QuizRequiredForPoints(ProfileId);
if (ApplyToQuiz) // quiz only
{
if (!(objProfile.CheckQuizPointsAlreadyGivenForPeriod(ProfileId, intUserIDAdapt, ModuleID, 1)))
{
objProfile.ApplyCPDPoints(ProfileId, intUserIDAdapt, ModuleID, 1);
}
}
}
}
// read cert flag
tmpRow = endQuizInfo.Rows[0];
Boolean blnSendCert = (bool)tmpRow["sendcert"];
if (blnSendCert)
{
DefaultQuiz dq = new DefaultQuiz();
dq.certemail(intUserIDAdapt, intCourseIDAdapt, 0);
}
}
else if (!isLesson && sessiondata == SessionID && (score > 0 && score < 100))
{
int intUserIDAdapt;
int intQuizIDAdapt;
int intPassMarkAdapt;
int intUnitIDAdapt;
int intModuleIDAdapt;
int intQuizFrequencyAdapt;
int intOldCourseStatusAdapt;
int intNewCourseStatusAdapt;
int intNewQuizStatusAdapt;
int intCourseIDAdapt;
DateTime dtmQuizCompletionDateAdapt;
intUserIDAdapt = Int32.Parse(tmpRow["UserID"].ToString());
try
{
intQuizIDAdapt = Int32.Parse(tmpRow["QuizID"].ToString());
}
catch { intQuizIDAdapt = 0; }
intPassMarkAdapt = Int32.Parse(tmpRow["PassMark"].ToString());
intUnitIDAdapt = Int32.Parse(tmpRow["UnitID"].ToString());
intModuleIDAdapt = Int32.Parse(tmpRow["ModuleID"].ToString());
intQuizFrequencyAdapt = tmpRow["adaptivequizfreq"] == null ? 0 : Int32.Parse(tmpRow["adaptivequizfreq"].ToString());
intOldCourseStatusAdapt = Int32.Parse(tmpRow["OldCourseStatus"].ToString());
intNewCourseStatusAdapt = Int32.Parse(tmpRow["NewCourseStatus"].ToString());
intNewQuizStatusAdapt = Int32.Parse(tmpRow["NewQuizStatus"].ToString());
intCourseIDAdapt = Int32.Parse(tmpRow["CourseID"].ToString());
dtmQuizCompletionDateAdapt = (tmpRow["QuizCompletionDate"] == System.DBNull.Value ? DateTime.Parse("1/1/1900") : (DateTime)tmpRow["QuizCompletionDate"]);
if (score == 100)
{
endQuizInfo = objToolbook.EndQuizSession_UpdateTables(SessionID, 46664, score, intUserIDAdapt, intQuizIDAdapt, intPassMarkAdapt, intUnitIDAdapt, ModuleID, intCourseIDAdapt, intOldCourseStatusAdapt, intNewQuizStatusAdapt, intNewCourseStatusAdapt, intQuizFrequencyAdapt, dtmQuizCompletionDateAdapt);
if (ProfileId > -1)
{
BusinessServices.Profile objProfile = new BusinessServices.Profile();
bool ApplyToQuiz = objProfile.QuizRequiredForPoints(ProfileId);
if (ApplyToQuiz) // quiz only
{
if (!(objProfile.CheckQuizPointsAlreadyGivenForPeriod(ProfileId, intUserIDAdapt, ModuleID, 1)))
{
objProfile.ApplyCPDPoints(ProfileId, intUserIDAdapt, ModuleID, 1);
}
}
}
}
}
}
}
//end code
delDME(StudentID, ModuleID);
}
if (completed && isLesson)
{
delDME(StudentID, ModuleID);
Module.InsertLessonStatus(StudentID, ModuleID, LessonStatus.Completed);
}
return("");
}
catch (Exception exc)
{
// do some thign here
Debug.WriteLine(exc.StackTrace);
return("");
}
}
private void ApplyProfilePoints(int ProfileID)
{
BusinessServices.Profile objProfile = new BusinessServices.Profile();
bool ApplyToQuiz = objProfile.QuizRequiredForPoints(ProfileID);
bool ApplyToLesson = objProfile.LessonRequiredForPoints(ProfileID);
int ModuleID = Int32.Parse(Request.QueryString["ModuleID"].ToString());
int UserID = Int32.Parse(Request.QueryString["UserID"].ToString());
// If both Quiz and Lesson need to be completed to gain points
if (ApplyToQuiz && ApplyToLesson)
{
//Check if quiz has been completed
//if it has and if lesson completed then apply points to user
if ((objProfile.CheckQuizComplete(UserID, ProfileID, ModuleID)) && (objProfile.CheckLessonComplete(UserID, ProfileID, ModuleID)))
{
if (!(objProfile.CheckLessonPointsAlreadyGivenForPeriod(ProfileID, UserID, ModuleID, 2)) || !(objProfile.CheckQuizPointsAlreadyGivenForPeriod(ProfileID, UserID, ModuleID, 2)))
{
objProfile.ApplyCPDPoints(ProfileID, UserID, ModuleID, 2);
}
}
}
else // then either quiz only or lesson only
{
if (ApplyToLesson) // lesson only
{
// if lesson completed then apply points to user
if (!(objProfile.CheckLessonPointsAlreadyGivenForPeriod(ProfileID, UserID, ModuleID, 0)))
{
objProfile.ApplyCPDPoints(ProfileID, UserID, ModuleID, 0);
}
}
// not worried about quiz in this scenario as have just completed lesson
}
}