public void TestConnection()
{
FdoProviderInfo provider = _view.SelectedProvider;
string connStr = ExpressUtility.ConvertFromNameValueCollection(_view.ConnectProperties);
FdoConnection conn = new FdoConnection(provider.Name, connStr);
try
{
FdoConnectionState state = conn.Open();
if (state == FdoConnectionState.Open || state == FdoConnectionState.Pending)
{
_view.ShowMessage(null, "Test successful");
conn.Close();
}
else
{
_view.ShowError("Connection test failed");
}
}
catch (FdoException ex)
{
_view.ShowError(ex.InnerException.Message);
}
finally
{
conn.Dispose();
}
}
public void TestSQLite()
{
IConnectionManager connMgr = FdoFeatureAccessManager.GetConnectionManager();
FdoIConnection conn = connMgr.CreateConnection("OSGeo.SQLite");
conn.ConnectionString = "File=" + TestDataStore.SQLITE;
Assert.Equal(FdoConnectionState.FdoConnectionState_Open, conn.Open());
conn.Close();
conn.ConnectionString = "File=../IDontExist.sqlite";
Assert.Throws <ManagedFdoException>(() =>
{
FdoConnectionState state = conn.Open();
});
}
public void TestSHP()
{
IConnectionManager connMgr = FdoFeatureAccessManager.GetConnectionManager();
FdoIConnection conn = connMgr.CreateConnection("OSGeo.SHP");
conn.ConnectionString = "DefaultFileLocation=" + TestDataStore.SHP;
Assert.Equal(FdoConnectionState.FdoConnectionState_Open, conn.Open());
conn.Close();
conn.ConnectionString = "DefaultFileLocation=" + TestDataStore.SHP_DIR;
Assert.Equal(FdoConnectionState.FdoConnectionState_Open, conn.Open());
conn.Close();
conn.ConnectionString = "File=../IDontExist.shp";
Assert.Throws <ManagedFdoException>(() =>
{
FdoConnectionState state = conn.Open();
});
}
public void TestConnection()
{
FdoConnection conn = new FdoConnection("OSGeo.OGR", _view.BuilderObject.ToConnectionString());
try
{
FdoConnectionState state = conn.Open();
if (state == FdoConnectionState.Open)
{
_view.ShowMessage(null, "Test successful");
conn.Close();
}
else
{
_view.ShowError("Connection test failed");
}
}
catch (FdoException ex)
{
_view.ShowError(ex.InnerException.Message);
}
}
public bool Connect()
{
if (string.IsNullOrEmpty(_view.ConnectionName))
{
_view.FlagNameError("Required");
return(false);
}
FdoConnection conn = _manager.GetConnection(_view.ConnectionName);
if (conn != null)
{
_view.FlagNameError("A connection named " + _view.ConnectionName + " already exists");
return(false);
}
FdoProviderInfo provider = _view.SelectedProvider;
//string connStr = ExpressUtility.ConvertFromNameValueCollection(_view.ConnectProperties);
NameValueCollection cp = new NameValueCollection(_view.ConnectProperties);
if (_pendingProperties.Count > 0)
{
NameValueCollection extra = new NameValueCollection();
cp.Add(extra);
}
string connStr = ExpressUtility.ConvertFromNameValueCollection(cp);
conn = new FdoConnection(provider.Name, connStr);
if (FileService.FileExists(_view.ConfigFile))
{
try
{
conn.SetConfiguration(_view.ConfigFile);
}
catch (Exception ex)
{
conn.Dispose();
_view.FlagConfigError(ex.Message);
return(false);
}
}
try
{
FdoConnectionState state = conn.Open();
if (state == FdoConnectionState.Open)
{
_manager.AddConnection(_view.ConnectionName, conn);
return(true);
}
else if (state == FdoConnectionState.Pending)
{
//Re-query the pending parameters and re-prompt in a new dialog
if (_pendingProperties.Count > 0)
{
List <DictionaryProperty> pend = new List <DictionaryProperty>();
foreach (DictionaryProperty p in _pendingProperties)
{
pend.Add(conn.GetConnectTimeProperty(p.Name));
}
NameValueCollection extra = PendingParameterDialog.GetExtraParameters(pend);
//Cancelled action
if (extra == null)
{
return(false);
}
cp.Add(extra);
conn.ConnectionString = ExpressUtility.ConvertFromNameValueCollection(cp);
if (conn.Open() == FdoConnectionState.Open)
{
_manager.AddConnection(_view.ConnectionName, conn);
return(true);
}
}
}
else
{
return(false);
}
}
catch (Exception ex)
{
_view.ShowError(ex);
conn.Dispose();
return(false);
}
return(false);
}
