/// <summary> /// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. /// </summary> public void Configure(IApplicationBuilder app, IWebHostEnvironment env, CustomerDBContext db) { // check environment app.UseExceptionHandling(); db.Database.EnsureCreated(); app.UseStaticFiles(); app.UseRouting(); app.UseAuthorization(); app.UseEndpoints(endpoints => { endpoints.MapControllers(); }); app.UseResponseCompression(); if (!env.IsProduction()) { app.UseDocumentation(); } app.UseMvp24Hours(); }
public ActionResult OrderCard() { int userID = Convert.ToInt32(System.Web.HttpContext.Current.Session["userID"]); var activeCard = customerDB.Cards.Where(c => c.CustomerID == userID && c.IsActive == true).FirstOrDefault(); if (activeCard != null) { ModelState.AddModelError("CardID", "Customer has active card. Deactivate first"); return(View("Card", activeCard)); } else { using (CustomerDBContext db = new CustomerDBContext()) { Card newCard = new Card { IsActive = true, CustomerID = userID }; db.Cards.Add(newCard); db.SaveChanges(); } return(RedirectToAction("Card")); } }
public ActionResult MakeTransfer(Payment payment) { int userID = Convert.ToInt32(System.Web.HttpContext.Current.Session["userID"]); if (!ModelState.IsValid) { return(View("Transfer", payment)); } else { using (CustomerDBContext db = new CustomerDBContext()) { var customer = db.Customers.Where(c => c.CustomerID == userID).FirstOrDefault(); if (payment.Amount > customer.Balance) { ModelState.AddModelError("Amount", "Payment amount exceeded balance"); return(View("Transfer")); } else { checkInternalTransfer(customer, payment); customer.Balance -= payment.Amount; payment.CustomerID = userID; payment.Amount = payment.Amount * (-1); db.Payments.Add(payment); db.SaveChanges(); ModelState.Clear(); } } return(View("Transfer")); } }
public static void Seed(this CustomerDBContext dbContext) { dbContext.CustomerList.Add(new Customer { FirstName = "John", LastName = "Smith", DateOfBirth = System.DateTime.Now.Date.AddYears(-10) }); dbContext.CustomerList.Add(new Customer { FirstName = "Nancy", LastName = "Davolio", DateOfBirth = System.DateTime.Now.Date.AddYears(-20) }); dbContext.CustomerList.Add(new Customer { FirstName = "Andrew", LastName = "Fuller", DateOfBirth = DateTime.Parse("1963-08-30") }); dbContext.CustomerList.Add(new Customer { FirstName = "Janet", LastName = "Leverling", DateOfBirth = DateTime.Parse("1937-09-19") }); dbContext.CustomerList.Add(new Customer { FirstName = "Margaret", LastName = "Peacock", DateOfBirth = DateTime.Parse("1955-03-04") }); dbContext.CustomerList.Add(new Customer { FirstName = "Steven", LastName = "Buchanan", DateOfBirth = DateTime.Parse("1963-07-02") }); dbContext.CustomerList.Add(new Customer { FirstName = "Michael", LastName = "Suyama", DateOfBirth = DateTime.Parse("1960-05-29") }); dbContext.CustomerList.Add(new Customer { FirstName = "Robert", LastName = "King", DateOfBirth = DateTime.Parse("1958-01-09") }); dbContext.CustomerList.Add(new Customer { FirstName = "Laura", LastName = "Callahan", DateOfBirth = DateTime.Parse("1966-01-27") }); dbContext.CustomerList.Add(new Customer { FirstName = "Anne", LastName = "Dodsworth", DateOfBirth = DateTime.Parse("1948-12-08") }); dbContext.SaveChanges(); }
public List <Loan> GetLoans() { using (CustomerDBContext context = new CustomerDBContext()) { return(context.loans.ToList()); } }
public static void Initialize(IServiceProvider serviceProvider) { using (var dbContext = new CustomerDBContext( serviceProvider.GetRequiredService <DbContextOptions <CustomerDBContext> >())) { if (!dbContext.Customers.Any()) { dbContext.Customers.AddRange(new[] { new Customer() { FirstName = "Syed", LastName = "Majeeduddin", DOB = DateTime.Now.AddYears(-25) }, new Customer() { FirstName = "John", LastName = "Alexander", DOB = DateTime.Now.AddYears(-35) }, new Customer() { FirstName = "Trent", LastName = "Smith", DOB = DateTime.Now.AddYears(-56) } }); } dbContext.SaveChanges(); } }
public ActionResult Delete(int id) { CustomerDBContext context = new CustomerDBContext(); Customer customerDetail = context.customers.Find(id); //CustomerModel model = new CustomerModel //{ // id = customerDetail.customerid, // name = customerDetail.name, // type = (Type)Enum.Parse(typeof(Type), (customerDetail.type)), // monthlyIncome = customerDetail.monthlyIncome, // mobilenumber = customerDetail.mobilenumber, // residentArea = customerDetail.residentArea, // salaryReceivedIn = (Bank)Enum.Parse(typeof(Bank), (customerDetail.salaryReceivedIn)), // desiredLoanAmount = customerDetail.desiredLoanAmount, // gender = customerDetail.gender, // pincode = customerDetail.pincode, // panCardNumber = customerDetail.panCardNumber, // dateOfBirth = customerDetail.dateOfBirth, // email = customerDetail.email, // company = customerDetail.company, // currentEMIAmount = customerDetail.currentEMIAmount, // tenure = customerDetail.tenure, // experience = customerDetail.experience, // haveLoan = (Loans)Enum.Parse(typeof(Loans), (customerDetail.haveLoan)), // password = customerDetail.password //}; var model = AutoMapper.Mapper.Map <Customer, CustomerModel>(customerDetail); return(View(model)); }
public List <Bank> GetBanks() { using (CustomerDBContext context = new CustomerDBContext()) { return(context.banks.ToList()); } }
public ActionResult Edit(int id) { CustomerDBContext context = new CustomerDBContext(); Customer customerDetail = context.customers.Find(id); CustomerModel model = new CustomerModel { customerid = customerDetail.customerid, name = customerDetail.name, type = (Type)Enum.Parse(typeof(Type), (customerDetail.type)), monthlyIncome = customerDetail.monthlyIncome, mobilenumber = customerDetail.mobilenumber, residentArea = customerDetail.residentArea, salaryReceivedIn = (Bank)Enum.Parse(typeof(Bank), (customerDetail.salaryReceivedIn)), desiredLoanAmount = customerDetail.desiredLoanAmount, gender = customerDetail.gender, pincode = customerDetail.pincode, panCardNumber = customerDetail.panCardNumber, dateOfBirth = customerDetail.dateOfBirth, email = customerDetail.email, company = customerDetail.company, currentEMIAmount = customerDetail.currentEMIAmount, tenure = customerDetail.tenure, experience = customerDetail.experience, haveLoan = (Loans)Enum.Parse(typeof(Loans), (customerDetail.haveLoan)), password = customerDetail.password }; return(View(model)); }
public CustomerControllerTest() { _logger = new MockLogger <CustomerController>(); _dbContext = new MockDbContext().DbContext(); _customerRepository = new CustomerRepository(_dbContext); _customerService = new CustomerService(_customerRepository); _customerController = new CustomerController(_customerService, _logger); }
public ActionResult DeleteLoan(int id) { CustomerDBContext context = new CustomerDBContext(); Loan loanDetail = context.loans.Find(id); var mapper = AutoMapper.Mapper.Map <Loan, LoanModel>(loanDetail); return(View(mapper)); }
public CustomerProvider(CustomerDBContext dbContext, ILogger <CustomerProvider> logger, IMapper mapper) { _dbContext = dbContext; _logger = logger; _mapper = mapper; SeedData(); }
public ActionResult DeleteBank(int id) { CustomerDBContext context = new CustomerDBContext(); Bank bankDetail = context.banks.Find(id); var mapper = AutoMapper.Mapper.Map <Bank, BankModel>(bankDetail); return(View(mapper)); }
public CreateCustomerdHandler(IBusPublisher busPublisher, CustomerDBContext dbContext, ILogger <CreateCustomerdHandler> logger) { _logger = logger; _busPublisher = busPublisher; _dbContext = dbContext; }
public OrderCompletedHandler(IBusPublisher busPublisher, CustomerDBContext dbContext, ILogger <OrderCompletedHandler> logger) { _logger = logger; _busPublisher = busPublisher; _dbContext = dbContext; }
public CustomerProvider(CustomerDBContext dbContext, ILogger <Db.Customer> logger, IMapper mapper) { this.dbContext = dbContext; this.logger = logger; this.mapper = mapper; SeedData(); }
public ActionResult Quenue() { using (CustomerDBContext db = new CustomerDBContext()) { return(View(db.customer.ToList())); } }
public void AddLoan(Loan loan) { using (CustomerDBContext context = new CustomerDBContext()) { SqlParameter loanname = new SqlParameter("@name", loan.name); var data = context.Database.ExecuteSqlCommand("Loan_Insert @name", loanname); //context.loans.Add(loan); //context.SaveChanges(); } }
public AddProductToBasketHandler(IBusPublisher busPublisher, CustomerDBContext dbContext, IProductHttpService productHttpService, ILogger <AddProductToBasketHandler> logger ) { _productHttpService = productHttpService; _logger = logger; _busPublisher = busPublisher; _dbContext = dbContext; }
// GET: Customers/DeleteALl/5 public ActionResult DeleteAll(string confirmButton) { using (var context = new CustomerDBContext()) { var itemsToDelete = context.Set <Customer>(); context.Customers.RemoveRange(itemsToDelete); context.SaveChanges(); } return(RedirectToAction("Index")); }
public void EditLoan(Loan loan) { using (CustomerDBContext context = new CustomerDBContext()) { //context.Entry(loan).State = EntityState.Modified; SqlParameter loanid = new SqlParameter("@loanid", loan.loanid); SqlParameter loanname = new SqlParameter("@name", loan.name); var data = context.Database.ExecuteSqlCommand("Loan_Update @loanid,@name", loanid, loanname); //context.SaveChanges(); } }
public void DeleteLoan(int loanid) { using (CustomerDBContext context = new CustomerDBContext()) { //Loan loan = context.loans.Find(loanid); //context.loans.Remove(loan); SqlParameter id = new SqlParameter("@loanid", loanid); var data = context.Database.ExecuteSqlCommand("Loan_Delete @loanid", id); // context.SaveChanges(); } }
public void DeleteBank(int bankid) { using (CustomerDBContext context = new CustomerDBContext()) { //Bank bank = context.banks.Find(bankid); //context.banks.Remove(bank); SqlParameter id = new SqlParameter("@bankid", bankid); var data = context.Database.ExecuteSqlCommand("Bank_Delete @bankid", id); //context.SaveChanges(); } }
public ActionResult ChosenDropDown() { CustomerDBContext db = new CustomerDBContext(); Customers objCus = new Customers(); objCus.GetCustomersList = db.TblCustomers.Select(s => new Customers { CustomerId = s.Id, CustomerName = s.Name }).ToList(); return(View(objCus)); }
public static CustomerDBContext GetCustomerDBContext(string dbName) { // Create options for DbContext instance var options = new DbContextOptionsBuilder <CustomerDBContext>() .UseInMemoryDatabase(databaseName: dbName) .Options; // Create instance of DbContext var dbContext = new CustomerDBContext(options); // Add entities in memory dbContext.Seed(); return(dbContext); }
public ActionResult Authorization(Customer customer) { using (CustomerDBContext db = new CustomerDBContext()) { var selectedCustomer = db.Customers.Where(c => c.CustomerID == (int)customer.CustomerID).FirstOrDefault(); if (!ModelState.IsValid) { return(View("Index", customer)); } else { if (selectedCustomer == null) { ModelState.AddModelError("CustomerID", "Customer doesn't exist"); return(View("Index")); } else { bool isAccountBlocked = CheckIfAccountIsBlocked(selectedCustomer); if (isAccountBlocked) { ModelState.AddModelError("CustomerID", "Account has been blocked"); return(View("Index")); } else { var selectedCustomerWithPassword = db.Customers.Where(c => c.CustomerID == customer.CustomerID && c.Password == customer.Password).FirstOrDefault(); if (selectedCustomerWithPassword == null) { selectedCustomer.IncorrectLogins += 1; db.SaveChanges(); ModelState.AddModelError("CustomerID", "Incorrect login/password"); return(View("Index")); } else { selectedCustomer.IncorrectLogins = 0; db.SaveChanges(); Session["userID"] = selectedCustomer.CustomerID; return(RedirectToAction("Index", "Home")); } } } } } }
public void AddBank(Bank bank) { using (CustomerDBContext context = new CustomerDBContext()) { SqlParameter bankname = new SqlParameter("@name", bank.name); SqlParameter interestRate = new SqlParameter("@interestRate", bank.interestRate); SqlParameter processingFees = new SqlParameter("@processingFees", bank.processingFees); SqlParameter EMI = new SqlParameter("@EMI", bank.EMI); SqlParameter bankTenure = new SqlParameter("@bankTenure", bank.bankTenure); SqlParameter minimumAmount = new SqlParameter("@minimumAmount", bank.minimumAmount); SqlParameter chanceOfLoan = new SqlParameter("@chanceOfLoan", bank.chanceOfLoan); var data = context.Database.ExecuteSqlCommand("Bank_Insert @name,@interestRate,@processingFees,@EMI,@bankTenure,@minimumAmount,@chanceOfLoan", bankname, interestRate, processingFees, EMI, bankTenure, minimumAmount, chanceOfLoan); //context.banks.Add(bank); //context.SaveChanges(); } }
public void GetCustomerById_ReturnsCustomerByIdTwo() { // Arrange var connectionStringBuilder = new SqliteConnectionStringBuilder { DataSource = ":memory:" }; var connection = new SqliteConnection(connectionStringBuilder.ToString()); var options = new DbContextOptionsBuilder <CustomerDBContext>() .UseSqlite(connection) .Options; using (var context = new CustomerDBContext(options)) { context.Database.OpenConnection(); context.Database.EnsureCreated(); context.Customers.AddRange(new[] { new Customer() { FirstName = "Syed", LastName = "Majeeduddin", DOB = DateTime.Now.AddYears(-25) }, new Customer() { FirstName = "John", LastName = "Alexander", DOB = DateTime.Now.AddYears(-35) }, new Customer() { FirstName = "Trent", LastName = "Smith", DOB = DateTime.Now.AddYears(-56) } }); context.SaveChanges(); var customerRepository = new CustomerRepository(context); // Act var customer = customerRepository.FindById(2); // Assert Assert.Equal("John", (customer.Result).FirstName); } }
public ActionResult Register(Customer customer) { using (context = new CustomerDBContext()) { customer.Account_number = AlexaService.GenerateNewAccountNumber().ToString(); customer.Balance = "500"; context.Customers.Add(customer); context.SaveChanges(); } ModelState.Clear(); ViewBag.Message = "Account Created sucessfully. Account number has been sent to your Registered email address"; AlexaService.SendAccountConfirmationMail(customer.Email.ToString(), customer.Account_number); return(View()); }
public void EditBank(Bank bank) { using (CustomerDBContext context = new CustomerDBContext()) { //context.Entry(bank).State = EntityState.Modified; SqlParameter bankid = new SqlParameter("@bankid", bank.bankid); SqlParameter bankname = new SqlParameter("@name", bank.name); SqlParameter interestRate = new SqlParameter("@interestRate", bank.interestRate); SqlParameter processingFees = new SqlParameter("@processingFees", bank.processingFees); SqlParameter EMI = new SqlParameter("@EMI", bank.EMI); SqlParameter bankTenure = new SqlParameter("@bankTenure", bank.bankTenure); SqlParameter minimumAmount = new SqlParameter("@minimumAmount", bank.minimumAmount); SqlParameter chanceOfLoan = new SqlParameter("@chanceOfLoan", bank.chanceOfLoan); var data = context.Database.ExecuteSqlCommand("Bank_Update @bankid,@name,@interestRate,@processingFees,@EMI,@bankTenure,@minimumAmount,@chanceOfLoan", bankname, interestRate, processingFees, EMI, bankTenure, minimumAmount, chanceOfLoan); //context.SaveChanges(); } }