public static void Initialize(AppDataBaseContext context)
{
#region единицы измерения unitsDemo х8
UnitGoodObjectModel[] unitsDemo = new UnitGoodObjectModel[]
{
new UnitGoodObjectModel {
Name = "шт.", Information = "Штука"
},
new UnitGoodObjectModel {
Name = "м.", Information = "Метр"
},
new UnitGoodObjectModel {
Name = "гр.", Information = "Грамм"
},
new UnitGoodObjectModel {
Name = "уп.5шт.", Information = "Упаковка 5 штук"
},
new UnitGoodObjectModel {
Name = "500гр.", Information = "Фасовка 500гр."
},
new UnitGoodObjectModel {
Name = "1000гр.", Information = "Фасовка 1000гр."
},
new UnitGoodObjectModel {
Name = "300гр.", Information = "Фасовка 300гр."
},
new UnitGoodObjectModel {
Name = "кмпл.", Information = "Комплект"
}
};
if (!context.Units.Any())
{
context.Units.AddRange(unitsDemo);
context.SaveChanges();
}
#endregion
#region группы номенклатуры groupGoodsDemo x3
GroupGoodsObjectModel[] groupGoodsDemo = new GroupGoodsObjectModel[]
{
new GroupGoodsObjectModel {
Name = "Посуда"
},
new GroupGoodsObjectModel {
Name = "Одежда/Обувь"
},
new GroupGoodsObjectModel {
Name = "Бакалея"
}
};
if (!context.GroupsGoods.Any())
{
context.GroupsGoods.AddRange(groupGoodsDemo);
context.SaveChanges();
}
#endregion
#region номенклатура goodsDemo x22
GoodObjectModel[] goodsDemo = new GoodObjectModel[]
{
new GoodObjectModel {
Name = "Тарелка", Price = 200, Group = groupGoodsDemo[0], Unit = unitsDemo[3]
},
new GoodObjectModel {
Name = "Кружка", Price = 0, Group = groupGoodsDemo[0], Unit = unitsDemo[0]
},
new GoodObjectModel {
Name = "Чайник", Price = 2200, Group = groupGoodsDemo[0], Unit = unitsDemo[0]
},
new GoodObjectModel {
Name = "Кофта", Price = 3800, Group = groupGoodsDemo[1], Unit = unitsDemo[0]
},
new GoodObjectModel {
Name = "Шорты", Price = 2500, Group = groupGoodsDemo[1], Unit = unitsDemo[0]
},
new GoodObjectModel {
Name = "Носки", Price = 0, Group = groupGoodsDemo[1], Unit = unitsDemo[7]
},
new GoodObjectModel {
Name = "Куртка", Price = 6400, Group = groupGoodsDemo[1], Unit = unitsDemo[0]
},
new GoodObjectModel {
Name = "Варежки", Price = 1350, Group = groupGoodsDemo[1], Unit = unitsDemo[7]
},
new GoodObjectModel {
Name = "Лента (отрез)", Price = 50, Group = groupGoodsDemo[1], Unit = unitsDemo[1]
},
new GoodObjectModel {
Name = "Мука", Price = 45, Group = groupGoodsDemo[2], Unit = unitsDemo[4]
},
new GoodObjectModel {
Name = "Гречка", Price = 87, Group = groupGoodsDemo[2], Unit = unitsDemo[4]
},
new GoodObjectModel {
Name = "Овсянка", Price = 64, Group = groupGoodsDemo[2], Unit = unitsDemo[6]
},
new GoodObjectModel {
Name = "Рис", Price = 0, Group = groupGoodsDemo[2], Unit = unitsDemo[4]
},
new GoodObjectModel {
Name = "Горох", Price = 134, Group = groupGoodsDemo[2], Unit = unitsDemo[5]
},
new GoodObjectModel {
Name = "Фасоль", Price = 200, Group = groupGoodsDemo[2], Unit = unitsDemo[4]
},
new GoodObjectModel {
Name = "Чечевица", Price = 87, Group = groupGoodsDemo[2], Unit = unitsDemo[5]
},
new GoodObjectModel {
Name = "Лапша", Price = 100, Group = groupGoodsDemo[2], Unit = unitsDemo[5]
},
new GoodObjectModel {
Name = "Кетчуп", Price = 280, Group = groupGoodsDemo[2], Unit = unitsDemo[4]
},
new GoodObjectModel {
Name = "Майонез", Price = 0, Group = groupGoodsDemo[2], Unit = unitsDemo[6]
},
new GoodObjectModel {
Name = "Сахар", Price = 76, Group = groupGoodsDemo[2], Unit = unitsDemo[5]
},
new GoodObjectModel {
Name = "Соль", Price = 64, Group = groupGoodsDemo[2], Unit = unitsDemo[6]
},
new GoodObjectModel {
Name = "Сода", Price = 165, Group = groupGoodsDemo[2], Unit = unitsDemo[6]
}
};
if (!context.Goods.Any())
{
context.Goods.AddRange(goodsDemo);
context.SaveChanges();
}
#endregion
#region пользователи x17 / департаменты x7
if (!context.Departments.Any())
{
context.Departments.AddRange(
new DepartmentObjectModel {
Name = "user", isReadonly = true
},
new DepartmentObjectModel {
Name = "Хозяйственный блок"
},
new DepartmentObjectModel {
Name = "Снабженцы"
},
new DepartmentObjectModel {
Name = "Секретариат"
},
new DepartmentObjectModel {
Name = "Производство"
},
new DepartmentObjectModel {
Name = "Бухгалтерия"
},
new DepartmentObjectModel {
Name = "ИТ"
});
context.SaveChanges();
}
if (!context.Users.Any())
{
string demoPass = glob_tools.GetHashString("demo");
context.Users.AddRange(
new UserObjectModel {
Name = "system", DepartmentId = 1, Role = AccessLevelUserRolesEnum.Auth, Email = "*", Password = "******", LastWebVisit = DateTime.MaxValue, isReadonly = true, isGlobalFavorite = true, Information = "Системная учётная запись"
},
new UserObjectModel {
Name = "Иванова И", DepartmentId = 2, Role = AccessLevelUserRolesEnum.Verified, Email = "verified", Password = demoPass
},
new UserObjectModel {
Name = "Петрова П", DepartmentId = 2, Role = AccessLevelUserRolesEnum.Verified, Email = "demo1", Password = demoPass
},
new UserObjectModel {
Name = "Сидоров С", DepartmentId = 2, Role = AccessLevelUserRolesEnum.Verified, Email = "demo2", Password = demoPass
},
new UserObjectModel {
Name = "Ромашкин Р", DepartmentId = 2, Role = AccessLevelUserRolesEnum.Verified, Email = "demo3", Password = demoPass
},
new UserObjectModel {
Name = "Кузнецов К", DepartmentId = 4, Role = AccessLevelUserRolesEnum.Privileged, Email = "privileged", Password = demoPass
},
new UserObjectModel {
Name = "Зайцев З", DepartmentId = 4, Role = AccessLevelUserRolesEnum.Privileged, Email = "demo4", Password = demoPass
},
new UserObjectModel {
Name = "Новиков Н", DepartmentId = 4, Role = AccessLevelUserRolesEnum.Privileged, Email = "demo5", Password = demoPass
},
new UserObjectModel {
Name = "Морозов М", DepartmentId = 4, Role = AccessLevelUserRolesEnum.Privileged, Email = "demo6", Password = demoPass
},
new UserObjectModel {
Name = "Волков В", DepartmentId = 5, Role = AccessLevelUserRolesEnum.Privileged, Email = "manager", Password = demoPass
},
new UserObjectModel {
Name = "Голубев Г", DepartmentId = 5, Role = AccessLevelUserRolesEnum.Manager, Email = "demo7", Password = demoPass
},
new UserObjectModel {
Name = "Богданов Б", DepartmentId = 5, Role = AccessLevelUserRolesEnum.Privileged, Email = "demo8", Password = demoPass
},
new UserObjectModel {
Name = "Фёдоров Ф", DepartmentId = 5, Role = AccessLevelUserRolesEnum.Manager, Email = "demo9", Password = demoPass
},
new UserObjectModel {
Name = "Тарасов Т", DepartmentId = 6, Role = AccessLevelUserRolesEnum.Admin, Email = "demo10", Password = demoPass
},
new UserObjectModel {
Name = "Егоров Е", DepartmentId = 6, Role = AccessLevelUserRolesEnum.Admin, Email = "demo11", Password = demoPass
},
new UserObjectModel {
Name = "Орлов О", DepartmentId = 6, Role = AccessLevelUserRolesEnum.Admin, Email = "admin", Password = demoPass
},
new UserObjectModel {
Name = "Абрамович А", DepartmentId = 7, Role = AccessLevelUserRolesEnum.ROOT, Email = "root", Password = demoPass
});
context.SaveChanges();
}
#endregion
#region склады количественного учёта номенклатуры warehousesDemo x3
WarehouseObjectModel[] warehousesDemo = new WarehouseObjectModel[]
{
new WarehouseObjectModel()
{
Name = "Центральный склад"
},
new WarehouseObjectModel()
{
Name = "К доставке"
},
new WarehouseObjectModel()
{
Name = "Магазин"
}
};
if (!context.Warehouses.Any())
{
context.Warehouses.AddRange(warehousesDemo);
context.SaveChanges();
}
#endregion
#region документы поступления на склад x14
if (!context.ReceiptesGoodsToWarehousesDocuments.Any())
{
ReceiptToWarehouseDocumentModel[] warehouseReceipts = new ReceiptToWarehouseDocumentModel[]
{
new ReceiptToWarehouseDocumentModel()
{
AuthorId = 3, Name = "demo поступление на склад 14", Information = "demo пополнение 14. склад: " + warehousesDemo[2].Name, WarehouseReceipt = warehousesDemo[2]
},
new ReceiptToWarehouseDocumentModel()
{
AuthorId = 2, Name = "demo поступление на склад 13", Information = "demo пополнение 13. склад: " + warehousesDemo[0].Name, WarehouseReceipt = warehousesDemo[0]
},
new ReceiptToWarehouseDocumentModel()
{
AuthorId = 1, Name = "demo поступление на склад 12", Information = "demo пополнение 12. склад: " + warehousesDemo[1].Name, WarehouseReceipt = warehousesDemo[1]
},
new ReceiptToWarehouseDocumentModel()
{
AuthorId = 1, Name = "demo поступление на склад 11", Information = "demo пополнение 11. склад: " + warehousesDemo[2].Name, WarehouseReceipt = warehousesDemo[2]
},
new ReceiptToWarehouseDocumentModel()
{
AuthorId = 3, Name = "demo поступление на склад 10", Information = "demo пополнение 10. склад: " + warehousesDemo[1].Name, WarehouseReceipt = warehousesDemo[1]
},
new ReceiptToWarehouseDocumentModel()
{
AuthorId = 1, Name = "demo поступление на склад 9", Information = "demo пополнение 9. склад: " + warehousesDemo[0].Name, WarehouseReceipt = warehousesDemo[0]
},
new ReceiptToWarehouseDocumentModel()
{
AuthorId = 2, Name = "demo поступление на склад 8", Information = "demo пополнение 8. склад: " + warehousesDemo[1].Name, WarehouseReceipt = warehousesDemo[1]
},
new ReceiptToWarehouseDocumentModel()
{
AuthorId = 3, Name = "demo поступление на склад 7", Information = "demo пополнение 7. склад: " + warehousesDemo[2].Name, WarehouseReceipt = warehousesDemo[2]
},
new ReceiptToWarehouseDocumentModel()
{
AuthorId = 2, Name = "demo поступление на склад 6", Information = "demo пополнение 6. склад: " + warehousesDemo[0].Name, WarehouseReceipt = warehousesDemo[0]
},
new ReceiptToWarehouseDocumentModel()
{
AuthorId = 1, Name = "demo поступление на склад 5", Information = "demo пополнение 5. склад: " + warehousesDemo[0].Name, WarehouseReceipt = warehousesDemo[0]
},
new ReceiptToWarehouseDocumentModel()
{
AuthorId = 3, Name = "demo поступление на склад 4", Information = "demo пополнение 4. склад: " + warehousesDemo[2].Name, WarehouseReceipt = warehousesDemo[2]
},
new ReceiptToWarehouseDocumentModel()
{
AuthorId = 2, Name = "demo поступление на склад 3", Information = "demo пополнение 3. склад: " + warehousesDemo[2].Name, WarehouseReceipt = warehousesDemo[2]
},
new ReceiptToWarehouseDocumentModel()
{
AuthorId = 1, Name = "demo поступление на склад 2", Information = "demo пополнение 2. склад: " + warehousesDemo[1].Name, WarehouseReceipt = warehousesDemo[1]
},
new ReceiptToWarehouseDocumentModel()
{
AuthorId = 2, Name = "demo поступление на склад 1", Information = "demo пополнение 1. склад: " + warehousesDemo[1].Name, WarehouseReceipt = warehousesDemo[1]
}
};
context.ReceiptesGoodsToWarehousesDocuments.AddRange(warehouseReceipts);
context.SaveChanges();
//context.GoodMovementDocumentRows.AddRange(new RowGoodMovementRegisterModel[] // goodsDemo[0 7 19]
//{
RowGoodMovementRegisterModel[] rows = new RowGoodMovementRegisterModel[]
{
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 1, GoodId = goodsDemo[0].Id, Quantity = 22, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 1, GoodId = goodsDemo[7].Id, Quantity = 28, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 1, GoodId = goodsDemo[17].Id, Quantity = 14, UnitId = 3
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 2, GoodId = goodsDemo[19].Id, Quantity = 25, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 2, GoodId = goodsDemo[0].Id, Quantity = 23, UnitId = 3
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 2, GoodId = goodsDemo[7].Id, Quantity = 25, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 3, GoodId = goodsDemo[7].Id, Quantity = 13, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 3, GoodId = goodsDemo[0].Id, Quantity = 24, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 3, GoodId = goodsDemo[19].Id, Quantity = 12, UnitId = 3
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 4, GoodId = goodsDemo[7].Id, Quantity = 23, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 4, GoodId = goodsDemo[19].Id, Quantity = 25, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 4, GoodId = goodsDemo[7].Id, Quantity = 12, UnitId = 3
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 5, GoodId = goodsDemo[0].Id, Quantity = 23, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 5, GoodId = goodsDemo[7].Id, Quantity = 25, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 5, GoodId = goodsDemo[19].Id, Quantity = 12, UnitId = 3
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 6, GoodId = goodsDemo[19].Id, Quantity = 23, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 6, GoodId = goodsDemo[0].Id, Quantity = 25, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 6, GoodId = goodsDemo[7].Id, Quantity = 12, UnitId = 3
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 7, GoodId = goodsDemo[19].Id, Quantity = 23, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 7, GoodId = goodsDemo[0].Id, Quantity = 25, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 7, GoodId = goodsDemo[7].Id, Quantity = 12, UnitId = 3
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 8, GoodId = goodsDemo[0].Id, Quantity = 23, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 8, GoodId = goodsDemo[7].Id, Quantity = 25, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 8, GoodId = goodsDemo[19].Id, Quantity = 12, UnitId = 3
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 9, GoodId = goodsDemo[7].Id, Quantity = 23, UnitId = 3
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 9, GoodId = goodsDemo[0].Id, Quantity = 25, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 9, GoodId = goodsDemo[19].Id, Quantity = 12, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 10, GoodId = goodsDemo[0].Id, Quantity = 23, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 10, GoodId = goodsDemo[19].Id, Quantity = 25, UnitId = 3
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 10, GoodId = goodsDemo[7].Id, Quantity = 12, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 11, GoodId = goodsDemo[0].Id, Quantity = 23, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 11, GoodId = goodsDemo[7].Id, Quantity = 25, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 11, GoodId = goodsDemo[19].Id, Quantity = 12, UnitId = 3
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 12, GoodId = goodsDemo[7].Id, Quantity = 23, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 12, GoodId = goodsDemo[19].Id, Quantity = 25, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 12, GoodId = goodsDemo[0].Id, Quantity = 12, UnitId = 3
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 13, GoodId = goodsDemo[0].Id, Quantity = 23, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 13, GoodId = goodsDemo[19].Id, Quantity = 25, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 13, GoodId = goodsDemo[7].Id, Quantity = 12, UnitId = 3
}
};
warehouseReceipts[0].RowsDocument = new List <RowGoodMovementRegisterModel>(new RowGoodMovementRegisterModel[] {
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 14, GoodId = goodsDemo[7].Id, Quantity = 23, UnitId = 3
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 14, GoodId = goodsDemo[0].Id, Quantity = 25, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
BodyDocumentId = 14, GoodId = goodsDemo[19].Id, Quantity = 12, UnitId = 1
}
});
//});
context.GoodMovementDocumentRows.AddRange(rows);
context.SaveChanges();
}
#endregion
#region документы внутреннего перемещение номенклатуры (между складами) x7
if (!context.InternalDisplacementWarehouseDocuments.Any())
{
InternalDisplacementWarehouseDocumentModel[] internalDisplacements = new InternalDisplacementWarehouseDocumentModel[]
{
new InternalDisplacementWarehouseDocumentModel()
{
WarehouseDebitingId = warehousesDemo[0].Id, WarehouseReceiptId = warehousesDemo[1].Id, AuthorId = 1, Name = "demo перемещение 7", Information = $"demo внутреннее перемещение 7. [{warehousesDemo[0].Name}] -> [{warehousesDemo[1].Name}]"
},
new InternalDisplacementWarehouseDocumentModel()
{
WarehouseDebitingId = warehousesDemo[1].Id, WarehouseReceiptId = warehousesDemo[2].Id, AuthorId = 2, Name = "demo перемещение 6", Information = $"demo внутреннее перемещение 6. [{warehousesDemo[1].Name}] -> [{warehousesDemo[2].Name}]"
},
new InternalDisplacementWarehouseDocumentModel()
{
WarehouseDebitingId = warehousesDemo[2].Id, WarehouseReceiptId = warehousesDemo[0].Id, AuthorId = 3, Name = "demo перемещение 5", Information = $"demo внутреннее перемещение 5. [{warehousesDemo[2].Name}] -> [{warehousesDemo[0].Name}]"
},
new InternalDisplacementWarehouseDocumentModel()
{
WarehouseDebitingId = warehousesDemo[0].Id, WarehouseReceiptId = warehousesDemo[1].Id, AuthorId = 1, Name = "demo перемещение 4", Information = $"demo внутреннее перемещение 4. [{warehousesDemo[0].Name}] -> [{warehousesDemo[1].Name}]"
},
new InternalDisplacementWarehouseDocumentModel()
{
WarehouseDebitingId = warehousesDemo[1].Id, WarehouseReceiptId = warehousesDemo[2].Id, AuthorId = 3, Name = "demo перемещение 3", Information = $"demo внутреннее перемещение 3. [{warehousesDemo[1].Name}] -> [{warehousesDemo[2].Name}]"
},
new InternalDisplacementWarehouseDocumentModel()
{
WarehouseDebitingId = warehousesDemo[2].Id, WarehouseReceiptId = warehousesDemo[0].Id, AuthorId = 2, Name = "demo перемещение 2", Information = $"demo внутреннее перемещение 2. [{warehousesDemo[2].Name}] -> [{warehousesDemo[0].Name}]"
},
new InternalDisplacementWarehouseDocumentModel()
{
WarehouseDebitingId = warehousesDemo[0].Id, WarehouseReceiptId = warehousesDemo[1].Id, AuthorId = 1, Name = "demo перемещение 1", Information = $"demo внутреннее перемещение 1. [{warehousesDemo[0].Name}] -> [{warehousesDemo[1].Name}]"
}
};
internalDisplacements[0].RowsDocument = new List <RowGoodMovementRegisterModel>(new RowGoodMovementRegisterModel[]
{
new RowGoodMovementRegisterModel()
{
GoodId = 1, Quantity = 1, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
GoodId = 2, Quantity = 2, UnitId = 2
}
});
internalDisplacements[1].RowsDocument = new List <RowGoodMovementRegisterModel>(new RowGoodMovementRegisterModel[]
{
new RowGoodMovementRegisterModel()
{
GoodId = 2, Quantity = 3, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
GoodId = 1, Quantity = 2, UnitId = 1
}
});
internalDisplacements[2].RowsDocument = new List <RowGoodMovementRegisterModel>(new RowGoodMovementRegisterModel[]
{
new RowGoodMovementRegisterModel()
{
GoodId = 1, Quantity = 4, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
GoodId = 2, Quantity = 3, UnitId = 2
}
});
internalDisplacements[3].RowsDocument = new List <RowGoodMovementRegisterModel>(new RowGoodMovementRegisterModel[]
{
new RowGoodMovementRegisterModel()
{
GoodId = 2, Quantity = 3, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
GoodId = 1, Quantity = 2, UnitId = 1
}
});
internalDisplacements[4].RowsDocument = new List <RowGoodMovementRegisterModel>(new RowGoodMovementRegisterModel[]
{
new RowGoodMovementRegisterModel()
{
GoodId = 1, Quantity = 2, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
GoodId = 2, Quantity = 5, UnitId = 2
}
});
internalDisplacements[5].RowsDocument = new List <RowGoodMovementRegisterModel>(new RowGoodMovementRegisterModel[]
{
new RowGoodMovementRegisterModel()
{
GoodId = 2, Quantity = 3, UnitId = 2
},
new RowGoodMovementRegisterModel()
{
GoodId = 1, Quantity = 2, UnitId = 1
}
});
internalDisplacements[6].RowsDocument = new List <RowGoodMovementRegisterModel>(new RowGoodMovementRegisterModel[]
{
new RowGoodMovementRegisterModel()
{
GoodId = 1, Quantity = 2, UnitId = 1
},
new RowGoodMovementRegisterModel()
{
GoodId = 2, Quantity = 3, UnitId = 2
}
});
context.InternalDisplacementWarehouseDocuments.AddRange(internalDisplacements);
context.SaveChanges();
}
#endregion
#region остатки номенклатуры в контексте складов x
if (!context.InventoryGoodsBalancesWarehouses.Any())
{
context.InventoryGoodsBalancesWarehouses.AddRange(new InventoryBalancesWarehousesAnalyticalModel[]
{
});
context.SaveChanges();
}
#endregion
#region документы отгрузки номенклатуры в доставку x
if (!context.MovementTurnoverDeliveryDocuments.Any())
{
context.MovementTurnoverDeliveryDocuments.AddRange(new MovementTurnoverDeliveryDocumentModel[]
{
});
context.SaveChanges();
}
#endregion
#region остатки номенклатуры в контексте доставки x
if (!context.InventoryGoodsBalancesDeliveries.Any())
{
context.InventoryGoodsBalancesDeliveries.AddRange(new InventoryBalancesDeliveriesAnalyticalModel[]
{
});
context.SaveChanges();
}
#endregion
}
/// <summary>
/// Формирование анономного/динамического объекта: документ-владелец записи регистра.
/// </summary>
/// <param name="document">объект-документ, строки которого представляют записи регистров</param>
/// <param name="context">контекст базы данных</param>
/// <returns>возвращается объект-документ-владелец записи регистра в виде объекта анонимного типа</returns>
public static object getDocument(BodyGoodMovementDocumentModel document, AppDataBaseContext context)
{
switch (document.Discriminator)
{
case nameof(ReceiptToWarehouseDocumentModel):
ReceiptToWarehouseDocumentModel movDocument = context.ReceiptesGoodsToWarehousesDocuments
.Where(x => x.Id == document.Id)
.Include(x => x.WarehouseReceipt)
.FirstOrDefault();
return(new
{
document.DateCreate,
document.Id,
document.Name,
document.Information,
document.Discriminator,
Warehouse = new
{
movDocument.WarehouseReceipt.Id,
movDocument.WarehouseReceipt.Name,
movDocument.WarehouseReceipt.Information
},
Author = new
{
document.Author.Id,
document.Author.Name,
document.Author.Information
}
});
case nameof(InternalDisplacementWarehouseDocumentModel):
InternalDisplacementWarehouseDocumentModel InternalDisplacementWarehouseDocument = context.InternalDisplacementWarehouseDocuments.Include(x => x.Author).Include(x => x.WarehouseReceipt).FirstOrDefault(x => x.Id == document.Id);
WarehouseObjectModel WarehouseDebiting = context.Warehouses.Find(InternalDisplacementWarehouseDocument.WarehouseDebitingId);
return(new
{
document.DateCreate,
author = new { id = document.AuthorId, document.Author.Name },
document.Id,
document.Name,
document.Information,
document.Discriminator,
about = "Поступление на склад",
WarehouseDebiting = new { WarehouseDebiting.Id, WarehouseDebiting.Name },
WarehouseReceipt = new { InternalDisplacementWarehouseDocument.WarehouseReceipt.Id, InternalDisplacementWarehouseDocument.WarehouseReceipt.Name, InternalDisplacementWarehouseDocument.WarehouseReceipt.Information }
});
case nameof(MovementTurnoverDeliveryDocumentModel):
MovementTurnoverDeliveryDocumentModel MovementTurnoverDeliveryDocument = context.MovementTurnoverDeliveryDocuments.Include(x => x.DeliveryService).Include(x => x.DeliveryMethod).Include(x => x.Buyer).FirstOrDefault(x => x.Id == document.Id);
return(new
{
document.DateCreate,
author = new { id = document.AuthorId, document.Author.Name },
document.Id,
document.Name,
document.Information,
document.Discriminator,
about = "Отгрузка/Доставка",
buyer = new
{
MovementTurnoverDeliveryDocument.Buyer?.Id,
MovementTurnoverDeliveryDocument.Buyer?.Name
},
deliveryMethod = new
{
MovementTurnoverDeliveryDocument.DeliveryMethod?.Id,
MovementTurnoverDeliveryDocument.DeliveryMethod?.Name
},
deliveryService = new
{
MovementTurnoverDeliveryDocument.DeliveryService?.Id,
MovementTurnoverDeliveryDocument.DeliveryService?.Name
},
MovementTurnoverDeliveryDocument.DeliveryAddress1,
MovementTurnoverDeliveryDocument.DeliveryAddress2
});
default:
return(new
{
document.Id,
document.Name,
document.Information,
document.Discriminator,
author = new
{
document.Author.Id,
document.Author.Name
}
});
}
}
