public JsonResult UpdatePrice(int isId, double newprice) { ItemSupplierData.SetPriceById(isId, newprice); /// object n = new { Id = isId, nprice = newprice }; return(Json(n, JsonRequestBehavior.AllowGet)); }
public ActionResult EditSupplierPrice(int sid, string searchStr, int?page) { //////////////////////////////////////////////////////searchbox feature List <Item> listitem = ItemData.FindAll(); ViewBag.listItem = listitem; IPagedList <Item> pagedlist; List <Item> resultlist = new List <Item>(); bool match = false; if (searchStr == null) { searchStr = ""; pagedlist = listitem.ToPagedList(page ?? 1, 7); } else { foreach (Item Pro in listitem) { bool fit = false; if (Search.Found(Pro.Description, searchStr).fit) { fit = true; Pro.Description = Search.Found(Pro.Description, searchStr).str; } if (fit) { match = true; resultlist.Add(Pro); } } pagedlist = resultlist.ToPagedList(page ?? 1, 7); } ViewBag.Rlist = pagedlist; ViewData["searchStr"] = searchStr; ViewData["match"] = match; ///////////////////////////////////////////////////////////// List <ItemSupplier> rlist = new List <ItemSupplier>(); List <ItemSupplier> list = ItemSupplierData.GetAllBySupplierId(sid); foreach (Item item in pagedlist) { rlist.Add(list.Where(x => x.item.Id == item.Id).FirstOrDefault()); } ViewBag.listitemsup = rlist; return(View()); }
public JsonResult GeneratePendingPO() { List <PurchaseOrder> listPO = new List <PurchaseOrder>(); Dictionary <int, int> selectedsupplier = new Dictionary <int, int>(); if (Session["selectedsupplier"] != null) { selectedsupplier = (Dictionary <int, int>)Session["selectedsupplier"]; } else { throw new Exception("please log in"); } //Group the reorder demand by selected supplier Dictionary <int, List <int> > itemsforeachsupplier = new Dictionary <int, List <int> >(); var supplierIdset = new HashSet <int>(selectedsupplier.Values); foreach (int supId in supplierIdset) { List <int> itemlist = new List <int>(); foreach (int itemId in selectedsupplier.Keys) { if (selectedsupplier[itemId] == supId) { if (itemsforeachsupplier.ContainsKey(supId)) { itemsforeachsupplier[supId].Add(itemId); } else { itemlist.Add(itemId); itemsforeachsupplier.Add(supId, itemlist); } } } } //Create PO foreach (int supId in itemsforeachsupplier.Keys) { List <ItemSupplier> lrr = new List <ItemSupplier>(); foreach (int itemId in itemsforeachsupplier[supId]) { ItemSupplier its = ItemSupplierData.GetByItemIdAndSupplierId(itemId, supId); int itId = its.Id; int suId = its.supplier.Id; lrr.Add(its); //ReOrderRecordData.CreateReOrderRocord(its); } PurchaseOrderData.CreatePO(lrr); } ViewBag.reorderrecordgroupbysupplier = itemsforeachsupplier; Session.Remove("selectedsupplier"); object new_amount = new { }; return(Json(new_amount, JsonRequestBehavior.AllowGet)); }