public int registrarImagen(SG_PERSONA_IMAGENE entity)
{
Database db = DatabaseFactory.CreateDatabase(ConfigurationManager.AppSettings["conecion"].ToString());
int resultado = 0;
using (DbConnection cone = db.CreateConnection())
{
cone.Open();
using (DbTransaction trans = cone.BeginTransaction())
{
try
{
DbCommand cmd = db.GetStoredProcCommand("SG_SP_REGISTRAR_PERSONA_IMAGENES");
db.AddInParameter(cmd, "C_COD_PERSONA", DbType.String, entity.C_COD_PERSONA);
db.AddInParameter(cmd, "I_COD_TIPO_IMAGEN", DbType.String, entity.I_COD_TIPO_IMAGEN);
db.AddInParameter(cmd, "V_DES_IMAGEN", DbType.String, entity.V_DES_IMAGEN);
resultado = Convert.ToInt32(db.ExecuteNonQuery(cmd, trans));
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
}
finally
{
if (cone.State == ConnectionState.Open)
{
cone.Close();
}
}
}
}
return(resultado);
}
public int registrarImagen(SG_PERSONA_IMAGENE entity)
{
return(new personaDA().registrarImagen(entity));
}
