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()); }