public static void Update(Model.NHANVIEN item, string id) { Model.NHANVIEN getdt = Model.DataProvider.Ins.DB.NHANVIENs.Where(x => x.ma_nhanvien == id).SingleOrDefault(); getdt.ten_nhanvien = item.ten_nhanvien; getdt.ngaysinh = item.ngaysinh; getdt.sodienthoai = item.sodienthoai; getdt.diachi = item.diachi; getdt.QUYEN = item.QUYEN; Model.DataProvider.Ins.DB.SaveChanges(); }
public static void Insert(Model.NHANVIEN item) { Model.DataProvider.Ins.DB.NHANVIENs.Add(item); Model.DataProvider.Ins.DB.SaveChanges(); }
public static void Delete(Model.NHANVIEN item) { Model.DataProvider.Ins.DB.NHANVIENs.Remove(item); }
public Nhanvien_ViewModel() { List = new ObservableCollection <Model.NHANVIEN>(Model.DataProvider.Ins.DB.NHANVIENs.Where(x => x.IsDeleted == false)); DeleteList = new ObservableCollection <Model.NHANVIEN>(); List_Quyen = new ObservableCollection <Model.QUYEN>(Model.DataProvider.Ins.DB.QUYENs); Active = false; IsOpen = false; Active_Command = new RelayCommand <object>(p => { if (Active == false) { return(false); } return(true); }, p => { Active = false; }); CloseDialog_Command = new RelayCommand <object>(p => { return(true); }, p => { IsOpen = false; }); Load_Command = new RelayCommand <object>(p => { return(true); }, p => { List = new ObservableCollection <Model.NHANVIEN>(Model.DataProvider.Ins.DB.NHANVIENs.Where(x => x.IsDeleted == false)); DeleteList = new ObservableCollection <Model.NHANVIEN>(); List_Quyen = new ObservableCollection <Model.QUYEN>(Model.DataProvider.Ins.DB.QUYENs); Active = false; IsOpen = false; }); #region Tao moi Reset_Command = new RelayCommand <object>(p => { return(true); }, p => { SelectedItem = null; Tennhanvien = ""; Diachi = ""; Sodienthoai = ""; Ngaysinh = ""; SQuyen = null; }); #endregion #region Phan them Insert_Command = new RelayCommand <object>(p => { if (string.IsNullOrEmpty(Tennhanvien) || string.IsNullOrEmpty(Sodienthoai) || string.IsNullOrEmpty(Diachi) || string.IsNullOrEmpty(Ngaysinh)) { return(false); } long i = 0; if (!long.TryParse(Sodienthoai, out i)) { return(false); } int count = Model.DataProvider.Ins.DB.NHANVIENs.Where(x => x.sodienthoai == Sodienthoai).Count(); if (count != 0) { return(false); } if (SQuyen == null) { return(false); } return(true); }, p => { SelectedItem = null; Model.NHANVIEN newItem = new Model.NHANVIEN() { ma_nhanvien = MyStaticMethods.RandomInt(10), ten_nhanvien = Tennhanvien, ngaysinh = MyStaticMethods.FormatDateString(Ngaysinh), QUYEN = SQuyen, diachi = Diachi, sodienthoai = Sodienthoai, IsDeleted = false }; Model.Nhanvien_Service.Insert(newItem); List.Insert(0, newItem); SelectedItem = newItem; Active = true; Message = "Thêm mới thành công !!!"; }); #endregion #region Phan sua Update_Command = new RelayCommand <object>(p => { if (SelectedItem == null) { return(false); } if (string.IsNullOrEmpty(Tennhanvien) || string.IsNullOrEmpty(Sodienthoai) || string.IsNullOrEmpty(Diachi) || string.IsNullOrEmpty(Ngaysinh)) { return(false); } long i = 0; if (!long.TryParse(Sodienthoai, out i)) { return(false); } if (SQuyen == null) { return(false); } return(true); }, p => { Model.NHANVIEN UpdateItem = new Model.NHANVIEN() { ten_nhanvien = Tennhanvien, ngaysinh = MyStaticMethods.FormatDateString(Ngaysinh), QUYEN = SQuyen, diachi = Diachi, sodienthoai = Sodienthoai }; Model.Nhanvien_Service.Update(UpdateItem, Manhanvien); for (int i = 0; i < List.Count(); i++) { if (List[i] == SelectedItem) { List[i] = new Model.NHANVIEN() { ma_nhanvien = Manhanvien, ten_nhanvien = Tennhanvien, diachi = Diachi, sodienthoai = Sodienthoai, ngaysinh = MyStaticMethods.FormatDateString(Ngaysinh), QUYEN = _SQuyen }; break; } } //MessageBox.Show("Chỉnh sửa thành công", "THÔNG BÁO"); SelectedItem = null; Tennhanvien = ""; Diachi = ""; Sodienthoai = ""; Ngaysinh = ""; SQuyen = null; Active = true; Message = "Chỉnh sửa thành công !!!"; }); #endregion #region Phan xoa DeleteShow_Command = new RelayCommand <object>(p => { if (DeleteList.Count() == 0) { return(false); } return(true); }, p => { IsOpen = true; Content = " Xóa các bản ghi được chọn ???"; }); AddDeleteList_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { DeleteList.Add(List.Where(x => x.ma_nhanvien == p.Uid.ToString()).SingleOrDefault()); }); RemoveDeleteList_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { DeleteList.Remove(List.Where(x => x.ma_nhanvien == p.Uid.ToString()).SingleOrDefault()); }); Delete_Command = new RelayCommand <object>(p => { if (DeleteList.Count() == 0) { return(false); } return(true); }, p => { RemoveIteminDb(); RemoveIteminList(); Capnhat_dboTaiKhoan(); DeleteList = new ObservableCollection <Model.NHANVIEN>(); IsOpen = false; SelectedItem = null; }); #endregion #region Sap xep OrderbyTen_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.NHANVIEN> chkList = new ObservableCollection <Model.NHANVIEN>(List.OrderByDescending(x => x.ten_nhanvien)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.NHANVIEN>(List.OrderBy(x => x.ten_nhanvien)); } else { List = new ObservableCollection <Model.NHANVIEN>(chkList); } }); OrderbyDiachi_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.NHANVIEN> chkList = new ObservableCollection <Model.NHANVIEN>(List.OrderByDescending(x => x.diachi)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.NHANVIEN>(List.OrderBy(x => x.diachi)); } else { List = new ObservableCollection <Model.NHANVIEN>(chkList); } }); OrderbyVitri_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.NHANVIEN> chkList = new ObservableCollection <Model.NHANVIEN>(List.OrderByDescending(x => x.QUYEN.ma_quyen)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.NHANVIEN>(List.OrderBy(x => x.QUYEN.ma_quyen)); } else { List = new ObservableCollection <Model.NHANVIEN>(chkList); } }); #endregion }