public ActionResult GenerateDelOrder() { Dictionary <int, int> collist = new Dictionary <int, int>(); if (Session["collist"] != null) { collist = (Dictionary <int, int>)Session["collist"]; } else { Session["collist"] = new Dictionary <int, int>(); } List <ReqItem> lri = ReqItemData.GetAllReqItemApproved(); var itemIdset = new HashSet <int>(collist.Keys); var depIdset = new HashSet <int>(lri.Select(x => x.emp.department.Id).ToList()); List <ReqItem> slist = new List <ReqItem>(); List <ReqItem> xlist = new List <ReqItem>(); Dictionary <int, Dictionary <int, int> > list = new Dictionary <int, Dictionary <int, int> >(); foreach (int depId in depIdset) { slist = lri.Where(x => x.emp.department.Id == depId).ToList(); Dictionary <int, int> itemmap = new Dictionary <int, int>(); foreach (int itemId in itemIdset) { xlist = slist.Where(x => x.item.Id == itemId).ToList(); int quant = xlist.Select(x => x.Quant).Sum(); double price = StockCardData.GetLatestPriceByItem(ItemData.GetItemById(itemId)); if (quant != 0) { itemmap.Add(itemId, quant); } DepOrderData.CreateDepOrder(depId, itemId, quant, price); //Withdraw from stock Item item = ItemData.GetItemById(itemId); int balance = StockCardData.GetStockBalanceByItem(item); StockCardData.WithdrawFromStockRecord(item, DateTime.Today, DepartmentData.GetDepById(depId), quant, balance); int stockbalance = StockCardData.GetStockBalanceByItem(item); //if (stockbalance < item.ReorderLevel) Send Notification } list.Add(depId, itemmap); } ViewBag.Rlist = list; Session["plannedlist"] = list; return(View()); }
public JsonResult ConfirmDelOrder() { object result; Dictionary <int, Dictionary <int, int> > plannedlist = new Dictionary <int, Dictionary <int, int> >(); if (Session["plannedlist"] != null) { plannedlist = (Dictionary <int, Dictionary <int, int> >)Session["plannedlist"]; } //Check if the collected quant is tally with deliver plan Dictionary <int, int> collist = (Dictionary <int, int>)Session["collist"]; foreach (int itemId in collist.Keys) { int itemtotal = 0; foreach (int depId in plannedlist.Keys) { itemtotal += plannedlist[depId][itemId]; } if (itemtotal != collist[itemId]) { result = new { status = false }; return(Json(result, JsonRequestBehavior.AllowGet)); } } //Set ItemReq status and Dep Order status foreach (int depId in plannedlist.Keys) { bool notifystatus = false; foreach (int itemId in plannedlist[depId].Keys) { DepOrderData.SetCollected(depId, itemId, plannedlist[depId][itemId]); foreach (int empId in DepartmentData.GetAllEmpByDepId(depId).Select(x => x.Id)) { if (ReqItemData.SetReqItemCollected(empId, itemId) && notifystatus == false) { string emailaddress = EmployeeData.FindEmpById(empId).EmailAdd; Task task = Task.Run(() => { EmailNotification.SendNotificationEmailToEmployee(emailaddress, "Stationary Requisition Status Changed", "Your Stationary Requisition is under delivering"); }); notifystatus = true; } } } } result = new { status = true }; return(Json(result, JsonRequestBehavior.AllowGet)); }
// GET: StoreClerk public ActionResult TobeCollectList() { ////////////////////////////////////////////////////////Dispatch features ///Retrieve all reqitems need to be deal with List <ReqItem> lri = ReqItemData.GetAllReqItemApproved(); List <ReqItem> slist = new List <ReqItem>(); List <ReqItem> xlist = new List <ReqItem>(); var itemIdset = new HashSet <int>(lri.Select(x => x.item.Id).ToList()); var depIdset = new HashSet <int>(lri.Select(x => x.emp.department.Id).ToList()); var empIdset = new HashSet <int>(lri.Select(x => x.emp.Id).ToList()); List <List <List <ReqItem> > > lll = new List <List <List <ReqItem> > >(); List <List <ReqItem> > ll = new List <List <ReqItem> >(); Dictionary <int, Dictionary <int, int> > list = new Dictionary <int, Dictionary <int, int> >(); foreach (int itemId in itemIdset) { slist = lri.Where(x => x.item.Id == itemId).ToList(); Dictionary <int, int> depmap = new Dictionary <int, int>(); foreach (int depId in depIdset) { xlist = slist.Where(x => x.emp.department.Id == depId && x.item.Id == itemId).ToList(); depmap.Add(depId, xlist.Select(x => x.Quant).Sum()); foreach (int empId in empIdset) {//ReqItemData.SetReqItemCollecting(empId, itemId); } } list.Add(itemId, depmap); } ViewBag.Rlist = list; return(View()); }
public JsonResult ConfirmReceive() { //load the signinglist Dictionary <int, int> signinglist = new Dictionary <int, int>(); if (Session["signinglist"] != null) { signinglist = (Dictionary <int, int>)Session["signinglist"]; } else { throw new Exception("please sign in to confirm receivement"); } int depId; if (Session["username"] != null) { Employee u = EmployeeData.FindByUserName((string)Session["username"]); depId = u.department.Id; } else { throw new Exception("please sign in to confirm receivement"); } bool notifystatus = false; foreach (int itemId in signinglist.Keys) { // SRequisition sr = new SRequisition(); //sr.ListItem = new List<ReqItem>(); foreach (int empId in DepartmentData.GetDepById(depId).Employees.Select(x => x.Id)) { if (ReqItemData.SetReqItemDeliveredToRep(empId, itemId) && notifystatus == false) { string emailaddress = EmployeeData.FindEmpById(empId).EmailAdd; Task task = Task.Run(() => { EmailNotification.SendNotificationEmailToEmployee(emailaddress, "Stationary Requisition Status Changed", "Your Stationary Requisition has delivered to Department Representative."); }); notifystatus = true; } } //if any discrepancy, create new reqItem to replenish in next delivery. int dif = DepOrderData.GetDeliveringOrderByDepAndItem(depId, itemId).quant - signinglist[itemId]; if (dif > 0) { int i = itemId; int j = DepartmentData.GetRepById(depId); ReqItemData.CreatReqItem(itemId, DepartmentData.GetRepById(depId), dif, "approved"); ///////////////////////// } //mark this DepOrder to be delivered DepOrderData.SetReceived(depId, itemId, signinglist[itemId]); } Session.Remove("signinglist"); object new_amount = new { }; return(Json(new_amount, JsonRequestBehavior.AllowGet)); }