private async Task <bool> CreateInvStockQty(int ProdId, int WhId, double Qty)
{
// Create Inv Stock Record for the product
InvStockQty InvStockQty = new InvStockQty
{
ProdId = ProdId,
WhId = WhId,
Qty = Qty
};
_db.InvStockQty.Add(InvStockQty);
await _db.SaveChangesAsync();
return(true);
}
//This funtion will update the stock qty of a product. By admin only
public async Task <bool> UpdateProdStkQty(int StkId, double Qty)
{
try
{
InvStockQty InvStockQty = _db.InvStockQty.FirstOrDefault(stk => stk.Id == StkId);
InvStockQty.Qty = Qty;
// Save changes
await _db.SaveChangesAsync();
return(true);
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
return(false);
}
}
// leave it for later
private bool CheckQtyInWh(string ProdCode, double Qty)
{
InvStockQty = _db.InvStockQty.FirstOrDefaultAsync(inv => inv.ProdInfo.ProdCode == ProdCode & inv.Warehouse.WhType.Type == SD.ShowRoom).GetAwaiter().GetResult();
if (InvStockQty == null)
{
return(false);
}
double StockQty = InvStockQty.Qty;
if (StockQty >= Qty)
{
return(true);
}
else
{
return(false);
}
}