public ActionResult DeleteConfirmed(int id)
        {
            courseCategory courseCategory = db.courseCategories.Find(id);

            db.courseCategories.Remove(courseCategory);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "courseCategoryId,courseCategory1")] courseCategory courseCategory)
 {
     if (ModelState.IsValid)
     {
         db.Entry(courseCategory).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(courseCategory));
 }
        public ActionResult Create([Bind(Include = "courseCategoryId,courseCategory1")] courseCategory courseCategory)
        {
            if (ModelState.IsValid)
            {
                db.courseCategories.Add(courseCategory);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(courseCategory));
        }
示例#4
0
        private static void GetCourseCategory()
        {
            Debug.WriteLine("Starting WebScrape");
            var htmldocument       = DocumentURLReturn(baseURL);
            var courseCategoryHtml = htmldocument.DocumentNode.Descendants("div")
                                     .Where(node => node.GetAttributeValue("class", "")
                                            .Equals("toc")).ToList();
            var courseCategoryList = courseCategoryHtml[0].Descendants("a").ToList();

            using (MyDbContext context = new MyDbContext())
            {
                //Remove All subjectMapping
                var mall = from c in context.majors select c;
                context.majors.RemoveRange(mall);
                var dall = from c in context.majorSubjects select c;
                context.majorSubjects.RemoveRange(dall);
                context.SaveChanges();

                //Remove All courses
                var all = from c in context.CourseLists select c;
                context.CourseLists.RemoveRange(all);
                context.SaveChanges();

                //Remove All Course Categories
                var ball = from c in context.courseCategories select c;
                context.courseCategories.RemoveRange(ball);
                context.SaveChanges();


                foreach (var courseCategory in courseCategoryList)
                {
                    //Course Category
                    string categoryName = courseCategory.InnerText;
                    //link to undergraduate course information
                    string categoryUndergradURL = baseURL + courseCategory.GetAttributeValue("href", "").Replace("index.html", "ug/index.html");
                    //Write to debug
                    fullCouseCategoryList.Add(new string[2] {
                        categoryName, categoryUndergradURL
                    });
                    //Debug.WriteLine(categoryName);
                    //Debug.WriteLine(categoryUndergradURL);

                    //write to database
                    courseCategory category = new courseCategory {
                        courseCategory1 = categoryName
                    };
                    context.courseCategories.Add(category);
                }
                context.SaveChanges();
            }
        }
        // GET: Category/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            courseCategory courseCategory = db.courseCategories.Find(id);

            if (courseCategory == null)
            {
                return(HttpNotFound());
            }
            return(View(courseCategory));
        }
示例#6
0
        private static void WebScrapeCourses(string categoryname, string categoryURL)
        {
            //Debug.WriteLine("Function 2 " + categoryname + " " + categoryURL);
            var htmldocument   = DocumentURLReturn(categoryURL);
            var courseListHTML = htmldocument.DocumentNode.SelectNodes("/ html / body / div[4] / div[1] / div[2] / div / div / div / div[1]");
            var courseList     = courseListHTML[0].Descendants("tr").ToList();

            //if (categoryname == "UTS: Communication") {
            //    Debug.WriteLine("");
            //}

            using (MyDbContext context = new MyDbContext())
            {
                foreach (var course in courseList)
                {
                    //Course Number
                    string courseNumbers = course.FirstChild.InnerText;
                    //Course Name
                    string coursesName = course.LastChild.InnerText;
                    //Course URL
                    string courseURL = course.FirstChild.FirstChild.GetAttributeValue("href", "");
                    //Write to debug
                    Debug.WriteLine("Category: " + categoryname + " Course Number: " + courseNumbers + " Course Name: " + coursesName + " Course URL: " + courseURL);
                    fullCourseList.Add(new string[4] {
                        categoryname, courseNumbers, coursesName, courseURL
                    });

                    //write to database
                    courseCategory category = context.courseCategories.FirstOrDefault(c => c.courseCategory1 == categoryname);
                    //context.CourseLists.Add(new CourseList { courseName = coursesName, courseCategory = category, courseNumber = courseNumbers });
                    category.CourseLists.Add(new CourseList {
                        courseName = coursesName, courseNumber = courseNumbers
                    });

                    Debug.WriteLine("");
                }
                context.SaveChanges();
            }
        }