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