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