public static void createNewConsolidatedRequisitionList(Dictionary <string, List <ConsolidatedRequisitionListDetail> > dictionary)
{
UniversityStoreEntities context = new UniversityStoreEntities();
foreach (KeyValuePair <string, List <ConsolidatedRequisitionListDetail> > kvp in dictionary)
{
ConsolidatedRequisitionList consolidatedList = new ConsolidatedRequisitionList();
consolidatedList.DepartmentCode = kvp.Key;
consolidatedList.Status = STATUS_OPEN;
EntityCollection <ConsolidatedRequisitionListDetail> listDetails = new EntityCollection <ConsolidatedRequisitionListDetail>();
List <ConsolidatedRequisitionListDetail> detailsList = kvp.Value;
Console.WriteLine(detailsList.Count);
foreach (ConsolidatedRequisitionListDetail detail in detailsList)
{
Console.WriteLine(detail.ItemNumber);
Console.WriteLine("asdfasdf" + detail.QuantityRequested);
listDetails.Add(detail);
}
consolidatedList.ConsolidatedRequisitionListDetails = listDetails;
context.AddToConsolidatedRequisitionLists(consolidatedList);
context.SaveChanges();
}
}
public static void setListStatusToAwaiting(int consolidatedListId)
{
UniversityStoreEntities context = new UniversityStoreEntities();
ConsolidatedRequisitionList consolidatedList = context.ConsolidatedRequisitionLists.Where(x => x.ConsolidatedListID == consolidatedListId).First();
consolidatedList.Status = STATUS_WAITING;
context.SaveChanges();
}
public static ConsolidatedRequisitionList getOpenListForDept(string deptCode)
{
UniversityStoreEntities context = new UniversityStoreEntities();
var query = from x in context.ConsolidatedRequisitionLists
where x.DepartmentCode == deptCode && x.Status == STATUS_OPEN
select x;
List <ConsolidatedRequisitionList> list = query.ToList <ConsolidatedRequisitionList>();
ConsolidatedRequisitionList cl = query.First <ConsolidatedRequisitionList>();
return(cl);
}
public static Department getListForConsolidatedItem(ConsolidatedRequisitionListDetail item)
{
UniversityStoreEntities context = new UniversityStoreEntities();
var query = from x in context.ConsolidatedRequisitionLists
from y in context.ConsolidatedRequisitionListDetails
where x.ConsolidatedListID == y.ConsolidatedListID
select x;
ConsolidatedRequisitionList list = query.First();
Department dept = list.Department;
return(dept);
}
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();
}
}
