public void ProcessRequest(HttpContext context) { int success = 0; string isComplete = context.Request.QueryString["isComplete"]; SPA.User user = new SPA.User(); try { if (isComplete == "1") { if (context.User.Identity.Name != null) { user = new SPA.User(context.User.Identity.Name); Action.Write(string.Format("Called DISACAC Handler for IsComplete"), context.User.Identity.Name); } else { Action.Write(string.Format("Called DISACAC Handler for IsComplete"), "User Unknown"); } SPA.TrngRecord trngRecord = new SPA.TrngRecord(1, user.ID); if (trngRecord.ID == 0) { // create a new entry for user trngRecord.UserID = user.ID; trngRecord.CourseID = 1; trngRecord.DateCompleted = DateTime.Now; if (trngRecord.Insert()) { success = 1; } } else { // update entry for user trngRecord.DateCompleted = DateTime.Now; if (trngRecord.Update()) { success = 1; } } } } catch (Exception ex) { SPA.Error.WriteError(ex); } context.Response.ContentType = "text/javascript"; context.Response.Write(success); }
private bool DeleteItem() { bool success = false; try { SPA.TrngRecord item = new SPA.TrngRecord(ItemID); if (item.Delete()) { success = true; ItemID = 0; } else { // display message that item is im use } } catch (Exception ex) { SPA.Error.WriteError(ex); if (ShowDebug) { lblErrorMessage.Text = ex.ToString(); } } return(success); }
protected void SaveTrainingRecord() { lblCompletedError.Visible = false; lblErrorMessage.Text += "SaveTrainingRecord()"; try { bool save = false; TrngRecord item = new SPA.TrngRecord(RecordID); string DateCompleted = ((TextBox)this.dtcCompleted.Controls[0]).Text; lblErrorMessage.Text += DateCompleted.ToString(); if (DateCompleted.Length > 0) { if (Common.IsDate(DateCompleted)) { DateTime newDate = DateTime.Parse(DateCompleted); if (newDate > item.DateCompleted) { if (newDate > DateTime.Now.AddDays(1)) { lblCompletedError.Text = "<br>Completed date must be today or previous date."; } else { // not a future date, so ok save = true; } } else { // older than previously recorded save = true; } } else { lblCompletedError.Text = "<br/>The value of this field must be a valid date."; } lblErrorMessage.Text += save.ToString(); } else { save = true; } if (save) { DateTime completedDate; if (String.IsNullOrWhiteSpace(DateCompleted)) { lblErrorMessage.Text += "null"; completedDate = new DateTime(1900, 1, 1); } else { lblErrorMessage.Text += "not null"; completedDate = Convert.ToDateTime(DateCompleted); } item.DateCompleted = completedDate; item.ModifiedBy = CurrentUser.DisplayName; item.Comment = Common.HtmlEncode(txtComment.Text); item.Update(); OpenTrainingRecord(); } else { lblCompletedError.Visible = true; } } catch (Exception ex) { SPA.Error.WriteError(ex); if (ShowDebug) { lblErrorMessage.Text += ex.ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { int RecordID = 0; SPA.User currentUser = new SPA.User(Context.User.Identity.Name); bool IsTrngAdmin = currentUser.InRole(RoleType.TrngAdmin.ToString()); foreach (string name in Request.QueryString.AllKeys) { string value = Request.QueryString[name].ToString(); if (!string.IsNullOrEmpty(value)) { switch (name.ToLower()) { case "recordid": RecordID = int.Parse(value); break; } } } if (RecordID > 0) { SPA.TrngRecord selectedRecord = new SPA.TrngRecord(RecordID); if (selectedRecord.ID != 0) { // you must be a training administrator to print another users certificate if (selectedRecord.UserID == currentUser.ID || IsTrngAdmin) { SPA.User selectedUser = new SPA.User(selectedRecord.UserID); SPA.TrngCourse selectedCourse = new SPA.TrngCourse(selectedRecord.CourseID); SPA.TrngCategory selectedCategory = new TrngCategory(selectedCourse.TrngCategoryID); lblUserName.Text = selectedUser.DisplayName; lblCourseName.Text = selectedCourse.Name; lblDateCompleted.Text = selectedRecord.DateCompleted.ToLongDateString(); if (selectedCategory.Name.ToLower() == "sap") { imgSAPCertTop.Visible = true; } else { imgCertTop.Visible = true; } } else { contentarea.Visible = false; lblErrorMessage.Text = "You are not authorized to print this user certificate!"; } } else { contentarea.Visible = false; lblErrorMessage.Text = "Training record not found!"; } } else { contentarea.Visible = false; lblErrorMessage.Text = "Training record not found!"; } }