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"));
}
