public ProductView()
{
InitializeComponent();
SqlProductRepository colRecord = new SqlProductRepository();
txtColRecord.Text = Convert.ToString(colRecord.CountRecords());
}
private void btnRefresh_Click(object sender, RoutedEventArgs e)
{
SqlProductRepository listProduct = new SqlProductRepository();
List<Product> list = new List<Product>();
list = listProduct.SelectAll();
this.ListRecord.ItemsSource = list;
txtColRecord.Text = listProduct.CountRecords().ToString();
}