public void RefreshDisplay() { _lookup = LoanProduct.CollectAll(); _viewModel = new LoanProductViewModel(); { _viewModel.Collection = LoanProduct.CollectAll(); } DataContext = _viewModel; }
internal static LoanProductCollection CollectAll() { var dataTable = DatabaseController.ExecuteSelectQuery("SELECT * FROM " + TABLE_NAME + " ORDER BY `Name`"); var collection = new LoanProductCollection(); foreach (DataRow dataRow in dataTable.Rows) { var item = new LoanProduct(); item.SetPropertiesFromDataRow(dataRow); collection.Add(item); } return(collection); }