public IQueryable <BudgetCategory> GetCategories(bool currentOnly = true)
{
if (currentOnly)
{
var query = from category in _context.GetCategories()
where category.EffectiveFrom == _context.GetCategories().Where(c => c.Name == category.Name).OrderByDescending(c => c.EffectiveFrom).First().EffectiveFrom
select category;
return(query);
}
return(_context.GetCategories());
}
public async Task <int> AddPayeeAsync(string name, string categoryName)
{
BudgetCategory category = _context.GetCategories()
.Where(c => c.Name == categoryName)
.OrderByDescending(c => c.EffectiveFrom)
.FirstOrDefault() ?? throw new ModelValidationException(nameof(Payee.BudgetCategoryID), null,
$"There is no Budget Category named '{categoryName}'");
return(await AddPayeeAsync(new Payee {
Name = name,
EffectiveFrom = DateTime.Now,
BudgetCategoryID = category.ID
}));
}
public bool HasCategories()
{
return(_context.GetCategories().Any());
}
public static async Task Initialize(IBudgetRepo context)
{
if (context.GetCategories().Any())
{
return; // Db Already has data
}
// Populate Budget Categories
List <BudgetCategory> categories = new List <BudgetCategory> {
new BudgetCategory {
Name = "Electric Bill",
Amount = 100,
EffectiveFrom = DateTime.Parse("9/1/2016"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Fuel",
Amount = 150,
EffectiveFrom = DateTime.Parse("9/1/2016"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Gas Bill",
Amount = 65,
EffectiveFrom = DateTime.Parse("8/1/2017"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Groceries",
Amount = 750,
EffectiveFrom = DateTime.Parse("10/1/2017"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Insurance",
Amount = 650,
EffectiveFrom = DateTime.Parse("10/1/2017"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Internet",
Amount = 50,
EffectiveFrom = DateTime.Parse("5/1/2017"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Phone",
Amount = 95,
EffectiveFrom = DateTime.Parse("6/1/2017"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Student Loans",
Amount = 500,
EffectiveFrom = DateTime.Parse("6/1/2016"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Tithe",
Amount = 563,
EffectiveFrom = DateTime.Parse("10/1/2017"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Water Bill",
Amount = 110,
EffectiveFrom = DateTime.Parse("10/1/2016"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Rent",
Amount = 575,
EffectiveFrom = DateTime.Parse("10/1/2016"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Extra Spending",
Amount = 350,
EffectiveFrom = DateTime.Parse("10/1/2016"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "ARC Income",
Amount = 0,
EffectiveFrom = DateTime.Parse("10/1/2016"),
Type = BudgetType.Income
},
new BudgetCategory {
Name = "ATM Withdrawals",
Amount = 0,
EffectiveFrom = DateTime.Parse("10/1/2016"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Medical",
Amount = 0,
EffectiveFrom = DateTime.Parse("10/1/2016"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Restaurants",
Amount = 0,
EffectiveFrom = DateTime.Parse("10/1/2016"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Miscellaneous",
Amount = 0,
EffectiveFrom = DateTime.Parse("10/1/2016"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Shopping",
Amount = 0,
EffectiveFrom = DateTime.Parse("10/1/2016"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Vehicle Maintenance",
Amount = 0,
EffectiveFrom = DateTime.Parse("10/1/2016"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Entertainment",
Amount = 0,
EffectiveFrom = DateTime.Parse("10/1/2016"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Taxes",
Amount = 0,
EffectiveFrom = DateTime.Parse("10/1/2016"),
Type = BudgetType.Expense
},
new BudgetCategory {
Name = "Tax Refund",
Amount = 0,
EffectiveFrom = DateTime.Parse("10/1/2016"),
Type = BudgetType.Income
},
new BudgetCategory {
Name = "Teaching Drums",
Amount = 0,
EffectiveFrom = DateTime.Parse("5/1/2016"),
Type = BudgetType.Income
},
new BudgetCategory {
Name = "Extra Income",
Amount = 0,
EffectiveFrom = DateTime.Parse("10/1/2016"),
Type = BudgetType.Income
},
new BudgetCategory {
Name = "Tutoring",
Amount = 0,
EffectiveFrom = DateTime.Parse("10/1/2017"),
Type = BudgetType.Income
}
};
foreach (var c in categories)
{
context.AddBudgetCategory(c);
}
// Populate Payees
List <Payee> payees = new List <Payee> {
new Payee {
Name = "Appraisal Research",
EffectiveFrom = DateTime.Parse("6/20/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "ARC Income").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "ARC Income").FirstOrDefault()
},
new Payee {
Name = "Cash Deposit",
EffectiveFrom = DateTime.Parse("10/1/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "Extra Income").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Extra Income").FirstOrDefault()
},
new Payee {
Name = "Earned Interest",
EffectiveFrom = DateTime.Parse("10/1/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "Extra Income").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Extra Income").FirstOrDefault()
},
new Payee {
Name = "Reiske Drum Lesson",
EffectiveFrom = DateTime.Parse("5/1/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "Teaching Drums").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Teaching Drums").FirstOrDefault()
},
new Payee {
Name = "Northwestern Water (102 Maple)",
EffectiveFrom = DateTime.Parse("10/1/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "Water Bill").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Water Bill").FirstOrDefault()
},
new Payee {
Name = "Medical Mutual",
EffectiveFrom = DateTime.Parse("10/1/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "Insurance").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Insurance").FirstOrDefault()
},
new Payee {
Name = "Dave and Louise",
EffectiveFrom = DateTime.Parse("10/1/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "Rent").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Rent").FirstOrDefault()
},
new Payee {
Name = "Verizon Wireless",
EffectiveFrom = DateTime.Parse("10/1/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "Phone").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Phone").FirstOrDefault()
},
new Payee {
Name = "Columbia Gas of Ohio",
EffectiveFrom = DateTime.Parse("10/1/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "Gas Bill").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Gas Bill").FirstOrDefault()
},
new Payee {
Name = "Medishare",
EffectiveFrom = DateTime.Parse("10/1/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "Insurance").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Insurance").FirstOrDefault()
},
new Payee {
Name = "Village of Bloomdale",
EffectiveFrom = DateTime.Parse("10/1/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "Electric Bill").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Electric Bill").FirstOrDefault()
},
new Payee {
Name = "FedLoan Servicing",
EffectiveFrom = DateTime.Parse("10/1/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "Student Loans").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Student Loans").FirstOrDefault()
},
new Payee {
Name = "Progressive Insurance",
EffectiveFrom = DateTime.Parse("8/1/2017"),
BudgetCategoryID = categories.Where(c => c.Name == "Insurance").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Insurance").FirstOrDefault()
},
new Payee {
Name = "Straight Talk",
EffectiveFrom = DateTime.Parse("10/1/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "Phone").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Phone").FirstOrDefault()
},
new Payee {
Name = "Brookside",
EffectiveFrom = DateTime.Parse("10/1/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "Tithe").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Tithe").FirstOrDefault()
},
new Payee {
Name = "Meijer",
EffectiveFrom = DateTime.Parse("10/1/2016"),
BudgetCategoryID = categories.Where(c => c.Name == "Groceries").FirstOrDefault().ID,
Category = categories.Where(c => c.Name == "Groceries").FirstOrDefault()
}
};
foreach (var p in payees)
{
context.AddPayee(p);
}
// Create Aliases
List <Alias> aliases = new List <Alias> {
new Alias {
Name = "Dave & Louise",
PayeeID = payees.Where(p => p.Name == "Dave and Louise").First().ID
},
new Alias {
Name = "Louise and Dave",
PayeeID = payees.Where(p => p.Name == "Dave and Louise").First().ID
},
new Alias {
Name = "Louise & Dave",
PayeeID = payees.Where(p => p.Name == "Dave and Louise").First().ID
},
new Alias {
Name = "MEIJER # 051",
PayeeID = payees.Where(p => p.Name == "Meijer").First().ID
},
new Alias {
Name = "MEIJER # 156",
PayeeID = payees.Where(p => p.Name == "Meijer").First().ID
},
new Alias {
Name = "Appraisal Re6366 APP RESEAR",
PayeeID = payees.Where(p => p.Name == "Appraisal Research").First().ID
},
new Alias {
Name = "FEDLOANSERVICING STDNT LOAN",
PayeeID = payees.Where(p => p.Name == "FedLoan Servicing").First().ID
},
new Alias {
Name = "PROGRESSIVE *INSURANCE",
PayeeID = payees.Where(p => p.Name == "Progressive Insurance").First().ID
},
new Alias {
Name = "STRAIGHTTALK*AIRTIME",
PayeeID = payees.Where(p => p.Name == "Straight Talk").First().ID
},
new Alias {
Name = "Brookside Evange WEB PMTS",
PayeeID = payees.Where(p => p.Name == "Brookside").First().ID
}
};
foreach (var a in aliases)
{
context.AddAlias(a);
}
await context.SaveChangesAsync();
}
