Exemplo n.º 1
0
        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;
        }
Exemplo n.º 2
0
 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;
 }
Exemplo n.º 3
0
 /// <summary>
 /// 用于更改课程信息,这是一个很强的方法,理论上可以更改全部信息。该方法可以覆盖UpdateCourseStatus的功能。
 /// 如果有更相应的方法不推荐使用这个方法
 /// </summary>
 /// <param name="course">更改后的Course的实例</param>
 /// <returns>ture表示成功,false表示失败</returns>
 public static bool UpdateCourse(COURSE course)
 {
     using (CloudEDUEntities ctx = new CloudEDUEntities())
     {
         try
         {
             ctx.Entry(course).State = System.Data.EntityState.Modified;
             ctx.SaveChanges();
         }
         catch (Exception e)
         {
             System.Diagnostics.Debug.WriteLine(e.ToString());
             return false;
         }
     }
     return true;
 }
Exemplo n.º 4
0
 public static bool RemoveCourseFromRecommendation(COURSE course, RECOMMENDATION reco)
 {
     using (CloudEDUEntities ctx = new CloudEDUEntities())
     {
         try
         {
             ctx.RECOMMENDATIONs.Attach(reco);
             ctx.COURSEs.Attach(course);
             reco.COURSEs.Remove(course);
             ctx.SaveChanges();
         }
         catch (Exception e)
         {
             System.Diagnostics.Debug.WriteLine(e.ToString());
             return false;
         }
     }
     return true;
 }
Exemplo n.º 5
0
 public static LESSON[] GetLessonsByCourse(COURSE course)
 {
     LESSON[] lessons = null;
     using (CloudEDUEntities ctx = new CloudEDUEntities())
     {
         var cs = ctx.COURSEs.Include("LESSONs").Where(c => c.ID == course.ID).FirstOrDefault();
         lessons = cs.LESSONs.ToArray();
     }
     return lessons;
 }
Exemplo n.º 6
0
 public static COMMENT[] GetCommentsByCourse(COURSE course)
 {
     COMMENT[] comments = null;
     using (CloudEDUEntities ctx = new CloudEDUEntities())
     {
         comments = ctx.COMMENTs.Where(c => c.COURSE_ID == course.ID).ToArray();
     }
     return comments;
 }
Exemplo n.º 7
0
        public static COURSE[] GetAllPendingCourses()
        {
            COURSE_PENDING[] courses = null;
            using (CloudEDUEntities ctx = new CloudEDUEntities())
            {
                courses = ctx.COURSE_PENDING.ToArray();
            }

            COURSE[] returnCourse=new COURSE[courses.Length];
            for (int i = 0; i < courses.Length; i++)
            {
                returnCourse[i] = ConvertToCourse(courses[i]);
            }
            return returnCourse;
        }