public static void SeedStates(NodeSenseWebApiWorkshopServer.Models.DataContext context)
{
string path = AppDomain.CurrentDomain.GetData("DataDirectory").ToString();
JObject statesJson = JObject.Parse(File.ReadAllText(path + "/states.json"));
JArray states = (JArray)statesJson["states"];
DateTime timeNow = DateTime.Now;
foreach (JObject o in states)
{
JToken id = o["id"];
State state = new State();
state.Id = o["id"].Value <int>();
state.Name = o["name"].Value <string>();
state.Code = o["code"].Value <string>();
state.Updated = timeNow;
if (context != null)
{
context.States.AddOrUpdate(
c => c.Id,
state
);
Console.WriteLine("Updated state {0}-{1}", state.Id, state.Name);
}
}
}
public static void SeedCities(NodeSenseWebApiWorkshopServer.Models.DataContext context)
{
string path = AppDomain.CurrentDomain.GetData("DataDirectory").ToString();
JObject citiesJson = JObject.Parse(File.ReadAllText(path + "/cities.json"));
JArray cities = (JArray)citiesJson["cities"];
DateTime timeNow = DateTime.Now;
foreach (JObject o in cities)
{
JToken id = o["id"];
City city = new City();
city.Id = o["id"].Value <int>();
city.Name = o["name"].Value <string>();
city.StateId = o["stateId"].Value <int>();
city.Updated = timeNow;
if (context != null)
{
context.Cities.AddOrUpdate(
c => c.Id,
city
);
Console.WriteLine("Updated city {0}-{1}", city.Id, city.Name);
}
}
}
public static void SeedData(NodeSenseWebApiWorkshopServer.Models.DataContext context)
{
SeedCities(context);
SeedStates(context);
SeedBrands(context);
SeedProducts(context);
}
public static void SeedBrands(NodeSenseWebApiWorkshopServer.Models.DataContext context)
{
string path = AppDomain.CurrentDomain.GetData("DataDirectory").ToString();
JObject brandsJson = JObject.Parse(File.ReadAllText(path + "/brands.json"));
JArray brands = (JArray)brandsJson["brands"];
DateTime timeNow = DateTime.Now;
foreach (JObject o in brands)
{
JToken id = o["id"];
Brand brand = new Brand();
brand.Id = o["id"].Value <int>();
brand.Name = o["name"].Value <string>();
brand.Updated = timeNow;
if (context != null)
{
context.Brands.AddOrUpdate(
c => c.Id,
brand
);
Console.WriteLine("Updated state {0}-{1}", brand.Id, brand.Name);
}
}
}
public static void SeedProducts(NodeSenseWebApiWorkshopServer.Models.DataContext context)
{
string path = AppDomain.CurrentDomain.GetData("DataDirectory").ToString();
JObject productsJson = JObject.Parse(File.ReadAllText(path + "/products.json"));
JArray products = (JArray)productsJson["products"];
DateTime timeNow = DateTime.Now;
Random priceGenerator = new Random();
foreach (JObject o in products)
{
JToken id = o["id"];
Product product = new Product();
product.Id = o["id"].Value <int>();
product.Name = o["name"].Value <string>();
product.OS = o["os"].Value <string>();
product.RAM = o["ram"].Value <string>();
product.Size = o["size"].Value <string>();
product.Storage = o["storage"].Value <string>();
product.Weight = o["weight"].Value <string>();
product.Year = o["year"].Value <int>();
product.Camera = o["camera"].Value <string>();
product.CPU = o["cpu"].Value <string>();
product.GPU = o["gpu"].Value <string>();
product.Display = o["display"].Value <string>();
//product.Price = o["price"].Value<decimal>();
product.Price = priceGenerator.Next(100, 300);
product.BrandId = o["brandId"].Value <int>();
product.Updated = timeNow;
if (context != null)
{
context.Products.AddOrUpdate(
c => c.Id,
product
);
Console.WriteLine("Updated state {0}-{1}", product.Id, product.Name);
}
}
}