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];
}
