public void ParseCategories(ProductShopContext ctx)
{
var categories = FileOperations.ParseCategories(Constants.CategoryXml);
var products = ctx.Products.ToArray();
int i = 0;
foreach (var c in categories)
{
c.Id = i++;
int rndNumberOfProducts = random.Next(5, 20);
for (int j = 0; j < rndNumberOfProducts; j++)
{
var rndProduct = products[random.Next(0, products.Length - 1)];
if (!c.Products.Contains(rndProduct))
{
c.Products.Add(rndProduct);
}
else
{
j--;
}
}
ctx.Categories.Add(c);
}
DbOperationExtentions.ExecTranOnContext(ctx, "Could not add categories.");
}
private void ParseProducts()
{
var products = FileOperations.DeserializeJson <Product>(Constants.ProductJson);
var users = context.Users.ToArray();
var categories = context.Categories.ToArray();
int categoriesCount = context.Categories.Count();
int i = 0;
foreach (var p in products)
{
p.Id = i++;
p.Seller = users[random.Next(0, users.Length - 1)];
if (random.Next() % 2 == 0)
{
p.Buyer = users[random.Next(0, users.Length - 1)];
}
int rndCategoryCount = random.Next(0, categoriesCount - 1);
for (int j = 0; j < rndCategoryCount; j++)
{
var rndCategory = categories[random.Next(0, categoriesCount - 1)];
if (!p.Categories.Contains(rndCategory))
{
p.Categories.Add(rndCategory);
}
}
this.context.Products.Add(p);
}
DbOperationExtentions.ExecTranOnContext(this.context, "Could not add products.");
}
private void ParseCars()
{
var cars = FileOperations.DeserializeJson <Car>(Constants.CarJson);
var parts = this.context.Parts.ToArray();
int i = 0;
foreach (var c in cars)
{
c.Id = i++;
int rndNumberOfParts = random.Next(10, 20);
for (int j = 0; j < rndNumberOfParts; j++)
{
var rndPart = parts[random.Next(0, parts.Length - 1)];
if (!c.Parts.Contains(rndPart))
{
c.Parts.Add(rndPart);
}
else
{
j--;
}
}
this.context.Cars.Add(c);
}
DbOperationExtentions.ExecTranOnContext(this.context, "Could not add cars");
}
public void ParseUsers(ProductShopContext ctx)
{
var users = FileOperations.ParseUsers(Constants.UserXml);
int i = 0;
foreach (var u in users)
{
u.Id = i++;
ctx.Users.Add(u);
}
DbOperationExtentions.ExecTranOnContext(ctx, "Could not add users.");
}
private void ParseSuppliers()
{
var suppliers = FileOperations.DeserializeJson <Supplier>(Constants.SupplierJson);
int i = 0;
foreach (var s in suppliers)
{
s.Id = i++;
this.context.Supliers.Add(s);
}
DbOperationExtentions.ExecTranOnContext(this.context, "Could not add suppliers");
}
private void ParseCustomers()
{
var customers = FileOperations.DeserializeJson <Customer>(Constants.CustomerJson);
int i = 0;
foreach (var c in customers)
{
c.Id = i++;
this.context.Customers.Add(c);
}
DbOperationExtentions.ExecTranOnContext(this.context, "Could not add customers");
}
private void ParseUsers()
{
var users = FileOperations.DeserializeJson <User>(Constants.UserJson);
int i = 0;
foreach (var u in users)
{
u.Id = i++;
this.context.Users.Add(u);
}
DbOperationExtentions.ExecTranOnContext(this.context, "Could not add users.");
}
private void ParseCategories()
{
var categories = FileOperations.DeserializeJson <Category>(Constants.CategoryJson);
int i = 0;
foreach (var c in categories)
{
c.Id = i++;
this.context.Categories.Add(c);
}
DbOperationExtentions.ExecTranOnContext(this.context, "Could not add categories.");
}
private void ParseCustomers(CarDealerContext ctx)
{
var customers = FileOperations.ParseCustomers(Constants.CustomerXml);
int i = 0;
foreach (var c in customers)
{
c.Id = i++;
ctx.Customers.Add(c);
}
DbOperationExtentions.ExecTranOnContext(ctx, "Could not parse customers.");
}
private void ParseSuppliers(CarDealerContext ctx)
{
var suppliers = FileOperations.ParseSuppliers(Constants.SupplierXml);
int i = 0;
foreach (var s in suppliers)
{
s.Id = i++;
ctx.Suppliers.Add(s);
}
DbOperationExtentions.ExecTranOnContext(ctx, "Could not parse suppliers.");
}
private void ParseParts()
{
var parts = FileOperations.DeserializeJson <Part>(Constants.PartJson);
var suppliers = this.context.Supliers.ToArray();
int i = 0;
foreach (var p in parts)
{
p.Id = i++;
p.Supplier = suppliers[random.Next(0, suppliers.Length - 1)];
this.context.Parts.Add(p);
}
DbOperationExtentions.ExecTranOnContext(this.context, "Could not add parts");
}
private void ParseParts(CarDealerContext ctx)
{
var parts = FileOperations.ParseParts(Constants.PartsXml);
var suppliers = ctx.Suppliers.ToArray();
int i = 0;
foreach (var p in parts)
{
p.Id = i++;
p.Supplier = suppliers[random.Next(0, suppliers.Length - 1)];
ctx.Parts.Add(p);
}
DbOperationExtentions.ExecTranOnContext(ctx, "Could not parse suppliers.");
}
private void ParseSales()
{
var sales = new Sale[random.Next(50, 200)];
var cars = this.context.Cars.ToArray();
var customers = this.context.Customers.ToArray();
decimal[] discountRanges = { 0m, 0.05m, 0.10m, 0.15m, 0.20m, 0.30m, 0.40m, 0.50m };
for (int i = 0; i < sales.Length; i++)
{
sales[i] = new Sale();
var s = sales[i];
s.Id = i++;
s.Car = cars[random.Next(0, cars.Length - 1)];
s.Customer = customers[random.Next(0, customers.Length - 1)];
s.Discount = discountRanges[random.Next(0, discountRanges.Length - 1)];
this.context.Sales.Add(s);
}
DbOperationExtentions.ExecTranOnContext(this.context, "Could not add sales");
}
private void ParseSales(CarDealerContext ctx)
{
int saleCount = 500;
var cars = ctx.Cars.ToArray();
var customers = ctx.Customers.ToArray();
decimal[] discountRanges = { 0m, 0.5m, 0.10m, 0.15m, 0.20m, 0.30m, 0.40m, 0.50m };
for (int i = 0; i < saleCount; i++)
{
var s = new Sale();
s.Id = i;
s.Car = cars[random.Next(0, cars.Length - 1)];
s.Customer = customers[random.Next(0, customers.Length - 1)];
s.Discount = discountRanges[random.Next(0, discountRanges.Length - 1)];
ctx.Sales.Add(s);
}
DbOperationExtentions.ExecTranOnContext(ctx, "Could not parse sales.");
}
public void ParseProducts(ProductShopContext ctx)
{
var products = FileOperations.ParseProducts(Constants.ProductXml);
var users = ctx.Users.ToArray();
int i = 0;
foreach (var p in products)
{
p.Id = i++;
p.Seller = users[random.Next(0, users.Length - 1)];
if (random.Next() % 2 == 0)
{
p.Buyer = users[random.Next(0, users.Length - 1)];
}
ctx.Products.Add(p);
}
DbOperationExtentions.ExecTranOnContext(ctx, "Could not add products.");
}
private void ParseCars(CarDealerContext ctx)
{
var cars = FileOperations.ParseCars(Constants.CarXml);
var parts = ctx.Parts.ToArray();
int i = 0;
foreach (var c in cars)
{
c.Id = i++;
int rndCarCount = random.Next(10, 20);
for (int j = 0; j < rndCarCount; j++)
{
var rndPart = parts[random.Next(0, parts.Length - 1)];
c.Parts.Add(rndPart);
}
ctx.Cars.Add(c);
}
DbOperationExtentions.ExecTranOnContext(ctx, "Could not parse cars.");
}
