public static void Update(Model.MATHANG item, string id)
{
Model.MATHANG getdt = Model.DataProvider.Ins.DB.MATHANGs.Where(x => x.ma_mathang == id).SingleOrDefault();
getdt.ten_mathang = item.ten_mathang;
getdt.hang = item.hang;
getdt.dong = item.dong;
getdt.DONVITINH = item.DONVITINH;
getdt.NHACUNGCAP = item.NHACUNGCAP;
getdt.LOAIHANG = item.LOAIHANG;
getdt.mota = item.mota;
Model.DataProvider.Ins.DB.SaveChanges();
}
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 static void Delete(Model.MATHANG item)
{
Model.DataProvider.Ins.DB.MATHANGs.Remove(item);
}
public static void Insert(Model.MATHANG item)
{
Model.DataProvider.Ins.DB.MATHANGs.Add(item);
Model.DataProvider.Ins.DB.SaveChanges();
}
