static void Project()
{
#if Project
using (var db = new PurchasingEntities())
{
WriteLine($"\n<----- Project ----->\nPop Properties");
WriteLine($"PO ID\tPartId" +
$"\tQuantity\tQuantityReceived" +
$"\tBackOrdered\tCostReceived");
var pops = db.PurchaseOrderParts.ToArray();
foreach (var pop in pops)
{
Display(pop);
}
WriteLine($"\n<----- Open Purchase Orders ----->");
WriteLine($"PO ID\tPODate\t\tAmount" +
$"\tVendor\tStatus\tTotal Amount Property");
var pos = PurchaseOrder.OpenOrders;
foreach (var po in pos)
{
po.UpdateAmount();
Display(po);
}
WriteLine($"\n<----- Top 3 Vendors ----->\nVendorId\tName\t\tAmount");
var vendors = Vendor.Top3;
foreach (var vendor in vendors)
{
Display(vendor);
}
}
#endif
}
private static void PurchaseOrderTest()
{
#if EfAssignment1
WriteLine("\n<----------- Test PurchaseOrders ----------->");
using (var db = new PurchasingEntities())
{
var purchaseOrders = db.PurchaseOrders;
foreach (var purchaseOrder in purchaseOrders)
{
Display(purchaseOrder);
}
}
#endif
}
private static void VendorTest()
{
#if EfAssignment1
using (var db = new PurchasingEntities())
{
WriteLine("\n<----------- Test Vendors ----------->");
var vendors = db.Vendors;
foreach (var vendor in vendors)
{
Display(vendor);
}
}
#endif
}
public IHttpActionResult Get([FromUri] PagingModel pagingModel, string startDate, string endDate)
{
using (PurchasingEntities entities = new PurchasingEntities())
{
List <PurchaseOrderDetail> purchaseList = entities.PurchaseOrderDetails.ToList();
DateTime?start = null;
if (startDate != null)
{
start = DateTime.Parse(startDate);
}
DateTime?end = null;
if (endDate != null)
{
end = DateTime.Parse(endDate);
}
var results = from purchase in purchaseList
where purchase.DueDate >= start && purchase.DueDate <= end
group purchase by purchase.DueDate into data
select new Result
{
SumOfTraffic = data.Sum(x => x.LineTotal),
OrderQty = data.Sum(x => x.OrderQty),
SumAll = data.Sum(x => x.LineTotal + x.OrderQty)
};
if (results.Count() == 0)
{
return(NotFound());
}
else
{
//Calculate paging
int totalResults = results.Count();
int currentPage = pagingModel.PageNumber;
int pageSize = pagingModel.PageSize;
int pagesNumber = (int)Math.Ceiling((double)totalResults / (double)pageSize);
var resultsPart = results.Skip((currentPage - 1) * pageSize).Take(pageSize).ToList();
return(Ok(resultsPart));
}
}
}
