private int AddSearchSessionToDb(tblSearchSession searchSession)
        {
            var dbWriter        = new DBWriter();
            int searchSessionID = dbWriter.InsertSearchSession(searchSession);

            return(searchSessionID);
        }
        public int GetSingleRowHtml(string tagToSearch)
        {
            for (int i = 0; i < 20; i++)
            {
                if (CheckElementExists(tagToSearch, i))
                {
                    rowElementHTML =
                        (String)((IJavaScriptExecutor)driver).ExecuteScript("return arguments[0].innerHTML", tableRowElement);


                    string encodedHtml = HttpUtility.HtmlEncode("<table class=\"t_main\" cellpadding=\"0\" cellspacing=\"0\">");

                    rowElementHTML = HttpUtility.HtmlDecode(encodedHtml) + rowElementHTML;

                    // get all the text data
                    // TextData(i);


                    /* // Console.WriteLine("Writing Row Element Data! ******" + rowElementHTML + "*************");
                     * Console.WriteLine("Written data aj_view" + i);*/


                    // Save to DB
                    ///////
                    var dbWriter = new DBWriter();

                    dbWriter.SaveHtmlRowToDB(rowElementHTML, searchSessionID, vehicleID);


                    // return 0;
                }
                else
                {
                    return(1);
                }
            }

            Console.WriteLine("***FINISHED SCRAPING SINGLE ROWS***");
            // Console.ReadLine();

            // error 1 not found so go back to beginning of loop.
            return(1);
        }
        public int GetSingleRowHtml(string tagToSearch)
        {
            for (int i = 0; i < 20; i++)
            {

                if (CheckElementExists(tagToSearch, i)) {
                    rowElementHTML =
                   (String)((IJavaScriptExecutor)driver).ExecuteScript("return arguments[0].innerHTML", tableRowElement);

                    string encodedHtml = HttpUtility.HtmlEncode("<table class=\"t_main\" cellpadding=\"0\" cellspacing=\"0\">");

                    rowElementHTML = HttpUtility.HtmlDecode(encodedHtml) + rowElementHTML;

                    // get all the text data
                   // TextData(i);

                   /* // Console.WriteLine("Writing Row Element Data! ******" + rowElementHTML + "*************");
                    Console.WriteLine("Written data aj_view" + i);*/

                    // Save to DB
                    ///////
                    var dbWriter = new DBWriter();

                    dbWriter.SaveHtmlRowToDB(rowElementHTML, searchSessionID, vehicleID);

                    // return 0;
                }
                else
                {
                    return 1;
                }

            }

            Console.WriteLine("***FINISHED SCRAPING SINGLE ROWS***");
               // Console.ReadLine();

            // error 1 not found so go back to beginning of loop.
            return 1;
        }
 private int AddSearchSessionToDb(tblSearchSession searchSession)
 {
     var dbWriter = new DBWriter();
        int searchSessionID = dbWriter.InsertSearchSession(searchSession);
        return searchSessionID;
 }