public void Execute(object parameter) { bool res = false; var window = (Window)parameter; ExpenseDetailsDAL expenseDetailsDAL = new ExpenseDetailsDAL(); ExpenseDetails expense = new ExpenseDetails { UserId = AddExpenseViewModel.UserId, CategoryId = AddExpenseViewModel.CategoryId, Amount = AddExpenseViewModel.Amount, ExpenseDate = AddExpenseViewModel.ExpenseDate.GetValueOrDefault().ToString("yyyy-MM-dd"), Item = AddExpenseViewModel.Item, ExpenseTrackerId = AddExpenseViewModel.ExpenseTrackerId, }; if (expense.ExpenseTrackerId > 0) { res = expenseDetailsDAL.UpdateExpense(expense); } else { res = expenseDetailsDAL.AddExpense(expense); } if (res) { var viewModel = new ExpenseTrackerManagerViewModel(AddExpenseViewModel.UserId); viewModel.UserName = AddExpenseViewModel.UserName; ExpenseTrackerManager expenseTrackerManager = new ExpenseTrackerManager(viewModel); window.Close(); expenseTrackerManager.Show(); } }
public ExpenseTrackerManagerViewModel(int userId) { this.UserId = userId; this.LogoutCommand = new LogoutCommand(); this.AddExpensePageShowCommand = new AddExpensePageShowCommand(UserId, UserName); ExpenseDetailsDAL expenseDetailsDAL = new ExpenseDetailsDAL(); this.Expenses = new ObservableCollection <ExpenseDetails>(expenseDetailsDAL.GetExpenses(UserId)); this.TempExpenses = Expenses; this.ExpenseFilterCommand = new ExpenseFilterCommand(this); this.EditExpenseCommand = new EditExpenseCommand(this); this.DeleteExpenseCommand = new DeleteExpenseCommand(this); this.ExpenseChartCommand = new ExpenseChartCommand(this); }
public List <Bar> MappingOfBarValues(int userId) { CategoryDetailsDAL categoryDetailsDAL = new CategoryDetailsDAL(); var categoryList = categoryDetailsDAL.GetCategories(); ExpenseDetailsDAL expenseDetailsDAL = new ExpenseDetailsDAL(); var expenses = expenseDetailsDAL.GetExpenses(userId); List <Bar> _bar = new List <Bar>(); foreach (var category in categoryList) { var value = expenses.Where(x => x.CategoryId == category.CategoryId).Select(x => x.Amount).Sum(); _bar.Add(new Bar() { BarName = category.CategoryName, Value = value }); } return(_bar); }
public void Execute(object parameter) { MessageBoxResult result = MessageBox.Show("Do you want to Delete this Expense?", "Confirmation", MessageBoxButton.YesNoCancel, MessageBoxImage.Warning); if (result == MessageBoxResult.Yes) { ExpenseDetailsDAL expenseDetailsDAL = new ExpenseDetailsDAL(); var res = expenseDetailsDAL.DeleteExpense(ExpenseTrackerManagerViewModel.ExpenseDetails.ExpenseTrackerId); if (res) { MessageBox.Show("Expense Deleted Successfully!"); ExpenseTrackerManagerViewModel.Expenses = new ObservableCollection <ExpenseDetails>(expenseDetailsDAL.GetExpenses(ExpenseTrackerManagerViewModel.UserId)); } } else { } }