コード例 #1
0
        /// <summary>
        ///CONSTRUCTOR
        /// </summary>
        public MainViewModel()
        {
            //  DriverSqlite.InstallSqLiteDriver();
            //Chek if odbc pilote is Installed
               // if (DriverSqlite.Installed()) { }

            //Check IF Databse Exist
            var PathDatabase = new ConnectionProvider().GetOpenConnection().ConnectionString.Substring(12);
            if (File.Exists(PathDatabase))
            {
                if (new FileInfo(PathDatabase).Length == 0)
                    DataBaseManager.CreateDatabase();
            }
            else
            {
                return;
            }

            PathCurrentFrame = "NeutralView.xaml";
            //NavigationName = NameFrame.BankAccount;
            BankAccounts = new ObservableCollection<BankAccount>(BankAccountDAL.Load());
            OpenFlyOutBankAccountCommand = new RelayCommand(ShowFlyOutBankAccount);
            SelectedFrameCommand = new RelayCommand<string>(SelectedFrame);
            ShowNav = Visibility.Collapsed;
            //Ask Bank Account
            OpenFlyOutBankAccount = true;
        }
コード例 #2
0
        public static void CreateDatabase()
        {
            using (var cnn = new ConnectionProvider().GetOpenConnection())
            {
               cnn.Execute(
                    @"CREATE TABLE BankAccount
                    (
                        Code INT PRIMARY KEY NOT NULL,
                        Wording VARCHAR(200) NOT NULL,
                        Description VARCHAR(200) NOT NULL,
                        Investment BOOLEAN NOT NULL
                    );

                    CREATE TABLE Category
                    (
                        Id INTEGER PRIMARY KEY AUTOINCREMENT,
                        Wording VARCHAR(200) NOT NULL,
                        Targetprice decimal(8,2) NOT NULL,
                        B_Code int NOT NULL,
                        FOREIGN KEY(B_Code) REFERENCES BankAccount(Code) ON DELETE CASCADE
                    );

                    CREATE TABLE Frequency(
                        Code VARCHAR(4) PRIMARY KEY NOT NULL,
                        Wording VARCHAR(200) NOT NULL
                    );

                    CREATE TABLE Transfer(
                        Id INTEGER PRIMARY KEY AUTOINCREMENT,
                        Wording VARCHAR(200) NOT NULL,
                        Description VARCHAR(300) NULL,
                        Price decimal(7,2) NOT NULL,
                        DateL Date NOT NULL,
                        Way BOOLEAN,
                        F_Code VARCHAR(4) NULL,
                        C_Id INTEGER NOT NULL,
                        B_Code int NOT NULL,
                        B_CodeBeneficiary int NULL,
                        Beneficiary VARCHAR(50) NULL,
                        FOREIGN KEY(B_CodeBeneficiary) REFERENCES BankAccount(Code)  ON DELETE CASCADE,
                        FOREIGN KEY(B_Code) REFERENCES BankAccount(Code)  ON DELETE CASCADE,
                        FOREIGN KEY(C_Id) REFERENCES Category(Id) ON DELETE CASCADE,
                        FOREIGN KEY(F_Code) REFERENCES Frequency(Code) ON DELETE CASCADE
                    );

                    CREATE TABLE Registration(
                        Id INTEGER PRIMARY KEY AUTOINCREMENT,
                        Wording VARCHAR(200) NOT NULL,
                        Description VARCHAR(300) NULL,
                        DateR Date NOT NULL,
                        Price decimal(10,2) NOT NULL,
                        Way BOOLEAN,
                        B_Code int NOT NULL,
                        C_Id INTEGER NOT NULL,
                        T_Id int NULL,
                        FOREIGN KEY(B_Code) REFERENCES BankAccount(Code)  ON DELETE CASCADE,
                        FOREIGN KEY(C_Id) REFERENCES Category(Id)  ON DELETE CASCADE,
                        FOREIGN KEY(T_Id) REFERENCES Transfer(Id) ON DELETE CASCADE
                    );
                       INSERT INTO BankAccount(Code,Wording,Description,Investment) VALUES(999999,'Premiere Connexion','Premiere Connexion', 0);
            "
                /*
                  INSERT INTO Category(Wording,Targetprice,B_Code) VALUES('Nourriture',400.00,184645511);
                                    INSERT INTO Category(Wording, Targetprice,B_Code) VALUES('Téléphones', 20.00,184645511);
                                    INSERT INTO Category(Wording, Targetprice,B_Code) VALUES('Internet', 40.00,1848451);
                                    INSERT INTO Category(Wording, Targetprice,B_Code) VALUES('EDF', 70.00,1848451);

                                    INSERT INTO BankAccount(Code,Wording,Description,Investment) VALUES(184645511,'CCP','Melanie', 1);
                                    INSERT INTO BankAccount(Code,Wording,Description,Investment) VALUES(1848451,'Livret A','Camille', 0);

                                    INSERT INTO Frequency(Code,Wording) VALUES('IMM','Immédiat');
                                    INSERT INTO Frequency(Code,Wording) VALUES('MENS','Mensuels');
                                    INSERT INTO Frequency(Code,Wording) VALUES('TRI','Trimestriel');
                                    INSERT INTO Frequency(Code,Wording) VALUES('SEME','Semestriel');
                                    INSERT INTO Frequency(Code,Wording) VALUES('ANN','Annuel');

                                    INSERT INTO Transfer(Wording,Description,DateL,F_Code,C_Id,B_Code,Price,Way,B_CodeBeneficiary,Beneficiary) VALUES('CANAL+','','2016-08-12','IMM',3,184645511,30.00,0,1848451,'');
                                    INSERT INTO Transfer(Wording,Description,DateL,F_Code,C_Id,B_Code,Price,Way,B_CodeBeneficiary,Beneficiary) VALUES('EDF','','2016-05-25','MENS',2,184645511,20.00,0,1848451,'');
                                    INSERT INTO Transfer(Wording,Description,DateL,F_Code,C_Id,B_Code,Price,Way,B_CodeBeneficiary,Beneficiary) VALUES('APL','','2016-08-12','IMM',3,1848451,15.00,1,0,'testautre');
                 * */
                );
            }
        }