private void btnXoaDuLieu_Click(object sender, RoutedEventArgs e)
{
using (QuanLyDuLieu db = new QuanLyDuLieu())
{
List <SuKien> sk = db.SuKien.ToList().FindAll(m => m.NguoiDungID == NguoiDungING.NguoiDungID && m.TieuDe == ("###" + NguoiDungING.NguoiDungID + "***"));
List <PhanLoaiSuKien> listplsk = new List <PhanLoaiSuKien>();
foreach (SuKien i in sk)
{
listplsk.Add(db.PhanLoaiSuKien.ToList().Find(m => m.PhanLoaiSuKienID == i.PhanLoaiSuKienID));
}
foreach (PhanLoaiSuKien item in listplsk)
{
PhanLoaiSuKien plsk = item;
foreach (SuKien i in plsk.SuKien.ToList())
{
db.SuKien.ToList().Remove(i);
}
db.SaveChanges();
PhanLoaiSuKien plskXoa = db.PhanLoaiSuKien.ToList().Find(m => m.PhanLoaiSuKienID == plsk.PhanLoaiSuKienID);
db.PhanLoaiSuKien.Remove(plskXoa);
db.SaveChanges();
}
List <CongViec> lcv = db.CongViec.ToList().FindAll(m => m.NguoiDungID == NguoiDungING.NguoiDungID);
foreach (CongViec i in lcv)
{
db.CongViec.Remove(i);
}
db.SaveChanges();
MessageBox.Show("Xóa dữ liệu thành công !", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
private void Click_btnThem(object sender, RoutedEventArgs e)
{
using (QuanLyDuLieu db = new QuanLyDuLieu())
{
PhanLoaiSuKien plsk = new PhanLoaiSuKien
{
TieuDe = txbTieuDe.Text == "" ? "(Không có tiêu đề)" : txbTieuDe.Text,
HienThi = true,
};
db.PhanLoaiSuKien.Add(plsk);
db.SaveChanges();
SuKien sk = new SuKien
{
TieuDe = "###" + NguoiDungING.NguoiDungID + "***",
ThoiGianBatDau = DateTime.Now,
ThoiGianKetThuc = DateTime.Now,
LapLai = true,
KhungThoiGianLap = "",
ThongBao = true,
ThoiGianThongBao = 0,
KhungThoiGianThongBao = "",
Mau = "",
NoiDung = "",
NguoiDungID = NguoiDungING.NguoiDungID,
PhanLoaiSuKienID = plsk.PhanLoaiSuKienID,
};
db.SuKien.Add(sk);
db.SaveChanges();
txbTieuDe.Text = "";
List <PhanLoaiSuKien> lplsk = db.PhanLoaiSuKien.ToList();
loadDBtoDataGrid();
}
}
private void LoadDefault()
{
using (QuanLyDuLieu db = new QuanLyDuLieu())
{
List <NguoiDung> NguoiDung = db.NguoiDung.ToList();
List <PhanLoaiSuKien> PhanLoaiSuKien = db.PhanLoaiSuKien.ToList();
List <CongViec> CongViec = db.CongViec.ToList();
List <SuKien> SuKien = db.SuKien.ToList();
PhanLoaiSuKien plsk = db.PhanLoaiSuKien.ToList().Find(m => m.TieuDe == "Sinh nhật");
List <SuKien> SuKienSinhNhat = db.SuKien.ToList().FindAll(m => m.NguoiDungID == "admin" && m.PhanLoaiSuKienID == plsk.PhanLoaiSuKienID);
LoadSuKienToLich();
LoadCongViec();
LoadPhanLoaiSuKien();
}
}
private void CheckBox_Check(object sender, RoutedEventArgs e)
{
CheckBox chkBox = sender as CheckBox;
PhanLoaiSuKien plsk = (PhanLoaiSuKien)chkBox.DataContext;
using (QuanLyDuLieu db = new QuanLyDuLieu())
{
PhanLoaiSuKien plskThayDoi = db.PhanLoaiSuKien.ToList().Single(m => m.PhanLoaiSuKienID == plsk.PhanLoaiSuKienID);
plskThayDoi.HienThi = chkBox.IsChecked ?? false;
db.SaveChanges();
}
LoadPhanLoaiSuKien();
LoadSuKienToLich();
}
private void Click_btnSua(object sender, RoutedEventArgs e)
{
if (dataGirdDSPhanLoaiSuKien.SelectedIndex >= 0)
{
using (QuanLyDuLieu db = new QuanLyDuLieu())
{
PhanLoaiSuKien plsk = (PhanLoaiSuKien)dataGirdDSPhanLoaiSuKien.SelectedItem;
PhanLoaiSuKien plskSua = db.PhanLoaiSuKien.ToList().SingleOrDefault(m => m.PhanLoaiSuKienID == plsk.PhanLoaiSuKienID);
plskSua.TieuDe = txbTieuDe.Text;
MessageBox.Show("Sửa đổi thành công !", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Information);
db.SaveChanges();
}
loadDBtoDataGrid();
}
else
{
MessageBox.Show("Vui lòng chọn giá trị để sửa.", "Thông báo lỗi", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void Click_btnXoa(object sender, RoutedEventArgs e)
{
if (dataGirdDSPhanLoaiSuKien.SelectedIndex >= 0)
{
using (QuanLyDuLieu db = new QuanLyDuLieu())
{
PhanLoaiSuKien plsk = (PhanLoaiSuKien)dataGirdDSPhanLoaiSuKien.SelectedItem;
List <PhanLoaiSuKien> lplsk = db.PhanLoaiSuKien.ToList();
foreach (SuKien item in plsk.SuKien.ToList())
{
db.SuKien.ToList().Remove(item);
}
db.SaveChanges();
PhanLoaiSuKien plskXoa = db.PhanLoaiSuKien.ToList().Find(m => m.PhanLoaiSuKienID == plsk.PhanLoaiSuKienID);
db.PhanLoaiSuKien.Remove(plskXoa);
db.SaveChanges();
}
loadDBtoDataGrid();
txbTieuDe.Text = "";
}
}
