private void DeleteButton_Click(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show( "Are you sure you want to delete?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dialogResult == DialogResult.Yes) { using (DataBase.DBContainer db = new DataBase.DBContainer()) { var contact = (from Contacts in db.Contacts where Contact.Id == Contacts.Id select Contacts).FirstOrDefault(); if (contact != null) { db.Contacts.Remove(contact); db.SaveChanges(); } } this.Close(); } }
private void DeleteButton_Click(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show( "Are you sure you want to delete?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dialogResult == DialogResult.Yes) { using (DataBase.DBContainer db = new DataBase.DBContainer()) { var transaction = (from Transactions in db.Transactions where Transactions.Id == updatingTransaction.Id select Transactions).FirstOrDefault(); if (transaction != null) { db.Transactions.Remove(transaction); db.SaveChanges(); } } this.Close(); } }
private void saveContact(object sender, EventArgs e) { if (firstNameTextBox.Text.Length == 0) { MessageBox.Show( "Please add first name", "Missing field", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (lastNameTextBox.Text.Length == 0) { MessageBox.Show( "Please add last name", "Missing field", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var firstName = firstNameTextBox.Text; var lastName = lastNameTextBox.Text; var description = descriptionTextBox.Text; // database if (isUpdating) { using (DataBase.DBContainer db = new DataBase.DBContainer()) { var contact = (from Contacts in db.Contacts where Contact.Id == Contacts.Id select Contacts).FirstOrDefault(); if (contact != null) { contact.FirstName = firstName; contact.LastName = lastName; contact.Description = description; } db.SaveChanges(); } this.Close(); } else { using (DataBase.DBContainer db = new DataBase.DBContainer()) { DataBase.Contact contact = new DataBase.Contact { FirstName = firstName, LastName = lastName, Description = description, }; db.Contacts.Add(contact); db.SaveChanges(); } this.Close(); } }
private void saveCategory(object sender, EventArgs e) { if (categoryNameTextBox.Text.Length == 0) { MessageBox.Show( "Please add a category name", "Missing field", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (categoryTypeComboBox.SelectedItem == null) { MessageBox.Show( "Please select a category type", "Missing field", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var categoryName = categoryNameTextBox.Text; var categoryType = categoryTypeComboBox.SelectedItem.ToString(); // database if (isUpdating) { using (DataBase.DBContainer db = new DataBase.DBContainer()) { var category = (from Categories in db.Categories where Categories.Id == Category.Id select Categories).FirstOrDefault(); if (category != null) { category.Name = categoryName; category.TransactionType = categoryType; } db.SaveChanges(); } didSaveButtonPress = true; this.Close(); } else { using (DataBase.DBContainer db = new DataBase.DBContainer()) { DataBase.Category category = new DataBase.Category { Name = categoryName, TransactionType = categoryType, }; db.Categories.Add(category); db.SaveChanges(); } didSaveButtonPress = true; // data set this.dbData.Category.Rows.RemoveAt(0); this.dbData.AcceptChanges(); // xml String filePath = String.Format( "{0}\\{1}", Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "DSCategories.txt" ); this.dbData.WriteXml(filePath); this.Close(); } }
private void saveTransaction(object sender, EventArgs e) { var amount = decimal.ToDouble(amountNumericUpDown.Value); var categoryId = int.Parse(categoriesComboBox.SelectedValue.ToString()); var contactId = int.Parse(contactsComboBox.SelectedValue.ToString()); var date = datePicker.Value; if (amount == 0) { MessageBox.Show( "Please add an amount", "Missing field", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (categoryId == 0) { MessageBox.Show( "Please select a category", "Missing field", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (isUpdating) { using (DataBase.DBContainer db = new DataBase.DBContainer()) { var transaction = (from Transactions in db.Transactions where Transactions.Id == updatingTransaction.Id select Transactions).FirstOrDefault(); var selectedContact = (from Contacts in db.Contacts where Contacts.Id == contactId select Contacts).FirstOrDefault(); var selectedCategory = (from Categories in db.Categories where Categories.Id == categoryId select Categories).FirstOrDefault(); if (transaction != null) { transaction.Amount = amount; transaction.Category = selectedCategory; transaction.Contact = selectedContact; transaction.DateTime = date; transaction.TransactionType = selectedTransactionType.ToString(); } db.SaveChanges(); } this.Close(); } else { using (DataBase.DBContainer db = new DataBase.DBContainer()) { var selectedContact = (from Contacts in db.Contacts where Contacts.Id == contactId select Contacts).FirstOrDefault(); var selectedCategory = (from Categories in db.Categories where Categories.Id == categoryId select Categories).FirstOrDefault(); DataBase.Transaction transaction = new DataBase.Transaction { Amount = amount, Category = selectedCategory, DateTime = date, Contact = selectedContact, TransactionType = selectedTransactionType.ToString() }; db.Transactions.Add(transaction); db.SaveChanges(); } this.Close(); } }