public List <v_ListarProductos> BuscarXCodigo(string id) { List <v_ListarProductos> listapro = new List <v_ListarProductos>(); string find = ""; if (id == "0") { find = "select*from Producto where Id_prod like'%" + id + "%'"; } else { find = "select*from Producto where Id_prod ='" + id + "'"; } try { string cnx = db.Database.Connection.ConnectionString; con = new SqlConnection(cnx); comando = new SqlCommand(find, con); con.Open(); SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { v_ListarProductos objProdcutos = new v_ListarProductos(); objProdcutos.Id_prod = Convert.ToInt32(reader[0].ToString()); objProdcutos.Nombre = reader[6].ToString(); objProdcutos.descripcion = reader[1].ToString(); objProdcutos.PesoKilos = Convert.ToDecimal(reader[2].ToString()); objProdcutos.PVentaS = Convert.ToDecimal(reader[3].ToString()); objProdcutos.PVentaD = Convert.ToDecimal(reader[4].ToString()); objProdcutos.Marca = reader[5].ToString(); listapro.Add(objProdcutos); } } catch (Exception ex) { throw ex; } finally { con.Close(); } return(listapro); }
public List <v_ListarProductos> ListarProducto() { List <v_ListarProductos> listaTipoMov = new List <v_ListarProductos>(); string find = "select*from v_ListarProductos order by Id_prod asc"; try { string cnx = db.Database.Connection.ConnectionString; con = new SqlConnection(cnx); comando = new SqlCommand(find, con); con.Open(); reader = comando.ExecuteReader(); while (reader.Read()) { v_ListarProductos objProdcutos = new v_ListarProductos(); objProdcutos.Id_prod = Convert.ToInt32(reader[0].ToString()); objProdcutos.Nombre = reader[6].ToString(); objProdcutos.descripcion = reader[1].ToString(); objProdcutos.PesoKilos = Convert.ToDecimal(reader[2].ToString()); objProdcutos.PVentaS = Convert.ToDecimal(reader[3].ToString()); objProdcutos.PVentaD = Convert.ToDecimal(reader[4].ToString()); objProdcutos.Marca = reader[5].ToString(); listaTipoMov.Add(objProdcutos); } } catch (Exception e) { throw e; } finally { con.Close(); } return(listaTipoMov); }