public void Insertar(DO.Persona persona) { DbProviderFactory factory = DbProviderFactories.GetFactory(Settings.Default.proveedor); DbConnection conn = null; DbCommand comm = null; try { conn = factory.CreateConnection(); conn.ConnectionString = Settings.Default.connection; comm = factory.CreateCommand(); DbParameter param1 = factory.CreateParameter(); DbParameter param2 = factory.CreateParameter(); DbParameter param3 = factory.CreateParameter(); DbParameter param4 = factory.CreateParameter(); DbParameter param5 = factory.CreateParameter(); DbParameter param6 = factory.CreateParameter(); param1.ParameterName = "@vNombre"; param1.DbType = System.Data.DbType.String; param1.Value = persona.VNombre; param2.ParameterName = "@iGenero"; param2.DbType = System.Data.DbType.Int32; param2.Value = persona.IGenero; param3.ParameterName = "@vCategoria"; param3.DbType = System.Data.DbType.String; param3.Value = persona.VCategoria; param4.ParameterName = "@iValor"; param4.DbType = System.Data.DbType.Decimal; param4.Value = persona.IValor; param5.ParameterName = "@bDisponible"; param5.DbType = System.Data.DbType.Boolean; param5.Value = persona.BDisponible; //Abrir Coneccion comm.Connection = conn; conn.Open(); //Ejecutar Store Procedure comm.CommandType = System.Data.CommandType.StoredProcedure; comm.CommandText = "sp_Insertar"; comm.Parameters.Add(param1); comm.Parameters.Add(param2); comm.Parameters.Add(param3); comm.Parameters.Add(param4); comm.Parameters.Add(param5); comm.ExecuteNonQuery(); } catch (Exception ee) { throw; } finally { comm.Dispose(); conn.Dispose(); } }
public void Borrar(DO.Persona persona) { DbProviderFactory factory = DbProviderFactories.GetFactory(Settings.Default.proveedor); DbConnection conn = null; DbCommand comm = null; try { conn = factory.CreateConnection(); conn.ConnectionString = Settings.Default.connection; comm = factory.CreateCommand(); DbParameter param1 = factory.CreateParameter(); //Carga de Parametros param1.ParameterName = "@iId"; param1.DbType = System.Data.DbType.Int32; param1.Value = persona.IId; //Abrir Coneccion comm.Connection = conn; conn.Open(); //Ejecutar Store Procedure comm.CommandType = System.Data.CommandType.StoredProcedure; comm.CommandText = "sp_Eliminar"; comm.Parameters.Add(param1); comm.ExecuteNonQuery(); } catch (Exception ee) { throw; } finally { comm.Dispose(); conn.Dispose(); } }