public static void Serialize(IEnumerable <ITweet> tweets, string topic)
{
jsontweets = new List <DAL.Tweet>();
//perform sentiment analysis on the tweet
var analyzer = new SentimentIntensityAnalyzer();
using (var db = new SentimentContext())
{
if (db.Tweets.Count() > 1)
{
db.Tweets.RemoveRange(db.Tweets);
}
foreach (var tweet in tweets)
{
var check = db.Tweets.Where(x => x.TwitterId == tweet.Id).FirstOrDefault();
if (check == null)
{
jsontweets.Add(new DAL.Tweet()
{
TweetId = DateTime.Now.ToString(CultureInfo.CurrentCulture),
//TweetContent = tweet.ToJson(),
TweetHandle = tweet.CreatedBy.ScreenName,
TweetMsg = tweet.FullText,
TwitterId = tweet.Id,
TweetImgLink = tweet.CreatedBy.ProfileImageUrl400x400,
Topic = topic,
TweetSentimentPositiveValue = $"{analyzer.PolarityScores(tweet.FullText).Positive.ToString(CultureInfo.CurrentCulture)}",
TweetSentimentNegativeValue = $"{analyzer.PolarityScores(tweet.FullText).Negative.ToString(CultureInfo.CurrentCulture)}",
TweetSentimentNeutralValue = $"{analyzer.PolarityScores(tweet.FullText).Neutral.ToString(CultureInfo.CurrentCulture)}",
TweetSentimentCompoundValue = $"{analyzer.PolarityScores(tweet.FullText).Compound.ToString(CultureInfo.CurrentCulture)}",
});
}
db.Tweets.AddRange(jsontweets);
}
db.SaveChanges();
//var serializer = new Newtonsoft.Json.JsonSerializer();
//serializer.NullValueHandling = NullValueHandling.Ignore;
//serializer.TypeNameHandling = TypeNameHandling.Auto;
//serializer.Formatting = Formatting.Indented;
//using (var sw = new StreamWriter(@".\tweets.json", true))
//{
// using (JsonWriter jwriter = new JsonTextWriter(sw))
// {
// serializer.Serialize(jwriter, jsontweets, typeof(List<DAL.Tweet>));
// }
//}
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
//implement login to sysytem
using (var db = new SentimentContext())
{
var user = db.Employees.FirstOrDefault(x => x.Email == txtUsername.Text && x.Password == txtPassword.Text);
if (user != null)
{
MessageBox.Show(@"yes");
bunifuTransition1.HideSync(transparentPanel1);
}
else
{
MessageBox.Show(@"Please sign in with correct details");
}
}
}