/// <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();
}
}
