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(); }