static void Main(string[] args)
{
NetmeraClient.init(KEY);
var files = Directory.GetFiles(Directory.GetCurrentDirectory(), "*.sqlite3");
foreach (var f in files)
{
Console.WriteLine("Processing: " + f);
var c = new SQLiteConnection(f);
var survelems = c.Table <Survelem>().ToList();
ProcessSurvelemes(survelems);
c.Close();
c.Dispose();
File.Move(f, f.Replace("sqlite3", "sqlite3+"));
Console.WriteLine("Inserted " + totalNum + "records");
}
Console.WriteLine("Done");
Console.ReadLine();
}
// Do not add any additional code to this method
private void InitializePhoneApplication()
{
if (phoneApplicationInitialized)
{
return;
}
// Create the frame but don't set it as RootVisual yet; this allows the splash
// screen to remain active until the application is ready to render.
RootFrame = new PhoneApplicationFrame();
RootFrame.Navigated += CompleteInitializePhoneApplication;
// Handle navigation failures
RootFrame.NavigationFailed += RootFrame_NavigationFailed;
// Handle reset requests for clearing the backstack
RootFrame.Navigated += CheckForResetNavigation;
new DbService().Initialize();
StateService.ProgressIndicatorService = new ProgressIndicatorService();
//test key
NetmeraClient.init(KEY);
// Ensure we don't initialize again
phoneApplicationInitialized = true;
}
protected override BaseReply Execute(ImportRequest request)
{
_request = request;
_request.CheckIfInserted = true;
var reply = new BaseReply();
NetmeraClient.init(KEY);
if (request.ClearDb)
{
ClearDatabase(DbContext);
}
Import();
return(reply);
}
protected override BaseReply Execute(ImportSurveyorDataRequest request)
{
NetmeraClient.init(ImportRequestHandler.KEY);
_options = DbContext.Options.ToList();
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
var reply = new BaseReply();
if (string.IsNullOrEmpty(request.NetmeraId))
{
var netmeraService = new NetmeraService("Surveyors");
netmeraService.setMax(100);
var surveyors = netmeraService.search();
foreach (var s in surveyors)
{
var o = JsonConvert.DeserializeObject <SurveyorOld>(s.data.ToString());
ImportSurveyoyr(o.id.ToString(), connection);
}
}
else
{
ImportSurveyoyr(request.NetmeraId, connection);
}
return(reply);
}
}
