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 SetUp()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
CreateStoredProcedure();
}
public void SetUp()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
var factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
CompleteSetup(db);
}
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;
}
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;
}
public ExactusData()
{
//Crea proveedor para la conexion
factory = new DatabaseProviderFactory();
//Crea el objeto conexion con Enterprise Library
db = factory.Create("ExactusConnection");
}
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;
}
static void Main(string[] args)
{
#region Create the required objects
// Configure the DatabaseFactory to read its configuration from the config file
DatabaseProviderFactory factory = new DatabaseProviderFactory();
// Create a Database object from the factory using the default database defined in the configuration file:
// <dataConfiguration defaultDatabase="ExampleDatabase" />
defaultDB = factory.CreateDefault();
// Or create a Database object from the factory using the connection string name.
// defaultDB = factory.Create("ExampleDatabase");
// Create a SqlDatabase object from the factory using the default database.
sqlServerDB = factory.Create("ExampleDatabase") as SqlDatabase;
// Crate a Database object that has "Asynchronous Processing=true" in the connection string.
asyncDB = factory.Create("AsyncExampleDatabase");
// An alternative approach to building the database objects using the
// static facade is:
//DatabaseFactory.SetDatabaseProviderFactory(factory, false);
//defaultDB = DatabaseFactory.CreateDatabase("ExampleDatabase");
//sqlServerDB = DatabaseFactory.CreateDatabase() as SqlDatabase;
//asyncDB = DatabaseFactory.CreateDatabase("AsyncExampleDatabase");
#endregion
new MenuDrivenApplication("Data Access Block Developer's Guide Examples",
ReadSQLStatement,
ReadStoredProcWithParams,
ReadSQLOrSprocWithNamedParams,
ReadDataAsObjects,
ReadDataAsXML,
ReadScalarValue,
ReadDataAsynchronously,
ReadDataAsynchronouslyTask,
ReadObjectsAsynchronously,
UpdateWithCommand,
FillAndUpdateDataset,
LoadAndUpdateTypedDataset,
UseConnectionTransaction,
UseTransactionScope).Run();
}
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 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 static Database CreateDatabase(string name)
{
try
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(ConfigurationSourceFactory.Create());
return(factory.Create(name));
}
catch (ConfigurationErrorsException configurationException)
{
TryLogConfigurationError(configurationException, name);
throw;
}
}
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];
}
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 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 void Initialize()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
try
{
DeleteStoredProcedures();
}
catch { }
CreateStoredProcedures();
base.SetUp();
}
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);
}
/// <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="instanceName"/> 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 = new DatabaseProviderFactory(ConfigurationSourceFactory.Create());
return factory.Create(name);
}
catch (ConfigurationErrorsException configurationException)
{
TryLogConfigurationError(configurationException, name);
throw;
}
}
/// <summary>
/// Method to process and get the PhoneBook data from SQL for all users
/// </summary>
/// <returns>PhoneBook class</returns>
public Collection<PhonebookClass> ReadPhonebookDataFromSql()
{
using (CommonHelper.LoggingScope)
{
// Configure the DatabaseFactory to read its configuration from the .config file
DatabaseProviderFactory factory = new DatabaseProviderFactory();
// Create a Database object from the factory using the connection string name.
Database toyotaDB = factory.Create(Constants.ToyotaIntegration);
// Retrieve the records from table
Collection<PhonebookClass> phonebookCollection = RetrievePhoneBookRecords(toyotaDB, PhoneBookOperations.PhoneBookDataRead.Name, string.Empty, DbType.String, string.Empty);
return phonebookCollection;
}
}
public void SetUp()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
try
{
DeleteStoredProcedures();
}
catch {}
CreateStoredProcedures();
baseFixture = new TransactionScopeFixture(db);
baseFixture.Cleanup();
}
public Database GetFactoryProvider()
{
try
{
DatabaseProviderFactory factoryProvider = new DatabaseProviderFactory();
//factoryProvider.CreateDefault();
return factoryProvider.Create("DefaultConnection");
}
catch (Exception ex)
{
throw ex;
}
}
public void DatabaseCreatedByProviderFactoryIsASqlCeDatabase()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSettings settings = new DatabaseSettings();
ConnectionStringsSection connSection = GetConnectionStringsSection();
DbProviderMapping providerMapping = GetProviderMapping();
settings.ProviderMappings.Add(providerMapping);
source.Add("dataConfiguration", settings);
source.Add("connectionStrings", connSection);
DatabaseProviderFactory factory = new DatabaseProviderFactory(source);
Database db = factory.Create(instanceName);
Assert.IsNotNull(db);
Assert.AreSame(typeof(SqlCeDatabase), db.GetType());
}
public int DeleteProject(int id)
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Database db = factory.Create("JIRA");
int result = 0;
using (DbCommand cmd = db.GetStoredProcCommand("[dbo].[DeleteProjectWithId]"))
{
cmd.CommandTimeout = dbTimeout;
db.AddInParameter(cmd, "@Id", DbType.Int32, id);
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");
}
return result;
}
private void LoadProducts()
{
//This code is used to call stored procedure without parameter and bind gridview
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Database objDataBase = factory.Create("Sales");
DataSet ds = new DataSet();
try
{
ds = objDataBase.ExecuteDataSet(CommandType.StoredProcedure,
"roducts_GetProducts");
// ds = objDataBase.ExecuteDataSet("SELECT * FROM tblProducts;");
// ds = objDataBase.ExecuteDataSet(CommandType.Text, sql);
grvProduct.DataSource = ds;
grvProduct.DataBind();
}
catch (Exception ex)
{
Response.Write("Error: " + ex.Message);
}
}
public void CanInsertNullStringParameter()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
Database db = factory.Create("OracleTest");
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
using (DbTransaction transaction = connection.BeginTransaction())
{
string sqlString = "insert into Customers (CustomerID, CompanyName, ContactName) Values (:id, :name, :contact)";
DbCommand insert = db.GetSqlStringCommand(sqlString);
db.AddInParameter(insert, ":id", DbType.Int32, 1);
db.AddInParameter(insert, ":name", DbType.String, "fee");
db.AddInParameter(insert, ":contact", DbType.String, null);
db.ExecuteNonQuery(insert, transaction);
transaction.Rollback();
}
}
}
public DASales()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
odb = factory.Create("PS");
ocn = odb.CreateConnection();
}
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 Database GetDatabase()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Database db = factory.Create("StudentConnectionString");
return db;
}
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;
}
