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>";
}
}
