Beispiel #1
0
        public void blogss()
        {
            var category = from pst in db.soptions
                           where pst.disc == "category"
                           orderby pst.name ascending
                           select pst;

            Listcategory.DataSource = category;
            Listcategory.DataBind();

            lblblog.Text = "Category";
            string frm = Request.QueryString["frm"].ToString();

            switch (frm)
            {
            case "req":
                string dis = Request.QueryString["retrive"].ToString();

                var viewcategory = db.sp_search_categorypost(dis.ToString());

                ListView_blog.DataSource = viewcategory;
                ListView_blog.DataBind();
                break;
            }
        }
        public void blogss()
        {
            var post = from pst in db.viewposts
                       where pst.status == "Publish"
                       orderby pst.dte ascending
                       select pst;



            ListView_blog.DataSource = post;
            ListView_blog.DataBind();

            string YourText = lblcontent.Text;

            if (YourText.Length > 50)
            {
                YourText    = YourText.Substring(0, 50);
                YourText   += "<a href=''>... Read more</a>";
                Label1.Text = YourText.ToString();
            }

            var category = from pst in db.soptions
                           where pst.disc == "category"
                           orderby pst.name ascending
                           select pst;

            Listcategory.DataSource = category;
            Listcategory.DataBind();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            this.blogss();
            this.sitemap();
            try
            {
                string frm = Request.QueryString["frm"].ToString();
                switch (frm)
                {
                case "read":


                    read = Request.QueryString["id"].ToString();
                    viewpost vPost = db.viewposts.First(use => use.pst_id == Convert.ToInt16(read));
                    lblsitemap.Text   = " <ol class='breadcrumb'><li><a href='home.aspx'>Home</a></li><li><a href='Destination.aspx'>Destination</a></li><li class='active'>" + vPost.pst_title + "</li></ol>";
                    lbldate.Text      = Convert.ToString(vPost.dte);
                    lbltitle.Text     = vPost.pst_title;
                    lblrestitle.Text  = vPost.pst_title;
                    lblcontent.Text   = vPost.pst_content;
                    lblauthor.Text    = vPost.Username;
                    lblpostimage.Text = "<a href='../images/oreginal/" + vPost.Image + "'><img class='img-responsive' src='../images/oreginal/" + vPost.Image + "'/></a>";


                    HttpCookie cookie = Request.Cookies["rowenref"];    // declaration cookie
                    if (cookie == null)
                    {
                        // imguser.ImageUrl = "../profilepic/thumb/default.png";
                        Panel1.Visible = true;
                        Panel2.Visible = false;
                    }
                    else
                    {
                        user User = db.users.First(use => use.username == cookie["username"]);
                        imguserlogin.ImageUrl = "../profilepic/thumb/" + User.Image;
                        Panel1.Visible        = false;
                        Panel2.Visible        = true;
                    }

                    //sider
                    tbl_gallery gall = db.tbl_galleries.First(use => use.pst_id == Convert.ToInt16(read));
                    lblgallerytitle.Text = gall.title + " Gallery";
                    var slider = from slide in db.gallerylists
                                 where slide.gallery_id == gall.gallery_id
                                 select slide;

                    listslider.DataSource = slider;
                    listslider.DataBind();
                    ////end slider
                    //var con = db.sp_selected_tbl_comment(Convert.ToInt16(read), Convert.ToInt16(13));
                    var con = from pst in db.view_comments
                              where pst.pst_id == Convert.ToInt16(read)
                              where pst.c_status == "Approved"
                              select pst;
                    //view_comment vComment = db.view_comments.First(use => use.pst_id == Convert.ToInt16(read));
                    ListView1.DataSource = con;
                    ListView1.DataBind();
                    MultiView1.ActiveViewIndex = 1;

                    comment Cmt = db.comments.First(use => use.c_status == Convert.ToInt16(13));

                    if (db.f_countcomment(Convert.ToInt16(read)) != 0)
                    {
                        Label1.Text = Convert.ToString((db.f_countcomment(Convert.ToInt16(read)))) + " Comment";
                        lblres.Text = Convert.ToString((db.f_countcomment(Convert.ToInt16(read))));
                    }
                    else
                    {
                        Label1.Text = "0 Comment";
                        lblres.Text = "No ";
                    }

                    break;


                case "srh":
                    string srcs = Request.QueryString["cn"].ToString();


                    var viewsearch = db.sp_search_post(srcs.ToString());
                    ListView_blog.DataSource = viewsearch;
                    ListView_blog.DataBind();



                    break;
                }
            }
            catch (Exception ex)
            {
            }
        }