public void ParseJson()
{
List<RootObject> stations = null;
if (1 > 2)
{
RKConn db = new RKConn();
for (int zoneNo = 192; zoneNo < 195; ++zoneNo)
{
//int zoneNo = 1;
using (StreamReader r = new StreamReader(@"Z:\workspace\holdepladser\zone" + zoneNo + ".json"))
{
string json = r.ReadToEnd();
stations = JsonHelper.DeserializeJson<List<RootObject>>(json, true);
}
foreach (var rootObject in stations)
{
int zoneType = Convert.ToInt32(rootObject.type.nr);
var zone = db.routing_zones.FirstOrDefault(x => x.rot_zon_area_id.Equals(zoneNo));
var ok = new transit_locations
{
rot_zon_id = zone.rot_zon_id,
tra_loc_active = true,
tra_loc_area_id = zoneNo,
tra_loc_title = rootObject.navn,
//transit_type = type,
tra_typ_id = zoneType
};
db.transit_locations.Add(ok);
db.SaveChanges();
}
}
}
Assert.IsNotNull(stations);
}
public SecurityGroupRepository()
{
db = new RKConn();
}
public UserRepository()
{
db = new RKConn();
}
public WithdrawRepository()
{
_db = new RKConn();
}
public RoutingRepository()
{
db = new RKConn();
}
public FareCollectionRepository()
{
_db = new RKConn();
}
public DepositRepository()
{
db = new RKConn();
}
public CityRepository()
{
db = new RKConn();
}
public TransitRepository()
{
_db = new RKConn();
}
public RegisterRepository()
{
_db = new RKConn();
}