Пример #1
0
        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;
            }
        }
Пример #2
0
        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;
            }
        }
Пример #3
0
        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;
            }
        }
Пример #4
0
        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;
            }
        }
Пример #5
0
        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;
            }
        }