public static void ReadUsersXml() { var xmlString = File.ReadAllText("../../../xml/users.xml"); var serializer = new XmlSerializer(typeof(UserDto[]), new XmlRootAttribute("users")); var deserializer = (UserDto[])serializer.Deserialize(new StringReader(xmlString)); var mapperConfig = new MapperConfiguration(cfg => { cfg.AddProfile <XmlProcessingExerciseProfile>(); }); var mapper = mapperConfig.CreateMapper(); //var users = new List<User>(); foreach (UserDto userDto in deserializer) { if (IsValid(userDto) == false) { Console.WriteLine("Invalid user data"); continue; } var user = mapper.Map <User>(userDto); //users.Add(user); var context = new XmlProcessingExerciseContext(); context.Add(user); context.SaveChanges(); } Console.WriteLine("Users added successfully!"); }
public static void ReadCategoriesXml() { var xmlString = File.ReadAllText("../../../xml/categories.xml"); var serializer = new XmlSerializer(typeof(CategoryDto[]), new XmlRootAttribute("categories")); var deserializer = (CategoryDto[])serializer.Deserialize(new StringReader(xmlString)); var mapperConfig = new MapperConfiguration(cfg => { cfg.AddProfile <XmlProcessingExerciseProfile>(); }); var mapper = mapperConfig.CreateMapper(); //var categories = new List<Category>(); foreach (CategoryDto categoryDto in deserializer) { if (IsValid(categoryDto) == false) { Console.WriteLine("Invalid category data"); continue; } var category = mapper.Map <Category>(categoryDto); var context = new XmlProcessingExerciseContext(); context.Add(category); context.SaveChanges(); } Console.WriteLine("Categories added successfully!"); }
public static void ReadProductsXml() { var xmlString = File.ReadAllText("../../../xml/products.xml"); var serializer = new XmlSerializer(typeof(ProductDto[]), new XmlRootAttribute("products")); var deserializer = (ProductDto[])serializer.Deserialize(new StringReader(xmlString)); var mapperConfig = new MapperConfiguration(cfg => { cfg.AddProfile <XmlProcessingExerciseProfile>(); }); var mapper = mapperConfig.CreateMapper(); //var products = new List<User>(); int counter = 0; foreach (ProductDto productDto in deserializer) { if (IsValid(productDto) == false) { Console.WriteLine("Invalid product data"); continue; } var product = mapper.Map <Product>(productDto); int?buyerId = new Random().Next(1, 30); int sellerId = new Random().Next(31, 56); if (counter == 4) { buyerId = null; counter = 0; } counter++; product.BuyerId = buyerId; product.SellerId = sellerId; var context = new XmlProcessingExerciseContext(); context.Add(product); context.SaveChanges(); } Console.WriteLine("Products added successfully!"); }
public static void GenerateCategoriesProducts(XmlProcessingExerciseContext context) { int productsCount = context.Products.Count(); int categoriesCount = context.Categories.Count(); var categoryProducts = new List <CategoryProduct>(); for (int productId = 1; productId <= productsCount; productId++) { var categoryId = new Random().Next(1, categoriesCount + 1); var categoryProduct = new CategoryProduct() { ProductId = productId, CategoryId = categoryId }; categoryProducts.Add(categoryProduct); } context.CategoryProducts.AddRange(categoryProducts); context.SaveChanges(); Console.WriteLine("Category-Products generated succesfully"); }