public async Task ReturnCorrectAmount()
{
// setup in-memory database
var dbContextOptions = new Microsoft.EntityFrameworkCore.DbContextOptionsBuilder <VmDbContext>().UseInMemoryDatabase("VMDB");
var dbContext = new VmDbContext(dbContextOptions.Options);
// seed some data
DataSeedingHelper.Seed(dbContext);
var service = new VendingMachineService(dbContext);
var product = (await service.GetProductsAsync()).First();
var change = new Dictionary <decimal, int>();
var payCoins = new Dictionary <decimal, int>();
payCoins.Add(0.1m, 5);
payCoins.Add(1.0m, 2);
var ok = await service.PurchaseAsync(product.Id, payCoins, change);
Assert.True(ok);
var changeSum = change.ToList().Sum(x => x.Key * x.Value);
var paiedSum = payCoins.ToList().Sum(x => x.Key * x.Value);
Assert.Equal(changeSum, paiedSum - product.Price);
}
public MaisCadastrosContext CreateDbContext(string[] args)
{
var optionsBuilder = new Microsoft.EntityFrameworkCore.DbContextOptionsBuilder <MaisCadastrosContext>();
optionsBuilder.UseSqlServer(@"Data Source=(localdb)\\MSSQLLocalDB;Integrated Security=True; MultipleActiveResultSets=True;");
return(new MaisCadastrosContext(optionsBuilder.Options));
}
protected ApplicationDbContext GetDbContext()
{
var options = new Microsoft.EntityFrameworkCore.DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
return(new ApplicationDbContext(options));
}
public AssetContext CreateDbContext(string[] args)
{
var builder = new Microsoft.EntityFrameworkCore.DbContextOptionsBuilder <AssetContext>();
var connectionString = @"Data Source=SQLAPP;Initial Catalog=Asset;Trusted_Connection=True;";
builder.UseSqlServer(connectionString);
return(new AssetContext(builder.Options));
}
public BaseController()
{
var connection = @"Server=BUSWGVMINDEV3\MSSQLSERVER12;Database=RoomPlannerDev;User Id=roomplanner;Password=roomplanner123";
var builder = new Microsoft.EntityFrameworkCore.DbContextOptionsBuilder <RoomPlannerDevContext>();
builder.UseSqlServer(connection);
Context = new RoomPlannerDevContext(builder.Options);
}
public DataContext CreateDbContext(string[] args)
{
IConfigurationRoot configuration = new ConfigurationBuilder()
.SetBasePath(System.IO.Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json")
.Build();
var builder = new Microsoft.EntityFrameworkCore.DbContextOptionsBuilder <DataContext>();
var connectionString = configuration.GetConnectionString("StoreConnectionString");
builder.UseSqlServer(connectionString);
return(new DataContext(builder.Options));
}
private EposDbContext GetWasteDbContext()
{
var options = new Microsoft.EntityFrameworkCore.DbContextOptionsBuilder <EposDbContext>();
options.UseSqlServer(
this.connectionString,
options =>
{
options.CommandTimeout(20); // secs
});
return(new EposDbContext(options.Options));
}
/// <summary>
/// Constrcuts a new instance of a data repository
/// </summary>
/// <param name="context"></param>
public DataRepository(DatabaseContext context, IAuthenticationService authService, IConfiguration config)
{
this._db = context;
//Multitenancy Implimentation
var tenant = authService.GetTenantName();
if (!String.IsNullOrEmpty(tenant))
{
//use other conn string
var optionsBuilder = new Microsoft.EntityFrameworkCore.DbContextOptionsBuilder <DatabaseContext>();
optionsBuilder.UseSqlServer(config.GetConnectionString(tenant));
_db = new DatabaseContext(optionsBuilder.Options);
}
}
public static Microsoft.EntityFrameworkCore.DbContextOptions <ApplicationDbContext> TestDbContextOptions()
{
// Create a new service provider to create a new in-memory database.
var serviceProvider = new ServiceCollection()
.AddEntityFrameworkInMemoryDatabase()
.BuildServiceProvider();
// Create a new options instance using an in-memory database and
// IServiceProvider that the context should resolve all of its
// services from.
var builder = new Microsoft.EntityFrameworkCore.DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase("LMS_Zenith")
.UseInternalServiceProvider(serviceProvider);
return(builder.Options);
}
public static Microsoft.EntityFrameworkCore.DbContextOptions <DbContext> CreateNewContextOptions()
{
// Create a fresh service provider, and therefore a fresh
// InMemory database instance.
var serviceProvider = new Microsoft.Extensions.DependencyInjection.ServiceCollection()
.AddEntityFrameworkInMemoryDatabase()
.BuildServiceProvider();
// Create a new options instance telling the context to use an
// InMemory database and the new service provider.
var builder = new Microsoft.EntityFrameworkCore.DbContextOptionsBuilder <DbContext>();
builder.UseInMemoryDatabase()
.UseInternalServiceProvider(serviceProvider);
return(builder.Options);
}
public void Setup()
{
SqliteCommand sqlite_cmd;
SqliteConnection sqlite_conn = new SqliteConnection(@"Data Source=../../../database/phonebook.db");
// open the connection:
sqlite_conn.Open();
// create a new SQL command:
sqlite_cmd = sqlite_conn.CreateCommand();
sqlite_cmd.CommandText = "DROP Table 'phonebook_entries'";
sqlite_cmd.ExecuteNonQuery();
sqlite_cmd.CommandText = "DROP Table 'entry'";
sqlite_cmd.ExecuteNonQuery();
sqlite_cmd.CommandText = "DROP Table 'phonebook'";
sqlite_cmd.ExecuteNonQuery();
sqlite_cmd.CommandText = "DROP Table 'user'";
sqlite_cmd.ExecuteNonQuery();
sqlite_cmd.CommandText = @"CREATE TABLE 'entry' (
'Id' INTEGER PRIMARY KEY AUTOINCREMENT,
'Name' TEXT NOT NULL,
'PhoneNumber' TEXT NOT NULL
)";
sqlite_cmd.ExecuteNonQuery();
sqlite_cmd.CommandText = @"CREATE TABLE 'user' (
'Id' INTEGER PRIMARY KEY AUTOINCREMENT,
'Username' TEXT NOT NULL UNIQUE,
'Password' TEXT NOT NULL,
'created_date' TEXT NOT NULL,
'Name' TEXT NOT NULL
)";
sqlite_cmd.ExecuteNonQuery();
sqlite_cmd.CommandText = @"CREATE TABLE 'phonebook' (
'Id' INTEGER PRIMARY KEY AUTOINCREMENT,
'Name' TEXT NOT NULL,
'UserId' INTEGER NOT NULL,
FOREIGN KEY('UserId') REFERENCES 'user'('Id')
)";
sqlite_cmd.ExecuteNonQuery();
sqlite_cmd.CommandText = @"CREATE TABLE 'phonebook_entries' (
'phonebook_id' INTEGER NOT NULL,
'entry_id' INTEGER NOT NULL,
FOREIGN KEY('phonebook_id') REFERENCES 'phonebook'('Id'),
PRIMARY KEY('phonebook_id','entry_id'),
FOREIGN KEY('entry_id') REFERENCES 'entry'('Id')
)";
sqlite_cmd.ExecuteNonQuery();
sqlite_conn.Close();
var optionsBuilder = new Microsoft.EntityFrameworkCore.DbContextOptionsBuilder <PhonebookContext>();
optionsBuilder.UseSqlite("Data Source=../../../database/phonebook.db");
dbContext = new PhonebookContext(optionsBuilder.Options);
repo = new PhonebookRepository(dbContext);
auth_repo = new AuthenticationRepository(dbContext);
}
