public void UploadDiamond_Replace()
{
ProductServiceTestHelper.UploadDiamond("product_diamond_1.csv", ProductFileUploadType.Replace);
ProductServiceTestHelper.UploadDiamond("product_diamond_3.csv", ProductFileUploadType.Replace);
var imports = default(IEnumerable<ProductDiamondImport>);
var diamonds = default(IEnumerable<ProductDiamond>);
using (var db = new ProductDbContext())
{
imports = db.DiamondImports.OrderBy(d => d.Created).ToArray();
diamonds = db.Diamonds.ToArray();
}
Assert.AreEqual(2, imports.Count());
Assert.AreEqual(1, diamonds.Count());
{
var import = imports.ElementAt(0);
Assert.AreEqual(2, import.Count);
}
{
var import = imports.ElementAt(1);
Assert.AreEqual(1, import.Count);
}
ValidateDiamond(diamonds, 3, false);
}
public static void CleanupDatabase()
{
using (var db = new ProductDbContext())
{
db.Database.ExecuteSqlCommand("DELETE tc_product_diamond");
db.Database.ExecuteSqlCommand("DELETE tc_product_diamond_import");
db.SaveChanges();
}
}
public void GetDiamondImportById()
{
var import = default(ProductDiamondImport);
using (var db = new ProductDbContext())
{
import = db.DiamondImports.First();
}
var token = ODataClientHelper.InvokeGet(string.Format("{0}DiamondImports({1})", ProductServiceRootUrl, import.Id));
Compare(import, token);
}
public void GetDiamondImportProperty()
{
var import = default(ProductDiamondImport);
using (var db = new ProductDbContext())
{
import = db.DiamondImports.First();
}
var token = ODataClientHelper.InvokeGet(string.Format("{0}DiamondImports({1})/Count", ProductServiceRootUrl, import.Id));
Assert.AreEqual(import.Count, (int)token);
}
static async Task Main(string[] args)
{
DbContextOptions options = new DbContextOptionsBuilder().UseInMemoryDatabase("products").Options;
ProductDbContext context = new ProductDbContext(options);
IProductRepository productRepository = new DatabaseProductRepository(context);
IProductWriter productWriter = new FileProductWriter(new FileWriter(), "products.txt");
await Run(productRepository, productWriter);
}
private void _getData()
{
//显示数据
using (var context = new ProductDbContext())
{
var productList = context.Products.OrderBy(x => x.SN).ToList();
GridView1.DataSource = productList;
GridView1.DataBind();
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ProductDbContext productDbContext)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseMvc();
productDbContext.Database.EnsureCreated();
}
public void GetDiamondById()
{
var diamond = default(ProductDiamond);
using (var db = new ProductDbContext())
{
diamond = db.Diamonds.First();
}
var token = ODataClientHelper.InvokeGet(string.Format("{0}Diamonds({1})", ProductServiceRootUrl, diamond.Id));
Compare(diamond, token);
}
public ProductRepository(ProductDbContext product)
{
_db = product;
MapperConfiguration cofiguration = new MapperConfiguration(cfg =>
{
cfg.CreateMap <ProductDto, ProductModel>().ReverseMap();
});
_mapper = cofiguration.CreateMapper();
}
public void TestGetProductByNameNotFound()
{
using (var context = new ProductDbContext(builder.Options))
{
SetUpTestData(context);
IProductRepository productRepository = new ProductRepository(context);
var p = productRepository.GetProductsByName("NonExisting");
p.Result.Should().BeEmpty();
context.Database.EnsureDeleted();
}
}
public void TestGetProductOptionByProductIdNotFound()
{
using (var context = new ProductDbContext(builder.Options))
{
SetUpTestData(context);
IProductOptionRepository productOptionRepository = new ProductOptionRepository(context);
var p = productOptionRepository.GetProductOptionsByProductId(new Guid());
p.Result.Should().BeEmpty();
context.Database.EnsureDeleted();
}
}
public void TestGetProductOptionByIdNotFound()
{
using (var context = new ProductDbContext(builder.Options))
{
SetUpTestData(context);
IProductOptionRepository productOptionRepository = new ProductOptionRepository(context);
ProductOption po = productOptionRepository.GetById(new Guid());
po.Should().BeNull();
context.Database.EnsureDeleted();
}
}
public UnitOfWork(ProductDbContext dbContext, IMapper mapper, IProductRepository productRepository)
{
if (dbContext == null)
{
throw new ArgumentNullException("dbContext can not be null.");
}
_dbContext = dbContext;
_mapper = mapper;
_productRepository = productRepository;
}
protected void Dispose(bool disposing)
{
if (disposing)
{
if (context != null)
{
context.Dispose();
context = null;
}
}
}
public async Task <int> Execute(OutputParameters parameters)
{
string configFile = parameters.ConfigFilePath ?? DefaultConfigFile;
string configFileContent = File.ReadAllText(configFile);
var configuration = JsonConvert.DeserializeObject <Configuration>(configFileContent);
string databaseServer = parameters.DatabaseServer ?? configuration.DatabaseServer;
string databaseName = parameters.DatabaseName ?? configuration.DatabaseName;
string username = parameters.Username ?? configuration.Username;
string password = parameters.Password ?? configuration.Password;
int checkInterval = parameters.CheckInterval ?? configuration.CheckInterval;
int topAmount = parameters.TopAmount ?? configuration.TopAmount;
int minutesToInclude = parameters.MinutesToInclude ?? configuration.MinutesToInclude;
int secondsToWait = parameters.SecondsToWait ?? configuration.SecondsToWait;
Console.TreatControlCAsInput = true;
var cancellationTokenSource = new CancellationTokenSource();
var logConfiguration = new LoggingConfiguration();
var now = DateTime.Now;
var logfile = new FileTarget {
FileName = $"generated-{now:yyyyMMddHHmmss}.log"
};
var logconsole = new ConsoleTarget();
logConfiguration.AddRule(LogLevel.Info, LogLevel.Fatal, logconsole);
logConfiguration.AddRule(LogLevel.Debug, LogLevel.Fatal, logfile);
LogManager.Configuration = logConfiguration;
var logger = LogManager.GetCurrentClassLogger();
logger.Log(LogLevel.Info, $"Waiting {secondsToWait}s for database startup...");
await Task.Delay(TimeSpan.FromSeconds(secondsToWait));
logger.Log(LogLevel.Info, "To quit the application, press [CTRL]+[C]");
logger.Log(LogLevel.Info, $"Connecting to {databaseServer}; Database name {databaseName}; User: {username}");
using (var dbcontext = new ProductDbContext(databaseServer, databaseName, username, password))
{
dbcontext.Database.Migrate();
var timeoutLoopTask = TimeoutLoop(checkInterval, cancellationTokenSource);
var fetchLoopTask = FetchLoop(topAmount, TimeSpan.FromMilliseconds(minutesToInclude), dbcontext, cancellationTokenSource);
var inputLoopTask = InputLoopAsync(cancellationTokenSource);
Task.WaitAll(timeoutLoopTask, fetchLoopTask, inputLoopTask);
}
return(0);
}
public void GetDiamondImports()
{
var tokens = ODataClientHelper.GetServerPaging(ProductServiceRootUrl + "DiamondImports");
Assert.AreEqual(2, tokens.Count);
var imports = default(IList<ProductDiamondImport>);
using (var db = new ProductDbContext())
{
imports = db.DiamondImports.ToArray();
}
CompareCollection(imports, tokens, Compare);
}
public Product UpdateProductById(int productIdToEdit, Product productEditValues)
{
using (var db = new ProductDbContext())
{
var productToEdit = db.Products.First(product => product.ProductId == productIdToEdit);
productToEdit.Price = productEditValues.Price;
productToEdit.Name = productEditValues.Name;
db.Products.Update(productToEdit);
db.SaveChanges();
return(productToEdit);
}
}
public TransactionsController(ILogger <TransactionsController> logger,
ProductDbContext dbContext,
CancellationTaskRabbitMqMessageSender messageSender,
IdentityGenerator generator,
IConfiguration configuration)
{
Logger = logger;
DbContext = dbContext;
MessageSender = messageSender;
Generator = generator;
Configuration = configuration;
}
public ProductUnitTestDb()
{
scope = new TransactionScope(TransactionScopeOption.Required,
new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted },
TransactionScopeAsyncFlowOption.Enabled);
productDbContext = new ProductDbContext(ConnectionString);
factoryMock = new Mock<IDBContextFactory>();
productRepo = new ProductRepo(factoryMock.Object);
factoryMock.Setup(o => o.createDbContext<IProductDbContext>(It.IsAny<String>()))
.Returns(productDbContext);
}
public List <Product> GetAllProduct()
{
try
{
pro = new ProductDbContext();
}
catch (Exception ex)
{
string r = ex.Message;
}
return(pro.Products.ToList());
}
public ProductDbContext CreateContextForSqlServer()
{
var connection = new SqlConnection("Data Source=(localdb)\\mssqlLocaldb;Initial Catalog=EcommerceDbTest;Integrated Security=True;Pooling=False");
connection.Open();
var option = new DbContextOptionsBuilder <ProductDbContext>().UseSqlServer(connection).Options;
var context = new ProductDbContext(option);
return(context);
}
private static async Task SeedData(ProductDbContext dbContext)
{
var categoryBlue = new Category
{
Name = "Blue",
Description = "This is the Blue Category"
};
var categoryRed = new Category
{
Name = "Red",
Description = "This is the Red Category"
};
var productRed1 = new Product
{
Name = "Product Red 1",
Description = "This is the Product Red 1",
Image = "This is the Image for Product Red 1",
Price = 333.33m,
Category = categoryRed
};
var productRed2 = new Product
{
Name = "Product Red 2",
Description = "This is the Product Red 2",
Image = "This is the Image for Product Red 2",
Price = 444.44m,
Category = categoryRed
};
var productBlue1 = new Product
{
Name = "Product Blue 1",
Description = "This is the Product Blue 1",
Image = "This is the Image for Product Blue 1",
Price = 222.22m,
Category = categoryBlue
};
await dbContext.Categories.AddAsync(categoryRed);
await dbContext.Categories.AddAsync(categoryBlue);
await dbContext.Products.AddAsync(productRed1);
await dbContext.Products.AddAsync(productRed2);
await dbContext.Products.AddAsync(productBlue1);
await dbContext.SaveChangesAsync();
}
/// <summary>
/// 更新商品库存，并返回商品售卖简要信息
/// </summary>
/// <param name="transIdentity">分布式事务标识</param>
/// <param name="buyItems">购买的商品精简信息</param>
/// <returns></returns>
public List <SellProductDto> UpdateProductOnhand(string transIdentity, IEnumerable <BuyProductDto> buyItems)
{
ProductDbContext context = new ProductDbContext();
DTController controller = new DTController(transIdentity);
return(controller.DistTrans3PCRequest <List <SellProductDto> >(DTS_Proxy,
context.CurrentDataBase,
c =>
{
return InnerUpdateProductOnhand(context, buyItems);
}));
}
public ProductListWidgetService(IWidgetBasePartService widgetService,
IProductService productService,
IProductCategoryService productCategoryService,
IApplicationContext applicationContext,
IPageService pageService,
ProductDbContext dbContext)
: base(widgetService, applicationContext, dbContext)
{
_productService = productService;
_productCategoryService = productCategoryService;
_pageService = pageService;
}
public void Init()
{
var options = new DbContextOptionsBuilder <ProductDbContext>()
.UseInMemoryDatabase(databaseName: "Product_Context_Mock")
.Options;
_productDbContext = new ProductDbContext(options);
// TODO: move db helper in Web.API to this project after Web.API have been refactored to use persistence db
_productDbContext.EnsureDbSeeded();
_productService = new ProductService(_productDbContext);
}
private void CreateProducts(ProductDbContext db)
{
for (int i = 1; i < 11; i++)
{
db.ProductDtos.Add(new ProductDto()
{
Id = i, Name = Guid.NewGuid().ToString(), Inventory = i + 5, Price = (decimal)(i * 3.14)
});
}
db.SaveChanges();
}
public int Update(Product product)
{
using (ProductDbContext _db = new ProductDbContext())
{
Product p = _db.Products.First(e => e.ID == product.ID);
p.Name = product.Name;
p.Price = product.Price;
p.Description = product.Description;
_db.Entry <Product>(p).State = System.Data.Entity.EntityState.Modified;
return(_db.SaveChanges());
}
}
public static void Seed(ProductDbContext context)
{
for (int s = 0; s < 10; s++)
{
var c1 = new Category()
{
Name = "商品" + s.ToString(),
SortCode = s.ToString()
};
context.Categorys.Add(c1);
}
context.SaveChanges();
}
public void TestDeleteProductOptionOK()
{
using (var context = new ProductDbContext(builder.Options))
{
SetUpTestData(context);
IProductOptionRepository productOptionRepository = new ProductOptionRepository(context);
productOptionRepository.DeleteAsync(productOptions[0]);
var currentProductOptions = productOptionRepository.GetProductOptions();
currentProductOptions.Result.Should().BeEmpty();
context.Database.EnsureDeleted();
}
}
static void Main(string[] args)
{
using ProductDbContext context = new ProductDbContext();
IProductRepository repository = new ProductRepository(context);
var categoryies = repository.GetAllCategories();
foreach (var category in categoryies)
{
var products = repository.GetProducts(category);
Console.WriteLine($"{category.Name}:{products.Count}");
}
}
public Recommender(
// PredictionEnginePool<CourseRatingMl, RatingPrediction> predictionEnginePool,
ProductDbContext dbContext, MLContext mlContext, ModelHolder modelHolder)
{
// _predictionEnginePool = predictionEnginePool;
_dbContext = dbContext;
_mlContext = mlContext;
_modelHolder = modelHolder;
maxRating = 5.0;
maxAttempts = 3;
coursesPerAttempt = 52;
requiredCourses = 5;
}
/// <inheritdoc/>
public void DeleteProduct(int id)
{
using (var context = new ProductDbContext())
{
var targetProduct = context.Products.FirstOrDefault(p => p.Id == id);
if (targetProduct != null)
{
context.Products.Remove(targetProduct);
context.SaveChanges();
}
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
var id = Guid.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString());
using (var context = new ProductDbContext())
{
//删除这条记录
var delProduct = context.Products.Find(id);
context.Products.Remove(delProduct);
context.SaveChanges();
}
_getData();
}
public Product GetProduct(int id)
{
using (ProductDbContext db = new ProductDbContext())
{
if (db.Products.Find(id) == null)
{
return(null);
}
else
{
return(db.Products.Find(id));
}
}
}
private void CreateProducts(ProductDbContext dbContext)
{
for (int i = 1; i <= 10; i++)
{
dbContext.Products.Add(new Product()
{
Id = i,
Name = Guid.NewGuid().ToString(),
Inventory = i + 10,
Price = (decimal)(i * 31.3)
});
dbContext.SaveChanges();
}
}
public ProductDbContext CreateContextForInMemory()
{
var option = new DbContextOptionsBuilder <ProductDbContext>().UseInMemoryDatabase(databaseName: "Test_Database").Options;
var context = new ProductDbContext(option);
if (context != null)
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
}
return(context);
}
public void AddToDb(Product product)
{
using (var db = new ProductDbContext())
{
if (product != null)
{
if (!db.Products.Any(p => p.Code.Equals(product.Code)))
{
db.Products.Add(product);
db.SaveChanges();
}
}
}
}
public void GetDiamondProperty()
{
var diamond = default(ProductDiamond);
using (var db = new ProductDbContext())
{
diamond = db.Diamonds.First();
}
var token = ODataClientHelper.InvokeGet(string.Format("{0}Diamonds({1})/Cost", ProductServiceRootUrl, diamond.Id));
Assert.AreEqual(diamond.Cost, (decimal)token);
}
