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 dataGridEditValue(object sender, DataGridViewCellEventArgs e)
{
int budgetItemId = Convert.ToInt32(dataGridBudget.SelectedRows[0].Cells[0].Value.ToString());
Console.WriteLine("selected id :" + budgetItemId);
BudgetManagerModelContainer db = new BudgetManagerModelContainer();
var query = from BudgetItem in db.BudgetItems
where BudgetItem.Id == budgetItemId
select BudgetItem;
BudgetItem budgetItem = query.First();
txtYear.Text = budgetItem.Budget.Year.ToString();
txtYear.ReadOnly = true;
cmbMonth.SelectedIndex = (budgetItem.Budget.Month - 1);
//cmbMonth
txtMonth.Visible = true;
txtMonth.Text = (String)cmbMonth.SelectedItem;
txtMonth.ReadOnly = true;
cmbMonth.Visible = false;
cmbCategory.SelectedValue = budgetItem.CategoryId;
cmbType.SelectedItem = budgetItem.ItemType;
Console.WriteLine("55 :" + budgetItem.ItemType);
txtAmount.Text = budgetItem.Allocation.ToString();
txtBudgetItemId.Text = budgetItem.Id.ToString();
}
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 = "";
}
public BudgetMgt()
{
InitializeComponent();
//hide month textbox
txtMonth.Visible = false;
btnDeleteBudgetItem.BackColor = Color.Red;
//set values to category combo Box
BudgetManagerModelContainer db = new BudgetManagerModelContainer();
var query = from Category in db.Categories
where Category.UserId == 1
select Category;
List <Category> categoryList = query.ToList();
cmbCategory.DataSource = categoryList;
cmbCategory.DisplayMember = "Name";
cmbCategory.ValueMember = "Id";
//view grig for current month
string currentMonth = DateTime.Now.Month.ToString();
string currentYear = DateTime.Now.Year.ToString();
//MessageBox.Show("year :" + currentYear);
//MessageBox.Show("month" + currentMonth);
txtViewYear.Text = currentYear;
cmbViewMonth.SelectedIndex = Convert.ToInt16(currentMonth) - 1;
setDataGridValue(Convert.ToInt16(currentYear), Convert.ToInt16(currentMonth));
//set type valu combo box
cmbType.DataSource = Enum.GetValues(typeof(TransactionType));
cmbType.SelectedIndex = 0;
}
private void getBudgetItems()
{
BudgetManagerModelContainer budgetManager = new BudgetManagerModelContainer();
var query = from Budget in budgetManager.Budgets
where Budget.UserId == 1 && Budget.Month == DateTime.Now.Month
select Budget;
if (query.Any())
{
ThisMonthItemList = query.First().BudgetItems.ToList();
}
}
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 loadCategoryList()
{
BudgetManagerModelContainer budgetManager = new BudgetManagerModelContainer();
var query = from Category in budgetManager.Categories
where Category.UserId == 1 // to do : user should be passed
select Category;
categoriesList = categoriesList = query.ToList();
gridViewCategory.DataSource = categoriesList.Select(o => new
{ Id = o.Id, Name = o.Name, Description = o.Desc }).ToList();
this.gridViewCategory.Columns["Id"].Visible = false;
this.gridViewCategory.Columns["Description"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void loadCategoryList()
{
BudgetManagerModelContainer budgetManager = new BudgetManagerModelContainer();
var query = from Category in budgetManager.Categories
where Category.UserId == 1 // to do : user should be passed
select Category;
if (query.Any())
{
categoriesList = query.ToList();
loadExpenseBars();
}
}
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();
}
}
//get budget item list for month
private List <BudgetItem> getBudgetItemListForMonth(int year, int month)
{
BudgetManagerModelContainer db = new BudgetManagerModelContainer();
var query = from Budget in db.Budgets
where Budget.Month == month && Budget.Year == year && Budget.UserId == 1
select Budget;
List <BudgetItem> budgets = new List <BudgetItem>();
if (query.Any())
{
budgets = query.First().BudgetItems.ToList();
return(budgets);
}
else
{
return(budgets);
}
}
private void loadData()
{
userId = 1;
budgetManager = new BudgetManagerModelContainer();
var query = from Transaction in budgetManager.Transactions
where Transaction.UserId == 1 // to do : user should be passed
select Transaction;
transactionsList = query.ToList();
generateDataGridView(transactionsList);
var query2 = from Category in budgetManager.Categories
where Category.UserId == 1 // to do : user should be passed
select Category;
if (query2.Any())
{
categoryList = query2.ToList();
comboCategory.DataSource = categoryList;
comboCategory.DisplayMember = "Name";
comboCategory.ValueMember = "Id";
comboCategory.SelectedIndex = 0;
}
radioIncome.Checked = true;
comboRecursionType.DataSource = Enum.GetValues(typeof(RecursionInterval));
comboRecursionType.SelectedIndex = 0;
txtTitle.Text = "";
txtValue.Text = "";
txtDescription.Text = "";
setselectedTransactionId(-1);
datePickerTransaction.Value = DateTime.Today.AddDays(0);
datePickerStart.Value = DateTime.Today.AddDays(0);
datePickerEnd.Value = DateTime.Today.AddDays(0);
}
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");
}
public Login()
{
InitializeComponent();
budgetManager = new BudgetManagerModelContainer();
clearFields();
}
private void loadData()
{
budgetManager = new BudgetManagerModelContainer();
}
