protected virtual IDbConnection GetConnection(MapDataSet.durados_AppRow appRow)
{
if (appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection == null)
{
throw new DuradosException("Missing app connection");
}
SqlPersistency persistency = new SqlPersistency();
System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder();
persistency.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MapsConnectionString"].ConnectionString;
int sqlProduct = appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection.SqlProductId;
string connectionString = persistency.GetConnection(appRow, builder).ToString();
int localPort = 0;
if (sqlProduct == (int)SqlProduct.MySql)
{
if (appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection.IsSshUsesNull() || !appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection.SshUses)
{
localPort = 3306;
}
else
{
localPort = 11111;
}
}
else if (sqlProduct == (int)SqlProduct.Postgre)
{
localPort = Convert.ToInt32(appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection.ProductPort ?? "5432");
}
else if (sqlProduct == (int)SqlProduct.Oracle)
{
localPort = Convert.ToInt32(appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection.ProductPort ?? "1521");
}
if (sqlProduct == 3)
{
connectionString = persistency.GetMySqlConnection(appRow, builder, localPort).ToString();
}
else if (sqlProduct == 4)
{
connectionString = persistency.GetPostgreConnection(appRow, builder, localPort).ToString();
}
else if (sqlProduct == 5)
{
connectionString = persistency.GetOracleConnection(appRow, builder, localPort).ToString();
}
else
{
connectionString = persistency.GetSqlServerConnection(appRow, builder).ToString();
}
return(SqlAccess.GetNewConnection((SqlProduct)sqlProduct, connectionString));
}
protected virtual IDbConnection GetSystemConnection(MapDataSet.durados_AppRow appRow)
{
if (appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection_System == null)
{
throw new DuradosException("Missing system connection");
}
SqlPersistency persistency = new SqlPersistency();
System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder();
persistency.SystemConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SystemMapsConnectionString"].ConnectionString;
int systemSqlProduct = appRow.durados_SqlConnectionRowByFK_durados_App_durados_SqlConnection_System.SqlProductId;
string connectionString = persistency.GetSystemConnection(appRow, builder).ToString();
return(SqlAccess.GetNewConnection((SqlProduct)systemSqlProduct, connectionString));
}
