} //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 }));
}
