//Teach Add Exercise public JsonResult AddEx(string idex, string exname, string createdate, string deadline, string idsub) { DateTime?crdate = string.IsNullOrEmpty(createdate) ? (DateTime?)null : DateTime.Parse(createdate); DateTime?dl = string.IsNullOrEmpty(deadline) ? (DateTime?)null : DateTime.Parse(deadline); db.Configuration.ProxyCreationEnabled = false; var query = from e in db.Exercise where e.IDSubject == idsub select e.IDUser; List <string> stuinsub = query.Distinct().ToList(); foreach (var item in stuinsub) { ExerciseSubject add = new ExerciseSubject() { IDExercise = idex, IDUser = item, ExerciseName = exname, CreateDate = crdate, DeadLine = dl, IDSubject = idsub }; db.Exercise.Add(add); db.SaveChanges(); } return(Json(db.SaveChanges(), JsonRequestBehavior.AllowGet)); }
public JsonResult DelEx(string iduser, string idex) { db.Configuration.ProxyCreationEnabled = false; var obj = from ex in db.Exercise where ex.IDUser == iduser && ex.IDExercise == idex select ex; ExerciseSubject csdel = obj.SingleOrDefault(); db.Exercise.Remove(csdel); return(Json(db.SaveChanges(), JsonRequestBehavior.AllowGet)); }
//POST Save Edit public JsonResult SaveEdit(ExerciseSubject ex) { var query = from s in db.Exercise where s.IDUser == ex.IDUser && s.IDExercise == ex.IDExercise && s.IDSubject == ex.IDSubject select s; foreach (ExerciseSubject e in query) { e.IDExercise = ex.IDExercise; e.IDUser = ex.IDUser; e.ExerciseName = ex.ExerciseName; e.Content = ex.Content; e.CreateDate = ex.CreateDate; e.DeadLine = ex.DeadLine; e.IDSubject = ex.IDSubject; e.Mark = ex.Mark; } return(Json(db.SaveChanges(), JsonRequestBehavior.AllowGet)); }
//---------------------------------- Json Result --------------------- //POST Add public JsonResult AddEx(ExerciseSubject ex) { db.Exercise.Add(ex); return(Json(db.SaveChanges(), JsonRequestBehavior.AllowGet)); }