public CheckInOut_ViewModel() { Load_Command = new RelayCommand <object>(p => { return(true); }, p => { IsActive = false; Message = String.Empty; IsChkInOpen = false; IsChkOutOpen = false; SelectedItem = new Models.CheckInOut(); ListType = new ObservableCollection <Models.Price>(Models.DataProvider.Ins.DB.Prices); SelectedType = null; }); CloseDetail_Command = new RelayCommand <object>(p => { return(true); }, p => { IsChkInOpen = false; IsChkOutOpen = false; }); OpenChkIn_Command = new RelayCommand <object>(p => { if (String.IsNullOrEmpty(BiensoNhandang) || String.IsNullOrEmpty(Thexe)) { return(false); } if (SelectedType == null) { return(false); } if (IsChkInOpen == true) { return(false); } return(true); }, p => { IsChkInOpen = true; }); CheckIn_Command = new RelayCommand <object>(p => { if (String.IsNullOrEmpty(BiensoNhandang) || String.IsNullOrEmpty(Thexe)) { return(false); } if (SelectedType == null) { return(false); } return(true); }, p => { if (checkValid()) { Models.CheckInOut insertItem = new Models.CheckInOut() { license = BiensoNhandang, cardId = Thexe, checkInTime = DateTime.Now, Price = SelectedType, checkInUserName = Login_ViewModel.CurrentUser.name }; Models.DataProvider.Ins.DB.CheckInOuts.Add(insertItem); Models.DataProvider.Ins.DB.SaveChanges(); IsChkInOpen = false; IsActive = true; Message = "Thao tác thành công"; } else { IsChkInOpen = false; IsActive = true; Message = "Biển số hoặc mã thẻ đã được thêm"; } }); OpenChkOut_Command = new RelayCommand <object>(p => { if (IsChkOutOpen == true) { return(false); } if (Thexe.Length != 5) { return(false); } if (String.IsNullOrEmpty(BiensoNhandang) || String.IsNullOrEmpty(Thexe)) { return(false); } return(true); }, p => { SelectedItem = Models.DataProvider.Ins.DB.CheckInOuts .Where(x => x.license == BiensoNhandang && x.cardId == Thexe && x.checkOutTime == null) .SingleOrDefault(); if (SelectedItem != null) { IsChkOutOpen = true; } else { IsActive = true; Message = "Không tìm được xe"; } }); CheckOut_Command = new RelayCommand <object>(p => { if (String.IsNullOrEmpty(BiensoNhandang) || String.IsNullOrEmpty(Thexe)) { return(false); } if (Thexe.Length != 5) { return(false); } return(true); }, p => { Models.CheckInOut updateItem = Models.DataProvider.Ins.DB.CheckInOuts .Where(x => x.license == BiensoNhandang && x.cardId == Thexe && x.checkOutTime == null) .SingleOrDefault(); if (updateItem != null) { updateItem.checkOutTime = DateTime.Now; updateItem.checkOutUserName = Login_ViewModel.CurrentUser.name; Models.DataProvider.Ins.DB.SaveChanges(); IsChkOutOpen = false; IsActive = true; Message = "Thao tác thành công"; } }); CloseAlert_Command = new RelayCommand <object>(p => { return(true); }, p => { IsActive = false; Message = String.Empty; }); GeneId_Command = new RelayCommand <object>(p => { return(true); }, p => { Thexe = MyStaticMethods.RandomInt(5); }); }
public Taikhoan_ViewModel() { List = new ObservableCollection <Model.TAIKHOAN>(Model.DataProvider.Ins.DB.TAIKHOANs.Where(x => x.IsDeleted == false).ToList().OrderBy(x => x.NHANVIEN.ma_quyen)); TaoDSNhanvien(); DeleteList = new ObservableCollection <Model.TAIKHOAN>(); 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; }); #region Trang quan tri he thong #region Load trang quan tri Load_Command = new RelayCommand <object>(p => { return(true); }, p => { List = new ObservableCollection <Model.TAIKHOAN>(Model.DataProvider.Ins.DB.TAIKHOANs.Where(x => x.IsDeleted == false).ToList().OrderBy(x => x.NHANVIEN.ma_quyen)); TaoDSNhanvien(); DeleteList = new ObservableCollection <Model.TAIKHOAN>(); }); #endregion #region Them tai khoan GetPassword_Command = new RelayCommand <PasswordBox>(p => { if (p.Password.Length < 5) { return(false); } return(true); }, p => { Matkhautaikhoan = p.Password; }); GetRePassword_Command = new RelayCommand <PasswordBox>(p => { if (p.Password.Length < 5) { return(false); } return(true); }, p => { Matkhauxacnhan = p.Password; }); Insert_Command = new RelayCommand <object>(p => { if (string.IsNullOrEmpty(Tentaikhoan) || string.IsNullOrEmpty(Emailkhoiphuc) || string.IsNullOrEmpty(Matkhautaikhoan) || string.IsNullOrEmpty(Matkhauxacnhan)) { return(false); } if (SNhanvien == null) { return(false); } if (MyStaticMethods.CheckEmail(Emailkhoiphuc) == false) { return(false); } return(true); }, p => { if (Matkhauxacnhan == Matkhautaikhoan) { if (!Kiemtratendangnhap(Tentaikhoan)) { Model.TAIKHOAN newItem = new Model.TAIKHOAN() { ma_taikhoan = MyStaticMethods.RandomInt(10), ten_taikhoan = Tentaikhoan, email = Emailkhoiphuc, matkhau = MyStaticMethods.MD5Hash(MyStaticMethods.Base64Encode(Matkhautaikhoan)), NHANVIEN = SNhanvien, IsDeleted = false, IsLogin = false }; Model.DataProvider.Ins.DB.TAIKHOANs.Add(newItem); Model.DataProvider.Ins.DB.SaveChanges(); List.Insert(0, newItem); TaoDSNhanvien(); SelectedItem = newItem; Active = true; Message = "Thêm mới thành công !!!"; } else { Active = true; Message = "Tên đăng nhập đã tồn tại !!!"; } } else { Active = true; Message = "Mật khẩu và xác nhận mật khẩu không trùng khớp !!!"; } }); #endregion #region Tao moi Reset_Command = new RelayCommand <object>(p => { return(true); }, p => { Tentaikhoan = ""; Matkhautaikhoan = ""; Matkhauxacnhan = ""; Emailkhoiphuc = ""; SNhanvien = null; SelectedItem = null; }); #endregion #region Xoa tai khoan DeleteShow_Command = new RelayCommand <object>(p => { if (DeleteList.Count() == 0) { return(false); } if (IsOpen == true) { return(false); } return(true); }, p => { IsOpen = true; Content = " Xóa vĩnh viễn các bản ghi được chọn ???"; }); AddDeleteList_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { DeleteList.Add(List.Where(x => x.ma_taikhoan == p.Uid.ToString()).SingleOrDefault()); }); RemoveDeleteList_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { DeleteList.Remove(List.Where(x => x.ma_taikhoan == 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.TAIKHOAN>(); Tentaikhoan = ""; Matkhautaikhoan = ""; Emailkhoiphuc = ""; SNhanvien = null; TaoDSNhanvien(); IsOpen = false; }); #endregion #endregion #region Trang dang nhap #region Dang nhap LoadDangnhap_Command = new RelayCommand <Window>(p => { return(true); }, p => { Matkhau = string.Empty; CheckRemember(p); }); getCurrentPass_Command = new RelayCommand <PasswordBox>(p => { return(true); }, p => { Matkhau = p.Password; }); Login_Command = new RelayCommand <Button>(p => { if (string.IsNullOrEmpty(Matkhau) || string.IsNullOrEmpty(Tendangnhap)) { return(false); } return(true); }, p => { if (Kiemtrataikhoan(Tendangnhap, Matkhau)) { string mk = MyStaticMethods.MD5Hash(MyStaticMethods.Base64Encode(Matkhau)); var current_user = Model.DataProvider.Ins.DB.TAIKHOANs.Where(x => x.ten_taikhoan == Tendangnhap && x.matkhau == mk).SingleOrDefault(); if (current_user.NHANVIEN.ma_quyen == 1) { View.View_Quanly.Manhinhchinh view = new View.View_Quanly.Manhinhchinh(); view.Show(); //MessageBox.Show("Đăng nhập thành công", "THÔNG BÁO"); } else { View.View_Thukho.Manhinhchinh view = new View.View_Thukho.Manhinhchinh(); view.Show(); //MessageBox.Show("Đăng nhập thành công", "THÔNG BÁO"); } CurrentUser = current_user; IsRemember(); Window w = getWindowParent(p) as Window; if (p != null) { w.Close(); } Chuyentrangthai_Mo(CurrentUser); } else { Active = true; Message = "Vui lòng kiểm tra lại tên đăng nhập và mật khẩu !!!"; } }); #endregion #region Khoi phuc Send_Command = new RelayCommand <Button>(p => { return(true); }, p => { if (!string.IsNullOrEmpty(Tendangnhap)) { var result = Model.DataProvider.Ins.DB.TAIKHOANs.Where(x => x.ten_taikhoan == Tendangnhap).Count(); if (result != 0) { Model.TAIKHOAN TK = Model.DataProvider.Ins.DB.TAIKHOANs.Where(x => x.ten_taikhoan == Tendangnhap).SingleOrDefault(); try { Makhoiphuc = GuiMail(TK); Khoiphuctk view = new Khoiphuctk(); view.Show(); Window w = getWindowParent(p) as Window; if (w != null) { w.Close(); } Active = true; Message = "Đã gửi mã xác thực !!! Vui lòng kiểm tra email "; } catch (Exception) { Active = true; Message = "Không thể gửi mã !!! "; } } else { Active = true; Message = "Tên đăng nhập không tồn tại !!!"; } } else { Active = true; Message = "Vui lòng điền tên đăng nhập !!!"; } }); Check_Command = new RelayCommand <Button>(p => { if (string.IsNullOrEmpty(Tendangnhap) || string.IsNullOrEmpty(Maxacthuc)) { return(false); } return(true); }, p => { Model.TAIKHOAN TK = Model.DataProvider.Ins.DB.TAIKHOANs.Where(x => x.ten_taikhoan == Tendangnhap).SingleOrDefault(); if (Maxacthuc == Makhoiphuc) { if (TK.NHANVIEN.ma_quyen == 1) { View.View_Quanly.Manhinhchinh view = new View.View_Quanly.Manhinhchinh(); view.Show(); //MessageBox.Show("Đăng nhập thành công", "THÔNG BÁO"); } else { View.View_Thukho.Manhinhchinh view = new View.View_Thukho.Manhinhchinh(); view.Show(); //MessageBox.Show("Đăng nhập thành công", "THÔNG BÁO"); } CurrentUser = TK; Makhoiphuc = ""; Maxacthuc = ""; Window w = getWindowParent(p) as Window; if (w != null) { w.Close(); } Chuyentrangthai_Mo(CurrentUser); } else { Active = true; Message = "Mã xác thực sai"; } }); #endregion #endregion #region Thay doi thong tin getNewCurrentPass_Command = new RelayCommand <PasswordBox>(p => { if (p.Password.Length < 5) { return(false); } if (string.IsNullOrEmpty(p.Password)) { return(false); } return(true); }, p => { Matkhaumoi = p.Password; }); getNewCurrentRePass_Command = new RelayCommand <PasswordBox>(p => { if (p.Password.Length < 5) { return(false); } if (string.IsNullOrEmpty(p.Password)) { return(false); } return(true); }, p => { XacnhanMatkhaumoi = p.Password; }); Update_Command = new RelayCommand <Button>(p => { if (string.IsNullOrEmpty(Tentkmoi) || string.IsNullOrEmpty(CurrentUser.email) || string.IsNullOrEmpty(CurrentUser.NHANVIEN.ten_nhanvien)) { return(false); } if (!MyStaticMethods.CheckEmail(CurrentUser.email)) { return(false); } return(true); }, p => { if (!Kiemtratendangnhap(Tentkmoi)) { if (!string.IsNullOrEmpty(Matkhaumoi) && !string.IsNullOrEmpty(XacnhanMatkhaumoi)) { if (Matkhaumoi == XacnhanMatkhaumoi) { CurrentUser.matkhau = MyStaticMethods.MD5Hash(MyStaticMethods.Base64Encode(Matkhaumoi)); } } CurrentUser.ten_taikhoan = Tentkmoi; Model.DataProvider.Ins.DB.SaveChanges(); Active = true; Message = "Đã cập nhật thông tin !!!"; } else { if (!string.IsNullOrEmpty(Matkhaumoi) && !string.IsNullOrEmpty(XacnhanMatkhaumoi)) { if (Matkhaumoi == XacnhanMatkhaumoi) { CurrentUser.matkhau = MyStaticMethods.MD5Hash(MyStaticMethods.Base64Encode(Matkhaumoi)); } } Model.DataProvider.Ins.DB.SaveChanges(); Active = true; Message = "Đã cập nhật thông tin !!! Không sửa tên đăng nhập"; } }); Back_Command = new RelayCommand <Button>(p => { return(true); }, p => { Window w = getWindowParent(p) as Window; if (w != null) { CurrentUser = Model.DataProvider.Ins.DB.TAIKHOANs.Where(x => x.ma_taikhoan == CurrentUser.ma_taikhoan).SingleOrDefault(); w.Close(); } }); #endregion #region Phan tinh trang Status_Command = new RelayCommand <object>(p => { return(true); }, p => { View.View_Quanly.Tinhtrang_nguoidung view = new View.View_Quanly.Tinhtrang_nguoidung(); view.WindowStartupLocation = WindowStartupLocation.CenterScreen; view.ShowDialog(); }); Refesh_State_Command = new RelayCommand <object>(p => { return(true); }, p => { Capnhattrangthai(); }); #endregion #region Phan sap xep OrderbyTennhanvien_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { if (p == null) { ObservableCollection <Model.TAIKHOAN> chkList = new ObservableCollection <Model.TAIKHOAN>(List.OrderByDescending(x => x.NHANVIEN.ten_nhanvien)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.TAIKHOAN>(List.OrderBy(x => x.NHANVIEN.ten_nhanvien)); } else { List = new ObservableCollection <Model.TAIKHOAN>(chkList); } } else if (p != null) { ObservableCollection <Model.TAIKHOAN> chkList = new ObservableCollection <Model.TAIKHOAN>(List_Tinhtrang.OrderByDescending(x => x.NHANVIEN.ten_nhanvien)); if (List_Tinhtrang[0] == chkList[0]) { List_Tinhtrang = new ObservableCollection <Model.TAIKHOAN>(List_Tinhtrang.OrderBy(x => x.NHANVIEN.ten_nhanvien)); } else { List_Tinhtrang = new ObservableCollection <Model.TAIKHOAN>(chkList); } } }); OrderbyTentaikhoan_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { if (p == null) { ObservableCollection <Model.TAIKHOAN> chkList = new ObservableCollection <Model.TAIKHOAN>(List.OrderByDescending(x => x.ten_taikhoan)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.TAIKHOAN>(List.OrderBy(x => x.ten_taikhoan)); } else { List = new ObservableCollection <Model.TAIKHOAN>(chkList); } } else if (p != null) { ObservableCollection <Model.TAIKHOAN> chkList = new ObservableCollection <Model.TAIKHOAN>(List_Tinhtrang.OrderByDescending(x => x.ten_taikhoan)); if (List_Tinhtrang[0] == chkList[0]) { List_Tinhtrang = new ObservableCollection <Model.TAIKHOAN>(List_Tinhtrang.OrderBy(x => x.ten_taikhoan)); } else { List_Tinhtrang = new ObservableCollection <Model.TAIKHOAN>(chkList); } } }); OrderbyTinhtrang_Command = new RelayCommand <object>(p => { if (List_Tinhtrang.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.TAIKHOAN> chkList = new ObservableCollection <Model.TAIKHOAN>(List_Tinhtrang.OrderByDescending(x => x.IsLogin)); if (List_Tinhtrang[0] == chkList[0]) { List_Tinhtrang = new ObservableCollection <Model.TAIKHOAN>(List.OrderBy(x => x.IsLogin)); } else { List_Tinhtrang = new ObservableCollection <Model.TAIKHOAN>(chkList); } }); #endregion }
public Nhaphang_ViewModel() { TaoDS_nhap(); DeleteList = new ObservableCollection <Model.CHITIETPHIEUNHAP>(); ListMathang = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); ListNCC_Print = new ObservableCollection <Model.NHACUNGCAP>(Model.DataProvider.Ins.DB.NHACUNGCAPs.Where(x => x.IsDeleted == false)); Active = false; IsOpen = false; IsOpen_insert = false; IsOpen_Filter = false; IsOpen_prt = 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_prt = false; }); Load_Command = new RelayCommand <object>(p => { return(true); }, p => { TaoDS_nhap(); DeleteList = new ObservableCollection <Model.CHITIETPHIEUNHAP>(); ListMathang = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); ListNCC_Print = 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)); ListMathang_Filter = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); ListNhacungcap_Filter = new ObservableCollection <Model.NHACUNGCAP>(Model.DataProvider.Ins.DB.NHACUNGCAPs.Where(x => x.IsDeleted == false)); Active = false; IsOpen = false; IsOpen_insert = false; IsOpen_Filter = false; IsOpen_prt = false; }); #region Tao moi Reset_Command = new RelayCommand <object>(p => { return(true); }, p => { SMathang = null; Soluongnhap = ""; Soluongthucnhap = ""; Dongianhap = ""; Dongiaxuat = ""; Phantram = ""; SelectedItem = null; }); #endregion #region Phan them GetvalueTextbox_Command = new RelayCommand <TextBox>(p => { double d; if (!double.TryParse((p.Text), out d)) { return(false); } if (string.IsNullOrEmpty(p.Text)) { return(false); } if (SMathang == null) { return(false); } if (string.IsNullOrEmpty(Soluongnhap) || string.IsNullOrEmpty(Soluongthucnhap) || string.IsNullOrEmpty(Dongianhap)) { return(false); } int dongianhap = 0; if (!int.TryParse(Dongianhap.Replace(" ", String.Empty), out dongianhap)) { return(false); } int soluongnhap = 0; if (!int.TryParse(Soluongnhap.Replace(" ", String.Empty), out soluongnhap)) { return(false); } int soluongthucnhap = 0; if (!int.TryParse(Soluongthucnhap.Replace(" ", String.Empty), out soluongthucnhap)) { return(false); } return(true); }, p => { Dongiaxuat = String.Empty; double phantram = Convert.ToDouble(Phantram) / 100; double dongianhap = Convert.ToDouble(Dongianhap.Replace(" ", String.Empty)); double dongiaxuat = ((phantram * dongianhap) + dongianhap); Dongiaxuat = dongiaxuat.ToString(); }); InsertShow_Command = new RelayCommand <object>(p => { if (SMathang == null) { return(false); } if (string.IsNullOrEmpty(Soluongnhap) || string.IsNullOrEmpty(Soluongthucnhap) || string.IsNullOrEmpty(Dongiaxuat) || string.IsNullOrEmpty(Dongianhap) || string.IsNullOrEmpty(Phantram)) { return(false); } int dongianhap = 0; if (!int.TryParse(Dongianhap.Replace(" ", String.Empty), out dongianhap)) { return(false); } int soluongnhap = 0; if (!int.TryParse(Soluongnhap.Replace(" ", String.Empty), out soluongnhap)) { return(false); } int soluongthucnhap = 0; if (!int.TryParse(Soluongthucnhap.Replace(" ", String.Empty), out soluongthucnhap)) { return(false); } try { if (Convert.ToInt32(Soluongnhap) <= 0 || Convert.ToInt32(Soluongthucnhap) <= 0) { return(false); } if (Convert.ToInt32(Dongianhap) <= 0 || Convert.ToDouble(Phantram) < 0) { return(false); } if (Convert.ToInt32(Dongiaxuat) <= 0) { return(false); } } catch (Exception) { /*Try catch de sua loi FormatException*/ } if (IsOpen_insert == true || IsOpen == true) { return(false); } return(true); }, p => { IsOpen_insert = true; string date_str = MyStaticMethods.ConvertDate2Vn_Today(); Ngay = date_str; }); Insert_Command = new RelayCommand <object>(p => { if (SMathang == null) { return(false); } if (string.IsNullOrEmpty(Soluongnhap) || string.IsNullOrEmpty(Soluongthucnhap) || string.IsNullOrEmpty(Dongiaxuat) || string.IsNullOrEmpty(Dongianhap) || string.IsNullOrEmpty(Phantram)) { return(false); } int dongianhap = 0; if (!int.TryParse(Dongianhap.Replace(" ", String.Empty), out dongianhap)) { return(false); } int soluongnhap = 0; if (!int.TryParse(Soluongnhap.Replace(" ", String.Empty), out soluongnhap)) { return(false); } int soluongthucnhap = 0; if (!int.TryParse(Soluongthucnhap.Replace(" ", String.Empty), out soluongthucnhap)) { return(false); } return(true); }, p => { string date_str = MyStaticMethods.ConvertDate2Vn_Today(); Model.PHIEUNHAP Phieu = CheckPhieunhap(date_str); Model.CHITIETPHIEUNHAP newPhieu = new Model.CHITIETPHIEUNHAP() { ma_ctphieunhap = MyStaticMethods.RandomInt(5) + "-" + SMathang.ma_mathang, MATHANG = SMathang, ma_phieunhap = Phieu.ma_phieunhap, soluongnhap = Convert.ToInt32(Soluongnhap.Replace(" ", String.Empty)), soluongthuc = Convert.ToInt32(Soluongthucnhap.Replace(" ", String.Empty)), soluongton = Convert.ToInt32(Soluongthucnhap.Replace(" ", String.Empty)), gianhap = Convert.ToDouble(Dongianhap.Replace(" ", String.Empty)), giaxuat = Convert.ToDouble(Dongiaxuat.Replace(" ", String.Empty)), nguoitao = getCurrentUser(), ghichu = Ghichu != "" ? Ghichu : null, IsDeleted = false, }; Model.Nhaphang_Service.Insert(newPhieu); List.Insert(0, newPhieu); SelectedItem = newPhieu; Active = true; Message = "Thêm mới thành công !!!"; IsOpen_insert = false; }); #endregion #region Phan xoa AddDeleteList_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { DeleteList.Add(List.Where(x => x.ma_ctphieunhap == p.Uid.ToString()).SingleOrDefault()); }); RemoveDeleteList_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { DeleteList.Remove(List.Where(x => x.ma_ctphieunhap == p.Uid.ToString()).SingleOrDefault()); }); DeleteShow_Command = new RelayCommand <object>(p => { if (DeleteList.Count() == 0) { return(false); } if (IsOpen_insert == true || IsOpen == true) { 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.CHITIETPHIEUNHAP>(); IsOpen = false; SelectedItem = null; }); #endregion #region Phan loc ListLoai_Filter = new ObservableCollection <Model.LOAIHANG>(Model.DataProvider.Ins.DB.LOAIHANGs.Where(x => x.IsDeleted == false)); ListMathang_Filter = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); ListNhacungcap_Filter = new ObservableCollection <Model.NHACUNGCAP>(Model.DataProvider.Ins.DB.NHACUNGCAPs.Where(x => x.IsDeleted == false)); FilterLoai_Command = new RelayCommand <ComboBox>(p => { return(true); }, p => { if (SLoai_Filter != null) { string ma = SLoai_Filter.ma_loaihang; FilterMathangby_Loai(ma); } else { ListMathang_Filter = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); } }); OpenFilter_Command = new RelayCommand <object>(p => { if (IsOpen_Filter == true || IsOpen == true || IsOpen_insert == true || IsOpen_prt == true) { return(false); } return(true); }, p => { IsOpen_Filter = true; }); ResetFilter_Command = new RelayCommand <Button>(p => { return(true); }, p => { ListLoai_Filter = new ObservableCollection <Model.LOAIHANG>(Model.DataProvider.Ins.DB.LOAIHANGs.Where(x => x.IsDeleted == false)); ListMathang_Filter = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); ListNhacungcap_Filter = new ObservableCollection <Model.NHACUNGCAP>(Model.DataProvider.Ins.DB.NHACUNGCAPs.Where(x => x.IsDeleted == false)); SNhacungcap_Filter = null; SMathang_Filter = null; SLoai_Filter = null; Date_Start = String.Empty; Date_End = String.Empty; TaoDS_nhap(); IsOpen_Filter = false; }); Filter_Command = new RelayCommand <Button>(p => { if (string.IsNullOrEmpty(Date_Start) || string.IsNullOrEmpty(Date_End)) { return(false); } DateTime date_start = Convert.ToDateTime(Date_Start); DateTime date_end = Convert.ToDateTime(Date_End); if ((date_start > date_end) && DateTime.TryParse(Date_Start, out date_start) && DateTime.TryParse(Date_End, out date_end)) { return(false); } return(true); }, p => { List = new ObservableCollection <Model.CHITIETPHIEUNHAP>(Model.DataProvider.Ins.DB.CHITIETPHIEUNHAPs.Where(x => x.IsDeleted == false).OrderByDescending(x => x.ma_phieunhap)); DateTime date_start = Convert.ToDateTime(Date_Start); DateTime date_end = Convert.ToDateTime(Date_End); FindByDate(date_start, date_end); if (SMathang_Filter != null) { FindByMH(SMathang_Filter.ma_mathang); } if (SNhacungcap_Filter != null) { FindByNCC(SNhacungcap_Filter.ma_nhacungcap); } if (SLoai_Filter != null) { FindByLOAI(SLoai_Filter.ma_loaihang); } 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.CHITIETPHIEUNHAP> chkList = new ObservableCollection <Model.CHITIETPHIEUNHAP>(List.OrderByDescending(x => x.MATHANG.ten_mathang)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.CHITIETPHIEUNHAP>(List.OrderBy(x => x.MATHANG.ten_mathang)); } else { List = new ObservableCollection <Model.CHITIETPHIEUNHAP>(chkList); } }); OrderbyTennhacungcap_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.CHITIETPHIEUNHAP> chkList = new ObservableCollection <Model.CHITIETPHIEUNHAP>(List.OrderByDescending(x => x.MATHANG.NHACUNGCAP.ten_nhacungcap)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.CHITIETPHIEUNHAP>(List.OrderBy(x => x.MATHANG.NHACUNGCAP.ten_nhacungcap)); } else { List = new ObservableCollection <Model.CHITIETPHIEUNHAP>(chkList); } }); OrderbyNgay_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.CHITIETPHIEUNHAP> chkList = new ObservableCollection <Model.CHITIETPHIEUNHAP>(List.OrderByDescending(x => MyStaticMethods.ConvertStringtoDate(x.PHIEUNHAP.ngaynhap))); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.CHITIETPHIEUNHAP>(List.OrderBy(x => MyStaticMethods.ConvertStringtoDate(x.PHIEUNHAP.ngaynhap))); } else { List = new ObservableCollection <Model.CHITIETPHIEUNHAP>(chkList); } }); OrderbyTendonvi_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.CHITIETPHIEUNHAP> chkList = new ObservableCollection <Model.CHITIETPHIEUNHAP>(List.OrderByDescending(x => x.MATHANG.DONVITINH.ten_donvi)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.CHITIETPHIEUNHAP>(List.OrderBy(x => x.MATHANG.DONVITINH.ten_donvi)); } else { List = new ObservableCollection <Model.CHITIETPHIEUNHAP>(chkList); } }); #endregion #region Printer PrinterOpen_Command = new RelayCommand <object>(p => { if (SNhacungcapPrint == null) { return(false); } if (string.IsNullOrEmpty(DayPrint)) { return(false); } return(true); }, p => { List_Print = new ObservableCollection <Model.CHITIETPHIEUNHAP>(List.Where(x => x.MATHANG.NHACUNGCAP == SNhacungcapPrint && x.PHIEUNHAP.ngaynhap == MyStaticMethods.FormatDateString(DayPrint))); var list_chk = new ObservableCollection <Model.CHITIETPHIEUNHAP>(); ItemsCount = 0; Tongtien = 0; foreach (var item in List_Print) { Tongtien += (double)(item.gianhap * item.soluongthuc); if (list_chk.Where(x => x.MATHANG == item.MATHANG).Count() == 0) { list_chk.Add(item); } } ItemsCount = list_chk.Count(); DayPrintVN = MyStaticMethods.FormatDateString(DayPrint); View.View_Thukho.In_Nhap w = new View.View_Thukho.In_Nhap(); w.ShowDialog(); }); OpenPrintDialog_Command = new RelayCommand <object>(p => { if (IsOpen == true) { return(false); } if (IsOpen_insert == true) { return(false); } if (IsOpen_Filter == true) { return(false); } return(true); }, p => { IsOpen_prt = true; }); Print_Command = new RelayCommand <Grid>(p => { return(true); }, p => { try { PrintDialog printDialog = new PrintDialog(); if (printDialog.ShowDialog() == true) { printDialog.PrintVisual(p, "invoice"); } MessageBox.Show("Thành công !!!", "THÔNG BÁO"); } catch (Exception) { MessageBox.Show("Có lỗi xảy ra !!!", "THÔNG BÁO"); }; }); PrinterFormClose_Command = new RelayCommand <Window>(p => { return(true); }, p => { if (p != null) { p.Close(); IsOpen_prt = false; } }); #endregion }
public Xuathang_ViewModel() { List = new ObservableCollection <Model.CHITIETPHIEUXUAT>(Model.DataProvider.Ins.DB.CHITIETPHIEUXUATs.Where(x => x.IsDeleted == false).ToList().OrderByDescending(x => MyStaticMethods.ConvertStringtoDate(x.PHIEUXUAT.ngayxuat))); DeleteList = new ObservableCollection <Model.CHITIETPHIEUXUAT>(); ListMathang = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); ListKhachhang = new ObservableCollection <Model.KHACHHANG>(Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.IsDeleted == false)); ListPhieunhap = new ObservableCollection <Model.CHITIETPHIEUNHAP>(); ListKH_Print = new ObservableCollection <Model.KHACHHANG>(Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.IsDeleted == false)); ListSoluong = new ObservableCollection <string>(); Active = false; IsOpen = false; IsOpen_insert = false; IsOpen_Filter = false; IsOpen_prt = 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_prt = false; }); Load_Command = new RelayCommand <object>(p => { return(true); }, p => { List = new ObservableCollection <Model.CHITIETPHIEUXUAT>(Model.DataProvider.Ins.DB.CHITIETPHIEUXUATs.Where(x => x.IsDeleted == false).ToList().OrderByDescending(x => MyStaticMethods.ConvertStringtoDate(x.PHIEUXUAT.ngayxuat))); DeleteList = new ObservableCollection <Model.CHITIETPHIEUXUAT>(); ListMathang = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); ListKhachhang = new ObservableCollection <Model.KHACHHANG>(Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.IsDeleted == false)); ListPhieunhap = new ObservableCollection <Model.CHITIETPHIEUNHAP>(); ListSoluong = new ObservableCollection <string>(); Active = false; IsOpen = false; IsOpen_insert = false; IsOpen_Filter = false; IsOpen_prt = false; ListLoai_Filter = new ObservableCollection <Model.LOAIHANG>(Model.DataProvider.Ins.DB.LOAIHANGs.Where(x => x.IsDeleted == false)); ListMathang_Filter = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); ListKhachhang_Filter = new ObservableCollection <Model.KHACHHANG>(Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.IsDeleted == false)); ListKH_Print = new ObservableCollection <Model.KHACHHANG>(Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.IsDeleted == false)); }); #region Lua chon mat hang va phieu nhap Select_mathang_Command = new RelayCommand <ComboBox>(p => { if (SMathang == null) { return(false); } return(true); }, p => { ListPhieunhap = new ObservableCollection <Model.CHITIETPHIEUNHAP>(); foreach (var item in Model.DataProvider.Ins.DB.CHITIETPHIEUNHAPs.Where(x => x.IsDeleted == false)) { while (item.MATHANG == SMathang) { ListPhieunhap.Add(item); break; } } }); Select_phieunhap_Command = new RelayCommand <ComboBox>(p => { if (SMathang == null || SPhieunhap == null) { return(false); } return(true); }, p => { Dongiaxuat = SPhieunhap.giaxuat.ToString(); ListSoluong = new ObservableCollection <string>(); for (int i = 1; i <= SPhieunhap.soluongton; i++) { ListSoluong.Add(i.ToString()); } }); #endregion #region Them moi InsertShow_Command = new RelayCommand <object>(p => { if (SPhieunhap == null || SKhachhang == null || SMathang == null) { return(false); } if (string.IsNullOrEmpty(Soluongxuat) || string.IsNullOrEmpty(Soluongthucxuat)) { return(false); } int soluongnhap = 0; if (!int.TryParse(Soluongxuat.Replace(" ", String.Empty), out soluongnhap)) { return(false); } int soluongthucnhap = 0; if (!int.TryParse(Soluongthucxuat.Replace(" ", String.Empty), out soluongthucnhap)) { return(false); } if (IsOpen_insert == true || IsOpen == true) { return(false); } if (Convert.ToInt32(Dongiaxuat) <= 0 || Convert.ToInt32(Soluongxuat) <= 0 || Convert.ToInt32(Soluongthucxuat) <= 0) { return(false); } return(true); }, p => { IsOpen_insert = true; string date_str = MyStaticMethods.ConvertDate2Vn_Today(); Ngay = date_str; }); Insert_Command = new RelayCommand <object>(p => { if (SPhieunhap == null || SKhachhang == null || SMathang == null) { return(false); } if (string.IsNullOrEmpty(Soluongxuat) || string.IsNullOrEmpty(Soluongthucxuat)) { return(false); } int soluongnhap = 0; if (!int.TryParse(Soluongxuat.Replace(" ", String.Empty), out soluongnhap)) { return(false); } int soluongthucnhap = 0; if (!int.TryParse(Soluongthucxuat.Replace(" ", String.Empty), out soluongthucnhap)) { return(false); } return(true); }, p => { string date_str = MyStaticMethods.ConvertDate2Vn_Today(); Model.PHIEUXUAT Phieu = CheckPhieuxuat(date_str); Model.CHITIETPHIEUXUAT newPhieu = new Model.CHITIETPHIEUXUAT() { ma_ctphieuxuat = MyStaticMethods.RandomInt(5) + "-" + SPhieunhap.MATHANG.ma_mathang, CHITIETPHIEUNHAP = SPhieunhap, KHACHHANG = SKhachhang, PHIEUXUAT = Phieu, soluongxuat = Convert.ToInt32(Soluongxuat), soluongthucxuat = Convert.ToInt32(Soluongthucxuat), nguoitao = getCurrentUser(), ghichu = Ghichu != "" ? Ghichu : null, IsDeleted = false, }; Model.Xuathang_Service.Insert(newPhieu); Update_luonghang(Convert.ToInt32(Soluongthucxuat), newPhieu.ma_ctphieunhap); List.Insert(0, newPhieu); SelectedItem = newPhieu; Active = true; Message = "Thêm mới thành công !!!"; IsOpen_insert = false; }); #endregion #region Phan xoa DeleteShow_Command = new RelayCommand <object>(p => { if (DeleteList.Count() == 0) { return(false); } if (IsOpen_insert == true || IsOpen == true) { 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_ctphieuxuat == p.Uid.ToString()).SingleOrDefault()); }); RemoveDeleteList_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { DeleteList.Remove(List.Where(x => x.ma_ctphieuxuat == 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.CHITIETPHIEUXUAT>(); IsOpen = false; SelectedItem = null; }); #endregion #region Tao moi Reset_Command = new RelayCommand <object>(p => { return(true); }, p => { SMathang = null; SPhieunhap = null; SKhachhang = null; Soluongxuat = ""; Soluongthucxuat = ""; Dongiaxuat = ""; SelectedItem = null; ListMathang = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); ListKhachhang = new ObservableCollection <Model.KHACHHANG>(Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.IsDeleted == false)); ListPhieunhap = new ObservableCollection <Model.CHITIETPHIEUNHAP>(); ListSoluong = new ObservableCollection <string>(); }); #endregion #region Phan loc ListLoai_Filter = new ObservableCollection <Model.LOAIHANG>(Model.DataProvider.Ins.DB.LOAIHANGs.Where(x => x.IsDeleted == false)); ListMathang_Filter = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); ListKhachhang_Filter = new ObservableCollection <Model.KHACHHANG>(Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.IsDeleted == false)); OpenFilter_Command = new RelayCommand <object>(p => { if (IsOpen_Filter == true || IsOpen_insert == true || IsOpen_prt == true || IsOpen == true) { return(false); } return(true); }, p => { IsOpen_Filter = true; }); FilterLoai_Command = new RelayCommand <ComboBox>(p => { return(true); }, p => { if (SLoai_Filter != null) { FilterMathangby_Loai(SLoai_Filter.ma_loaihang); } else { ListMathang_Filter = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); } }); ResetFilter_Command = new RelayCommand <Button>(p => { return(true); }, p => { ListLoai_Filter = new ObservableCollection <Model.LOAIHANG>(Model.DataProvider.Ins.DB.LOAIHANGs.Where(x => x.IsDeleted == false)); ListMathang_Filter = new ObservableCollection <Model.MATHANG>(Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.IsDeleted == false)); ListKhachhang_Filter = new ObservableCollection <Model.KHACHHANG>(Model.DataProvider.Ins.DB.KHACHHANGs.Where(x => x.IsDeleted == false)); SKhachhang_Filter = null; SMathang_Filter = null; SLoai_Filter = null; Date_Start = String.Empty; Date_End = String.Empty; List = new ObservableCollection <Model.CHITIETPHIEUXUAT>(Model.DataProvider.Ins.DB.CHITIETPHIEUXUATs.Where(x => x.IsDeleted == false).OrderByDescending(x => x.ma_phieuxuat)); IsOpen_Filter = false; }); Filter_Command = new RelayCommand <Button>(p => { if (string.IsNullOrEmpty(Date_Start) || string.IsNullOrEmpty(Date_End)) { return(false); } DateTime date_start = Convert.ToDateTime(Date_Start); DateTime date_end = Convert.ToDateTime(Date_End); if ((date_start > date_end) && DateTime.TryParse(Date_Start, out date_start) && DateTime.TryParse(Date_End, out date_end)) { return(false); } return(true); }, p => { List = new ObservableCollection <Model.CHITIETPHIEUXUAT>(Model.DataProvider.Ins.DB.CHITIETPHIEUXUATs.Where(x => x.IsDeleted == false).ToList().OrderByDescending(x => MyStaticMethods.ConvertStringtoDate(x.PHIEUXUAT.ngayxuat))); DateTime date_start = Convert.ToDateTime(Date_Start); DateTime date_end = Convert.ToDateTime(Date_End); FindByDate(date_start, date_end); if (SMathang_Filter != null) { FindByMH(SMathang_Filter.ma_mathang); } if (SKhachhang_Filter != null) { FindByKH(SKhachhang_Filter.ma_khachhang); } if (SLoai_Filter != null) { FindByLOAI(SLoai_Filter.ma_loaihang); } 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.CHITIETPHIEUXUAT> chkList = new ObservableCollection <Model.CHITIETPHIEUXUAT>(List.OrderByDescending(x => x.CHITIETPHIEUNHAP.MATHANG.ten_mathang)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.CHITIETPHIEUXUAT>(List.OrderBy(x => x.CHITIETPHIEUNHAP.MATHANG.ten_mathang)); } else { List = new ObservableCollection <Model.CHITIETPHIEUXUAT>(chkList); } }); OrderbyTennhacungcap_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.CHITIETPHIEUXUAT> chkList = new ObservableCollection <Model.CHITIETPHIEUXUAT>(List.OrderByDescending(x => x.CHITIETPHIEUNHAP.MATHANG.NHACUNGCAP.ten_nhacungcap)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.CHITIETPHIEUXUAT>(List.OrderBy(x => x.CHITIETPHIEUNHAP.MATHANG.NHACUNGCAP.ten_nhacungcap)); } else { List = new ObservableCollection <Model.CHITIETPHIEUXUAT>(chkList); } }); OrderbyNgay_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.CHITIETPHIEUXUAT> chkList = new ObservableCollection <Model.CHITIETPHIEUXUAT>(List.OrderByDescending(x => MyStaticMethods.ConvertStringtoDate(x.PHIEUXUAT.ngayxuat))); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.CHITIETPHIEUXUAT>(List.OrderBy(x => MyStaticMethods.ConvertStringtoDate(x.PHIEUXUAT.ngayxuat))); } else { List = new ObservableCollection <Model.CHITIETPHIEUXUAT>(chkList); } }); OrderbyTendonvi_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.CHITIETPHIEUXUAT> chkList = new ObservableCollection <Model.CHITIETPHIEUXUAT>(List.OrderByDescending(x => x.CHITIETPHIEUNHAP.MATHANG.DONVITINH.ten_donvi)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.CHITIETPHIEUXUAT>(List.OrderBy(x => x.CHITIETPHIEUNHAP.MATHANG.DONVITINH.ten_donvi)); } else { List = new ObservableCollection <Model.CHITIETPHIEUXUAT>(chkList); } }); #endregion #region Printer PrinterOpen_Command = new RelayCommand <object>(p => { if (SKhachhangPrint == null) { return(false); } if (string.IsNullOrEmpty(DayPrint)) { return(false); } return(true); }, p => { List_Print = new ObservableCollection <Model.CHITIETPHIEUXUAT>(List.Where(x => x.KHACHHANG == SKhachhangPrint && x.PHIEUXUAT.ngayxuat == MyStaticMethods.FormatDateString(DayPrint))); var list_chk = new ObservableCollection <Model.CHITIETPHIEUXUAT>(); ItemsCount = 0; Tongtien = 0; foreach (var item in List_Print) { Tongtien += (double)(item.CHITIETPHIEUNHAP.giaxuat * item.soluongthucxuat); if (list_chk.Where(x => x.CHITIETPHIEUNHAP.MATHANG == item.CHITIETPHIEUNHAP.MATHANG).Count() == 0) { list_chk.Add(item); } } ItemsCount = list_chk.Count(); DayPrintVN = MyStaticMethods.FormatDateString(DayPrint); View.View_Thukho.In_Xuat w = new View.View_Thukho.In_Xuat(); w.ShowDialog(); }); OpenPrintDialog_Command = new RelayCommand <object>(p => { if (IsOpen == true) { return(false); } if (IsOpen_insert == true) { return(false); } if (IsOpen_Filter == true) { return(false); } return(true); }, p => { IsOpen_prt = true; }); Print_Command = new RelayCommand <Grid>(p => { return(true); }, p => { try { PrintDialog printDialog = new PrintDialog(); if (printDialog.ShowDialog() == true) { printDialog.PrintVisual(p, "invoice"); } MessageBox.Show("Thành công !!!", "THÔNG BÁO"); } catch (Exception) { MessageBox.Show("Có lỗi xảy ra !!!", "THÔNG BÁO"); }; }); PrinterFormClose_Command = new RelayCommand <Window>(p => { return(true); }, p => { if (p != null) { p.Close(); IsOpen_prt = false; } }); #endregion }
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 Nhanvien_ViewModel() { List = new ObservableCollection <Model.NHANVIEN>(Model.DataProvider.Ins.DB.NHANVIENs.Where(x => x.IsDeleted == false)); DeleteList = new ObservableCollection <Model.NHANVIEN>(); List_Quyen = new ObservableCollection <Model.QUYEN>(Model.DataProvider.Ins.DB.QUYENs); 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.NHANVIEN>(Model.DataProvider.Ins.DB.NHANVIENs.Where(x => x.IsDeleted == false)); DeleteList = new ObservableCollection <Model.NHANVIEN>(); List_Quyen = new ObservableCollection <Model.QUYEN>(Model.DataProvider.Ins.DB.QUYENs); Active = false; IsOpen = false; }); #region Tao moi Reset_Command = new RelayCommand <object>(p => { return(true); }, p => { SelectedItem = null; Tennhanvien = ""; Diachi = ""; Sodienthoai = ""; Ngaysinh = ""; SQuyen = null; }); #endregion #region Phan them Insert_Command = new RelayCommand <object>(p => { if (string.IsNullOrEmpty(Tennhanvien) || string.IsNullOrEmpty(Sodienthoai) || string.IsNullOrEmpty(Diachi) || string.IsNullOrEmpty(Ngaysinh)) { return(false); } long i = 0; if (!long.TryParse(Sodienthoai, out i)) { return(false); } int count = Model.DataProvider.Ins.DB.NHANVIENs.Where(x => x.sodienthoai == Sodienthoai).Count(); if (count != 0) { return(false); } if (SQuyen == null) { return(false); } return(true); }, p => { SelectedItem = null; Model.NHANVIEN newItem = new Model.NHANVIEN() { ma_nhanvien = MyStaticMethods.RandomInt(10), ten_nhanvien = Tennhanvien, ngaysinh = MyStaticMethods.FormatDateString(Ngaysinh), QUYEN = SQuyen, diachi = Diachi, sodienthoai = Sodienthoai, IsDeleted = false }; Model.Nhanvien_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(Tennhanvien) || string.IsNullOrEmpty(Sodienthoai) || string.IsNullOrEmpty(Diachi) || string.IsNullOrEmpty(Ngaysinh)) { return(false); } long i = 0; if (!long.TryParse(Sodienthoai, out i)) { return(false); } if (SQuyen == null) { return(false); } return(true); }, p => { Model.NHANVIEN UpdateItem = new Model.NHANVIEN() { ten_nhanvien = Tennhanvien, ngaysinh = MyStaticMethods.FormatDateString(Ngaysinh), QUYEN = SQuyen, diachi = Diachi, sodienthoai = Sodienthoai }; Model.Nhanvien_Service.Update(UpdateItem, Manhanvien); for (int i = 0; i < List.Count(); i++) { if (List[i] == SelectedItem) { List[i] = new Model.NHANVIEN() { ma_nhanvien = Manhanvien, ten_nhanvien = Tennhanvien, diachi = Diachi, sodienthoai = Sodienthoai, ngaysinh = MyStaticMethods.FormatDateString(Ngaysinh), QUYEN = _SQuyen }; break; } } //MessageBox.Show("Chỉnh sửa thành công", "THÔNG BÁO"); SelectedItem = null; Tennhanvien = ""; Diachi = ""; Sodienthoai = ""; Ngaysinh = ""; SQuyen = null; 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_nhanvien == p.Uid.ToString()).SingleOrDefault()); }); RemoveDeleteList_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { DeleteList.Remove(List.Where(x => x.ma_nhanvien == p.Uid.ToString()).SingleOrDefault()); }); Delete_Command = new RelayCommand <object>(p => { if (DeleteList.Count() == 0) { return(false); } return(true); }, p => { RemoveIteminDb(); RemoveIteminList(); Capnhat_dboTaiKhoan(); DeleteList = new ObservableCollection <Model.NHANVIEN>(); IsOpen = false; SelectedItem = null; }); #endregion #region Sap xep OrderbyTen_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.NHANVIEN> chkList = new ObservableCollection <Model.NHANVIEN>(List.OrderByDescending(x => x.ten_nhanvien)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.NHANVIEN>(List.OrderBy(x => x.ten_nhanvien)); } else { List = new ObservableCollection <Model.NHANVIEN>(chkList); } }); OrderbyDiachi_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.NHANVIEN> chkList = new ObservableCollection <Model.NHANVIEN>(List.OrderByDescending(x => x.diachi)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.NHANVIEN>(List.OrderBy(x => x.diachi)); } else { List = new ObservableCollection <Model.NHANVIEN>(chkList); } }); OrderbyVitri_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.NHANVIEN> chkList = new ObservableCollection <Model.NHANVIEN>(List.OrderByDescending(x => x.QUYEN.ma_quyen)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.NHANVIEN>(List.OrderBy(x => x.QUYEN.ma_quyen)); } else { List = new ObservableCollection <Model.NHANVIEN>(chkList); } }); #endregion }