private void IncomeWindow_Load(object sender, EventArgs e) { String[] sort = { "IncomeID", "PaidFrom", "Payment", "IncomeDate" }; transactionDatePicker.Format = DateTimePickerFormat.Custom; transactionDatePicker.CustomFormat = "yyyy-MM-dd"; DatabaseCalls.GetIncome(dataadapter, ds); incomeGridView.DataSource = ds.Tables[0]; incomeGridView.Columns[2].DefaultCellStyle.Format = "C"; incomeGridView.Columns["Payment"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; incomeGridView.Columns["Id"].Width = 50; incomeGridView.Columns["Recipient"].Width = 140; incomeGridView.Columns["TransactionDate"].Width = 140; recipients = Recipient.GetRecipients(); categories = Category.GetCategories(); foreach (Category category in categories) { categoryBox.Items.Add(category.Name); } foreach (DataGridViewColumn column in incomeGridView.Columns) { column.SortMode = DataGridViewColumnSortMode.Automatic; } }
private void deleteBtn_Click(object sender, EventArgs e) { income = new Income { Id = int.Parse(IDBox.Text) }; income.Delete(); ds.Tables.Clear(); DatabaseCalls.GetIncome(dataadapter, ds); incomeGridView.DataSource = ds.Tables[0]; }
private void updateBtn_Click(object sender, EventArgs e) { income = new Income { Id = int.Parse(IDBox.Text), RecipientId = recipients.Find(r => r.Name == recipientBox.Text).RecipientId, Payment = Convert.ToDouble(paymentBox.Text), PaymentDate = transactionDatePicker.Text }; income.Update(); ds.Tables.Clear(); DatabaseCalls.GetIncome(dataadapter, ds); incomeGridView.DataSource = ds.Tables[0]; }
private void transactionBtn_Click(object sender, EventArgs e) { income.GetNewestIncome(); recipients = Recipient.GetRecipients(); income.RecipientId = recipients.Find(r => r.Name == recipientBox.Text)?.RecipientId; category.CategoryId = categories.Find(c => c.Name == categoryBox.Text)?.CategoryId; if (income.RecipientId == null) { recipient = new Recipient { Name = recipientBox.Text }; recipient.Add(); income.RecipientId = recipient.RecipientId; } if (category.CategoryId == null) { category = new Category { Name = categoryBox.Text }; category.Add(); income.RecipientId = recipient.RecipientId; } income.Payment = Convert.ToDouble(paymentBox.Text); income.PaymentDate = transactionDatePicker.Text; income.Insert(); ds.Tables.Clear(); DatabaseCalls.GetIncome(dataadapter, ds); incomeGridView.DataSource = ds.Tables[0]; }