/// <summary>
/// Usa la clase en Sales.Datails.dbml
/// Usa LinQ
/// </summary>
public static IEnumerable<SalesOrderHeader> BuscarVentasByParams(int pCustomerID)
{
SalesDataContext dc = new SalesDataContext();
IEnumerable<SalesOrderHeader> detalles = from sales in dc.SalesOrderHeaders where sales.CustomerID == pCustomerID select sales;
return detalles;
}
/// <summary>
/// Usa la clase en Sales.Datails.dbml
/// Usa LinQ
/// </summary>
public static List<DetailsView> BuscarDetallesToList(int pCustomerID)
{
SalesDataContext dc = new SalesDataContext();
var detallesView = from sales in dc.SalesOrderDetails
where sales.SalesOrderHeader.CustomerID == pCustomerID
select (new DetailsView
{
SalesOrderID = sales.SalesOrderID,
ProductID = sales.ProductID,
CarrierTrackingNumber = sales.CarrierTrackingNumber,
OrderDate = sales.SalesOrderHeader.OrderDate
});
return detallesView.ToList<DetailsView>();
}
/// <summary>
/// Usa la clase en Sales.Datails.dbml
/// Usa LinQ
/// </summary>
public static IEnumerable<DetailsView> BuscarDetallesIEnumerableTodos(out int count)
{
SalesDataContext dc = new SalesDataContext();
IEnumerable<DetailsView> detallesView = from sales in dc.SalesOrderDetails
select (new DetailsView
{
SalesOrderID = sales.SalesOrderID,
ProductID = sales.ProductID,
CarrierTrackingNumber = sales.CarrierTrackingNumber,
OrderDate = sales.SalesOrderHeader.OrderDate
});
count = detallesView.Count<DetailsView>();
return detallesView;
}
