Exemplo n.º 1
0
 private DatabaseHandler()
 {
     db = new DataContextBuilder(ConnectionString);
 }
Exemplo n.º 2
0
        /// <summary>
        /// Constructor for the Application object.
        /// </summary>
        public App()
        {
            // Global handler for uncaught exceptions.
            UnhandledException += Application_UnhandledException;

            // Standard XAML initialization
            InitializeComponent();

            // Phone-specific initialization
            InitializePhoneApplication();

            // Language display initialization
            InitializeLanguage();

            // Show graphics profiling information while debugging.
            if (Debugger.IsAttached)
            {
                // Display the current frame rate counters
                Current.Host.Settings.EnableFrameRateCounter = true;

                // Show the areas of the app that are being redrawn in each frame.
                //Application.Current.Host.Settings.EnableRedrawRegions = true;

                // Enable non-production analysis visualization mode,
                // which shows areas of a page that are handed off to GPU with a colored overlay.
                //Application.Current.Host.Settings.EnableCacheVisualization = true;

                // Prevent the screen from turning off while under the debugger by disabling
                // the application's idle detection.
                // Caution:- Use this under debug mode only. Application that disables user idle detection will continue to run
                // and consume battery power when the user is not using the phone.
                PhoneApplicationService.Current.UserIdleDetectionMode = IdleDetectionMode.Disabled;
            }

            using (DataContextBuilder db = new DataContextBuilder(DataContextBuilder.DBConnectionString))
            {
                if (db.DatabaseExists() == false)
                {
                    db.CreateDatabase();
                }
            }

            DatabaseHandler    dbHandler = DatabaseHandler.DbHandler;
            DataContextBuilder dbTest    = new DataContextBuilder("DataSource=isostore:/RUISviewDB.sdf");

            Photos photo = new Photos()
            {
                p_Location   = "pLocation",
                p_PhotoName  = "testPhoto",
                p_ShowTime   = 0,
                p_TimesShown = 10
            };

            dbHandler.Interact(0, null, photo);

            Maps map = new Maps();

            map.m_MapLocation = "Testlocation";
            map.m_MapName     = "Testname";

            Photos p2 = new Photos()
            {
                p_Location   = "pLocation2",
                p_PhotoName  = "testPhoto2",
                p_ShowTime   = 2,
                p_TimesShown = 20
            };

            dbHandler.Interact(0, map, null);
            Maps   m = dbTest.Maps.First();
            string s = m.m_MapName;

            photo.m_MapId = m.m_MapId;

            dbHandler.Interact(0, null, p2);
        }