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 { } }