public void SetUp()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource());
db = factory.CreateDefault();
CompleteSetup(db);
}
public void SetUp()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(new TestConfigurationContext());
this.db = factory.CreateDatabase("OracleTest");
this.sqlCommand = "Select count(*) from region";
this.command = this.db.GetSqlStringCommandWrapper(this.sqlCommand);
}
public void SetUp()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(new Db2TestConfigurationContext());
this.db = factory.CreateDatabase("DB2Test");
this.dataSet = new DataSet();
this.command = this.db.GetSqlStringCommandWrapper(this.sqlQuery);
}
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("System.Data.OracleClient")
&& ex.Message.Contains("8.1.7"))
{
oracleClientIsInstalled = false;
oracleClientNotInstalledErrorMessage = ex.Message;
}
else
{
throw;
}
}
}
if (oracleClientIsInstalled.HasValue && oracleClientIsInstalled.Value == false)
{
Assert.Inconclusive(oracleClientNotInstalledErrorMessage);
}
}
public void SetUp()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
CreateTableWithGuidAndBinary();
}
public void SetUp()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
var factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
CompleteSetup(db);
}
public void SkipsConnectionStringsWithoutProviderNamesOrWithProviderNamesWhichDoNotMapToAProviderFactory()
{
DictionaryConfigurationSource configurationSource = new DictionaryConfigurationSource();
ConnectionStringsSection section = new ConnectionStringsSection();
section.ConnectionStrings.Add(new ConnectionStringSettings("cs1", "cs1", "System.Data.SqlClient"));
section.ConnectionStrings.Add(new ConnectionStringSettings("cs2", "cs2"));
section.ConnectionStrings.Add(new ConnectionStringSettings("cs3", "cs3", "a bogus provider name"));
section.ConnectionStrings.Add(new ConnectionStringSettings("cs4", "cs4", "System.Data.SqlClient"));
configurationSource.Add("connectionStrings", section);
var factory = new DatabaseProviderFactory(configurationSource.GetSection);
Assert.AreEqual("cs1", factory.Create("cs1").ConnectionString);
Assert.AreEqual("cs4", factory.Create("cs4").ConnectionString);
try
{
factory.Create("cs2");
Assert.Fail("should have thrown");
}
catch (InvalidOperationException)
{
// expected, connection string is ignored
}
try
{
factory.Create("cs3");
Assert.Fail("should have thrown");
}
catch (InvalidOperationException)
{
// expected, connection string is ignored
}
}
public void UseParameterCachingWithPersistSecurityInfoFalse()
{
try
{
DeleteUser();
CreateUser();
DatabaseProviderFactory factory = new DatabaseProviderFactory(new TestConfigurationContext());
Database dbsec = factory.CreateDatabase("NorthwindPersistFalse");
connection = dbsec.GetConnection();
connection.Open();
DBCommandWrapper storedProc1 = dbsec.GetStoredProcCommandWrapper("CustOrdersOrders", "ALFKI");
storedProc1.Command.Connection = connection;
TestCache testCache = new TestCache();
testCache.FillParameters(storedProc1, '@');
DBCommandWrapper storedProc2 = dbsec.GetStoredProcCommandWrapper("CustOrdersOrders", "ALFKI");
storedProc2.Command.Connection = connection;
testCache.FillParameters(storedProc2, '@');
Assert.IsTrue(testCache.CacheUsed);
}
finally
{
DeleteUser();
}
}
public void Setup()
{
var factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource());
var db = factory.CreateDefault();
connection = db.CreateConnection();
connection.Open();
}
public void SetUp()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource());
db = factory.CreateDefault();
DbCommand command = db.GetSqlStringCommand("Select count(*) from region");
baseFixture = new ExecuteScalarFixture(db, command);
}
public void CallingTwiceReturnsDifferenceDatabaseInstances()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource());
Database firstDb = factory.Create("NewDatabase");
Database secondDb = factory.Create("NewDatabase");
Assert.AreNotSame(firstDb, secondDb);
}
public void CallingTwiceReturnsDifferenceDatabaseInstances()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(new TestConfigurationContext());
Database firstDb = factory.CreateDatabase("NewDatabase");
Database secondDb = factory.CreateDatabase("NewDatabase");
Assert.IsFalse(firstDb == secondDb);
}
public void SetUp()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(new Db2TestConfigurationContext());
this.db = factory.CreateDatabase("DB2Test");
this.queryString = "Select * from Region";
this.insertString = "Insert into Region values (99, 'Midwest')";
this.insertCommand = this.db.GetSqlStringCommandWrapper(this.insertString);
this.queryCommand = this.db.GetSqlStringCommandWrapper(this.queryString);
}
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);
}
public void CanCreateSqlDatabaseFromFactory()
{
var factory = new DatabaseProviderFactory(new SystemConfigurationSource(false).GetSection);
Database createdObject = factory.Create("Service_Dflt");
Assert.IsNotNull(createdObject);
Assert.AreEqual(@"server=(localdb)\v11.0;database=northwind;integrated security=true;",
createdObject.ConnectionStringWithoutCredentials);
}
public void SetUp()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource());
db = factory.CreateDefault();
DbCommand insertionCommand = db.GetSqlStringCommand(insertString);
DbCommand countCommand = db.GetSqlStringCommand(countQuery);
baseFixture = new ExecuteNonQueryFixture(db, insertString, countQuery, insertionCommand, countCommand);
}
public void TestInitialize()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource());
db = factory.CreateDefault();
DbCommand insertCommand = db.GetSqlStringCommand(insertString);
DbCommand queryCommand = db.GetSqlStringCommand(queryString);
baseFixture = new ExecuteReaderFixture(db, insertString, insertCommand, queryString, queryCommand);
}
public void CanCreateGenericDatabaseFromSysConfiguration()
{
Database database =
new DatabaseProviderFactory(new SystemConfigurationSource(false)).Create("OdbcDatabase");
Assert.IsNotNull(database);
Assert.AreEqual(database.GetType(), typeof(GenericDatabase));
Assert.AreEqual(database.DbProviderFactory.GetType(), typeof(OdbcFactory));
Assert.AreEqual(connectionString, database.ConnectionStringWithoutCredentials);
}
public void SetUp()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(new Db2TestConfigurationContext());
this.db = factory.CreateDatabase("DB2Test");
this.insertString = "insert into Region values (77, 'Elbonia')";
this.insertionCommand = this.db.GetSqlStringCommandWrapper(this.insertString);
this.countQuery = "select count(*) from Region";
this.countCommand = this.db.GetSqlStringCommandWrapper(this.countQuery);
}
public void SetUp()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(new TestConfigurationContext());
this.db = factory.CreateDefaultDatabase();
storedProcedure = db.GetStoredProcCommandWrapper("CustOrdersOrders", "ALFKI");
connection = db.GetConnection();
connection.Open();
storedProcedure.Command.Connection = connection;
cache = new ParameterCache();
}
public void SetUp()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
DbCommand insertCommand = db.GetSqlStringCommand(insertString);
DbCommand queryCommand = db.GetSqlStringCommand(queryString);
baseFixture = new ExecuteReaderFixture(db, insertString, insertCommand, queryString, queryCommand);
}
public void CreateNamedDatabaseInstanceWithDictSource()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSettings settings = new DatabaseSettings();
ConnectionStringsSection connSection = GetConnectionStringsSection();
source.Add("dataConfiguration", settings);
source.Add("connectionStrings", connSection);
DatabaseProviderFactory factory = new DatabaseProviderFactory(source);
Database dbIns = factory.Create(instanceName);
Assert.IsNotNull(dbIns);
}
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 void SetUp()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource());
db = factory.CreateDefault();
storedProcedure = db.GetStoredProcCommand("CustOrdersOrders");
connection = db.CreateConnection();
connection.Open();
storedProcedure.Connection = connection;
cache = new ParameterCache();
baseFixture = new ParameterDiscoveryFixture(storedProcedure);
}
public void Initialize()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
try
{
DeleteStoredProcedures();
}
catch { }
CreateStoredProcedures();
base.SetUp();
}
public List <Barra> GetGastosDB(string strAnoConsultaGastos, string strMesConsultaGastos)
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Database db = factory.Create("WalletConnectionString");
DbCommand dbc = db.GetStoredProcCommand("dbo.paGetGastos");
db.AddInParameter(dbc, "@Ano", DbType.String, strAnoConsultaGastos);
db.AddInParameter(dbc, "@Mes", DbType.String, strMesConsultaGastos);
DataSet dsGastos = db.ExecuteDataSet(dbc);
List <Barra> listaBarras = ConvertToList(dsGastos);
return(listaBarras);
}
public void Initialize()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
try
{
DeleteStoredProcedures();
}
catch { }
CreateStoredProcedures();
base.SetUp();
}
public void SetUp()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource());
db = factory.CreateDefault();
storedProcedure = db.GetStoredProcCommand("CustOrdersOrders");
connection = db.CreateConnection();
connection.Open();
storedProcedure.Connection = connection;
cache = new ParameterCache();
baseFixture = new ParameterDiscoveryFixture(storedProcedure);
}
public void Initialize()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(TestConfigurationSource.CreateConfigurationSource());
db = factory.CreateDefault();
try
{
DeleteStoredProcedures();
}
catch {}
CreateStoredProcedures();
base.SetUp();
}
public IEnumerable <PaymentMode> getPaymentModes()
{
Database db;
DatabaseProviderFactory factory = new DatabaseProviderFactory();
db = factory.Create("OPSDBConn");
string sql = "SELECT PaymentModeId ,Mode FROM [dbo].[PaymentMode] where IsActive=1 ";
var paymentMode = db.ExecuteSqlStringAccessor <PaymentMode>(sql);
return(paymentMode);
}
//string constr = Properties.Settings.Default.WalletConnectionString;
public void GuardarMovimientoDB(Movimiento movimiento)
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Database db = factory.Create("WalletConnectionString");
DbCommand dbc = db.GetStoredProcCommand("dbo.paCrearMovimiento");
db.AddInParameter(dbc, "@TipoMovimientoId", DbType.Int32, movimiento.TipoMovimientoId);
db.AddInParameter(dbc, "@CuentaId", DbType.Int32, movimiento.CuentaId);
db.AddInParameter(dbc, "@CategoriaId", DbType.Int32, movimiento.CategoriaId);
db.AddInParameter(dbc, "@Valor", DbType.Decimal, movimiento.Valor);
db.AddInParameter(dbc, "@Descripcion", DbType.String, movimiento.Descripcion);
db.ExecuteNonQuery(dbc);
}
static void Init()
{
/// <summary>
/// Configure the DatabaseFactory to read its configuration from the .config file
/// </summary>
DatabaseProviderFactory factory = new DatabaseProviderFactory();
/// <summary>
/// Create the default Database object from the factory.
///The actual concrete type is determined by the configuration settings.
/// </summary>
cisDB = factory.CreateDefault();
}
public Database GetFactoryProvider()
{
try
{
DatabaseProviderFactory factoryProvider = new DatabaseProviderFactory();
//factoryProvider.CreateDefault();
return(factoryProvider.Create("DefaultConnection"));
}
catch (Exception ex)
{
throw ex;
}
}
public void CreateNamedDatabaseInstanceWithDictSource()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSettings settings = new DatabaseSettings();
ConnectionStringsSection connSection = GetConnectionStringsSection();
source.Add("dataConfiguration", settings);
source.Add("connectionStrings", connSection);
DatabaseProviderFactory factory = new DatabaseProviderFactory(source);
Database dbIns = factory.Create(instanceName);
Assert.IsNotNull(dbIns);
}
public Customer SelectCustomer(int id)
{
DatabaseProviderFactory dbPFactory = new DatabaseProviderFactory();
Database defaultDb = dbPFactory.CreateDefault();
Database database = dbPFactory.Create(DBName);
DbCommand dbcommand = database.GetStoredProcCommand("spSelectCustomer");
database.AddInParameter(dbcommand, "CustomerId", System.Data.DbType.Int32, id);
DataSet dataset = database.ExecuteDataSet(dbcommand);
return(TranslateCustomer.PaserCustomer(dataset));
}
public void InsertCustomer(string firstname, string lastname, string emailid, string phonenumber)
{
DatabaseProviderFactory dbfactory = new DatabaseProviderFactory();
Database defaultdatabase = dbfactory.CreateDefault();
Database database = dbfactory.Create(DBName);
DbCommand command = database.GetStoredProcCommand("spInsertCustomer");
database.AddInParameter(command, "FirstName", System.Data.DbType.String, firstname);
database.AddInParameter(command, "LastName", System.Data.DbType.String, lastname);
database.AddInParameter(command, "EmailId", System.Data.DbType.String, emailid);
database.AddInParameter(command, "PhoneNumber", System.Data.DbType.String, phonenumber);
database.ExecuteScalar(command);
}
public IEnumerable <Treatment> getTreatmentList()
{
Database db;
DatabaseProviderFactory factory = new DatabaseProviderFactory();
db = factory.Create("OPSDBConn");
//IDataReader reader = db.ExecuteReader(CommandType.Text, "select * from ProductMaser");
var TreatmentInfo = db.ExecuteSqlStringAccessor <Treatment>("SELECT 0 as IsSelected, TreatmentId, TreatmentName from Treatment where IsActive=1");
return(TreatmentInfo);
}
public void InsertCustomer(string FirstName, string LastName, string EmailId, string PhoneNumber)
{
DatabaseProviderFactory dbfactory = new DatabaseProviderFactory();
Database defaultDB = dbfactory.CreateDefault();
Database database = dbfactory.Create("HotelReservationSystem");
DbCommand dbcommand = database.GetStoredProcCommand("spInsertCustomer");
database.AddInParameter(dbcommand, "@FirstName", System.Data.DbType.String, FirstName);
database.AddInParameter(dbcommand, "@LastName", System.Data.DbType.String, LastName);
database.AddInParameter(dbcommand, "@EmailId", System.Data.DbType.String, EmailId);
database.AddInParameter(dbcommand, "@PhoneNumber", System.Data.DbType.String, PhoneNumber);
database.ExecuteScalar(dbcommand);
}
public void OneTimeSetUp()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(new TestConfigurationContext());
db = factory.CreateDefaultDatabase();
try
{
DeleteStoredProcedures();
}
catch
{
}
CreateStoredProcedures();
}
public static ListEx <TagsStatisticsItem> GetList(TagsStatisticsFilter f)
{
Database db = new DatabaseProviderFactory().CreateDefault();
DbCommand command = db.GetStoredProcCommand("p_TagsStatistics_GetList",
f.Paging.CurrentPage,
f.Paging.RecordsPerPage);
command.CommandTimeout = DataBaseSettings.SqlCommandTimeout;
using (IDataReader r = db.ExecuteReader(command))
{
return(new ListEx <TagsStatisticsItem>(r, x => new TagsStatisticsItem(x)));
}
}
public Customer SelectCustomer(string firstname)
{
DatabaseProviderFactory dbfactory = new DatabaseProviderFactory();
Database defaultdatabase = dbfactory.CreateDefault();
Database database = dbfactory.Create(DBName);
DbCommand command = database.GetStoredProcCommand("spSelectCustomer");
database.AddInParameter(command, "FirstName", System.Data.DbType.String, firstname);
Customer customer = CustomerTranslate.ParseCustomer(database.ExecuteDataSet(command));
return(customer);
}
public int UpdateOnlyRole(RoleInfo role)
{
DatabaseProviderFactory dbFactory = new DatabaseProviderFactory();
Database database = dbFactory.CreateDefault();
string sql = "update T_S_ROLE set {0} where roleid={1}";
string column = @" name='" + role.RoleName + "',description='" + role.Description + "'";
sql = string.Format(sql, column, role.RoleId);
DbCommand dbCommand = database.GetSqlStringCommand(sql);
int result = database.ExecuteNonQuery(dbCommand);
return(result);
}
public void SetUp()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
DbCommand insertCommand = db.GetSqlStringCommand(insertString);
DbCommand queryCommand = db.GetSqlStringCommand(queryString);
baseFixture = new ExecuteReaderFixture(db, insertString, insertCommand, queryString, queryCommand);
}
/// <summary>
/// Inserta un registro en la Tabla User median el SP USER_INS
/// Requiere que el Objeto tenga Nombre, Apellido, Email y Password cargados
/// </summary>
void Insertdb()
{
string szQuery = "USER_INS";
Database db = new DatabaseProviderFactory().Create("EX1DB");
DbCommand dbCommand = db.GetStoredProcCommand(szQuery);
dbCommand.CommandTimeout = 100;
db.AddInParameter(dbCommand, "NOMBRE", DbType.String, this.nombre);
db.AddInParameter(dbCommand, "APELLIDO", DbType.String, this.apellido);
db.AddInParameter(dbCommand, "EMAIL", DbType.String, this.email);
db.AddInParameter(dbCommand, "PASSWORD", DbType.String, this.password);
db.ExecuteNonQuery(dbCommand);
}
public IEnumerable <Supplier> getSuppliers()
{
Database db;
DatabaseProviderFactory factory = new DatabaseProviderFactory();
db = factory.Create("OPSDBConn");
//IDataReader reader = db.ExecuteReader(CommandType.Text, "select * from ProductMaser");
var supplierInfo = db.ExecuteSqlStringAccessor <Supplier>("SELECT SupplierId, Name as SupplierName, IsActive FROM Supplier where IsActive=1");
return(supplierInfo);
}
public void ResultsAreReturnedWhenExecutingStoredProcrocAccessorWithCustomRowMapper()
{
Database db = new DatabaseProviderFactory(base.ConfigurationSource).CreateDefault();
var accessor = new SprocAccessor <TopTenProduct>(db, "Ten Most Expensive Products", new TopTenProductRowMapper());
var results = accessor.Execute();
var topTenProduct = results.First();
Assert.AreEqual("C�te de Blaye", topTenProduct.TenMostExpensiveProducts);
Assert.AreEqual(263.50M, topTenProduct.UnitPrice);
}
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 GetTiemposDeAlimentacion(int TiemposDeAlimentacionID)
{
DatabaseProviderFactory databaseProviderFactory = new DatabaseProviderFactory();
Microsoft.Practices.EnterpriseLibrary.Data.Database database = databaseProviderFactory.Create("DefaultConnection");
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendLine("SELECT Nombre FROM TblTiemposDeAlimentacion WHERE TiemposDeAlimentacionID=@PTiemposDeAlimentacionID");
DbCommand command = database.GetSqlStringCommand(stringBuilder.ToString());
database.AddInParameter(command, "PTiemposDeAlimentacionID", System.Data.DbType.String, TiemposDeAlimentacionID);
Nombre = database.ExecuteScalar(command).ToString();
}
public void GetModuloHabitacional(string ModuloHabitacionalID)
{
DatabaseProviderFactory databaseProviderFactory = new DatabaseProviderFactory();
Microsoft.Practices.EnterpriseLibrary.Data.Database database = databaseProviderFactory.Create("DefaultConnection");
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendLine("SELECT Nombre FROM TblModulosHabitacionales WHERE ModuloHabitacional=@PModuloHabitacional");
DbCommand command = database.GetSqlStringCommand(stringBuilder.ToString());
database.AddInParameter(command, "PModuloHabitacional", System.Data.DbType.String, ModuloHabitacionalID);
Nombre = database.ExecuteScalar(command).ToString();
}
public void Initialize()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(new Db2TestConfigurationContext());
this.db = factory.CreateDatabase("DB2Test");
try
{
DeleteStoredProcedures();
}
catch
{
}
CreateStoredProcedures();
}
public List <BEcccmex.BEEventoEquipo> GetEventoEquipo(Int64?idCentro, Int64?idInstalacion)
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Database db = factory.CreateDefault();
List <BEEventoEquipo> listaEventoEquipo = new List <BEEventoEquipo>();
//IDPropietario= 0, significa que quiero todo el catalogo completo
DbCommand dbc = db.GetStoredProcCommand("dbo.proc_getevento_equipo");
if (idCentro > 0)
{
db.AddInParameter(dbc, "IDCENTRO", System.Data.DbType.Int64, idCentro);
}
if (idInstalacion > 0)
{
db.AddInParameter(dbc, "IDINSTALACION", System.Data.DbType.Int64, idInstalacion);
}
DataSet ds = db.ExecuteDataSet(dbc);
foreach (DataRow dr in ds.Tables[0].Rows)
{
BEEventoEquipo objEventoEquipo = new BEEventoEquipo();
//Almacenamos informacion del evento
objEventoEquipo.IdEvento = convertir.toNInt64(dr["IDEVENTO"]);
objEventoEquipo.IdEquipo = convertir.toNInt64(dr["IDEQUIPO"]);
objEventoEquipo.Evento = dr["EVENTO"].ToString();
objEventoEquipo.TipoAlarma = dr["TIPOEVENTO"].ToString();
objEventoEquipo.Prealarma = convertir.toNInt64(dr["PREALARMA"]);
objEventoEquipo.FechaEvento = Convert.ToDateTime(dr["FECHAEVENTO"]).ToString("dd/MM/yyyy");
objEventoEquipo.Vigencia = dr["VIGENCIA"].ToString();
objEventoEquipo.PostAlarma = convertir.toNInt64(dr["POSTALARMA"] ?? 0);
objEventoEquipo.Observacion = dr["OBSERVACION"].ToString();
//Almacenamos informacion del equipo
objEventoEquipo.IdEquipo = convertir.toNInt64(dr["IDEQUIPO"]);
objEventoEquipo.Equipo = dr["EQUIPO"].ToString();
//Almacenamos informacion de la instalacion
objEventoEquipo.IdInstalacion = convertir.toNInt64(dr["IDINST"]);
objEventoEquipo.Instalacion = dr["INSTALACION"].ToString();
//Almacenamos informacion del centro
objEventoEquipo.IdCentro = convertir.toNInt64(dr["IDCENTRO"]);
objEventoEquipo.Centro = dr["CENTRO"].ToString();
listaEventoEquipo.Add(objEventoEquipo);
}
return(listaEventoEquipo);
}
//
public Ticket TurnoSiguiente(int IdTipoServicio, int IdCaja)
{
SqlDatabase _Db = null;
Ticket _instance = null;
try
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
_Db = factory.CreateDefault() as SqlDatabase;
using (DbConnection connetion = _Db.CreateConnection())
{
if (connetion.State == ConnectionState.Closed)
{
connetion.Open();
}
using (DbCommand _DbCommand = _Db.GetStoredProcCommand("dbo.TurnoSiguiente"))
{
_DbCommand.Connection = connetion;
_DbCommand.Parameters.Add(new SqlParameter()
{
ParameterName = "@IdTipoServicio", SqlDbType = SqlDbType.Int, Value = IdTipoServicio
});
_DbCommand.Parameters.Add(new SqlParameter()
{
ParameterName = "@IdCaja", SqlDbType = SqlDbType.Int, Value = IdCaja
});
using (IDataReader reader = _DbCommand.ExecuteReader())
{
while (reader.Read())
{
_instance = new Ticket();
_instance.IdTicket = reader["IdTicket"] != DBNull.Value ? Convert.ToInt32(reader["IdTicket"]) : 0;
_instance.Secuencia = reader["Turno"] != DBNull.Value ? Convert.ToInt32(reader["Turno"]) : 0;
}
}
}
}
}
catch (Exception ex)
{
Com.Hit.TurnoMatic.Utils.Log.LogError(TAG, "TurnoSiguiente", ex);
}
return(_instance);
}
public List <SEC_Menu> GetMenu(string ownerID, string menuID, string action, out string errorNumber)
{
errorNumber = string.Empty;
List <SEC_Menu> userList = new List <SEC_Menu>();
DatabaseProviderFactory factory = new DatabaseProviderFactory();
SqlDatabase db = factory.CreateDefault() as SqlDatabase;
using (DbCommand dbCommandWrapper = db.GetStoredProcCommand("GetAllMenu"))
{
// Set parameters
db.AddInParameter(dbCommandWrapper, "@MenuId", SqlDbType.VarChar, menuID);
db.AddInParameter(dbCommandWrapper, "@OwnerID", SqlDbType.VarChar, ownerID);
// db.AddInParameter(dbCommandWrapper, "@Action", SqlDbType.VarChar, action);
db.AddOutParameter(dbCommandWrapper, spErrorParam, DbType.Int32, 10);
// Execute SP.
DataSet ds = db.ExecuteDataSet(dbCommandWrapper);
if (!db.GetParameterValue(dbCommandWrapper, "@p_Status").IsNullOrZero())
{
// Get the error number, if error occurred.
errorNumber = db.GetParameterValue(dbCommandWrapper, "@p_Status").PrefixErrorCode();
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt1 = ds.Tables[0];
userList = dt1.AsEnumerable().Select(reader => new SEC_Menu
{
MenuID = reader.GetString("MenuID"),
MenuTitle = reader.GetString("MenuTitle"),
MenuUrl = reader.GetString("MenuUrl"),
ParentMenuID = reader.GetString("ParentMenuID"),
MenuIcon = reader.GetString("MenuIcon"),
MenuOrder = reader.GetInt32("MenuOrder"),
TotalUserAllowed = reader.GetInt32("TotalUserAllowed"),
ConcurrentUser = reader.GetInt32("ConcurrentUser"),
OwnerID = reader.GetString("OwnerID"),
UserLevel = reader.GetInt32("UserLevel"),
SetOn = reader.GetString("SetOn"),
SetBy = reader.GetString("SetBy"),
ModifiedOn = reader.GetString("ModifiedOn"),
ModifiedBy = reader.GetString("ModifiedBy"),
Status = reader.GetInt32("Status")
}).ToList();
}
}
}
return(userList);
}
public static ClienteModel ActualizarCliente(ClienteModel pCte)
{
Database database;
DbCommand dbCommand;
DatabaseProviderFactory factory = new DatabaseProviderFactory();
ClienteModel Cte = pCte;
try
{
database = factory.Create(ClientesConstantesBD.strConexion);
dbCommand = database.GetStoredProcCommand(ClientesConstantesBD.strCLIENTES_INSERTAR);
database.AddInParameter(dbCommand, "P_IN_KEYCLI", DbType.Int16, pCte.KEYCLI);
database.AddInParameter(dbCommand, "P_IN_KEYTCP", DbType.Int16, pCte.KEYTCP);
database.AddInParameter(dbCommand, "P_IN_RFCCLI", DbType.String, pCte.RFCCLI);
database.AddInParameter(dbCommand, "P_IN_NOMBRE", DbType.String, pCte.NOMCLI);
database.AddInParameter(dbCommand, "P_IN_APEPAT", DbType.String, pCte.APEPAT);
database.AddInParameter(dbCommand, "P_IN_APEMAT", DbType.String, pCte.APEMAT);
database.AddInParameter(dbCommand, "P_IN_DOMICI", DbType.String, pCte.DOMCLI);
database.AddInParameter(dbCommand, "P_IN_NUMEXT", DbType.String, pCte.NUMEXT);
database.AddInParameter(dbCommand, "P_IN_NUMINT", DbType.String, pCte.NUMINT);
database.AddInParameter(dbCommand, "P_IN_COLONI", DbType.String, pCte.COLONI);
database.AddInParameter(dbCommand, "P_IN_CODPOS", DbType.String, pCte.CODPOS);
database.AddInParameter(dbCommand, "P_IN_NOMPAI", DbType.String, pCte.NOMPAI);
database.AddInParameter(dbCommand, "P_IN_NOMEDO", DbType.String, pCte.NOMEDO);
database.AddInParameter(dbCommand, "P_IN_NOMCIU", DbType.String, pCte.NOMCIU);
database.AddOutParameter(dbCommand, "P_OUT_FEULAC", DbType.DateTime, 20);
database.ExecuteNonQuery(dbCommand);
Cte.FEULAC = Convert.ToDateTime(database.GetParameterValue(dbCommand, "P_OUT_FEULAC"));
if (Cte.FEULAC == null)
{
return(null);
}
else
{
return(Cte);
}
}
catch (Exception exp) {
// throw new ApplicationException(exp.Message, exp);
return(null);
}
finally {
database = null;
dbCommand = null;
factory = null;
Cte = null;
}
}
public void Initialize()
{
EnvironmentHelper.AssertOracleClientIsInstalled();
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
try
{
DeleteStoredProcedures();
}
catch { }
CreateStoredProcedures();
base.SetUp();
}
public void Initialize()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(new TestConfigurationContext());
db = factory.CreateDefaultDatabase();
try
{
DeleteStoredProcedures();
}
catch
{
}
CreateStoredProcedures();
}
public void Initialize()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(OracleTestConfigurationSource.CreateConfigurationSource());
db = factory.Create("OracleTest");
// ensure that stored procedures are dropped before trying to create them
try
{
DeleteStoredProcedures();
}
catch { }
CreateStoredProcedures();
base.SetUp();
}
private static void TempSil()
{
try
{
DatabaseProviderFactory factory = new DatabaseProviderFactory();
Database db = factory.Create("connStrBot");
var comm = db.GetSqlStringCommand("TRUNCATE TABLE temp_RehberTablo");
db.ExecuteNonQuery(comm);
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public void Initialize()
{
DatabaseProviderFactory factory = new DatabaseProviderFactory(new TestConfigurationContext());
this.db = factory.CreateDatabase("OracleTest");
// ensure that stored procedures are dropped before trying to create them
try
{
DeleteStoredProcedures();
}
catch
{
}
CreateStoredProcedures();
}
public List <SEC_UserDataAccess> GetAllUserDataAccess(string _UserID,
out string _errorNumber)
{
_errorNumber = string.Empty;
List <SEC_UserDataAccess> userDataAccesses = new List <SEC_UserDataAccess>();
DatabaseProviderFactory factory = new DatabaseProviderFactory();
SqlDatabase db = factory.CreateDefault() as SqlDatabase;
using (DbCommand dbCommandWrapper = db.GetStoredProcCommand("GetAllUserDataAccess"))
{
db.AddInParameter(dbCommandWrapper, "@UserID", SqlDbType.VarChar, _UserID);
db.AddOutParameter(dbCommandWrapper, spStatusParam, DbType.String, 10);
DataSet ds = db.ExecuteDataSet(dbCommandWrapper);
if (!db.GetParameterValue(dbCommandWrapper, spStatusParam).IsNullOrZero())
{
_errorNumber = db.GetParameterValue(dbCommandWrapper, spStatusParam).PrefixErrorCode();
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt1 = ds.Tables[0];
userDataAccesses = dt1.AsEnumerable().Select(reader => new SEC_UserDataAccess
{
UserDataAccessID = reader.GetString("UserDataAccessID"),
UserID = reader.GetString("UserID"),
OwnerID = reader.GetString("OwnerID"),
UserOwnerAccessID = reader.GetString("UserOwnerAccessID"),
DocCategoryID = reader.GetString("DocCategoryID"),
DocTypeID = reader.GetString("DocTypeID"),
DocPropertyID = reader.GetString("DocPropertyID"),
DocPropIdentifyID = reader.GetString("DocPropIdentifyID"),
MetaValue = reader.GetString("MetaValue"),
DataAccessLevel = reader.GetString("DataAccessLevel"),
DataAccessPower = reader.GetString("DataAccessPower"),
AccessTimeLimit = reader.GetString("AccessTimeLimit"),
Remarks = reader.GetString("Remarks"),
SetOn = reader.GetString("SetOn"),
SetBy = reader.GetString("SetBy"),
ModifiedOn = reader.GetString("ModifiedOn"),
ModifiedBy = reader.GetString("ModifiedBy"),
Status = reader.GetInt32("Status")
}).ToList();
}
}
}
return(userDataAccesses);
}
