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