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