HTsekin

Seed

Apr 14th, 2021
490
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.11 KB | None | 0 0
  1. private static void SeedData(ModelBuilder builder)
  2. {
  3. var countries = new List<Country>
  4. {
  5. new Country
  6. {
  7. CountryId = 1,
  8. Name = "Bulgaria",
  9. },
  10. new Country
  11. {
  12. CountryId = 2,
  13. Name = "USA",
  14. },
  15. new Country
  16. {
  17. CountryId = 3,
  18. Name = "India",
  19. }
  20. };
  21.  
  22. var cities = new List<City>()
  23. {
  24. new City
  25. {
  26. CityId = 1,
  27. Name = "Los Angeles",
  28. CountryId = 2,
  29. },
  30. new City
  31. {
  32. CityId = 2,
  33. Name = "Varna",
  34. CountryId = 1,
  35. },
  36. new City
  37. {
  38. CityId = 3,
  39. Name = "Plovdiv",
  40. CountryId = 1,
  41. }
  42. };
  43.  
  44. var addresses = new List<Address>()
  45. {
  46. new Address
  47. {
  48. AddressId = 1,
  49. CityId = 2,
  50. StreetName = "Luben Karavelov 1",
  51. },
  52. new Address
  53. {
  54. AddressId = 2,
  55. CityId = 1,
  56. StreetName = "12 North West Lane",
  57. },
  58. new Address
  59. {
  60. AddressId = 3,
  61. CityId = 3,
  62. StreetName = "12 North West Lane",
  63. },
  64. };
  65.  
  66. var customers = new List<Customer>()
  67. {
  68. new Customer
  69. {
  70. CustomerId = 1,
  71. FirstName = "Gonzo",
  72. LastName = "ivanov",
  73. Email = "[email protected]",
  74. AddressForDeliveryId = 1
  75. }
  76. //new Customer
  77. //{
  78. // CustomerId = 2,
  79. // FirstName = "Lionel",
  80. // LastName = "Messi",
  81. // Email = "[email protected]",
  82. // AddressForDeliveryId = 2
  83. //}
  84. };
  85.  
  86. var category1 = new Category()
  87. {
  88. CategoryId = 1,
  89. Name = "electronic"
  90. };
  91. var status = new Status()
  92. {
  93. StatusId = 1,
  94. Name = "on the way"
  95. };
  96.  
  97. var employee1 = new Employee()
  98. {
  99. EmployeeId = 1,
  100. FirstName = "Petar",
  101. LastName = "Ivanov",
  102. Email = "[email protected]",
  103. AddressId = 2
  104. };
  105.  
  106. var warehouse1 = new Warehouse()
  107. {
  108. WarehouseId = 1,
  109. Name = "Kometa 3",
  110. AddressId = 3
  111. };
  112.  
  113.  
  114. var shipment1 = new Shipment()
  115. {
  116. ShipmentId = 1,
  117. ArrivalDate = new DateTime(2021, 5, 6),
  118. DepartureDate = new DateTime(2021, 5, 10),
  119. StatusId = 1
  120. };
  121.  
  122.  
  123.  
  124. var parcels = new List<Parcel>()
  125. {
  126. new Parcel
  127. {
  128. ParcelId = 1,
  129. CustomerId = 1,
  130. CategoryId = 1,
  131. EmployeeId = 1,
  132. ShipmentId = 1,
  133. WarehouseId = 1,
  134. }
  135. };
  136. // new Parcel
  137. // {
  138. // ParcelId = 2,
  139. // CustomerId = 2,
  140. // CategoryId = 2,
  141. // EmployeeId = 2,
  142. // ShipmentId = 2,
  143. // WarehouseId = 2,
  144. // Customer = new Customer()
  145. // {
  146. // CustomerId = 2,
  147. // FirstName = "Mehmet",
  148. // LastName = "ivanov",
  149. // Email = "[email protected]",
  150. // AddressForDeliveryId = 2
  151. // },
  152. // Category = new Category()
  153. // {
  154. // CategoryId = 2,
  155. // Name = "clothes"
  156. // },
  157. // Employee = new Employee()
  158. // {
  159. // EmployeeId = 2,
  160. // FirstName = "Ivan",
  161. // LastName = "Ivanov",
  162. // Email = "[email protected]"
  163. // },
  164. // Shipment = new Shipment()
  165. // {
  166. // ShipmentId = 2,
  167. // ArrivalDate = new DateTime(2022, 5, 6),
  168. // DepartureDate = new DateTime(2022, 5, 10),
  169. // Status = new Status()
  170. // {
  171. // StatusId = 2,
  172. // Name = "on the way"
  173. // }
  174. // },
  175. // Warehouse = new Warehouse()
  176. // {
  177. // WarehouseId = 2,
  178. // Name = "Panda IP"
  179. // }
  180. // };
  181.  
  182.  
  183.  
  184. builder.Entity<Country>().HasData(countries);
  185. builder.Entity<City>().HasData(cities);
  186. builder.Entity<Address>().HasData(addresses);
  187. builder.Entity<Customer>().HasData(customers);
  188. builder.Entity<Employee>().HasData(employee1);
  189.  
  190. builder.Entity<Status>().HasData(status);
  191. builder.Entity<Category>().HasData(category1);
  192. builder.Entity<Shipment>().HasData(shipment1);
  193.  
  194. builder.Entity<Warehouse>().HasData(warehouse1);
  195.  
  196. builder.Entity<Parcel>().HasData(parcels);
  197. }
Add Comment
Please, Sign In to add comment