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(); }