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