public static void InitDataCheck()
{
QLBanVePhimEntities db = new QLBanVePhimEntities();
var list_GiaVe = db.gia_ve.Where(x => x.id == "WEEKDAY" || x.id == "WEEKEND").ToList();
var list_LoaiGhe = db.loai_ghe.Where(x => x.id == "NORMAL" || x.id == "VIP").ToList();
var list_FoodSize = db.kich_co_do_an.Where(x => x.id == "S" || x.id == "M" || x.id == "L").ToList();
var list_DDP = db.dinh_dang_phim.Where(x => x.id == "2d" || x.id == "3d").ToList();
if (list_GiaVe.Count() < 2)
{
InitDataGenerator("GiaVe");
}
if (list_LoaiGhe.Count() < 2)
{
InitDataGenerator("LoaiGhe");
}
if (list_FoodSize.Count() < 3)
{
InitDataGenerator("FoodSize");
}
if (list_DDP.Count() < 2)
{
InitDataGenerator("DDP");
}
}
public static void TicketCheck()
{
QLBanVePhimEntities db = new QLBanVePhimEntities();
var dsve = db.ve_ban.Where(s => s.trang_thai == "Book").ToList();
bool flag = false;
foreach (ve_ban ve in dsve)
{
DateTime ngChieu = (DateTime)ve.suat_chieu.ngay_chieu;
TimeSpan gioChieu = (TimeSpan)ve.suat_chieu.gio_bat_dau;
if (ngChieu.Date < DateTime.Today)
{
flag = true;
}
else if (ngChieu.Date == DateTime.Today)
{
if (DateTime.Now.TimeOfDay >= gioChieu)
{
flag = true;
}
}
if (flag)
{
ve.ghe_ngoi.da_chon = false;
ve.trang_thai = "Cancelled";
}
}
db.SaveChanges();
}
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;
}
}
