//Lấy ID Thể Loại Tin hiển thị tất cả tin trong thể loại sang trang TLTin.aspx
public List <TinTuc1> LayIDTLTin(string IDTLTin)
{
string sql = "select * from TINTUC where IDTHELOAITIN='" + IDTLTin + "' order by IDTINTUC desc";
dah.KetNoi();
DataTable dt = dah.LoadDuLieu(sql);
dah.NgatKetNoi();
List <TinTuc1> ds = new List <TinTuc1>();
foreach (DataRow dr in dt.Rows)
{
TinTuc1 tt = new TinTuc1();
tt.IDTinTuc = int.Parse(dr[0].ToString());
tt.IDTheLoaiTin = dr[1].ToString();
tt.TieuDe = dr[2].ToString();
tt.TomTat = dr[3].ToString();
tt.NoiDung = dr[4].ToString();
tt.AnhDaiDien = dr[5].ToString();
tt.NgayDang = DateTime.Parse(dr[6].ToString());
tt.TacGia = dr[7].ToString();
tt.NguoiDang = dr[8].ToString();
tt.LuotXem = int.Parse(dr[9].ToString());
ds.Add(tt);
}
this.DanhSachTinTuc = ds;
return(ds);
}
// Tin đọc nhiều nhất , hiển thị cuối trang DetailTinTuc.aspx
public List <TinTuc1> TinDocNhieuNhat()
{
string sql = "Select top 8 * from TINTUC order by LUOTXEM desc";
dah.KetNoi();
DataTable dt = dah.LoadDuLieu(sql);
dah.NgatKetNoi();
List <TinTuc1> ds = new List <TinTuc1>();
foreach (DataRow dr in dt.Rows)
{
TinTuc1 tt = new TinTuc1();
tt.IDTinTuc = int.Parse(dr[0].ToString());
tt.IDTheLoaiTin = dr[1].ToString();
tt.TieuDe = dr[2].ToString();
tt.TomTat = dr[3].ToString();
tt.NoiDung = dr[4].ToString();
tt.AnhDaiDien = dr[5].ToString();
tt.NgayDang = DateTime.Parse(dr[6].ToString());
tt.TacGia = dr[7].ToString();
tt.NguoiDang = dr[8].ToString();
tt.LuotXem = int.Parse(dr[9].ToString());
ds.Add(tt);
}
this.DanhSachTinTuc = ds;
return(ds);
}
//Tìm kiếm tin tức
public List <TinTuc1> TimKiem(string keyword)
{
string sql = "select * from TINTUC where TIEUDE like N'%" + keyword + "%' or NOIDUNG like N'%" + keyword + "%' or TOMTAT like N'%" + keyword + "%' order by NGAYDANG desc";
dah.KetNoi();
DataTable dt = dah.LoadDuLieu(sql);
dah.NgatKetNoi();
List <TinTuc1> ds = new List <TinTuc1>();
foreach (DataRow dr in dt.Rows)
{
TinTuc1 tt = new TinTuc1();
tt.IDTinTuc = int.Parse(dr[0].ToString());
tt.IDTheLoaiTin = dr[1].ToString();
tt.TieuDe = dr[2].ToString();
tt.TomTat = dr[3].ToString();
tt.NoiDung = dr[4].ToString();
tt.AnhDaiDien = dr[5].ToString();
tt.NgayDang = DateTime.Parse(dr[6].ToString());
tt.TacGia = dr[7].ToString();
tt.NguoiDang = dr[8].ToString();
tt.LuotXem = int.Parse(dr[9].ToString());
ds.Add(tt);
}
this.DanhSachTinTuc = ds;
return(ds);
}
public ActionResult DeleteConfirmed(string id)
{
TinTuc1 tinTuc1 = db.TinTucs.Find(id);
db.TinTucs.Remove(tinTuc1);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,Author,Context")] TinTuc1 tinTuc1)
{
if (ModelState.IsValid)
{
db.Entry(tinTuc1).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tinTuc1));
}
public ActionResult Create([Bind(Include = "ID,Author,Context")] TinTuc1 tinTuc1)
{
if (ModelState.IsValid)
{
db.TinTucs.Add(tinTuc1);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tinTuc1));
}
// GET: TinTuc1/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TinTuc1 tinTuc1 = db.TinTucs.Find(id);
if (tinTuc1 == null)
{
return(HttpNotFound());
}
return(View(tinTuc1));
}
public void SuaTinTuc(TinTuc1 tt)
{
dal.SuaTinTuc(tt);
}
public void ThemTinTuc(TinTuc1 tt)
{
dal.ThemTinTuc(tt);
}
public void SuaTinTuc(TinTuc1 tt)
{
string sql = "update TINTUC set IDTHELOAITIN='" + tt.IDTheLoaiTin + "', TIEUDE=N'" + tt.TieuDe + "', TOMTAT=N'" + tt.TomTat + "', NOIDUNG=N'" + tt.NoiDung + "', ANHDAIDIEN='" + tt.AnhDaiDien + "', NGAYDANG='" + tt.NgayDang + "', TACGIA=N'" + tt.TacGia + "', NGUOIDANG=N'" + tt.NguoiDang + "', LUOTXEM=" + tt.LuotXem + " where IDTINTUC='" + tt.IDTinTuc + "'";
dah.ThucThi(sql);
}
public void ThemTinTuc(TinTuc1 tt)
{
string sql = "insert into TINTUC values ('" + tt.IDTheLoaiTin + "',N'" + tt.TieuDe + "',N'" + tt.TomTat + "',N'" + tt.NoiDung + "','" + tt.AnhDaiDien + "','" + tt.NgayDang + "',N'" + tt.TacGia + "',N'" + tt.NguoiDang + "'," + tt.LuotXem + ")";
dah.ThucThi(sql);
}
