xp-dev.com Git - CPE_learningsite/blob - CPE/CPE.App/CPE.App.Api/Helpers/TinCanHelper.cs

   1 using CPE.App.Api.Models;
   2 using CPE.App.Web.Code;
   3 using System;
   4 using System.Collections.Generic;
   5 using System.Linq;
   6 using System.Web;
   7 using Newtonsoft.Json;
   8
   9 namespace CPE.App.Api.Helpers
  10 {
  11     public class TinCanHelper
  12     {
  13         public static bool HandleStatement(TinCanStatementModel statement)
  14         {
  15             // statement.Verb.Id=http://adlnet.gov/expapi/verbs/answered
  16             // statement.Verb.Id=http://adlnet.gov/expapi/verbs/experienced
  17             var dtNow = DateTime.UtcNow.ToString("yyyyMMdd_HHmmss");
  18             if (statement.Verb.Id.IndexOf("passed")>-1)
  19             {
  20                 Utilities.LogWrapper.Info("[TinCanHelper][HandleStatement] {0} statement.Verb.Id={1}. statement={2}", dtNow, statement.Verb.Id, JsonConvert.SerializeObject(statement));
  21
  22                 //parse statement to db variables
  23                 var email = statement.Actor.Mbox.Substring(7);
  24                 var fname = statement.Actor.Name.Substring(0, statement.Actor.Name.IndexOf(" ") + 1);
  25                 var lname = statement.Actor.Name.Substring(statement.Actor.Name.LastIndexOf(" ") + 1);
  26                 var courseUrl = statement.Object.Id.Substring(statement.Object.Id.LastIndexOf("/") + 1);
  27                 var courseName = statement.Object.Definition.Name.EnUs;
  28                 bool done;
  29
  30                 //cpe has test data with multiple, currently valid purchases of the same course for one user, which causes problems but is not a real-world problem.
  31                 //elucidat tracks all users globally by email address so a tincan statement won't identify a specific purchase here
  32                 //unless we create unique email addy (e.g. email+ticket@mail.com) when originally logging them in to content
  33                 var course = BaseController.Database.PurchasedCourses.FirstOrDefault(c =>
  34                     c.Email == email && c.ContentUrl == courseUrl && c.CertificateDate == null);
  35                 if (course == null)
  36                 {
  37                     Utilities.LogWrapper.Info("[TinCanHelper][HandleStatement] {0} no action 1, cert already earned email={1} courseName={2}", dtNow, email, courseName);
  38                     //no action, cert already earned
  39                     //try
  40                     //{
  41                     //    course = BaseController.Database.PurchasedCourses.FirstOrDefault(c => c.Email == email && c.ContentUrl == courseUrl && c.CertificateDate!=null);
  42                     //    if (course == null)
  43                     //    {
  44                     //        Utilities.LogWrapper.Info("[TinCanHelper][HandleStatement] {0} no action, course == null, select courseName={1} from db with CertificateDate.", dtNow, courseName);
  45                     //    }
  46
  47                     //    Utilities.LogWrapper.Info("[TinCanHelper][HandleStatement] {0} no action, select courseName={1} from db with CertificateDate. course={2}", dtNow,  courseName, JsonConvert.SerializeObject(course));
  48
  49                     //    done = SendEmailHelper.SendCertificateEmail(course);
  50
  51                     //    Utilities.LogWrapper.Info("[TinCanHelper][HandleStatement] {0} no action, send courseName={1} from db to email={2} successfully", dtNow, courseName, email);
  52                     //}
  53                     //catch (Exception exception)
  54                     //{
  55                     //    var innerException = "";
  56                     //    if (exception.InnerException != null) innerException = exception.InnerException.ToString();
  57                     //    Utilities.LogWrapper.Info("[TinCanHelper][HandleStatement] {0} email={1} courseName={2} exception={3}", dtNow, email, courseName, exception.ToString()+ innerException);
  58                     //}
  59
  60                     //Utilities.LogWrapper.Info("[TinCanHelper][HandleStatement] {0} cert sent email={1} courseName={2}", dtNow, email, courseName);
  61
  62                     return true;
  63                 }
  64
  65                 course.CertificateDate = Convert.ToDateTime(statement.Timestamp);
  66                 try
  67                 {
  68                     BaseController.Database.SubmitChanges();
  69                 }
  70                 catch (Exception exception)
  71                 {
  72                     Utilities.LogWrapper.Error("[TinCanHelper][HandleStatement] {0} email={1} courseName={2} exception={3}", dtNow, email, courseName, exception.ToString());
  73                 }
  74
  75                 done = SendEmailHelper.SendCertificateEmail(course);
  76
  77                 Utilities.LogWrapper.Info("[TinCanHelper][HandleStatement] {0} cert sent email={1} courseName={2}", dtNow, email, courseName);
  78
  79                 //umm why am i not returning done here?
  80                 return true;
  81             }
  82
  83
  84             if (statement.Verb.Id.IndexOf("failed") > -1)
  85             {
  86                 Utilities.LogWrapper.Info("[TinCanHelper][HandleStatement] {0} statement.Verb.Id={1}. statement={2}", dtNow, statement.Verb.Id, JsonConvert.SerializeObject(statement));
  87
  88                 //parse statement to db variables
  89                 var email = statement.Actor.Mbox.Substring(7);
  90                 var fname = statement.Actor.Name.Substring(0, statement.Actor.Name.IndexOf(" ") + 1);
  91                 var lname = statement.Actor.Name.Substring(statement.Actor.Name.LastIndexOf(" ") + 1);
  92                 var courseUrl = statement.Object.Id.Substring(statement.Object.Id.LastIndexOf("/") + 1);
  93                 var courseName = statement.Object.Definition.Name.EnUs;
  94
  95                 //only logging failed attempts prior to earning a cert
  96                 //selecting first record for a user for a course that is not expired. To allow for if a user fails to earn a cert within a year and re-purchases course
  97
  98                 var course = BaseController.Database.PurchasedCourses.FirstOrDefault(c => c.Email == email && c.ContentUrl == courseUrl && c.CertificateDate == null && ((c.PurchaseDate).AddYears(1)) > DateTime.UtcNow);
  99                 if (course == null)
 100                 {
 101                     //no action, cert already earned
 102                     return true;
 103                 }
 104
 105                 Utilities.LogWrapper.Info("[TinCanHelper][HandleStatement] {0} course.Ticket={1}", dtNow, course.Ticket);
 106
 107                 if (!course.FailedAttempts.HasValue)
 108                 {
 109                     course.FailedAttempts = 0;
 110                 }
 111                 course.FailedAttempts++;
 112                 try
 113                 {
 114                     BaseController.Database.SubmitChanges();
 115                 }
 116                 catch (Exception exception)
 117                 {
 118                     Utilities.LogWrapper.Error("[TinCanHelper][HandleStatement] {0} email={1} courseName={2} exception={3}", dtNow, email, courseName, exception.ToString());
 119                 }
 120
 121                 Utilities.LogWrapper.Info("[TinCanHelper][HandleStatement] {0} failure recorded email={1} courseName={2}", dtNow, email, courseName);
 122
 123                 return true;
 124             }
 125             return true;
 126         }
 127     }
 128 }