public static void generateDisbursementList() { Dictionary <string, List <ConsolidatedRequisitionListDetail> > consolidatedDictionary = new Dictionary <string, List <ConsolidatedRequisitionListDetail> >(); List <string> dlist = new List <string>(); List <ConsolidatedRequisitionList> el; el = ConsolidatedRequisitionListEFFacade.getAllDepInvolved(); foreach (ConsolidatedRequisitionList e in el) { dlist.Add(e.DepartmentCode); } List <string> deplist = RequisitionDAO.getAllReqDepartments(); 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 = RequisitionDAO.getAllApprovedOfDep(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))), (RequisitionDAO.getTheFirstDatetDate(deplist[p])), 0); } } } if (dlist.Contains(deplist[p]) == false) { List <Object> olist = RequisitionDAO.getAllApprovedDetails(deplist[p]); List <ConsolidatedRequisitionListDetail> crl = new List <ConsolidatedRequisitionListDetail>(); for (int i = 0; i < olist.Count(); i++) { ConsolidatedRequisitionListDetail c = new ConsolidatedRequisitionListDetail(); c.ItemNumber = olist[i].ToString().Substring(15, 4); c.QuantityRequested = Convert.ToInt32(olist[i].ToString().Substring(32, ((olist[i].ToString().Length) - 34))); c.DateRequest = RequisitionDAO.getTheFirstDatetDate(deplist[p]); c.ActualQuantity = 0; crl.Add(c); } consolidatedDictionary.Add(deplist[p], crl); } } ConsolidatedRequisitionListEFFacade.createNewConsolidatedRequisitionList(consolidatedDictionary); RequisitionDAO.changeApprovedToClosed(); } }