/// <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;
}
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');
* */
);
}
}