public ExpenseViewViewModel()
{
_queryHandler = ExpenseQueryHandler.GetDBConnector();
PopulateData();
ExpenseTypes = new ObservableCollection <string>((from expense in Expenses
orderby expense.Type
select expense.Type).Distinct().ToList());
}
public DataViewViewModel()
{
FileName = "Select a File to Load";
_queryHandler = ExpenseQueryHandler.GetDBConnector();
//YearWiseExpenses = new ObservableCollection<YearlyExpenseData>();
PopulateData();
StartDate = EndDate = DateTime.Today;
}
private async void LoadData()
{
OpenFileDialog fileDialog = new OpenFileDialog();
fileDialog.ShowDialog();
FileName = fileDialog.FileName;
ExpenseData.Clear();
//YearWiseExpenses.Clear();
IList <Expense> Result = await ExcelParser.Parse(FileName);
await ExpenseQueryHandler.GetDBConnector().ImportDataBase(Result);
PopulateData();
}
