protected void Page_Load(object sender, EventArgs e) { int? eventType = Utilities.TryToParseAsInt(Request.QueryString["et"]); //event type key int? rowId = Utilities.TryToParseAsInt(Request.QueryString["rowId"]); //row ID key bool?courseStarted = Utilities.TryToParseAsBool(Request.QueryString["st"]); //course started key if (eventType != null && rowId != null) { //load event data lms_Entities db = new ClientDBEntities(); RBDateType.Enabled = RBScoreType.Enabled = false; if (eventType == (int)UsageEventType.SCORE) { //it's a SCORE RBScoreType.Checked = true; RBDateType.Checked = false; Courses_Scores cs = db.Courses_Scores.Where(c => c.rowId == rowId).FirstOrDefault(); TxtScore.Text = cs.score.ToString(); TxtTimestamp.Text = cs.dateStamp.ToString(); } else { //it's a STARTED/COMPLETED event RBScoreType.Checked = false; RBDateType.Checked = true; Courses_Usage cu = db.Courses_Usage.Where(c => c.rowId == rowId).FirstOrDefault(); TxtStartedDate.Text = cu.startDate.ToString(); TxtCompletedDate.Text = cu.endDate.ToString(); } } else { // new event: enable some things, not all if (courseStarted == true) { RBDateType.Enabled = false; RBDateType.Checked = false; RBScoreType.Checked = true; } else { RBScoreType.Enabled = false; RBScoreType.Checked = false; RBDateType.Checked = true; } } }
public static string DeleteEvent(int rowId, UsageEventType eventType) { try { lms_Entities db = new ClientDBEntities(); if (eventType == UsageEventType.SCORE) { Courses_Scores cs = db.Courses_Scores.Where(c => c.rowId == rowId).FirstOrDefault(); db.Courses_Scores.Remove(cs); } else { Courses_Usage cu = db.Courses_Usage.Where(c => c.rowId == rowId).FirstOrDefault(); db.Courses_Usage.Remove(cu); } db.SaveChanges(); return(JsonResponse.NoError); } catch (Exception ex) { return(JsonResponse.Error(ex)); } }
public static string Save(bool isScoreType, decimal?score, string scoreDate, string startDate, string endDate) { string rowIdStr = Utilities.GetQueryString("rowId"); int? rowId = Utilities.TryToParseAsInt(rowIdStr); try { Courses_Scores cs; Courses_Usage cu; lms_Entities db = new ClientDBEntities(); if (rowId == null) { //this is a new event if (isScoreType) { DateTime?dateStamp; if (scoreDate == "") { dateStamp = DateTime.Now; } else { dateStamp = Utilities.TryToParseAsDateTime(scoreDate); if (dateStamp == null) { return(JsonResponse.Error("Incorrect date/time format entered. Please try again.")); } else { cs = new Courses_Scores(); cs.score = Utilities.TryToParseAsDec(score.ToString()); //clean just in case cs.dateStamp = (DateTime)dateStamp; db.Courses_Scores.Add(cs); } } } else { DateTime?startDateTime = Utilities.TryToParseAsDateTime(startDate); if (startDateTime == null) { return(JsonResponse.Error("Incorrect STARTED date/time format entered. Please try again.")); } else { DateTime?endDateTime; if (endDate == "") { endDateTime = null; } else { endDateTime = Utilities.TryToParseAsDateTime(endDate); if (endDateTime == null) { return(JsonResponse.Error("Incorrect COMPLETED date/time format entered. Please try again.")); } } cu = new Courses_Usage(); cu.assignmentId = (int)Utilities.TryToParseAsInt(Utilities.GetQueryString("aId")); cu.courseId = (int)Utilities.TryToParseAsInt(Utilities.GetQueryString("cId")); cu.userId = (int)Utilities.TryToParseAsInt(Utilities.GetQueryString("uId")); cu.startDate = (DateTime)startDateTime; cu.endDate = endDateTime; db.Courses_Usage.Add(cu); } } } else { //this is an update if (isScoreType) { DateTime?dateStamp; if (scoreDate == "") { dateStamp = DateTime.Now; } else { dateStamp = Utilities.TryToParseAsDateTime(scoreDate); if (dateStamp == null) { return(JsonResponse.Error("Incorrect date/time format entered. Please try again.")); } else { cs = db.Courses_Scores.Where(c => c.rowId == rowId).FirstOrDefault(); cs.score = Utilities.TryToParseAsDec(score.ToString()); cs.dateStamp = (DateTime)dateStamp; } } } else { DateTime?startDateTime = Utilities.TryToParseAsDateTime(startDate); if (startDateTime == null) { return(JsonResponse.Error("Incorrect STARTED date/time format entered. Please try again.")); } else { DateTime?endDateTime; if (endDate == "") { endDateTime = null; } else { endDateTime = Utilities.TryToParseAsDateTime(endDate); if (endDateTime == null) { return(JsonResponse.Error("Incorrect COMPLETED date/time format entered. Please try again.")); } } cu = db.Courses_Usage.Where(c => c.rowId == rowId).FirstOrDefault(); cu.assignmentId = (int)Utilities.TryToParseAsInt(Utilities.GetQueryString("aId")); cu.courseId = (int)Utilities.TryToParseAsInt(Utilities.GetQueryString("cId")); cu.userId = (int)Utilities.TryToParseAsInt(Utilities.GetQueryString("uId")); cu.startDate = (DateTime)startDateTime; cu.endDate = endDateTime; } } } db.SaveChanges(); return(JsonResponse.NoError); } catch (Exception ex) { return(JsonResponse.Error(ex)); } }