public static bool CreateToken(Token tokenObj)
{
bool InsertBDok = false;
try
{
var ConectStr = ConfigurationSettings.AppSettings["ConectionAuction"];
ConectStr = ConectStr.Replace("USER", tokenObj.UserName); //testgas1
ConectStr = ConectStr.Replace("PASS", tokenObj.Password); //test12345
// Database dbeAuction = DatabaseFactory.CreateDatabase(a);
Database dbeAuction = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(ConectStr);
// Crear objeto SP
DbCommand spUsuarios = dbeAuction.GetStoredProcCommand("SP_USUARIOS");
dbeAuction.AddInParameter(spUsuarios, "@i_operation", DbType.String, "IU");
dbeAuction.AddInParameter(spUsuarios, "@i_option", DbType.String, "A");
dbeAuction.AddInParameter(spUsuarios, "@UserId", DbType.String, tokenObj.IdUser);
dbeAuction.AddInParameter(spUsuarios, "@UserName", DbType.String, tokenObj.UserName);
dbeAuction.AddInParameter(spUsuarios, "@AuthToken", DbType.String, tokenObj.AuthToken);
dbeAuction.AddInParameter(spUsuarios, "@Password", DbType.String, tokenObj.Password);
dbeAuction.ExecuteNonQuery(spUsuarios);
InsertBDok = true;
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name));
throw new Exception((string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name)));
}
return(InsertBDok);
}
public static Database GetConnectionSecurity()
{
Database SFDatebase = DatabaseFactory.CreateDatabase();
try
{
string path = ConfigurationSettings.AppSettings["FileLocation"].ToString() + ConfigurationSettings.AppSettings["FileName"].ToString();
//string[] lines = File.ReadAllLines(HttpContext.Current.Server.MapPath(path), Encoding.UTF8);
string[] lines = File.ReadAllLines(path, Encoding.UTF8);
if (lines.Length > 0)
{
string databaseString = DatabaseFactory.CreateDatabase("APPSERVICESConnectionString").ConnectionString;
string connectionString = "";
foreach (string res in lines)
{
connectionString = connectionString + res.ToString();
}
connectionString = "User " + connectionString + databaseString;
SFDatebase = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(connectionString);
}
}
catch (Exception ex)
{
string error = ex.Message.ToString();
return(SFDatebase);
}
return(SFDatebase);
}
public static DataTable PurchaserInfoById(Purchaser obj)
{
DataSet dsDatos;
DataTable dtDatos = new DataTable();
try
{
var ConectStr = Tools.ConectionNow.BuildConection(obj.User);
Database dbeAuction = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(ConectStr);
// Database dbeAuction = DatabaseFactory.CreateDatabase("Auction");
// Crear objeto SP
DbCommand spComprador = dbeAuction.GetStoredProcCommand("SP_COMPRADORES");
dbeAuction.AddInParameter(spComprador, "@i_operation", DbType.String, "S");
dbeAuction.AddInParameter(spComprador, "@i_option", DbType.String, "B");
dbeAuction.AddInParameter(spComprador, "@id_Comprador", DbType.Int32, obj.IdSegas);
dbeAuction.AddInParameter(spComprador, "@IdSubasta", DbType.Int32, obj.IdSubasta);
spComprador.CommandTimeout = 900000000;
dsDatos = dbeAuction.ExecuteDataSet(spComprador);
if (dsDatos.Tables[0].Rows.Count > 0)
{
dtDatos = dsDatos.Tables[0];
}
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name));
throw new Exception((string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name)));
}
return(dtDatos);
}
public static Seller SellerSave(Seller sellerobj)
{
int datos;
try
{
var ConectStr = Tools.ConectionNow.BuildConection(sellerobj.User);
Database dbeAuction = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(ConectStr);
// Database dbeAuction = DatabaseFactory.CreateDatabase("Auction");
// Crear objeto SP
// Crear objeto SP
DbCommand spVendedor = dbeAuction.GetStoredProcCommand("SP_VENDEDORES");
dbeAuction.AddInParameter(spVendedor, "@i_operation", DbType.String, "IU");
dbeAuction.AddInParameter(spVendedor, "@i_option", DbType.String, "A");
dbeAuction.AddInParameter(spVendedor, "@id_Vendedor", DbType.Int32, sellerobj.IdSegas);
dbeAuction.AddInParameter(spVendedor, "@PTDVF", DbType.Decimal, sellerobj.PTDVF);
dbeAuction.AddInParameter(spVendedor, "@CIFVF", DbType.Decimal, sellerobj.CIFVF);
dbeAuction.AddInParameter(spVendedor, "@IdSubasta", DbType.Int32, sellerobj.IdSubasta);
dbeAuction.AddInParameter(spVendedor, "@Nombre", DbType.String, sellerobj.Nombre);
dbeAuction.AddInParameter(spVendedor, "@IdOperador", DbType.Int32, sellerobj.User.CodigoOperador);
spVendedor.CommandTimeout = 900000000;
datos = dbeAuction.ExecuteNonQuery(spVendedor);
return(sellerobj);
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name));
throw new Exception((string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name)));
}
}
public static bool PurchasersSaveState(Purchaser pucharserobj)
{
bool transOk = false;
int datos;
try
{
var ConectStr = Tools.ConectionNow.BuildConection(pucharserobj.User);
Database dbeAuction = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(ConectStr);
// Database dbeAuction = DatabaseFactory.CreateDatabase("Auction");
// Crear objeto SP
DbCommand spComprador = dbeAuction.GetStoredProcCommand("SP_COMPRADORES");
dbeAuction.AddInParameter(spComprador, "@i_operation", DbType.String, "IU");
dbeAuction.AddInParameter(spComprador, "@i_option", DbType.String, "B");
dbeAuction.AddInParameter(spComprador, "@id_Comprador", DbType.Int32, pucharserobj.IdSegas);
dbeAuction.AddInParameter(spComprador, "@IdSubasta", DbType.Int32, pucharserobj.IdSubasta);
dbeAuction.AddInParameter(spComprador, "@Estado", DbType.Boolean, pucharserobj.Estado);
dbeAuction.AddInParameter(spComprador, "@Cubrimiento", DbType.Boolean, pucharserobj.Cubrimiento);
dbeAuction.AddInParameter(spComprador, "@Listas", DbType.Boolean, pucharserobj.Listas);
spComprador.CommandTimeout = 900000000;
datos = dbeAuction.ExecuteNonQuery(spComprador);
transOk = true;
}
catch (Exception ex)
{
transOk = false;
System.Diagnostics.Trace.WriteLine(string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name));
throw new Exception((string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name)));
}
return(transOk);
}
public static bool SavePurchaserUser(Purchaser purchaserobj)
{
int datos;
bool SafeSave;
try
{
var ConectStr = Tools.ConectionNow.BuildConection(purchaserobj.User);
Database dbeAuction = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(ConectStr);
// Database dbeAuction = DatabaseFactory.CreateDatabase("Auction");
// Crear objeto SP
DbCommand spComprador = dbeAuction.GetStoredProcCommand("SP_COMPRADORES");
dbeAuction.AddInParameter(spComprador, "@i_operation", DbType.String, "IU");
dbeAuction.AddInParameter(spComprador, "@i_option", DbType.String, "C");
dbeAuction.AddInParameter(spComprador, "@id_Comprador", DbType.Int32, purchaserobj.IdSegas);
dbeAuction.AddInParameter(spComprador, "@Nombre", DbType.String, purchaserobj.Nombre);
dbeAuction.AddInParameter(spComprador, "@IdSubasta", DbType.Int32, purchaserobj.IdSubasta);
dbeAuction.AddInParameter(spComprador, "@DemandaMaxima", DbType.Int32, purchaserobj.DemandaMaximaTotal);
dbeAuction.AddInParameter(spComprador, "@IdOperador", DbType.Int32, purchaserobj.User.CodigoOperador);
spComprador.CommandTimeout = 900000000;
datos = dbeAuction.ExecuteNonQuery(spComprador);
SafeSave = true;
}
catch (Exception ex)
{
SafeSave = false;
System.Diagnostics.Trace.WriteLine(string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name));
throw new Exception((string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name)));
}
return(SafeSave);
}
public static DataTable SearchMessages(UserAutentication objUser)
{
DataSet datos;
DataTable clientes = new DataTable();
try
{
var ConectStr = Tools.ConectionNow.BuildConection(objUser);
Database dbeAuction = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(ConectStr);
// Database dbeAuction = DatabaseFactory.CreateDatabase("Auction");
// Crear objeto SP
// Crear objeto SP
DbCommand spConsultarNotificaciones = dbeAuction.GetStoredProcCommand("SP_NOTIFICACIONES");
dbeAuction.AddInParameter(spConsultarNotificaciones, "@i_operation", DbType.String, "S");
dbeAuction.AddInParameter(spConsultarNotificaciones, "@i_option", DbType.String, "B");
spConsultarNotificaciones.CommandTimeout = 900000000;
datos = dbeAuction.ExecuteDataSet(spConsultarNotificaciones);
if (datos.Tables[0].Rows.Count > 0)
{
clientes = datos.Tables[0];
}
return(clientes);
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name));
throw new Exception((string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name)));
}
}
/// <summary>
/// For getting data in single table from database
/// </summary>
/// <param name="spDOM"></param>
/// <returns></returns>
public static DataTable GetDT(XDocument spDOM, string ConnectionStr)
{
try
{
Database db = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(ConnectionStr);
DbParameter parameter;
DbCommand cmd;
IEnumerable <XElement> elems;
IEnumerable <XElement> elem_list;
string spName = GetProcName(spDOM);
cmd = db.GetStoredProcCommand(spName);
SetCommandTimeOut(cmd);
elems = spDOM.Descendants();
elem_list = from elem in elems select elem;
foreach (XElement element in elem_list)
{
parameter = cmd.CreateParameter();
if (element.Name.ToString() != "BIC" && element.Name.ToString() != "XsdName" && element.Name.ToString() != "procName" && element.Name.ToString() != "pERRORXML")
{
parameter.ParameterName = "@" + element.Name.ToString();
parameter.Value = element.Value;
cmd.Parameters.Add(parameter);
}
}
return(db.ExecuteDataSet(cmd).Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// for getting integer result form database
/// </summary>
/// <param name="dom"></param>
/// <returns></returns>
public static int ExecuteScalarforInt(XDocument dom, string ConnectionStr)
{
try
{
Database db = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(ConnectionStr);
DbParameter parameter;
DbCommand cmd;
IEnumerable <XElement> elems;
IEnumerable <XElement> elem_list;
string Procname = GetProcName(dom);
cmd = db.GetStoredProcCommand(Procname);
SetCommandTimeOut(cmd);
elems = dom.Descendants();
elem_list = from elem in elems
select elem;
foreach (XElement element in elem_list)
{
parameter = cmd.CreateParameter();
if (element.Name.ToString() != "BIC" && element.Name.ToString() != "XsdName" && element.Name.ToString() != "procName" && element.Name.ToString() != "pERRORXML")
{
parameter.ParameterName = "@" + element.Name.ToString();
parameter.Value = element.Value;
cmd.Parameters.Add(parameter);
}
}
int retval = Convert.ToInt32(db.ExecuteScalar(cmd));
return(retval);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 以指定的 SQL Server 数据库连接字符串获取一个 <see cref="Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase"/> 对象。
/// </summary>
/// <param name="connectionString">SQL Server数据库连接字符串</param>
/// <returns>一个 <see cref="Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase"/> 对象。</returns>
protected Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase GetPrimitiveSqlDatabase(string connectionString)
{
if (this._database == null)
{
this._database = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(connectionString);
}
return this._database;
}
/// <summary>
/// 以指定的 SQL Server 数据库连接字符串获取一个 <see cref="Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase"/> 对象。
/// </summary>
/// <param name="connectionString">SQL Server数据库连接字符串</param>
/// <returns>一个 <see cref="Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase"/> 对象。</returns>
protected Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase GetPrimitiveSqlDatabase(string connectionString)
{
if (this._database == null)
{
this._database = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(connectionString);
}
return(this._database);
}
///--------------------------------------------------------------------------------
/// <summary>This constructor creates the sql manager with an underlying Microsoft
/// Enterprise Library sql database instance.</summary>
///
/// <param name="dbOptions">The database options for connecting to the database and using it.</param>
///--------------------------------------------------------------------------------
public SqlDbManager(DatabaseOptions dbOptions)
{
if (dbOptions == null || string.IsNullOrEmpty(dbOptions.ConnectionString))
{
throw new ArgumentException("MoPlus.Data.SqlManager - dbOptions");
}
_dbOptions = dbOptions;
_database = new Ent.Sql.SqlDatabase(dbOptions.ConnectionString);
}
public static DataTable GetDataTable(int key)
{
Database db = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(LocalSqlConn());
string sqlCommand = "select * from accessControl where sitekey='" + key + "' and is_authenticate=1";
DbCommand DBcmd = db.GetSqlStringCommand(sqlCommand);
DBcmd.CommandType = CommandType.Text;
DataSet ds = db.ExecuteDataSet(DBcmd);
return(ds.Tables[0]);
}
public static Database CreateDB()
{
try
{
//Database dataBase = new DatabaseProviderFactory().Create(ConfigurationManager.AppSettings.Get("Banco"));
string conexaoString = Easydoc.Core.Infrastructure.Conexao.DescriptografarConexaoString("DefaultConnection");
Database dataBase = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(conexaoString);
return dataBase;
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex.InnerException);
}
}
public DataAccessComponent(string connectionString, DatabaseType type)
{
switch (type)
{
case DatabaseType.MySQL:
break;
case DatabaseType.Oracle:
break;
case DatabaseType.SQLServer:
database = null;
Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase db = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(connectionString);
database = db;
break;
}
}
/// <summary>
/// For getting xml from database
/// </summary>
/// <param name="dom"></param>
/// <returns></returns>
public static string GetXml(XDocument dom, string ConnectionStr)
{
try
{
Database db = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(ConnectionStr);
DbParameter parameter;
DbCommand cmd;
IEnumerable <XElement> elems;
IEnumerable <XElement> elem_list;
string Procname = GetProcName(dom);
cmd = db.GetStoredProcCommand(Procname);
SetCommandTimeOut(cmd);
string OutParameterName = "";
elems = dom.Descendants();
elem_list = from elem in elems
select elem;
foreach (XElement element in elem_list)
{
parameter = cmd.CreateParameter();
if (element.Name.ToString() != "BIC" && element.Name.ToString() != "XsdName" && element.Name.ToString() != "procName" && element.Name.ToString() != "pFILESDATA")
{
OutParameterName = element.Name.ToString();
parameter.ParameterName = "@" + element.Name.ToString();
if (element.Name.ToString().Trim() == "pERRORXML")
{
parameter.DbType = DbType.Xml;
parameter.Direction = ParameterDirection.Output;
}
else
{
parameter.Value = element.Value;
parameter.Direction = ParameterDirection.Input;
}
cmd.Parameters.Add(parameter);
}
}
db.ExecuteNonQuery(cmd);
var retval = db.GetParameterValue(cmd, "@pERRORXML");
return(Convert.ToString(retval));
}
catch (Exception ex)
{
throw ex;
}
}
public DataAccessComponent(string connectionString, DatabaseType type)
{
switch (type)
{
case DatabaseType.MySQL:
break;
case DatabaseType.Oracle:
break;
case DatabaseType.SQLServer:
database = null;
Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase db = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(connectionString);
database = db;
break;
}
}
/// <summary>
/// Reads the application connection string from Config database
/// </summary>
/// <param name="connectionStringID">value of connectionStringID</param>
/// <returns>application connection string</returns>
private static string GetApplicationConnectionStringFromDB(string connectionStringID)
{
string configDatabaseConnectionString = null;
string applicationConnectionString = null;
configDatabaseConnectionString = GetDatabaseConnectionStringFromRegistry(CONFIGSDATABASEKEY);
Database database = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(configDatabaseConnectionString);
using (DbCommand cmd = database.GetStoredProcCommand(CONFIGURATIONCONNECTIONSTRINGGET))
{
database.AddInParameter(cmd, "@connectionStringKey", DbType.AnsiString, connectionStringID);
database.AddOutParameter(cmd, "@connectionStringValue", DbType.AnsiString, 8000);
database.ExecuteNonQuery(cmd);
applicationConnectionString = (string)database.GetParameterValue(cmd, "@connectionStringValue");
}
return(applicationConnectionString);
}
Database GetDatabase()
{
var factory = new DatabaseProviderFactory();
Database dataAccess;
if (this.ConnectionString != null)
{
dataAccess = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(this.ConnectionString);
}
else if (this.DatabaseName == null)
{
dataAccess = factory.CreateDefault();
}
else
{
dataAccess = factory.Create(this.DatabaseName);
}
return(dataAccess);
}
public static DataTable SearchParams(Params paramsobj)
{
DataSet datos;
DataTable parametros = new DataTable();
string tipoConsulta = "A";
try
{
var ConectStr = Tools.ConectionNow.BuildConection(paramsobj.User);
Database dbeAuction = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(ConectStr);
// Database dbeAuction = DatabaseFactory.CreateDatabase("Auction");
// Crear objeto SP
DbCommand spParametros = dbeAuction.GetStoredProcCommand("SP_PARAMETROS");
if (!String.IsNullOrEmpty(paramsobj.NombreParametro))
{
tipoConsulta = "B";
}
dbeAuction.AddInParameter(spParametros, "@i_operation", DbType.String, "S");
dbeAuction.AddInParameter(spParametros, "@i_option", DbType.String, tipoConsulta);
dbeAuction.AddInParameter(spParametros, "@NombreParametro", DbType.String, paramsobj.NombreParametro);
spParametros.CommandTimeout = 900000000;
datos = dbeAuction.ExecuteDataSet(spParametros);
if (datos.Tables[0].Rows.Count > 0)
{
parametros = datos.Tables[0];
}
return(parametros);
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name));
throw new Exception((string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name)));
}
}
public static int InsertLogGas(GasLog gasobj)
{
int datos;
DataTable clientes = new DataTable();
try
{
var ConectStr = Tools.ConectionNow.BuildConection(gasobj.User);
Database dbAuction = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(ConectStr);
// Database dbeAuction = DatabaseFactory.CreateDatabase("Auction");
// Crear objeto SP
DbCommand spInsertarLog = dbAuction.GetStoredProcCommand("SP_GASLOG");
dbAuction.AddInParameter(spInsertarLog, "@i_operation", DbType.String, "I");
dbAuction.AddInParameter(spInsertarLog, "@i_option", DbType.String, "A");
dbAuction.AddInParameter(spInsertarLog, "@Descripcion", DbType.String, gasobj.Descripcion);
dbAuction.AddInParameter(spInsertarLog, "@NombreUsuario", DbType.String, gasobj.NombreUsuario);
dbAuction.AddInParameter(spInsertarLog, "@IdUsuario", DbType.Int16, gasobj.IdUsuario);
dbAuction.AddInParameter(spInsertarLog, "@TipoMovimiento", DbType.String, gasobj.Descripcion);
dbAuction.AddInParameter(spInsertarLog, "@IdTipoAccion", DbType.Int16, gasobj.IdTipoAccion);
dbAuction.AddInParameter(spInsertarLog, "@Nombre", DbType.String, gasobj.Nombre);
dbAuction.AddInParameter(spInsertarLog, "@EstadoTrans", DbType.Boolean, gasobj.EstadoTransaccion);
spInsertarLog.CommandTimeout = 900000000;
datos = dbAuction.ExecuteNonQuery(spInsertarLog);
return(datos);
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name));
throw new Exception("Excepcion en la funcion LogGas" + ex.StackTrace);
}
}
/// <summary>
/// 以 <paramref name="sqlDatabase"/> 作为 <seealso cref="PrimitiveDatabase"/> 值初始化 <see cref="NDF.Data.Sql.SqlDatabase"/> 对象。
/// </summary>
/// <param name="sqlDatabase">指定的 <see cref="Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase"/> 对象，表示微软企业库提供的一个 SQL Server 数据库访问组件。</param>
public SqlDatabase(Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase sqlDatabase) : base(sqlDatabase)
{
}
public static DataTable SearchLog(GasLogSearch search)
{
DataSet dsDatos;
DataTable dtDatos = new DataTable();
try
{
//Database dbAuction = DatabaseFactory.CreateDatabase("Auction");
var ConectStr = Tools.ConectionNow.BuildConection(search.User);
Database dbAuction = new Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase(ConectStr);
// Crear objeto SP
DbCommand spConsultarLog = dbAuction.GetStoredProcCommand("SP_GASLOG");
dbAuction.AddInParameter(spConsultarLog, "@i_operation", DbType.String, "S");
dbAuction.AddInParameter(spConsultarLog, "@i_option", DbType.String, "A");
if (search.IdUsuario > 0)
{
dbAuction.AddInParameter(spConsultarLog, "@IdUsuario", DbType.Int16, search.IdUsuario);
}
if (search.IdTipoAccion > 0)
{
dbAuction.AddInParameter(spConsultarLog, "@IdTipoAccion", DbType.Int16, search.IdTipoAccion);
}
if (search.FechaInicio != null && search.FechaInicio.Length > 0)
{
string fechain = search.FechaInicio.Substring(0, 10) + " 00:00";
DateTime ffin = Convert.ToDateTime(fechain);
dbAuction.AddInParameter(spConsultarLog, "@FechaInicio", DbType.DateTime, ffin);
}
if (search.FechaFin != null && search.FechaFin.Length > 0)
{
string fechaout = search.FechaFin.Substring(0, 10) + " 23:59";
DateTime ffout = Convert.ToDateTime(fechaout);
dbAuction.AddInParameter(spConsultarLog, "@FechaFin", DbType.DateTime, ffout);
}
if (search.EstadoTransaccion != null && search.EstadoTransaccion.Trim().Length > 0)
{
dbAuction.AddInParameter(spConsultarLog, "@EstadoTrans", DbType.Boolean, search.EstadoTransaccion == "SI" ? true: false);
}
spConsultarLog.CommandTimeout = 900000000;
dsDatos = dbAuction.ExecuteDataSet(spConsultarLog);
if (dsDatos.Tables[0].Rows.Count > 0)
{
dtDatos = dsDatos.Tables[0];
}
//return datos;
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(string.Format("AuctionGas ApiWebServices Auditoria: {0} , NameSpace: {1}, Clase: {2}, Metodo: {3} ", ex.Message, MethodBase.GetCurrentMethod().DeclaringType.Namespace, MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name));
throw new Exception("Excepcion en la funcion LogGas" + ex.StackTrace);
}
return(dtDatos);
}
protected override Microsoft.Practices.EnterpriseLibrary.Data.Database CreateDB()
{
DEntLib.Database db = new DEntLib.Sql.SqlDatabase(dbConnectionString);
return db;
}
