} //for Chosen Plugin DDL public List <string> AddEditActivity(int memberId, int activityID, int activityStatusID, bool?isParticipated, DateTime activityDate, string activityNote, string userId) { Error error = new Error(); error.errCode = ErrorDetail.Success; List <string> errs = new List <string>(); List <string> warnings = new List <string>(); string warning = String.Empty; using (LRCEntities context = new LRCEntities()) { try { var existingActivity = context.tb_MemberActivity.Where(t => t.MemberID == memberId && t.ActivityID == activityID).FirstOrDefault(); if (existingActivity == null) // Add new activity for selected Member { tb_MemberActivity memberActivity = new tb_MemberActivity { ActivityID = activityID, MemberID = memberId, ActivityStatusID = activityStatusID, Participated = isParticipated }; context.tb_MemberActivity.Add(memberActivity); } else //Edit existing activity for selected Member { existingActivity.ActivityStatusID = activityStatusID; existingActivity.Participated = isParticipated; } tb_Activity activity = context.tb_Activity.Find(activityID); // Change if Activity was edited (activityDate or ActivityNote fields) if (activity.ActivityDate != activityDate || activity.ActivityNote.ToUpper() != activityNote.ToUpper()) { activity.ModifiedBy = userId; activity.ModifiedDateTime = DateTime.UtcNow; activity.ActivityDate = activityDate; activity.ActivityNote = activityNote; } context.SaveChanges(); } catch (DbEntityValidationException ex) { error.errCode = ErrorDetail.DataImportError; error.errMsg = ErrorDetail.GetMsg(error.errCode); foreach (DbEntityValidationResult validationError in ex.EntityValidationErrors) { error.errMsg += ". Object: " + validationError.Entry.Entity.ToString(); foreach (DbValidationError err in validationError.ValidationErrors) { error.errMsg += ". " + err.ErrorMessage; } } errs.Add("Error #" + error.errCode.ToString() + "!" + error.errMsg); return(errs); } } return(errs); }
public ActionResult DeleteActivity(int?ActivityID, int?MemberId, int?CollegeID) { Error error = new Error(); error.errCode = ErrorDetail.Success; if (ActivityID == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (LRCEntities context = new LRCEntities()) { try { tb_MemberActivity activity = context.tb_MemberActivity.Find(ActivityID); if (activity == null) { return(HttpNotFound()); } context.tb_MemberActivity.Remove(activity); context.SaveChanges(); } catch (DbEntityValidationException ex) { error.errCode = ErrorDetail.DataImportError; error.errMsg = ErrorDetail.GetMsg(error.errCode); foreach (DbEntityValidationResult validationError in ex.EntityValidationErrors) { error.errMsg += ". Object: " + validationError.Entry.Entity.ToString(); foreach (DbValidationError err in validationError.ValidationErrors) { error.errMsg += ". " + err.ErrorMessage; } } } } return(RedirectToAction("AddPersonAssessmentActivity", new { @id = MemberId, CollegeID = CollegeID })); }