/// <summary>
/// Will use the License.DAT file for ConnectionString
/// Use this function for Desktop Applications
/// </summary>
public Oyster()
{
try
{
// string ConnectionString = GetEncryptedConnectionString();
string ConnectionString;
if (System.Web.HttpContext.Current == null)
{
RegistryKey rk = CarverLab.Utility.Registry.DefaultProductKey;
if (rk == null)
{
Logger.WriteLog("Could not find the registry key {0} in the registry.", CarverLab.Utility.Registry.DefaultProductKeyString);
throw new ApplicationException("The registry key " + CarverLab.Utility.Registry.DefaultProductKeyString + " could not be found. This application may not be setup properly.");
}
object obj = rk.GetValue("ConnectionString");
if (obj == null)
{
Logger.WriteLog("Could not find the connection string at {0} in the registry.", rk.ToString());
throw new ApplicationException("The server connection info could not be found. Please contact your system administrator.");
}
ConnectionString = obj.ToString();
Logger.WriteLog("Got a ConnectionString from the registry");
}
else
{
ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
if (ConnectionString == null || ConnectionString.Trim().Length == 0)
{
throw new ApplicationException("The web.config Connection String for " + CarverLab.Utility.AppInfo.Title + " could not be found. Is this application setup properly?");
}
Logger.WriteLog("Got a ConnectionString from app settings");
}
if(ConnectionString == "")
throw new Exception("Unable to acquire connection data to Database!!");
SCO = new StaticConnectionObject();
SCO.StaticConnectionString = ConnectionString;
SCO.IsConnectionStatic = true;
OysterTimer = new System.Timers.Timer(5000);
OysterTimer.Elapsed += new System.Timers.ElapsedEventHandler(this.OysterTimer_Tick);
OysterTimer.AutoReset = true;
OysterTimer.Enabled = false;
IsLoggedOn = false;
Logger.WriteLog("created Oyster object");
}
catch(Exception Err)
{
throw new Exception(Err.Message,Err.InnerException);
}
}
/// <summary>
/// Will use the License.DAT file for ConnectionString
/// If Set to True it will look for the License.DAT file in
/// "//LocalHost/License.dat" Otherwise in the application directory.
/// </summary>
public Oyster(bool IsWebApplication)
{
try
{
mvarIsRunningInWebApp = IsWebApplication;
string ConnectionString = GetEncryptedConnectionString();
if(ConnectionString == "")
throw new Exception("Unable to aquire connection data to Database!!");
SCO = new StaticConnectionObject();
SCO.StaticConnectionString = ConnectionString;
SCO.IsConnectionStatic = true;
OysterTimer = new System.Timers.Timer(5000);
OysterTimer.Elapsed += new System.Timers.ElapsedEventHandler(this.OysterTimer_Tick);
OysterTimer.AutoReset = true;
OysterTimer.Enabled = false;
IsLoggedOn = false;
Logger.WriteLog("Created an Oyster object for a web application");
}
catch(Exception Err)
{
throw new Exception(Err.Message,Err.InnerException);
}
}
public Oyster(string ServerAddress, string sPassword)
{
try
{
if (ServerAddress != "")
{
SCO = new StaticConnectionObject();
SCO.StaticConnectionString = "data source=" + ServerAddress + ";initial catalog=Oyster;persist security info=False;user id=sa;password="******";packet size=4096";
SCO.IsConnectionStatic = true;
try
{
EncryptConnectionString(SCO.StaticConnectionString);
}
catch
{
}
}
OysterTimer = new System.Timers.Timer(5000);
OysterTimer.Elapsed += new System.Timers.ElapsedEventHandler(this.OysterTimer_Tick);
OysterTimer.AutoReset = true;
OysterTimer.Enabled = false;
IsLoggedOn = false;
Logger.WriteLog("created Oyster object with passed in ServerAddress and Password");
}
catch(Exception Err)
{
throw new Exception(Err.Message,Err.InnerException);
}
}
public Oyster(string ConnectionString)
{
try
{
if(ConnectionString != "")
{
SCO = new StaticConnectionObject();
SCO.StaticConnectionString = ConnectionString;
SCO.IsConnectionStatic = true;
EncryptConnectionString(ConnectionString);
}
OysterTimer = new System.Timers.Timer(5000);
OysterTimer.Elapsed += new System.Timers.ElapsedEventHandler(this.OysterTimer_Tick);
OysterTimer.AutoReset = true;
OysterTimer.Enabled = false;
IsLoggedOn = false;
Logger.WriteLog("created Oyster object with passed in ConnectionString");
}
catch(Exception Err)
{
throw new Exception(Err.Message,Err.InnerException);
}
}
// internal void ShareOpenConnection(ref SqlConnection R)
// {
// R = MC;
// }
// internal SqlConnection GetConnection()
// {
// return MC;
// }
internal string GetConnectionString()
{
StaticConnectionObject OCL = new StaticConnectionObject();
return OCL.StaticConnectionString;
}
//internal string ConnectionString;
/// <summary>
/// Opens and manages its own connection to the Oyster Database
/// ALL Instances of the Functions Class use the same Connection
/// Always returns True
/// </summary>
///
public Functions()
{
//
// TODO: Add constructor logic here
//
try
{
// if(MC == null)
// {
// MC = new SqlConnection();
// }
//
// if((MC.State == ConnectionState.Closed)||(MC.State == ConnectionState.Broken))
// {
if(!IsInitialized)
{
IsInitialized = true;
StaticConnectionObject OCL = new StaticConnectionObject();
if(!OCL.IsConnectionStatic)
{
RegistryKey RK;
//RK = Registry.LocalMachine.OpenSubKey("Software\\VSC\\CardVideo");
//UseExternalDatabase = 0;
RK = Registry.LocalMachine.OpenSubKey("Software\\Carver Lab\\Oyster V2.0\\Data");
if(RK != null)
{
ConnectionString = Convert.ToString((object)RK.GetValue("ConnectionString",""));
//UseExternalDatabase = Convert.ToInt32((object)RK.GetValue("UseExternalDatabase",0));
}
//ConnectionString = "data source=mssql2.michiganwebtech.com;initial catalog=carverl_oyster;persist security info=False;user id=carverl_admin;password = oyster;packet size=4096";
//ConnectionString = "data source=localhost;initial catalog=Oyster;persist security info=False;user id=sa;workstation id=LIGHTBRINGER;packet size=4096";
}
else
ConnectionString = OCL.StaticConnectionString;
m_Connections = new Functions.RFConnection[5];
for (int i = 0; i < m_Connections.GetLength(0); i++)
{
m_Connections[i] = new Functions.RFConnection(new System.Data.SqlClient.SqlConnection(ConnectionString));
}
}
// MC = new SqlConnection(ConnectionString);
// numconnections++;
// MC.Open();
// }
// else
// {
// //Do Nothing but share the already existing connection
// numconnections++;
// }
}
catch(Exception Err)
{
throw new Exception(Err.Message,Err.InnerException);
}
}
public void BeginUsingNewConnectionString(string sConnectionString)
{
StaticConnectionObject SCO = new StaticConnectionObject();
SCO.IsConnectionStatic = true;
SCO.StaticConnectionString = sConnectionString;
ConnectionString = sConnectionString;
foreach(Functions.RFConnection mConn in m_Connections)
{
try
{
if((mConn.Connection.State == ConnectionState.Closed)||(mConn.Connection.State == ConnectionState.Broken))
{
mConn.Connection.ConnectionString = sConnectionString;
//mConn.Connection.Open();
}
else
{
mConn.Connection.Close();
mConn.Connection.ConnectionString = sConnectionString;
//mConn.Connection.Open();
}
}
catch(Exception Err)
{
throw new Exception(Err.Message,Err.InnerException);
}
}
}