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