public ActionResult Create(StockCardViewModel stockCardViewModel) { string itemNo = null; if (TempData.ContainsKey("id")) { itemNo = TempData["id"].ToString(); } InventoryViewModel i = InventoryDAO.GetInventoryByItemNo(itemNo); stockCardViewModel.balance = i.balance; stockCardViewModel.category = i.category; stockCardViewModel.description = i.description; stockCardViewModel.itemNo = i.itemNo; stockCardViewModel.dateModified = DateTime.Today; bool result = StockCardDAO.CreateStockCard(stockCardViewModel); if (result) { return(RedirectToAction("Index", new { id = itemNo })); } else { return(View("~/Views/Shared/Error.cshtml")); } }
public ActionResult ViewStockCard() { List <StockCard> stockCards = new StockCardDAO().GetAllStockCards(); ViewData["stockCards"] = stockCards; return(View()); }
// GET: StockCard public ActionResult Index(string id) { List <StockCardViewModel> stockCardViewModel = new List <StockCardViewModel>(); if (!string.IsNullOrEmpty(id)) { TempData["id"] = id; stockCardViewModel = StockCardDAO.GetStockCardsById(id); } return(View(stockCardViewModel)); }
public static List <StockCard> GetStockCardById(long ItemId) { List <StockCard> stockCards = StockCardDAO.GetStockCardById(ItemId); foreach (StockCard stockCard in stockCards) { switch (stockCard.SourceType) { case 1: stockCard.AdjVoucher = new AdjVoucher { AdjId = stockCard.SourceId }; string adjId = stockCard.AdjVoucher.AdjId.ToString("000/000"); string year = stockCard.Date.Year.ToString("0000"); stockCard.Display = "Stock Adjustment " + adjId + "/" + year; break; case 2: stockCard.DisbursementList = new DisbursementList() { Department = new Department() { DeptId = stockCard.SourceId } }; Department department = DepartmentService.GetDepartmentById(stockCard.DisbursementList.Department.DeptId); stockCard.Display = department.DeptName; break; case 3: stockCard.PurchaseOrder = new PurchaseOrder() { SupplierId = stockCard.SourceId }; Supplier supplier = SupplierService.GetSupplierById(stockCard.PurchaseOrder.SupplierId); if (supplier.SupplierCode == null) { supplier.SupplierCode = "Nil"; } stockCard.Display = "Supplier - " + supplier.SupplierCode; break; } } return(stockCards); }
public static void CreateStockCardFromAdj(long adjId, long itemId, int adjQty) { StockCard stockCard = new StockCard(); stockCard.Date = DateTime.Now; stockCard.ItemId = itemId; stockCard.SourceId = adjId; if (adjQty < 0) { stockCard.Qty = "ADJ - " + Math.Abs(adjQty); } else { stockCard.Qty = "ADJ + " + Math.Abs(adjQty); } stockCard.Balance = CatalogueService.GetCatalogueById(itemId).StockLevel; StockCardDAO.CreateStockCardFromAdj(stockCard); }
public static void CreateStockCardFromOrder(PurchaseOrder order, List <long> itemIds, List <int> itemQuantities) { int totalQuantity = itemQuantities.Sum(m => m); if (totalQuantity != 0) { for (int i = 0; i < itemIds.Count; i++) { if (itemQuantities[i] != 0) { StockCard stockCard = new StockCard(); stockCard.Date = DateTime.Now; stockCard.ItemId = itemIds[i]; stockCard.SourceId = order.SupplierId; stockCard.Qty = "+ " + itemQuantities[i]; stockCard.Balance = CatalogueService.GetCatalogueById(itemIds[i]).StockLevel + itemQuantities[i]; StockCardDAO.CreateStockCardFromOrder(stockCard); } } } }
public JsonResult GetItemStockCard(string Id) { List <Object> itemStockCard = new List <Object>(); Item item = new Item(); List <StockCard> stockCards = new List <StockCard>(); ItemDAO itemDAO = new ItemDAO(); try { item = itemDAO.GetItemById(Id); stockCards = new StockCardDAO().GetStockCardsByItemId(Id); itemStockCard.Add(item); if (stockCards != null) { itemStockCard.Add(stockCards); } } catch (FormatException) { Console.WriteLine("{0} is not an Id", Id); } return(Json(itemStockCard, JsonRequestBehavior.AllowGet)); }
public static void CreateStockCardFromDisburse(DisbursementListDetails disbursementDetails, DisbursementList disbursementList, int balance) { StockCardDAO.CreateStockCardFromDisburse(disbursementDetails, disbursementList, balance); }