private void Delete_OnClick(object sender, RoutedEventArgs e) { var removeItem = _observableDataBanks.Where(x => x.Selected).ToList(); if (removeItem.Count == 0) { MessageBox.Show("Check a box to delete a record.", "Error", MessageBoxButton.OK, MessageBoxImage.Stop); return; } foreach (var item in removeItem) { // var timestamp = item.Timestamp.ToString("yyyy-MM-dd HH:mm:ss"); _observableDataBanks.Remove(item); _current += item.Money; _expense.Remove(item); var currentTotal = new SqlConnect.Bank(_current, DateTime.Now); SqlConnect.InsertMoney("total", _userId, _current); _total.Add(currentTotal); SqlConnect.DeleteMoney("expense", item.Id, _userId); } CurrentMoney.Text = _current.ToString("C"); }
private void Income_OnClick(object sender, RoutedEventArgs e) { Income.IsEnabled = false; // Get amount of income var income = GetMoneyInput(); if (income <= 0) { Income.IsEnabled = true; return; } // Get current total _current = _current + income; // Update Total list and database var currentTotal = new SqlConnect.Bank(_current, DateTime.Now); SqlConnect.InsertMoney("total", _userId, _current); _total.Add(currentTotal); // Show current total CurrentMoney.Text = _current.ToString("C"); //MessageBox.Show(@"You successfully added an income to your bank"); Income.IsEnabled = true; }
private void Income_Click(object sender, EventArgs e) { // Get amount of income var income = GetMoneyInput(); if (income <= 0) { return; } // Get current total _current = _current + income; // Update Total list and database var currentTotal = new SqlConnect.Bank(_current, DateTime.Now); sql.InsertMoney("total", _userId, _current); _total.Add(currentTotal); // Show current total CurrentMoney.Text = _current.ToString("C"); }
private void Spend_OnClick(object sender, RoutedEventArgs e) { Spend.IsEnabled = false; // Get amount of expense var expense = GetMoneyInput(); if (expense <= 0) { Spend.IsEnabled = true; return; } // Get category string category; if (string.IsNullOrWhiteSpace(Category.Text)) { MessageBox.Show(@"You didn't choose category"); Spend.IsEnabled = true; return; } else { category = Category.Text; } // Get current total _current = _current - expense; // Update the expense list var expenseInput = new SqlConnect.Bank(expense, DateTime.Now, category); SqlConnect.InsertMoney("expense", _userId, expense, category); _expense.Add(expenseInput); _observableDataBanks.Add(expenseInput); // Update Total list and database var currentTotal = new SqlConnect.Bank(_current, DateTime.Now); SqlConnect.InsertMoney("total", _userId, _current); _total.Add(currentTotal); // Show current total CurrentMoney.Text = _current.ToString("C"); //MessageBox.Show(@"You successfully added an expense to your bank"); Spend.IsEnabled = true; }