private static void ImportParts(CarDealerContext context)
{
var xml = XDocument.Load(PartsPath);
var parts = xml.XPathSelectElements("parts").Elements("part");
Random rnd = new Random();
foreach (var part in parts)
{
string name = part.Attribute("name").Value;
decimal price = decimal.Parse(part.Attribute("price").Value);
int quantity = int.Parse(part.Attribute("quantity").Value);
int supplierId = rnd.Next(1, context.PartSuppliers.Count() + 1);
PartSupplier supplier = context.PartSuppliers.FirstOrDefault(x => x.Id == supplierId);
Part newPart = new Part()
{
Name = name,
Price = price,
Quantity = quantity,
PartSupplier = supplier
};
context.Parts.Add(newPart);
}
context.SaveChanges();
}
private static void ImportParts(CarDealerContext context)
{
var json = File.ReadAllText(PartsPath);
var parts = JsonConvert.DeserializeObject <IEnumerable <PartDTO> >(json);
Random rnd = new Random();
foreach (var element in parts)
{
int supplierId = rnd.Next(1, context.PartSuppliers.Count() + 1);
PartSupplier partSupplier = context.PartSuppliers.FirstOrDefault(x => x.Id == supplierId);
Part part = new Part()
{
Name = element.Name,
Price = element.Price,
Quantity = element.Quantity,
PartSupplier = partSupplier
};
context.Parts.Add(part);
}
context.SaveChanges();
}
public bool DeletePartSupplier(int partSupplierId)
{
PartSupplier partSupplier = GetPartSupplier(partSupplierId);
dataContext.PartSuppliers.DeleteOnSubmit(partSupplier);
dataContext.SubmitChanges();
return(dataContext.ChangeConflicts != null && dataContext.ChangeConflicts.Count == 0);
}
public bool AddNewPartSupplier(int supplierId, string partSku)
{
Part part = GetPart(partSku);
Supplier supplier = GetSupplier(supplierId);
var partSupplier = new PartSupplier
{
Part = part,
Supplier = supplier
};
dataContext.PartSuppliers.InsertOnSubmit(partSupplier);
dataContext.SubmitChanges();
return(dataContext.ChangeConflicts != null && dataContext.ChangeConflicts.Count == 0);
}
private static void ImportSuppliers(CarDealerContext context)
{
var json = File.ReadAllText(SuppliersPath);
var suppliers = JsonConvert.DeserializeObject <IEnumerable <PartSupplierDTO> >(json);
foreach (var element in suppliers)
{
PartSupplier partSupplier = new PartSupplier()
{
Name = element.Name,
IsImporter = element.IsImporter
};
context.PartSuppliers.Add(partSupplier);
}
context.SaveChanges();
}
private static void ImportSuppliers(CarDealerContext context)
{
var xml = XDocument.Load(SuppliersPath);
var suppliers = xml.XPathSelectElements("suppliers").Elements("supplier");
foreach (var supplier in suppliers)
{
string name = supplier.Attribute("name").Value;
bool isImporter = bool.Parse(supplier.Attribute("is-importer").Value);
PartSupplier supplierToAdd = new PartSupplier()
{
Name = name,
IsImporter = isImporter
};
context.PartSuppliers.Add(supplierToAdd);
}
context.SaveChanges();
}
