public FrmDelSchema(FProbDatabaseBLL probDatabase)
{
// TODO: Complete member initialization
InitializeComponent();
this.probDatabase = probDatabase;
this.list = this.probDatabase.ListOfSchemeNameToLower();
}
public FrmEditSchema(FProbDatabaseBLL probDatabase, string scheme)
{
// TODO: Complete member initialization
InitializeComponent();
this.probDatabase = probDatabase;
this.scheme = scheme;
}
public FrmRenameRelation(FProbDatabaseBLL probDatabase, string relationName)
{
// TODO: Complete member initialization
InitializeComponent();
this.relationName = relationName;
this.probDatabase = probDatabase;
}
public FrmDelQuery(FProbDatabaseBLL probDatabase, string QueryName)
{
// TODO: Complete member initialization
InitializeComponent();
this.probDatabase = probDatabase;
this.QueryName = QueryName;
QueryNameRemove = "";
}
public FrmRenameQuery(FProbDatabaseBLL probDatabase, string queryName)
{
// TODO: Complete member initialization
this.probDatabase = probDatabase;
listNameQuery.AddRange(this.probDatabase.ListOfQueryNameToLower());
InitializeComponent();
this.queryName = queryName;
}
internal static bool CreateNewDatabase(FProbDatabaseBLL 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))
{
XtraMessageBox.Show("Error : " + db.errorMessage + " please try again!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
catch (Exception Ex)
{
XtraMessageBox.Show(Ex.Message);
return(false);
}
return(true);
}
internal static FProbDatabaseBLL OpenExistingDatabase(FProbDatabaseBLL probDatabase)
{
FProbDatabaseBLL newProbDatabase = new FProbDatabaseBLL(probDatabase);
try
{
List <FProbSchemaBLL> Schemes = new List <FProbSchemaBLL>();
Schemes = new FProbSchemaBLL().getAllScheme();
newProbDatabase.FproSchemas = Schemes;
List <FProbRelationBLL> relations = new List <FProbRelationBLL>();
relations = new FProbRelationBLL().getAllRelation();
newProbDatabase.FproRelations = relations;
List <FProbQueryBLL> querys = new List <FProbQueryBLL>();
querys = new FProbQueryBLL().getAllQuery();
newProbDatabase.FproQueries = querys;
}
catch (Exception)
{
return(null);
}
return(newProbDatabase);
}
public FrmRenameDB(FProbDatabaseBLL probDatabase)
{
// TODO: Complete member initialization
InitializeComponent();
this.probDatabase = probDatabase;
}
internal static bool SaveDatabase(FProbDatabaseBLL probDatabase)
{
try
{
//Drop data base
DropDatabaseData();
int schemeID = 0;
int attributeID = 0;
#region Save Scheme
foreach (FProbSchemaBLL scheme in probDatabase.FproSchemas)
{
/// Save Schemes
schemeID++;
scheme.SchemaName = scheme.SchemaName.ToLower().Trim();
scheme.IdSchema = schemeID;
scheme.Insert();
///Save attributes of the scheme to the System Attribute Table
foreach (FProbAttributeBLL attr in scheme.FproAttributes)
{
attributeID++;
attr.FproSchema = scheme;
attr.AttributeName = attr.AttributeName.Trim();
attr.IdAttribute = attributeID;
attr.Insert();
}
}
#endregion
#region Save Relations
int relationID = 0;
foreach (FProbRelationBLL relation in probDatabase.FproRelations)
{
relationID++;
relation.IdRelation = relationID;
relation.RelationName = relation.RelationName.ToLower().Trim();
relation.InsertSystemRelation();
/// Create Table <Relation> //
relation.CreateTableRelation();
// Insert tuples into Talbe <Relation> //
relation.InsertTupleIntoTableRelation();
}
#endregion
#region Save Query
int queryID = 0;
foreach (FProbQueryBLL item in probDatabase.FproQueries)
{
queryID++;
item.QueryName = item.QueryName.ToLower().Trim();
item.IdQuery = queryID;
item.Insert();
}
#endregion
}
catch (Exception Ex)
{
XtraMessageBox.Show(Ex.Message);
return(false);
}
return(true);
}
