public static void FillParameters()
{
using (databaseTestEntities entities = new databaseTestEntities())
{
var famInfo1 = entities.F_S_FamilyInfos.Add(new F_S_FamilyInfos()
{
FAMILY_NAME = "Базовая стена", FAMILY_SYMBOL = "ВН_ЖБ_100"
});
var famInfo2 = entities.F_S_FamilyInfos.Add(new F_S_FamilyInfos()
{
FAMILY_NAME = "Базовая стена", FAMILY_SYMBOL = "ВН_ЖБ_140"
});
var famInfo3 = entities.F_S_FamilyInfos.Add(new F_S_FamilyInfos()
{
FAMILY_NAME = "Базовая стена", FAMILY_SYMBOL = "ВН_ЖБ_200"
});
var p1 = entities.F_S_Parameters.Add(new F_S_Parameters()
{
NAME_PARAMETER = "Direction", TYPE_PARAMETER = "Point"
});
var p2 = entities.F_S_Parameters.Add(new F_S_Parameters()
{
NAME_PARAMETER = "Location", TYPE_PARAMETER = "Point"
});
var p3 = entities.F_S_Parameters.Add(new F_S_Parameters()
{
NAME_PARAMETER = "Length", TYPE_PARAMETER = "Double"
});
var p4 = entities.F_S_Parameters.Add(new F_S_Parameters()
{
NAME_PARAMETER = "Height", TYPE_PARAMETER = "Double"
});
var c1 = entities.F_S_Categories.Add(new F_S_Categories()
{
NAME_RUS_CATEGORY = "Стены", NAME_ENG_CATEGORY = ""
});
entities.F_nn_Category_Parameters.Add(new F_nn_Category_Parameters()
{
F_S_Categories = c1, F_S_Parameters = p1
});
entities.F_nn_Category_Parameters.Add(new F_nn_Category_Parameters()
{
F_S_Categories = c1, F_S_Parameters = p2
});
entities.F_nn_Category_Parameters.Add(new F_nn_Category_Parameters()
{
F_S_Categories = c1, F_S_Parameters = p3
});
entities.F_nn_Category_Parameters.Add(new F_nn_Category_Parameters()
{
F_S_Categories = c1, F_S_Parameters = p4
});
entities.SaveChanges();
}
}
public static void FillFlatsModules()
{
using (databaseTestEntities entities = new databaseTestEntities())
{
F_R_Flats flat1 = entities.F_R_Flats.Add(new F_R_Flats()
{
COMMERCIAL_NAME = "", WORKNAME = "Flat1", REVISION = 0
});
F_R_Flats flat2 = entities.F_R_Flats.Add(new F_R_Flats()
{
COMMERCIAL_NAME = "", WORKNAME = "Flat2", REVISION = 0
});
F_R_Flats flat1r1 = entities.F_R_Flats.Add(new F_R_Flats()
{
COMMERCIAL_NAME = "", WORKNAME = "Flat2", REVISION = 1
});
F_R_Modules module1 = entities.F_R_Modules.Add(new F_R_Modules()
{
NAME_MODULE = "Module1"
});
F_R_Modules module2 = entities.F_R_Modules.Add(new F_R_Modules()
{
NAME_MODULE = "Module2"
});
F_nn_FlatModules fm11 = entities.F_nn_FlatModules.Add(
new F_nn_FlatModules()
{
F_R_Flats = flat1,
F_R_Modules = module1,
DIRECTION = "0,0,0",
LOCATION = "0,0,0",
REVISION = 0
});
F_nn_FlatModules fm12 = entities.F_nn_FlatModules.Add(
new F_nn_FlatModules()
{
F_R_Flats = flat1,
F_R_Modules = module2,
DIRECTION = "1,1,0",
LOCATION = "100,100,0",
REVISION = 0
});
F_nn_FlatModules fm11r1 = entities.F_nn_FlatModules.Add(
new F_nn_FlatModules()
{
F_R_Flats = flat1,
F_R_Modules = module1,
DIRECTION = "0,0,0",
LOCATION = "0,0,0",
REVISION = 1
});
entities.SaveChanges();
}
}