public string FTP_Kings(string streetno, string direction, string streetname, string streettype, 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;
var driverService = PhantomJSDriverService.CreateDefaultService();
driverService.HideCommandPromptWindow = true;
//driver = new ChromeDriver();
// driver = new PhantomJSDriver();
string StartTime = "", AssessmentTime = "", TaxTime = "", CitytaxTime = "", LastEndTime = "";
using (driver = new PhantomJSDriver())
{
try
{
StartTime = DateTime.Now.ToString("HH:mm:ss");
// https://a836-pts-access.nyc.gov/care/search/commonsearch.aspx?mode=address
if (searchType == "titleflex")
{
gc.TitleFlexSearch(orderNumber, "", ownernm, "", "NY", "Kings");
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_NYKing"] = "Yes";
driver.Quit();
return("No Data Found");
}
parcelNumber = HttpContext.Current.Session["titleparcel"].ToString().Replace(".", "");
searchType = "parcel";;
}
driver.Navigate().GoToUrl("https://a836-pts-access.nyc.gov/care/search/commonsearch.aspx?mode=address");
driver.FindElement(By.Id("btAgree")).Click();
Thread.Sleep(2000);
gc.CreatePdf_WOP(orderNumber, "Agree After", driver, "NY", "Kings");
IWebElement PropertyInformation = driver.FindElement(By.Id("Select1"));
SelectElement PropertyInformationSelect = new SelectElement(PropertyInformation);
PropertyInformationSelect.SelectByIndex(3);
Thread.Sleep(2000);
gc.CreatePdf_WOP(orderNumber, "County Select", driver, "NY", "Kings");
if (searchType == "address")
{
if (streetname.Any(char.IsDigit))
{
streetname = Regex.Match(streetname, @"\d+").Value;
}
string Street = "";
if (direction != "")
{
Street = direction.Trim() + " " + streetname.Trim() + " " + streettype.Trim();
}
else
{
Street = streetname.Trim() + " " + streettype.Trim();
}
driver.FindElement(By.Id("inpNumber")).SendKeys(streetno);
driver.FindElement(By.Id("inpStreet")).SendKeys(Street.Trim());
driver.FindElement(By.Id("inpSuffix2")).SendKeys(unitnumber);
gc.CreatePdf_WOP(orderNumber, "Address Search Before", driver, "NY", "Kings");
driver.FindElement(By.Id("btSearch")).Click();
// gc.CreatePdf_WOP(orderNumber, "Address Search After", driver, "NY", "Kings");
try
{
int Max = 0;
IWebElement Addresstable = driver.FindElement(By.XPath("//*[@id='searchResults']/tbody"));
IList <IWebElement> Addresrow = Addresstable.FindElements(By.TagName("tr"));
IList <IWebElement> AddressTD;
gc.CreatePdf_WOP(orderNumber, "Address After", driver, "NY", "Kings");
foreach (IWebElement AddressT in Addresrow)
{
AddressTD = AddressT.FindElements(By.TagName("td"));
if (AddressTD.Count > 1 && !AddressT.Text.Contains("BBL"))
{
//IWebElement Parcellink = AddressTD[0].FindElement(By.TagName("a"));
// Addresshrf = Parcellink.GetAttribute("href");
string parcelno = AddressTD[0].Text;
string OwnerName = AddressTD[1].Text;
string Address = AddressTD[2].Text;
string Addressresult = OwnerName + "~" + Address;
Max++;
gc.insert_date(orderNumber, parcelno, 628, Addressresult, 1, DateTime.Now);
}
}
if (Max > 1 && Max < 26)
{
HttpContext.Current.Session["multiparcel_King"] = "Yes";
driver.Quit();
return("MultiParcel");
}
if (Max > 25)
{
HttpContext.Current.Session["multiParcel_King_Multicount"] = "Maximum";
driver.Quit();
return("Maximum");
}
}
catch { }
try
{
string Nodata = driver.FindElement(By.XPath("//*[@id='frmMain']/table/tbody/tr/td/div/div/table[2]/tbody/tr/td/table/tbody/tr[3]/td/center/table[1]/tbody/tr[1]/td/div/p")).Text;
if (Nodata.Contains("Your search did"))
{
gc.CreatePdf_WOP(orderNumber, "No data", driver, "NY", "Kings");
HttpContext.Current.Session["Nodata_NYKing"] = "Yes";
driver.Quit();
return("No Data Found");
}
}
catch { }
}
if (searchType == "parcel")
{
IWebElement parcellink = driver.FindElement(By.XPath("//*[@id='secondarytopmenu']/ul/li[2]")).FindElement(By.TagName("a"));
string parcelhref = parcellink.GetAttribute("href");
driver.Navigate().GoToUrl(parcelhref);
Thread.Sleep(2000);
IWebElement PropertyInformation1 = driver.FindElement(By.Id("inpParid"));
SelectElement PropertyInformationSelect1 = new SelectElement(PropertyInformation1);
PropertyInformationSelect1.SelectByIndex(3);
// int a= Convert.ToInt32(parcelNumber.Trim().Count());
if (Convert.ToInt32(parcelNumber.Trim().Count()) == 10)
{
driver.FindElement(By.Id("inpTag")).SendKeys(parcelNumber.TrimStart('0').Substring(2, 4));
driver.FindElement(By.Id("inpStat")).SendKeys(parcelNumber.TrimStart('0').Substring(6));
driver.FindElement(By.Id("btSearch")).Click();
Thread.Sleep(2000);
}
if (parcelNumber.Contains("/"))
{
splitarray = parcelNumber.Split('/');
if (Convert.ToInt16(splitarray.Count()) == 3)
{
driver.FindElement(By.Id("inpTag")).SendKeys(splitarray[1].TrimStart('0'));
driver.FindElement(By.Id("inpStat")).SendKeys(splitarray[2].TrimStart('0'));
gc.CreatePdf(orderNumber, parcel_number, "Parcel Search", driver, "NY", "Kings");
driver.FindElement(By.Id("btSearch")).Click();
Thread.Sleep(2000);
}
if (Convert.ToInt16(splitarray.Count()) == 2)
{
driver.FindElement(By.Id("inpTag")).SendKeys(splitarray[0].TrimStart('0'));
driver.FindElement(By.Id("inpStat")).SendKeys(splitarray[1].TrimStart('0'));
gc.CreatePdf(orderNumber, parcel_number, "Parcel Search", driver, "NY", "Kings");
driver.FindElement(By.Id("btSearch")).Click();
Thread.Sleep(2000);
}
}
try
{
string Nodata = driver.FindElement(By.XPath("//*[@id='frmMain']/table/tbody/tr/td/div/div/table[2]/tbody/tr/td/table/tbody/tr[3]/td/center/table[1]/tbody/tr[1]/td/div/p")).Text;
if (Nodata.Contains("Your search did"))
{
gc.CreatePdf_WOP(orderNumber, "No data", driver, "NY", "Kings");
HttpContext.Current.Session["Nodata_NYKing"] = "Yes";
driver.Quit();
return("No Data Found");
}
}
catch { }
}
string blocktaken = driver.FindElement(By.XPath("//*[@id='datalet_header_row']/td/table/tbody/tr[2]/td[2]")).Text;
string block = gc.Between(blocktaken, "Block:", "Lot:").Trim();
string lot = GlobalClass.After(blocktaken, "Lot:").Trim();
parcel_number = block + "/" + lot;
string ownername = driver.FindElement(By.XPath("//*[@id='Property Owner(s)']/tbody/tr[2]/td")).Text;
string propertdata = driver.FindElement(By.Id("Property Data")).Text;
string Tax_year = gc.Between(propertdata, "Tax Year", "Lot Grouping");
string Propertyaddress = gc.Between(propertdata, "Property Address", "Tax Class");
string taxclass = gc.Between(propertdata, "Tax Class", "Building Class");
string Buildingclass = gc.Between(propertdata, "Building Class", "Condo Development");
string propertyresult = ownername + "~" + Tax_year + "~" + Propertyaddress + "~" + taxclass + "~" + Buildingclass;
gc.CreatePdf(orderNumber, parcel_number, "Peoperty Detail", driver, "NY", "Kings");
gc.insert_date(orderNumber, parcel_number, 604, propertyresult, 1, DateTime.Now);
//Assessment
IWebElement accounthistoryy = driver.FindElement(By.XPath("//*[@id='sidemenu']/li[3]")).FindElement(By.TagName("a"));
string Accounthref = accounthistoryy.GetAttribute("href");
driver.Navigate().GoToUrl(Accounthref);
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, parcel_number, "Account History", driver, "NY", "Kings");
try
{
string Assessment = driver.FindElement(By.XPath("//*[@id='Profile']/tbody")).Text;
string BuildingClass = gc.Between(Assessment, "Building Class", "Tax Class");
string TaxClass = gc.Between(Assessment, "Tax Class", "Unused SCRIE Credit");
string scriecredit = gc.Between(Assessment, "Unused SCRIE Credit", "Unused DRIE Credit");
string Direcredit = gc.Between(Assessment, "Unused DRIE Credit", "Refund Amount");
string refundamt = gc.Between(Assessment, "Refund Amount", "Overpayment amount");
string overpayment = GlobalClass.After(Assessment, "Overpayment amount");
string assessmentresult = BuildingClass + "~" + TaxClass + "~" + scriecredit + "~" + Direcredit + "~" + refundamt + "~" + overpayment;
gc.insert_date(orderNumber, parcel_number, 626, assessmentresult, 1, DateTime.Now);
}
catch { }
//tax History
try
{
IWebElement Accounthistoryhref = driver.FindElement(By.XPath("//*[@id='Account History Details']/tbody/tr[2]/td")).FindElement(By.TagName("a"));
string accountyhistoryhref = Accounthistoryhref.GetAttribute("href");
driver.Navigate().GoToUrl(accountyhistoryhref);
//Account History Details
IWebElement Accounthostorytable = driver.FindElement(By.Id("Account History Details"));
IList <IWebElement> Accountrow = Accounthostorytable.FindElements(By.TagName("tr"));
IList <IWebElement> accountyhistoryid;
foreach (IWebElement accounthistory in Accountrow)
{
accountyhistoryid = accounthistory.FindElements(By.TagName("td"));
if (accountyhistoryid.Count > 1 && !accounthistory.Text.Contains("Year"))
{
string Accounthistoryresult = accountyhistoryid[0].Text + "~" + accountyhistoryid[1].Text + "~" + accountyhistoryid[2].Text + "~" + accountyhistoryid[3].Text + "~" + accountyhistoryid[4].Text + "~" + accountyhistoryid[5].Text + "~" + accountyhistoryid[6].Text + "~" + accountyhistoryid[7].Text + "~" + accountyhistoryid[8].Text + "~" + accountyhistoryid[9].Text + "~" + accountyhistoryid[10].Text + "~" + accountyhistoryid[11].Text;
gc.insert_date(orderNumber, parcel_number, 621, Accounthistoryresult, 1, DateTime.Now);
}
}
}
catch { }
IWebElement proowner = driver.FindElement(By.XPath("//*[@id='sidemenu']/li[6]")).FindElement(By.TagName("a"));
string ownerpro = proowner.GetAttribute("href");
driver.Navigate().GoToUrl(ownerpro);
gc.CreatePdf(orderNumber, parcel_number, "Ownerpro", driver, "NY", "Kings");
try
{
IWebElement Proownertable = driver.FindElement(By.Id("Exemptions"));
IList <IWebElement> Proownerrow = Proownertable.FindElements(By.TagName("tr"));
IList <IWebElement> Proownerid;
foreach (IWebElement Proowner in Proownerrow)
{
Proownerid = Proowner.FindElements(By.TagName("td"));
if (Proownerid.Count > 1 && !Proowner.Text.Contains("Year"))
{
string Proownerresult = Proownerid[0].Text + "~" + Proownerid[1].Text + "~" + Proownerid[3].Text + "~" + Proownerid[4].Text;
gc.insert_date(orderNumber, parcel_number, 613, Proownerresult, 1, DateTime.Now);
}
}
}
catch { }
//Property Tax Bills
IWebElement propertytaxbill = driver.FindElement(By.XPath("//*[@id='sidemenu']/li[5]")).FindElement(By.TagName("a"));
string Propertyhref = propertytaxbill.GetAttribute("href");
driver.Navigate().GoToUrl(Propertyhref);
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, parcel_number, "Property Bill", driver, "NY", "Kings");
string currentlink = driver.CurrentWindowHandle;
int p = 1;
IWebElement PropertyBilltable = driver.FindElement(By.Id("Property Tax Bills"));
IList <IWebElement> PropertyBillrow = PropertyBilltable.FindElements(By.TagName("tr"));
IList <IWebElement> PropertyBillid;
foreach (IWebElement PropertyBill in PropertyBillrow)
{
PropertyBillid = PropertyBill.FindElements(By.TagName("td"));
if (PropertyBillid.Count != 0 && PropertyBillid[0].Text.Trim() != "")
{
if (p < 5)
{
IWebElement PropertyLink = PropertyBillid[2].FindElement(By.TagName("a"));
string prowhref = PropertyLink.GetAttribute("href");
gc.downloadfile(prowhref, orderNumber, parcel_number, "Property Taax Bill" + p, "NY", "Kings");
// Downloadpdf.Add(prowhref);
//driver.SwitchTo().Window(driver.WindowHandles.Last());
//Thread.Sleep(8000);
//gc.downloadfile(driver.Url, orderNumber, parcel_number, "Property Taax Bill" + p, "NY", "Kings");
// gc.CreatePdf(orderNumber, parcel_number, "Property Taax Bill" + p, driver, "NY", "Kings");
//driver.Close();
//driver.SwitchTo().Window(currentlink);
p++;
}
if (p == 5)
{
break;
}
}
}
// Benefits Business
IWebElement Benefits = driver.FindElement(By.XPath("//*[@id='sidemenu']/li[7]")).FindElement(By.TagName("a"));
string Beniftshref = Benefits.GetAttribute("href");
driver.Navigate().GoToUrl(Beniftshref);
Thread.Sleep(1000);
gc.CreatePdf(orderNumber, parcel_number, "Benefits", driver, "NY", "Kings");
//Benefits Non gov
IWebElement Benefitsgov = driver.FindElement(By.XPath("//*[@id='sidemenu']/li[7]")).FindElement(By.TagName("a"));
string Beniftshrefgov = Benefitsgov.GetAttribute("href");
driver.Navigate().GoToUrl(Beniftshrefgov);
Thread.Sleep(1000);
gc.CreatePdf(orderNumber, parcel_number, "Benefits Gov", driver, "NY", "Kings");
//prior Year
try
{
IWebElement prioryear = driver.FindElement(By.XPath("//*[@id='sidemenu']/li[10]")).FindElement(By.TagName("a"));
string prioryearhref = prioryear.GetAttribute("href");
driver.Navigate().GoToUrl(prioryearhref);
Thread.Sleep(1000);
gc.CreatePdf(orderNumber, parcel_number, "prior year", driver, "NY", "Kings");
IWebElement prioryeartable = driver.FindElement(By.Id("Historical Market Values and Assessment Rolls"));
IList <IWebElement> prioryearrow = prioryeartable.FindElements(By.TagName("tr"));
IList <IWebElement> prioryearid;
foreach (IWebElement prioryearele in prioryearrow)
{
prioryearid = prioryearele.FindElements(By.TagName("td"));
if (prioryearele.Text.Contains("Final Assessment Roll"))
{
IWebElement prioryearlink = prioryearid[3].FindElement(By.TagName("a"));
string Priorhref = prioryearlink.GetAttribute("href");
gc.downloadfile(Priorhref, orderNumber, parcel_number, "Final Assessment Roll", "NY", "Kings");
// Downloadpdf.Add(Priorhref);
//prioryearlink.Click();
//Thread.Sleep(9000);
// driver.SwitchTo().Window(driver.WindowHandles.Last());
//gc.downloadfile(driver.Url, orderNumber, parcel_number, "Final Assessment Roll", "NY", "Kings");
// gc.CreatePdf(orderNumber, parcel_number, "Final Assessment Roll", driver, "NY", "Kings");
break;
}
}
}
catch { }
//driver.Navigate().GoToUrl("https://webapps.nyc.gov/cics/f704/f403001i?DET=3-00" + block + "-00" + lot + "-");
////Old site History Table
//IWebElement Taxtable = driver.FindElement(By.XPath("/html/body/div/center/table/tbody/tr[2]/td/table[8]/tbody"));
//IList<IWebElement> TaxtableRow = Taxtable.FindElements(By.TagName("tr"));
//IList<IWebElement> taxtableid;
//foreach (IWebElement tax in TaxtableRow)
//{
// try
// {
// taxtableid = tax.FindElements(By.TagName("td"));
// if (taxtableid.Count != 0 && !tax.Text.Contains("Account"))
// {
// string Taxresult = taxtableid[1].Text + "~" + taxtableid[2].Text + "~" + taxtableid[3].Text + "~" + taxtableid[4].Text + "~" + taxtableid[5].Text + "~" + taxtableid[6].Text + "~" + taxtableid[7].Text + "~" + taxtableid[8].Text + "~" + taxtableid[9].Text + "~" + taxtableid[10].Text;
// gc.insert_date(orderNumber, parcel_number, 621, Taxresult, 1, DateTime.Now);
// }
// }
// catch { }
//}
// currentyear++;
//var chromeOptions = new ChromeOptions();
//var chDriver = new ChromeDriver(chromeOptions);
//try
//{
// string fileName = "";
// var downloadDirectory = ConfigurationManager.AppSettings["AutoPdf"];
// chromeOptions.AddUserProfilePreference("download.default_directory", downloadDirectory);
// chromeOptions.AddUserProfilePreference("download.prompt_for_download", false);
// chromeOptions.AddUserProfilePreference("disable-popup-blocking", "true");
// chromeOptions.AddUserProfilePreference("plugins.always_open_pdf_externally", true);
// Array.ForEach(Directory.GetFiles(@downloadDirectory), File.Delete); //Delete all the files in auto pdf
// try
// {
// foreach (string Down in Downloadpdf)
// {
// chDriver.Navigate().GoToUrl(Down);
// Thread.Sleep(5000);
// fileName = latestfilename();
// gc.AutoDownloadFileSpokane(orderNumber, parcel_number, "Kings", "NY", fileName);
// }
// }
// catch { }
// chDriver.Quit();
//}
//catch { }
TaxTime = DateTime.Now.ToString("HH:mm:ss");
LastEndTime = DateTime.Now.ToString("HH:mm:ss");
gc.insert_TakenTime(orderNumber, "NY", "Kings", StartTime, AssessmentTime, TaxTime, CitytaxTime, LastEndTime);
driver.Quit();
gc.mergpdf(orderNumber, "NY", "Kings");
return("Data Inserted Successfully");
}
catch (Exception ex)
{
driver.Quit();
GlobalClass.LogError(ex, orderNumber);
throw ex;
}
}
}
public string FTP_QueensNY(string streetno, string direction, string streetname, string streettype, 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;
var driverService = PhantomJSDriverService.CreateDefaultService();
driverService.HideCommandPromptWindow = true;
//driver = new ChromeDriver();
// driver = new PhantomJSDriver();
string StartTime = "", AssessmentTime = "", TaxTime = "", CitytaxTime = "", LastEndTime = "";
using (driver = new PhantomJSDriver())
{
try
{
StartTime = DateTime.Now.ToString("HH:mm:ss");
// https://a836-pts-access.nyc.gov/care/search/commonsearch.aspx?mode=address
if (searchType == "titleflex")
{
gc.TitleFlexSearch(orderNumber, "", ownernm, "", "NY", "Queens");
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_QueensNY"] = "Yes";
driver.Quit();
return("No Data Found");
}
parcelNumber = HttpContext.Current.Session["titleparcel"].ToString();
searchType = "parcel";
}
driver.Navigate().GoToUrl("https://a836-pts-access.nyc.gov/care/search/commonsearch.aspx?mode=address");
driver.FindElement(By.Id("btAgree")).Click();
Thread.Sleep(2000);
gc.CreatePdf_WOP(orderNumber, "Aggre After", driver, "NY", "Queens");
IWebElement PropertyInformation = driver.FindElement(By.Id("Select1"));
SelectElement PropertyInformationSelect = new SelectElement(PropertyInformation);
PropertyInformationSelect.SelectByIndex(4);
Thread.Sleep(2000);
gc.CreatePdf_WOP(orderNumber, "County Select", driver, "NY", "Queens");
if (searchType == "address")
{
if (streetname.Any(char.IsDigit))
{
streetname = Regex.Match(streetname, @"\d+").Value;
}
string Street = "";
if (direction != "")
{
Street = direction.Trim() + " " + streetname.Trim() + " " + streettype.Trim();
}
else
{
Street = streetname.Trim() + " " + streettype.Trim();
}
driver.FindElement(By.Id("inpNumber")).SendKeys(streetno);
driver.FindElement(By.Id("inpStreet")).SendKeys(Street);
driver.FindElement(By.Id("inpSuffix2")).SendKeys(unitnumber);
gc.CreatePdf_WOP(orderNumber, "Address Search", driver, "NY", "Queens");
driver.FindElement(By.Id("btSearch")).Click();
Thread.Sleep(2000);
try
{
int Max = 0;
IWebElement Addresstable = driver.FindElement(By.XPath("//*[@id='searchResults']/tbody"));
IList <IWebElement> Addresrow = Addresstable.FindElements(By.TagName("tr"));
IList <IWebElement> AddressTD;
gc.CreatePdf_WOP(orderNumber, "Address After", driver, "NY", "Queens");
foreach (IWebElement AddressT in Addresrow)
{
AddressTD = AddressT.FindElements(By.TagName("td"));
if (AddressTD.Count > 1 && !AddressT.Text.Contains("BBL"))
{
//IWebElement Parcellink = AddressTD[0].FindElement(By.TagName("a"));
// Addresshrf = Parcellink.GetAttribute("href");
string parcelno = AddressTD[0].Text;
string OwnerName = AddressTD[1].Text;
string Address = AddressTD[2].Text;
string Addressresult = OwnerName + "~" + Address;
Max++;
gc.insert_date(orderNumber, parcelno, 628, Addressresult, 1, DateTime.Now);
}
}
if (Max > 1 && Max < 26)
{
HttpContext.Current.Session["multiparcel_QueensNY"] = "Yes";
driver.Quit();
return("MultiParcel");
}
if (Max > 25)
{
HttpContext.Current.Session["multiParcel_QueensNY_Multicount"] = "Maximum";
driver.Quit();
return("Maximum");
}
}
catch { }
//try
//{
// string Nodata = driver.FindElement(By.XPath("//*[@id='frmMain']/table/tbody/tr/td/div/div/table[2]/tbody/tr/td/table/tbody/tr[3]/td/center/table[1]/tbody/tr[1]/td/div/p")).Text;
// if(Nodata.Contains("Your search did not"))
// {
// HttpContext.Current.Session["Nodata_QueensNY"] = "Zero";
// driver.Quit();
// return "No Data Found";
// }
//}
//catch { }
}
if (searchType == "parcel")
{
IWebElement parcellink = driver.FindElement(By.XPath("//*[@id='secondarytopmenu']/ul/li[2]")).FindElement(By.TagName("a"));
string parcelhref = parcellink.GetAttribute("href");
driver.Navigate().GoToUrl(parcelhref);
Thread.Sleep(2000);
IWebElement PropertyInformation1 = driver.FindElement(By.Id("inpParid"));
SelectElement PropertyInformationSelect1 = new SelectElement(PropertyInformation1);
PropertyInformationSelect1.SelectByIndex(3);
// int a= Convert.ToInt32(parcelNumber.Trim().Count());
if (Convert.ToInt32(parcelNumber.Trim().Count()) == 10)
{
driver.FindElement(By.Id("inpTag")).SendKeys(parcelNumber.TrimStart('0').Substring(1, 5));
driver.FindElement(By.Id("inpStat")).SendKeys(parcelNumber.TrimStart('0').Substring(6));
driver.FindElement(By.Id("btSearch")).Click();
Thread.Sleep(2000);
}
if (parcelNumber.Contains("-"))
{
splitarray = parcelNumber.Split('-');
if (Convert.ToInt16(splitarray.Count()) == 3)
{
driver.FindElement(By.Id("inpTag")).SendKeys(splitarray[1].TrimStart('0'));
driver.FindElement(By.Id("inpStat")).SendKeys(splitarray[2].TrimStart('0'));
driver.FindElement(By.Id("btSearch")).Click();
Thread.Sleep(2000);
}
if (Convert.ToInt16(splitarray.Count()) == 2)
{
driver.FindElement(By.Id("inpTag")).SendKeys(splitarray[0].TrimStart('0'));
driver.FindElement(By.Id("inpStat")).SendKeys(splitarray[1].TrimStart('0'));
driver.FindElement(By.Id("btSearch")).Click();
Thread.Sleep(2000);
}
}
}
try
{
IWebElement INodata = driver.FindElement(By.XPath("//*[@id='frmMain']/table/tbody/tr/td/div/div/table[2]"));
if (INodata.Text.Contains("search did not find any records"))
{
HttpContext.Current.Session["Nodata_QueensNY"] = "Zero";
driver.Quit();
return("No Data Found");
}
}
catch { }
string blocktaken = driver.FindElement(By.XPath("//*[@id='datalet_header_row']/td/table/tbody/tr[2]/td[2]")).Text;
string block = gc.Between(blocktaken, "Block:", "Lot:").Trim();
string lot = GlobalClass.After(blocktaken, "Lot:").Trim();
parcel_number = block + lot;
string ownername = driver.FindElement(By.XPath("//*[@id='Property Owner(s)']/tbody/tr[2]/td")).Text;
string propertdata = driver.FindElement(By.Id("Property Data")).Text;
string Tax_year = gc.Between(propertdata, "Tax Year", "Lot Grouping");
string Propertyaddress = gc.Between(propertdata, "Property Address", "Tax Class");
string taxclass = gc.Between(propertdata, "Tax Class", "Building Class");
string Buildingclass = gc.Between(propertdata, "Building Class", "Condo Development");
string propertyresult = ownername + "~" + Tax_year + "~" + Propertyaddress + "~" + taxclass + "~" + Buildingclass;
gc.CreatePdf(orderNumber, parcel_number, "Peoperty Detail", driver, "NY", "Queens");
gc.insert_date(orderNumber, parcel_number, 1468, propertyresult, 1, DateTime.Now);
//Assessment
IWebElement accounthistoryy = driver.FindElement(By.XPath("//*[@id='sidemenu']/li[3]")).FindElement(By.TagName("a"));
string Accounthref = accounthistoryy.GetAttribute("href");
driver.Navigate().GoToUrl(Accounthref);
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, parcel_number, "Account History", driver, "NY", "Queens");
try
{
string Assessment = driver.FindElement(By.XPath("//*[@id='Profile']/tbody")).Text;
string BuildingClass = gc.Between(Assessment, "Building Class", "Tax Class");
string TaxClass = gc.Between(Assessment, "Tax Class", "Unused SCRIE Credit");
string scriecredit = gc.Between(Assessment, "Unused SCRIE Credit", "Unused DRIE Credit");
string Direcredit = gc.Between(Assessment, "Unused DRIE Credit", "Refund Amount");
string refundamt = gc.Between(Assessment, "Refund Amount", "Overpayment amount");
string overpayment = GlobalClass.After(Assessment, "Overpayment amount");
string assessmentresult = BuildingClass + "~" + TaxClass + "~" + scriecredit + "~" + Direcredit + "~" + refundamt + "~" + overpayment;
gc.insert_date(orderNumber, parcel_number, 1472, assessmentresult, 1, DateTime.Now);
}
catch { }
//tax History
try
{
IWebElement Accounthistoryhref = driver.FindElement(By.XPath("//*[@id='Account History Details']/tbody/tr[2]/td")).FindElement(By.TagName("a"));
string accountyhistoryhref = Accounthistoryhref.GetAttribute("href");
driver.Navigate().GoToUrl(accountyhistoryhref);
gc.CreatePdf(orderNumber, parcel_number, "Account History1", driver, "NY", "Queens");
IWebElement Accounthostorytable = driver.FindElement(By.Id("Account History Details"));
IList <IWebElement> Accountrow = Accounthostorytable.FindElements(By.TagName("tr"));
IList <IWebElement> accountyhistoryid;
foreach (IWebElement accounthistory in Accountrow)
{
accountyhistoryid = accounthistory.FindElements(By.TagName("td"));
if (accountyhistoryid.Count > 1 && !accounthistory.Text.Contains("Year"))
{
string Accounthistoryresult = accountyhistoryid[0].Text + "~" + accountyhistoryid[1].Text + "~" + accountyhistoryid[2].Text + "~" + accountyhistoryid[3].Text + "~" + accountyhistoryid[4].Text + "~" + accountyhistoryid[5].Text + "~" + accountyhistoryid[6].Text + "~" + accountyhistoryid[7].Text + "~" + accountyhistoryid[8].Text + "~" + accountyhistoryid[9].Text + "~" + accountyhistoryid[10].Text + "~" + accountyhistoryid[11].Text;
gc.insert_date(orderNumber, parcel_number, 1471, Accounthistoryresult, 1, DateTime.Now);
}
}
}
catch { }
IWebElement proowner = driver.FindElement(By.XPath("//*[@id='sidemenu']/li[6]")).FindElement(By.TagName("a"));
string ownerpro = proowner.GetAttribute("href");
driver.Navigate().GoToUrl(ownerpro);
gc.CreatePdf(orderNumber, parcel_number, "Ownerpro", driver, "NY", "Queens");
try
{
IWebElement Proownertable = driver.FindElement(By.Id("Exemptions"));
IList <IWebElement> Proownerrow = Proownertable.FindElements(By.TagName("tr"));
IList <IWebElement> Proownerid;
foreach (IWebElement Proowner in Proownerrow)
{
Proownerid = Proowner.FindElements(By.TagName("td"));
if (Proownerid.Count > 1 && !Proowner.Text.Contains("Year"))
{
string Proownerresult = Proownerid[0].Text + "~" + Proownerid[1].Text + "~" + Proownerid[3].Text + "~" + Proownerid[4].Text;
gc.insert_date(orderNumber, parcel_number, 1469, Proownerresult, 1, DateTime.Now);
}
}
}
catch { }
//Property Tax Bills
IWebElement propertytaxbill = driver.FindElement(By.XPath("//*[@id='sidemenu']/li[4]")).FindElement(By.TagName("a"));
string Propertyhref = propertytaxbill.GetAttribute("href");
driver.Navigate().GoToUrl(Propertyhref);
Thread.Sleep(2000);
gc.CreatePdf(orderNumber, parcel_number, "Property Bill", driver, "NY", "Queens");
string currentlink = driver.CurrentWindowHandle;
int p = 1;
IWebElement PropertyBilltable = driver.FindElement(By.Id("Notices of Property Value"));
IList <IWebElement> PropertyBillrow = PropertyBilltable.FindElements(By.TagName("tr"));
IList <IWebElement> PropertyBillid;
foreach (IWebElement PropertyBill in PropertyBillrow)
{
PropertyBillid = PropertyBill.FindElements(By.TagName("td"));
if (PropertyBillid.Count != 0 && PropertyBillid[0].Text.Trim() != "")
{
if (p < 5)
{
IWebElement PropertyLink = PropertyBillid[1].FindElement(By.TagName("a"));
string Hrefpro = PropertyLink.GetAttribute("href");
gc.downloadfile(Hrefpro, orderNumber, parcel_number, "Property Taax Bill" + p, "NY", "Queens");
//PropertyLink.Click();
//Thread.Sleep(4000);
//driver.SwitchTo().Window(driver.WindowHandles.Last());
//Thread.Sleep(2000);
//gc.CreatePdf(orderNumber, parcel_number, "Property Taax Bill" + p, driver, "NY", "Queens");
//driver.Close();
//driver.SwitchTo().Window(currentlink);
p++;
}
if (p == 5)
{
break;
}
}
}
// Benefits Business
IWebElement Benefits = driver.FindElement(By.XPath("//*[@id='sidemenu']/li[7]")).FindElement(By.TagName("a"));
string Beniftshref = Benefits.GetAttribute("href");
driver.Navigate().GoToUrl(Beniftshref);
Thread.Sleep(1000);
gc.CreatePdf(orderNumber, parcel_number, "Benefits", driver, "NY", "Queens");
//Benefits Non gov
IWebElement Benefitsgov = driver.FindElement(By.XPath("//*[@id='sidemenu']/li[7]")).FindElement(By.TagName("a"));
string Beniftshrefgov = Benefitsgov.GetAttribute("href");
driver.Navigate().GoToUrl(Beniftshrefgov);
Thread.Sleep(1000);
gc.CreatePdf(orderNumber, parcel_number, "Benefits Gov", driver, "NY", "Queens");
//prior Year
IWebElement prioryear = driver.FindElement(By.XPath("//*[@id='sidemenu']/li[10]")).FindElement(By.TagName("a"));
string prioryearhref = prioryear.GetAttribute("href");
driver.Navigate().GoToUrl(prioryearhref);
Thread.Sleep(1000);
gc.CreatePdf(orderNumber, parcel_number, "prior year", driver, "NY", "Queens");
try
{
IWebElement prioryeartable = driver.FindElement(By.Id("Historical Market Values and Assessment Rolls"));
IList <IWebElement> prioryearrow = prioryeartable.FindElements(By.TagName("tr"));
IList <IWebElement> prioryearid;
foreach (IWebElement prioryearele in prioryearrow)
{
prioryearid = prioryearele.FindElements(By.TagName("td"));
if (prioryearele.Text.Contains("Final Assessment Roll"))
{
IWebElement prioryearlink = prioryearid[3].FindElement(By.TagName("a"));
string Priorhref = prioryearlink.GetAttribute("href");
gc.downloadfile(Priorhref, orderNumber, parcel_number, "Final Assessment Roll", "NY", "Queens");
// prioryearlink.Click();
// Thread.Sleep(9000);
//driver.SwitchTo().Window(driver.WindowHandles.Last());
// gc.CreatePdf(orderNumber, parcel_number, "Final Assessment Roll", driver, "NY", "Queens");
break;
}
}
}
catch { }
// currentyear++;
TaxTime = DateTime.Now.ToString("HH:mm:ss");
LastEndTime = DateTime.Now.ToString("HH:mm:ss");
gc.insert_TakenTime(orderNumber, "NY", "Queens", StartTime, AssessmentTime, TaxTime, CitytaxTime, LastEndTime);
driver.Quit();
gc.mergpdf(orderNumber, "NY", "Queens");
return("Data Inserted Successfully");
}
catch (Exception ex)
{
driver.Quit();
GlobalClass.LogError(ex, orderNumber);
throw ex;
}
}
}
