public DBService(ConnectionVO connVO,string HostURL)
{
try
{
NpgsqlConnectionStringBuilder nsb = new NpgsqlConnectionStringBuilder();
nsb.Host = HostURL;
nsb.Port = 5432;
nsb.SSL = false;
nsb.IntegratedSecurity = false;
nsb.UserName = "******";
nsb.Database = connVO.DataBaseName;
nsb.Password = connVO.DBPassword;
NpgConn = new NpgsqlConnection(nsb.ToString());
NpgConn.Open();
}
catch (Exception ex)
{
throw ex;
}
}
public void RestoreDB(string BackupFilePath, ConnectionVO connVO)
{
DBController.RestoreDB(BackupFilePath, connVO);
}
public void CreateDB(ConnectionVO connVO)
{
// DBController.CreateDB(connVO);
}
internal static void RestoreDB(string BackupFilePath, ConnectionVO connVO)
{
// DBService.Restore(connVO.DataBasePath, BackupFilePath,connVO.DBID,connVO.DBPassword);
}
private bool CheckDB(ConnectionVO connVO)
{
//string DBList = new FileExecuter().ExecWithReturnValue("psql.exe", @"\list");
//if (DBList)
//{
//}
return true;
}
private void AddDB(ConnectionVO connVO)
{
}