public static void GetGemParts(Models.AlphaContext context)
{
var Part = new PartGem
{
PartID = 3,
ActualWeight = .90m,
PartGemID = 1,
Color = "Green",
GemStoneTypeID = 1, //Amethys
GemShapeID = 1, //Round
IsEstWeight = true,
IsSynthetic = false,
PricePerCarat = 50,
PricePerStone = 2,
Weight = .55m,
Finish = "Good"
};
//GemShapeMeasurements = ShapeMeasurements
context.PartGems.Add(Part);
context.SaveChanges();
var ShapeMeasurements = new GemShapeMeasurements {
PartGemID = Part.PartGemID, Depth = 3m
};
context.GemShapeMeasurements.Add(ShapeMeasurements);
context.SaveChanges();
List <GemDiameterMeasurement> DiameterList = new List <GemDiameterMeasurement>();
DiameterList.Add(new GemDiameterMeasurement {
GemShapeMesurementsID = ShapeMeasurements.GemShapeMesurementsID, Diameter = 5
});
DiameterList.Add(new GemDiameterMeasurement {
GemShapeMesurementsID = ShapeMeasurements.GemShapeMesurementsID, Diameter = 5.2m
});
context.GemDiameterMeasurements.AddRange(DiameterList);
context.SaveChanges();
}
public static void AddDiamondPart(AlphaContext context)
{
int count = context.PartDiamonds.Count();
if (count == 0)
{
PartDiamond DiamondPart =
new PartDiamond
{
PartDiamondID = 1,
DiamondShapeID = 1, //Round
LowerClarityGrade = "VS2",
TopClarityGrade = "VS1",
LowerColorGrade = "J",
TopColorGrade = "H",
PricePerCarat = 1000.00m,
DiamondMeasurement = new DiamondMeasurement
{
DiamondMesurementsID = 1,
Depth = 3.52m,
DiamondDiameterMeasurements = new List <DiamondDiameterMeasurement>
{
new DiamondDiameterMeasurement {
Diameter = 5m
},
new DiamondDiameterMeasurement {
Diameter = 5.1m
},
new DiamondDiameterMeasurement {
Diameter = 5.22m
},
new DiamondDiameterMeasurement {
Diameter = 5.13m
}
},
DiamondTableMeasurements = new List <DiamondTableMeasurement>
{
new DiamondTableMeasurement
{
DiamondMesurementID = 1,
DiamondTableMeasurementsID = 1,
TableMeasurement = 4m
},
new DiamondTableMeasurement
{
DiamondMesurementID = 1,
DiamondTableMeasurementsID = 2,
TableMeasurement = 4.3m
}
}
}
};
context.DiamondShapes.AddRange(Diamond.DiamondData.CreateDiamondShapeList());
}
context.SaveChanges();
}
public static void AddDiamondData(AlphaContext context)
{
int count = context.DiamondShapes.Count();
if (count == 0)
{
context.DiamondShapes.AddRange(Diamond.DiamondData.CreateDiamondShapeList());
}
context.SaveChanges();
}