public ActionResult IsMatriculFiscalAvailable(String m) { try { using (var db = new BankDbContext()) { try { var mF = db.PersonnesMorales.Single(p => p.MatriculFiscal == m); return(Json(false, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(true, JsonRequestBehavior.AllowGet)); } } } catch (Exception) { return(RedirectToAction("Error")); } }
private void UserDepositsForm_Load(object sender, EventArgs e) { dbContext = new BankDbContext(); userDeposits = new List <UserDepositEntity>(); currentUserLabel.Text += " " + currentUser.ToString(); var bankAccounts = dbContext.BankAccounts .Include(ba => ba.UserDeposits) .ThenInclude(ud => ud.DepositType) .Where(ba => ba.UserId == currentUser.Id) .ToList(); if (bankAccounts == null) { errorLabel.Text = "Bank accounts is null."; return; } foreach (var account in bankAccounts) { foreach (var deposit in account.UserDeposits) { if (!deposit.IsPaid) { userDeposits.Add(deposit); } } } if (userDeposits.Count == 0) { errorLabel.Text = "You have no open deposits."; putMoneyButton.Enabled = false; moneyRetutnButton.Enabled = false; } userDepositsDataGridView.DataSource = userDeposits; }
public void Withdraw(long accountId, int amount, string comments = "Withdraw") {// use transactions using (var db = new BankDbContext()) { var account = db.Account.FirstOrDefault(x => x.Id == accountId); account.Balance -= amount; var transaction = new Transaction() { Balance = account.Balance, Withdraw = amount, TransactionType = "Cr", Comments = comments, AccountID = accountId, TransactionDTTM = DateTime.Now }; db.Entry(account).State = System.Data.Entity.EntityState.Modified; db.Transaction.Add(transaction); db.SaveChanges(); } }
public ActionResult IsCinAvailable(String cin) { try { using (var db = new BankDbContext()) { try { var cCin = db.PersonnesPhysiques.Single(p => p.Cin == cin); return(Json(false, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(true, JsonRequestBehavior.AllowGet)); } } } catch (Exception) { return(RedirectToAction("Error")); } }
public void Interest() { using (var context = new BankDbContext(options)) { int id = 8; decimal interest = 0.135m; DateTime now = DateTime.Now; DateTime latestInterest = now.AddDays(-365); decimal balance = 100m; decimal expected = 113.5m; var model = new InterestModel() { AccountId = id }; var account = new Account() { AccountId = id, Balance = balance }; context.Accounts.Add(account); context.SaveChanges(); new InterestCommand().RunAsync(context, model, latestInterest, interest).Wait(); int numOfTransactions = context.Transactions .Where(t => t.AccountId == account.AccountId || t.AccountId == account.AccountId) .Count(); var createdAccount1 = context.Accounts.Single(a => a.AccountId == id); // Check balance Assert.Equal(expected, createdAccount1.Balance); // Checks so that a transaction was made Assert.Equal(1, numOfTransactions); } }
public async static void SeedItems(this IApplicationBuilder app) { BankDbContext context = app.ApplicationServices.GetRequiredService <BankDbContext>(); context.Database.Migrate(); if (!await context.Credits.AnyAsync()) { context.Credits.AddRange( new Credit { Amount = 1120, EndDate = DateTime.Now.AddDays(100) }, new Credit { Amount = 1820, EndDate = DateTime.Now.AddDays(90) }, new Credit { Amount = 1920, EndDate = DateTime.Now.AddDays(70) } ); await context.SaveChangesAsync(); } if (!await context.People.AnyAsync()) { context.People.AddRange( new Person { Name = "Memmed", Email = "*****@*****.**", Surname = "Memmedov", passnum = "12995695", CreditId = 1 }, new Person { Name = "Memmed", Email = "*****@*****.**", Surname = "Memmedov", passnum = "12995695", CreditId = 2 }, new Person { Name = "Memmed", Email = "*****@*****.**", Surname = "Memmedov", passnum = "12995695", CreditId = 3 } ); await context.SaveChangesAsync(); } }
public void Update() { //Arrange var accountLoan = new AccountLoan() { Id = 1 }; var iRepositoryAccountLoan = new MockIRepository <AccountLoan>() .MockUpdate(accountLoan); var accountLoanRepository = new MockAccountLoanRepository(); var bankDbContext = new BankDbContext(); var iRepositoryAccount = new MockIRepository <Account>(); var accountLoanService = new AccountLoanService( iRepositoryAccountLoan.Object, accountLoanRepository.Object, bankDbContext, iRepositoryAccount.Object, null); //Act var updatedLoan = accountLoanService.Update(accountLoan); //Assert Assert.IsNotNull(updatedLoan); }
public void RequestedLoanDetails() { //Arrange var loan = new AccountLoan() { Id = 1 }; var iRepositoryAccountLoan = new MockIRepository <AccountLoan>(); var accountLoanRepository = new MockAccountLoanRepository() .MockRequestedLoanDetails(loan); var bankDbContext = new BankDbContext(); var iRepositoryAccount = new MockIRepository <Account>(); var accountLoanService = new AccountLoanService( iRepositoryAccountLoan.Object, accountLoanRepository.Object, bankDbContext, iRepositoryAccount.Object, null); //Act var loanDetails = accountLoanService.RequestedLoanDetails(1); //Assert Assert.IsNotNull(loanDetails); }
public void GetById() { //Arrange var accountLoan = new AccountLoan() { Id = 1 }; var iRepositoryAccountLoan = new MockIRepository <AccountLoan>() .MockGetById(accountLoan); var accountLoanRepository = new MockAccountLoanRepository(); var bankDbContext = new BankDbContext(); var iRepositoryAccount = new MockIRepository <Account>(); var accountLoanService = new AccountLoanService( iRepositoryAccountLoan.Object, accountLoanRepository.Object, bankDbContext, iRepositoryAccount.Object, null); //Act var loanById = accountLoanService.GetById(1); //Assert Assert.IsNotNull(loanById); }
public AccountsController(BankDbContext context, UserManager <ApplicationUser> userManager) { _context = context; _userManager = userManager; }
public UserService(BankDbContext context) { _context = context; }
public ClientsController(IClientRepository context, BankDbContext contextBank) { _context = context; _contextBank = contextBank; }
public AccountsController(BankDbContext context) { _context = context; }
public AccountBalanceAccess(BankDbContext bankDbContext) { _bankDbContext = bankDbContext; }
public BillPayController(BankDbContext context, UserManager <BankDbUser> userManager) { _context = context; _userManager = userManager; }
public DepositCommand(BankDbContext db, string[] arguments) : base(db, arguments) { }
public ServiceCategoryRepository(BankDbContext ctx) : base(ctx) { }
public QuestionRepository(BankDbContext ctx) : base(ctx) { }
public AccountController(IMediator mediator, BankDbContext context) { this._mediator = mediator; _context = context; }
public BillPayController(BankDbContext context) { _context = context; }
public CustomerController(BankDbContext context, UserManager <BankDbUser> userManager) { _context = context; _userManager = userManager; }
public TransactionRepository(BankDbContext context) { this.db = context; }
public UnitOfWork(BankDbContext db) { _db = db; Account = new AccountRepository(_db); }
public LoanTypeRepository(BankDbContext ctx) : base(ctx) { }
public AccountLoanRepository(BankDbContext context) { _context = context; }
public static void FillDb() { using (var context = new BankDbContext()) { Console.WriteLine("ConnectionString\n" + context.Database.Connection.ConnectionString); Console.WriteLine("DataSource\n" + context.Database.Connection.DataSource); Console.WriteLine("ConnectionString\n" + context.Database.Connection.Database); // CLEARS ALL DATA !!! Console.WriteLine("ALL DATA WILL BE DELETED FROM DB NOW!!! ([ENTER] TO PROCEED)"); Console.ReadLine(); //if (!context.Database.Exists()) //{ context.Database.Delete(); context.Database.Create(); //} context.Database.Initialize(true);// Console.WriteLine("Db initialized"); Console.ReadLine(); context.Accounts.RemoveRange(context.Accounts); ///Console.WriteLine("I've successfully completed first db action!"); ///Console.ReadLine(); context.Clients.RemoveRange(context.Clients); context.Credits.RemoveRange(context.Credits); context.CreditTypes.RemoveRange(context.CreditTypes); context.Payments.RemoveRange(context.Payments); context.Requests.RemoveRange(context.Requests); //context.RequestStatuses.RemoveRange(context.RequestStatuses); context.Users.RemoveRange(context.Users); context.SaveChanges(); // CLEARS ALL DATA !!! //var statusRepo = new RequestStatusRepository(context); //var statusCreated = new RequestStatus { Status = "Created" }; //var statusConfirmedByOperator = new RequestStatus { Status = "statusConfirmedByOperator" }; //var statusConfirmedBySse = new RequestStatus { Status = "statusConfirmedBySecurityServiceEmployee" }; ////var statusConfirmed = new RequestStatus { Status = "ConfirmedBy" }; //var statusCreditProvided = new RequestStatus { Status = "statusCreditProvided" }; //var statusDenied = new RequestStatus { Status = "Denied" }; //statusRepo.Add(statusCreated, statusConfirmedByOperator, statusConfirmedByOperator, statusCreditProvided,statusDenied); // context.SaveChanges(); // var confirmedByOperatorStatusId = statusCreditProvided.RequestStatusId; // var createdStatusId = statusCreated.RequestStatusId; // var deinedStatusId = statusDenied.RequestStatusId; var creditShort = new CreditType { Name = "Easy Money", //Type = "" WTF IS TYPE????? TimeMonths = 12, PercentPerYear = 20.0m, Currency = "USD", FinePercent = 40.0m, MinAmount = 200, MaxAmount = 2000, IsAvailable = true }; var creditMedium = new CreditType { Name = "Not So Easy Money", //Type = "" WTF IS TYPE????? TimeMonths = 12 * 2, PercentPerYear = 25.0m, Currency = "USD", FinePercent = 50.0m, MinAmount = 200, MaxAmount = 5000, IsAvailable = true }; var creditLong = new CreditType { Name = "Still Money", //Type = "" WTF IS TYPE????? TimeMonths = 12 * 4, PercentPerYear = 30.0m, Currency = "USD", FinePercent = 60.0m, MinAmount = 200, MaxAmount = 5000, IsAvailable = true }; var creditTypeRepo = new CreditTypeRepository(context); creditTypeRepo.Add(creditShort, creditLong, creditMedium); context.SaveChanges(); var creditEasyId = creditShort.CreditTypeId; var creditMediumId = creditMedium.CreditTypeId; var creditLongId = creditLong.CreditTypeId; var admin = new User { Login = "******", Password = "******", Role = UserRole.Admin, IsActive = true }; var ss = new User // security service employee { Login = "******", Password = "******", Role = UserRole.SecurityServiceEmployee, IsActive = true }; var operator1 = new User // { Login = "******", Password = "******", Role = UserRole.Operator, IsActive = true }; var operator2 = new User // { Login = "******", Password = "******", Role = UserRole.Operator, IsActive = true }; var client1 = new User { Login = "******", Password = "******", Role = UserRole.Client }; var client2 = new User { Login = "******", Password = "******", Role = UserRole.Client }; var client3 = new User { Login = "******", Password = "******", Role = UserRole.Client }; var userRepo = new UserRepository(context); userRepo.Add(admin, ss, operator1, operator2, client1, client2, client3); context.SaveChanges(); var client1Id = client1.UserId; var client2Id = client2.UserId; var client3Id = client3.UserId; var client1Info = new Client { UserId = client1.UserId, Name = "Clientone", LastName = "Clientov", Patronymic = "Clientovich", Birthday = new DateTime(1990, 1, 1), Mobile = "+375441234567", Email = "*****@*****.**", PassportNo = "AB1234567", PassportIdentificationNo = "4123456B124PB7", PassportAuthority = "Ministry of internal affairs", PassportExpirationDate = DateTime.Now.AddYears(6), PlaceOfResidence = "Pushkina st.1 app.18", RegistrationAddress = "Pushkina st.1 app.18" }; var client2Info = new Client { UserId = client2.UserId, Name = "Clienttwo", LastName = "Clientov", Patronymic = "Clientovich", Birthday = new DateTime(1982, 2, 2), Mobile = "+375251234567", Email = "*****@*****.**", PassportNo = "AB1234123", PassportIdentificationNo = "4125552B124PB7", PassportAuthority = "Ministry of internal affairs", PassportExpirationDate = DateTime.Now.AddYears(1), PlaceOfResidence = "Pushkina st.2 app.7", RegistrationAddress = "Pushkina st.2 app.7" }; var client3Info = new Client { UserId = client3.UserId, Name = "Clientthree", LastName = "Clientov", Patronymic = "Clientovich", Birthday = new DateTime(1973, 3, 3), Mobile = "+375291234567", Email = "*****@*****.**", PassportNo = "AB1223331", PassportIdentificationNo = "4129332B124PB3", PassportAuthority = "Ministry of internal affairs", PassportExpirationDate = DateTime.Now.AddYears(6), PlaceOfResidence = "Pushkina st.3 app.24", RegistrationAddress = "Pushkina st.3 app.24" }; var clientRepo = new ClientRepository(context); clientRepo.Add(client1Info, client2Info, client3Info); context.SaveChanges(); var request1client1 = new Request { ClientId = client1Info.ClientId, //RequestStatusId = createdStatusId, Status = RequestStatus.Created, CreditTypeId = creditEasyId, AmountOfCredit = 1000, Salary = 500 }; var request2client1 = new Request { ClientId = client1Info.ClientId, //RequestStatusId = createdStatusId, Status = RequestStatus.Created, OperatorId = operator1.UserId, CreditTypeId = creditMediumId, AmountOfCredit = 1200, Salary = 500 }; var request3client1 = new Request { ClientId = client1Info.ClientId, //RequestStatusId = confirmedByOperatorStatusId, Status = RequestStatus.ConfirmedByOperator, OperatorId = operator1.UserId, CreditTypeId = creditLongId, AmountOfCredit = 1000, Salary = 500 }; var request4client1 = new Request { ClientId = client1Info.ClientId, Status = RequestStatus.ConfirmedByOperator, // createdStatusId, OperatorId = operator1.UserId, CreditTypeId = creditMediumId, AmountOfCredit = 1100, Salary = 500 }; var request5client1 = new Request { ClientId = client1Info.ClientId, //RequestStatusId = createdStatusId, Status = RequestStatus.CreditProvided, OperatorId = operator1.UserId, CreditTypeId = creditLongId, AmountOfCredit = 1300, Salary = 500 }; var request6client1 = new Request { ClientId = client1Info.ClientId, //RequestStatusId = confirmedByOperatorStatusId, Status = RequestStatus.CreditProvided, OperatorId = operator1.UserId, CreditTypeId = creditLongId, AmountOfCredit = 900, Salary = 500 }; var request7client1 = new Request { ClientId = client1Info.ClientId, Status = RequestStatus.ConfirmedBySecurityOfficer, // createdStatusId, OperatorId = operator1.UserId, CreditTypeId = creditLongId, AmountOfCredit = 800, Salary = 500 }; var request8client1 = new Request { ClientId = client1Info.ClientId, //RequestStatusId = confirmedByOperatorStatusId, Status = RequestStatus.CreditProvided, OperatorId = operator1.UserId, CreditTypeId = creditMediumId, AmountOfCredit = 900, Salary = 500 }; var requestRepo = new RequestRepository(context); requestRepo.Add( request1client1, request2client1, request3client1, request4client1, request5client1, request6client1, request7client1, request8client1); context.SaveChanges(); //var acc1 = new Account //Bank Account //{ // ClientId = null, // Balance = 40*1000*1000 //}; var bankAccount = new BankAccount //Bank Account { Balance = 40 * 1000 * 1000, Currency = "USD" }; context.BankAccount = bankAccount; context.SaveChanges(); var acc2 = new Account { ClientId = client1Info.ClientId, Balance = request2client1.AmountOfCredit }; var accountRepo = new AccountRepository(context); accountRepo.Add(/*acc1,*/ acc2); context.SaveChanges(); DateTime dt1 = DateTime.Now.AddDays(-(30 * 4 + 5)); var credit1Client1 = new Credit { AccountId = acc2.AccountId, CreditTypeId = creditLong.CreditTypeId, //ContractNo = 123123, //random RequestId = request5client1.RequestId, //AllreadyPaid = 0, AmountOfPaymentPerMonth = (request5client1.AmountOfCredit / creditLong.TimeMonths) * (1 + creditLong.PercentPerYear / 100 * creditLong.TimeMonths / 12), StartDate = dt1, IsRepaid = false, HasDelays = false, CountFineFromThisDate = dt1.AddDays(30),//DateTime.UtcNow.AddDays(30), //!!! hard-coded!!! AmountToCountFineFromForFirstDelayedMonth = (request5client1.AmountOfCredit / creditLong.TimeMonths) * (1 + creditLong.PercentPerYear / 100 * creditLong.TimeMonths / 12), PaidForFine = 0 }; DateTime dt2 = DateTime.UtcNow.AddDays(-(30 * 50 + 7)); var credit2Client1 = new Credit { AccountId = acc2.AccountId, CreditTypeId = creditLong.CreditTypeId, //ContractNo = 123123, //random RequestId = request6client1.RequestId, //AllreadyPaid = 0, AmountOfPaymentPerMonth = (request6client1.AmountOfCredit / creditLong.TimeMonths) * (1 + creditLong.PercentPerYear / 100 * creditLong.TimeMonths / 12), StartDate = dt2, IsRepaid = true, HasDelays = true, CountFineFromThisDate = dt2.AddDays(30), //!!! hard-coded!!! AmountToCountFineFromForFirstDelayedMonth = (request6client1.AmountOfCredit / creditLong.TimeMonths) * (1 + creditLong.PercentPerYear / 100 * creditLong.TimeMonths / 12), PaidForFine = 0 }; var credit3Client1 = new Credit { AccountId = acc2.AccountId, CreditTypeId = creditMedium.CreditTypeId, //ContractNo = 123123, //random RequestId = request8client1.RequestId, //AllreadyPaid = 0, AmountOfPaymentPerMonth = (request8client1.AmountOfCredit / creditMedium.TimeMonths) * (1 + creditMedium.PercentPerYear / 100 * creditMedium.TimeMonths / 12), StartDate = DateTime.Now, IsRepaid = false, HasDelays = true, CountFineFromThisDate = DateTime.Now.AddDays(30), //!!! hard-coded!!! AmountToCountFineFromForFirstDelayedMonth = (request8client1.AmountOfCredit / creditMedium.TimeMonths) * (1 + creditMedium.PercentPerYear / 100 * creditMedium.TimeMonths / 12), PaidForFine = 0 }; request5client1.Credit = credit1Client1; // IMPORTANT do this for 1-1 relationship (exception otherwise) request6client1.Credit = credit2Client1; // IMPORTANT do this for 1-1 relationship (exception otherwise) request8client1.Credit = credit3Client1; // IMPORTANT do this for 1-1 relationship (exception otherwise) var creditRepo = new CreditRepository(context); creditRepo.Add(credit1Client1, credit2Client1, credit3Client1); context.SaveChanges(); /* var payment = new Payment * { * OperatorId = operator1.UserId, * CreditId = credit1Client1.CreditId, * //ContractNo = credit1Client1.ContractNo, * Amount = 75, * Date = credit1Client1.StartDate.AddDays(15) * }; * //var credit * * var payRepo = new PaymentRepository(context); * payRepo.Add(payment); */ var test = context.BankAccount; //context.RequestStatuses.Where(x => x.Status.Contains("Created")).FirstOrDefault(); //context.RequestStatuses.Add(new RequestStatus { Status = "Created" }); context.SaveChanges(); } }
public ClientsRepository(BankDbContext db) { _db = db; }
public IncidentsRepository(BankDbContext db) { _db = db; }
public DepositTermRepository(BankDbContext ctx) : base(ctx) { }
public EmploymentTypeRepository(BankDbContext ctx) : base(ctx) { }