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 Thongke_ViewModel() { List = new ObservableCollection <Model.Thongke>(); DeleteList = new ObservableCollection <Model.Thongke>(); List_nhacungcap = new ObservableCollection <Model.NHACUNGCAP>(Model.DataProvider.Ins.DB.NHACUNGCAPs.Where(x => x.IsDeleted == false)); FilterList_nhacungcap = new ObservableCollection <Model.NHACUNGCAP>(); List_loaihang = new ObservableCollection <Model.LOAIHANG>(Model.DataProvider.Ins.DB.LOAIHANGs.Where(x => x.IsDeleted == false)); FilterList_loaihang = new ObservableCollection <Model.LOAIHANG>(); List_donvi = new ObservableCollection <Model.DONVITINH>(Model.DataProvider.Ins.DB.DONVITINHs.Where(x => x.IsDeleted == false)); FilterList_donvi = new ObservableCollection <Model.DONVITINH>(); IscheckAll = true; IsOpen = false; CloseDialog_Command = new RelayCommand <MaterialDesignThemes.Wpf.DialogHost>(p => { return(true); }, p => { p.IsOpen = false; }); Load_Command = new RelayCommand <object>(p => { return(true); }, p => { List = new ObservableCollection <Model.Thongke>(); DeleteList = new ObservableCollection <Model.Thongke>(); List_nhacungcap = new ObservableCollection <Model.NHACUNGCAP>(Model.DataProvider.Ins.DB.NHACUNGCAPs.Where(x => x.IsDeleted == false)); FilterList_nhacungcap = new ObservableCollection <Model.NHACUNGCAP>(); List_loaihang = new ObservableCollection <Model.LOAIHANG>(Model.DataProvider.Ins.DB.LOAIHANGs.Where(x => x.IsDeleted == false)); FilterList_loaihang = new ObservableCollection <Model.LOAIHANG>(); List_donvi = new ObservableCollection <Model.DONVITINH>(Model.DataProvider.Ins.DB.DONVITINHs.Where(x => x.IsDeleted == false)); FilterList_donvi = new ObservableCollection <Model.DONVITINH>(); IsOpen = false; }); #region Them / xoa khoi FilterList_nhacungcap AddtoFilterNCC_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { string id = p.Uid.ToString(); var item = List_nhacungcap.Where(x => x.ma_nhacungcap == id).SingleOrDefault(); FilterList_nhacungcap.Add(item); }); DeletefromFilterNCC_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { string id = p.Uid.ToString(); var item = List_nhacungcap.Where(x => x.ma_nhacungcap == id).SingleOrDefault(); FilterList_nhacungcap.Remove(item); }); #endregion #region Them / xoa khoi FilterList_loaihang AddtoFilterLH_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { string id = p.Uid.ToString(); var item = List_loaihang.Where(x => x.ma_loaihang == id).SingleOrDefault(); FilterList_loaihang.Add(item); }); DeletefromFilterLH_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { string id = p.Uid.ToString(); var item = List_loaihang.Where(x => x.ma_loaihang == id).SingleOrDefault(); FilterList_loaihang.Remove(item); }); #endregion #region Them / xoa khoi FilterList_donvi AddtoFilterDV_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { string id = p.Uid.ToString(); var item = List_donvi.Where(x => x.ma_donvi == id).SingleOrDefault(); FilterList_donvi.Add(item); }); DeletefromFilterDV_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { string id = p.Uid.ToString(); var item = List_donvi.Where(x => x.ma_donvi == id).SingleOrDefault(); FilterList_donvi.Remove(item); }); #endregion #region Phan xoa AddDeleteList_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { DeleteList.Add(List.Where(x => x.mathang.ma_mathang == p.Uid.ToString()).SingleOrDefault()); }); RemoveDeleteList_Command = new RelayCommand <CheckBox>(p => { return(true); }, p => { DeleteList.Remove(List.Where(x => x.mathang.ma_mathang == p.Uid.ToString()).SingleOrDefault()); }); 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 các bản ghi được chọn ???"; }); Delete_Command = new RelayCommand <object>(p => { if (DeleteList.Count() == 0) { return(false); } return(true); }, p => { for (int i = 0; i < List.Count(); i++) { while (DeleteList.Where(x => x == List[i]).Count() != 0) { if (List[i] == List[List.Count() - 1]) { List.Remove(List[i]); break; } else { List.Remove(List[i]); } } ; } DeleteList = new ObservableCollection <Model.Thongke>(); IsOpen = false; }); #endregion #region Thong ke Statistic_Command = new RelayCommand <object>(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.Thongke>(); Filter_ngaythang(MyStaticMethods.FormatDateString(Date_Start), MyStaticMethods.FormatDateString(Date_End)); if (IscheckAll == false) { UncheckAll_Filter(); } if (FilterList_nhacungcap.Count() != 0) { Filter_nhacungcap(); } if (FilterList_loaihang.Count() != 0) { Filter_loaimathang(); } if (FilterList_donvi.Count() != 0) { Filter_donvi(); } }); #endregion #region Xuat Excel Excel_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { string filePath = "*.xlsx"; // tạo SaveFileDialog để lưu file excel SaveFileDialog dialogs = new SaveFileDialog(); // chỉ lọc ra các file có định dạng Excel dialogs.Filter = "Excel | *.xlsx | Excel 2003 | *.xls"; // Nếu mở file và chọn nơi lưu file thành công sẽ lưu đường dẫn lại dùng if (dialogs.ShowDialog() == true) { filePath = dialogs.FileName; } // nếu đường dẫn null hoặc rỗng thì báo không hợp lệ và return hàm if (string.IsNullOrEmpty(filePath)) { MessageBox.Show("Đường dẫn báo cáo không hợp lệ"); return; } try { using (ExcelPackage pk = new ExcelPackage()) { // đặt tên người tạo file pk.Workbook.Properties.Author = ViewModel.Taikhoan_ViewModel.getCurrent(); // đặt tiêu đề cho file pk.Workbook.Properties.Title = "Báo cáo thống kê"; //Tạo một sheet để làm việc trên đó pk.Workbook.Worksheets.Add("BCTK sheet"); // lấy sheet vừa add ra để thao tác ExcelWorksheet ws = pk.Workbook.Worksheets[1]; // đặt tên cho sheet ws.Name = "BCTK sheet"; // fontsize mặc định cho cả sheet ws.Cells.Style.Font.Size = 11; // font family mặc định cho cả sheet ws.Cells.Style.Font.Name = "Calibri"; // Tạo danh sách các column header string[] arrColumnHeader = { (Date_Start + " - " + Date_End), "Mã mặt hàng", "Tên mặt hàng", "Loại mặt hàng", "Nhà cung cấp", "Số lượng nhập", "Số lượng xuất", "Số lượng tồn", "Đơn vị tính" }; // lấy ra số lượng cột cần dùng dựa vào số lượng header var countColHeader = arrColumnHeader.Count(); // merge các column lại từ column 1 đến số column header // gán giá trị cho cell vừa merge là Thống kê thông tni User Kteam ws.Cells[1, 1].Value = "Thống kê hàng hóa"; ws.Cells[1, 1, 1, countColHeader].Merge = true; // in đậm ws.Cells[1, 1, 1, countColHeader].Style.Font.Bold = true; // căn giữa ws.Cells[1, 1, 1, countColHeader].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center; int colIndex = 1; int rowIndex = 2; //tạo các header từ column header đã tạo từ bên trên foreach (var item in arrColumnHeader) { var cell = ws.Cells[rowIndex, colIndex]; //set màu thành gray var fill = cell.Style.Fill; fill.PatternType = ExcelFillStyle.Solid; fill.BackgroundColor.SetColor(System.Drawing.Color.LightBlue); //căn chỉnh các border var border = cell.Style.Border; border.Bottom.Style = border.Top.Style = border.Left.Style = border.Right.Style = ExcelBorderStyle.Thin; //gán giá trị cell.Value = item; colIndex++; } // lấy ra danh sách UserInfo từ ItemSource của DataGrid List <Model.Thongke> userList = List.Cast <Model.Thongke>().ToList(); // với mỗi item trong danh sách sẽ ghi trên 1 dòng foreach (var item in userList) { // bắt đầu ghi từ cột 1. Excel bắt đầu từ 1 không phải từ 0 colIndex = 1; // rowIndex tương ứng từng dòng dữ liệu rowIndex++; //gán giá trị cho từng cell ws.Cells[rowIndex, colIndex++].Value = ""; ws.Cells[rowIndex, colIndex++].Value = item.mathang.ma_mathang; ws.Cells[rowIndex, colIndex++].Value = item.mathang.ten_mathang; ws.Cells[rowIndex, colIndex++].Value = item.mathang.LOAIHANG.ten_loaihang; ws.Cells[rowIndex, colIndex++].Value = item.mathang.NHACUNGCAP.ten_nhacungcap; ws.Cells[rowIndex, colIndex++].Value = item.soluongnhap; ws.Cells[rowIndex, colIndex++].Value = item.soluongxuat; ws.Cells[rowIndex, colIndex++].Value = item.tonkho; ws.Cells[rowIndex, colIndex++].Value = item.mathang.DONVITINH.ten_donvi; } //Lưu file lại Byte[] bin = pk.GetAsByteArray(); File.WriteAllBytes(filePath, bin); } MessageBox.Show("Thành công !!!", "THÔNG BÁO"); Process.Start(filePath); } catch (Exception) { MessageBox.Show("Có lỗi khi lưu file !!!", "THÔNG BÁO"); } }); #endregion #region Sap xep OrderbyNhap_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.Thongke> chkList = new ObservableCollection <Model.Thongke>(List.OrderByDescending(x => x.soluongnhap)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.Thongke>(List.OrderBy(x => x.soluongnhap)); } else { List = new ObservableCollection <Model.Thongke>(chkList); } }); OrderbyXuat_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.Thongke> chkList = new ObservableCollection <Model.Thongke>(List.OrderByDescending(x => x.soluongxuat)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.Thongke>(List.OrderBy(x => x.soluongxuat)); } else { List = new ObservableCollection <Model.Thongke>(chkList); } }); OrderbyTon_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.Thongke> chkList = new ObservableCollection <Model.Thongke>(List.OrderByDescending(x => x.tonkho)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.Thongke>(List.OrderBy(x => x.tonkho)); } else { List = new ObservableCollection <Model.Thongke>(chkList); } }); OrderbyTenMathang_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.Thongke> chkList = new ObservableCollection <Model.Thongke>(List.OrderByDescending(x => x.mathang.ten_mathang)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.Thongke>(List.OrderBy(x => x.mathang.ten_mathang)); } else { List = new ObservableCollection <Model.Thongke>(chkList); } }); OrderbyTennhacungcap_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.Thongke> chkList = new ObservableCollection <Model.Thongke>(List.OrderByDescending(x => x.mathang.NHACUNGCAP.ten_nhacungcap)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.Thongke>(List.OrderBy(x => x.mathang.NHACUNGCAP.ten_nhacungcap)); } else { List = new ObservableCollection <Model.Thongke>(chkList); } }); OrderbyTenloai_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.Thongke> chkList = new ObservableCollection <Model.Thongke>(List.OrderByDescending(x => x.mathang.LOAIHANG.ten_loaihang)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.Thongke>(List.OrderBy(x => x.mathang.LOAIHANG.ten_loaihang)); } else { List = new ObservableCollection <Model.Thongke>(chkList); } }); OrderbyTendonvi_Command = new RelayCommand <object>(p => { if (List.Count() == 0) { return(false); } return(true); }, p => { ObservableCollection <Model.Thongke> chkList = new ObservableCollection <Model.Thongke>(List.OrderByDescending(x => x.mathang.DONVITINH.ten_donvi)); if (List[0] == chkList[0]) { List = new ObservableCollection <Model.Thongke>(List.OrderBy(x => x.mathang.DONVITINH.ten_donvi)); } else { List = new ObservableCollection <Model.Thongke>(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 }