public void RemoveFromSumBeforeDetailedCategoryDelete(int detailedCategoryId) { DetailedCategory detCategory = _detailedCRepo.GetDetailedCategoryById(detailedCategoryId); int mainCategoryId = detCategory.MainCategoryId; var budget = GetBudgetOfMainCategory(mainCategoryId); var sumToRemoveFromBudget = SumAllExpensesAmountsOfDetailedCategory(detCategory); UpdateBudgetBeforeCategoryDelete(budget, sumToRemoveFromBudget); }
private decimal SumAllExpensesAmountsOfDetailedCategory(DetailedCategory detCategory) { decimal sum = 0; List <Expense> expensesOfCategory = _expenseRepo.GetAllExpensesOfDetailedCategory(detCategory.Id).ToList(); for (int i = 0; i < expensesOfCategory.Count; i++) { sum += expensesOfCategory[i].Amount; } return(sum); }
public void CreateDetailedCategoriesForNewUser(string userId) { var mainCategories = _mainCRepo.GetAllMainCategoriesOfUser(userId).ToList(); var d1 = new DetailedCategory() { Name = "Żywność", MainCategoryId = mainCategories[0].Id }; var d2 = new DetailedCategory() { Name = "Chemia domowa", MainCategoryId = mainCategories[0].Id }; var d3 = new DetailedCategory() { Name = "Rachunki", MainCategoryId = mainCategories[1].Id }; var d4 = new DetailedCategory() { Name = "Kredyty", MainCategoryId = mainCategories[1].Id }; var d5 = new DetailedCategory() { Name = "Transport i komunikacja", MainCategoryId = mainCategories[1].Id }; var d6 = new DetailedCategory() { Name = "Hobby i rozrywka", MainCategoryId = mainCategories[2].Id }; var d7 = new DetailedCategory() { Name = "Wystrój mieszkania", MainCategoryId = mainCategories[2].Id }; var d8 = new DetailedCategory() { Name = "Wyjazdy", MainCategoryId = mainCategories[2].Id }; List <DetailedCategory> detailedCategories = new List <DetailedCategory>() { d1, d2, d3, d4, d5, d6, d7, d8 }; _detailedCRepo.AddDetailedCategories(detailedCategories); }
public void UpdateDetailedCategory(DetailedCategory detailedCategory) { _context.Attach(detailedCategory); _context.Entry(detailedCategory).Property("Name").IsModified = true; _context.SaveChanges(); }
public int AddDetailedCategory(DetailedCategory detCategory) { _context.DetailedCategories.Add(detCategory); _context.SaveChanges(); return(detCategory.Id); }