private static async Task SeedExpenses(ExpenseTrackerDbContext context)
{
if (!context.Expenses.Any())
{
context.Expenses.AddRange(
new Expense()
{
Amount = 26.54m,
ExpenseTypeId = context.ExpenseTypes.SingleOrDefault(pf => pf.Name == "Gas").Id,
Date = DateTime.Parse("2021-03-25")
},
new Expense()
{
Amount = 173.54m,
ExpenseTypeId = context.ExpenseTypes.SingleOrDefault(pf => pf.Name == "Internet").Id,
Date = DateTime.Parse("2021-02-27")
},
new Expense()
{
Amount = 145.21m,
ExpenseTypeId = context.ExpenseTypes.SingleOrDefault(pf => pf.Name == "Groceries").Id,
Date = DateTime.Parse("2021-03-28")
},
new Expense()
{
Amount = 86.04m,
ExpenseTypeId = context.ExpenseTypes.SingleOrDefault(pf => pf.Name == "Credit Card").Id,
Date = DateTime.Parse("2021-03-25")
},
new Expense()
{
Amount = 210.98m,
ExpenseTypeId = context.ExpenseTypes.SingleOrDefault(pf => pf.Name == "Car Repair").Id,
Date = DateTime.Parse("2021-03-25")
},
new Expense()
{
Amount = 81.02m,
ExpenseTypeId = context.ExpenseTypes.SingleOrDefault(pf => pf.Name == "Phone").Id,
Date = DateTime.Parse("2021-02-27")
},
new Expense()
{
Amount = 98.00m,
ExpenseTypeId = context.ExpenseTypes.SingleOrDefault(pf => pf.Name == "Heat").Id,
Date = DateTime.Parse("2021-03-28")
});
await context.SaveChangesAsync();
}
}
private static async Task SeedExpenseTypes(ExpenseTrackerDbContext context)
{
if (!context.ExpenseTypes.Any())
{
context.ExpenseTypes.AddRange(
new ExpenseType()
{
Name = "Car Repair"
},
new ExpenseType()
{
Name = "Phone"
},
new ExpenseType()
{
Name = "Heat"
},
new ExpenseType()
{
Name = "Internet"
},
new ExpenseType()
{
Name = "Groceries"
},
new ExpenseType()
{
Name = "Gas"
},
new ExpenseType()
{
Name = "Credit Card"
});
await context.SaveChangesAsync();
}
}
public static async Task SeedSampleDataAsync(ExpenseTrackerDbContext context)
{
await SeedExpenseTypes(context);
await SeedExpenses(context);
}
