public ActionResult GetProductos(int provID) { List<Product> ListaProductos = new List<Product>(); List<int> ListaID = new List<int>(); AdventureWorks2014Entities contexto = new AdventureWorks2014Entities(); var LHeader = (from OrderHeader in contexto.SalesOrderHeader where OrderHeader.SalesPersonID == provID join OrderDetail in contexto.SalesOrderDetail on OrderHeader.SalesOrderID equals OrderDetail.SalesOrderID into lista from listaproductos in lista select listaproductos.ProductID).Distinct(); ListaID = LHeader.ToList(); foreach (int id in ListaID) { var producto = (from product in contexto.Product where product.ProductID == id select product).First(); ListaProductos.Add(producto); } contexto.Dispose(); ViewBag.ID = provID; return PartialView("_Producto", ListaProductos); }
public ActionResult GetProveedores() { List<Person> ListaProveedores; AdventureWorks2014Entities contexto = new AdventureWorks2014Entities(); var proveedores = (from prov in contexto.SalesPerson join per in contexto.Person on prov.BusinessEntityID equals per.BusinessEntityID into lista from ListaProv in lista select ListaProv); ListaProveedores = proveedores.ToList(); contexto.Dispose(); return View("Proveedor", ListaProveedores); }
public ActionResult ModificarProveedor(int negocio) { Person persona; SalesPerson salesPerson; AdventureWorks2014Entities contexto = new AdventureWorks2014Entities(); var proveedor = (from prov in contexto.Person where prov.BusinessEntityID == negocio select prov).First(); persona = (Person)proveedor; var salesP = from prov in contexto.SalesPerson where prov.BusinessEntityID == negocio select prov; salesPerson = salesP.First(); contexto.Dispose(); ViewBag.salesPerson = salesPerson; return View("ModificarProveedor", persona); }
public ActionResult ModificarProducto(int productID) { Product producto; AdventureWorks2014Entities contexto = new AdventureWorks2014Entities(); var pro = (from productos in contexto.Product where productos.ProductID == productID select productos).First(); producto = (Product)pro; contexto.Dispose(); return View("ModificarProducto", producto); }