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