public override void Init(MarbleDataBase database)
{
base.Init(database);
var locations = from d in database.Locationdesc
select d;
foreach (Locationdesc location in locations)
{
_locationMap.Add(location.Name, location.LocationdescID);
}
var images = from d in database.Imagedata
select d;
foreach (ImageData image in images)
{
_imageMap.Add(image.Lowresurl, image.ImageDataID);
}
var features = from d in database.Featuredesc
select d;
foreach (Featuredesc feature in features)
{
_featureMap.Add(feature.LocationID.ToString() + feature.Name, feature.FeaturedescID);
}
}
public override void Init(MarbleDataBase database)
{
base.Init(database);
var locations = from d in database.Locationdesc
select d;
_locationSource = locations.ToList();
}
public override void Init(MarbleDataBase database)
{
base.Init(database);
var missions = from d in database.Dataset
select d;
_dataSetList = missions.ToList();
}
public static void FixInvalidHighResUri()
{
MarbleDataBase db = new MarbleDataBase();
var allImages = from image in db.Imagedata select image;
foreach (ImageData iData in allImages)
{
if (!doesUriExist(iData.Highresurl))
{
Console.WriteLine("HighRes url doesn't exist: " + iData.Highresurl);
iData.Highresurl = iData.Lowresurl;
}
}
db.SaveChanges();
Console.WriteLine("Saved changes from UriChecker");
}
public override void ProcessRecord(string[] tokens)
{
currentCount++;
string locationdesc = tokens[9];
string featuredesc = tokens[10];
//this should throw if it doesn't find anything - should never happen
int locationId = GetLocationID(locationdesc);
if (!features.Exists(f => f.LocationID == locationId && f.Name == featuredesc))
{
Featuredesc feature = new Featuredesc
{
LocationID = locationId,
Name = featuredesc
};
features.Add(feature);
_database.Featuredesc.Add(feature);
if (currentCount > commitCount)
{
_database.SaveChanges();
_database.Dispose();
_database = new MarbleDataBase();
_database.Configuration.AutoDetectChangesEnabled = false;
var featurecheck = from f in _database.Featuredesc
where f.FeaturedescID == feature.FeaturedescID
select f;
foreach (Featuredesc fcheck in featurecheck)
{
Console.WriteLine("{0} {1} {2}", fcheck.FeaturedescID, fcheck.LocationID, fcheck.Name);
}
currentCount = 0;
}
}
}
public override void ProcessRecord(string[] tokens)
{
currentCount++;
string locationdesc = tokens[9];
string featuredesc = tokens[10];
string lowresurl = tokens[11];
int locationId = _locationMap[locationdesc];
featuredesc = locationId.ToString() + featuredesc;
int featureId = _featureMap[featuredesc];
int imageId = _imageMap[lowresurl];
_imageMap.Remove(lowresurl);
Imagexfeature imagexfeature = new Imagexfeature
{
ImageDataID = imageId,
FeaturedescID = featureId,
Priority = 0
};
_database.Imagexfeature.Add(imagexfeature);
if (currentCount > commitCount)
{
_database.SaveChanges();
_database.Dispose();
_database = new MarbleDataBase();
_database.Configuration.AutoDetectChangesEnabled = false;
Console.WriteLine("{0} {1} {2}", imagexfeature.ImagexfeatureID, imagexfeature.ImageDataID, imagexfeature.FeaturedescID);
currentCount = 0;
}
}
public AnimationController()
{
_database = new MarbleDataBase();
_gifImageRange = 10; //defaulting to 10
}
public virtual void Init(MarbleDataBase database)
{
_database = database;
}
public DatasetController()
{
_database = new MarbleDataBase();
}
private static void executeRowImportProcessor()
{
string csvFile = Directory.GetCurrentDirectory() + @"\images.csv";
Console.WriteLine("CSV File: {0}", csvFile);
List<ImageData> images = new List<ImageData>();
DatasetImporter dataSetImporter = new DatasetImporter();
ImageDataImporter imageDataImporter = new ImageDataImporter();
LocationImporter locationImporter = new LocationImporter();
FeatureImporter featureImporter = new FeatureImporter();
ImageXFeatureImporter imagexFeatureImporter = new ImageXFeatureImporter();
STARTPROCESSING:
StreamReader reader = new StreamReader(csvFile);
MarbleDataBase database = new MarbleDataBase();
try
{
//don't need this line
string header = reader.ReadLine();
//this speeds it up
database.Configuration.AutoDetectChangesEnabled = false;
//init processor
switch (ProcessingType)
{
case ProcessorType.DataSet:
Console.WriteLine("Data Set Init");
dataSetImporter.Init(database);
break;
case ProcessorType.ImageData:
Console.WriteLine("Image Data Init");
imageDataImporter.Init(database);
break;
case ProcessorType.Location:
Console.WriteLine("Location Init");
locationImporter.Init(database);
break;
case ProcessorType.Feature:
Console.WriteLine("Feature Init");
featureImporter.Init(database);
break;
case ProcessorType.ImageXFeature:
Console.WriteLine("Imagexfeature Init");
imagexFeatureImporter.Init(database);
break;
}
do
{
try
{
string nextLine = reader.ReadLine();
string[] tokens = nextLine.Split(',');
if (tokens.Length != 12)
{
Console.WriteLine("Not enough tokens, skipping line: " + tokens.ToString());
continue;
}
string missionDesc = tokens[0];
//process data record
switch (ProcessingType)
{
case ProcessorType.DataSet:
dataSetImporter.ProcessRecord(tokens);
break;
case ProcessorType.ImageData:
imageDataImporter.ProcessRecord(tokens);
break;
case ProcessorType.Location:
locationImporter.ProcessRecord(tokens);
break;
case ProcessorType.Feature:
featureImporter.ProcessRecord(tokens);
break;
case ProcessorType.ImageXFeature:
imagexFeatureImporter.ProcessRecord(tokens);
break;
}
}
catch (Exception ex)
{
Console.WriteLine(string.Format("Import of row failed with error '{0}'", ex.ToString()));
}
} while (reader.Peek() >= 0);
}
catch (Exception ex)
{
Console.WriteLine("ERROR, terminating importer");
Console.WriteLine(ex);
}
finally
{
reader.Close();
//finalize data record
switch (ProcessingType)
{
case ProcessorType.DataSet:
Console.WriteLine("Close up dataset");
dataSetImporter.CloseUp();
break;
case ProcessorType.ImageData:
Console.WriteLine("Close up image");
imageDataImporter.CloseUp();
break;
case ProcessorType.Location:
Console.WriteLine("Close up locations");
locationImporter.CloseUp();
break;
case ProcessorType.Feature:
Console.WriteLine("Close up features");
featureImporter.CloseUp();
break;
case ProcessorType.ImageXFeature:
Console.WriteLine("Close up imagexfeature");
imagexFeatureImporter.CloseUp();
break;
}
database.Dispose();
}
if (ProcessingType == ProcessorType.DataSet)
{
ProcessingType = ProcessorType.ImageData;
goto STARTPROCESSING;
}
if (ProcessingType == ProcessorType.ImageData)
{
ProcessingType = ProcessorType.Location;
goto STARTPROCESSING;
}
if (ProcessingType == ProcessorType.Location)
{
ProcessingType = ProcessorType.Feature;
goto STARTPROCESSING;
}
if (ProcessingType == ProcessorType.Feature)
{
ProcessingType = ProcessorType.ImageXFeature;
goto STARTPROCESSING;
}
}
/// <summary>
/// Constructor for FeatureController
/// </summary>
public FeatureController()
{
_database = new MarbleDataBase();
}
double _defaultRange; // default range of miles used when searching for images using a street address
#endregion Fields
#region Constructors
/// <summary>
/// Constructor for ImageController
/// </summary>
public ImageController()
{
_database = new MarbleDataBase();
_defaultRange = 100; //defaulting to 100 miles
}
public LocationController()
{
_database = new MarbleDataBase();
}