示例#1
0
        public static SQLite.SQLiteConnection Connection()
        {
            var conn = new SQLite.SQLiteConnection(DBPath);
            if (!Initialized)
            {
                conn.CreateTable<Car.Car>();
                conn.CreateTable<Fillup.Fillup>();
                conn.CreateTable<Maintenance.Maintenance>();
                conn.CreateTable<Reminder.Reminder>();

                var cars = conn.Table<Car.Car>();

                if (cars.Count() == 0)
                {
                    Car.Car car = new Car.Car();
                    conn.Insert(car);
                }

                var firstCar = cars.First();

                if (cars.Where(vehicle => vehicle.ID == Settings.CurrentCarID).Count() == 0)
                    Settings.CurrentCarID = firstCar.ID;




                Initialized = true;
            }
            return conn;
        }
示例#2
0
        public bool InsertEvent(Event ae1)
        {
            try
            {
                //Create event
                if (db.GetTableInfo("Event").Count == 0)
                {
                    db.CreateTable <Event>();
                }



                int numberOfRows = db.Insert(ae1);
                //Inserted event
                if (numberOfRows > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch
            {
                return(false);
            }
        }
示例#3
0
 public CredentialsService()
 {
     try
     {
         database = DependencyService.Get <ISQLiteSetup>().GetConnection();
         database.CreateTable <Person>();
         database.CreateTable <Verification>();
         if (database.Table <Person>().Count() == 0)
         {
             Person demo = new Person()
             {
                 Name = "John", Surname = "Doe", Admin = true, Position = "Manager"
             };
             database.Insert(demo);
             database.Insert(new Verification()
             {
                 Username = "******", Password = "******", PersonId = demo.Id
             });
         }
         database.CreateTable <CheckInOut>();
     }
     catch (Exception e)
     {
         Debug.WriteLine($"Error instantiating connection to the database!! {e.Message}");
     }
 }
示例#4
0
 public SqlLiteOrderRepository()
 {
     _connection = Xamarin.Forms.DependencyService.Get <ISqlLiteConnection>().GetConnection();
     _connection.CreateTable <OrderEntity>();
     _connection.CreateTable <OrderItemEntity>();
     _connection.CreateTable <OrderCustomerEntity>();
 }
示例#5
0
        public App()
        {
            string fileName     = "StadiYUMdb.db";
            string fileLocation = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal);
            string fullPath     = Path.Combine(fileLocation, fileName);

            DB_PATH = fullPath;
            using (SQLite.SQLiteConnection db = new SQLite.SQLiteConnection(DB_PATH))
            {
                db.DropTable <Concession>();
                db.DropTable <ConcessionItem>();
                db.DropTable <Item>();
                db.DropTable <Order>();
                db.DropTable <RealUser>();
                db.CreateTable <Concession>();
                db.CreateTable <ConcessionItem>();
                db.CreateTable <Item>();
                db.CreateTable <Order>();
                db.CreateTable <RealUser>();
                //var AJBombers = db.Table<Concession>().Where(c => c.Name == "AJ Bombers").FirstOrDefault();
                //ConcessionItem concession1 = new ConcessionItem { ConcessionId = (int)AJBombers.Id, ItemId=0  };
                //db.Insert(concession1);
                //ConcessionItem concession2 = new ConcessionItem { ConcessionId = (int)AJBombers.Id, ItemId = 1 };
                //db.Insert(concession2);
                //ConcessionItem concession3 = new ConcessionItem { ConcessionId = (int)AJBombers.Id, ItemId = 2 };
                //db.Insert(concession3);
                //ConcessionItem concession4 = new ConcessionItem { ConcessionId = (int)AJBombers.Id, ItemId = 3 };
                //db.Insert(concession4);
            }

            InitializeComponent();
            MainPage = new NavigationPage(new MainPage());
        }
示例#6
0
        public bool createDataBase()
        {
            try
            {
                using (var conecction = new SQLite.SQLiteConnection(System.IO.Path.Combine(folder, "AndroidConsultorioDos.db")))
                {
                    /*Crear las tablas Locales*/
                    conecction.CreateTable <Usuario>();
                    conecction.CreateTable <Doctor>();
                    conecction.CreateTable <Paciente>();
                    conecction.CreateTable <PacienteConsulta>();
                    conecction.CreateTable <Estudios>();
                    //Consultorio.Usuario Usuario = new Consultorio.Usuario
                    //{

                    //    Nombre = "Ivan"
                    //    ,User = "******"
                    //    ,Contraseña = "p81bg8f7"
                    //};

                    //conecction.Insert(Usuario);



                    return(true);
                }
            }
            catch (SQLite.SQLiteException ex)
            {
                Log.Info("SQLiteEx", ex.Message);
                return(false);
            }
        }
示例#7
0
        public static async Task NavigateToProfile(Models.FacebookResponse profile)
        {
            if (profile == null)
            {
                Application.Current.MainPage = new NavigationPage(new LoginPage());
                return;
            }

            var apiService = new ApiService();

            var apiSecurity = Application.Current.Resources["APISecurity"].ToString();
            var token       = await apiService.LoginFacebook(
                apiSecurity,
                "/api",
                "/Users/LoginFacebook",
                profile);

            if (token == null)
            {
                Application.Current.MainPage = new NavigationPage(new LoginPage());
                return;
            }

            var user = await apiService.GetUserByEmail(
                apiSecurity,
                "/api",
                "/Users/GetUserByEmail",
                token.TokenType,
                token.AccessToken,
                token.UserName);

            UserLocal userLocal = null;

            if (user != null)
            {
                userLocal = Converter.ToUserLocal(user);

                //Save Local User in SQLite
                using (var conn = new SQLite.SQLiteConnection(App.root_db))
                {
                    conn.CreateTable <UserLocal>();
                    conn.CreateTable <TokenResponse>();

                    conn.Insert(token);
                    conn.Insert(userLocal);
                }
            }

            var mainViewModel = MainViewModel.GetInstance();

            mainViewModel.Token = token;
            mainViewModel.User  = userLocal;

            mainViewModel.Lands          = new LandsViewModel();
            Application.Current.MainPage = new MasterPage();
            Settings.IsRemembered        = "true";

            mainViewModel.Lands          = new LandsViewModel();
            Application.Current.MainPage = new MasterPage();
        }
示例#8
0
        /**
         * Saves the data of a hole
         * game : the game
         * hole : the hole to save
         * save : true to save the hole stats, false otherwise. false returns the ScoreHole anyway
         * return the created ScoreHole
         */
        public static ScoreHole saveForStats(Partie game, Hole hole, bool save)
        {
            ScoreHole h = new ScoreHole(hole, game.getPenalityCount(), game.getCurrentScore(), isHit(game.Shots, hole.Par), nbCoupPutt(game.Shots), DateTime.Now);

            if (save)
            {
                if (game.Shots.Count == 0)
                {
                    throw new Exception("0 shots dans la liste des shots.");
                }
                SQLite.SQLiteConnection connection = DependencyService.Get <ISQLiteDb>().GetConnection();
                connection.CreateTable <Club>();
                connection.CreateTable <MyPosition>();
                connection.CreateTable <Shot>();
                //first let's insert in the database all the shots currently stored in the game
                SQLiteNetExtensions.Extensions.WriteOperations.InsertOrReplaceAllWithChildren(connection, game.Shots, true);
                connection.CreateTable <ScoreHole>();

                //then creates a ScoreHole object that stores the hole statistics and insert it in the database
                SQLiteNetExtensions.Extensions.WriteOperations.InsertWithChildren(connection, h, false);
                string sql = @"select last_insert_rowid()";
                h.Id = connection.ExecuteScalar <int>(sql);
            }
            return(h);
        }
示例#9
0
        async void ButtonClicked(object sender, EventArgs e)
        {
            User user = new User()
            {
                Name     = nameEntry.Text,
                Birthday = (bdayPick.Date).ToShortDateString(),
                Email    = emailEntry.Text,
            };

            if (user.Name == "")
            {
            }
            else
            {
                user.Appointments = new List <Appointment>
                {
                };
                user.Prescriptions = new List <Prescription>
                {
                };
                using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.FilePath))
                {
                    conn.CreateTable <User>();
                    conn.CreateTable <Appointment>();
                    conn.CreateTable <Prescription>();
                    conn.Insert(user);
                    await Navigation.PopModalAsync();
                }
            }
        }
示例#10
0
        /// <summary>
        /// Invoked when the application is launched normally by the end user.  Other entry points
        /// will be used when the application is launched to open a specific file, to display
        /// search results, and so forth.
        /// </summary>
        /// <param name="args">Details about the launch request and process.</param>
        protected override void OnLaunched(LaunchActivatedEventArgs args)
        {
            Frame rootFrame = Window.Current.Content as Frame;

            // Do not repeat app initialization when the Window already has content,
            // just ensure that the window is active
            if (rootFrame == null)
            {
                // Create a Frame to act as the navigation context and navigate to the first page
                rootFrame = new Frame();

                if (args.PreviousExecutionState == ApplicationExecutionState.Terminated)
                {
                    //TODO: Load state from previously suspended application
                }

                // Get a reference to the SQLite database
                this.DBPath = Path.Combine(
                    Windows.Storage.ApplicationData.Current.LocalFolder.Path, "budget.sqlite");

                // Initialize the database if necessary
                using (var db = new SQLite.SQLiteConnection(this.DBPath))
                {
                    // Create the tables if they don't exist
                    db.CreateTable<Budget>();
                    db.CreateTable<BudgetEnvelope>();
                    db.CreateTable<Account>();
                    db.CreateTable<Transaction>();

                    db.DeleteAll<Budget>();

                    db.Insert(new Budget()
                    {
                        Id = 1,
                        PaycheckAmount = 1000.0f,
                        Frequency = PaycheckFrequency.SemiMonthly,
                        Name = "My New Budget"
                    });

                    Budget b = db.Table<Budget>().First();
                }

                // Place the frame in the current Window
                Window.Current.Content = rootFrame;
            }

            if (rootFrame.Content == null)
            {
                // When the navigation stack isn't restored navigate to the first page,
                // configuring the new page by passing required information as a navigation
                // parameter
                if (!rootFrame.Navigate(typeof(MainPage), args.Arguments))
                {
                    throw new Exception("Failed to create initial page");
                }
            }
            // Ensure the current window is active
            Window.Current.Activate();
        }
示例#11
0
 private void CreateTables(SQLite.SQLiteConnection connection)
 {
     connection.CreateTable <MediaStatusEntity>();
     connection.CreateTable <MediaTypeEntity>();
     connection.CreateTable <VersionEntity>();
     connection.CreateTable <FavoriteMusicEntity>();
     connection.CreateTable <FavoriteSportEntity>();
 }
示例#12
0
        async void ButtonClicked(object sender, EventArgs e)
        {
            Conditions cond = new Conditions
            {
                Type = ""
            };

            condition.Type = NameEntry.Text;
            using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.FilePath))
            {
                conn.CreateTable <Conditions>();
                {
                    try
                    {
                        var c = conn.Query <Conditions>("select * from Conditions where Type=?", condition.Type);
                        cond = conn.GetWithChildren <Conditions>(condition.Type);
                    }
                    catch (Exception f)
                    {
                    }
                }
            }
            if (cond.Type.Equals(""))
            {
                using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.FilePath))
                {
                    conn.CreateTable <Conditions>();
                    conn.CreateTable <User>();
                    conn.Insert(condition);
                    conn.UpdateWithChildren(condition);
                    await Navigation.PopModalAsync();
                }
            }
            else
            {
                foreach (User u in cond.Users)
                {
                    if (u.Id == condition.Users[0].Id)
                    {
                        exists = true;
                    }
                }
                if (exists)
                {
                    await DisplayAlert("Oops!", "You already have this condition listed", "OK");
                }
                else
                {
                    cond.Users.Add(condition.Users[0]);
                    using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.FilePath))
                    {
                        conn.CreateTable <Conditions>();
                        conn.UpdateWithChildren(cond);
                    }
                    await Navigation.PopModalAsync();
                }
            }
        }
示例#13
0
        async void ButtonClicked(object sender, EventArgs e)
        {
            bool    exists = false;
            Allergy a      = new Allergy
            {
                Type = ""
            };

            allergy.Type = NameEntry.Text;
            try
            {
                using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.FilePath))
                {
                    conn.CreateTable <Allergy>();
                    var allergies = conn.Query <Allergy>("select * from Allergy where Type=?", allergy.Type);
                    a = conn.GetWithChildren <Allergy>(allergy.Type);
                }
            }
            catch (Exception f)
            {
            }
            if (a.Type.Equals(""))
            {
                using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.FilePath))
                {
                    conn.CreateTable <Allergy>();
                    conn.CreateTable <User>();
                    conn.Insert(allergy);
                    conn.UpdateWithChildren(allergy);
                }
                await Navigation.PopModalAsync();
            }
            else
            {
                foreach (User u in a.Users)
                {
                    if (u.Id == allergy.Users[0].Id)
                    {
                        exists = true;
                        break;
                    }
                }
                if (exists)
                {
                    await DisplayAlert("Oops!", "You already have this allergy listed", "OK");
                }
                else
                {
                    a.Users.Add(allergy.Users[0]);
                    using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.FilePath))
                    {
                        conn.CreateTable <Allergy>();
                        conn.UpdateWithChildren(a);
                    }
                    await Navigation.PopModalAsync();
                }
            }
        }
示例#14
0
 public bool Update(Construction obj)
 {
     using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.DB_PATH))
     {
         conn.CreateTable <Construction>();
         conn.CreateTable <ConstrucionEmployee>();
         return(conn.Update(obj) > 0);
     }
 }
示例#15
0
 public Construction GetWithChildren(int id)
 {
     using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.DB_PATH))
     {
         conn.CreateTable <Construction>();
         conn.CreateTable <ConstrucionEmployee>();
         return(conn.GetWithChildren <Construction>(id));
     }
 }
示例#16
0
 public Construction GetById(int id)
 {
     using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.DB_PATH))
     {
         conn.CreateTable <Construction>();
         conn.CreateTable <ConstrucionEmployee>();
         return(conn.Query <Construction>("SELECT * FROM Construction WHERE ID = ?", id).FirstOrDefault());
     }
 }
 private void SetupDb()
 {
     using (var db = new SQLite.SQLiteConnection(AppState.State.Instance.DbPath))
     {
         db.CreateTable <User>();
         db.CreateTable <Model.ChallengeProgress>();
         db.CreateTable <Model.TaskProgress>();
     }
 }
示例#18
0
        private void DB_Seed()
        {
            using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.DbPath))
            {
                conn.CreateTable <TrackLevel>();
                if (conn.Table <TrackLevel>().Count() == 0)
                {
                    TrackLevel Easy = new TrackLevel()
                    {
                        Name = "Easy", Description = "Easy"
                    };
                    TrackLevel Moderate = new TrackLevel()
                    {
                        Name = "Moderate", Description = "Moderate"
                    };
                    TrackLevel Difficult = new TrackLevel()
                    {
                        Name = "Difficult", Description = "Difficult"
                    };

                    conn.Insert(Easy);
                    conn.Insert(Moderate);
                    conn.Insert(Difficult);
                }

                conn.CreateTable <TrackType>();
                if (conn.Table <TrackType>().Count() == 0)
                {
                    TrackType Enduro = new TrackType()
                    {
                        Name = "Enduro", Description = "Enduro"
                    };
                    TrackType Motocross = new TrackType()
                    {
                        Name = "Motocross", Description = "Motocross"
                    };
                    TrackType Outrides = new TrackType()
                    {
                        Name = "Outrides", Description = "Outrides"
                    };
                    TrackType MountainBike = new TrackType()
                    {
                        Name = "Mountain Bike", Description = "Mountain Bike"
                    };
                    TrackType Other = new TrackType()
                    {
                        Name = "Other", Description = "Other"
                    };

                    conn.Insert(Enduro);
                    conn.Insert(Motocross);
                    conn.Insert(Outrides);
                    conn.Insert(MountainBike);
                    conn.Insert(Other);
                }
            }
        }
示例#19
0
        /// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
        public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
        {
            if (env.IsDevelopment())
            {
                app.UseDeveloperExceptionPage();
            }

            //初始化库
            using var db = new SQLite.SQLiteConnection(Application.FileServerService.SQLiteConn);
            db.CreateTable <Model.SysApp>();
            db.CreateTable <Model.FileRecord>();

            //配置swagger
            app.UseSwagger().UseSwaggerUI(c =>
            {
                c.DocumentTitle = "FileServer API";
                c.SwaggerEndpoint("/swagger/v1/swagger.json", "FileServer API");
                c.InjectStylesheet("/Home/SwaggerCustomStyle");
            });

            //静态资源允许跨域
            app.UseStaticFiles(new StaticFileOptions()
            {
                OnPrepareResponse = (x) =>
                {
                    x.Context.Response.Headers.Add("Access-Control-Allow-Origin", "*");
                },
                ServeUnknownFileTypes = true
            });

            //目录浏览
            string vrootdir = GlobalTo.GetValue("StaticResource:RootDir");
            string prootdir = Fast.PathTo.Combine(GlobalTo.WebRootPath, vrootdir);

            if (!System.IO.Directory.Exists(prootdir))
            {
                System.IO.Directory.CreateDirectory(prootdir);
            }
            app.UseFileServer(new FileServerOptions()
            {
                FileProvider            = new PhysicalFileProvider(prootdir),
                RequestPath             = new Microsoft.AspNetCore.Http.PathString(vrootdir),
                EnableDirectoryBrowsing = GlobalTo.GetValue <bool>("Safe:EnableDirectoryBrowsing"),
                EnableDefaultFiles      = false
            });

            app.UseRouting();

            app.UseAuthorization();

            app.UseEndpoints(endpoints =>
            {
                endpoints.MapControllerRoute(
                    name: "default",
                    pattern: "{controller=Home}/{action=Index}/{id?}");
            });
        }
示例#20
0
 public static void CrearTablas()
 {
     using (SQLite.SQLiteConnection con = new SQLite.SQLiteConnection(App.RutaDB))
     {
         con.DropTable <Models.Employee>();
         con.CreateTable <Models.Employee>();
         con.DropTable <Models.EmployeeProduct>();
         con.CreateTable <Models.EmployeeProduct>();
     }
 }
示例#21
0
 public int Create(Construction obj)
 {
     using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.DB_PATH))
     {
         conn.CreateTable <Construction>();
         conn.CreateTable <ConstrucionEmployee>();
         conn.Insert(obj);
         return(conn.ExecuteScalar <int>("SELECT MAX(Id) FROM Construction"));
     }
 }
示例#22
0
        public static void InitializeTournamentMain(SQLite.SQLiteConnection conn)
        {
            //Need to create all tables for SQLite
            conn.CreateTable <TournamentMain>();
            conn.CreateTable <TournamentMainPlayer>();
            conn.CreateTable <TournamentMainRound>();
            //conn.CreateTable<TournamentMainRoundPlayer>();
            conn.CreateTable <TournamentMainRoundTable>();

            conn.CreateTable <Player>();
        }
示例#23
0
        static DatabaseModel()
        {
            string filename     = "users_db.sqlite";
            string fileLocation = Environment.GetFolderPath(Environment.SpecialFolder.Personal);

            databaseConnection = new SQLite.SQLiteConnection(Path.Combine(fileLocation, filename));
            databaseConnection.CreateTable <User>();
            databaseConnection.CreateTable <ImageInfo>();
            databaseConnection.CreateTable <Emotion>();
            databaseConnection.CreateTable <Group>();
        }
示例#24
0
        public (Dictionary <long, string> Teams, HashSet <long> Results) Get()
        {
            using (var conn2 = new SQLite.SQLiteConnection(_name))
            {
                conn2.CreateTable <Team>();
                conn2.CreateTable <Result>();
                var dictTeams = conn2.Table <Team>().ToList().ToDictionary(_ => _.Id, _ => _.Name);
                var hsResults = new HashSet <long>(conn2.Table <Result>().ToList().Select(_ => _.Id));

                return(dictTeams, hsResults);
            }
        }
示例#25
0
        protected override void OnAppearing()
        {
            base.OnAppearing();
            User user;

            using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.FilePath))
            {
                conn.CreateTable <User>();
                //Ignored if the table already exists
                conn.CreateTable <Doctor>();
                conn.CreateTable <UsersDoctors>();
                conn.CreateTable <Vaccine>();
                conn.CreateTable <Allergy>();
                conn.CreateTable <UsersAllergies>();
                conn.CreateTable <Prescription>();
                conn.CreateTable <Tables.Conditions>();
                conn.CreateTable <UsersConditions>();
                user = conn.GetWithChildren <User>(uid);
            }
            string allergies  = "";
            string conditions = "";

            if (!(user.Allergies.Count == 0))
            {
                using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.FilePath))
                {
                    conn.CreateTable <User>();
                    //Ignored if the table already exists
                    conn.CreateTable <Doctor>();
                    conn.CreateTable <UsersDoctors>();
                    conn.CreateTable <Vaccine>();
                    conn.CreateTable <Allergy>();
                    conn.CreateTable <UsersAllergies>();
                    conn.CreateTable <Prescription>();
                    conn.CreateTable <Tables.Conditions>();
                    user = conn.GetWithChildren <User>(uid);
                }
                foreach (Allergy a in user.Allergies)
                {
                    allergies = allergies + a.Type + ", ";
                }
                allergies = allergies.Remove(allergies.Length - 2);
            }
            if (!(user.Conditions.Count == 0))
            {
                foreach (Tables.Conditions c in user.Conditions)
                {
                    conditions = conditions + c.Type + ", ";
                }
                conditions = conditions.Remove(conditions.Length - 2);
            }
            Allergies.Text  = allergies;
            Name.Text       = user.Name;
            Bday.Text       = user.Birthday;
            Conditions.Text = conditions;
            Email.Text      = user.Email;
        }
 public static void CreateTables()
 {
     _db.CreateTable <Manufacturer>();
     _db.CreateTable <Nozzle>();
     _db.CreateTable <WaterFlow>();
     _db.CreateTable <Pressure>();
     _db.CreateTable <CalcSprayQuality>();
     _db.CreateTable <SprayQuality>();
     _db.CreateTable <WindSpeed>();
     _db.CreateTable <LabelSprayQuality>();
     _db.CreateTable <BoomHeight>();
     _db.CreateTable <Multiplier>();
 }
示例#27
0
        public static void CreateDataBase()
        {
            using (var db = new SQLite.SQLiteConnection(DataBasePath))
            {
                db.CreateTable <DataVersionsEntity>();
                if (!db.Table <DataVersionsEntity>().Any())
                {
                    db.Insert(new DataVersionsEntity());
                }
                db.CreateTable <CategoryLargeEntity>();
                if (!db.Table <CategoryLargeEntity>().Any())
                {
                    db.Insert(new CategoryLargeEntity()
                    {
                        Id = 1, ContentCategoryLargeName = ResourceTexts.CategorySpecial, IconFileName = nameof(ResourceImages.CategorySpecial)
                    });
                    db.Insert(new CategoryLargeEntity()
                    {
                        Id = 4, ContentCategoryLargeName = ResourceTexts.CategoryTransferLife, IconFileName = nameof(ResourceImages.CategoryTransferLife)
                    });
                    db.Insert(new CategoryLargeEntity()
                    {
                        Id = 5, ContentCategoryLargeName = ResourceTexts.CategoryStaySpring, IconFileName = nameof(ResourceImages.CategoryStaySpring)
                    });
                    db.Insert(new CategoryLargeEntity()
                    {
                        Id = 2, ContentCategoryLargeName = ResourceTexts.CategoryGourmet, IconFileName = nameof(ResourceImages.CategoryGourmet)
                    });
                    db.Insert(new CategoryLargeEntity()
                    {
                        Id = 3, ContentCategoryLargeName = ResourceTexts.CategoryLocalGourmet, IconFileName = nameof(ResourceImages.CategoryLocalGourmet)
                    });
                    db.Insert(new CategoryLargeEntity()
                    {
                        Id = 6, ContentCategoryLargeName = ResourceTexts.CategoryToiletParking, IconFileName = nameof(ResourceImages.CategoryToiletParking)
                    });
                    db.Insert(new CategoryLargeEntity()
                    {
                        Id = 7, ContentCategoryLargeName = ResourceTexts.CategoryPresent, IconFileName = nameof(ResourceImages.CategoryPresent)
                    });
                }
                db.CreateTable <ContentSummaryEntity>();
                db.CreateTable <ContentDetailEntity>();

                // Plugins
                foreach (var plugin in App.Plugins)
                {
                    plugin.CreateDataBase(db);
                }
            }
        }
示例#28
0
        /// <summary>
        /// Tworzy potrzebne tabele w bazie danych
        /// Tworzy folder do zapisu tresci notatek
        /// </summary>
        private void CreateTables()
        {
            using (SQLite.SQLiteConnection cn = new SQLite.SQLiteConnection(DatabaseHelper.dbFile))
            {
                cn.CreateTable <Notebook>();
                cn.CreateTable <Note>();
            }

            //utworzenie folderu na notatki
            if (!Directory.Exists(NotesPath))
            {
                Directory.CreateDirectory(NotesPath);
            }
        }
示例#29
0
        public DataBase()
        {
            var path = GetDatabasePath(DBFileName);

            if (!File.Exists(path))
            {
                database = new SQLite.SQLiteConnection(path);
                database.CreateTable <ModelCategory>();
                database.CreateTable <ModelDataFile>();
            }
            else
            {
                database = new SQLite.SQLiteConnection(path);
            }
        }
示例#30
0
        private void Button_Clicked(object sender, EventArgs e)
        {
            if (zvali == -1)
            {
                DisplayAlert("Greška", "Stisnite na MI / VI kako biste odabrali ekipu koja je zvala.", "Ok");
                return;
            }
            if (String.IsNullOrWhiteSpace(miRezEntry.Text) ||
                !miRezEntry.Text.All(char.IsDigit) ||
                String.IsNullOrWhiteSpace(viRezEntry.Text) ||
                !viRezEntry.Text.All(char.IsDigit))
            {
                DisplayAlert("Greška", "Unesite pravilne podatke.", "Ok");
                return;
            }

            GetResult(ref a, ref b, ref c, ref d);

            using (SQLite.SQLiteConnection connection = new SQLite.SQLiteConnection(App.DB_PATH))
            {
                connection.CreateTable <Result>();
                if (resultToChange == null)
                {
                    connection.CreateTable <Result>();
                    connection.Insert(new Result {
                        MiResult = b, ViResult = d, MiZvanje = a, ViZvanje = c, Zvali = zvali
                    });
                }
                else
                {
                    resultToChange.MiResult = b;
                    resultToChange.ViResult = d;
                    resultToChange.MiZvanje = a;
                    resultToChange.ViZvanje = c;
                    resultToChange.Zvali    = zvali;
                    connection.Update(resultToChange);
                }
            }

            if (CheckPad())
            {
                Application.Current.MainPage.Navigation.PushAsync(new Pad(this));
            }
            else
            {
                Zavrsi();
            }
        }
        /// <summary>
        /// Invoked when the application is launched normally by the end user.  Other entry points
        /// will be used when the application is launched to open a specific file, to display
        /// search results, and so forth.
        /// </summary>
        /// <param name="args">Details about the launch request and process.</param>
        protected override void OnLaunched(LaunchActivatedEventArgs args)
        {
            Frame rootFrame = Window.Current.Content as Frame;

            // Do not repeat app initialization when the Window already has content,
            // just ensure that the window is active
            if (rootFrame == null)
            {
                // Create a Frame to act as the navigation context and navigate to the first page
                rootFrame = new Frame();
                //Associate the frame with a SuspensionManager key
                SuspensionManager.RegisterFrame(rootFrame, "AppFrame");

                if (args.PreviousExecutionState == ApplicationExecutionState.Terminated)
                {
                    //TODO: Load state from previously suspended application
                }

                // Get a reference to the SQLite database
                DBPath = Path.Combine(
                    Windows.Storage.ApplicationData.Current.LocalFolder.Path, "customers.s3db");
                // Initialize the database if necessary
                using (var db = new SQLite.SQLiteConnection(DBPath))
                {
                    // Create the tables if they don't exist
                    db.CreateTable <Customer>();
                    db.CreateTable <Project>();
                }

                ResetData();

                // Place the frame in the current Window
                Window.Current.Content = rootFrame;
            }

            if (rootFrame.Content == null)
            {
                // When the navigation stack isn't restored navigate to the first page,
                // configuring the new page by passing required information as a navigation
                // parameter
                if (!rootFrame.Navigate(typeof(MainPage), args.Arguments))
                {
                    throw new Exception("Failed to create initial page");
                }
            }
            // Ensure the current window is active
            Window.Current.Activate();
        }
示例#32
0
        private void Button_Clicked(object sender, EventArgs e)
        {
            Journal journal = new Journal()
            {
                JournalName   = titleEntry.Text,
                JournalDetail = detailEntry.Text,
                PostDate      = DateTime.Now
            };

            //create connection to database. when you use "using", you dont need close connection
            using (SQLite.SQLiteConnection conn = new SQLite.SQLiteConnection(App.DB_PATH))
            {
                //make sure the table exist
                conn.CreateTable <Journal>();
                //number of rows in table
                var numberOfRows = conn.Insert(journal);

                if (numberOfRows > 0)
                {
                    DisplayAlert("Success", "Journal succesfully inserted", "Great!");
                }
                else
                {
                    DisplayAlert("Failure", "Journal failed to be inserted", "Dang it!");
                }
            }

            Navigation.PushAsync(new MainPage());
        }
示例#33
0
		private void CreateTable()
		{
			using (var conn = new SQLite.SQLiteConnection(GetDatabasePath()))
			{
				conn.CreateTable<Person>();
			}
		}
        private void btnAdd_Click(object sender, RoutedEventArgs e)
        {

            if (FieldValidationExtensions.GetIsValid(AddressbookUserName) && FieldValidationExtensions.GetIsValid(AddressbookEmail))
            {

                var dbPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
                using (var db = new SQLite.SQLiteConnection(dbPath))
                {
                    db.CreateTable<AddressBookEntree>();

                    User addressbookuser = new User();
                    addressbookuser.UserName = AddressbookUserName.Text;
                    addressbookuser.EmailAddress = AddressbookEmail.Text;

                    db.RunInTransaction(() =>
                    {
                        db.Insert(addressbookuser);

                        db.Insert(new AddressBookEntree() { OwnerUserID = App.loggedInUser.Id, EntreeUserID = addressbookuser.Id });
                    });
                }

            }

            this.Frame.Navigate(typeof(Dashboard));

        }
示例#35
0
        /// <summary>
        /// Invoked when the application is launched normally by the end user.  Other entry points
        /// will be used when the application is launched to open a specific file, to display
        /// search results, and so forth.
        /// </summary>
        /// <param name="args">Details about the launch request and process.</param>
        protected override void OnLaunched(LaunchActivatedEventArgs args)
        {
            // Initialize the database if necessary
            using (var db = new SQLite.SQLiteConnection(DBPath))
            {
                // Create the tables if they don't exist
                db.CreateTable<Day>();
                db.CreateTable<Intake>();
                Day day = new Day();
                day.Date = DateTime.Today;
                db.Insert(day);
            }

            CurrentDay = DayViewModel.GetDayByDate(DateTime.Today);

            Frame rootFrame = Window.Current.Content as Frame;

            // Do not repeat app initialization when the Window already has content,
            // just ensure that the window is active
            if (rootFrame == null)
            {
                // Create a Frame to act as the navigation context and navigate to the first page
                rootFrame = new Frame();

                if (args.PreviousExecutionState == ApplicationExecutionState.Terminated)
                {
                    //TODO: Load state from previously suspended application
                }

                // Place the frame in the current Window
                Window.Current.Content = rootFrame;
            }

            if (rootFrame.Content == null)
            {
                // When the navigation stack isn't restored navigate to the first page,
                // configuring the new page by passing required information as a navigation
                // parameter
                if (!rootFrame.Navigate(typeof(MainPage), args.Arguments))
                {
                    throw new Exception("Failed to create initial page");
                }
            }

            // Ensure the current window is active
            Window.Current.Activate();
        }
示例#36
0
        private async void Button_Click_1(object sender, RoutedEventArgs e)
        {
            baza = TextBoxNazwaNowejBazy.Text;
            string komunikat = textboxkomunikatistniejacabaza.Text;
            string komunikat2 = TextBoxKomunikatNazwaZastrzezona.Text;
            string komunikat3 = TextBoxZaKrotkaNazwa.Text;
            
            if (baza.Equals("AppData") | baza.Equals("eFiszki") | baza.Equals("efiszki"))
                {
                    MessageDialog dialog = new MessageDialog(komunikat2);
                    await dialog.ShowAsync();
                }
            else if (baza.Length < 2)
            {
                MessageDialog dialog = new MessageDialog(komunikat3);
                await dialog.ShowAsync();

            }

            else
            {
                StorageFolder folder = Windows.Storage.ApplicationData.Current.LocalFolder;
                IReadOnlyList<StorageFile> fList = await folder.GetFilesAsync();
                int sprawdz = 0;
                foreach (var f in fList)
                {
                    if (baza.Equals(f.DisplayName))
                    {
                        sprawdz = 1;
                    }
                };

                if (sprawdz == 1)
                {
                    MessageDialog dialog = new MessageDialog(komunikat);
                    await dialog.ShowAsync();
                }
                else
                {
                    string DBPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, baza + ".sqlite");
                    using (var db = new SQLite.SQLiteConnection(DBPath))
                    {
                        db.CreateTable<UserDefaultDataBase>();
                    }


                    this.Frame.Navigate(typeof(DodajSlowko));

                }


            }
            
        }
 private List<OldMessageSettings> loadOldMessages()
 {
     var oldMessages = new List<OldMessageSettings>();
     using (var db = new SQLite.SQLiteConnection(this.DBPath))
     {
         db.CreateTable<OldMessageSettings>();
         foreach (var oldMessage in db.Table<OldMessageSettings>().OrderByDescending(msg => msg.Added))
         {
             oldMessages.Add(oldMessage);
         }
     }
     return oldMessages;
 }
 private List<FavoriteMessageSettings> loadFavoriteMessage()
 {
     var favMessages = new List<FavoriteMessageSettings>();
     using (var db = new SQLite.SQLiteConnection(this.DBPath))
     {
         db.CreateTable<FavoriteMessageSettings>();
         foreach (var favMessage in db.Table<FavoriteMessageSettings>().OrderByDescending(msg => msg.Added))
         {
             favMessages.Add(favMessage);
         }
     }
     return favMessages;
 }
        public EmprestimoViewModel()
        {
            using (var db = new SQLite.SQLiteConnection(DB_PATH))
            {
                db.CreateTable<Model.Emprestimo>();
            }

            ListaDeEmprestimos = GetAllEmprestimos();

            ListaDeEmprestimosAtivos = ListaDeEmprestimos.Where(i => !i.DataDevolucao.HasValue).ToList();

            SalvarEmprestimo = new ViewModel.DelegateCommand<Model.Emprestimo>(Salvar);
            DevolverLivro = new ViewModel.DelegateCommand<Model.Emprestimo>(Devolver);
            VisualizarEmprestimo = new ViewModel.DelegateCommand<Model.Emprestimo>(Visualizar);
        }
示例#40
0
        public static Array BindRequests()
        {
            var dbPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
            using (var db = new SQLite.SQLiteConnection(dbPath))
            {
                db.CreateTable<Appointment>();

                var appoinmentquery = (from x in db.Table<Appointment>()
                                       where x.OwnerUserID == App.loggedInUser.Id
                                       orderby x.Date
                                       select x).ToArray();

                return appoinmentquery;
            }
        }
示例#41
0
        private void btnRegister_Click(object sender, RoutedEventArgs e)
        {
            if (FieldValidationExtensions.GetIsValid(RegisterUserName) && FieldValidationExtensions.GetIsValid(RegisterPassword) && FieldValidationExtensions.GetIsValid(RegisterEmail))
            {
                var dbPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
                using (var db = new SQLite.SQLiteConnection(dbPath))
                {
                    db.CreateTable<User>();

                    db.RunInTransaction(() =>
                        {
                            db.Insert(new User() { UserName = RegisterUserName.Text, PassWord = RegisterPassword.Password, EmailAddress = RegisterEmail.Text });
                        });
                }

                this.Frame.Navigate(typeof(MainPage));
            }
        }
示例#42
0
        public UsuarioViewModel()
        {
            using (var db = new SQLite.SQLiteConnection(DB_PATH))
            {
                db.CreateTable<Model.Usuario>();
            }

            ListaDeUsuarios = GetAllUsuario().Where(i => String.IsNullOrEmpty(i.Senha)).ToList();

            ListaDeUsuariosComSenha = GetAllUsuario().Where(i => !String.IsNullOrEmpty(i.Senha)).ToList();

            DeleteUsuario = new ViewModel.DelegateCommand<Model.Usuario>(Delete);
            UpdateUsuario = new ViewModel.DelegateCommand<Model.Usuario>(Update);
            EditUsuario = new ViewModel.DelegateCommand<Model.Usuario>(Edit);
            SalvarUsuarioAcesso = new ViewModel.DelegateCommand<Model.Usuario>(Salvar);
            LoginUsuario = new ViewModel.DelegateCommand<Model.Usuario>(Logar);
            SelecionarUsuarioParaEmprestimo = new ViewModel.DelegateCommand<Model.Usuario>(SelecionarParaEmprestimo);
        }
示例#43
0
        /// <summary>
        /// Invoked when the application is launched normally by the end user.  Other entry points
        /// will be used when the application is launched to open a specific file, to display
        /// search results, and so forth.
        /// </summary>
        /// <param name="args">Details about the launch request and process.</param>
        protected override void OnLaunched(LaunchActivatedEventArgs args)
        {
            Frame rootFrame = Window.Current.Content as Frame;

            // Do not repeat app initialization when the Window already has content,
            // just ensure that the window is active
            if (rootFrame == null)
            {
                // Create a Frame to act as the navigation context and navigate to the first page
                rootFrame = new Frame();

                if (args.PreviousExecutionState == ApplicationExecutionState.Terminated)
                {
                    //TODO: Load state from previously suspended application
                }

                // Place the frame in the current Window
                Window.Current.Content = rootFrame;
            }

            DBPath = Path.Combine(
                Windows.Storage.ApplicationData.Current.LocalFolder.Path, "customers.s3db");
            // Initialize the database if necessary
            using (var db = new SQLite.SQLiteConnection(DBPath))
            {
                // Create the tables if they don't exist
                db.CreateTable<Customer>();
            }

            LoadData();

            if (rootFrame.Content == null)
            {
                // When the navigation stack isn't restored navigate to the first page,
                // configuring the new page by passing required information as a navigation
                // parameter
                if (!rootFrame.Navigate(typeof(MainPage), args.Arguments))
                {
                    throw new Exception("Failed to create initial page");
                }
            }
            // Ensure the current window is active
            Window.Current.Activate();
        }
示例#44
0
            public void addMeterBox(string meterBoxNumber, double current)
            {
                
                string result = string.Empty;
                using (var db = new SQLite.SQLiteConnection(app.DBPath))
                    try
                    {
                        db.CreateTable<MeterBox>();
                        int success1 = db.Insert(new MeterBox()
                        {
                            ID = 0,
                            meterBoxNumber = meterBoxNumber,
                            currentUnits = current
                        });
                        var existing = db.Query<MeterBox>("select * from MeterBox").First();
                        if (existing == null)
                        {
                                int success = db.Insert(new MeterBox()
                            {
                                ID = 0,
                                meterBoxNumber = meterBoxNumber,
                                currentUnits = current
                            });
                        }
                        else if(existing != null)
                        {
                            existing.meterBoxNumber = meterBoxNumber;
                            existing.currentUnits = current;
                            db.RunInTransaction(() =>
                            {
                                db.Update(existing);
                            });
                        }
                  
                    }
                    catch (Exception e)
                    {

                    }
                //return "Success";
            }
示例#45
0
        public static Array BindAddressBook()
        {
            var dbPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
            using (var db = new SQLite.SQLiteConnection(dbPath))
            {
                db.CreateTable<AddressBookEntree>();

                var addressquery = (from x in db.Table<AddressBookEntree>()
                                    where x.OwnerUserID == App.loggedInUser.Id
                                    select x).ToArray();

                var tempquery = addressquery.Select(x => x.EntreeUserID).ToArray();

                var userquery = (from x in db.Table<User>()
                                 where tempquery.Contains(x.Id)
                                 select x).ToArray();


                return userquery;
            }
        }
示例#46
0
		public override void ViewDidLoad ()
		{
			base.ViewDidLoad ();

			#region observadores del teclado
			// Keyboard popup
			NSNotificationCenter.DefaultCenter.AddObserver
			(UIKeyboard.DidShowNotification,KeyBoardUpNotification);

			// Keyboard Down
			NSNotificationCenter.DefaultCenter.AddObserver
			(UIKeyboard.WillHideNotification,KeyBoardDownNotification);
			#endregion

			if (UIDevice.CurrentDevice.UserInterfaceIdiom == UIUserInterfaceIdiom.Phone) {
				this.cmpContraseñaIphone.SecureTextEntry = true;
			} else {
				this.cmpContraseña.SecureTextEntry = true;
			}
				
			// Figure out where the SQLite database will be.
			var documents = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
			_pathToDatabase = Path.Combine(documents, "db_sqlite-net.db");

			this.btnEntrar.TouchUpInside += (sender, e) => {
				try{
					if (UIDevice.CurrentDevice.UserInterfaceIdiom == UIUserInterfaceIdiom.Phone) {
						contraseña = cmpContraseñaIphone;
					} else{
						contraseña = cmpContraseña;
					}
					if(cmpEmail.Text == "" || contraseña.Text == ""){
						UIAlertView alert = new UIAlertView () { 
							Title = "Espera!", Message = "Debes ingresar tu email y tu contraseña primero"
						};
						alert.AddButton ("Aceptar");
						alert.Show ();
					} else{
						//Creamos la base de datos y la tabla de persona
						using (var conn= new SQLite.SQLiteConnection(_pathToDatabase))
						{
							conn.DropTable<Person>();
							conn.CreateTable<Person>();
						}
						if(UIDevice.CurrentDevice.UserInterfaceIdiom == UIUserInterfaceIdiom.Phone){
							loginService.setUserData(cmpEmail.Text.Trim(), cmpContraseñaIphone.Text);
						}else{
							loginService.setUserData(cmpEmail.Text.Trim(), cmpContraseña.Text);
						}

						LoginService userData = loginService.Find();

						if(userData.Id.Equals("Invalido")){
							UIAlertView alert = new UIAlertView () { 
								Title = "Lo sentimos", Message = "Tus datos fueron invalidos, intentalo de nuevo"
							};
							alert.AddButton ("Aceptar");
							alert.Show ();
						}else{
							var person = new Person {ID = int.Parse(userData.Id),  Name = userData.nombre, LastName = userData.paterno, SecondLastName = userData.materno};
							using (var db = new SQLite.SQLiteConnection(_pathToDatabase ))
							{
								db.Insert(person);
							}
							UIAlertView alert = new UIAlertView () { 
								Title = "Bienvenido", Message = "Bienvenido a Fixbuy " + userData.nombre
							};
							alert.AddButton ("Aceptar");
							alert.Show ();
							Console.WriteLine("Este el es ID de usuario: " + userData.Id);
							this.NavigationController.PopViewController(true);
						}
					}
				}catch(System.Net.WebException){
					UIAlertView alerta = new UIAlertView () { 
						Title = "Ups =S", Message = "Algo salio mal, verifica tu conexión a internet e intentalo de nuevo"
					};
					alerta.AddButton ("Aceptar");
					alerta.Show ();
				}catch(Exception){
					UIAlertView alerta = new UIAlertView () { 
						Title = "Ups =S", Message = "Algo salio mal, por favor intentalo de nuevo"
					};
					alerta.AddButton ("Aceptar");
					alerta.Show ();
				}
			};

			this.btnRegistro.TouchUpInside += (sender, e) => {
				RegistryView registry = new RegistryView();
				this.NavigationController.PushViewController(registry, true);
			};
		}
示例#47
0
        /// <summary>
        /// Invoked when the application is launched normally by the end user.  Other entry points
        /// will be used such as when the application is launched to open a specific file.
        /// </summary>
        /// <param name="e">Details about the launch request and process.</param>
        protected override void OnLaunched(LaunchActivatedEventArgs e)
        {
            #if DEBUG
            if (System.Diagnostics.Debugger.IsAttached)
            {
                this.DebugSettings.EnableFrameRateCounter = true;
            }
            #endif

            Frame rootFrame = Window.Current.Content as Frame;

            // Do not repeat app initialization when the Window already has content,
            // just ensure that the window is active
            if (rootFrame == null)
            {
                // Create a Frame to act as the navigation context and navigate to the first page
                rootFrame = new Frame();
                // Set the default language
                rootFrame.Language = Windows.Globalization.ApplicationLanguages.Languages[0];

                rootFrame.NavigationFailed += OnNavigationFailed;

                if (e.PreviousExecutionState == ApplicationExecutionState.Terminated)
                {
                    //TODO: Load state from previously suspended application
                }

                this.DBPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "journal.sqlite");

                using (var db = new SQLite.SQLiteConnection(this.DBPath))
                {
                    db.CreateTable<JournalEntry>();
                }

                //ResetData.ResetDBData();
                // Place the frame in the current Window
                Window.Current.Content = rootFrame;
            }

            if (rootFrame.Content == null)
            {
                // When the navigation stack isn't restored navigate to the first page,
                // configuring the new page by passing required information as a navigation
                // parameter
                rootFrame.Navigate(typeof(MainPage), e.Arguments);
            }
            // Ensure the current window is active
            Window.Current.Activate();
        }
示例#48
0
        protected void initializeDatabase()
        {
            var docsFolder = System.Environment.GetFolderPath (System.Environment.SpecialFolder.MyDocuments);
            var pathToDatabase = System.IO.Path.Combine (docsFolder, "db_sqlnet.db");

            using (var connection= new SQLite.SQLiteConnection(pathToDatabase))
            {
                var info = connection.GetTableInfo ("GcmMessage");

                if (!info.Any ()) {
                    connection.CreateTable<GcmMessage> ();
                    Console.WriteLine ("Creating database ....");
                } else {
                    Console.WriteLine ("Database exists");
                }
            }
        }
示例#49
0
        private void LoadUserInfo()
        {
            this.siteList.Items.Clear();
            ListItemTemplate addNew = new ListItemTemplate();
            addNew.siteTitle.Text = "+ Add Account";
            this.siteList.Items.Add(addNew);

            var dbPath = System.IO.Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, dbName);
            SiteListSolution siteList = new SiteListSolution();
            if (IsInternet())
            {
                connectTest.Visibility = Windows.UI.Xaml.Visibility.Collapsed;
                connectTest2.Visibility = Windows.UI.Xaml.Visibility.Visible;
                using (var db = new SQLite.SQLiteConnection(dbPath))
                {
                    db.CreateTable<Authorization>();
                    ObservableCollection<Authorization> list = new ObservableCollection<Authorization>(db.Query<Authorization>("select * from Authorization"));
                    for (int i = 0; i < list.Count; i++)
                    {
                        if (list[i].Site.Equals("Facebook"))
                        {
                            siteList.FacebookHandle(list[i].AccessToken, this.siteList);
                        }
                    }
                }
            }
            else
            {
                connectTest2.Visibility = Windows.UI.Xaml.Visibility.Collapsed;
                connectTest.Visibility = Windows.UI.Xaml.Visibility.Visible;
            }
           
        }
示例#50
0
        /// <summary>
        /// Invoked when the application is launched normally by the end user.  Other entry points
        /// will be used when the application is launched to open a specific file, to display
        /// search results, and so forth.
        /// </summary>
        /// <param name="e">Details about the launch request and process.</param>
        protected override void OnLaunched(LaunchActivatedEventArgs e)
        {
#if DEBUG
            if (System.Diagnostics.Debugger.IsAttached)
            {
                this.DebugSettings.EnableFrameRateCounter = true;
            }
#endif
            try
            {
                this.dbPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "Studdy.db");
                using (var dbase = new SQLite.SQLiteConnection(dbPath))
                {
                    dbase.CreateTable<Accounting>();
                    dbase.CreateTable<Business>();
                    dbase.CreateTable<English>();
                    dbase.CreateTable<Geography>();
                    dbase.CreateTable<History>();
                    dbase.CreateTable<Life>();
                    dbase.CreateTable<Physics>();
                    dbase.CreateTable<Maths>();

                }


            }
            catch
            {

            }

            Frame rootFrame = Window.Current.Content as Frame;

            // Do not repeat app initialization when the Window already has content,
            // just ensure that the window is active
            if (rootFrame == null)
            {
                // Create a Frame to act as the navigation context and navigate to the first page
                rootFrame = new Frame();

                // TODO: change this value to a cache size that is appropriate for your application
                rootFrame.CacheSize = 1;

                if (e.PreviousExecutionState == ApplicationExecutionState.Terminated)
                {
                    // TODO: Load state from previously suspended application
                }

                // Place the frame in the current Window
                Window.Current.Content = rootFrame;
            }

            if (rootFrame.Content == null)
            {
#if WINDOWS_PHONE_APP
                // Removes the turnstile navigation for startup.
                if (rootFrame.ContentTransitions != null)
                {
                    this.transitions = new TransitionCollection();
                    foreach (var c in rootFrame.ContentTransitions)
                    {
                        this.transitions.Add(c);
                    }
                }

                rootFrame.ContentTransitions = null;
                rootFrame.Navigated += this.RootFrame_FirstNavigated;
#endif

                // When the navigation stack isn't restored navigate to the first page,
                // configuring the new page by passing required information as a navigation
                // parameter
                if (!rootFrame.Navigate(typeof(DemoPage), e.Arguments))
                {
                    throw new Exception("Failed to create initial page");
                }
            }

            // Ensure the current window is active
            Window.Current.Activate();
        }
示例#51
0
        public static void Insert()
        {
            var entities = GetEntities().ToArray();
            using (Siaqodb siaqodb = new Siaqodb())
            {
                siaqodb.Open(siaqodbPath, 100 * OneMB, 20);

                Console.WriteLine("InsertSiaqodb...");
                var stopwatch = new Stopwatch();
                stopwatch.Start();

                for (int i = 0; i < ENTITY_COUNT; i++)
                {
                    siaqodb.StoreObject(entities[i]);
                }

                stopwatch.Stop();
                Console.WriteLine("InsertSiaqodb took:" + stopwatch.Elapsed);

            }

            using (var dbsql = new SQLite.SQLiteConnection(sqLitePath))
            {
                dbsql.CreateTable<MyEntity>();
                Console.WriteLine("InsertSQLite...");
                var stopwatch = new Stopwatch();
                stopwatch.Start();

                for (int i = 0; i < ENTITY_COUNT; i++)
                {
                    dbsql.Insert(entities[i]);
                }

                stopwatch.Stop();
                Console.WriteLine("InsertSQLite took:" + stopwatch.Elapsed);
            }
        }
示例#52
0
 //        void ExitApp ()
 //        {
 //            ((GlobalvarsApp)this.Application).ISLOGON = false;
 //            Finish ();
 //            Android.OS.Process.KillProcess (Android.OS.Process.MyPid ());
 //
 //        }
 void createTable(string pathToDatabase)
 {
     using (var conn= new SQLite.SQLiteConnection(pathToDatabase))
     {
         conn.CreateTable<Item>();
         conn.CreateTable<Invoice>();
         conn.CreateTable<InvoiceDtls>();
         conn.CreateTable<Trader> ();
         conn.CreateTable<AdUser> ();
         conn.CreateTable<CompanyInfo> ();
         conn.CreateTable<AdPara> ();
         conn.CreateTable<AdNumDate> ();
         conn.CreateTable<CNNote>();
         conn.CreateTable<CNNoteDtls>();
         conn.CreateTable<SaleOrder>();
         conn.CreateTable<SaleOrderDtls>();
         conn.CreateTable<DelOrder>();
         conn.CreateTable<DelOrderDtls>();
     }
 }
示例#53
0
        private void ResetData()
        {
            using (var db = new SQLite.SQLiteConnection(this.DBPath))
            {
                // Empty the Customer and Project tables 
                //db.DeleteAll<Collection>();
                //db.DeleteAll<Album>();
                db.DropTable<Collection>();
                db.DropTable<Album>();
                db.CreateTable<Collection>();
                db.CreateTable<Album>();

                // Add seed customers and projects
                db.Insert(new Collection()
                {
                    Id = 1,
                    Title = "Relaxing Music",
                    DateCreated = DateTime.Now.AddDays(-3),
                    Image = "Assets/DarkGray.png",
                    Void = false
                });
                db.Insert(new Collection()
                {
                    Id = 2,
                    Title = "Hardcore Metal",
                    DateCreated = DateTime.Now.AddDays(-2),
                    Image = "Assets/MediumGray.png",
                    Void = false
                });
                db.Insert(new Collection()
                {
                    Id = 3,
                    Title = "Best 90s Music",
                    DateCreated = DateTime.Now.AddDays(-1),
                    Image = "Assets/LightGray.png",
                    Void = false
                });
                db.Insert(new Album()
                {
                    Id = 1,
                    Title = "Believe",
                    Artist = "Cher",
                    CollectionId = 1,
                    LastFmId = "2026126",
                    MusicBrainzId = "61bf0388-b8a9-48f4-81d1-7eb02706dfb0",
                    DateAdded = DateTime.Now.AddDays(-4),
                    Void = false
                });
                db.Insert(new Album()
                {
                    Id = 2,
                    Title = "Believe 2",
                    Artist = "Cher",
                    CollectionId = 1,
                    LastFmId = "2026126",
                    MusicBrainzId = "61bf0388-b8a9-48f4-81d1-7eb02706dfb0",
                    DateAdded = DateTime.Now.AddDays(-3),
                    Void = false
                });
                db.Insert(new Album()
                {
                    Id = 3,
                    Title = "Believe 3",
                    Artist = "Cher",
                    CollectionId = 2,
                    LastFmId = "2026126",
                    MusicBrainzId = "61bf0388-b8a9-48f4-81d1-7eb02706dfb0",
                    DateAdded = DateTime.Now.AddDays(-2),
                    Void = false
                });
                db.Insert(new Album()
                {
                    Id = 4,
                    Title = "Believe 4",
                    Artist = "Cher",
                    CollectionId = 3,
                    LastFmId = "2026126",
                    MusicBrainzId = "61bf0388-b8a9-48f4-81d1-7eb02706dfb0",
                    DateAdded = DateTime.Now.AddDays(-1),
                    Void = false
                });

                //2026126","mbid":"61bf0388-b8a9-48f4-81d1-7eb02706dfb0"
                
            }
        }
示例#54
0
		public override void ViewDidLoad ()
		{
			base.ViewDidLoad ();
			
			//Declaramos el actionsheet donde se mostrara el picker
			//actionSheetPicker = new ActionSheetPicker(this.View, null);
			this.pickerStates.Hidden = true;
			this.btnAceptar.Hidden = true;
			//Declaramos el data model para el estado
			pickerDataModel = new PickerDataModel ();
			//Declaramos el data model para la localidad
			pickerDataModelLocality = new PickerDataModelLocality ();

			var documents = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
			_pathToDatabase = Path.Combine(documents, "db_sqlite-net.db");

			using (var db = new SQLite.SQLiteConnection(_pathToDatabase ))
			{
				states = new List<State> (from s in db.Table<State> () select s);
			}

			if(states.Count > 0){
				State estado = states.ElementAt(0);
				this.btnEstado.SetTitle (estado.state, UIControlState.Normal);
				this.btnLocalidad.SetTitle (estado.locality, UIControlState.Normal);
			}

			this.btnEstado.TouchUpInside += (sender, e) => {
				try{
					statesService = new StatesService();
					List<StatesService> estados = statesService.All();
					pickerDataModel.Items = estados;
					pickerStates.Model = pickerDataModel;
					pickerStates.Hidden = false;
					btnAceptar.Hidden = false;
					//actionSheetPicker.Picker.Source = pickerDataModel;
					//actionSheetPicker.Show();
				}catch (System.Net.WebException){
					UIAlertView alert = new UIAlertView () { 
						Title = "Ups =S", Message = "No se puede mostrar la lista de estados, verifica tu conexión a internet e intentalo de nuevo."
					};
					alert.AddButton ("Aceptar");
					alert.Show ();
				}catch(Exception excep){
					Console.WriteLine("ESTE ES EL ERROR: " + excep.ToString());
					UIAlertView alert = new UIAlertView () { 
						Title = "Ups =S", Message = excep.ToString()
					};
					alert.AddButton("Aceptar");
					alert.Show ();
				}
			};

			btnAceptar.TouchUpInside += (sender, e) => {
				this.pickerStates.Hidden = true;
				this.btnAceptar.Hidden = true;
			};

			pickerDataModel.ValueChanged += (sender, e) => {
				this.btnEstado.SetTitle(pickerDataModel.SelectedItem.ToString(), UIControlState.Normal);
				this.stateId = pickerDataModel.SelectedItem.id;
				this.state = pickerDataModel.SelectedItem.ToString();
			};

			this.btnLocalidad.TouchUpInside += (sender, e) => {
				try{
					if(stateId != ""){
						localityService = new LocalityService();
						localityService.setState(stateId);
						List<LocalityService> localidades = localityService.All();
						pickerDataModelLocality.Items = localidades;
						pickerStates.Model = pickerDataModelLocality;
						pickerStates.Hidden = false;
						btnAceptar.Hidden = false;
						//actionSheetPicker.Picker.Source = pickerDataModelLocality;
						//actionSheetPicker.Show();
					}
				}catch(System.Net.WebException){
					UIAlertView alert = new UIAlertView () { 
						Title = "Ups =S", Message = "No se puede mostrar la lista de localidades, verifica tu conexión a internet e intentalo de nuevo."
					};
					alert.AddButton ("Aceptar");
					alert.Show ();
				}catch(Exception){
					UIAlertView alert = new UIAlertView () { 
						Title = "Ups =S", Message = "Algo salio mal, por favor intentalo de nuevo."
					};
					alert.AddButton("Aceptar");
					alert.Show ();
				}
			};
				
			pickerDataModelLocality.ValueChanged += (sender, e) => {
				this.btnLocalidad.SetTitle(pickerDataModelLocality.SelectedItem.ToString(),UIControlState.Normal);
				this.localityId = pickerDataModelLocality.SelectedItem.id;
				this.locality = pickerDataModelLocality.SelectedItem.ToString();
			};

			btnGuardar.TouchUpInside += (sender, e) => {
				try{
					if(this.stateId != "" && this.localityId != ""){
						var state = new State {stateId = int.Parse( this.stateId), state = this.locality, localityId = int.Parse(this.localityId), locality = this.locality};
						using (var db = new SQLite.SQLiteConnection(_pathToDatabase ))
						{
							db.DropTable<State>();
							db.CreateTable<State>();
							db.Insert(state);
						}

						MainView.localityId = state.localityId;
						UIAlertView alert = new UIAlertView () { 
							Title = "Bien! =D", Message = "Gracias por definir tu estado y localidad ahora puedes empezar a buscar productos con FixBuy =D"
						};
						alert.AddButton ("Aceptar");
						alert.Show ();
						this.NavigationController.PopViewController(true);
					}
				}catch(Exception){
					UIAlertView alert = new UIAlertView () { 
						Title = "Ups =S", Message = "Algo salio mal, por favor intentalo de nuevo."
					};
					alert.AddButton("Aceptar");
					alert.Show ();
				}
			};
		}
示例#55
0
		public override void ViewDidLoad ()
		{
			base.ViewDidLoad ();
			this.Add (faceBookView);
			this.Add (facebookView2);

			iPhoneLocationManager = new CLLocationManager ();
			iPhoneLocationManager.DesiredAccuracy = CLLocation.AccuracyNearestTenMeters;
			iPhoneLocationManager.LocationsUpdated += (object sender, CLLocationsUpdatedEventArgs e) => {

			};
				
			iPhoneLocationManager.RequestAlwaysAuthorization ();
			if (CLLocationManager.LocationServicesEnabled) {
				iPhoneLocationManager.StartUpdatingLocation ();
			}
			#region observadores del teclado
			// Keyboard popup
			NSNotificationCenter.DefaultCenter.AddObserver
			(UIKeyboard.DidShowNotification,KeyBoardUpNotification);

			// Keyboard Down
			NSNotificationCenter.DefaultCenter.AddObserver
			(UIKeyboard.WillHideNotification,KeyBoardDownNotification);
			#endregion

			#region declaracion de vista de Facebook
			// Create the Facebook LogIn View with the needed Permissions
			// https://developers.facebook.com/ios/login-ui-control/
			loginView = new FBLoginView (ExtendedPermissions) {
				Frame = new CGRect (0,0,45, 45)
			};

			// Create view that will display user's profile picture
			// https://developers.facebook.com/ios/profilepicture-ui-control/

			pictureView = new FBProfilePictureView () {
				Frame = new CGRect (0, 0, 45, 45)
			};
			pictureView.UserInteractionEnabled = true;
			// Hook up to FetchedUserInfo event, so you know when
			// you have the user information available
			loginView.FetchedUserInfo += (sender, e) => {
				user = e.User;
				pictureView.ProfileID = user.GetId ();
				MainView.isWithFacebook = true;
				loginView.Alpha = 0.1f;
				pictureView.Hidden = false;
			};

			// Clean user Picture and label when Logged Out
			loginView.ShowingLoggedOutUser += (sender, e) => {
				pictureView.ProfileID = null;
				pictureView.Hidden = true;
				lblUserName.Text = string.Empty;
				loginView.Alpha = 1f;
				MainView.isWithFacebook = false;
			};
		
			this.faceBookView.Add(pictureView);
			this.faceBookView.Add(loginView);
			#endregion

			var documents = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
			_pathToDatabase = Path.Combine(documents, "db_sqlite-net.db");

			//Creamos la base de datos y la tabla de persona
			using (var conn= new SQLite.SQLiteConnection(_pathToDatabase))
			{
				conn.CreateTable<Person>();
				conn.CreateTable<State> ();
				conn.CreateTable<Terms> ();
				conn.CreateTable<PrivacyNotice> ();
			}

			using (var db = new SQLite.SQLiteConnection(_pathToDatabase ))
			{
				people = new List<Person> (from p in db.Table<Person> () select p);
				states = new List<State> (from s in db.Table<State> () select s);
				terms = new List<Terms> (from t in db.Table<Terms> ()select t);
				privacyNotices = new List<PrivacyNotice> (from pr in db.Table<PrivacyNotice> () select pr);
			}

			if(people.Count > 0){
				Person user = people.ElementAt(0);
				MainView.userId = user.ID;
				Console.WriteLine ("El Id de usuario es: "+ user.ID);
			}

			if(states.Count > 0){
				State estado = states.ElementAt(0);
				MainView.localityId = estado.localityId;
				Console.WriteLine ("El Id de localidad es: "+ estado.stateId);
			}
				
			//Boton para entrar al menu de la aplicacion.
			this.btnEntrar.TouchUpInside += (sender, e) => {
				scanView = new ScanView();
				this.NavigationController.PushViewController(scanView, true);
			};

			this.btnListas.TouchUpInside += (sender, e) => {
				using (var db = new SQLite.SQLiteConnection(_pathToDatabase ))
				{
					people = new List<Person> (from p in db.Table<Person> () select p);
				}
				if(people.Count > 0){
					MyListsView mylists = new MyListsView();
					this.NavigationController.PushViewController(mylists,true);
				}else{
					UIAlertView alert = new UIAlertView () { 
						Title = "Espera!", Message = "Debes iniciar sesion para acceder a tus listas"
					};
					alert.AddButton ("Aceptar");
					alert.Show ();
				}
			};

			//Boton para hacer busqueda por nombre de producto
			this.btnBuscar.TouchUpInside += (sender, e) => {
				if(this.cmpNombre.Text == ""){
					UIAlertView alert = new UIAlertView () { 
						Title = "Espera!", Message = "Debes ingresar el nombre del producto a buscar"
					};
					alert.AddButton ("Aceptar");
					alert.Show ();
				}
				else if (states.Count < 1){
					UIAlertView alert = new UIAlertView () { 
						Title = "Espera!", Message = "Debes seleccionar tu ubicacion antes de comenzar a usar FixBuy, por favor ingresa " +
							"Al menu de opciones para establecerla"
					};
					alert.AddButton ("Aceptar");
					alert.Clicked += (s, o) => {
						StatesView statesView = new StatesView();
						this.NavigationController.PushViewController(statesView, true);
					};
					alert.Show ();
				}
				else{
					this._loadPop = new LoadingOverlay (UIScreen.MainScreen.Bounds);
					this.View.Add ( this._loadPop );
					this.cmpNombre.ResignFirstResponder();
					Task.Factory.StartNew (
						() => {
							System.Threading.Thread.Sleep ( 1 * 1000 );
						}
					).ContinueWith ( 
						t => {
							nsr = new NameSearchResultView();
							nsr.setProductName(this.cmpNombre.Text.Trim());
							this.NavigationController.PushViewController(nsr,true);
							this._loadPop.Hide ();
						}, TaskScheduler.FromCurrentSynchronizationContext()
					);
				}
			};

			this.cmpNombre.ShouldReturn += (textField) => {
				if(this.cmpNombre.Text == ""){
					UIAlertView alert = new UIAlertView () { 
						Title = "Espera!", Message = "Debes ingresar el nombre del producto a buscar"
					};
					alert.AddButton ("Aceptar");
					alert.Show ();
				}
				else if (states.Count < 1){
					UIAlertView alert = new UIAlertView () { 
						Title = "Espera!", Message = "Debes seleccionar tu ubicacion antes de comenzar a usar FixBuy, por favor ingresa " +
							"Al menu de opciones para establecerla"
					};
					alert.AddButton ("Aceptar");
					alert.Clicked += (s, o) => {
						StatesView statesView = new StatesView();
						this.NavigationController.PushViewController(statesView, true);
					};
					alert.Show ();
				}
				else{
					this._loadPop = new LoadingOverlay (UIScreen.MainScreen.Bounds);
					this.View.Add ( this._loadPop );
					this.cmpNombre.ResignFirstResponder();
					Task.Factory.StartNew (
						() => {
							System.Threading.Thread.Sleep ( 1 * 1000 );
						}
					).ContinueWith ( 
						t => {
							nsr = new NameSearchResultView();
							nsr.setProductName(this.cmpNombre.Text.Trim());
							this.NavigationController.PushViewController(nsr,true);
							this._loadPop.Hide ();
						}, TaskScheduler.FromCurrentSynchronizationContext()
					);
				} 
				return true; 
			};

			//Boton para iniciar el escaner de codigo de barras
			this.btnCodigo.TouchUpInside += (sender, e) => {
				if(states.Count > 0){
					// Configurar el escaner de codigo de barras.
					picker = new ScanditSDKRotatingBarcodePicker (appKey);
					picker.OverlayController.Delegate = new overlayControllerDelegate(picker, this);
					picker.OverlayController.ShowToolBar(true);
					picker.OverlayController.ShowSearchBar(true);
					picker.OverlayController.SetToolBarButtonCaption("Cancelar");
					picker.OverlayController.SetSearchBarKeyboardType(UIKeyboardType.Default);
					picker.OverlayController.SetSearchBarPlaceholderText("Búsqueda por nombre de producto");
					picker.OverlayController.SetCameraSwitchVisibility(SICameraSwitchVisibility.OnTablet);
					picker.OverlayController.SetTextForInitializingCamera("Iniciando la camara");
					this.PresentViewController (picker, true, null);
					picker.StartScanning ();
				}else{
					UIAlertView alert = new UIAlertView () { 
						Title = "Espera!", Message = "Debes seleccionar tu ubicacion antes de comenzar a usar FixBuy, por favor ingresa " +
							"Al menu de opciones para establecerla"
					};
					alert.AddButton ("Aceptar");
					alert.Clicked += (s, o) => {
						StatesView statesView = new StatesView();
						this.NavigationController.PushViewController(statesView, true);
					};
					alert.Show ();
				}
			};
		}
        public void Devolver(Model.Emprestimo emprestimo)
        {
            emprestimo.DataDevolucao = DateTime.Now;

            using (var db = new SQLite.SQLiteConnection(DB_PATH))
            {
                db.CreateTable<Model.Emprestimo>();
            }

            using (var db = new SQLite.SQLiteConnection(DB_PATH))
            {
                if (db.InsertOrReplace(emprestimo) > 0)
                {
                    int index = this.ListaDeEmprestimos.IndexOf(emprestimo);
                    if (index > -1)
                        this.ListaDeEmprestimos[index] = emprestimo;
                    else
                        this.ListaDeEmprestimos.Add(emprestimo);
                }
            }

            Frame rootFrame = Window.Current.Content as Frame;
            rootFrame.Navigate(typeof(View.PivotPage));
        }
示例#57
0
		public bool CreateTableLogin()
		{
			try
			{
				dbConn = new SQLite.SQLiteConnection (dbPath);
				var creatingTable = dbConn.CreateTable<MMenu_LoginInfo> ();
				Console.WriteLine("[InitialStartup] Table creating LoginInfo with status: {0}",creatingTable);
				Console.WriteLine("[InitialStartup] Table creating LoginInfo success");

				return true;
			}
			catch(Exception e)
			{
				Console.WriteLine("[InitialStartup] Table creating LoginInfo error with status: {0}",e);
				return false;
			}
		}
示例#58
0
        private void UpdateDatbase()
        {
            try {
                using (var conn = new SQLite.SQLiteConnection (pathToDatabase)) {

                    var num = conn.ExecuteScalar<Int32> ("SELECT count(name) FROM sqlite_master WHERE type='table' and name='CNNote'", new object[]{ });
                    int count = Convert.ToInt32 (num);
                    if (count > 0)
                        return;

                    conn.CreateTable<CNNote> ();
                    conn.CreateTable<CNNoteDtls> ();
                    conn.DropTable<AdPara> ();
                    conn.CreateTable<AdPara> ();
                    conn.DropTable<AdNumDate> ();
                    conn.CreateTable<AdNumDate> ();
                    conn.DropTable<CompanyInfo> ();
                    conn.CreateTable<CompanyInfo> ();
                    conn.DropTable<Trader> ();
                    conn.CreateTable<Trader> ();
                    conn.DropTable<AdUser> ();
                    conn.CreateTable<AdUser> ();

                    string sql = @"ALTER TABLE Invoice RENAME TO sqlitestudio_temp_table;
                                    CREATE TABLE Invoice (invno varchar PRIMARY KEY NOT NULL, trxtype varchar, invdate bigint, created bigint, amount float, taxamt float, custcode varchar, description varchar, uploaded bigint, isUploaded integer, isPrinted integer);
                                    INSERT INTO Invoice (invno, trxtype, invdate, created, amount, taxamt, custcode, description, uploaded, isUploaded,isPrinted) SELECT invno, trxtype, invdate, created, amount, taxamt, custcode, description, uploaded, isUploaded,0 FROM sqlitestudio_temp_table;
                                    DROP TABLE sqlitestudio_temp_table";
                    string[] sqls = sql.Split (new char[]{ ';' });
                    foreach (string ssql in sqls) {
                        conn.Execute (ssql, new object[]{ });
                    }
                }
            } catch (Exception ex) {
                AlertShow (ex.Message);
            }
        }
        /// <summary>
        /// Invoked when the application is launched normally by the end user.  Other entry points
        /// will be used such as when the application is launched to open a specific file.
        /// </summary>
        /// <param name="e">Details about the launch request and process.</param>
        protected override void OnLaunched(LaunchActivatedEventArgs e)
        {
            Frame rootFrame = Window.Current.Content as Frame;

            // Do not repeat app initialization when the Window already has content,
            // just ensure that the window is active
            if (rootFrame == null)
            {
                // Create a Frame to act as the navigation context and navigate to the first page
                rootFrame = new Frame();

                rootFrame.NavigationFailed += OnNavigationFailed;

                if (e.PreviousExecutionState == ApplicationExecutionState.Terminated)
                {
                    //TODO: Load state from previously suspended application
                }

                // Get a reference to the SQLite database
                DBPath = Path.Combine(
                    Windows.Storage.ApplicationData.Current.LocalFolder.Path, "meals.db");
                // Initialize the database if necessary
                using (var db = new SQLite.SQLiteConnection(DBPath))
                {
                    // Create the tables if they don't exist
                    db.CreateTable<Meal>();
                    db.CreateTable<MealItem>();
                    db.CreateTable<Ingredient>();
                    db.CreateTable<FoodCategory>();
                    db.CreateTable<UnitOfMeasure>();
                    db.CreateTable<Contact>();
                    db.CreateTable<MealSuggestion>();
                    db.CreateTable <MealSuggestionCategory>();
                }

                //this.ResetData();
                //addFoodCategories();

                // Place the frame in the current Window
                Window.Current.Content = rootFrame;
            }

            if (rootFrame.Content == null)
            {
                // When the navigation stack isn't restored navigate to the first page,
                // configuring the new page by passing required information as a navigation
                // parameter
                rootFrame.Navigate(typeof(StartPage), e.Arguments);
            }
            // Ensure the current window is active
            Window.Current.Activate();
        }
示例#60
0
		public bool CreateTableUserSettings()
		{
			try
			{
				dbConn = new SQLite.SQLiteConnection (dbPath);
				var creatingTable = dbConn.CreateTable<UserSettings> ();
				Console.WriteLine("[InitialStartup] Table creating UserSettings with status: {0}",creatingTable);
				Console.WriteLine("[InitialStartup] Table creating UserSettings success");

				return true;
			}
			catch(Exception e)
			{
				Console.WriteLine("[InitialStartup] Table creating UserSettings error with status: {0}",e);
				return false;
			}
		}