public string FTP_WoodOH(string streetno, string direction, string streettype, string streetname, string unitnumber, string ownernm, string parcelNumber, string searchType, string orderNumber, string directParcel)
{
GlobalClass.global_orderNo = orderNumber;
HttpContext.Current.Session["orderNo"] = orderNumber;
GlobalClass.global_parcelNo = parcelNumber;
List <string> taxinformation = new List <string>();
string StartTime = "", AssessmentTime = "", TaxTime = "", CitytaxTime = "", LastEndTime = "";
string Parcel_number = "", Tax_Authority = "", yearbuild = "", apprasiedresult = "", Addresshrf = "", Valuvationresult = "", Multiaddressadd = "", MailingAddress = "";
var driverService = PhantomJSDriverService.CreateDefaultService();
driverService.HideCommandPromptWindow = true;
//driver = new ChromeDriver();driver = new PhantomJSDriver()
using (driver = new PhantomJSDriver())
{
try
{
StartTime = DateTime.Now.ToString("HH:mm:ss");
driver.Navigate().GoToUrl("http://auditor.co.wood.oh.us/Search.aspx");
if (searchType == "address")
{
driver.FindElement(By.LinkText("Address")).Click();
driver.FindElement(By.Id("ContentPlaceHolder1_Address_tbAddressNumber")).SendKeys(streetno);
// driver.FindElement(By.Id("ContentPlaceHolder1_Address_tbAddressDirection")).SendKeys(direction);
driver.FindElement(By.Id("ContentPlaceHolder1_Address_tbAddressStreet")).SendKeys(streetname);
gc.CreatePdf_WOP(orderNumber, "SearchBefore", driver, "OH", "Wood");
driver.FindElement(By.Id("ContentPlaceHolder1_Address_btnSearchAddress")).Click();
Thread.Sleep(2000);
try
{
int Max = 0;
//*[@id="ContentPlaceHolder1_gvSearchResults"]/tbody
IWebElement Multiparceladdress = driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_gvSearchResults']/tbody"));
IList <IWebElement> Multiparcelrow = Multiparceladdress.FindElements(By.TagName("tr"));
IList <IWebElement> Multiparcelid;
gc.CreatePdf_WOP(orderNumber, "SearchAfter", driver, "OH", "Wood");
foreach (IWebElement multiparcel in Multiparcelrow)
{
Multiparcelid = multiparcel.FindElements(By.TagName("td"));
if (Multiparcelid.Count != 0)
{
Address1 = Multiparcelid[0].FindElement(By.TagName("a"));
Addresshrf = Address1.GetAttribute("href");
string Addressst = Address1.Text;
string Owner = Multiparcelid[1].Text;
string Pin = Multiparcelid[2].Text;
string Multiparcel = Pin + "~" + Owner;
gc.insert_date(orderNumber, Addressst, 1490, Multiparcel, 1, DateTime.Now);
Max++;
}
}
if (Max == 1)
{
Address1.Click();
Thread.Sleep(2000);
}
if (Max > 1 && Max < 26)
{
HttpContext.Current.Session["multiParcel_WoodOH"] = "Maximum";
driver.Quit();
return("MultiParcel");
}
if (Max > 25)
{
HttpContext.Current.Session["multiParcel_WoodOH_Multicount"] = "Maximum";
driver.Quit();
return("Maximum");
}
if (Max == 0)
{
HttpContext.Current.Session["Zero_WoodOH"] = "Zero";
driver.Quit();
return("Zero");
}
}
catch { }
}
if (searchType == "ownername")
{
string[] Ownarsplit = ownernm.Split(' ');
if (Ownarsplit.Length == 2)
{
string lastname = Ownarsplit[1];
string firstname = Ownarsplit[0];
driver.FindElement(By.Id("ContentPlaceHolder1_Owner_tbOwnerLastName")).SendKeys(firstname.Trim());
driver.FindElement(By.Id("ContentPlaceHolder1_Owner_tbOwnerFirstName")).SendKeys(lastname.Trim());
}
else
{
driver.FindElement(By.Id("ContentPlaceHolder1_Owner_tbOwnerLastName")).SendKeys(ownernm.Trim());
}
gc.CreatePdf_WOP(orderNumber, "Search Before", driver, "OH", "Wood");
driver.FindElement(By.Id("ContentPlaceHolder1_Owner_btnSearchOwner")).Click();
Thread.Sleep(2000);
try
{
int Max = 0;
IWebElement Multiparceladdress = driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_gvSearchResults']/tbody"));
IList <IWebElement> Multiparcelrow = Multiparceladdress.FindElements(By.TagName("tr"));
IList <IWebElement> Multiparcelid;
gc.CreatePdf_WOP(orderNumber, "SearchAfter", driver, "OH", "Wood");
foreach (IWebElement multiparcel in Multiparcelrow)
{
Multiparcelid = multiparcel.FindElements(By.TagName("td"));
if (Multiparcelid.Count != 0)
{
Address1 = Multiparcelid[0].FindElement(By.TagName("a"));
Addresshrf = Address1.GetAttribute("href");
string Addressst = Address1.Text;
string Owner = Multiparcelid[1].Text;
string Pin = Multiparcelid[2].Text;
string Multiparcel = Pin + "~" + Owner;
gc.insert_date(orderNumber, Addressst, 1490, Multiparcel, 1, DateTime.Now);
Max++;
}
}
if (Max == 1)
{
Address1.Click();
Thread.Sleep(2000);
}
if (Max > 1 && Max < 26)
{
HttpContext.Current.Session["multiParcel_WoodOH"] = "Yes";
driver.Quit();
return("MultiParcel");
}
if (Max > 25)
{
HttpContext.Current.Session["multiParcel_WoodOH_Multicount"] = "Maximum";
driver.Quit();
return("Maximum");
}
if (Max == 0)
{
HttpContext.Current.Session["Zero_WoodOH"] = "Zero";
driver.Quit();
return("Zero");
}
}
catch { }
try
{
string Noresult = driver.FindElement(By.Id("ContentPlaceHolder1_lblNumberOfResults")).Text;
if (Noresult.Trim() != "")
{
HttpContext.Current.Session["Zero_WoodOH"] = "Zero";
driver.Quit();
return("Zero");
}
}
catch { }
}
if (searchType == "parcel")
{
driver.FindElement(By.LinkText("Parcel")).Click();
Thread.Sleep(2000);
driver.FindElement(By.Id("ContentPlaceHolder1_Parcel_tbParcelNumber")).SendKeys(parcelNumber);
gc.CreatePdf(orderNumber, parcelNumber, "Parcel Before", driver, "OH", "Wood");
driver.FindElement(By.Id("ContentPlaceHolder1_Parcel_btnSearchParcel")).Click();
Thread.Sleep(2000);
try
{
int Max = 0;
IWebElement Multiparceladdress = driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_gvSearchResults']/tbody"));
IList <IWebElement> Multiparcelrow = Multiparceladdress.FindElements(By.TagName("tr"));
IList <IWebElement> Multiparcelid;
gc.CreatePdf(orderNumber, parcelNumber, "Parcel After", driver, "OH", "Wood");
foreach (IWebElement multiparcel in Multiparcelrow)
{
Multiparcelid = multiparcel.FindElements(By.TagName("td"));
if (Multiparcelid.Count != 0)
{
Address1 = Multiparcelid[0].FindElement(By.TagName("a"));
Addresshrf = Address1.GetAttribute("href");
string Addressst = Address1.Text;
string Owner = Multiparcelid[1].Text;
string Pin = Multiparcelid[2].Text;
string Multiparcel = Pin + "~" + Owner;
gc.insert_date(orderNumber, Addressst, 1434, Multiparcel, 1, DateTime.Now);
Max++;
}
}
if (Max == 1)
{
Address1.Click();
Thread.Sleep(2000);
}
if (Max > 1 && Max < 26)
{
HttpContext.Current.Session["multiParcel_WoodOH"] = "Yes";
driver.Quit();
return("MultiParcel");
}
if (Max > 25)
{
HttpContext.Current.Session["multiParcel_WoodOH_Multicount"] = "Maximum";
driver.Quit();
return("Maximum");
}
if (Max == 0)
{
HttpContext.Current.Session["Zero_WoodOH"] = "Zero";
driver.Quit();
return("Zero");
}
}
catch { }
}
try
{
//No Data Found
string nodata = driver.FindElement(By.Id("ContentPlaceHolder1_lblNumberOfResults")).Text;
if (nodata.Contains("No results"))
{
HttpContext.Current.Session["Zero_WoodOH"] = "Zero";
driver.Quit();
return("Zero");
}
}
catch { }
Parcel_number = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataProfile_ParcelLabel")).Text;
string Ownar = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataProfile_OwnerLabel")).Text;
string address = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataProfile_AddressLabel")).Text;
string mailname = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataMailingAddress_MailingAddressLine1Label")).Text;
string mailaddress = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataMailingAddress_MailingAddressLine2Label")).Text;
string mailcity = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataMailingAddress_MailingAddressLine3Label")).Text;
string mailingaddress = mailname + " " + mailaddress + " " + mailcity;
string city = driver.FindElement(By.Id("ContentPlaceHolder1_Base_FormView1_CityLabel")).Text;
string Township = driver.FindElement(By.Id("ContentPlaceHolder1_Base_FormView1_TownshipLabel")).Text;
string school = driver.FindElement(By.Id("ContentPlaceHolder1_Base_FormView1_SchoolDistrictLabel")).Text;
// string Taxdistient = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataGeographic_TaxDistrictLabel")).Text;
string LegalDescription = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_LegalDescriptionLabel")).Text;
string LegalAcres = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_TotalAcresLabel")).Text;
string LandUse = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_LandUseDescriptionLabel")).Text;
string AnnualTax = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_AnnualTaxLabel")).Text;
//string MapNumber = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_MapNumberLabel")).Text;
string HomesteadReduction = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_HomesteadReductionLabel")).Text;
string Reduction = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_Reduction25Label")).Text;
string RedictionHd = driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_Base_fvDataLegal']/tbody/tr/td/table/tbody/tr[2]/th[2]")).Text;
string Foreclosure = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_ForeclosedLabel")).Text;
string Board = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_BoardOfRevisionLabel")).Text;
string NewConstruction = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_NewConstructionLabel")).Text;
string DividedProperty = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_DividedPropertyLabel")).Text;
gc.CreatePdf(orderNumber, Parcel_number, "Base", driver, "OH", "Wood");
driver.FindElement(By.LinkText("Residential")).Click();
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_number, "Residential", driver, "OH", "Wood");
try
{
yearbuild = driver.FindElement(By.Id("ContentPlaceHolder1_Residential_fvDataResidential_YearBuiltLabel")).Text;
}
catch { }
string Propertyresult = Ownar + "~" + address + "~" + mailingaddress + "~" + city + "~" + Township + "~" + school + "~" + LegalDescription + "~" + LegalAcres + "~" + LandUse + "~" + AnnualTax + "~" + yearbuild;
gc.insert_date(orderNumber, Parcel_number, 1435, Propertyresult, 1, DateTime.Now);
string flagresult = HomesteadReduction + "~" + Reduction + "~" + Foreclosure + "~" + Board + "~" + NewConstruction + "~" + DividedProperty;
gc.insert_date(orderNumber, Parcel_number, 1583, flagresult, 1, DateTime.Now);
AssessmentTime = DateTime.Now.ToString("HH:mm:ss");
driver.FindElement(By.LinkText("Land")).Click();
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_number, "Lane", driver, "OH", "Wood");
//assessment
driver.FindElement(By.LinkText("Valuation")).Click();
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_number, "Valuation", driver, "OH", "Wood");
IWebElement valuvationTable = driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_Valuation_fvDataValuation']/tbody/tr/td/table/tbody"));
IList <IWebElement> Valuvationrow = valuvationTable.FindElements(By.TagName("tr"));
IList <IWebElement> valuvationid;
IList <IWebElement> valuvationTh;
foreach (IWebElement valuvation in Valuvationrow)
{
valuvationid = valuvation.FindElements(By.TagName("td"));
valuvationTh = valuvation.FindElements(By.TagName("th"));
if (valuvationid.Count > 1)
{
apprasiedresult = valuvationTh[0].Text + "~" + valuvationid[0].Text + "~" + valuvationid[1].Text;
gc.insert_date(orderNumber, Parcel_number, 1436, apprasiedresult, 1, DateTime.Now);
}
if (valuvationid.Count == 1)
{
apprasiedresult = valuvationTh[0].Text + "~" + " " + "~" + valuvationid[0].Text;
gc.insert_date(orderNumber, Parcel_number, 1436, apprasiedresult, 1, DateTime.Now);
}
}
//gc.insert_date(orderNumber, Parcel_number, 1436, apprasiedresult.Remove(apprasiedresult.Length - 1), 1, DateTime.Now);
//IWebElement valuvationhistorytable = driver.FindElement(By.Id("ContentPlaceHolder1_Valuation_gvValuationHistory"));
//IList<IWebElement> valuvationhistortrow = valuvationhistorytable.FindElements(By.TagName("tr"));
//IList<IWebElement> valuvationhistoryid;
//foreach (IWebElement valuvation in valuvationhistortrow)
//{
// valuvationhistoryid = valuvation.FindElements(By.TagName("td"));
// if (valuvationhistoryid.Count != 0 & !valuvation.Text.Contains("Date"))
// {
// string valuvationhistory = valuvationhistoryid[0].Text + "~" + valuvationhistoryid[1].Text + "~" + valuvationhistoryid[2].Text + "~" + valuvationhistoryid[3].Text + "~" + valuvationhistoryid[4].Text + "~" + valuvationhistoryid[5].Text + "~" + valuvationhistoryid[6].Text + "~" + valuvationhistoryid[7].Text;
// gc.insert_date(orderNumber, Parcel_number, 1424, valuvationhistory, 1, DateTime.Now);
// }
//}
driver.FindElement(By.LinkText("Sales")).Click();
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_number, "Sales", driver, "OH", "Wood");
driver.FindElement(By.LinkText("Tax")).Click();
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_number, "Tax", driver, "OH", "Wood");
string taxrat = driver.FindElement(By.Id("ContentPlaceHolder1_Tax_fvDataTaxRates_FullRateLabel")).Text;
string EFtaxrate = driver.FindElement(By.Id("ContentPlaceHolder1_Tax_fvDataTaxRates_EffectiveRateLabel")).Text;
// string Escrow = driver.FindElement(By.Id("ContentPlaceHolder1_Tax_fvDataEscrow_EscrowAmountLabel")).Text;
string taxinfores = taxrat + "~" + EFtaxrate;
gc.insert_date(orderNumber, Parcel_number, 1437, taxinfores, 1, DateTime.Now);
//property detail
IWebElement propertytaxtable = driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_Tax_fvDataTax']/tbody/tr/td/table/tbody"));
IList <IWebElement> propertytaxrow = propertytaxtable.FindElements(By.TagName("tr"));
IList <IWebElement> properttaxid;
IList <IWebElement> propertytaxth;
foreach (IWebElement propertytax in propertytaxrow)
{
properttaxid = propertytax.FindElements(By.TagName("td"));
propertytaxth = propertytax.FindElements(By.TagName("th"));
if (properttaxid.Count == 6)
{
string Propertyresult1 = propertytaxth[0].Text + "~" + properttaxid[0].Text + "~" + properttaxid[1].Text + "~" + properttaxid[2].Text + "~" + properttaxid[3].Text + "~" + properttaxid[4].Text + "~" + properttaxid[5].Text + "~" + " ";
gc.insert_date(orderNumber, Parcel_number, 1438, Propertyresult1, 1, DateTime.Now);
}
if (properttaxid.Count == 3)
{
string nettaxresult = propertytaxth[0].Text + "~" + properttaxid[0].Text + "~" + " " + "~" + properttaxid[1].Text + "~" + " " + "~" + properttaxid[2].Text + "~" + " " + "~" + " ";
gc.insert_date(orderNumber, Parcel_number, 1438, nettaxresult, 1, DateTime.Now);
}
if (properttaxid.Count == 4)
{
string Netresult = propertytaxth[0].Text + "~" + properttaxid[0].Text + "~" + " " + "~" + properttaxid[1].Text + "~" + " " + "~" + properttaxid[2].Text + "~" + " " + "~" + properttaxid[3].Text;
gc.insert_date(orderNumber, Parcel_number, 1438, Netresult, 1, DateTime.Now);
}
}
//splialassessment
try
{
string countvalue = driver.FindElement(By.Id("ContentPlaceHolder1_Tax_fvDataSpecials_lblDataSpecials")).Text.Replace("of", "").Trim();
int sp = 0;
for (int s = 1; s <= Convert.ToInt16(countvalue); s++)
{
if (s != 1)
{
IWebElement PropertyInformation = driver.FindElement(By.Id("ContentPlaceHolder1_Tax_fvDataSpecials_ddlDataSpecials"));
SelectElement PropertyInformationSelect = new SelectElement(PropertyInformation);
PropertyInformationSelect.SelectByIndex(sp);
Thread.Sleep(1000);
gc.CreatePdf(orderNumber, Parcel_number, "Tax" + s, driver, "OH", "Wood");
}
string spcialtype = driver.FindElement(By.Id("ContentPlaceHolder1_Tax_fvDataSpecials_Label")).Text;
IWebElement Splialassessmentable = driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_Tax_fvDataSpecials']/tbody"));
IList <IWebElement> Splialassessmenrow = Splialassessmentable.FindElements(By.TagName("tr"));
IList <IWebElement> Splialassessmenid;
IList <IWebElement> SplialassessmenTH;
foreach (IWebElement Splialassessmen in Splialassessmenrow)
{
Splialassessmenid = Splialassessmen.FindElements(By.TagName("td"));
SplialassessmenTH = Splialassessmen.FindElements(By.TagName("th"));
if (Splialassessmenid.Count == 6)
{
string taxpaymentresult = spcialtype + "~" + SplialassessmenTH[0].Text + "~" + Splialassessmenid[0].Text + "~" + Splialassessmenid[1].Text + "~" + Splialassessmenid[2].Text + "~" + Splialassessmenid[3].Text + "~" + Splialassessmenid[4].Text + "~" + Splialassessmenid[5].Text;
gc.insert_date(orderNumber, Parcel_number, 1439, taxpaymentresult, 1, DateTime.Now);
}
if (Splialassessmenid.Count == 3)
{
string taxpaymentresult1 = spcialtype + "~" + SplialassessmenTH[0].Text + "~" + Splialassessmenid[0].Text + "~" + "~" + Splialassessmenid[1].Text + "~" + "~" + Splialassessmenid[2].Text + "~";
gc.insert_date(orderNumber, Parcel_number, 1439, taxpaymentresult1, 1, DateTime.Now);
}
}
sp++;
}
}
catch { }
IWebElement taxpaymenthistable = driver.FindElement(By.Id("ContentPlaceHolder1_Tax_gvDataPayments"));
IList <IWebElement> taxpaymenthistryrow = taxpaymenthistable.FindElements(By.TagName("tr"));
IList <IWebElement> taxpaymenthisid;
foreach (IWebElement taxpaymenthis in taxpaymenthistryrow)
{
taxpaymenthisid = taxpaymenthis.FindElements(By.TagName("td"));
if (taxpaymenthisid.Count != 0)
{
string taxpaymentresult = taxpaymenthisid[0].Text + "~" + taxpaymenthisid[1].Text + "~" + taxpaymenthisid[2].Text + "~" + taxpaymenthisid[3].Text + "~" + taxpaymenthisid[4].Text + "~" + taxpaymenthisid[5].Text + "~" + taxpaymenthisid[6].Text;
gc.insert_date(orderNumber, Parcel_number, 1576, taxpaymentresult, 1, DateTime.Now);
}
}
driver.FindElement(By.LinkText("Improvements")).Click();
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_number, "Improvements", driver, "OH", "Wood");
LastEndTime = DateTime.Now.ToString("HH:mm:ss");
gc.insert_TakenTime(orderNumber, "OH", "Wood", StartTime, AssessmentTime, TaxTime, CitytaxTime, LastEndTime);
driver.Quit();
gc.mergpdf(orderNumber, "OH", "Wood");
return("Data Inserted Successfully");
}
catch (Exception ex)
{
driver.Quit();
GlobalClass.LogError(ex, orderNumber);
throw ex;
}
}
}
public string FTP_Lake(string streetno, string streetname, string direction, string streetype, string unitno, string ownername, string parcelNumber, string searchType, string orderNumber, string directParcel)
{
GlobalClass.global_orderNo = orderNumber;
HttpContext.Current.Session["orderNo"] = orderNumber;
GlobalClass.global_parcelNo = parcelNumber;
List <string> multiparcel = new List <string>();
string StartTime = "", AssessmentTime = "", TaxTime = "", CitytaxTime = "", LastEndTime = "";
string Parcel_number = "", Tax_Authority = "", yearbuilt = "", apprasiedresult = "", Valuvationresult = "", Multiaddressadd = "", MailingAddress = "", Addresshrf1 = "", Address12 = "";
var driverService = PhantomJSDriverService.CreateDefaultService();
driverService.HideCommandPromptWindow = true;
//driver = new PhantomJSDriver();
//driver = new ChromeDriver();
using (driver = new PhantomJSDriver())
{
StartTime = DateTime.Now.ToString("HH:mm:ss");
driver.Navigate().GoToUrl("http://lake.iviewauditor.com/Search.aspx");
Thread.Sleep(2000);
try
{
if (searchType == "titleflex")
{
string straddress = streetno + " " + direction + " " + streetname + " " + streetype + " " + unitno;
gc.TitleFlexSearch(orderNumber, parcelNumber, "", straddress, "OH", "Lake");
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_LakeOH"] = "Yes";
driver.Quit();
return("No Data Found");
}
parcelNumber = HttpContext.Current.Session["titleparcel"].ToString();
searchType = "parcel";
}
if (searchType == "address")
{
driver.FindElement(By.Id("ContentPlaceHolder1_btnDisclaimerAccept")).Click();
Thread.Sleep(2000);
driver.FindElement(By.LinkText("Address")).Click();
Thread.Sleep(2000);
gc.CreatePdf_WOP(orderNumber, "Address search Input ", driver, "OH", "Lake");
driver.FindElement(By.Name("ctl00$ContentPlaceHolder1$Address$tbAddressNumber")).SendKeys(streetno);
driver.FindElement(By.Id("ContentPlaceHolder1_Address_tbAddressDirection")).SendKeys(direction);
driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_Address_tbAddressStreet']")).SendKeys(streetname.Trim());
gc.CreatePdf_WOP(orderNumber, "Address search Result ", driver, "OH", "Lake");
driver.FindElement(By.Id("ContentPlaceHolder1_Address_btnSearchAddress")).Click();
Thread.Sleep(5000);
try
{
int Max = 0;
//*[@id="ContentPlaceHolder1_gvSearchResults"]/tbody
IWebElement Multiparceladdress = driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_gvSearchResults']/tbody"));
IList <IWebElement> Multiparcelrow = Multiparceladdress.FindElements(By.TagName("tr"));
IList <IWebElement> Multiparcelid;
gc.CreatePdf_WOP(orderNumber, "SearchAfter", driver, "OH", "Lake");
foreach (IWebElement multiparcel1 in Multiparcelrow)
{
Multiparcelid = multiparcel1.FindElements(By.TagName("td"));
if (Multiparcelid.Count != 0)
{
Address1 = Multiparcelid[0].FindElement(By.TagName("a"));
string Addresshrf = Address1.GetAttribute("href");
string Addressst = Address1.Text;
string Owner = Multiparcelid[1].Text;
string Pin = Multiparcelid[2].Text;
string Multiparcel = Owner + "~" + Pin;
gc.insert_date(orderNumber, Addressst, 876, Multiparcel, 1, DateTime.Now);
Max++;
}
}
if (Max == 1)
{
Address1.Click();
Thread.Sleep(2000);
}
if (Max > 1 && Max < 26)
{
HttpContext.Current.Session["multiParcel_LakeOH"] = "Yes";
driver.Quit();
return("MultiParcel");
}
if (Max > 25)
{
HttpContext.Current.Session["multiParcel_LakeOH_Multicount"] = "Maximum";
driver.Quit();
return("Maximum");
}
}
catch { }
try
{
//No Data Found
string nodata = driver.FindElement(By.Id("ContentPlaceHolder1_lblNumberOfResults")).Text;
if (nodata.Contains("No results"))
{
HttpContext.Current.Session["Nodata_LakeOH"] = "Yes";
driver.Quit();
return("No Data Found");
}
}
catch { }
}
if (searchType == "parcel")
{
driver.FindElement(By.Id("ContentPlaceHolder1_btnDisclaimerAccept")).Click();
Thread.Sleep(2000);
driver.FindElement(By.LinkText("Parcel")).Click();
Thread.Sleep(2000);
gc.CreatePdf_WOP(orderNumber, "Parcel search Input ", driver, "OH", "Lake");
driver.FindElement(By.Id("ContentPlaceHolder1_Parcel_tbParcelNumber")).SendKeys(parcelNumber);
gc.CreatePdf_WOP(orderNumber, "Parcel search Result ", driver, "OH", "Lake");
driver.FindElement(By.Id("ContentPlaceHolder1_Parcel_btnSearchParcel")).Click();
Thread.Sleep(2000);
try
{
//No Data Found
string nodata = driver.FindElement(By.Id("ContentPlaceHolder1_lblNumberOfResults")).Text;
if (nodata.Contains("No results"))
{
HttpContext.Current.Session["Nodata_LakeOH"] = "Yes";
driver.Quit();
return("No Data Found");
}
}
catch { }
}
if (searchType == "ownername")
{
string[] Ownarsplit = ownername.Split(' ');
string lastname = Ownarsplit[0];
string firstname = Ownarsplit[1];
driver.FindElement(By.Id("ContentPlaceHolder1_btnDisclaimerAccept")).Click();
Thread.Sleep(2000);
driver.FindElement(By.LinkText("Owner")).Click();
Thread.Sleep(2000);
driver.FindElement(By.Id("ContentPlaceHolder1_Owner_tbOwnerLastName")).SendKeys(lastname.Trim());
driver.FindElement(By.Id("ContentPlaceHolder1_Owner_tbOwnerFirstName")).SendKeys(firstname.Trim());
gc.CreatePdf_WOP(orderNumber, "Owner search Input ", driver, "OH", "Lake");
driver.FindElement(By.Id("ContentPlaceHolder1_Owner_btnSearchOwner")).Click();
Thread.Sleep(2000);
gc.CreatePdf_WOP(orderNumber, "Owner search Result ", driver, "OH", "Lake");
//Multiparcel
try
{
int Max = 0;
IWebElement Multiparceladdress = driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_gvSearchResults']/tbody"));
IList <IWebElement> Multiparcelrow = Multiparceladdress.FindElements(By.TagName("tr"));
IList <IWebElement> Multiparcelid;
gc.CreatePdf_WOP(orderNumber, "SearchAfter", driver, "OH", "Lake");
foreach (IWebElement multiparcel1 in Multiparcelrow)
{
Multiparcelid = multiparcel1.FindElements(By.TagName("td"));
if (Multiparcelid.Count != 0)
{
Address1 = Multiparcelid[0].FindElement(By.TagName("a"));
string Addresshrf = Address1.GetAttribute("href");
string Addressst = Address1.Text;
string Owner = Multiparcelid[1].Text;
string Pin = Multiparcelid[2].Text;
string Multiparcel = Owner + "~" + Pin;
gc.insert_date(orderNumber, Addressst, 876, Multiparcel, 1, DateTime.Now);
Max++;
}
}
if (Max == 1)
{
Address1.Click();
Thread.Sleep(2000);
}
if (Max > 1 && Max < 26)
{
HttpContext.Current.Session["multiParcel_LakeOH"] = "Yes";
driver.Quit();
return("MultiParcel");
}
if (Max > 25)
{
HttpContext.Current.Session["multiParcel_LakeOH_Multicount"] = "Maximum";
driver.Quit();
return("Maximum");
}
}
catch { }
try
{
//No Data Found
string nodata = driver.FindElement(By.Id("ContentPlaceHolder1_lblNumberOfResults")).Text;
if (nodata.Contains("No results"))
{
HttpContext.Current.Session["Nodata_LakeOH"] = "Yes";
driver.Quit();
return("No Data Found");
}
}
catch { }
}
//Property Details
try
{
driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_gvSearchResults']/tbody/tr[2]/td[1]/a")).Click();
Thread.Sleep(5000);
}
catch { }
Parcel_number = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataProfile_ParcelLabel")).Text;
string Ownar = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataProfile_OwnerLabel")).Text;
string address = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataProfile_AddressLabel")).Text;
string mailaddress = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataMailingAddress_OwnerAddressLine2Label")).Text;
string mailcity = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataMailingAddress_OwnerAddressLine3Label")).Text;
string mailingaddress = mailaddress + " " + mailcity;
string city = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataGeographic_CityLabel")).Text;
string Township = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataGeographic_TownshipLabel")).Text;
string school = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataGeographic_SchoolDistrictLabel")).Text;
string Legal = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_LegalDescriptionLine1Label")).Text;
string Description = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_LegalDescriptionLine2Label")).Text;
string LegalDescription = Legal + " " + Description;
string LegalAcres = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_RangeLabel")).Text;
string LandUse = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataLegal_LandUseCodeLabel")).Text;
string HomesteadReduction = driver.FindElement(By.Id("ContentPlaceHolder1_Base_fvDataTaxCredits_HomesteadReductionLabel")).Text;
gc.CreatePdf(orderNumber, Parcel_number, "Base", driver, "OH", "Lake");
driver.FindElement(By.LinkText("Improvements")).Click();
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_number, "Improvements", driver, "OH", "Lake");
try
{
yearbuilt = driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_Improvements_gvDataImprovements']/tbody/tr[2]/td[3]")).Text;
}
catch { }
string Propertyresult = Ownar + "~" + address + "~" + mailingaddress + "~" + city + "~" + Township + "~" + school + "~" + LegalDescription + "~" + LegalAcres + "~" + LandUse + "~" + yearbuilt;
gc.insert_date(orderNumber, Parcel_number, 1684, Propertyresult, 1, DateTime.Now);
//Assessment Details
driver.FindElement(By.LinkText("Base")).Click();
Thread.Sleep(2000);
IWebElement valuvationTable = driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_Base_fvDataValuation']/tbody/tr/td/table/tbody"));
IList <IWebElement> Valuvationrow = valuvationTable.FindElements(By.TagName("tr"));
IList <IWebElement> valuvationid;
IList <IWebElement> valuvationTh;
foreach (IWebElement valuvation in Valuvationrow)
{
valuvationid = valuvation.FindElements(By.TagName("td"));
valuvationTh = valuvation.FindElements(By.TagName("th"));
if (valuvationid.Count > 1)
{
apprasiedresult = valuvationTh[0].Text.Replace(":", "").Trim() + "~" + valuvationid[0].Text + "~" + valuvationid[1].Text;
gc.insert_date(orderNumber, Parcel_number, 1685, apprasiedresult, 1, DateTime.Now);
}
if (valuvationid.Count == 1)
{
apprasiedresult = valuvationTh[0].Text.Replace(":", "").Trim() + "~" + " " + "~" + valuvationid[0].Text;
gc.insert_date(orderNumber, Parcel_number, 1685, apprasiedresult, 1, DateTime.Now);
}
}
//Tax credits
string apprasiedresult1 = "";
IWebElement valuvationTable1 = driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_Base_fvDataTaxCredits']/tbody/tr/td/table/tbody"));
IList <IWebElement> Valuvationrow1 = valuvationTable1.FindElements(By.TagName("tr"));
IList <IWebElement> valuvationid1;
IList <IWebElement> valuvationTh1;
foreach (IWebElement valuvation1 in Valuvationrow1)
{
valuvationid1 = valuvation1.FindElements(By.TagName("td"));
valuvationTh1 = valuvation1.FindElements(By.TagName("th"));
if (valuvationid1.Count == 1)
{
apprasiedresult1 = valuvationTh1[0].Text.Replace(":", "").Trim() + "~" + " " + "~" + valuvationid1[0].Text;
gc.insert_date(orderNumber, Parcel_number, 1685, apprasiedresult1, 1, DateTime.Now);
}
}
AssessmentTime = DateTime.Now.ToString("HH:mm:ss");
driver.FindElement(By.LinkText("Land")).Click();
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_number, "Lane", driver, "OH", "Lake");
//Valuation pdf
driver.FindElement(By.LinkText("Valuation")).Click();
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_number, "Valuation", driver, "OH", "Lake");
//property detail
driver.FindElement(By.LinkText("Sales")).Click();
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_number, "Sales", driver, "OH", "Lake");
driver.FindElement(By.LinkText("Tax")).Click();
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_number, "Tax", driver, "OH", "Lake");
IWebElement propertytaxtable = driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_Tax_fvDataTax']/tbody/tr/td/table/tbody"));
IList <IWebElement> propertytaxrow = propertytaxtable.FindElements(By.TagName("tr"));
IList <IWebElement> properttaxid;
IList <IWebElement> propertytaxth;
foreach (IWebElement propertytax in propertytaxrow)
{
properttaxid = propertytax.FindElements(By.TagName("td"));
propertytaxth = propertytax.FindElements(By.TagName("th"));
if (propertytaxth.Count == 2 && !propertytax.Text.Contains("Tax Year 2018 Payable 2019"))
{
db.ExecuteQuery("update data_field_master set Data_Fields_Text='" + "Property Tax~" + properttaxid[0].Text + "~" + properttaxid[1].Text + "' where Id = '" + 1686 + "'");
}
if (propertytaxth.Count == 3)
{
db.ExecuteQuery("update data_field_master set Data_Fields_Text='" + "Property Tax~" + propertytaxth[1].Text + "~" + propertytaxth[2].Text + "' where Id = '" + 1686 + "'");
}
if (properttaxid.Count == 2)
{
string Netresult = propertytaxth[0].Text + "~" + properttaxid[0].Text + "~" + properttaxid[1].Text;
gc.insert_date(orderNumber, Parcel_number, 1686, Netresult, 1, DateTime.Now);
}
if (properttaxid.Count == 3)
{
string Netresult = propertytaxth[0].Text + "~" + properttaxid[0].Text + "~" + properttaxid[1].Text;
gc.insert_date(orderNumber, Parcel_number, 1686, Netresult, 1, DateTime.Now);
}
if (properttaxid.Count == 1)
{
db.ExecuteQuery("update data_field_master set Data_Fields_Text='" + "Property Tax~" + propertytaxth[0].Text + "' where Id = '" + 1687 + "'");
string Netresult1 = propertytaxth[0].Text.Replace(":", "").Trim() + "~" + properttaxid[0].Text.Replace("Pay This Amount", "").Trim();
gc.insert_date(orderNumber, Parcel_number, 1687, Netresult1, 1, DateTime.Now);
}
}
//Special Assessment Details
//1688
try
{
string countvalue = driver.FindElement(By.Id("ContentPlaceHolder1_Tax_fvDataSpecials_lblDataSpecials")).Text.Replace("of", "").Trim();
for (int s = 1; s <= 2; s++)
{
if (s == 2 & countvalue == "2")
{
IWebElement PropertyInformation = driver.FindElement(By.Id("ContentPlaceHolder1_Tax_fvDataSpecials_ddlDataSpecials"));
SelectElement PropertyInformationSelect = new SelectElement(PropertyInformation);
PropertyInformationSelect.SelectByIndex(1);
gc.CreatePdf(orderNumber, Parcel_number, "Tax 2", driver, "OH", "Lake");
}
if (s == 2 & countvalue == "1")
{
break;
}
IWebElement Splialassessmentable = driver.FindElement(By.XPath("//*[@id='ContentPlaceHolder1_Tax_fvDataSpecials']/tbody"));
IList <IWebElement> Splialassessmenrow = Splialassessmentable.FindElements(By.TagName("tr"));
IList <IWebElement> Splialassessmenid;
foreach (IWebElement Splialassessmen in Splialassessmenrow)
{
Splialassessmenid = Splialassessmen.FindElements(By.TagName("td"));
if (Splialassessmenid.Count == 4)
{
string taxpaymentresult = Splialassessmenid[1].Text + "~" + Splialassessmenid[2].Text.Replace("\r", " ") + "~" + Splialassessmenid[3].Text;
gc.insert_date(orderNumber, Parcel_number, 1688, taxpaymentresult, 1, DateTime.Now);
}
}
}
}
catch { }
// Tax Payment History Details
IWebElement taxpaymenthistable = driver.FindElement(By.Id("ContentPlaceHolder1_Tax_gvDataPayments"));
IList <IWebElement> taxpaymenthistryrow = taxpaymenthistable.FindElements(By.TagName("tr"));
IList <IWebElement> taxpaymenthisid;
foreach (IWebElement taxpaymenthis in taxpaymenthistryrow)
{
taxpaymenthisid = taxpaymenthis.FindElements(By.TagName("td"));
if (taxpaymenthisid.Count != 0)
{
string taxpaymentresult = taxpaymenthisid[0].Text + "~" + taxpaymenthisid[1].Text;
gc.insert_date(orderNumber, Parcel_number, 1691, taxpaymentresult, 1, DateTime.Now);
}
}
//Tax Bill Download
driver.FindElement(By.LinkText("Tax")).Click();
Thread.Sleep(2000);
IWebElement test = driver.FindElement(By.Id("ContentPlaceHolder1_Tax_hlinkTaxBill"));
string downurl = test.GetAttribute("href");
driver.Navigate().GoToUrl(downurl);
Thread.Sleep(15000);
gc.downloadfile(downurl, orderNumber, Parcel_number, "ViewTaxBill", "OH", "Lake");
//Improvements
driver.FindElement(By.LinkText("Improvements")).Click();
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_number, "Improvements", driver, "OH", "Lake");
//Permit
driver.FindElement(By.LinkText("Permit")).Click();
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_number, "Permit", driver, "OH", "Lake");
//Permit
driver.FindElement(By.LinkText("Commercial")).Click();
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, Parcel_number, "Commercial", driver, "OH", "Lake");
//End
TaxTime = DateTime.Now.ToString("HH:mm:ss");
driver.Quit();
gc.mergpdf(orderNumber, "OH", "Lake");
LastEndTime = DateTime.Now.ToString("HH:mm:ss");
gc.insert_TakenTime(orderNumber, "OH", "Lake", StartTime, AssessmentTime, TaxTime, CitytaxTime, LastEndTime);
return("Data Inserted Successfully");
}
catch (Exception ex)
{
driver.Quit();
GlobalClass.LogError(ex, orderNumber);
throw ex;
}
}
}
