public void RefreshDisplay()
{
_lookup = FinancialConditionReportConfiguration.CollectAll();
_viewModel = new ViewModel
{
Collection = FinancialConditionReportConfiguration.CollectAll()
};
DataContext = _viewModel;
}
internal static FinancialConditionReportConfigurationCollection CollectAll()
{
var query = string.Format("SELECT * FROM `{0}` ORDER BY order_no", TableName);
var collection = new FinancialConditionReportConfigurationCollection();
var dataTable = DatabaseController.ExecuteSelectQuery(query);
foreach (DataRow dataRow in dataTable.Rows)
{
var item = new FinancialConditionReportConfiguration();
item.SetPropertiesFromDataRow(dataRow);
collection.Add(item);
}
return(collection);
}
public void Search()
{
if (_lookup == null)
{
return;
}
if (!_lookup.Any())
{
return;
}
var searchItem = SearchTextBox.Text;
if (searchItem.Trim().Length == 0)
{
RefreshDisplay();
}
else
{
var filteredItem = from item in _lookup
where
item.AccountCode.ToLower().Contains(searchItem.ToLower()) ||
item.AccountTitle.ToLower().Contains(
searchItem.ToLower())
select item;
var collection = new FinancialConditionReportConfigurationCollection();
foreach (var item in filteredItem)
{
collection.Add(item);
}
_viewModel.Collection = collection;
DataContext = _viewModel;
}
}
