public int AddStudentToClass(int newStudentId, int classId) { Model.StudentClass sc = new Model.StudentClass() { StudentId = newStudentId, ClassId = classId }; string sql = "insert into [StudentClass](StudentId, ClassId) values(@StudentId,@ClassId)"; int ret = db.Execute(sql, sc); return(ret); }
/// <summary> /// /// </summary> /// <param name="s"></param> /// <param name="c"></param> public void RemoveStudentFromClass(Model.NewStudent s, Model.Class c) { try { Model.StudentClass studentClass = this.dbContext.Set <Model.StudentClass>().Single(x => x.ClassId == c.ClassId && x.StudentId == s.NewStudentId); this.dbContext.Set <Model.StudentClass>().Remove(studentClass); this.dbContext.SaveChanges(); } catch (Exception ex) { throw (ex); } }
public void ChangeStudentClass(Model.NewStudent s, Model.Class newClass, Model.Class oldClass) { try { Model.StudentClass studentClass = this.dbContext.Set <Model.StudentClass>().Single(x => x.ClassId == oldClass.ClassId && x.StudentId == s.NewStudentId); studentClass.ClassId = newClass.ClassId; this.dbContext.SaveChanges(); } catch (Exception ex) { throw (ex); } }
/// <summary> /// /// </summary> /// <param name="s"></param> /// <param name="c"></param> public void AddStudentToClass(Model.NewStudent s, Model.Class c) { Model.StudentClass studentClass = new Model.StudentClass(); studentClass.ClassId = c.ClassId; studentClass.StudentId = s.NewStudentId; try { this.dbContext.Set <Model.StudentClass>().Add(studentClass); this.dbContext.SaveChanges(); } catch (Exception ex) { throw(ex); } }