public void findSoLuongGhe(string MaRap, ref int hangGhe)
{
QuanLyRapPhimDataContext qlrp = new QuanLyRapPhimDataContext();
var temp = (from i in qlrp.Raps where i.MaRap == MaRap select i.SoDayGhe).ToList();
hangGhe = Convert.ToInt32(temp[0]);
}
public System.Data.Linq.Table <DatVe> LayThongTinVe()
{
DataSet ds = new DataSet();
QuanLyRapPhimDataContext qlv = new QuanLyRapPhimDataContext();
return(qlv.DatVes);
}
public System.Data.Linq.Table <Phim> LayPhim()
{
DataSet ds = new DataSet();
QuanLyRapPhimDataContext qlP = new QuanLyRapPhimDataContext();
return(qlP.Phims);
}
public System.Data.Linq.Table <NhanVien> LayNhanVien()
{
DataSet ds = new DataSet();
QuanLyRapPhimDataContext qlNV = new QuanLyRapPhimDataContext();
return(qlNV.NhanViens);
}
public System.Data.Linq.Table <KhachHang> LayKhachHang()
{
DataSet ds = new DataSet();
QuanLyRapPhimDataContext qlKH = new QuanLyRapPhimDataContext();
return(qlKH.KhachHangs);
}
public System.Data.Linq.Table <ChucVu> LayChucVu()
{
DataSet ds = new DataSet();
QuanLyRapPhimDataContext qlCV = new QuanLyRapPhimDataContext();
return(qlCV.ChucVus);
}
public void findsodayghe(string marap, ref int dayGhe)
{
QuanLyRapPhimDataContext qlrp = new QuanLyRapPhimDataContext();
var temp = (from i in qlrp.Raps where i.MaRap == marap select i.SoDayGhe).ToList();
dayGhe = Convert.ToInt32(temp[0]);
}
public int findrap(string marap)
{
QuanLyRapPhimDataContext qlrp = new QuanLyRapPhimDataContext();
var temp = qlrp.Raps.Where(item => item.MaRap == marap).ToList();
return(temp.Count);
}
public System.Data.Linq.Table <SuatChieuPhim> LaySuatChieu()
{
DataSet ds = new DataSet();
QuanLyRapPhimDataContext qlSC = new QuanLyRapPhimDataContext();
return(qlSC.SuatChieuPhims);
}
public System.Data.Linq.Table <Rap> LayRap()
{
DataSet ds = new DataSet();
QuanLyRapPhimDataContext qlR = new QuanLyRapPhimDataContext();
return(qlR.Raps);
}
public void findBookedSeat(string maRap, string tgChieu, ref List <string> bookedSeatAlpha, ref List <string> bookedSeatNum)
{
QuanLyRapPhimDataContext qlrp = new QuanLyRapPhimDataContext();
var query = (from i in qlrp.DatVes where i.MaRap == maRap && i.SuatChieu == tgChieu select new { i.Day, i.So }).ToList();
for (int i = 0; i < query.Count; i++)
{
bookedSeatAlpha.Add(query[i].Day);
bookedSeatNum.Add(query[i].So.ToString());
}
}
public bool TimKiemNhanVien(string Ten)
{
QuanLyRapPhimDataContext qlNV = new QuanLyRapPhimDataContext();
var nvQuery = (from nv in qlNV.NhanViens where nv.TenNV == Ten select nv).FirstOrDefault();
if (nvQuery != null)
{
return(true);
}
return(false);
}
private void cbbMaCV_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbbMaCV.ValueMember == "")
{
return;
}
using (QuanLyRapPhimDataContext db = new QuanLyRapPhimDataContext())
{
txtChucVu.Text = dgv_NHANVIEN.SelectedCells[0].OwningRow.Cells["ChucVu"].Value.ToString();
txtLuong.Text = dgv_NHANVIEN.SelectedCells[0].OwningRow.Cells["Luong"].Value.ToString();
}
}
public DataTable right()
{
DataTable dt = new DataTable();
dt.Clear();
QuanLyRapPhimDataContext qlrp = new QuanLyRapPhimDataContext();
var query = (from i in qlrp.DatVes join j in qlrp.Phims on i.MaPhim equals j.MaPhim select new { i.SuatChieu, j.TenPhim, j.MaPhim }).ToList();
for (int i = 0; i < query.Count; i++)
{
dt.Rows[i].ItemArray[0] = query[i].MaPhim;
dt.Rows[i].ItemArray[1] = query[i].SuatChieu;
dt.Rows[i].ItemArray[2] = query[i].TenPhim;
}
return(dt);
}
public bool XoaNhanVien(ref string err, string MaNV)
{
try
{
QuanLyRapPhimDataContext qlNV = new QuanLyRapPhimDataContext();
var nvQuery = from nv in qlNV.NhanViens
where nv.MaNV == MaNV
select nv;
qlNV.NhanViens.DeleteAllOnSubmit(nvQuery);
qlNV.SubmitChanges();
}
catch (SqlException)
{
MessageBox.Show("Không xóa được. Lỗi rồi!!!");
}
return(true);
}
public bool XoaKhachHang(ref string err, string MaKH)
{
try
{
QuanLyRapPhimDataContext qlKH = new QuanLyRapPhimDataContext();
var khQuery = from kh in qlKH.KhachHangs
where kh.MaKH == MaKH
select kh;
qlKH.KhachHangs.DeleteAllOnSubmit(khQuery);
qlKH.SubmitChanges();
}
catch (SqlException)
{
MessageBox.Show("Không xóa được. Lỗi rồi!!!");
}
return(true);
}
public bool XoaRap(ref string err, string MaRap)
{
try
{
QuanLyRapPhimDataContext qlR = new QuanLyRapPhimDataContext();
var rQuery = from r in qlR.Raps
where r.MaRap == MaRap
select r;
qlR.Raps.DeleteAllOnSubmit(rQuery);
qlR.SubmitChanges();
}
catch (SqlException)
{
MessageBox.Show("Không xóa được. Lỗi rồi!!!");
}
return(true);
}
public bool XoaPhim(ref string err, string MaPhim)
{
try
{
QuanLyRapPhimDataContext qlP = new QuanLyRapPhimDataContext();
var pQuery = from p in qlP.Phims
where p.MaPhim == MaPhim
select p;
qlP.Phims.DeleteAllOnSubmit(pQuery);
qlP.SubmitChanges();
}
catch (SqlException)
{
MessageBox.Show("Không xóa được. Lỗi rồi!!!");
}
return(true);
}
public bool themVe(string MaPhim, string Rap, string SuatChieu, string MaNV, string MaKH, string Day, string Ghe, ref string err)
{
QuanLyRapPhimDataContext qlrp = new QuanLyRapPhimDataContext();
DatVe datVe = new DatVe();
datVe.MaPhim = MaPhim;
datVe.MaRap = Rap;
datVe.SuatChieu = SuatChieu;
datVe.MaNV = MaNV;
datVe.MaKH = MaKH;
datVe.Day = Day;
datVe.So = Convert.ToInt32(Ghe);
qlrp.DatVes.InsertOnSubmit(datVe);
qlrp.DatVes.Context.SubmitChanges();
return(true);
//string sqlString = $"Insert Into DatVe values('{MaPhim.Trim()}','{SuatChieu.Trim()}','{MaNV.Trim()}','{MaKH.Trim()}','{Rap.Trim()}','{Day.Trim()}','{Ghe.Trim()}')";
//return db.MyExecuteNonQuery(sqlString, CommandType.Text, ref err);
}
public bool XoaSuatChieu(ref string err, string SuatChieu)
{
try
{
QuanLyRapPhimDataContext qlSC = new QuanLyRapPhimDataContext();
var scQuery = from sc in qlSC.SuatChieuPhims
where sc.SuatChieu == SuatChieu
select sc;
qlSC.SuatChieuPhims.DeleteAllOnSubmit(scQuery);
qlSC.SubmitChanges();
}
catch (SqlException)
{
MessageBox.Show("Không xóa được. Lỗi rồi!!!");
}
return(true);
}
public bool XoaChucVu(ref string err, string MaCV)
{
try
{
QuanLyRapPhimDataContext qlCV = new QuanLyRapPhimDataContext();
var cvQuery = from cv in qlCV.ChucVus
where cv.MaCV == MaCV
select cv;
qlCV.ChucVus.DeleteAllOnSubmit(cvQuery);
qlCV.SubmitChanges();
}
catch (SqlException)
{
MessageBox.Show("Không xóa được. Lỗi rồi!!!");
}
return(true);
}
public bool ThemSuatChieu(string MaPhim, string SuatChieu, string MaRap, ref string err)
{
try
{
QuanLyRapPhimDataContext qlSC = new QuanLyRapPhimDataContext();
SuatChieuPhim sc = new SuatChieuPhim();
sc.MaPhim = MaPhim;
sc.SuatChieu = SuatChieu;
sc.MaRap = MaRap;
qlSC.SuatChieuPhims.InsertOnSubmit(sc);
qlSC.SuatChieuPhims.Context.SubmitChanges();
}
catch (SqlException)
{
MessageBox.Show("Không thêm được. Lỗi rồi!");
}
return(true);
}
public bool CapNhatChucVu(string MaCV, string ChucVu, int Luong, ref string err)
{
try
{
QuanLyRapPhimDataContext qlCV = new QuanLyRapPhimDataContext();
var cvQuery = (from cv in qlCV.ChucVus where cv.MaCV == MaCV select cv).SingleOrDefault();
if (cvQuery != null)
{
cvQuery.ChucVu1 = ChucVu;
cvQuery.Luong = Luong;
qlCV.SubmitChanges();
}
}
catch (SqlException)
{
MessageBox.Show("Không sửa được. Lỗi rồi!");
}
return(true);
}
public bool CapNhatKhachHang(string MaKH,
string TenKH, ref string err)
{
try
{
QuanLyRapPhimDataContext qlKH = new QuanLyRapPhimDataContext();
var khQuery = (from kh in qlKH.KhachHangs where kh.MaKH == MaKH select kh).SingleOrDefault();
if (khQuery != null)
{
khQuery.TenKH = TenKH;
qlKH.SubmitChanges();
}
}
catch (SqlException)
{
MessageBox.Show("Không sửa được. Lỗi rồi!");
}
return(true);
}
public bool CapNhatSuatChieu(string MaPhim, string SuatChieu, string MaRap, ref string err)
{
try
{
QuanLyRapPhimDataContext qlSC = new QuanLyRapPhimDataContext();
var scQuery = (from sc in qlSC.SuatChieuPhims where sc.MaPhim == MaPhim select sc).SingleOrDefault();
if (scQuery != null)
{
scQuery.SuatChieu = SuatChieu;
scQuery.MaRap = MaRap;
qlSC.SubmitChanges();
}
}
catch (SqlException)
{
MessageBox.Show("Không sửa được. Lỗi rồi!");
}
return(true);
}
public bool ThemRap(string MaRap, string SoDayGhe,
string SoLuongGhe, string LoaiRap, ref string err)
{
try
{
QuanLyRapPhimDataContext qlR = new QuanLyRapPhimDataContext();
Rap r = new Rap();
r.SoDayGhe = SoDayGhe;
r.SoLuongGhe = SoLuongGhe;
r.LoaiPhim = LoaiRap;
qlR.Raps.InsertOnSubmit(r);
qlR.Raps.Context.SubmitChanges();
}
catch (SqlException)
{
MessageBox.Show("Không thêm được. Lỗi rồi!");
}
return(true);
}
public bool ThemChucVu(string MaCV, string ChucVu,
int Luong, ref string err)
{
try
{
QuanLyRapPhimDataContext qlCV = new QuanLyRapPhimDataContext();
ChucVu cv = new ChucVu();
cv.MaCV = MaCV;
cv.ChucVu1 = ChucVu;
cv.Luong = Luong;
qlCV.ChucVus.InsertOnSubmit(cv);
qlCV.ChucVus.Context.SubmitChanges();
}
catch (SqlException)
{
MessageBox.Show("Không thêm được. Lỗi rồi!");
}
return(true);
}
public bool ThemKhachHang(string MaKH, string HovaTenLotKH,
string TenKH, ref string err)
{
try
{
QuanLyRapPhimDataContext qlKH = new QuanLyRapPhimDataContext();
KhachHang kh = new KhachHang();
kh.MaKH = MaKH;
kh.HovaLotKH = HovaTenLotKH;
kh.TenKH = TenKH;
qlKH.KhachHangs.InsertOnSubmit(kh);
qlKH.KhachHangs.Context.SubmitChanges();
}
catch (SqlException)
{
MessageBox.Show("Không thêm được. Lỗi rồi!");
}
return(true);
}
public bool ThemPhim(string TenPhim, string MaPhim, int GiaVe, MemoryStream Poster, ref string err)
{
try
{
QuanLyRapPhimDataContext qlP = new QuanLyRapPhimDataContext();
Phim p = new Phim();
p.TenPhim = TenPhim;
p.MaPhim = MaPhim;
p.GiaVe = GiaVe;
p.Poster = Poster.ToArray();
qlP.Phims.InsertOnSubmit(p);
qlP.Phims.Context.SubmitChanges();
}
catch (SqlException)
{
MessageBox.Show("Không thêm được. Lỗi rồi!");
}
return(true);
}
public bool CapNhatPhim(string MaPhim, string TenPhim, int GiaVe, MemoryStream Poster, ref string err)
{
try
{
QuanLyRapPhimDataContext qlP = new QuanLyRapPhimDataContext();
var pQuery = (from p in qlP.Phims where p.MaPhim == MaPhim select p).SingleOrDefault();
if (pQuery != null)
{
pQuery.TenPhim = TenPhim;
pQuery.GiaVe = GiaVe;
pQuery.Poster = Poster.ToArray();
qlP.SubmitChanges();
}
}
catch (SqlException)
{
MessageBox.Show("Không sửa được. Lỗi rồi!");
}
return(true);
}
