public M_ResourceSetup[] Init(MasterDBContext context)
{
var resourceSetups = new M_ResourceSetup[] {
SAW_1_BLADE_BIG,
SAW_2_BLADE_BIG,
SAW_2_BLADE_SMALL,
DRILL_1_M4,
DRILL_1_M6,
ASSEMBLY_1_SCREWDRIVER,
ASSEMBLY_2_SCREWDRIVER
};
context.ResourceSetups.AddRange(entities: resourceSetups);
context.SaveChanges();
return(resourceSetups);
}
/// <summary>
/// /
/// </summary>
/// <param name="resources"></param>
/// <param name="resourceTools"></param>
/// <returns></returns>
private static M_ResourceSetup[] CreateResourceSetups(M_Resource[] resources, M_ResourceTool[] resourceTools)
{
var resourceSetups = new M_ResourceSetup[]
{
new M_ResourceSetup
{
Name = RESCOURCESETUP_SAW1_SAWBIG, Resource = resources.Single(predicate: s => s.Name == RESCOURCE_SAW1),
ResourceTool = resourceTools.Single(predicate: s => s.Name == RESCOURCETOOL_SAWBIG), SetupTime = 5
},
new M_ResourceSetup
{
Name = RESCOURCESETUP_SAW2_SAWBIG, Resource = resources.Single(predicate: s => s.Name == RESCOURCE_SAW2),
ResourceTool = resourceTools.Single(predicate: s => s.Name == RESCOURCETOOL_SAWBIG), SetupTime = 5
},
new M_ResourceSetup
{
Name = RESCOURCESETUP_SAW2_SAWSMALL, Resource = resources.Single(predicate: s => s.Name == RESCOURCE_SAW2),
ResourceTool = resourceTools.Single(predicate: s => s.Name == RESCOURCETOOL_SAWSMALL), SetupTime = 5
},
new M_ResourceSetup
{
Name = RESCOURCESETUP_DRILL1_M6, Resource = resources.Single(predicate: s => s.Name == RESCOURCE_DRILL1),
ResourceTool = resourceTools.Single(predicate: s => s.Name == RESCOURCETOOL_M6), SetupTime = 10
},
new M_ResourceSetup
{
Name = RESCOURCESETUP_DRILL1_M4, Resource = resources.Single(predicate: s => s.Name == RESCOURCE_DRILL1),
ResourceTool = resourceTools.Single(predicate: s => s.Name == RESCOURCETOOL_M4), SetupTime = 10
},
new M_ResourceSetup
{
Name = RESCOURCESETUP_ASSEMBLY1_SCREW2,
Resource = resources.Single(predicate: s => s.Name == RESCOURCE_ASSEMBLY1),
ResourceTool = resourceTools.Single(predicate: s => s.Name == RESCOURCETOOL_SCREWDRIVERCROSS2), SetupTime = 5
},
new M_ResourceSetup
{
Name = RESCOURCESETUP_ASSEMBLY2_SCREW2,
Resource = resources.Single(predicate: s => s.Name == RESCOURCE_ASSEMBLY2),
ResourceTool = resourceTools.Single(predicate: s => s.Name == RESCOURCETOOL_SCREWDRIVERCROSS2), SetupTime = 5
},
};
return(resourceSetups);
}
private static M_ResourceSetup[] CreateResourceSetups(M_ResourceTool[] resourceTools
, M_Resource[] resources
, M_ResourceSkill[] resourceSkills)
{
var resource1 = new M_ResourceSetup
{
Name = resourceSkills.Single(x => x.Name == RESOURCE_SKILL_PACKING).Name + " Setup",
ResourceId = resources.Single(x => x.Name == RESOURCE_WRAPPER).Id,
ResourceToolId = resourceTools.Single(x => x.Name == RESOURCE_TOOL_WELDER).Id,
ResourceSkillId = resourceSkills.Single(x => x.Name == RESOURCE_SKILL_PACKING).Id
};
var resource2 = new M_ResourceSetup
{
Name = resourceSkills.Single(x => x.Name == RESOURCE_SKILL_ASSEMBLING).Name + " Setup",
ResourceId = resources.Single(x => x.Name == RESOURCE_ASSEMBLY_1).Id,
ResourceToolId = resourceTools.Single(x => x.Name == RESOURCE_TOOL_WELDER).Id,
ResourceSkillId = resourceSkills.Single(x => x.Name == RESOURCE_SKILL_ASSEMBLING).Id
};
var resource3 = new M_ResourceSetup
{
Name = resourceSkills.Single(x => x.Name == RESOURCE_SKILL_ASSEMBLING).Name + " Setup",
ResourceId = resources.Single(x => x.Name == RESOURCE_ASSEMBLY_2).Id,
ResourceToolId = resourceTools.Single(x => x.Name == RESOURCE_TOOL_WELDER).Id,
ResourceSkillId = resourceSkills.Single(x => x.Name == RESOURCE_SKILL_ASSEMBLING).Id
};
var resource4 = new M_ResourceSetup
{
Name = resourceSkills.Single(x => x.Name == RESOURCE_SKILL_WELDING).Name + " Setup",
ResourceId = resources.Single(x => x.Name == RESOURCE_WELDING_1).Id,
ResourceToolId = resourceTools.Single(x => x.Name == RESOURCE_TOOL_WELDER).Id,
ResourceSkillId = resourceSkills.Single(x => x.Name == RESOURCE_SKILL_WELDING).Id
};
var resource5 = new M_ResourceSetup
{
Name = resourceSkills.Single(x => x.Name == RESOURCE_SKILL_WELDING).Name + " Setup",
ResourceId = resources.Single(x => x.Name == RESOURCE_WELDING_2).Id,
ResourceToolId = resourceTools.Single(x => x.Name == RESOURCE_TOOL_WELDER).Id,
ResourceSkillId = resourceSkills.Single(x => x.Name == RESOURCE_SKILL_WELDING).Id
};
var resourceSetups = new M_ResourceSetup[] { resource1, resource2, resource3, resource4, resource5 };
return(resourceSetups);
}
internal MasterTableResourceSetup(MasterTableResource resource
, MasterTableResourceTool resourceTool
, MasterTableResourceSkill resourceSkill)
{
SAW_1_BLADE_BIG = new M_ResourceSetup
{
Name = resource.SAW_1.Name + " blade big",
ResourceId = resource.SAW_1.Id,
ResourceToolId = resourceTool.SAW_BLADE_BIG.Id,
ResourceSkillId = resourceSkill.CUTTING.Id,
SetupTime = 5
};
SAW_2_BLADE_BIG = new M_ResourceSetup
{
Name = resource.SAW_2.Name + " blade big",
ResourceId = resource.SAW_2.Id,
ResourceToolId = resourceTool.SAW_BLADE_BIG.Id,
ResourceSkillId = resourceSkill.CUTTING.Id,
SetupTime = 5
};
SAW_2_BLADE_SMALL = new M_ResourceSetup
{
Name = resource.SAW_2.Name + " blade small",
ResourceId = resource.SAW_2.Id,
ResourceToolId = resourceTool.SAW_BLADE_SMALL.Id,
ResourceSkillId = resourceSkill.CUTTING.Id,
SetupTime = 5
};
DRILL_1_M4 = new M_ResourceSetup
{
Name = resource.DRILL_1.Name + " M4",
ResourceId = resource.DRILL_1.Id,
ResourceToolId = resourceTool.DRILL_HEAD_M4.Id,
ResourceSkillId = resourceSkill.DRILLING.Id,
SetupTime = 10
};
DRILL_1_M6 = new M_ResourceSetup
{
Name = resource.DRILL_1.Name + " M6",
ResourceId = resource.DRILL_1.Id,
ResourceToolId = resourceTool.DRILL_HEAD_M6.Id,
ResourceSkillId = resourceSkill.DRILLING.Id,
SetupTime = 10
};
ASSEMBLY_1_SCREWDRIVER = new M_ResourceSetup
{
Name = resource.ASSEMBLY_1.Name + " screwdriver universal",
ResourceId = resource.ASSEMBLY_1.Id,
ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id,
ResourceSkillId = resourceSkill.ASSEMBLING.Id,
SetupTime = 5
};
ASSEMBLY_2_SCREWDRIVER = new M_ResourceSetup
{
Name = resource.ASSEMBLY_2.Name + " screwdriver universal",
ResourceId = resource.ASSEMBLY_2.Id,
ResourceToolId = resourceTool.ASSEMBLY_SCREWDRIVER.Id,
ResourceSkillId = resourceSkill.ASSEMBLING.Id,
SetupTime = 5
};
}
