public void LoadData() { using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { SucChua = (from dd in db.DIADIEMTOCHUCs where dd.IDDD == HoiNghi.IDDD select dd).First().SUCCHUA; var ListUser = db.USERs; this.ListDangKyUser = new ObservableCollection <XacNhanDangKyUser>(); foreach (var user in ListUser) { foreach (var dangKy in db.DANGKITHAMGIAs) { if (dangKy.IDUSER == user.IDUSER && dangKy.IDHN == HoiNghi.IDHN) { if (user.HINHANH != string.Empty) { user.HINHANH = Path.GetFullPath(user.HINHANH); } else { user.HINHANH = Path.GetFullPath("Images/user_example.png"); } XacNhanDangKyUser capQuyenUser = new XacNhanDangKyUser(user, dangKy, HoiNghi, SucChua); ListDangKyUser.Add(capQuyenUser); } } } } }
public ChiTietHoiNghiViewModel(HOINGHI hoiNghi, Window window) { this.Window = window; using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { this.HoiNghi = hoiNghi; DIADIEMTOCHUC diaDiem = (from dd in db.DIADIEMTOCHUCs where dd.IDDD == hoiNghi.IDDD select dd).ToList().FirstOrDefault(); this.DiaDiem = diaDiem.TENDD + ", " + diaDiem.DIACHI; this.SucChua = diaDiem.SUCCHUA; if (DangNhapViewModel.User == null) { this.Status = 0; this.SignUpCommand = new RelayCommand(SignUp); } else { DANGKITHAMGIA dktg = (from dk in db.DANGKITHAMGIAs where dk.IDUSER == DangNhapViewModel.User.IDUSER && dk.IDHN == hoiNghi.IDHN select dk).FirstOrDefault(); this.Status = dktg != null ? (dktg.TRANGTHAI == 1 ? -1 : 1) : 0; this.SignUpCommand = Status == 0 ? new RelayCommand(SignUp) : new RelayCommand(UnSignUp); } } this.NgayBatDau = this.HoiNghi.THOIGIANBATDAU.ToString("dd/MM/yyyy hh:mm"); this.NgayKetThuc = this.HoiNghi.THOIGIANKETTHUC.ToString("dd/MM/yyyy hh:mm"); this.ImagePathHoiNghi = Path.Combine(Environment.CurrentDirectory, this.HoiNghi.HINHANH); }
private void LoadData() { this.TenHoiNghi = this.HoiNghi.TENHN; this.NoiDungHoiNghi = this.HoiNghi.MOTACHITIETHN; this.NgayBatDau = this.HoiNghi.THOIGIANBATDAU; this.NgayKetThuc = this.HoiNghi.THOIGIANKETTHUC; this.ImagePathHoiNghi = Path.Combine(Environment.CurrentDirectory, this.HoiNghi.HINHANH); IsChooseImage = !String.IsNullOrEmpty(this.ImagePathHoiNghi); this.SoLuong = this.HoiNghi.SOLUONG.ToString(); this.MoTa = this.HoiNghi.MOTANGANHN; this.ListDiaDiemString = new List <string>(); using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { this.ListDiaDiem = (from dd in db.DIADIEMTOCHUCs select dd).ToList(); for (int i = 0; i < this.ListDiaDiem.Count; i++) { this.ListDiaDiemString.Add(this.ListDiaDiem[i].TENDD + ", " + this.ListDiaDiem[i].DIACHI); if (this.ListDiaDiem[i].IDDD == this.HoiNghi.IDDD) { this.IndexDiaDiem = i; } } } }
public bool kiemTraUser(string username, string password) { using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { USER user = null; var hasuser = from us in db.USERs where us.USERNAME == username select us; if (hasuser.Count() <= 0) { return(false); } user = hasuser.First(); if (user.PASSWORD != password) { return(false); } User = user; User.HINHANH = System.IO.Path.GetFullPath(User.HINHANH); return(true); } }
public List <string> layTatCaUserName() { using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { var list = from user in db.USERs select user.USERNAME; return(list.ToList()); } }
public static List <HOINGHI> GetAllHoiNghi() { List <HOINGHI> list = new List <HOINGHI>(); using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { list = db.HOINGHIs.ToList(); } return(list); }
public static List <HOINGHI> GetResultSearchHoiNghiDaDangKy(string name, string place, DateTime date) { List <HOINGHI> list = new List <HOINGHI>(); using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { string sqlHoiNghi = $"select * from HOINGHI where freetext(TENHN, N'%{name}%')"; List <HOINGHI> resultHoiNghi = db.HOINGHIs.SqlQuery(sqlHoiNghi).ToList(); DateTime defaultDate = new DateTime(); if (date != defaultDate) { if (resultHoiNghi.Count <= 0) { resultHoiNghi = db.HOINGHIs.ToList(); } resultHoiNghi = (from item in resultHoiNghi where item.THOIGIANBATDAU.Date == date.Date select item).ToList(); } string sqlDiaDiem = $"select* from DIADIEMTOCHUC where freetext(TENDD, N'%{place}%')"; var resultDiaDiem = db.DIADIEMTOCHUCs.SqlQuery(sqlDiaDiem); if (resultDiaDiem.Count() > 0 && resultHoiNghi.Count > 0) { var result = from hn in resultHoiNghi join dd in resultDiaDiem on hn.IDDD equals dd.IDDD select hn; list = result.ToList(); } else if (resultHoiNghi.Count > 0) { list = resultHoiNghi; } else if (resultDiaDiem.Count() > 0) { string sql = $"select hn.IDHN, hn.IDDD, TENHN,hn.MOTANGANHN, hn.MOTACHITIETHN, hn.HINHANH, hn.THOIGIANBATDAU, hn.THOIGIANKETTHUC, hn.SOLUONG from HOINGHI as hn join DIADIEMTOCHUC as dd on hn.IDDD = dd.IDDD where (dd.TENDD LIKE N'%{place}%')"; var result = db.HOINGHIs.SqlQuery(sql); list = result.ToList(); } var listHN = from hn in list join dk in db.DANGKITHAMGIAs on hn.IDHN equals dk.IDHN where dk.IDUSER == DangNhapViewModel.User.IDUSER select hn; list = listHN.ToList(); } return(list); }
private void SignUp() { if (DangNhapViewModel.User == null) { DangNhapWindow dangNhapWindow = new DangNhapWindow(); dangNhapWindow.Show(); this.Window.Close(); } else { if (this.HoiNghi.SOLUONG >= this.SucChua) { MessageBox.Show("Số lượng tham gia hội nghị đã đạt giới hạn."); return; } try { using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { DANGKITHAMGIA dktg = (from dk in db.DANGKITHAMGIAs where dk.IDUSER == DangNhapViewModel.User.IDUSER && dk.IDHN == this.HoiNghi.IDHN select dk).FirstOrDefault(); if (dktg != null && dktg.TRANGTHAI == 1) { MessageBox.Show("Bạn đã bị chặn."); return; } DANGKITHAMGIA dangky = new DANGKITHAMGIA(); dangky.IDHN = this.HoiNghi.IDHN; dangky.IDUSER = DangNhapViewModel.User.IDUSER; dangky.TRANGTHAI = 0; dangky.THOIGIANDK = DateTime.Now; db.DANGKITHAMGIAs.Add(dangky); db.SaveChanges(); } Status = 1; SignUpCommand = new RelayCommand(UnSignUp); } catch { MessageBox.Show("Đã có lỗi xảy ra."); } } }
public static List <HOINGHI> GetAllHoiNghiDaDangKy() { List <HOINGHI> list = new List <HOINGHI>(); using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { var listHoiNghi = from hoiNghi in db.HOINGHIs join dangkithamgia in db.DANGKITHAMGIAs on hoiNghi.IDHN equals dangkithamgia.IDHN where dangkithamgia.IDUSER == DangNhapViewModel.User.IDUSER select hoiNghi; list = listHoiNghi.ToList(); } return(list); }
public static List <HOINGHI> GetAllHoiNghiQuanLy() { List <HOINGHI> list = new List <HOINGHI>(); using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { var listHoiNghi = from hoiNghi in db.HOINGHIs join chitietadmin in db.CHITIETADMINs on hoiNghi.IDHN equals chitietadmin.IDHN where chitietadmin.IDUSER == DangNhapViewModel.User.IDUSER select hoiNghi; list = listHoiNghi.ToList(); } return(list); }
public void chinhSuaHinhAnh(string newPathImage) { User.HINHANH = newPathImage; using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { foreach (var us in db.USERs) { if (us.IDUSER == User.IDUSER) { us.HINHANH = newPathImage; break; } } db.SaveChanges(); } }
public void chinhSuaEmailUser(string newEmail) { User.EMAIL = newEmail; using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { foreach (var us in db.USERs) { if (us.IDUSER == User.IDUSER) { us.EMAIL = newEmail; break; } } db.SaveChanges(); } }
public void chinhSuaHoTen(string newName) { User.TENUSER = newName; using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { foreach (var us in db.USERs) { if (us.IDUSER == User.IDUSER) { us.TENUSER = newName; break; } } db.SaveChanges(); } }
private void AddHoiNghi() { if (!ValidateInput()) { return; } try { using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { int id = db.HOINGHIs.Max(hn => hn.IDHN) + 1; HOINGHI HoiNghi = new HOINGHI(); HoiNghi.IDHN = id; HoiNghi.IDDD = ListDiaDiem[IndexDiaDiem].IDDD; HoiNghi.TENHN = TenHoiNghi; HoiNghi.MOTACHITIETHN = NoiDungHoiNghi; HoiNghi.THOIGIANBATDAU = NgayBatDau; HoiNghi.THOIGIANKETTHUC = NgayKetThuc; String path = SaveImage(ImagePathHoiNghi); HoiNghi.HINHANH = path; HoiNghi.MOTANGANHN = MoTa; HoiNghi.SOLUONG = int.Parse(SoLuong); db.HOINGHIs.Add(HoiNghi); db.SaveChanges(); CHITIETADMIN ChiTietAdmin = new CHITIETADMIN(); ChiTietAdmin.IDHN = id; ChiTietAdmin.IDUSER = DangNhapViewModel.User.IDUSER; ChiTietAdmin.LOAIADMIN = "0"; db.CHITIETADMINs.Add(ChiTietAdmin); db.SaveChanges(); IsSaved = true; SavedId = id; MessageBox.Show("Đã thêm hội nghị."); } } catch { MessageBox.Show("Đã có lỗi xảy ra."); return; } }
private void CapQuyen() { if (!IsSaved) { MessageBox.Show("Hội nghị phải được lưu trước khi cấp quyền."); return; } using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { HOINGHI hoiNghi = (HOINGHI)db.HOINGHIs.Where(hn => hn.IDHN == SavedId).FirstOrDefault(); CapQuyenHoiNghiWindow window = new CapQuyenHoiNghiWindow(hoiNghi, "0"); //this.Window.Show(); window.Show(); this.Window.Close(); } }
public void LoadDataByNameAndEmail(string name, string email) { using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { string sql = "select* from [QuanLiHoiNghi].[dbo].[USER] "; string sqlName = $" freetext(TENUSER, N'%{name}%')"; string sqlEmail = $" EMAIL like N'%{email}%'"; if (name != "" && email != "") { sql += "where" + sqlName + "and" + sqlEmail; } else if (name != "") { sql += "where" + sqlName; } else if (email != "") { sql += "where" + sqlEmail; } var ListUser = db.USERs.SqlQuery(sql); this.ListDangKyUser = new ObservableCollection <XacNhanDangKyUser>(); foreach (var user in ListUser) { foreach (var dangKy in db.DANGKITHAMGIAs) { if (dangKy.IDUSER == user.IDUSER && dangKy.IDHN == HoiNghi.IDHN) { if (user.HINHANH != string.Empty) { user.HINHANH = Path.GetFullPath(user.HINHANH); } else { user.HINHANH = Path.GetFullPath("Images/user_example.png"); } XacNhanDangKyUser capQuyenUser = new XacNhanDangKyUser(user, dangKy, HoiNghi, SucChua); ListDangKyUser.Add(capQuyenUser); } } } } }
public void chinhSuaMatKhau(string pass) { string hashPass = this.maHoaMatKhauMD5(pass); User.PASSWORD = hashPass; using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { foreach (var us in db.USERs) { if (us.IDUSER == User.IDUSER) { us.PASSWORD = hashPass; break; } } db.SaveChanges(); } }
private bool ValidateInput() { if (String.IsNullOrEmpty(TenHoiNghi.Trim())) { MessageBox.Show("Mời nhập lại tên hội nghị."); return(false); } if (NgayBatDau >= NgayKetThuc) { MessageBox.Show("Mời chọn lại thời gian."); return(false); } if (String.IsNullOrEmpty(MoTa.Trim())) { MessageBox.Show("Mời nhập lại mô tả."); return(false); } if (String.IsNullOrEmpty(NoiDungHoiNghi.Trim())) { MessageBox.Show("Mời nhập lại nội dung hội nghị."); return(false); } using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { int iddd = this.ListDiaDiem[IndexDiaDiem].IDDD; var listHN = db.HOINGHIs.Where(o => (o.IDDD == iddd && o.IDHN != this.HoiNghi.IDHN && (o.THOIGIANBATDAU >= this.NgayBatDau && o.THOIGIANBATDAU <= this.NgayKetThuc || o.THOIGIANKETTHUC >= this.NgayBatDau && o.THOIGIANKETTHUC <= this.NgayKetThuc) )).ToList(); if (listHN.Count() > 0) { MessageBox.Show("Đã có hội nghị diễn tra trong khung giờ này."); return(false); } } return(true); }
private void LoadData() { ListCapQuyenUser.Clear(); int index = PageIndex - 1; using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { var ListUser = db.USERs.Where(u => u.LOAIUSER.Equals("1")).OrderBy(u => u.IDUSER).Skip(index * USER_PER_PAGE).Take(USER_PER_PAGE).ToList(); var ListChiTietAdmin = db.CHITIETADMINs.Where(ct => ct.IDHN == this.HoiNghi.IDHN).ToList(); foreach (var user in ListUser) { var chiTiet = ListChiTietAdmin.Find(ct => ct.IDUSER == user.IDUSER); CapQuyenUser capQuyenUser = new CapQuyenUser(user, this.HoiNghi.IDHN, chiTiet != null, LoaiAdmin); ListCapQuyenUser.Add(capQuyenUser); } } }
public CapQuyenHoiNghiViewModel(HOINGHI HoiNghi, String type) { this.HoiNghi = HoiNghi; this.LoaiAdmin = type; this.PageIndex = 1; using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { float count = db.USERs.Where(u => u.LOAIUSER.Equals("1")).Count(); LastPage = (int)Math.Ceiling(count / USER_PER_PAGE); Pagination = PageIndex.ToString() + "/" + LastPage.ToString(); } this.ListCapQuyenUser = new ObservableCollection <CapQuyenUser>(); LoadData(); PreviousPageCommand = new RelayCommand(GetPreviousPage); NextPageCommand = new RelayCommand(GetNextPage); }
private void SaveHoiNghi() { if (!ValidateInput()) { LoadData(); return; } try { using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { HOINGHI hoiNghi = (from hn in db.HOINGHIs where hn.IDHN == this.HoiNghi.IDHN select hn).ToList().FirstOrDefault(); hoiNghi.TENHN = TenHoiNghi; hoiNghi.MOTACHITIETHN = NoiDungHoiNghi; hoiNghi.IDDD = this.ListDiaDiem[IndexDiaDiem].IDDD; hoiNghi.THOIGIANBATDAU = NgayBatDau; hoiNghi.THOIGIANKETTHUC = NgayKetThuc; if (!ImagePathHoiNghi.Contains(hoiNghi.HINHANH)) { String path = SaveImage(ImagePathHoiNghi); String oldPath = hoiNghi.HINHANH; hoiNghi.HINHANH = path; } hoiNghi.MOTANGANHN = MoTa; hoiNghi.SOLUONG = int.Parse(SoLuong); db.SaveChanges(); MessageBox.Show("Đã cập nhật thông tin hội nghị."); } } catch (Exception ex) { MessageBox.Show("Đã có lỗi xảy ra."); } }
private void UnSignUp() { if (DangNhapViewModel.User == null) { DangNhapWindow dangNhapWindow = new DangNhapWindow(); dangNhapWindow.Show(); this.Window.Close(); } else { try { using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { var dky = from dk in db.DANGKITHAMGIAs where dk.IDHN == this.HoiNghi.IDHN && dk.IDUSER == DangNhapViewModel.User.IDUSER select dk; if (dky.Count() > 0) { if (dky.First().TRANGTHAI == 2) { HOINGHI hn = db.HOINGHIs.Where(o => o.IDHN == this.HoiNghi.IDHN).FirstOrDefault(); hn.SOLUONG -= 1; } db.DANGKITHAMGIAs.Remove(dky.First()); db.SaveChanges(); Status = 0; SignUpCommand = new RelayCommand(SignUp); } } } catch { MessageBox.Show("Đã có lỗi xảy ra."); } } }
public void themUser(string ten, string tenDangNhap, string matKhau, string email, string loaiUser) { using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { var list = from us in db.USERs orderby us.IDUSER descending select us; int idMax = list.ToList().First().IDUSER; USER user = new USER(); user.IDUSER = idMax + 1; user.TENUSER = ten; user.USERNAME = tenDangNhap; user.PASSWORD = matKhau; user.EMAIL = email; user.LOAIUSER = loaiUser; user.HINHANH = "Images/user_example.png"; db.USERs.Add(user); db.SaveChanges(); } }
private void CapQuyen() { this.IsCapQuyen = !this.IsCapQuyen; try { if (this.IsCapQuyen) { using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { CHITIETADMIN chiTiet = new CHITIETADMIN(); chiTiet.IDHN = IdHN; chiTiet.IDUSER = User.IDUSER; chiTiet.LOAIADMIN = LoaiAdmin; db.CHITIETADMINs.Add(chiTiet); db.SaveChanges(); } } else { using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { CHITIETADMIN chiTiet = (from ct in db.CHITIETADMINs where ct.IDHN == IdHN && ct.IDUSER == User.IDUSER select ct).ToList().FirstOrDefault(); db.CHITIETADMINs.Remove(chiTiet); db.SaveChanges(); } } } catch { this.IsCapQuyen = !this.IsCapQuyen; MessageBox.Show("Đã có lỗi xảy ra."); } }
public ThemHoiNghiViewModel(Window window) { this.Window = window; ImagePathHoiNghi = NoiDungHoiNghi = TenHoiNghi = MoTa = ""; SoLuong = "0"; NgayBatDau = NgayKetThuc = DateTime.Now; IsChooseImage = IsSaved = false; IndexDiaDiem = -1; ListDiaDiemString = new List <string>(); using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { this.ListDiaDiem = (from dd in db.DIADIEMTOCHUCs select dd).ToList(); foreach (var diaDiem in ListDiaDiem) { ListDiaDiemString.Add(diaDiem.TENDD + ", " + diaDiem.DIACHI); } } this.ChooseImageCommand = new RelayCommand(ChooseImage); this.AddHoiNghiCommand = new RelayCommand(AddHoiNghi); this.CapQuyenCommand = new RelayCommand(CapQuyen); }
private void xachNhanDangKy() { try { if (this.DangKiThamGia.TRANGTHAI == 2) { this.DangKiThamGia.TRANGTHAI = 0; using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { foreach (var item in db.DANGKITHAMGIAs) { if (item.IDUSER == this.User.IDUSER && item.IDHN == this.DangKiThamGia.IDHN) { item.TRANGTHAI = this.DangKiThamGia.TRANGTHAI; break; } } foreach (var item in db.HOINGHIs) { if (item.IDHN == this.HoiNghi.IDHN) { item.SOLUONG--; this.HoiNghi.SOLUONG--; break; } } db.SaveChanges(); } } else if (this.DangKiThamGia.TRANGTHAI == 0) { if (this.HoiNghi.SOLUONG == SucChua) { MessageBox.Show("Số lượng người tham dự không thể vượt quá sức chứa của địa điểm.", "", MessageBoxButton.OK, MessageBoxImage.Warning); } else { this.DangKiThamGia.TRANGTHAI = 2; using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { foreach (var item in db.DANGKITHAMGIAs) { if (item.IDUSER == this.User.IDUSER && item.IDHN == this.DangKiThamGia.IDHN) { item.TRANGTHAI = this.DangKiThamGia.TRANGTHAI; break; } } foreach (var item in db.HOINGHIs) { if (item.IDHN == this.HoiNghi.IDHN) { item.SOLUONG++; this.HoiNghi.SOLUONG++; break; } } db.SaveChanges(); } } } } catch { MessageBox.Show("Đã có lỗi xảy ra."); } }
private void chanNguoiDung() { if (this.DangKiThamGia.TRANGTHAI == 2) // 0: Chua xac nhan ; 1: Chan ; 2: Xac nhan { this.DangKiThamGia.TRANGTHAI = 1; using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { foreach (var item in db.DANGKITHAMGIAs) { if (item.IDUSER == this.User.IDUSER && item.IDHN == this.DangKiThamGia.IDHN) { item.TRANGTHAI = this.DangKiThamGia.TRANGTHAI; break; } } foreach (var item in db.HOINGHIs) { if (item.IDHN == this.HoiNghi.IDHN) { item.SOLUONG--; this.HoiNghi.SOLUONG--; break; } } db.SaveChanges(); } } else if (this.DangKiThamGia.TRANGTHAI == 0) { this.DangKiThamGia.TRANGTHAI = 1; using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { foreach (var item in db.DANGKITHAMGIAs) { if (item.IDUSER == this.User.IDUSER && item.IDHN == this.DangKiThamGia.IDHN) { item.TRANGTHAI = this.DangKiThamGia.TRANGTHAI; break; } } db.SaveChanges(); } } else { this.DangKiThamGia.TRANGTHAI = 0; using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { foreach (var item in db.DANGKITHAMGIAs) { if (item.IDUSER == this.User.IDUSER && item.IDHN == this.DangKiThamGia.IDHN) { item.TRANGTHAI = this.DangKiThamGia.TRANGTHAI; break; } } db.SaveChanges(); } } }
private bool ValidateInput() { if (String.IsNullOrEmpty(TenHoiNghi.Trim())) { MessageBox.Show("Mời nhập lại tên hội nghị."); return(false); } if (NgayBatDau >= NgayKetThuc) { MessageBox.Show("Mời chọn lại thời gian."); return(false); } if (IndexDiaDiem < 0) { MessageBox.Show("Mời chọn lại địa điểm."); return(false); } int num; if (String.IsNullOrEmpty(SoLuong.Trim()) || !int.TryParse(SoLuong, out num) || num > ListDiaDiem[IndexDiaDiem].SUCCHUA) { MessageBox.Show("Mời nhập lại số lượng."); return(false); } if (String.IsNullOrEmpty(MoTa.Trim())) { MessageBox.Show("Mời nhập lại mô tả."); return(false); } if (String.IsNullOrEmpty(NoiDungHoiNghi.Trim())) { MessageBox.Show("Mời nhập lại nội dung hội nghị."); return(false); } if (String.IsNullOrEmpty(ImagePathHoiNghi)) { MessageBox.Show("Mời chọn lại hình ảnh."); return(false); } using (DBQuanLiHoiNghiEntities db = new DBQuanLiHoiNghiEntities()) { int iddd = this.ListDiaDiem[IndexDiaDiem].IDDD; var listHN = db.HOINGHIs.Where(o => (o.IDDD == iddd && (o.THOIGIANBATDAU >= this.NgayBatDau && o.THOIGIANBATDAU <= this.NgayKetThuc || o.THOIGIANKETTHUC >= this.NgayBatDau && o.THOIGIANKETTHUC <= this.NgayKetThuc))).ToList(); if (listHN.Count != 0) { MessageBox.Show("Đã có hội nghị diễn tra trong khung giờ này."); return(false); } } return(true); }