public async Task <int> UpdateAliasAsync(int id, string name, int payeeId)
{
Alias originalAlias = _context.GetAliases()
.FirstOrDefault(a => a.ID == id) ?? throw new IdNotFoundException($"No Alias found for Id = {id}");
originalAlias.Name = name;
originalAlias.PayeeID = payeeId;
ValidateAlias(originalAlias);
try {
_context.EditAlias(originalAlias);
return(await _context.SaveChangesAsync());
} catch (DbUpdateConcurrencyException) {
throw new ConcurrencyException();
}
}
public async Task SaveChangesAsync_calls_EFCore_SaveChangesAsync()
{
// Act
await _testRepo.SaveChangesAsync();
// Assert
_mockContext.Verify(m => m.SaveChangesAsync(It.IsAny <CancellationToken>()), Times.Once);
}
public async Task <int> AddPayeeAsync(Payee payee)
{
ValidatePayee(payee);
_context.AddPayee(payee);
return(await _context.SaveChangesAsync());
}
public async Task <int> UpdateCategoryAsync(int id, double amount, DateTime effectiveFrom, BudgetType type)
{
BudgetCategory originalCategory = _context.GetCategories()
.FirstOrDefault(c => c.ID == id) ?? throw new IdNotFoundException($"No BudgetCategory found for Id = {id}");
try {
if (effectiveFrom > originalCategory.EffectiveFrom)
{
// Add new category
var categoryToAdd = new BudgetCategory {
Name = originalCategory.Name,
EffectiveFrom = effectiveFrom,
Amount = amount,
Type = type
};
ValidateBudgetCategory(categoryToAdd, false);
_context.AddBudgetCategory(categoryToAdd);
// Reassign payees and transactions accordingly
ReassignPayeesByDate(originalCategory, categoryToAdd);
ReassingTransactionsByDate(originalCategory, categoryToAdd);
}
else
{
if (effectiveFrom < originalCategory.EffectiveFrom)
{
// Check if there is an older category whose transactions/payees need to be split up
var categoryToStealFrom = _context.GetCategories()
.Where(c => c.Name == originalCategory.Name && c.EffectiveFrom < effectiveFrom)
.OrderByDescending(c => c.EffectiveFrom)
.FirstOrDefault();
// Update the originalCategory's date so payees/transactions will be properly reassigned
originalCategory.EffectiveFrom = effectiveFrom;
if (categoryToStealFrom != null)
{
ReassignPayeesByDate(categoryToStealFrom, originalCategory);
ReassingTransactionsByDate(categoryToStealFrom, originalCategory);
}
// Reassign payees/transactions from categories with newer EffectiveFrom dates and then delete the categories
foreach (BudgetCategory categoryToDelete in _context.GetCategories()
.Where(c => c.Name == originalCategory.Name &&
c.EffectiveFrom >= effectiveFrom &&
c.ID != id))
{
ReassignPayeesByDate(categoryToDelete, originalCategory);
ReassingTransactionsByDate(categoryToDelete, originalCategory);
_context.DeleteBudgetCategory(categoryToDelete);
}
}
// Update the original category's values
originalCategory.EffectiveFrom = effectiveFrom;
originalCategory.Amount = amount;
originalCategory.Type = type;
ValidateBudgetCategory(originalCategory, false);
_context.EditBudgetCategory(originalCategory);
}
return(await _context.SaveChangesAsync());
} catch (DbUpdateConcurrencyException) {
throw new ConcurrencyException();
}
}
public async Task <int> AddTransactionAsync(Transaction transaction)
{
_context.AddTransaction(transaction);
return(await _context.SaveChangesAsync());
}
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();
}