Gyoshev

Untitled

Mar 30th, 2017
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.65 KB | None | 0 0
  1. public class Car
  2. {
  3. public Car()
  4. {
  5. this.Parts = new HashSet<Part>();
  6. }
  7. public int Id { get; set; }
  8. public string Make { get; set; }
  9. public string Model { get; set; }
  10. public Int64 TravelledDistance { get; set; }
  11. public virtual ICollection<Part> Parts { get; set; }
  12. }
  13.  
  14. public class Customer
  15. {
  16. public Customer()
  17. {
  18. this.Sales = new HashSet<Sale>();
  19. }
  20. public int Id { get; set; }
  21. public string Name { get; set; }
  22. public DateTime BirthDate { get; set; }
  23. public bool IsYoungDriver { get; set; }
  24. public virtual ICollection<Sale> Sales { get; set; }
  25. }
  26.  
  27. public class Sale
  28. {
  29. public int Id { get; set; }
  30. public int Discount { get; set; }
  31. public int CustomerId { get; set; }
  32. public virtual Customer Customer { get; set; }
  33. public int CarId { get; set; }
  34. public virtual Car Car { get; set; }
  35. }
  36.  
  37. И методите за зареждане на данни
  38.  
  39. private static void ImportCars(CarDealerContext context)
  40. {
  41. string json = File.ReadAllText("../../Import/cars.json");
  42. List<Car> cars = JsonConvert.DeserializeObject<List<Car>>(json);
  43. Random rnd = new Random();
  44. List<Part> parts = context.Parts.ToList();
  45.  
  46. foreach (var c in cars)
  47. {
  48. int partsId = rnd.Next(1, parts.Count - 1);
  49. Part part = context.Parts.Find(partsId);
  50. c.Parts.Add(part);
  51. partsId = rnd.Next(1, parts.Count - 1);
  52. c.Parts.Add(context.Parts.Find(partsId));
  53. partsId = rnd.Next(1, parts.Count - 1);
  54. c.Parts.Add(context.Parts.Find(partsId));
  55. }
  56.  
  57. context.Cars.AddRange(cars);
  58. context.SaveChanges();
  59. }
  60.  
  61. private static void ImportCustomers(CarDealerContext context)
  62. {
  63. string json = File.ReadAllText("../../Import/customers.json");
  64. List<Customer> customer = JsonConvert.DeserializeObject<List<Customer>>(json);
  65. Random rnd = new Random();
  66. List<Car> cars = context.Cars.ToList();
  67.  
  68. foreach (var c in customer)
  69. {
  70. int carsId = rnd.Next(1, cars.Count - 1);
  71. c.Sales.Add(context.Sales.Find(carsId));
  72. carsId = rnd.Next(1, cars.Count - 1);
  73. c.Sales.Add(context.Sales.Find(carsId));
  74. }
  75.  
  76. context.Customers.AddRange(customer);
  77. context.SaveChanges();
  78.  
  79. }
Advertisement
Add Comment
Please, Sign In to add comment