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