public static void Seed(this ExpenseManagerContext dbContext)
{
dbContext.Users.AddRange(new User[]
{
new User {
FirstName = "Anthony", LastName = "Stark", Currency = "USD"
},
new User {
FirstName = "Natasha", LastName = "Romanova", Currency = "RUB"
}
});
dbContext.Expenses.AddRange(new Expense[]
{
new Expense {
UserID = 1, Amount = 30, Comment = "This is a test comment", CreationDate = DateTime.Now, Type = Expense.ExpenseType.Restaurant, Currency = "USD"
},
new Expense {
UserID = 1, Amount = 30, Comment = "This is a test comment", CreationDate = DateTime.Now.AddDays(-2), Type = Expense.ExpenseType.Hotel, Currency = "USD"
},
new Expense {
UserID = 2, Amount = 50, Comment = "This is a test comment", CreationDate = DateTime.Now, Type = Expense.ExpenseType.Misc, Currency = "RUB"
},
});
dbContext.SaveChanges();
}
public static ExpenseManagerContext GetExpenseManagerDbContext(string dbName)
{
// Create options for DbContext instance
var options = new DbContextOptionsBuilder <ExpenseManagerContext>()
.UseInMemoryDatabase(databaseName: dbName)
.Options;
// Create instance of DbContext
var dbContext = new ExpenseManagerContext(options);
// Add entities in memory
dbContext.Seed();
return(dbContext);
}
public AccountController(ILogger <AccountController> logger, ExpenseManagerContext context)
: base(logger, context)
{
}
public UnitOfWork(ExpenseManagerContext context)
{
_currentContext = context;
Repository = new Repository(context);
}
public ExpensesController(ExpenseManagerContext context)
{
_context = context;
}
public BudgetRepository(ExpenseManagerContext context)
{
_context = context;
}
public ExpenseRepository(ExpenseManagerContext context)
{
_context = context;
}
public static void Initialise(ExpenseManagerContext context)
{
if (context.Users.Any())
{
return;
}
var users = new User[] {
new User()
{
Email = "*****@*****.**",
Name = "Sharan",
Password = "******",
Phone = "+64275932755",
UserId = "123456"
},
};
foreach (var user in users)
{
context.Users.Add(user);
}
context.SaveChanges();
var expenseCategories = new ExpenseCategory[] {
new ExpenseCategory()
{
Name = "Food"
},
new ExpenseCategory()
{
Name = "Restraunts", ParentId = 1
},
new ExpenseCategory()
{
Name = "Subway", ParentId = 1
}
};
foreach (var category in expenseCategories)
{
context.ExpenseCategories.Add(category);
}
context.SaveChanges();
var expenses = new Expense[] {
new Expense()
{
ExpenseCategoryId = 1,
ExpenseDate = DateTime.UtcNow,
PaymentMethod = PaymentMethod.Cash,
Price = 20,
UserId = "123456"
}
};
foreach (var expense in expenses)
{
context.Expenses.Add(expense);
}
var budgets = new Budget[] {
new Budget()
{
Money = 1000,
FromDate = DateTime.UtcNow,
ToDate = DateTime.UtcNow.AddDays(10),
UserId = "123456"
},
};
foreach (var budget in budgets)
{
context.Budgets.Add(budget);
}
context.SaveChanges();
}
public TransactionController(ILogger <TransactionController> logger, ExpenseManagerContext context)
: base(logger, context)
{
}
// ReSharper disable once ContextualLoggerProblem : Inheritance hack used
protected BaseController(ILogger <T> logger, ExpenseManagerContext context)
{
Logger = logger;
DbContext = context;
}
public CategoryRepository(ExpenseManagerContext context)
{
_context = context;
}
public CategoryController(ILogger <CategoryController> logger, ExpenseManagerContext context)
: base(logger, context)
{
}
