public void SaveContacts(TextBox[] contactsTextBox, RadioButtons[] radioButtons) { for (int i = 0; i < contactsTextBox.Length; i++) { var contact = contactsTextBox[i].Text; var checkedType = radioButtons[i].Controls.OfType <RadioButton>() .FirstOrDefault(r => r.Checked); if (contact.Trim() == "" || checkedType == null) { MessageBox.Show(@"Please fill all the fields for contact : " + (i + 1), @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } using (var dbEntities = new ExpenseTrackerDBEntities()) { dbEntities.Contacts.Add(new Contact() { contactType = checkedType.Text, contactName = contact.Trim() }); dbEntities.SaveChanges(); } } MessageBox.Show(@"Contacts Are Successfully Added", @"Success", MessageBoxButtons.OK); }
public void Save(string transactionName, int value, string description, DateTime dateTime, RadioButton checkedType, RadioButton checkedRecurringOption, Contact contact, int id) { using (var dbEntities = new ExpenseTrackerDBEntities()) { Transaction transaction = new Transaction() { UsersId = MainView.user.Id, transactionId = id, date = dateTime, transactionName = transactionName, description = description, value = value, transactionType = checkedType.Text, isRecurring = checkedRecurringOption.Text, ContactId = contact.contactId }; if (id == 0) { dbEntities.Transactions.Add(transaction); } else { dbEntities.Entry(transaction).State = EntityState.Modified; } dbEntities.SaveChanges(); } }
public List <Transaction> GetMonthlyExpenses() { using (ExpenseTrackerDBEntities dbEntities = new ExpenseTrackerDBEntities()) { var dateTime = DateTime.Now.AddDays(-31); var todayDateTime = DateTime.Now; return(dbEntities.Transactions.Where(r => todayDateTime > r.date && r.date > dateTime).ToList <Transaction>()); } }
void PopulateTransactionsDataGridView() { dataGridTransactions.AutoGenerateColumns = false; using (ExpenseTrackerDBEntities dbEntities = new ExpenseTrackerDBEntities()) { var q = from t1 in dbEntities.Transactions join t2 in dbEntities.Contacts on t1.ContactId equals t2.contactId select new { t1.transactionId, t1.transactionName, t1.date, t1.description, t1.isRecurring, t1.transactionType, t1.UsersId, t1.value, t2.contactName, t2.contactId }; dataGridTransactions.DataSource = q.ToList(); } }
public bool VerifyLogin(String username, String password) { using (ExpenseTrackerDBEntities et = new ExpenseTrackerDBEntities()) { User user = et.Users.FirstOrDefault(r => r.username == username && r.password == password); if (user != null) { MainView mainView = new MainView(user); mainView.Show(); return(true); } else { return(false); } } }
private void TransactionForm_Load(object sender, EventArgs e) { using (var dbEntity = new ExpenseTrackerDBEntities()) { _payers = dbEntity.Contacts.Where(r => r.contactType == "Payer").ToList <Contact>(); _payees = dbEntity.Contacts.Where(r => r.contactType == "Payee").ToList <Contact>(); if (_payees.Count == 0 || _payers.Count == 0) { MessageBox.Show("Please add payers and payees via the contact list", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } PopulateTransactionsDataGridView(); Clear(); }
private void dataGridTransactions_DoubleClick(object sender, EventArgs e) { if (dataGridTransactions.CurrentRow.Index != -1) { _transaction.transactionId = Convert.ToInt32(dataGridTransactions.CurrentRow.Cells["transactionId"].Value); id = _transaction.transactionId; int contactId = Convert.ToInt32(dataGridTransactions.CurrentRow.Cells["contactId"].Value); using (ExpenseTrackerDBEntities dbEntities = new ExpenseTrackerDBEntities()) { _transaction = _transactionController.GetTransaction(dbEntities, _transaction); txtName.Text = _transaction.transactionName; txtDescription.Text = _transaction.description; txtValue.Text = _transaction.value.ToString(); if (_transaction.isRecurring == "Yes") { rbtYes.Checked = true; } else { rbtNo.Checked = true; } if (_transaction.transactionType == "Income") { btnIncome.Checked = true; int index = _payers.IndexOf(_payers.Find(r => r.contactId == contactId)); income_Combo(); cmbBoxContacts.SelectedIndex = index; } else if (_transaction.transactionType == "Expense") { btnExpense.Checked = true; int index = _payees.IndexOf(_payees.Find(r => r.contactId == contactId)); expense_Combo(); cmbBoxContacts.SelectedIndex = index; } btnSubmit.Text = "Update"; } } }
public Transaction GetTransaction(ExpenseTrackerDBEntities dbEntities, Transaction transaction) { return(dbEntities.Transactions.Where(x => x.transactionId == transaction.transactionId).FirstOrDefault()); }