// Lay ten chuyen muc tren cung end // Phân trang theo chuyên mục start // link tham khảo: https://www.dotnetcurry.com/ShowArticle.aspx?ID=345 public void FetchData(int take, int pagesize) { int idcm = int.Parse(Request.QueryString["ID_ChuyenMuc"]); using (NewsEntities2 dc = new NewsEntities2()) { var query = from p in dc.BaiViet.Where(c => c.ID_ChuyenMuc == idcm).OrderBy(o => o.ID_BaiViet).Take(take).Skip(pagesize) select new { idbaiviet = p.ID_BaiViet, anhthum = p.AnhThumbnail, Tenbai = p.TenBaiViet, Count = dc.BaiViet.Where(x => x.ID_ChuyenMuc == idcm).Count() }; PagedDataSource pgitems = new PagedDataSource(); pgitems.AllowCustomPaging = true; pgitems.AllowPaging = true; pgitems.DataSource = query; pgitems.PageSize = 10; dgvchuyenmuc.DataSource = pgitems; dgvchuyenmuc.DataBind(); if (!IsPostBack) { RowCount = query.First().Count; CreatePagingControl(); } } }
public string getidcomlogout(int idreader) { NewsEntities2 db = new NewsEntities2(); List <News.LoginReader> listreader = db.LoginReader.OrderBy(x => x.ID_Reader).OrderBy(c => c.ID_Reader).ToList(); return(db.LoginReader.First(x => x.ID_Reader == idreader).NickName); }
// Lấy tên bài viết hiển thị trong tab poppular theo id_bài viêt start // Lấy tên bài viết hiển thị trong tab lasest theo id_bài viêt start public void getdatalastest() { NewsEntities2 db = new NewsEntities2(); List <News.BaiViet> listfeature = db.BaiViet.OrderByDescending(x => x.TGViet).Take(4).ToList(); dgvlastest.DataSource = listfeature; dgvlastest.DataBind(); }
// Lấy tên bài viết hiển thị trong tab feature theo id_bài viêt end // Lấy tên bài viết hiển thị trong tab poppular theo id_bài viêt start public void getdatapopular() { NewsEntities2 db = new NewsEntities2(); List <News.BaiViet> listfeature = db.BaiViet.OrderBy(x => x.ID_BaiViet).Skip(5).Take(4).ToList(); dgvpopular.DataSource = listfeature; dgvpopular.DataBind(); }
// Lay chi tiêt nôi dung bai viet end // Relates news start public void relatednewbaivietmoi() { NewsEntities2 db = new NewsEntities2(); List <News.BaiViet> listbaiviet = db.BaiViet.OrderByDescending(x => x.ID_BaiViet).Take(6).ToList(); dgvrelatedmoi.DataSource = listbaiviet; dgvrelatedmoi.DataBind(); }
//Slide bài viet mới theo id bài viêt end ////Hien thi 3 bài viets random Start //public void getbaivietrandom() //{ // NewsEntities2 db = new NewsEntities2(); // List<News.BaiViet> num = db.BaiViet.OrderBy(x => x.ID_BaiViet).ToList(); // Random rand = new Random(); // int toskip = rand.Next(1, 10); // List<News.BaiViet> listsport = db.BaiViet.OrderBy(x => x.TGViet).Skip(toskip).Take(3).ToList(); // dgvbaivietrandom.DataSource = listsport; // dgvbaivietrandom.DataBind(); //} //public string showbaivietrandom(string tenbaiviet) //{ // NewsEntities2 db = new NewsEntities2(); // return db.BaiViet.First(x => x.TenBaiViet == tenbaiviet).TenBaiViet; //} //public string layanhanhtheoidbai(int idbaiviet) //{ // NewsEntities2 db = new NewsEntities2(); // return db.BaiViet.First(x => x.ID_BaiViet == idbaiviet).AnhThumbnail; //} //// Hiện thị 3 bài viết randon END // lấy tên các chuyên mục cha và con hiên thị trong repeater start public void getdgvchuyenmuccha() { NewsEntities2 db = new NewsEntities2(); List <News.ChuyenMuc> listcha = db.ChuyenMuc.Where(x => x.ID_ChuyenMucCha == 1 && x.ID_ChuyenMuc != 101).ToList(); dgvchuyenmuccha.DataSource = listcha; dgvchuyenmuccha.DataBind(); }
// lấy ten bài viết hiện thị trong tab mostrecent theo id_baiviet end // lay tat cả bài viet start public void getallbaiviet() { NewsEntities2 db = new NewsEntities2(); List <News.BaiViet> listall = db.BaiViet.OrderBy(x => x.ID_BaiViet).ToList(); tatcabaiviet.DataSource = listall; tatcabaiviet.DataBind(); }
// láy ten bài viết hiện thị trong tab mostread theo id_baiviet end // Lây tên bài viết hiện thị trong tab mostrecent theo id_bài viết start public void getdatamostrecent() { NewsEntities2 db = new NewsEntities2(); List <News.BaiViet> listmostread = db.BaiViet.OrderBy(x => x.ID_BaiViet).Skip(8).Take(4).ToList(); dgvmostrecent.DataSource = listmostread; dgvmostrecent.DataBind(); }
// Lấy tên bài viết hiển thị trong tab lastest theo id_bài viêt start // Lấy tên bài viết hiển thị trong tab mostviews theo id_bài viêt start public void getdatamostviews() { NewsEntities2 db = new NewsEntities2(); List <News.BaiViet> listmostviews = db.BaiViet.OrderBy(x => x.TGViet).Take(4).ToList(); dgvmostview.DataSource = listmostviews; dgvmostview.DataBind(); }
// Lay tên và anh cho bài viết new posts start public void getdatanewposts() { NewsEntities2 db = new NewsEntities2(); List <News.BaiViet> listhotposts = db.BaiViet.OrderByDescending(x => x.ID_BaiViet).Take(2).ToList(); dgvnewposts.DataSource = listhotposts; dgvnewposts.DataBind(); }
public List <News.ChuyenMuc> tenchuyenmuc(int idcm) { NewsEntities2 db = new NewsEntities2(); //Random rand = new Random(); //int randnum = rand.Next(1, 10); return(db.ChuyenMuc.Where(c => c.ID_ChuyenMucCha == idcm).OrderBy(x => x.TenChuyenMuc).ToList()); }
// lay ten chuyen muc hien thị ở short link end // Lay chi tiêt nôi dung bai viet start public void getbaiviet() { int idbv = int.Parse(Request.QueryString["ID_BaiViet"]); NewsEntities2 db = new NewsEntities2(); List <News.BaiViet> listchitietbv = db.BaiViet.Where(x => x.ID_BaiViet == idbv).ToList(); chitietbaiviet.DataSource = listchitietbv; chitietbaiviet.DataBind(); }
// hiển thị các comment lab login end // hiển thị các comment lab logout start public void getdatacommentlogout() { int idbaiviet = int.Parse(Request.QueryString["ID_Baiviet"]); NewsEntities2 db = new NewsEntities2(); List <News.Comment> listcomment = db.Comment.Where(x => x.ID_BaiViet == idbaiviet).ToList(); licommentlogout.DataSource = listcomment; licommentlogout.DataBind(); }
//// Featuate repeater chưa phan trang start //public void getidchuyenmuc1() //{ // int idcm = int.Parse(Request.QueryString["ID_ChuyenMuc"]); // NewsEntities2 db = new NewsEntities2(); // List<News.BaiViet> listchuyenmuc = db.BaiViet.Where(x => x.ID_ChuyenMuc == idcm).ToList(); // //List<News.ChuyenMuc> listchuyenmuc = db.ChuyenMuc.Where(x => x.ID_ChuyenMuc == idcm).ToList(); // dgvchuyenmuc1.DataSource = listchuyenmuc; // //dgvchuyenmuc.DataSource = listchuyenmuc; // dgvchuyenmuc1.DataBind(); //} //public string laycacbaiviet(int idbaiviet) //{ // NewsEntities2 db = new NewsEntities2(); // return db.BaiViet.Where(x => x.ID_ChuyenMuc == idbaiviet).ToString(); //} //// Featuate repeater chưa phan trang end //public void getidchuyenmuc() //{ // int idcm = int.Parse(Request.QueryString["ID_ChuyenMuc"]); // NewsEntities2 db = new NewsEntities2(); // List<News.BaiViet> listchuyenmuc = db.BaiViet.Where(x => x.ID_ChuyenMuc == idcm).ToList(); // //List<News.ChuyenMuc> listchuyenmuc = db.ChuyenMuc.Where(x => x.ID_ChuyenMuc == idcm).ToList(); // dgvchuyenmuc.DataSource = listchuyenmuc; // //dgvchuyenmuc.DataSource = listchuyenmuc; // dgvchuyenmuc.DataBind(); //} //tenchuyenmucotren // Lay ten chuyen muc tren cung start public void laytenchuyenmuc() { int idcmtren = int.Parse(Request.QueryString["ID_ChuyenMuc"]); NewsEntities2 db = new NewsEntities2(); List <News.ChuyenMuc> listcm = db.ChuyenMuc.Where(x => x.ID_ChuyenMuc == idcmtren).ToList(); tenchuyenmucotren.DataSource = listcm; tenchuyenmucotren.DataBind(); }
// Lây tên tag cloud end // Count bài viet chuyen mục start public void countbaiviet() { NewsEntities2 db = new NewsEntities2(); List <News.ChuyenMuc> listcm = db.ChuyenMuc.Where(x => x.ID_ChuyenMucCha == 1 && x.ID_ChuyenMuc != 101).ToList(); countCategory.DataSource = listcm; countCategory.DataBind(); }
// Lấy tên bài viết hiển thị trong tab quick link theo id_bài viêt end // Lấy tên bài viết hiển thị trong tab quick link theo id_bài viêt start public void getdatauserfull() { NewsEntities2 db = new NewsEntities2(); Random ran = new Random(); int rand = ran.Next(5, 10); List <News.ChuyenMuc> listusefull = db.ChuyenMuc.OrderBy(x => x.ID_ChuyenMuc).Skip(rand).Take(5).ToList(); dgvusefull.DataSource = listusefull; dgvusefull.DataBind(); }
// Lấy tên bài viết hiển thị trong tab lastest theo id_bài viêt start // Láy tên tag cloud start public void laytencmpushtag() { NewsEntities2 db = new NewsEntities2(); Random ran = new Random(); int rannum = ran.Next(1, 4); List <News.ChuyenMuc> listcm = db.ChuyenMuc.Where(x => x.ID_ChuyenMucCha == 1).Take(rannum).ToList(); tagscha.DataSource = listcm; tagscha.DataBind(); }
// Lấy tên bài viết hiển thị trong tab quick link theo id_bài viêt start public void getdataquickly() { NewsEntities2 db = new NewsEntities2(); Random ran = new Random(); int rand = ran.Next(1, 5); List <News.ChuyenMuc> listquickly = db.ChuyenMuc.OrderBy(x => x.ID_ChuyenMuc).Skip(rand).Take(5).ToList(); dgvquicklink.DataSource = listquickly; dgvquicklink.DataBind(); }
// lay ten chuyen mục hien thi ở short link start public void shortcm() { int idcmtren = int.Parse(Request.QueryString["ID_Baiviet"]); NewsEntities2 db = new NewsEntities2(); int idcm = (int)db.BaiViet.First(x => x.ID_BaiViet == idcmtren).ID_ChuyenMuc; List <News.ChuyenMuc> listcm = db.ChuyenMuc.Where(x => x.ID_ChuyenMuc == idcm).ToList(); shortlinkcm.DataSource = listcm; shortlinkcm.DataBind(); }
// Phân trang theo chuyên mục end // Read more random start public void getvietrandom() { NewsEntities2 db = new NewsEntities2(); List <News.BaiViet> num = db.BaiViet.OrderBy(x => x.ID_BaiViet).ToList(); Random rand = new Random(); int toskip = rand.Next(1, 10); List <News.BaiViet> listsport = db.BaiViet.OrderBy(x => x.TGViet).Skip(toskip).Take(10).ToList(); dgvbairandom.DataSource = listsport; dgvbairandom.DataBind(); }
// Relates new end // Lây bai viets trong cùng chuyen mục start public void getbaivietcungcm() { int idcmtren = int.Parse(Request.QueryString["ID_Baiviet"]); NewsEntities2 db = new NewsEntities2(); //Random rand = new Random(); //int toskip = rand.Next(1, 10); int idcm = (int)db.BaiViet.First(x => x.ID_BaiViet == idcmtren).ID_ChuyenMuc; //List<News.BaiViet> listcm = db.BaiViet.Where(x => x.ID_ChuyenMuc == idcm).OrderBy(x => x.TGViet).Skip(toskip).Take(5).ToList(); List <News.BaiViet> listcm = db.BaiViet.Where(x => x.ID_ChuyenMuc == idcm).OrderBy(x => x.TGViet).Take(5).ToList(); cungthumuc.DataSource = listcm; cungthumuc.DataBind(); }
// hiển thị các comment lab logout end // Thêm mới comment vào bài viết start protected void btnsubmitcom_Click(object sender, EventArgs e) { NewsEntities2 db = new NewsEntities2(); int idbaiviet = int.Parse(Request.QueryString["ID_Baiviet"]); DateTime addtime = DateTime.Now; News.Comment obj = new News.Comment(); obj.Comment1 = addComment.Text; obj.ID_BaiViet = int.Parse(Request.QueryString["ID_Baiviet"]); obj.Time = addtime; obj.ID_Reader = 3; db.Comment.Add(obj); db.SaveChanges(); Response.Redirect("single_page.aspx?ID_Baiviet=" + idbaiviet); //loadlaitrang(idbaiviet); }
public List <News.BaiViet> getCmCoutBv(int id) { NewsEntities2 db = new NewsEntities2(); return(db.BaiViet.Where(x => x.ID_ChuyenMuc == id).Take(10).ToList()); //return db.BaiViet.Where(x => x.ID_ChuyenMuc == id).ToList(); //List<BaiViet> query = (List<BaiViet>)(from p in db.BaiViet.Where(x => x.ID_ChuyenMuc == id) // select new // { // idbaiviet = p.ID_BaiViet, // anhthum = p.AnhThumbnail, // Tenbai = p.TenBaiViet, // Count = db.BaiViet.Where(x => x.ID_ChuyenMuc == id).Count() // }); //return query; }
// Count Bài viết chuyen muc end // Đăng nhập start protected void btncreateacount_Click(object sender, EventArgs e) { NewsEntities2 db = new NewsEntities2(); News.LoginReader obj = db.LoginReader.FirstOrDefault(x => x.Name == Taikhoan.Text); if (obj != null) { // Cảnh báo mã sản phẩm đã tồn tại } else { obj = new News.LoginReader(); obj.Name = Taikhoan.Text; obj.Email = email.Text; obj.Password = Password.Text; //obj.MaLoai = cmbLoaiSP.SelectedValue; db.LoginReader.Add(obj); db.SaveChanges(); Response.Redirect("Content.aspx"); } }
public string relatednewmoi(string tenbaiviet) { NewsEntities2 db = new NewsEntities2(); return(db.BaiViet.First(x => x.TenBaiViet == tenbaiviet).TenBaiViet); }
public string getsignature(int iduser) { NewsEntities2 db = new NewsEntities2(); return(db.User.First(x => x.ID_User == iduser).TenUser); }
public string layidbaiviet(int idbaiviet) { NewsEntities2 db = new NewsEntities2(); return(db.BaiViet.First(x => x.ID_ChuyenMuc == idbaiviet).TenBaiViet); }
public string shortlink(int idchuyenmuc) { NewsEntities2 db = new NewsEntities2(); return(db.ChuyenMuc.First(c => c.ID_ChuyenMuc == idchuyenmuc).TenChuyenMuc); }
public DateTime laytimecomlogout(int idreader) { NewsEntities2 db = new NewsEntities2(); return((DateTime)db.Comment.First(x => x.ID_Comment == idreader).Time); }
public string laycomdetaillogout(int idreader) { NewsEntities2 db = new NewsEntities2(); return(db.Comment.First(x => x.ID_Comment == idreader).Comment1); }