// dch rkl 11/27/2016 return qty available public decimal GetQuantityAvailDecimal(string itemCode, string wareHouseCode, string serialNumber) { IM_ItemCost quantityOnHand = _database.Table<IM_ItemCost>().Where(x => x.ItemCode == itemCode && x.WarehouseCode == wareHouseCode && x.LotSerialNo == serialNumber).FirstOrDefault(); if (quantityOnHand == null) { return 0; } return (Convert.ToDecimal(quantityOnHand.QuantityOnHand) - Convert.ToDecimal(quantityOnHand.QuantityCommitted)); }
public string GetQuantityOnHand(string itemCode, string wareHouseCode, string serialNumber) { IM_ItemCost quantityOnHand = _database.Table<IM_ItemCost>().Where(x => x.ItemCode == itemCode && x.WarehouseCode == wareHouseCode && x.LotSerialNo == serialNumber).FirstOrDefault(); if (quantityOnHand == null) { return "0"; } return (quantityOnHand.QuantityOnHand - quantityOnHand.QuantityCommitted).ToString(); }
// dch rkl 01/20/2017 - Get Qty On Hand, Qty Available and Unit Cost for a Lot/Serial Number public void GetQOHAvlCost(string itemCode, string wareHouseCode, string serialNumber, ref double QOH, ref double Avail, ref decimal UnitCost) { QOH = 0; Avail = 0; UnitCost = 0; IM_ItemCost itemCost = _database.Table<IM_ItemCost>().Where(x => x.ItemCode == itemCode && x.WarehouseCode == wareHouseCode && x.LotSerialNo == serialNumber).FirstOrDefault(); if (itemCost != null) { QOH = Convert.ToDouble(itemCost.QuantityOnHand); Avail = Convert.ToDouble(itemCost.QuantityOnHand) - Convert.ToDouble(itemCost.QuantityCommitted); UnitCost = Convert.ToDecimal(itemCost.UnitCost); } }