protected void btExport_Click(object sender, EventArgs e) { BUSHoatDong bushoatdong = new BUSHoatDong(); HOATDONG hoatdong = bushoatdong.TimKiem(int.Parse(Request.QueryString["id"])); fileSave = "Chi_Tiet_Dang_Ky_Hoat_Dong_" + hoatdong.TenHoatDong + ".xls"; ExportToExcel(); Response.Redirect("~\\Download\\" + fileSave); }
protected void ddlMaHoatDong_SelectedIndexChanged(object sender, EventArgs e) { BUSHoatDong bushoatdong = new BUSHoatDong(); HOATDONG hoatdong = bushoatdong.TimKiem(int.Parse(ddlMaHoatDong.SelectedValue)); txtTenHoatDong.Text = hoatdong.TenHoatDong; ddlLoaiHoatDong.Text = hoatdong.MaLoaiHoatDong.ToString(); txtNgayDienRa.Text = hoatdong.NgayDienRa.Value.Day + "/" + hoatdong.NgayDienRa.Value.Month + "/" + hoatdong.NgayDienRa.Value.Year; txtThoiGianBatDauDK.Text = hoatdong.ThoiGianBatDauDangKy.Value.Day + "/" + hoatdong.ThoiGianBatDauDangKy.Value.Month + "/" + hoatdong.ThoiGianBatDauDangKy.Value.Year; txtThoiGianKetThucDK.Text = hoatdong.ThoiGianKetThucDangKy.Value.Day + "/" + hoatdong.ThoiGianKetThucDangKy.Value.Month + "/" + hoatdong.ThoiGianKetThucDangKy.Value.Year; }
protected void WriteTitle(ExcelCOM.Worksheet worksheet) { BUSHoatDong bushoatdong = new BUSHoatDong(); HOATDONG hoatdong = bushoatdong.TimKiem(int.Parse(Request.QueryString["id"])); ExcelCOM.Range sheetTitle = (ExcelCOM.Range)worksheet.get_Range("A1", "D1"); sheetTitle.MergeCells = true; sheetTitle.Value2 = "Chi Tiết Đăng Ký Hoạt Động " + hoatdong.TenHoatDong; sheetTitle.Font.Bold = true; sheetTitle.Font.Size = 20; sheetTitle.HorizontalAlignment = ExcelCOM.XlHAlign.xlHAlignCenter; sheetTitle.Rows.AutoFit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(sheetTitle); for (int i = 0; i < GridViewDangKyHoatDong.Columns.Count; i++) { WriteIndexColumn(worksheet, 3, i + 1, GridViewDangKyHoatDong.Columns[i].ToString()); } }
protected void LoadHoatDong() { //lay ma int mahoatdong = int.Parse(Request.QueryString["id"]); //lay thong tin va load len cac textbox BUSHoatDong BUSHoatDong = new BUSHoatDong(); HOATDONG lpDTO = BUSHoatDong.TimKiem(mahoatdong); txttenhoatdong.Text = lpDTO.TenHoatDong; ddlLoaiHoatDong.SelectedValue = lpDTO.MaLoaiHoatDong.ToString(); txtngaydienra.Text = ((DateTime)lpDTO.NgayDienRa).ToString("dd/MM/yyyy"); txtthoigianbatdaudangky.Text = ((DateTime)lpDTO.ThoiGianBatDauDangKy).ToString("dd/MM/yyyy"); txtthoigianketthucdangky.Text = ((DateTime)lpDTO.ThoiGianKetThucDangKy).ToString("dd/MM/yyyy"); if (lpDTO.HinhAnh == "") { link = ""; image.Visible = false; } else { if (lpDTO.HinhAnh != "") { link = defaultLink + lpDTO.HinhAnh; image.ImageUrl = link; image.Visible = true; } } }
protected void btnXoa_Click(object sender, EventArgs e) { try { //lay thong tin tu textbox int mahoatdong = int.Parse(Request.QueryString["id"]); BUSHoatDong BUSHoatDong = new BUSHoatDong(); HOATDONG hoatdong = BUSHoatDong.TimKiem(mahoatdong); //xac nhan truoc khi xoa //Goi ham xoa BUSDangKyHoatDong BUSDangKyHoatDong = new BUSDangKyHoatDong(); BUSDangKyHoatDong.Xoa(mahoatdong); if (BUSHoatDong.Xoa(mahoatdong) == 0) { //Thong bao lbThongBao.Text = "Xóa Thành Công"; lbThongBao.Visible = true; DeleteHinhAnh(link); link = ""; Response.Redirect("~/administration/HoatDong.aspx"); } else { lbThongBao.Text = "Xóa Không Thành Công"; lbThongBao.Visible = true; } } catch { lbThongBao.Text = "Xóa Không Thành Công"; lbThongBao.Visible = true; } }