public int LoadTapTin()
{
List<TAPTINBAIVIET> lt = new List<TAPTINBAIVIET>();
BUSTapTinBaiViet BUSTapTinBaiViet = new BUSTapTinBaiViet();
int sodong;
BaiVietTemp = (BAIVIET)Session["BaiVietTemp"];
lt = BUSTapTinBaiViet.TimKiemMaBaiViet(BaiVietTemp.MaBaiViet);
if (lt != null)
{
this.GridViewTapTin.DataSource = lt;
GridViewTapTin.DataBind();
PanelMessage.Visible = false;
PanelDanhSach.Visible = true;
sodong = lt.Count;
}
else
{
//lt = new List<TAPTINBAIVIET>();
// this.GridViewTapTin.DataSource = lt;
// GridViewTapTin.DataBind();
PanelMessage.Visible = true;
PanelDanhSach.Visible = true;
sodong = 0;
}
Session.Add("GridViewTapTinDataSource", lt);
List<TAPTINBAIVIET> lFileTemp = new List<TAPTINBAIVIET>();
Session.Add("FileUploadTemp", lFileTemp);
List<HttpPostedFile> lFileClientPath = new List<HttpPostedFile>();
Session.Add("FileClientTemp", lFileClientPath);
return sodong;
}
public ActionResult PostNews(BAIVIET bv, HttpPostedFileBase fileupload)
{
ADMIN tk = (ADMIN)Session["TaikhoanSV"];
ViewBag.Taikhoan = tk.Name;
var count = (from c in data.BAIVIETs select c).Count();
ViewBag.Count = count;
ViewBag.Id = new SelectList(data.DANHMUCs.ToList().OrderBy(n => n.Id), "Id", "TenDM");
if (ModelState.IsValid)
{
var fileName = Path.GetFileName(fileupload.FileName);
var path = Path.Combine(Server.MapPath("~/images/imagesNews"), fileName);
fileupload.SaveAs(path);
bv.HinhAnh = fileName;
data.BAIVIETs.InsertOnSubmit(bv);
data.SubmitChanges();
}
return(RedirectToAction("IAdminITU"));
}
public ActionResult Them(BAIVIET bv)
{
using (Web_KTCKEntities db = new Web_KTCKEntities())
{
try
{
if (bv.NgayDang == null)
{
bv.NgayDang = DateTime.Parse(DateTime.Now.ToString());
}
else
{
bv.NgayDang = bv.NgayDang;
}
bv.NgayCapNhat = null;
bv.LuotXem = 0;
ViewBag.IdTheLoai = new SelectList(db.THELOAIBAIVIETs.ToList(), "IdTheLoai", "TenTheLoai");
ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen");
db.BAIVIETs.Add(bv);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(RedirectToAction("Index"));
}
}
}
// GET: Admin/BaiViet/Sua
public ActionResult Sua(int id)
{
using (Web_KTCKEntities db = new Web_KTCKEntities())
{
BAIVIET baiviet = db.BAIVIETs.SingleOrDefault(n => n.IdBV == id);
ViewBag.IdTheLoai = new SelectList(db.THELOAIBAIVIETs.ToList(), "IdTheLoai", "TenTheLoai", baiviet.IdTheLoai);
ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen");
return(View(baiviet));
}
}
public ActionResult ChitietBaiviet(int id)
{
BAIVIET bv = data.BAIVIETs.SingleOrDefault(n => n.IdBV == id);
if (bv == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(bv));
}
public ActionResult Delete(int id)
{
var dal = new BaiVietDAL();
BAIVIET baiviet = dal.Detail(id);
if (baiviet == null)
{
return(HttpNotFound());
}
return(View(baiviet));
}
public ActionResult Edit(BAIVIET bv)
{
try
{
db.Entry(bv).State = EntityState.Modified; // edit dữ liệu dc chọn
db.SaveChanges(); // lưu dữ liệu
return(RedirectToAction("Index", "QuanLyBaiViet")); // trả về controller QuanLyBaiViet với view là Index
}
catch (Exception ex)
{
return(View());
}
}
public ActionResult ChiTiet(int id = 0)
{
BAIVIET baiviet = db.BAIVIETs.SingleOrDefault(n => n.IdBV == id);
baiviet.LuotXem = baiviet.LuotXem + 1;
db.SaveChanges();
if (baiviet == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(baiviet));
}
// POST: Admin/BaiViet/Xoa
public ActionResult Xoa(int id)
{
using (Web_KTCKEntities db = new Web_KTCKEntities())
{
BAIVIET bv = db.BAIVIETs.SingleOrDefault(n => n.IdBV == id);
if (bv != null)
{
db.BAIVIETs.Remove(bv);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
}
public ActionResult Delete(int id)
{
try
{
BAIVIET bv = db.BAIVIETs.Where(x => x.MABV == id).FirstOrDefault(); // show dữ liệu với id được chọn
db.BAIVIETs.Remove(bv); // xóa dữ liệu
db.SaveChanges(); // lưu dữ liệu sau khi xóa
return(RedirectToAction("Index", "QuanLyBaiViet")); // trả về controller QuanLyBaiViet
}
catch
{
return(View());
}
}
public ActionResult ChitietBaivietAdmin(int id)
{
TAIKHOAN tk = (TAIKHOAN)Session["TaikhoanSV"];
ViewBag.Taikhoan = tk.SINHVIEN.TenSV;
BAIVIET bv = data.BAIVIETs.SingleOrDefault(n => n.IdBV == id);
if (bv == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(bv));
}
// GET: Admin/BaiViet/ChiTiet
public ActionResult ChiTiet(int id = 0)
{
using (Web_KTCKEntities db = new Web_KTCKEntities())
{
BAIVIET bv = db.BAIVIETs.SingleOrDefault(n => n.IdBV == id);
if (bv == null)
{
Response.StatusCode = 404;
return(null);
}
ViewBag.IdTheLoai = new SelectList(db.THELOAIBAIVIETs.ToList(), "IdTheLoai", "TenTheLoai");
ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen");
return(View(bv));
}
}
public ActionResult Create(BAIVIET bv)
{
var CurrentCurlture = Session["CurrentCurlture"];
bv.LANGUEGE = CurrentCurlture.ToString();
try
{
db.BAIVIETs.Add(bv); // thêm dữ liệu vào database
db.SaveChanges(); // lưu dữ liệu
return(RedirectToAction("Index", "QuanLyBaiViet")); // trả về controller QuanLyBaiViet
}
catch (Exception ex)
{
return(View());
}
}
public ActionResult Sua(BAIVIET bv)
{
using (Web_KTCKEntities db = new Web_KTCKEntities())
{
BAIVIET baiviet = db.BAIVIETs.SingleOrDefault(n => n.IdBV == bv.IdBV);
if (baiviet != null)
{
baiviet.TieuDe = bv.TieuDe;
baiviet.TomTat = bv.TomTat;
if (bv.NoiDung == null)
{
baiviet.NoiDung = baiviet.NoiDung;
}
else
{
baiviet.NoiDung = bv.NoiDung;
}
if (bv.NgayDang == null)
{
baiviet.NgayDang = baiviet.NgayDang;
}
else
{
baiviet.NgayDang = bv.NgayDang;
}
if (bv.NgayCapNhat == null)
{
baiviet.NgayCapNhat = DateTime.Parse(DateTime.Now.ToString());
}
else
{
baiviet.NgayCapNhat = bv.NgayCapNhat;
}
baiviet.TacGia = bv.TacGia;
baiviet.IdTheLoai = bv.IdTheLoai;
baiviet.Slide = bv.Slide;
baiviet.TrangThai = bv.TrangThai;
baiviet.IdTaiKhoan = bv.IdTaiKhoan;
baiviet.AnhBV = bv.AnhBV;
ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen", baiviet.IdTaiKhoan);
ViewBag.IdTaiKhoan = new SelectList(db.TAIKHOANs.ToList(), "IdTK", "HoTen");
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
}
public ActionResult EditNews(int id, FormCollection collection, HttpPostedFileBase fileupload)
{
ADMIN tk = (ADMIN)Session["TaikhoanSV"];
if (tk == null || String.IsNullOrEmpty(tk.ToString()))
{
return(RedirectToAction("LoginAdminStudent"));
}
else
{
ViewBag.UserName = tk.Username;
ViewBag.Taikhoan = tk.Name;
var count = (from c in data.BAIVIETs select c).Count();
ViewBag.Count = count;
var bv = data.BAIVIETs.First(m => m.IdBV == id);
BAIVIET b = data.BAIVIETs.First(m => m.IdBV == id);
if (fileupload == null)
{
ViewBag.ThongBaoIma = "Vui lòng chọn ảnh !";
return(View());
}
var fileName = Path.GetFileName(fileupload.FileName);
var path = Path.Combine(Server.MapPath("~/images/imagesNews"), fileName);
fileupload.SaveAs(path);
string hinhanh = fileName;
bv.IdBV = b.IdBV;
bv.Id = b.Id;
bv.TieuDe = collection["TieuDe"];
bv.HinhAnh = hinhanh;
bv.TomTat = collection["TomTat"];
bv.NgayViet = DateTime.Parse(collection["NgayViet"]);
bv.ChiTiet = collection["ChiTiet"];
bv.Nguon = collection["Nguon"];
UpdateModel(bv);
data.SubmitChanges();
return(RedirectToAction("ViewNews"));
}
}
public ActionResult Edit(BAIVIET bv)
{
if (ModelState.IsValid)
{
var dal = new BaiVietDAL();
var result = dal.Edit(bv);
if (result)
{
return(RedirectToAction("Index", "BaiViet"));
}
else
{
MsgBox("Cập nhật bài viết thất bại");
}
}
return(View("Index"));
}
public bool Edit(BAIVIET bv)
{
try
{
var baiviet = db.BAIVIETs.Find(bv.IDBaiViet);
baiviet.TieuDe = bv.TieuDe;
baiviet.NoiDung = bv.NoiDung;
baiviet.HinhAnh = bv.HinhAnh;
baiviet.NgayTao = bv.NgayTao;
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
// GET: QLSV
public ActionResult Index()
{
//TinTuc
BAIVIET bv = data.BAIVIETs.FirstOrDefault(n => n.Id == 3);
var tintuc = from t in data.BAIVIETs where t.Id == 3 select t;
ViewBag.TieuDe = bv.TieuDe;
ViewBag.TomTat = bv.TomTat;
ViewBag.IdBv = bv.IdBV;
//ThanhTuu
BAIVIET bv2 = data.BAIVIETs.FirstOrDefault(n => n.Id == 4);
var tintuc2 = from t in data.BAIVIETs where t.Id == 4 select t;
ViewBag.TieuDe2 = bv2.TieuDe;
ViewBag.TomTat2 = bv2.TomTat;
ViewBag.IdBv2 = bv2.IdBV;
//Doingulienket
BAIVIET bv3 = data.BAIVIETs.FirstOrDefault(n => n.Id == 5);
var tintuc3 = from t in data.BAIVIETs where t.Id == 5 select t;
ViewBag.TieuDe3 = bv3.TieuDe;
ViewBag.TomTat3 = bv3.TomTat;
ViewBag.IdBv3 = bv3.IdBV;
//Hotroviechoc
BAIVIET bv4 = data.BAIVIETs.FirstOrDefault(n => n.Id == 6);
var tintuc4 = (from t in data.BAIVIETs where t.Id == 6 select t).Take(7);
ViewBag.TieuDe4 = bv4.TieuDe;
ViewBag.TomTat4 = bv4.TomTat;
ViewBag.IdB4v = bv4.IdBV;
ViewBag.tieude4 = tintuc4.Select(n => n.TieuDe);
ViewBag.Id4 = tintuc4.Select(n => n.IdBV);
return(View(data.BAIVIETs.ToList().OrderBy(n => n.NgayViet)));
}
public List<BAIVIET> LayBaiVietMoiNhat(int SoLuong)
{
List<BAIVIET> list = new List<BAIVIET>();
using (LinQDataContext db = new LinQDataContext())
{
ISingleResult<BAIVIET_LayBaiVietMoiNhatResult> lp = db.BAIVIET_LayBaiVietMoiNhat();
int i = 0;
foreach(BAIVIET_LayBaiVietMoiNhatResult bv in lp)
{
if (i == SoLuong)
{
break;
}
//BAIVIET_LayBaiVietMoiNhatResult bv = temp[i];
BAIVIET var1 = new BAIVIET();
var1.MaBaiViet = bv.MaBaiViet;
var1.TieuDe = bv.TieuDe;
var1.NoiDung = bv.NoiDung;
var1.MaLoaiBaiViet = bv.MaLoaiBaiViet;
var1.NgayDang = bv.NgayDang;
var1.HinhAnh = bv.HinhAnh;
var1.TomTat = bv.TomTat;
if (bv.CapNhat!=null)
var1.CapNhat = (DateTime)bv.CapNhat;
list.Add(var1);
i++;
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public ActionResult PostNews(BAIVIET bv, HttpPostedFileBase fileupload)
{
ADMIN tk = (ADMIN)Session["TaikhoanSV"];
if (tk == null || String.IsNullOrEmpty(tk.ToString()))
{
return(RedirectToAction("LoginAdminStudent"));
}
else
{
ViewBag.UserName = tk.Username;
ViewBag.Taikhoan = tk.Name;
var count = (from c in data.BAIVIETs select c).Count();
ViewBag.Count = count;
ViewBag.Id = new SelectList(data.DANHMUCs.ToList().OrderBy(n => n.Id), "Id", "TenDM");
if (fileupload == null)
{
ViewBag.ThongBaoIma = "Vui lòng chọn ảnh !";
return(View());
}
if (ModelState.IsValid)
{
var fileName = Path.GetFileName(fileupload.FileName);
var path = Path.Combine(Server.MapPath("~/images/imagesNews"), fileName);
fileupload.SaveAs(path);
bv.HinhAnh = fileName;
data.BAIVIETs.InsertOnSubmit(bv);
data.SubmitChanges();
}
return(RedirectToAction("IAdminITU"));
}
}
public ActionResult ThemBaiViet(HttpPostedFileBase file, BAIVIET bv)
{
if (ModelState.IsValid)
{
if (file != null)
{
if (file.ContentLength > 0)
{
string filename = Path.GetFileName(file.FileName);
/*Saving the file in server folder*/
//Xử lý upload trùng tên
var FullPath = Request.MapPath("~/Images/BaiViet/" + filename);
if (System.IO.File.Exists(FullPath))
{
filename = "1_" + filename;
}
//upload
file.SaveAs(Server.MapPath("~/Images/BaiViet/" + filename));
bv.HinhAnh = filename;
}
else
{
bv.HinhAnh = "BaiViet_Default.jpg";
}
}
else
{
bv.HinhAnh = "default.jpg";
}
bv.TrangThai = true;
bv.NgayViet = DateTime.Now;
bv.NgayDang = DateTime.Now;
db.BAIVIETs.Add(bv);
db.SaveChanges();
}
return(View());
}
public int CapNhat(BAIVIET lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
db.BAIVIET_update(
lpDTO.MaBaiViet,
lpDTO.TieuDe,
lpDTO.NoiDung,
lpDTO.MaLoaiBaiViet,
lpDTO.NgayDang, lpDTO.CapNhat,
lpDTO.HinhAnh,
lpDTO.TomTat, lpDTO.TinNoiBat
);
db.SubmitChanges();
return 0;
}
catch (Exception ex)
{
throw (ex);
}
}
public ActionResult Create(BAIVIET model)
{
if (ModelState.IsValid)
{
var dal = new BaiVietDAL();
var baiviet = new BAIVIET();
baiviet.TieuDe = model.TieuDe;
baiviet.NoiDung = model.NoiDung;
baiviet.HinhAnh = model.HinhAnh;
baiviet.NgayTao = DateTime.Now;
var result = dal.Insert(baiviet);
if (result > 0)
{
MsgBox("Thêm bài viết thành công");
}
else
{
MsgBox("Thêm bài viết thất bại");
}
// return RedirectToAction("Index", "BaiViet");
}
return(View());
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
try
{
//lay thong tin tu textbox
BAIVIET lpDTO = new BAIVIET();
lpDTO.MaBaiViet = int.Parse(Request.QueryString["id"]);
lpDTO.MaLoaiBaiViet = int.Parse(ddlLoaiBaiViet.SelectedValue);
lpDTO.NgayDang = Convert.ToDateTime(lblNgayDang.Text);
lpDTO.CapNhat = Convert.ToDateTime(System.DateTime.Now);
lpDTO.NoiDung = this.txtnoidung.Value;
lpDTO.TieuDe = this.txttieude.Text;
lpDTO.TomTat = this.txtTomTat.Text;
BaiVietTemp = (BAIVIET)Session["BaiVietTemp"];
BUSBaiViet BUSBaiViet = new BUSBaiViet();
if (this.fulImage.HasFile)
{
// if (BaiVietTemp.HinhAnh != null && BaiVietTemp.HinhAnh != "")
// System.IO.File.Delete(Server.MapPath("~/Uploads/") + BaiVietTemp.HinhAnh);
String currentPath = Server.MapPath("~/Uploads/");
String tempPath = Server.MapPath("~/Temp/");
String fileName = "anh_dai_dien" + lpDTO.NgayDang.Value.Day.ToString()
+ lpDTO.NgayDang.Value.Month.ToString() + lpDTO.NgayDang.Value.Year.ToString()
+ lpDTO.NgayDang.Value.Hour.ToString() + lpDTO.NgayDang.Value.Minute.ToString() + lpDTO.NgayDang.Value.Second.ToString() + ".jpg";
lpDTO.HinhAnh = fileName;
this.fulImage.SaveAs(tempPath + fileName);
SaveImageThumbnail(tempPath + fileName, currentPath + fileName, true);
}
else
{
lpDTO.HinhAnh = BaiVietTemp.HinhAnh;
}
//Goi ham cap nhat
if (BUSBaiViet.CapNhat(lpDTO) == 0)
{
//Thong bao
lbThongBao.Text = "Cập Nhật Thành Công";
// //Upload tập tin
// List<TAPTINBAIVIET> lTapTinDTO = new List<TAPTINBAIVIET>();
// string savePath = Server.MapPath("~/Uploads\\");
//
// //string fileName;
// lTapTinDTO = (List<TAPTINBAIVIET>)Session["FileUploadTemp"];
// List<HttpPostedFile> lFile = (List<HttpPostedFile>)Session["FileClientTemp"];
// BUSTapTinBaiViet BUSTapTinBaiViet = new BUSTapTinBaiViet();
// for (int i = 0; i < lTapTinDTO.Count && i < lFile.Count; i++)
// {
// lFile[i].SaveAs(savePath + lTapTinDTO[i].TenTapTin);
// if (BUSTapTinBaiViet.Them(lTapTinDTO[i]) == 0)
// {
// MessageBox.Show("Upload tập tin " + lTapTinDTO[i].TenTapTin + " thất bại.");
//
// }
// }
lbThongBao.Visible = true;
Response.Redirect("~/administration/BaiViet.aspx?id=" + lpDTO.MaBaiViet.ToString());
}
else
{
lbThongBao.Text = "Cập Nhật Không Thành Công";
lbThongBao.Visible = true;
}
}
catch
{
lbThongBao.Text = "Cập nhật Không Thành Công";
lbThongBao.Visible = true;
}
}
protected void btnThem_Click(object sender, EventArgs e)
{
//txtngaydang.Text = DateTime.Now.ToShortDateString();
try
{
//lay thong tin tu textbox
BAIVIET lpDTO = new BAIVIET();
lpDTO.MaLoaiBaiViet = int.Parse(ddlLoaiBaiViet.SelectedValue);
lpDTO.NgayDang = Convert.ToDateTime(System.DateTime.Now);
lpDTO.NoiDung = this.txtnoidung.Value;
lpDTO.TieuDe = this.txttieude.Text;
//Nhi sửa: thêm phần tóm tắt bài viết 11/8/2010
lpDTO.TomTat = this.txtTomTat.Text;
if (this.fulImage.HasFile)
{
String currentPath = Server.MapPath("~/Uploads/");
String tempPath = Server.MapPath("~/Temp/");
String fileName = "anh_dai_dien" + lpDTO.NgayDang.Value.Day.ToString()
+ lpDTO.NgayDang.Value.Month.ToString() + lpDTO.NgayDang.Value.Year.ToString()
+ lpDTO.NgayDang.Value.Hour.ToString() + lpDTO.NgayDang.Value.Minute.ToString() + lpDTO.NgayDang.Value.Second.ToString() + ".jpg";
lpDTO.HinhAnh = fileName;
this.fulImage.SaveAs(tempPath + fileName);
SaveImageThumbnail(tempPath + fileName, currentPath + fileName, true);
}
//Goi ham cap nhat
BUSBaiViet BUSBaiViet = new BUSBaiViet();
if (BUSBaiViet.Them(lpDTO) == 1)
{
//Thong bao
lbThongBao.Text = "Thêm Thành Công";
lbThongBao.Visible = true;
Response.Redirect("BaiViet.aspx");
}
else
{
lbThongBao.Text = "Thêm Không Thành Công";
lbThongBao.Visible = true;
}
}
catch
{
lbThongBao.Text = "Thêm Không Thành Công";
lbThongBao.Visible = true;
}
}
protected void load()
{
//Thong tin nguoi dung
if (!IsPostBack)
{
if (Request.QueryString["id"] != null)
{
//lay ma
int mabaiviet = int.Parse(Request.QueryString["id"]);
BUSBaiViet BUSBaiViet = new BUSBaiViet();
BAIVIET lpDTO = BUSBaiViet.TimKiem(mabaiviet);
BaiVietTemp = lpDTO;
Session.Add("BaiVietTemp", BaiVietTemp);
BUSChuyenMuc BUSChuyenMuc = new BUSChuyenMuc();
CHUYENMUC cmDTO = BUSChuyenMuc.LayChuyenMucTheoBaiViet((int)lpDTO.MaLoaiBaiViet);
//this.txtngaydang.Text = dt.ToString("dd/MM/yyyy");
this.txtnoidung.Value = lpDTO.NoiDung;
this.txtTomTat.Text = lpDTO.TomTat;
this.txttieude.Text = lpDTO.TieuDe;
this.lblNgayDang.Text = lpDTO.NgayDang.ToString();
this.lblNgayCapNhat.Text = lpDTO.CapNhat.ToString();
if (lpDTO.HinhAnh != "")
{
this.imgAnhDaiDien.ImageUrl = @"~\Uploads/" + lpDTO.HinhAnh;
}
// load ddl
load_ddlChuyenMuc();
ddlChuyenMuc.SelectedValue = cmDTO.MaChuyenMuc.ToString();
load_ddlLBV(cmDTO.MaChuyenMuc);
ddlLoaiBaiViet.SelectedValue = lpDTO.MaLoaiBaiViet.ToString();
int soDong = LoadTapTin();
FilterSTT(soDong, 0, 30);
PanelBtnUpload.Visible = true;
}
else
{
load_ddlChuyenMuc();
ddlChuyenMuc.SelectedValue = "1";
load_ddlLBV(1);
PanelBtnUpload.Visible = false;
}
}
}
protected void GridViewBaiViet_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "XoaBaiViet")
{
List<BAIVIET> lt = new List<BAIVIET>();
BUSBaiViet busBaiViet = new BUSBaiViet();
lt = busBaiViet.SelectBAIVIETsAll();
//Anh Vu
//kiem tra xem co phai admin hoac tac gia bai viet thi cho xoa
//
if (((NGUOIDUNG)Session["LOGIN"]) != null)
{
if (((NGUOIDUNG)Session["LOGIN"]).MaVaiTro == 4)
{
int idBV = Convert.ToInt32(e.CommandArgument);
XoaBaiViet(idBV);
}
else
{
BAIVIET baiviet = new BAIVIET();
BUSBaiViet bviet = new BUSBaiViet();
int idBV = Convert.ToInt32(e.CommandArgument);
baiviet = bviet.TimKiemTheoMa(idBV);
if (((NGUOIDUNG)Session["LOGIN"]).MaNguoiDung == baiviet.MaNguoiDang)
{
XoaBaiViet(idBV);
}
else
{
ThongBao.Text = "<h1>Không xoá được vì bạn không phải admin hoặc tác giả bài viết !!!</h1>";
}
}
}
}
}
public List<BAIVIET> LayBaiVietMoiNhatTheoChuyenMuc(int MaChuyenMuc)
{
List<BAIVIET> list = new List<BAIVIET>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<BAIVIET_LayTopBaiVietMoiNhatTheoChuyenMucResult> lp = db.BAIVIET_LayTopBaiVietMoiNhatTheoChuyenMuc(MaChuyenMuc);
foreach (BAIVIET_LayTopBaiVietMoiNhatTheoChuyenMucResult bv in lp)
{
//BAIVIET_LayBaiVietMoiNhatResult bv = temp[i];
BAIVIET var1 = new BAIVIET();
var1.MaBaiViet = bv.MaBaiViet;
var1.TieuDe = bv.TieuDe;
var1.NoiDung = bv.NoiDung;
var1.MaLoaiBaiViet = bv.MaLoaiBaiViet;
var1.NgayDang = bv.NgayDang;
var1.HinhAnh = bv.HinhAnh;
var1.TomTat = bv.TomTat;
if (bv.CapNhat != null)
var1.CapNhat = (DateTime)bv.CapNhat;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
if (list.Count > 0)
return list;
else
return null;
}
public int Insert(BAIVIET bv)
{
db.BAIVIETs.Add(bv);
db.SaveChanges();
return(bv.IDBaiViet);
}
public int Them(BAIVIET lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
db.BAIVIET_add(
lpDTO.TieuDe,
lpDTO.NoiDung,
lpDTO.MaLoaiBaiViet,
lpDTO.NgayDang,
lpDTO.HinhAnh,
lpDTO.TomTat, lpDTO.MaNguoiDang, lpDTO.TinNoiBat
);
return 1;
}
catch
{
return 0;
}
}
public List<BAIVIET> SelectBAIVIETsAll()
{
List<BAIVIET> list = new List<BAIVIET>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<BAIVIET_getallResult> lp = db.BAIVIET_getall();
foreach (BAIVIET_getallResult BAIVIET in lp)
{
BAIVIET var1 = new BAIVIET();
var1.MaBaiViet = BAIVIET.MaBaiViet;
var1.TieuDe = BAIVIET.TieuDe;
var1.NoiDung = BAIVIET.NoiDung;
var1.MaLoaiBaiViet = BAIVIET.MaLoaiBaiViet;
var1.NgayDang = BAIVIET.NgayDang;
var1.HinhAnh = BAIVIET.HinhAnh;
var1.TomTat = BAIVIET.TieuDe;
if (BAIVIET.CapNhat != null)
var1.CapNhat = (DateTime)BAIVIET.CapNhat;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public int Them(BAIVIET lpDTO)
{
DAOBaiViet BAIVIET = new DAOBaiViet();
return BAIVIET.Them(lpDTO);
}
public int CapNhat(BAIVIET lpDTO)
{
DAOBaiViet BAIVIET = new DAOBaiViet();
return BAIVIET.CapNhat(lpDTO);
}
