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