public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new CommerceDbContext(
serviceProvider.GetRequiredService <
DbContextOptions <CommerceDbContext> >()))
{
// Look for any thing.
if (context.Users.Any())
{
return; // DB has been seeded
}
if (context.Products.Any())
{
return; // DB has been seeded
}
context.Users.AddRange(
new User
{
Name = "Truong Tien",
Username = "******",
Password = "******"
}
);
context.SaveChanges();
context.Products.AddRange(
new Product
{
Title = "Iphone 11 pro",
Image = "https://res.cloudinary.com/summonersrift/image/upload/v1616489223/Picture/iPhone_11_Pro_Max_256GB_d19ax9.jpg",
Price = 999,
Sale = 799,
Quantity = 1000,
Description = "abc xyz 123"
}
);
context.SaveChanges();
context.Pictures.AddRange(
new Picture
{
IdProduct = 1,
Image = "https://res.cloudinary.com/summonersrift/image/upload/v1616489721/Picture/iPhone_11_Pro_Max_64GB_yrrmiz.jpg",
},
new Picture
{
IdProduct = 1,
Image = "https://res.cloudinary.com/summonersrift/image/upload/v1616489733/Picture/iPhone_11_Pro_Max_512GB_u9udnt.jpg",
}
);
context.SaveChanges();
}
}
public static void Seed(IServiceProvider serviceProvider)
{
using (var context = new CommerceDbContext(serviceProvider.GetRequiredService <DbContextOptions <CommerceDbContext> >()))
{
if (context.Contractors.Count() < 10)
{
for (int i = 0; i < 10000; i++)
{
AddContractors(context);
}
context.SaveChanges();
}
}
}
private static void AddContractors(CommerceDbContext context)
{
Contractor c = new Contractor();
c.FirstName = RandString();
c.LastName = RandString();
c.BankAccountNumber = RandString(15, 15);
c.City = RandString();
c.Country = RandString();
c.Email = RandString() + "@" + RandString(2, 4) + "." + RandString(2, 4);
c.NBRN = RandString(15, 15);
c.Street = RandString();
c.TaxNumber = RandString(9, 9);
context.Add(c);
}
public void Add(CommerceSetting setting)
{
string commerceFolder = this.GetCommercePhysicalFolder(setting.Name);
if (!Directory.Exists(commerceFolder))
{
//Create folder
Directory.CreateDirectory(commerceFolder);
string imagesFolder = this.GetImageFilePhysicalFolder(setting.Name);
string databaseFolder = this.GetDatabaseFilePhysicalFolder(setting.Name);
string[] folders = new string[] { imagesFolder, databaseFolder };
foreach (string path in folders)
{
Directory.CreateDirectory(path);
}
//Create database
if (setting.EnableConnectionString)
{
CommerceDbContext ctx = new CommerceDbContext(setting.ConnectionString);
ctx.Database.Create();
ctx.Dispose();
}
else
{
//SqlCE
setting.DatabaseFilePath = this.GetDatabaseFilePhysicalPath(setting.Name);
CommerceDbContext ctx = new CommerceDbContext(setting.DatabaseFilePath);
ctx.Database.Create();
ctx.Dispose();
}
//Create file:setting.config
string settingFilePath = this.GetSettingFilePhysicalPath(setting.Name);
Serialization.Serialize <CommerceSetting>(setting, settingFilePath);
}
else
{
string message = string.Format("{0} is already exist.".Localize());
throw new ArgumentException(message);
}
}
private static void UseEnsureCreated(CommerceDbContext db)
{
if (db.Database.EnsureCreated())
{
// add some data
db.Products.Add(new Product
{
Description = "il TV",
Price = 1234.56m
});
db.Products.Add(new Product
{
Description = "Dash Button",
Price = 4.99m
});
db.SaveChanges();
}
}
private static void UseMigration(CommerceDbContext db)
{
// Add-Migration InitialCreate
db.Database.Migrate();
// POSSO AGGIUNGERE I DATI COSI' OPPURE ATTRAVERSO UNA MIGRAZIONE
var tv = db.Products.FirstOrDefault(x => x.Description == "il TV");
if (tv == null)
{
db.Products.Add(new Product
{
Description = "il TV",
Price = 1234.56m
});
}
else
{
tv.Price = 1234.56m;
}
var dashButton = db.Products.FirstOrDefault(x => x.Description == "Dash Button");
if (tv == null)
{
db.Products.Add(new Product
{
Description = "Dash Button",
Price = 4.99m
});
}
else
{
dashButton.Price = 4.99m;
}
db.SaveChanges();
}
public SavingDbChanges(CommerceDbContext dbContext)
{
DbContext = dbContext;
}
public ContractorsController(CommerceDbContext dbContext)
{
this.dbContext = dbContext;
}
public ProductService(CommerceDbContext commerceDbContext)
{
_commerceDbContext = commerceDbContext;
}
public CategoryFactory(CommerceDbContext db)
{
_db = db;
}
public ProductImagesHelper(CommerceDbContext commerceDbContext, IHostingEnvironment hostingEnvironment)
{
_commerceDbContext = commerceDbContext;
_hostingEnvironment = hostingEnvironment;
}
public BasketView(CommerceDbContext context, UserManager <ApplicationUser> userManager)
{
_context = context;
_userManager = userManager;
}
public ImageFactory(CommerceDbContext db)
{
_db = db;
}
public HomeController(ILogger <HomeController> logger, CommerceDbContext context)
{
_logger = logger;
_context = context;
}
public IssueTypeController(CommerceDbContext commerceDbContext)
{
this.commerceDbContext = commerceDbContext;
}
public DevIBasket(CommerceDbContext context, IConfiguration configuration)
{
_context = context;
Configuration = configuration;
}
public DevIOrder(CommerceDbContext context, IConfiguration configuration)
{
_context = context;
Configuration = configuration;
}
public CommerceRepository(string connStr)
{
_dbContext = CreateCommerceDbContext(connStr);
}
public OrderController(ILogger <OrderController> logger, CommerceDbContext commerceDbContext)
{
_logger = logger;
_commerceDbContext = commerceDbContext;
_orderRepository = new OrderRepository(_commerceDbContext);
}
public CategoryRepository(CommerceDbContext commerceDbContext)
{
_commerceDbContext = commerceDbContext;
}
public PersonFactory(CommerceDbContext db)
{
_db = db;
}
public SavingDbChanges(CommerceDbContext dbContext)
{
DbContext = dbContext;
}
public CommerceController(CommerceDbContext dbContext)
{
commerceDbContext = dbContext;
}
public OrdersController(CommerceDbContext dbContext, ICurrencyConverter currencyConverter)
{
_dbContext = dbContext;
_currencyConverter = currencyConverter;
}
public HomeController(CommerceDbContext commerceDbContext)
{
this.commerceDbContext = commerceDbContext;
}
public ProductImageRepository(CommerceDbContext commerceDbContext)
{
_commerceDbContext = commerceDbContext;
}
public OrderRepository(CommerceDbContext commerceDbContext)
{
_commerceDbContext = commerceDbContext;
}
public ProductController(ILogger <ProductController> logger, CommerceDbContext commerceDbContext, IHostingEnvironment hostingEnvironment)
{
_logger = logger;
_commerceDbContext = commerceDbContext;
_hostingEnvironment = hostingEnvironment;
}
public ProductsController(CommerceDbContext dbContext)
{
_dbContext = dbContext;
}
public CategoryController(ILogger <CategoryController> logger, CommerceDbContext commerceDbContext)
{
_logger = logger;
_commerceDbContext = commerceDbContext;
repository = new CategoryRepository(_commerceDbContext);
}
public CartService(ILogger <CartService> logger, CommerceDbContext commerceDbContext)
{
_logger = logger;
_commerceDbContext = commerceDbContext;
}
