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