public DataTable GetPendingPurchaseOrdersListByWarehouse(string warehouseId) { PurchaseOrderDAL purchaseOrder = new PurchaseOrderDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = purchaseOrder.GetPendingPurchaseOrdersListByWarehouse(warehouseId, db); db.Stop(); return dt; } catch (Exception) { throw; } finally { purchaseOrder = null; } }
public DataTable GetPurchaseOrdersListByWarehouseDateRangeAndStatus(string warehouseId, string fromDate, string toDate, string status) { PurchaseOrderDAL purchaseOrder = new PurchaseOrderDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = purchaseOrder.GetPurchaseOrdersListByWarehouseDateRangeAndStatus(warehouseId, fromDate, toDate, status, db); db.Stop(); return dt; } catch (Exception) { throw; } finally { purchaseOrder = null; } }
public string SavePurchaseOrder(List<PurchaseOrderBLL> purchaseOrders, string warehouseId, string narration) { PurchaseOrderDAL purchaseOrder = new PurchaseOrderDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); string purchaseOrderId = "";// purchaseOrder.SavePurchaseOrder(purchaseOrders, warehouseId, narration, db); db.Stop(); return purchaseOrderId; } catch (Exception) { throw; } finally { purchaseOrder = null; } }
public void UpdatePurchaseOrderCancelPendingStatusById(string purchaseOrderId, string status) { PurchaseOrderDAL purchaseOrder = new PurchaseOrderDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = purchaseOrder.UpdatePurchaseOrderCancelPendingStatusById(purchaseOrderId, status, db); db.Stop(); } catch (Exception) { throw; } finally { purchaseOrder = null; } }
public DataTable GetPurchaseOrderProductListById(string purchaseOrderId, string purchaseRequisitionId) { PurchaseOrderDAL purchaseOrder = new PurchaseOrderDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = purchaseOrder.GetPurchaseOrderProductListById(purchaseOrderId, purchaseRequisitionId, db); db.Stop(); return dt; } catch (Exception) { throw; } finally { purchaseOrder = null; } }