public void Save() { dbContext.SaveChanges(); }
public Restaurant AddRes(Restaurant Res) { _context.Add(Res); _context.SaveChanges(); return(Res); }
public void DeleteUserContact(int id) { context.Set <UserInfo>().Remove(GetUser(id)); context.SaveChanges(); }
public async Task GetMonthlyReportForAccount_TestAsync() { var id = new Guid("17b33123-99ea-4bac-b1d1-c3fc0b7579c3"); var options = new DbContextOptionsBuilder <SqlDBContext>() .UseInMemoryDatabase(databaseName: "Test") .Options; using (var context = new SqlDBContext(options)) { context.Accounts.Add(new Account { ResourceId = new Guid("17b33123-99ea-4bac-b1d1-c3fc0b7579c3"), Product = new Product { Id = new Guid(), Name = "some product" }, IBAN = "32141sadf", Name = "Jon", Transactions = new List <Transaction>() { new Transaction { Amount = 20.0M, CategoryId = Models.Enums.Category.Travel, IBAN = "dsafdsafafdas", TransactionDate = new DateTimeOffset(2020, 9, 10, 13, 0, 0, TimeSpan.Zero), TransactionId = 1 }, new Transaction { Amount = 120.0M, CategoryId = Models.Enums.Category.Travel, IBAN = "dsafdsafafdas", TransactionDate = new DateTimeOffset(2020, 9, 10, 13, 0, 0, TimeSpan.Zero), TransactionId = 4 }, new Transaction { Amount = 40.0M, CategoryId = Models.Enums.Category.Food, IBAN = "dsafdsafafdas", TransactionDate = new DateTimeOffset(2020, 9, 10, 13, 0, 0, TimeSpan.Zero), TransactionId = 2 }, new Transaction { Amount = 160.0M, CategoryId = Models.Enums.Category.Food, IBAN = "dsafdsafafdas", TransactionDate = new DateTimeOffset(2020, 9, 10, 13, 0, 0, TimeSpan.Zero), TransactionId = 5 } }, Currency = Models.Enums.Currency.RON }); context.Accounts.Add(new Account { ResourceId = new Guid("e2287c78-0454-402a-86bd-b9e6f5cb73be"), Product = new Product { Id = new Guid(), Name = "some product" }, IBAN = "32141sadf", Name = "Jon", Transactions = new List <Transaction>() { new Transaction { Amount = 20.0M, CategoryId = Models.Enums.Category.MedicalExpenses, IBAN = "dsafdsafafdas", TransactionDate = new DateTimeOffset(2020, 10, 10, 13, 0, 0, TimeSpan.Zero), TransactionId = 15 }, new Transaction { Amount = 120.0M, CategoryId = Models.Enums.Category.MedicalExpenses, IBAN = "dsafdsafafdas", TransactionDate = new DateTimeOffset(2020, 9, 10, 13, 0, 0, TimeSpan.Zero), TransactionId = 42 }, new Transaction { Amount = 40.0M, CategoryId = Models.Enums.Category.Food, IBAN = "dsafdsafafdas", TransactionDate = new DateTimeOffset(2020, 9, 10, 13, 0, 0, TimeSpan.Zero), TransactionId = 45 }, new Transaction { Amount = 55.0M, CategoryId = Models.Enums.Category.Entertainment, IBAN = "dsafdsafafdas", TransactionDate = new DateTimeOffset(2020, 9, 10, 13, 0, 0, TimeSpan.Zero), TransactionId = 46 } }, Currency = Models.Enums.Currency.EUR }); context.Accounts.Add(new Account { ResourceId = new Guid("e2417c78-4254-402a-86bd-b9d1f5cb73be"), Product = new Product { Id = new Guid(), Name = "some product" }, IBAN = "32141sadf", Name = "Joffen", Transactions = new List <Transaction>() { new Transaction { Amount = 220.0M, CategoryId = Models.Enums.Category.Clothing, IBAN = "dsafdsafafdas", TransactionDate = new DateTimeOffset(2020, 9, 10, 13, 0, 0, TimeSpan.Zero), TransactionId = 113 }, new Transaction { Amount = 420.0M, CategoryId = Models.Enums.Category.Clothing, IBAN = "dsafdsafafdas", TransactionDate = new DateTimeOffset(2020, 9, 10, 13, 0, 0, TimeSpan.Zero), TransactionId = 415 }, new Transaction { Amount = 20.0M, CategoryId = Models.Enums.Category.Food, IBAN = "dsafdsafafdas", TransactionDate = new DateTimeOffset(2020, 9, 10, 13, 0, 0, TimeSpan.Zero), TransactionId = 462 } }, Currency = Models.Enums.Currency.GBP }); context.SaveChanges(); } var repo = new AccountRepository(new SqlDBContext(options)); var result = await repo.GetMonthlyReportForAccount(id); var travel = result.Where(x => x.CategoryName == ChallengeING.Models.Enums.Category.Travel.ToString()).Select(y => y.TotalAmount); var food = result.Where(x => x.CategoryName == ChallengeING.Models.Enums.Category.Travel.ToString()).Select(y => y.TotalAmount); Assert.AreEqual(160.0M, travel.FirstOrDefault()); Assert.AreEqual(200.0M, food.FirstOrDefault()); }
public int Save() { return(_dbContext.SaveChanges()); }