C# (CSharp) Reserve_Invoices_2 DevEntities.sp_SAP_WarehouseStockAvailability Examples

Example #1

File: BatchBinAllocation.cs Project: KwokHoiMan-Longdan/Newton

 public sp_SAP_WarehouseStockAvailability_Result WarehouseBatches(string itemcode)
 {
     using (var ctx = new DevEntities())
     {
         return(ctx.sp_SAP_WarehouseStockAvailability(itemcode).FirstOrDefault());
     }
 }

Example #2

        public static sp_SAP_WarehouseStockAvailability_Result WarehouseStockCheck(string itemcode, decimal invquantity)
        {
            using (var ctx = new DevEntities())
            {
                var fromwhs = ctx.sp_SAP_WarehouseStockAvailability(itemcode)
                              .Where(x => x.AVAILQTY.Value >= invquantity)
                              .OrderBy(x => x.PRIORITY)
                              .FirstOrDefault();

                return(fromwhs);
            }
        }