private void submitBillButton_Click(object sender, EventArgs e) { uint index = 1; int debtorCount = debtorsListBox.Items.Count; Payment[] payments = new Payment[debtorCount + 1]; Transaction t = new Transaction(amountTextBox.Value, transactionDatePicker.Value, descriptionTextbox.Text); Decimal debitAmount = t.Amount / debtorCount; payments[0] = new Payment(payerComboBox.SelectedUser, t.Amount, t, false); foreach (User u in debtorsListBox.Items) { payments[index] = new Payment(u, debitAmount, t, true); } TransactionSQLAccess.AddTransaction(t); foreach (Payment p in payments) { PaymentSQLAccess.AddPayment(p); } }
private void SetTransaction(Int32 transactionID) { this.transactionDetailView.Rows.Clear(); foreach (Payment p in PaymentSQLAccess.GetPayments(transactionID)) { this.transactionDetailView.Rows.Add(new object[] { p.User, p.Amount }); } }
public BillSummaryForm() { InitializeComponent(); Dictionary <User, Decimal> balances = new Dictionary <User, Decimal>(); foreach (Payment p in PaymentSQLAccess.GetAllPayments()) { if (balances.ContainsKey(p.User)) { balances[p.User] += p.Amount; } else { balances[p.User] = p.Amount; } } bindingSource = new BindingSource(); foreach (User u in balances.Keys) { bindingSource.Add(new BalanceData(u, balances[u])); } balanceTable.AutoGenerateColumns = true; balanceTable.AutoSize = true; balanceTable.DataSource = bindingSource; /* * DataGridViewColumn nameColumn = new DataGridViewColumn(); * nameColumn.DataPropertyName = "User.DisplayName"; * nameColumn.Name = "Name"; * balanceTable */ }