Пример #1
0
 public frm_edit_scheme(ProbDatabase probDatabase_2, string scheme)
 {
     // TODO: Complete member initialization
     InitializeComponent();
     this.probDatabase = probDatabase_2;
     this.scheme       = scheme;
 }
Пример #2
0
 public frm_Delete_relation(ProbDatabase probDatabase, string relationName)
 {
     // TODO: Complete member initialization
     InitializeComponent();
     this.probDatabase = probDatabase;
     this.relationName = relationName.ToLower();
 }
Пример #3
0
 public frm_delete_query(ProbDatabase probDatabase, string QueryName)
 {
     // TODO: Complete member initialization
     InitializeComponent();
     this.probDatabase = probDatabase;
     this.QueryName    = QueryName;
 }
Пример #4
0
 public frm_Delete_Scheme(BLL.ProbDatabase probDatabase)
 {
     // TODO: Complete member initialization
     InitializeComponent();
     this.probDatabase = probDatabase;
     this.list         = this.probDatabase.ListOfSchemeNameToLower();
 }
Пример #5
0
        public frm_rename_relation(BLL.ProbDatabase probDatabase)
        {
            // TODO: Complete member initialization

            InitializeComponent();
            this.probDatabase = probDatabase;
        }
Пример #6
0
 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;
 }
Пример #7
0
        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);
        }
Пример #8
0
 public frm_new_scheme(BLL.ProbDatabase probDatabase)
 {
     // TODO: Complete member initialization
     InitializeComponent();
     this.probDatabase = probDatabase;
 }
Пример #9
0
 public frm_open_query(BLL.ProbDatabase probDatabase)
 {
     // TODO: Complete member initialization
     InitializeComponent();
     this.probDatabase = probDatabase;
 }