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