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