protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { TrainingID = Convert.ToInt32 (Request.QueryString ["TrainingID"]); qPtl_User user = new qPtl_User(Convert.ToInt32(Context.Items["UserID"])); lblName.Text = user.FirstName + " " + user.LastName; string signature = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["Learning_certSignature1"]) + "<br>" + Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["Learning_certSignature2"]); lblSignature.Text = signature; imgCertBgImage.ImageUrl = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["Resources_URL"]) + "/learning/certs/" + Context.Items["ScopeID"] + "/cert_bg.png"; qLrn_UserTraining_View u_training = new qLrn_UserTraining_View(user.UserID, TrainingID); if (u_training != null) { lblTrainingTitle.Text = u_training.Title; lblCompletionDate.Text = "Completed: " + String.Format("{0:M/d/yyyy}", u_training.Completed); if (u_training.EstMinutesToComplete > 0) { float num_hours = u_training.EstMinutesToComplete / 60; lblCompletionHours.Text = " for a total of " + num_hours + " contact hours"; } } else { lblTrainingTitle.Text = "Training title not available"; lblCompletionDate.Text = "Training completion date not available"; } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { profile_id = Convert.ToInt32(Request.QueryString["userID"]); qPtl_User profile = new qPtl_User(profile_id); username = profile.UserName; string curr_tab = string.Empty; curr_tab = Request.QueryString["currTab"]; lit1Class.Text = ""; lit2Class.Text = ""; lit3Class.Text = ""; lit4Class.Text = ""; lit5Class.Text = ""; litTab1Class.Text = "class=\"tab-pane\""; litTab2Class.Text = "class=\"tab-pane\""; litTab3Class.Text = "class=\"tab-pane\""; litTab4Class.Text = "class=\"tab-pane\""; litTab5Class.Text = "class=\"tab-pane\""; if (curr_tab == "overview") { lit1Class.Text = "class='active'"; litTab1Class.Text = "class=\"tab-pane active\""; if (!String.IsNullOrEmpty(Request.QueryString["message"])) lblTab1Message.Text = " *** " + Request.QueryString["message"] + "***"; } else if (curr_tab == "trainings") { lit2Class.Text = "class='active'"; litTab2Class.Text = "class=\"tab-pane active\""; if (!String.IsNullOrEmpty(Request.QueryString["message"])) lblTab2Message.Text = " *** " + Request.QueryString["message"] + "***"; } else if (curr_tab == "assessments") { lit3Class.Text = "class='active'"; litTab3Class.Text = "class=\"tab-pane active\""; if (!String.IsNullOrEmpty(Request.QueryString["message"])) lblTab3Message.Text = " *** " + Request.QueryString["message"] + "***"; } else if (curr_tab == "certificates") { lit4Class.Text = "class='active'"; litTab4Class.Text = "class=\"tab-pane active\""; if (!String.IsNullOrEmpty(Request.QueryString["message"])) lblTab4Message.Text = " *** " + Request.QueryString["message"] + "***"; } else if (curr_tab == "tools") { lit5Class.Text = "class='active'"; litTab5Class.Text = "class=\"tab-pane active\""; if (!String.IsNullOrEmpty(Request.QueryString["message"])) lblTab5Message.Text = " *** " + Request.QueryString["message"] + "***"; } else { lit1Class.Text = "class='active'"; litTab1Class.Text = "class=\"tab-pane active\""; } // tab 2 - assigned trainings var u_trainings = qLrn_UserTraining_View.GetUserTrainings(profile_id); string u_training_html = string.Empty; if (u_trainings != null) { foreach (var t in u_trainings) { u_training_html += "<strong>" + t.Title + "</strong><br>Status: " + t.Status + "<br><br>"; } litUserTrainingList.Text = u_training_html; } else litUserTrainingList.Text = "No trainings assigned"; // tab 3 - assessments userAssessments.SelectCommand = "SELECT * FROM qLrn_UserAssessments_View WHERE UserID = " + profile_id + " AND Available = 'Yes' AND MarkAsDelete = 0 AND Created > '" + System.Configuration.ConfigurationManager.AppSettings["Solution_StartDate"] + "' ORDER BY Created DESC"; startDate = null; endDate = null; // tab 4 - certificates var certificates = qLrn_UserTrainingCertificates.GetUserTrainingCertificates(profile_id); if (certificates != null) { string cert_html = string.Empty; foreach (var c in certificates) { if (c.UserTrainingCertificateID > 0) { qLrn_UserTraining_View training = new qLrn_UserTraining_View(c.UserTrainingID); cert_html += "<li><i class=\"icon-download-alt\"></i> <a href=\"/user_data/" + profile.UserName + "/" + c.FileName + "\"><strong>" + training.Title + "</strong></a> uploaded at: " + c.Created + "</li>"; } } if (!String.IsNullOrEmpty(cert_html)) litCertificates.Text = cert_html; else litCertificates.Text = "No Certificates."; } else { litCertificates.Text = "No Certificates."; } // tab 5 - tools // TOOL: Add Trainings string sqlCode = string.Empty; qDbs_SQLcode sql = new qDbs_SQLcode(); q_Helper helper = new q_Helper(); // get roles sqlCode = "SELECT TrainingID, Title FROM qLrn_Trainings WHERE Available = 'Yes' ORDER BY TrainingID"; DataTable dtTrainings; using (dtTrainings = sql.GetDataTable(sqlCode)) { cblTrainings.DataSource = dtTrainings; cblTrainings.DataValueField = "TrainingID"; cblTrainings.DataTextField = "Title"; cblTrainings.DataBind(); } // mark current trainings sqlCode = "SELECT TrainingID FROM qLrn_UserTrainings WHERE UserID = " + Request.QueryString["userID"]; SqlDataReader rReader; int i = 0; using (rReader = sql.GetDataReader(sqlCode)) { while (rReader.Read()) { ListItem currentCheckBox = cblTrainings.Items.FindByValue(rReader["TrainingID"].ToString()); if (currentCheckBox != null) { currentCheckBox.Selected = true; } i++; } } litNumTrainings.Text = "Member is enrolled in <strong>" + i + " trainings</strong>"; // TOOL: Reset/Delete Trainings plhTrainings.Visible = false; plhResetOptions.Visible = false; btnProcessTrainings.Visible = false; dpkStartDate.SelectedDate = DateTime.Now.AddDays(-1); txtDaysAvailable.Text = "4000"; var u_assessments = qLrn_UserAssessment.GetUserAssessments(profile_id, ""); int num_assessments = 0; if (u_assessments != null) num_assessments = u_assessments.Count; litNumAssessments.Text = "Member has taken <strong>" + num_assessments + " assessments</strong>"; } }