public ActionResult Export(string pageid)
{
try
{
User objUser = (User)Session["User"];
var products = new System.Data.DataTable("teste");
products.Columns.Add("Post", typeof(string));
products.Columns.Add("Type", typeof(string));
products.Columns.Add("Like Count", typeof(string));
products.Columns.Add("Comment Count", typeof(string));
products.Columns.Add("Share Count", typeof(string));
products.Columns.Add("Comments", typeof(string));
products.Columns.Add("User Liked", typeof(string));
List<FbPagePost> FbPagePostDetails =new List<FbPagePost> ();
try
{
FbPagePostDetails = Helper.SBUtils.FbPagePostDetails(pageid, objUser.Id.ToString());
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
foreach (var item in FbPagePostDetails)
{
try
{
string postscomments = string.Empty;
string postslikes = string.Empty;
Socioboard.Api.FbPageComment.FbPageComment ApiobjFbPageComment = new Socioboard.Api.FbPageComment.FbPageComment();
List<Domain.Socioboard.Domain.FbPageComment> lstFbPageComment = (List<Domain.Socioboard.Domain.FbPageComment>)(new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize(ApiobjFbPageComment.GetPostComments(item.PostId.ToString()), typeof(List<Domain.Socioboard.Domain.FbPageComment>)));
foreach (var FbPageComment in lstFbPageComment)
{
try
{
postscomments += FbPageComment .FromName + "-->" + FbPageComment.Comment + ", ";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
try
{
postscomments = postscomments.Substring(0, postscomments.Length - 1);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
Socioboard.Api.FbPageLiker.FbPageLiker apiobjFbPageLiker = new Socioboard.Api.FbPageLiker.FbPageLiker();
List<Domain.Socioboard.Domain.FbPageLiker> lstFbPageLiker = (List<Domain.Socioboard.Domain.FbPageLiker>)(new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize(apiobjFbPageLiker.GetLikeByPostId(item.PostId.ToString(), item.UserId.ToString()), typeof(List<Domain.Socioboard.Domain.FbPageLiker>)));
foreach (var FbPageLiker in lstFbPageComment)
{
try
{
postslikes += FbPageLiker.FromName + ", ";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
try
{
postslikes = postslikes.Substring(0, postslikes.Length - 1);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
products.Rows.Add(item.Post, item.Type, item.Likes, item.Comments, item.Shares, postscomments, postslikes);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
var grid = new GridView();
grid.DataSource = products;
grid.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
return View();
}
public ActionResult Export(string pageid)
{
try
{
User objUser = (User)Session["User"];
var products = new System.Data.DataTable("teste");
products.Columns.Add("Post", typeof(string));
products.Columns.Add("Type", typeof(string));
products.Columns.Add("Like Count", typeof(string));
products.Columns.Add("Comment Count", typeof(string));
products.Columns.Add("Share Count", typeof(string));
products.Columns.Add("Comments", typeof(string));
products.Columns.Add("User Liked", typeof(string));
List <FbPagePost> FbPagePostDetails = new List <FbPagePost> ();
try
{
FbPagePostDetails = Helper.SBUtils.FbPagePostDetails(pageid, objUser.Id.ToString());
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
foreach (var item in FbPagePostDetails)
{
try
{
string postscomments = string.Empty;
string postslikes = string.Empty;
Socioboard.Api.FbPageComment.FbPageComment ApiobjFbPageComment = new Socioboard.Api.FbPageComment.FbPageComment();
List <Domain.Socioboard.Domain.FbPageComment> lstFbPageComment = (List <Domain.Socioboard.Domain.FbPageComment>)(new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize(ApiobjFbPageComment.GetPostComments(item.PostId.ToString()), typeof(List <Domain.Socioboard.Domain.FbPageComment>)));
foreach (var FbPageComment in lstFbPageComment)
{
try
{
postscomments += FbPageComment.FromName + "-->" + FbPageComment.Comment + ", ";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
try
{
postscomments = postscomments.Substring(0, postscomments.Length - 1);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
Socioboard.Api.FbPageLiker.FbPageLiker apiobjFbPageLiker = new Socioboard.Api.FbPageLiker.FbPageLiker();
List <Domain.Socioboard.Domain.FbPageLiker> lstFbPageLiker = (List <Domain.Socioboard.Domain.FbPageLiker>)(new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize(apiobjFbPageLiker.GetLikeByPostId(item.PostId.ToString(), item.UserId.ToString()), typeof(List <Domain.Socioboard.Domain.FbPageLiker>)));
foreach (var FbPageLiker in lstFbPageComment)
{
try
{
postslikes += FbPageLiker.FromName + ", ";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
try
{
postslikes = postslikes.Substring(0, postslikes.Length - 1);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
products.Rows.Add(item.Post, item.Type, item.Likes, item.Comments, item.Shares, postscomments, postslikes);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
var grid = new GridView();
grid.DataSource = products;
grid.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
return(View());
}
