public List<Cie10> Buscar(string parametro, int operacion)
{
List<Cie10> lstCie10 = null;
try
{
cmd = new SqlCommand();
cmd.CommandText = "CIE10_Buscar";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = Conexion.instancia().obtenerConexion();
cmd.Parameters.AddWithValue("@Valor", parametro);
cmd.Parameters.AddWithValue("@Oper", operacion);
dr = cmd.ExecuteReader();
Cie10 objCie10 = null;
while (dr.Read())
{
objCie10 = new Cie10();
objCie10.id = (int)dr["idCie10"];
objCie10.codigo = dr["codigo"].ToString();
objCie10.descripcion = dr["descripcion"].ToString();
lstCie10.Add(objCie10);
}
}
catch (Exception e)
{
throw e;
}
finally
{
this.cerrar();
}
return lstCie10;
}
public Cie10 Obtener(int id)
{
Cie10 objCie = null;
try
{
cmd = new SqlCommand("Cie10HEListar");
cmd.CommandType = CommandType.StoredProcedure;
using (cmd.Connection = Conexion.instancia().obtenerConexion())
{
cmd.Parameters.AddWithValue("@idCie10", id);
dr = cmd.ExecuteReader();
if (dr.Read())
{
objCie = new Cie10();
objCie.id = (int)dr["IdCie"];
objCie.codigo = dr["Codigo"].ToString();
objCie.descripcion = dr["Descripcion"].ToString();
}
}
}
catch (Exception)
{
throw;
}
finally { this.cerrar(); }
return objCie;
}