//save the actual quantity for osItems public void saveOutstandingItems(int index, int actual) { OutstandingItem osItem = context.OutstandingItems.Where(x => x.outstandingItemID == index).First(); osItem.actualQty = actual; context.SaveChanges(); }
// add new outstanding item public void createNewOutstandingItem(string itemID, int osID, int needed, int actual) { OutstandingItem outstandingItem = new OutstandingItem(); outstandingItem.outstandingID = osID; outstandingItem.itemID = itemID; outstandingItem.expectedQty = needed - actual; outstandingItem.actualQty = outstandingItem.expectedQty; context.OutstandingItems.Add(outstandingItem); context.SaveChanges(); }
private List <Outstanding> generateOutstandingList(List <Disbursement> dislist) { List <Outstanding> outlist = new List <Outstanding>(); bool IsNewDepartment = true; foreach (Disbursement dept in dislist)// each department { foreach (DisbursementItem item in dept.DisbursementItems) { if (item.expectedQty > item.actualQty)// outstanding { foreach (Outstanding outsdept in outlist) { IsNewDepartment = true; if (outsdept.deptID == dept.deptID)//not a new department in outstanding { IsNewDepartment = false; OutstandingItem outitem = new OutstandingItem(); outitem.itemID = item.itemID; outitem.expectedQty = item.expectedQty - item.actualQty; outitem.actualQty = outitem.expectedQty; outsdept.OutstandingItems.Add(outitem); break; } } if (IsNewDepartment)//add a new department in outstading { Outstanding outs = new Outstanding(); outs.deptID = dept.deptID; outs.disburseDate = dept.disburseDate; outs.storeStaffID = dept.storeStaffID; outs.status = "Pending"; OutstandingItem outitem = new OutstandingItem(); outitem.itemID = item.itemID; outitem.expectedQty = item.expectedQty - item.actualQty; outitem.actualQty = outitem.expectedQty; outs.OutstandingItems.Add(outitem); outlist.Add(outs); } } } } return(outlist); }
/// <summary> /// Force closes an order /// </summary> private void SubmitForceClose() { // Creates a list of outstanding items (StockItemID and quantity outstanding) List <OutstandingItem> outstandingItems = new List <OutstandingItem>(); foreach (GridViewRow row in ReceivingItemsGridView.Rows) { // Adds row to the temporary list OutstandingItem item = new OutstandingItem(); item.StockItemID = int.Parse(row.Cells[0].Text); item.QuantityOutstanding = int.Parse(row.Cells[3].Text); outstandingItems.Add(item); } // Submits information ReceivingController controller = new ReceivingController(); controller.CloseOrder(currentOrderId, ForceCloseReasonTextBox.Text.Trim(), outstandingItems); ClearAndRefreshPage(); }