public void DeleteAPost(int postID)
        {

            NewsfeedDAL newsfeedDAL = new NewsfeedDAL();
            Post aPost = new Post(postID);
            newsfeedDAL.FlagPost(aPost);
        }

 public static void ShouldMatch(this PostViewModel candidate, Post actual)
 {
     candidate.Author.ShouldEqual(actual.Author);
     candidate.Content.ShouldEqual(actual.Content);
     candidate.PublishDate.ShouldEqual(actual.PublishDate);
     candidate.Title.ShouldEqual(actual.Title);
 }

        public string AddComment(int postID, string commentTxt)
        {
            Comments comment = new Comments();
            comment.MemberId = Context.Session["memberID"].ToString();
            comment.CommentText = commentTxt;
            comment.PostId = postID;
            messageDAL.InsertComment(comment);

            //Insert notification
            NotificationDAL notificationDAL = new NotificationDAL();

            Post aPost = new Post(postID);

            List<Member> MemberList = new List<Member>();
            MemberList = notificationDAL.GetPostOwner(aPost);
            string friendId = MemberList[0].MemberId;
            Member aFriend = new Member(friendId);

            Member aMember = new Member(Context.Session["memberID"].ToString());

            if (aMember.MemberId != aFriend.MemberId)
            {
                notificationDAL.InsertCommentedOnPostNotification(aMember, aFriend, aPost);
            }
            //Refreshing the Comment count
            Post post = new Post();
            post.PostId = comment.PostId;

            return messageDAL.CountComments(post).ToString();
        }

 public void get_column_value()
 {
     var post = new Post() {Title = "title12"};
     var id = _db.Insert(post).InsertedId<int>();
     Assert.Equal("title12",_db.GetColumnValue<Post,string>(p=>p.Title,p => p.Id == id));
     Assert.Null(_db.GetColumnValue<Post, string>(p => p.Title, p => p.Id == 2890));
 }

        public ActionResult Create(FormCollection formCollection)
        {
            string title = formCollection.Get("Title");
            string body = formCollection.Get("Body");
            bool isPublic = formCollection.Get("IsPublic").Contains("true");

            IRepository<Category> categoriesRepo = new CategoryRepository();
            IRepository<Post> postsRepo = new PostRepository();
            List<Category> allCategories = (List<Category>)categoriesRepo.GetAll();

            Post post = new Post();
            post.Body = body;
            post.Title = title;
            post.CreationDate = DateTime.Now;
            post.IsPublic = isPublic;

            foreach (Category category in allCategories)
            {
                if (formCollection.Get(category.Id.ToString()).Contains("true"))
                    post.Categories.Add(category);

            }

            postsRepo.Save(post);


            return RedirectToAction("Index");
        }

 //
 public ActionResult FindByLegend(Post post)
 {
     PostServiceClient service = new PostServiceClient();
     //Davi ira fazer o metodo
     //service.findByLegend(post);
     return PartialView("_FindPost");
 }

        static void Main(string[] args)
        {
            Client client = new Client("2", "a18632aa82be8e925ef349164314311a", "http://hook.dev/public/index.php/");
            Collection posts = client.Collection ("posts");

            var post = new Post ();
            post.title = "Hello there!";
            post.score = 15;
            post.date = new DateTime (2014, 07, 07, 17, 30, 0);

            posts.Create (post).ContinueWith<Post> (result => {
                Console.WriteLine(result.ToString());
            });

            posts.Get ().ContinueWith<Post[]> (result => {
                Console.WriteLine(result.ToString());
            });

            req = posts.Sort ("created_at", Order.DESCENDING).Limit(1).First().ContinueWith<Post> (data => {
                Console.WriteLine("Post id: ");
                Console.WriteLine(data._id);
            });

            NSApplication.Init ();
            NSApplication.Main (args);
        }

 public ActionResult Database()
 {
     posts.DeleteAll();
     var folders = Directory.GetDirectories(Server.MapPath("~" + Constants.PostsFolder));
     var messagesAndErrors = new List<Pair<string, bool>>();
     foreach (var folder in folders)
     {
         var entry = new Post();
         var dir = new DirectoryInfo(folder);
         var postMessagesAndErrors = populators.Select(x =>
                                              {
                                                  try
                                                  {
                                                      x.Populate(entry, dir);
                                                      return new Pair<string, bool>(string.Format("{0} | {1} is OK.", entry.Slug, x.GetType().Name), true);
                                                  }
                                                  catch (Exception e)
                                                  {
                                                      return new Pair<string, bool>(string.Format("{0} | {1} | {2}", entry.Slug, e.GetType(), e.Message), false);
                                                  }
                                              }).ToList();
         messagesAndErrors.AddRange(postMessagesAndErrors);
         if (postMessagesAndErrors.All(x => x.Other)) posts.Save(entry);
         posts.Commit();
     }
     return View(messagesAndErrors);
 }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Permission.Check("post.read", true)) return;

        if (!Page.IsPostBack)
        {
            using (MooDB db = new MooDB())
            {
                if (Request["id"] != null)
                {
                    int postID = int.Parse(Request["id"]);
                    post = (from p in db.Posts
                            where p.ID == postID
                            select p).SingleOrDefault<Post>();
                }

                if (post == null)
                {
                    PageUtil.Redirect(Resources.Moo.FoundNothing, "~/");
                    return;
                }

                ViewState["postID"] = post.ID;
                Page.DataBind();
            }
        }
    }

        private void setup_sample_post(User user)
        {
            var oxiteTag = new Tag {Name = "Oxite", CreatedDate = DateTime.Parse("12 NOV 2008")};

            var defaultPost = new Post
            {
                Title = "World.Hello()",
                Slug = "World_Hello",
                BodyShort = "Welcome to Oxite! &nbsp;This is a sample application targeting developers built on <a href=\"http://asp.net/mvc\">ASP.NET MVC</a>. &nbsp;Make any changes you like. &nbsp;If you build a feature you think other developers would be interested in and would like to share your code go to the <a href=\"http://www.codeplex.com/oxite\">Oxite Code Plex project</a> to see how you can contribute.<br /><br />To get started, sign in with \"Admin\" and \"pa$$w0rd\" and click on the Admin tab.<br /><br />For more information about <a href=\"http://oxite.net\">Oxite</a> visit the default <a href=\"/About\">About</a> page.",
                Body = "Welcome to Oxite! &nbsp;This is a sample application targeting developers built on <a href=\"http://asp.net/mvc\">ASP.NET MVC</a>. &nbsp;Make any changes you like. &nbsp;If you build a feature you think other developers would be interested in and would like to share your code go to the <a href=\"http://www.codeplex.com/oxite\">Oxite Code Plex project</a> to see how you can contribute.<br /><br />To get started, sign in with \"Admin\" and \"pa$$w0rd\" and click on the Admin tab.<br /><br />For more information about <a href=\"http://oxite.net\">Oxite</a> visit the default <a href=\"/About\">About</a> page.",
                Published = DateTime.Parse("2008-12-05 09:29:03.270"),
                User = user
            };
            defaultPost.AddTag(oxiteTag);

            _repository.Save(defaultPost);

            var defaultPost1 = new Post
            {
                Title = "World.Hello()",
                Slug = "World_Hello2",
                BodyShort = "Welcome to Oxite! &nbsp;This is a sample application targeting developers built on <a href=\"http://asp.net/mvc\">ASP.NET MVC</a>. &nbsp;Make any changes you like. &nbsp;If you build a feature you think other developers would be interested in and would like to share your code go to the <a href=\"http://www.codeplex.com/oxite\">Oxite Code Plex project</a> to see how you can contribute.<br /><br />To get started, sign in with \"Admin\" and \"pa$$w0rd\" and click on the Admin tab.<br /><br />For more information about <a href=\"http://oxite.net\">Oxite</a> visit the default <a href=\"/About\">About</a> page.",
                Body = "Welcome to Oxite! &nbsp;This is a sample application targeting developers built on <a href=\"http://asp.net/mvc\">ASP.NET MVC</a>. &nbsp;Make any changes you like. &nbsp;If you build a feature you think other developers would be interested in and would like to share your code go to the <a href=\"http://www.codeplex.com/oxite\">Oxite Code Plex project</a> to see how you can contribute.<br /><br />To get started, sign in with \"Admin\" and \"pa$$w0rd\" and click on the Admin tab.<br /><br />For more information about <a href=\"http://oxite.net\">Oxite</a> visit the default <a href=\"/About\">About</a> page.",
                Published = DateTime.Parse("2008-12-05 09:29:03.270"),
                User = user
            };
            defaultPost1.AddTag(oxiteTag);
            defaultPost1.AddTag(new Tag { Name = "AltOxite", CreatedDate = DateTime.Parse("30 DEC 2008") });
            defaultPost1.AddComment(new Comment { Post = defaultPost1, User = user, Body = "test comment", Published = DateTime.Parse("31 DEC 2008") });

            _repository.Save(defaultPost1);
        }

        public void SetUp()
        {
            _siteConfiguration = new SiteConfiguration
            {
                TwitterUserName = "TestUser",
                TwitterPassword = "TestPassword",
            };

            _twitterClient = MockRepository.GenerateStub<ITwitterClient>();
            _tinyUrlService = MockRepository.GenerateStub<ITinyUrlService>();
            _urlResolver = MockRepository.GenerateStub<IUrlResolver>();

            _twitterService = new TwitterService(_siteConfiguration, _twitterClient, _tinyUrlService, _urlResolver);

            _user = new User
            {
                TwitterUserName = "MarkNijhof",
            };

            _post = new Post
            {
                User = _user,
                Title = "Test title",
            };
        }

        static void Main(string[] args)
        {
            var post = new Post();

            post["title"] = "MyPost";
            post["description"] = "This is a description of my post";
            Console.WriteLine(post["title"]);
            Console.WriteLine(post["description"]);
            Console.WriteLine("This post was created: " + post.TimeCreated());

            for (var i = 0; i < 5; i++)
            {
                Console.WriteLine("\n\nTo UpVote this post, press 1.");
                Console.WriteLine("To DownVote this post, press  2.");
                if (Console.ReadLine() == "1")
                {
                    post.UpVote++;
                }
                else if (Console.ReadLine() == "2")
                {
                    post.DownVote++;
                }
                Console.WriteLine("\nThere are currently " + post.UpVote + " UpVotes " + "And " + post.DownVote + " Down Votes");
            }
        }

    private static void Save(HttpContext context, Post post)
    {
        string name = context.Request.Form["name"];
        string email = context.Request.Form["email"];
        string website = context.Request.Form["website"];
        string content = context.Request.Form["content"];

        Validate(name, email, content);

        Comment comment = new Comment()
        {
            Author = name.Trim(),
            Email = email.Trim(),
            Website = GetUrl(website),
            Ip = context.Request.UserHostAddress,
            UserAgent = context.Request.UserAgent,
            IsAdmin = context.User.Identity.IsAuthenticated,
            Content = HttpUtility.HtmlEncode(content.Trim()).Replace("\n", "<br />"),
        };

        post.Comments.Add(comment);
        Storage.Save(post);

        if (!context.User.Identity.IsAuthenticated)
            System.Threading.ThreadPool.QueueUserWorkItem((s) => SendEmail(comment, post, context.Request));

        RenderComment(context, comment);
    }

        public void AnExceptionInvalidatesTheScopeAndPreventItsFlushing()
        {
            using (new SessionScope()) {
                Post.DeleteAll();
                Blog.DeleteAll();
            }

            Post post;

            // Prepare
            using(new SessionScope())
            {
                var blog = new Blog {Author = "hammett", Name = "some name"};
                blog.Save();

                post = new Post(blog, "title", "contents", "castle");
                post.Save();
            }

            using(var session = new SessionScope())
            {
                Assert.IsFalse(session.HasSessionError);

                Assert.Throws<ActiveRecordException>(() => {
                    post = new Post(new Blog(100), "title", "contents", "castle");
                    post.Save();
                    session.Flush();
                });

                Assert.IsTrue(session.HasSessionError);
            }
        }

        public ActionResult FindById(Post post)
        {
            PostServiceClient service = new PostServiceClient();

            service.find(post);
            return View();
        }

	private void SaveFilesToDisk(Post post)
	{
		foreach (Match match in Regex.Matches(post.Content, "(src|href)=\"(data:([^\"]+))\"(>.*?</a>)?"))
		{
			string extension = string.Empty;
			string filename = string.Empty;

			// Image
			if (match.Groups[1].Value == "src")
			{
				extension = Regex.Match(match.Value, "data:([^/]+)/([a-z]+);base64").Groups[2].Value;
			}
			// Other file type
			else
			{
				// Entire filename
				extension = Regex.Match(match.Value, "data:([^/]+)/([a-z0-9+-.]+);base64.*\">(.*)</a>").Groups[3].Value;
			}

			byte[] bytes = ConvertToBytes(match.Groups[2].Value);
			string path = Blog.SaveFileToDisk(bytes, extension);

			string value = string.Format("src=\"{0}\" alt=\"\" ", path);

			if (match.Groups[1].Value == "href")
				value = string.Format("href=\"{0}\"", path);

			Match m = Regex.Match(match.Value, "(src|href)=\"(data:([^\"]+))\"");
			post.Content = post.Content.Replace(m.Value, value);
		}
	}

 public ActionResult FindByLatLong(Post post)
 {
     PostServiceClient service = new PostServiceClient();
     //Davi ira fazer o metodo
     service.findAllByLatitudeAndLongitude(post);
     return View();
 }

        public Post CreatePost(string message,string emailAddress)
        {
            Post post = new Post();
            using (DatabaseLayer dbLayer = new DatabaseLayer())
            {
                SqlCommand cmd = new SqlCommand("CreatePost");
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@emailAddress", emailAddress);
                cmd.Parameters.AddWithValue("@message", message);

                DataSet postDataset = dbLayer.FillDataSet(cmd);

                if (postDataset != null && postDataset.Tables.Count > 0)
                {
                    foreach (DataRow row in postDataset.Tables[0].Rows)
                    {
                        post.Id = Convert.ToInt32(row["Id"].ToString());
                        post.Message = row["Message"].ToString();
                        post.CreatedOn = Convert.ToDateTime(row["CreatedOn"].ToString());
                        post.CreatedByString = row["CreatedByString"].ToString();
                        post.CreatedBy = Convert.ToInt32(row["CreatedBy"].ToString());

                    }
                }
            }

            return post;
        }

 protected static Post SavePost(Post post)
 {
     string conn = ConfigurationManager.AppSettings["mongolab"];
     PostData postData = new PostData(conn);
     postData.SavePost(post);
     return post;
 }

        public List<Post> GetPostByUserId(int Id)
        {
            List<Post> lstPosts = new List<Post>();
            using (DatabaseLayer dbLayer = new DatabaseLayer())
            {
                SqlCommand cmd = new SqlCommand("GetPostByUserId");
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@id", Id);

                DataSet postDataset = dbLayer.FillDataSet(cmd);

                if (postDataset != null && postDataset.Tables.Count > 0)
                {
                    foreach (DataRow row in postDataset.Tables[0].Rows)
                    {
                        Post post = new Post();
                        post.Id = Convert.ToInt32(row["Id"].ToString());
                        post.Message = row["Message"].ToString();
                        post.CreatedOn = Convert.ToDateTime(row["CreatedOn"].ToString());
                        post.CreatedByString = row["CreatedByString"].ToString();
                        post.CreatedBy = Convert.ToInt32(row["CreatedBy"].ToString());
                        lstPosts.Add(post);
                    }
                }
            }

            return lstPosts;
        }