public List<TwitterEntity> FindAll(ActionState actionState) { List<TwitterEntity> twitterEntityList; MongoServer server = null; MongoDatabase database = null; TwitterEntity entity; twitterEntityList = new List<TwitterEntity>(); entity = null; try { server = MongoServer.Create(ConfigurationManager.AppSettings[CommonConstants.ConnictionString]); database = server.GetDatabase(CommonConstants.DatabaseName); MongoCollection<BsonDocument> tweet = database.GetCollection<BsonDocument>(TwitterConstants.TweetsCollection); foreach (BsonDocument tweetEntity in tweet.FindAll()) { entity = new TwitterEntity(); entity.ID = tweetEntity[TwitterConstants.ID].ToString(); entity.Name = tweetEntity[TwitterConstants.Name].AsString; entity.ScreenName = tweetEntity[TwitterConstants.ScreenName].AsString; entity.CreatedDate = tweetEntity[TwitterConstants.CreatedDate].AsDateTime; entity.Tweet = tweetEntity[TwitterConstants.Tweets].AsString; entity.UserID = tweetEntity[TwitterConstants.UserID].AsString; twitterEntityList.Add(entity); } actionState.SetSuccess(); } catch (Exception ex) { actionState.SetFail(ActionStateEnum.Exception, ex.Message); } finally { server.Disconnect(); server = null; database = null; } return twitterEntityList; }
public void DeleteAll( ActionState actionState) { MongoServer server = null; MongoDatabase database = null; try { server = MongoServer.Create(ConfigurationManager.AppSettings[CommonConstants.ConnictionString]); database = server.GetDatabase(CommonConstants.DatabaseName); MongoCollection<BsonDocument> twiter = database.GetCollection<BsonDocument>(TwitterConstants.TweetsCollection); twiter.RemoveAll(); actionState.SetSuccess(); } catch (Exception ex) { actionState.SetFail(ActionStateEnum.Exception, ex.Message); } finally { server.Disconnect(); server = null; database = null; } }
public void Insert(TwitterEntity entity, ActionState actionState) { MongoServer server = null; MongoDatabase database = null; try { server = MongoServer.Create(ConfigurationManager.AppSettings[CommonConstants.ConnictionString]); database = server.GetDatabase(CommonConstants.DatabaseName); var dataCollection = database.CollectionExists(TwitterConstants.TweetsCollection); if (Convert.ToBoolean(dataCollection) == false) { database.CreateCollection(TwitterConstants.TweetsCollection); MongoCollection<BsonDocument> tweet = database.GetCollection<BsonDocument>(TwitterConstants.TweetsCollection); BsonDocument tweetEntity = new BsonDocument { { TwitterConstants.Name, entity.Name }, { TwitterConstants.ScreenName, entity.ScreenName }, { TwitterConstants.Tweets, entity.Tweet }, { TwitterConstants.UserID, entity.UserID }, { TwitterConstants.CreatedDate, entity.CreatedDate } }; tweet.Insert(tweetEntity); actionState.SetSuccess(); } else { MongoCollection<BsonDocument> tweet = database.GetCollection<BsonDocument>(TwitterConstants.TweetsCollection); BsonDocument tweetEntity = new BsonDocument { { TwitterConstants.Name, entity.Name }, { TwitterConstants.ScreenName, entity.ScreenName }, { TwitterConstants.Tweets, entity.Tweet }, { TwitterConstants.UserID, entity.UserID }, { TwitterConstants.CreatedDate, entity.CreatedDate } }; tweet.Insert(tweetEntity); actionState.SetSuccess(); } } catch (Exception ex) { actionState.SetFail(ActionStateEnum.Exception, ex.Message); } finally { server.Disconnect(); server = null; database = null; } }
/// <summary> /// /// </summary> /// <param name="actionState"></param> /// <returns></returns> public List<TwitterEntity> GetTwitter(ActionState actionState) { List<TwitterEntity> list = new List<TwitterEntity>(); try { var mvcAuthorizer = new MvcAuthorizer { Credentials = new InMemoryCredentials { ConsumerKey = ConfigurationManager.AppSettings[CommonConstants.ConsumerKey], ConsumerSecret = ConfigurationManager.AppSettings[CommonConstants.ConsumerSecret], AccessToken = ConfigurationManager.AppSettings[CommonConstants.AccessToken], OAuthToken = ConfigurationManager.AppSettings[CommonConstants.OAuthToken], ScreenName = ConfigurationManager.AppSettings[CommonConstants.ScreenName] } }; var twitterCtx = new TwitterContext(mvcAuthorizer); var friendTweets = (from tweet in twitterCtx.Status where tweet.Type == StatusType.Home && tweet.Count == Convert.ToInt32(ConfigurationManager.AppSettings[CommonConstants.TwittegGetFieldCount]) select new TwitterEntity { Name = tweet.User.Name, Tweet = tweet.Text, UserID = tweet.User.Identifier.ID, ScreenName = tweet.User.Identifier.ScreenName, CreatedDate = tweet.CreatedAt }); list = friendTweets.ToList<TwitterEntity>(); actionState.SetSuccess(); } catch (Exception ex) { actionState.SetFail(Enums.ActionStateEnum.Exception, ex.Message); } return list; }