//
public Boolean Restore(String p_path)
{
try
{
FbRestore mFbRestore = new FbRestore(C_Setting_DB.get_db_url());
mFbRestore.BackupFiles.Add(new FbBackupFile(p_path, 2048));
mFbRestore.Options = FbRestoreFlags.Create | FbRestoreFlags.Replace;
//mFbRestore.Verbose = true;
//mFbRestore.ServiceOutput += new ServiceOutputEventHandler(ServiceOutput);
mFbRestore.Execute();
return(true);
}
catch (Exception e)
{
F_File.LogError(e);
return(false);
}
}
//
public Boolean Backup(String p_path)
{
try
{
FbBackup mFbBackup = new FbBackup(C_Setting_DB.get_db_url());
mFbBackup.BackupFiles.Add(new FbBackupFile(p_path, 2048));
mFbBackup.Options = FbBackupFlags.IgnoreLimbo;
//mFbBackup.Verbose = true;
//mFbBackup.ServiceOutput += new ServiceOutputEventHandler(ServiceOutput);
mFbBackup.Execute();
return(true);
}
catch (Exception e)
{
F_File.LogError(e);
return(false);
}
}
//
public Boolean Shutdown()
{
try
{
FbConfiguration configurationSvc = new FbConfiguration();
configurationSvc.ConnectionString = C_Setting_DB.get_db_url();
configurationSvc.SetSweepInterval(1000);
configurationSvc.SetReserveSpace(true);
configurationSvc.SetForcedWrites(true);
configurationSvc.DatabaseOnline();
configurationSvc.DatabaseShutdown(FbShutdownMode.Forced, 1);
return(true);
}
catch (Exception e)
{
F_File.LogError(e);
return(false);
}
}
//
public Boolean CreateNew()
{
try
{
FbConnection.CreateDatabase(C_Setting_DB.get_db_url());
string sql_script = Properties.Resources.sql;
if (ExecuteScript(sql_script))
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
F_File.LogError(e);
return(false);
}
}
private void execute <Object>(Object obj)
{
string st = obj as string;
switch (st)
{
case "DatabasePath":
{
TB_DatabasePath = F_File.browserFile("Database | *.FDB;");
C_Variables.DB_.file = TB_DatabasePath;
}
break;
case "Save":
{
C_Setting_DB.SaveConfigDatabase();
}
break;
case "Test":
{
if (T_Helper.IsNull())
{
DialogError.Error();
}
else
{
DialogInformation.OK();
}
}
break;
case "Shutdown":
{
if (DB_Access.GetInstatce().Shutdown())
{
DialogInformation.OK();
}
else
{
DialogError.Error();
}
}
break;
case "Backup":
{
if (DB_Access.GetInstatce().Backup() == "")
{
DialogError.Error();
}
else
{
DialogInformation.OK();
}
}
break;
case "Restore":
{
string p = F_File.browserFile("Database | *.FBK;");
if (p == "")
{
DialogError.Error(); break;
}
if (DB_Access.GetInstatce().Restore(p))
{
DialogInformation.OK();
}
else
{
DialogError.Error();
}
}
break;
case "CreateNew":
{
if (DB_Access.GetInstatce().CreateNew())
{
DialogInformation.OK();
}
else
{
DialogError.Error();
}
}
break;
case "Default":
{
C_Setting_DB.set_db_Default();
TB_DatabaseDataSource = C_Variables.DB_.host;
TB_DatabasePath = C_Variables.DB_.file;
TB_DatabasePort = C_Variables.DB_.Port;
TB_DatabaseUserID = C_Variables.DB_.UserID;
TB_DatabasePassword = C_Variables.DB_.Password;
ComboBoxSelected = C_Variables.DB_.type == 0 ? "Default" : "Embedded";
}
break;
case "Embedded":
{
C_Setting_DB.set_db_Embedded();
TB_DatabaseDataSource = C_Variables.DB_.host;
TB_DatabasePath = C_Variables.DB_.file;
TB_DatabasePort = C_Variables.DB_.Port;
TB_DatabaseUserID = C_Variables.DB_.UserID;
TB_DatabasePassword = C_Variables.DB_.Password;
ComboBoxSelected = C_Variables.DB_.type == 0 ? "Default" : "Embedded";
}
break;
default: break;
}
}
//*********************************************************************************
#region initialis
public DB_Access()
{
connection_db = new FbConnection(C_Setting_DB.get_db_url());
}
//********************************************************
#region init
private Entities() // Entities = Constructor of calss model
: base(new FbConnection(C_Setting_DB.get_db_url()), true) //C_Setting.get_db_url()== function get database string
{
}
