public async Task <ActionResult> Posts()
{
//Access Token
var currentClaims = await UserManager.GetClaimsAsync(HttpContext.User.Identity.GetUserId());
var accesstoken = currentClaims.FirstOrDefault(x => x.Type == "urn:tokens:facebook");
if (accesstoken == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.NotFound, "Token not found"));
}
//format a url to retrieve posts or feed data from facebook
string url = string.Format(
"https://graph.facebook.com/me?fields=id,name,feed.limit(1000){{attachments,message,story,created_time}}&access_token=EAAD48iRvOb4BAJ2aEOdAqlmCZAWRPOmSZB7LdOH5x1ZB4xmVHx0u9ckEoS9EQAlzjGhtO2RyB4fEpyYZCX3PABPUP6sQaZC4cIqXmyXhkWGkIk9xTKYJzHZAv78pFSNeO4ydjGP7wA218rYwE9gIiRkfHNIWA6aEpEOYkBvN7GXYhjV5g1XpS4nlOZB9mo0vdgq0ihVOI5Gr6ZBaZC5b1nvj3eJOJRHBdqcDzmRhvqCWQUgZDZD", accesstoken.Value);
HttpWebRequest request = WebRequest.Create(url) as HttpWebRequest;
request.Method = "GET";
using (HttpWebResponse response = await request.GetResponseAsync() as HttpWebResponse)
{
StreamReader reader = new StreamReader(response.GetResponseStream());
string result = await reader.ReadToEndAsync();
dynamic jsonobj = System.Web.Helpers.Json.Decode(result);
Models.SocialMedia.Facebook.posts posts = new Models.SocialMedia.Facebook.posts(jsonobj);
ViewBag.JSON = result;
return(View(posts));
}
}
public async Task <ActionResult> Posts()
{
var currentClaims = await UserManager.GetClaimsAsync(HttpContext.User.Identity.GetUserId());
var accesstoken = currentClaims.FirstOrDefault(x => x.Type == "urn:tokens:facebook");
if (accesstoken == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.NotFound, "Toekn not found"));
}
string url = String.Format("https://graph.facebook.com/me?fields=id,name,feed.limit(100){{message,story,created_time,attachments{{description,type,url,title,media,target}},likes{{id,name}},comments{{id,from,message}}}}&access_token={0}", accesstoken.Value);
HttpWebRequest request = WebRequest.Create(url) as HttpWebRequest;
request.Method = "GET";
using (HttpWebResponse response = await request.GetResponseAsync() as HttpWebResponse)
{
StreamReader reader = new StreamReader(response.GetResponseStream());
string result = await reader.ReadToEndAsync();
dynamic jsonObj = System.Web.Helpers.Json.Decode(result);
Models.SocialMedia.Facebook.posts posts = new Models.SocialMedia.Facebook.posts(jsonObj);
ViewBag.JSON = result;
return(View(posts));
}
}
public async Task <ActionResult> Posts()
{
//Access Token
var currentClaims = await UserManager.GetClaimsAsync(HttpContext.User.Identity.GetUserId());
var accesstoken = currentClaims.FirstOrDefault(x => x.Type == "urn:tokens:facebook");
if (accesstoken == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.NotFound, "Token not found"));
}
//format a url to retrieve posts or feed data from facebook
string url = string.Format(
"https://graph.facebook.com/me?fields=id,name,feed.limit(1000){{attachments,message,story,created_time}}&access_token=EAAYZBjZBHfshEBAKUMJkiZBSeGirVKLlJ8w59N8dbmUHCvd9UXe2B9RGoeDudmrISqQEzAwtvYbRQIrOnmewZAtYXQbvG4qAglPFyylYmZBeSn8lzS8j9z6O7EiUuahbvOhoScs6OEEN1IgZBbFB7xdmvvpdxD83I6GmLoi7WRHuNXeaODZAEb9bEpBsyTRi9vY7AiuJiBwfpnYNfd5ZBFvJLt6cvXIkOWyB5ZCDIly8KOQZDZD", accesstoken.Value);
HttpWebRequest request = WebRequest.Create(url) as HttpWebRequest;
request.Method = "GET";
using (HttpWebResponse response = await request.GetResponseAsync() as HttpWebResponse)
{
StreamReader reader = new StreamReader(response.GetResponseStream());
string result = await reader.ReadToEndAsync();
dynamic jsonobj = System.Web.Helpers.Json.Decode(result);
Models.SocialMedia.Facebook.posts posts = new Models.SocialMedia.Facebook.posts(jsonobj);
ViewBag.JSON = result;
return(View(posts));
}
}
public async Task <ActionResult> Posts()
{
Models.SocialMedia.Facebook.FacebookClient facebookClient = new Models.SocialMedia.Facebook.FacebookClient();
facebookClient.HttpContext = HttpContext;
Models.SocialMedia.Facebook.posts posts = await facebookClient.Posts();
return(View(posts));
}
public async Task <ActionResult> Posts()
{
var currentClaims = await UserManager.GetClaimsAsync(HttpContext.User.Identity.GetUserId());
var accestoken = currentClaims.FirstOrDefault(x => x.Type == "urn:tokens:facebook");
if (accestoken == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.NotFound, "Token not found"));
}
string url = String.Format("https://graph.facebook.com/me?fields=id,name,feed.limit(500){{link,height,width,type,message,story,created_time,id,target,full_picture}}&access_token={0}", accestoken.Value);
HttpWebRequest request = WebRequest.Create(url) as HttpWebRequest;
request.Method = "GET";
using (HttpWebResponse response = await request.GetResponseAsync() as HttpWebResponse)
{
StreamReader reader = new StreamReader(response.GetResponseStream());
string result = await reader.ReadToEndAsync();
dynamic jsonObj = System.Web.Helpers.Json.Decode(result);
Models.SocialMedia.Facebook.posts posts = new Models.SocialMedia.Facebook.posts(jsonObj);
ViewBag.JSON = result;
string json = JsonConvert.SerializeObject(jsonObj);
string path = @"C:\Big Data Analytics\Social data mining Technique\Assignment\fbdata.json";
using (TextWriter tw = new StreamWriter(path))
{
//foreach (var p in json)
// {
tw.WriteLine(json);
// }
}
var connectionString = "mongodb+srv://test:[email protected]/test?retryWrites=true&w=majority";
var client = new MongoClient(connectionString);
var database = client.GetDatabase("SocialMediaR");
string text = System.IO.File.ReadAllText(path);
var collection = database.GetCollection <BsonDocument>("FacebookR");
var aa = new BsonDocument
{
{ "a", "aa" },
{ "b", "bb" }
};
await collection.InsertOneAsync(aa);
client.DropDatabase("SocialMedia" +
"");
MongoDB.Bson.BsonDocument docu
= MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(result);
await collection.InsertOneAsync(docu);
return(View(posts));
}
}
public async Task <posts> Posts()
{
//Access Token
await GetAccessToken();
string url = String.Format("{0}{1}&access_token={2}", baseUrl, FeedUrl, "EAADtSvZAF4lgBALCZBrvAymqZC8Evwj1GrvxsPdl6v2mBV3rQLDcOxqxiZBU2ZBVO7ERIKygjYc9i7Xim7BUuD4cZCOpFXXB68aN4mWCVZCIiNUSvpqn0iI5cxeynADyQP9ZCMpMaSeRQVA9ZC9WrzuRjA0fumTCLT1QPqcGjV02JA8d931z9nXRfyWuLZCtYFhsPo0nyIHyUoKQZDZD");
Console.WriteLine(url);
//Get data
dynamic jsonObj = await Get(url);
//Convert JSON
Models.SocialMedia.Facebook.posts posts =
new Models.SocialMedia.Facebook.posts(jsonObj);
using (SqlConnection connection = new SqlConnection("Data Source=DESKTOP-LNSE3O5;AttachDbFilename=|DataDirectory|SocialMediaReader2020.mdf;Initial Catalog=SocialMediaReader2020;Integrated Security=True"))
{
using (SqlCommand command = new SqlCommand())
{
int id = jsonObj.id;
DateTime created_time = jsonObj.created_time;
string src = jsonObj.src;
int width = jsonObj.width;
int height = jsonObj.height;
command.Connection = connection; // <== lacking
command.CommandType = CommandType.Text;
command.CommandText = "INSERT into feed (src,width,height) VALUES (@src,@width,@height)";
command.Parameters.AddWithValue("@id", id);
command.Parameters.AddWithValue("@created_time", created_time);
command.Parameters.AddWithValue("@src", src);
command.Parameters.AddWithValue("@height", height);
command.Parameters.AddWithValue("@width", width);
try
{
connection.Open();
int recordsAffected = command.ExecuteNonQuery();
}
catch (SqlException)
{
// error here
}
finally
{
connection.Close();
}
}
return(posts);
}
}
public async Task <posts> Posts()
{
//Access Token
await GetAccessToken();
string url = String.Format("{0}{1}&access_token={2}", baseUrl, FeedUrl, AccessToken);
//Get data
dynamic jsonObj = await Get(url);
//Convert JSON
Models.SocialMedia.Facebook.posts posts = new Models.SocialMedia.Facebook.posts(jsonObj);
return(posts);
}
public async Task <ActionResult> Posts()
{
Models.SocialMedia.Facebook.FacebookClient facebookClient = new Models.SocialMedia.Facebook.FacebookClient();
facebookClient.HttpContext = HttpContext;
Models.SocialMedia.Facebook.posts posts = await facebookClient.Posts();
return(View(posts));
////Get Access Token
//var currentClaims = await UserManager.GetClaimsAsync(HttpContext.User.Identity.GetUserId());
//var accesstoken = currentClaims.FirstOrDefault(x => x.Type == "urn:tokens:facebook");
//if (accesstoken == null)
//{
// return (new HttpStatusCodeResult(HttpStatusCode.NotFound, "Token not found."));
//}
////Format a url to retrieve posts or feed data from Facebook
//string url = String.Format("https://graph.facebook.com/me?fields=id,name,feed.limit(1000){{attachments,message,story,created_time,likes}}&access_token={0}", accesstoken.Value);
////Generate a web request using the url
//HttpWebRequest request = WebRequest.Create(url) as HttpWebRequest;
//request.Method = "GET";
////Ask for data from the server
//using (HttpWebResponse response = await request.GetResponseAsync() as HttpWebResponse)
//{
// StreamReader reader = new StreamReader(response.GetResponseStream());
// //Place result into a string
// string result = await reader.ReadToEndAsync();
// //Convert result to JSON Object
// dynamic jsonObj = System.Web.Helpers.Json.Decode(result);
// Models.SocialMedia.Facebook.posts posts = new Models.SocialMedia.Facebook.posts(jsonObj);
// ViewBag.JSON = result;
// return View(posts);
//}
}
