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;
}
protected void btnThem_Click(object sender, EventArgs e)
{
try
{
//lay thong tin tu textbox
TAPTINBAIVIET lpDTO = new TAPTINBAIVIET();
lpDTO.MaTapTin = int.Parse(this.txtmataptin.Text);
lpDTO.TenTapTin = this.txttentaptin.Text;
lpDTO.MaBaiViet = int.Parse(this.txtmabaiviet.Text);
lpDTO.DuongDan = this.txtduongdan.Text;
//Goi ham cap nhat
BUSTapTinBaiViet BUSTapTinBaiViet = new BUSTapTinBaiViet();
if (BUSTapTinBaiViet.Them(lpDTO) == 0)
{
//Thong bao
lbThongBao.Text = "Thêm Thành Công";
lbThongBao.Visible = true;
//Response.Redirect("LoaiMatHang.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 GridViewTAPTINBAIVIET_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "XoaFile")
{
// Convert the row index stored in the CommandArgument
// property to an Integer.
int index = Convert.ToInt32(e.CommandArgument);
List<TAPTINBAIVIET> lt = new List<TAPTINBAIVIET>();
BUSTapTinBaiViet BUSTapTinBaiViet = new BUSTapTinBaiViet();
lt = BUSTapTinBaiViet.getLichLamViec();
XoaFile_Click(lt[index].TenTapTin);
}
}
//Load
public int LoadTapTin()
{
List<TAPTINBAIVIET> lt = new List<TAPTINBAIVIET>();
BUSTapTinBaiViet BUSTapTinBaiViet = new BUSTapTinBaiViet();
lt = BUSTapTinBaiViet.SelectTAPTINBAIVIETsAll();
if (lt.Count > 0)
{
this.GridViewTapTin.DataSource = lt;
GridViewTapTin.DataBind();
PanelDanhSach.Visible = true;
PanelMessage.Visible = false;
return lt.Count;
}
else
{
PanelDanhSach.Visible = false;
PanelMessage.Visible = true;
return 0;
}
}
protected void LoadBaiViet()
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("default.aspx");
}
else
{
BUSBaiViet BaiVietBUS = new BUSBaiViet();
int MaBaiViet = int.Parse(Request.QueryString["id"]);
BAIVIET BaiViet = BaiVietBUS.TimKiem(MaBaiViet);
lblNoiDungBaiViet.Text = BaiViet.NoiDung;
lblTieuDe.Text = BaiViet.TieuDe;
lblTieuDe.Font.Bold = true;
lblTieuDe.Font.Size = 18;
if (BaiViet.NgayDang != null)
{
lblNgayDang.Text = "Ngày đăng: " + BaiViet.NgayDang.Value.Day + "/" + BaiViet.NgayDang.Value.Month + "/" + BaiViet.NgayDang.Value.Year;
lblNgayDang.Font.Italic = true;
}
else
lblNgayDang.Visible = false;
BUSTapTinBaiViet busTapTinBaiViet = new BUSTapTinBaiViet();
List<TAPTINBAIVIET> DStapTinBaiViet = busTapTinBaiViet.TimKiemMaBaiViet(MaBaiViet);
if (DStapTinBaiViet != null)
{
foreach(TAPTINBAIVIET ttbv in DStapTinBaiViet)
{
System.Web.UI.WebControls.MenuItem item = new System.Web.UI.WebControls.MenuItem("-" + ttbv.TenTapTin);
item.NavigateUrl = ttbv.DuongDan;
hplDownloadLink.Items.Add(item);
}
}
}
}
protected void XoaTapTin(int maTapTin)
{
try
{
//xac nhan truoc khi xoa
BUSTapTinBaiViet bus = new BUSTapTinBaiViet();
TAPTINBAIVIET ttbv = bus.TimKiemMaTapTin(maTapTin);
XoaFile(ttbv.DuongDan);
if (bus.Xoa(maTapTin) == 0)
{
//Thong bao
Response.Redirect("TapTinBaiViet.aspx");
}
}
catch
{
}
}
void SaveFile(HttpPostedFile file)
{
//Duong dan den thu muc Uploads tren server
string savePath = Server.MapPath("~/Uploads\\TapTin");
// Ten file upload
string fileName = FileUploadTapTin.FileName;
// Tao duong dan de kiem tra xem file da ton tai chua
string pathToCheck = savePath + Path.DirectorySeparatorChar+ fileName;
string tempfileName = fileName;
//bool overwrite = false;
// Kiem tra xem da ton tai file co ten giong voi file nguoi dung muon up chua
if (System.IO.File.Exists(pathToCheck))
{
LabelUploadStatus.Text = "Tập tin trùng với tập tin đã có trên csdl";
}
else
{
file.SaveAs(savePath+ Path.DirectorySeparatorChar +fileName);
// Thong bao la da upload thanh cong
TAPTINBAIVIET ttbvDTO = new TAPTINBAIVIET();
ttbvDTO.TenTapTin = fileName;
string linkDir = "~/Uploads/TapTin/" + fileName;
ttbvDTO.DuongDan = linkDir;
ttbvDTO.MaBaiViet = int.Parse(Request.QueryString["id"]);
BUSTapTinBaiViet bus = new BUSTapTinBaiViet();
bus.Them(ttbvDTO);
List<TAPTINBAIVIET> gvTapTinDS = bus.TimKiemMaBaiViet(int.Parse(Request.QueryString["id"]));
// gvTapTinDS.Add(ttbvDTO);
this.GridViewTapTin.DataSource = gvTapTinDS;
this.GridViewTapTin.DataBind();
FilterSTT(gvTapTinDS.Count, 0, 30);
((List<TAPTINBAIVIET>)Session["FileUploadTemp"]).Add(ttbvDTO);
((List<HttpPostedFile>)Session["FileClientTemp"]).Add(file);
}
}
protected void GridViewTapTin_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "XoaTapTin")
{
int idBV = Convert.ToInt32(e.CommandArgument);
//List<BAIVIET> lt = new List<BAIVIET>();
//BUSBaiViet busBaiViet = new BUSBaiViet();
//lt = busBaiViet.SelectBAIVIETsAll();
BUSTapTinBaiViet bus = new BUSTapTinBaiViet();
bus.Xoa(idBV);
List<TAPTINBAIVIET> gvTapTinDS = bus.TimKiemMaBaiViet(int.Parse(Request.QueryString["id"]));
// gvTapTinDS.Add(ttbvDTO);
this.GridViewTapTin.DataSource = gvTapTinDS;
this.GridViewTapTin.DataBind();
FilterSTT(gvTapTinDS.Count, 0, 30);
}
}
void SaveFile(HttpPostedFile file)
{
//Duong dan den thu muc Uploads tren server
string savePath = Server.MapPath("Uploads\\");
// Ten file upload
string fileName = FileUploadHinhAnh.FileName;
// Tao duong dan de kiem tra xem file da ton tai chua
string pathToCheck = savePath + fileName;
string tempfileName = fileName;
bool overwrite = false;
// Kiem tra xem da ton tai file co ten giong voi file nguoi dung muon up chua
if (System.IO.File.Exists(pathToCheck))
{
int counter = 2;
while (System.IO.File.Exists(pathToCheck))
{
DialogResult result;
string message = "Tên file " + tempfileName + " đã tồn tại. Bạn có muốn ghi đè lên không?";
result = MessageBox.Show(message, "Caution", MessageBoxButtons.YesNo);
if (result == DialogResult.No)
{
// them (so) vao sau ten file
int point = fileName.LastIndexOf('.');
string nameNumber = "(" + counter.ToString() + ")";
tempfileName = fileName.Insert(point, nameNumber);
pathToCheck = savePath + tempfileName;
counter++;
}
else
{
overwrite = true;
LabelUploadStatus.Text = "File của bạn đã được ghi đè thành công.";
break;
}
}
fileName = tempfileName;
if (counter > 2)
LabelUploadStatus.Text = "File của bạn đã được ghi dưới tên: " + fileName;
}
else
{
// Thong bao la da upload thanh cong
LabelUploadStatus.Text = "File của bạn đã được ghi thành công.";
}
savePath += fileName;
//Luu file
FileUploadHinhAnh.SaveAs(savePath);
//Duong dan de tai file
string linkDir = "~/Uploads/" + fileName;
//Them vao bang TapTin
//id la tham so truyen vao url, la id cua bai viet lien quan den tap tin
if (Request.QueryString["id"] != null)
{
if (overwrite == false)
{
int maBaiViet = int.Parse(Request.QueryString["id"]);
BUSTapTinBaiViet busTapTin = new BUSTapTinBaiViet();
int numberTapTin = busTapTin.TimSoLuongTapTin();
TAPTINBAIVIET lpDTO = new TAPTINBAIVIET();
lpDTO.TenTapTin = fileName;
lpDTO.DuongDan = linkDir;
lpDTO.MaBaiViet = maBaiViet;
lpDTO.MaTapTin = numberTapTin + 1;
busTapTin.Them(lpDTO);
}
else
{
int maBaiViet = int.Parse(Request.QueryString["id"]);
BUSTapTinBaiViet busTapTin = new BUSTapTinBaiViet();
TAPTINBAIVIET lpDTO = busTapTin.TimKiemTenTapTin(fileName);
lpDTO.MaBaiViet = maBaiViet;
busTapTin.CapNhat(lpDTO);
}
}
}
protected void XoaChuyenMuc(int maChuyenMuc)
{
try
{
//xac nhan truoc khi xoa
BUSBaiViet busBaiViet = new BUSBaiViet();
List<BAIVIET> lstBaiViet = busBaiViet.LayDSBaiVietTheoChuyenMuc(maChuyenMuc);
if (lstBaiViet != null)
{
foreach (BAIVIET bv in lstBaiViet)
{
BUSTapTinBaiViet busTapTin = new BUSTapTinBaiViet();
List<TAPTINBAIVIET> lstTapTin = busTapTin.TimKiemMaBaiViet(bv.MaBaiViet);
if (lstTapTin != null)
{
foreach (TAPTINBAIVIET taptin in lstTapTin)
{
busTapTin.Xoa(taptin.MaTapTin);
}
}
busBaiViet.Xoa(bv.MaBaiViet);
}
}
BUSChuyenMuc busChuyenMuc = new BUSChuyenMuc();
if (busChuyenMuc.Xoa(maChuyenMuc) == 0)
{
//Thong bao
Response.Redirect("ChuyenMuc.aspx");
}
}
catch
{
}
}
protected void XoaFile_Click(string tenTapTin)
{
DialogResult rs = MessageBox.Show("Bạn có chắc là muốn xoá lịch làm việc " + tenTapTin + " không?", "Warning!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (rs == DialogResult.Yes)
{
//Goi ham xoa
BUSTapTinBaiViet busTapTinBaiViet = new BUSTapTinBaiViet();
TAPTINBAIVIET ttbv = busTapTinBaiViet.TimKiemTenTapTin(tenTapTin);
XoaFile(ttbv.DuongDan);
busTapTinBaiViet.Xoa(ttbv.MaTapTin);
Response.Redirect("LichLamViec.aspx");
}
else
{
Response.Redirect("LichLamViec.aspx");
}
}
protected void btnXoa_Click(object sender, EventArgs e)
{
try
{
//lay thong tin tu textbox
int mataptin = int.Parse(Request.QueryString["id"]);
//xac nhan truoc khi xoa
BUSTapTinBaiViet BUSTapTinBaiViet = new BUSTapTinBaiViet();
if (BUSTapTinBaiViet.Xoa(mataptin) == 0)
{
//Thong bao
lbThongBao.Text = "Xóa Thành Công";
lbThongBao.Visible = true;
Response.Redirect("TapTinBaiViet.aspx");
}
}
catch
{
lbThongBao.Text = "Xoa Không Thành Công";
lbThongBao.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Thong tin nguoi dung
NGUOIDUNG a = new NGUOIDUNG();
a.MaNguoiDung = 1;
Session["NGUOIDUNG"] = a;
if (Request.QueryString["id"] != null)
{
//lay ma
int mataptin = int.Parse(Request.QueryString["id"]);
//lay thong tin va load len cac textbox
BUSTapTinBaiViet BUSTapTinBaiViet = new BUSTapTinBaiViet();
TAPTINBAIVIET lpDTO = BUSTapTinBaiViet.TimKiemMaTapTin(mataptin);
this.txtmataptin.Text = Convert.ToString(lpDTO.MaTapTin );
this.txttentaptin.Text = lpDTO.TenTapTin ;
this.txtmabaiviet.Text = Convert.ToString(lpDTO.MaBaiViet );
this.txtduongdan.Text = lpDTO.DuongDan ;
}
}
protected void btnXoa_Click(object sender, EventArgs e)
{
try
{
//lay thong tin tu textbox
int machuyenmuc = int.Parse(Request.QueryString["id"]);
BUSBaiViet busBaiViet = new BUSBaiViet();
List<BAIVIET> lstBaiViet = busBaiViet.LayDSBaiVietTheoChuyenMuc(machuyenmuc);
if (lstBaiViet != null)
{
foreach (BAIVIET bv in lstBaiViet)
{
BUSTapTinBaiViet busTapTin = new BUSTapTinBaiViet();
List<TAPTINBAIVIET> lstTapTin = busTapTin.TimKiemMaBaiViet(bv.MaBaiViet);
if (lstTapTin != null)
{
foreach (TAPTINBAIVIET taptin in lstTapTin)
{
busTapTin.Xoa(taptin.MaTapTin);
}
}
busBaiViet.Xoa(bv.MaBaiViet);
}
}
//xac nhan truoc khi xoa
//Goi ham xoa
BUSChuyenMuc BUSChuyenMuc = new BUSChuyenMuc();
if (BUSChuyenMuc.Xoa(machuyenmuc) == 0)
{
//Thong bao
lbThongBao.Text = "Xóa Thành Công";
lbThongBao.Visible = true;
Response.Redirect("HoatDong.aspx");
}
}
catch
{
lbThongBao.Text = "Xoa Không Thành Công";
lbThongBao.Visible = true;
}
}
protected void XoaBai(int maloai)
{
try
{
//xac nhan truoc khi xoa
BUSBaiViet busBaiViet = new BUSBaiViet();
List<BAIVIET> lstBaiViet = busBaiViet.TimKiemTheoLoaiBaiViet(maloai);
if (lstBaiViet != null)
{
foreach (BAIVIET bv in lstBaiViet)
{
BUSTapTinBaiViet busTapTin = new BUSTapTinBaiViet();
List<TAPTINBAIVIET> lstTapTin = busTapTin.TimKiemMaBaiViet(bv.MaBaiViet);
if (lstTapTin != null)
{
foreach (TAPTINBAIVIET taptin in lstTapTin)
{
busTapTin.Xoa(taptin.MaTapTin);
}
}
busBaiViet.Xoa(bv.MaBaiViet);
}
}
BUSLoaiBaiViet bus = new BUSLoaiBaiViet();
if (bus.Xoa(maloai) == 0)
{
//Thong bao
Response.Redirect("LoaiBaiViet.aspx");
}
}
catch
{
}
}