public frm_edit_scheme(ProbDatabase probDatabase_2, string scheme)
{
// TODO: Complete member initialization
InitializeComponent();
this.probDatabase = probDatabase_2;
this.scheme = scheme;
}
public frm_Delete_relation(ProbDatabase probDatabase, string relationName)
{
// TODO: Complete member initialization
InitializeComponent();
this.probDatabase = probDatabase;
this.relationName = relationName.ToLower();
}
public frm_delete_query(ProbDatabase probDatabase, string QueryName)
{
// TODO: Complete member initialization
InitializeComponent();
this.probDatabase = probDatabase;
this.QueryName = QueryName;
}
public frm_Delete_Scheme(BLL.ProbDatabase probDatabase)
{
// TODO: Complete member initialization
InitializeComponent();
this.probDatabase = probDatabase;
this.list = this.probDatabase.ListOfSchemeNameToLower();
}
public frm_rename_relation(BLL.ProbDatabase probDatabase)
{
// TODO: Complete member initialization
InitializeComponent();
this.probDatabase = probDatabase;
}
public frm_rename_query(BLL.ProbDatabase probDatabase, string queryName)
{
// TODO: Complete member initialization
this.probDatabase = probDatabase;
listNameQuery.AddRange(this.probDatabase.ListOfQueryNameToLower());
InitializeComponent();
this.queryName = queryName;
}
internal static bool CreateNewDatabase(BLL.ProbDatabase probDatabase)
{
try
{
SQLiteConnection.CreateFile(probDatabase.DBPath);
DataBase db = new DataBase(probDatabase.ConnectString);
string strSQL = "";
// Record set of schemes to the database system
strSQL += "CREATE TABLE SystemScheme ( ID INT, SchemeName NVARCHAR(255) );";
if (!db.CreateTable(strSQL))
{
throw new Exception(db.errorMessage);
}
// Record set of relations to the database system
strSQL = "";
strSQL += "CREATE TABLE SystemRelation (ID INT,RelationName NVARCHAR(255), SchemeID INT );";
if (!db.CreateTable(strSQL))
{
throw new Exception(db.errorMessage);
}
// Record set of attributes to the database system
strSQL = "";
strSQL += "CREATE TABLE SystemAttribute (ID INT,PrimaryKey NVARCHAR(10),AttributeName NVARCHAR(255),DataType NVARCHAR(255),Domain TEXT,Description TEXT,SchemeID INT ); ";
if (!db.CreateTable(strSQL))
{
throw new Exception(db.errorMessage);
}
// Record set of queries to the database system
strSQL = "";
strSQL += "CREATE TABLE SystemQuery (ID INT,QueryName NVARCHAR(255),QueryString TEXT );";
if (!db.CreateTable(strSQL))
{
MessageBox.Show("Error : " + db.errorMessage + " please try again!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
return(false);
}
return(true);
}
public frm_new_scheme(BLL.ProbDatabase probDatabase)
{
// TODO: Complete member initialization
InitializeComponent();
this.probDatabase = probDatabase;
}
public frm_open_query(BLL.ProbDatabase probDatabase)
{
// TODO: Complete member initialization
InitializeComponent();
this.probDatabase = probDatabase;
}