static void Main(string[] args) { RadBankContext bc = new RadBankContext(); Console.WriteLine("Hello"); get_transcations(bc); }
private void SeedAccounts(RadBankContext context) { context.Accounts.AddOrUpdate(account => account.AccountID, new Models.Account[] { new Models.Account { AccountID = 1, AccountName = "Current 1", InceptionDate = DateTime.Parse("12/01/2002"), CustomerID = 1, CurrentBalance = 30000.00, AccountTypeID = 1 }, new Models.Account { AccountID = 2, AccountName = "Current 2", InceptionDate = DateTime.Parse("31/10/2004"), CustomerID = 1, CurrentBalance = 200000.00, AccountTypeID = 1 }, new Models.Account { AccountID = 3, AccountName = "Deposit 1", InceptionDate = DateTime.Parse("10/10/2014"), CustomerID = 2, CurrentBalance = 10000.00, AccountTypeID = 3 }, new Models.Account { AccountID = 4, AccountName = "Deposit 1", InceptionDate = DateTime.Parse("03/05/2011"), CustomerID = 3, CurrentBalance = 50000.00, AccountTypeID = 3 }, new Models.Account { AccountID = 5, AccountName = "Savings 1", InceptionDate = DateTime.Parse("02/02/2010"), CustomerID = 2, CurrentBalance = 3000.00, AccountTypeID = 2 }, new Models.Account { AccountID = 6, AccountName = "Current 1", InceptionDate = DateTime.Parse("29/09/2004"), CustomerID = 3, CurrentBalance = 10000.00, AccountTypeID = 1 }, }); }
public static void get_transcations(RadBankContext bc) { var getTranscations = from t in bc.Transcations join a in bc.Accounts on t.AccountID equals a.AccountID select new { t.TransactionID }; foreach (var item in getTranscations) { Console.WriteLine(item.ToString()); } }
private void SeedAccountType(RadBankContext context) { context.AccountTypes.AddOrUpdate(accountType => accountType.AccountTypeID, new Models.AccountType[] { new Models.AccountType { AccountTypeID = 1, TypeName = "Current", Conditons = "Current Account Terms and conditions apply" }, new Models.AccountType { AccountTypeID = 2, TypeName = "Savings", Conditons = "Saving Account Terms and conditions apply" }, new Models.AccountType { AccountTypeID = 3, TypeName = "Deposit", Conditons = "Deposit Account Terms and conditions apply" } }); }
private void SeedCustomer(RadBankContext context) { context.Customers.AddOrUpdate(customer => customer.Name, new Models.Customer[] { new Models.Customer { CustomerID = 1, Name = "Customer 1", Address = "Address for Customer 1" }, new Models.Customer { CustomerID = 2, Name = "Customer 2", Address = "Address for Customer 2" }, new Models.Customer { CustomerID = 3, Name = "Customer 3", Address = "Address for Customer 3" }, }); }
private void SeedCustomers(UserManager <ApplicationUser> manager, ApplicationDbContext context, PasswordHasher ps) { using (RadBankContext db = new RadBankContext()) { foreach (var c in db.Customers) { context.Users.AddOrUpdate(u => u.UserName, new ApplicationUser { UserName = c.Name, Email = c.Name + "@mail.ie", SecurityStamp = Guid.NewGuid().ToString(), PasswordHash = ps.HashPassword("Harry$1") }); { ApplicationUser customer = manager.FindByEmail(c.Name + "@mail.ie"); if (customer != null) { manager.AddToRole(customer.Id, "Customer"); } } } } }
private void SeedTransactions(RadBankContext context) { context.Transcations.AddOrUpdate(transaction => transaction.TransactionID, new Models.Transcations[] { new Models.Transcations { TransactionID = 1, TransactionType = (transactionType)0, Amount = 300.00, transactionDate = DateTime.Parse("18/01/2002"), AccountID = 1 }, new Models.Transcations { TransactionID = 2, TransactionType = (transactionType)1, Amount = 500.00, transactionDate = DateTime.Parse("14/01/2002"), AccountID = 1 }, new Models.Transcations { TransactionID = 3, TransactionType = (transactionType)1, Amount = 300.00, transactionDate = DateTime.Parse("05/11/2004"), AccountID = 2 }, new Models.Transcations { TransactionID = 4, TransactionType = (transactionType)0, Amount = 200.00, transactionDate = DateTime.Parse("05/11/2004"), AccountID = 3 }, new Models.Transcations { TransactionID = 5, TransactionType = (transactionType)0, Amount = 1000.00, transactionDate = DateTime.Parse("25/10/2014"), AccountID = 4 }, new Models.Transcations { TransactionID = 6, TransactionType = (transactionType)1, Amount = 1000.00, transactionDate = DateTime.Parse("14/02/2010"), AccountID = 5 }, new Models.Transcations { TransactionID = 7, TransactionType = (transactionType)1, Amount = 1000.00, transactionDate = DateTime.Parse("04/10/2004"), AccountID = 6 }, }); }