public static void WriteLog(string message, string category, string status, System.Diagnostics.TraceEventType eventType, string name, string filename, int priority)
{
//DatabaseFactory.SetDatabaseProviderFactory(new DatabaseProviderFactory());
//DatabaseProviderFactory factory = new DatabaseProviderFactory();
//Database db = factory.Create("Logging");
//DatabaseFactory.SetDatabaseProviderFactory(factory, true);
DatabaseProviderFactory factory = new DatabaseProviderFactory(new SystemConfigurationSource(false).GetSection);
DatabaseFactory.SetDatabaseProviderFactory(factory, false);
LogWriterFactory logWriterFactory = new LogWriterFactory();
Logger.SetLogWriter(logWriterFactory.Create());
LogEntry log = new LogEntry();
log.Categories.Add(category);
log.Message = status + " : " + message;
log.EventId = 1;
log.Priority = priority;
if (!string.IsNullOrEmpty(name.Trim()))
log.ManagedThreadName = name;
log.TimeStamp = System.DateTime.Now;
log.Severity = eventType;
if (!string.IsNullOrEmpty(filename.Trim()))
log.Title = category + " : " + filename + " : " + message;
else
log.Title = category + " : " + message;
Logger.Write(log);
Logger.Reset();
}
public void TestInitialize()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
baseFixture = new DataAccessTestsFixture(db);
}
public List<ProjectModel> GetProject()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Database db = factory.Create("JIRA");
List<ProjectModel> modelList = new List<ProjectModel>();
using (DbCommand cmd = db.GetStoredProcCommand("[dbo].[GetProject]"))
{
cmd.CommandTimeout = dbTimeout;
db.AddOutParameter(cmd, "@Result", DbType.Int32, Int32.MaxValue);
DataSet ds = db.ExecuteDataSet(cmd);
// DB returns 1 if there is no error.
int result = (int)db.GetParameterValue(cmd, "@Result");
if (result == 1)
{
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
ProjectModel model = new ProjectModel();
model.Id = (int)dt.Rows[i]["Id"];
model.Subject = dt.Rows[i]["Subject"].ToString();
model.Status = (int)dt.Rows[i]["Status"];
model.ReleasedVersion = dt.Rows[i]["ReleasedVersion"].ToString();
model.Description = dt.Rows[i]["Description"].ToString();
model.SourceRespository = dt.Rows[i]["SourceRespository"].ToString();
model.UpdatedTimeStamp = (DateTime)dt.Rows[i]["UpdatedTimeStamp"];
modelList.Add(model);
}
}
}
return modelList;
}
private Logger()
{
TraceManager traceMgr;
DatabaseProviderFactory factory = new DatabaseProviderFactory(new SystemConfigurationSource(false).GetSection);
DatabaseFactory.SetDatabaseProviderFactory(factory, false);
LoggingConfiguration loggingConfiguration = BuildProgrammaticConfig();
defaultWriter = new LogWriter(loggingConfiguration);
// Create a TraceManager object for use in activity tracing example.
traceMgr = new TraceManager(defaultWriter);
try
{
if (!Directory.Exists(@"C:\Temp"))
{
Directory.CreateDirectory(@"C:\Temp");
}
}
catch
{
//Console.WriteLine(@"WARNING: Folder C:\Temp cannot be created for disk log files");
//Console.WriteLine();
}
}
public void SetUp()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
CreateStoredProcedure();
}
private void btImportar_Click(object sender, EventArgs e)
{
//importar datos seleccionados
//string SamplesSelected = (gridControl1.DataSource as DataTable).AsEnumerable().
var lst = (from t in (gridControl1.DataSource as DataTable).AsEnumerable()
where t.Field<bool>("Sel") == true
select new
{
Id = t.Field<int>("SamplesId").ToString()
});
string SamplesSelected = string.Join("|", lst.Select(x=> x.Id));
// importar desde base de datos del icp (sql server)
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Database namedDB = factory.Create("las2010");
StringBuilder sql = new StringBuilder("spFindIcpAnalysis @DateIni='{0}', @DateEnd='{1}', @MethodName='{2}', @SamplesSelected='{3}'");
string dateIni = deDateIni.DateTime.ToString("yyyyMMdd");
string dateEnd = deDateEnd.DateTime.ToString("yyyyMMdd");
string method = cbMethods.Text;
DataTable dtImport = namedDB.ExecuteDataSet(CommandType.Text, string.Format(sql.ToString(), dateIni, dateEnd, method, SamplesSelected)).Tables[0];
// guardar en la base de datos del lims postgresql
}
public void SetTaskComplete(TaskStatus status)
{
int statusId = (int)status;
DatabaseProviderFactory factory = new DatabaseProviderFactory();
var db = factory.CreateDefault();
db.ExecuteNonQuery(CommandType.Text, "update app.taskqueue set statusid = " + statusId + ", completedate = '" + DateTime.Now.ToString() + "' where taskQueueId = " + this.TaskQueueId);
}
public void SetUp()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
var factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
CompleteSetup(db);
}
private static Database CreateDatabase(MethodType type)
{
switch (type)
{
case MethodType.One:
{
// Should only exist one DatabaseProviderFactory object in your application,
// since all the Database objects are cached in the factory
var factory = new DatabaseProviderFactory();
return factory.CreateDefault();
}
case MethodType.Two:
{
var factory = new DatabaseProviderFactory();
DatabaseFactory.SetDatabaseProviderFactory(factory);
return DatabaseFactory.CreateDatabase();
}
case MethodType.Three:
{
var factory = new DatabaseProviderFactory();
DatabaseFactory.SetDatabaseProviderFactory(factory);
return DatabaseFactory.CreateDatabase("LocalDb");
}
case MethodType.Four:
{
return new SqlDatabase(ConfigurationManager.ConnectionStrings["LocalDb"].ConnectionString);
}
default:
throw new NotSupportedException();
}
}
static void LogWithFluentInterface(CustomLogEntry logEntry)
{
var builder = new ConfigurationSourceBuilder();
builder.ConfigureData()
.ForDatabaseNamed("Logging")
.ThatIs.ASqlDatabase()
.WithConnectionString(@"data source=.\SQLEXPRESS;Integrated Security=SSPI;Database=Logging")
.AsDefault();
builder.ConfigureLogging()
.WithOptions
.DoNotRevertImpersonation()
.LogToCategoryNamed("General")
.WithOptions.SetAsDefaultCategory()
.SendTo.CustomDatabase("Custom Database Trace Listener")
.WithAddCategoryStoredProcedure("AddCategory")
.UseDatabase("Logging")
.Filter(System.Diagnostics.SourceLevels.All)
.WithWriteLogStoredProcedure("WriteLog")
.FormatWithSharedFormatter("Text Formatter")
.SpecialSources.LoggingErrorsAndWarningsCategory
.SendTo.EventLog("Event Log Listener")
.FormatWith(new FormatterBuilder()
.TextFormatterNamed("Text Formatter")
.UsingTemplate(@"Timestamp: {timestamp}{newline}
Message: {message}{newline}
Category: {category}{newline}
Priority: {priority}{newline}
EventId: {eventid}{newline}
Severity: {severity}{newline}
Title:{title}{newline}
Machine: {localMachine}{newline}
App Domain: {localAppDomain}{newline}
ProcessId: {localProcessId}{newline}
Process Name: {localProcessName}{newline}
Thread Name: {threadName}{newline}
Win32 ThreadId:{win32ThreadId}{newline}
Extended Properties: {dictionary({key} - {value}{newline})}"))
.ToLog("Application")
.ToMachine(".")
.UsingEventLogSource("Enterprise Library Logging")
.Filter(SourceLevels.All)
;
var configSource = new DictionaryConfigurationSource();
builder.UpdateConfigurationWithReplace(configSource);
var dbProviderFactory = new DatabaseProviderFactory(configSource);
DatabaseFactory.SetDatabaseProviderFactory(dbProviderFactory, false);
var logWriterFactory = new LogWriterFactory(configSource);
var logWriter = logWriterFactory.Create();
logWriter.Write(logEntry);
// Re-initialize static Logger
Logger.SetLogWriter(logWriter, false);
Logger.Write("Test2", "General");
}
public ExactusData()
{
//Crea proveedor para la conexion
factory = new DatabaseProviderFactory();
//Crea el objeto conexion con Enterprise Library
db = factory.Create("ExactusConnection");
}
int GetNumberOfLogMessage(string databaseName)
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Data.Database db = ((databaseName == null) || (databaseName.Length == 0)) ? factory.CreateDefault() : factory.Create(databaseName);
DbCommand command = db.GetSqlStringCommand("SELECT COUNT(*) FROM Log");
int numMessages = Convert.ToInt32(db.ExecuteScalar(command));
return numMessages;
}
string GetLastLogMessage(string databaseName)
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Data.Database db = ((databaseName == null) || (databaseName.Length == 0)) ? factory.CreateDefault() : factory.Create(databaseName);
DbCommand command = db.GetSqlStringCommand("SELECT TOP 1 FormattedMessage FROM Log ORDER BY TimeStamp DESC");
string messageContents = Convert.ToString(db.ExecuteScalar(command));
return messageContents;
}
void ClearLogs()
{
//clear the log entries from the database
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Data.Database db = factory.CreateDefault();
DbCommand command = db.GetStoredProcCommand("ClearLogs");
db.ExecuteNonQuery(command);
}
public void SetUp()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
DbCommand command = db.GetSqlStringCommand("Select count(*) from region");
baseFixture = new ExecuteScalarFixture(db, command);
}
/// <summary>
/// 根据链接构建实例
/// </summary>
private DbInfo()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
db = factory.Create("DBConnStr");
ExecuteResult = new DbResult();
Procdbcomm = db.DbProviderFactory.CreateCommand();
listDbParameter = new List<DbParameter>();
}
public DataTable LISTA_VENDA()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Database BANCO = factory.Create("TAX");
System.Data.Common.DbCommand cmd = BANCO.GetStoredProcCommand("listataX");
DataTable LISTANPROC = BANCO.ExecuteDataSet(cmd).Tables[0];
return LISTANPROC;
}
public ExactusData(string User, string Pass, String Schema)
{
this.user = User;
this.password = Pass;
this.schema = Schema;
//Crea proveedor para la conexion
factory = new DatabaseProviderFactory();
//Crea el objeto conexion con Enterprise Library
db = new GenericDatabase(getConnectionString(User,Pass),DbProviderFactories.GetFactory("System.Data.SqlClient"));
}
public void SetUp()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
DbCommand insertionCommand = db.GetSqlStringCommand(insertString);
DbCommand countCommand = db.GetSqlStringCommand(countQuery);
baseFixture = new ExecuteNonQueryFixture(db, insertString, countQuery, insertionCommand, countCommand);
}
public BaseEngine()
{
// Configure the DatabaseFactory to read its configuration from the .config file
Factory = new DatabaseProviderFactory();
// Create the default Database object from the factory.
// The actual concrete type is determined by the configuration settings.
DefaultDb = Factory.CreateDefault();
//// Create a Database object from the factory using the connection string name.
//Database namedDB = Factory.Create("ExampleDatabase");
}
public void GRAVA_VENDA(string comprador, string descricao, Decimal preco, int qtd,string endereco,string fornecedor)
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Database BANCO = factory.Create("TAX");
System.Data.Common.DbCommand cmd = BANCO.GetStoredProcCommand("gravatax");
BANCO.AddInParameter(cmd, "@comprador", DbType.String, comprador);
BANCO.AddInParameter(cmd, "@descricao", DbType.String, descricao);
BANCO.AddInParameter(cmd, "@preco", DbType.Decimal, preco);
BANCO.AddInParameter(cmd, "@quantidade", DbType.Int16, qtd);
BANCO.AddInParameter(cmd, "@endereco", DbType.String, endereco);
BANCO.AddInParameter(cmd, "@fornecedor", DbType.String, fornecedor);
BANCO.ExecuteNonQuery(cmd);
}
public void Initialize()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
try
{
DeleteStoredProcedures();
}
catch { }
CreateStoredProcedures();
base.SetUp();
}
private void btShowSamples_Click(object sender, EventArgs e)
{
// Configure the DatabaseFactory to read its configuration from the .config file
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Database namedDB = factory.Create("las2010");
StringBuilder sql = new StringBuilder("spFindIcpSamples @DateIni='{0}', @DateEnd='{1}', @MethodName='{2}'");
string dateIni = deDateIni.DateTime.ToString("yyyyMMdd");
string dateEnd = deDateEnd.DateTime.ToString("yyyyMMdd");
string method = cbMethods.Text;
gridControl1.DataSource = namedDB.ExecuteDataSet(CommandType.Text, string.Format(sql.ToString(), dateIni, dateEnd, method)).Tables[0];
}
public void TestInitialize()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
storedProcedure = db.GetStoredProcCommand("NWND_CustOrdersOrders");
connection = db.CreateConnection();
connection.Open();
storedProcedure.Connection = connection;
cache = new ParameterCache();
baseFixture = new ParameterDiscoveryFixture(storedProcedure);
}
public static Database CreateDatabase(string name)
{
try
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(ConfigurationSourceFactory.Create());
return(factory.Create(name));
}
catch (ConfigurationErrorsException configurationException)
{
TryLogConfigurationError(configurationException, name);
throw;
}
}
static void Main(string[] args)
{
//从Data.config配置文件获取设置
DatabaseProviderFactory dbFactory =
new DatabaseProviderFactory(GetFileConfigurationSource("Data Configuration Source"));
Database db = dbFactory.Create("Connection String");
Console.WriteLine(db.ConnectionString);
//从Log.config的配置文件获取设置
LogWriter lw = new LogWriterFactory(GetFileConfigurationSource("Log Configuration Source")).Create();
lw.Write("123");
}
public void SetUp()
{
DatabaseProviderFactory dbFactory = new DatabaseProviderFactory(ConfigurationSourceFactory.Create());
db = dbFactory.CreateDefault();
unencryptedBackingStore = new DataBackingStore(db, "encryptionTests", null);
unencryptedBackingStore.Flush();
ProtectedKey key = KeyManager.GenerateSymmetricKey(typeof(RijndaelManaged), DataProtectionScope.CurrentUser);
using (FileStream stream = new FileStream("ProtectedKey.file", FileMode.Create))
{
KeyManager.Write(stream, key);
}
}
/// <summary>
/// Method for invoking a default Database object. Reads default settings
/// from the ConnectionSettings.config file.
/// </summary>
/// <example>
/// <code>
/// Database dbSvc = DatabaseFactory.CreateDatabase();
/// </code>
/// </example>
/// <returns>Database</returns>
/// <exception cref="System.Configuration.ConfigurationException">
/// <para>An error occured while reading the configuration.</para>
/// </exception>
public static Database CreateDatabase()
{
try
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(ConfigurationSourceFactory.Create());
return factory.CreateDefault();
}
catch (ConfigurationErrorsException configurationException)
{
TryLogConfigurationError(configurationException, "default");
throw;
}
}
/// <summary>
/// Method for invoking a specified Database service object. Reads service settings
/// from the ConnectionSettings.config file.
/// </summary>
/// <example>
/// <code>
/// Database dbSvc = DatabaseFactory.CreateDatabase("SQL_Customers");
/// </code>
/// </example>
/// <param name="name">configuration key for database service</param>
/// <returns>Database</returns>
/// <exception cref="System.Configuration.ConfigurationException">
/// <para><paramref name="name"/> is not defined in configuration.</para>
/// <para>- or -</para>
/// <para>An error exists in the configuration.</para>
/// <para>- or -</para>
/// <para>An error occured while reading the configuration.</para>
/// </exception>
/// <exception cref="System.Reflection.TargetInvocationException">
/// <para>The constructor being called throws an exception.</para>
/// </exception>
public static Database CreateDatabase(string name)
{
try
{
DatabaseProviderFactory factory = null;
if (System.IO.File.Exists("./adcemr.exe.config"))
{
FileConfigurationSource fileSource = new FileConfigurationSource("./adcemr.exe.config");
factory = new DatabaseProviderFactory(fileSource);
}
else
{
factory = new DatabaseProviderFactory(ConfigurationSourceFactory.Create());
}
return(factory.Create(name));
}
catch (ConfigurationErrorsException configurationException)
{
TryLogConfigurationError(configurationException, name);
throw;
}
}
/// <summary>
/// Sets the provider factory for the static <see cref="DatabaseFactory"/>.
/// </summary>
/// <param name="factory">The provider factory.</param>
/// <param name="throwIfSet"><see langword="true"/> to thrown an exception if the factory is already set; otherwise, <see langword="false"/>. Defaults to <see langword="true"/>.</param>
/// <exception cref="InvalidOperationException">The factory is already set and <paramref name="throwIfSet"/> is <see langword="true"/>.</exception>
public static void SetDatabaseProviderFactory(DatabaseProviderFactory factory, bool throwIfSet = true)
{
Guard.ArgumentNotNull(factory, "factory");
SetDatabases(factory.CreateDefault, factory.Create, throwIfSet);
}
public static void AssertOracleClientIsInstalled()
{
if (!oracleClientIsInstalled.HasValue)
{
try
{
var factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
var db = factory.Create("OracleTest");
var conn = db.CreateConnection();
conn.Open();
conn.Close();
}
catch (Exception ex)
{
if (ex.Message != null && ex.Message.Contains("Data Source=XE;User id=system;Password=admin"))
{
oracleClientIsInstalled = false;
oracleClientNotInstalledErrorMessage = ex.Message;
}
else
{
throw;
}
}
}
if (oracleClientIsInstalled.HasValue && oracleClientIsInstalled.Value == false)
{
Assert.Inconclusive(oracleClientNotInstalledErrorMessage);
}
}
public List<UserModel> GetProjectMembers(int projectId)
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Database db = factory.Create("JIRA");
int result = 0;
List<UserModel> modelList = new List<UserModel>();
using (DbCommand cmd = db.GetStoredProcCommand("[dbo].[GetProjectMembersWithId]"))
{
cmd.CommandTimeout = dbTimeout;
db.AddInParameter(cmd, "@ProjectId", DbType.Int32, projectId);
db.AddOutParameter(cmd, "@Result", DbType.Int32, Int32.MaxValue);
DataSet ds = db.ExecuteDataSet(cmd);
// DB returns 1 if there is no error.
result = (int)db.GetParameterValue(cmd, "@Result");
if (result == 1)
{
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
UserModel model = new UserModel();
model.Name = dt.Rows[i]["Name"].ToString();
model.Email = dt.Rows[i]["Email"].ToString();
model.Dept = dt.Rows[i]["Dept"].ToString();
model.Role = dt.Rows[i]["Role"].ToString();
modelList.Add(model);
}
}
}
return modelList;
}
public Database GetDatabase()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Database db = factory.Create("StudentConnectionString");
return db;
}
