public string FTP_GAFayette(string address, string assessment_id, string parcelNumber, string searchType, string orderNumber, string directParcel, string ownername)
{
string Parcelno = "", Owner = "", Property_Address = "", Legal_Desp = "", MultiOwner_details = "", MultiAddress_details = "";
string Parcel_ID = "", Location = "", Legal = "", Property_Class = "", Nighbrhod = "", Tax_Dis = "", Zoing = "", Acres = "", Homestd = "", Exemption = "", Overall_OwnMailAdd = "", Year_Built = "";
string property = "", yblt = "", Mailing_Address2 = "", Mailing_Address1 = "", Owner1 = "", Owner2 = "", Exemp = "", Home = "", Acrs = "", Zone = "", tx_Dis = "", Nhg = "", Pro_Cls = "", Lg_Des = "", Loc = "", Par = "";
string Year1 = "", Year2 = "", Year3 = "", Year4 = "", Assemnt_Details1 = "", Assemnt_Details2 = "", Assemnt_Details3 = "", Assemnt_Details4 = "", total = "", Total_Payments = "", Convey = "", Convey_Fee = "", Paid = "", Total_Paid = "", TaxPayment_details1 = "", TaxPayment_details = "", Balnce_Due = "", Tax_Bill = "", Tax_year = "";
string Taxy = "", Total_DUE = "", Last_PAYDATE = "", Tax_P = "", Tax_Payer = "", Map = "", Map_Code = "", Desk = "", Desk_Pro = "", Locy = "", Tax_Location = "", Bl_No = "", Tax_Billno = "", Disti = "", Tax_Dist = "", Build_Val = "", Land_Val = "", Tax_Acres = "", FrMkt_Val = "", Tax_DueDate = "", Tax_Exmpions = "", TaxInfo_Details = "";
string Cu_Du = "", Penalt = "", In_Tx = "", Oth_Fe = "", Pre_Pay = "", Bc_Tx = "", Tl_Du = "", Cur_Due = "", Tax_Penalty = "", Int_Rest = "", Other_Fees = "", Previous_Payments = "", Back_Taxes = "", TaxToal_Due = "", DueTaxInfo_Details = "";
string Entity = "", FMV = "", Net_Assmnt = "", Exmpl = "", Taxble_Value = "", Millage_Rate = "", Grs_Tax = "", Cretit = "", NetTax = "", CityPayment_details = "", Taxble_Value1 = "", Millage_Rate1 = "", Grs_Tax1 = "", Cretit1 = "", NetTax1 = "";
string Tax_Auth1 = "", Tax_Auth2 = "", Tax_Authotiry = "", TaxAuthority_Details = "";
GlobalClass.global_orderNo = orderNumber;
HttpContext.Current.Session["orderNo"] = orderNumber;
GlobalClass.global_parcelNo = parcelNumber;
string StartTime = "", AssessmentTime = "", TaxTime = "", CitytaxTime = "", LastEndTime = "";
var driverService = PhantomJSDriverService.CreateDefaultService();
driverService.HideCommandPromptWindow = true;
using (driver = new PhantomJSDriver())
{
try
{
StartTime = DateTime.Now.ToString("HH:mm:ss");
if (searchType == "titleflex")
{
string titleaddress = address;
gc.TitleFlexSearch(orderNumber, "", "", titleaddress, "GA", "Fayette");
if ((HttpContext.Current.Session["TitleFlex_Search"] != null && HttpContext.Current.Session["TitleFlex_Search"].ToString() == "Yes"))
{
driver.Quit();
return("MultiParcel");
}
else if (HttpContext.Current.Session["titleparcel"].ToString() == "")
{
HttpContext.Current.Session["Nodata_GAFayette"] = "Yes";
driver.Quit();
return("No Data Found");
}
parcelNumber = HttpContext.Current.Session["titleparcel"].ToString();
searchType = "parcel";
}
if (searchType == "address")
{
driver.Navigate().GoToUrl("https://qpublic.schneidercorp.com/Application.aspx?AppID=942&LayerID=18406&PageTypeID=2&PageID=8204");
Thread.Sleep(2000);
try
{
driver.FindElement(By.XPath("//*[@id='appBody']/div[4]/div/div/div[3]/a[1]")).Click();
Thread.Sleep(2000);
}
catch { }
driver.FindElement(By.Id("ctlBodyPane_ctl01_ctl01_txtAddress")).SendKeys(address);
gc.CreatePdf_WOP(orderNumber, "Address search", driver, "GA", "Fayette");
driver.FindElement(By.Id("ctlBodyPane_ctl01_ctl01_btnSearch")).SendKeys(Keys.Enter);
Thread.Sleep(2000);
try
{
IWebElement MultiAddressTB = driver.FindElement(By.XPath("//*[@id='ctlBodyPane_ctl00_ctl01_gvwParcelResults']/tbody"));
IList <IWebElement> MultiAddressTR = MultiAddressTB.FindElements(By.TagName("tr"));
IList <IWebElement> MultiAddressTD;
gc.CreatePdf_WOP(orderNumber, "Multi Address search", driver, "GA", "Fayette");
int AddressmaxCheck = 0;
foreach (IWebElement MultiAddress in MultiAddressTR)
{
if (AddressmaxCheck <= 25)
{
MultiAddressTD = MultiAddress.FindElements(By.TagName("td"));
if (MultiAddressTD.Count != 0)
{
Parcelno = MultiAddressTD[1].Text;
Owner = MultiAddressTD[2].Text;
Property_Address = MultiAddressTD[3].Text;
Legal_Desp = MultiAddressTD[4].Text;
MultiAddress_details = Owner + "~" + Property_Address + "~" + Legal_Desp;
gc.insert_date(orderNumber, Parcelno, 784, MultiAddress_details, 1, DateTime.Now);
}
AddressmaxCheck++;
}
}
if (MultiAddressTR.Count > 25)
{
HttpContext.Current.Session["multiParcel_GAFayette_Multicount"] = "Maximum";
}
else
{
HttpContext.Current.Session["multiparcel_GAFayette"] = "Yes";
}
driver.Quit();
return("MultiParcel");
}
catch
{ }
}
if (searchType == "parcel")
{
driver.Navigate().GoToUrl("https://qpublic.schneidercorp.com/Application.aspx?AppID=942&LayerID=18406&PageTypeID=2&PageID=8204");
Thread.Sleep(2000);
try
{
driver.FindElement(By.XPath("//*[@id='appBody']/div[4]/div/div/div[3]/a[1]")).Click();
Thread.Sleep(2000);
}
catch { }
if (parcelNumber.Contains(" ") || parcelNumber.Contains("-"))
{
parcelNumber = parcelNumber.Replace(" ", "").Replace("-", "");
}
string CommonParcel = parcelNumber;
if (CommonParcel.Length == 9)
{
driver.FindElement(By.Id("ctlBodyPane_ctl02_ctl01_txtParcelID")).SendKeys(parcelNumber);
gc.CreatePdf(orderNumber, parcelNumber, "ParcelSearch", driver, "GA", "Fayette");
driver.FindElement(By.Id("ctlBodyPane_ctl02_ctl01_btnSearch")).SendKeys(Keys.Enter);
Thread.Sleep(2000);
}
if (CommonParcel.Length == 7)
{
driver.FindElement(By.Id("ctlBodyPane_ctl02_ctl01_txtParcelID")).SendKeys(parcelNumber);
gc.CreatePdf(orderNumber, parcelNumber, "ParcelSearch", driver, "GA", "Fayette");
driver.FindElement(By.Id("ctlBodyPane_ctl02_ctl01_btnSearch")).SendKeys(Keys.Enter);
Thread.Sleep(2000);
}
}
if (searchType == "ownername")
{
driver.Navigate().GoToUrl("https://qpublic.schneidercorp.com/Application.aspx?AppID=942&LayerID=18406&PageTypeID=2&PageID=8204");
Thread.Sleep(2000);
try
{
driver.FindElement(By.XPath("//*[@id='appBody']/div[4]/div/div/div[3]/a[1]")).Click();
Thread.Sleep(2000);
}
catch { }
driver.FindElement(By.Id("ctlBodyPane_ctl00_ctl01_txtName")).SendKeys(ownername);
gc.CreatePdf_WOP(orderNumber, "Owner search", driver, "GA", "Fayette");
driver.FindElement(By.Id("ctlBodyPane_ctl00_ctl01_btnSearch")).SendKeys(Keys.Enter);
Thread.Sleep(2000);
try
{
IWebElement MultiOwnerTB = driver.FindElement(By.XPath("//*[@id='ctlBodyPane_ctl00_ctl01_gvwParcelResults']/tbody"));
IList <IWebElement> MultiOwnerTR = MultiOwnerTB.FindElements(By.TagName("tr"));
IList <IWebElement> MultiOwnerTD;
gc.CreatePdf_WOP(orderNumber, "Multi Owner search", driver, "GA", "Fayette");
int AddressmaxCheck = 0;
foreach (IWebElement MultiOwner in MultiOwnerTR)
{
if (AddressmaxCheck <= 25)
{
MultiOwnerTD = MultiOwner.FindElements(By.TagName("td"));
if (MultiOwnerTD.Count != 0)
{
Parcelno = MultiOwnerTD[1].Text;
Owner = MultiOwnerTD[2].Text;
Property_Address = MultiOwnerTD[3].Text;
Legal_Desp = MultiOwnerTD[4].Text;
MultiOwner_details = Owner + "~" + Property_Address + "~" + Legal_Desp;
gc.insert_date(orderNumber, Parcelno, 784, MultiOwner_details, 1, DateTime.Now);
}
AddressmaxCheck++;
}
}
if (MultiOwnerTR.Count > 25)
{
HttpContext.Current.Session["multiParcel_GAFayette_Multicount"] = "Maximum";
}
else
{
HttpContext.Current.Session["multiparcel_GAFayette"] = "Yes";
}
driver.Quit();
return("MultiParcel");
}
catch
{ }
}
try
{
IWebElement Inodata = driver.FindElement(By.Id("ctlBodyPane_noDataList_pnlNoResults"));
if (Inodata.Text.Contains("No results match your search criteria"))
{
HttpContext.Current.Session["Nodata_GAFayette"] = "Yes";
driver.Quit();
return("No Data Found");
}
}
catch { }
//Property Details
IWebElement PropertyTB = driver.FindElement(By.XPath("//*[@id='ctlBodyPane_ctl00_mSection']/div/table[1]/tbody"));
IList <IWebElement> PropertyTR = PropertyTB.FindElements(By.TagName("tr"));
IList <IWebElement> PropertyTD;
foreach (IWebElement Property in PropertyTR)
{
PropertyTD = Property.FindElements(By.TagName("td"));
if (PropertyTD.Count != 0)
{
Par = PropertyTD[0].Text;
if (Par.Contains("Parcel Number"))
{
Parcel_ID = PropertyTD[1].Text;
}
Loc = PropertyTD[0].Text;
if (Loc.Contains("Location Address"))
{
Location = PropertyTD[1].Text;
}
Lg_Des = PropertyTD[0].Text;
if (Lg_Des.Contains("Legal Description"))
{
Legal = PropertyTD[1].Text;
}
Pro_Cls = PropertyTD[0].Text;
if (Pro_Cls.Contains("Property Class"))
{
Property_Class = PropertyTD[1].Text;
}
Nhg = PropertyTD[0].Text;
if (Nhg.Contains("Neighborhood"))
{
Nighbrhod = PropertyTD[1].Text;
}
tx_Dis = PropertyTD[0].Text;
if (tx_Dis.Contains("Tax District"))
{
Tax_Dis = PropertyTD[1].Text;
}
Zone = PropertyTD[0].Text;
if (Zone.Contains("Zoning"))
{
Zoing = PropertyTD[1].Text;
}
Acrs = PropertyTD[0].Text;
if (Acrs.Contains("Acres"))
{
Acres = PropertyTD[1].Text;
}
Home = PropertyTD[0].Text;
if (Home.Contains("Homestead"))
{
Homestd = PropertyTD[1].Text;
}
Exemp = PropertyTD[0].Text;
if (Exemp.Contains("Exemptions"))
{
Exemption = PropertyTD[1].Text;
}
}
}
try
{
Owner1 = driver.FindElement(By.XPath("//*[@id='ctlBodyPane_ctl01_ctl01_lnkOwnerName1_lblSearch']")).Text;
Owner2 = driver.FindElement(By.Id("ctlBodyPane_ctl01_ctl01_lblOwnerName2")).Text;
Mailing_Address1 = driver.FindElement(By.Id("ctlBodyPane_ctl01_ctl01_lblAddress1")).Text;
Mailing_Address2 = driver.FindElement(By.Id("ctlBodyPane_ctl01_ctl01_lblCityStZip")).Text;
Overall_OwnMailAdd = Owner1 + " " + Owner2 + " & " + Mailing_Address1 + " " + Mailing_Address2;
}
catch
{ }
try
{
Owner1 = driver.FindElement(By.XPath("//*[@id='ctlBodyPane_ctl01_ctl01_lnkOwnerName1_lblSearch']")).Text;
Mailing_Address1 = driver.FindElement(By.Id("ctlBodyPane_ctl01_ctl01_lblAddress1")).Text;
Mailing_Address2 = driver.FindElement(By.Id("ctlBodyPane_ctl01_ctl01_lblCityStZip")).Text;
Overall_OwnMailAdd = Owner1 + " & " + Mailing_Address1 + " " + Mailing_Address2;
}
catch
{ }
try
{
Owner1 = driver.FindElement(By.XPath("//*[@id='ctlBodyPane_ctl01_ctl01_lnkOwnerName1_lnkSearch']")).Text;
Mailing_Address1 = driver.FindElement(By.Id("ctlBodyPane_ctl01_ctl01_lblAddress1")).Text;
Mailing_Address2 = driver.FindElement(By.Id("ctlBodyPane_ctl01_ctl01_lblCityStZip")).Text;
Overall_OwnMailAdd = Owner1 + " & " + Mailing_Address1 + " " + Mailing_Address2;
}
catch
{ }
try
{
IWebElement Yeartb = driver.FindElement(By.XPath("//*[@id='ctlBodyPane_ctl04_mSection']/div/div/div[1]/table/tbody"));
IList <IWebElement> YearTR = Yeartb.FindElements(By.TagName("tr"));
IList <IWebElement> YearTD;
foreach (IWebElement Tax4 in YearTR)
{
YearTD = Tax4.FindElements(By.TagName("td"));
if (YearTD.Count != 0)
{
yblt = YearTD[0].Text;
if (yblt.Contains("Year Built"))
{
Year_Built = YearTD[1].Text;
}
}
}
}
catch
{ }
property = Location + "~" + Legal + "~" + Property_Class + "~" + Nighbrhod + "~" + Tax_Dis + "~" + Zoing + "~" + Acres + "~" + Homestd + "~" + Exemption + "~" + Overall_OwnMailAdd + "~" + Year_Built;
gc.CreatePdf(orderNumber, Parcel_ID, "Property Details", driver, "GA", "Fayette");
gc.insert_date(orderNumber, Parcel_ID, 785, property, 1, DateTime.Now);
//Assessment Details
IWebElement AssmThTb = driver.FindElement(By.XPath("//*[@id='ctlBodyPane_ctl02_ctl01_grdValuation']/thead"));
IList <IWebElement> AssmThTr = AssmThTb.FindElements(By.TagName("tr"));
IList <IWebElement> AssmTh;
foreach (IWebElement Assm in AssmThTr)
{
AssmTh = Assm.FindElements(By.TagName("th"));
if (AssmTh.Count != 0)
{
Year1 = AssmTh[0].Text;
Year2 = AssmTh[1].Text;
Year3 = AssmTh[2].Text;
Year4 = AssmTh[3].Text;
}
}
IWebElement AssmTb = driver.FindElement(By.XPath("//*[@id='ctlBodyPane_ctl02_ctl01_grdValuation']/tbody"));
IList <IWebElement> AssmTr = AssmTb.FindElements(By.TagName("tr"));
IList <IWebElement> AssmTd;
int j = 0;
List <string> LUC = new List <string>();
List <string> Class = new List <string>();
List <string> Land_Value = new List <string>();
List <string> Build_Value = new List <string>();
List <string> Total_Value = new List <string>();
List <string> Assed_Value = new List <string>();
foreach (IWebElement Assmrow in AssmTr)
{
AssmTd = Assmrow.FindElements(By.TagName("td"));
if (AssmTd.Count != 0)
{
if (j == 0)
{
LUC.Add(AssmTd[2].Text);
LUC.Add(AssmTd[3].Text);
LUC.Add(AssmTd[4].Text);
LUC.Add(AssmTd[5].Text);
}
else if (j == 1)
{
Class.Add(AssmTd[2].Text);
Class.Add(AssmTd[3].Text);
Class.Add(AssmTd[4].Text);
Class.Add(AssmTd[5].Text);
}
else if (j == 2)
{
Land_Value.Add(AssmTd[2].Text);
Land_Value.Add(AssmTd[3].Text);
Land_Value.Add(AssmTd[4].Text);
Land_Value.Add(AssmTd[5].Text);
}
else if (j == 3)
{
Build_Value.Add(AssmTd[2].Text);
Build_Value.Add(AssmTd[3].Text);
Build_Value.Add(AssmTd[4].Text);
Build_Value.Add(AssmTd[5].Text);
}
else if (j == 4)
{
Total_Value.Add(AssmTd[2].Text);
Total_Value.Add(AssmTd[3].Text);
Total_Value.Add(AssmTd[4].Text);
Total_Value.Add(AssmTd[5].Text);
}
else if (j == 6)
{
Assed_Value.Add(AssmTd[2].Text);
Assed_Value.Add(AssmTd[3].Text);
Assed_Value.Add(AssmTd[4].Text);
Assed_Value.Add(AssmTd[5].Text);
}
j++;
}
}
Assemnt_Details1 = Year1 + "~" + LUC[0] + "~" + Class[0] + "~" + Land_Value[0] + "~" + Build_Value[0] + "~" + Total_Value[0] + "~" + Assed_Value[0];
Assemnt_Details2 = Year2 + "~" + LUC[1] + "~" + Class[1] + "~" + Land_Value[1] + "~" + Build_Value[1] + "~" + Total_Value[1] + "~" + Assed_Value[1];
Assemnt_Details3 = Year3 + "~" + LUC[2] + "~" + Class[2] + "~" + Land_Value[2] + "~" + Build_Value[2] + "~" + Total_Value[2] + "~" + Assed_Value[2];
Assemnt_Details4 = Year4 + "~" + LUC[3] + "~" + Class[3] + "~" + Land_Value[3] + "~" + Build_Value[3] + "~" + Total_Value[3] + "~" + Assed_Value[3];
gc.insert_date(orderNumber, Parcel_ID, 791, Assemnt_Details1, 1, DateTime.Now);
gc.insert_date(orderNumber, Parcel_ID, 791, Assemnt_Details2, 1, DateTime.Now);
gc.insert_date(orderNumber, Parcel_ID, 791, Assemnt_Details3, 1, DateTime.Now);
gc.insert_date(orderNumber, Parcel_ID, 791, Assemnt_Details4, 1, DateTime.Now);
AssessmentTime = DateTime.Now.ToString("HH:mm:ss");
try
{
//Tax Details
driver.Navigate().GoToUrl("http://www.fayettecountytaxcomm.com/taxbillsearch.aspx");
driver.FindElement(By.Id("Body_MapParcelID1")).SendKeys(Parcel_ID);
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_ID, "Tax Parcel Search", driver, "GA", "Fayette");
driver.FindElement(By.Id("Body_MapParcelIDGo")).SendKeys(Keys.Enter);
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_ID, "Tax Site", driver, "GA", "Fayette");
driver.FindElement(By.XPath("//*[@id='Body_GridView1']/tbody/tr[2]/td[1]/a")).Click();
Thread.Sleep(2000);
driver.SwitchTo().Window(driver.WindowHandles.Last());
Thread.Sleep(3000);
//Tax Payment Details
try
{
IWebElement TaxPaymentTB = driver.FindElement(By.XPath("//*[@id='Body_GridView1']/tbody"));
IList <IWebElement> TaxPaymentTR = TaxPaymentTB.FindElements(By.TagName("tr"));
IList <IWebElement> TaxPaymentTD;
foreach (IWebElement TaxPayment in TaxPaymentTR)
{
TaxPaymentTD = TaxPayment.FindElements(By.TagName("td"));
if (TaxPaymentTD.Count != 0 && !TaxPayment.Text.Contains("Year"))
{
Tax_year = TaxPaymentTD[0].Text;
Tax_Bill = TaxPaymentTD[1].Text;
Balnce_Due = TaxPaymentTD[2].Text;
TaxPayment_details = Tax_year + "~" + Tax_Bill + "~" + Balnce_Due;
gc.CreatePdf(orderNumber, Parcel_ID, "Tax Payment Details", driver, "GA", "Fayette");
gc.insert_date(orderNumber, Parcel_ID, 792, TaxPayment_details, 1, DateTime.Now);
}
}
}
catch
{ }
try
{
IWebElement Tax2TB = driver.FindElement(By.XPath("//*[@id='form1']/div[3]/div/table/tbody"));
IList <IWebElement> Tax2TR = Tax2TB.FindElements(By.TagName("tr"));
IList <IWebElement> Tax2TD;
foreach (IWebElement Tax2 in Tax2TR)
{
Tax2TD = Tax2.FindElements(By.TagName("td"));
if (Tax2TD.Count != 0)
{
total = Tax2TD[0].Text;
if (total.Contains("Total Payments Pending:"))
{
Total_Payments = Tax2TD[1].Text;
}
Convey = Tax2TD[0].Text;
if (Convey.Contains("Convenience Fee:"))
{
Convey_Fee = Tax2TD[1].Text;
}
Paid = Tax2TD[0].Text;
if (Paid.Contains("Total Amount to be paid:"))
{
Total_Paid = Tax2TD[1].Text;
}
}
}
TaxPayment_details1 = "" + "~" + "" + "~" + "" + "~" + Total_Payments + "~" + Convey_Fee + "~" + Total_Paid;
gc.insert_date(orderNumber, Parcel_ID, 792, TaxPayment_details1, 1, DateTime.Now);
}
catch
{ }
//Tax Info Details
List <string> TaxInfoSearch = new List <string>();
IWebElement TaxInfoTB = driver.FindElement(By.XPath("//*[@id='Body_GridView1']/tbody"));
IList <IWebElement> TaxInfoTR = TaxInfoTB.FindElements(By.TagName("tr"));
TaxInfoTR.Reverse();
int rows_count = TaxInfoTR.Count;
for (int row = 0; row < rows_count; row++)
{
if (row == rows_count - 1 || row == rows_count - 2 || row == rows_count - 3)
{
IList <IWebElement> Columns_row = TaxInfoTR[row].FindElements(By.TagName("td"));
int columns_count = Columns_row.Count;
for (int column = 0; column < columns_count; column++)
{
if (column == columns_count - 2)
{
IWebElement ParcelBill_link = Columns_row[1].FindElement(By.TagName("a"));
string Parcelurl = ParcelBill_link.GetAttribute("href");
TaxInfoSearch.Add(Parcelurl);
}
}
}
}
foreach (string TaxInfobill in TaxInfoSearch)
{
driver.Navigate().GoToUrl(TaxInfobill);
Thread.Sleep(3000);
driver.SwitchTo().Window(driver.WindowHandles.Last());
Thread.Sleep(2000);
try
{
Taxy = driver.FindElement(By.Id("PropertyTaxLabel")).Text;
Taxy = WebDriverTest.Before(Taxy, " Property Tax Statement");
Total_DUE = driver.FindElement(By.Id("TotalDueTopText")).Text;
Last_PAYDATE = driver.FindElement(By.Id("LastPaymentTopText")).Text;
Last_PAYDATE = WebDriverTest.After(Last_PAYDATE, "Last payment made on: ");
}
catch
{ }
try
{
IWebElement IntrestTB = driver.FindElement(By.XPath("//*[@id='TaxPayerInfo']/tbody"));
IList <IWebElement> IntrestTR = IntrestTB.FindElements(By.TagName("tr"));
IList <IWebElement> IntrestTD;
foreach (IWebElement Intrest in IntrestTR)
{
IntrestTD = Intrest.FindElements(By.TagName("td"));
if (IntrestTD.Count != 0)
{
Tax_P = IntrestTD[0].Text;
if (Tax_P.Contains("Tax Payer:"))
{
Tax_Payer = IntrestTD[1].Text;
}
Map = IntrestTD[0].Text;
if (Map.Contains("Map Code:"))
{
Map_Code = IntrestTD[1].Text;
}
Desk = IntrestTD[0].Text;
if (Desk.Contains("Description:"))
{
Desk_Pro = IntrestTD[1].Text;
}
Locy = IntrestTD[0].Text;
if (Locy.Contains("Location:"))
{
Tax_Location = IntrestTD[1].Text;
}
Bl_No = IntrestTD[0].Text;
if (Bl_No.Contains("Bill No:"))
{
Tax_Billno = IntrestTD[1].Text;
}
Disti = IntrestTD[0].Text;
if (Disti.Contains("District:"))
{
Tax_Dist = IntrestTD[1].Text;
}
}
}
}
catch
{ }
try
{
IWebElement CinfoTB = driver.FindElement(By.XPath("//*[@id='BottomTable']/tbody"));
IList <IWebElement> CinfoTR = CinfoTB.FindElements(By.TagName("tr"));
IList <IWebElement> CinfoTD;
foreach (IWebElement Cinfo in CinfoTR)
{
CinfoTD = Cinfo.FindElements(By.TagName("td"));
if (CinfoTD.Count != 0 && !Cinfo.Text.Contains("Building Value") && Cinfo.Text != "")
{
Build_Val = CinfoTD[0].Text;
Land_Val = CinfoTD[1].Text;
Tax_Acres = CinfoTD[2].Text;
FrMkt_Val = CinfoTD[3].Text;
Tax_DueDate = CinfoTD[4].Text;
Tax_Exmpions = CinfoTD[7].Text;
}
}
}
catch
{ }
gc.CreatePdf(orderNumber, Parcel_ID, "Tax Info Details" + " " + Taxy, driver, "GA", "Fayette");
TaxInfo_Details = Taxy + "~" + Tax_Payer + "~" + Map_Code + "~" + Desk_Pro + "~" + Tax_Location + "~" + Tax_Billno + "~" + Tax_Dist + "~" + Last_PAYDATE + "~" + Build_Val + "~" + Land_Val + "~" + Tax_Acres + "~" + FrMkt_Val + "~" + Tax_Exmpions + "~" + Tax_DueDate + "~" + Total_DUE;
gc.insert_date(orderNumber, Parcel_ID, 793, TaxInfo_Details, 1, DateTime.Now);
Tax_Payer = ""; Map_Code = ""; Desk_Pro = ""; Tax_Location = ""; Tax_Billno = ""; Tax_Dist = ""; Last_PAYDATE = ""; Build_Val = ""; Land_Val = ""; Tax_Acres = ""; FrMkt_Val = ""; Tax_Exmpions = ""; Tax_DueDate = ""; Total_DUE = "";
try
{
IWebElement DueTaxTB = driver.FindElement(By.XPath("//*[@id='CurrentDueTable']/tbody"));
IList <IWebElement> DueTaxTR = DueTaxTB.FindElements(By.TagName("tr"));
IList <IWebElement> DueTaxTD;
foreach (IWebElement DueTax in DueTaxTR)
{
DueTaxTD = DueTax.FindElements(By.TagName("td"));
if (DueTaxTD.Count != 0 && DueTaxTD.Count != 1 && DueTaxTD.Count != 8 && DueTaxTD.Count != 9)
{
Cu_Du = DueTaxTD[1].Text;
if (Cu_Du.Contains("Current Due"))
{
Cur_Due = DueTaxTD[2].Text;
}
Penalt = DueTaxTD[1].Text;
if (Penalt.Contains("Penalty"))
{
Tax_Penalty = DueTaxTD[2].Text;
}
In_Tx = DueTaxTD[1].Text;
if (In_Tx.Contains("Interest"))
{
Int_Rest = DueTaxTD[2].Text;
}
Oth_Fe = DueTaxTD[1].Text;
if (Oth_Fe.Contains("Other Fees"))
{
Other_Fees = DueTaxTD[2].Text;
}
Pre_Pay = DueTaxTD[1].Text;
if (Pre_Pay.Contains("Previous Payments"))
{
Previous_Payments = DueTaxTD[2].Text;
}
Bc_Tx = DueTaxTD[1].Text;
if (Bc_Tx.Contains("Back Taxes"))
{
Back_Taxes = DueTaxTD[2].Text;
}
Tl_Du = DueTaxTD[1].Text;
if (Tl_Du.Contains("Total Due"))
{
TaxToal_Due = DueTaxTD[2].Text;
}
}
}
DueTaxInfo_Details = Taxy + "~" + Cur_Due + "~" + Tax_Penalty + "~" + Int_Rest + "~" + Other_Fees + "~" + Previous_Payments + "~" + Back_Taxes + "~" + TaxToal_Due;
gc.insert_date(orderNumber, Parcel_ID, 802, DueTaxInfo_Details, 1, DateTime.Now);
}
catch
{ }
try
{
IWebElement CityTaxPaymentTB = driver.FindElement(By.XPath("//*[@id='EntityTable']/tbody"));
IList <IWebElement> CityTaxPaymentTR = CityTaxPaymentTB.FindElements(By.TagName("tr"));
IList <IWebElement> CityTaxPaymentTD;
foreach (IWebElement CityTaxPayment in CityTaxPaymentTR)
{
CityTaxPaymentTD = CityTaxPayment.FindElements(By.TagName("td"));
if (CityTaxPaymentTD.Count != 0 && !CityTaxPayment.Text.Contains("Entity") && !CityTaxPayment.Text.Contains("Totals: "))
{
Entity = CityTaxPaymentTD[0].Text;
FMV = CityTaxPaymentTD[1].Text;
Net_Assmnt = CityTaxPaymentTD[2].Text;
Exmpl = CityTaxPaymentTD[3].Text;
Taxble_Value = CityTaxPaymentTD[4].Text;
Millage_Rate = CityTaxPaymentTD[5].Text;
Grs_Tax = CityTaxPaymentTD[6].Text;
Cretit = CityTaxPaymentTD[7].Text;
NetTax = CityTaxPaymentTD[8].Text;
CityPayment_details = Entity + "~" + FMV + "~" + Net_Assmnt + "~" + Exmpl + "~" + Taxble_Value + "~" + Millage_Rate + "~" + Grs_Tax + "~" + Cretit + "~" + NetTax;
gc.insert_date(orderNumber, Parcel_ID, 803, CityPayment_details, 1, DateTime.Now);
}
}
}
catch
{ }
try
{
IWebElement CityTaxPaymentTB1 = driver.FindElement(By.XPath("//*[@id='EntityTable']/tbody"));
IList <IWebElement> CityTaxPaymentTR1 = CityTaxPaymentTB1.FindElements(By.TagName("tr"));
IList <IWebElement> CityTaxPaymentTD1;
foreach (IWebElement CityTaxPayment1 in CityTaxPaymentTR1)
{
CityTaxPaymentTD1 = CityTaxPayment1.FindElements(By.TagName("td"));
if (CityTaxPaymentTD1.Count != 0 && CityTaxPayment1.Text.Contains("Totals: "))
{
Taxble_Value1 = CityTaxPaymentTD1[0].Text;
Millage_Rate1 = CityTaxPaymentTD1[1].Text;
Grs_Tax1 = CityTaxPaymentTD1[2].Text;
Cretit1 = CityTaxPaymentTD1[3].Text;
NetTax1 = CityTaxPaymentTD1[4].Text;
CityPayment_details = "" + "~" + "" + "~" + "" + "~" + "" + "~" + Taxble_Value1 + "~" + Millage_Rate1 + "~" + Grs_Tax1 + "~" + Cretit1 + "~" + NetTax1;
gc.insert_date(orderNumber, Parcel_ID, 803, CityPayment_details, 1, DateTime.Now);
}
}
}
catch
{ }
}
}
catch
{ }
//Tax Avthority
driver.Navigate().GoToUrl("http://www.fayettecountytaxcomm.com/");
Thread.Sleep(2000);
Tax_Auth1 = driver.FindElement(By.XPath("/html/body/div/table/tbody/tr[3]/td[3]/p[19]")).Text.Replace("Suite 109 (Motor Vehicles)", "");
Tax_Auth2 = driver.FindElement(By.XPath("/html/body/div/table/tbody/tr[3]/td[3]/p[15]")).Text;
Tax_Authotiry = Tax_Auth1 + " & " + Tax_Auth2;
TaxAuthority_Details = Tax_Authotiry;
gc.CreatePdf(orderNumber, Parcel_ID, "Tax Authority Details", driver, "GA", "Fayette");
gc.insert_date(orderNumber, Parcel_ID, 804, TaxAuthority_Details, 1, DateTime.Now);
TaxTime = DateTime.Now.ToString("HH:mm:ss");
LastEndTime = DateTime.Now.ToString("HH:mm:ss");
gc.insert_TakenTime(orderNumber, "GA", "Fayette", StartTime, AssessmentTime, TaxTime, CitytaxTime, LastEndTime);
driver.Quit();
gc.mergpdf(orderNumber, "GA", "Fayette");
return("Data Inserted Successfully");
}
catch (Exception ex)
{
driver.Quit();
GlobalClass.LogError(ex, orderNumber);
throw;
}
}
}
public string FTP_TNHamilton(string houseno, string sname, string sttype, string accno, string parcelNumber, string searchType, string orderNumber, string ownername, string directParcel, string unitno)
{
GlobalClass.global_orderNo = orderNumber;
HttpContext.Current.Session["orderNo"] = orderNumber;
GlobalClass.global_parcelNo = parcelNumber;
string StartTime = "", AssessmentTime = "", TaxTime = "", CitytaxTime = "", LastEndTime = "";
var driverService = PhantomJSDriverService.CreateDefaultService();
driverService.HideCommandPromptWindow = true;
using (driver = new PhantomJSDriver())
{
//driver = new ChromeDriver();
try
{
StartTime = DateTime.Now.ToString("HH:mm:ss");
if (searchType == "titleflex")
{
string address = houseno + " " + sname + " " + unitno;
gc.TitleFlexSearch(orderNumber, parcelNumber, "", address, "TN", "Hamilton");
if ((HttpContext.Current.Session["TitleFlex_Search"] != null && HttpContext.Current.Session["TitleFlex_Search"].ToString() == "Yes"))
{
driver.Quit();
return("MultiParcel");
}
else if (HttpContext.Current.Session["titleparcel"].ToString() == "")
{
HttpContext.Current.Session["Nodata_TNHamilton"] = "Yes";
driver.Quit();
return("No Data Found");
}
parcelNumber = HttpContext.Current.Session["titleparcel"].ToString();
searchType = "parcel";
}
if (searchType == "address")
{
driver.Navigate().GoToUrl("http://assessor.hamiltontn.gov/search.aspx");
Thread.Sleep(2000);
driver.FindElement(By.Id("SearchStreetName")).SendKeys(sname);
driver.FindElement(By.Id("SearchStreetNumber")).SendKeys(houseno);
driver.FindElement(By.Id("cmdGo")).SendKeys(Keys.Enter);
Thread.Sleep(2000);
gc.CreatePdf_WOP(orderNumber, "Address search", driver, "TN", "Hamilton");
IWebElement MultiAddressTB = driver.FindElement(By.XPath("//*[@id='T1']/tbody"));
IList <IWebElement> MultiAddressTR = MultiAddressTB.FindElements(By.TagName("tr"));
IList <IWebElement> MultiAddressTD;
if (MultiAddressTR.Count == 1)
{
driver.FindElement(By.XPath("//*[@id='T1']/tbody/tr/td[1]/a")).Click();
Thread.Sleep(2000);
}
else
{
int AddressmaxCheck = 0;
foreach (IWebElement MultiAddress in MultiAddressTR)
{
if (AddressmaxCheck <= 25)
{
MultiAddressTD = MultiAddress.FindElements(By.TagName("td"));
if (MultiAddressTD.Count != 0)
{
Parcelno = MultiAddressTD[0].Text;
Location = MultiAddressTD[1].Text;
Owner = MultiAddressTD[2].Text;
MultiAddress_details = Location + "~" + Owner;
gc.insert_date(orderNumber, Parcelno, 764, MultiAddress_details, 1, DateTime.Now);
}
AddressmaxCheck++;
}
}
if (MultiAddressTR.Count > 25)
{
HttpContext.Current.Session["multiParcel_TNHamilton_Multicount"] = "Maximum";
}
else
{
HttpContext.Current.Session["multiparcel_TNHamilton"] = "Yes";
}
driver.Quit();
return("MultiParcel");
}
try
{
//No Data Found
string nodata = driver.FindElement(By.XPath("//*[@id='body']/div[3]")).Text;
if (nodata.Contains("No results found!"))
{
HttpContext.Current.Session["Nodata_TNHamilton"] = "Yes";
driver.Quit();
return("No Data Found");
}
}
catch { }
}
if (searchType == "parcel")
{
driver.Navigate().GoToUrl("http://assessor.hamiltontn.gov/search.aspx");
Thread.Sleep(2000);
if (parcelNumber.Contains("-") || parcelNumber.Contains(" ") || parcelNumber.Contains("."))
{
parcelNumber = parcelNumber.Replace("-", "").Replace(" ", "").Replace(".", "");
}
string CommonParcel = parcelNumber;
if (CommonParcel.Length == 8)
{
string a = parcelNumber.Substring(0, 4);
string b = parcelNumber.Substring(4, 1);
string c = parcelNumber.Substring(5, 3);
parcelNumber = a + " " + b + " " + c;
}
if (CommonParcel.Length == 6)
{
string g = parcelNumber.Substring(0, 3);
string h = parcelNumber.Substring(3, 3);
parcelNumber = g + " " + h;
}
if (CommonParcel.Length == 13)
{
string d = parcelNumber.Substring(0, 4);
string e = parcelNumber.Substring(5, 1);
string f = parcelNumber.Substring(6, 3);
parcelNumber = d + " " + e + " " + f;
}
driver.FindElement(By.Id("SearchParcel")).SendKeys(parcelNumber);
driver.FindElement(By.Id("cmdGo")).SendKeys(Keys.Enter);
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, parcelNumber, "ParcelSearch", driver, "TN", "Hamilton");
driver.FindElement(By.XPath("//*[@id='T1']/tbody/tr/td[1]/a")).Click();
Thread.Sleep(2000);
}
if (searchType == "ownername")
{
driver.Navigate().GoToUrl("http://assessor.hamiltontn.gov/search.aspx");
Thread.Sleep(2000);
driver.FindElement(By.Id("SearchOwner")).SendKeys(ownername);
driver.FindElement(By.Id("cmdGo")).SendKeys(Keys.Enter);
Thread.Sleep(2000);
gc.CreatePdf_WOP(orderNumber, "Owner search", driver, "TN", "Hamilton");
IWebElement MultiOwnerTB = driver.FindElement(By.XPath("//*[@id='T1']/tbody"));
IList <IWebElement> MultiOwnerTR = MultiOwnerTB.FindElements(By.TagName("tr"));
IList <IWebElement> MultiOwnerTD;
if (MultiOwnerTR.Count == 1)
{
driver.FindElement(By.XPath("//*[@id='T1']/tbody/tr/td[1]/a")).Click();
Thread.Sleep(2000);
}
else
{
int AddressmaxCheck = 0;
foreach (IWebElement MultiOwner in MultiOwnerTR)
{
if (AddressmaxCheck <= 25)
{
MultiOwnerTD = MultiOwner.FindElements(By.TagName("td"));
if (MultiOwnerTD.Count != 0)
{
Parcelno = MultiOwnerTD[0].Text;
Location = MultiOwnerTD[1].Text;
Owner = MultiOwnerTD[2].Text;
MultiOwner_details = Location + "~" + Owner;
gc.insert_date(orderNumber, Parcelno, 764, MultiOwner_details, 1, DateTime.Now);
}
AddressmaxCheck++;
}
}
if (MultiOwnerTR.Count > 25)
{
HttpContext.Current.Session["multiParcel_TNHamilton_Multicount"] = "Maximum";
}
else
{
HttpContext.Current.Session["multiparcel_TNHamilton"] = "Yes";
}
driver.Quit();
return("MultiParcel");
}
try
{
//No Data Found
string nodata = driver.FindElement(By.XPath("//*[@id='body']/div[3]")).Text;
if (nodata.Contains("No results found!"))
{
HttpContext.Current.Session["Nodata_TNHamilton"] = "Yes";
driver.Quit();
return("No Data Found");
}
}
catch { }
}
//Property Details
try
{
Property_Address = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[1]/tbody/tr[1]/td[1]/div/div")).Text;
Account_No = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[1]/tbody/tr[1]/td[2]/div/div")).Text;
Parcel_ID = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[1]/tbody/tr[1]/td[3]/div/div")).Text;
Pro_Type = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[1]/tbody/tr[2]/td[1]/div/div")).Text;
Land_Use = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[1]/tbody/tr[2]/td[2]/div/div")).Text;
Dist = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[1]/tbody/tr[2]/td[3]/div/div")).Text;
Owner1 = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[2]/tbody/tr[2]/td/div/table/tbody/tr/td/table/tbody/tr[1]/td[2]/div")).Text;
Owner2 = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[2]/tbody/tr[2]/td/div/table/tbody/tr/td/table/tbody/tr[2]/td[2]/div")).Text;
Owners = Owner1 + " &" + Owner2;
Mailing1 = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[2]/tbody/tr[2]/td/div/table/tbody/tr/td/table/tbody/tr[3]/td[2]/div")).Text;
Mailing2 = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[2]/tbody/tr[2]/td/div/table/tbody/tr/td/table/tbody/tr[1]/td[4]/div")).Text;
Mailing3 = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[2]/tbody/tr[2]/td/div/table/tbody/tr/td/table/tbody/tr[2]/td[4]/div")).Text;
Mailing4 = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[2]/tbody/tr[2]/td/div/table/tbody/tr/td/table/tbody/tr[3]/td[4]/div")).Text;
Mailing_Address = Mailing1 + "," + Mailing2 + "," + Mailing3 + " " + Mailing4;
Year_Built = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[2]/tbody/tr[4]/td/div[2]/center/table/tbody/tr[2]/td/div/table/tbody/tr/td/div")).Text;
Year_Built = WebDriverTest.Between(Year_Built, "about ", " with");
Legal_Desp = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[2]/tbody/tr[4]/td/div[2]/center/table/tbody/tr[2]/td/font[2]/div[1]/center/table[2]/tbody/tr[2]/td/div/table/tbody/tr/td/div")).Text;
property = Account_No + "~" + Property_Address + "~" + Pro_Type + "~" + Land_Use + "~" + Dist + "~" + Owners + "~" + Mailing_Address + "~" + Year_Built + "~" + Legal_Desp;
gc.CreatePdf(orderNumber, Parcel_ID, "Property Details", driver, "TN", "Hamilton");
gc.insert_date(orderNumber, Parcel_ID, 766, property, 1, DateTime.Now);
}
catch
{ }
//Assessment Deatils
try
{
IWebElement tbmulti11 = driver.FindElement(By.XPath("//*[@id='body']/form/div[2]/table[2]/tbody/tr[4]/td/div[1]/center/table/tbody/tr[2]/td/div/table/tbody/tr/td/table/tbody"));
IList <IWebElement> TRmulti11 = tbmulti11.FindElements(By.TagName("tr"));
IList <IWebElement> TDmulti11;
foreach (IWebElement row in TRmulti11)
{
TDmulti11 = row.FindElements(By.TagName("td"));
if (TDmulti11.Count != 0)
{
Build = TDmulti11[0].Text;
if (Build.Contains("Building Value"))
{
Building_Value = TDmulti11[1].Text;
}
Xtra = TDmulti11[0].Text;
if (Xtra.Contains("Xtra Features Value"))
{
Xtra_Fetures_Value = TDmulti11[1].Text;
}
Land = TDmulti11[0].Text;
if (Land.Contains("Land Value"))
{
Land_Value = TDmulti11[1].Text;
}
tol = TDmulti11[0].Text;
if (tol.Contains("Total Value"))
{
Total_Value = TDmulti11[1].Text;
}
Assed = TDmulti11[0].Text;
if (Assed.Contains("Assessed Value"))
{
Assessed_Value = TDmulti11[1].Text;
}
}
}
Assessment = Building_Value + "~" + Xtra_Fetures_Value + "~" + Land_Value + "~" + Total_Value + "~" + Assessed_Value;
gc.insert_date(orderNumber, Parcel_ID, 767, Assessment, 1, DateTime.Now);
}
catch
{ }
//Tax Details
driver.Navigate().GoToUrl("http://tpti.hamiltontn.gov/AppFolder/Trustee_PropertySearch.aspx");
Thread.Sleep(2000);
driver.FindElement(By.Id("ctl00_MainContent_btnMGP")).Click();
Thread.Sleep(2000);
Parcel_ID = Parcel_ID.Replace("_", "");
if (Parcel_ID.Contains("."))
{
Parcel_ID = GlobalClass.Before(Parcel_ID, ".").Trim();
}
string com_Parcel = Parcel_ID;
if (com_Parcel.Length == 7)
{
Map = Parcel_ID.Substring(0, 4);
Parcel = Parcel_ID.Substring(4, 3);
}
if (com_Parcel.Length == 8)
{
Map = Parcel_ID.Substring(0, 4);
Group = Parcel_ID.Substring(4, 1);
Parcel = Parcel_ID.Substring(5, 3);
}
if (com_Parcel.Length == 9)
{
Map = Parcel_ID.Substring(0, 5);
Group = Parcel_ID.Substring(5, 1);
Parcel = Parcel_ID.Substring(6, 3);
}
driver.FindElement(By.Id("ctl00_MainContent_txtMap")).SendKeys(Map);
driver.FindElement(By.Id("ctl00_MainContent_txtGroup")).SendKeys(Group);
driver.FindElement(By.Id("ctl00_MainContent_txtParcel")).SendKeys(Parcel);
gc.CreatePdf(orderNumber, Parcel_ID, "Tax Parcel search", driver, "TN", "Hamilton");
driver.FindElement(By.Id("ctl00_MainContent_cmdMGP_Search")).SendKeys(Keys.Enter);
//County Tax History Details
try
{
IWebElement CountyTaxPaymentTB = driver.FindElement(By.XPath("//*[@id='ctl00_MainContent_dgrResults']/tbody"));
IList <IWebElement> CountyTaxPaymentTR = CountyTaxPaymentTB.FindElements(By.TagName("tr"));
IList <IWebElement> CountyTaxPaymentTD;
foreach (IWebElement CountyTaxPayment in CountyTaxPaymentTR)
{
CountyTaxPaymentTD = CountyTaxPayment.FindElements(By.TagName("td"));
if (CountyTaxPaymentTD.Count != 0 && !CountyTaxPayment.Text.Contains("Year"))
{
County_Taxyear = CountyTaxPaymentTD[1].Text;
Bill = CountyTaxPaymentTD[2].Text;
Bill_Type = CountyTaxPaymentTD[4].Text;
CPro_Type = CountyTaxPaymentTD[5].Text;
Own_name = CountyTaxPaymentTD[6].Text;
Tol_Due = CountyTaxPaymentTD[7].Text;
Status = CountyTaxPaymentTD[8].Text;
CountyPayment_details = County_Taxyear + "~" + Bill + "~" + Bill_Type + "~" + CPro_Type + "~" + Own_name + "~" + Tol_Due + "~" + Status;
gc.CreatePdf(orderNumber, Parcel_ID, "County Tax History Details", driver, "TN", "Hamilton");
gc.insert_date(orderNumber, Parcel_ID, 768, CountyPayment_details, 1, DateTime.Now);
}
}
}
catch
{ }
//County Tax Info Details
List <string> CountyInfoSearch = new List <string>();
try
{
IWebElement CityInfoTB = driver.FindElement(By.XPath("//*[@id='ctl00_MainContent_dgrResults']/tbody"));
IList <IWebElement> CityInfoTR = CityInfoTB.FindElements(By.TagName("tr"));
IList <IWebElement> CityInfoTD;
int i = 0;
foreach (IWebElement CityInfo in CityInfoTR)
{
if (!CityInfo.Text.Contains("Year"))
{
if (i == 1 || i == 2 || i == 3)
{
CityInfoTD = CityInfo.FindElements(By.TagName("td"));
IWebElement CityInfo_link = CityInfoTD[0].FindElement(By.TagName("a"));
string CityInfourl = CityInfo_link.GetAttribute("href");
CountyInfoSearch.Add(CityInfourl);
}
}
i++;
}
foreach (string CityInfobill in CountyInfoSearch)
{
driver.Navigate().GoToUrl(CityInfobill);
Thread.Sleep(5000);
driver.SwitchTo().Window(driver.WindowHandles.Last());
Thread.Sleep(3000);
//Tax Info
Flags = driver.FindElement(By.XPath("//*[@id='aspnetForm']/div[3]/table/tbody/tr[2]/td[2]/table/tbody/tr[5]/td/table/tbody/tr[1]/td[4]")).Text;
Tax_Distrct = driver.FindElement(By.XPath("//*[@id='aspnetForm']/div[3]/table/tbody/tr[2]/td[2]/table/tbody/tr[5]/td/table/tbody/tr[2]/td[2]")).Text;
Bil_type = driver.FindElement(By.XPath("//*[@id='aspnetForm']/div[3]/table/tbody/tr[2]/td[2]/table/tbody/tr[7]/td/table/tbody/tr[1]/td[2]")).Text;
TaxBil_type = driver.FindElement(By.XPath("//*[@id='aspnetForm']/div[3]/table/tbody/tr[2]/td[2]/table/tbody/tr[7]/td/table/tbody/tr[1]/td[4]")).Text;
Bil_Status = driver.FindElement(By.XPath("//*[@id='aspnetForm']/div[3]/table/tbody/tr[2]/td[2]/table/tbody/tr[7]/td/table/tbody/tr[2]/td[2]")).Text;
Bill_Hash = driver.FindElement(By.XPath("//*[@id='aspnetForm']/div[3]/table/tbody/tr[2]/td[2]/table/tbody/tr[7]/td/table/tbody/tr[2]/td[4]")).Text;
Tax_Assessment = driver.FindElement(By.XPath("//*[@id='aspnetForm']/div[3]/table/tbody/tr[2]/td[2]/table/tbody/tr[7]/td/table/tbody/tr[5]/td[2]")).Text;
IWebElement Tax3TB = driver.FindElement(By.XPath("//*[@id='ctl00_MainContent_dgrTrans']/tbody"));
IList <IWebElement> Tax3TR = Tax3TB.FindElements(By.TagName("tr"));
IList <IWebElement> Tax3TD;
foreach (IWebElement Tax3 in Tax3TR)
{
Tax3TD = Tax3.FindElements(By.TagName("td"));
if (Tax3TD.Count != 0 && !Tax3.Text.Contains("Date"))
{
Billing_Date = Tax3TD[0].Text;
Trns_type = Tax3TD[1].Text;
Fee_Type = Tax3TD[2].Text;
Bill_Amount = Tax3TD[4].Text;
}
}
try
{
IWebElement Tax4TB = driver.FindElement(By.XPath("//*[@id='ctl00_MainContent_dgrPayments']/tbody"));
IList <IWebElement> Tax4TR = Tax4TB.FindElements(By.TagName("tr"));
IList <IWebElement> Tax4TD;
foreach (IWebElement Tax4 in Tax4TR)
{
Tax4TD = Tax4.FindElements(By.TagName("td"));
if (Tax4TD.Count != 0 && !Tax4.Text.Contains("Date Paid"))
{
PayIfo_Date = Tax4TD[0].Text;
PayIfoTrns_type = Tax4TD[1].Text;
PayIfoFee_Type = Tax4TD[2].Text;
PayIfo_Amount = Tax4TD[3].Text;
}
}
}
catch
{ }
//Deliquent Details
try
{
IWebElement IntrestTB = driver.FindElement(By.XPath("//*[@id='ctl00_MainContent_lblIntAndFees']/table/tbody"));
IList <IWebElement> IntrestTR = IntrestTB.FindElements(By.TagName("tr"));
IList <IWebElement> IntrestTD;
foreach (IWebElement Intrest in IntrestTR)
{
IntrestTD = Intrest.FindElements(By.TagName("td"));
if (IntrestTD.Count != 0)
{
ints = IntrestTD[0].Text;
if (ints.Contains("Interest:"))
{
Deliq_Interest = IntrestTD[1].Text;
}
Court = IntrestTD[0].Text;
if (Court.Contains("Court Cost:"))
{
Deliq_CourtCost = IntrestTD[1].Text;
}
Att = IntrestTD[0].Text;
if (Att.Contains("Attorney's Fee:"))
{
Deliq_Attornys = IntrestTD[1].Text;
}
Clerk = IntrestTD[0].Text;
if (Clerk.Contains("Clerk Commission:"))
{
Deliq_Clerk = IntrestTD[1].Text;
}
TR = IntrestTD[0].Text;
if (TR.Contains("TR Costs:"))
{
Deliq_TR = IntrestTD[1].Text;
}
}
}
}
catch
{ }
IWebElement Tax2TB = driver.FindElement(By.XPath("//*[@id='ctl00_MainContent_pnlTotalDue']/table[1]/tbody/tr[1]/td/table/tbody"));
IList <IWebElement> Tax2TR = Tax2TB.FindElements(By.TagName("tr"));
IList <IWebElement> Tax2TD;
foreach (IWebElement Tax2 in Tax2TR)
{
Tax2TD = Tax2.FindElements(By.TagName("td"));
if (Tax2TD.Count != 0)
{
t_du = Tax2TD[0].Text;
if (t_du.Contains(" Total Due "))
{
Total_taxDue = Tax2TD[1].Text;
}
}
}
gc.CreatePdf(orderNumber, Parcel_ID, "Tax Details" + TaxBil_type, driver, "TN", "Hamilton");
try
{
Tax_Authority = driver.FindElement(By.XPath("//*[@id='ctl00_MainContent_pnlOurAddr']/table/tbody/tr/td/b")).Text;
}
catch
{ }
try
{
Tax_Authority = driver.FindElement(By.XPath("//*[@id='ctl00_MainContent_pnlDelQ']/table/tbody/tr/td/b")).Text;
}
catch
{ }
Tax_Deatils = Tax_Distrct + "~" + TaxBil_type + "~" + Flags + "~" + Bil_type + "~" + Bil_Status + "~" + Bill_Hash + "~" + Tax_Assessment + "~" + Billing_Date + "~" + Trns_type + "~" + Fee_Type + "~" + Bill_Amount + "~" + PayIfo_Date + "~" + PayIfoTrns_type + "~" + PayIfoFee_Type + "~" + PayIfo_Amount + "~" + Deliq_Interest + "~" + Deliq_CourtCost + "~" + Deliq_Attornys + "~" + Deliq_Clerk + "~" + Deliq_TR + "~" + Total_taxDue + "~" + Tax_Authority;
gc.insert_date(orderNumber, Parcel_ID, 769, Tax_Deatils, 1, DateTime.Now);
PayIfo_Date = ""; PayIfoTrns_type = ""; PayIfoFee_Type = ""; PayIfo_Amount = ""; Deliq_Interest = ""; Deliq_CourtCost = ""; Deliq_Attornys = ""; Deliq_Clerk = ""; Deliq_TR = ""; Total_taxDue = ""; Tax_Authority = "";
}
}
catch { }
TaxTime = DateTime.Now.ToString("HH:mm:ss");
if (Tax_Distrct == "Chattanooga (1)")
{
driver.Navigate().GoToUrl("http://propertytax.chattanooga.gov/component/ptaxweb/searchpage?field=mgp");
Thread.Sleep(2000);
City_map = Map.Replace(" ", "");
driver.FindElement(By.Id("filter_search_map")).SendKeys(City_map);
driver.FindElement(By.Id("filter_search_group")).SendKeys(Group);
driver.FindElement(By.Id("filter_search_parcel")).SendKeys(Parcel);
gc.CreatePdf(orderNumber, Parcel_ID, "City Parcel search", driver, "TN", "Hamilton");
driver.FindElement(By.XPath("//*[@id='content']/div[1]/form/div/div[2]/button")).SendKeys(Keys.Enter);
Thread.Sleep(2000);
driver.FindElement(By.XPath("//*[@id=\'content']/div/div[1]/form/table/tbody/tr/td[1]/a")).Click();
Thread.Sleep(2000);
//City Tax History Details
try
{
IWebElement CityTaxPaymentTB = driver.FindElement(By.XPath("//*[@id='content']/div/div[1]/form/table[2]/tbody"));
IList <IWebElement> CityTaxPaymentTR = CityTaxPaymentTB.FindElements(By.TagName("tr"));
IList <IWebElement> CityTaxPaymentTD;
foreach (IWebElement CityTaxPayment in CityTaxPaymentTR)
{
CityTaxPaymentTD = CityTaxPayment.FindElements(By.TagName("td"));
if (CityTaxPaymentTD.Count != 0 && !CityTaxPayment.Text.Contains("Year"))
{
City_Taxyear = CityTaxPaymentTD[1].Text;
City_Bill = CityTaxPaymentTD[2].Text;
CityBill_Type = CityTaxPaymentTD[3].Text;
CityPro_Type = CityTaxPaymentTD[4].Text;
CityOwn_name = CityTaxPaymentTD[5].Text;
CityTol_Due = CityTaxPaymentTD[6].Text;
CityStatus = CityTaxPaymentTD[7].Text;
CityPayment_details = City_Taxyear + "~" + City_Bill + "~" + CityBill_Type + "~" + CityPro_Type + "~" + CityOwn_name + "~" + CityTol_Due + "~" + CityStatus;
gc.CreatePdf(orderNumber, Parcel_ID, "CIty Tax History Details", driver, "TN", "Hamilton");
gc.insert_date(orderNumber, Parcel_ID, 770, CityPayment_details, 1, DateTime.Now);
}
}
}
catch
{ }
//City Info Details
List <string> CityInfoSearch = new List <string>();
try
{
IWebElement CityInfo1TB = driver.FindElement(By.XPath("//*[@id='content']/div/div[1]/form/table[2]/tbody"));
IList <IWebElement> CityInfo1TR = CityInfo1TB.FindElements(By.TagName("tr"));
IList <IWebElement> CityInfo1TD;
int i = 0;
foreach (IWebElement CityInfo1 in CityInfo1TR)
{
if (i == 0 || i == 1 || i == 2)
{
CityInfo1TD = CityInfo1.FindElements(By.TagName("td"));
IWebElement CityInfo1_link = CityInfo1TD[0].FindElement(By.TagName("a"));
string CityInfo1url = CityInfo1_link.GetAttribute("href");
CityInfoSearch.Add(CityInfo1url);
}
i++;
}
foreach (string CityInfobill1 in CityInfoSearch)
{
driver.Navigate().GoToUrl(CityInfobill1);
Thread.Sleep(5000);
driver.SwitchTo().Window(driver.WindowHandles.Last());
Thread.Sleep(3000);
City_Flags = driver.FindElement(By.XPath("//*[@id='ptaxweb-content']/table[1]/tbody/tr[1]/td[4]")).Text;
City_BillHash = driver.FindElement(By.XPath("//*[@id='ptaxweb-content']/table[2]/tbody/tr/td[2]")).Text;
City_Bil_type = driver.FindElement(By.XPath("//*[@id='ptaxweb-content']/table[3]/tbody/tr[1]/td[2]")).Text;
City_TaxBil_Year = driver.FindElement(By.XPath("//*[@id='ptaxweb-content']/table[3]/tbody/tr[1]/td[4]")).Text;
City_Bil_Status = driver.FindElement(By.XPath("//*[@id='ptaxweb-content']/table[3]/tbody/tr[2]/td[2]")).Text;
City_Assessment = driver.FindElement(By.XPath("//*[@id='ptaxweb-content']/table[3]/tbody/tr[4]/td[4]")).Text;
try
{
IWebElement Tax211TB = driver.FindElement(By.XPath("//*[@id='ptaxweb-content']/table[5]/tbody[2]"));
IList <IWebElement> Tax211TR = Tax211TB.FindElements(By.TagName("tr"));
IList <IWebElement> Tax211TD;
foreach (IWebElement Tax211 in Tax211TR)
{
Tax211TD = Tax211.FindElements(By.TagName("td"));
if (Tax211TD.Count != 0)
{
t_Inst = Tax211TD[0].Text;
if (t_Inst.Contains("Taxes & Interest"))
{
Tax_Instr = Tax211TD[1].Text;
}
t_Water = Tax211TD[0].Text;
if (t_Water.Contains("Water Quality Fee & Interest"))
{
Tax_Water = Tax211TD[1].Text;
}
}
}
}
catch
{ }
try
{
IWebElement Tax212TB = driver.FindElement(By.XPath("//*[@id='ptaxweb-content']/table[5]/tbody[2]"));
IList <IWebElement> Tax212TR = Tax212TB.FindElements(By.TagName("tr"));
IList <IWebElement> Tax212TD;
foreach (IWebElement Tax212 in Tax212TR)
{
Tax212TD = Tax212.FindElements(By.TagName("td"));
if (Tax212TD.Count != 0)
{
City_PaidDate = Tax212TD[0].Text;
City_PaidAmount = Tax212TD[1].Text;
}
}
}
catch
{ }
try
{
IWebElement Tax21TB = driver.FindElement(By.XPath("//*[@id='ptaxweb-content']/table[6]/tbody[2]"));
IList <IWebElement> Tax21TR = Tax21TB.FindElements(By.TagName("tr"));
IList <IWebElement> Tax21TD;
foreach (IWebElement Tax21 in Tax21TR)
{
Tax21TD = Tax21.FindElements(By.TagName("td"));
if (Tax21TD.Count != 0)
{
City_PaidDate = Tax21TD[0].Text;
City_PaidAmount = Tax21TD[1].Text;
}
}
}
catch
{ }
try
{
IWebElement Tax311TB = driver.FindElement(By.XPath("//*[@id='ptaxweb-content']/table[7]/tbody"));
IList <IWebElement> Tax311TR = Tax311TB.FindElements(By.TagName("tr"));
IList <IWebElement> Tax311TD;
foreach (IWebElement Tax311 in Tax311TR)
{
Tax311TD = Tax311.FindElements(By.TagName("td"));
if (Tax311TD.Count != 0)
{
tauth_Inst1 = Tax311TD[0].Text;
if (tauth_Inst.Contains("Total Due"))
{
City_TotalDue = Tax311TD[1].Text;
}
}
}
}
catch
{ }
try
{
IWebElement Tax311TB = driver.FindElement(By.XPath("//*[@id='ptaxweb-content']/table[8]/tbody"));
IList <IWebElement> Tax311TR = Tax311TB.FindElements(By.TagName("tr"));
IList <IWebElement> Tax311TD;
foreach (IWebElement Tax311 in Tax311TR)
{
Tax311TD = Tax311.FindElements(By.TagName("td"));
if (Tax311TD.Count != 0)
{
tauth_Inst = Tax311TD[0].Text;
if (tauth_Inst.Contains("Total Due"))
{
City_TotalDue = Tax311TD[1].Text;
}
}
}
}
catch
{ }
try
{
CityTax_Authority = driver.FindElement(By.XPath("//*[@id='ptaxweb-content']/table[6]/tbody/tr/td")).Text;
CityTax_Authority = WebDriverTest.After(CityTax_Authority, "MAKE CHECKS PAYABLE AND MAIL TO:");
}
catch
{ }
try
{
CityTax_Authority1 = driver.FindElement(By.XPath("//*[@id='ptaxweb-content']/table[7]/tbody/tr/td")).Text;
CityTax_Authority1 = WebDriverTest.After(CityTax_Authority1, "MAKE CHECKS PAYABLE AND MAIL TO:");
}
catch
{ }
CityTax_Deatils = City_Flags + "~" + City_BillHash + "~" + City_Bil_type + "~" + City_TaxBil_Year + "~" + City_Bil_Status + "~" + City_Assessment + "~" + City_PaidDate + "~" + City_PaidAmount + "~" + Tax_Instr + "~" + Tax_Water + "~" + City_TotalDue + "~" + CityTax_Authority + "~" + CityTax_Authority1;
gc.CreatePdf(orderNumber, Parcel_ID, "City Tax Details" + City_TaxBil_Year, driver, "TN", "Hamilton");
gc.insert_date(orderNumber, Parcel_ID, 771, CityTax_Deatils, 1, DateTime.Now);
City_PaidDate = ""; City_PaidAmount = ""; Tax_Instr = ""; Tax_Water = ""; City_TotalDue = "";
try
{
IWebElement CinfoTB = driver.FindElement(By.XPath("//*[@id='ptaxweb-content']/table[4]/tbody[2]"));
IList <IWebElement> CinfoTR = CinfoTB.FindElements(By.TagName("tr"));
IList <IWebElement> CinfoTD;
foreach (IWebElement Cinfo in CinfoTR)
{
CinfoTD = Cinfo.FindElements(By.TagName("td"));
if (CinfoTD.Count != 0)
{
Cinfo_Taxyear = CinfoTD[0].Text;
Cinfo_Transtype = CinfoTD[1].Text;
Cinfo_Feetype = CinfoTD[2].Text;
Cinfo_Amount = CinfoTD[3].Text;
Cinfo_details = Cinfo_Taxyear + "~" + Cinfo_Transtype + "~" + Cinfo_Feetype + "~" + Cinfo_Amount;
gc.insert_date(orderNumber, Parcel_ID, 772, Cinfo_details, 1, DateTime.Now);
}
}
}
catch
{ }
}
}
catch { }
}
CitytaxTime = DateTime.Now.ToString("HH:mm:ss");
LastEndTime = DateTime.Now.ToString("HH:mm:ss");
gc.insert_TakenTime(orderNumber, "TN", "Hamilton", StartTime, AssessmentTime, TaxTime, CitytaxTime, LastEndTime);
driver.Quit();
gc.mergpdf(orderNumber, "TN", "Hamilton");
return("Data Inserted Successfully");
}
catch (Exception ex)
{
driver.Quit();
GlobalClass.LogError(ex, orderNumber);
throw;
}
}
}