public frmAddIncome()
{
InitializeComponent();
using (CapitalResistDbContext context = new CapitalResistDbContext())
{
foreach (Category item in context.Categories.ToArray())
{
cmbCategory.Items.Add(item);
}
foreach (Account item in context.Accounts.ToArray())
{
cmbAccounts.Items.Add(item);
}
if (cmbAccounts.Items.Count > 0)
{
cmbAccounts.SelectedIndex = 0;
}
if (cmbCategory.Items.Count > 0)
{
cmbCategory.SelectedIndex = 0;
}
}
}
private void BtnAddCategory_Click(object sender, EventArgs e)
{
using (CapitalResistDbContext context = new CapitalResistDbContext())
{
context.Categories.Add(new Category {
Name = txtCategory.Text
});
context.SaveChanges();
}
Close();
}
private void BtnAddAccount_Click(object sender, EventArgs e)
{
using (CapitalResistDbContext context = new CapitalResistDbContext())
{
context.Accounts.Add(new Account
{
Name = txtAccountName.Text
});
context.SaveChanges();
}
Close();
}
private void FrmShowIncome_Load(object sender, EventArgs e)
{
using (var context = new CapitalResistDbContext())
{
var view = context.Transactions
.Where(x => x._Type == Transaction.Type.Income)
.Select(x => new {
Miktar = x.Money,
GelirTarihi = x.TransactionDate,
HesapAdı = x.Account.Name,
Kategori = x.Category.Name,
Not = x.Notes
});
dataGridView1.DataSource = view.ToArray();
lblTotal.Text = view.Sum(x => x.Miktar).ToString("f2");
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
var expenseData = new Transaction
{
TransactionDate = dateTimePicker.Value,
CreateDate = DateTime.Now,
Money = decimal.Parse(txtMoney.Text),
CategoryId = ((Category)cmbCategory.SelectedItem).Id,
AccountId = ((Account)cmbAccounts.SelectedItem).Id,
_Type = Transaction.Type.Income,
Notes = txtNotes.Text
};
using (CapitalResistDbContext context = new CapitalResistDbContext())
{
context.Transactions.Add(expenseData);
context.SaveChanges();
}
this.Close();
}
