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 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 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 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 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 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();
}
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 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 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 btn_Chuyen_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
if (Session["Phong"] == null)
Response.Redirect("/admin/default.aspx");
Ghe ghe = dt.Ghes.Where(_ghe => _ghe.MaGhe == int.Parse(((ImageButton)sender).CommandArgument)).Select(_ghe => _ghe).Single();
if (ghe.MaDanhMucGhe == dt.DanhMucGhes.Where(dmg => dmg.TenDanhMucGhe.CompareTo("Thường") == 0).Select(dmg => dmg.MaDanhMucGhe).Single())
{
ghe.MaDanhMucGhe = dt.DanhMucGhes.Where(dmg => dmg.TenDanhMucGhe.CompareTo("Vip") == 0).Select(dmg => dmg.MaDanhMucGhe).Single();
}
else
{
ghe.MaDanhMucGhe = dt.DanhMucGhes.Where(dmg => dmg.TenDanhMucGhe.CompareTo("Thường") == 0).Select(dmg => dmg.MaDanhMucGhe).Single();
}
dt.SubmitChanges();
}
protected void btn_Chuyen_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var phong = (from _phong in dt.PhongChieuPhims
where _phong.MaPhongChieuPhim == int.Parse(cbb_Phong.SelectedItem.Value)
select _phong).Single();
Ghe ghe = dt.Ghes.Where(_ghe => _ghe.MaGhe == int.Parse(((ImageButton)sender).CommandArgument)).Select(_ghe => _ghe).Single();
if (ghe.MaDanhMucGhe == dt.DanhMucGhes.Where(dmg => dmg.TenDanhMucGhe.CompareTo("Thường") == 0).Select(dmg => dmg.MaDanhMucGhe).Single())
{
ghe.MaDanhMucGhe = dt.DanhMucGhes.Where(dmg => dmg.TenDanhMucGhe.CompareTo("Vip") == 0).Select(dmg => dmg.MaDanhMucGhe).Single();
}
else
{
ghe.MaDanhMucGhe = dt.DanhMucGhes.Where(dmg => dmg.TenDanhMucGhe.CompareTo("Thường") == 0).Select(dmg => dmg.MaDanhMucGhe).Single();
}
dt.SubmitChanges();
}
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;
}
}
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 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();
}
}
}
protected void btn_ThemSuat_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = from dmsc in dt.DanhMucSuatChieus
where dmsc.ThoiGianBatDau.Hour == int.Parse(tb_Gio.Text) && dmsc.ThoiGianBatDau.Minute == int.Parse(tb_Phut.Text)
select dmsc;
if (query.Count<DanhMucSuatChieu>() == 0)
{
DanhMucSuatChieu dmsc = new DanhMucSuatChieu();
DateTime time = new DateTime(1990, 1, 1);
time = time.AddHours(int.Parse(tb_Gio.Text));
time = time.AddMinutes(int.Parse(tb_Phut.Text));
dmsc.ThoiGianBatDau = time;
dmsc.TinhTrang = true;
dmsc.GiaDanhMuc = int.Parse(tb_GiaDanhMucSuatMoi.Text);
dt.DanhMucSuatChieus.InsertOnSubmit(dmsc);
dt.SubmitChanges();
}
}
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 Xl_DangNhap_Click(object sender, EventArgs e)
{
try
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
Session["PreviousUrl"] = Request.Url;
string tenDangNhap = Th_TenDangNhap.Text;
string matKhau = Th_MatKhau.Text;
MD5 md5Hasher = MD5.Create();
byte[] data = md5Hasher.ComputeHash(Encoding.Default.GetBytes(matKhau));
StringBuilder sBuilder = new StringBuilder();
for (int i = 0; i < data.Length; i++)
{
sBuilder.Append(data[i].ToString("x2"));
}
string strPassword = sBuilder.ToString();
var query = (from nguoiDung in dt.NguoiDungs
where tenDangNhap.CompareTo(nguoiDung.TenNguoiDung) == 0 && strPassword.CompareTo(nguoiDung.MatKhau) == 0
select nguoiDung).Single();
if (query.TinhTrang == dt.DanhMucTinhTrangNguoiDungs.Where(ttnd=> ttnd.TenDanhMucTinhTrangNguoiDung.CompareTo("Tạm khóa") == 0).Select(ttnd=> ttnd.MaDanhMucTinhTrangNguoiDung).Single())
{
Label2.Text = "Tài khoản đã bị khóa, vui lòng kiểm tra lại";
Label2.Visible = true;
}
else
{
Session["NguoiDung"] = query;
Response.Redirect("dangnhapthanhcong.aspx");
}
}
catch
{
Label2.Text = "Sai tên đăng nhập hoặc mật khẩu";
Label2.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Th_TenPhim.Text == null || Th_TenPhim.Text.Trim().Length == 0)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
Th_TenPhim.Text = ((Phim)Session["CurrentPhim"]).TenPhim;
Th_DaoDien.Text = ((Phim)Session["CurrentPhim"]).DaoDien;
Th_DienVien.Text = ((Phim)Session["CurrentPhim"]).DienVienThamGia;
Th_NgonNgu.Text = ((Phim)Session["CurrentPhim"]).NgonNgu;
Th_NoiDung.Text = ((Phim)Session["CurrentPhim"]).NoiDung;
Th_ThoiLuong.Text = ((Phim)Session["CurrentPhim"]).ThoiLuong.ToString();
Image1.ImageUrl = ((Phim)Session["CurrentPhim"]).AnhPhim;
}
}
catch
{
Response.Redirect("Default.aspx");
}
}
protected void Xl_CapNhatThayDoi_Click(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
var query = (from phim in dt.Phims
where phim.MaPhim == ((Phim)Session["CurrentPhim"]).MaPhim
select phim).Single();
query.TenPhim = Th_TenPhim.Text;
query.NoiDung = Th_NoiDung.Text;
query.TheLoai = int.Parse(DropDownList1.SelectedItem.Value);
query.LoaiPhim = int.Parse(DropDownList2.SelectedItem.Value);
query.ThoiLuong = int.Parse(Th_ThoiLuong.Text);
query.DienVienThamGia = Th_DienVien.Text;
query.DaoDien = Th_DaoDien.Text;
query.NgonNgu = Th_NgonNgu.Text;
if (Th_AnhPhim.FileName != null && Th_AnhPhim.FileName.Trim().Length != 0)
{
string posterFileName = query.MaPhim.ToString() + Th_AnhPhim.FileName.Substring(Th_AnhPhim.FileName.Length - 4);
string posterName = "/phim/poster/" + posterFileName;
Th_AnhPhim.SaveAs(Server.MapPath("/phim/poster/") + posterFileName);
query.AnhPhim = posterName;
}
if (Th_Trailer.FileName != null && Th_Trailer.FileName.Trim().Length != 0)
{
string trailerFileName = query.MaPhim.ToString() + Th_Trailer.FileName.Substring(Th_Trailer.FileName.Length - 4);
string trailerName = "/phim/trailer/" + trailerFileName;
Th_Trailer.SaveAs(Server.MapPath("/phim/trailer/") + trailerFileName);
query.TrailerPhim = trailerName;
}
dt.SubmitChanges();
Session["CurrentPhim"] = query;
Response.Redirect("default.aspx");
}
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 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();
}
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 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;
}
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_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"]));
}
protected void UpdatePanel1_PreRender(object sender, EventArgs e)
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
if (cbb_ChonPhim.SelectedIndex == -1 || cbb_ChonNgay.SelectedIndex == -1 || cbb_Phong.SelectedIndex == -1)
return;
List<DateTime> dsNgayChieu = new List<DateTime>();
for (int i = 0; i < int.Parse(cbb_ChonNgay.SelectedItem.Value); ++i)
dsNgayChieu.Add(DateTime.Today.AddDays(i + 1));
var dsLichChieu = from _lichChieu in dt.LichChieuPhims
where dsNgayChieu.Contains(_lichChieu.NgayChieu)
select _lichChieu;
dl_DsLichChieu.DataSource = dsLichChieu;
dl_DsLichChieu.DataBind();
int count = 0;
foreach (LichChieuPhim _lichchieu in dsLichChieu)
{
Label lb_NgayChieu = (Label)dl_DsLichChieu.Items[count].FindControl("lb_NgayChieu");
lb_NgayChieu.Text = _lichchieu.NgayChieu.ToShortDateString();
DataList dl_SuatChieu = (DataList)dl_DsLichChieu.Items[count].FindControl("dl_SuatChieu");
var dsSuatChieu = (from _suatchieu in dt.SuatChieus
where _suatchieu.MaLichChieu == _lichchieu.MaLichChieuPhim && _suatchieu.MaPhong == int.Parse(cbb_Phong.SelectedItem.Value) && _suatchieu.MaPhim == int.Parse(cbb_ChonPhim.SelectedItem.Value)
select _suatchieu).OrderBy(_suatchieu => _suatchieu.DanhMucSuatChieu.ThoiGianBatDau);
dsSuatChieu.OrderBy(_suatchieu => _suatchieu.DanhMucSuatChieu.ThoiGianBatDau);
dl_SuatChieu.DataSource = dsSuatChieu;
dl_SuatChieu.DataBind();
int _count = 0;
foreach (SuatChieu _suatchieu in dsSuatChieu)
{
Label lb_ThoiGian = (Label)dl_SuatChieu.Items[_count].FindControl("lb_ThoiGian");
lb_ThoiGian.Text = _suatchieu.DanhMucSuatChieu.ThoiGianBatDau.ToShortTimeString();
Label lb_Phong = (Label)dl_SuatChieu.Items[_count].FindControl("lb_Phong");
lb_Phong.Text = _suatchieu.PhongChieuPhim.TenPhongChieuPhim;
Label lb_Phim = (Label)dl_SuatChieu.Items[_count].FindControl("lb_Phim");
lb_Phim.Text = _suatchieu.Phim.TenPhim;
Label lb_TinhTrang = (Label)dl_SuatChieu.Items[_count].FindControl("lb_TinhTrang");
var dsSuatChieuCungGio = from __suatchieu in dt.SuatChieus
where __suatchieu.MaPhong == _suatchieu.MaPhong && __suatchieu.MaDanhMucSuatChieu == _suatchieu.MaDanhMucSuatChieu && __suatchieu.MaSuatChieu != _suatchieu.MaSuatChieu && __suatchieu.MaLichChieu == _suatchieu.MaLichChieu
|| (((__suatchieu.DanhMucSuatChieu.ThoiGianBatDau.CompareTo(_suatchieu.DanhMucSuatChieu.ThoiGianBatDau) > 0 && __suatchieu.DanhMucSuatChieu.ThoiGianBatDau.CompareTo(_suatchieu.DanhMucSuatChieu.ThoiGianBatDau.AddMinutes(_suatchieu.Phim.ThoiLuong)) <= 0)
|| (_suatchieu.DanhMucSuatChieu.ThoiGianBatDau.CompareTo(__suatchieu.DanhMucSuatChieu.ThoiGianBatDau) > 0 && _suatchieu.DanhMucSuatChieu.ThoiGianBatDau.CompareTo(__suatchieu.DanhMucSuatChieu.ThoiGianBatDau.AddMinutes(__suatchieu.Phim.ThoiLuong)) <= 0))
&& __suatchieu.DanhMucSuatChieu.SuatChieus.Count<SuatChieu>(___suatchieu => ___suatchieu.MaLichChieu == _suatchieu.MaLichChieu) != 0)
select __suatchieu;
((LinkButton)dl_SuatChieu.Items[_count].FindControl("btn_ThayDoi")).Text = "Xóa";
Session["DungDo"] = false;
if (dsSuatChieuCungGio.Count<SuatChieu>() != 0)
{
lb_TinhTrang.Text = "Đụng độ";
lb_TinhTrang.ForeColor = Color.Red;
Session["DungDo"] = true;
}
++_count;
}
++count;
}
}
protected void Xl_ThemBinhLuan_Click(object sender, EventArgs e)
{
try
{
CinemaLINQDataContext dt = new CinemaLINQDataContext();
BinhLuan bl = new BinhLuan();
bl.MaPhim = ((Phim)Session["CurrentPhim"]).MaPhim;
bl.NoiDungBinhLuan = Th_BinhLuanMoi.Text;
bl.MaNguoiDung = ((NguoiDung)Session["NguoiDung"]).MaNguoiDung;
bl.TinhTrang = dt.DanhMucTinhTrangBinhLuans.Where(ttbl => ttbl.TenTinhTrang.CompareTo("Bình thường")==0).Select(ttbl => ttbl.MaTinhTrang).Single();
bl.ThoiGianBinhLuan = DateTime.Now;
dt.BinhLuans.InsertOnSubmit(bl);
dt.SubmitChanges();
Th_BinhLuanMoi.Text = "";
//Response.Redirect("/phim/chitietphim.aspx");
}
catch
{
//Response.Redirect("/phim/chitietphim.aspx");
}
}