private static void InitialiseAccountsMster(QuickLoanDbContext context)
{
var accountEntries = new Accounts[]
{
new Accounts
{
AccountNumber = "5000",
},
new Accounts
{
AccountNumber = "6000"
},
new Accounts
{
AccountNumber = "7000"
},
new Accounts
{
AccountNumber = "8000"
}
};
foreach (Accounts accountEntry in accountEntries)
{
context.Accounts.Add(accountEntry);
}
context.SaveChanges();
}
private static void IntialiseBanker(QuickLoanDbContext context)
{
var bankOfficers = new BankOfficer[]
{
new BankOfficer {
FirstName = "ERIC",
LastName = "JHON",
Branch = new Branch
{
BranchCode = "BR0002",
Name = "Branch 2"
},
OnlineUser = new User {
UserId = "eric",
Password = "******",
UserType = 1
}
}
};
foreach (BankOfficer bo in bankOfficers)
{
context.BankerOfficers.Add(bo);
}
context.SaveChanges();
}
private static void InitialiseLoansMster(QuickLoanDbContext context)
{
var loanDetailsEntries = new Loans[]
{
new Loans()
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "5000").ToList <Accounts>()[0].Id,
LoanNumber = 0,
Balance = 10000,
EmiDue = 400,
EmiDueDate = DateTime.Now.AddDays(3).ToString("MM/dd/yyyy"),
Description = "Description"
},
new Loans()
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "6000").ToList <Accounts>()[0].Id,
LoanNumber = 1,
Balance = 20000,
EmiDue = 100,
EmiDueDate = DateTime.Now.AddDays(4).ToString("MM/dd/yyyy"),
Description = "Description"
},
new Loans()
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "6000").ToList <Accounts>()[0].Id,
LoanNumber = 3,
Balance = 20000,
EmiDue = 200,
EmiDueDate = DateTime.Now.AddDays(1).ToString("MM/dd/yyyy"),
Description = "Description"
},
new Loans()
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "7000").ToList <Accounts>()[0].Id,
LoanNumber = 3,
Balance = 60000,
EmiDue = 300,
EmiDueDate = DateTime.Now.AddDays(2).ToString("MM/dd/yyyy"),
Description = "Description"
},
new Loans()
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "8000").ToList <Accounts>()[0].Id,
LoanNumber = 3,
Balance = 70000,
EmiDue = 700,
EmiDueDate = DateTime.Now.AddDays(2).ToString("MM/dd/yyyy"),
Description = "Description"
}
};
foreach (Loans loanDetailsEntry in loanDetailsEntries)
{
context.Loans.Add(loanDetailsEntry);
}
context.SaveChanges();
}
private static void InitialiseShareMster(QuickLoanDbContext context)
{
var shareDetailsEntries = new Shares[]
{
new Shares()
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "5000").ToList <Accounts>()[0].Id,
ShareNumber = 0,
Balance = 10000,
Description = "Description"
},
new Shares()
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "6000").ToList <Accounts>()[0].Id,
ShareNumber = 1,
Balance = 20000,
Description = "Description"
},
new Shares()
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "6000").ToList <Accounts>()[0].Id,
ShareNumber = 3,
Balance = 30000,
Description = "Description"
},
new Shares()
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "7000").ToList <Accounts>()[0].Id,
ShareNumber = 3,
Balance = 40000,
Description = "Description"
},
new Shares()
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "8000").ToList <Accounts>()[0].Id,
ShareNumber = 3,
Balance = 50000,
Description = "Description"
}
};
foreach (Shares shareDetailsEntry in shareDetailsEntries)
{
context.Shares.Add(shareDetailsEntry);
}
context.SaveChanges();
}
public static void Initialize(QuickLoanDbContext context)
{
context.Database.EnsureCreated();
//InitialiseLoanOptions(context);
// Look for any users.
if (context.Users.Any())
{
return; // DB has been seeded
}
InitialiseAccount(context);
IntialiseBanker(context);
InitialiseLoanOptions(context);
}
private static void InitialiseAccount(QuickLoanDbContext context)
{
var accounts = new Account[]
{
new Account {
FirstName = "BRENNA ANNA C",
LastName = "MURPHY",
Number = "8976890760",
Addresses = new List <Address> {
new Address {
AddressType = "PERM",
StreetAddress = "",
City = "",
State = "",
Country = "",
ZipCode = ""
},
new Address {
AddressType = "RESI",
StreetAddress = "",
City = "",
State = "",
Country = "",
ZipCode = ""
}
},
Branch = new Branch
{
BranchCode = "BR0001",
Name = "Branch 1"
},
OnlineUser = new User {
UserId = "amurphy",
Password = "******",
UserType = 3
}
}
};
foreach (Account account in accounts)
{
context.Accounts.Add(account);
}
context.SaveChanges();
}
private static void InitialiseCards(QuickLoanDbContext context)
{
var cards = new Cards[]
{
new Cards()
{
CardNumber = "7890",
AccountsId = 1,
Type = "CREDIT",
PaymentDueDate = "04/09/2018",
PaymentDue = 100
},
new Cards()
{
CardNumber = "8942",
AccountsId = 2,
Type = "CREDIT",
PaymentDueDate = "03/03/2018",
PaymentDue = 200
},
new Cards()
{
CardNumber = "8945",
AccountsId = 3,
Type = "CREDIT",
PaymentDueDate = "06/06/2018",
PaymentDue = 90
},
new Cards()
{
CardNumber = "7842",
AccountsId = 4,
Type = "CREDIT",
PaymentDueDate = "05/03/2019",
PaymentDue = 50
}
};
foreach (Cards card in cards)
{
context.Cards.Add(card);
}
context.SaveChanges();
}
private static void InitialiseBankNames(QuickLoanDbContext context)
{
var BankNames = new BankNames[]
{
new BankNames
{
BankId = 10,
NationalIdentifier = "ABC",
BankName = "OBC1"
},
new BankNames
{
BankId = 10,
NationalIdentifier = "ABC",
BankName = "OBC1"
}
};
}
private static void InitialiseMembersMster(QuickLoanDbContext context)
{
var memberEntries = new Members[]
{
new Members
{
MemberName = "Member1",
LoanEligibility = 3000,
LastLogin = "******",
IsEditable = false,
InUse = true
},
new Members
{
MemberName = "Member2",
LoanEligibility = 4000,
LastLogin = "******",
IsEditable = false,
InUse = true
},
new Members
{
MemberName = "Member3",
LoanEligibility = 1000,
LastLogin = "******",
IsEditable = true,
InUse = false
},
new Members
{
MemberName = "Member4",
LoanEligibility = 2000,
LastLogin = "******",
IsEditable = true,
InUse = false
}
};
foreach (Members memberEntry in memberEntries)
{
context.Members.Add(memberEntry);
}
context.SaveChanges();
}
public static void Initialize(QuickLoanDbContext context)
{
context.Database.EnsureCreated();
if (context.Accounts.Any())
{
return; // DB has been seeded
}
InitialiseAccountTypeMster(context);
InitialiseAccountsMster(context);
InitialiseMembersMster(context);
InitialiseAccountMemberDetailsMster(context);
InitialiseLoansMster(context);
InitialiseShareMster(context);
InitialiseTransaction(context);
InitialiseCards(context);
InitialiseBankNames(context);
}
private static void InitialiseAccountMemberDetailsMster(QuickLoanDbContext context)
{
var accountDetailsEntries = new AccountDetails[]
{
new AccountDetails
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "5000").ToList <Accounts>()[0].Id,
MembersId = context.Members.Select(item => item).Where(item => item.MemberName == "Member1").ToList <Members>()[0].Id,
AccountTypesId = context.AccountTypes.Select(item => item).Where(item => item.Type == "Primary").ToList <AccountTypes>()[0].Id,
},
new AccountDetails
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "6000").ToList <Accounts>()[0].Id,
MembersId = context.Members.Select(item => item).Where(item => item.MemberName == "Member2").ToList <Members>()[0].Id,
AccountTypesId = context.AccountTypes.Select(item => item).Where(item => item.Type == "Primary").ToList <AccountTypes>()[0].Id,
},
new AccountDetails
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "6000").ToList <Accounts>()[0].Id,
MembersId = context.Members.Select(item => item).Where(item => item.MemberName == "Member1").ToList <Members>()[0].Id,
AccountTypesId = context.AccountTypes.Select(item => item).Where(item => item.Type == "Joint").ToList <AccountTypes>()[0].Id,
},
new AccountDetails
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "7000").ToList <Accounts>()[0].Id,
MembersId = context.Members.Select(item => item).Where(item => item.MemberName == "Member3").ToList <Members>()[0].Id,
AccountTypesId = context.AccountTypes.Select(item => item).Where(item => item.Type == "Primary").ToList <AccountTypes>()[0].Id,
},
new AccountDetails
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "8000").ToList <Accounts>()[0].Id,
MembersId = context.Members.Select(item => item).Where(item => item.MemberName == "Member4").ToList <Members>()[0].Id,
AccountTypesId = context.AccountTypes.Select(item => item).Where(item => item.Type == "Primary").ToList <AccountTypes>()[0].Id,
}
};
foreach (AccountDetails accountDetailsEntry in accountDetailsEntries)
{
context.AccountDetails.Add(accountDetailsEntry);
}
context.SaveChanges();
}
private static void InitialiseAccountTypeMster(QuickLoanDbContext context)
{
var accountTypeEntries = new AccountTypes[]
{
new AccountTypes
{
//Id=1,
Type = "Primary"
},
new AccountTypes
{
//Id=2,
Type = "Joint"
}
};
foreach (AccountTypes accountTypeEntry in accountTypeEntries)
{
context.AccountTypes.Add(accountTypeEntry);
}
context.SaveChanges();
}
private static void InitialiseLoanOptions(QuickLoanDbContext context)
{
var loanOptions = new List <LoanOptions> {
new LoanOptions {
Tenure = "5 Years",
LoanAmount = 100000.00m,
EMIAmount = 1887.22m,
InterestRate = "5.00",
LoanSchedule = new List <LoanSchedule>()
{
new LoanSchedule {
TenureYear = "2018",
PrincipalPaid = 8915.12m,
InterestPaid = 2407.60m,
Balance = 91084.88m
},
new LoanSchedule {
TenureYear = "2019",
PrincipalPaid = 18511.59m,
InterestPaid = 4133.85m,
Balance = 72573.29m
},
new LoanSchedule {
TenureYear = "2020",
PrincipalPaid = 19458.66m,
InterestPaid = 3186.78m,
Balance = 53114.63m
},
new LoanSchedule {
TenureYear = "2021",
PrincipalPaid = 20454.23m,
InterestPaid = 2191.21m,
Balance = 32660.40m
},
new LoanSchedule {
TenureYear = "2022",
PrincipalPaid = 21500.69m,
InterestPaid = 1144.75m,
Balance = 11159.71m
},
new LoanSchedule {
TenureYear = "2023",
PrincipalPaid = 11159.71m,
InterestPaid = 163.32m,
Balance = 0
}
}
},
new LoanOptions {
Tenure = "10 Years",
LoanAmount = 100000.00m,
EMIAmount = 1000.60m,
InterestRate = "5.00",
LoanSchedule = new List <LoanSchedule>()
{
new LoanSchedule {
TenureYear = "2018",
PrincipalPaid = 3904.43m,
InterestPaid = 2459.53m,
Balance = 96095.57m
},
new LoanSchedule {
TenureYear = "2019",
PrincipalPaid = 8107.25m,
InterestPaid = 4620.67m,
Balance = 87988.32m
},
new LoanSchedule {
TenureYear = "2020",
PrincipalPaid = 8522.03m,
InterestPaid = 4205.89m,
Balance = 79466.29m
},
new LoanSchedule {
TenureYear = "2021",
PrincipalPaid = 8958.05m,
InterestPaid = 3769.87m,
Balance = 70508.24m
},
new LoanSchedule {
TenureYear = "2022",
PrincipalPaid = 9416.36m,
InterestPaid = 3311.56m,
Balance = 61091.88m
},
new LoanSchedule {
TenureYear = "2023",
PrincipalPaid = 9898.12m,
InterestPaid = 2829.80m,
Balance = 51193.76m
},
new LoanSchedule {
TenureYear = "2024",
PrincipalPaid = 10404.51m,
InterestPaid = 2323.41m,
Balance = 40789.25m
},
new LoanSchedule {
TenureYear = "2025",
PrincipalPaid = 10936.84m,
InterestPaid = 1791.08m,
Balance = 29852.41m
},
new LoanSchedule {
TenureYear = "2026",
PrincipalPaid = 11496.39m,
InterestPaid = 1231.53m,
Balance = 18356.02m
},
new LoanSchedule {
TenureYear = "2027",
PrincipalPaid = 12084.56m,
InterestPaid = 643.36m,
Balance = 6271.46m
},
new LoanSchedule {
TenureYear = "2028",
PrincipalPaid = 6271.46m,
InterestPaid = 91.77m,
Balance = 0
}
}
},
new LoanOptions {
Tenure = "15 Years",
LoanAmount = 100000.00m,
EMIAmount = 600.45m,
InterestRate = "5.00",
LoanSchedule = new List <LoanSchedule>()
{
new LoanSchedule {
TenureYear = "2018",
PrincipalPaid = 2268.25m,
InterestPaid = 2476.49m,
Balance = 97731.75m
},
new LoanSchedule {
TenureYear = "2019",
PrincipalPaid = 4709.85m,
InterestPaid = 4779.63m,
Balance = 93021.90m
},
new LoanSchedule {
TenureYear = "2020",
PrincipalPaid = 4950.83m,
InterestPaid = 4538.65m,
Balance = 88071.07m
},
new LoanSchedule {
TenureYear = "2021",
PrincipalPaid = 5204.11m,
InterestPaid = 4285.37m,
Balance = 82866.96m
},
new LoanSchedule {
TenureYear = "2022",
PrincipalPaid = 5470.37m,
InterestPaid = 4019.11m,
Balance = 77396.59m
},
new LoanSchedule {
TenureYear = "2023",
PrincipalPaid = 5750.22m,
InterestPaid = 3739.26m,
Balance = 71646.37m
},
new LoanSchedule {
TenureYear = "2024",
PrincipalPaid = 6044.40m,
InterestPaid = 3445.08m,
Balance = 65601.97m
},
new LoanSchedule {
TenureYear = "2025",
PrincipalPaid = 6353.68m,
InterestPaid = 3135.80m,
Balance = 59248.29m
},
new LoanSchedule {
TenureYear = "2026",
PrincipalPaid = 6678.74m,
InterestPaid = 2810.74m,
Balance = 52569.55m
},
new LoanSchedule {
TenureYear = "2027",
PrincipalPaid = 7020.43m,
InterestPaid = 2469.05m,
Balance = 45549.12m
},
new LoanSchedule {
TenureYear = "2028",
PrincipalPaid = 7379.62m,
InterestPaid = 2109.86m,
Balance = 38169.50m
},
new LoanSchedule {
TenureYear = "2029",
PrincipalPaid = 7757.18m,
InterestPaid = 1732.30m,
Balance = 30412.32m
},
new LoanSchedule {
TenureYear = "2030",
PrincipalPaid = 8154.04m,
InterestPaid = 1335.44m,
Balance = 22258.28m
},
new LoanSchedule {
TenureYear = "2031",
PrincipalPaid = 8571.22m,
InterestPaid = 918.26m,
Balance = 13687.06m
},
new LoanSchedule {
TenureYear = "2032",
PrincipalPaid = 9009.75m,
InterestPaid = 479.73m,
Balance = 4677.31m
},
new LoanSchedule {
TenureYear = "2033",
PrincipalPaid = 4677.31m,
InterestPaid = 68.47m,
Balance = 0.00m
}
}
}
};
foreach (LoanOptions lo in loanOptions)
{
context.LoanOptions.Add(lo);
}
context.SaveChanges();
}
public LoanManager(QuickLoanDbContext quickLoanDbContext, IConfiguration configuration)
{
_quickLoanDbContext = quickLoanDbContext;
_configuration = configuration;
}
public AuthManager(QuickLoanDbContext context)
{
_context = context;
}
public ResetCreditCardManager(QuickLoanDbContext context)
{
_context = context;
}
public PaymentManager(QuickLoanDbContext context)
{
_context = context;
}
private static void InitialiseTransaction(QuickLoanDbContext context)
{
var transactions = new Transactions[]
{
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "5000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 0,
Postdate = "01/09/2018",
Amount = 300
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "5000").ToList <Accounts>()[0].Id,
Description = "Loan advance",
Type = "LOAN",
RecordId = 0,
Postdate = "02/08/2018",
Amount = 700
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "5000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 0,
Postdate = "03/09/2018",
Amount = 300
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "5000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 0,
Postdate = "04/09/2018",
Amount = 200
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "5000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 0,
Postdate = "05/09/2018",
Amount = 700
},
//-----------------------------------
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "6000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 1,
Postdate = "01/09/2018",
Amount = 300
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "6000").ToList <Accounts>()[0].Id,
Description = "Loan advance",
Type = "LOAN",
RecordId = 1,
Postdate = "02/08/2018",
Amount = 700
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "6000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 3,
Postdate = "03/09/2018",
Amount = 300
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "6000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 1,
Postdate = "04/09/2018",
Amount = 200
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "6000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 3,
Postdate = "05/09/2018",
Amount = 700
},
//-----------------------------------
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "7000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 3,
Postdate = "02/09/2018",
Amount = 300
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "7000").ToList <Accounts>()[0].Id,
Description = "Loan advance",
Type = "LOAN",
RecordId = 3,
Postdate = "02/18/2018",
Amount = 700
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "7000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 3,
Postdate = "03/20/2018",
Amount = 300
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "7000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 3,
Postdate = "04/09/2018",
Amount = 200
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "7000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 3,
Postdate = "06/09/2018",
Amount = 700
},
//-----------------------------------
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "8000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 3,
Postdate = "02/09/2018",
Amount = 500
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "8000").ToList <Accounts>()[0].Id,
Description = "Loan advance",
Type = "LOAN",
RecordId = 3,
Postdate = "02/18/2018",
Amount = 900
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "8000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 3,
Postdate = "03/20/2018",
Amount = 390
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "8000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 3,
Postdate = "04/09/2018",
Amount = 200
},
new Transactions
{
AccountsId = context.Accounts.Select(item => item).Where(item => item.AccountNumber == "8000").ToList <Accounts>()[0].Id,
Description = "cash deposit",
Type = "Share",
RecordId = 3,
Postdate = "06/09/2018",
Amount = 700
},
};
foreach (Transactions transaction in transactions)
{
context.Transactions.Add(transaction);
}
context.SaveChanges();
}
public AccountManager(QuickLoanDbContext context)
{
_context = context;
}