public ActionResult ViewRetrievalList() { List <RetrievalList> list = new List <RetrievalList>(); RetrievalList retrievalList = new RetrievalList(); RetrievalDAO retrieval = new RetrievalDAO(); retrievalList.retrievals = retrieval.GetItemsAndQty(); foreach (var item in retrievalList.retrievals) { if (retrieval.checkOutstandingList(item.ItemId)) { int outstandingQty = retrieval.GetOutstandingQtyByItemId(item.ItemId); item.Qty += outstandingQty; } } foreach (var item in retrievalList.retrievals) { string itemId = item.ItemId; RetrievalList r_list = new RetrievalList(); r_list.ItemId = itemId; r_list.ItemDesc = retrieval.GetItemDescByItemId(itemId); r_list.Total = item.Qty; r_list.RetrievedQty = 0; r_list.ItemReqList = retrieval.GetItemRequestAndDepts(itemId); foreach (var row in r_list.ItemReqList) { r_list.RetrievedQty += row.ActualQty; } list.Add(r_list); } return(View(list)); }
public MResponse GetRetrievalList() { List <Retrieval> retrievals = new RetrievalDAO().GetRetrievalList(); return(new MResponseList <Retrieval>() { ResList = retrievals }); }
public ActionResult CreateRetrievalList() { RetrievalDAO retrieval = new RetrievalDAO(); RetrievalList retrievalList = new RetrievalList(); retrievalList.retrievals = retrieval.GetRetrievalList(); //foreach (var item in retrievalList.retrievals) //{ // if (retrieval.checkOutstandingList(item.ItemId)) // { // int outstandingQty = retrieval.GetOutstandingQtyByItemId(item.ItemId); // item.Qty += outstandingQty; // } //} return(View(retrievalList)); }
public ActionResult CreateRetrieval() { string username = Session["username"].ToString(); List <Retrieval> r_list = new List <Retrieval>(); foreach (string key in Request.Form.AllKeys) { Retrieval r = new Retrieval(); r.ItemId = Convert.ToString(key); r.RetrievalQty = Convert.ToInt32(Request[key]); r_list.Add(r); } EmployeeDAO e = new EmployeeDAO(); Employee e_info = e.GetEmployeeByUsername(username); RetrievalDAO retrieval = new RetrievalDAO(); retrieval.CreateRetrieval(e_info.Id, r_list); return(RedirectToAction("ViewRetrievalList")); }