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