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)); }