public static Dictionary<string, CategoryType> CreateCategoryTypes(HttpContext context) { var dbContext = context.RequestServices.GetRequiredService<AccountingContext>(); var expenseType = new CategoryType { Name = ExpensesName, DisplayOrder = 2, AddTo = true }; var assetType = new CategoryType { Name = AssetsName, DisplayOrder = 1, AddTo = true, AddFrom = false }; var incomeType = new CategoryType { Name = IncomeName, DisplayOrder = 3, AddFrom = true }; dbContext.CategoryTypes.Add(expenseType); dbContext.CategoryTypes.Add(assetType); dbContext.CategoryTypes.Add(incomeType); var dict = new Dictionary<string, CategoryType>(); dict.Add(assetType.Name, assetType); dict.Add(expenseType.Name, expenseType); dict.Add(incomeType.Name, incomeType); return dict; }
private async Task SeedDevelopmentData() { if (await this.userManager.FindByEmailAsync("*****@*****.**") == null) { var newUser = new AccountingUser { UserName = "******", Email = "*****@*****.**" }; var result = await this.userManager.CreateAsync(newUser, "password"); } var base64Token = "OMuo2TLAB/iOX4IQs98+ag=="; SignupToken token = null; if (!this.context.SignupTokens.Any(t => t.Token == base64Token)) { this.context.SignupTokens.Add(new SignupToken { Token = base64Token }); } else { token = this.context.SignupTokens.First(t => t.Token == base64Token); token.Used = false; token.AccountingUser = null; token.AccountingUserId = null; this.context.SignupTokens.Update(token); } var user = await this.userManager.FindByNameAsync("testuser"); var expenseType = new CategoryType { Name = "Expenses", DisplayOrder = 2, AddTo = true }; var assetType = new CategoryType { Name = "Assets", DisplayOrder = 1, AddTo = true, AddFrom = false }; var incomeType = new CategoryType { Name = "Income", DisplayOrder = 3, AddFrom = true }; if (!this.context.CategoryTypes.Any(c => c.Name == expenseType.Name)) { this.context.CategoryTypes.Add(expenseType); } else { expenseType = this.context.CategoryTypes.First(c => c.Name == expenseType.Name); } if (!this.context.CategoryTypes.Any(c => c.Name == assetType.Name)) { this.context.CategoryTypes.Add(assetType); } else { assetType = this.context.CategoryTypes.First(c => c.Name == assetType.Name); } if (!this.context.CategoryTypes.Any(c => c.Name == incomeType.Name)) { this.context.CategoryTypes.Add(incomeType); } else { incomeType = this.context.CategoryTypes.First(c => c.Name == incomeType.Name); } var savings = new Category { Name = "Savings", NormalizedName = Category.NormalizeName("Savings"), CategoryType = assetType, AccountingUser = user }; var grocceries = new Category { Name = "Grocceries", NormalizedName = Category.NormalizeName("Grocceries"), CategoryType = expenseType, AccountingUser = user }; var salary = new Category { Name = "Salary", NormalizedName = Category.NormalizeName("Salary"), CategoryType = incomeType, AccountingUser = user }; var work = new Category { Name = "Work", NormalizedName = Category.NormalizeName("Work"), CategoryType = incomeType, AccountingUser = user, ParentCategory = salary }; var subwork = new Category { Name = "Subwork", NormalizedName = Category.NormalizeName("Subwork"), CategoryType = incomeType, AccountingUser = user, ParentCategory = work }; var incomeTransType = new TransactionType { Name = "Income", From = incomeType, To = assetType }; var expenseTransType = new TransactionType { Name = "Expense", From = assetType, To = expenseType }; var transferTransType = new TransactionType { Name = "Transfer", From = assetType, To = assetType }; if (!this.context.Categories.Any(c => c.Name == savings.Name)) { this.context.Categories.Add(savings); this.context.Categories.Add(grocceries); this.context.Categories.Add(salary); this.context.Categories.Add(work); this.context.Categories.Add(subwork); } else { savings = this.context.Categories.SingleOrDefault(c => c.Name == savings.Name); grocceries = this.context.Categories.SingleOrDefault(c => c.Name == grocceries.Name); salary = this.context.Categories.SingleOrDefault(c => c.Name == salary.Name); work = this.context.Categories.SingleOrDefault(c => c.Name == work.Name); subwork = this.context.Categories.SingleOrDefault(c => c.Name == subwork.Name); } if (!this.context.TransactionTypes.Any(t => t.Name == incomeTransType.Name)) { this.context.TransactionTypes.Add(incomeTransType); } else { incomeTransType = this.context.TransactionTypes.SingleOrDefault(t => t.Name == incomeTransType.Name); } if (!this.context.TransactionTypes.Any(t => t.Name == expenseTransType.Name)) { this.context.TransactionTypes.Add(expenseTransType); } else { expenseTransType = this.context.TransactionTypes.SingleOrDefault(t => t.Name == expenseTransType.Name); } if (!this.context.TransactionTypes.Any(t => t.Name == transferTransType.Name)) { this.context.TransactionTypes.Add(transferTransType); } else { transferTransType = this.context.TransactionTypes.SingleOrDefault(t => t.Name == transferTransType.Name); } this.context.SaveChanges(); var trans = new Transaction { From = salary, To = savings, TransactionType = incomeTransType, Total = 100, DateTime = DateTime.UtcNow, AccountingUser = user }; if (!this.context.Transactions.Any()) { this.context.Transactions.Add(trans); trans.To.AddTransaction(trans, from: false); trans.From.AddTransaction(trans, from: true); this.context.SaveChanges(); } }