コード例 #1
0
ファイル: QuickPost.xaml.cs プロジェクト: JCPyron/WCCF
        public QuickPost()
        {
            InitializeComponent();

            db = new SEMDBDataContext(dbConnectionString);
            //TWITTER: retrieving the db info, setting up the twit classes, and putting them in a list
            try
            {
                Table <Twitter> t = db.GetTable <Twitter>();
                foreach (Twitter item in t)
                {
                    twitter.Add(new Twit(item.AToken, item.ASecret, item.UserId, item.ScreenName.Trim()));
                }
            }
            catch (Exception ex)
            {
                StreamWriter w = new StreamWriter("errorLog.txt");
                w.Write(ex.Message + "\n" + "Twitter" + DateTime.Now + "\n\n");
                w.Close();
                MessageBox.Show("AN ERROR HAS OCCURED WHEN PULLING TWITTER DATA", "Database Error", MessageBoxButton.OK, MessageBoxImage.Error);
            }

            //FACEBOOK: retrieves the db info and adds it to a list
            try
            {
                Table <Face> face = db.GetTable <Face>();
                foreach (Face fb in face)
                {
                    fbClass.Add(new FacebookLogic(fb.AToken));
                }
            }
            catch (Exception ex)
            {
                StreamWriter w = new StreamWriter("errorLog.txt");
                w.Write(ex.Message + "\n" + "Facebook" + DateTime.Now + "\n\n");
                w.Close();
                MessageBox.Show("AN ERROR HAS OCCURED WHEN PULLING FACEBOOK DATA", "Database Error", MessageBoxButton.OK, MessageBoxImage.Error);
            }

            //EMAIL: retrieves the db info
            try
            {
                Table <UMail> m = db.GetTable <UMail>();
                foreach (UMail temp in m)
                {
                    gMail.Add(new GmailClass(temp.UserName, temp.Password));
                }
            }
            catch (Exception ex)
            {
                StreamWriter w = new StreamWriter("errorLog.txt");
                w.Write(ex.Message + "\n" + "Email" + DateTime.Now + "\n\n");
                MessageBox.Show("AN ERROR HAS OCCURED WHEN PULLING EMAIL DATA", "Database Error", MessageBoxButton.OK, MessageBoxImage.Error);
            }

            fillCombo();
        }
コード例 #2
0
        private void grabDBInfo()
        {
            var db = new SEMDBDataContext(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\SMBDB.mdf;Integrated Security=True;Connect Timeout=30");
            // Change this for final DB.
            Table <Email> clients = db.GetTable <Email>();

            foreach (Email address in clients)
            {
                EventAttendee attendee = new EventAttendee();
                attendee.Email = address.EmailAddress;

                atList.Add(attendee);
            }
        }