public static void ReadJsonFilesAndFillDb()
{
string jsonCategoriesInput = File.ReadAllText(@"../Resources/categories.json");
string jsonUsersInput = File.ReadAllText(@"../Resources/users.json");
string jsonProductsInput = File.ReadAllText(@"../Resources/products.json");
User[] UsersFromJSON = JsonConvert.DeserializeObject <User[]>(jsonUsersInput);
Category[] CategoriesFromJSON = JsonConvert.DeserializeObject <Category[]>(jsonCategoriesInput);
Product[] ProductsFromJSON = JsonConvert.DeserializeObject <Product[]>(jsonProductsInput);
ProductsShopContext dbContext = new ProductsShopContext();
Random randomInstance = new Random();
using (dbContext)
{
DbFill.ImportUsersToDb(UsersFromJSON, dbContext);
DbFill.ImportCategoriesToDb(CategoriesFromJSON, dbContext);
DbFill.ImportProductsToDb(ProductsFromJSON, dbContext, randomInstance);
}
}
internal static void ImportXMLDataAndPopulateDB()
{
string xmlUsersInput = File.ReadAllText(@"../Resources/users.xml");
XDocument xmlUsersDoc = XDocument.Parse(xmlUsersInput);
IEnumerable <XElement> xElementsUsers = xmlUsersDoc.Root.Elements();
List <User> users = new List <User>();
foreach (XElement e in xElementsUsers)
{
string firstName = e.Attribute("firstName")?.Value;
string lastName = e.Attribute("lastName").Value;
bool successfullyParsed = int.TryParse(e.Attribute("age")?.Value, out int parsedAge);
int? age = successfullyParsed ? parsedAge : (int?)null;
User user = new User
{
FirstName = firstName,
LastName = lastName,
Age = age
};
users.Add(user);
}
string xmlCategoriesInput = File.ReadAllText(@"../Resources/categories.xml");
XDocument xmlCategoriesDoc = XDocument.Parse(xmlCategoriesInput);
IEnumerable <XElement> xElementsCategories = xmlCategoriesDoc.Root.Elements();
List <Category> categories = new List <Category>();
foreach (XElement e in xElementsCategories)
{
Category category = new Category()
{
Name = e.Element("name").Value
};
categories.Add(category);
}
string xmlProductsInput = File.ReadAllText(@"../Resources/products.xml");
XDocument xmlProductsDoc = XDocument.Parse(xmlProductsInput);
IEnumerable <XElement> xProductsCategories = xmlProductsDoc.Root.Elements();
List <Product> products = new List <Product>();
foreach (XElement e in xProductsCategories)
{
Product product = new Product()
{
Name = e.Element("name").Value,
Price = decimal.Parse(e.Element("price").Value)
};
products.Add(product);
}
using (ProductsShopContext context = new ProductsShopContext())
{
DbFill.ImportUsersToDb(users, context);
DbFill.ImportCategoriesToDb(categories, context);
Random randomInstance = new Random();
DbFill.ImportProductsToDb(products, context, randomInstance);
}
}
