public static bool AddCourseToRecommendation(COURSE course, RECOMMENDATION reco) { using (CloudEDUEntities ctx = new CloudEDUEntities()) { try { var rc = ctx.RECOMMENDATIONs.Include("COURSEs").Where(r => r.ID == reco.ID).FirstOrDefault(); var cs = ctx.COURSEs.Where(c => c.ID == course.ID).FirstOrDefault(); rc.COURSEs.Add(cs); ctx.Entry(rc).State = System.Data.EntityState.Modified; ctx.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.ToString()); return false; } } return true; }
/// <summary> /// 用于更改Manager的Type /// </summary> /// <param name="manager">需要更改的Manager的实例</param> /// <param name="type">需要改为的Type的ID</param> /// <returns>true表示成功创建,false表示失败</returns> public static bool ChangeManagerManagerType(MANAGER manager, int type) { using (CloudEDUEntities ctx = new CloudEDUEntities()) { try { manager.MNGR_TYPE = type; ctx.Entry(manager).State = System.Data.EntityState.Modified; ctx.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.ToString()); return false; } } return true; //throw new Exception("Not Support Yet"); }
/// <summary> /// 用于更改Permission的一般信息,包括NAME和TYPE /// </summary> /// <param name="permission">更改后的Permission的实例</param> /// <returns>true表示成功创建,false表示失败</returns> public static bool UpdatePermission(PERMISSION permission) { using (CloudEDUEntities ctx = new CloudEDUEntities()) { try { ctx.Entry(permission).State = System.Data.EntityState.Modified; ctx.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.ToString()); return false; } } return true; }
/// <summary> /// 用于更改TYPE的一般信息,包括DESCRIPTION /// </summary> /// <param name="type">更改后的TYPE的实例</param> /// <returns>true表示成功创建,false表示失败</returns> public static bool UpdateManagerType(TYPE type) { using (CloudEDUEntities ctx = new CloudEDUEntities()) { try { ctx.Entry(type).State = System.Data.EntityState.Modified; ctx.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.ToString()); return false; } } return true; }
/// <summary> /// 回收授予某Manager的权限 /// </summary> /// <param name="manager_id">被回收的Manager的ID</param> /// <param name="permission_id">被回收的Permission的ID</param> /// <returns>true表示成功创建,false表示失败</returns> public static bool RevokePermissionFromManager(int manager_id, int permission_id) { using (CloudEDUEntities ctx = new CloudEDUEntities()) { try { var manager = ctx.MANAGERs.Include("PERMISSIONs").Where(mngr => mngr.ID == manager_id).FirstOrDefault<MANAGER>(); var perm = ctx.PERMISSIONs.Where(p => p.ID == permission_id).FirstOrDefault<PERMISSION>(); //System.Diagnostics.Debug.WriteLine(ctx.Entry(manager).State); //System.Diagnostics.Debug.WriteLine(ctx.Entry(perm).State); manager.PERMISSIONs.Remove(perm); ctx.Entry(manager).State = System.Data.EntityState.Modified; ctx.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.ToString()); return false; } } return true; }
private static bool AddResourcesToLesson(RESOURCE[] res, LESSON lesson) { using (CloudEDUEntities ctx = new CloudEDUEntities()) { var ls = ctx.LESSONs.Include("RESOURCEs").Where(l => l.ID == lesson.ID).FirstOrDefault(); foreach (RESOURCE rs in res) ls.RESOURCEs.Add(rs); ctx.Entry(ls).State = System.Data.EntityState.Modified; ctx.SaveChanges(); } return true; }
private static bool AddLessonsToCourse(LESSON[] lessons, COURSE course) { using (CloudEDUEntities ctx = new CloudEDUEntities()) { try { var cs = ctx.COURSEs.Include("LESSONs").Where(c => c.ID == course.ID).FirstOrDefault(); foreach (LESSON ls in lessons) cs.LESSONs.Add(ls); ctx.Entry(cs).State = System.Data.EntityState.Modified; ctx.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.ToString()); return false; } } return true; }
public static bool UpdateRecommendation(RECOMMENDATION reco) { using (CloudEDUEntities ctx = new CloudEDUEntities()) { try { ctx.Entry(reco).State = System.Data.EntityState.Modified; ctx.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.ToString()); return false; } } return true; }
/// <summary> /// 用于更新课程的状态,状态包括Pending、OK、Cancel三项 /// </summary> /// <param name="course_id">课程的ID</param> /// <param name="state">课程的状态,类型为枚举CourseStatus</param> /// <returns>true表示成功,false表示失败</returns> public static bool UpdateCourseStatus(int course_id, CourseStatus state) { using (CloudEDUEntities ctx = new CloudEDUEntities()) { try { COURSE course = ctx.COURSEs.Where(c => c.ID == course_id).FirstOrDefault(); course.COURSE_STATUS = state.ToString(); ctx.Entry(course).State = System.Data.EntityState.Modified; ctx.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.ToString()); return false; } } return true; }
public static bool ToggleNoteSharability(NOTE note) { note.SHARE = !note.SHARE; using (CloudEDUEntities ctx = new CloudEDUEntities()) { try { ctx.Set<NOTE>().Attach(note); ctx.Entry(note).State = System.Data.EntityState.Modified; ctx.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e.ToString()); return false; } } return true; }