public void ConfirmDeletePhanBon(object parameter) { MessageBoxResult result = MessageBox.Show("Bạn có chắc chắn muốn xóa những phân bón chứ?", "Quản lý phân bón", MessageBoxButton.YesNo, MessageBoxImage.Hand); if (result == MessageBoxResult.Yes) { QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities(); for (int i = 0; i < phanBonChecked.Count; i++) { if (phanBonChecked[i].isDelete == true) { PhanBon temp = quanLyPhanBonEntities.PhanBons.Find(phanBonChecked[i].IDPhanBon); temp.isDelete = true; quanLyPhanBonEntities.SaveChanges(); } } FillMyDataGrid(); } else { checkBox.Visibility = Visibility.Collapsed; AddAdvancedFormat = Visibility.Visible; AdvancedFormat = Visibility.Collapsed; isClickDelete = false; } }
public void _SaveNhanVien(object parameter) { var ThemNhanVienWD = parameter as Window; try { QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities(); NhanVien nhanVien = quanLyPhanBonEntities.NhanViens.Find(IdNhanVien); nhanVien.TenNhanVien = _TenNhanVien; nhanVien.GioiTinh = _SelectedGioiTinh.Key; nhanVien.SDT = _SDT; nhanVien.DiaChi = _DiaChi; nhanVien.Luong = Int32.Parse(_Luong); TaiKhoan taiKhoan = quanLyPhanBonEntities.TaiKhoans.Find(_TenTaiKhoan); if (taiKhoan != null) { taiKhoan.MatKhau = _PassWord; } quanLyPhanBonEntities.SaveChanges(); ThemNhanVienWD.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void _No(object parameter) { try { var ThanhToanWinDow = parameter as Window; QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities(); KhachHang khachHang = new KhachHang(); khachHang = quanLyPhanBonEntities.KhachHangs.Find(IDKhachHang); if (khachHang.IsThieuTien == false) { khachHang.TienNo = ToTal; } else { khachHang.TienNo = khachHang.TienNo + ToTal; } quanLyPhanBonEntities.SaveChanges(); MessageBox.Show("Thanh toán thành công!!"); ThanhToanWinDow.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public ChinhSuaPhanBonViewModel() { SaveImage = new DelegateCommand(SaveImageClick); EditPhanBon = new DelegateCommand(_EditPhanBon); AddPhanBon = new DelegateCommand(Save); ExitThisWindow = new DelegateCommand(Exit); FillComboBox(); if (phanBon != null) { _isChinhSua = false; QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities(); LoaiPhanBon loaiphanBon = new LoaiPhanBon(); loaiphanBon = quanLyPhanBonEntities.LoaiPhanBons.Find(phanBon.LoaiPhanBon); quanLyPhanBonEntities.SaveChanges(); _selectedLoaiPhanBon = new KeyValuePair <int, string>(phanBon.LoaiPhanBon, loaiphanBon.TenLoaiPhanBon); _TenPhanBon = phanBon.TenPhanBon; _gia = phanBon.Gia.ToString(); _soLuong = phanBon.SoLuong.ToString(); imagePath = phanBon.HinhAnh; if (imagePath != null) { BitmapImage bm = new BitmapImage(); bm.BeginInit(); bm.UriSource = new Uri(imagePath, UriKind.RelativeOrAbsolute); bm.EndInit(); _sourceImage = bm; } } }
public void _RemoveNhanVien(object parameter) { var ChinhSUaWD = parameter as Window; MessageBoxResult result = MessageBox.Show("Bạn có chắc chắn muốn xóa nhân viên chứ?", "Quản lý phân bón", MessageBoxButton.YesNo, MessageBoxImage.Hand); if (result == MessageBoxResult.Yes) { try { using (QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities()) { NhanVien nhanVien = quanLyPhanBonEntities.NhanViens.Find(IdNhanVien); TaiKhoan taiKhoan = quanLyPhanBonEntities.TaiKhoans.Find(_TenTaiKhoan); if (nhanVien != null) { quanLyPhanBonEntities.NhanViens.Remove(nhanVien); } if (taiKhoan != null) { quanLyPhanBonEntities.TaiKhoans.Remove(taiKhoan); } quanLyPhanBonEntities.SaveChanges(); ChinhSUaWD.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { } }
private void Save(object parameter) { var EditWindow = parameter as Window; using (QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities()) { try { PhanBon phanBon1; phanBon1 = quanLyPhanBonEntities.PhanBons.Find(phanBon.IDPhanBon); phanBon1.TenPhanBon = _TenPhanBon; phanBon1.LoaiPhanBon = _selectedLoaiPhanBon.Key; phanBon1.HinhAnh = imagePath; phanBon1.SoLuong = int.Parse(_soLuong); phanBon1.Gia = int.Parse(_gia); quanLyPhanBonEntities.SaveChanges(); EditWindow.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
public void getData() { QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities(); _ListPhanBon_KH = new ObservableCollection <PhanBon_KH>(quanLyPhanBonEntities.PhanBon_KH.ToList()); OnPropertyChanged("ListPhanBon_KH"); quanLyPhanBonEntities.SaveChanges(); }
public void RefreshKH() { QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities(); _ListKH = new ObservableCollection <KhachHang>(quanLyPhanBonEntities.KhachHangs.ToList()); OnPropertyChanged("ListKH"); quanLyPhanBonEntities.SaveChanges(); }
private void FillDataKH() { QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities(); _ListKH = new ObservableCollection <KhachHang>(quanLyPhanBonEntities.KhachHangs.ToList()); OnPropertyChanged("ListKH"); quanLyPhanBonEntities.SaveChanges(); }
public void Refresh() { QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities(); ListNhanVien = new ObservableCollection <NhanVien>(quanLyPhanBonEntities.NhanViens.ToList()); OnPropertyChanged("ListNhanVien"); quanLyPhanBonEntities.SaveChanges(); }
public QuanLyLuongViewModel() { using (QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities()) { _ListNhanVien = new ObservableCollection <NhanVien>(quanLyPhanBonEntities.NhanViens.ToList()); OnPropertyChanged("ListNhanVien"); quanLyPhanBonEntities.SaveChanges(); } OK = new DelegateCommand(_OK); }
public void FillComboBox() { QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities(); ObservableCollection <LoaiPhanBon> _listLoaiPhanBon = new ObservableCollection <LoaiPhanBon>(quanLyPhanBonEntities.LoaiPhanBons.ToList()); quanLyPhanBonEntities.SaveChanges(); foreach (var loaiPhan in _listLoaiPhanBon) { _loaiPhanBon.Add(new KeyValuePair <int, string>(loaiPhan.IDLoaiPhanBon, loaiPhan.TenLoaiPhanBon)); } }
public void _Vang(object parameter) { using (var db = new QuanLyPhanBonEntities()) { DiemDanh diemDanh = new DiemDanh(); diemDanh.isCoMat = false; diemDanh.isVang = true; diemDanh.NgayLam = DateTime.Now; diemDanh.NhanVien = _SelectedNhanVien.IDNhanVien; db.DiemDanhs.Add(diemDanh); _ListNhanVien.Remove(_SelectedNhanVien); OnPropertyChanged("ListNhanVien"); db.SaveChanges(); } }
private void getDataPhanBon() { QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities(); _ListPhanBon = new ObservableCollection <PhanBon> (quanLyPhanBonEntities.PhanBons.ToList()); OnPropertyChanged("ListPhanBon"); quanLyPhanBonEntities.SaveChanges(); if (_ListPhanBonTemp.Count > 0) { _ListPhanBonTemp.Clear(); } for (int i = 0; i < _ListPhanBon.Count; i++) { _ListPhanBonTemp.Add(_ListPhanBon[i]); } }
public void getData() { using (var db = new QuanLyPhanBonEntities()) { _ListNhanVien = new ObservableCollection <NhanVien>(db.NhanViens.ToList()); var listDiemDanh = new ObservableCollection <DiemDanh>(db.DiemDanhs.ToList()); foreach (var s in listDiemDanh) { if (s.NgayLam.Date == DateTime.Now.Date && s.NgayLam.Month == DateTime.Now.Month && s.NgayLam.Year == DateTime.Now.Year) { NhanVien nhanVien = db.NhanViens.Find(s.NhanVien); _ListNhanVien.Remove(nhanVien); OnPropertyChanged("ListNhanVien"); } } db.SaveChanges(); } }
public void _SaveKH(object parameter) { try { var ThemKHWinDow = parameter as Window; QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities(); KhachHang khachHang = new KhachHang(); khachHang.TenKhachHang = _TenKH; khachHang.GioiTinh = _SelectedGioiTinh.Key; khachHang.SDT = _SDT; khachHang.DiaChi = _DiaChi; quanLyPhanBonEntities.KhachHangs.Add(khachHang); quanLyPhanBonEntities.SaveChanges(); ThemKHWinDow.Close(); } catch (Exception ex) { } }
public KhuyenMaiViewModel() { BanPhanBonViewModel.PhanTramKM = 0; OKClick = new DelegateCommand(_OKClick); ObservableCollection <KhuyenMai> listKM; QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities(); listKM = new ObservableCollection <KhuyenMai>(quanLyPhanBonEntities.KhuyenMais.ToList()); quanLyPhanBonEntities.SaveChanges(); for (int i = 0; i < listKM.Count; i++) { if (listKM[i].NgayBatDau > DateTime.Now || listKM[i].NgayKetThuc < DateTime.Now) { listKM.RemoveAt(i); } } for (int i = 0; i < listKM.Count; i++) { _ListkM.Add(new KeyValuePair <string, double>(listKM[i].IDKhuyenMai, listKM[i].PhanTram)); } }
public void _SaveNhanVien(object parameter) { var ThemNhanVienWD = parameter as Window; try { NhanVien nhanVien = new NhanVien(); QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities(); nhanVien.TenNhanVien = _TenNhanVien; nhanVien.GioiTinh = _SelectedGioiTinh.Key; nhanVien.SDT = _SDT; nhanVien.DiaChi = _DiaChi; nhanVien.Luong = Int32.Parse(_Luong); quanLyPhanBonEntities.NhanViens.Add(nhanVien); quanLyPhanBonEntities.SaveChanges(); ThemNhanVienWD.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void _ThanhToan(object parameter) { try { ThanhToanViewModel.IDKhachHang = _SelectedKhachHang.IDKhachHang; ThanhToanViewModel.ToTal = decimal.Parse(_ThanhTien); View.Ban.ThanhToan thanhToan = new ThanhToan(); thanhToan.ShowDialog(); for (int i = 0; i < _ListPhanBon_KH.Count; i++) { QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities(); quanLyPhanBonEntities.PhanBon_KH.Add(_ListPhanBon_KH[i]); quanLyPhanBonEntities.SaveChanges(); //Chỗ này } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void FillMyDataGrid() { QuanLyPhanBonEntities entities = new QuanLyPhanBonEntities(); ObservableCollection <PhanBon> phanBonDataTableEntities = new ObservableCollection <PhanBon>(entities.PhanBons.ToList()); phanBonDataTable = new ObservableCollection <PhanBon>(); for (int i = 0; i < phanBonDataTableEntities.Count; i++) { if (phanBonDataTableEntities[i].isDelete == false) { phanBonDataTable.Add(phanBonDataTableEntities[i]); } } OnPropertyChanged("PhanBonDataTable"); _listLoaiPhanBon = new ObservableCollection <LoaiPhanBon>(entities.LoaiPhanBons.ToList()); OnPropertyChanged("listLoaiPhanBon"); entities.SaveChanges(); TemplatePhanBonDataTable = new ObservableCollection <PhanBon>(); for (int i = 0; i < phanBonDataTable.Count; i++) { TemplatePhanBonDataTable.Add(phanBonDataTable[i]); } }