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