public int SaveCategory(string categoryName)
{
var category = new model.Category
{
name = categoryName,
date = DateTime.Now
};
_entityModel.Categories.Add(category);
_entityModel.SaveChanges();
var result = category.categoryId;
return(result);
}
public int SaveChannel(string channelName, string source_Name)
{
try
{
var channel = new model.Channel
{
categoryId = 0,
src_Name = source_Name,
name = channelName,
date = DateTime.Now,
};
_entityModel.Channels.Add(channel);
_entityModel.SaveChanges();
var result = channel.channelId;
return(result);
}
catch (Exception exception)
{
throw new TwitterApplicationExceptions(TwitterServiceExceptions.FailedConnectionToDb);
}
}
public void SaveTweets(int id, IEnumerable <TwitterStatus> tweets)
{
try
{
_entityModel.Tweets.AddRange(
tweets.Select(tweet => new model.Tweet
{
channelId = id,
text = tweet.Text,
date_time = tweet.CreatedDate,
src_image = tweet.User.ProfileImageUrl,
image = (tweet.Entities.Media.Count != 0) ?
tweet.Entities.Media.First().MediaUrl : "false"
}));
_entityModel.SaveChanges();
}
catch (Exception ex)
{
}
}
