Esempio n. 1
0
        public static string GetEmail(List <string> emailList)
        {
            string emailToReturn = "";
            Dictionary <string, SalesForce.EMAIL_WEIGHT> emailWeights
                = new Dictionary <string, SalesForce.EMAIL_WEIGHT>();

            foreach (string email in emailList)
            {
                string hostDomain = email.Split('@')[1];
                string domain     = hostDomain.Split('.')[0];

                if (emailWeights.ContainsKey(domain))
                {
                    continue;
                }
                else
                {
                    emailWeights.Add(domain, SalesForce.GetWeight(domain.ToUpper()));
                }
            }

            var myList = emailWeights.ToList();

            myList.Sort((pair2, pair1) => pair1.Value.CompareTo(pair2.Value));

            emailToReturn = myList[0].Key;

            return(emailToReturn);
        }
Esempio n. 2
0
        private static Dictionary <string, EmailRecord> getNameValueByElementType(
            HtmlAgilityPack.HtmlDocument source,
            SalesForce salesForce
            )
        {
            Dictionary <string, EmailRecord> output
                = new Dictionary <string, EmailRecord>();

            var document = source.DocumentNode;

            foreach (KeyValuePair <string, bool> emailItem
                     in salesForce.emailHeaderIdentities)
            {
                if (emailItem.Value)
                {
                    HtmlAgilityPack.HtmlNode editNode = source.GetElementbyId(emailItem.Key);

                    if (editNode.Attributes.ToList().Count(x => x.Name == "value") >= 1)
                    {
                        HtmlAgilityPack.HtmlAttribute attribute = editNode.Attributes["value"];

                        EmailRecord record = new EmailRecord();

                        record.emailAddress = attribute.Value;

                        output.Add(emailItem.Key, record);
                    }
                }
            }

            return(output);
        }
Esempio n. 3
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="source"></param>
        /// <param name="advanced"></param>
        /// <returns></returns>
        private static void getNameValueByElementTypeVoid(
            HtmlAgilityPack.HtmlDocument source,
            SalesForce salesForce
            )
        {
            var document = source.DocumentNode;

            HtmlAgilityPack.HtmlNode editNode = document.QuerySelector(salesForce.elementOne);

            HtmlAgilityPack.HtmlAttribute attribute = editNode.Attributes["href"];

            salesForce.endpointEditSearchFieldTemplate = attribute.Value;
        }
Esempio n. 4
0
        private void button2_Click(object sender, EventArgs e)
        {
            // track enter and exit
            this.breakOutExited = false;

            if (lblExcelFileStatus.BackColor != Color.DarkGreen ||
                lblConfirmedWorksheet.BackColor != Color.DarkGreen)
            {
                MessageBox.Show("Donna, you forgot a step make sure everything is green!", "Hey Donna... :-)");
                return;
            }

            KeyInput            input = new KeyInput();
            ApplicationSettings settings
                = new ApplicationSettings();

            // set csv output
            string csvOutput = settings.FILE_EXPORT_PATH;

            // remove files
            CleanUp(settings.WEB_EXPORT_PATH);

            try
            {
                // on new run, remove output file
                if (File.Exists(csvOutput))
                {
                    File.Copy(csvOutput, csvOutput.Replace(".csv", "_" + DateTime.Now.ToFileTime() + ".csv"));
                    File.Delete(csvOutput);
                }
            }
            catch (Exception)
            {
                MessageBox.Show("Donna, did you close the Output.csv file? Close it, then press OK.", "Hey Donna... :-)");
                File.Copy(csvOutput, csvOutput.Replace(".csv", "_" + DateTime.Now.ToFileTime() + ".csv"));
                File.Delete(csvOutput);
            }

            // exit if the file goes away
            if (!File.Exists(this.excelFileLocation))
            {
                return;
            }

            List <string[]> idNumbers = uwExcel.createFromExcel(this.excelFileLocation,
                                                                "A",
                                                                "O",
                                                                txtWorksheetName.Text);

            // excel row number from original
            int rowIndexNo = 1;

            int startFromIndex = 0;
            int endIndexRow    = 0;

            // startFrom
            if (settings.START_AT_ROW > 0)
            {
                startFromIndex = settings.START_AT_ROW;
            }

            // startFrom
            if (settings.END_AT_ROW > 0)
            {
                endIndexRow = settings.END_AT_ROW;
            }

            List <SalesForce> salesForcePersons = new List <SalesForce>();

            foreach (string[] person in idNumbers)
            {
                SalesForce salesForce = new SalesForce(SalesForce.TREE_TYPE.PERSON_SEARCH);

                // get default values
                salesForce.idNumber = person[0];
                salesForce.oldEmail = person[14];

                if (startFromIndex > 0)
                {
                    if (rowIndexNo - 1 <= startFromIndex)
                    {
                        rowIndexNo++;
                        continue;
                    }
                }

                // skip if missing id number
                if (String.IsNullOrEmpty(person[0]))
                {
                    rowIndexNo++;
                    continue;
                }

                Process chrome = Process.Start(settings.DEFAULT_BROWSER_EXE,
                                               salesForce.GetNewEndpoint(person[0]));

                Thread.Sleep(settings.DEFAULT_SLEEP_INTERVAL);

                foreach (var browserInstruction in input.InstructionsBrowser)
                {
                    SendKeys.SendWait(browserInstruction);

                    Thread.Sleep(settings.DEFAULT_SLEEP_INTERVAL);
                }

                var html = Clipboard.GetText();

                loadHtmlGetElementsBySelectorSalesForceGetEditLink(html, salesForce);

                // if no edit link returned skip
                //if (salesForce.endpointEditSearchFieldTemplate == "")
                //{
                //    rowIndexNo++;
                //    continue;
                //}

                salesForce.rowNo = rowIndexNo;

                salesForcePersons.Add(salesForce);

                rowIndexNo++;

                if (endIndexRow > 0)
                {
                    if (rowIndexNo - 1 >= endIndexRow)
                    {
                        rowIndexNo++;

                        // break out as it is the end.
                        break;
                    }
                }
            }

            List <SalesForce> updatedSalesforceList = new List <SalesForce>();

            foreach (SalesForce salesForceElement in salesForcePersons)
            {
                Process chromeEdit = Process.Start(settings.DEFAULT_BROWSER_EXE,
                                                   salesForceElement.GetEditEndpoint());

                Thread.Sleep(settings.DEFAULT_SLEEP_INTERVAL);

                foreach (var browserInstruction in input.InstructionsBrowser)
                {
                    SendKeys.SendWait(browserInstruction);

                    Thread.Sleep(settings.DEFAULT_SLEEP_INTERVAL);
                }

                var htmlEdit = Clipboard.GetText();

                Dictionary <string, EmailRecord> emailDictionary = loadHtmlGetElementsBySelector(htmlEdit, salesForceElement);

                List <string> emailList = new List <string>();
                // if no emails returned skip
                if (emailDictionary.Count > 0)
                {
                    foreach (KeyValuePair <string, EmailRecord> emailRecord in emailDictionary)
                    {
                        EmailRecord record = emailRecord.Value;

                        emailList.Add(record.emailAddress);
                    }
                }

                // copy the object
                SalesForce salesForceNew = salesForceElement.DeepCopy();

                // assign the new email list
                salesForceNew.emailRecordList = emailList;

                // make new list
                updatedSalesforceList.Add(salesForceNew);
            }

            foreach (SalesForce updatedSalesForceItem in updatedSalesforceList)
            {
                string emailToWrite    = "";
                bool   hasEmailChanged = false;

                if (updatedSalesForceItem.emailRecordList.Count > 0)
                {
                    // weigh out emails
                    string domain = GetEmail(updatedSalesForceItem.emailRecordList);

                    // find the email to write
                    emailToWrite = updatedSalesForceItem.emailRecordList.Find(p => p.Contains(domain));


                    if (updatedSalesForceItem.oldEmail != emailToWrite ||
                        updatedSalesForceItem.oldEmail == "" && emailToWrite != "")
                    {
                        hasEmailChanged = true;
                    }
                }

                // This text is always added, making the file longer over time
                // if it is not deleted.
                using (StreamWriter sw = File.AppendText(csvOutput))
                {
                    sw.WriteLine("{0},{1},{2},{3},{4}",
                                 updatedSalesForceItem.idNumber,
                                 hasEmailChanged,
                                 emailToWrite,
                                 updatedSalesForceItem.oldEmail,
                                 updatedSalesForceItem.rowNo);
                }
            }
        }
Esempio n. 5
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="html"></param>
        /// <param name="advanced"></param>
        /// <returns></returns>
        public static void loadHtmlGetElementsBySelectorSalesForceGetEditLink(string html, SalesForce salesForce)
        {
            var source = new HtmlAgilityPack.HtmlDocument();

            source.LoadHtml(html);

            getNameValueByElementTypeVoid(source, salesForce);
        }
Esempio n. 6
0
        public static Dictionary <string, EmailRecord> loadHtmlGetElementsBySelector(string html, SalesForce salesForce)
        {
            var source = new HtmlAgilityPack.HtmlDocument();

            source.LoadHtml(html);

            return(getNameValueByElementType(source, salesForce));
        }