Esempio n. 1
0
 public FacebookQuerier(string accessToken)
 {
     mFacebookClient = new FacebookClient(accessToken);
      mFacebookDataContext = new FacebookDataContext(mFacebookClient);
 }
Esempio n. 2
0
        private void FqlToLinqSample()
        {
            var fb = new FacebookClient(GetAccessToken());
            var db = new FacebookDataContext(fb);

            var useQuerySyntax = true;
            var useMethodSyntax = false;

            if (useQuerySyntax)
            {

                /*

                var albumQuery = from album in db.Album where album.Aid == new AlbumId("20531316728_324257") select album;
                var albumResult = albumQuery.ToArray();

                var applicationQuery = from application in db.Application where
                                           application.AppId == new AppId("231464590266507") // servicestack-dev
                                           || application.Namespace == "skype" // Skype
                                           || application.Namespace == "inthemafia" // Mafia Wars
                                           || application.Namespace == "m_calendar" // MyCalendar
                                       select application;

                var applicationResult = applicationQuery.ToArray();

                var apprequestQuery = from apprequest in db.Apprequest
                                      where apprequest.RecipientUid == db.Me
                                         && apprequest.AppId == new AppId("231464590266507")
                                      select apprequest;
                var apprequestResult = apprequestQuery.ToArray();

                var checkinQuery = from checkin in db.Checkin where checkin.AuthorUid == db.Me  select checkin;
                var checkinResult = checkinQuery.ToArray();

                var albumObjectIdQuery = from album in db.Album where album.Aid == new AlbumId("20531316728_324257") select album.ObjectId;
                var commentQuery = from comment in db.Comment where albumObjectIdQuery.Contains(comment.ObjectId) select comment;
                var commentResult = commentQuery.ToArray();

                var connectionQuery = from connection in db.Connection where connection.SourceId == db.Me select connection;
                var connectionResult = connectionQuery.ToArray();

                var cookiesQuery = from cookies in db.Cookies where cookies.Uid == db.Me select cookies;
                var cookiesResult = cookiesQuery.ToArray();

                var developerQuery = from developer in db.Developer where developer.DeveloperId == db.Me select developer;
                var developerResult = developerQuery.ToArray();

                var eventQuery = from event_ in db.Event where event_.Eid == new EventId("209798352393506") select event_;
                var eventResult = eventQuery.ToArray();

                var commentsQuery = from comments in db.Comment where comments.ObjectId == new ObjectId("483854529708") select comments;
                var commentsResult = commentsQuery.ToArray();

                var threadQuery = from thread in db.Thread where thread.FolderId == FolderId.Inbox select thread.ThreadId;
                var messageQuery = from message in db.Message where threadQuery.Contains(message.ThreadId) select message;
                var messageResult = messageQuery.ToArray();

                DateTime yesterday = DateTime.Today.AddDays(-1);
                var threadQuery2 = from thread in db.Thread where thread.FolderId == FolderId.Inbox select thread.ThreadId;
                var messageQuery2 = from message in db.Message
                                    where threadQuery2.Contains(message.ThreadId)
                                        && message.CreatedTime > yesterday
                                    select message;
                var messageResult2 = messageQuery2.ToArray();

                var notificationQuery = from notification in db.Notification where notification.RecipientId == db.Me select notification;
                var notificationResult = notificationQuery.ToArray();

                var groupQuery = from group_ in db.Group where group_.Gid == new GroupId("146797922030397") select group_;
                var groupResult = groupQuery.ToArray();

                var streamQuery = from stream in db.Stream where stream.SourceId == db.Me select stream;
                var streamResult = streamQuery.ToArray();

                //*/

                // substr sample
                //var friendIds = from friend in db.Friend where friend.Uid1 == db.Me select friend.Uid2;
                //var friendDetails = (from user in db.User where friendIds.Contains(user.Uid) && user.Name.Substring(0, 1) == "a" select new { Uid = user.Uid, Name = user.Name, Picture = user.PicSmall });

                // strlen sample
                //var friendIds = from friend in db.Friend where friend.Uid1 == db.Me select friend.Uid2;
                //var friendDetails = (from user in db.User where friendIds.Contains(user.Uid) && user.Name.Length == 14 select new { Uid = user.Uid, Name = user.Name, Picture = user.PicSmall });

                // strpos sample
                //var friendIds = from friend in db.Friend where friend.Uid1 == db.Me select friend.Uid2;
                //var friendDetails = (from user in db.User where friendIds.Contains(user.Uid) && user.Name.IndexOf("as") > 0 select new { Uid = user.Uid, Name = user.Name, Picture = user.PicSmall });

                var friendIds = from friend in db.Friend where friend.Uid1 == db.Me select friend.Uid2;
                var friendDetails = (from user in db.User where friendIds.Contains(user.Uid) select new { Uid = user.Uid, Name = user.Name, Picture = user.PicSmall });
                listFriends.DataSource = friendDetails.ToArray();
                DataBind();
            }
            else if (useMethodSyntax)
            {
                var friendIds2 = db.Friend.Where(t => t.Uid1 == db.Me).Select(t => t.Uid2);
                var friendDetails2 = db.User.Where(t => friendIds2.Contains(t.Uid)).Select(t => new { Name = t.Name, Picture = t.PicSmall }).Take(5);
                listFriends.DataSource = friendDetails2.ToArray();
                DataBind();
            }
        }
Esempio n. 3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            GridView1.PageIndexChanging += GridView1_PageIndexChanging;

            string prefix = ConfigurationManager.AppSettings["mode"];
            string mRedirectUri = ConfigurationManager.AppSettings[prefix + "_redirectUri"];
            string clientId = ConfigurationManager.AppSettings[prefix + "_clientId"];
            string clientSecret = ConfigurationManager.AppSettings[prefix + "_clientSecret"];

            FacebookAuthentication auth = new FacebookAuthentication(clientId, clientSecret, mRedirectUri);
            string accessToken = auth.Login(Request.Params["code"]);

            var fb = new FacebookClient(accessToken);
            db = new FacebookDataContext(fb);
            if (!IsPostBack)
            {
                QueryFriendList();
                QueryLinks();
            }
        }