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 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 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 ChinhSuaViewModel()
{
_isEdit = false;
OnPropertyChanged("isEdit");
_GioiTinh.Add(new KeyValuePair <string, int>("Nam", 1));
_GioiTinh.Add(new KeyValuePair <string, int>("Nữ", 2));
EditNhanVien = new DelegateCommand(_EditNhanVien);
SaveNhanVien = new DelegateCommand(_SaveNhanVien);
Thoat = new DelegateCommand(_Thoat);
RemoveNhanVien = new DelegateCommand(_RemoveNhanVien);
QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities();
NhanVien nhanVien = quanLyPhanBonEntities.NhanViens.Find(IdNhanVien);
_TenNhanVien = nhanVien.TenNhanVien;
if (nhanVien.GioiTinh == "Nam")
{
_SelectedGioiTinh = new KeyValuePair <string, int>(nhanVien.GioiTinh, 1);
}
else
{
_SelectedGioiTinh = new KeyValuePair <string, int>(nhanVien.GioiTinh, 2);
}
_DiaChi = nhanVien.DiaChi;
OnPropertyChanged("SelectedGioiTinh");
_Luong = nhanVien.Luong.ToString();
_SDT = nhanVien.SDT;
TaiKhoan taiKhoan = quanLyPhanBonEntities.TaiKhoans.Where(b => b.IDNhanVien == IdNhanVien).FirstOrDefault();
if (taiKhoan != null)
{
_TenTaiKhoan = taiKhoan.TenTaiKhoan;
_PassWord = taiKhoan.MatKhau;
}
}
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;
}
}
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);
}
}
}
private void getData()
{
using (var db = new QuanLyPhanBonEntities())
{
var listDiemDanh = db.DiemDanhs.Where(s => s.NgayLam.Year == DateTime.Now.Year && s.NgayLam.Month == DateTime.Now.Month && s.isCoMat == true).ToList();
foreach (var s in listDiemDanh)
{
LuongHienTai luongHienTai = new LuongHienTai();
luongHienTai.TenNhanVien = db.NhanViens.Find(s.NhanVien).TenNhanVien;
luongHienTai.TienLuong = db.NhanViens.Find(s.NhanVien).Luong;
_listTienLuong.Add(luongHienTai);
}
for (int i = 0; i < (_listTienLuong.Count - 1); i++)
{
for (int j = i + 1; j < _listTienLuong.Count; j++)
{
if (_listTienLuong[i].TenNhanVien == _listTienLuong[j].TenNhanVien)
{
_listTienLuong[i].TienLuong += _listTienLuong[j].TienLuong;
_listTienLuong.RemoveAt(j);
OnPropertyChanged("ListTienLuong");
j--;
}
}
}
}
}
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
{
}
}
public void Refresh()
{
QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities();
ListNhanVien = new ObservableCollection <NhanVien>(quanLyPhanBonEntities.NhanViens.ToList());
OnPropertyChanged("ListNhanVien");
quanLyPhanBonEntities.SaveChanges();
}
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 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 LoginClick(object parameter)
{
var loginWindow = parameter as Window;
var passwordBox = parameter as IHavePassword;
if (_txtUser != null)
{
var db = new QuanLyPhanBonEntities();
TaiKhoan taiKhoan = null;
taiKhoan = db.TaiKhoans.Find(_txtUser.Trim());
if (taiKhoan != null)
{
var secureString = passwordBox.Password;
string PasswordBox = ConvertToUnsecureString(secureString);
if (PasswordBox == taiKhoan.MatKhau.Trim() && taiKhoan.IDNhanVien == 1 && _isQuanLy == true)
{
//Open New window with Manager
App.isQuanLy = true;
Home home = new Home();
// loginWindow.Hide();
loginWindow.Close();
home.ShowDialog();
}
else if (PasswordBox == taiKhoan.MatKhau.Trim() && _isQuanLy == false && taiKhoan.IDNhanVien != 1)
{
//Open new Window
App.isQuanLy = false;
Home home = new Home();
loginWindow.Close();
home.ShowDialog();
}
else
{
MessageBox.Show("Mật khẩu sai hoặc đăng nhập sai quyền!!Xin vui lòng kiểm tra lại!!");
}
}
else
{
MessageBox.Show("K tồn tại tài khoản, xin vui lòng kiểm tra lại!!");
}
}
}
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 _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 _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);
}
}
private void getData()
{
using (QuanLyPhanBonEntities quanLyPhanBonEntities = new QuanLyPhanBonEntities())
{
ObservableCollection <PhanBon_KH> phanBon_KHs = new ObservableCollection <PhanBon_KH>(quanLyPhanBonEntities.PhanBon_KH.ToList());
ObservableCollection <PhanBon_KH> TempPB_KH = new ObservableCollection <PhanBon_KH>();
decimal TongTien = 0;
for (int i = 0; i < phanBon_KHs.Count; i++)
{
if (phanBon_KHs[i].NgayBan.Month == DateTime.Now.Month && phanBon_KHs[i].NgayBan.Year == DateTime.Now.Year)
{
TempPB_KH.Add(phanBon_KHs[i]);
}
TongTien += phanBon_KHs[i].Gia;
}
_TongDoanhThu = TongTien + "";
OnPropertyChanged("TongDoanhThu");
for (int i = 0; i < (TempPB_KH.Count - 1); i++)
{
for (int j = i + 1; j < TempPB_KH.Count; j++)
{
if (TempPB_KH[i].IDPhanBon == TempPB_KH[j].IDPhanBon)
{
TempPB_KH[i].SoLuong += TempPB_KH[j].SoLuong;
TempPB_KH.RemoveAt(j);
j--;
}
}
}
for (int i = 0; i < TempPB_KH.Count; i++)
{
banChayTrongThang.Add(new KeyValuePair <string, int>(TempPB_KH[i].TenPhanBon, TempPB_KH[i].SoLuong));
}
_TopBanChay = banChayTrongThang;
OnPropertyChanged("TopBanChay");
}
}
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]);
}
}
