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();
}
}
}
}
partial void DeleteSuatChieu(SuatChieu instance);
partial void UpdateSuatChieu(SuatChieu instance);
partial void InsertSuatChieu(SuatChieu instance);
private void detach_SuatChieus(SuatChieu entity)
{
this.SendPropertyChanging();
entity.PhongChieuPhim = null;
}
private void attach_SuatChieus(SuatChieu entity)
{
this.SendPropertyChanging();
entity.Phim = this;
}
private void detach_SuatChieus(SuatChieu entity)
{
this.SendPropertyChanging();
entity.DanhMucSuatChieu = null;
}
