private DBProductPicture GetProductPictureFromReader(IDataReader dataReader)
{
DBProductPicture productPicture = new DBProductPicture();
productPicture.ProductPictureID = NopSqlDataHelper.GetInt(dataReader, "ProductPictureID");
productPicture.ProductID = NopSqlDataHelper.GetInt(dataReader, "ProductID");
productPicture.PictureID = NopSqlDataHelper.GetInt(dataReader, "PictureID");
productPicture.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder");
return productPicture;
}
async Task <int> CreateProductPictures(int maxProductId)
{
int id = 1;
var files = Directory.GetFiles($"sampledata/pictures/bikes", "*.png");
for (int productId = 1; productId < maxProductId; productId++)
{
var productPicture = new DBProductPicture()
{
Id = id.ToString(),
Picture = File.ReadAllBytes(files[Randomize.Next(0, files.Length - 1)]),
ProductId = productId.ToString()
};
await CreateProductPicture(productPicture);
id++;
}
return(id);
}
async Task CreateProductPicture(DBProductPicture productPicture)
{
await CreateDocument(BikesConstants.ProductPictures, JsonConvert.SerializeObject(productPicture));
}
private static ProductPicture DBMapping(DBProductPicture dbItem)
{
if (dbItem == null)
return null;
ProductPicture item = new ProductPicture();
item.ProductPictureID = dbItem.ProductPictureID;
item.ProductID = dbItem.ProductID;
item.PictureID = dbItem.PictureID;
item.DisplayOrder = dbItem.DisplayOrder;
return item;
}
