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); }