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(); }