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