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(); }