private static void AddLensToManufacturer(PhotographySystemEntities context, Manufacturer manufacturer, Lens lense)
{
if (manufacturer != null)
{
if (manufacturer.Lenses.Contains(lense))
{
Console.WriteLine("Existing lens: {0}", lense.Model);
}
else
{
manufacturer.Lenses.Add(lense);
context.SaveChanges();
Console.WriteLine("Created lens: {0}", lense.Model);
}
}
}
private static void CreateNewLensesIfNotExists(PhotographySystemEntities context, Manufacturer manufacturer, IEnumerable<XElement> xLenses)
{
foreach (var xLense in xLenses)
{
var lenseModel = xLense.Attribute("model").Value;
var lenseType = xLense.Attribute("type").Value;
var xLensePrice = xLense.Attribute("price");
string lensePrice = null;
if (xLensePrice != null)
{
lensePrice = xLensePrice.Value;
}
var lense = context.Lenses
.FirstOrDefault(l => l.Model == lenseModel);
if (lense != null)
{
Console.WriteLine("Existing lens: {0}", lenseModel);
}
else
{
lense = new Lens()
{
Model = lenseModel,
Type = lenseType
};
if (lensePrice != null)
{
lense.Price = decimal.Parse(lensePrice);
}
context.Lenses.Add(lense);
}
AddLensToManufacturer(context, manufacturer, lense);
}
}
private static Manufacturer CreateNewManufacturerIfNotExists(PhotographySystemEntities context, XElement xManufacturer)
{
Manufacturer manufacturer = null;
var xManufacturerName = xManufacturer.Element("manufacturer-name");
if (xManufacturerName != null)
{
string manufacturerName = xManufacturerName.Value;
manufacturer = context.Manufacturers.FirstOrDefault(m => m.Name == manufacturerName);
if (manufacturer != null)
{
Console.WriteLine("Existing manufacturer: {0}", manufacturerName);
}
else
{
manufacturer = new Manufacturer(){ Name = manufacturerName};
context.Manufacturers.Add(manufacturer);
context.SaveChanges();
Console.WriteLine("Created manufacturer: {0}", manufacturerName);
}
}
return manufacturer;
}
