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;
}
public void LoadImage()
{
BUSLoaiHoatDong busLoaiHD = new BUSLoaiHoatDong();
LOAIHOATDONG aLoaiHD = busLoaiHD.TimKiem("Hoạt động nổi bật");
if (aLoaiHD != null)
{
BUSHoatDong busHD = new BUSHoatDong();
List<HOATDONG> dsHDNoiBat = busHD.LayHoatDongTheoLoai(aLoaiHD.MaLoaiHoatDong);
if (dsHDNoiBat.Count > 0)
{
imgMain.ImageUrl = "~/Uploads/HinhAnhHoatDong/" + dsHDNoiBat[0].HinhAnh;
imgMain.AlternateText = "Không tìm thấy hình ảnh";
imgMain.PostBackUrl = "~/ChiTietHoatDong.aspx?id=" + dsHDNoiBat[0].MaHoatDong;
}
}
}
protected void btCapNhat_Click(object sender, EventArgs e)
{
if (KiemTra() == false)
{
txtThongTin.Text = "Thời gian không hợp lệ";
return;
}
HOATDONG hoatdong = new HOATDONG();
hoatdong.MaHoatDong = int.Parse(ddlMaHoatDong.SelectedValue);
hoatdong.TenHoatDong = txtTenHoatDong.Text;
hoatdong.MaLoaiHoatDong = int.Parse(ddlMaHoatDong.SelectedValue);
hoatdong.NgayDienRa = new DateTime(int.Parse(txtNgayDienRa.Text.Substring(6, 4)), int.Parse(txtNgayDienRa.Text.Substring(3, 2)), int.Parse(txtNgayDienRa.Text.Substring(0, 2)));
hoatdong.ThoiGianBatDauDangKy = new DateTime(int.Parse(txtThoiGianBatDauDK.Text.Substring(6, 4)), int.Parse(txtThoiGianBatDauDK.Text.Substring(3, 2)), int.Parse(txtThoiGianBatDauDK.Text.Substring(0, 2)));
hoatdong.ThoiGianKetThucDangKy = new DateTime(int.Parse(txtThoiGianKetThucDK.Text.Substring(6, 4)), int.Parse(txtThoiGianKetThucDK.Text.Substring(3, 2)), int.Parse(txtThoiGianKetThucDK.Text.Substring(0, 2)));
BUSHoatDong bushoatdong = new BUSHoatDong();
bushoatdong.CapNhat(hoatdong);
}
//Load
public int LoadHoatDong()
{
List<HOATDONG> lt = new List<HOATDONG>();
BUSHoatDong BUSHoatDong = new BUSHoatDong();
lt = BUSHoatDong.SelectHOATDONGsAll();
if (lt.Count > 0)
{
this.GridViewHoatDong.DataSource = lt;
GridViewHoatDong.DataBind();
PanelDanhSach.Visible = true;
PanelMessage.Visible = false;
return lt.Count;
}
else
{
PanelDanhSach.Visible = false;
PanelMessage.Visible = true;
return 0;
}
}
protected void ddlLoaiHoatDong_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlLoaiHoatDong.SelectedIndex != -1)
{
int iMaLoai = int.Parse(ddlLoaiHoatDong.SelectedValue);
BUSLoaiHoatDong busLoaiHD = new BUSLoaiHoatDong();
LOAIHOATDONG LoaiTatCa = busLoaiHD.TimKiem("Tất Cả");
if (LoaiTatCa != null && iMaLoai == LoaiTatCa.MaLoaiHoatDong)
{
int soDong = LoadHoatDong();
FilterSTT(soDong, 0, int.Parse(DropDownListPaging.SelectedValue));
}
else
{
//Lấy hoạt động theo mã loại
BUSHoatDong busHoatDong = new BUSHoatDong();
List<HOATDONG> dsHoatDong = busHoatDong.LayHoatDongTheoLoai(iMaLoai);
GridViewHoatDong.DataSource = dsHoatDong;
GridViewHoatDong.AutoGenerateColumns = false;
GridViewHoatDong.DataBind();
this.FilterSTT(dsHoatDong.Count, GridViewHoatDong.PageIndex, int.Parse(DropDownListPaging.SelectedValue));
}
}
}
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 Page_Load(object sender, EventArgs e)
{
//Thong tin nguoi dung
BUSHoatDong HoatDongBUS = new BUSHoatDong();
List<HOATDONG> DSHoatDong = HoatDongBUS.SelectHOATDONGsAll();
drlHoatDong.DataSource = DSHoatDong;
drlHoatDong.DataTextField = "TenHoatDong";
drlHoatDong.DataValueField = "MaHoatDong";
drlHoatDong.DataBind();
if (Request.QueryString["id"] != null)
{
//lay ma
int mahoatdong = int.Parse(Request.QueryString["id"]);
//lay thong tin va load len cac textbox
BUSThongBao BUSThongBao = new BUSThongBao();
THONGBAO lpDTO = BUSThongBao.TimKiem(mahoatdong);
txttieude.Text = lpDTO.TieuDe ;
txtnoidung.Content = lpDTO.NoiDung ;
drlHoatDong.SelectedValue = mahoatdong.ToString();
}
}
protected void XoaHoatDong(int id)
{
try
{
//xac nhan truoc khi xoa
BUSHoatDong bus = new BUSHoatDong();
if (bus.Xoa(id) == 0)
{
//Thong bao
Response.Redirect("HoatDong.aspx");
}
}
catch
{
}
}
protected void btXoa_Click(object sender, EventArgs e)
{
BUSHoatDong bushoatdong = new BUSHoatDong();
bushoatdong.Xoa(int.Parse(ddlMaHoatDong.SelectedValue));
Response.Redirect("QuanLyHoatDong.aspx");
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
if (KiemTra() == false)
{
return;
}
try
{
//lay thong tin tu textbox
HOATDONG lpDTO = new HOATDONG();
lpDTO.MaHoatDong = int.Parse(Request.QueryString["id"]);
lpDTO.TenHoatDong = txttenhoatdong.Text;
lpDTO.MaLoaiHoatDong = int.Parse(ddlLoaiHoatDong.SelectedValue);
//
IFormatProvider culture = new CultureInfo("vi-VN", true);
lpDTO.NgayDienRa = DateTime.Parse(txtngaydienra.Text, culture);
lpDTO.ThoiGianBatDauDangKy = DateTime.Parse(txtthoigianbatdaudangky.Text, culture);
lpDTO.ThoiGianKetThucDangKy = DateTime.Parse(txtthoigianketthucdangky.Text, culture);
if (image.ImageUrl == link)
{
lpDTO.HinhAnh = link.Substring(defaultLink.Length);
}
else
{
if (image.ImageUrl != "")
{
lpDTO.HinhAnh = RenameHinhAnh(image.ImageUrl, lpDTO.TenHoatDong).Substring(defaultLink.Length);
}
}
//Goi ham cap nhat
BUSHoatDong BUSHoatDong = new BUSHoatDong();
if (BUSHoatDong.CapNhat(lpDTO) == 0)
{
//Thong bao
lbThongBao.Text = "Cập Nhật Thành Công";
lbThongBao.Visible = true;
link = "";
linkTemp = "";
Response.Redirect("~/administration/HoatDong.aspx?id=" + Request.QueryString["id"]);
}
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;
}
DeleteHinhAnh(linkTemp);
link = "";
linkTemp = "";
}
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;
}
}