void reLoadData()
{
var dt = QueryForSQLServer.GetPurchase();
allPurchase = new ObservableCollection <object>();
//purchase
foreach (DataRow item in dt.Rows)
{
string formatted = ((DateTime)item["Created_At"]).ToString();
var _p = new
{
Purchase_ID = (int)item["Purchase_ID"],
Customer_Name = item["Customer_Name"] as string,
Tel = item["Tel"] as string,
Total = (decimal)item["Total"],
Created_At = formatted,
Status = (PurchaseStatus)(item["Status"])
};
allPurchase.Add(_p);
}
purchaseDataGrid.ItemsSource = allPurchase;
PagingPage();
//list_product.Clear();
}
