public List <SalesOrderDetail> GetSalesSP(TrialsDBEntities tdb)
{
try
{
var myList = tdb.Database.SqlQuery <SalesOrderDetail>("EXEC usp_Get_SalesOrderDetail").ToList();
return(myList);
}
catch (Exception)
{
throw new NotImplementedException();
}
}
public object GetSales(TrialsDBEntities tdb)
{
try
{
var myList = ((from l in tdb.SalesOrderDetails
select new
{
SalesOrderID = l.SalesOrderID,
SalesOrderDetailID = l.SalesOrderDetailID,
CarrierTrackingNumber = l.CarrierTrackingNumber,
OrderQty = l.OrderQty,
ProductID = l.ProductID,
UnitPrice = l.UnitPrice
}).OrderBy(l => l.SalesOrderID)).Take(17000).ToList();
return(myList);
}
catch (Exception)
{
throw new NotImplementedException();
}
}