public async static Task <int> GetNextIdAsync(IronChurchContext dbContext, string table_name)
{
var tableNextIDObject = await dbContext.SeqControl.Where(x => x.ObjName == table_name).FirstOrDefaultAsync();
tableNextIDObject.NextId += 1;
dbContext.Entry(tableNextIDObject).Property(x => x.NextId).IsModified = true;
await dbContext.SaveChangesAsync();
return(tableNextIDObject.NextId);
}
public async Task Get()
{
var options = this.CreateInMemoryDatabase("Get_Account_Database");
using (var _context = new IronChurchContext(options))
{
AccountsController accountController = new AccountsController(_context);
var result = await accountController.Get();
Assert.IsTrue(result.Count == 1);
}
}
public static int GetNextId(IronChurchContext dbContext, string table_name)
{
var nextId = dbContext.SeqControl.Where(x => x.ObjName == table_name).FirstOrDefault().NextId + 1;
var newSeqcontrol = new SeqControl()
{
ObjName = "table_name", NextId = nextId
};
dbContext.Entry(newSeqcontrol).Property(x => x.NextId).IsModified = true;
dbContext.SaveChangesAsync();
return(nextId);
}
public async Task GetAccountByIdTest()
{
var options = this.CreateInMemoryDatabase("Get_Account_By_Id_database");
using (var _context = new IronChurchContext(options))
{
AccountsController accountController = new AccountsController(_context);
var result = await accountController.GetAccount(21);
Assert.IsTrue(result.Value.AccountName == "Bank 1");
}
}
public async Task GetByIdTest()
{
var options = this.CreateInMemoryDatabase("Get_By_Id_database");
using (var _context = new IronChurchContext(options))
{
MemberController contController = new MemberController(_context);
var result = await contController.Get(122);
Assert.IsTrue(result.Value.FirstName.Equals("Sarah"));
}
}
public async Task Get()
{
var options = this.CreateInMemoryDatabase("Get_Contributor_Database");
using (var _context = new IronChurchContext(options))
{
MemberController contController = new MemberController(_context);
var result = await contController.Get();
Assert.IsTrue(result.Count == 2);
}
}
protected DbContextOptions <IronChurchContext> CreateInMemoryDatabase(string databaseName)
{
var options = new DbContextOptionsBuilder <IronChurchContext>()
.UseInMemoryDatabase(databaseName: databaseName)
.Options;
var _context = new IronChurchContext(options);
/*
* Mock Contributor Data
*/
_context.Contributor.Add(new Contributor {
ContributorId = 124, FirstName = "Samuel", LastName = "Henry", FamilyName = "Mathe"
});
_context.Contributor.Add(new Contributor {
ContributorId = 122, FirstName = "Sarah", LastName = "Solomon", FamilyName = "Mathe"
});
/*
* Mock Seq Control Data
*/
_context.SeqControl.Add(new SeqControl {
ObjName = "contributor", NextId = 150
});
_context.SeqControl.Add(new SeqControl {
ObjName = "account", NextId = 30
});
_context.SeqControl.Add(new SeqControl {
ObjName = "organization", NextId = 30
});
/*
* Mock Account Data
*/
_context.Account.Add(new Account {
AccountId = 21, AccountName = "Bank 1", AccountNumber = "1234", BankName = "BOFA", InitialBalance = 4444m
});
/*
* Mock Organizations Data
*/
_context.Organization.Add(new Organization {
OrganizationId = 1, Name = "Sam Test"
});
_context.SaveChanges();
return(options);
}
public async Task AddMemberTest()
{
var options = this.CreateInMemoryDatabase("Add_Member_database");
using (var _context = new IronChurchContext(options))
{
MemberController contController = new MemberController(_context);
var testContributor = new Contributor {
FirstName = "John", LastName = "Kenny", FamilyName = "Mathe", DateAdded = DateTime.Now, Status = 1
};
var result = await contController.PostContributor(testContributor);
var currentCount = contController.Get().Result.Count;
// Assert
Assert.IsTrue(currentCount == 3);
}
}
public async Task UpdateMemberTest()
{
var options = this.CreateInMemoryDatabase("Update_Member_database");
using (var _context = new IronChurchContext(options))
{
MemberController contController = new MemberController(_context);
var testContributor = new Contributor {
ContributorId = 124, FirstName = "Samarah", LastName = "Henry", FamilyName = "Mathe"
};
var result = await contController.PutContributor(124, testContributor);
var newResult = await contController.Get(124);
Assert.IsTrue(newResult.Value.FirstName.Equals(testContributor.FirstName));
}
}
public async Task AddAccountTest()
{
var options = this.CreateInMemoryDatabase("Add_Account_database");
using (var _context = new IronChurchContext(options))
{
AccountsController accountController = new AccountsController(_context);
var testAccount = new Account {
AccountName = "Bank 2", AccountNumber = "123444", BankName = "BOFA 2", InitialBalance = 22m, DateAdded = DateTime.UtcNow
};
var result = await accountController.PostAccount(testAccount);
var currentCount = accountController.Get().Result.Count;
// Assert
Assert.IsTrue(currentCount == 2);
}
}
public async Task UpdateAccountTest()
{
var options = this.CreateInMemoryDatabase("Update_Account_database");
using (var _context = new IronChurchContext(options))
{
AccountsController accountController = new AccountsController(_context);
var testAccount = new Account {
AccountId = 21, AccountName = "Bank 2", AccountNumber = "123444", BankName = "BOFA 2", InitialBalance = 22m, DateChanged = DateTime.UtcNow
};
var result = await accountController.PutAccount(21, testAccount);
var newResult = await accountController.GetAccount(21);
Assert.IsTrue(newResult.Value.AccountName.Equals(testAccount.AccountName));
}
}
public async Task AddOrganizationTest()
{
var options = this.CreateInMemoryDatabase("Add_Organizations_Database");
using (var _context = new IronChurchContext(options))
{
OrganizationsController orgController = new OrganizationsController(_context);
var ExpectedOrg = new Organization {
Name = "Sam Test 1"
};
var result = await orgController.PostOrganization(ExpectedOrg);
var ActualOrganization = orgController.GetOrganization().Result.Where(x => x.OrganizationId == 31).FirstOrDefault();
Assert.AreEqual(ExpectedOrg.Name, ActualOrganization.Name);
}
}
public async Task EndAccountTest()
{
var options = this.CreateInMemoryDatabase("End_Account_database");
using (var _context = new IronChurchContext(options))
{
AccountsController accountController = new AccountsController(_context);
var testAccount = new Account {
AccountId = 21, AccountEndDate = DateTime.UtcNow
};
var result = await accountController.EndAccount(21, testAccount);
var newResult = await accountController.GetAccount(21);
Assert.IsTrue(newResult.Value.AccountEndDate != null);
Assert.IsTrue(newResult.Value.AccountEndDate.Equals(testAccount.AccountEndDate));
}
}
private DbContextOptions <IronChurchContext> CreateInMemoryDatabase(string databaseName)
{
var options = new DbContextOptionsBuilder <IronChurchContext>()
.UseInMemoryDatabase(databaseName: databaseName)
.Options;
var _context = new IronChurchContext(options);
_context.Contributor.Add(new Contributor {
ContributorId = 124, FirstName = "Samuel", LastName = "Henry", FamilyName = "Mathe", Status = 1
});
_context.Contributor.Add(new Contributor {
ContributorId = 122, FirstName = "Sarah", LastName = "Solomon", FamilyName = "Mathe", Status = 1
});
_context.SeqControl.Add(new SeqControl {
ObjName = "contributor", NextId = 150
});
_context.SaveChanges();
return(options);
}
public IndustriesController(IronChurchContext context)
{
_context = context;
}
public UserOrganizationsController(IronChurchContext context)
{
_context = context;
}
public OrganizationCategoriesController(IronChurchContext context)
{
_context = context;
}
/// <summary>
/// Check if Member exists
/// </summary>
/// <param name="dbContext"></param>
/// <param name="memberId"></param>
/// <returns></returns>
public static bool MemberExists(IronChurchContext dbContext, int memberId)
{
return(dbContext.Contributor.Any(e => e.ContributorId == memberId));
}
public LoansController(IronChurchContext context)
{
_context = context;
}
/// <summary>
/// Check if Transactions exist for Member Id
/// </summary>
/// <param name="dbContext"></param>
/// <param name="MemberId"></param>
/// <returns></returns>
public static bool TransactionsExistForMemberId(IronChurchContext dbContext, int MemberId)
{
return(dbContext.Contribution.Any(e => e.ContributorId == MemberId));
}
public MemberController(IronChurchContext context)
{
_context = context;
}
public UsersController(IronChurchContext context)
{
_context = context;
}
public ColumnValueDescController(IronChurchContext context)
{
_context = context;
}
public TransactionsController(IronChurchContext context)
{
_context = context;
}
public AccountsController(IronChurchContext context)
{
_context = context;
}
