/// <summary> /// 批量删除用户 /// </summary> /// <param name="users"></param> /// <returns></returns> public static int DeleteUser(List <User> users) { using (var dbContext = new DataModels()) { users.ForEach(u => dbContext.Entry(u).State = System.Data.Entity.EntityState.Deleted); dbContext.Users.RemoveRange(users); return(dbContext.SaveChanges()); } }
//增添: /// <summary> /// 增加新的experiment /// </summary> /// <param name="experiment"></param> /// <returns>0|1</returns> /// 思路:传入experiment拥有courseid,name,type,detail,resource /// createtime,starttime,endtime,deadline....... /// 缺:好像啥都不缺... public static int AddExperiment(Experiment experiment) { using (var dbContext = new DataModels()) { dbContext.Experiments.Add(experiment); dbContext.SaveChanges(); dbContext.Entry(experiment); return(experiment.id); } }
/// <summary> /// 按学生id及课程id删除课程-学生 /// created by jyf /// 2019.7.22 /// </summary> /// <param name="courseId"></param> /// <returns>n</returns> public static int DeleteMapByStudentIdAndCourseId(string studentId, int courseId) { using (var dbContext = new DataModels()) { var vm = dbContext.course_student_mapping.Where(r => r.student_id == studentId).Where(r => r.course_id == courseId); vm.ToList().ForEach(t => dbContext.Entry(t).State = System.Data.Entity.EntityState.Deleted); dbContext.course_student_mapping.RemoveRange(vm); return(dbContext.SaveChanges()); } }
public ActionResult Edit(int id, Customer customer) { try { // TODO: Add update logic here using (DataModels db = new DataModels()) { db.Entry(customer).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }