public static void Update(Model.KHACHHANG item, string id) { Model.KHACHHANG getdt = Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.ma_khachhang == id).SingleOrDefault(); getdt.ten_khachhang = item.ten_khachhang; getdt.sodienthoai = item.sodienthoai; getdt.diachi = item.diachi; Model.DataProvider.Ins.DB.SaveChanges(); }
public Khachhang_ViewModel() { List = new ObservableCollection <Model.KHACHHANG>(Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.IsDeleted == false)); DeleteList = new ObservableCollection <Model.KHACHHANG>(); 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.KHACHHANG>(Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.IsDeleted == false)); DeleteList = new ObservableCollection <Model.KHACHHANG>(); Active = false; IsOpen = false; }); #region Phan them Insert_Command = new RelayCommand <object>(p => { if (string.IsNullOrEmpty(Tenkhachhang) || string.IsNullOrEmpty(Sodienthoai) || string.IsNullOrEmpty(Diachi)) { return(false); } long i = 0; if (!long.TryParse(Sodienthoai, out i)) { return(false); } var check = Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.ten_khachhang == Tenkhachhang); if (check == null || check.Count() != 0) { return(false); } return(true); }, p => { SelectedItem = null; Model.KHACHHANG newItem = new Model.KHACHHANG() { ma_khachhang = Guid.NewGuid().ToString(), ten_khachhang = Tenkhachhang, diachi = Diachi, sodienthoai = Sodienthoai, IsDeleted = false }; Model.Khachhang_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); } long i = 0; if (!long.TryParse(Sodienthoai, out i)) { return(false); } if (string.IsNullOrEmpty(Tenkhachhang) || string.IsNullOrEmpty(Sodienthoai) || string.IsNullOrEmpty(Diachi)) { return(false); } var check = Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.ten_khachhang == Tenkhachhang && x.diachi == Diachi && x.sodienthoai == Sodienthoai); if (check == null || check.Count() != 0) { return(false); } return(true); }, p => { Model.KHACHHANG UpdateItem = new Model.KHACHHANG() { ten_khachhang = Tenkhachhang, sodienthoai = Sodienthoai, diachi = Diachi }; Model.Khachhang_Service.Update(UpdateItem, Makhachhang); for (int i = 0; i < List.Count(); i++) { if (List[i] == SelectedItem) { List[i] = new Model.KHACHHANG() { ma_khachhang = Makhachhang, ten_khachhang = Tenkhachhang, diachi = Diachi, sodienthoai = Sodienthoai }; break; } } //MessageBox.Show("Chỉnh sửa thành công", "THÔNG BÁO"); SelectedItem = null; Tenkhachhang = ""; Sodienthoai = ""; Diachi = ""; 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_khachhang == p.Uid.ToString()).SingleOrDefault()); }); RemoveDeleteList_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { DeleteList.Remove(List.Where(x => x.ma_khachhang == p.Uid.ToString()).SingleOrDefault()); }); Delete_Command = new RelayCommand <object>(p => { if (DeleteList.Count() == 0) { return(false); } return(true); }, p => { RemoveIteminDb(); RemoveIteminList(); DeleteList = new ObservableCollection <Model.KHACHHANG>(); IsOpen = false; SelectedItem = null; }); #endregion #region Tao moi Reset_Command = new RelayCommand <object>(p => { return(true); }, p => { SelectedItem = null; Tenkhachhang = ""; Diachi = ""; Sodienthoai = ""; }); #endregion #region Phan sap xep Sort_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.KHACHHANG> chkList = new ObservableCollection <Model.KHACHHANG>(List.OrderByDescending(x => x.ten_khachhang)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.KHACHHANG>(List.OrderBy(x => x.ten_khachhang)); } else { List = new ObservableCollection <Model.KHACHHANG>(chkList); } }); SortbyDiachi_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.KHACHHANG> chkList = new ObservableCollection <Model.KHACHHANG>(List.OrderByDescending(x => x.diachi)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.KHACHHANG>(List.OrderBy(x => x.diachi)); } else { List = new ObservableCollection <Model.KHACHHANG>(chkList); } }); #endregion }
public static void Delete(Model.KHACHHANG item) { Model.DataProvider.Ins.DB.KHACHHANGs.Remove(item); }
public static void Insert(Model.KHACHHANG item) { Model.DataProvider.Ins.DB.KHACHHANGs.Add(item); Model.DataProvider.Ins.DB.SaveChanges(); }