Esempio n. 1
0
        private async void Delete_Click(object sender, EventArgs e)
        {
            /*
             * if (!backgroundWorker1.IsBusy)
             * {
             *  backgroundWorker1.RunWorkerAsync();
             * }
             * else
             * {
             *  label4.Text = "Processing, please wait";
             * }*/
            /*
             * SaleForceConnect con = SaleForceConnect.getInstance(ConfigurationManager.AppSettings["UserName"], ConfigurationManager.AppSettings["Password"], ConfigurationManager.AppSettings["ServerURL"]);
             *
             * SforceService connection = con.getCon();
             */
            /*
             * String stringExcelPath = "CeciReportingTestLOG_deletion.txt";
             * AccountFactory a = new AccountFactory(connection);
             * a.loadAccount();
             * a.deleteAccount(stringExcelPath, a.getAccount());*/
            /*
             * PrivateReportFactory prf = new PrivateReportFactory(connection);
             * prf.loadPrivateReport();
             * PublicReportFactory pr90 = new PublicReportFactory(connection);
             * pr90.loadPublicReport(Convert.ToInt32(publicParams.Text)); // tread  initialize on the Go click event
             * PublicDashboardComponentFactory pdcf = new PublicDashboardComponentFactory(connection);
             * pdcf.loadPublicDashboardComponents();
             * PublicDashboardFactory pdf = new PublicDashboardFactory(connection);
             * pdf.loadPublicDashboard();
             * PrivateDashboardComponentFactory prdcf = new PrivateDashboardComponentFactory(connection);
             * prdcf.loadPrivateDashboardComponent();
             * PrivateDashboardFactory prdf = new PrivateDashboardFactory(connection);
             * prdf.loadPrivateDashboard();
             * PeopleFactory p = new PeopleFactory(connection);
             * p.loadPeople();  // tread  initialize on the Go click event // with  backgroundworker
             * UserFactory u = new UserFactory(connection);
             * u.loadUser();  // tread  initialize on the Go click event// with  backgroundworker
             */
            label4.Text        = "Processing, please wait";
            progressBar1.Value = 0;
            dgv.Rows.Clear();
            dgv.Refresh();

            SaleForceConnect     con        = SaleForceConnect.getInstance(ConfigurationManager.AppSettings["UserName"], ConfigurationManager.AppSettings["Password"], ConfigurationManager.AppSettings["ServerURLsoap"]);
            SforceService        connection = con.getCon();
            PrivateReportFactory prf        = new PrivateReportFactory(connection);

            await Task.Factory.StartNew(() => prf.loadPrivateReport()).ContinueWith(t => progressBar1.Value += 5, TaskScheduler.FromCurrentSynchronizationContext());

            PublicReportFactory pr = new PublicReportFactory(connection);
            await Task.Factory.StartNew(() => pr.loadPublicReport(Convert.ToInt32(publicParams.Text))).ContinueWith(t => progressBar1.Value += 5, TaskScheduler.FromCurrentSynchronizationContext());

            PeopleFactory p = new PeopleFactory(connection);
            await Task.Factory.StartNew(() => p.loadPeopleAsync()).ContinueWith(t => progressBar1.Value += 5, TaskScheduler.FromCurrentSynchronizationContext());

            UserFactory u = new UserFactory(connection);
            await Task.Factory.StartNew(() => u.loadUser()).ContinueWith(t => progressBar1.Value += 5, TaskScheduler.FromCurrentSynchronizationContext());

            PublicDashboardComponentFactory pdcf = new PublicDashboardComponentFactory(connection);
            await Task.Factory.StartNew(() => pdcf.loadPublicDashboardComponents()).ContinueWith(t => progressBar1.Value += 10, TaskScheduler.FromCurrentSynchronizationContext());

            //pdcf.loadPublicDashboardComponents();
            PublicDashboardFactory pdf = new PublicDashboardFactory(connection);
            await Task.Factory.StartNew(() => pdf.loadPublicDashboard()).ContinueWith(t => progressBar1.Value += 10, TaskScheduler.FromCurrentSynchronizationContext());

            //pdf.loadPublicDashboard();
            PrivateDashboardComponentFactory prdcf = new PrivateDashboardComponentFactory(connection);
            await Task.Factory.StartNew(() => prdcf.loadPrivateDashboardComponent()).ContinueWith(t => progressBar1.Value += 10, TaskScheduler.FromCurrentSynchronizationContext());

            prdcf.loadPrivateDashboardComponent();
            PrivateDashboardFactory prdf = new PrivateDashboardFactory(connection);
            await Task.Factory.StartNew(() => prdf.loadPrivateDashboard()).ContinueWith(t => progressBar1.Value += 50, TaskScheduler.FromCurrentSynchronizationContext());

            //prdf.loadPrivateDashboard();


            String fileName;

            if (listQuery.SelectedItem.ToString().Equals("1a - Inactive Employees (Retired, withdrawn)"))
            {
                //clear columns
                dgv.Columns.Clear();
                //clear rows


                DataGridViewHandler       dgv1      = new DataGridViewHandler();
                ListasSfCollectionObjects sfQuery1a = new ListasSfCollectionObjects();
                fileName = "Query 1a";



                dgv1.dgvQuery1a(sfQuery1a.query1a(prf.getPrivateReport(), p.getPeople(), u.getUser(), IgnoreIds), dgv, label4);
                dgv1.excelFile(fileName, dgv);
                //Meesage box

                DialogResult result = MessageBox.Show("This is going to be delete, are you agree?", "Deletion alert", MessageBoxButtons.YesNo);

                if (result == DialogResult.Yes)
                {
                    /*
                     * String stringExcelPath1 = "privateDashboardIDQuery1aLOG_Deletion.txt";
                     * prdf.deletePrivateDashboard(stringExcelPath1, sfQuery1a.queryID1aDeletePrivateDashboard(prf.getPrivateReport(), prdcf.getPrivateDashboardComponent(),
                     * prdf.GetPrivateDashboards(), p.getPeople(), u.getUser()));
                     *
                     * String stringExcelPath2 = "publicDashboardIDQuery1aLOG_Deletion.txt";
                     * pdf.deletePublicDashboard(stringExcelPath2, sfQuery1a.queryID1aDeletePublicDashboard(prf.getPrivateReport(), pdf.GetPublicDashboards(),
                     * pdcf.GetPublicDashboardComponent(), p.getPeople(), u.getUser()));*/

                    String stringExcelPath3 = "PrivateReportQuery1aLOG_deletion.txt";
                    await Task.Run(() => prf.deletePrivateReports(stringExcelPath3, sfQuery1a.queryID1aDeletePrivateReports(prf.getPrivateReport(), p.getPeople(), u.getUser())));
                }
                else
                {
                    MessageBox.Show("The deletion hasn't been done", "Declined Deletion", MessageBoxButtons.OK);
                }
            }
            if (listQuery.SelectedItem.ToString().Equals("1b - Inactive Employees (but not Retired, Withdrawn)"))
            {
                //clear columns
                dgv.Columns.Clear();
                //clear rows

                dgv.Rows.Clear();
                DataGridViewHandler       dgv2      = new DataGridViewHandler();
                ListasSfCollectionObjects sfQuery1b = new ListasSfCollectionObjects();
                fileName = "Query 1b";

                dgv2.dgvQuery1b(sfQuery1b.query1b_deletion(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds), dgv, label4);
                dgv2.excelFile(fileName, dgv);

                //Meesage box

                DialogResult result = MessageBox.Show("This is going to be delete, are you agree?", "Deletion alert", MessageBoxButtons.YesNo);

                if (result == DialogResult.Yes)
                {
                    /*
                     * String stringExcelPath1 = "privateDashboardIDQuery1bLOG_Deletion.txt";
                     * prdf.deletePrivateDashboard(stringExcelPath1, sfQuery1b.queryID1bDeletePrivateDashboard(prf.getPrivateReport(), prdcf.getPrivateDashboardComponent(),
                     * prdf.GetPrivateDashboards(), p.getPeople(), u.getUser(),Convert.ToInt32(privateParams.Text)));
                     *
                     * String stringExcelPath2 = "publicDashboardIDQuery1bLOG_Deletion.txt";
                     * pdf.deletePublicDashboard(stringExcelPath2, sfQuery1b.queryID1bDeletePublicDashboard(prf.getPrivateReport(), pdf.GetPublicDashboards(),
                     * pdcf.GetPublicDashboardComponent(), p.getPeople(), u.getUser(),Convert.ToInt32(privateParams.Text)));
                     *
                     */

                    String stringExcelPath3 = "PrivateReportQuery1bLOG_deletion.txt";
                    await Task.Run(() => prf.deletePrivateReports(stringExcelPath3, sfQuery1b.queryID1bDeletePrivateReports(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds)));
                }
                else
                {
                    MessageBox.Show("The deletion hasn't been done", "Declined Deletion", MessageBoxButtons.OK);
                }
            }
            if (listQuery.SelectedItem.ToString().Equals(" 2 - Inactive MMS users - last login is >180 days"))
            {
                //clear columns
                dgv.Columns.Clear();
                //clear rows

                dgv.Rows.Clear();
                DataGridViewHandler       dgv3     = new DataGridViewHandler();
                ListasSfCollectionObjects sfQuery2 = new ListasSfCollectionObjects();
                fileName = "Query 2";

                dgv3.dgvQuery2(sfQuery2.query2_delete(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds), dgv, label4);
                dgv3.excelFile(fileName, dgv);
                //Meesage box

                DialogResult result = MessageBox.Show("This is going to be delete, are you agree?", "Deletion alert", MessageBoxButtons.YesNo);
                if (result == DialogResult.Yes)
                {
                    String stringExcelPath1 = "privateDashboardIDQuery2LOG_Deletion.txt";
                    await Task.Run(() => prdf.deletePrivateDashboard(stringExcelPath1, sfQuery2.queryID2DeletePrivateDashboard(prf.getPrivateReport(), prdcf.getPrivateDashboardComponent(),
                                                                                                                               prdf.GetPrivateDashboards(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds)));

                    String stringExcelPath2 = "publicDashboardIDQuery2LOG_Deletion.txt";
                    await Task.Run(() => pdf.deletePublicDashboard(stringExcelPath2, sfQuery2.queryID2DeletePublicDashboard(prf.getPrivateReport(), pdf.GetPublicDashboards(),
                                                                                                                            pdcf.GetPublicDashboardComponent(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds)));

                    String stringExcelPath3 = "PrivateReportIDQuery2LOG_deletion.txt";
                    await Task.Run(() => prf.deletePrivateReports(stringExcelPath3, sfQuery2.queryID2DeletePrivateReports(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds)));
                }
                else
                {
                    MessageBox.Show("The deletion hasn't been done", "Declined Deletion", MessageBoxButtons.OK);
                }
            }
            if (listQuery.SelectedItem.ToString().Equals(" 3 - Active MMS Users - Reports not run in more than 180 days"))
            {
                //clear columns
                dgv.Columns.Clear();
                //clear rows

                dgv.Rows.Clear();
                DataGridViewHandler       dgv4     = new DataGridViewHandler();
                ListasSfCollectionObjects sfQuery3 = new ListasSfCollectionObjects();
                fileName = "Query 3";

                dgv4.dgvQuery3(sfQuery3.query3_deletion(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds), dgv, label4);
                dgv4.excelFile(fileName, dgv);
                //Meesage box

                DialogResult result = MessageBox.Show("This is going to be delete, are you agree?", "Deletion alert", MessageBoxButtons.YesNo);
                if (result == DialogResult.Yes)
                {
                    String stringExcelPath3 = "PrivateReportIDQuery3LOG_deletion.txt";
                    await Task.Run(() => prf.deletePrivateReports(stringExcelPath3, sfQuery3.queryID3DeletePrivateReports(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds)));
                }
                else
                {
                    MessageBox.Show("The deletion hasn't been done", "Declined Deletion", MessageBoxButtons.OK);
                }
            }
            if (listQuery.SelectedItem.ToString().Equals(" 4 - Public Reports not run in more than 90 Days"))
            {
                //clear columns

                dgv.Columns.Clear();
                //clear rows
                dgv.Rows.Clear();

                DataGridViewHandler       dgv5     = new DataGridViewHandler();
                ListasSfCollectionObjects sfQuery4 = new ListasSfCollectionObjects();
                fileName = "Query 4";

                dgv5.dgvQuery4(sfQuery4.query4(pr.getPublicReport(), u.getUser(), IgnoreIds), dgv, label4);
                dgv5.excelFile(fileName, dgv);
                //Meesage box

                DialogResult result = MessageBox.Show("This is going to be delete, are you agree?", "Deletion alert", MessageBoxButtons.YesNo);
                if (result == DialogResult.Yes)
                {
                    String stringExcelPath3 = "PublicReportIDQuery4LOG_deletion.txt";
                    await Task.Run(() => pr.deletePublicReport(stringExcelPath3, sfQuery4.queryID4DeletePublicReports(pr.getPublicReport(), u.getUser(), IgnoreIds)));
                }
                else
                {
                    MessageBox.Show("The deletion hasn't been done", "Declined Deletion", MessageBoxButtons.OK);
                }
            }
            if (listQuery.SelectedItem.ToString().Equals(" 5 - Public and private Dashboard"))
            {
                /*
                 * //clear columns
                 * dgv.Columns.Clear();
                 * //clear rows
                 * dgv.Rows.Clear();
                 *
                 *
                 *
                 * DataGridViewHandler dgv6 = new DataGridViewHandler();
                 * ListasSfCollectionObjects sfQuery5 = new ListasSfCollectionObjects();
                 * fileName = "Query 5";
                 *
                 * dgv6.dgvQuery5(sfQuery5.query5_deletion(pdcf.GetPublicDashboardComponent(),
                 *  pr.getPublicReport(), pdf.GetPublicDashboards(), prdcf.getPrivateDashboardComponent(), prdf.GetPrivateDashboards(),
                 *  prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), Convert.ToInt32(publicParams.Text)), dgv, label4);
                 * dgv6.excelFile(fileName, dgv);
                 * //Meesage box
                 *
                 * DialogResult result = MessageBox.Show("This is going to be delete, are you agree?", "Deletion alert", MessageBoxButtons.YesNo);
                 * if (result == DialogResult.Yes)
                 * {
                 *  String stringExcelPath1 = "privateDashboardIDQuery5LOG_Deletion.txt";
                 *  prdf.deletePrivateDashboard(stringExcelPath1, sfQuery5.queryID5DeletePrivateDashboard(prf.getPrivateReport(), prdcf.getPrivateDashboardComponent(),
                 *  prdf.GetPrivateDashboards(), pr.getPublicReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), Convert.ToInt32(publicParams.Text)));
                 *
                 *  String stringExcelPath2 = "publicDashboardIDQuery5LOG_Deletion.txt";
                 *  pdf.deletePublicDashboard(stringExcelPath2, sfQuery5.queryID5DeletePublicDashboard(u.getUser(), p.getPeople(), pdcf.GetPublicDashboardComponent(), pr.getPublicReport(),
                 *      pdf.GetPublicDashboards(), prf.getPrivateReport(), Convert.ToInt32(privateParams.Text), Convert.ToInt32(publicParams.Text)));
                 *
                 *
                 * }
                 * else
                 * {
                 *  MessageBox.Show("The deletion hasn't been done", "Declined Deletion", MessageBoxButtons.OK);
                 *
                 * }
                 */
                MessageBox.Show("This functionality is not implemented", "Declined Deletion", MessageBoxButtons.OK);
            }
        }
Esempio n. 2
0
        private async void FolderShare_Click(object sender, EventArgs e)
        {
            label4.Text          = "Processing, please wait";
            progressBar1.Value   = 0;
            progressBar1.Visible = true;

            dgv.Rows.Clear();
            dgv.Refresh();


            SaleForceConnect con = SaleForceConnect.getInstance(ConfigurationManager.AppSettings["UserName"], ConfigurationManager.AppSettings["Password"], ConfigurationManager.AppSettings["ServerURLsoap"]);

            SforceService connection = con.getCon();// private connection.
            //clear columns
            //dgv.Columns.Clear();
            //clear rows
            //dgv.Rows.Clear();
            DataGridViewHandler dgvFS = new DataGridViewHandler();
            FolderSecurity      fs    = new FolderSecurity();


            ////////////////////////////method that retrieve a list with FolderSecurity information for the dgv\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

            /************loading private and public reports and dashboard******************/
            int param;

            if (Int32.TryParse(publicParams.Text, out param))
            {
                param = Convert.ToInt32(publicParams.Text);
            }
            else
            {
                param = 0;
            }

            PrivateReportFactory prf = new PrivateReportFactory(connection);
            await Task.Factory.StartNew(() => prf.loadPrivateReport()).ContinueWith(t => progressBar1.Value += 25, TaskScheduler.FromCurrentSynchronizationContext());

            PublicReportFactory pr = new PublicReportFactory(connection);
            await Task.Factory.StartNew(() => pr.loadPublicReport(param)).ContinueWith(t => progressBar1.Value += 25, TaskScheduler.FromCurrentSynchronizationContext());

            PublicDashboardFactory pdf = new PublicDashboardFactory(connection);
            await Task.Factory.StartNew(() => pdf.loadPublicDashboard()).ContinueWith(t => progressBar1.Value += 25, TaskScheduler.FromCurrentSynchronizationContext());

            PrivateDashboardFactory prdf = new PrivateDashboardFactory(connection);
            await Task.Factory.StartNew(() => prdf.loadPrivateDashboard());


            /************loading  Folders and FolderShare********************************/
            Rootobject       rObjFolders   = new Rootobject();
            Rootobject       rObjFolders2  = new Rootobject();
            RootobjectShares rObjectShares = new RootobjectShares();
            List <string>    folderIdList  = new List <string>();
            IDictionary <String, List <FolderShare> > mappingFolderIdAndShares = new Dictionary <String, List <FolderShare> >();

            //List<FolderShare> fsList = new List<FolderShare>();
            folderIdList = await rObjFolders.GetFolderIdAsync();

            mappingFolderIdAndShares = await rObjectShares.GetFolderShareListAsync(folderIdList);

            rObjFolders2 = await Rootobject.GetFoldersAsync();

            /******************Query for the final report*******************************/
            List <FolderSecurity>     qFolderSecurity = new List <FolderSecurity>();
            ListasSfCollectionObjects fsq             = new ListasSfCollectionObjects();

            qFolderSecurity = fsq.QueryFolderSecurity(pr.getPublicReport(), prf.getPrivateReport(), pdf.GetPublicDashboards(),
                                                      prdf.GetPrivateDashboards(), mappingFolderIdAndShares, rObjFolders2);
            //await Task.Factory.StartNew(() => dgvFS.dgvFolderSecurity(qFolderSecurity, dgv, label4).ContinueWith(t => progressBar1.Value += 25, TaskScheduler.FromCurrentSynchronizationContext()));

            dgvFS.dgvFolderSecurity(qFolderSecurity, dgv, label4);
            progressBar1.Value += 25;

            buttonFolderShareWasClicked = true;
        }
Esempio n. 3
0
        private async void bLogin_Click(object sender, EventArgs e)
        {
            label4.Text          = "Processing, please wait";
            progressBar1.Value   = 0;
            progressBar1.Visible = true;
            dgv.Rows.Clear();
            dgv.Refresh();

            SaleForceConnect     con        = SaleForceConnect.getInstance(ConfigurationManager.AppSettings["UserName"], ConfigurationManager.AppSettings["Password"], ConfigurationManager.AppSettings["ServerURLsoap"]);
            SforceService        connection = con.getCon();
            PrivateReportFactory prf        = new PrivateReportFactory(connection);

            await Task.Factory.StartNew(() => prf.loadPrivateReport()).ContinueWith(t => progressBar1.Value += 25, TaskScheduler.FromCurrentSynchronizationContext());

            PublicReportFactory pr = new PublicReportFactory(connection);
            await Task.Factory.StartNew(() => pr.loadPublicReport(Convert.ToInt32(publicParams.Text))).ContinueWith(t => progressBar1.Value += 25, TaskScheduler.FromCurrentSynchronizationContext());

            PeopleFactory p = new PeopleFactory(connection);
            await Task.Factory.StartNew(() => p.loadPeopleAsync()).ContinueWith(t => progressBar1.Value += 25, TaskScheduler.FromCurrentSynchronizationContext());

            UserFactory u = new UserFactory(connection);
            await Task.Factory.StartNew(() => u.loadUser()).ContinueWith(t => progressBar1.Value += 25, TaskScheduler.FromCurrentSynchronizationContext());

            /* if (backgroundWorker1.IsBusy != true)
             * {
             *
             *   bgw.RunWorkerAsync();*/

            // stopwatchLoadPrivateReport.Start();
            // PrivateReportFactory prf = new PrivateReportFactory(connection);
            //  prf.loadPrivateReport(/*bgw*/);

            // stopwatchLoadPrivateReport.Stop();

            //PublicReportFactory pr = new PublicReportFactory(connection);
            // stopwatchLoadPublicReport.Start();
            //pr.loadPublicReport(Convert.ToInt32(publicParams.Text)/*, bgw*/);
            //stopwatchLoadPublicReport.Stop();

            // PeopleFactory p = new PeopleFactory(connection);
            // stopwatchLoadPeople.Start();
            // p.loadPeople(/*bgw*/);
            // stopwatchLoadPeople.Stop();

            //UserFactory u = new UserFactory(connection);
            //stopwatchLoadUser.Start();
            //u.loadUser(/*bgw*/);
            // stopwatchLoadUser.Stop();
            // }

            /*
             *   Console.WriteLine("Time elapsed in private report loading: {0:hh\\:mm\\:ss}", stopwatchLoadPrivateReport.Elapsed);
             *   Console.WriteLine("Time elapsed in public report loading: {0:hh\\:mm\\:ss}", stopwatchLoadPublicReport.Elapsed);
             *   Console.WriteLine("Time elapsed in User loading: {0:hh\\:mm\\:ss}", stopwatchLoadUser.Elapsed);
             *   Console.WriteLine("Time elapsed in people loading: {0:hh\\:mm\\:ss}", stopwatchLoadPeople.Elapsed);
             */

            //authenticate();
            if (listQuery.SelectedItem.ToString().Equals("1a - Inactive Employees (Retired, withdrawn)"))
            {
                //clear columns
                dgv.Columns.Clear();
                //clear rows


                DataGridViewHandler       dgv1      = new DataGridViewHandler();
                ListasSfCollectionObjects sfQuery1a = new ListasSfCollectionObjects();


                //stopwatchQuery1a.Start();

                dgv1.dgvQuery1a(sfQuery1a.query1a(prf.getPrivateReport(), p.getPeople(), u.getUser(), IgnoreIds), dgv, label4);

                // stopwatchQuery1a.Stop();

                //Console.WriteLine("Time elapsed in execution query1a: {0:hh\\:mm\\:ss}", stopwatchQuery1a.Elapsed);
            }
            if (listQuery.SelectedItem.ToString().Equals("1b - Inactive Employees (but not Retired, Withdrawn)"))
            {
                //clear columns
                dgv.Columns.Clear();
                //clear rows

                dgv.Rows.Clear();
                DataGridViewHandler       dgv2      = new DataGridViewHandler();
                ListasSfCollectionObjects sfQuery1b = new ListasSfCollectionObjects();

                //stopwatchQuery1b.Start();

                dgv2.dgvQuery1b(sfQuery1b.query1b(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds), dgv, label4);

                //stopwatchQuery1b.Stop();

                // Console.WriteLine("Time elapsed in execution query1b: {0:hh\\:mm\\:ss}", stopwatchQuery1b.Elapsed);
            }
            if (listQuery.SelectedItem.ToString().Equals(" 2 - Inactive MMS users - last login is >180 days"))
            {
                //clear columns
                dgv.Columns.Clear();
                //clear rows

                dgv.Rows.Clear();
                DataGridViewHandler       dgv3     = new DataGridViewHandler();
                ListasSfCollectionObjects sfQuery2 = new ListasSfCollectionObjects();

                //stopwatchQuery2.Start();

                dgv3.dgvQuery2(sfQuery2.query2(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds), dgv, label4);

                // stopwatchQuery2.Stop();

                //Console.WriteLine("Time elapsed in execution query2: {0:hh\\:mm\\:ss}", stopwatchQuery2.Elapsed);
            }

            if (listQuery.SelectedItem.ToString().Equals(" 3 - Active MMS Users - Reports not run in more than 180 days"))
            {
                //clear columns
                dgv.Columns.Clear();
                //clear rows

                dgv.Rows.Clear();
                DataGridViewHandler       dgv4     = new DataGridViewHandler();
                ListasSfCollectionObjects sfQuery3 = new ListasSfCollectionObjects();

                //stopwatchQuery3.Start();

                dgv4.dgvQuery3(sfQuery3.query3(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds), dgv, label4);

                //stopwatchQuery3.Stop();

                //Console.WriteLine("Time elapsed in execution query3: {0:hh\\:mm\\:ss}", stopwatchQuery3.Elapsed);
            }


            if (listQuery.SelectedItem.ToString().Equals(" 4 - Public Reports not run in more than 90 Days"))
            {//clear columns
                dgv.Columns.Clear();
                //clear rows
                dgv.Rows.Clear();

                DataGridViewHandler       dgv5     = new DataGridViewHandler();
                ListasSfCollectionObjects sfQuery4 = new ListasSfCollectionObjects();

                //stopwatchQuery4.Start();

                dgv5.dgvQuery4(sfQuery4.query4(pr.getPublicReport(), u.getUser(), IgnoreIds), dgv, label4);

                //stopwatchQuery3.Stop();

                //Console.WriteLine("Time elapsed in execution query4: {0:hh\\:mm\\:ss}", stopwatchQuery4.Elapsed);
            }
            if (listQuery.SelectedItem.ToString().Equals(" 5 - Public and private Dashboard"))
            {
                //clear columns
                dgv.Columns.Clear();
                //clear rows
                dgv.Rows.Clear();



                DataGridViewHandler       dgv6     = new DataGridViewHandler();
                ListasSfCollectionObjects sfQuery5 = new ListasSfCollectionObjects();

                PublicDashboardComponentFactory pdcf = new PublicDashboardComponentFactory(connection);
                //stopwatchLoadPrivateDashboardComponent.Start();
                pdcf.loadPublicDashboardComponents();
                //stopwatchLoadPublicDashboardComponent.Stop();

                PublicDashboardFactory pdf = new PublicDashboardFactory(connection);
                //stopwatchLoadPublicDashboard.Start();
                pdf.loadPublicDashboard();
                //stopwatchLoadPublicDashboard.Stop();

                PrivateDashboardComponentFactory prdcf = new PrivateDashboardComponentFactory(connection);
                //stopwatchLoadPrivateDashboardComponent.Start();
                prdcf.loadPrivateDashboardComponent();
                // stopwatchLoadPrivateDashboardComponent.Stop();

                PrivateDashboardFactory prdf = new PrivateDashboardFactory(connection);
                //stopwatchLoadPrivateDashboard.Start();
                prdf.loadPrivateDashboard();
                //stopwatchLoadPrivateDashboard.Stop();

                //stopwatchQuery5.Start();

                dgv6.dgvQuery5(sfQuery5.query5(u.getUser(), pdcf.GetPublicDashboardComponent(),
                                               pr.getPublicReport(), pdf.GetPublicDashboards(), prdcf.getPrivateDashboardComponent(), prdf.GetPrivateDashboards(),
                                               prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds), dgv, label4);

                //stopwatchQuery5.Stop();

                // Write hours, minutes and seconds.

                /*
                 * Console.WriteLine("Time elapsed in public dashboard component: {0:hh\\:mm\\:ss}", stopwatchLoadPublicDashboardComponent.Elapsed);
                 * Console.WriteLine("Time elapsed in private dashboard component: {0:hh\\:mm\\:ss}", stopwatchLoadPrivateDashboardComponent.Elapsed);
                 * Console.WriteLine("Time elapsed in public dashboard: {0:hh\\:mm\\:ss}", stopwatchLoadPublicDashboard.Elapsed);
                 * Console.WriteLine("Time elapsed in public dashboard: {0:hh\\:mm\\:ss}", stopwatchLoadPrivateDashboard.Elapsed);
                 * Console.WriteLine("Time elapsed in public dashboard: {0:hh\\:mm\\:ss}", stopwatchQuery5.Elapsed);
                 */
            }
        }