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