void MyDataBind()
{
if (Session["XLC-MaPhim"] == null)
{
return;
}
int _maPhim = int.Parse(Session["XLC-MaPhim"].ToString());
CinemaLINQDataContext dt = new CinemaLINQDataContext();
List <LichChieuPhim> _dsNgayChieu = (from _lc in dt.LichChieuPhims
where _lc.NgayChieu >= DateTime.Now.Date && _lc.SuatChieus.Where(_sc => _sc.MaPhim == _maPhim).Count() > 0
orderby _lc.NgayChieu.Date ascending
select _lc).ToList();
Phim _phim = (from _ph in dt.Phims
where _ph.MaPhim == _maPhim
select _ph).Single();
Label6.Text = _phim.TenPhim;
dtl_dsNgayChieu.DataSource = _dsNgayChieu;
dtl_dsNgayChieu.DataBind();
for (int i = 0; i < _dsNgayChieu.Count; i++)
{
((LinkButton)dtl_dsNgayChieu.Items[i].FindControl("lbt_NgayChieu")).Text = _dsNgayChieu[i].NgayChieu.ToString("dd/MM/yyyy");
}
}
private void KiemTraQuyenBinhLuan(CinemaLINQDataContext dt)
{
if ((NguoiDung)Session["NguoiDung"] != null)
{
var query = from cd_ in dt.ChamDiems
where cd_.MaNguoiDung == ((NguoiDung)Session["NguoiDung"]).MaNguoiDung && cd_.MaPhim == ((Phim)Session["CurrentPhim"]).MaPhim
select cd_;
if (query.Count <ChamDiem>() == 0)
{
Th_DiemCuaBan.Visible = true;
Xl_ChoDiem.Visible = true;
Lb_DiemCuaBan.Visible = true;
Lb_DaChoDiem.Visible = false;
}
else
{
Th_DiemCuaBan.Visible = false;
Xl_ChoDiem.Visible = false;
Lb_DiemCuaBan.Visible = false;
Lb_DaChoDiem.Visible = true;
Lb_DaChoDiem.Text = "Bạn đã chấm điểm cho phim này rồi";
}
}
else
{
Th_DiemCuaBan.Visible = false;
Xl_ChoDiem.Visible = false;
Lb_DiemCuaBan.Visible = false;
Lb_DaChoDiem.Visible = true;
Lb_DaChoDiem.Text = "Bạn cần đăng nhập để chấm điểm cho phim";
}
}
protected void Page_Load(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
KiemTraQuyenBinhLuan(dt);
LoadThongTinPhim(dt, ((Phim)Session["CurrentPhim"]));
if (!IsPostBack)
{
try
{
//Th_HinhAnh.ImageUrl = ((Phim)Session["CurrentPhim"]).AnhPhim;
//KiemTraQuyenBinhLuan(dt);
//FormView_Phim.DataSource = from phim in dt.Phims
// where phim.MaPhim == currentPhim.MaPhim
// select phim;
//FormView_Phim.DataBind();
}
catch
{
Response.Redirect("Default.aspx");
}
}
else
{
}
}
public void MyDataBind()
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
List <SuatChieu> _dsSuatChieu = (from _sc in dt.SuatChieus
where _sc.LichChieuPhim.NgayChieu.Date >= DateTime.Now.Date && _sc.TinhTrang == true
orderby _sc.MaPhim ascending
select _sc).ToList();
if (_dsSuatChieu.Count == 0)
{
return;
}
List <SuatChieu> _dsSuatChieuTheoPhim = new List <SuatChieu>();
int _currentPhim = -1;
for (int i = 0; i < _dsSuatChieu.Count; i++)
{
if (_dsSuatChieu[i].MaPhim != _currentPhim)
{
_dsSuatChieuTheoPhim.Add(_dsSuatChieu[i]);
_currentPhim = _dsSuatChieu[i].MaPhim;
}
}
//DataList _temp = (DataList)Panel1.FindControl("dtl_DanhSachPhim");
((DataList)Panel1.FindControl("dtl_DanhSachPhim")).DataSource = _dsSuatChieuTheoPhim;
((DataList)Panel1.FindControl("dtl_DanhSachPhim")).DataBind();
//dtl_DanhSachPhim.DataSource = _dsSuatChieuTheoPhim;
//dtl_DanhSachPhim.DataBind();
}
protected void dl_SuatChieuHienTai_PreRender(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var dsdmsc = (from dmsc in dt.DanhMucSuatChieus
select dmsc).OrderBy(dmsc => dmsc.ThoiGianBatDau);
dl_SuatChieuHienTai.DataSource = dsdmsc;
dl_SuatChieuHienTai.DataBind();
int _count = 0;
foreach (DanhMucSuatChieu dmsc in dsdmsc)
{
Label lb = (Label)dl_SuatChieuHienTai.Items[_count].FindControl("lb_ThoiGianBatDau");
lb.Text = dmsc.ThoiGianBatDau.ToShortTimeString();
lb.ForeColor = dmsc.TinhTrang ? Color.LightGreen : Color.DarkGray;
Label lbTT = (Label)dl_SuatChieuHienTai.Items[_count].FindControl("lb_TrangThai");
lbTT.Text = dmsc.TinhTrang ? "Đang sử dụng" : "Chưa sử dụng";
lbTT.ForeColor = dmsc.TinhTrang ? Color.Green : Color.Red;
LinkButton btn = (LinkButton)dl_SuatChieuHienTai.Items[_count].FindControl("btn_ThayDoi");
btn.Text = dmsc.TinhTrang ? "Ngưng sử dụng" : "Sử dụng";
LinkButton btnCN = (LinkButton)dl_SuatChieuHienTai.Items[_count].FindControl("btn_CapNhatGia");
btnCN.CommandName = _count.ToString();
++_count;
}
}
protected void Xl_CapNhatThayDoi_Click(object sender, EventArgs e)
{
try
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = from nd in dt.NguoiDungs
where nd.TenNguoiDung == Th_TenTaiKhoan.Text
select nd;
if (query.Count <NguoiDung>() == 0)
{
Label3.Text = "Tài khoản không tồn tại";
Label3.ForeColor = Color.Red;
Label3.Visible = true;
}
else
{
query.Single().TinhTrang = int.Parse(DropDownList2.SelectedItem.Value);
dt.SubmitChanges();
Response.Redirect("ThayDoiThongTinTaiKhoanThanhCong.aspx");
}
}
catch
{
}
}
protected void Check_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = from nguoiDung in dt.NguoiDungs
where nguoiDung.TenNguoiDung.CompareTo(Th_TenTaiKhoan.Text) == 0
select nguoiDung;
if (query.Count <NguoiDung>() == 0)
{
Label3.Text = "Tài khoản không tồn tại";
Label3.ForeColor = Color.Red;
Label3.Visible = true;
}
else
{
//Label3.Text = "Hiển thị thông tin thành công";
//Label3.ForeColor = Color.Green;
//Label3.Visible = true;
Xl_CapNhatThayDoi.Enabled = true;
var query1 = (from nd in dt.NguoiDungs
where nd.TenNguoiDung == Th_TenTaiKhoan.Text
select nd).Single();
//ChinhSuaThongTinTaiKhoan.nd = query1;
DropDownList2.SelectedIndex = DropDownList2.Items.IndexOf(DropDownList2.Items.FindByValue(query1.TinhTrang.ToString()));
}
}
protected void bt_CapNhat_Click(object sender, EventArgs e)
{
if (Session["NguoiDung"] == null)
{
Response.Redirect("/thanhvien/DangNhap.aspx");
return;
}
CinemaLINQDataContext dt = new CinemaLINQDataContext();
Button _sender = (Button)sender;
int _maSuatChieu = int.Parse(_sender.CommandArgument);
SuatChieu _suatChieuCapNhat = (from _sc in dt.SuatChieus
where _sc.MaSuatChieu == _maSuatChieu
select _sc).Single();
TimeSpan _toQuery = TimeSpan.Parse(Session["CNLC-SuatChieuMoi"].ToString());
DanhMucSuatChieu _scToUpdate = (from _dmsc in dt.DanhMucSuatChieus
where _dmsc.ThoiGianBatDau.TimeOfDay == _toQuery
select _dmsc).Single();
_suatChieuCapNhat.MaDanhMucSuatChieu = _scToUpdate.MaDanhMucSuatChieu;
dt.SubmitChanges();
MyDataBind();
}
protected void bt_CapNhat_Click(object sender, EventArgs e)
{
if (Session["NguoiDung"] == null)
{
Response.Redirect("/thanhvien/DangNhap.aspx");
return;
}
CinemaLINQDataContext dt = new CinemaLINQDataContext();
Button _sender = (Button)sender;
int _maSuatChieu = int.Parse(_sender.CommandArgument);
SuatChieu _suatChieuCapNhat = (from _sc in dt.SuatChieus
where _sc.MaSuatChieu == _maSuatChieu
select _sc).Single();
TimeSpan _toQuery = TimeSpan.Parse(Session["CNLC-SuatChieuMoi"].ToString());
DanhMucSuatChieu _scToUpdate = (from _dmsc in dt.DanhMucSuatChieus
where _dmsc.ThoiGianBatDau.TimeOfDay == _toQuery
select _dmsc).Single();
_suatChieuCapNhat.MaDanhMucSuatChieu = _scToUpdate.MaDanhMucSuatChieu;
dt.SubmitChanges();
MyDataBind();
}
protected void Xl_CapNhatThayDoi_Click(object sender, EventArgs e)
{
try
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = from nd in dt.NguoiDungs
where nd.TenNguoiDung == Th_TenTaiKhoan.Text
select nd;
if (query.Count<NguoiDung>() == 0)
{
Label3.Text = "Tài khoản không tồn tại";
Label3.ForeColor = Color.Red;
Label3.Visible = true;
}
else
{
query.Single().TinhTrang = int.Parse(DropDownList2.SelectedItem.Value);
dt.SubmitChanges();
Response.Redirect("ThayDoiThongTinTaiKhoanThanhCong.aspx");
}
}
catch
{
}
}
protected void UpdatePanel1_PreRender(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
PhongChieuPhim phong = (PhongChieuPhim)Session["Phong"];
if (phong != null)
{
var query = from ghe in dt.Ghes
where ghe.MaPhongChieuPhim == phong.MaPhongChieuPhim
select ghe;
dl_SoDoGhe.DataSource = query;
dl_SoDoGhe.DataBind();
dl_SoDoGhe.RepeatColumns = phong.SoGheTrenHang;
int _count = 0;
foreach (Ghe ghe in query)
{
ImageButton imgbtn = (ImageButton)dl_SoDoGhe.Items[_count].FindControl("btn_Chuyen");
imgbtn.ToolTip = (char)(ghe.Hang + 65) + (ghe.SoThuTu + 1).ToString() + " - Ghế " + ghe.DanhMucGhe.TenDanhMucGhe;
if (ghe.DanhMucGhe.TenDanhMucGhe.CompareTo("Thường") == 0)
{
imgbtn.ImageUrl = "/Img/ghethuong.jpg";
}
else
{
imgbtn.ImageUrl = "/Img/ghevip.jpg";
}
_count++;
}
}
}
protected void Xl_XemSoDoGhe_Click(object sender, EventArgs e)
{
int soHang = int.Parse(tb_SoHangGhe.Text);
int soGheTrenHang = int.Parse(tb_SoGheTrenHang.Text);
CinemaLINQDataContext dt = new CinemaLINQDataContext();
PhongChieuPhim phong = new PhongChieuPhim();
phong.MaRapChieuPhim = int.Parse(cbb_RapPhim.SelectedItem.Value);
phong.TenPhongChieuPhim = tb_TenPhong.Text;
phong.TongSoLuongGhe = soGheTrenHang * soHang;
phong.TinhTrang = false;
phong.SoHang = soHang;
phong.SoGheTrenHang = soGheTrenHang;
dt.PhongChieuPhims.InsertOnSubmit(phong);
dt.SubmitChanges();
for (int i = 0; i < soHang; ++i)
{
for (int j = 0; j < soGheTrenHang; ++j)
{
Ghe ghe = new Ghe();
ghe.MaPhongChieuPhim = phong.MaPhongChieuPhim;
ghe.TenGhe = "Ghe";
ghe.MaDanhMucGhe = dt.DanhMucGhes.Where(dmg => dmg.TenDanhMucGhe.CompareTo("Thường") == 0).Select(dmg => dmg.MaDanhMucGhe).Single();
ghe.Hang = i;
ghe.SoThuTu = j;
ghe.TinhTrang = -1;
dt.Ghes.InsertOnSubmit(ghe);
dt.SubmitChanges();
}
}
Session["Phong"] = (PhongChieuPhim)phong;
}
// public static NguoiDung nd = new NguoiDung();
protected void Check_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = from nguoiDung in dt.NguoiDungs
where nguoiDung.TenNguoiDung.CompareTo(Th_TenTaiKhoan.Text) == 0
select nguoiDung;
if (query.Count<NguoiDung>() == 0)
{
Label3.Text = "Tài khoản không tồn tại";
Label3.ForeColor = Color.Red;
Label3.Visible = true;
}
else
{
Label3.Text = "Hiển thị thông tin thành công";
Label3.ForeColor = Color.Green;
Label3.Visible = true;
var query1 = (from nd in dt.NguoiDungs
where nd.TenNguoiDung == Th_TenTaiKhoan.Text
select nd).Single();
//ChinhSuaThongTinTaiKhoan.nd = query1;
DropDownList2.SelectedIndex = DropDownList2.Items.IndexOf(DropDownList2.Items.FindByValue(query1.MaDanhMucNguoiDung.ToString()));
Th_Email.Text = query1.Email.Trim();
Th_DiaChi.Text = query1.DiaChi.Trim();
}
}
protected void Xl_ChoDiem_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
ChamDiem cd = new ChamDiem();
cd.MaPhim = ((Phim)Session["CurrentPhim"]).MaPhim;
cd.SoDiem = int.Parse(Th_DiemCuaBan.SelectedItem.Value);
cd.MaNguoiDung = ((NguoiDung)Session["NguoiDung"]).MaNguoiDung;
dt.ChamDiems.InsertOnSubmit(cd);
dt.SubmitChanges();
var query = (from phim in dt.Phims
where phim.MaPhim == ((Phim)Session["CurrentPhim"]).MaPhim
select phim).Single();
var query1 = from cd_ in dt.ChamDiems
where cd_.MaPhim == ((Phim)Session["CurrentPhim"]).MaPhim
select cd_.SoDiem;
query.DiemDanhGia = (float)query1.Sum() / (float)query1.Count();
dt.SubmitChanges();
KiemTraQuyenBinhLuan(dt);
LoadThongTinPhim(dt, ((Phim)Session["CurrentPhim"]));
}
private void LoadThongTinPhim(CinemaLINQDataContext dt, Phim currentPhim)
{
FormView_Phim.DataSource = from phim in dt.Phims
where phim.MaPhim == currentPhim.MaPhim
select phim;
FormView_Phim.DataBind();
}
protected void Xl_Sua_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = (from binhLuan in dt.BinhLuans
where binhLuan.MaBinhLuan == int.Parse(((Button)sender).CommandArgument)
select binhLuan).Single();
query.NoiDungBinhLuan = ((TextBox)DataList1.Items[int.Parse(((Button)sender).CommandName)].FindControl("Th_NoiDungBinhLuan")).Text;
dt.SubmitChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
NguoiDung nd = (NguoiDung)Session["NguoiDung"];
if (nd == null || nd.DanhMucNguoiDung.TenDanhMucNguoiDung != "Admin")
{
Response.Redirect("/thanhvien/yeucauquyenadmin.aspx");
}
}
protected void Xl_Xoa_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = (from binhLuan in dt.BinhLuans
where binhLuan.MaBinhLuan == int.Parse(((Button)sender).CommandArgument)
select binhLuan).Single();
query.TinhTrang = dt.DanhMucTinhTrangBinhLuans.Where(ttbl => ttbl.TenTinhTrang.CompareTo("Đã xóa") == 0).Select(ttbl => ttbl.MaTinhTrang).Single();;
dt.SubmitChanges();
}
protected void btn_ThayDoi_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var suatchieu = from _suatchieu in dt.SuatChieus
where _suatchieu.MaSuatChieu == int.Parse(((LinkButton)sender).CommandArgument)
select _suatchieu;
dt.SuatChieus.DeleteAllOnSubmit(suatchieu);
dt.SubmitChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddl_LoaiTimKiem.Items.Add("Tên phim");
ddl_LoaiTimKiem.Items.Add("Lịch chiếu");
ddl_LoaiTimKiem.Items.Add("Suất chiếu");
CinemaLINQDataContext dt = new CinemaLINQDataContext();
List <DanhMucSuatChieu> _dsDMSC = (from _dmsc in dt.DanhMucSuatChieus
orderby _dmsc.ThoiGianBatDau ascending
select _dmsc).ToList();
dtl_SuatChieu.DataSource = _dsDMSC;
dtl_SuatChieu.DataBind();
if (_dsDMSC.Count > 0)
{
int _count = 0;
foreach (DanhMucSuatChieu _dmsc in _dsDMSC)
{
((LinkButton)dtl_SuatChieu.Items[_count].FindControl("lbt_SuatChieu")).Text = _dsDMSC[_count].ThoiGianBatDau.ToString("HH:mm");
_count++;
}
}
if (Session["SearchMode"] == null)
{
Session["SearchMode"] = "Tên phim";
}
Display_SearchMode(Session["SearchMode"].ToString());
NguoiDung nd = (NguoiDung)Session["NguoiDung"];
if (nd == null)
{
panel_DangNhap.Visible = true;
panel_NguoiDung.Visible = false;
}
else
{
panel_DangNhap.Visible = false;
panel_NguoiDung.Visible = true;
lb_TenNguoiDung.Text = nd.TenNguoiDung;
if (nd.DanhMucNguoiDung.TenDanhMucNguoiDung.CompareTo("Admin") == 0)
{
hp_Admin.Visible = true;
}
else
{
hp_Admin.Visible = false;
}
}
}
}
protected void btn_CapNhatGia_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = (from dmsc in dt.DanhMucSuatChieus
where dmsc.MaDanhMucSuatChieu == int.Parse(((LinkButton)sender).CommandArgument)
select dmsc).Single();
var giaMoi = int.Parse(((TextBox)dl_SuatChieuHienTai.Items[int.Parse(((LinkButton)sender).CommandName)].FindControl("tb_GiaDanhMuc")).Text);
query.GiaDanhMuc = giaMoi;
dt.SubmitChanges();
}
//protected void btn_Sua_Click(object sender, EventArgs e)
//{
// Button btn = (Button)sender;
// //((TextBox)dl_SuatChieuHienTai.Items[int.Parse(btn.CommandName)].FindControl("tb_ThoiGian")).ReadOnly = false;
// CinemaLINQDataContext dt = new CinemaLINQDataContext();
// DateTime time = new DateTime();
// for (int i = 0; i < 96; ++i)
// {
// DanhMucSuatChieu dmsc = new DanhMucSuatChieu();
// dmsc.ThoiGianBatDau = time.AddMinutes(i * 15);
// dmsc.TinhTrang = false;
// dmsc.GiaDanhMuc = 90000;
// dt.DanhMucSuatChieus.InsertOnSubmit(dmsc);
// }
// dt.SubmitChanges();
//}
protected void btn_ThayDoi_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = (from dmsc in dt.DanhMucSuatChieus
where dmsc.MaDanhMucSuatChieu == int.Parse(((LinkButton)sender).CommandArgument)
select dmsc).Single();
query.TinhTrang = !query.TinhTrang;
dt.SubmitChanges();
}
public void MyDataBind()
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
int _maLichChieu = int.Parse(Session["CNLC-MaLichChieuDuocChon"].ToString());
int _maPhim = int.Parse(Session["CNLC-MaPhimDuocChon"].ToString());
List <SuatChieu> _dsSuatChieu = (from sc in dt.SuatChieus
where sc.MaLichChieu == _maLichChieu && sc.MaPhim == _maPhim
orderby sc.DanhMucSuatChieu.ThoiGianBatDau ascending
select sc).ToList();
Phim _phim = (from ph in dt.Phims
where ph.MaPhim == _maPhim
select ph).Single();
LichChieuPhim _lichChieuPhim = (from lc in dt.LichChieuPhims
where lc.MaLichChieuPhim == _maLichChieu
select lc).Single();
lb_Phim.Text += _phim.TenPhim;
lb_NgayChieu.Text += _lichChieuPhim.NgayChieu.Date.ToString("dd/MM/yyyy");
DataList1.DataSource = _dsSuatChieu;
DataList1.DataBind();
int _count = 0;
foreach (SuatChieu sc in _dsSuatChieu)
{
((Label)DataList1.Items[_count].FindControl("lb_Suat")).Text = sc.DanhMucSuatChieu.ThoiGianBatDau.ToString("HH:mm");
((LinkButton)DataList1.Items[_count].FindControl("lbt_CapNhat")).CommandArgument = _count.ToString();
LinkButton _lbtXoa = (LinkButton)DataList1.Items[_count].FindControl("lbt_Xoa");
List <DatVe> _dsVeDatTrongSuat = (from _dt in dt.DatVes
where _dt.MaSuatChieu == sc.MaSuatChieu
select _dt).ToList();
if (_dsVeDatTrongSuat.Count == 0)
{
_lbtXoa.Visible = true;
}
else
{
_lbtXoa.Visible = false;
}
_count++;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = from nguoiDung in dt.NguoiDungs
where nguoiDung.TenNguoiDung.CompareTo(Th_TenTaiKhoan.Text) == 0
select nguoiDung;
if (query.Count<NguoiDung>() == 0)
{
NguoiDung nd = new NguoiDung();
MD5 md5Hasher = MD5.Create();
byte[] data = md5Hasher.ComputeHash(Encoding.Default.GetBytes(Th_MatKhau.Text));
StringBuilder sBuilder = new StringBuilder();
for (int i = 0; i < data.Length; i++)
{
sBuilder.Append(data[i].ToString("x2"));
}
string strPassword = sBuilder.ToString();
nd.TenNguoiDung = Th_TenTaiKhoan.Text;
nd.MatKhau = strPassword;
nd.Email = Th_Email.Text;
nd.DiaChi = Th_DiaChi.Text;
nd.MaDanhMucNguoiDung = int.Parse(DropDownList2.SelectedItem.Value);
nd.TinhTrang = dt.DanhMucTinhTrangNguoiDungs.Where(ttnd=> ttnd.TenDanhMucTinhTrangNguoiDung.CompareTo("Bình thường") == 0).Select(ttnd=> ttnd.MaDanhMucTinhTrangNguoiDung).Single();
dt.NguoiDungs.InsertOnSubmit(nd);
dt.SubmitChanges();
Response.Redirect("TaoTaiKhoanThanhCong.aspx");
}
else
{
Label3.Text = "Tên tài khoản đã tồn tại";
Label3.ForeColor = Color.Red;
Label3.Visible = true;
}
}
catch
{
}
}
public void BindingData()
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
List <Phim> _dsPhim = (from _phim in dt.Phims
where _phim.TenPhim.Contains(Session["TenPhimTimKiem"].ToString())
orderby _phim.TenPhim ascending
select _phim).ToList();
if (_dsPhim.Count == 0)
{
lb_KetQuaTraCuu.Text = "Không tìm thấy kết quả nào";
return;
}
else
{
lb_KetQuaTraCuu.Text = "Kết quả tra cứu";
PagedDataSource pds = new PagedDataSource();
pds.DataSource = _dsPhim;
pds.AllowPaging = true;
pds.PageSize = _pageSize;
pds.CurrentPageIndex = CurrentIndex;
Th_KetQuaTraCuu.DataSource = pds;
Th_KetQuaTraCuu.DataBind();
if (Session["NguoiDung"] == null || ((NguoiDung)Session["NguoiDung"]).MaDanhMucNguoiDung != 1)
{
int _temp = _dsPhim.Count - (CurrentIndex * _pageSize);
int _itemCount = 0;
if (_temp >= _pageSize)
{
_itemCount = _pageSize;
}
else
{
_itemCount = _temp;
}
for (int i = 0; i < _itemCount; i++)
{
((LinkButton)Th_KetQuaTraCuu.Items[i].FindControl("lbt_ChinhSuaPhim")).Visible = false;
}
}
Pagging_CountPage(_dsPhim.Count);
}
}
protected void btn_PhatSinh_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
for (int i = 0; i < int.Parse(cbb_ChonNgay.SelectedItem.Value); ++i)
{
var query = from _lichchieu in dt.LichChieuPhims
where _lichchieu.NgayChieu.CompareTo(DateTime.Today.AddDays(i + 1)) == 0
select _lichchieu;
LichChieuPhim lichchieu = null;
if (query.Count <LichChieuPhim>() == 0)
{
lichchieu = new LichChieuPhim();
lichchieu.NgayChieu = DateTime.Today.AddDays(i + 1);
lichchieu.TinhTrang = true;
dt.LichChieuPhims.InsertOnSubmit(lichchieu);
dt.SubmitChanges();
}
else
{
lichchieu = query.Single();
}
var dmSuatChieu = from _dmsc in dt.DanhMucSuatChieus
where _dmsc.TinhTrang == true
select _dmsc;
foreach (DanhMucSuatChieu dmsc in dmSuatChieu)
{
var suatchieu = from _suatchieu in dt.SuatChieus
where _suatchieu.MaLichChieu == lichchieu.MaLichChieuPhim && _suatchieu.MaPhim == int.Parse(cbb_ChonPhim.SelectedItem.Value) && _suatchieu.MaPhong == int.Parse(cbb_Phong.SelectedItem.Value) && _suatchieu.MaDanhMucSuatChieu == dmsc.MaDanhMucSuatChieu
select _suatchieu;
if (suatchieu.Count <SuatChieu>() == 0)
{
SuatChieu sc = new SuatChieu();
sc.MaLichChieu = lichchieu.MaLichChieuPhim;
sc.MaPhim = int.Parse(cbb_ChonPhim.SelectedItem.Value);
sc.MaPhong = int.Parse(cbb_Phong.SelectedItem.Value);
sc.MaDanhMucSuatChieu = dmsc.MaDanhMucSuatChieu;
sc.TinhTrang = false;
dt.SuatChieus.InsertOnSubmit(sc);
dt.SubmitChanges();
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
int maxMaPhim = -1;
try
{
maxMaPhim = (from film in dt.Phims select film.MaPhim).Max();
}
catch
{
maxMaPhim = 1;
}
string posterFileName = (maxMaPhim + 1).ToString() + Th_AnhPhim.FileName.Substring(Th_AnhPhim.FileName.Length - 4);
string posterName = "/phim/poster/" + posterFileName;
Th_AnhPhim.SaveAs(Server.MapPath("/phim/poster/") + posterFileName);
string trailerFileName = (maxMaPhim + 1).ToString() + Th_Trailer.FileName.Substring(Th_Trailer.FileName.Length - 4);
string trailerName = "/phim/trailer/" + trailerFileName;
Th_Trailer.SaveAs(Server.MapPath("/phim/trailer/") + trailerFileName);
Phim phim = new Phim();
phim.TenPhim = Th_TenPhim.Text;
phim.TheLoai = int.Parse(DropDownList1.SelectedItem.Value);
phim.DaoDien = Th_DaoDien.Text;
phim.DienVienThamGia = Th_DienVien.Text;
phim.NoiDung = Th_NoiDung.Text;
phim.NgonNgu = Th_NgonNgu.Text;
phim.ThoiLuong = int.Parse(Th_ThoiLuong.Text);
phim.DiemDanhGia = 0;
phim.TinhTrang = true;
phim.AnhPhim = posterName;
phim.TrailerPhim = trailerName;
phim.LoaiPhim = int.Parse(DropDownList2.SelectedItem.Value);
dt.Phims.InsertOnSubmit(phim);
dt.SubmitChanges();
Session["SelectedFilmID"] = phim.MaPhim;
Response.Redirect("ThemPhimThanhCong.aspx");
}
catch
{
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = from nguoiDung in dt.NguoiDungs
where nguoiDung.TenNguoiDung.CompareTo(Th_TenTaiKhoan.Text) == 0
select nguoiDung;
if (query.Count <NguoiDung>() == 0)
{
NguoiDung nd = new NguoiDung();
MD5 md5Hasher = MD5.Create();
byte[] data = md5Hasher.ComputeHash(Encoding.Default.GetBytes(Th_MatKhau.Text));
StringBuilder sBuilder = new StringBuilder();
for (int i = 0; i < data.Length; i++)
{
sBuilder.Append(data[i].ToString("x2"));
}
string strPassword = sBuilder.ToString();
nd.TenNguoiDung = Th_TenTaiKhoan.Text;
nd.MatKhau = strPassword;
nd.Email = Th_Email.Text;
nd.DiaChi = Th_DiaChi.Text;
nd.MaDanhMucNguoiDung = int.Parse(DropDownList2.SelectedItem.Value);
nd.TinhTrang = dt.DanhMucTinhTrangNguoiDungs.Where(ttnd => ttnd.TenDanhMucTinhTrangNguoiDung.CompareTo("Bình thường") == 0).Select(ttnd => ttnd.MaDanhMucTinhTrangNguoiDung).Single();
dt.NguoiDungs.InsertOnSubmit(nd);
dt.SubmitChanges();
Response.Redirect("TaoTaiKhoanThanhCong.aspx");
}
else
{
Label3.Text = "Tên tài khoản đã tồn tại";
Label3.ForeColor = Color.Red;
Label3.Visible = true;
}
}
catch
{
}
}
public void BindingData()
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
List <Phim> _dsPhim = (from _phim in dt.Phims
where _phim.SuatChieus.Where(sc => sc.LichChieuPhim.NgayChieu.Date >= DateTime.Now.Date).Count() > 0
orderby _phim.TenPhim ascending
select _phim).ToList();
if (_dsPhim.Count == 0)
{
return;
}
else
{
PagedDataSource pds = new PagedDataSource();
pds.DataSource = _dsPhim;
pds.AllowPaging = true;
pds.PageSize = _pageSize;
pds.CurrentPageIndex = CurrentIndex;
Th_KetQuaTraCuu.DataSource = pds;
Th_KetQuaTraCuu.DataBind();
if (Session["NguoiDung"] == null || ((NguoiDung)Session["NguoiDung"]).MaDanhMucNguoiDung != 1)
{
int _temp = _dsPhim.Count - (CurrentIndex * _pageSize);
int _itemCount = 0;
if (_temp >= _pageSize)
{
_itemCount = _pageSize;
}
else
{
_itemCount = _temp;
}
for (int i = 0; i < _itemCount; i++)
{
((LinkButton)Th_KetQuaTraCuu.Items[i].FindControl("lbt_ChinhSuaPhim")).Visible = false;
}
}
Pagging_CountPage(_dsPhim.Count);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
MD5 md5Hasher = MD5.Create();
byte[] data = md5Hasher.ComputeHash(Encoding.Default.GetBytes(Th_MatKhauCu.Text));
StringBuilder sBuilder = new StringBuilder();
for (int i = 0; i < data.Length; i++)
{
sBuilder.Append(data[i].ToString("x2"));
}
string strPassword = sBuilder.ToString();
if (strPassword.CompareTo(((NguoiDung)Session["NguoiDung"]).MatKhau) == 0)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = (from nd in dt.NguoiDungs
where nd.MaNguoiDung == ((NguoiDung)Session["NguoiDung"]).MaNguoiDung
select nd).Single();
MD5 md5Hasher1 = MD5.Create();
byte[] data1 = md5Hasher1.ComputeHash(Encoding.Default.GetBytes(Th_MatKhauMoi.Text));
StringBuilder sBuilder1 = new StringBuilder();
for (int i = 0; i < data1.Length; i++)
{
sBuilder1.Append(data1[i].ToString("x2"));
}
string strPassword1 = sBuilder1.ToString();
query.MatKhau = strPassword1;
dt.SubmitChanges();
Response.Redirect("/thanhvien/DoiMatKhauThanhCong.aspx");
}
else
{
Label2.Text = "Mật khẩu cũ không chính xác";
Label2.Visible = true;
}
}
catch
{
}
}
protected void btn_XacNhan_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
if (Session["DungDo"] != null && (bool)Session["DungDo"] == true)
{
lb_ThongBao.Text = "Vẫn còn đụng độ trên lịch chiếu - Thêm mới thất bại";
}
else
{
for (int i = 0; i < int.Parse(cbb_ChonNgay.SelectedItem.Value); ++i)
{
var query = from _lichchieu in dt.LichChieuPhims
where _lichchieu.NgayChieu.CompareTo(DateTime.Today.AddDays(i + 1)) == 0
select _lichchieu;
LichChieuPhim lichchieu = null;
if (query.Count <LichChieuPhim>() == 0)
{
lichchieu = new LichChieuPhim();
lichchieu.NgayChieu = DateTime.Today.AddDays(i + 1);
lichchieu.TinhTrang = true;
dt.LichChieuPhims.InsertOnSubmit(lichchieu);
dt.SubmitChanges();
}
else
{
lichchieu = query.Single();
}
var dsSuatChieu = from _suatchieu in dt.SuatChieus
where _suatchieu.MaLichChieu == lichchieu.MaLichChieuPhim && _suatchieu.MaPhim == int.Parse(cbb_ChonPhim.SelectedItem.Value) && _suatchieu.MaPhong == int.Parse(cbb_Phong.SelectedItem.Value) && _suatchieu.TinhTrang == false
select _suatchieu;
foreach (SuatChieu _suatchieu in dsSuatChieu)
{
_suatchieu.TinhTrang = true;
dt.SubmitChanges();
}
var dsSuatChieuTam = from _suatchieu in dt.SuatChieus
where _suatchieu.TinhTrang == false
select _suatchieu;
dt.SuatChieus.DeleteAllOnSubmit(dsSuatChieuTam);
dt.SubmitChanges();
}
}
}
public void BindingData()
{
DateTime _dateSelected = (DateTime)Session["ThoiGianTimKiem"];
CinemaLINQDataContext dt = new CinemaLINQDataContext();
List <LichChieuPhim> _dsLichChieu = (from _lichChieu in dt.LichChieuPhims
where _lichChieu.NgayChieu == _dateSelected
select _lichChieu).ToList();
if (_dsLichChieu.Count == 0)
{
lb_KetQuaTraCuu.Text = "Chưa có lịch chiếu cho ngày " + _dateSelected.Day.ToString() + "/" + _dateSelected.Month.ToString() + "/" + _dateSelected.Year.ToString();
return;
}
lb_KetQuaTraCuu.Text = "Lịch chiếu ngày " + _dateSelected.Day.ToString() + "/" + _dateSelected.Month.ToString() + "/" + _dateSelected.Year.ToString();
List <SuatChieu> _dsSuatChieu = (from _suatChieu in dt.SuatChieus
where _suatChieu.MaLichChieu == _dsLichChieu[0].MaLichChieuPhim && _suatChieu.TinhTrang == true
orderby _suatChieu.MaPhim ascending
select _suatChieu).ToList();
if (_dsSuatChieu.Count == 0)
{
lb_KetQuaTraCuu.Text = "Chưa có lịch chiếu cho ngày " + _dateSelected.Day.ToString() + "/" + _dateSelected.Month.ToString() + "/" + _dateSelected.Year.ToString();
return;
}
List <SuatChieu> _dsSuatChieuTheoPhim = new List <SuatChieu>();
int _currentPhim = -1;
for (int i = 0; i < _dsSuatChieu.Count; i++)
{
if (_currentPhim != _dsSuatChieu[i].MaPhim)
{
_dsSuatChieuTheoPhim.Add(_dsSuatChieu[i]);
_currentPhim = _dsSuatChieu[i].MaPhim;
}
}
dtl_DanhSachPhim.DataSource = _dsSuatChieuTheoPhim;
dtl_DanhSachPhim.DataBind();
}
protected void btn_ThemPhongMoi_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
PhongChieuPhim phong = (PhongChieuPhim)Session["Phong"];
if (phong == null)
{
Response.Redirect("/admin/default.aspx");
}
var __phong = (from _phong in dt.PhongChieuPhims
where _phong.MaPhongChieuPhim == phong.MaPhongChieuPhim
select _phong).Single();
__phong.TinhTrang = true;
dt.SubmitChanges();
var dsGhe = from _ghe in dt.Ghes
where _ghe.MaPhongChieuPhim == __phong.MaPhongChieuPhim
select _ghe;
foreach (Ghe _ghe in dsGhe)
{
_ghe.TinhTrang = 1;
}
dt.SubmitChanges();
var dsGheTam = from _ghe in dt.Ghes
where _ghe.TinhTrang == -1
select _ghe;
dt.Ghes.DeleteAllOnSubmit(dsGheTam);
dt.SubmitChanges();
var dsPhongTam = from _phong in dt.PhongChieuPhims
where _phong.TinhTrang == false
select _phong;
dt.PhongChieuPhims.DeleteAllOnSubmit(dsPhongTam);
dt.SubmitChanges();
Session["Phong"] = null;
Response.Redirect("/admin/ThemPhongThanhCong.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
MD5 md5Hasher = MD5.Create();
byte[] data = md5Hasher.ComputeHash(Encoding.Default.GetBytes(Th_MatKhauCu.Text));
StringBuilder sBuilder = new StringBuilder();
for (int i = 0; i < data.Length; i++)
{
sBuilder.Append(data[i].ToString("x2"));
}
string strPassword = sBuilder.ToString();
if (strPassword.CompareTo(((NguoiDung)Session["NguoiDung"]).MatKhau) == 0)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = (from nd in dt.NguoiDungs
where nd.MaNguoiDung == ((NguoiDung)Session["NguoiDung"]).MaNguoiDung
select nd).Single();
MD5 md5Hasher1 = MD5.Create();
byte[] data1 = md5Hasher1.ComputeHash(Encoding.Default.GetBytes(Th_MatKhauMoi.Text));
StringBuilder sBuilder1 = new StringBuilder();
for (int i = 0; i < data1.Length; i++)
{
sBuilder1.Append(data1[i].ToString("x2"));
}
string strPassword1 = sBuilder1.ToString();
query.MatKhau = strPassword1;
dt.SubmitChanges();
Response.Redirect("/thanhvien/DoiMatKhauThanhCong.aspx");
}
else
{
Label2.Text = "Mật khẩu cũ không chính xác";
Label2.Visible = true;
}
}
catch
{
}
}
public void MyDataBind()
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
int _maLichChieu = int.Parse(Session["CNLC-MaLichChieuDuocChon"].ToString());
int _maPhim = int.Parse(Session["CNLC-MaPhimDuocChon"].ToString());
List<SuatChieu> _dsSuatChieu = (from sc in dt.SuatChieus
where sc.MaLichChieu == _maLichChieu && sc.MaPhim == _maPhim
orderby sc.DanhMucSuatChieu.ThoiGianBatDau ascending
select sc).ToList();
Phim _phim = (from ph in dt.Phims
where ph.MaPhim == _maPhim
select ph).Single();
LichChieuPhim _lichChieuPhim = (from lc in dt.LichChieuPhims
where lc.MaLichChieuPhim == _maLichChieu
select lc).Single();
lb_Phim.Text += _phim.TenPhim;
lb_NgayChieu.Text += _lichChieuPhim.NgayChieu.Date.ToString("dd/MM/yyyy");
DataList1.DataSource = _dsSuatChieu;
DataList1.DataBind();
int _count = 0;
foreach (SuatChieu sc in _dsSuatChieu)
{
((Label)DataList1.Items[_count].FindControl("lb_Suat")).Text = sc.DanhMucSuatChieu.ThoiGianBatDau.ToString("HH:mm");
((LinkButton)DataList1.Items[_count].FindControl("lbt_CapNhat")).CommandArgument = _count.ToString();
LinkButton _lbtXoa = (LinkButton)DataList1.Items[_count].FindControl("lbt_Xoa");
List<DatVe> _dsVeDatTrongSuat = (from _dt in dt.DatVes
where _dt.MaSuatChieu == sc.MaSuatChieu
select _dt).ToList();
if (_dsVeDatTrongSuat.Count == 0)
_lbtXoa.Visible = true;
else
_lbtXoa.Visible = false;
_count++;
}
}
public void BindingData()
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
List<Phim> _dsPhim = (from _phim in dt.Phims
where _phim.TenPhim.Contains(Session["TenPhimTimKiem"].ToString())
orderby _phim.TenPhim ascending
select _phim).ToList();
if (_dsPhim.Count == 0)
{
lb_KetQuaTraCuu.Text = "Không tìm thấy kết quả nào";
return;
}
else
{
lb_KetQuaTraCuu.Text = "Kết quả tra cứu";
PagedDataSource pds = new PagedDataSource();
pds.DataSource = _dsPhim;
pds.AllowPaging = true;
pds.PageSize = _pageSize;
pds.CurrentPageIndex = CurrentIndex;
Th_KetQuaTraCuu.DataSource = pds;
Th_KetQuaTraCuu.DataBind();
if (Session["NguoiDung"] == null || ((NguoiDung)Session["NguoiDung"]).MaDanhMucNguoiDung != 1)
{
int _temp = _dsPhim.Count - (CurrentIndex * _pageSize);
int _itemCount = 0;
if (_temp >= _pageSize)
_itemCount = _pageSize;
else
_itemCount = _temp;
for (int i = 0; i < _itemCount; i++)
{
((LinkButton)Th_KetQuaTraCuu.Items[i].FindControl("lbt_ChinhSuaPhim")).Visible = false;
}
}
Pagging_CountPage(_dsPhim.Count);
}
}
public void BindingData()
{
DateTime _dateSelected = (DateTime)Session["ThoiGianTimKiem"];
CinemaLINQDataContext dt = new CinemaLINQDataContext();
List<LichChieuPhim> _dsLichChieu = (from _lichChieu in dt.LichChieuPhims
where _lichChieu.NgayChieu == _dateSelected
select _lichChieu).ToList();
if (_dsLichChieu.Count == 0)
{
lb_KetQuaTraCuu.Text = "Chưa có lịch chiếu cho ngày " + _dateSelected.Day.ToString() + "/" + _dateSelected.Month.ToString() + "/" + _dateSelected.Year.ToString();
return;
}
lb_KetQuaTraCuu.Text = "Lịch chiếu ngày " + _dateSelected.Day.ToString() + "/" + _dateSelected.Month.ToString() + "/" + _dateSelected.Year.ToString();
List<SuatChieu> _dsSuatChieu = (from _suatChieu in dt.SuatChieus
where _suatChieu.MaLichChieu == _dsLichChieu[0].MaLichChieuPhim && _suatChieu.TinhTrang == true
orderby _suatChieu.MaPhim ascending
select _suatChieu).ToList();
if (_dsSuatChieu.Count == 0)
{
lb_KetQuaTraCuu.Text = "Chưa có lịch chiếu cho ngày " + _dateSelected.Day.ToString() + "/" + _dateSelected.Month.ToString() + "/" + _dateSelected.Year.ToString();
return;
}
List<SuatChieu> _dsSuatChieuTheoPhim = new List<SuatChieu>();
int _currentPhim = -1;
for (int i = 0; i < _dsSuatChieu.Count; i++)
{
if (_currentPhim != _dsSuatChieu[i].MaPhim)
{
_dsSuatChieuTheoPhim.Add(_dsSuatChieu[i]);
_currentPhim = _dsSuatChieu[i].MaPhim;
}
}
dtl_DanhSachPhim.DataSource = _dsSuatChieuTheoPhim;
dtl_DanhSachPhim.DataBind();
}
protected void UpdatePanel1_PreRender(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
NguoiDung nguoiDung = ((NguoiDung)Session["NguoiDung"]);
var query = from binhLuan in dt.BinhLuans
where binhLuan.MaPhim == ((Phim)Session["CurrentPhim"]).MaPhim && binhLuan.TinhTrang == dt.DanhMucTinhTrangBinhLuans.Where(ttbl => ttbl.TenTinhTrang.CompareTo("Bình thường") == 0).Select(ttbl => ttbl.MaTinhTrang).Single()
select binhLuan;
DataList1.DataSource = query;
DataList1.DataBind();
int _count = 0;
foreach (BinhLuan _bl in query)
{
if (nguoiDung != null && (nguoiDung.MaDanhMucNguoiDung == dt.DanhMucNguoiDungs.Where(dmnd => dmnd.TenDanhMucNguoiDung.CompareTo("Admin") == 0).Select(dmnd => dmnd.MaDanhMucNguoiDung).Single() || nguoiDung.MaNguoiDung == _bl.MaNguoiDung))
{
((TextBox)DataList1.Items[_count].FindControl("Th_NoiDungBinhLuan")).ReadOnly = false;
DataList1.Items[_count].FindControl("Xl_Sua").Visible = true;
DataList1.Items[_count].FindControl("Xl_Xoa").Visible = true;
}
else
{
((TextBox)DataList1.Items[_count].FindControl("Th_NoiDungBinhLuan")).ReadOnly = true;
DataList1.Items[_count].FindControl("Xl_Sua").Visible = false;
DataList1.Items[_count].FindControl("Xl_Xoa").Visible = false;
}
Button temp = (Button)DataList1.Items[_count].FindControl("Xl_Sua");
temp.CommandName = _count.ToString();
_count++;
}
if (nguoiDung == null)
{
UpdatePanel1.FindControl("Xl_ThemBinhLuan").Visible = false;
UpdatePanel1.FindControl("Th_BinhLuanMoi").Visible = false;
}
else
{
UpdatePanel1.FindControl("Xl_ThemBinhLuan").Visible = true;
UpdatePanel1.FindControl("Th_BinhLuanMoi").Visible = true;
}
}
protected void Check_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = from nguoiDung in dt.NguoiDungs
where nguoiDung.TenNguoiDung.CompareTo(Th_TenTaiKhoan.Text) == 0
select nguoiDung;
if (query.Count<NguoiDung>() == 0)
{
Label3.Text = "Bạn có thể sử dụng tên này";
Label3.ForeColor = Color.Green;
Label3.Visible = true;
}
else
{
Label3.Text = "Tên tài khoản đã tồn tại";
Label3.ForeColor = Color.Red;
Label3.Visible = true;
}
}
protected void Xl_CapNhatThayDoi_Click(object sender, EventArgs e)
{
try
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = (from nd in dt.NguoiDungs
where nd.TenNguoiDung == Th_TenTaiKhoan.Text
select nd).Single();
query.Email = Th_Email.Text;
query.DiaChi = Th_DiaChi.Text;
query.MaDanhMucNguoiDung = int.Parse(DropDownList2.SelectedItem.Value);
dt.SubmitChanges();
Response.Redirect("ThayDoiThongTinTaiKhoanThanhCong.aspx");
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["NguoiDung"] == null)
Response.Redirect("/thanhvien/YeuCauDangNhap.aspx");
else
{
try
{
if (Lb_TenTaiKhoan.Text == null || Lb_TenTaiKhoan.Text.Trim().Length == 0)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
Lb_TenTaiKhoan.Text = ((NguoiDung)Session["NguoiDung"]).TenNguoiDung;
Th_Email.Text = ((NguoiDung)Session["NguoiDung"]).Email.Trim();
Th_DiaChi.Text = ((NguoiDung)Session["NguoiDung"]).DiaChi;
}
}
catch
{
}
}
}
protected void Xl_CapNhatThayDoi_Click(object sender, EventArgs e)
{
try
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = (from nd in dt.NguoiDungs
where nd.MaNguoiDung == ((NguoiDung)Session["NguoiDung"]).MaNguoiDung
select nd).Single();
query.Email = Th_Email.Text;
query.DiaChi = Th_DiaChi.Text;
dt.SubmitChanges();
Label2.Text = "Cập nhật thông tin tài khoản thành công";
Label2.Visible = true;
Session["NguoiDung"] = query;
}
catch
{
}
}
protected void UpdatePanel2_PreRender(object sender, EventArgs e)
{
DateTime _selectionDate = Calendar1.SelectedDate;
DanhMucSuatChieu _loaiSuatChieu;
CinemaLINQDataContext dt = new CinemaLINQDataContext();
if (Session["SuatChieuTimKiem"] == null)
return;
else
{
int _maSuatChieuTimKiem = int.Parse(Session["SuatChieuTimKiem"].ToString());
_loaiSuatChieu = (from _dmsc in dt.DanhMucSuatChieus
where _dmsc.MaDanhMucSuatChieu == _maSuatChieuTimKiem
select _dmsc).Single();
lb_SuatChieuChon.Text = "Suất chiếu chọn tra cứu: " + _loaiSuatChieu.ThoiGianBatDau.ToString("HH:mm");
if (_selectionDate == DateTime.MinValue)
return;
}
List<SuatChieu> _dsSuatChieu = (from _sc in dt.SuatChieus
where _sc.LichChieuPhim.NgayChieu == _selectionDate && _sc.MaDanhMucSuatChieu == int.Parse(Session["SuatChieuTimKiem"].ToString()) && _sc.TinhTrang == true
orderby _sc.MaPhim
select _sc).ToList();
if (_dsSuatChieu.Count == 0)
{
lb_DanhSachPhimChieu.Visible = true;
lb_DanhSachPhimChieu.Text = "Hiện chưa có phim được chiếu vào ngày " +
_selectionDate.Day.ToString() + "/" + _selectionDate.Month.ToString() + "/" + _selectionDate.Year.ToString() +
", suất: " + _loaiSuatChieu.ThoiGianBatDau.ToString("HH:mm");
List<SuatChieu> _dsSuatChieuRong = new List<SuatChieu>();
DataList1.DataSource = _dsSuatChieuRong;
DataList1.DataBind();
return;
}
lb_DanhSachPhimChieu.Visible = true;
lb_DanhSachPhimChieu.Text = "Danh sách phim chiếu vào ngày " +
_selectionDate.Day.ToString() + "/" + _selectionDate.Month.ToString() + "/" + _selectionDate.Year.ToString() +
", suất: " + _loaiSuatChieu.ThoiGianBatDau.ToString("HH:mm");
List<SuatChieu> _dsSuatChieuTheoPhim = new List<SuatChieu>();
int _currentPhim = -1;
for (int i = 0; i < _dsSuatChieu.Count; i++)
{
if (_currentPhim != _dsSuatChieu[i].Phim.MaPhim)
{
_dsSuatChieuTheoPhim.Add(_dsSuatChieu[i]);
_currentPhim = _dsSuatChieu[i].Phim.MaPhim;
}
}
DataList1.DataSource = _dsSuatChieuTheoPhim;
DataList1.DataBind();
if (_selectionDate.Date < DateTime.Now.Date || (_selectionDate.Date == DateTime.Now.Date && _loaiSuatChieu.ThoiGianBatDau.AddHours(-2).TimeOfDay < DateTime.Now.TimeOfDay))
{
for (int i = 0; i < _dsSuatChieuTheoPhim.Count; i++)
{
((LinkButton)DataList1.Items[i].FindControl("lbt_DatVe")).Visible = false;
}
}
}
