public List <BEcategoria> getLstCategoria() { try { using (cn = new SqlConnection(DAConexion.ConexionBD())) { using (cmd = new SqlCommand("spcategoria_setAll", cn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cn.Open(); using (dr = cmd.ExecuteReader()) { while (dr.Read()) { objcategoria = new BEcategoria(); objcategoria.id_categoria = ((dr["id_categoria"] == DBNull.Value) ? 0 : Convert.ToInt32(dr["id_categoria"])); objcategoria.nombre = (dr["nombre"] == DBNull.Value ? string.Empty : dr["nombre"].ToString()); lstBEcategoria.Add(objcategoria); } } } } } catch (Exception ex) { throw ex; } finally { dr.Dispose(); cmd.Dispose(); cn.Close(); cn.Dispose(); } return(lstBEcategoria); }
public BEproducto() { categoria = new BEcategoria(); }