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