public DataTable GetProductRequisitionById(string purchaseRequisitionId)
        {
            ProductRequisitionDAL productRequisition = new ProductRequisitionDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = productRequisition.GetProductRequisitionById(purchaseRequisitionId, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                productRequisition = null;
            }
        }