public string ApprovePurchaseRequisitionAndCreatePurchaseOrder(DataTable dt, string purchaseRequisitionId, string warehouseId)
        {
            PurchaseRequisitionDAL purchaseRequisition = new PurchaseRequisitionDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                string msg = purchaseRequisition.ApprovePurchaseRequisitionAndCreatePurchaseOrder(dt, purchaseRequisitionId, warehouseId, db);
                db.Stop();

                return msg;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                purchaseRequisition = null;
            }
        }