private static void Main(string[] args)
{
var context = new PhotographySystemEntities();
XmlDocument doc = new XmlDocument();
doc.Load("../../manufacturers-and-lenses.xml");
var root = doc.DocumentElement;
int id = 1;
foreach (XmlNode manufacturer in doc.DocumentElement)
{
Console.WriteLine("Processing # {0}", id++);
var manufacturerChilds = manufacturer.ChildNodes;
var manufacturerName = manufacturerChilds[0].InnerXml;
Manufacturer XmlManufacturer = new Manufacturer();
if (context.Manufacturers.Any(m => m.Name == manufacturerName))
{
Console.WriteLine("Existing manufacturer: {0}", manufacturerName);
}
else
{
Console.WriteLine("Created manufacturer: {0}",manufacturerName);
XmlManufacturer.Name = manufacturerName;
context.Manufacturers.Add(XmlManufacturer);
context.SaveChanges();
}
XmlNode lenses = manufacturerChilds[1];
if (lenses != null)
{
foreach (XmlNode lense in lenses)
{
string lenseModel = lense.Attributes["model"].Value;
string lenseType = lense.Attributes["type"].Value;
string lensePrice = lense.Attributes["price"] == null ? null : lense.Attributes["price"].Value;
if (context.Lenses.Any(l => l.Model == lenseModel))
{
Console.WriteLine("Existing lens: {0}", lenseModel);
}
else
{
Lens lens = new Lens()
{
Model = lenseModel,
Type = lenseType,
Price = lensePrice == null ? (decimal?)null : Decimal.Parse(lensePrice),
Manufacturer = context.Manufacturers.FirstOrDefault (m=>m.Name==manufacturerName)
};
context.Lenses.Add(lens);
context.SaveChanges();
Console.WriteLine("Created lens: {0}",lenseModel);
}
}
}
Console.WriteLine();
}
}
private static void Main()
{
var context = new PhotographySystemEntities();
var doc = XDocument.Load(@"..\\..\\manufacturers-and-lenses.xml");
var photographyNodes = doc.XPathSelectElements("/manufacturers-and-lenses/manufacturer");
int index = 1;
foreach (var photographyNode in photographyNodes)
{
Console.WriteLine("Processing manufacturer #{0} ...", index++);
string manifacturer = photographyNode.Element("manufacturer-name").Value;
var query = context.Manufacturers.Where(m=>m.Name==manifacturer).Select(m => m.Name);
if (!query.Any())
{
context.Manufacturers.Add(new Manufacturer()
{
Name = manifacturer
});
context.SaveChanges();
Console.WriteLine("Created manufacturer: {0}", manifacturer);
}
else
{
Console.WriteLine("Existing manufacturer: {0}", manifacturer);
}
var manifacturerId = context.Manufacturers.Where(m => m.Name == manifacturer).Select(m => m.Id).FirstOrDefault();
var lensNodes = photographyNode.XPathSelectElements("lenses/lens");
if (lensNodes.Count()!=0)
{
foreach (var lensNode in lensNodes)
{
var lensModels = lensNode.Attributes("model").Select(l => l.Value);
string model = lensModels.FirstOrDefault().ToString();
var modelQuery = context.Lenses.Where(l=>l.Model==model).Select(l => l.Model);
if (!modelQuery.Any())
{
var lensTypes = lensNode.Attributes("type").Select(l => l.Value);
string type = lensTypes.FirstOrDefault().ToString();
if (lensNode.Attributes("price").Any())
{
var lensPrices = lensNode.Attributes("price").Select(l => l.Value);
decimal price = Decimal.Parse(lensPrices.FirstOrDefault().ToString());
context.Lenses.Add(new Lens()
{
ManufacturerId = manifacturerId,
Model = model,
Type = type,
Price = price
});
}
else
{
context.Lenses.Add(new Lens()
{
ManufacturerId = manifacturerId,
Model = model,
Type = type
});
}
Console.WriteLine("Created lens: {0}", model);
}
else
{
Console.WriteLine("Existing lens: {0}", model);
}
}
}
}
context.SaveChanges();
}
static void Main()
{
var context = new PhotographySystemEntities();
var doc = XDocument.Load(@"..\\..\\generate-equipments.xml");
var generateNodes = doc.XPathSelectElements("/generate-random-equipments/generate");
int index = 1;
foreach (var generateNode in generateNodes)
{
int count = 1;
string manifacturer = "Nikon";
int mId = 11;
Console.WriteLine("Processing request #{0} ...", index++);
if (generateNode.Attributes("generate-count").Any())
{
var counts = generateNode.Attributes("generate-count").Select(l => l.Value);
count = int.Parse(counts.FirstOrDefault().ToString());
}
for (int i = 0; i < count; i++)
{
if (generateNode.Element("manufacturer")!=null)
{
manifacturer = generateNode.Element("manufacturer").Value.ToString();
var manifacturers = context.Manufacturers.Where(m => m.Name == manifacturer).Select(m => m.Name);
if (!manifacturers.Any())
{
context.Manufacturers.Add(new Manufacturer()
{
Name = manifacturer
});
}
var query = context.Manufacturers.Where(m => m.Name == manifacturer).Select(m => m.Id);
mId = query.FirstOrDefault();
}
var cameras = context.Cameras.ToList();
Random rnd = new Random();
int inx = rnd.Next(cameras.Count());
Camera newCamera = cameras[inx];
newCamera.ManufacturerId = mId;
var lenses = context.Lenses.ToList();
Random r = new Random();
int inx2 = r.Next(lenses.Count());
Lens newLens = lenses[inx2];
newLens.ManufacturerId = mId;
context.Lenses.Add(newLens);
context.SaveChanges();
var lensID = context.Lenses.Where(l=>l.Model==newLens.Model).Select(l => l.Id).FirstOrDefault();
var cameraID = context.Cameras.Where(c => c.Model == newCamera.Model).Select(c => c.Id).FirstOrDefault();
context.Equipments.Add(new Equipment()
{
LensId = lensID,
CameraId = cameraID
});
Console.WriteLine("Equipment added: {0} (Camera: {1} - Lens: {2})",
manifacturer,
newCamera.Model,
newLens.Model);
context.SaveChanges();
}
}
}
