Models.Employee.ItemModel IEmployeesHelper.GetEmptyItem()
{
var itemModel = new Models.Employee.ItemModel();
var shops = _employeeRepository.DictShops
.Select(x => x)
.ToList();
var quanList = new List <items_quantity>();
foreach (var item in shops)
{
var q = new items_quantity();
q.Id_Shop = item.Id;
q.Quantity = 0;
q.Shop = item;
quanList.Add(q);
}
itemModel.Quantity = quanList;
itemModel.DetailsItem = new List <string>();
return(itemModel);
}
/// <summary>
/// Dane inicializujące podczas tworzenia bazy danych
/// </summary>
/// <param name="context">Zmienna bazowa</param>
protected override void Seed(EFDbContext context)
{
var tablePath = AppDomain.CurrentDomain.BaseDirectory.Split(new string[] { "SportStore.Web" }, StringSplitOptions.RemoveEmptyEntries);
string path = tablePath[0] + @"/SportStore.Domain/SqlFiles/Initialization";
var sqlFiles = Directory.GetFiles(path, "*.sql");
foreach (var file in sqlFiles)
{
context.Database.ExecuteSqlCommand(File.ReadAllText(file));
}
//zdjęcia
path = tablePath[0] + @"/SportStore.Domain/SqlFiles/Pictures";
var imageFiles = Directory.GetFiles(path, "*.jpg");
int iterator = 0;
for (int i = 0; i < 11; i++)
{
for (int j = 0; j < 3; j++)
{
var image = new items_picutures
{
Id_Item = (i + 1),
PictureData = HelperClass.Img2Byte(imageFiles[iterator]),
PictureMimeType = "picture/jpeg"
};
iterator++;
context.ItemsPictures.Add(image);
}
}
var random = new Random();
//ilosc itemów w sklepach
for (int i = 1; i <= 5; i++)
{
for (int j = 1; j <= 11; j++)
{
var quantity = new items_quantity
{
Id_Shop = i,
Id_Item = j,
Quantity = random.Next(1, 50)
};
context.ItemsQuantity.Add(quantity);
}
}
context.SaveChanges();
}
