/// <summary>
/// Stores Twitter Feed to database
/// </summary>
/// <param name="sTweetsOnlyList"></param>
/// <returns></returns>
public bool SetTweetsOnlyToDB(List <OnlyTweet> sTweetsOnlyList)
{
var sTweetExist = false;
try
{
using (var db = new OnlyTweetContext())
{
// Create and save a new status tweet
//Console.Write("Text for new status tweet : ");
int count = 0;
foreach (var statusTweet in sTweetsOnlyList)
{
if (statusTweet != null)
{
//Console.WriteLine((count + 1) + ". {0}-{1}\n\t{2}", statusTweet.CreatedAt, statusTweet.Text, statusTweet.ScreenName);
// Check if Status Tweets already exists in the database
var query = from t in db.OnlyTweetDB
where t.Text == statusTweet.Text
orderby t.Text
select t;
sTweetExist = false;
//Console.WriteLine("Reading all Status Tweets in the database...");
foreach (var item in query)
{
if (String.Equals(item.Text, statusTweet.Text) && String.Equals(item.CreatedAt, statusTweet.CreatedAt))
{
// Status Tweet already exists, do not duplicate
Console.WriteLine("Status tweet already exists: \n{0}", statusTweet.Text);
sTweetExist = true;
}
}
//Write Status Tweet to database if title doesn't exist in Db
if (!sTweetExist)
{
var sTweet = new OnlyTweet
{
CreatedAt = statusTweet.CreatedAt,
ScreenName = statusTweet.ScreenName,
Text = statusTweet.Text,
StatusID = statusTweet.StatusID
};
db.OnlyTweetDB.Add(sTweet);
db.SaveChanges();
count++;
sTweetExist = true;
}
}
else
{
Console.WriteLine("No status tweets found in the database.");
}
}
//Console.WriteLine("Press any key to exit...");
//Console.ReadKey();
}
}
catch (Exception ex)
{
string innerMessage =
(ex.InnerException != null) ?
ex.InnerException.Message : String.Empty;
Console.WriteLine("{0}\n{1}", ex.Message, innerMessage);
}
return(sTweetExist);
}
//Write tweets to azure database
public static bool SetTweetsOnlyToDB(List<OnlyTweet> sTweetsOnlyList)
{
var sTweetExist = false;
try
{
using (var db = new OnlyTweetContext())
{
// Create and save a new status tweet
//Console.Write("Text for new status tweet : ");
int count = 0;
foreach (var statusTweet in sTweetsOnlyList)
{
if (statusTweet != null)
{
//Console.WriteLine((count + 1) + ". {0}-{1}\n\t{2}", statusTweet.CreatedAt, statusTweet.Text, statusTweet.ScreenName);
// Check if Status Tweets already exists in the database
var query = from t in db.OnlyTweetDB
where t.Text == statusTweet.Text
orderby t.Text
select t;
sTweetExist = false;
//Console.WriteLine("Reading all Status Tweets in the database...");
foreach (var item in query)
{
if (String.Equals(item.Text, statusTweet.Text) && String.Equals(item.CreatedAt, statusTweet.CreatedAt))
{
// Status Tweet already exists, do not duplicate
Console.WriteLine("Status tweet already exists: \n{0}", statusTweet.Text);
sTweetExist = true;
}
}
//Write Status Tweet to database if title doesn't exist in Db
if (!sTweetExist)
{
var sTweet = new OnlyTweet
{
CreatedAt = statusTweet.CreatedAt,
ScreenName = statusTweet.ScreenName,
Text = statusTweet.Text,
StatusID = statusTweet.StatusID
};
db.OnlyTweetDB.Add(sTweet);
db.SaveChanges();
count++;
sTweetExist = true;
}
}
else
{
Console.WriteLine("No status tweets found in the database.");
}
}
//Console.WriteLine("Press any key to exit...");
//Console.ReadKey();
}
}
catch (Exception ex)
{
string innerMessage =
(ex.InnerException != null) ?
ex.InnerException.Message : String.Empty;
Console.WriteLine("{0}\n{1}", ex.Message, innerMessage);
}
return sTweetExist;
}
