public bool ActivarCertificado(int idCertificado)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_AC_CERTIFICADO", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_ID_CERTIFICADO", idCertificado);
try
{
int id = cmd.ExecuteNonQuery();
if (id == 0)
{
throw new Exception("No fue posible activar el certificado");
}
return(true);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
cmd.Dispose();
cnn.Dispose();
}
}
public int ActivarUnidadOperativa(int idUnidadOperativa)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_AC_UNIDAD_OPERATIVA", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_K_UNIDAD_OPERATIVA", idUnidadOperativa);
int resultado;
try
{
resultado = cmd.ExecuteNonQuery();
return(resultado);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
cmd.Dispose();
cnn.Dispose();
}
}
public string GetThumbnail(int id, System.IO.Stream strm)
{
string fileName = this.DB.Products.Where(a => a.ProductID == id).Select(a => a.ThumbnailPhotoFileName).FirstOrDefault();
if (string.IsNullOrEmpty(fileName))
{
return("");
}
System.Transactions.TransactionOptions top = new System.Transactions.TransactionOptions();
top.Timeout = TimeSpan.FromSeconds(60);
top.IsolationLevel = System.Transactions.IsolationLevel.Serializable;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, top))
using (DbConnection conn = DBConnectionFactory.GetRIAppDemoConnection())
{
byte[] bytes = new byte[64 * 1024];
string fldname = "ThumbNailPhoto";
BlobStream bstrm = new BlobStream(conn as SqlConnection, "[SalesLT].[Product]", fldname, string.Format("WHERE [ProductID]={0}", id));
bstrm.Open();
int cnt = bstrm.Read(bytes, 0, bytes.Length);
while (cnt > 0)
{
strm.Write(bytes, 0, cnt);
cnt = bstrm.Read(bytes, 0, bytes.Length);
}
bstrm.Close();
scope.Complete();
}
return(fileName);
}
public DbDataReader ExecutePureSQL(string query, Dictionary <string, object> parameters = null)
{
try
{
using (connection = DBConnectionFactory.Instance(contextName))
{
DBConnectionOperation.ConnectionOpen(connection);
command = connection.CreateCommand();
command.CommandText = query;
if (parameters != null)
{
foreach (var loopParameter in parameters)
{
DbParameter parameter = command.CreateParameter();
parameter.ParameterName = loopParameter.Key.ToString();
parameter.Value = loopParameter.Value;
command.Parameters.Add(parameter);
}
}
return(command.ExecuteReader());
}
}
catch (Exception ex)
{
DBConnectionOperation.ConnectionClose(connection);
throw ex;
}
}
/// <summary>
/// TR : CRUD işlemlerinden sonra çalıştırılacak method
/// EN :
/// </summary>
/// <returns></returns>
/// <summary>
public virtual int PushToDB()
{
try
{
using (connection = DBConnectionFactory.Instance(contextName))
{
DBConnectionOperation.ConnectionOpen(connection);
command = connection.CreateCommand();
command.CommandText = runVersionQuery;
//Development ortamı isteyen geliştiriciler override edip bu satırları aktif hale getirecekler
//if (DBConnectionFactory.LatestDatabaseVersionFromXML(contextName) != Convert.ToInt32(command.ExecuteScalar()))
// throw new Exception("Veritabanı üzerinde bir güncelleme olduğu için bu işlem gerçekleştirilemez.Lütfen öncelikle Veritabanı versiyonunuzu eşitleyiniz.");
command.CommandText = runQuery;
if (parameterList != null && parameterList.Count > 0)
{
foreach (var loopParameter in parameterList)
{
DbParameter parameter = command.CreateParameter();
parameter.ParameterName = loopParameter.Key.ToString();
parameter.Value = loopParameter.Value;
command.Parameters.Add(parameter);
}
}
return(command.ExecuteNonQuery());
}
}
catch (Exception ex)
{
DBConnectionOperation.ConnectionClose(connection);
throw ex;
}
}
public int getSeriesCount()
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_SK_SERIES_COUNT", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_TOTAL_REG", 0).Direction = ParameterDirection.InputOutput;
int total = 0;
try
{
cmd.ExecuteNonQuery();
total = (int)cmd.Parameters["@PP_TOTAL_REG"].Value;
return(total);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
cmd.Dispose();
cnn.Close();
}
}
public List <Serie> getSeries(int page, int rpp)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_SK_SERIES", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_NUM_PAGINA", page);
cmd.Parameters.AddWithValue("@PP_RPP", rpp);
SqlDataReader reader = cmd.ExecuteReader();
var series = new List <Serie>();
try
{
if (!reader.HasRows)
{
throw new NotFoundException("No se han encontrado series");
}
while (reader.Read())
{
series.Add(getSerieFromReader(reader));
}
return(series);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
reader.Close();
cmd.Dispose();
cnn.Close();
}
}
// <summary>
/// Tablo ve Sütun adı verilerek ilgili Constraint ismini döner
/// </summary>
/// <param name="schemaName">Tablo Şema Adı</param>
/// <param name="tableName">Tablo Adı</param>
/// <param name="columnName">Sütun Adı</param>
/// <returns></returns>
public Tuple <string, string> ConstraintNameByTableAndColumnName(string tableName, string columnName, string schemaName = "")
{
string constraintName = string.Empty;
string constraintType = string.Empty;
try
{
using (connection = DBConnectionFactory.Instance(this.ContextName))
{
DBConnectionOperation.ConnectionOpen(connection);
MySqlCommand command = new MySqlCommand($"SELECT Col.COLUMN_NAME,Col.CONSTRAINT_NAME,Tbl.CONSTRAINT_TYPE " +
$"FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS Tbl,INFORMATION_SCHEMA.KEY_COLUMN_USAGE Col " +
$"WHERE Col.CONSTRAINT_NAME = Tbl.CONSTRAINT_NAME " +
$"AND Col.TABLE_NAME = Tbl.TABLE_NAME " +
$"AND Col.TABLE_NAME = @TableName " +
$"AND Col.COLUMN_NAME = @ColumnName", (MySqlConnection)connection);
command.Parameters.AddWithValue("@TableName", tableName);
command.Parameters.AddWithValue("@ColumnName", columnName);
DbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
constraintName = reader.GetString(1);
constraintType = reader.GetString(2);
}
reader.Close();
}
}
catch (Exception ex)
{
DBConnectionOperation.ConnectionClose(connection);
throw ex;
}
return(Tuple.Create(constraintName, constraintType));
}
public int LatestVersionDatabase()
{
int version = 0;
try
{
using (connection = DBConnectionFactory.Instance(this.ContextName))
{
DBConnectionOperation.ConnectionOpen(connection);
MySqlCommand command = new MySqlCommand($"SELECT Version FROM __WORM__Configuration ORDER BY Version DESC LIMIT 1", (MySqlConnection)connection);
DbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
version = reader.GetInt32(0);
}
reader.Close();
}
}
catch (Exception ex)
{
DBConnectionOperation.ConnectionClose(connection);
throw ex;
}
return(version);
}
/// <summary>
/// Tablo üzerindeki sütunların isimlerini listeler
/// </summary>
/// <param name="tableName">Sütunları listelenecek tablo adı</param>
/// <returns></returns>
public List <string> ColumnListOnTable(string tableName)
{
List <string> columnList = new List <string>();
try
{
using (connection = DBConnectionFactory.Instance(this.ContextName))
{
DBConnectionOperation.ConnectionOpen(connection);
MySqlCommand command = new MySqlCommand($"SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TableName", (MySqlConnection)connection);
command.Parameters.AddWithValue("@TableName", tableName);
DbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
columnList.Add(reader.GetString(3));
}
reader.Close();
}
}
catch (Exception)
{
DBConnectionOperation.ConnectionClose(connection);
}
return(columnList);
}
public bool IsTableHasPrimaryKey(string schemaName, string tableName)
{
bool tablehasPrimaryKey = false;
try
{
using (connection = DBConnectionFactory.Instance(this.contextName))
{
DBConnectionOperation.ConnectionOpen(connection);
MySqlCommand command = new MySqlCommand($"SELECT CASE WHEN EXISTS((SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME = @TableName " +
"AND TABLE_SCHEMA = @SchemaName" +
"AND CONSTRAINT_TYPE = 'PRIMARY KEY')) THEN 1 ELSE 0 END",
(MySqlConnection)connection);
command.Parameters.AddWithValue("@SchemaName", schemaName);
command.Parameters.AddWithValue("@TableName", tableName);
tablehasPrimaryKey = (int)command.ExecuteScalar() == 1 ? true : false;
}
}
catch (Exception ex)
{
DBConnectionOperation.ConnectionClose(connection);
throw ex;
}
return(tablehasPrimaryKey);
}
/// <summary>
/// Veritabanı üzerindeki tabloları isim ve şema birlikte listeler
/// </summary>
/// <returns></returns>
public List <DBTableModel> TableListOnDB()
{
List <DBTableModel> tableList = new List <DBTableModel>();
try
{
using (connection = DBConnectionFactory.Instance(this.contextName))
{
DBConnectionOperation.ConnectionOpen(connection);
DataTable tables = connection.GetSchema("Tables");
foreach (DataRow table in tables.Rows)
{
DBTableModel dBTableModel = new DBTableModel
{
TableName = table[2].ToString()
};
tableList.Add(dBTableModel);
}
}
}
catch (Exception)
{
DBConnectionOperation.ConnectionClose(connection);
}
return(tableList);
}
public Certificado GetCertificado(int idCertificado)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_SK_CERTIFICADO", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_K_CERTIFICADO", idCertificado);
SqlDataReader rdr = null;
try
{
rdr = cmd.ExecuteReader();
if (!rdr.HasRows)
{
throw new NotFoundException("No se ha encontrado el certificado");
}
rdr.Read();
return(getCertificadoFromReader(rdr));
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
rdr.Close();
cmd.Dispose();
cnn.Dispose();
}
}
public int getCertificadosTotal()
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_SK_CERTIFICADOS_TOTAL", cnn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = null;
try
{
rdr = cmd.ExecuteReader();
rdr.Read();
return(rdr.GetInt32(0));
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
rdr.Close();
cmd.Dispose();
cnn.Dispose();
}
}
public Serie insertSerie(Serie serie)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_IN_SERIE", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_ID_SERIE", 0).Direction = ParameterDirection.InputOutput;
cmd.Parameters.AddWithValue("@PP_K_RAZON_SOCIAL", serie.emisor.unidadOperativa.razonSocial.idRazonSocial);
cmd.Parameters.AddWithValue("@PP_TIPO_VENTA", serie.tipoVenta);
cmd.Parameters.AddWithValue("@PP_SERIE", serie.serie);
try
{
cmd.ExecuteNonQuery();
int id = (int)cmd.Parameters["@PP_ID_SERIE"].Value;
if (id <= 0)
{
throw new Exception("Error al insertar la serie");
}
serie.id = id;
return(serie);
}
catch (Exception e)
{
logger.Error(e);
throw e;
}
finally
{
cmd.Dispose();
cnn.Dispose();
}
}
public string ColumnInformationFromDB(string tableName, string columnName)
{
string columnInformation = string.Empty;
try
{
using (connection = DBConnectionFactory.Instance(this.ContextName))
{
DBConnectionOperation.ConnectionOpen(connection);
MySqlCommand command = new MySqlCommand($"SELECT DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,IS_NULLABLE FROM INFORMATION_SCHEMA.COLUMNS " +
$"WHERE TABLE_NAME = @TableName AND COLUMN_NAME = @ColumnName", (MySqlConnection)connection);
command.Parameters.AddWithValue("@TableName", tableName);
command.Parameters.AddWithValue("@ColumnName", columnName);
DbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
columnInformation = $"{reader.GetString(0)}{(reader.IsDBNull(1) ? "" : $"({reader.GetString(1)})")} {(reader.GetString(2) == "YES" ? "NULL" : "NOT NULL")} ";
}
reader.Close();
}
}
catch (Exception ex)
{
DBConnectionOperation.ConnectionClose(connection);
throw ex;
}
return(columnInformation);
}
public void updateSerie(Serie serie)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_UP_SERIE", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_ID_SERIE", serie.id);
cmd.Parameters.AddWithValue("@PP_K_RAZON_SOCIAL", serie.emisor.unidadOperativa.razonSocial.idRazonSocial);
cmd.Parameters.AddWithValue("@PP_TIPO_VENTA", serie.tipoVenta);
cmd.Parameters.AddWithValue("@PP_SERIE", serie.serie);
try
{
int affectedRows = cmd.ExecuteNonQuery();
if (affectedRows == 0)
{
throw new Exception("La serie no ha sido actualizada");
}
}
catch (Exception e)
{
logger.Error(e, e.Message);
}
finally
{
cmd.Dispose();
cnn.Dispose();
}
}
public GameService()
{
var connfactory = new DBConnectionFactory();
conn = connfactory.Connect();
conn.CreateTable();
var worlds = InstanceWorldManager.Instance;
var defaultWorld = worlds.Get(InstanceWorldManager.DefaultID);
var sessionLayer = NetworkStack.Session;
sessionLayer.Connect.Received.Subscribe(d => HandleConnect(d.Session, d.Packet));
sessionLayer.Disconnect.Received.Subscribe(d => HandleDisconnect(d.Session, d.Packet));
sessionLayer.Ping.Received.Subscribe(d => HandlePing(d.Session, d.Packet));
sessionLayer.Heartbeat.Received.Subscribe(d => HandleHeartbeat(d.Session, d.Packet));
sessionLayer.SignUp.Received.Subscribe(d => HandleSignUp(d.Session, d.Packet));
sessionLayer.Authentication.Received.Subscribe(d => HandleAuthentication(d.Session, d.Packet));
sessionLayer.WorldJoin.Received.Subscribe(d => HandleWorldJoin(d.Session, d));
sessionLayer.WorldLeave.Received.Subscribe(d => HandleWorldLeave(d.Session, d));
sessionLayer.Attack.Received.Subscribe(d => EnqueueWorldPacket(d));
sessionLayer.PlayerReady.Received.Subscribe(d => EnqueueWorldPacket(d));
sessionLayer.Move.Received.Subscribe(d => EnqueueWorldPacket(d));
}
public void ActivarSerie(int id)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_AC_SERIE", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_ID_SERIE", id);
try
{
int affectedRows = cmd.ExecuteNonQuery();
if (affectedRows == 0)
{
throw new Exception("La serie no ha sido activada");
}
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
cmd.Dispose();
cnn.Dispose();
}
}
public Zona getZona(int idZona)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_SK_ZONA", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_K_ZONA", idZona);
SqlDataReader reader = null;
Zona zona = new Zona();
try
{
reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return(null);
}
reader.Read();
zona = getZonaFromReader(reader);
return(zona);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
reader.Close();
cmd.Dispose();
cnn.Dispose();
}
}
public Serie getSerie(int id)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_SK_SERIE", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_ID_SERIE", id);
Serie serie = null;
SqlDataReader reader = null;
try
{
reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
throw new NotFoundException("No se ha encontrado la serie con id: " + id);
}
reader.Read();
serie = getSerieFromReader(reader);
return(serie);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
reader.Close();
cmd.Dispose();
cnn.Dispose();
}
}
public int InsertarZona(Zona zona)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_IN_ZONA", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_K_ZONA", 0).Direction = ParameterDirection.InputOutput;
cmd.Parameters.AddWithValue("@PP_ZONA_NOMBRE", zona.zona);
cmd.Parameters.AddWithValue("@PP_DESCRIPCTION", zona.descripcion);
cmd.Parameters.AddWithValue("@PP_IDENTIFICADOR", zona.identificador);
int resultado;
try
{
resultado = cmd.ExecuteNonQuery();
if (resultado > 0)
{
zona.idZona = int.Parse(cmd.Parameters["@PP_K_ZONA"].Value.ToString());
}
return(resultado);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
cmd.Dispose();
cnn.Dispose();
}
}
protected int BaseTransaction(DbTransaction transaction)
{
try
{
connection = DBConnectionFactory.Instance(contextName);
DBConnectionOperation.ConnectionOpen(connection);
command = connection.CreateCommand();
command.Transaction = transaction;
command.CommandText = runQuery;
if (parameterList != null && parameterList.Count > 0)
{
foreach (var loopParameter in parameterList)
{
DbParameter parameter = command.CreateParameter();
parameter.ParameterName = loopParameter.Key.ToString();
parameter.Value = loopParameter.Value;
command.Parameters.Add(parameter);
}
}
return(command.ExecuteNonQuery());
}
catch (Exception ex)
{
DBConnectionOperation.ConnectionClose(connection);
throw ex;
}
}
public int ActualizarZona(Zona zona)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_UP_ZONA", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_K_ZONA", zona.idZona);
cmd.Parameters.AddWithValue("@PP_ZONA_NOMBRE", zona.zona);
cmd.Parameters.AddWithValue("@PP_DESCRIPCTION", zona.descripcion);
cmd.Parameters.AddWithValue("@PP_IDENTIFICADOR", zona.identificador);
int resultado;
try
{
resultado = cmd.ExecuteNonQuery();
return(resultado);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
cmd.Dispose();
cnn.Dispose();
}
}
public void TestBadParameters()
{
var factory = new DBConnectionFactory();
Assert.ThrowsException <ArgumentNullException>(() => factory.CreateConnection(null, default));
Assert.ThrowsException <ArgumentOutOfRangeException>(() => factory.CreateConnection(String.Empty, (DatabaseType)42));
}
public int EliminarZona(int idZona)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_DL_ZONA", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_K_ZONA", idZona);
int resultado;
try
{
resultado = cmd.ExecuteNonQuery();
return(resultado);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
cmd.Dispose();
cnn.Dispose();
}
}
public UnidadOperativa ObtenerUnidadOperativa(int idUnidadOperativa)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_SK_UNIDAD_OPERATIVA_V2", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_ID_UNIDAD_OPERATIVA", idUnidadOperativa);
SqlDataReader reader = null;
UnidadOperativa uos = null;
try
{
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
uos = new UnidadOperativa();
while (reader.Read())
{
uos = GetUnidadOperativaFromReader(reader);
}
}
return(uos);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
reader.Close();
cmd.Dispose();
cnn.Dispose();
}
}
public int ObtenerZonasTotal()
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_SK_ZONAS_TOTAL", cnn);
cmd.CommandType = CommandType.StoredProcedure;
int zonasTotal;
SqlDataReader reader = null;
try
{
reader = cmd.ExecuteReader();
reader.Read();
zonasTotal = reader.GetInt32(0);
return(zonasTotal);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
cmd.Dispose();
cnn.Dispose();
}
}
public void SaveThumbnail(int id, string fileName, System.IO.Stream strm)
{
var product = this.DB.Products.Where(a => a.ProductID == id).FirstOrDefault();
if (product == null)
{
throw new Exception("Product is not found");
}
TransactionOptions topts = new System.Transactions.TransactionOptions();
topts.Timeout = TimeSpan.FromSeconds(60);
topts.IsolationLevel = System.Transactions.IsolationLevel.Serializable;
using (TransactionScope trxScope = new TransactionScope(TransactionScopeOption.Required, topts))
using (DbConnection conn = DBConnectionFactory.GetRIAppDemoConnection())
{
System.IO.BinaryReader br = new System.IO.BinaryReader(strm);
byte[] bytes = br.ReadBytes(64 * 1024);
string fldname = "ThumbNailPhoto";
BlobStream bstrm = new BlobStream(conn as SqlConnection, "[SalesLT].[Product]", fldname, string.Format("WHERE [ProductID]={0}", id));
bstrm.InitColumn();
bstrm.Open();
while (bytes != null && bytes.Length > 0)
{
bstrm.Write(bytes, 0, bytes.Length);
bytes = br.ReadBytes(64 * 1024);;
}
bstrm.Close();
br.Close();
trxScope.Complete();
}
product.ThumbnailPhotoFileName = fileName;
this.DB.SubmitChanges();
}
public bool UpdateCertificado(Certificado cert)
{
SqlConnection cnn = DBConnectionFactory.GetOpenConnection();
SqlCommand cmd = new SqlCommand("PG_UP_CERTIFICADO", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PP_ID_CERTIFICADO", cert.idCertificado);
cmd.Parameters.AddWithValue("@PP_D_CERTIFICADO", cert.descripcion);
cmd.Parameters.AddWithValue("@PP_C_CERTIFICADO", cert.identificador);
cmd.Parameters.AddWithValue("@PP_CERTIFICADO", cert.cert);
cmd.Parameters.AddWithValue("@PP_RUTA_CERTIFICADO", cert.rutaCert);
cmd.Parameters.AddWithValue("@PP_LLAVE", cert.key);
cmd.Parameters.AddWithValue("@PP_CONTRASENA", cert.contrasena);
cmd.Parameters.AddWithValue("@PP_LOGO", "logo_" + cert.cert);
cmd.Parameters.AddWithValue("@PP_FECHA_EXPIRACION", cert.fechaExpiracion);
try
{
int id = cmd.ExecuteNonQuery();
if (id == 0)
{
throw new Exception("No fue posible actualizar el certificado");
}
return(true);
}
catch (Exception e)
{
logger.Error(e, e.Message);
throw e;
}
finally
{
cmd.Dispose();
cnn.Dispose();
}
}
