public int EliminarTipoPersona(TipoPersonaEN en)
{
IDbConnection _conn = DBCommon.Conexion();
_conn.Open();
SqlCommand _comand = new SqlCommand("ELIMINAR_TIPOPERSONA", _conn as SqlConnection);
_comand.CommandType = CommandType.StoredProcedure;
_comand.Parameters.Add(new SqlParameter("@ID", en.Id));
int r = _comand.ExecuteNonQuery();
_conn.Close();
return(r);
}
public List <TipoPersonaEN> ObtenerTipoPersona()
{
IDbConnection _conn = DBCommon.Conexion();
_conn.Open();
SqlCommand _comand = new SqlCommand("CONSULTAR_TIPOPERSONA", _conn as SqlConnection);
_comand.CommandType = CommandType.StoredProcedure;
IDataReader _reader = _comand.ExecuteReader();
List <TipoPersonaEN> _lista = new List <TipoPersonaEN>();
while (_reader.Read())
{
TipoPersonaEN pEN = new TipoPersonaEN();
pEN.Id = _reader.GetInt64(0);
pEN.Nombre = _reader.GetString(1);
_lista.Add(pEN);
}
_conn.Close();
return(_lista);
}
