public static RetrievalForm getRetrivalData(string productNum)
{
RetrievalForm rf = new RetrievalForm();
Product p = ProductDAO.getSearchProductbyid(productNum);
rf.productDescription = p.Description.ToString();
rf.availableQty = Convert.ToInt32(p.Stock.TotalInventoryBalance);
rf.needeQty = ConsolidatedRequisitionListEFFacade.getNeededQty(productNum);
List <string> depList = ConsolidatedRequisitionListEFFacade.getAllDepInvolved(productNum);
List <int> qtyList = ConsolidatedRequisitionListEFFacade.getQtyNeedeOfDep(depList, productNum);
rf.departments = depList;
rf.depNeededQty = qtyList;
List <int> tempDistList = new List <int>();
int tempStock = rf.availableQty;
for (int i = 0; i < depList.Count(); i++)
{
if (tempStock < rf.depNeededQty[i])
{
tempDistList.Add(tempStock);
tempStock = 0;
}
if (tempStock > rf.depNeededQty[i])
{
tempDistList.Add(rf.depNeededQty[i]);
tempStock = tempStock - rf.depNeededQty[i];
}
}
rf.depAvailQty = tempDistList;
return(rf);
}
public static void generateConsolidatedListFromUnfullfilled()
{
List <string> dlist = new List <string>();
List <ConsolidatedRequisitionList> el;
el = ConsolidatedRequisitionListEFFacade.getAllDepInvolved();
foreach (ConsolidatedRequisitionList e in el)
{
dlist.Add(e.DepartmentCode);
}
List <string> deplist = UnfulfilledDAO.getAllUnfullfilledDepartments();
Dictionary <string, List <ConsolidatedRequisitionListDetail> > consolidatedDictionary = new Dictionary <string, List <ConsolidatedRequisitionListDetail> >();
if (deplist.Count() != 0)
{
for (int p = 0; p < deplist.Count(); p++)
{
if (dlist.Contains(deplist[p]))
{
ConsolidatedRequisitionList cl = ConsolidatedRequisitionListEFFacade.getOpenListForDept(deplist[p]);
int listid = cl.ConsolidatedListID;
List <string> itemlist = ConsolidatedRequisitionListEFFacade.getAllItemsOfList(listid);
List <Object> olist1 = UnfulfilledDAO.getAllUnfuffilledOfDep(deplist[p]);
for (int i = 0; i < olist1.Count(); i++)
{
string itmeNum;
itmeNum = olist1[i].ToString().Substring(15, 4);
if (itemlist.Contains(itmeNum))
{
ConsolidatedRequisitionListEFFacade.addRequestedQtyForItem(listid, itmeNum, Convert.ToInt32(olist1[i].ToString().Substring(32, ((olist1[i].ToString().Length) - 34))));
}
else
{
ConsolidatedRequisitionListEFFacade.addDetailToList(listid, itmeNum, Convert.ToInt32(olist1[i].ToString().Substring(32, ((olist1[i].ToString().Length) - 34))), (UnfulfilledDAO.getTheFirstDatetDate(deplist[p])), 0);
}
}
}
if (dlist.Contains(deplist[p]) == false)
{
List <Object> olist2 = UnfulfilledDAO.getAllUnfuffilledOfDep(deplist[p]);
List <ConsolidatedRequisitionListDetail> crl = new List <ConsolidatedRequisitionListDetail>();
for (int i = 0; i < olist2.Count(); i++)
{
ConsolidatedRequisitionListDetail c = new ConsolidatedRequisitionListDetail();
c.ItemNumber = olist2[i].ToString().Substring(15, 4);
c.QuantityRequested = Convert.ToInt32(olist2[i].ToString().Substring(32, ((olist2[i].ToString().Length) - 34)));
c.DateRequest = UnfulfilledDAO.getTheFirstDatetDate(deplist[p]);
c.ActualQuantity = 0;
crl.Add(c);
}
consolidatedDictionary.Add(deplist[p], crl);
ConsolidatedRequisitionListEFFacade.createNewConsolidatedRequisitionList(consolidatedDictionary);
}
}
UnfulfilledDAO.changeOpenToClosed();
}
}