public static ObservableCollection <Category> GetCategoriesFromDb()
{
var categoriesList = new ObservableCollection <Category>();
DataTable q = QueryForSQLServer.GetCategory();
foreach (DataRow row in q.Rows)
{
var category = new Category {
Id = (int)row.ItemArray[0], Name = (string)row.ItemArray[1]
};
categoriesList.Add(category);
}
return(categoriesList);
}
public void searchFillter(ObservableCollection <Product> products)
{
this.InitializeComponent();
var categoriesList = new ObservableCollection <Category>();
DataTable q = QueryForSQLServer.GetCategory();
foreach (DataRow row in q.Rows)
{
var category = new Category {
Id = (int)row.ItemArray[0], Name = (string)row.ItemArray[1]
};
categoriesList.Add(category);
}
ProductData = products;
PagingPage();
cbbListType.ItemsSource = categoriesList;
}