private void getPRsFromQueryToolStripMenuItem_Click(object sender, EventArgs e)
        {
            try
            {
                clsStaticMethods.queryExcelPath = "";
                frmGetPRsByQuery objFrm = new frmGetPRsByQuery();
                objFrm.ShowDialog();
                Application.DoEvents();
                objFrm.Dispose();

                if (!string.IsNullOrEmpty(clsStaticMethods.queryExcelPath) && File.Exists(clsStaticMethods.queryExcelPath))
                {
                    txtFileName.Text = clsStaticMethods.queryExcelPath;
                }
            }
            catch (Exception ex)
            {
                clsStaticMethods.WriteLog("getPRsFromQueryToolStripMenuItem_Click()-->" + ex.Message);
            }
        }
        private void lbtnGetPRsByQuery_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            try
            {
                clsStaticMethods.queryExcelPath = "";
                frmGetPRsByQuery objFrm = new frmGetPRsByQuery();
                objFrm.ShowDialog();
                Application.DoEvents();
                objFrm.Dispose();

                if (!string.IsNullOrEmpty(clsStaticMethods.queryExcelPath) && File.Exists(clsStaticMethods.queryExcelPath))
                {
                    txtFileName.Text = clsStaticMethods.queryExcelPath;
                }
            }
            catch (Exception ex)
            {
                clsStaticMethods.WriteLog("lbtnGetPRsByQuery_LinkClicked()-->" + ex.Message);
            }
        }