public static void Update(Model.DONVITINH item, string id) { Model.DONVITINH getdt = Model.DataProvider.Ins.DB.DONVITINHs.Where(x => x.ma_donvi == id).SingleOrDefault(); getdt.ten_donvi = item.ten_donvi; getdt.mota = item.mota; Model.DataProvider.Ins.DB.SaveChanges(); }
public static void Insert(Model.DONVITINH item) { Model.DataProvider.Ins.DB.DONVITINHs.Add(item); Model.DataProvider.Ins.DB.SaveChanges(); }
public static void Delete(Model.DONVITINH item) { Model.DataProvider.Ins.DB.DONVITINHs.Remove(item); }
public Donvi_ViewModel() { List = new ObservableCollection <Model.DONVITINH>(Model.DataProvider.Ins.DB.DONVITINHs.Where(x => x.IsDeleted == false)); DeleteList = new ObservableCollection <Model.DONVITINH>(); 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.DONVITINH>(Model.DataProvider.Ins.DB.DONVITINHs.Where(x => x.IsDeleted == false)); DeleteList = new ObservableCollection <Model.DONVITINH>(); Active = false; IsOpen = false; }); #region Phan them Insert_Command = new RelayCommand <object>(p => { if (string.IsNullOrEmpty(Tendonvi)) { return(false); } var check = Model.DataProvider.Ins.DB.DONVITINHs.Where(x => x.ten_donvi == Tendonvi); if (check == null || check.Count() != 0) { return(false); } return(true); }, p => { SelectedItem = null; Model.DONVITINH newItem = new Model.DONVITINH() { ma_donvi = MyStaticMethods.RandomString(5, false), ten_donvi = Tendonvi, mota = (string.IsNullOrEmpty(Mota)) ? null : Mota, IsDeleted = false }; Model.Donvitinh_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(Tendonvi)) { return(false); } return(true); }, p => { Model.DONVITINH UpdateItem = new Model.DONVITINH() { ten_donvi = Tendonvi, mota = string.IsNullOrEmpty(Mota) ? null : Mota }; Model.Donvitinh_Service.Update(UpdateItem, Madonvi); for (int i = 0; i < List.Count(); i++) { if (List[i] == SelectedItem) { List[i] = new Model.DONVITINH() { ma_donvi = Madonvi, ten_donvi = Tendonvi, mota = (string.IsNullOrEmpty(Mota)) ? null : Mota }; break; } } //MessageBox.Show("Chỉnh sửa thành công", "THÔNG BÁO"); SelectedItem = null; Tendonvi = ""; Mota = ""; Active = true; Message = "Chỉnh sửa thành công !!!"; }); #endregion #region Phan xoa AddDeleteList_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { DeleteList.Add(List.Where(x => x.ma_donvi == p.Uid.ToString()).SingleOrDefault()); }); RemoveDeleteList_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { DeleteList.Remove(List.Where(x => x.ma_donvi == p.Uid.ToString()).SingleOrDefault()); }); 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 ???"; }); Delete_Command = new RelayCommand <object>(p => { if (DeleteList.Count() == 0) { return(false); } return(true); }, p => { RemoveIteminDb(); RemoveIteminList(); DeleteList = new ObservableCollection <Model.DONVITINH>(); IsOpen = false; SelectedItem = null; }); #endregion #region Tao moi Reset_Command = new RelayCommand <object>(p => { return(true); }, p => { SelectedItem = null; Tendonvi = ""; Mota = ""; }); #endregion #region Phan sap xep Sort_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.DONVITINH> chkList = new ObservableCollection <Model.DONVITINH>(List.OrderByDescending(x => x.ten_donvi)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.DONVITINH>(List.OrderBy(x => x.ten_donvi)); } else { List = new ObservableCollection <Model.DONVITINH>(chkList); } }); #endregion }