public TeenDataHelper()
{
StringBuilder sb = new StringBuilder();
string ModelPath = "Entity.TeenData.TeensDB";
System.Data.SqlClient.SqlConnectionStringBuilder csb = new System.Data.SqlClient.SqlConnectionStringBuilder();
csb.ApplicationName = "EntityFrameWork";
csb.InitialCatalog = "TeenData";
csb.Password = Password;
csb.UserID = UserName;
csb.IntegratedSecurity = false;
csb.DataSource = ServerAddress;
sb.Append("metadata=");
sb.Append("res://*/"); sb.Append(ModelPath); sb.Append(".csdl|");
sb.Append("res://*/"); sb.Append(ModelPath); sb.Append(".ssdl|");
sb.Append("res://*/"); sb.Append(ModelPath); sb.Append(".msl;");
sb.Append("provider=System.Data.SqlClient;");
sb.Append("provider connection string=\"");
sb.Append(csb.ToString());
sb.Append(";MultipleActiveResultSets=True;");
sb.Append("App=EntityFramework\"");
EntityConnStr = sb.ToString();
}
public InsertConsumerTest()
{
customerTable = new TableEntity("dbo", "Customer");
var customerId = DatabaseEntityFactory.CreateColumnEntity("CustomerId", new ColumnDataTypeDefinition("int", false), true, 1, false, null, null);
customerTable.AddColumn(customerId);
customerTable.AddColumn(DatabaseEntityFactory.CreateColumnEntity("CustomerType", new ColumnDataTypeDefinition("int", false), false, 2, false, null, null));
customerTable.AddColumn(DatabaseEntityFactory.CreateColumnEntity("Name", new ColumnDataTypeDefinition("varchar", false), false, 3, false, null, null));
customerTable.AddColumn(DatabaseEntityFactory.CreateColumnEntity("IsActive", new ColumnDataTypeDefinition("bit", false), false, 4, false, null, null));
orderTable = new TableEntity("dbo", "Orders");
orderTable.AddColumn(DatabaseEntityFactory.CreateColumnEntity("OrderId", new ColumnDataTypeDefinition("int", false), true, 1, false, null, null));
var fk = new ForeignKeyEntity();
fk.ReferencingColumn = "CustomerId";
fk.ReferencingTable = customerTable;
var customerIdColumn = DatabaseEntityFactory.CreateColumnEntity("CustomerId", new ColumnDataTypeDefinition("int", false), false, 2, true, null, fk);
customerIdColumn.Generator = new SQLDataProducer.Entities.Generators.IntGenerators.ValueFromOtherColumnIntGenerator(customerIdColumn.ColumnDataType);
customerIdColumn.Generator.GeneratorParameters.ValueFromOtherColumn.Value = customerId;
orderTable.AddColumn(customerIdColumn);
orderTable.AddColumn(DatabaseEntityFactory.CreateColumnEntity("ArticleId", new ColumnDataTypeDefinition("int", false), false, 3, false, null, null));
orderTable.AddColumn(DatabaseEntityFactory.CreateColumnEntity("TotalAmount", new ColumnDataTypeDefinition("decimal(19, 6)", false), false, 4, false, null, null));
var builder = new System.Data.SqlClient.SqlConnectionStringBuilder();
builder.DataSource = "localhost";
builder.InitialCatalog = "AdventureWorks";
builder.IntegratedSecurity = true;
connectionString = builder.ToString();
}
public TeenDataHelper()
{
StringBuilder sb = new StringBuilder();
string ModelPath = "Entity.TeenData.TeensDB";
System.Data.SqlClient.SqlConnectionStringBuilder csb = new System.Data.SqlClient.SqlConnectionStringBuilder();
csb.ApplicationName = "EntityFrameWork";
csb.InitialCatalog = "TeenData";
csb.Password = Password;
csb.UserID = UserName;
csb.IntegratedSecurity = false;
csb.DataSource = ServerAddress;
sb.Append("metadata=");
sb.Append("res://*/"); sb.Append(ModelPath); sb.Append(".csdl|");
sb.Append("res://*/"); sb.Append(ModelPath); sb.Append(".ssdl|");
sb.Append("res://*/"); sb.Append(ModelPath); sb.Append(".msl;");
sb.Append("provider=System.Data.SqlClient;");
sb.Append("provider connection string=\"");
sb.Append(csb.ToString());
sb.Append(";MultipleActiveResultSets=True;");
sb.Append("App=EntityFramework\"");
EntityConnStr = sb.ToString();
}
public static string GetConnectionString()
{
System.Data.SqlClient.SqlConnectionStringBuilder csb = new System.Data.SqlClient.SqlConnectionStringBuilder();
csb.DataSource = System.Environment.MachineName;
if (System.StringComparer.OrdinalIgnoreCase.Equals("COR", System.Environment.UserDomainName))
{
// csb.DataSource = System.Environment.MachineName + @"\SqlExpress";
csb.DataSource = System.Environment.MachineName;
}
else if (System.Environment.OSVersion.Platform == System.PlatformID.Unix)
{
csb.DataSource = System.Environment.MachineName + ",2017";
}
csb.DataSource = SecretManager.GetSecret <string>("DefaultDataSource");
csb.InitialCatalog = SecretManager.GetSecret <string>("DefaultCatalog");
// csb.DataSource = System.Environment.MachineName;
// csb.InitialCatalog = "COR_Basic_Demo_V4";
csb.IntegratedSecurity = false;
csb.IntegratedSecurity = System.StringComparer.OrdinalIgnoreCase.Equals(System.Environment.UserDomainName, "COR");
if (!csb.IntegratedSecurity)
{
csb.UserID = SecretManager.GetSecret <string>("DefaultDbUser");
csb.Password = SecretManager.GetSecret <string>("DefaultDbPassword");
}
return(csb.ToString());
}
public static string GetConnectionString()
{
System.Data.SqlClient.SqlConnectionStringBuilder csb = new System.Data.SqlClient.SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["UserContext"].ConnectionString.ToString());
csb.Password = EncryptionUtils.Decrypt(csb.Password);
string myCs = csb.ToString();
return(myCs);
}
private string GetStringConnection()
{
System.Data.SqlClient.SqlConnectionStringBuilder st = new System.Data.SqlClient.SqlConnectionStringBuilder(Configuration.GetConnectionString("local"));
string mdfPath = Path.Combine(Directory.GetCurrentDirectory(), "App_Data", "bluebankdb.mdf");
st.AttachDBFilename = mdfPath;
return(st.ToString());
}
private string GetConnectionString()
{
var builder = new System.Data.SqlClient.SqlConnectionStringBuilder();
builder.DataSource = @"localhost\peheintegration";
builder.InitialCatalog = "ConfigurationManagement";
builder.IntegratedSecurity = true;
return(builder.ToString());
}
private string GetConnectonString()
{
var conStrBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder();
conStrBuilder.DataSource = "cloud4.jnmoura.com.br,1495";
conStrBuilder.InitialCatalog = "LUPO_GLOBAL";
conStrBuilder.UserID = "userLUPO_GLOBAL_HML";
conStrBuilder.Password = "******";
return(conStrBuilder.ToString());
}
public SqlLockProvider(string connectionString, ILoggerFactory logFactory)
{
_logger = logFactory.CreateLogger <SqlLockProvider>();
var csb = new System.Data.SqlClient.SqlConnectionStringBuilder(connectionString)
{
Pooling = true,
ApplicationName = "Workflow Core Lock Manager"
};
_connectionString = csb.ToString();
}
private static string GetConnectionString()
{
System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder();
builder.DataSource = @".\SQLEX2017";
builder.InitialCatalog = "Northwind";
builder.IntegratedSecurity = true;
builder.MultipleActiveResultSets = true;
return(builder.ToString());
//string databaseFile = Path.GetFullPath(@"Northwind.mdf");
//return string.Format(@"Data Source=.\SQLEX2014;Integrated Security=True;Connect Timeout=30;User Instance=True;MultipleActiveResultSets=true;AttachDbFilename='{0}'", databaseFile);
}
public static TenantDataCtx Create(string databaseServer, string databaseName, string databaseUserName, string databasePassword, Guid tenantId)
{
var connectionStringBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder();
connectionStringBuilder.DataSource = databaseServer;
connectionStringBuilder.InitialCatalog = databaseName;
connectionStringBuilder.UserID = databaseUserName;
connectionStringBuilder.Password = databasePassword;
string connectionString = connectionStringBuilder.ToString();
return(new TenantDataCtx(connectionString, tenantId));
}
public static Kiosco Create(/*string databaseServer, string databaseName, string databaseUserName, string databasePassword,*/ string tenantId)
{
var connectionStringBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder();
connectionStringBuilder.DataSource = "LAPTOP-ND2LJQD5";
connectionStringBuilder.InitialCatalog = "PruebaMultiTenantDB";
// connectionStringBuilder.UserID = "emimartins";
// connectionStringBuilder.Password = databasePassword;
string connectionString = connectionStringBuilder.ToString();
return(new Kiosco("data source = LAPTOP-ND2LJQD5; initial catalog = PruebaMultiTenantDB; integrated security = True; MultipleActiveResultSets = True; App = EntityFramework", tenantId));
}
static public void SetupTestDB()
{
if (IsDbSet)
{
return;
}
IsDbSet = true;
string cs = CardValidationServiceDB.DefaultConnectionString;
var ecb = new System.Data.Entity.Core.EntityClient.EntityConnectionStringBuilder(cs);
var cb = new System.Data.SqlClient.SqlConnectionStringBuilder(ecb.ProviderConnectionString)
{
AttachDBFilename = Path.GetFullPath("CardValidationServiceDB.mdf"),
};
ecb.ProviderConnectionString = cb.ToString();
CardValidationServiceDB.DefaultConnectionString = ecb.ConnectionString;
using (var db = new CardValidationServiceDB())
{
try { if (db.Database.Exists())
{
db.Database.Delete();
}
}
catch { }
db.Database.Create();
db.Database.ExecuteSqlCommand(File.ReadAllText(@"..\..\..\CardValidationService.DB\Functions\GetCardType.sql"));
string fuzzDBLibPath = Path.GetFullPath(@"..\CardValidationService.DB\CardValidationServiceDB.dll");
db.Database.ExecuteSqlCommand($"CREATE ASSEMBLY [CardValidationServiceDB] FROM '{fuzzDBLibPath}'");
db.Database.ExecuteSqlCommand(@"
CREATE FUNCTION [dbo].[IsPrimeNumber](@number INT)
RETURNS BIT
EXTERNAL NAME [CardValidationServiceDB].[UserDefinedFunctions].[IsPrimeNumber]");
db.Database.ExecuteSqlCommand(File.ReadAllText(@"..\..\..\CardValidationService.DB\Functions\IsExpiryDateValid.sql"));
db.Database.ExecuteSqlCommand(File.ReadAllText(@"..\..\..\CardValidationService.DB\Procedures\ValidateCard.sql"));
db.Card.AddRange(
from fi in typeof(CardTestInfo).GetFields(BindingFlags.Public | BindingFlags.Static)
where fi.FieldType == typeof(CardTestInfo)
let ci = (CardTestInfo)fi.GetValue(typeof(CardTestInfo))
where ci.ExpiryDate != null
select new Card
{
Number = ci.Number,
ExpiryDate = ci.ExpiryDate.Value
});
db.SaveChanges();
}
}
public VFSModelPersister(string serverName, string databaseName, string userName, string password)
{
var connStringBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder()
{
DataSource = serverName,
InitialCatalog = databaseName,
UserID = userName,
Password = password
};
dbConnectionString = connStringBuilder.ToString();
OpenDbConnection();
CloseConnection();
}
public override string ToString()
{
System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder();
builder.InitialCatalog = this.InitialCatalog;
builder.DataSource = this.DataSource;
//if (this.IsLocal)
// builder.DataSource = Global.SqlCon.DataSource;
builder.IntegratedSecurity = this.IntegratedSecurity;
if (this.IntegratedSecurity == false)
{
builder.Password = this.Password;
builder.UserID = this.UserID;
}
return(builder.ToString());
}
public void ConnectionString_Check()
{
System.Data.SqlClient.SqlConnectionStringBuilder conStrBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder("server=ETHAN-20171016H;uid=sa;pwd=123;Database=TestDB");
conStrBuilder.InitialCatalog = "master";
var constr = conStrBuilder.ToString();
//Server=;Port=5432;UserId=;Password=;Database=;
Npgsql.NpgsqlConnectionStringBuilder conStrBuilder2 = new Npgsql.NpgsqlConnectionStringBuilder("Server=localhost;Port=5432;UserId=sa;Password=1;Database=testDB;");
conStrBuilder2.Database = null;
constr = conStrBuilder2.ToString();
Pomelo.Data.MySql.MySqlConnectionStringBuilder conStrBuilder3 = new Pomelo.Data.MySql.MySqlConnectionStringBuilder("server=locahost;User Id=sa;password=12;Database=testDB");
conStrBuilder3.Database = null;
constr = conStrBuilder3.ToString();
//server=;User Id=;password=;Database=
}
public static string getConnectionStringUDL()
{
System.Data.SqlClient.SqlConnectionStringBuilder sqlString = new System.Data.SqlClient.SqlConnectionStringBuilder()
{
ConnectionString = objDataLayer.ConnectionString,
IntegratedSecurity = true,
MultipleActiveResultSets = true
};
//Build an Entity Framework connection string
System.Data.Entity.Core.EntityClient.EntityConnectionStringBuilder entityString = new System.Data.Entity.Core.EntityClient.EntityConnectionStringBuilder()
{
Provider = (objDataLayer.ProviderName == "SqlClient" ? "System.Data.SqlClient" : objDataLayer.ProviderName),
Metadata = "res://*/GruposEtareosModel.csdl|res://*/GruposEtareosModel.ssdl|res://*/GruposEtareosModel.msl",
ProviderConnectionString = sqlString.ToString()
};
return(entityString.ConnectionString);
}
public static TenantDataCtx Create(string tanent) //string databaseServer, string databaseName, string databaseUserName, string databasePassword, Guid tenantId
{
//var connectionStringBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder();
//connectionStringBuilder.DataSource = databaseServer;
//connectionStringBuilder.InitialCatalog = databaseName;
//connectionStringBuilder.UserID = databaseUserName;
//connectionStringBuilder.Password = databasePassword;
var connectionStringBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder();
connectionStringBuilder.DataSource = "SCIBDDHKICT22\\SQLEXPRESS";
connectionStringBuilder.InitialCatalog = "Company1";
connectionStringBuilder.UserID = "sa";
connectionStringBuilder.Password = "******";
string connectionString = connectionStringBuilder.ToString();
return(new TenantDataCtx(connectionString, tanent));
}
bool TestSQLServer(string server, string port, string database, string userID, string password, int connectionTimeout)
{
System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder();
builder.DataSource = server + (string.IsNullOrWhiteSpace(port) ? string.Empty : ", " + port);
builder.InitialCatalog = database;
builder.ConnectTimeout = connectionTimeout;
if (!string.IsNullOrWhiteSpace(userID))
{
builder.UserID = userID;
builder.Password = password;
}
else
{
builder.IntegratedSecurity = true;
}
using (var conn = new System.Data.SqlClient.SqlConnection(builder.ToString()))
{
return(TestConnection(conn));
}
}
/// <summary>
/// Pega a string de conecão
/// </summary>
/// <returns>Um string</returns>
internal string GetConnString()
{
if (ConnectionParameter.IsHostedEnvironment && ConnectionParameter.TrustedConnection)
{
return(string.Format(@"
server={0};
Initial Catalog={1};
MultipleActiveResultSets=false;Trusted_Connection=Yes;",
ConnectionParameter.Server,
ConnectionParameter.CompanyDb));
}
else if (ConnectionParameter.IsHostedEnvironment &&
!ConnectionParameter.TrustedConnection)
{
var sqlConnStringBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder();
sqlConnStringBuilder.DataSource = ConnectionParameter.Server;
sqlConnStringBuilder.UserID = ConnectionParameter.DBUser;
sqlConnStringBuilder.Password = ConnectionParameter.DBPassword;
sqlConnStringBuilder.InitialCatalog = ConnectionParameter.CompanyDb;
sqlConnStringBuilder.ConnectTimeout = ConnectionParameter.ConnectionTimeout;
return(sqlConnStringBuilder.ToString());
}
else
{
var sqlConnStringBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder();
sqlConnStringBuilder.DataSource = ConnectionParameter.Server;
sqlConnStringBuilder.UserID = ConnectionParameter.DBUser;
sqlConnStringBuilder.Password = ConnectionParameter.DBPassword;
sqlConnStringBuilder.InitialCatalog = ConnectionParameter.Database;
sqlConnStringBuilder.ConnectTimeout = ConnectionParameter.ConnectionTimeout == 0
? 15
: ConnectionParameter.ConnectionTimeout;
return(sqlConnStringBuilder.ToString());
}
}
public static string GetConnectionString()
{
System.Data.SqlClient.SqlConnectionStringBuilder csb = new System.Data.SqlClient.SqlConnectionStringBuilder();
csb.DataSource = System.Environment.MachineName;
if (System.StringComparer.OrdinalIgnoreCase.Equals("COR", System.Environment.UserDomainName))
{
csb.DataSource += @"\SqlExpress";
}
csb.InitialCatalog = "COR_Basic_Demo_V4";
csb.InitialCatalog = "SwissRe_Test_V4";
csb.IntegratedSecurity = System.StringComparer.OrdinalIgnoreCase.Equals(System.Environment.UserDomainName, "COR");
if (!csb.IntegratedSecurity)
{
csb.UserID = SecretManager.GetSecret <string>("DefaultDbUser");
csb.Password = SecretManager.GetSecret <string>("DefaultDbPassword");
}
return(csb.ToString());
}
public bool CmdCheckConnection(IWin32Window owner, String server, LocationType locType, String dbLocation)
{
var builder = new System.Data.SqlClient.SqlConnectionStringBuilder();
builder.DataSource = server;
builder.IntegratedSecurity = true;
builder.AsynchronousProcessing = true;
switch (locType)
{
case LocationType.Name:
builder.InitialCatalog = dbLocation;
break;
case LocationType.Path:
builder.AttachDBFilename = dbLocation;
break;
default:
Debug.Fail("Invalid case: " + locType.ToString());
break;
}
return(CheckConnectionString(owner, builder.ToString()));
}
private static void Main(string[] args)
{
NLog.Targets.Target.Register <Logging.ExceptionalErrorStoreTarget>("ErrorStore");
LoggerCQ.LogInfo("Initializing Service...");
#if DEBUG
LoggerCQ.LogInfo("(Debug Build)");
#endif
//Try to connect to database and if successfull the assume service will start
try
{
var installer = new DatabaseInstaller();
var connectionStringSettings = ConfigurationManager.ConnectionStrings["DatastoreEntities"];
//Just wait a few seconds to determine if the database is there
var cb = new System.Data.SqlClient.SqlConnectionStringBuilder(connectionStringSettings.ConnectionString);
cb.ConnectTimeout = 12;
var b = installer.NeedsUpdate(cb.ToString());
}
catch (Exception ex)
{
LoggerCQ.LogError(ex, "Failed to connect to database.");
throw new Exception("Failed to connect to database.");
}
LoggerCQ.LogInfo("Database connection verified.");
if (args.Any(x => x == "-console" || x == "/console"))
{
try
{
var enableHouseKeeping = true;
if (args.Any(x => x == "-nohousekeeping" || x == "/nohousekeeping"))
{
enableHouseKeeping = false;
}
var service = new PersistentService(enableHouseKeeping);
service.Start();
Console.WriteLine("Press <ENTER> to stop...");
Console.ReadLine();
service.Cleanup();
service.Stop();
}
catch (Exception ex)
{
LoggerCQ.LogError(ex, "Failed to start service from console.");
throw;
}
}
else
{
try
{
var servicesToRun = new ServiceBase[]
{
new PersistentService()
};
ServiceBase.Run(servicesToRun);
}
catch (Exception ex)
{
LoggerCQ.LogError(ex, "Failed to start service.");
}
}
}
private void radioButton_Click(object sender, EventArgs e)
{
Cursor mic = mapBox1.Cursor;
mapBox1.Cursor = Cursors.WaitCursor;
Cursor = Cursors.WaitCursor;
if (formSqlServerOpts != null)
{
formSqlServerOpts.Close();
formSqlServerOpts = null;
}
try
{
//mapImage.ActiveTool = MapImage.Tools.None;
string text = ((RadioButton)sender).Text;
switch (text)
{
case "Shapefile":
mapBox1.Map = ShapefileSample.InitializeMap(tbAngle.Value);
break;
case "GradientTheme":
mapBox1.Map = GradiantThemeSample.InitializeMap(tbAngle.Value);
break;
case "WFS Client":
mapBox1.Map = WfsSample.InitializeMap(tbAngle.Value);
break;
case "WMS Client":
//mapBox1.Map = TiledWmsSample.InitializeMap();
mapBox1.Map = WmsSample.InitializeMap(tbAngle.Value);
break;
case "OGR - MapInfo":
case "OGR - S-57":
mapBox1.Map = OgrSample.InitializeMap(tbAngle.Value);
break;
case "GDAL - GeoTiff":
case "GDAL - '.DEM'":
case "GDAL - '.ASC'":
case "GDAL - '.VRT'":
mapBox1.Map = GdalSample.InitializeMap(tbAngle.Value);
mapBox1.ActiveTool = MapBox.Tools.Pan;
break;
case "TileLayer - OSM":
case "TileLayer - OSM with XLS":
case "TileLayer - Bing Roads":
case "TileLayer - Bing Aerial":
case "TileLayer - Bing Hybrid":
case "TileLayer - GoogleMap":
case "TileLayer - GoogleSatellite":
case "TileLayer - GoogleTerrain":
case "TileLayer - GoogleLabels":
case "Eniro":
/*
* tbAngle.Visible = text.Equals("TileLayer - GoogleLabels");
* if (!tbAngle.Visible) tbAngle.Value = 0;
*/
mapBox1.Map = TileLayerSample.InitializeMap(tbAngle.Value);
((RadioButton)sender).Text = (mapBox1.Map.BackgroundLayer.Count > 0)
? ((RadioButton)sender).Text = mapBox1.Map.BackgroundLayer[0].LayerName
: ((RadioButton)sender).Text = mapBox1.Map.Layers[0].LayerName;
break;
case "PostGis":
mapBox1.Map = PostGisSample.InitializeMap(tbAngle.Value);
break;
case "SpatiaLite":
mapBox1.Map = SpatiaLiteSample.InitializeMap(tbAngle.Value);
break;
case "SqlServer":
// create empty map with BruTile basemap
mapBox1.Map = SqlServerSample.InitializeMap(tbAngle.Value);
// check conn string
var connStrBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder(Properties.Settings.Default.SqlServerConnectionString);
if (string.IsNullOrEmpty(connStrBuilder.DataSource) || string.IsNullOrEmpty(connStrBuilder.InitialCatalog))
{
mapBox1.Refresh();
MessageBox.Show("Requires SqlServer connection string to be defined (Project / Settings)",
"Sql Server", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
// now show SqlServer dialog
formSqlServerOpts = new FormSqlServerOpts()
{
MapBox = mapBox1,
ConnectionString = connStrBuilder.ToString()
};
formSqlServerOpts.Show(this);
break;
case "Oracle":
mapBox1.Map = OracleSample.InitializeMap(tbAngle.Value);
break;
case "shp_TextOnPath":
mapBox1.Map = TextOnPathSample.InitializeMapOrig(tbAngle.Value);
break;
case "GdiImageLayer":
mapBox1.Map = GdiImageLayerSample.InitializeMap(tbAngle.Value);
break;
default:
break;
}
//Add checked Map decorations
foreach (ListViewItem checkedItem in lvwDecorations.CheckedItems)
{
Type mdType;
if (MapDecorationTypes.TryGetValue(checkedItem.Text, out mdType))
{
IMapDecoration md = Activator.CreateInstance(mdType) as IMapDecoration;
mapBox1.Map.Decorations.Add(md);
}
}
mapBox1.Map.Size = Size;
mapBox1.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error");
}
finally
{
Cursor = Cursors.Default;
mapBox1.Cursor = mic;
}
}
public bool CmdCheckConnection(IWin32Window owner, String server, LocationType locType, String dbLocation)
{
var builder = new System.Data.SqlClient.SqlConnectionStringBuilder();
builder.DataSource = server;
builder.IntegratedSecurity = true;
builder.AsynchronousProcessing = true;
switch (locType)
{
case LocationType.Name:
builder.InitialCatalog = dbLocation;
break;
case LocationType.Path:
builder.AttachDBFilename = dbLocation;
break;
default:
Debug.Fail("Invalid case: " + locType.ToString());
break;
}
return CheckConnectionString(owner, builder.ToString());
}
private static System.Data.SqlClient.SqlConnection Connection()
{
var csb = new System.Data.SqlClient.SqlConnectionStringBuilder();
csb.DataSource = Server;
csb.InitialCatalog = Database;
if (User == null)
{
csb.IntegratedSecurity = true;
}
else
{
csb.IntegratedSecurity = false;
csb.UserID = User;
csb.Password = Password;
}
var conn= new System.Data.SqlClient.SqlConnection(csb.ToString());
conn.Open();
return conn;
}
public SQLTransactionScopeProviderDataAccessor(System.Data.SqlClient.SqlConnectionStringBuilder stringBuilder) : this(stringBuilder.ToString())
{
}
