public static List <Address> GetAddressList() { List <Address> returnValue = new List <Address>(); using (Models.AlphaContext context = new Models.AlphaContext()) { returnValue.Add(new Address { PersonID = context.People.Single(i => i.LastName == "Beaver").PersonID, AddressID = 1, AddressType = "Home", Add1 = "SomeWhere", Add2 = "", City = "San Antonio", State = "TX", PostalCode = "33033", Country = "USA" }); returnValue.Add(new Address { PersonID = context.People.Single(i => i.LastName == "Morris").PersonID, AddressID = 2, AddressType = "Shipping", Add1 = "AnyWhere", Add2 = "", City = "San Antonio", State = "TX", PostalCode = "33033", Country = "USA" }); return(returnValue); } }
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 PartDiamond TestDiamondPart() { using (Models.AlphaContext context = new Models.AlphaContext()) { var d = new Models.PartDiamond(); d.DiamondMeasurement.DiamondDiameterMeasurements = new List <DiamondDiameterMeasurement> { new DiamondDiameterMeasurement { Diameter = 6m }, new DiamondDiameterMeasurement { Diameter = 5.1m }, new DiamondDiameterMeasurement { Diameter = 5.22m }, new DiamondDiameterMeasurement { Diameter = 5.13m } }; d.DiamondMeasurement.DiamondTableMeasurements = new List <DiamondTableMeasurement> { new DiamondTableMeasurement { TableMeasurement = 3m }, new DiamondTableMeasurement { TableMeasurement = 3.05m } }; d.DiamondMeasurement.Depth = 3m; d.DiamondShapeID = 0; //for Round //Set Quality d.LowerClarityGrade = "VS1"; d.TopClarityGrade = "VVS1"; d.TopColorGrade = "D"; d.LowerColorGrade = "H"; //Accounting d.Part.Cost = 100m; d.Part.Quantity = 3; d.PricePerCarat = 300; d.DiamondShape = new DiamondShape { DiamondShapeID = 0, ShapeName = "Round Brilliant" }; var dc = new DiamondCalculations.CalculateWeight(); d.Weight = DiamondWeightEstimator(d.DiamondShape, d.DiamondMeasurement); return(d); } }
public static void AddDiamondData(AlphaContext context) { int count = context.DiamondShapes.Count(); if (count == 0) { context.DiamondShapes.AddRange(Diamond.DiamondData.CreateDiamondShapeList()); } context.SaveChanges(); }
public static List <Repair> GetRepairsList() { List <Repair> retrunValue = new List <Repair>(); using (AlphaContext context = new AlphaContext()) { retrunValue.Add(new Repair { RepairID = 1, CustomerID = 1, TakeInDate = DateTime.Today, PromiseDate = DateTime.Today.AddDays(3), }); return(retrunValue); } }
public static List <Item> GetItems() { List <Item> retrunValue = new List <Item>(); using (AlphaContext context = new AlphaContext()) { retrunValue.Add(new Item { ItemType = "Repair", Description = "Item Description", ItemID = 1 } ); } return(retrunValue); }
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 List <VendorContact> GetVendorContact() { using (Models.AlphaContext context = new Models.AlphaContext()) { //List<VendorContact> PersonList = new List<VendorContact>(); var returnValue = new List <VendorContact>(); returnValue.Add(new VendorContact { VendorContactID = 1, VendorID = 1, PersonID = context.People.Single(i => i.LastName == "Morris").PersonID, VendorContactType = "Sales Person" }); return(returnValue); } }
public static List <ItemRepair> GetRepairItems() { List <ItemRepair> retrunValue = new List <ItemRepair>(); using (AlphaContext context = new AlphaContext()) { retrunValue.Add(new ItemRepair { CompletionDate = DateTime.Now, Instruction = "Size 10", EstimatedValue = 300.00m, PickupDate = DateTime.Now, ItemID = 3, RepairID = 6 }); return(retrunValue); } }
public static List <Customer> GetCustomers(List <Person> People) { using (Models.AlphaContext context = new Models.AlphaContext()) { List <Customer> PersonList = new List <Customer>(); var returnValue = new List <Customer>(); returnValue.Add(new Customer { CustomerID = 1, IsActive = true, PersonID = context.People.Single(i => i.LastName == "Beaver").PersonID }); returnValue.Add(new Customer { CustomerID = 2, IsActive = true, PersonID = context.People.Single(i => i.LastName == "Dupont").PersonID }); returnValue.Add(new Customer { CustomerID = 2, IsActive = true, PersonID = context.People.Single(i => i.LastName == "Persavil").PersonID }); return(returnValue); } }
public static List <EmailAddress> GetEmailAddressList() { using (AlphaContext context = new AlphaContext()) { List <EmailAddress> returnValue = new List <EmailAddress>(); returnValue.Add(new EmailAddress { EmailAddressID = 1, PersonID = context.People.Single(i => i.LastName == "Dupont").PersonID, Addresstype = "Work", ThAddress = "*****@*****.**" }); returnValue.Add(new EmailAddress { EmailAddressID = 2, PersonID = context.People.Single(i => i.LastName == "Morris").PersonID, Addresstype = "Work", ThAddress = "*****@*****.**" }); return(returnValue); } }