/// <summary>
/// Determines the correct provider to use and sets up the connection and command
/// objects for use in other methods
/// </summary>
/// <param name="connectString">The full connection string to the database</param>
/// <param name="providerlist">The enum value of providers from dbutilities.Providers</param>
public void CreateDBObjects(string connectString, Providers providerList)
{
//CreateDBObjects(connectString, providerList, null);
switch (providerList)
{
case Providers.SqlServer:
_factory = SqlClientFactory.Instance;
break;
case Providers.Oracle:
_factory = OracleClientFactory.Instance;
break;
case Providers.OleDB:
_factory = OleDbFactory.Instance;
break;
case Providers.ODBC:
_factory = OdbcFactory.Instance;
break;
}
_connection = _factory.CreateConnection();
_command = _factory.CreateCommand();
_connection.ConnectionString = connectString;
_command.Connection = connection;
}
public Task Init(string name, Providers.IProviderRuntime providerRuntime, Providers.IProviderConfiguration config)
{
this.Name = name;
if (!config.Properties.ContainsKey("DataConnectionString") || string.IsNullOrWhiteSpace(config.Properties["DataConnectionString"]))
{
throw new ArgumentException("DataConnectionString property not set");
}
var connectionString = config.Properties["DataConnectionString"];
var tableName = "OrleansGrainState";
if (config.Properties.ContainsKey("TableName"))
{
tableName = config.Properties["TableName"];
}
Log = providerRuntime.GetLogger("Storage.AzureTableStorageEx", Logger.LoggerType.Runtime);
CloudStorageAccount storageAccount = null;
if (!CloudStorageAccount.TryParse(connectionString, out storageAccount))
{
throw new ApplicationException("Invalid DataConnectionString");
}
var tableClient = storageAccount.CreateCloudTableClient();
_table = tableClient.GetTableReference(tableName);
return _table.CreateIfNotExistsAsync();
}
void LiveControlManager_OnScreenshotReceived(object sender, Providers.LiveControl.Client.ScreenshotMessageEventArgs e)
{
var screenshot = e.Screenshot;
using (var stream = new MemoryStream(screenshot.Image))
{
Image image = Image.FromStream(stream);
if (ShowRegionOutlines)
{
var gfx = gdiScreen1.CreateGraphics();
gfx.DrawLine(pen, new Point(e.Screenshot.Region.X, e.Screenshot.Region.Y), new Point(e.Screenshot.Region.X + e.Screenshot.Region.Width, e.Screenshot.Region.Y));
gfx.DrawLine(pen, new Point(e.Screenshot.Region.X + e.Screenshot.Region.Width, e.Screenshot.Region.Y), new Point(e.Screenshot.Region.X + e.Screenshot.Region.Width, e.Screenshot.Region.Y + e.Screenshot.Region.Y));
gfx.DrawLine(pen, new Point(e.Screenshot.Region.X + e.Screenshot.Region.Width, e.Screenshot.Region.Y + e.Screenshot.Region.Y), new Point(e.Screenshot.Region.X, e.Screenshot.Region.Y + e.Screenshot.Region.Y));
gfx.DrawLine(pen, new Point(e.Screenshot.Region.X, e.Screenshot.Region.Y + e.Screenshot.Region.Y), new Point(e.Screenshot.Region.X, e.Screenshot.Region.Y));
gfx.Dispose();
}
gdiScreen1.Draw(image, screenshot.Region);
}
LiveControlManager.RequestScreenshot();
Trace.WriteLine(String.Format("Processed Image #{0}, Size: {1} KB", e.Screenshot.Number, GetKBFromBytes(e.Screenshot.Image.Length)));
}
public Consumer(Providers.Consumer consumer)
{
this.Callback = consumer.Callback;
this.Key = consumer.Key;
this.Name = consumer.Name;
this.Secret = consumer.Secret;
}
public DatabaseSessionManager(Providers.IEngine engine, Providers.IDatabase db)
{
_engine = engine;
_db = db;
_db.SessionManager = this;
_sessions = new Dictionary<Guid, Session>();
}
public DatabaseSessionManager(Providers.IEngine engine, Providers.IDatabase db, List<Security.Group> groups)
{
_engine = engine;
_db = db;
_db.SessionManager = this;
_sessions = new Dictionary<Guid, Session>();
_groups = groups;
}
public override void FillField(Providers.BaseDataMap map, object importRow, ref Item newItem, string importValue, out bool updatedField, ref LevelLogger logger)
{
var xml = string.Empty;
if (!String.IsNullOrEmpty(importValue))
{
xml = String.Format(SitecoreExternalLinkXml, importValue);
}
base.FillField(map, importRow, ref newItem, xml, out updatedField, ref logger);
}
public Initialize(EngineRequest request, Security.SessionManager sessionManager,
Providers.EngineBase.InitializationDelegate onInitialized, List<Providers.IDatabase> databases)
: base(request)
{
_sessionMgr = sessionManager;
_ignoringInitializationComplete = false;
request.Engine.SetState(false, false);
_databases = databases;
_onInitialized = onInitialized;
}
public DatabaseHelper(string connectionstring, Providers provider)
{
strConnectionString = connectionstring;
switch (provider)
{
case Providers.SqlServer:
objFactory = SqlClientFactory.Instance;
break;
case Providers.OleDb:
objFactory = OleDbFactory.Instance;
break;
case Providers.ODBC:
objFactory = OdbcFactory.Instance;
break;
case Providers.ConfigDefined:
string providername="";
if (connectionstring=="")
{
if (!string.IsNullOrEmpty(ConnectionStringHnalder))
connectionstring = ConnectionStringHnalder;
else
{
//Get connection information
GetConnectionInfoFromConfig(ref strConnectionString, ref providername);
ConnectionStringHnalder = strConnectionString;
}
}
else
{
ConnectionStringHnalder = connectionstring;
providername = ConfigurationManager.ConnectionStrings["connectionstring"].ProviderName;
}
switch (providername)
{
case "System.Data.SqlClient":
objFactory = SqlClientFactory.Instance;
break;
case "System.Data.OleDb":
objFactory = OleDbFactory.Instance;
break;
case "System.Data.Odbc":
objFactory = OdbcFactory.Instance;
break;
}
break;
}
objConnection = objFactory.CreateConnection();
objCommand = objFactory.CreateCommand();
objConnection.ConnectionString = strConnectionString;
objCommand.Connection = objConnection;
}
public static IAuthentication CreateAuthenticator(Providers provider)
{
switch (provider)
{
case Providers.TigoBolivia:
return new TBoliviaAuthenticationProvider();
case Providers.VivaBolivia:
throw new NotImplementedException();
default:
throw new NotImplementedException();
}
}
public static IDataProvider CreateDataProvider(Providers provider)
{
switch (provider)
{
case Providers.TigoBolivia:
return new TBoliviaDataProvider();
case Providers.VivaBolivia:
throw new NotImplementedException();
default:
throw new NotImplementedException();
}
}
/// <summary>
/// create a tracker for preferred provider with custom tick timeout and poll frequency settings
/// </summary>
/// <param name="pollintervalms"></param>
/// <param name="timeoutintervalsec"></param>
/// <param name="client"></param>
/// <param name="PreferredBroker"></param>
/// <param name="connectany"></param>
public TLTracker(int pollintervalms, int timeoutintervalsec, TLClient client, Providers PreferredBroker, bool connectany)
{
_tl = client;
_tw = new TickWatcher(pollintervalms);
_tw.AlertThreshold = timeoutintervalsec;
_connected = (client.ProvidersAvailable.Length > 0) && (client.ProviderSelected >= 0);
if (!_connected && (GotConnectFail!= null))
GotConnectFail();
if (_connected && (GotConnect != null))
GotConnect();
// handle situations when no ticks arrive
_tw.GotMassAlert += new Int32Delegate(_tw_GotMassAlert);
_broker = PreferredBroker;
_connectany = connectany;
}
/// <summary>
/// if you provide ip addresses, BF will use IP as the transport.
/// otherwise it uses windows ipc/messaging
/// </summary>
/// <param name="feed"></param>
/// <param name="broker"></param>
/// <param name="useany"></param>
/// <param name="threadsafe"></param>
/// <param name="program"></param>
/// <param name="servers"></param>
/// <param name="port"></param>
public BrokerFeed(Providers feed, Providers broker, bool useany, bool threadsafe,string program, string[] servers, int port)
{
_servers = servers;
_port = port;
PROGRAM = program;
_feed = feed;
_broker = broker;
_reqpref = useany;
_threadsafe = threadsafe;
if (_threadsafe)
{
_reader = new Thread(new ParameterizedThreadStart(readdata));
_reader.Start();
}
}
//Constructor for using an intrinsic .Net SymmetricAlgorithm class.
public Crypto(Providers NetSelected)
{
switch (NetSelected)
{
case Providers.DES:
_CryptoService = new DESCryptoServiceProvider();
break;
case Providers.RC2:
_CryptoService = new RC2CryptoServiceProvider();
break;
case Providers.Rijndael:
_CryptoService = new RijndaelManaged();
break;
}
}
public DatabaseHelper(string connectionstring,Providers provider)
{
strConnectionString = connectionstring;
switch (provider)
{
case Providers.SqlServer:
objFactory = SqlClientFactory.Instance;
break;
case Providers.OleDb:
objFactory = OleDbFactory.Instance;
break;
case Providers.Oracle:
objFactory = OracleClientFactory.Instance;
break;
case Providers.ODBC:
objFactory = OdbcFactory.Instance;
break;
case Providers.ConfigDefined:
string providername=ConfigurationManager.ConnectionStrings["connectionstring"].ProviderName;
switch (providername)
{
case "System.Data.SqlClient":
objFactory = SqlClientFactory.Instance;
break;
case "System.Data.OleDb":
objFactory = OleDbFactory.Instance;
break;
case "System.Data.OracleClient":
objFactory = OracleClientFactory.Instance;
break;
case "System.Data.Odbc":
objFactory = OdbcFactory.Instance;
break;
}
break;
}
objConnection = objFactory.CreateConnection();
objCommand = objFactory.CreateCommand();
objConnection.ConnectionString = strConnectionString;
objCommand.Connection = objConnection;
}
public async Task Init(string name, Providers.IProviderRuntime providerRuntime, Providers.IProviderConfiguration config)
{
try
{
var url = config.Properties["Url"];
var key = config.Properties["Key"];
var databaseName = config.Properties["Database"];
this.Client = new DocumentClient(new Uri(url), key);
var databases = await this.Client.ReadDatabaseFeedAsync();
this.Database = databases.Where(d => d.Id == databaseName).FirstOrDefault()
?? await this.Client.CreateDatabaseAsync(new Database { Id = databaseName });
}
catch (Exception ex)
{
Log.Error(0, "Error in Init.", ex);
}
}
public override void FillField(Providers.BaseDataMap map, object importRow, ref Item newItem, string importValue, out bool updatedField, ref LevelLogger logger)
{
var fillFieldLogger = logger.CreateLevelLogger();
var xml = string.Empty;
if (!String.IsNullOrEmpty(importValue))
{
const string pattern = @".+\@.+\..+";
if (Regex.Match(importValue, pattern).Success)
{
xml = String.Format(SitecoreEmailLinkXml, importValue);
}
else
{
updatedField = false;
fillFieldLogger.AddError(CategoryConstants.EmailWasInWrongFormatOnImportRow, String.Format("The import value '{0}' was not a correct email. The value was not stored on the field. Importrow: {1}. ", importValue, map.GetImportRowDebugInfo(importRow)));
return;
}
}
base.FillField(map, importRow, ref newItem, xml, out updatedField, ref fillFieldLogger);
}
internal static void ListProviders()
{
using (Providers providers = new Providers(ChannelEditing.object_store))
{
foreach(Provider provider in providers)
{
Console.WriteLine("Copyright: {0} DisplayName: {1} Id: {2} Name: {3} Provider: {4} Uids: {5}",
provider.Copyright, provider.DisplayName, provider.Id, provider.Name, provider.Provider,
Misc.UidsToString(provider.UIds));
}
}
using (Lineups lineups = new Lineups(ChannelEditing.object_store))
{
foreach(Lineup lineup in lineups)
{
Console.WriteLine("Lineup ID: {0} Name: {1} UIDs: {2} Provider: {3}",
lineup.Id, lineup.Name, Misc.UidsToString(lineup.UIds), lineup.Provider);
}
}
}
public static IWeatherDataService getWeatherDataService(Providers site)
{
switch(site)
{
case Providers.OPENMAP:
return WeatherDataProviderOpenWeatherMap.Instance;
case Providers.WUNDERGROUND:
return WeatherDataProviderWunderGround.Instance;
case Providers.WORLDWEATHERONLINE:
return WeatherDataProviderWorldWeatherOnline.Instance;
default:
return null;
}
}
int getproviderindex(Providers p)
{
if (p == Providers.Unknown) return -1;
for (int i = 0; i < ProvidersAvailable.Length; i++)
if (ProvidersAvailable[i] == p) return i;
return -1;
}
/// <summary>
/// create broker feed
/// </summary>
/// <param name="feed"></param>
/// <param name="broker"></param>
/// <param name="useany"></param>
/// <param name="threadsafe"></param>
public BrokerFeed(Providers feed, Providers broker, bool useany, bool threadsafe)
: this(feed, broker, useany, threadsafe, "BrokerFeed", new string[0],IPUtil.TLDEFAULTBASEPORT)
{
}
/// <summary>
/// reset brokerfeed, look for any new servers and attempt to connect to current preferred providers
/// </summary>
public void Reset()
{
feedready = false;
if (IPUtil.hasValidAddress(_servers))
debug("At least one valid IpAddress found, attempting IP transport.");
else
debug("No ip addresses specified, attempting Windows IPC.");
TLClient tl = getsearchclient();
_pavail = tl.ProvidersAvailable;
if (_pavail.Length == 0)
debug("No providers were found. Ensure connectors are running.");
bool setquote = false;
bool setexec = false;
// see if we can get preferred providers
int xi = getproviderindex(_broker);
int qi = getproviderindex(_feed);
_isprefq = (qi != -1) && hasminquote(tl, qi);
_isprefx = (xi != -1) && hasminexec(tl, xi);
if (!isPreferredFeed)
debug("preferred data not available: " + _feed);
if (!isPreferredBroker)
debug("preferred execute not available: " + _broker);
// search for features
for (int i = 0; i < ProvidersAvailable.Length; i++)
{
if ((qi != -1) && (xi != -1)) break;
// switch to provider
if ((qi == -1) && hasminquote(tl, i))
qi = i;
if ((xi == -1) && hasminexec(tl, i))
xi = i;
}
// see if we're allowed to fallback
// not allowed
if (RequirePreferred)
{
setquote = isPreferredFeed ;
setexec = isPreferredBroker ;
}
else // ok to fallback,but where
{
setquote = (qi != -1);
setexec = (xi != -1);
}
// map handlers
if (setquote)
{
quote = getrealclient(qi, PROGRAM + "quote");
quote.gotFeatures += new MessageTypesMsgDelegate(quote_gotFeatures);
debug("DataFeed: " + quote.BrokerName + " " + quote.ServerVersion);
_feed = quote.BrokerName;
// clear any leftover subscriptions
quote.Unsubscribe();
if (isThreadSafe)
{
quote.gotTick += new TickDelegate(quote_gotTick);
quote.gotUnknownMessage += new MessageDelegate(quote_gotUnknownMessage);
}
else
{
quote.gotTick += new TickDelegate(quote_gotTick2);
quote.gotUnknownMessage += new MessageDelegate(quote_gotUnknownMessage2);
}
quote.gotImbalance += new ImbalanceDelegate(quote_gotImbalance);
}
if (setexec)
{
execute = getrealclient(xi, PROGRAM + "exec");
_broker = execute.BrokerName;
execute.gotFeatures += new MessageTypesMsgDelegate(execute_gotFeatures);
if (isThreadSafe)
{
execute.gotAccounts += new DebugDelegate(execute_gotAccounts);
execute.gotFill += new FillDelegate(execute_gotFill);
execute.gotOrder += new OrderDelegate(execute_gotOrder);
execute.gotOrderCancel += new LongDelegate(execute_gotOrderCancel);
execute.gotPosition += new PositionDelegate(execute_gotPosition);
execute.gotUnknownMessage += new MessageDelegate(execute_gotUnknownMessage);
}
else
{
execute.gotAccounts += new DebugDelegate(execute_gotAccounts2);
execute.gotFill += new FillDelegate(execute_gotFill2);
execute.gotOrder += new OrderDelegate(execute_gotOrder2);
execute.gotOrderCancel += new LongDelegate(execute_gotOrderCancel2);
execute.gotPosition += new PositionDelegate(execute_gotPosition2);
execute.gotUnknownMessage += new MessageDelegate(execute_gotUnknownMessage2);
}
debug("Executions: " + execute.BrokerName + " " + execute.ServerVersion);
if (RequestAccountsOnStartup)
RequestAccounts();
}
feedready = true;
// connect to the rest
for (int i = 0; i < ProvidersAvailable.Length; i++)
{
// skip existing connections
if (i == xi)
{
_pcon.Add(execute);
continue;
}
if ((xi!=qi) && (i == qi))
{
_pcon.Add(quote);
continue;
}
// add new connections
TLClient newcon = getrealclient(i, PROGRAM);
newcon.gotFeatures += new MessageTypesMsgDelegate(newcon_gotFeatures);
newcon.gotUnknownMessage += new MessageDelegate(newcon_gotUnknownMessage);
_pcon.Add(newcon);
}
tl.Disconnect();
tl = null;
}
public bool ModifyFeed(int provider, bool warn)
{
if (!feedready) return false;
TLClient tl = getsearchclient();
if ((provider < 0) || (provider > ProvidersAvailable.Length)) return false;
Providers p = ProvidersAvailable[provider];
bool ok = hasminquote(tl, provider);
if (!ok)
{
System.Windows.Forms.MessageBox.Show(p.ToString() + " does not support quotes.");
return false;
}
this.v(tl.Name + " " + provider + " " + tl.BrokerName + (ok ? " has feed support." : " no feed support."));
_feed = p;
tl.Disconnect();
Reset();
return true;
}
public bool isProviderAvailable(Providers p)
{
int idx = getproviderindex(p);
return idx != -1;
}
public override byte[] GetImageAsBytes(Providers.BaseDataMap map, object importRow, ref Item newItem, string importValue, ref LevelLogger logger)
{
var getImageAsBytesLogger = logger.CreateLevelLogger();
try
{
if (IsRequired && String.IsNullOrEmpty(importValue))
{
getImageAsBytesLogger.AddError("Required field was null or empty in GetImageAsBytes", String.Format(
"The 'GetImageAsBytes' could not retrieve an image since the importValue was null or empty. The field was marked as required. " +
"ImportRow: {0}.",
map.GetImportRowDebugInfo(importRow)));
return null;
}
if (!IsRequired && String.IsNullOrEmpty(importValue))
{
return null;
}
if (String.IsNullOrEmpty(ImageFilesToImportAbsolutePath))
{
getImageAsBytesLogger.AddError("The setting 'ImageFilesToImportAbsolutePath' was null or empty", String.Format(
"The setting 'ImageFilesToImportAbsolutePath' was null or empty. Therefor the image could not be found, since there is no place to search for it. Plase provide a value." +
"ImportValue: {0}. ImportRow: {1}.", importValue, map.GetImportRowDebugInfo(importRow)));
return null;
}
var searchPattern = importValue + "*.*";
var directoryInfo = new DirectoryInfo(ImageFilesToImportAbsolutePath);
var files = directoryInfo.GetFiles(searchPattern, SearchTopDirectoryOnly);
if (files.Length == 0)
{
getImageAsBytesLogger.AddError("Attempt to find a file failed in GetImageAsBytes", String.Format(
"In the GetImageAsBytes method the attempt to find a file failed. No file was found in the search for file '{0}' in the folder '{1}'." +
" ImportValue: {2}. ImportRow: {3}. SearchTopDirectoryOnlye: {4}.", searchPattern,
ImageFilesToImportAbsolutePath, importValue, map.GetImportRowDebugInfo(importRow),
SearchTopDirectoryOnly));
return null;
}
if (files.Length > 1)
{
getImageAsBytesLogger.AddError("More than one file found in GetImageAsBytes", String.Format(
"In the GetImageAsBytes method there where found more than one file in the search for file '{0}' in the folder '{1}'." +
" ImportValue: {2}. ImportRow: {3}. SearchTopDirectoryOnlye: {4}.", searchPattern,
ImageFilesToImportAbsolutePath, importValue, map.GetImportRowDebugInfo(importRow),
SearchTopDirectoryOnly));
return null;
}
var file = files.First();
if (file != null)
{
try
{
byte[] bytes = File.ReadAllBytes(file.FullName);
return bytes;
}
catch (Exception ex)
{
getImageAsBytesLogger.AddError("Exception occured trying to ReadAllBytes from GetImageAsBytes", String.Format(
"In the GetImageAsBytes method an exception occured in trying to ReadAllBytes from file '{0}'. SearchPattern: '{1}' in the folder '{2}'." +
" ImportValue: {3}. ImportRow: {4}. SearchTopDirectoryOnlye: {5}. Exception: {6}.",
file.FullName, searchPattern, ImageFilesToImportAbsolutePath, importValue,
map.GetImportRowDebugInfo(importRow), SearchTopDirectoryOnly,
map.GetExceptionDebugInfo(ex)));
return null;
}
}
getImageAsBytesLogger.AddError("One file found but it was null in GetImageAsBytes", String.Format(
"In the GetImageAsBytes method one file was found, but it was null. SearchPattern: '{0}' in the folder '{1}'." +
" ImportValue: {2}. ImportRow: {3}. SearchTopDirectoryOnlye: {4}.",
searchPattern, ImageFilesToImportAbsolutePath, importValue, map.GetImportRowDebugInfo(importRow),
SearchTopDirectoryOnly));
return null;
}
catch (Exception ex)
{
getImageAsBytesLogger.AddError(CategoryConstants.GetImageAsBytesFailedWithException, String.Format("In the GetImageAsBytes method an exception occured. ImageFilesToImportAbsolutePath: '{0}'." +
" ImportValue: {1}. ImportRow: {2}. SearchTopDirectoryOnlye: {3}. Exception: {4}",
ImageFilesToImportAbsolutePath, importValue, map.GetImportRowDebugInfo(importRow), SearchTopDirectoryOnly, map.GetExceptionDebugInfo(ex)));
return null;
}
}
public bool Mode(int ProviderIndex, bool showwarning)
{
// search our provider list
TLFound();
// see if called from start
if (ProviderIndex < 0)
{
debug("provider index cannot be less than zero, using first provider.");
ProviderIndex = 0;
}
// attempt to connect to preferred
bool ok = connect(ProviderIndex, false);
if (!_started && ok)
{
// restart if we connected
_started = true;
// background thread to receive messages
debug("client starting background thread.");
_bw = new System.ComponentModel.BackgroundWorker();
_bw.WorkerSupportsCancellation = true;
_bw.DoWork += new System.ComponentModel.DoWorkEventHandler(_bw_DoWork);
_bw.RunWorkerAsync(ProviderIndex);
_bw2 = new System.ComponentModel.BackgroundWorker();
_bw2.WorkerSupportsCancellation = true;
_bw2.DoWork+=new System.ComponentModel.DoWorkEventHandler(_bw2_DoWork);
_bw2.RunWorkerAsync(ProviderIndex);
}
if (!ok)
{
debug("Unable to connect to provider: " + ProviderIndex);
return false;
}
try
{
// register ourselves with provider
Register();
// request list of features from provider
RequestFeatures();
// assuming we got this far, mark selected provider current
_curprovider = ProviderIndex;
_bn = servers[_curprovider];
return true;
}
catch (SocketException ex)
{
debug("socket exception: " + ex.SocketErrorCode + ex.Message + ex.StackTrace);
}
catch (Exception ex)
{
debug(ex.Message+ex.StackTrace);
}
debug("Server not found at index: " + ProviderIndex);
return false;
}
public Config(Providers.Settings.ISettings settings, Providers.Settings.ConfigSection configSection)
{
_settings = settings;
_config = configSection;
}
public DataAccess(Providers provider)
: this(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString, provider)
{
}
public DbHelper(Providers provider)
: this(ConfigurationManager.ConnectionStrings["PFDConnectionString"].ConnectionString, provider)
{
}
/// <summary>
/// create a tracker for a preferred provider on client
/// </summary>
/// <param name="client"></param>
/// <param name="PreferredBroker"></param>
public TLTracker(TLClient client, Providers PreferredBroker) : this(DEFAULTPOLLMS,DEFAULTTIMEOUTSEC,client, PreferredBroker, false) { }
