public List <ItemPricesListViewModel> FindAllItemPriceList() { List <Item> iList = itemService.FindAllActiveItems(); List <ItemPricesListViewModel> ip = new List <ItemPricesListViewModel>(); ItemPricesListViewModel myModel = new ItemPricesListViewModel(); foreach (Item i in iList) { ip.Add(new ItemPricesListViewModel() { ItemCode = i.ItemCode, Description = i.Description, Code1 = itemPriceService.FindOneByItemAndSequence(i, 1).SupplierCode, Code2 = itemPriceService.FindOneByItemAndSequence(i, 2).SupplierCode, Code3 = itemPriceService.FindOneByItemAndSequence(i, 3).SupplierCode, Price1 = itemPriceService.FindOneByItemAndSequence(i, 1).Price, Price2 = itemPriceService.FindOneByItemAndSequence(i, 2).Price, Price3 = itemPriceService.FindOneByItemAndSequence(i, 3).Price }); } return(ip); }
public ActionResult GeneratePrice() { //ViewBag.myFlag = flag; List <Item> iList = itemService.FindAllActiveItems(); List <ItemPricesListViewModel> ip = new List <ItemPricesListViewModel>(); ItemPricesListViewModel myModel = new ItemPricesListViewModel(); foreach (Item i in iList) { ip.Add(new ItemPricesListViewModel() { ItemCode = i.ItemCode, Description = i.Description, Code1 = itemPriceService.FindOneByItemAndSequence(i, 1).SupplierCode, Code2 = itemPriceService.FindOneByItemAndSequence(i, 2).SupplierCode, Code3 = itemPriceService.FindOneByItemAndSequence(i, 3).SupplierCode, Price1 = itemPriceService.FindOneByItemAndSequence(i, 1).Price, Price2 = itemPriceService.FindOneByItemAndSequence(i, 2).Price, Price3 = itemPriceService.FindOneByItemAndSequence(i, 3).Price }); } return(View(ip)); }
public ActionResult Save(List <PurchaseOrderDetailsViewModel> purchaseOrderDetailList) { List <Supplier> supList = new List <Supplier>(); foreach (PurchaseOrderDetailsViewModel pod in purchaseOrderDetailList) { Item item = itemService.FindItemByItemCode(pod.ItemCode); ItemPrice itemPrice = itemPriceService.FindOneByItemAndSequence(item, pod.SupplierPriority); if (!supList.Contains(itemPrice.Supplier)) { supList.Add(itemPrice.Supplier); } } List <PurchaseOrder> poList = purchaseOrderService.CreatePOForEachSupplier(supList); List <string> purchaseOrderIds = new List <string>(); foreach (PurchaseOrder pOrder in poList) { pOrder.CreatedBy = userService.FindUserByEmail(System.Web.HttpContext.Current.User.Identity.GetUserName()); pOrder.PurchaseOrderDetails = new List <PurchaseOrderDetail>(); pOrder.DeliveryOrders = new List <DeliveryOrder>(); purchaseOrderService.Save(pOrder); purchaseOrderIds.Add(pOrder.PurchaseOrderNo); } foreach (PurchaseOrderDetailsViewModel pod in purchaseOrderDetailList) { PurchaseOrderDetail poDetail = new PurchaseOrderDetail(); poDetail.Item = itemService.FindItemByItemCode(pod.ItemCode); poDetail.ItemCode = pod.ItemCode; poDetail.Quantity = pod.QuantityOrdered; poDetail.Status = statusService.FindStatusByStatusId(11); poDetail.Status.StatusId = 11; //poDetail.UpdatedDateTime = DateTime.Now; // poDetail.UpdatedBy = userService.FindUserByEmail(System.Web.HttpContext.Current.User.Identity.GetUserName()); foreach (PurchaseOrder po in poList) { Item item = itemService.FindItemByItemCode(pod.ItemCode); ItemPrice itemPrice = itemPriceService.FindOneByItemAndSequence(item, pod.SupplierPriority); if (itemPrice.SupplierCode == po.SupplierCode) { poDetail.PurchaseOrder = po; po.PurchaseOrderDetails.Add(poDetail); purchaseOrderService.Save(po); break; } } purchaseOrderService.SavePurchaseOrderDetail(poDetail); } return(new JsonResult { Data = new { purchaseOrders = purchaseOrderIds } }); }