public void CreateTransaction() { var userRepo = new UserRepository(); var accountRepo = new AccountRepository(); var transactionRepo = new TransactionRepository(); var user = TestEntityMaker.GetUser(); var account = TestEntityMaker.GetAccount(); userRepo.Add(user); accountRepo.Add(account); var transaction = new Business.Entities.Transaction(); transaction.TransactionDate = DateTime.Now; transaction.Payee = "The Man"; transaction.AccountId = account.Id; transactionRepo.Add(transaction); using (var context = new MacroMoneyContext()) { var result = context.Account .Include(i => i.Transactions) .Where(e => e.Id == account.Id); Assert.IsTrue(result.Any()); } }
public User GetAccountInfoById(Guid id) { var users = new User(); using (var entityContext = new MacroMoneyContext()) { users = entityContext.Users .FirstOrDefault(a => a.Id == id); } return(users); }
//public Account GetAccountInfoByUserId(Guid id) //{ // var account = new Account(); // using (var entityContext = new MacroMoneyContext()) // { // account = entityContext.Account // .FirstOrDefault(a => a.Id == id); // } // return account; //} public List <Account> GetAccountsByUserId(Guid userId) { var accounts = new List <Account>(); using (var entityContext = new MacroMoneyContext()) { accounts = entityContext.Account .Include(e => e.Transactions) .Include(e => e.Transactions.Select(td => td.TransactionDetails)) .Where(a => a.UserId == userId).ToList(); } return(accounts); }
public void CreateUser() { var newUser = new User { Id = Guid.NewGuid(), UserName = "******" }; using (var context = new MacroMoneyContext()) { context.Users.Add(newUser); context.SaveChanges(); } }
public void GetData() { using (var context = new MacroMoneyContext()) { //var result = context.Users // .Include() // .Where(e => e.Id == new Guid("96CEAB57-71ED-466E-A502-93A24C4D184E")).FirstOrDefault(); var query1 = (from u in context.Users .Include(e => e.Accounts) .Include(e => e.Accounts.Select(t => t.Transactions)) .Include(e => e.Accounts.Select(t => t.Transactions.Select(td => td.TransactionDetails))) .Include(e => e.Accounts.Select(t => t.Transactions.Select(td => td.TransactionDetails.Select(cat => cat.Category)))) where u.Id == new Guid("96CEAB57-71ED-466E-A502-93A24C4D184E") select u).FirstOrDefault(); Assert.IsTrue(true); //var query = (from u in context.Users // where u.Id == new Guid("96CEAB57-71ED-466E-A502-93A24C4D184E") // select new User() // { // Id = u.Id, // UserName = u.UserName, // Accounts = (from a in context.Account // where a.UserId == u.Id // select new Account() // { // Transactions = (from t in context.Transactions // where t.AccountId == a.Id // select new Transactions() // { // TransactionDetails = context.TransactionDetails // }) // }) //} //).FirstOrDefault(); //select new User() //{ // Accounts = a, //} } }
protected override TransactionDetail GetEntity(MacroMoneyContext entityContext, Guid id) { var entity = entityContext.TransactionDetail.FirstOrDefault(e => e.Id == id); return(entity); }
protected override IEnumerable <TransactionDetail> GetEntities(MacroMoneyContext entityContext) { var entities = entityContext.TransactionDetail; return(entities); }
protected override TransactionDetail UpdateEntity(MacroMoneyContext entityContext, TransactionDetail entity) { entity = entityContext.TransactionDetail.FirstOrDefault(e => e.Id == entity.Id); return(entity); }
protected override TransactionDetail AddEntity(MacroMoneyContext entityContext, TransactionDetail entity) { entity.Id = Guid.NewGuid(); entityContext.TransactionDetail.Add(entity); return(entity); }
protected override IEnumerable <Category> GetEntities(MacroMoneyContext entityContext) { var entities = entityContext.Category; return(entities); }
protected override Account UpdateEntity(MacroMoneyContext entityContext, Account entity) { entity = entityContext.Account.FirstOrDefault(e => e.Id == entity.Id); return(entity); }
protected override Account AddEntity(MacroMoneyContext entityContext, Account entity) { entity.Id = Guid.NewGuid(); entityContext.Account.Add(entity); return(entity); }
protected override IEnumerable <User> GetEntities(MacroMoneyContext entityContext) { var entities = entityContext.Users; return(entities); }
protected override User UpdateEntity(MacroMoneyContext entityContext, User entity) { entity = entityContext.Users.FirstOrDefault(e => e.Id == entity.Id); return(entity); }
protected override User AddEntity(MacroMoneyContext entityContext, User entity) { entity.Id = Guid.NewGuid(); entityContext.Users.Add(entity); return(entity); }
protected override Category AddEntity(MacroMoneyContext entityContext, Category entity) { entity.Id = Guid.NewGuid(); entityContext.Category.Add(entity); return(entity); }
protected override Category UpdateEntity(MacroMoneyContext entityContext, Category entity) { entity = entityContext.Category.FirstOrDefault(e => e.Id == entity.Id); return(entity); }
protected override IEnumerable <Account> GetEntities(MacroMoneyContext entityContext) { var entities = entityContext.Account; return(entities); }
protected override Category GetEntity(MacroMoneyContext entityContext, Guid id) { var entity = entityContext.Category.FirstOrDefault(e => e.Id == id); return(entity); }
protected override Account GetEntity(MacroMoneyContext entityContext, Guid id) { var entity = entityContext.Account.FirstOrDefault(e => e.Id == id); return(entity); }