public ActionResult Update_GV(FormCollection form)
{
if (!AuthCheck("admin"))
{
return(RedirectToAction("Index", "QLHome"));
}
string id = form["idGV_edit"].ToString();
gia_ve gv = db.gia_ve.Where(item => item.id == id).FirstOrDefault();
gv.ten = form["tenGV_edit"].ToString();
gv.don_gia = int.Parse(form["dongiaGV_edit"]);
db.SaveChanges();
return(Redirect(Url.Action("Index", "QLSetting") + "#GV"));
}
private static void InitDataGenerator(string type)
{
QLBanVePhimEntities db = new QLBanVePhimEntities();
switch (type)
{
case "GiaVe":
if (db.gia_ve.Where(x => x.id == "WEEKDAY").ToList().Count() == 0)
{
gia_ve gv = new gia_ve();
gv.id = "WEEKDAY";
gv.ten = "Ngay Thuong";
gv.don_gia = 50000;
db.gia_ve.Add(gv);
}
if (db.gia_ve.Where(x => x.id == "WEEKEND").ToList().Count() == 0)
{
gia_ve gv2 = new gia_ve();
gv2.id = "WEEKEND";
gv2.ten = "Cuoi Tuan";
gv2.don_gia = 70000;
db.gia_ve.Add(gv2);
}
db.SaveChanges();
break;
case "LoaiGhe":
if (db.loai_ghe.Where(x => x.id == "NORMAL").ToList().Count() == 0)
{
loai_ghe lg = new loai_ghe();
lg.id = "NORMAL";
lg.ten_ghe = "Normal";
lg.phu_thu = 0;
db.loai_ghe.Add(lg);
}
if (db.loai_ghe.Where(x => x.id == "VIP").ToList().Count() == 0)
{
loai_ghe lg2 = new loai_ghe();
lg2.id = "VIP";
lg2.ten_ghe = "VIP";
lg2.phu_thu = 0;
db.loai_ghe.Add(lg2);
}
db.SaveChanges();
break;
case "FoodSize":
if (db.kich_co_do_an.Where(x => x.id == "S").ToList().Count() == 0)
{
kich_co_do_an fs = new kich_co_do_an
{
id = "S",
ten = "Nhỏ"
};
db.kich_co_do_an.Add(fs);
}
if (db.kich_co_do_an.Where(x => x.id == "M").ToList().Count() == 0)
{
kich_co_do_an fs2 = new kich_co_do_an
{
id = "M",
ten = "Vừa"
};
db.kich_co_do_an.Add(fs2);
}
if (db.kich_co_do_an.Where(x => x.id == "L").ToList().Count() == 0)
{
kich_co_do_an fs3 = new kich_co_do_an
{
id = "L",
ten = "Lớn"
};
db.kich_co_do_an.Add(fs3);
}
db.SaveChanges();
break;
case "DDP":
if (db.dinh_dang_phim.Where(x => x.id == "2d").ToList().Count() == 0)
{
dinh_dang_phim ddp = new dinh_dang_phim
{
id = "2d",
ten = "2D",
phu_thu = 0
};
db.dinh_dang_phim.Add(ddp);
}
if (db.dinh_dang_phim.Where(x => x.id == "3d").ToList().Count() == 0)
{
dinh_dang_phim ddp2 = new dinh_dang_phim
{
id = "3d",
ten = "3D",
phu_thu = 20000
};
db.dinh_dang_phim.Add(ddp2);
}
db.SaveChanges();
break;
default:
break;
}
}
public ActionResult OrderTicket(string suatChieu, string dsGhe)
{
try
{
Random random = new Random();
string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789qwertyuiopasdfghjklzxcvbnm";
//Session["Id"] = 1;
//Dòng trên chỉ để test code
suat_chieu sc = database.suat_chieu.Where(s => s.id == suatChieu).FirstOrDefault();
ve_dat veDat = new ve_dat();
string[] listGhe = dsGhe.Split(',');
int tienDinhDangPhim = 0;
int tongTien = 0;
if (sc.dinh_dang_phim_id != "2D")
{
tienDinhDangPhim = (int)sc.dinh_dang_phim.phu_thu;
}
string randomChar = new string(Enumerable.Repeat(chars, 3).Select(s => s[random.Next(s.Length)]).ToArray());
veDat.id = Session["Id"].ToString() + "-" + sc.id + "-" + DateTime.Now.Second + randomChar;
veDat.khach_hang_id = Convert.ToInt32(Session["Id"]);
veDat.ngay_dat = DateTime.Now.Date;
database.ve_dat.Add(veDat);
database.SaveChanges();
string randomChr = new string(Enumerable.Repeat(chars, 5).Select(s => s[random.Next(s.Length)]).ToArray());
foreach (var item in listGhe)
{
ve_ban veBan = new ve_ban();
ve_dat_chi_tiet veDatChiTiet = new ve_dat_chi_tiet();
ghe_ngoi ghe = database.ghe_ngoi.Where(g => g.id == item).FirstOrDefault();
ghe.da_chon = true;
veBan.id = sc.id + "-" + ghe.id + "-" + randomChr;
veBan.suat_chieu_id = sc.id;
if (DateTime.Today.DayOfWeek == DayOfWeek.Saturday || DateTime.Today.DayOfWeek == DayOfWeek.Sunday)
{
veBan.gia_ve_id = "WEEKEND";
gia_ve giaVe = database.gia_ve.Where(gv => gv.id == veBan.gia_ve_id).FirstOrDefault();
veBan.tong__tien = tienDinhDangPhim + ghe.loai_ghe.phu_thu + giaVe.don_gia;
tongTien += (int)veBan.tong__tien;
}
else
{
veBan.gia_ve_id = "WEEKDAY";
gia_ve giaVe = database.gia_ve.Where(gv => gv.id == veBan.gia_ve_id).FirstOrDefault();
veBan.tong__tien = tienDinhDangPhim + ghe.loai_ghe.phu_thu + giaVe.don_gia;
tongTien += (int)veBan.tong__tien;
}
veBan.ghe_id = ghe.id;
veBan.trang_thai = "Book";
veBan.nhan_vien_id = database.nguoi_dung.FirstOrDefault().id;
//Dòng trên chỉ để test code
veDatChiTiet.id = veBan.id;
veDatChiTiet.ve_dat_id = veDat.id;
database.ve_ban.Add(veBan);
database.ve_dat_chi_tiet.Add(veDatChiTiet);
database.SaveChanges();
}
TempData["CodeDatVe"] = veDat.id.ToString();
TempData["MaKhachHang"] = veDat.khach_hang_id.ToString();
TempData["Phim"] = sc.phim.ten.ToString();
TempData["ThoiLuong"] = sc.phim.thoi_luong.ToString();
TempData["BatDau"] = sc.gio_bat_dau.ToString();
TempData["TongTien"] = tongTien.ToString();
return(Redirect("Confirmation"));
}
catch (Exception ex)
{
return(Content(ex.ToString()));
}
}
