public EditCategoryWindow(int categoryID) { InitializeComponent(); this._mViewModel = new AddCategoryViewModel(); this.DataContext = _mViewModel; // Set viewmodel values to the category being edited editingCategoryMonthly = EZBudgetDB.GetCategoryMonthly(categoryID); populateViewModel(); }
public static ObservableCollection <Category> GetCurrentMonthBudgetCategories(int userID) { ObservableCollection <Category> Categories = new ObservableCollection <Category>(); try { var activeGlobalCategories = (from user in context.Users where user.UserID == userID select user.Budgets.FirstOrDefault() .Category_Global.Where(categoryGlobal => categoryGlobal.IsActive == true)); foreach (var categoryGlobal in activeGlobalCategories.First()) { var globalCategory = (Category_Global)categoryGlobal; // Get the current month category Category_Monthly currentMonthCategory = globalCategory.Category_Monthly.Where(categoryMonthly => categoryMonthly.CreationDate.Year == DateTime.Now.Year && categoryMonthly.CreationDate.Month == DateTime.Now.Month) .FirstOrDefault(); // Add category to Collection if (currentMonthCategory != null) { Categories.Add(new Category() { ID = currentMonthCategory.CategoryMonthlyID, GlobalID = globalCategory.CategoryGlobalID, Name = globalCategory.CategoryName, Description = globalCategory.CategoryDescription, ColorTag = globalCategory.ColorTag, Amount = Math.Round(currentMonthCategory.Amount, 2), Expenses = new List <Expense>() }); } } return(Categories); } catch { return(Categories); } }