private void SeedUserSale(BreadingBreadDbContext context)
{
var userSales = new UserSale[]
{
new UserSale
{
IdPath = 1,
IdUser = 1,
Visited = false,
VisitedDate = System.DateTime.Now
},
new UserSale
{
IdPath = 1,
IdUser = 2,
Visited = false,
VisitedDate = System.DateTime.Now.AddDays(-1)
},
new UserSale
{
IdPath = 1,
IdUser = 2,
Visited = true,
VisitedDate = System.DateTime.Now.AddDays(-1)
},
};
foreach (var userSale in userSales)
{
context.UserSale.Add(userSale);
context.SaveChanges();
}
}
private void SeedPathStore(BreadingBreadDbContext context)
{
var pathStores = new PathStore[]
{
new PathStore
{
IdPath = 1,
IdStore = 1
},
new PathStore
{
IdPath = 1,
IdStore = 2
},
new PathStore
{
IdPath = 1,
IdStore = 3
},
new PathStore
{
IdPath = 1,
IdStore = 4
},
new PathStore
{
IdPath = 1,
IdStore = 5
},
new PathStore
{
IdPath = 2,
IdStore = 1
},
new PathStore
{
IdPath = 2,
IdStore = 2
},
new PathStore
{
IdPath = 3,
IdStore = 1
},
};
foreach (var pathStore in pathStores)
{
context.PathStore.Add(pathStore);
context.SaveChanges();
}
}
private void SeedInventory(BreadingBreadDbContext context)
{
var inventories = new Inventory[]
{
new Inventory
{
IdProduct = 1,
IdSaleUser = 1,
InitalCantity = 100
},
new Inventory
{
IdProduct = 2,
IdSaleUser = 1,
InitalCantity = 100
},
new Inventory
{
IdProduct = 3,
IdSaleUser = 1,
InitalCantity = 100
},
new Inventory
{
IdProduct = 4,
IdSaleUser = 1,
InitalCantity = 100
},
new Inventory
{
IdProduct = 1,
IdSaleUser = 2,
InitalCantity = 100
},
new Inventory
{
IdProduct = 1,
IdSaleUser = 2,
InitalCantity = 100
},
};
foreach (var inventory in inventories)
{
context.Inventory.Add(inventory);
context.SaveChanges();
}
}
private void SeedPromotion(BreadingBreadDbContext context)
{
var promotions = new Promotion[]
{
new Promotion
{
IdProducto = 1,
CantitySaleMin = 10,
CantityFree = 1,
Active = true
},
new Promotion
{
IdProducto = 2,
CantitySaleMin = 10,
CantityFree = 1,
Active = false
},
new Promotion
{
IdProducto = 3,
CantitySaleMin = 10,
Discount = 10,
Active = true
},
new Promotion
{
IdProducto = 4,
SaleMin = 300,
Discount = 10,
Active = true
},
new Promotion
{
IdProducto = 5,
SaleMin = 300,
CantityFree = 2,
Active = true
},
};
foreach (var promotion in promotions)
{
context.Promotion.Add(promotion);
context.SaveChanges();
}
}
private void SeedUsuario(BreadingBreadDbContext db)
{
var usuarios = new User[]
{
new User
{
// Id = 1,
UserName = "******",
UserType = Domain.Enums.UserType.Admin,
HashedPassword = "******",
Aproved = true,
TokenConfirmacion = "",
Name = "Nombre APaterno AMaterno Completo",
NormalizedUserName = "******"
},
new User
{
// Id = 2,
UserName = "******",
UserType = Domain.Enums.UserType.User,
HashedPassword = "******",
Aproved = true,
TokenConfirmacion = "",
Name = "Nombre",
NormalizedUserName = "******"
},
new User
{
UserName = "******",
UserType = Domain.Enums.UserType.User,
HashedPassword = "******",
Aproved = false,
TokenConfirmacion = "",
Name = "Usuario2 ",
NormalizedUserName = "******"
},
};
foreach (var usuario in usuarios)
{
db.User.Add(usuario);
db.SaveChanges();
}
}
public void SeedEverything(BreadingBreadDbContext context)
{
context.Database.EnsureCreated();
if (context.User.Any())
{
return; // Db has been seeded
}
SeedUsuario(context);
SeedPaths(context);
SeedStores(context);
SeedProducts(context);
SeedInventory(context);
SeedPromotion(context);
SeedPathStore(context);
SeedUserSale(context);
SeedSale(context);
SeedSaleProduct(context);
}
private void SeedStores(BreadingBreadDbContext context)
{
var stores = new Store[]
{
new Store
{
Name = "La Esquinita",
},
new Store
{
Name = "El atoron",
},
new Store
{
Name = "La tienda de don juan",
},
new Store
{
Name = "Don pancho",
},
new Store
{
Name = "Abuelito del Lson ",
},
new Store
{
Name = "Nieves la Miguel",
},
new Store
{
Name = "El cerro (casa de termy)",
},
};
foreach (var store in stores)
{
context.Store.Add(store);
context.SaveChanges();
}
}
private void SeedPaths(BreadingBreadDbContext context)
{
var paths = new Path[]
{
new Path
{
Name = "Ruta 1",
},
new Path
{
Name = "Ruta 2",
},
new Path
{
Name = "Ruta 3",
},
new Path
{
Name = "Ruta 4",
},
new Path
{
Name = "Ruta 5",
},
new Path
{
Name = "Ruta 6",
},
};
foreach (var path in paths)
{
context.Path.Add(path);
context.SaveChanges();
}
}
private void SeedSaleProduct(BreadingBreadDbContext context)
{
var productSale = new ProductSale[]
{
new ProductSale
{
IdSale = 1,
IdProduct = 1,
Cantity = 10,
UnitPrice = 3,
Total = 30
},
new ProductSale
{
IdSale = 1,
IdProduct = 2,
Cantity = 2,
UnitPrice = 10,
Total = 20,
},
new ProductSale
{
IdSale = 1,
IdProduct = 3,
Cantity = 10,
UnitPrice = 10,
Total = 30,
IdPromo = 1,
ReturnCantity = 2
},
new ProductSale
{
IdSale = 1,
IdProduct = 1,
Cantity = 10,
UnitPrice = 3,
Total = 9.9M,
IdPromo = 2,
Discount = 20.1M,
},
new ProductSale
{
IdSale = 2,
IdProduct = 1,
Cantity = 10,
UnitPrice = 3,
Total = 30
},
new ProductSale
{
IdSale = 3,
IdProduct = 1,
Cantity = 10,
UnitPrice = 3,
Total = 30
},
};
foreach (var sale in productSale)
{
context.ProductSale.Add(sale);
context.SaveChanges();
}
}
public static void Initialize(BreadingBreadDbContext context)
{
var initializer = new BreadingBreadDbInitializer();
initializer.SeedEverything(context);
}
private void SeedProducts(BreadingBreadDbContext context)
{
var products = new Product[]
{
new Product
{
Name = "Baguette",
Price = 8
},
new Product
{
Name = "Bolillo Ch.",
Price = 6
},
new Product
{
Name = "Cuerno",
Price = 7
},
new Product
{
Name = "Marihuano",
Price = (decimal)10.5
},
new Product
{
Name = "Pellizco",
Price = (decimal)9.5
},
new Product
{
Name = "Bolillo Gr.",
Price = 15
},
new Product
{
Name = "Dona",
Price = 8
},
new Product
{
Name = "Pan grande bolillo mamalon",
Price = 15
},
new Product
{
Name = "Concha",
Price = 6
},
new Product
{
Name = "Gollete",
Price = 10
},
new Product
{
Name = "Panquesito",
Price = 7
},
};
foreach (var product in products)
{
context.Product.Add(product);
context.SaveChanges();
}
}
private void SeedSale(BreadingBreadDbContext context)
{
var sales = new Sale[]
{
new Sale
{
IdUserSale = 1,
IdStore = 1,
Total = 20,
Visited = System.DateTime.Now,
Lat = 1.1223,
Lon = -1223.22,
Commentary = ""
},
new Sale
{
IdUserSale = 1,
IdStore = 2,
Total = 30,
Visited = System.DateTime.Now,
Lat = 1.1223,
Lon = -1223.22,
Commentary = ""
},
new Sale
{
IdUserSale = 1,
IdStore = 3,
Total = 30,
Visited = System.DateTime.Now,
Lat = 1.1223,
Lon = -1223.22,
Commentary = ""
},
new Sale
{
IdUserSale = 2,
IdStore = 1,
Total = 20,
Visited = System.DateTime.Now.AddDays(-1),
Lat = 1.1223,
Lon = -1223.22,
Commentary = ""
},
new Sale
{
IdUserSale = 3,
IdStore = 2,
Total = 20,
Visited = System.DateTime.Now.AddDays(-1),
Lat = 1.1223,
Lon = -1223.22,
Commentary = ""
},
};
foreach (var sale in sales)
{
context.Sale.Add(sale);
context.SaveChanges();
}
}