public static void Update(Model.MATHANG item, string id) { Model.MATHANG getdt = Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.ma_mathang == id).SingleOrDefault(); getdt.ten_mathang = item.ten_mathang; getdt.hang = item.hang; getdt.dong = item.dong; getdt.DONVITINH = item.DONVITINH; getdt.NHACUNGCAP = item.NHACUNGCAP; getdt.LOAIHANG = item.LOAIHANG; getdt.mota = item.mota; Model.DataProvider.Ins.DB.SaveChanges(); }
public Mathang_ViewModel() { List = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); DeleteList = new ObservableCollection <Model.MATHANG>(); List_Loai = new ObservableCollection <Model.LOAIHANG>(Model.DataProvider.Ins.DB.LOAIHANGs.Where(x => x.IsDeleted == false)); List_Donvi = new ObservableCollection <Model.DONVITINH>(Model.DataProvider.Ins.DB.DONVITINHs.Where(x => x.IsDeleted == false)); List_Nhacungcap = new ObservableCollection <Model.NHACUNGCAP>(Model.DataProvider.Ins.DB.NHACUNGCAPs.Where(x => x.IsDeleted == false)); Active = false; IsOpen = false; IsOpen_Filter = 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.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); DeleteList = new ObservableCollection <Model.MATHANG>(); List_Loai = new ObservableCollection <Model.LOAIHANG>(Model.DataProvider.Ins.DB.LOAIHANGs.Where(x => x.IsDeleted == false)); List_Donvi = new ObservableCollection <Model.DONVITINH>(Model.DataProvider.Ins.DB.DONVITINHs.Where(x => x.IsDeleted == false)); List_Nhacungcap = new ObservableCollection <Model.NHACUNGCAP>(Model.DataProvider.Ins.DB.NHACUNGCAPs.Where(x => x.IsDeleted == false)); Active = false; IsOpen = false; IsOpen_Filter = false; ListDonvi_Filter = new ObservableCollection <Model.DONVITINH>(Model.DataProvider.Ins.DB.DONVITINHs.Where(x => x.IsDeleted == false)); ListNhacungcap_Filter = new ObservableCollection <Model.NHACUNGCAP>(Model.DataProvider.Ins.DB.NHACUNGCAPs.Where(x => x.IsDeleted == false)); ListLoai_Filter = new ObservableCollection <Model.LOAIHANG>(Model.DataProvider.Ins.DB.LOAIHANGs.Where(x => x.IsDeleted == false)); }); #region Tao moi Reset_Command = new RelayCommand <object>(p => { return(true); }, p => { SelectedItem = null; Tenmathang = ""; Dong = ""; Hang = ""; SNhacungcap = null; SLoai = null; SDonvi = null; Mota = ""; }); #endregion #region Phan them Insert_Command = new RelayCommand <object>(p => { if (string.IsNullOrEmpty(Tenmathang) || string.IsNullOrEmpty(Hang) || string.IsNullOrEmpty(Dong)) { return(false); } if (SDonvi == null || SNhacungcap == null || SLoai == null) { return(false); } return(true); }, p => { SelectedItem = null; Model.MATHANG newItem = new Model.MATHANG() { ma_mathang = MyStaticMethods.RandomInt(10), ten_mathang = Tenmathang, dong = Dong, hang = Hang, LOAIHANG = SLoai, DONVITINH = SDonvi, NHACUNGCAP = SNhacungcap, mota = (string.IsNullOrEmpty(Mota)) ? null : Mota, IsDeleted = false }; Model.Mathang_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(Tenmathang) || string.IsNullOrEmpty(Hang) || string.IsNullOrEmpty(Dong)) { return(false); } if (SDonvi == null || SNhacungcap == null || SLoai == null) { return(false); } return(true); }, p => { Model.MATHANG UpdateItem = new Model.MATHANG() { ten_mathang = Tenmathang, dong = _Dong, hang = _Hang, LOAIHANG = SLoai, NHACUNGCAP = SNhacungcap, DONVITINH = SDonvi, mota = (string.IsNullOrEmpty(Mota)) ? null : Mota }; Model.Mathang_Service.Update(UpdateItem, Mamathang); for (int i = 0; i < List.Count(); i++) { if (List[i] == SelectedItem) { List[i] = new Model.MATHANG() { ma_mathang = Mamathang, ten_mathang = Tenmathang, dong = Dong, hang = Hang, NHACUNGCAP = SNhacungcap, DONVITINH = SDonvi, LOAIHANG = SLoai, mota = (string.IsNullOrEmpty(Mota)) ? null : Mota }; break; } } //MessageBox.Show("Chỉnh sửa thành công", "THÔNG BÁO"); SelectedItem = null; Tenmathang = ""; Dong = ""; Hang = ""; SNhacungcap = null; SLoai = null; SDonvi = null; 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_mathang == p.Uid.ToString()).SingleOrDefault()); }); RemoveDeleteList_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { DeleteList.Remove(List.Where(x => x.ma_mathang == 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.MATHANG>(); IsOpen = false; SelectedItem = null; }); #endregion #region Phan loc ListDonvi_Filter = new ObservableCollection <Model.DONVITINH>(Model.DataProvider.Ins.DB.DONVITINHs.Where(x => x.IsDeleted == false)); ListNhacungcap_Filter = new ObservableCollection <Model.NHACUNGCAP>(Model.DataProvider.Ins.DB.NHACUNGCAPs.Where(x => x.IsDeleted == false)); ListLoai_Filter = new ObservableCollection <Model.LOAIHANG>(Model.DataProvider.Ins.DB.LOAIHANGs.Where(x => x.IsDeleted == false)); OpenFilter_Command = new RelayCommand <object>(p => { if (IsOpen == true || IsOpen_Filter == true) { return(false); } return(true); }, p => { IsOpen_Filter = true; }); ResetFilter_Command = new RelayCommand <Button>(p => { return(true); }, p => { List = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); SLoai_Filter = null; SNhacungcap_Filter = null; SDonvi_Filter = null; IsOpen_Filter = false; }); Filter_Command = new RelayCommand <Button>(p => { return(true); }, p => { List = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); if (SLoai_Filter != null) { FilterbyLoaihang(SLoai_Filter.ma_loaihang); } if (SNhacungcap_Filter != null) { FilterbyNhacungcap(SNhacungcap_Filter.ma_nhacungcap); } if (SDonvi_Filter != null) { FilterbyDonvi(SDonvi_Filter.ma_donvi); } IsOpen_Filter = false; }); #endregion #region Phan sap xep OrderbyTenMathang_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.MATHANG> chkList = new ObservableCollection <Model.MATHANG>(List.OrderByDescending(x => x.ten_mathang)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.MATHANG>(List.OrderBy(x => x.ten_mathang)); } else { List = new ObservableCollection <Model.MATHANG>(chkList); } }); OrderbyTennhacungcap_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.MATHANG> chkList = new ObservableCollection <Model.MATHANG>(List.OrderByDescending(x => x.NHACUNGCAP.ten_nhacungcap)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.MATHANG>(List.OrderBy(x => x.NHACUNGCAP.ten_nhacungcap)); } else { List = new ObservableCollection <Model.MATHANG>(chkList); } }); OrderbyTenloai_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.MATHANG> chkList = new ObservableCollection <Model.MATHANG>(List.OrderByDescending(x => x.LOAIHANG.ten_loaihang)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.MATHANG>(List.OrderBy(x => x.LOAIHANG.ten_loaihang)); } else { List = new ObservableCollection <Model.MATHANG>(chkList); } }); OrderbyTendonvi_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.MATHANG> chkList = new ObservableCollection <Model.MATHANG>(List.OrderByDescending(x => x.DONVITINH.ten_donvi)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.MATHANG>(List.OrderBy(x => x.DONVITINH.ten_donvi)); } else { List = new ObservableCollection <Model.MATHANG>(chkList); } }); #endregion }
public static void Delete(Model.MATHANG item) { Model.DataProvider.Ins.DB.MATHANGs.Remove(item); }
public static void Insert(Model.MATHANG item) { Model.DataProvider.Ins.DB.MATHANGs.Add(item); Model.DataProvider.Ins.DB.SaveChanges(); }