private SyncResponse SelExercises(SyncRequest request) { clr_exercises submitData = JsonHelper.DecodeJson <clr_exercises>(request.Data); using (var db = new fz_wisdomcampusEntities()) { List <clr_exercises> list = db.clr_exercises.Where(e => e.UserID == submitData.UserID).ToList(); return(SyncResponse.GetResponse(request, list)); } }
private SyncResponse InsertExercises(SyncRequest request) { clr_exercises submitData = JsonHelper.DecodeJson <clr_exercises>(request.Data); using (var db = new fz_wisdomcampusEntities()) { db.clr_exercises.Add(submitData); db.SaveChanges(); return(SyncResponse.GetResponse(request, true)); } }
private SyncResponse UpdateExercises(SyncRequest request) { clr_exercises submitData = JsonHelper.DecodeJson <clr_exercises>(request.Data); using (var db = new fz_wisdomcampusEntities()) { List <clr_exercises> list = db.clr_exercises.Where(e => e.UserID == submitData.UserID).ToList(); if (list != null) { foreach (var item in list) { item.Resources = submitData.Resources; } db.SaveChanges(); return(SyncResponse.GetResponse(request, true)); } else { return(SyncResponse.GetResponse(request, false)); } } }