partial void DeleteCourseCancelled(CourseCancelled instance);
 partial void InsertCourseCancelled(CourseCancelled instance);
 partial void UpdateCourseCancelled(CourseCancelled instance);
Exemplo n.º 4
0
 partial void DeleteCourseCancelled(CourseCancelled instance);
Exemplo n.º 5
0
 partial void UpdateCourseCancelled(CourseCancelled instance);
Exemplo n.º 6
0
 partial void InsertCourseCancelled(CourseCancelled instance);
        /// <summary>
        /// This loads cancelled classes from a feed and sends emails to registered students.
        /// </summary>
        public static void LoadStream()
        {
            XElement cancel = XElement.Load(FEED);
            var test = from t in cancel.Descendants("item")
                       select t.Element("title").Value;
            if(!test.FirstOrDefault().Equals("No classes cancelled."))
            {
                IEnumerable<CancelledClass> classes = from c in cancel.Descendants("item")
                                                  select new CancelledClass(c.Element("title").Value,
                                                  c.Element("course").Value,
                                                  c.Element("datecancelled").Value,
                                                  c.Element("teacher").Value, c.Element("notes").Value);
                List<CancelledClass> newCancelled = new List<CancelledClass>();
                bool isNew = true;
                using (TablesDataContext db = new TablesDataContext())
                {
                    IEnumerable<CancelledClass> allCancelled = from c in db.CourseCancelleds
                                                               select new CancelledClass(c.CourseID, c.Title, c.DateCancelled, c.Teacher, c.Notes);
                    string previousCourseID = "";
                    string previousDateCancelled = "";

                    foreach (CancelledClass c in classes)
                    {
                        isNew = true;
                        if (c.CourseID.Equals(previousCourseID) && c.DateCancelled.Equals(previousDateCancelled))
                            isNew = false;
                        else
                            foreach (CancelledClass allC in allCancelled)
                            {
                                if(c.Equals(allC))
                                {
                                    isNew = false;
                                    break;
                                }
                            }
                        if (isNew)
                            newCancelled.Add(c);
                        previousCourseID = c.CourseID;
                        previousDateCancelled = c.DateCancelled;
                    }

                    //Add the new cancelled courses to the database
                    CourseCancelled course;
                    foreach (CancelledClass c in newCancelled)
                    {
                        course = new CourseCancelled();
                        course.CourseID = c.CourseID;
                        course.DateCancelled = c.DateCancelled;
                        course.Teacher = c.Teacher;
                        course.Notes = c.Notes;
                        course.Title = c.Title;
                        db.CourseCancelleds.InsertOnSubmit(course);

                        //Cycle through new cancellations and send emails.
                        var students = from s in db.StudentCourses
                                       where s.CourseID.Equals(c.CourseID)
                                       select s.StudentID;
                        foreach (int studentID in students)
                        {
                            //Select email, send email.
                            var listOfEmails = from s in db.Students
                                        where s.StudentID == studentID
                                        select s.Email;
                            string email = listOfEmails.FirstOrDefault();
                            sendEmail(email, c);
                        }
                    }
                    try
                    {
                        db.SubmitChanges();
                    }
                    catch (ChangeConflictException cce)
                    {
                        foreach (var conflict in db.ChangeConflicts)
                            conflict.Resolve(RefreshMode.KeepCurrentValues);
                        db.SubmitChanges();
                    }
                }//end of using
            }
        }
        /// <summary>
        /// This loads cancelled classes from a feed and sends emails to registered students.
        /// </summary>
        public static void LoadStream()
        {
            XElement cancel = XElement.Load(FEED);
            var      test   = from t in cancel.Descendants("item")
                              select t.Element("title").Value;

            if (!test.FirstOrDefault().Equals("No classes cancelled."))
            {
                IEnumerable <CancelledClass> classes = from c in cancel.Descendants("item")
                                                       select new CancelledClass(c.Element("title").Value,
                                                                                 c.Element("course").Value,
                                                                                 c.Element("datecancelled").Value,
                                                                                 c.Element("teacher").Value, c.Element("notes").Value);
                List <CancelledClass> newCancelled = new List <CancelledClass>();
                bool isNew = true;
                using (TablesDataContext db = new TablesDataContext())
                {
                    IEnumerable <CancelledClass> allCancelled = from c in db.CourseCancelleds
                                                                select new CancelledClass(c.CourseID, c.Title, c.DateCancelled, c.Teacher, c.Notes);
                    string previousCourseID      = "";
                    string previousDateCancelled = "";

                    foreach (CancelledClass c in classes)
                    {
                        isNew = true;
                        if (c.CourseID.Equals(previousCourseID) && c.DateCancelled.Equals(previousDateCancelled))
                        {
                            isNew = false;
                        }
                        else
                        {
                            foreach (CancelledClass allC in allCancelled)
                            {
                                if (c.Equals(allC))
                                {
                                    isNew = false;
                                    break;
                                }
                            }
                        }
                        if (isNew)
                        {
                            newCancelled.Add(c);
                        }
                        previousCourseID      = c.CourseID;
                        previousDateCancelled = c.DateCancelled;
                    }

                    //Add the new cancelled courses to the database
                    CourseCancelled course;
                    foreach (CancelledClass c in newCancelled)
                    {
                        course               = new CourseCancelled();
                        course.CourseID      = c.CourseID;
                        course.DateCancelled = c.DateCancelled;
                        course.Teacher       = c.Teacher;
                        course.Notes         = c.Notes;
                        course.Title         = c.Title;
                        db.CourseCancelleds.InsertOnSubmit(course);

                        //Cycle through new cancellations and send emails.
                        var students = from s in db.StudentCourses
                                       where s.CourseID.Equals(c.CourseID)
                                       select s.StudentID;
                        foreach (int studentID in students)
                        {
                            //Select email, send email.
                            var listOfEmails = from s in db.Students
                                               where s.StudentID == studentID
                                               select s.Email;
                            string email = listOfEmails.FirstOrDefault();
                            sendEmail(email, c);
                        }
                    }
                    try
                    {
                        db.SubmitChanges();
                    }
                    catch (ChangeConflictException cce)
                    {
                        foreach (var conflict in db.ChangeConflicts)
                        {
                            conflict.Resolve(RefreshMode.KeepCurrentValues);
                        }
                        db.SubmitChanges();
                    }
                } //end of using
            }
        }         //end of method