public static void Initialize(MatchbookDbContext dbContext)
{
// Drop & re-create DB
dbContext.Database.EnsureDeleted();
dbContext.Database.EnsureCreated();
// Data is already seeded?
//if (dbContext.Orders.Any())
// return;
// Do the initialization
DataGenerator.KnownCurrencies
.Select(code => new Currency {
Code = code, Name = $"{code} currency"
})
.ForEach(currency => dbContext.Currencies.Add(currency));
dbContext.SaveChanges();
DataGenerator.KnownUnitsOfMeasure
.Select(code => new UnitOfMeasure {
Code = code, Name = $"{code} uom"
})
.ForEach(uom => dbContext.UnitsOfMeasure.Add(uom));
dbContext.SaveChanges();
DataGenerator.NewOrders()
.Take(20)
.ForEach(order => dbContext.Orders.Add(order));
dbContext.SaveChanges();
}
public static ProductSpecification NewSavedProductSpec(MatchbookDbContext dbContext)
{
var spec = NewProductSpec();
dbContext.ProductSpecifications.Add(spec);
dbContext.SaveChanges();
return(spec);
}
public static SubAccount NewSavedSubAccount(MatchbookDbContext dbContext)
{
var account = NewUnsavedSubAccount(dbContext);
dbContext.SubAccounts.Add(account);
dbContext.SaveChanges();
return(account);
}
//public static string connectionString = "Server=localhost\\SQLEXPRESS;Database=Matchbook;Trusted_Connection=True;";
public OrderLinkTestCase(DbContextFixture fixture)
{
this._fixture = fixture;
//dbContextOptions = new DbContextOptionsBuilder<MatchbookDbContext>()
// .UseInMemoryDatabase(databaseName: "Matchbook").Options;
MatchbookDbContextWithData = _fixture.NewDbContext();
}
public static SubAccount NewUnsavedSubAccount(MatchbookDbContext dbContext)
{
var clearingAccount = NewClearingAccount();
var internalClearingAccount = NewClearingAccount();
dbContext.ClearingAccounts.AddRange(clearingAccount, internalClearingAccount);
dbContext.SaveChanges();
var account = NewSubAccount();
account.ClearingAccountId = clearingAccount.Id;
account.InternalClearingAccountId = internalClearingAccount.Id;
return(account);
}
public void Seed(MatchbookDbContext context)
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
context.Orders.AddRange(
DataGenerator.NewOrders()
);
//context.Post.AddRange(
// new Post() { Title = "Test Title 1", Description = "Test Description 1", CategoryId = 2, CreatedDate = DateTime.Now },
// new Post() { Title = "Test Title 2", Description = "Test Description 2", CategoryId = 3, CreatedDate = DateTime.Now }
//);
context.SaveChanges();
}
public (int, string) GetLinkCountByName(string name)
{
int count = 0;
string message = string.Empty;
try
{
MatchbookDbContext dbContext = new MatchbookDbContext();
count = dbContext.OrderLink.Where(link => link.Name.ToLower() == name.ToLower()).Count();
}
catch (Exception ex)
{
message = ex.Message;
}
return(count, message);
}
public (int, string) CreateLink(string name)
{
int linkId = -1;
string message = string.Empty;
try
{
MatchbookDbContext dbContext = new MatchbookDbContext();
OrderLink orderLink = new OrderLink()
{
Name = name
};
dbContext.OrderLink.Add(orderLink);
dbContext.SaveChanges();
linkId = dbContext.OrderLink.OrderByDescending(link => link.Id).FirstOrDefault().Id ?? -1;
}
catch (Exception ex)
{
message = ex.Message;
}
return(linkId, message);
}
public (int, string) UpdateOrders(List <int> orderIds, int linkId)
{
int success = 0;
string message = string.Empty;
try
{
MatchbookDbContext matchDbContext = new MatchbookDbContext();
foreach (int orderId in orderIds)
{
Order order = matchDbContext.Orders.Find(orderId);
order.LinkId = linkId;
matchDbContext.Orders.Update(order);
}
matchDbContext.SaveChanges();
success = 1;
}
catch (Exception ex)
{
message = ex.Message;
}
return(success, message);
}
public OrdersController(MatchbookDbContext dbContext)
{
this.dbContext = dbContext;
}
public List <Order> GetOrders(List <int> orderIds)
{
MatchbookDbContext dbContext = new MatchbookDbContext();
return(dbContext.Orders.Where(order => orderIds.Contains(order.Id)).ToList());
}
