protected void cfmSubmit_Click(object sender, EventArgs e)
{
//to do validations
Course_elearnDAO ceDAO = new Course_elearnDAO();
int courseID = Convert.ToInt32(Request.QueryString["id"]);
Course_elearn currentCourse = ceDAO.get_course_by_id(courseID);
//change to MM-dd-yyyy
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);
ceDAO.updateCourse(courseID, Convert.ToInt32(moduleType.SelectedValue), nameOfModuleInput.Text, descriptionModuleInput.Text, Convert.ToDouble(hoursInput.Text), DateTime.ParseExact(fromDate, "MM/dd/yyyy", CultureInfo.InvariantCulture), DateTime.ParseExact(toDate, "MM/dd/yyyy", CultureInfo.InvariantCulture));
//update prerequisites
//delete all prereq first
ceDAO.deletePrerequisitesByCourseID(courseID);
//insert all new prereq
List <int> prereqIDlist = (List <int>)Session["selectedPrereq"];
foreach (int prereqID in prereqIDlist)
{
ceDAO.insertPrerequisite(courseID, prereqID);
}
//set audit
User currentUser = (User)Session["currentUser"];
setAudit(currentUser, "course", "update", courseID.ToString(), "course name: " + currentCourse.getCourseName());
Response.Redirect($"viewModuleInfo.aspx?id={courseID}");
}
protected void checkTitleExists(object sender, ServerValidateEventArgs args)
{
String input = uploadTitleInput.Text;
Boolean checker = false;
Course_elearnDAO cdao = new Course_elearnDAO();
ArrayList list = cdao.get_uploaded_content_by_id(current);
string dir = "Data/" + current.getCourseID();
foreach (string strfile in Directory.GetFiles(Server.MapPath(dir)))
{
foreach (Upload u in list)
{
if (u.getTitle().Equals(input))
{
checker = true;
}
}
}
if (checker)
{
System.Diagnostics.Debug.WriteLine("args false");
args.IsValid = false;
}
else
{
System.Diagnostics.Debug.WriteLine("args true");
args.IsValid = true;
}
}
protected void validateNameExists(Object source, EventArgs args)
{
System.Diagnostics.Debug.WriteLine("VALIDATENAMEEXISTS");
String input = nameOfModuleInput.Text;
input = input.Replace("'", "''");
Course_elearnDAO course_elearnDAO = new Course_elearnDAO();
if (course_elearnDAO.checkModuleNameExists(input))
{
if ((String)Session["currentMod"] == input)
{
System.Diagnostics.Debug.WriteLine("modulenamedoesnotexist");
//lbl_nameValidate.Visible = false;
lbl_nameValidate.Attributes.Add("style", "display:none");
lbl_nameValidate.Text = "";
}
else
{
System.Diagnostics.Debug.WriteLine("modulenameexists");
//lbl_nameValidate.Visible = true;
lbl_nameValidate.Attributes.Add("style", "display:unset");
lbl_nameValidate.Text = "This module already exists! Please input another Name.";
}
}
else
{
System.Diagnostics.Debug.WriteLine("modulenamedoesnotexist");
//lbl_nameValidate.Visible = false;
lbl_nameValidate.Attributes.Add("style", "display:none");
lbl_nameValidate.Text = "";
}
}
protected int checkNumberOfCourseUserComplete(string userID)
{
Course_elearnDAO ceDAO = new Course_elearnDAO();
ArrayList allCourses = ceDAO.getAllCourses();
QuizDAO quizDAO = new QuizDAO();
QuizResultDAO qrDAO = new QuizResultDAO();
ArrayList allResults = qrDAO.getAllQuizResultByUserID(userID);
List <int> allCompletedCourseID = new List <int>();
double totalLearningHours = 0;
int counter = 0;
foreach (Course_elearn ce in allCourses)
{
List <Quiz> allQuizForCourse = quizDAO.getAllQuizByCourseID(ce.getCourseID());
Boolean checkIfCompleteAllQuiz = true;
Boolean checkIfCourseGotQuiz = false;
foreach (Quiz currentQuiz in allQuizForCourse)
{
checkIfCourseGotQuiz = true;
if (!qrDAO.checkIfUserPassQuiz(userID, currentQuiz.getQuizID()))
{
checkIfCompleteAllQuiz = false;
}
}
if (checkIfCompleteAllQuiz && checkIfCourseGotQuiz)
{
counter++;
allCompletedCourseID.Add(ce.getCourseID());
totalLearningHours = totalLearningHours + ce.getHoursAwarded();
}
}
Session["allCompletedCourseID"] = allCompletedCourseID;
Session["totalLearningHours"] = totalLearningHours;
return(counter);
}
protected void checkVideoLinkExists(object sender, ServerValidateEventArgs args)
{
String currLink = "";
if (rblUploadType.SelectedValue.Equals("video"))
{
currLink = txtVideo.Text;
}
else if (rblUploadType.SelectedValue.Equals("both"))
{
currLink = txtVideo2.Text;
}
Course_elearnDAO cdao = new Course_elearnDAO();
ArrayList list = cdao.get_uploaded_content_by_id(current);
string dir = "Data/" + current.getCourseID();
Boolean toReturn = false;
foreach (Upload u in list)
{
if (currLink.Equals(u.video_link))
{
toReturn = true;
}
}
if (toReturn)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
User currentUser = (User)Session["currentUser"];
if (currentUser == null)
{
Response.Redirect("Login.aspx");
}
else
{
if (!IsPostBack)
{
UserDAO userDAO = new UserDAO();
User currentSelectedUser = userDAO.getUserByID((string)Request.QueryString["id"]);
Course_elearnDAO ceDAO = new Course_elearnDAO();
List <int> suggestedCourseIDList = ceDAO.getAllSuggestedCoursesByUserID((string)Request.QueryString["id"]);
Session["suggestedCourseIDList"] = suggestedCourseIDList;
}
var itemIDs = string.Join(",", ((IList <int>)Session["suggestedCourseIDList"]).ToArray());
//to load course list
var sqlQueryCourseList = "";
if (itemIDs.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.elearn_courseID NOT IN ({0})", itemIDs);
}
else
{
sqlQueryCourseList = "SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date <= getDate()";
}
SqlDataSource1.SelectCommand = sqlQueryCourseList;
gvCourses.DataSource = SqlDataSource1;
gvCourses.DataBind();
gvCourses.UseAccessibleHeader = true;
if (gvCourses.Rows.Count > 0)
{
gvCourses.HeaderRow.TableSection = TableRowSection.TableHeader;
}
//to load suggested cart
var sqlQuery = "";
if (itemIDs.Length > 0)
{
sqlQuery = String.Format("SELECT * FROM [Elearn_course] WHERE [elearn_courseID] IN ({0})", itemIDs);
}
else
{
sqlQuery = "SELECT * FROM [Elearn_course] WHERE [elearn_courseID] = -1";
}
SqlDataSourceCourseCart.SelectCommand = sqlQuery;
gvCourseCart.DataSource = SqlDataSourceCourseCart;
gvCourseCart.DataBind();
//btnViewReport.OnClientClick = $"window.open('progressReports.aspx?id={ddlSelectUser.SelectedValue}')";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null && Request.QueryString["path"] != null)
{
//TestimonialDAO tdao = new TestimonialDAO();
string id = Request.QueryString["id"];
string fullPath = Request.QueryString["path"];
int id_num = Convert.ToInt32(id);
if (!System.IO.File.Exists(fullPath))
{
Response.Redirect("Home.aspx");
}
else
{
System.IO.File.Delete(fullPath);
Course_elearnDAO cdao = new Course_elearnDAO();
cdao.delete_Material(id_num, fullPath);
//set audit
User currentUser = (User)Session["currentUser"];
string filename = Path.GetFileName(fullPath);
setAudit(currentUser, "course", "update", id, "deleted material link: " + filename);
}
Response.Redirect("viewModuleInfo.aspx?id=" + id_num);
}
}
protected void btnSaveDetails_Click(object sender, EventArgs e)
{
int courseID = Convert.ToInt32(Request.QueryString["id"]);
Course_elearnDAO ceDAO = new Course_elearnDAO();
//ceDAO.updateCourseTargetAudience(courseID, txtTargetAudience.Text);
Response.Redirect("viewModuleInfo.aspx?id=" + courseID);
}
protected void Page_Load(object sender, EventArgs e)
{
User currentUser = (User)Session["currentUser"];
if (currentUser == null)
{
Response.Redirect("Login.aspx");
}
else
{
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 (superuser || course_creator)
{
if (!IsPostBack)
{
Course_elearnDAO cdao = new Course_elearnDAO();
String id_str = Request.QueryString["id"];
int id_num = int.Parse(id_str);
lblBreadcrumbCourseName.Text = cdao.get_course_by_id(id_num).getCourseName();
List <QuizQuestion> allQuestions = new List <QuizQuestion>();
Session["allQuestions"] = allQuestions;
Session["questionNumber"] = 1;
lblQuestionNumber.Text = "Question " + 1;
lblAddedMsg.Visible = false;
}
else
{
int counter = (int)Session["questionNumber"];
lblQuestionNumber.Text = "Question " + counter;
lblAddedMsg.Visible = false;
}
}
else
{
Response.Redirect("errorPage.aspx");
}
/*
* if (Page.IsPostBack)
* {
* // reshow
* ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal();", true);
* }*/
}
}
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();
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 sqlQueryCourseList = "";
if (itemIDs.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'", itemIDs);
}
else
{
sqlQueryCourseList = "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'";
}
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})", itemIDs);
}
else
{
sqlQuery = "SELECT * FROM [Elearn_course] WHERE [elearn_courseID] = -1";
}
SqlDataSourcePrereqCart.SelectCommand = sqlQuery;
gvPrereqCart.DataSource = SqlDataSourcePrereqCart;
gvPrereqCart.DataBind();
}
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");
}
protected void Page_Load(object sender, EventArgs e)
{
User currentUser = (User)Session["currentUser"];
if (currentUser == null)
{
Response.Redirect("Login.aspx");
}
else
{
Boolean superuser = false;
foreach (string s in currentUser.getRoles())
{
if (s.Equals("superuser"))
{
superuser = true;
}
}
if (!superuser)
{
Response.Redirect("errorPage.aspx");
}
}
UserDAO userDAO = new UserDAO();
List <User> allUsers = userDAO.getAllUsers();
lblUsers.Text = allUsers.Count().ToString();
Course_elearnDAO courseDAO = new Course_elearnDAO();
ArrayList allCourses = courseDAO.getAllCourses();
lblCourses.Text = allCourses.Count.ToString();
lblQuizAttempts.Text = GetTotalNoOfQuiz().ToString();
lblHours.Text = GetTotalNoOfLearningHours().ToString();
renderUserPieChart();
renderCoursePieChart();
renderPopularCourse();
renderPopularCourseCategory();
renderAuditFunction();
renderAuditFunctionName();
renderTopLearnersHours();
renderTopLearnersName();
renderTopLearnersNameByQuiz();
renderTopLearnersQuiz();
}
protected void Page_Load(object sender, EventArgs e)
{
Course_elearnDAO d = new Course_elearnDAO();
ArrayList list = d.view_courses("Leadership");
foreach(Course_elearn c in list)
{
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
cell1.Text = c.getCourseID().ToString();
TableCell cell2 = new TableCell();
cell2.Text = c.getCourseName().ToString();
row.Cells.Add(cell1);
row.Cells.Add(cell2);
myTable.Rows.Add(row);
}
}
protected void ddlSelectUser_SelectedIndexChanged(object sender, EventArgs e)
{
Course_elearnDAO ceDAO = new Course_elearnDAO();
List <int> suggestedCourseIDList = ceDAO.getAllSuggestedCoursesByUserID((string)Request.QueryString["id"]);
Session["suggestedCourseIDList"] = suggestedCourseIDList;
var itemIDs = string.Join(",", ((IList <int>)Session["suggestedCourseIDList"]).ToArray());
//to load course list
var sqlQueryCourseList = "";
if (itemIDs.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.elearn_courseID NOT IN ({0})", itemIDs);
}
else
{
sqlQueryCourseList = "SELECT * FROM [Elearn_course] ec INNER JOIN [Elearn_courseCategory] ecc ON ec.categoryID = ecc.categoryID WHERE ec.status='active' and ec.start_date <= getDate()";
}
SqlDataSource1.SelectCommand = sqlQueryCourseList;
gvCourses.DataSource = SqlDataSource1;
gvCourses.DataBind();
gvCourses.UseAccessibleHeader = true;
if (gvCourses.Rows.Count > 0)
{
gvCourses.HeaderRow.TableSection = TableRowSection.TableHeader;
}
//to load suggested cart
var sqlQuery = "";
if (itemIDs.Length > 0)
{
sqlQuery = String.Format("SELECT * FROM [Elearn_course] WHERE [elearn_courseID] IN ({0})", itemIDs);
}
else
{
sqlQuery = "SELECT * FROM [Elearn_course] WHERE [elearn_courseID] = -1";
}
SqlDataSourceCourseCart.SelectCommand = sqlQuery;
gvCourseCart.DataSource = SqlDataSourceCourseCart;
gvCourseCart.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//Response.Write(DateTime.Now.ToShortDateString());
Course_elearnDAO cdao = new Course_elearnDAO();
string id_str = null;
if (Request.QueryString["id"] != null)
{
id_str = Request.QueryString["id"];
int id_num = int.Parse(id_str);
current = cdao.get_course_by_id(id_num);
TestimonialDAO t = new TestimonialDAO();
testimonials = t.get_testimonials_by_course(current);
}
else
{
return;
}
if (!IsPostBack)
{
int id_num = int.Parse(id_str);
current = cdao.get_course_by_id(id_num);
lblCourseNameHeader.Text = current.getCourseName();
lblBreadcrumbCourseName.Text = current.getCourseName();
lblCourseName.Text = current.getCourseName();
lblCourseDescription.Text = current.getDescription();
hoursOutput.Text = current.getHoursAwarded().ToString();
if (!current.getTargetAudience().Equals(""))
{
lblTargetAudience.Text = current.getTargetAudience();
}
else
{
lblTargetAudience.Text = "-";
}
lblCoursePeriodStart.Text = "Start: " + current.getStartDate().ToLongDateString();
lblCoursePeriodEnd.Text = "End: " + current.getExpiryDate().ToLongDateString();
DateTime currentDateTime = DateTime.Now;
if (current.getStatus().Equals("Inactive") || !(DateTime.Compare(current.getStartDate(), currentDateTime) < 0 && DateTime.Compare(current.getExpiryDate(), currentDateTime) > 0))
{
panelInactive.Visible = true;
}
Page.Form.Attributes.Add("enctype", "multipart/form-data");
}
}
protected void cfmSubmit_Click(object sender, EventArgs e)
{
string userID = (string)Request.QueryString["id"];
List <int> suggestedCourseIDList = (List <int>)Session["suggestedCourseIDList"];
Course_elearnDAO ceDAO = new Course_elearnDAO();
//delete all existing suggested courses
ceDAO.deleteSuggestedCoursesByUserID(userID);
//insert new suggested courses
foreach (int id in suggestedCourseIDList)
{
ceDAO.insertSuggestedCourses(id, userID);
}
//to change redirect path
Response.Redirect("progressReports.aspx?id=" + userID);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null && Request.QueryString["video_link"] != null)
{
//TestimonialDAO tdao = new TestimonialDAO();
string id = Request.QueryString["id"];
string link = Request.QueryString["video_link"];
int id_num = Convert.ToInt32(id);
User currentUser = (User)Session["currentUser"];
Course_elearnDAO cdao = new Course_elearnDAO();
cdao.delete_link(id_num, link);
setAudit(currentUser, "course", "update", id, "deleted material link: " + link);
Response.Redirect("viewModuleInfo.aspx?id=" + id_num);
}
}
protected void checkUploadNameExists(object sender, ServerValidateEventArgs args)
{
String currFileName = "";
if (rblUploadType.SelectedValue.Equals("file"))
{
currFileName = FileUpload1.FileName.ToString();
}
else if (rblUploadType.SelectedValue.Equals("both"))
{
currFileName = FileUpload2.FileName.ToString();
}
Course_elearnDAO cdao = new Course_elearnDAO();
ArrayList list = cdao.get_uploaded_content_by_id(current);
string strfile = "";
string dir = "Data/" + current.getCourseID();
Boolean toReturn = false;
foreach (Upload u in list)
{
//edit the getUploadID in dao to return video content also
DateTime date = DateTime.Now;
foreach (string str in Directory.GetFiles(Server.MapPath(dir)))
{
if (u.getServerPath() != null && u.getServerPath().Equals(str))
{
strfile = str;
String currName = Path.GetFileName(strfile);
if (currFileName.Equals(currName))
{
toReturn = true;
}
}
}
}
if (toReturn)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
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 ArrayList getAllPrerequisites(int courseID)
{
ArrayList toReturn = new ArrayList();
Course_elearnDAO ceDAO = new Course_elearnDAO();
ArrayList coursePrereqs = ceDAO.getPrereqOfCourse(courseID);
foreach (Course_elearn prerequisite in coursePrereqs)
{
toReturn.Add(prerequisite.getCourseID());
ArrayList morePrereq = getAllPrerequisites(prerequisite.getCourseID());
if (morePrereq.Count > 0)
{
foreach (int prerequisitesID in morePrereq)
{
toReturn.Add(prerequisitesID);
}
}
}
return(toReturn);
}
protected List <int> getAllPostRequisiteCourses(int courseID)
{
List <int> toReturn = new List <int>();
Course_elearnDAO ceDAO = new Course_elearnDAO();
List <int> currentPostRequisite = ceDAO.getAllCourseLinkedToPrerequisite(courseID);
foreach (int currentCourseID in currentPostRequisite)
{
toReturn.Add(currentCourseID);
List <int> innerList = getAllPostRequisiteCourses(currentCourseID);
if (innerList.Count > 0)
{
foreach (int innerListCourseID in innerList)
{
toReturn.Add(innerListCourseID);
}
}
}
return(toReturn);
}
protected void Page_Load(object sender, EventArgs e)
{
UserDAO userDAO = new UserDAO();
List <User> allUsers = userDAO.getAllUsers();
lblUsers.Text = allUsers.Count().ToString();
Course_elearnDAO courseDAO = new Course_elearnDAO();
ArrayList allCourses = courseDAO.getAllCourses();
lblCourses.Text = allCourses.Count.ToString();
//QuizResultHistoryDAO qrhDAO = new QuizResultHistoryDAO();
//List<QuizResultHistory> allQuiz = qrhDAO.getAll();
//lblQuizAttempts.Text = allQuiz.Count().ToString();
renderUserPieChart();
renderCoursePieChart();
renderPopularCourse();
renderPopularCourseCategory();
}
protected void Page_Load(object sender, EventArgs e)
{
//Response.Write(DateTime.Now.ToShortDateString());
Course_elearnDAO cdao = new Course_elearnDAO();
string id_str = null;
if (Request.QueryString["id"] != null)
{
id_str = Request.QueryString["id"];
int id_num = int.Parse(id_str);
current = cdao.get_course_by_id(id_num);
TestimonialDAO t = new TestimonialDAO();
testimonials = t.get_testimonials_by_course(current);
}
else
{
return;
}
if (!IsPostBack)
{
int id_num = int.Parse(id_str);
current = cdao.get_course_by_id(id_num);
lblCourseNameHeader.Text = current.getCourseName();
lblBreadcrumbCourseName.Text = current.getCourseName();
lblCourseName.Text = current.getCourseName();
lblCourseDescription.Text = current.getDescription();
hoursOutput.Text = current.getHoursAwarded().ToString();
if (!current.getTargetAudience().Equals(""))
{
lblTargetAudience.Text = current.getTargetAudience();
}
else
{
lblTargetAudience.Text = "-";
}
lblCoursePeriodStart.Text = "Start: " + current.getStartDate().ToLongDateString();
lblCoursePeriodEnd.Text = "End: " + current.getExpiryDate().ToLongDateString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
User currentUser = (User)Session["currentUser"];
if (currentUser == null)
{
Response.Redirect("Login.aspx");
}
else
{
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 (superuser || course_creator)
{
if (!IsPostBack)
{
Course_elearnDAO cdao = new Course_elearnDAO();
string id_str = Request.QueryString["id"];
int id_num = int.Parse(id_str);
lblBreadcrumbCourseName.Text = cdao.get_course_by_id(id_num).getCourseName();
}
}
else
{
Response.Redirect("errorPage.aspx");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Course_elearnDAO cdao = new Course_elearnDAO();
int id_int = Convert.ToInt32(id.Text);
Boolean check = false;
DateTime exp = new DateTime();
if (expiry != null)
{
if (expiry.Text != "")
{
exp = Convert.ToDateTime(expiry.Text);
check = true;
}
}
Course_elearn c = null;
if (check) // if no expiry date
{
c = new Course_elearn(id_int, name.Text, provider.Text, DateTime.Now, status.Text, desc.Text, "Leadership");
}
else // if got expiry date
{
c = new Course_elearn(id_int, name.Text, provider.Text, DateTime.Now, exp, status.Text, desc.Text, "Leadership");
}
//check pre req here
//pull pre req from model, check the course object here before creating the entry in the database
//create the course object
//now insert into database by calling DAO
Course_elearnDAO cDao = new Course_elearnDAO();
Course_elearn res = cDao.create_elearnCourse(c);
Session.Add("res", res);
Response.Redirect("WebForm1.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
User currentUser = (User)Session["currentUser"];
if (currentUser == null)
{
Response.Redirect("Login.aspx");
}
else
{
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 (!superuser || !course_creator)
{
Response.Redirect("errorPage.aspx");
}
if (!IsPostBack)
{
QuizDAO quizDAO = new QuizDAO();
Course_elearnDAO cdao = new Course_elearnDAO();
int quizID = Convert.ToInt32(Request.QueryString["id"]);
Quiz currentQuiz = quizDAO.getQuizByID(quizID);
int courseID = currentQuiz.getMainCourse().getCourseID();
lblBreadcrumbCourseName.Text = cdao.get_course_by_id(courseID).getCourseName();
}
}
}
protected void gvPrereq_RowCommand(object sender, GridViewCommandEventArgs e)
{
List <int> prereqIDlist = (List <int>)Session["selectedPrereq"];
int id = Convert.ToInt32(e.CommandArgument);
//to get course and add any prereq related to the course
Course_elearnDAO ceDAO = new Course_elearnDAO();
Course_elearn currentCourse = ceDAO.get_course_by_id(Convert.ToInt32(Request.QueryString["id"]));
Course_elearn selectedCourse = ceDAO.get_course_by_id(id);
ArrayList allPrereq = getAllPrerequisites(id);
ArrayList allPrereqNoDup = new ArrayList();
foreach (int prereqID in allPrereq)
{
if (!allPrereqNoDup.Contains(prereqID) && !prereqIDlist.Contains(prereqID))
{
allPrereqNoDup.Add(prereqID);
}
}
foreach (int prereqID in allPrereqNoDup)
{
prereqIDlist.Add(prereqID);
}
prereqIDlist.Add(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 = String.Format("SELECT * FROM [Elearn_course] WHERE [elearn_courseID] IN ({0}) and elearn_courseID != " + currentCourse.getCourseID(), itemIDs);
SqlDataSourcePrereqCart.SelectCommand = sqlQuery;
gvPrereqCart.DataSource = SqlDataSourcePrereqCart;
gvPrereqCart.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
User currentUser = (User)Session["currentUser"];
if (currentUser == null)
{
Response.Redirect("Login.aspx");
}
else
{
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 (superuser || course_creator)
{
if (!IsPostBack)
{
Course_elearnDAO cdao = new Course_elearnDAO();
string id_str = Request.QueryString["id"];
int id_num = int.Parse(id_str);
lblBreadcrumbCourseName.Text = cdao.get_course_by_id(id_num).getCourseName();
List <int> prereqIDlist = new List <int>();
List <string> part1 = new List <string>();
Session["createQuiz1"] = part1;
Session["selectedPrereq"] = prereqIDlist;
var itemIDs = string.Join(",", ((IList <int>)Session["selectedPrereq"]).ToArray());
//to load course list
var sqlQueryCourseList = "";
if (itemIDs.Length > 0)
{
sqlQueryCourseList = String.Format("SELECT * FROM [Quiz] WHERE status='active' and elearn_courseID='{0}' and quizID NOT IN ({1})", id_str, itemIDs);
}
else
{
sqlQueryCourseList = "SELECT * FROM [Quiz] WHERE status='active' and elearn_courseID = '" + id_str + "'";
}
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 [Quiz] WHERE [quizID] IN ({0})", itemIDs);
}
else
{
sqlQuery = "SELECT * FROM [Quiz] WHERE [quizID] = -1";
}
SqlDataSourcePrereqCart.SelectCommand = sqlQuery;
gvPrereqCart.DataSource = SqlDataSourcePrereqCart;
gvPrereqCart.DataBind();
}
}
else
{
Response.Redirect("errorPage.aspx");
}
}
}
protected void btnConfirmSubmit_Click(object sender, EventArgs e)
{
//to do validation
Page.Validate("ValidateFormTwo");
if (!Page.IsValid)
{
}
else
{
//add the last question
List <QuizQuestion> allQuestions = (List <QuizQuestion>)Session["allQuestions"];
QuizQuestion newQuestion = new QuizQuestion();
newQuestion.setQuestion(txtQuizQuestion.Text);
QuizAnswer answer1 = new QuizAnswer();
answer1.setAnswer(txtOptionOne.Text);
QuizAnswer answer2 = new QuizAnswer();
answer2.setAnswer(txtOptionTwo.Text);
QuizAnswer answer3 = new QuizAnswer();
answer3.setAnswer(txtOptionThree.Text);
QuizAnswer answer4 = new QuizAnswer();
answer4.setAnswer(txtOptionFour.Text);
List <QuizAnswer> allAnswersForLastQn = new List <QuizAnswer>();
allAnswersForLastQn.Add(answer1);
allAnswersForLastQn.Add(answer2);
allAnswersForLastQn.Add(answer3);
allAnswersForLastQn.Add(answer4);
newQuestion.setAllAnswers(allAnswersForLastQn);
if (ddlCorrectAns.SelectedValue.Equals("1"))
{
newQuestion.setQuizAnswer(answer1);
}
else if (ddlCorrectAns.SelectedValue.Equals("2"))
{
newQuestion.setQuizAnswer(answer2);
}
else if (ddlCorrectAns.SelectedValue.Equals("3"))
{
newQuestion.setQuizAnswer(answer3);
}
else
{
newQuestion.setQuizAnswer(answer4);
}
allQuestions.Add(newQuestion);
QuizDAO quizDAO = new QuizDAO();
QuizAnswerDAO qaDAO = new QuizAnswerDAO();
QuizQuestionDAO qqDAO = new QuizQuestionDAO();
Course_elearnDAO ceDAO = new Course_elearnDAO();
Course_elearn currentCourse = ceDAO.get_course_by_id(Convert.ToInt32(Request.QueryString["id"]));
//create quiz
List <string> part1 = (List <string>)Session["createQuiz1"];
Quiz newQuiz = new Quiz();
newQuiz.setTitle(part1[0]);
newQuiz.setDescription(part1[1]);
newQuiz.setMainCourse(currentCourse);
newQuiz.setPassingGrade(Convert.ToInt32(txtNumCorrectAns.Text));
newQuiz.setStatus("active");
if (ddlRandomize.SelectedValue.Equals("y"))
{
newQuiz.setRandomOrder("y");
}
else
{
newQuiz.setRandomOrder("n");
}
newQuiz.setTimeLimit(Convert.ToInt32(txtTimeLimit.Text));
if (rdlAttempt.SelectedValue.Equals("unlimited"))
{
newQuiz.setMultipleAttempts("y");
newQuiz.setNumberOfAttempts(0);
}
else
{
newQuiz.setMultipleAttempts("n");
newQuiz.setNumberOfAttempts(Convert.ToInt32(txtNoOfAttempt.Text));
}
newQuiz.setDisplayAnswer(ddlDisplayAnswer.SelectedValue);
int quizID = quizDAO.createQuiz(newQuiz);
//add prerequisites
List <int> prereqIDlist = (List <int>)Session["selectedPrereq"];
foreach (int prereqID in prereqIDlist)
{
quizDAO.insertPrerequisite(quizID, prereqID);
}
//create question and answer
foreach (QuizQuestion question in allQuestions)
{
question.setQuiz(quizDAO.getQuizByID(quizID));
int questionID = qqDAO.createQuizQuestion(question);
QuizQuestion currentQuestion = qqDAO.getQuizQuestionByID(questionID);
List <QuizAnswer> allAnswers = question.getAllAnswers();
foreach (QuizAnswer answer in allAnswers)
{
answer.setQuizQuestion(currentQuestion);
int answerID = qaDAO.createQuizAnswer(answer);
if (question.getQuizAnswer().getAnswer().Equals(answer.getAnswer()))
{
qqDAO.updateCorrectAnswerID(questionID, answerID);
}
}
}
//set audit
User currentUser = (User)Session["currentUser"];
setAudit(currentUser, "quiz", "create", quizID.ToString(), "quiz title: " + newQuiz.getTitle());
Response.Redirect($"quizSummary.aspx?id={quizID}");
}
}
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);
}
}
}
}
}
