public ArrayList get_uploaded_content_by_id(Course_elearn course)
{
SqlConnection conn = new SqlConnection();
ArrayList toReturn_list = new ArrayList();
Upload toReturn = null;
try
{
conn = new SqlConnection();
string connstr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString();
conn.ConnectionString = connstr;
conn.Open();
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.CommandText = "select upload_date, upload_title, upload_desc, server_path, upload_type, video_link from [Elearn_courseContent] where elearn_courseID=@id";
comm.Parameters.AddWithValue("@id", course.getCourseID());
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
toReturn = new Upload();
toReturn.setDate((DateTime)dr["upload_date"]); //3
toReturn.setTitle((string)dr["upload_title"]); //4
toReturn.setDesc((string)dr["upload_desc"]); //6
if (dr["server_path"] != DBNull.Value)
{
toReturn.setServerPath((string)dr["server_path"]);
}
if (dr["upload_type"] != DBNull.Value)
{
toReturn.upload_type = (string)dr["upload_type"];
}
if (dr["video_link"] != DBNull.Value)
{
toReturn.video_link = (string)dr["video_link"];
}
toReturn_list.Add(toReturn);
}
dr.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(toReturn_list);
}
protected void cfmActivate_Click(object sender, EventArgs e)
{
Course_elearnDAO ceDAO = new Course_elearnDAO();
Course_elearn currentCourse = ceDAO.get_course_by_id(Convert.ToInt32(Request.QueryString["id"]));
ceDAO.activateCourse(Convert.ToInt32(Request.QueryString["id"]));
int cat = currentCourse.getCategoryID();
//set audit
User currentUser = (User)Session["currentUser"];
setAudit(currentUser, "course", "activate", currentCourse.getCourseID().ToString(), "course name: " + currentCourse.getCourseName());
Response.Redirect($"viewAllModule.aspx");
}
public ArrayList get_testimonials_by_course(Course_elearn course)
{
SqlConnection conn = new SqlConnection();
ArrayList toReturn_list = new ArrayList();
Testimonial toReturn = null;
UserDAO u = new UserDAO();
try
{
conn = new SqlConnection();
string connstr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString();
conn.ConnectionString = connstr;
conn.Open();
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.CommandText = "select * from Testimonials where courseID=@id";
comm.Parameters.AddWithValue("@id", course.getCourseID());
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
toReturn = new Testimonial();
toReturn.setStaffName((string)dr["staff_name"]); //4
toReturn.set_course_elearn(course); //6
toReturn.setQuote((string)dr["quote"]);
toReturn.setUser(u.getUserByID((String)dr["userID"]));
toReturn.setID((int)dr["ID"]);
toReturn.setTitle((string)dr["title"]);
toReturn_list.Add(toReturn);
}
dr.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(toReturn_list);
}
protected Boolean checkIfCompletedAllPrerequisite(string userID, int quizID)
{
QuizDAO quizDAO = new QuizDAO();
QuizResultDAO qrDAO = new QuizResultDAO();
Course_elearnDAO ceDAO = new Course_elearnDAO();
Quiz currentQuiz = quizDAO.getQuizByID(quizID);
Course_elearn currentCourse = currentQuiz.getMainCourse();
//check user completed all prereq course's quizzes
ArrayList allPrereqCourses = ceDAO.getPrereqOfCourse(currentCourse.getCourseID());
if (allPrereqCourses.Count > 0)
{
foreach (Course_elearn ce in allPrereqCourses)
{
if (ce.getStatus().Equals("active") && (ce.getStartDate() <= DateTime.Now.Date && ce.getExpiryDate() >= DateTime.Now.Date))
{
List <Quiz> allQuizzes = quizDAO.getAllQuizByCourseID(ce.getCourseID());
foreach (Quiz innerQuiz in allQuizzes)
{
if (!qrDAO.getQuizResultByUserIDandQuizID(userID, innerQuiz.getQuizID()))
{
return(false);
}
}
}
}
}
//if all prereq courses cleared, to check current quiz's prereqs
ArrayList allPrerequisites = quizDAO.getPrereqOfQuiz(quizID);
foreach (Quiz prereq in allPrerequisites)
{
if (currentCourse.getStatus().Equals("active") && (currentCourse.getStartDate() <= DateTime.Now.Date && currentCourse.getExpiryDate() >= DateTime.Now.Date))
{
if (!qrDAO.getQuizResultByUserIDandQuizID(userID, prereq.getQuizID()))
{
return(false);
}
}
}
return(true);
}
protected void upload_click(object sender, EventArgs e)
{
Page.Validate("ValidateForm2");
if (!Page.IsValid)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "showModal();", true);
}
else
{
//check if is what content
string val = rblUploadType.SelectedValue.ToLower().Trim();
if (val.Equals("file"))
{
if (FileUpload1.HasFile)
{
int coursedir = current.getCourseID();
string fileName = FileUpload1.FileName;
string filepath = "~/Data/" + coursedir + "/";
string FileExtension = fileName.Substring(fileName.LastIndexOf('.') + 1).ToLower();
if (FileExtension.Equals("pdf") || FileExtension.Equals("jpeg") || FileExtension.Equals("png") || FileExtension.Equals("doc") ||
FileExtension.Equals("docx") || FileExtension.Equals("xlsx") || FileExtension.Equals("csv") || FileExtension.Equals("xlsm") ||
FileExtension.Equals("mp3") || FileExtension.Equals("mp4") || FileExtension.Equals("avi") || FileExtension.Equals("m4a") ||
FileExtension.Equals("zip") || FileExtension.Equals("rar") || FileExtension.Equals("ppt") || FileExtension.Equals("jpg") ||
FileExtension.Equals("pptx"))
{
FileUpload1.PostedFile
.SaveAs(Server.MapPath(filepath) + fileName);
string totalpath1 = Server.MapPath(filepath) + fileName;
Course_elearnDAO cdao = new Course_elearnDAO();
Upload u = new Upload(current, DateTime.Now, uploadTitleInput.Text, uploadDescriptionInput.Text, totalpath1);
u.upload_type = "file";
Upload upload_succ = cdao.upload_entry(u);
//set audit
User currentUser = (User)Session["currentUser"];
setAudit(currentUser, "course", "update", coursedir.ToString(), "uploaded filename: " + fileName);
}
}
}
else if (val.Equals("video"))
{
string title = TextBox1.Text;
string desc = TextBox2.Text;
string link = txtVideo.Text;
Course_elearnDAO cdao = new Course_elearnDAO();
Upload u = new Upload(current, DateTime.Now, TextBox1.Text, TextBox2.Text);
u.upload_type = "video";
u.video_link = link;
Upload upload_succ = cdao.upload_entry_video(u);
//set audit
User currentUser = (User)Session["currentUser"];
}
else
{
string link = TextBox5.Text;
if (FileUpload2.HasFile)
{
int coursedir = current.getCourseID();
string fileName = FileUpload2.FileName;
string filepath = "~/Data/" + coursedir + "/";
string FileExtension = fileName.Substring(fileName.LastIndexOf('.') + 1).ToLower();
if (FileExtension.Equals("pdf") || FileExtension.Equals("jpeg") || FileExtension.Equals("png") || FileExtension.Equals("doc") ||
FileExtension.Equals("docx") || FileExtension.Equals("xlsx") || FileExtension.Equals("csv") || FileExtension.Equals("xlsm") ||
FileExtension.Equals("mp3") || FileExtension.Equals("mp4") || FileExtension.Equals("avi") || FileExtension.Equals("m4a") ||
FileExtension.Equals("zip") || FileExtension.Equals("rar") || FileExtension.Equals("ppt") || FileExtension.Equals("jpg") ||
FileExtension.Equals("pptx"))
{
FileUpload2.PostedFile
.SaveAs(Server.MapPath(filepath) + fileName);
string totalpath1 = Server.MapPath(filepath) + fileName;
Course_elearnDAO cdao = new Course_elearnDAO();
Upload u = new Upload(current, DateTime.Now, TextBox3.Text, TextBox4.Text, totalpath1);
u.upload_type = "both";
u.video_link = link;
Upload upload_succ = cdao.upload_entry_both(u);
//set audit
User currentUser = (User)Session["currentUser"];
setAudit(currentUser, "course", "update", coursedir.ToString(), "uploaded filename: " + fileName);
}
}
}
}
}
protected void gvPrereqCart_RowCommand(object sender, GridViewCommandEventArgs e)
{
List <int> prereqIDlist = (List <int>)Session["selectedPrereq"];
int id = Convert.ToInt32(e.CommandArgument);
Course_elearnDAO ceDAO = new Course_elearnDAO();
Course_elearn currentCourse = ceDAO.get_course_by_id(Convert.ToInt32(Request.QueryString["id"]));
List <int> allLinkedCourses = ceDAO.getAllCourseLinkedToPrerequisite(id);
foreach (int linkedID in allLinkedCourses)
{
if (prereqIDlist.Contains(linkedID))
{
prereqIDlist.Remove(linkedID);
}
}
prereqIDlist.Remove(id);
Session["selectedPrereq"] = prereqIDlist;
var itemIDs = string.Join(",", ((IList <int>)Session["selectedPrereq"]).ToArray());
var itemIDs2 = string.Join(",", ((IList <int>)Session["selectedPostreq"]).ToArray());
var sqlQueryCourseList = "";
if (itemIDs.Length > 0 && itemIDs2.Length > 0)
{
sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.elearn_courseID NOT IN ({0}) and ec.elearn_courseID NOT IN ({1}) and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID(), itemIDs, itemIDs2);
}
else if (itemIDs.Length > 0 && itemIDs2.Length < 1)
{
sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.elearn_courseID NOT IN ({0}) and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID(), itemIDs);
}
else if (itemIDs.Length < 1 && itemIDs2.Length > 0)
{
sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.elearn_courseID NOT IN ({0}) and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID(), itemIDs2);
}
else
{
sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID());
}
SqlDataSource1.SelectCommand = sqlQueryCourseList;
gvPrereq.DataSource = SqlDataSource1;
gvPrereq.DataBind();
gvPrereq.UseAccessibleHeader = true;
if (gvPrereq.Rows.Count > 0)
{
gvPrereq.HeaderRow.TableSection = TableRowSection.TableHeader;
}
var sqlQuery = "";
if (itemIDs.Length > 0)
{
sqlQuery = String.Format("SELECT * FROM [Elearn_course] WHERE [elearn_courseID] IN ({0}) and elearn_courseID != " + currentCourse.getCourseID(), itemIDs);
}
else
{
sqlQuery = "SELECT * FROM [Elearn_course] WHERE [elearn_courseID] = -1";
}
SqlDataSourcePrereqCart.SelectCommand = sqlQuery;
gvPrereqCart.DataSource = SqlDataSourcePrereqCart;
gvPrereqCart.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["currentUser"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
User currentUser = (User)Session["currentUser"];
Course_elearnDAO ceDAO = new Course_elearnDAO();
Course_elearn currentCourse = ceDAO.get_course_by_id(Convert.ToInt32(Request.QueryString["id"]));
Boolean superuser = false;
Boolean course_creator = false;
foreach (string s in currentUser.getRoles())
{
if (s.Equals("superuser"))
{
superuser = true;
}
else if (s.Equals("course creator"))
{
course_creator = true;
}
}
if (currentUser.getUserID() != currentCourse.getCourseCreator().getUserID() && !(superuser || course_creator))
{
Response.Redirect("errorPage.aspx");
}
else
{
if (!IsPostBack)
{
moduleType.SelectedValue = currentCourse.getCategoryID().ToString();
ddlCourseType.SelectedValue = currentCourse.getCourseType();
nameOfModuleInput.Text = currentCourse.getCourseName();
lblBreadcrumbCourseName.Text = currentCourse.getCourseName();
descriptionModuleInput.Text = currentCourse.getDescription();
hoursInput.Text = currentCourse.getHoursAwarded().ToString();
if (currentCourse.getTargetAudience() != null)
{
txtTargetAudience.Text = currentCourse.getTargetAudience().ToString();
}
fromDateInput.Text = currentCourse.getStartDate().ToString("dd/MM/yyyy");
toDateInput.Text = currentCourse.getExpiryDate().ToString("dd/MM/yyyy");
//prerequisites
ArrayList allPrerequisites = currentCourse.getPrerequisite();
List <int> prereqIDlist = new List <int>();
foreach (Course_elearn prereq in allPrerequisites)
{
prereqIDlist.Add(prereq.getCourseID());
}
Session["selectedPrereq"] = prereqIDlist;
var itemIDs = string.Join(",", ((IList <int>)Session["selectedPrereq"]).ToArray());
//postrequisites
List <int> postReqIDList = getAllPostRequisiteCourses(currentCourse.getCourseID());
List <int> postReqIDListNoDup = new List <int>();
foreach (int postreqID in postReqIDList)
{
if (!postReqIDListNoDup.Contains(postreqID) && postReqIDList.Contains(postreqID))
{
postReqIDListNoDup.Add(postreqID);
}
}
Session["selectedPostreq"] = postReqIDListNoDup;
var itemIDs2 = string.Join(",", ((IList <int>)Session["selectedPostreq"]).ToArray());
//to load course list
var sqlQueryCourseList = "";
if (itemIDs.Length > 0 && itemIDs2.Length > 0)
{
sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.elearn_courseID NOT IN ({0}) and ec.elearn_courseID NOT IN ({1}) and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID(), itemIDs, itemIDs2);
}
else if (itemIDs.Length > 0 && itemIDs2.Length < 1)
{
sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.elearn_courseID NOT IN ({0}) and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID(), itemIDs);
}
else if (itemIDs.Length < 1 && itemIDs2.Length > 0)
{
sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.elearn_courseID NOT IN ({0}) and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID(), itemIDs2);
}
else
{
sqlQueryCourseList = String.Format("SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date<=getDate() and ec.expiry_date>=getDate() and ec.courseType='Online Learning' and ec.elearn_courseID != " + currentCourse.getCourseID());
}
SqlDataSource1.SelectCommand = sqlQueryCourseList;
gvPrereq.DataSource = SqlDataSource1;
gvPrereq.DataBind();
gvPrereq.UseAccessibleHeader = true;
if (gvPrereq.Rows.Count > 0)
{
gvPrereq.HeaderRow.TableSection = TableRowSection.TableHeader;
}
//to load prereq cart
var sqlQuery = "";
if (itemIDs.Length > 0)
{
sqlQuery = String.Format("SELECT * FROM [Elearn_course] WHERE [elearn_courseID] IN ({0}) and elearn_courseID != " + currentCourse.getCourseID(), itemIDs);
}
else
{
sqlQuery = "SELECT * FROM [Elearn_course] WHERE [elearn_courseID] = -1";
}
SqlDataSourcePrereqCart.SelectCommand = sqlQuery;
gvPrereqCart.DataSource = SqlDataSourcePrereqCart;
gvPrereqCart.DataBind();
Session["currentMod"] = nameOfModuleInput.Text;
}
}
}
}
protected void submitBtn_Click(object sender, EventArgs e)
{
Page.Validate("ValidateForm");
if (!Page.IsValid)
{
}
else
{
Course_elearnDAO cdao = new Course_elearnDAO();
//int id_int = Convert.ToInt32(id.Text);
Boolean check = true;
User user = (User)Session["currentUser"];
Course_elearn c = null;
string type = Request.QueryString["type"];
string name = nameOfModuleInput.Text;
string fromDate = fromDateInput.Text.Substring(3, 2) + "/" + fromDateInput.Text.Substring(0, 2) + "/" + fromDateInput.Text.Substring(6, 4);
string toDate = toDateInput.Text.Substring(3, 2) + "/" + toDateInput.Text.Substring(0, 2) + "/" + toDateInput.Text.Substring(6, 4);
if (check && moduleType.Text != "") // if no expiry date
{
c = new Course_elearn(name, user.getDepartment(), DateTime.Now,
DateTime.ParseExact(fromDate, "MM/dd/yyyy", CultureInfo.InvariantCulture), DateTime.ParseExact(toDate, "MM/dd/yyyy", CultureInfo.InvariantCulture), "active", descriptionModuleInput.Text, Convert.ToInt32(moduleType.SelectedValue), user, Convert.ToDouble(hoursInput.Text), txtTargetAudience.Text, ddlCourseType.SelectedValue);
}
//check pre req here
//pull pre req from model, check the course object here before creating the entry in the database
/*List<int> allSelectedID = new List<int>();
* int counter = 0;
* foreach (GridViewRow row in gvPrereq.Rows)
* {
* CheckBox chkRow = (row.Cells[0].FindControl("chkboxPrereq") as CheckBox);
* if (chkRow.Checked)
* {
* int prereqID = Convert.ToInt32(gvPrereq.DataKeys[counter].Value.ToString());
* allSelectedID.Add(prereqID);
* }
* counter++;
* }*/
//create the course object
//now insert into database by calling DAO
Course_elearnDAO cDao = new Course_elearnDAO();
Course_elearn res = cDao.create_elearnCourse(c);
Course_elearn course_with_id = cDao.get_course_by_name(res);
List <int> prereqIDlist = (List <int>)Session["selectedPrereq"];
int id = course_with_id.getCourseID();
if (ddlCourseType.SelectedValue.Equals("Online Learning"))
{
foreach (int prereqID in prereqIDlist)
{
cDao.insertPrerequisite(id, prereqID);
}
//create dir
string file = "~/Data/";
string add = Server.MapPath(file) + id;
Directory.CreateDirectory(add);
}
//set audit
User currentUser = (User)Session["currentUser"];
setAudit(currentUser, "course", "create", res.getCourseID().ToString(), "course name: " + res.getCourseName());
Response.Redirect("viewModuleInfo.aspx?id=" + id);
}
}
protected void gvPrereqCart_RowCommand(object sender, GridViewCommandEventArgs e)
{
string id_str = Request.QueryString["id"];
int id_num = int.Parse(id_str);
QuizDAO quizDAO = new QuizDAO();
Quiz currentQuiz = quizDAO.getQuizByID(id_num);
Course_elearn currentCourse = currentQuiz.getMainCourse();
List <int> prereqIDlist = (List <int>)Session["selectedPrereq"];
int id = Convert.ToInt32(e.CommandArgument);
List <int> allLinkedQuizzes = quizDAO.getAllQuizLinkedToPrerequisite(id);
foreach (int linkedID in allLinkedQuizzes)
{
if (prereqIDlist.Contains(linkedID))
{
prereqIDlist.Remove(linkedID);
}
}
prereqIDlist.Remove(id);
Session["selectedPrereq"] = prereqIDlist;
var itemIDs = string.Join(",", ((IList <int>)Session["selectedPrereq"]).ToArray());
var sqlQueryCourseList = "";
if (itemIDs.Length > 0)
{
sqlQueryCourseList = String.Format("SELECT * FROM [Quiz] WHERE status='active' and elearn_courseID='{0}' and quizID NOT IN ({1}) and quizID != " + id_str, currentCourse.getCourseID(), itemIDs);
}
else
{
sqlQueryCourseList = "SELECT * FROM [Quiz] WHERE status='active' and elearn_courseID = '" + currentCourse.getCourseID() + "' and quizID != " + currentQuiz.getQuizID();
}
SqlDataSource1.SelectCommand = sqlQueryCourseList;
gvPrereq.DataSource = SqlDataSource1;
gvPrereq.DataBind();
gvPrereq.UseAccessibleHeader = true;
if (gvPrereq.Rows.Count > 0)
{
gvPrereq.HeaderRow.TableSection = TableRowSection.TableHeader;
}
var sqlQuery = "";
if (itemIDs.Length > 0)
{
sqlQuery = String.Format("SELECT * FROM [Quiz] WHERE [quizID] IN ({0})", itemIDs);
}
else
{
sqlQuery = "SELECT * FROM [Quiz] WHERE [quizID] = -1";
}
SqlDataSourcePrereqCart.SelectCommand = sqlQuery;
gvPrereqCart.DataSource = SqlDataSourcePrereqCart;
gvPrereqCart.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["currentUser"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
User currentUser = (User)Session["currentUser"];
QuizDAO quizDAO = new QuizDAO();
String id_str = Request.QueryString["id"];
int id_num = int.Parse(id_str);
Quiz currentQuiz = quizDAO.getQuizByID(id_num);
Course_elearn currentCourse = currentQuiz.getMainCourse();
lblBreadcrumbCourseName.Text = currentQuiz.getMainCourse().getCourseName();
Boolean superuser = false;
Boolean course_creator = false;
foreach (string s in currentUser.getRoles())
{
if (s.Equals("superuser"))
{
superuser = true;
}
else if (s.Equals("course creator"))
{
course_creator = true;
}
}
if (currentUser.getUserID() != currentCourse.getCourseCreator().getUserID() && !(superuser || course_creator))
{
Response.Redirect("errorPage.aspx");
}
else
{
if (!IsPostBack)
{
txtQuizTitle.Text = currentQuiz.getTitle();
txtQuizDesc.Text = currentQuiz.getDescription();
txtNumCorrectAns.Text = currentQuiz.getPassingGrade().ToString();
txtTimeLimit.Text = currentQuiz.getTimeLimit().ToString();
rdlAttempt.SelectedValue = currentQuiz.getMultipleAttempts();
ddlDisplayAnswer.SelectedValue = currentQuiz.getDisplayAnswer();
if (currentQuiz.getMultipleAttempts().Equals("y"))
{
txtNoOfAttempt.Text = "";
txtNoOfAttempt.Enabled = false;
}
else
{
txtNoOfAttempt.Text = currentQuiz.getNumberOfAttempts().ToString();
txtNoOfAttempt.Enabled = true;
}
if (currentQuiz.getRandomOrder().Equals("y"))
{
ddlRandomize.SelectedIndex = 0;
}
else
{
ddlRandomize.SelectedIndex = 1;
}
if (currentQuiz.getStatus().Equals("active"))
{
btnActivate.Visible = false;
btnDeactivate.Visible = true;
}
else
{
btnActivate.Visible = true;
btnDeactivate.Visible = false;
}
//prerequisites
ArrayList allPrerequisites = quizDAO.getPrereqOfQuiz(currentQuiz.getQuizID());
List <int> prereqIDlist = new List <int>();
foreach (Quiz prereq in allPrerequisites)
{
prereqIDlist.Add(prereq.getQuizID());
}
Session["selectedPrereq"] = prereqIDlist;
var itemIDs = string.Join(",", ((IList <int>)Session["selectedPrereq"]).ToArray());
//to load course list
var sqlQueryQuizList = "";
if (itemIDs.Length > 0)
{
sqlQueryQuizList = String.Format("SELECT * FROM [Quiz] WHERE status='active' and elearn_courseID='{0}' and quizID NOT IN ({1}) and quizID != " + id_str, currentCourse.getCourseID(), itemIDs);
}
else
{
sqlQueryQuizList = "SELECT * FROM [Quiz] WHERE status='active' and elearn_courseID = '" + currentCourse.getCourseID() + "' and quizID != " + currentQuiz.getQuizID();
}
SqlDataSource1.SelectCommand = sqlQueryQuizList;
gvPrereq.DataSource = SqlDataSource1;
gvPrereq.DataBind();
gvPrereq.UseAccessibleHeader = true;
if (gvPrereq.Rows.Count > 0)
{
gvPrereq.HeaderRow.TableSection = TableRowSection.TableHeader;
}
//to load prereq cart
var sqlQuery = "";
if (itemIDs.Length > 0)
{
sqlQuery = String.Format("SELECT * FROM [Quiz] WHERE [quizID] IN ({0}) and quizID != " + currentQuiz.getQuizID(), itemIDs);
}
else
{
sqlQuery = "SELECT * FROM [Quiz] WHERE [quizID] = -1";
}
SqlDataSourcePrereqCart.SelectCommand = sqlQuery;
gvPrereqCart.DataSource = SqlDataSourcePrereqCart;
gvPrereqCart.DataBind();
}
}
/*
* if (Session["currentQuiz"] == null)
* {
* Session["currentQuiz"] = txtQuizTitle.Text;
* System.Diagnostics.Debug.WriteLine("Setting currentQuiz");
* }
*/
}
}
