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