private void getBudgetforMonth(int year, int month)
{
BudgetManagerModelContainer db = new BudgetManagerModelContainer();
List <BudgetItem> budgetItemList = new List <BudgetItem>();
var query = from Budget in db.Budgets
where Budget.Month == month && Budget.Year == year && Budget.UserId == 1
select Budget;
Budget budgets = new Budget();
if (query.Any())
{
budgets = query.First();
}
else
{
budgets = null;
}
BudgetItem budgetItem = new BudgetItem();
budgetItem.ItemType = (TransactionType)cmbType.SelectedItem;
budgetItem.Allocation = Double.Parse(txtAmount.Text);
budgetItem.CategoryId = ((Category)cmbCategory.SelectedItem).Id;
if (budgets != null)
{
budgetItem.BudgetId = budgets.Id;
budgetItemList = budgets.BudgetItems.ToList();
budgetItemList.Add(budgetItem);
budgets.BudgetItems = budgetItemList;
db.BudgetItems.Add(budgetItem);
db.SaveChanges();
}
else
{
budgets = new Budget();
budgetItemList.Add(budgetItem);
budgets.UserId = 1;
budgets.Year = Convert.ToInt16(year);
budgets.Month = Convert.ToInt16(month);
budgets.BudgetItems = budgetItemList;
db.Budgets.Add(budgets);
db.SaveChanges();
}
cleanFields();
setDataGridValue(year, month);
MessageBox.Show("Successful");
}
private void addTransaction(object sender, EventArgs e)
{
Transaction transaction = new Transaction();
if (createTransactionFromValues(ref transaction, transactionOperations.Save))
{
budgetManager.Transactions.Add(transaction);
budgetManager.SaveChanges();
MessageBox.Show("Transaction added successfully", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information);
loadData();
}
return;
}
private void btnDeleteBudgetClick(object sender, EventArgs e)
{
BudgetManagerModelContainer db = new BudgetManagerModelContainer();
Int16 budgetITemId = Convert.ToInt16(txtBudgetItemId.Text);
var query = from BudgetItem in db.BudgetItems
where BudgetItem.Id == budgetITemId
select BudgetItem;
var deleteBudgetItem = query.First();
db.BudgetItems.Remove(deleteBudgetItem);
db.SaveChanges();
int year = Int16.Parse(txtYear.Text);
Console.WriteLine("year :" + year);
int month = (cmbMonth.SelectedIndex) + 1;
Console.WriteLine("month :" + month);
setDataGridValue(year, month);
cleanFields();
}
private void Save(object sender, EventArgs e)
{
if (txtCategoryName.Text == "" || txtCategoryDesc.Text == "")
{
MessageBox.Show("Values Cannot be Empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
BudgetManagerModelContainer budgetManager = new BudgetManagerModelContainer();
var query = from Category in budgetManager.Categories
where Category.UserId == userId
select Category.Name;
if (!(query.ToList().Contains(txtCategoryName.Text)))
{
Category category = new Category();
category.Name = txtCategoryName.Text;
category.Desc = txtCategoryDesc.Text;
category.UserId = userId;
budgetManager.Categories.Add(category);
budgetManager.SaveChanges();
this.categoryAdded(true);
}
else
{
MessageBox.Show("Category Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
txtCategoryName.Text = "";
txtCategoryDesc.Text = "";
}
private void deleteCategory(object sender, EventArgs e)
{
if (GetUSerConfirmation())
{
BudgetManagerModelContainer budgetManager = new BudgetManagerModelContainer();
Int32 categoryId = Convert.ToInt32(gridViewCategory.SelectedRows[0].Cells[0].Value.ToString());
var query = from Category in budgetManager.Categories
where Category.Id == categoryId
select Category;
Category item = query.First();
budgetManager.Categories.Remove(item);
budgetManager.SaveChanges();
//MessageBox.Show("Deleted category successfully", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information);
loadCategoryList();
}
}
private void saveBudgetItem(Int16 id)
{
int year = Int16.Parse(txtYear.Text);
Console.WriteLine("year :" + year);
int month = (cmbMonth.SelectedIndex) + 1;
Console.WriteLine("month :" + month);
BudgetManagerModelContainer db = new BudgetManagerModelContainer();
var query = from BudgetItem in db.BudgetItems
where BudgetItem.Id == id
select BudgetItem;
BudgetItem budgetItem = query.First();
budgetItem.ItemType = (TransactionType)cmbType.SelectedItem;
budgetItem.Allocation = Double.Parse(txtAmount.Text);
budgetItem.CategoryId = ((Category)cmbCategory.SelectedItem).Id;
db.SaveChanges();
cleanFields();
setDataGridValue(year, month);
MessageBox.Show("Successful");
}
private void createUser(object sender, EventArgs e)
{
if (txtName.Text == "")
{
MessageBox.Show("'Name' field cannot be empty!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (txtUsername.Text == "")
{
MessageBox.Show("'Username' field cannot be empty!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (txtPassword.Text == "")
{
MessageBox.Show("'Password' field cannot be empty!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (txtRePassword.Text == "")
{
MessageBox.Show("'Confirm Password' field cannot be empty!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (txtPassword.Text != txtRePassword.Text)
{
MessageBox.Show("Password fields are not matching!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
User user = new User();
user.Name = txtUsername.Text;
var query = from User in budgetManager.Users
where User.UserName == user.UserName
select User;
User userFromDB;
if (query.Any())
{
userFromDB = query.First();
if (user.UserName != userFromDB.UserName)
{
MessageBox.Show("Username already exists!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
user.UserName = txtUsername.Text;
user.Password = txtPassword.Text;
budgetManager.Users.Add(user);
budgetManager.SaveChanges();
MessageBox.Show("User created successfully", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information);
clearFields();
/*if (createTransactionFromValues(ref transaction))
* {
* budgetManager.Transactions.Add(transaction);
* budgetManager.SaveChanges();
* MessageBox.Show("Transaction added successfully", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information);
* loadData();
* clearFields();
* }*/
}
