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; }